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.

N31FSStrickland Corp · Onida, SDBuilt 1974 · S/N D-9586N31KDChinook Fibre LLC · Wilmington, DEBuilt 1984 · S/N T30300310N31KGMidwest Corporate Air Inc · Bellefontaine, OHBuilt 1978 · S/N 310R1533N31KSPaxton Jacob · Killeen, TXS/N 421B-0662N31KTSmith Kenneth L · Pomona, CABuilt 1970 · S/N 421B0011N31MDKarmy Paul Edward · Burleson, TXBuilt 1980 · S/N P21000595N31RTPapuchin LLC · Highwood, ILBuilt 1970 · S/N 414-0158N31WLAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 0679N3200NLazy Bones LLC · Mitchell, SDBuilt 1998 · S/N E-3200N3205VGonzalez Efrain · Manhattan Beach, CABuilt 1994 · S/N E-2899N3206JHopman Pablo I · Stow, MABuilt 1994 · S/N EA-568N3206LAlpha Tango LLC · Omaha, NEBuilt 1976 · S/N D-9951N3206YN3206y Aviation LLC · Bloomfield Hills, MIBuilt 1994 · S/N E-2903N3207LRdl Construction Inc · Hollister, CABuilt 1976 · S/N E-935N3209DCirrus 1jr LLC · Webster, NYBuilt 1994 · S/N TH-1735N3209JDennis John W · Mooresville, NCBuilt 2000 · S/N E-3299N320ARAir Sal Leasing Inc · Fort Myers, FLS/N 320E-0079N320BVLaird Brian N · Monument, COBuilt 2005 · S/N 1N320CDSimpulse Inc · Oregonia, OHBuilt 2004 · S/N 1248N320DRMontgomery Machine LLC · Guilford, CTBuilt 2005 · S/N 42064N320FWMurrell James F · Douglas, AZBuilt 1967 · S/N 320F-0018N320JKTru-Point Tactical LLC · Columbia, MSBuilt 1966 · S/N 320E0048N320MSConsulat Inc · Cheyenne, WYBuilt 1966 · S/N 320E-0065N320PCAom Aircraft LLC · Wilmington, DES/N 402B0621N320RMRd Harrison Inc · Lexington, NCS/N 340A0939N320RRHighway Aero LLC · Bristow, VABuilt 2002 · S/N 0358N320SKDevries James E · Bejou, MNBuilt 1967 · S/N 320E-0077N320SWEast West Investment Advisors LLC · Sandy Point, VABuilt 1980 · S/N 414A0451N320TJBlaylock Arthur S III · Pace, FLBuilt 1963 · S/N 320B0017N320TTCarroll Richard J · Pocatello, IDBuilt 1966 · S/N 320E-0081N320VCDelta Three Air Services Inc · Burton, OHBuilt 1966 · S/N 320E-0016N320WDAt Liberty LLC · Apple Valley, MNBuilt 1974 · S/N TH-426N3210PKilcullen Brian DBA · Fort Lauderdale, FLBuilt 1978 · S/N P21000027N3211LPrevost Bryan · Lambert, MTBuilt 1976 · S/N D-9914N3212DHalo Aviation Corp · Wilmington, DES/N EA-651N3212GGibby Aviation Inc · Wilmington, DEBuilt 1994 · S/N EA-569N3212MKietzer Farms LLC · Wilmington, DEBuilt 1991 · S/N CE-1552N3213DMountaingales LLC · Phoenix, AZBuilt 1998 · S/N E3213N3214RLima Delta Co Trustee · New Castle, DEBuilt 1994 · S/N CE-1790N3214ZYounger Aviation LLC · Poteau, OKBuilt 1994 · S/N E-2911N3215UAileron T LLC · Orlando, FLBuilt 1994 · S/N E-2915N3216MN3216m Inc Trustee · Carson City, NVBuilt 1981 · S/N 414A0826N3216ZMy Fly LLC · Wilmington, DES/N E-2922N3217EDavis Darren · Flint, TXBuilt 1995 · S/N E-2926N3217MN3217m LLC · Polson, MTBuilt 2000 · S/N E-3317N3217UWelkin Aero Inc · Garden Plain, KSBuilt 1975 · S/N 18502738N3218XMjm Flying LLC · Traverse City, MIBuilt 2000 · S/N E-3358N321AZBuilders Aviation LLC · Algona, IABuilt 2003 · S/N 0508N321BGItinerant Orl LLC · Columbia, SCBuilt 2005 · S/N 1311N321BLWalls Bruce · Middletown, OHBuilt 1981 · S/N P21000792
Back to AD 86-13-04 R3