Registered aircraft · 40,472

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.

N20FVRogers Robert D Jr · Keller, TXBuilt 1986 · S/N 642 N20GGHofer Danny C · Huron, SDBuilt 1978 · S/N 28-7916032 N20HTRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1969 · S/N 17258306 N20JCJcmc Inc · Junction City, KSBuilt 1955 · S/N 22-2879 N20JDDesroches John · Scottsdale, AZBuilt 1962 · S/N 28-375 N20JEReid Keith D · Vinemont, ALBuilt 1996 · S/N 20 N20JMWaeltz Mark A · Lantana, FLBuilt 1967 · S/N 28-4393 N20JPJohnson Leif M · Midlothian, TXBuilt 1993 · S/N 783 N20JZWest William D · Newton, NCBuilt 1986 · S/N 652 N20KBAnderson David R · Sycamore, ILBuilt 1976 · S/N M-2-570 N20KGAdspitalny LLC · Waynesville, MOBuilt 1986 · S/N 668 N20KLBuell Kenneth B · Port Orange, FLBuilt 1986 · S/N 669 N20KNShaw William C · Carmel, NYS/N 682 N20LEQuality Leasing Inc · Niceville, FLBuilt 1994 · S/N 1809080 N20LKHobert Robert W Trustee · Penn Valley, CABuilt 2001 · S/N 21299 N20LLFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990119 N20MUOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271496 N20MZChakraborty Imon · Auburn, ALBuilt 1998 · S/N 001 N20NASchneider Adam R · Hutchinson, KSBuilt 1977 · S/N AA5B-0560 N20PGSteiner Gregory L · Fort Lauderdale, FLBuilt 1966 · S/N 28-22276 N20PPTullgren Michael · Lincoln, CABuilt 1956 · S/N 22-4554 N20QCHenderson Stephen L · Carthage, NCBuilt 1977 · S/N 28-7890227 N20RDickerson Stephen R · Frisco, TXBuilt 1960 · S/N 24-1684 N20RTTyson Richard E · Barton, FLBuilt 1966 · S/N 3309 N20SALc Air Leasing LLC · Treasure Island, FLBuilt 1976 · S/N 28-7690337 N20SBBrillaud Stephen A · Germantown, TNBuilt 1976 · S/N 917-76 N20SCTriple S Air LLC · Atchison, KSBuilt 2000 · S/N 2678 N20TACopperstone Fc LLC · Lancaster, PABuilt 2010 · S/N 2843677 N20WMMcdonald John P · Kennewick, WAFirst renewal noticeBuilt 1973 · S/N 17261658 N20WTRice James L · Mckinney, TXBuilt 1982 · S/N SW01 N20YBBurdick Rich · Montrose, COFirst renewal noticeBuilt 1964 · S/N 2708 N2100DL A M Capital Management LLC · Sheridan, WYBuilt 1978 · S/N ME-41 N21015Renfro Michael W · Bethel, AKBuilt 1974 · S/N 17263888 N2101EV1 Aviation LLC · Englewood, COBuilt 1978 · S/N 17271155 N2101UVansurdam John R · Seneca, SCBuilt 1961 · S/N 147 N2101WUtset Anthony · Okeechobee, FLBuilt 1973 · S/N M-1471 N2101XScofield Bruce W · Batavia, NYBuilt 1972 · S/N 17701785 N2102CGreat Northern Aircraft Inc · Griffith, INBuilt 1978 · S/N 28-7916130 N2102EBrooks Terry A · Shelby, NCBuilt 1978 · S/N 17271156 N2102RLarosa Vincent · Asbury, NJBuilt 1969 · S/N 28-5461 N2102VGiovanini Terry L · Bozeman, MTBuilt 1954 · S/N 182663 N21030Aircraft Management Group Inc · Honolulu, HIBuilt 1978 · S/N 28-7816529 N21035Hayes Bradley M · Grove, OKBuilt 1974 · S/N 17263890 N2103WGoold Michael D · Fort Worth, TXBuilt 1973 · S/N M-1450 N2104NHammond Brian R · Lincoln University, PABuilt 1979 · S/N 28-7990271 N2104UVeracy Aviation LLC · Arlington, VABuilt 1979 · S/N 28-7990327 N2104WMorgan Austin T · Henderson, NVBuilt 1973 · S/N M-1444 N21052Registered aircraftN-number assigned, not yet registeredS/N 28-7916023 N2105UPiper Automotive & Marine Service Inc · North Miami, FLBuilt 1979 · S/N 28-7990328 N2105WNenow William R · Tulare, CABuilt 1973 · S/N M-1433

Back to AD 80-04-03 R2