OpenAirDocs.org
AD 80-04-03 R2

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
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.

N208PFChristensen Todd S · Ririe, IDBuilt 2014 · S/N 6793N208PLLutz Paul Trustee · Seville, OHBuilt 2006 · S/N 24239N208RDChase Donaven Ray · Lake Elmo, MNBuilt 2003 · S/N 90178N2090PMartin Vernon W · Peoria Heights, ILS/N 23-678N2090RRubright Erik M · Gladstone, MIBuilt 1969 · S/N 28-4975N2090VWater Sports Unlimited · Griffin, GABuilt 1979 · S/N 28-7990339N20912Dart Gregory G · Mayville, NYBuilt 1976 · S/N 1N2091BRegistered aircraftBuilt 1978 · S/N 28-7990117N2091DRegistration Pending · Magnolia, TXRegistration pendingBuilt 1978 · S/N 28-7916141N20921Brigham David F · Elliottsville Twp, MEBuilt 1974 · S/N 17263869N2092AKimmons Anthony J · Quitman, TXBuilt 1978 · S/N 28-7916094N2092XAirx LLC · Warwick, RIBuilt 1979 · S/N 28-7916342N20932Registration Pending · Hammond, LARegistration pendingBuilt 1974 · S/N 17263872N20933Meacham Bruce E · Kansas City, KSS/N SA-233N20934Fly Skyhawk Llp · Galena, OHBuilt 1974 · S/N 17263874N2093MAir Cortright LLC · Boyne City, MIBuilt 1977 · S/N 28-7890228N20940Cirrus Flight Operations Inc · Minneapolis, MNBuilt 1974 · S/N 17263876N2094CAnson Air LLC · Sugar Land, TXBuilt 1978 · S/N 44-7995116N2094ROtt Rusty S · Sugar Grove, ILS/N 28-5459N20951Strevels Stephen M · Knoxville, TNBuilt 1974 · S/N 17263879N20954Hardin John M · Terrell, TXS/N 17263881N20958Ras Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7916020N2095KCalifornia In Nice Inc · San Jose, CAS/N 44-7995180N2095PForbes Richard L · Plano, TXBuilt 1956 · S/N 23-683N20965Reich Aviation LLC · Loudon, TNBuilt 1974 · S/N 17263883N2096LMcfarland Bruce R · Newberry, FLBuilt 1978 · S/N 28-7916242N2097NSidney Flying Club Inc · Sidney, OHBuilt 1979 · S/N 28-7916257N2097UNorris Barry D · Soquel, CABuilt 1979 · S/N 28-7916311N2098PRegistration Pending · Granger, IARegistration pendingS/N 23-686N20992Sketo Aviation LLC · Bardstown, KYBuilt 1978 · S/N 28-7990030N2099CFrazier Jon A · Vista, CAS/N TD-276N2099WInternational Air Services Inc Trustee · Carson City, NVBuilt 2000 · S/N 80438N209CCCampbell Aviation Inc · Dutton, MTBuilt 1997 · S/N 20209N209DBCreedon William P · Escondido, CABuilt 1971 · S/N 139N209DPBke Air LLC · Newnan, GABuilt 1977 · S/N 17270158N209ESSweeney Edward C · Parrish, FLBuilt 1971 · S/N 146N209HVAnderson Scott · Salem, ORBuilt 1979 · S/N 17272302N209JRegistered aircraftBuilt 1982 · S/N 28-8216153N209JVPlahn Paul H · Minneapolis, MNBuilt 1971 · S/N 148N209PTSilver Express DBA · Miami, FLBuilt 1979 · S/N 44-7995239N209SFWhitaker Alvin E · Waterloo, WIBuilt 1971 · S/N 142N20ALilbit Industries LLC · Oklahoma City, OKBuilt 1955 · S/N 23-396N20AAGrand River Aviation LLC · Kremmling, COBuilt 1968 · S/N 17256596N20AJTwigg Brett · Lincoln, ALBuilt 1985 · S/N 475N20AKAuer Matthew J · Anchorage, AKBuilt 2005 · S/N 5771N20ALHarrington Mark · West Milford, NJBuilt 1991 · S/N 46N20CUCosta Flying Service Inc · Painted Post, NYBuilt 1980 · S/N 172RG0323N20DKFlight Surgeon LLC · Fayetteville, ARBuilt 1976 · S/N 17266836N20DUWings Of Hope · Chesterfield, MOBuilt 1985 · S/N 529N20EUWerking John William III · New Windsor, MDS/N 628
Back to AD 80-04-03 R2