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.

N9598VTee William K Jr · Carlisle, MABuilt 1966 · S/N D-8115 N9599QDavis Eric · Pisgah Forest, NCBuilt 1966 · S/N D-8221 N959DCKpp Air LLC · Navasota, TXBuilt 1980 · S/N 340A0942 N959RHRd Holdings LLC · Las Vegas, NVBuilt 1978 · S/N 414A0217 N959TXAhern John · Prosper, TXBuilt 1977 · S/N 414A0011 N959WTAgave I LLC · Seattle, WABuilt 2004 · S/N 1120 N95AJAvnuts LLC · Pawleys Island, SCBuilt 1978 · S/N E-1254 N95ARPfaff Ben J · Bend, ORBuilt 1962 · S/N 500A-1270-93 N95BHSale Reported · Lacombe, LASale reported, canceledBuilt 1975 · S/N TJ-29 N95CFUes Bluesky Aviation LLC · New Berlin, WIBuilt 1988 · S/N CE-1291 N95DBBlankenbeker Edward D · Fernandina Beach, FLBuilt 1979 · S/N D-10239 N95DMValley Gabriel P · Holden, MES/N 18504319 N95DPNorthwest Aviation Inc · Oklahoma City, OKBuilt 1978 · S/N TE-1149 N95EERjt&E LLC · Spring, TXBuilt 2004 · S/N 42036 N95GMMeinig High Club LLC · Klamath Falls, ORBuilt 1980 · S/N 421C0821 N95JRKaiser Dennis · Portland, MEBuilt 1980 · S/N 18504074 N95KCTailwinds Flying LLC · Merritt Island, FLS/N TE-203 N95KMAerial Logistics LLC Trustee · Lakeland, FLBuilt 1981 · S/N TH-1315 N95MTTs Ibex Ltd · Bonners Ferry, IDBuilt 2005 · S/N 71 N95PJMoghimi Gholamali · Monroe, LABuilt 1980 · S/N TH-1162 N95PNM&B Aviation Services LLC · Wilmington, DEBuilt 1972 · S/N TH-282 N95PPElbow Joint Aviation LLC · Brunswick, GABuilt 2014 · S/N TH-2395 N95PRRogers Mark E · Livingston, TXBuilt 2007 · S/N E-3762 N95PYJayviation Inc · Lake City, FLBuilt 1964 · S/N 21058514 N95RRKentucky Oil And Refining Co · Betsy Layne, KYBuilt 1974 · S/N E-541 N95TFSage Mgmt LLC · Carefree, AZBuilt 1981 · S/N U20606137 N95TYFirst Light Aviation Services LLC · Middletown, DEBuilt 1979 · S/N 310R1678 N95VPVarsity Produce Sales Inc · Bakersfield, CABuilt 1980 · S/N EA-114 N95WDBurleson Gary L · Myrtle Beach, SCBuilt 1971 · S/N CE-322 N95WHPage William R · Bermuda Dunes, CABuilt 1978 · S/N TK-86 N95ZGGulfshore Leasing And Services Inc · North Aurora, ILBuilt 2023 · S/N 120 N9601ETrant David B · Kingsville, TXBuilt 1976 · S/N 76-30826 N9604GRoberts Development Company Inc · Tucson, AZBuilt 1972 · S/N U20601804 N9606ENeighborhood Helping Hands LLC · Mesa, AZBuilt 1976 · S/N 76-30819 N9606GJack Leasing Services Inc · Duchesne, UTBuilt 1974 · S/N 18801556T N9607EBabb Clifford · Kerrville, TXBuilt 1978 · S/N 78-30869 N9607YIsn Aviation LLC · Loup City, NEBuilt 1981 · S/N 21064559 N9608GCopper River Airmotive LLC · Copper Center, AKBuilt 1972 · S/N U20601808 N960AGLane Jason R · Tuttle, OKBuilt 1967 · S/N D-8538 N960BPCavu Enterprises LLC · Atlanta, GABuilt 2004 · S/N 1110 N960CM960 Charlie Mike LLC · Santa Rosa, CABuilt 2001 · S/N 0041 N960DFAir Services International Leasing LLC · Fort Lauderdale, FLBuilt 1979 · S/N 414A0444 N960EMCowboy Up Aviation LLC · Fort Worth, TXBuilt 1974 · S/N 421B0881 N960PDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N 0426 N9610ERegistration Pending · Cashion, OKRegistration pending, canceledBuilt 1977 · S/N 77-30856 N9610GChoice Aviation LLC · Hamilton, MTBuilt 1972 · S/N U20601810 N9612EUzochi Inc DBA · Santa Fe, NMBuilt 1975 · S/N 75-30768 N9612RBearnose II LLC · Edina, MNBuilt 1985 · S/N U20606901 N9613EWooding Jeremiah L · Arlington, TXBuilt 1978 · S/N 78-30884 N9613GDavid W Easter Consulting Inc · Libby, MTBuilt 1972 · S/N U20601813

Back to AD 86-13-04 R3