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.

N123BTYingling Consultation LLC · Wilmington, DEBuilt 1973 · S/N 421B0414N123CEBas Part Sales LLC · Greeley, COS/N 21061054N123CTPastor Jordan D · Riverside, CABuilt 1967 · S/N D-8590N123DDCenturion 123 LLC · Glenwood Springs, COBuilt 1974 · S/N 21060627N123ECJohnson Howard A · Lake Forest Park, WABuilt 1972 · S/N D-9412N123EPFalkenberg Randy J · Edmonson, TXBuilt 1976 · S/N 185-03216N123GBRegistered aircraftBuilt 1979 · S/N TE-1165N123GSLou Ann Inc · Los Altos, CABuilt 1979 · S/N E-1464N123HBValiair Limited Co Trustee · Casper, WYBuilt 2003 · S/N 0510N123JTGraham Richard A · Wichita Falls, TXBuilt 1965 · S/N T210-0019N123MCNelson Isaac · Saint Croix Falls, WIS/N 21063578N123PKNunley Lonnie · Show Low, AZBuilt 1998 · S/N LRK-017N123RGChurch Brett L · Whitefish, MTBuilt 1968 · S/N D-8816N123RKPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N CE909N123RLBastiano Richard A · Elba, NYBuilt 1966 · S/N 321N123TBTango Bravo LLC · Wilmington, DEBuilt 1979 · S/N 340A0795N123TDVinanam Aviation LLC · Cupertino, CABuilt 1977 · S/N 340A0307N123TMJaars Inc · Waxhaw, NCS/N U20601768N123TWGrandy Boyd · Smoot, WYBuilt 1974 · S/N E-518N123UAwg Aviation LLC · Ainsworth, IABuilt 1968 · S/N 21059004N123USLow Gary Mike · Southside, ARBuilt 1982 · S/N TH-1335N123VRLewis Edward M · Mesquite, NVS/N 210-59891N123WBHighview LLC · Brentwood, TNBuilt 1978 · S/N TH-937N123XCEiger Aviation LLC · Woodstock, ILBuilt 2002 · S/N 0345N1240AAlfa Monkey LLC · Wolfforth, TXBuilt 1969 · S/N D-9028N12434Aviation S And S LLC · Miami, FLBuilt 1983 · S/N 414A1002N1244YBurbank Dennis · Arcadia, OKBuilt 1966 · S/N TE-253N1245AAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 414A1201N1248DHamilton Dwight A · Umatilla, FLBuilt 1966 · S/N CE18N124CCWeaks Taylor Madison · Houma, LABuilt 1984 · S/N 46-8408036N124DPBaja Air LLC · Wilmington, DEBuilt 1979 · S/N 310R1670N124DRLeventis Phil P · Sumter, SCBuilt 1973 · S/N 340-0219N124ELerro Furey W · Wildwood, NJBuilt 2006 · S/N 29-0422N124EVEl Aero Services LLC · Verdi, NVBuilt 2005 · S/N 29-0382N124JFRegistered aircraftBuilt 2005 · S/N 1251N124KWN124kw Corp Trustee · Wilmington, DEBuilt 2005 · S/N 1566N124LCBucks Air Charters Inc · Wilmington, DEBuilt 1980 · S/N E-1684N124LRWilson David J · Palmer, AKBuilt 1970 · S/N 18501639N124MDKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1981 · S/N TJ374N124RMGolden Dreams LLC · Missoula, MTBuilt 1946 · S/N NAV-4-136N124TJAlan Aviation LLC · Los Angeles, CAS/N TH-923N124TMUniversal Aviation LLC · Decatur, ARS/N 421C-0898N124UAKagerer John A Trustee · Anchorage, AKBuilt 1976 · S/N 18503022N124WC3-B Farms Inc · Pinetown, NCBuilt 1973 · S/N 421B0484N124WHHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1979 · S/N U20605355N124WNTemple Steve D · Superior, MTBuilt 1972 · S/N U206-01832N1252GInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 414-0809N1255VHanson Lanny Lane · Polson, MTBuilt 1974 · S/N U20602540N1256Towner Jason A · Burneyville, OKBuilt 2004 · S/N 1205N1259ML A M Capital Management LLC · Sheridan, WYBuilt 1967 · S/N CE-175
Back to AD 86-13-04 R3