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.

N92NJDan Cox LLC · Troutdale, ORBuilt 1960 · S/N D-6604N92PAMarz Richard F · Statesboro, GABuilt 2003 · S/N 29-0304N92PSMeshoppen Air LLC · Tunkhannock, PABuilt 1971 · S/N 421B0134N92RHCrabtree Nathan J · Boise City, OKBuilt 1967 · S/N P206-0431N92RWInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N CE-972N92SEN92se LLC · Santa Barbara, CABuilt 1973 · S/N CE-463N92TTKent Oscar Kevin · Lucas, IABuilt 1972 · S/N TH-226N92WH322ee Aviation LLC · Union, KYBuilt 1977 · S/N 340A0271N92WMGerhardt David C · Denver, COBuilt 1979 · S/N 18503859N92WWMoran Richard J · Balsam, NCBuilt 1994 · S/N CE-1779N9300NChristensen Hans · Enterprise, UTBuilt 1981 · S/N 18504328N93010Davis Russell C · Odessa, TXBuilt 1976 · S/N 18503158N93018Joy Austin J Jr · Anchorage, AKBuilt 1976 · S/N 18503161N93022Red Leasing LLC · Juneau, AKBuilt 1979 · S/N U20605463N93023Ward Air Inc · Juneau, AKBuilt 1976 · S/N U20603526N93025Kiesel Edward K · Juneau, AKBuilt 1976 · S/N 18503163N93027Indy Air LLC · Blaine, MNBuilt 1976 · S/N 18503164N9302QSmith Winston C · Colleyville, TXBuilt 1971 · S/N E-294N93030Cathey Wacey D · Polson, MTBuilt 1976 · S/N 18503165N93033Kaval John P Jr · Duxbury, MABuilt 1976 · S/N 18503166N93035Des Aircraft LLC · Marianna, ARBuilt 1974 · S/N 21060232N93039Dorris Michael R · Mccall, IDBuilt 1977 · S/N 18503169N9303RCanoe Bay Outfitters LLC · Chugiak, AKBuilt 1984 · S/N U20606829N9304QK Factor Aircraft Corp · Jupiter, FLBuilt 1971 · S/N D-9296N9304RShah Zahid · Santa Paula, CAS/N U20606830N93050Wilson Thomas Henry III · Anchorage, AKBuilt 1976 · S/N 18503172N93052Pfm 2025 LLC · Lake Forest, ILBuilt 1974 · S/N 21060244N93055Moore Joshua M · North Pole, AKBuilt 1977 · S/N 18503173N9307YRader Drew · Avon, COBuilt 1981 · S/N 21064467N93098Faeo John D · Wasilla, AKBuilt 1976 · S/N 18503179N9309QBehrent Carl D · Granbury, TXBuilt 1971 · S/N D-9295N9309YYecny Alan K · San Luis Obispo, CABuilt 1981 · S/N 21064469N930AAN930aa LLC · Memphis, TNBuilt 1977 · S/N E-1139N930BDMomentum Air LLC · Brighton, MIBuilt 1973 · S/N TH-307N930DBKropp Christian Trustee · Azle, TXBuilt 1980 · S/N EA-184N930GGelazin Paul J · Palm Harbor, FLBuilt 1977 · S/N 21061866N930KHDirt Aviation LLC · Rome, GABuilt 2002 · S/N 0317N930LFWanner Robin L · Lufkin, TXBuilt 1966 · S/N 21058766N930MRJbk Aviation LLC · Bradfordwoods, PABuilt 1994 · S/N 29-0003N9310QMc Types II LLC · Jacksonville, FLBuilt 1971 · S/N TH-180N93112Strack Air LLC · Yorba Linda, CABuilt 1974 · S/N 21060267N93128High Plains Aero Consulting Inc · Pampa, TXBuilt 1974 · S/N 21060273N93129Klca Inc · Warsaw, INS/N 21060274N9312XLewan William F · Naperville, ILBuilt 1962 · S/N 18253712N93135Shannon Frances W · Clarksdale, MSBuilt 1974 · S/N 21060278N9313GSchwend Brian · Forsyth, MTBuilt 1973 · S/N 18801450N93157Haley Mitchell P · Big Lake, MNBuilt 1974 · S/N 21060285N9317MWestwind Aviation Inc · Phoenix, AZBuilt 1980 · S/N 20700680N9317WBruton Paul R · El Campo, TXBuilt 1986 · S/N U20607018N93183Frost John David Trustee · Anchorage, AKBuilt 1976 · S/N 18503190
Back to AD 86-13-04 R3