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.

N9488GTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17273629 N9488JSneed Associates LLC · Fort Morgan, COBuilt 1966 · S/N 28-3605 N9489JIndiana County Flying Club Inc · Blairsville, PABuilt 1966 · S/N 28-3606 N948DBBoard David N · Moundsville, WVBuilt 1963 · S/N 22-7600 N948RVGeer Roy R · Fort Worth, TXBuilt 2004 · S/N 82021 N948SMScenic Concepts LLC · La Crosse, WIBuilt 1982 · S/N 172RG1057 N948WDAndrews Aviation Two LLC · Temple, TXBuilt 2010 · S/N 71660 N9490HNovak Rickson J · Pine City, MNBuilt 1975 · S/N 17266177 N9491JRoy Thomas M Jr · Carbondale, ILBuilt 1966 · S/N 28-3609 N9492HSchodack Aviation Association · Ghent, NYBuilt 1975 · S/N 17266178 N9492VRivera Jaime · San Antonio, TXBuilt 1970 · S/N 700066 N9493DJack Browns Seaplane Base Inc · Winter Haven, FLBuilt 1958 · S/N 18-6745 N9493JHayes Enterprises · Glendale, AZBuilt 1966 · S/N 28-3611 N9494DReder Monte D · Miles City, MTBuilt 1958 · S/N 18-6746 N9494JRuiz Serge · Montgomery, TXS/N 28-3613 N9495HNelson Flying Service LLC · Lansford, NDBuilt 1975 · S/N 17266180 N9495VSoccer Goals LLC · Christoval, TXBuilt 1970 · S/N 700067 N9496DCavu Clearing LLC · Center Harbor, NHBuilt 1958 · S/N 18-6748 N9496VEvans Richard I · Elko, NVS/N 700050 N9497JShushnar Gary J · Irvine, CABuilt 1966 · S/N 28-3737 N9498JBrantley Hugh L · Hazlehurst, GAS/N 28-3738 N9498LRaber Jonathan L · Baltimore, MDBuilt 1972 · S/N AA5-0238 N9498VMoonshiner Aviation LLC · Austin, TXBuilt 1970 · S/N 700068 N949CDDupont Samuel F C · Mount Solon, VABuilt 1978 · S/N 17270883 N949MDUnruh Leasing LLC · Blossom, TXBuilt 1973 · S/N 21059889 N949RVVan Wagenen Stanley Keith Trustee · Las Vegas, NVBuilt 2003 · S/N 90369 N949SMAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1980 · S/N 172RG0713 N949TEBarron Wesley Thomas · Port Orange, FLBuilt 2003 · S/N 10228 N949WParrish Shawn J · Great Falls, MTBuilt 2010 · S/N 90467 N949WCCampbell Weldon W · Great Bend, KSBuilt 1997 · S/N 23469 N94ABMiller Paul · El Dorado Springs, MOBuilt 1994 · S/N 21923 N94BSMcdonnell John T · Yardley, PABuilt 1989 · S/N 2 N94CPAhlhorn Travis Wayne · New Braunfels, TXBuilt 1979 · S/N 17273150 N94DBFox Joseph L · Ocean City, NJBuilt 1983 · S/N 362 N94DGGreen Daryl K · Grove City, OHBuilt 2005 · S/N 21507 N94DLWhiskey November Aviation LLC · Minneapolis, MNBuilt 1973 · S/N 28-7415076 N94ERHill Andrew T · Smithville, TXBuilt 1983 · S/N 17276053 N94FDBeaver Jonathan D · Greensboro, NCBuilt 2002 · S/N 81243 N94GCCook Gregory L · Carl Junction, MOBuilt 1994 · S/N 20020C N94HFDefenbaugh Matthew J · Biggsville, ILBuilt 1979 · S/N 1153-79 N94HJGable Taylor Lee · Nicholson, GABuilt 1975 · S/N 17265633 N94HUTronstad John L · Baker, MTBuilt 1994 · S/N 1260 N94HWLach John F · Warren, OHBuilt 2002 · S/N 90045 N94HYWest Metro Aviation LLC · Buffalo, MNBuilt 2005 · S/N 2297 N94KBBaker Bryn M · Clinton, UTBuilt 2000 · S/N 23929 N94KDSprik Robert J · Hamilton, MIBuilt 1995 · S/N KD-03 N94KWHine Garrett Christopher · Panama City Beach, FLBuilt 1994 · S/N 19026C N94LBWhetzel Russell R · Milford, NJBuilt 1994 · S/N 19029C N94LESky Path N94le LLC · Carmel, INBuilt 1993 · S/N 20776 N94LJFrostenson Bobi J · Fairfield, IDBuilt 1986 · S/N 218

Back to AD 80-04-03 R2