OpenAirDocs.org
AD 80-04-03 R2

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

N944SJMiller David D · Plainfield, ILS/N 1547N944TDiedrick Michael R · Brooksville, FLBuilt 1960 · S/N TD-400N944VCoastal 944v LLC · Wilmington, NCBuilt 1975 · S/N M-1662N9450DSharabi Avinoam · Las Vegas, NVS/N 172RG1166N9451JJackson James E · Denair, CABuilt 1966 · S/N 28-3564N9452EDew Jason L · Krum, TXBuilt 1979 · S/N 17272268N9452HFreeland Thomas W · Early, TXBuilt 1975 · S/N 17266162N9452VFriesen Dwayne Phillip · Overton, TXBuilt 1970 · S/N 700052N9453JStarbard Donald · Crystal Bay, NVBuilt 1966 · S/N 28-3566N9453VNavflight Inc · Fort Worth, TXBuilt 1969 · S/N 700001N9454CPuglia Frank V · El Cajon, CABuilt 1978 · S/N 28-7816477N9455Sessions Richard T · Houston, TXBuilt 2002 · S/N 131N9456MDickey Brandon · Willow, AKBuilt 2016 · S/N 8180N9457DN1705r Inc · Cobb, CAS/N 172RG1172N9458JTibbitts Dennis C · Woodstock, ILBuilt 1966 · S/N 28-3571N9459Sullivan Stanley D · South Jordan, UTBuilt 1973 · S/N S1SN945DBHoskins Joshua C · Frisco, TXBuilt 2000 · S/N 2843312N945DSKnox Matthew · New Carlisle, OHBuilt 1962 · S/N 28-620N945GBWarbalow Peter R · Minocqua, WIBuilt 2004 · S/N 5709N945LBAllegro Jeff · Upper Lake, CABuilt 1979 · S/N 28-7990404N945SMFive Rivers Flight Training LLC · Livermore, CABuilt 1981 · S/N 17274742N945TC R Transport Inc · Wilmington, DES/N 17265082N945TELebanon Flying Club Inc · Lebanon, TNBuilt 2003 · S/N 10224N945VKTiedemann Daniel W · Carmel, INBuilt 2001 · S/N 20118N9460BEdwards Ag Service · Primghar, IABuilt 1958 · S/N 55260N9460DOlsen Marr B · Kelseyville, CABuilt 1959 · S/N 18-6810N9460JDerosa Michael D · Hewitt, TXBuilt 1966 · S/N 28-3573N9461CClub Cherokee Inc · Crystal, MNBuilt 1978 · S/N 28-7890412N9461DDurghinescu Cris Nicolae · Rancho Mirage, CABuilt 1984 · S/N 172RG1174N9461JKobbeman Joseph B · Louisville, KYBuilt 1966 · S/N 28-3574N9461PErickson Jess L · Saco, MTBuilt 1975 · S/N 18-7509133N9461VZembraski Jeffrey · Nocona, TXBuilt 1970 · S/N 700056N9462DEvans Randall Btrustee · Fallon, NVBuilt 1959 · S/N 18-6811N9463DHarris Aircraft Leasing Co · Oklahoma City, OKBuilt 1984 · S/N 172RG1175N9463KRegistered aircraftBuilt 1976 · S/N 28-7690253N9463VHatcher Mark F · Aloha, ORBuilt 1970 · S/N 700057N9464D907 Aviators LLC · Eagle River, AKBuilt 1958 · S/N 18-6707N9464JReinert Roger J · Duluth, MNS/N 28-3578N9465DMehrer Fritz J · Oceanside, CAS/N 172RG1176N9465JTaylor Robert J · Woodbridge, VABuilt 1966 · S/N 28-3579N9466DGerrard Michael K · Kaysville, UTS/N 18-6813N9466EGood Flight Aviation LLC · Stockton, CABuilt 1979 · S/N 17272272N9466JHawk Aviation Academy LLC · Saint Petersburg, FLBuilt 1966 · S/N 28-3580N9466PNewton Bros · Stratford, CABuilt 1973 · S/N 18-7309016N9467CDominy Alan L · The Woodlands, TXBuilt 1978 · S/N 28-7890413N9467DHahn Randal N · Wasilla, AKBuilt 1951 · S/N 18-863 MCN9468DKelly Henry Searles · Ossining, NYBuilt 1984 · S/N 172RG1177N9468HShouse Andrew · Flagstaff, AZBuilt 1975 · S/N 17266169N9468JSheffield Glenn A · Houston, TXBuilt 1966 · S/N 28-3582N9469DRanney Gayle · Cordova, AKBuilt 1959 · S/N 18-6815
Back to AD 80-04-03 R2