OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,473

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.

N6445UFerrin Lora J · Rio Rancho, NMBuilt 1962 · S/N 2192N64464Vector Air LLC · Erie, COBuilt 1982 · S/N 17275563N64465N64465 LLC · Fort Lauderdale, FLS/N 17265250N6446DN2893e LLC · Reno, NVBuilt 1979 · S/N 17272805N6446LPradhan Anis · Torrance, CABuilt 1972 · S/N AA1A-0446N6446RChapin Lee · Newburgh, INFirst renewal noticeBuilt 1966 · S/N 28-21629N64477Rico Aviation Services Inc · Miami, FLBuilt 1975 · S/N 17265257N6447964479 LLC · Cortland, OHBuilt 1975 · S/N 17265259N6447RGensler Orion M · Bloomfield, MOBuilt 1966 · S/N 28-21630N6447UOlathe Spray Ser Inc · Olathe, COBuilt 1962 · S/N 2252N6447WSeverson Eric · Waukesha, WIBuilt 1964 · S/N 28-20519N6447ZH&H Ag Aviation Inc · New Underwood, SDBuilt 1961 · S/N 25-607N64485Registration Pending · La Harpe, ILRegistration pendingBuilt 1975 · S/N 17265262N6448JMurphy Richard F · Hughesville, MDS/N 28-4867N6448RShaw Timothy E · Ashtabula, OHBuilt 1966 · S/N 28-21631N6448WSierra Lima Aviation LLC · Riverton, UTS/N 28-20520N64493Neron II LLC · Lewes, DEBuilt 1982 · S/N 17275565N6449JBentley Aviation Services · Lewes, DEBuilt 1980 · S/N 17273874N644CLLeckie Charles W · Rosemount, MNBuilt 1997 · S/N 1834N644CMMckenzie Bradley J · Houston, TXBuilt 2004 · S/N 1376-2004N644DRNorthwestern Michigan College · Traverse City, MIBuilt 1953 · S/N 18-2867N644FLAty Aviation Inc · Watertown, SDBuilt 1971 · S/N 28-7125552N644GRishel Keith D · Prineville, ORBuilt 1970 · S/N 28-26741N644GDDuda W Gregory · Grass Valley, CABuilt 1993 · S/N 644N644KCollins Curtis R · Tennessee Colony, TXBuilt 1999 · S/N 60209N644KSKent State University · Stow, OHBuilt 2006 · S/N 4496220N644PWWooten Jerry W · Taylor, TXBuilt 2023 · S/N 22455N645Endsley Terry G · Wilkeson, WABuilt 1981 · S/N 120N64507Quigley Patrick M · Slidell, LABuilt 1975 · S/N 17265267N64508Roseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 17265268N64509Wing Adney F III · Live Oak, FLBuilt 1975 · S/N 17265269N6450GN6450g Inc · Jacksonville, NCBuilt 1979 · S/N 17273597N6450KOstrowski-Swope Roxanne M · Ortonville, MIBuilt 1980 · S/N 17274197N6450RPlan Bee LLC · Washington, DCBuilt 1966 · S/N 28-21635N6450WJones Bobby R · Colorado Springs, COBuilt 1964 · S/N 28-20522N64510Gonzalez Leopoldo · San Antonio, TXS/N 17265270N6451RDamian Richard E · Sioux Falls, SDBuilt 1966 · S/N 28-21636N6451UPatterson Scott K · Roswell, NMBuilt 1962 · S/N 2198N6451WHickman John N · Mohave Valley, AZBuilt 1964 · S/N 28-20523N64524Ace Aviation 64524 LLC · Pembroke Pines, FLBuilt 1975 · S/N 17265280N64527Aspire Aviation LLC · Farmingdale, NYBuilt 1975 · S/N 17265283N6452ROr-El Elbaz · Woodland Hills, CABuilt 1966 · S/N 28-21637N6452UEllis & Ellis Aviation LLC · Haslet, TXBuilt 1962 · S/N 2199N64530Dazi Inc · Wilmington, DES/N 17265286N64532Wings Over Texas Holdins LLC · Denton, TXBuilt 1975 · S/N 17265288N64535Panair Flying Club Inc · Miami, FLBuilt 1975 · S/N 17265291N64537Peters Ronald J · Fountain Hills, AZBuilt 1975 · S/N 17265292N64538Crittenden Grace · San Luis Obispo, CAS/N 17265293N6453JN6529r LLC · Manassas, VABuilt 1968 · S/N 28-4874N6453RHerman Aaron T · Bryan, OHS/N 28-21638
Back to AD 80-04-03 R2