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.

N173ABae Systems Technology Solutions & Services Inc · Mojave, CABuilt 1980 · S/N 465-20 N173DSanford Mark J · Ithaca, NYBuilt 1964 · S/N TC-825 N173DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29692 N173FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63104 N173UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0868 N173USBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1481 N1743GYoung Harrison · Phoenix, AZBuilt 1962 · S/N TC-278 N174DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24802 N174DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29693 N174FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63105 N174UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0869 N174USBank Of Utah Trustee · Salt Lake City, UTS/N 1492 N17526Preferred Land Solutions LLC · Belden, MSBuilt 1977 · S/N TC-2031 N1757GMatrix Aviation Inc · Ponte Vedra Beach, FLBuilt 1962 · S/N TC-350 N175DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24803 N175DZDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29696 N175FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63106 N175JMKc Aviation Partners LLC · Wilmington, DES/N 28424 N17625Oehler David W · Ponchatoula, LABuilt 1977 · S/N TC-2070 N17626Beaugrenelle Aero Inc · Wilmington, DEBuilt 1977 · S/N TC-2061 N1767WN1767w LLC · Dover, DEBuilt 1972 · S/N TC-1500 N176BCCousins Mark T · Portland, ORS/N ME-269 N176DZDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29697 N176FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63107 N176MGFlying Orchard LLC · Missoula, MTBuilt 2002 · S/N 1501 N176UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1499 N176YVHill Air Executive Inc · Fort Pierce, FLBuilt 1995 · S/N UE-176 N1770GJansen David C · Warm Springs, GABuilt 1962 · S/N TC-294 N17722International Jets Inc · Gig Harbor, WABuilt 1977 · S/N TC-2045 N17726Air Commander LLC · Woodbury, MNBuilt 1977 · S/N TC-2046 N17790Tds Property Holdings LLC · Gilmer, TXBuilt 1977 · S/N TC-2055 N177BBSbg Aircraft Sales And Consulting LLC · Missouri City, TXBuilt 1988 · S/N 1073 N177DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25122 N177DZDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29698 N177FMeek Harvey K · Poplar Grove, ILBuilt 1964 · S/N TC-587 N177FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63108 N177RAUnited States Government · Fort Belvoir, VABuilt 1982 · S/N 85 N177USAmerican Airlines Inc · Fort Worth, TXS/N 1517 N177WWWallace William R · Fredericksburg, TXBuilt 1980 · S/N TC-2295 N178DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25143 N178DZDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30596 N178FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63109 N178JSTidd Scott · Reading, MIBuilt 1981 · S/N WA-230 N178PTPlatinum Aviation LLC · Carson City, NVBuilt 1992 · S/N 1204 N178USAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1519 N178WDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N TC-2096 N178YVAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-178 N179CAUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N 120.179 N179DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25144 N179FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63110

Back to AD 95-26-15 R1