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.

N26588Golden Aero LLC · Tarpon Springs, FLBuilt 1980 · S/N 421C0835N2658BBrowning Frank W · Port Orange, FLBuilt 1986 · S/N CE-1086N2658ZVirtue Genetics LLC · Cedar Rapids, IAS/N 421C0827N2659BAnderson Brian E · York, PABuilt 2002 · S/N 0237N2659SRovey Gerald A · Troy, IDBuilt 1973 · S/N 18502261N2659UMec Management LLC · Wilmington, DEBuilt 1986 · S/N E-2316N265DBKlw Coastal Equipment LLC · Destin, FLBuilt 2008 · S/N TH-2241N265JPN265jp LLC · Mill Valley, CABuilt 2004 · S/N 0888N265KBCedaron Medical Inc · Davis, CABuilt 2019 · S/N TH-2523N265PCSilver Eagle II LLC · Carson City, NVBuilt 1980 · S/N 340A-0996N2660UUnited Front Holdings LLC · Laguna Hills, CABuilt 1981 · S/N 421C1210N2662XTail Aero Corp · Wilmington, DEBuilt 1965 · S/N P206-0162N2664Lcj Holdings LLC · Youngsville, LAS/N 310R0195N2664FWisconsin Aviation Inc · Watertown, WIBuilt 1980 · S/N 414A0534N2664LAce Airways LLC · Quincy, WABuilt 1980 · S/N 414A0535N2664MInfcon LLC · Wilmington, DEFirst renewal noticeS/N E-2317N2667Marlow Air LLC · Gilmanton Iw, NHBuilt 1965 · S/N D-7997N2667BBellanca Flyer Inc · Winter Garden, FLBuilt 1988 · S/N 89-301002N2667MYce Consulting Inc · Easton, PABuilt 1989 · S/N 89-301008N2667SMarcum Aviation Maintenance Services LLC · Galena, OHS/N 21061347N2668ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 421C1216N26692Fields Douglas P Jr · Brooklyn, NYBuilt 1979 · S/N 310R1849N2669NWilliamson Benjamin J · Morgan Hill, CABuilt 1979 · S/N 340A0735N2669XSkydive Ricks LLC · Petersburg, OHBuilt 1965 · S/N P206-0169N266BNPinckney Michael M DBA · Pensacola, FLBuilt 1988 · S/N 89-301001N266GSchroeder Robert J · Kaukauna, WIBuilt 1966 · S/N TE-205N266HRegistered aircraftBuilt 2008 · S/N E-3877N266JDJ D Deboskey Inc · Palm Beach Gardens, FLS/N G-810N266PDLiberty Garden Center Inc · Norwich, NYBuilt 1967 · S/N D-8654N266TCAir Control Systems · Bigfork, MTS/N EA-483N2670MPhelan Construction LLC · North Andover, MABuilt 1986 · S/N CE-1082N26732Jefferies Jon F · Elk Grove Village, ILBuilt 1990 · S/N 90-301012N2673BM & N Of Alabama LLC · Magnolia Springs, ALBuilt 1980 · S/N 414A0630N2673DAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 340A0755N2673SWilliams Randall S · Chico, CABuilt 1976 · S/N 21061348N2674XKaiser Eric J · Milford, INBuilt 1966 · S/N P206-0174N2676BKero Jet Corporation · Montgomery, TXBuilt 1979 · S/N 340A0762N2676RStauter Michael D · Idabel, OKBuilt 1979 · S/N 340A0765N2676YHands Holdings · Newark, DEBuilt 1981 · S/N 414A0631N2677ST&D Janitorial Services LLC · Dexter, MOBuilt 1988 · S/N 89-301003N2677XHawk Jeff · Flowermound, TXBuilt 1965 · S/N P206-0177N2678SHardy Mikel Gareth · Thatcher, AZBuilt 1973 · S/N 18502265N2678XStewart Jeffrey D · Snyder, TXBuilt 1965 · S/N P206-0178N2678ZKing Canyon Buffalo Inc · Denver, COFirst renewal noticeBuilt 1990 · S/N 90-301010N26795Horan Roger · Plainview, TXBuilt 1992 · S/N 93-301015N267CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0030N267LMAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N P21000362N267PDWhite Hat Repair LLC · Greenleaf, IDBuilt 1967 · S/N TE-284N2681XZimmer Roy E Jr · Winter Park, FLBuilt 1965 · S/N P206-0181N2682AAnacortes Associates LLC · Anacortes, WABuilt 1969 · S/N D-9045
Back to AD 86-13-04 R3