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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N955LJTk Healthcare Management LLC · Abilene, TXS/N E-3082 N955LSSomd Seaplanes LLC · Lexington Park, MDBuilt 1973 · S/N 18502259 N955WGReich Stephen B · Kentfield, CABuilt 1978 · S/N P21000185 N9561GFlying D Aero LLC · Colorado City, TXBuilt 1974 · S/N 18801536T N9561QOliver James L · Orion, MIBuilt 1966 · S/N D-8171 N9563GLitzen Guide Service · Kenai, AKBuilt 1972 · S/N U20601763 N9563HHartman Thomas J Trustee · Anchorage, AKS/N 18503448 N9563QLarson Wallace K · Colorado Springs, COBuilt 1966 · S/N CE-61 N9564QHglv Holding Co LLC · New Rochelle, NYBuilt 1966 · S/N CE-62 N9565QBonanza II LLC · Milton, FLBuilt 1966 · S/N D-8282 N9566QMoskol Jake · Madison, WIBuilt 1966 · S/N D-8201 N9567QDreger Jeffrey W · Poplar Grove, ILBuilt 1966 · S/N D-8202 N9568QN9568q LLC · Lake Worth, FLBuilt 1966 · S/N D-8203 N956CL & S Aviation Inc · Manassas, VABuilt 2002 · S/N 0387 N956EALopez Fabio · Denver, NCBuilt 1976 · S/N 340A-0085 N956NDPrather L Norene Trustee · Eustis, FLS/N CD731 N956PAKoelbl Aviation LLC · Whitesboro, TXBuilt 1969 · S/N TE-703 N956SBBeaux Air LLC · England, ARBuilt 1973 · S/N TE956 N956TDDonohue Thomas · Carmel, NYBuilt 1959 · S/N NAV41838 N956VParker Aerospace LLC · Warren, VTBuilt 1975 · S/N D-9817 N956WBEd Payne Motors Inc · Weslaco, TXBuilt 1981 · S/N 21064532 N9570QAbubakar Sunday · Wichita Falls, TXBuilt 1968 · S/N E-18 N9572GJones Robert D Jr · Chugiak, AKBuilt 1972 · S/N U20601772 N9573ZBangert Richard E III · Seattle, WABuilt 1981 · S/N U20606549 N9574GKreiner Kurt · Rch Palos Vrd, CABuilt 1972 · S/N U20601774 N9574QHarris Steven L Trustee · Sisters, ORBuilt 1966 · S/N D-8205 N9575GGolden Eagle Outfitters · Delta Junction, AKFirst renewal noticeBuilt 1972 · S/N U20601775 N9576GWerth Lance C · Johnson Lake, NEBuilt 1974 · S/N 18801542 N9577EWeinrich Stanley Craig · Saint Augustine, FLBuilt 1976 · S/N 76-30837 N9577YShort Notice Inc · Pensacola, FLBuilt 1981 · S/N 21064552 N957DFNorthern Flight Expeditions LLC · Hopkins, MNBuilt 1973 · S/N 18502194 N9581HCole Jimmie D · Cotopaxi, COBuilt 1977 · S/N 18503450 N9582EDsm Aviation Financing LLC · Dallas, TXBuilt 1978 · S/N 78-30866 N9582MAmerican Aviation Inc · Woods Cross, UTBuilt 1981 · S/N 20700705 N9583MUsda Aphis Ppq · Edinburg, TXBuilt 1978 · S/N U20604552 N9583QHangarfinds LLC · Westminster, COBuilt 1966 · S/N D-8211 N9585GBillmyer Services Inc · Friday Harbor, WABuilt 1972 · S/N U20601785 N9585QTarheel Aircraft Inc · Richlands, NCBuilt 1968 · S/N D-8828 N9587QCherokee Flyers Lc · Ellsworth, IABuilt 1966 · S/N D-8214 N9588QNsa LLC · Chandler, AZBuilt 1966 · S/N D-8215 N958CCSolomon Mark Trustee · Wilmington, DEBuilt 1989 · S/N TH-1565 N958DMDw Moyer Aviation Inc · Stroudsburg, PABuilt 1982 · S/N CE-1005 N958HCHydroair LLC · Auburn, ALBuilt 1999 · S/N TH-1891 N958PDrew Jensen Inc · Lincoln, NEBuilt 1978 · S/N TJ-139 N958PBMo Elite Air LLC · Rolla, MOBuilt 1981 · S/N TJ-392 N958WDBrush Art Corp · Downs, KSBuilt 1999 · S/N TH-1928 N9591ELonas Hal C · Carlsbad, CAS/N 76-30843 N9594QJhb Leasing LLC · Madison, MNBuilt 1966 · S/N TE-178 N9597EEwart Scott J · Fallon, NVBuilt 1978 · S/N 78-30899 N9598QN9598q LLC · Cincinnati, OHBuilt 1966 · S/N D-8222

Back to AD 86-13-04 R3