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.

N3198WRobert And Donna Odegaard Family Lllp II · Kindred, NDBuilt 1974 · S/N TC-1647 N3199WCoastal Sky Partners LLC · Wilmington, DEBuilt 1974 · S/N TC-1648 N319CMCargo Aircraft Management Inc · Wilmington, OHS/N 24407 N319DNDelta Air Lines Inc · Atlanta, GAFirst renewal noticeBuilt 2017 · S/N 7479 N319USDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 208 N31GVAircraft Fidelity Corp Trustee · Dover, DEBuilt 1988 · S/N 1084 N31TNLake Clark Air Inc · Port Alsworth, AKBuilt 1969 · S/N U49 N31YBritton Stephen D · Delhi, LABuilt 1957 · S/N TD-41 N320AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-320 N320DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7546 N320RMRd Harrison Inc · Lexington, NCS/N 340A0939 N321AVCsds Asset Management LLC · Marana, AZS/N 2234 N321CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29431 N321DHUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7592 N321RPIsrael Oscar M III · Sinton, TXBuilt 1973 · S/N 340-0201 N321USDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 262 N3221CBank Of Utah Trustee · Salt Lake City, UTS/N 852 N322DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7707 N322SGAtlas Air Inc · Purchase, NYBuilt 2000 · S/N 30322 N323AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-323 N323CMBank Of Utah Trustee · Salt Lake City, UTS/N 29881 N323DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7672 N3240YMeadowlake Airpark LLC · Lenoir City, TNS/N TC2322 N324DXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7765 N324FPWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N 1475 N324SAAtlantic Air Services 71991 Inc · Largo, MDBuilt 1989 · S/N UC-94 N325DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7709 N325RRCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1967 · S/N LJ-289 N325SRFingerhut Steven · Cross Plains, TXBuilt 1966 · S/N TE-65 N325USDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 281 N326CAAlpine Aviation Inc · Provo, UTBuilt 1970 · S/N U-135 N326DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7845 N326TRTrans Executive Airlines Of Hawaii Inc DBA · Honolulu, HIS/N 20917 N327AGBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 340B-427 N327DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7777 N327TALeblanc Joseph E Jr · Houston, TXBuilt 1984 · S/N 340A1809 N327TLThomas H Lee Capital LLC · Teterboro, NJBuilt 1998 · S/N 1339 N328DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7840 N328NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 298 N329AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-329 N329DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7885 N329GAGulfstream Aerospace Corp · Savannah, GABuilt 1998 · S/N 1329 N329GBN329gb LLC · Chattanooga, TNBuilt 1978 · S/N ME-45 N329NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 306 N329ZAKalitta Air LLC · Ypsilanti, MIBuilt 2003 · S/N 32914 N32JEKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2001 · S/N 1460 N32PDynamic Avlease Inc · Bridgewater, VABuilt 1966 · S/N LM-31 N32VSpeer Aviation LLC · Evansville, INBuilt 1977 · S/N 340A0250 N32VSCraftline LLC · Delray Beach, FLS/N 340-0025 N330AFUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N UB-38

Back to AD 95-26-15 R1