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.

N39BPEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1999 · S/N 2906N39DBKwasinski Mark W · Kalamazoo, MIBuilt 1969 · S/N 153N39DCCruson Dale E · Ontario, ORBuilt 1993 · S/N 20374N39DRLehigh Valley Flying Club Inc · Lehigh Valley, PABuilt 1976 · S/N 28-7790221N39DUYokoo Kureha · Petaluma, CAS/N 22818N39ECSmith Adria A · Kingwood, TXBuilt 1968 · S/N 28-4985N39FZLongley Charles A · Nome, AKBuilt 1962 · S/N 18-7745N39GMonteleone Gene R · Mount Vernon, TXS/N 15N39GCWilliams Jeffrey D · Florence, ALBuilt 1980 · S/N AS123N39GDNovember Sierra Romeo LLC · Byron Center, MIS/N 10250N39GHApaka Lee K · Fairfield, CABuilt 1975 · S/N 65N39GMBacon Gregory A · Prairie Home, MOS/N 0001N39JMJads Aviation LLC · Rowlett, TXBuilt 1960 · S/N 23-1943N39KWFier William J · Austin, TXBuilt 2000 · S/N 3374N39KYYang Chi · Lafayette, COBuilt 1979 · S/N 447995304N39LDMau Thomas E · Kenmare, NDS/N 18-5757N39MRGraupman Gerald · Chicago, ILBuilt 1969 · S/N EGA-1N39RFHughes Todd R · Euless, TXBuilt 1996 · S/N 532N39SDMbm Leasing LLC · Jacksonville, NCBuilt 1966 · S/N 28-3565N39SJArrigo Johnathan T · Mill Spring, NCBuilt 1999 · S/N 3269N39SKJustman Robert A · Cotati, CABuilt 2003 · S/N 25726N39TSMiller William L · Williamson, GABuilt 1982 · S/N 39N39WDWilliams Ryan P · Calera, OKBuilt 1984 · S/N 106DN3AAJones Stephen C · Wadsworth, ILS/N E3B-318N3ACMaurer Christian N · Loveland, OHS/N 1002N3AKSantana Barry W · Wasilla, AKBuilt 2011 · S/N TC0604104N3ARMatejczyk Daniel E · West Hills, CAFirst renewal noticeBuilt 1974 · S/N 10N3BNHansen Warren K · Bozeman, MTBuilt 1972 · S/N 430-73N3BYJamora Daniel L · Victorville, CABuilt 1969 · S/N 17257965N3CLWehner Kaitlyn M · Malone, WIBuilt 1968 · S/N 17257531N3DNNodorft Daniel F · Orlando, FLBuilt 1983 · S/N 28-8390043N3DTBighorn Flying Company LLC · Wood River, NEBuilt 1962 · S/N 18-7774N3FHScarborough Alex C · Lubbock, TXBuilt 2001 · S/N 451-2001N3GPAerospace Museum Of California · Mcclellan, CAFirst renewal noticeBuilt 1973 · S/N GP3N3JARegistered aircraftBuilt 1975 · S/N 17266528N3JKPagenkopf Joseph C · Juneau, AKBuilt 1976 · S/N 941-76N3KBJobe Dwaine B · Chilhowee, MOBuilt 1967 · S/N 28-3872N3KMStevens Burton G · Las Vegas, NVBuilt 1965 · S/N 2995N3MSCarter Zac · Atlanta, GABuilt 1960 · S/N 24-1747N3MWDantonio David · Wichita Falls, TXBuilt 1977 · S/N 414N3NEPatton Ronald V · Marion, TXBuilt 1988 · S/N 2AP305N3NLBaez Rafael · Stafford, VABuilt 1964 · S/N 28-1826N3PLCarlin Bernard T III · Norman, OKBuilt 1969 · S/N 52N3RWGordon George M Jr · Weston, MABuilt 1978 · S/N 17271069N3RXMorelli Michael V · Kenilworth, ILBuilt 1974 · S/N 17264044N3SDDanish John S · Hooksett, NHBuilt 1958 · S/N 24-380N3SFPowers Gilford L · Glenville, NYBuilt 1970 · S/N 17259442N3SKMiller Chad L · Shipshewana, INBuilt 1979 · S/N AA5B1219N3TNChamplain Flyers LLC · Westford, VTBuilt 1974 · S/N 17263547N3VEAero 356 LLC · Phoenix, AZS/N 3073
Back to AD 80-04-03 R2