OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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.

N8602QMarker Richard A · Healdsburg, CABuilt 1964 · S/N D-7633N8603QHolland Jeffrey R · New Canaan, CTBuilt 1964 · S/N D-7634N8604QPearson John P · Pueblo, COBuilt 1964 · S/N D-7635N8604ZHirsch T J Jr · Olney, TXBuilt 1967 · S/N P206-0404N8605KWadsworth & Wadsworth LLC · Morehead City, NCS/N 340A1241N860AJohnson Plane Services LLC · Greenbrier, TNBuilt 1980 · S/N CE-934N860RCCornell Christopher M · Corpus Christi, TXS/N 421B0035N860TBrashier Gregery A · Decatur, TXBuilt 1964 · S/N D-7715N86109State Of Utah · Salt Lake City, UTBuilt 1976 · S/N 18503153N8610QPetersen Mark W · Poplar Grove, ILBuilt 1964 · S/N D-7623N8612QStockton Ethan · Santa Rosa, CABuilt 1964 · S/N D-7638N8613AAeromedical Aviation LLC · Santa Maria, CABuilt 2005 · S/N 1344N861BMEtos Air LLC · New London, TXBuilt 2018 · S/N E-4121N861DAirtipp LLC · Tipp City, OHBuilt 1975 · S/N TE-1052N861JDJoseph Gary W · Torrance, CABuilt 2000 · S/N 003N861RXMullen Robert R III Trustee · Woodland Hills, CABuilt 1979 · S/N E-1449N861SCSpotted Hawk Aviation LLC · Rosenberg, TXBuilt 1997 · S/N E3128N861THersman Scott · Ada, MIBuilt 1964 · S/N D-7507N861TZOneill Aviation LLC · Hartland, WIBuilt 2004 · S/N 0877N8621QGrossman Kenneth Randell · Merced, CABuilt 1964 · S/N D-7645N8623QS&B Aviation LLC · Incline Village, NVBuilt 1964 · S/N D-7648N8623ZHauze John W · San Antonio, TXBuilt 1967 · S/N P206-0423N8628ZSaddler Susan J · Dayton, OHBuilt 1967 · S/N P206-0428N862CDJolly Mon LLC · Knoxville, TNBuilt 2003 · S/N 0572N862DRegistered aircraftBuilt 1978 · S/N E-1362N862TNovember 862 Tango Inc · Wilmington, DES/N D-7524N8630ZAlaska Village Missions · Homer, AKBuilt 1967 · S/N P206-0430N8632KEano Air 340 LLC · Highland, UTBuilt 1981 · S/N 340A1243N8632ZTate Roger · Redlands, CAS/N P206-0432N8633MFranklin Leonard R · Fresno, TXBuilt 1963 · S/N D-7335N8635ZLipper Stephen W · Griffin, GAFirst renewal noticeBuilt 1967 · S/N P206-0435N8636A36a Ltd · Cincinnati, OHBuilt 1982 · S/N E1977N8636KM & J General Contractors Inc · Elgin, ILBuilt 1978 · S/N 340A0562N8636QJv Aviation LLC · Lynden, WABuilt 1964 · S/N D-7658N8637KCommonwealth Capital Corp · Wilmington, DEBuilt 1978 · S/N 340A0604N8638ZEichman David A · Topeka, KSBuilt 1967 · S/N P206-0438N863CDRoman Joseph L · Montrose, PABuilt 2005 · S/N 1701N863CFBpa Leasing LLC · Lehi, UTBuilt 2002 · S/N 0191N863CPNet Quest Management Services LLC · Winter Haven, FLBuilt 1968 · S/N 421-0117N863GWWellington Gregory D · Parkman, MEBuilt 1969 · S/N 185-1454N863PJBlue Sky Aeronautics Ltd · Toledo, OHBuilt 2014 · S/N E-4042N863STesterman George M Md · Kingsport, TNBuilt 1969 · S/N D-8922N86407Donalds Flying Service Inc · Pantego, NCBuilt 1975 · S/N 18802013TN8643QFirebird Aero LLC · Phoenix, AZBuilt 1964 · S/N D-7660N8643ZVitatoe Industries Inc · Chillicothe, OHBuilt 1967 · S/N P206-0443N86440Wilde Air Service-Huron LLC · Volga, SDBuilt 1975 · S/N 18802014TN8644ZMasters Mission · Nenana, AKBuilt 1967 · S/N P206-0444N8646QPoe Asphalt Paving Inc · Lewiston, IDBuilt 1976 · S/N U20603462N8647KJughead Aircraft LLC · Salina, KSBuilt 1978 · S/N 340A0605N8647QTechnical Applications & Consulting LLC · Topeka, KSBuilt 1976 · S/N U20603463
Back to AD 86-13-04 R3