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.

N293PCBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N E-4028N293SMKemp Aviation LLC · Hiram, GABuilt 1982 · S/N EA-329N293SRSykes Robert G · Hopkins, MNBuilt 2004 · S/N 0923N2943TN2943t LLC · Fort Myers, FLBuilt 1966 · S/N 346N294AMAeh Flying Inc · Cincinnati, OHBuilt 1985 · S/N E-2262N294DWStenographer Aviation LLC · Aiken, SCBuilt 2017 · S/N TH-2478N29542Giannakakis Peter J · Monroe, MIBuilt 1973 · S/N 21059866N2957QGenerals International Inc · Red Oak, TXBuilt 1969 · S/N 421A0057N295AKGlick Farms Inc · Minot, NDBuilt 2003 · S/N 0719N295EC295ec LLC · Eau Claire, WIBuilt 2002 · S/N 0197N295FAStationair Amphib LLC · Jefferson City, MOBuilt 1980 · S/N U20605482N295RJRegistered aircraftBuilt 1983 · S/N EA-381N2961JFrey Jerry P · Fallon, NVBuilt 1979 · S/N T18803581TN2961TMagnumforamen Ppg Aeroadventures LLC · Kalispell, MTBuilt 1966 · S/N 334N2962TAviation Days LLC · Ridgefield, CTBuilt 1966 · S/N 335N29631Registered aircraftBuilt 1973 · S/N 21059873N2964TMallard Aviation LLC · Manchester, NHBuilt 1966 · S/N 337N2966TThomas Paul J · Oakland, MDBuilt 1966 · S/N 339N29674Snflk Leasing LLC · Andrews, TXBuilt 1973 · S/N 21059875N2969TDoskicz Aircraft Specialties Inc · Bally, PABuilt 1966 · S/N 342N296BJQualitair LLC Trustee · MichelstadtBuilt 1965 · S/N 21058697N2971Dick Holdings LLC · Merritt Island, FLBuilt 2020 · S/N TH-2537N2971TWhitfield Robert O Jr · Hurdle Mills, NCBuilt 1966 · S/N 343N2972TTurnage Marvin E · Little Rock, ARBuilt 1966 · S/N 344N2975TSmith David W · Milaca, MNS/N 348N2976TMckay Ronye · Omaha, NEBuilt 1966 · S/N 349N2979TMays Stephen W · Carson City, NVBuilt 1966 · S/N 345N297DRMingus Mason · Scottsville, KYBuilt 1978 · S/N 62398N297MPElbow Joint Aviation LLC · Brunswick, GABuilt 2006 · S/N E-3711N297ZEnovi LLC · Las Vegas, NVBuilt 1981 · S/N U20606223N2980AWest David R · Newalla, OKBuilt 1978 · S/N D-10154N2980TMyers Thomas · Wills Point, TXBuilt 1966 · S/N 354N2981TKool-E5 LLC · Valdosta, GABuilt 1966 · S/N 355N2983TSlatter Lowell J · Buhl, IDBuilt 1966 · S/N 356N2987TDaly Arthur P · El Paso, TXBuilt 1966 · S/N 360N2988TSwiftmeyers LLC · Benton Harbor, MIBuilt 1966 · S/N 361N2989TMid America Museum Of Aviation And Transportation · Sioux City, IABuilt 1966 · S/N 362N298CSCirrus Sr22 Somex Inc Trustee · Wilmington, DEBuilt 2005 · S/N 1408N298FMStuart Scott · Lincoln, NEBuilt 2016 · S/N E-4098N2990TStahl Bradford C · Jackson, CAS/N 363N2991TRothgeb Michael A · Burns, ORBuilt 1966 · S/N 364N2992TMeyers 200 LLC · Malden, MOBuilt 1966 · S/N 365N2993TElghammer Garrott W · Niles, MIBuilt 1967 · S/N 366N2994TZakraisek Donald S · Sandy, UTBuilt 1967 · S/N 367N2996TSims Barry Don Sr · Canadian, TXBuilt 1967 · S/N 369N29970Andrecheck Cynthia R · Bethel, AKBuilt 1981 · S/N 185-04292N29972Windblown Ranch Inc · Echo, ORBuilt 1981 · S/N 185-04162N2998MM T Aviation LLC · Grove, OKBuilt 1986 · S/N CE-1097N2998TMartony Joseph M · Chandler, AZBuilt 1967 · S/N 371N2999MLopez Eve · Santa Monica, CABuilt 1985 · S/N CE-1074
Back to AD 86-13-04 R3