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.

N389CSSahi Carl R · Coventry, CTBuilt 1985 · S/N 250860N389MCCarstetter Melvin D · Lakebay, WABuilt 1978 · S/N D-10150N389SLively Kirk D · Cresson, TXBuilt 1969 · S/N D-9083N38AZN731ny LLC · Phoenix, AZBuilt 1980 · S/N P21000516N38CJAirplane Seven LLC · Watkins, COBuilt 1978 · S/N 402C0023N38CMSale Reported · Fay-Aux-LogesSale reportedBuilt 1979 · S/N 340A0901N38DKCullinan Robert B · Rch Palos Vrd, CABuilt 1965 · S/N D-7899N38DVMedic Choppers LLC · Springdale, ARBuilt 1968 · S/N E-83N38DZWoolard Flying Service Inc · Corning, ARBuilt 1990 · S/N TH-1577N38FCEagle Aero Inc · Lafayette, LABuilt 1980 · S/N 18504145N38FE239 Lear LLC · Dover, DES/N 340-0096N38FGPatten Mark Samuel · Anchorage, AKBuilt 1979 · S/N 18503920N38GJMonahan Jeffrey L Trustee · Long Beach, CABuilt 1982 · S/N 414A0829N38GWAircraft Partner N38gw Dst · BerlinBuilt 2004 · S/N 1015N38LPN38lp LLC · Jacksonville, FLBuilt 1977 · S/N 414-0960N38NTYorkavitz James B · Valley City, OHBuilt 1980 · S/N TJ-270N38PFSycan Corp DBA · Paso Robles, CABuilt 1980 · S/N 21063979N38PKDeininger Robert · Apopka, FLS/N EA-467N38RRClark Martin B · Dayton, OHBuilt 1976 · S/N E-815N38SSKane Of The Upstate · Greenville, SCS/N E-544N38TLBonanza 1 LLC · Hernando, MSBuilt 1991 · S/N TH1642N38WBEighttwotwo LLC · Wilmington, DEBuilt 1980 · S/N E-1780N38WGOneal Eric T · Geneva, FLBuilt 1970 · S/N TE-811N3900GCoyle Jerry Lee · Prairie Grove, ARBuilt 1967 · S/N U206-0900N3901YCentruion Express LLC · North Port, FLS/N 21058401N3902ACountry Trail LLC · Asheville, NCBuilt 1970 · S/N TE-786N3903QWashington Chinook LLC · Bellingham, WABuilt 1973 · S/N 18502209N3904YOtto William R · Ontario, CABuilt 1964 · S/N 21058404N3906YWildbur Mark B · Laramie, WYBuilt 1964 · S/N 21058406N3907GMid-America Sport Parachute Club · Taylorville, ILBuilt 1967 · S/N U206-0907N3907YAckley John · Brownsville, TXBuilt 1964 · S/N 21058407N390HWRojecki Stephen T Trustee · Navarre, FLBuilt 1967 · S/N D-8608N390LFAcadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1989 · S/N CE-1378N390RSSchoene Edward C · Springfield Center, NYBuilt 1976 · S/N 21061514N3910ARzepka Rick · Solon, OHBuilt 1970 · S/N D-9093N3912PRegistered aircraftBuilt 1978 · S/N P21000074N3914APlane Jane Aviation LLC · Sylvania, GABuilt 1970 · S/N TE-789N3916YMelagrano Jeffrey D · Scarsdale, NYBuilt 1964 · S/N 21058416N391BRWagers Wings LLC · Cleveland Heights, OHBuilt 2015 · S/N TH-2451N391PT7640 Drilling LLC · Amarillo, TXBuilt 1973 · S/N 21060097N391SCSkydive Pennsylvania Inc · Mercer, PABuilt 1969 · S/N U2061405N3920CN3920c Lc · Wichita, KSBuilt 1976 · S/N 421C0145N3921YThompson Steven J · Royse City, TXBuilt 1964 · S/N 21058421N3923GMiddle Fork Aviation Inc · Challis, IDBuilt 1967 · S/N U206-0923N3925YAbney Timothy D · Powell, OHS/N 21058425N3927GAerial Transport LLC · Dover, DEBuilt 1967 · S/N U206-0927N3927MTulin Donald J · Anchorage, AKS/N U20604423N3927YMackenzie Stuart D · Pearland, TXBuilt 1964 · S/N 21058427N3928BKellner Eric · Upland, CABuilt 2004 · S/N 0917N3929YAinsworth Ryan · Portales, NMBuilt 1964 · S/N 21058429
Back to AD 86-13-04 R3