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.

N301CTVatm Sky Investments LLC · Thomson, GABuilt 1980 · S/N TH-1166N301DBDon Davis Aviation Inc · Henderson, KYBuilt 1977 · S/N 310R0891N301DDRockalong Holdings LLC · Stanton, TXBuilt 1979 · S/N 18503985N301EBQuesnel William G · Truckee, CABuilt 1978 · S/N 21062524N301EFRegistered aircraftBuilt 2002 · S/N 3RX105N301HLnc4 Mcx1 LLC · Rexburg, IDBuilt 1999 · S/N 137N301JFGrace Eric C · Valdosta, GABuilt 1979 · S/N E-1593N301MCCharles Michael Maya · Erie, COBuilt 1978 · S/N 18503705N301PRussell Bill W · Victoria, TXBuilt 1978 · S/N TH-890N301PLCutbirth David B · Monahans, TXBuilt 1966 · S/N P206-0334N301RS2f Trade LLC · Collinsville, TXS/N 21062473N301RVK6 Construction Inc · Clovis, CABuilt 2004 · S/N 1172N3021WElliott Robert · Hartington, NES/N E-459N3023WBoughen James R · Camas, WABuilt 1973 · S/N D-9517N3024HMll Air LLC · Kalispell, MTBuilt 1994 · S/N E-2863N3024QJones Sean D · Adams, TNBuilt 1987 · S/N CE-1110N30268Rudd Terry R · Clarkston, WABuilt 1973 · S/N 21059903N30280Emery Clint L · Texarkana, ARBuilt 1973 · S/N 21059907N30282Saucerman Equipment Leasing LLC · Indianapolis, INFirst renewal noticeBuilt 1987 · S/N E-2357N3028WK2 Aviation LLC · Carroll, IABuilt 1973 · S/N E-465N302BCG2 Leasing LLC · Cedar Spring, MIBuilt 1982 · S/N E-1982N302BYAviation Homes LLC · Terrell, TXBuilt 2004 · S/N 0985N302CDChadmatt Explorations LLC · Pensacola, FLBuilt 2004 · S/N 1076N302GPInternational Air Services Inc Trustee · Carson City, NVS/N 21058682N302MCB & G Ventures LLC · Kalispell, MTBuilt 1973 · S/N 310Q0909N302STManagement Support Services LLC · Naturita, COBuilt 1968 · S/N T210-0350N302WDivine John S III DBA · Myrtle Beach, SCS/N E-302N3030DBoardwalk Management LLC · Kalispell, MTBuilt 1999 · S/N E-3230N3030SBrewer Mike · Cameron Park, CABuilt 1978 · S/N E-1280N3031QBrut N3031q · Los Angeles, CAFirst renewal noticeBuilt 1998 · S/N E-3196N3032LBlue Sky Air Ventures LLC · Wilmington, DEBuilt 1999 · S/N EA-632N3032WDebrouwer Isabelle Mc · Alpine, TXBuilt 1973 · S/N D-9525N3033BPalms Edward M · Greenwood Village, COBuilt 1998 · S/N TH-1869N3034CTyler Bonnie Flying LLC · Tyler, TXBuilt 1986 · S/N E-2341N3035WWorldwide Air & Sea Inc · Wilton, NHBuilt 1999 · S/N EA-635N30374Canihan William R · Novato, CABuilt 1973 · S/N 21059918N303ABMarc Inc · Bolton, MSBuilt 1981 · S/N T30300028N303BPMohan Anand · Vienna, VABuilt 2005 · S/N 1698N303CCSpectrum Aviation Inc · Wilmington, DEBuilt 1982 · S/N T30300069N303CGSolomon Mark Trustee · Wilmington, DEBuilt 1981 · S/N T30300022N303CMAdvantage Aviation Inc · Charlotte, NCBuilt 1984 · S/N T30300296N303CTFloyd Brian · Eatonton, GABuilt 1978 · S/N 21062591N303DBBas Part Sales LLC · Greeley, COBuilt 1981 · S/N T30300043N303DCRegistered aircraftBuilt 1973 · S/N 402B-0303N303DKTrading Planes Inc · Wilmington, DEBuilt 1982 · S/N T303-00068N303HLLao Che Airfreight LLC · North Weymouth, MABuilt 1982 · S/N T30300038N303HVRegistered aircraftBuilt 1994 · S/N E-2864N303JPJep Inc · Clarksville, TNBuilt 1982 · S/N T30300067N303KCCurry Kenneth R · Cookeville, TNS/N CE-1138N303KJBrother Michael Andrew · Bedford, TXBuilt 1984 · S/N T303-00301
Back to AD 86-13-04 R3