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.

N646TTango Charlie LLC · San Leon, TXBuilt 1974 · S/N TE-981N6470HJb Aircraft LLC · Anchorage, AKBuilt 1979 · S/N 20700534N6470YSkyhigh Enterprises LLC · Holland, MIBuilt 1981 · S/N 21064396N6476WWill Investments Inc · Englewood, COBuilt 1981 · S/N P21000784N6476ZVorlop Robert W · Delray Beach, FLBuilt 1982 · S/N EA-311N64793N64793 LLC · Naples, FLBuilt 1982 · S/N E-2057N6479NSouth Aero LLC · Albuquerque, NMBuilt 1978 · S/N 21063053N6479YGv Air Inc · Medford, ORBuilt 1981 · S/N 21064399N647CDGomez Enrique Jose · Pinecrest, FLBuilt 2005 · S/N 1724N647DKSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1967 · S/N D-8583N647JAGuarente Christopher Alan · Highlands Ranch, COBuilt 1997 · S/N DMO 374N647SBHyde Matthew L · Santa Cruz, CABuilt 1982 · S/N 21064743N647TMUnited States Air Force Owner · Hanscom Afb, MABuilt 1966 · S/N TF-59N6482NBoerboon Jeffrey T · Cave Creek, AZBuilt 1981 · S/N 18504311N6482YSky West Aviation Inc Trustee · Albuquerque, NMS/N 21064400N6484AState Of Illinois · Springfield, ILBuilt 1979 · S/N 21063535N6484L6484l LLC · Denver, COBuilt 1982 · S/N EA-313N6486NTennessee Aviation Co LLC · Knoxville, TNBuilt 1982 · S/N CE-1007N6486VVroom Engineering Inc · Tucson, AZBuilt 1984 · S/N T30300311N6489WReed Michael · Temple, TXBuilt 1981 · S/N P21000785N648CDurant Cecil John · Arlington, TXBuilt 2003 · S/N 0441N648CB648cb LLC · Columbus, OHS/N 0648N648DWDewhipet LLC · Sibley, LABuilt 1966 · S/N P206-0252N648JRStreamline Aviation LLC · Henderson, NVBuilt 1977 · S/N E-1070N648SBHays Kelly · Dumas, TXBuilt 1979 · S/N 421C0648N648VWYankee Flyers LLC · Mount Gilead, OHBuilt 2004 · S/N 200005-MN6491BTerrill Guy J · Dillon, MTBuilt 1978 · S/N 21062774N6491HBlue Air 3 LLC · Miami, FLBuilt 1979 · S/N 20700543N6491ZAndolina Richard F Jr · Hornell, NYBuilt 1981 · S/N U20606293N6492BPatno Delviny A · Daniel, WYBuilt 1978 · S/N 21062775N6492HSpernak Airways Inc · Anchorage, AKFirst renewal noticeBuilt 1979 · S/N 20700544N6492NOrmand Philip M · Tyrone, NMBuilt 1978 · S/N 21063066N6492UWisber Peter F Jr · Perkasie, PABuilt 1979 · S/N U20605489N6492YMiller Gary Lee · Pittsburgh, PABuilt 1981 · S/N 21064404N6493NEagle Cap Leasing Inc · Enterprise, ORBuilt 1978 · S/N 21063067N6495NBusiness Trip Corp Inc · Cape Coral, FLBuilt 1978 · S/N 21063069N6496NFisher Ranch Corporation · Blythe, CABuilt 1982 · S/N EA-314N6497EPeoples Mike · Rockwall, TXBuilt 1980 · S/N 18504050N6498VSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N T30300313N6499NHelgren Quentin C · Oakland, CABuilt 1978 · S/N 21063073N649CDSouthcap Brokerage Altanta Inc · Inlet Beach, FLBuilt 2005 · S/N 1709N649ECDriggers David M · Tifton, GABuilt 1981 · S/N TH-1323N649LCSmith Aviation LLC · Sitka, AKBuilt 1980 · S/N TJ-304N64BTSunflower Enterprises Inc · Dubuque, IAS/N CE-1152N64BWSkyjams Holdings LLC · Las Vegas, NVBuilt 1975 · S/N E-656N64CGRobinson James D · Spearfish, SDBuilt 1964 · S/N D-7674N64DDMorton Steven D · Wynantskill, NYS/N E-73N64DWNavation LLC · Lauderhill, FLBuilt 1973 · S/N TH-306N64GGShelby Monroe Group LLC · Sioux City, IABuilt 2015 · S/N E-4060N64KTKlute Jordan · Omaha, NEBuilt 1976 · S/N 340A0045
Back to AD 86-13-04 R3