Skip to content

Registered aircraft · 85,620

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.

N1538GMiller Andrew D · Broomfield, COBuilt 1988 · S/N E-2465 N1538HRobinson Manufacturing Inc · Rockford, ILBuilt 1988 · S/N E-2451 N1538SDeneve Allen J · Herndon, VABuilt 1962 · S/N D-6985 N1538VEvergreen Flying Club Inc · Medina, WABuilt 1974 · S/N 17263651 N1538XStaton Justin · Kemah, TXBuilt 1975 · S/N 28R-7535315 N1538YPrice Andre D · Granger, INBuilt 1962 · S/N 17249238 N15391Lyon Anthony R · Bethesda, MDBuilt 1972 · S/N 28-7305068 N15392Dgm Aviation LLC · Hurricane, WVBuilt 1972 · S/N 28-7305069 N15396Nomann Arnold H · Viroqua, WIBuilt 1972 · S/N 28-7310041 N15397Boisvert Thomas Michael · Sonoita, AZBuilt 1972 · S/N 28-7310042 N1539EMls Aviation LLC · Yorba Linda, CABuilt 1978 · S/N 17271040 N1539MN1539m LLC · Kalispell, MTBuilt 1975 · S/N 18264366 N1539V39 Victor Aviation Inc · Macomb, ILBuilt 1989 · S/N E-2469 N1539WM P W D Inc · Saint Charles, ILBuilt 1972 · S/N E-326 N1539ZGelber Lisa G Trustee · Tujunga, CABuilt 1961 · S/N D-6866 N153ASBowen Arrow Aviation Inc · Albany, NYFirst renewal noticeBuilt 1976 · S/N 28R-7635436 N153LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842196 N153LMSkylens LLC · Hammond, LABuilt 1976 · S/N 27-7754019 N153MKThomas Paul · Falls Church, VABuilt 1984 · S/N 32-8406009 N153PPBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 18266340 N153RJones Jeremy R · Lampasas, TXS/N 35020 N153SMN153sm LLC · Tallahassee, FLBuilt 1974 · S/N 28-7415167 N153SPRegistered aircraftN-number assigned, not yet registeredS/N CJ-24 N153WBOster Dale E · Trego, MTBuilt 1966 · S/N 27-3329 N153WSZeissner Douglas K · Chino, CABuilt 1952 · S/N 25355 N154Nystrom Timothy L · Foreston, MNBuilt 1974 · S/N 28-7405097 N15401Adkins Jerome B · Northridge, CABuilt 1972 · S/N 28-7325057 N15402Swaz Aviation LLC · Queen Creek, AZBuilt 1972 · S/N 28-7325058 N15405Kurin Kerry · Tulsa, OKBuilt 1972 · S/N 28-7305070 N15406Apollo Flying Club LLC · Nashua, NHBuilt 1972 · S/N 28-7305071 N1540JGray Caleb · Henderson, NVBuilt 1967 · S/N 28-23942 N1540MClark Robert L Jr · Johnston, IABuilt 1975 · S/N 18264367 N15410Simpson Randal L · Missouri City, TXBuilt 1972 · S/N 28-7310043 N15414Registration Pending · Milaca, MNRegistration pendingBuilt 1972 · S/N 28-7325061 N15417Coburn Kyler J · Mountain Home, IDBuilt 1972 · S/N 28-7305073 N1541CSwan Russell · Glenside, PABuilt 1963 · S/N 28-10042 N1541FRwr Air Inc · Tok, AKBuilt 1966 · S/N 185-0896 N1541JNauhaus Samuel W · Concord, NCBuilt 1967 · S/N 28-23943 N1541UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267169 N1541WGobogo LLC · Fort Collins, COBuilt 1972 · S/N E-327 N1541XSheffer Marshall A · Herrin, ILBuilt 1975 · S/N 32-7540171 N1541ZDebonair Inc · Kansas City, MOS/N CD-421 N15422N15422 LLC · Cortland, NYBuilt 1972 · S/N 28-7325063 N15423Gerken Scott G · Sharpsburg, GABuilt 1972 · S/N 28-7325064 N15426Piper Pilots LLC · Wilsonville, ORBuilt 1972 · S/N 28-7305075 N1542MMelgaard Kenneth William · Minot, NDBuilt 1975 · S/N 18264368 N1542UWarner Walt M · Willow, AKBuilt 1973 · S/N U20602249 N15435Crown Aviation LLC · Haltom City, TXBuilt 1972 · S/N 28-7325067 N15438Max Motors LLC · Encino, CABuilt 1972 · S/N 28-7305077 N1543JKosmin Vladimir · Delta Junction, AKBuilt 1967 · S/N 28-23946

Back to AD 98-21-21 R1