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.

N26STSky Condor Aviation LLC · Flatwoods, WVBuilt 1974 · S/N 414-0536N26TARyan Air Inc · Anchorage, AKBuilt 1981 · S/N 20700725N26URDartswift Inc · Philadelphia, PABuilt 1988 · S/N CE-1274N26WLTrio Leasing LLC · Highland, MIBuilt 1974 · S/N TH-406N2701TGray Stephen T · Lafayette, CAS/N D-8436N2702LE D Santos & Associates LLC · Wilmington, DEBuilt 1980 · S/N 414A0608N2702VAtx Aero LLC · Austin, TXBuilt 1979 · S/N 340A0904N2703TChapman Daniel W · Soldotna, AKS/N TE-342N2704NKimberton Corp LLC · Phoenixville, PABuilt 1979 · S/N 335-0003N2704SC&M Asset Management LLC · Owasso, OKBuilt 2005 · S/N 1265N2704UMatheson Thomas Blair · Mandan, NDS/N 335-0005N2704WSpillman David T · Flagstaff, AZBuilt 1967 · S/N U2060690N2705LLt Aviation LLC · Plattsmouth, NEBuilt 1979 · S/N 335-0010N2706AFlhs LLC · Cedar Park, TXBuilt 1979 · S/N 335-0013N2706TDodson Internarional Parts Inc · Rantoul, KSBuilt 1979 · S/N 335-0017N2708SQuiroga Herman R · Phoenix, AZBuilt 1979 · S/N 335-0032N2708TCae Aviation LLC · Peshtigo, WIBuilt 1979 · S/N 335-0033N2708YWings Aircraft LLC · New Richmond, WIBuilt 1979 · S/N 335-0035N2709BA&R Investments Inc · Sylvania, OHBuilt 1979 · S/N 335-0037N2709RSchultz Daniel A · Tipp City, OHS/N 335-0039N270KFirst Gear Inc · Fort Wayne, INBuilt 1989 · S/N CE-1386N270MRFurtado William J III DBA · Fremont, CABuilt 1976 · S/N 21061660N270RCEagle 1-N270rc LLC · San Juan, PRBuilt 1980 · S/N 402C0269N2710JPeople Incorporated Of Virginia · Abingdon, VABuilt 1979 · S/N 335-0043N27117Chalfant William Paxson III · Concord, NCBuilt 1979 · S/N E-1416N2711NMountain Air Aviation LLC · Fruit Heights, UTBuilt 1980 · S/N 335-0050N2712FDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N 402C0121N2712TJames Todd E · Lebanon, PAS/N TE-349N2714CLipcon James P · Stow, MABuilt 2005 · S/N 1393N2714TVertical Flight Leasing LLC · Wilmington, DEBuilt 1967 · S/N D-8438N2715TDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 402C0214N2717AMitchell Matthew · Roanoke, TXBuilt 1969 · S/N D-9049N2717TIberlin James M · Gillette, WYBuilt 1967 · S/N TE-351N2718YRichland Aviation Inc · Sidney, MTBuilt 1979 · S/N 402C0232N271PBClark Mayer Aviation LLC · Cross Roads, TXBuilt 1997 · S/N TH-1840N2720ABaron N2720a LLC · Faulkton, SDBuilt 1978 · S/N TK-69N2720TMiller Mark · Bellevue, WABuilt 1967 · S/N D-8441N2721TGalvin Peter · Laytonsville, MDBuilt 1967 · S/N D-8443N2722AMontgomery Douglas Tanner · San Antonio, TXBuilt 1969 · S/N D-9050N2724JHorseshoe Air LLC · Pella, IAS/N 185-1474N2724TWittenbrader Jeff · Lake Ariel, PABuilt 1967 · S/N TE-354N2727LAircraft Trustee Services Inc Trustee · Dover, DES/N 414A0602N2728TMilk Ranch LLC · Stephenville, TXBuilt 1967 · S/N D-8447N2729LVip Wellness LLC · Victoria, TXBuilt 1979 · S/N 414A0431N2729TWasileski David J · Auburn, NYS/N D-8451N272CTInncal Inc · Stockton, CABuilt 1993 · S/N E-2824N272MSHinkle Paul · Broken Arrow, OKBuilt 1964 · S/N D-7429N272QFlying Docs LLC · Tomball, TXBuilt 1966 · S/N TE-236N272SBofinger Jr John M · Hewitt, NJBuilt 1965 · S/N D-8002N2730ASteigenga Nathan L · Suffolk, VAS/N E-1229
Back to AD 86-13-04 R3