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.

N9149JJones Lynn · Birmingham, ALS/N 28-3204N9149SBurnard Russell J · Seward, AKBuilt 2001 · S/N 456RN914AZN969az LLC · Miami, FLBuilt 1985 · S/N 17276379N914HPBonsey James E · Newberg, ORBuilt 1968 · S/N 28-24646N914JDAis Wings LLC · Grand Rapids, MIBuilt 1972 · S/N 17261296N914RRMartinez Jeff L · Lewistown, MTS/N 17264508N914THanley Stuart · Hollywood, FLBuilt 1960 · S/N TD-347N914ZSkylens LLC · Hammond, LABuilt 1974 · S/N 17264444N91507Eagle Aviation LLC · Spearfish, SDBuilt 1973 · S/N 17261499N9150DFitzgerald Larry · Fairbanks, AKBuilt 1958 · S/N 18-6540N9150HN9150h LLC · Charleston, SCBuilt 1975 · S/N 17265975N91518Hatfield Timothy E · Parowan, UTBuilt 1996 · S/N 3121N9151HFirst Flight Corp · San Diego, CABuilt 1975 · S/N 17265976N9151LCerrato Michael J · Dublin, OHBuilt 1971 · S/N 306-71N9151NPlane Nonsense Inc · Middletown, DEBuilt 1988 · S/N 2890090N9152KHangar 9 Inc · Aberdeen, SDBuilt 1976 · S/N 28-7615179N9153HSambriski Michael Daniel III · Long Beach, NYBuilt 1975 · S/N 17265978N9153VRegistered aircraftBuilt 1969 · S/N 690027N91553Simpson Josiah J L Trustee · Shelburne, MABuilt 1973 · S/N 17261500N9155DTaylor Glenn Maurice · Fayetteville, GABuilt 1958 · S/N 22-6207N9156DTalmadge Jeffery K · New Milford, CTBuilt 1958 · S/N 22-6208N9156HSolar Flying Club · Grimes, IABuilt 1975 · S/N 17265981N9156JChristian Family Fellowship · Mesa, AZS/N 28-3213N9156SStickley Harold R · Wauseon, OHBuilt 1976 · S/N MC-401N9156VLegnaioli Richard · Cambridge, MDS/N 690013N9158HParrish Aviation Flight Academy LLC · Southlake, TXBuilt 1975 · S/N 17265982N9158YLockwood Rick I · Garden Grove, CAS/N 18-8911N91596West Michigan Flying Club Inc · Norton Shores, MIBuilt 1973 · S/N 17261505N9159HHess Garrett · Fullerton, CAS/N 17265983N9159KRoss Andrew · Yamhill, ORBuilt 1976 · S/N 28R-7635223N915CMVaayu Aviation LLC · Newark, CABuilt 1972 · S/N 17261229N915KPhelps Lawrence D · Vinton, IAS/N 001N915LCardinal Flying Corp · San Jose, CABuilt 1976 · S/N 17267355N915MBBarras David G · Breaux Bridge, LABuilt 2004 · S/N 1N915RSHayward Houston C · Lansdale, PABuilt 1999 · S/N 1260-99N915RVWiegand Jeffrey L · Ocean Isle Beach, NCBuilt 1999 · S/N 22356RV6N915TTLake Elmo Aero LLC · Lake Elmo, MNBuilt 1977 · S/N 28-7890158N915WBBordelon Warren P · Breaux Bridge, LABuilt 1972 · S/N 17261221N915WVSmith Aviation LLC · Springer, OKBuilt 1959 · S/N TD-236N9160DMalsby Thomas H · Blairsville, GABuilt 1958 · S/N 22-6212N9160HTodd Media Inc · Tuscaloosa, ALBuilt 1975 · S/N 17265984N9160JMohan Aditya · Rancho Cordova, CAS/N 28-3218N9160VLangis Maximus · Newburyport, MABuilt 1969 · S/N 690029N9161FHuie John E · Burnet, TXBuilt 2002 · S/N 001N9161HAir Athens LLC · Athens, GABuilt 1975 · S/N 17265985N9161JNortheast Nebraska Aviators Inc · Wayne, NEBuilt 1966 · S/N 28-3220N9161SCarr Jack Willson · East Lansing, MIBuilt 1975 · S/N MB-785N91622Utterback Karl D · Fort Wayne, INBuilt 2002 · S/N M-II-1820N9162HStratus Aviation LLC DBA · Vacaville, CABuilt 1975 · S/N 17265986N9162JHillelson Lawrence E · Grosse Ile, MIBuilt 1966 · S/N 28-3221
Back to AD 80-04-03 R2