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.

N9603DHeartland Aviation Inc · Alliance, NES/N 22-6512N9603FWylie Aviation LLC · Boise, IDBuilt 1989 · S/N 1121N9603QConnecticut Flyers Inc · Madison, CTBuilt 1975 · S/N 17265688N9603WMoore Alan Ray · Glenwood, ARBuilt 1967 · S/N 28-23055N96042Aeropaint LLC · Wylie, TXBuilt 1990 · S/N 1138N9604QStevens Joel N · Monticello, ARBuilt 1990 · S/N 1120N9604SFmco Promotions Inc · North Little Rock, ARS/N 25N96052Copp James E · Adin, CAS/N 1150N9605CA O G Aircraft Services LLC · Aberdeen, NJBuilt 1978 · S/N 28-7816502N9605DDirty Side Down LLC · Downers Grove, ILBuilt 1958 · S/N 22-6514N9605QBragan Ryan J · Dunedin, FLBuilt 1975 · S/N 17265690N9605RStieglitz Jeffrey B · Firth, IDBuilt 1990 · S/N 1143N9605VBrookhart Brent Robert · Anaconda, MTBuilt 1990 · S/N 1144N9605ZBorror Kevin Bruce · Grants Pass, ORBuilt 1990 · S/N 1147N9606DNiemi Danny L · Osage, MNS/N 22-6516N9606SMix Timothy R · Hubbard, ORS/N 43N9606WMandolesi Daniel Martin · Hulmeville, PABuilt 1967 · S/N 28-23059N9607CLmc Aviation LLC · Goleta, CABuilt 1978 · S/N 28-7890429N9607DRomo Mark A · Dillingham, AKBuilt 1958 · S/N 22-6517N9607HTwin Oaks Airpark Inc · Hillsboro, ORFirst renewal noticeBuilt 1975 · S/N 17266260N9607RJohnston Bradley G · Ossining, NYBuilt 1959 · S/N TD-290N9607TPeterson Bradley E · Williston, NDBuilt 1990 · S/N 1134N9607WK-9 Handler LLC · Henderson, NVBuilt 1967 · S/N 28-23060N96088Griffith Kruz S · Bakersfield, CABuilt 1990 · S/N 1151N9608HCag Aircraft Holdings LLC · Crystal River, FLBuilt 1975 · S/N 17266261N9608JGomm Bruce J · Colfax, NDS/N 28-3754N9608MWaryas Robert A · Long Island, VAFirst renewal noticeBuilt 1967 · S/N 670107N9608QLahmers Melvin E · Newcomerstown, OHBuilt 1976 · S/N 17265693N9608RB2 West Corporation · Winona, MNBuilt 1959 · S/N TD-291N9608UNorth Shore Aviation LLC · Honolulu, HIBuilt 1975 · S/N AA5-0808N9608WBright Skies Sales & Leasing LLC · Hendersonville, TNBuilt 1967 · S/N 28-23061N9609HWilliams Marc A · Fallon, NVBuilt 1990 · S/N 1167N9609JAdams Donald J · Lock Haven, PABuilt 1966 · S/N 28-3755N9609QWestrup Gregory W · Greensburg, INBuilt 1975 · S/N 17265694N9609WCullen Michael R · Fort Mohave, AZBuilt 1967 · S/N 28-23062N960ACNaples Air Center Inc · Naples, FLBuilt 1990 · S/N 2841325N960FSSouthern Aero LLC · Homestead, FLBuilt 1974 · S/N 17263386N960GSStevens Chad M · Huntsville, ALBuilt 1964 · S/N 2858N960RSSouthard James E Jr · Charleston, SCBuilt 1975 · S/N AA5-0807N960RVHouse Gregory E · Sealy, TXBuilt 2001 · S/N 80006N960TEBeauregard Timothy · Haslet, TXBuilt 2004 · S/N 10239N960VSSauder Philip J · Peninsula, OHBuilt 1959 · S/N 18-6799N960WCStardust Aviation LLC · Farmingdale, NYBuilt 2000 · S/N 2843368N96100Trajectory Aviation LLC · Hollywood, FLBuilt 1983 · S/N 17276020N96105Demon Air LLC · Palm City, FLS/N 17276023N9610BGoodman Aviation LLC · Choteau, MTBuilt 1990 · S/N 1169N9610CHageman Theron · Jay Em, WYBuilt 1991 · S/N 1171N9610DHicks Joseph O · Germanton, NCBuilt 1958 · S/N 22-6520N9610QUS Aviation Group LLC · Denton, TXBuilt 1976 · S/N 17265695N9610RReynolds Kirk S · Skaneateles, NYBuilt 1959 · S/N TD-305
Back to AD 80-04-03 R2