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.

N6642DShelk John Brian · Bend, ORBuilt 1979 · S/N TE-1162N6642VCasey Joseph · Buffalo, WYBuilt 1970 · S/N 30297N6643EReynolds Ronnie · White Hall, ARBuilt 1979 · S/N TJ-215N6643PRobert Yost Enterprises Inc DBA · Saint Francis, KSBuilt 1979 · S/N EA-45N6643VSullivan Hal N Administrator · Paducah, KYBuilt 1970 · S/N 30283N6644QLomakin Anatol · Lincoln Park, NJBuilt 1974 · S/N 414-0543N6644VHeminger Rex A · Colleyville, TXBuilt 1970 · S/N 30281N6645VBrown Christopher C · Sheridan, WYBuilt 1970 · S/N 30309N6646VBelush Richard · Columbus, INBuilt 1970 · S/N 30292N6646ZN1437a LLC · Delray Beach, FLBuilt 1981 · S/N TJ-203N6647RBradamike LLC · Fostoria, OHBuilt 1979 · S/N E-1561N66489Fog City Flying LLC · Dublin, OHBuilt 1983 · S/N E-2073N6648DPedrizetti Raymond D · Sammamish, WABuilt 1979 · S/N CE-864N6648JWindward Passage Corporation · Englewood, NJBuilt 1979 · S/N E-1514N6648NMark & David LLC · Coldwater, MSBuilt 1979 · S/N D-10250N6649DBas Part Sales LLC · Greeley, COBuilt 1979 · S/N TH-1041N6649LChauza Edward J · Mesa, AZBuilt 1979 · S/N E-1516N6649SRay James William · Albert, NMBuilt 1976 · S/N D-9847N664DMStar Air Group LLC · Anchorage, AKBuilt 1968 · S/N D-8721N664JGSpecialty Contractors Inc · Lake In The Hills, ILBuilt 1990 · S/N CE-1481N664RJGeneva Lakes Aviation LLC · Lake Geneva, WIBuilt 1975 · S/N 402B0854N664SKenney Michael D · Lucas, TXBuilt 1978 · S/N 421C0467N664TBechtol Andrew M · Long Beach, CABuilt 1972 · S/N D-9374N6650HN6650h LLC · Edmond, OKBuilt 1982 · S/N EA-318N6650LHoward Barron S · Henderson, NVS/N CE-866N6650VHarris Willis J · Letts, IABuilt 1966 · S/N 30001N66514Vintage Aviation Medical Associates LLC · Wilmington, DEBuilt 1979 · S/N E-1522N66518Daly Stephen M · Oakland, FLBuilt 1979 · S/N TH-1044N66519George Jon L · Gulf Shores, ALBuilt 1982 · S/N E-2054N6651VDunbar Stephen E Trustee · Broken Arrow, OKBuilt 1966 · S/N 30003N66529King Warren D · Bend, ORBuilt 1979 · S/N EA-8N6652DRafter B Cattle Company LLC · Gordonville, TXBuilt 1979 · S/N D-10254N6652JAir Chairs LLC · Austin, TXBuilt 1979 · S/N EA-11N6652RDrummond Williams D · Bloomington, INBuilt 1979 · S/N E-1524N6652VLaughlin David E · Rapid City, SDS/N 30005N6652YSeiger Thomas W · Medford, ORS/N E-1525N6653DWilliams Lee V · Dallas, TXS/N D-10256N6653VWalker Ray A · Sanger, TXBuilt 1979 · S/N D-10253N6654LRomeo Air LLC · Missoula, MTS/N EA-50N6654RLow Mach Aero LLC · Hays, KSBuilt 1979 · S/N D-10273N6654YLewis Garry L · Livingston, LABuilt 1979 · S/N TH-1061N6655GRight Wing Left Wing Flyers LLC · Cleveland, GABuilt 1968 · S/N E-89N6655QDurham Aviation LLC · Henrietta, TXS/N E-1740N6655YBretts Spray Service Inc · Onida, SDBuilt 1979 · S/N E-1559N66568Trapp Aviation Ltd · Lebanon, OHS/N TK-105N6656GCommonwealth Of Massachusetts · Plymouth, MABuilt 1973 · S/N 18801210N6656LAviation Solutions Group LLC · Royal Oak, MIBuilt 1979 · S/N CE-873N6656RHarris Walter D · Chatham, NJBuilt 1979 · S/N D-10275N6656WBonanza Partners Of Kc LLC · Shawnee, KSBuilt 1983 · S/N E-2075N6657TPilot-Ready LLC · Lime Springs, IABuilt 1979 · S/N EA-22
Back to AD 86-13-04 R3