Skip to content

Registered aircraft · 5,439

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.

N111PTpr Aviation LLC · Evergreen, COBuilt 1998 · S/N 1334 N111PDN111pd LLC · Wilmington, NCBuilt 1978 · S/N TC-2176 N111PJG&L Aviation Services LLC · Las Vegas, NVBuilt 1981 · S/N 340A1234 N111PQTriple Nickel Inc · Muleshoe, TXBuilt 1972 · S/N TC1427 N111QMTop Hand Inc · Laurel, MTBuilt 1966 · S/N TE-196 N111RBClear Skies LLC · Allentown, PABuilt 1978 · S/N 340A0545 N111RVRawson Keith L · Red Oak, TXBuilt 1966 · S/N TE-292 N111TXVirginia Air LLC · Wilmington, NCBuilt 1962 · S/N TC-283 N111USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1114 N111VMSkyline Aeronautical Services LLC · Dorado, PRBuilt 1977 · S/N TC-2081 N111WDSmith Toby D · Cresson, TXBuilt 1978 · S/N TC-2126 N111YVUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N UC-111 N111ZMAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5983 N112ACJones Michael · Freeport, TXBuilt 1964 · S/N TC-681 N112ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5991 N112DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10085 N112HBenschoter Cameron · Bonifay, FLS/N TC-722 N112MFMummy Mountain Med LLC · Paradise Valley, AZBuilt 1966 · S/N LP-37 N112USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1134 N112YVUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N UC112 N113ABSafford Aviation Service Inc · Coolidge, AZBuilt 1973 · S/N TC-1622 N113ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6020 N113AXAlaska Central Express Inc · Anchorage, AKBuilt 1988 · S/N UC-41 N113DXDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10100 N114AXAlpine Aviation Inc · Provo, UTBuilt 1988 · S/N UC-36 N114DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10122 N114FMoore Joe L · Cortez, COBuilt 1962 · S/N TC-347 N114KSUSA Up Star Air Charters LLC - S Series B · Greenwood, INBuilt 1987 · S/N 1012 N114RYoung John R · Rockland, MABuilt 1961 · S/N TE-120 N114UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1148 N1159TNxtday Aire LLC · Dover, DEBuilt 1974 · S/N TC-1784 N115AXAlaska Central Express Inc · Anchorage, AKBuilt 1988 · S/N UC-2 N115BHBighorn Airways Inc · Sheridan, WYBuilt 1982 · S/N 340A1531 N115DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10132 N115EATso Aviation LLC · Conway, ARBuilt 1978 · S/N 340A0484 N115NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6063 N115PACentral Virginia Aviation Inc · North Dinwiddie, VAS/N LJ-117 N1164WBeaver Brook Aviation LLC · Scotia, NYBuilt 1967 · S/N TE-400 N116ANUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6070 N116DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10121 N116EALewistown Aviation Inc · Lewistown, PABuilt 1979 · S/N 340A0750 N116HRegistration Pending · Kalispell, MTRegistration pendingBuilt 1964 · S/N TC-812 N116LLeavitt Mike · Kamas, UTBuilt 1964 · S/N TC-780 N117AGRegistered aircraftN-number assigned, not yet registeredS/N LP-20 N117ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6094 N117AXAlaska Central Express Inc · Anchorage, AKBuilt 1989 · S/N UC-79 N117DXDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10133 N117EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-114 N117FLKinley Air LLC · Wilmington, DEBuilt 1979 · S/N TC-2226 N117JASorbi Aviation Inc · El Cajon, CABuilt 1980 · S/N ME-282

Back to AD 95-26-15 R1