Skip to content

Registered aircraft · 5,440

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:95-26-15-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-15-R1') 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:95-26-15-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-15-R1')
  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:95-26-15-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-15-R1')
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.

N25698Tupelo Aeronautics Inc · Tupelo, MSS/N TC-1603 N256FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67537 N256JD Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N ME-107 N256NVSunrise Asset Managment LLC · Las Vegas, NVBuilt 2018 · S/N 8220 N257ASUas Transervices Inc · Boca Raton, FLBuilt 1989 · S/N 120.126 N257AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1999 · S/N 29605 N257FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67536 N257GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-257 N257NVAllegiant Air LLC · Las Vegas, NVBuilt 2018 · S/N 8329 N258ASUas Transervices Inc · Boca Raton, FLBuilt 1989 · S/N 120.131 N258AWCobra Aviation Services LLC · Oklahoma City, OKBuilt 1996 · S/N UE258 N258ESanogo Fousseni · Houston, TXBuilt 1964 · S/N TC-701 N258FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67535 N258NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4015 N258PChamberlin Charles · Winchester, TNBuilt 1981 · S/N TC-2414 N259FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67534 N259NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4057 N25BMaine Instrument Flight · Augusta, MES/N ME-49 N25EBLeisurecorp Inc · Anchorage, AKBuilt 1976 · S/N 340A0043 N25JRDjair · Winchester, VABuilt 1961 · S/N TC-132 N25RARadz Airways LLC · Solana Beach, CABuilt 1997 · S/N 1310 N25RFMlf Aviation LLC · Douglasville, GABuilt 1973 · S/N 340-0307 N25TAJms Properties Inc · Hudsonville, MIBuilt 1982 · S/N 340A1538 N260FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67533 N260NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4104 N261FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67532 N261GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-261 N261JDMaizenblue Express LLC · Jupiter, FLBuilt 2000 · S/N 1409 N261NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4115 N2625MB-Hive Inc · Augusta, GABuilt 1973 · S/N TC-1586 N262FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67531 N262NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4122 N263CNorpoth Robert L · Circleville, OHS/N LB28 N263FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67530 N263LMVent Airlines Inc · Dover, DEBuilt 1994 · S/N 26603 N263SGAtlas Air Inc · Purchase, NYBuilt 1999 · S/N 29263 N264DEAircraft Endeavors LLC · San Antonio, TXBuilt 1978 · S/N 46985 N264FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66869 N264QChan Hung-Chun · Orem, UTBuilt 1966 · S/N TC-987 N265AAWhitten Chris K · Alton, MOBuilt 1958 · S/N TD-132 N265FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66868 N265FTSunshine Aero Industries Inc · Crestview, FLBuilt 1980 · S/N 465-46 N265JAAviation Inventory Resources Inc · Alvarado, TXS/N 340B-265 N265PCSilver Eagle II LLC · Carson City, NVBuilt 1980 · S/N 340A-0996 N265WSPortside Aero LLC · Edgewater, NJBuilt 1981 · S/N 465-62 N2666DDrda Enterprises LLC · Denver, COS/N 340A0717 N2666JA-Leasing · Dayton, OHS/N 340A0718 N2669NWilliamson Benjamin J · Morgan Hill, CABuilt 1979 · S/N 340A0735 N266AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-266 N266ASTriangle Aviation Rdd LLC · Burbank, CABuilt 1990 · S/N 120.188

Back to AD 95-26-15 R1