Registered aircraft · 85,612

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N2632BHeubeck Associates Inc · New York, NYBuilt 1979 · S/N 310R1626 N2632CSheldon Benjamin Lloyd · Duck Creek Village, UTBuilt 1978 · S/N R18200184 N2632DRech Timothy J · Camano Island, WAS/N 20784 N2632FOn Final Holdings LLC · West Olive, MIBuilt 1965 · S/N 18256732 N2632GHuey James M · Fulton, MOFirst renewal noticeBuilt 1959 · S/N 51932 N2632LKelley James M · Greenwood, ARBuilt 1967 · S/N 17255832 N2632PBargabos Richard O · Peterboro, NYBuilt 1960 · S/N CD-114 N2632WKrapp Transfer · Jamestown, NDBuilt 1966 · S/N 3300 N2633CWalusz Bernice J · Linden, NJS/N R18200185 N2633FYork Greg · Blanco, TXBuilt 1965 · S/N 18256733 N2633RDevries Mark R · Eagle River, AKBuilt 1967 · S/N 18258333 N2634FCockerham Milton D · Gooding, IDBuilt 1965 · S/N 18256734 N2634KKoeppel Steven Lynn Trustee · Mckinney, TXS/N 310R1637 N2634LMetal Mistress Aviation LLC · Meadowview, VABuilt 1967 · S/N 17255834 N2634MN2634mm LLC · Farmingdale, NYBuilt 1977 · S/N 28-7816298 N2634RRichardson Michael T · Inver Grove Hghts, MNS/N 28R-35236 N2634UCoolaire LLC · Boerne, TXBuilt 1963 · S/N 17250234 N2634VClanton Leslie G · Yazoo City, MSFirst renewal noticeBuilt 1948 · S/N 18144 N2634WGuerrero Aircraft LLC · Newport, WABuilt 1966 · S/N 973 N26355Fay Andrew T · San Marcos, TXS/N 310R1645 N2635BGrimes Jeremy M · Wasilla, AKBuilt 1959 · S/N 50390 N2635CMason Gregory J · Rice Lake, WIBuilt 1978 · S/N R18200186 N2635GStockton Finance Inc · New Braunfels, TXBuilt 1959 · S/N 51935 N2635KVerdi Stephen · Newtown, PABuilt 1978 · S/N 18053020 N2635LQueen Matthew E · Shenandoah, VAS/N 17255835 N2635QAir-Mods Flight Academy · Robbinsville, NJBuilt 1977 · S/N 28-7716115 N2635RJong Hoon Cho · Rch Palos Vrd, CABuilt 1967 · S/N 18258335 N2635VLaycock Justin D · Johnson City, TNS/N 18145 N2635WElam Brent R · Woodford, VABuilt 1966 · S/N 974 N2635XN2635x LLC · Eau Claire, WIS/N 310R1642 N2636CSexton David Lee · Barnesville, GABuilt 1978 · S/N R18200187 N2636FCernilia James J · Newport Beach, CABuilt 1965 · S/N 18256736 N2636GHousken George E · Gardnerville, NVFirst renewal noticeBuilt 1959 · S/N 51936 N2636VMclaughlin Nathaniel D · Clayton, CABuilt 1958 · S/N 18146 N26370Gv Air Inc · Medford, ORBuilt 1979 · S/N 310R1659 N2637CSafety In Motion Flight Center Inc · Puyallup, WABuilt 1978 · S/N R18200188 N2637DMcanulla Robert · Trabuco Canyon, CABuilt 1979 · S/N 310R1655 N2637FMccrum James M · Seattle, WABuilt 1965 · S/N 18256737 N2637GSalisbury Jonathan T · Seabeck, WABuilt 1959 · S/N 51937 N2637LAustin Timothy · Abbeville, SCBuilt 1967 · S/N 17255837 N2637UMarks Charles A III · Apalachicola, FLBuilt 1963 · S/N 17250237 N2637WCox James L · Fort Worth, TXBuilt 1966 · S/N 3302 N2638CPickett Joseph C · El Paso, TXBuilt 1955 · S/N 35038 N2638DWallace Donald F · Palmer, AKBuilt 1952 · S/N 20790 N2638GEvans Steven H · Hattiesburg, MSBuilt 1959 · S/N 51938 N2638LMorgan Todd W · Roscoe, ILBuilt 1967 · S/N 17255838 N2638XSoftware 2000 Inc · Arroyo Grande, CABuilt 1979 · S/N 310R1666 N2638YLawson Sean E · Lexington, KYS/N 310R1667 N2638ZHowlett Corey W · Wasilla, AKBuilt 1963 · S/N 185-0638 N2639CClear And Seven LLC · Santa Teresa, NMBuilt 1978 · S/N R18200189

Back to AD 98-21-21 R1