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.

N6913TSanders Wes E · Palos Park, ILBuilt 1985 · S/N 46-8508072N6914YAirgo US Inc · Columbia, MOFirst renewal noticeBuilt 1985 · S/N 46-8508075N691CBHill Curtis B Trustee · Provo, UTBuilt 2015 · S/N E-4079N691DETilton Joseph J · Willow, AKBuilt 1968 · S/N 185 1310N691JHSb Airlines Inc · Wilmington, DEBuilt 1985 · S/N TJ-480N691MSSharptime LLC · Bossier City, LAS/N 20700514N691RBPali Inc · Nashville, TNBuilt 1967 · S/N D-8639N691WTPvb36 Leasing LLC · Roanoke, TXBuilt 1979 · S/N 340A0703N6924RTurbo Centurion LLC · Vail, AZBuilt 1967 · S/N T210-0324N6925RDelong Mark B · Rock Springs, WYBuilt 1967 · S/N T210-0325N69279Alexa Enterprises LLC · Indianapolis, INBuilt 1984 · S/N EA-413N6927BKryptonite Industries LLC · Golden, COBuilt 1978 · S/N 21062853N6927RSavord George Kevin · Boulder City, NVBuilt 1967 · S/N T210-0327N6928RZeroth Law Aviation LLC · Fitchburg, WIBuilt 1984 · S/N E-2151N6929BBantam Vision Inc · Monte Vista, COBuilt 1984 · S/N EA-414N6929RShelfer Douglas · Arlington, TXBuilt 1967 · S/N T210-0329N6930CSix26 Aviation LLC · Freeport, FLBuilt 1984 · S/N EA-420N6930SBurbach Paul J · Waukesha, WIBuilt 1984 · S/N EA-421N6931RFender Darrell L · Garfield, WABuilt 1967 · S/N T210-0331N6932RBoxwell Avionics · Green Cove Springs, FLS/N T210-0332N69369Mobarak Motorsports LLC · Singer Island, FLBuilt 1973 · S/N 402B0516N6936RKingrey William S III · Richmond, TXBuilt 1967 · S/N T210-0336N6939NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1978 · S/N 21063161N6939RGalloway Kyle J · Bradshaw, NEBuilt 1967 · S/N T210-0339N693BHRed River Cellular Telephone Corp · Texarkana, ARBuilt 1980 · S/N TJ-294N693CLin Steven C · Granite Falls, NCBuilt 2002 · S/N 0438N693CDAber Air LLC · Amherst, OHBuilt 2004 · S/N 0976N693CPCharlie Papa 1 LLC · Stafford, TXBuilt 2004 · S/N 1181N693TAIslander Holdings Ltd · Fort Lauderdale, FLBuilt 2026 · S/N 093/USN693TPRight Rudder LLC · Albemarle, NCBuilt 1975 · S/N 414-0624N69425Zanek Foundation · Wilmington, DEBuilt 1973 · S/N 340-0248N69433Rsy Corp · Wilmington, DEBuilt 1973 · S/N 340-0254N6944RSilcox Cleven L · Sapulpa, OKBuilt 1968 · S/N T210-0344N69457Ingram Sidney J DBA · Odessa, TXBuilt 1973 · S/N 340-0309N6945RDonham William David · Odessa, TXS/N T210-0345N6946RGrosslight Gordon · Westcliffe, COBuilt 1968 · S/N T210-0346N69472Rer Of Little Rock Inc · Little Rock, ARS/N 340-0318N69485Plane N Simple Aviation LLC · Los Angeles, CAS/N 340-0327N69492Graham Michael · Newnan, GABuilt 1974 · S/N 340-0332N6949RElyan Aviation Inc · Palm Springs, CABuilt 1968 · S/N T210-0349N694KTSzentkuti Richard · Ridgefield, CTBuilt 2004 · S/N 29-0329N694PRAdvanced Charter Industries LLC · Orange, CABuilt 2005 · S/N 1606N694TTMiller Patrick · Riverside, CABuilt 2004 · S/N 1239N69506Satko Frank G · Chesapeake, VABuilt 1974 · S/N 340-0343N6951YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N P210-00380N69522Kpk Enterprises Inc · Pasadena, CABuilt 1974 · S/N 340-0354N69542Dirty Side Down LLC · Hobbs, NMBuilt 1974 · S/N 340-0362N69555Obanion John William · Powder Springs, GABuilt 1974 · S/N 340-0370N6955NSweet Fred A · Loves Park, ILBuilt 1981 · S/N 18504315N69571Michaels Daniel T · Mars, PABuilt 1973 · S/N 310Q0789
Back to AD 86-13-04 R3