OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N9498YRamsgate Ltd · Sedalia, COBuilt 1981 · S/N 21064522N9499GT F T LLC · Hayden, IDBuilt 1971 · S/N U20601699N9499QE J K LLC · Brawley, CABuilt 1972 · S/N E-323N9499YMilhouse Richard J · Aguila, AZBuilt 1981 · S/N 21064523N949BGGabriel Kevin E · Galveston, TXBuilt 1979 · S/N E-1494N949BPColton William · Houston, TXBuilt 2014 · S/N E-4041N949LHappy Mangos LLC · Anchorage, AKBuilt 1982 · S/N U20606639N949SFRasmussen Agribusiness Inc · Antelope, MTBuilt 1979 · S/N 21063515N949WBBirdwin LLC · Buras, LABuilt 2003 · S/N 0447N94BWErdman Aviation LLC · Cameron Park, CABuilt 1964 · S/N D-7627N94DMLad Salvage LLC · Morgan City, LABuilt 1980 · S/N 18504086N94ELCehula James Douglas · Anchorage, AKBuilt 1977 · S/N U20604131N94EMSkyclub A36 LLC · Alpharetta, GABuilt 1982 · S/N E-2011N94JKWestwind Aviation Inc · Plantation, FLS/N E-2149N94JVSlikker Benn W · Marana, AZBuilt 1991 · S/N E-2625N94KMBurton Aviation LLC · Burlington, NCBuilt 1997 · S/N TH-1816N94MACox Dennis J · Beach City, TXBuilt 1986 · S/N 46-8608056N94MQBreshan Enterprises LLC · Chicago, ILBuilt 1975 · S/N TE-1060N94MRMooney Group LLC · Washington, DCBuilt 1994 · S/N 29-0002N94NMSykes Gregory P · Arlington, WABuilt 1974 · S/N U20602336N94PBBaron 94pb LLC · Tuscaloosa, ALBuilt 1979 · S/N TJ-245N94PSBrierley Michael G Trustee · Sparks, NVBuilt 1980 · S/N P21000469N94RWWithers Dana Ruth Executor · Mount Vernon, ILBuilt 1981 · S/N 414A0662N94TJHuber Robert T · West Chester, PABuilt 2002 · S/N TH2029N94WMGrowth Caddie LLC · Vero Beach, FLBuilt 1988 · S/N 4608114N94WWZephyr Homes LLC · Sebring, FLBuilt 1981 · S/N E-1817N94YEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1995 · S/N 0044N9500GEphbaugm Equipment LLC · Hartline, WABuilt 1974 · S/N 18801504TN9502YBci Aviation LLC · Arroyo Grande, CABuilt 1981 · S/N 21064525N9509GMid Continent Aircraft Corp · Hayti, MOBuilt 1974 · S/N 18801508TN950CAZero Charlie Alpha LLC · Mountain View, CABuilt 1974 · S/N D-9667N950DGoodwill Aviation Inc · Dover, DEBuilt 1969 · S/N TE-691N950DCParmelee Charles G Trustee · Reno, NVBuilt 1982 · S/N EA280N950MCL C Cattle Inc · Garden City, KSBuilt 1978 · S/N D-10171N950PSPlane Services LLC · Twin Falls, IDS/N EA-337N950QDodson International Parts Inc · Rantoul, KSBuilt 1961 · S/N CD-399N950SRAcme Aero LLC · Kingman, KSBuilt 1979 · S/N 21063698N950VWillow Equipment LLC · Sharon Springs, KSBuilt 1975 · S/N E-747N9510JOrange County Mosquito Control District · Orange, TXBuilt 1981 · S/N 18803814N9511RBrewer William B · Fairbanks, AKBuilt 1985 · S/N U20606881N9512YPalmer George J III · Orlando, FLBuilt 1981 · S/N 21064533N9513GThomas David · Boise, IDBuilt 1971 · S/N U20601713N9514GP51d Mustang LLC · Bigfork, MTBuilt 1971 · S/N U20601714N9515GRegistration Pending · Kenai, AKRegistration pendingS/N U20601715N9515RCunningham Michael K · Pinebluff, NCBuilt 1976 · S/N 18503186N9517ESlail Fahmi Y · Beaverton, ORBuilt 1975 · S/N 75-30774N9517QBrasco Inc · Huntley, ILBuilt 1966 · S/N D-8074N9518GKomer Thomas B Jr · Woodburn, ORBuilt 1971 · S/N U20601718N9518QGeorgeson Troy D · Sheyenne, NDBuilt 1966 · S/N D-8080N9519QNeumann Thomas Trustee · Antioch, ILS/N CE-20
Back to AD 86-13-04 R3