Registered aircraft · 40,471

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N9234KUnusual Attitudes LLC · Stow, OHBuilt 1976 · S/N 28-7690232 N92356Hub City Aviation Academy LLC · Lubbock, TXBuilt 1973 · S/N 17261567 N9235CWilliams Patrick S · Saint Paul, MNBuilt 1978 · S/N 28-7890392 N9235SKaidor Jerome L · Hayward, CABuilt 1975 · S/N M-1727 N92362Yeakley Gary G · Ontario, CABuilt 1993 · S/N 19006C N9236HOptic Air LLC · Sioux Center, IABuilt 1975 · S/N 17266034 N9236SMahi Aviation Corp · Winter Garden, FLNon-citizen corporation, flight hours not reportedBuilt 1975 · S/N M-1728 N9236YSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 19008C N9237JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1989 · S/N 2841123 N9237VPortouw Lawrence J · Huachuca City, AZBuilt 1969 · S/N 690058 N9238KCrow Wing Flying Club Corp · Nisswa, MNFirst renewal noticeBuilt 1976 · S/N 28-7690233 N9238NBloomberg David C · Northampton, MABuilt 1993 · S/N 19012C N9238SAllt International LLC · Parker, COBuilt 1976 · S/N M-1760 N9239JAshmore Benjamin H Jr · Austin, TXBuilt 1966 · S/N 28-3313 N9239SRoyer Richard W · Winnebago, MNBuilt 1975 · S/N M-1732 N9239VRegistration Pending · Louisville, MSRegistration pendingBuilt 1969 · S/N 690059 N923ACWarnock Tony J · Mobile, ALBuilt 1990 · S/N 42 N923EZE Z Air LLC · Wilmington, NCBuilt 1966 · S/N 3458 N923KMWilliams Zackery · Lake Tapps, WABuilt 1993 · S/N 20008 N923SMN923sm LLC · Rehoboth Beach, DEBuilt 1991 · S/N 1923M N923TEDiscover Resources LLC · Norman, OKBuilt 2001 · S/N 10202 N923VDog House Aviation LLC · Mount Pleasant, SCBuilt 1974 · S/N M-1591 N9240HPropability One LLC · Daytona Beach, FLBuilt 1975 · S/N 17266038 N9240JThorson Jason J · East Grand Forks, MNBuilt 1966 · S/N 28-3314 N9240KHolland Wyatt Eugene · Garner, IAS/N 28-7690234 N9241MBellinger John · Wexford, PABuilt 1966 · S/N 3447 N9241SCosby Asa · Weldon, CAS/N M-1734 N92424Christiansen Cortland · Bakersfield, CAS/N 17261573 N9242DWeishaar Wallace · Livingston, TXBuilt 1958 · S/N 22-6302 N9242HRoland Aviation LLC · Gualala, CABuilt 1975 · S/N 17266040 N9242JCoyote Flight Centers LLC · Amarillo, TXBuilt 1966 · S/N 28-3316 N9242VHurley Gregory · Capon Bridge, WVBuilt 1969 · S/N 690061 N9242ZProfit Solving Group LLC · Bigfork, MTBuilt 1975 · S/N AA5B-0183 N9243DPiper Aviation Museum Foundation · Lock Haven, PABuilt 1958 · S/N 22-6303 N9243HSeward Air Taxi LLC · Seward, AKBuilt 1975 · S/N 17266041 N9243JRoney Edward A · Weirton, WVBuilt 1966 · S/N 28-3318 N92445Pureflight Aviation Training LLC · Newberg, ORBuilt 1973 · S/N 17261575 N92447American Patrols Inc · Midland, TXBuilt 1973 · S/N 17261576 N92448Eckholt John · Forest Grove, ORBuilt 1973 · S/N 17261577 N9244DShrode Rafe C · Jewett, TXS/N 22-6304 N9244HCoachron Investments LLC · Grosse Ile, MIBuilt 1975 · S/N 17266042 N9244JRichardson David M · Dwight, ILS/N 28-3319 N9244SKonefal Arthur Joseph · Fairbanks, AKBuilt 1975 · S/N M-1740 N9244VGibbs Richard L · Palm Coast, FLBuilt 1969 · S/N 690062 N9245SMowery Joseph · Orlando, FLBuilt 1975 · S/N M-1741 N9246FFischer Alfred M · Genoa City, WIBuilt 1989 · S/N 2841254 N9246JMckool John Jr · Johnstown, PABuilt 1966 · S/N 28-3321 N9246KN9246k Corp LLC · Federal Way, WAFirst renewal noticeBuilt 1976 · S/N 28-7615189 N92471Shoemaker Floyd · Oneida, TNS/N 17261579 N9247DLaw C Scott · Oklahoma City, OKBuilt 1958 · S/N 22-6307

Back to AD 80-04-03 R2