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.

N88405Mulhern Georgia · Waddell, AZS/N 784-75N8840FPinchorski Ronald G · Wiconisco, PABuilt 1963 · S/N 33-0185N8840NBouillon Gloria J · Somerville, MABuilt 1969 · S/N 28-25691N88412Rider Shawna · Anchorage, AKS/N 779-75N88417Alaska Department Of Fish And Game · Fairbanks, AKS/N 123-75N8841JE & G Flying Club LLC · Alliance, OHBuilt 1965 · S/N 28-2798N8841WRegistration Pending · Dilley, TXRegistration pendingBuilt 1964 · S/N 28-10390N8841YHoffman Avery E · Bethel, AKBuilt 1973 · S/N 18-7309025N88421Dular Emil M · Elizabethtown, KYBuilt 1974 · S/N 785-75N88424Iowa Aerial Advertising LLC · Perry, IAS/N 305-75N88425Klamar Spraying Inc · Gatzke, MNBuilt 1974 · S/N 786-75N8842CTerry Jay F · Rome City, INBuilt 1953 · S/N 22-1455N8842DVan Bergeyk Ronald J · Trapper Creek, AKBuilt 1958 · S/N 22-6012N8842JCrowe Steven A · Bend, ORBuilt 1965 · S/N 28-2799N8843JDiorio Christopher J · Melba, IDS/N 28-2801N88443Jkt LLC · Douglas, WYBuilt 1974 · S/N 130-75N8844JCave Anthony B · Round Rock, TXBuilt 1965 · S/N 28-2802N8844NBruegmann Fred R III · Northfield, ILBuilt 1969 · S/N 28-25695N88451Williams Charles S · Pearland, TXS/N 131-75N88458Cole John R · Greenfield, INBuilt 1975 · S/N 790-75N8845JWilliams Daniel · Wallingford, KYBuilt 1965 · S/N 28-2803N88465Castleberry Inc · Ekalaka, MTBuilt 1974 · S/N 791-75N8846JFighter Pilot Enterprises LLC · Eaton, COBuilt 1965 · S/N 28-2804N8846NDegener William L · Leonard, TXBuilt 1969 · S/N 28-25697N88473A C E Aviation Inc · Ashton, IDBuilt 1974 · S/N 306-75N88477Holland William T III · Midway, ARBuilt 1974 · S/N 136-75N8847CBlumenberg Donald D · Fulton, SDBuilt 1953 · S/N 22-1459N8847FNeitzer Robert W · Milwaukee, WIBuilt 1976 · S/N 28-7725126N8847JFlw LLC · Sandpoint, IDS/N 28-2805N8847NMcdougal Thomas K · Woodward, OKBuilt 1969 · S/N 28-25699N8848JMegaw George C · Fort Lauderdale, FLBuilt 1965 · S/N 28-2806N8848NPro Tech Aviation LLC · Corona, CABuilt 1969 · S/N 28-25700N8849JBailey Aviation Company LLC · Little Rock, ARBuilt 1965 · S/N 28-2807N8849NCafran Lloyd V · Youngsville, NCBuilt 1969 · S/N 28-25701N884CAColeman Aero Club · Apo AeBuilt 1978 · S/N 17271876N884DCTanner Greg L · Bend, ORBuilt 1961 · S/N 24-2434N884JSCrane John R · Niceville, FLBuilt 1977 · S/N 340-77N884PSSpainhower Paul Allex · Taylorsville, UTS/N 2318N884SADamico Frank J · Pittsburgh, PABuilt 2003 · S/N 0037N8850NGregs Airplane Rental LLC · Eloy, AZBuilt 1969 · S/N 28-25702N8851JMoore Jeffrey A · Lawrenceburg, TNBuilt 1965 · S/N 28-2815N8851NBloodworth Nathan B · Hendersonville, TNS/N 28-25703N8853DSlaughter Don Wayne · Farmville, NCBuilt 1958 · S/N 22-6024N8853JN8853j LLC · Oak Park, ILBuilt 1965 · S/N 28-2817N8854CMid Continent Aircraft Corp · Hayti, MOBuilt 1953 · S/N 18-2900N8854DKidd Clifford L Jr · Monahans, TXBuilt 1958 · S/N 22-6025N8854LPfs Air Inc · Yellville, ARBuilt 1974 · S/N AA5-0654N8855NIndy Distributors Inc · Noblesville, INBuilt 1969 · S/N 28-25709N8856CBritton Mark W · Wasilla, AKBuilt 1953 · S/N 18-2913N8856JFifty Six Juliet LLC · West Lafayette, INS/N 28-2820
Back to AD 80-04-03 R2