OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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.

N2044KSchutze Curt · Knoxville, TNBuilt 1978 · S/N E-1389N2044VPerformance Construction LLC · Paris, TXBuilt 1978 · S/N E-1390N2044WMccraw Richard L Trustee · Hinesburg, VTBuilt 1978 · S/N E-1391N2045CBarreto Antonio Trustee · Norco, CABuilt 1978 · S/N E-1392N2045EDouble P Investments LLC · Kerrville, TXBuilt 1978 · S/N E-1393N2046SYankee Clipper LLC · Dayton, OHFirst renewal noticeS/N 21061013N2046WKj Cessna LLC · Waxahachie, TXBuilt 1978 · S/N CE-825N2046YBrainerd William F III · Sapello, NMBuilt 1978 · S/N E-1395N2046ZFreedom Flying Club LLC · Fort Collins, COBuilt 1978 · S/N E-1396N20478V35b Bonanza LLC · Temecula, CAS/N D-10194N2047BField Inspection LLC · Brawley, CABuilt 1978 · S/N E-1394N2047NAwa Aviation LLC · Sacramento, CABuilt 1978 · S/N E-1400N2047PFromknecht Robert L · Quakertown, PABuilt 1978 · S/N E-1401N2047WKapusta Marian · Clearwater, FLBuilt 1965 · S/N D-7986N2048BCicciari David A · Cincinnati, OHBuilt 1978 · S/N E-1402N2048V5l Aviation LLC · Decatur, TXBuilt 1978 · S/N E-1404N2048WTripi Mark DBA · Parkersburg, WVBuilt 1965 · S/N D-7987N2048ZJulis Wings LLC · Jacksonville, FLBuilt 1978 · S/N CE-828N2049ASouth Delta Aviation Inc · West Helena, ARBuilt 1978 · S/N E-1405N2049NAdvanced Aviation LLC · New Century, KSBuilt 1978 · S/N D-10190N2049WHufford P Thomas Trustee · San Diego, CABuilt 1965 · S/N D-7985N2049ZObie Edgar L · Chinook, MTBuilt 1978 · S/N E-1398N204GXAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 29-0373N204LPSteffenhagen Julian L Jr Trustee · Tustin, CABuilt 1988 · S/N CE-1262N204PT A Infinities LLC · Dover, DEBuilt 1991 · S/N E-2601N204TSAs The Crow Flies Aerial Services LLC · Irving, TXBuilt 1977 · S/N U20604052N2050NPerks Andrew · Weatherford, TXBuilt 1978 · S/N E-1429N2050SDavis Bryan C · Winfield, KSBuilt 1975 · S/N 21061017N2050YSomerville Elizabeth M · West Dennis, MABuilt 1978 · S/N CE-826N2050ZPong William Robert · San Mateo, CABuilt 1978 · S/N D-10193N2051KSocio Aviation Services LLC · Benton, KYBuilt 1978 · S/N D-10198N2051WLeiwant Alan J · Montville, NJBuilt 1978 · S/N E-1410N2051XArana Carlos · The Woodlands, TXBuilt 1978 · S/N E-1411N2053WOem Products Inc · Oklahoma City, OKBuilt 1965 · S/N D-7990N2054NHampton Todd J · Plainfield, INBuilt 1978 · S/N D-10196N2054WVerran Clinton T · Rochester Hills, MIBuilt 1965 · S/N D-7991N2055QJones Jeff A · Lewiston, IDBuilt 1975 · S/N U20602965N2055UR & D Aircraft LLC · Port Orange, FLBuilt 1978 · S/N D-10204N2056NN2056n LLC · Wilmington, DEBuilt 1978 · S/N TJ-156N2056SAcevedo Adriel · San Antonio, TXBuilt 1975 · S/N 21061023N20572Shaw Brian · Meadville, PABuilt 1979 · S/N D-10247N2057ADesruisseaux Kemens · Clarksville, TNBuilt 1978 · S/N E-1420N2058CScorpion Aviation LLC · Hemet, CABuilt 1978 · S/N TK-85N2058WSweet Fred A · Loves Park, ILS/N D-8192N2059ABuerge Scott · Nevada, MOBuilt 1978 · S/N D-10202N2059PNiemi Aviation LLC · Glyndon, MNBuilt 1998 · S/N TJ-159N2059WMorgan Jeffrey B · Edgewater, FLBuilt 1965 · S/N D-7993N2059XK Wings LLC · Golden Valley, MNBuilt 1978 · S/N TH-994N205AGWing Men LLC · Cleveland, OHBuilt 1974 · S/N TH-516N205BFWells David L · Neosho, MOBuilt 2005 · S/N 29-0386
Back to AD 86-13-04 R3