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.

N8338ZNistler Ben · Bozeman, MTBuilt 1963 · S/N 205-0338 N8339NMekolik Aaron S · College Station, TXBuilt 1968 · S/N D-8746 N833MAberle Jonathan Andrew · Denver, NCBuilt 2005 · S/N 1338 N833PMLonely Luggage Delivery Inc · Arroyo Grande, CABuilt 1979 · S/N CE-857 N833RTNash LLC · Carbondale, ILBuilt 1982 · S/N P21000809 N833SRN833sr LLC · Mount Sterling, KYBuilt 2005 · S/N 1530 N833TDTdu Investments LLC · Lewiston, IDBuilt 1998 · S/N CE766 N833TXN833tx LLC · Little Rock, ARBuilt 1978 · S/N TJ-153 N8343NWavra Mark F · East Grand Forks, MNBuilt 1968 · S/N D-8741 N8344NCatanzaro Dennis · Ocklawaha, FLBuilt 1968 · S/N CE-209 N8345QKatahdin Air Service Inc · Hermon, MEBuilt 1976 · S/N U20603206 N834AKGilreath Todd L · Benton, LABuilt 2005 · S/N 1288 N834BCSun Realty Of Nags Head Inc · Hobe Sound, FLBuilt 2018 · S/N TH-2502 N834CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N 0168 N834LAHampton Jeffrey · Wayne, ILBuilt 2003 · S/N 0463 N834TMStoelt William L · Lynden, WABuilt 1964 · S/N D-7433 N8352QUnited Indian Missions DBA · Tucson, AZBuilt 1976 · S/N U20603213 N8353NLindahl Jonathan · Cary, ILBuilt 1968 · S/N D-8756 N8355Premier Plus Aviation Inc · Fort Pierce, FLBuilt 1979 · S/N 421C0668 N8355QDelta Pacific Northwest LLC · Anchorage, AKS/N U20603216 N8356NNielson Frederick P · Mesquite, NVS/N D-8744 N8358NQuam Contracting LLC · Creston, IAS/N D-8751 N8359NHendricks Flying Service LLC · Imperial, NEBuilt 1968 · S/N D-8753 N835RCDodson International Parts Inc · Rantoul, KSS/N 4040835 N8360NYost Rawson · Watertown, SDBuilt 1968 · S/N D-8755 N8360QU S Department Of The Interior · Boise, IDBuilt 1978 · S/N 18503666 N8366QBesse Richard L · Wasilla, AKFirst renewal noticeBuilt 1976 · S/N U20603227 N8367NSearch Septic · Bailey, COBuilt 1968 · S/N D-8749 N8367QDashiell Paul · Fairfield, WABuilt 1978 · S/N 18503669 N8368QBrown Christopher · Grass Valley, CABuilt 1976 · S/N U20603229 N836BCTextron Aviation Inc · Wichita, KSBuilt 2014 · S/N E-4021 N836EVoss Danielle · Dover, NHBuilt 1982 · S/N E-2059 N836JBReis James C · Lake Ozark, MOBuilt 2000 · S/N E3312 N836LGFly A36 LLC · Browntown, WIBuilt 2001 · S/N E-3405 N836RFNuage Software Corp · Saint Petersburg, FLBuilt 2002 · S/N 40051 N8370QState Of Alaska Dept Of Fish And Game · Palmer, AKBuilt 1976 · S/N U20603231 N8371NDecision Air Corp · Wilmington, DEFirst renewal noticeBuilt 1968 · S/N D-8758 N8372NRudolph Pam G Trustee · Lake Havasu City, AZBuilt 1968 · S/N D-8759 N8373NCarey Thomas E · Huntington Beach, CAS/N TE-551 N8373QBassham Clark · Anchorage, AKBuilt 1978 · S/N 18503670 N8374Q8374q LLC · Gig Harbor, WABuilt 1976 · S/N U20603235 N8375QSt George Edward · Henderson, NVBuilt 1978 · S/N 18503671 N8377NGudgel Daniel R DBA · Lemoore, CABuilt 1968 · S/N CE-214 N8377QAafedt Aaron B · Belgrade, MTBuilt 1978 · S/N 18503672 N8378NBowler Joseph · Inglis, FLBuilt 1968 · S/N D-8760 N8378QAeroworks Of Alaska LLC · Chugiak, AKBuilt 1976 · S/N U20603239 N8379QLaumeyer Richard H · Wilson, WYBuilt 1978 · S/N 18503673 N837EGZachariah Craig Powell · Salina, KSS/N E-2467 N837MLBombero Aviation LLC · Childress, TXBuilt 1994 · S/N EA558 N8383QThompson Gordon H · Anchorage, AKBuilt 1978 · S/N 18503675

Back to AD 86-13-04 R3