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.

N946AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4924 N946FDFederal Express Corp · Memphis, TNS/N 24398 N946JLJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6425 N9478QWwpc Aviation LLC · Stanley, VABuilt 1972 · S/N TC1431 N947FDFederal Express Corp · Memphis, TNS/N 24882 N947JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6448 N9486YRobbins Donald Lee Jr DBA · Ruston, LABuilt 1961 · S/N TC-49 N9487YSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1961 · S/N TC-50 N9489SRoccatani Dante D · Merritt Island, FLBuilt 1966 · S/N TE-79 N948AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4933 N948FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25059 N948JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6560 N9494SLowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1966 · S/N TC-985 N9497YGreystone Enterprises Inc · Oklahoma City, OKBuilt 1961 · S/N TC-57 N949FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25060 N949JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6575 N94NDynamic Avlease Inc · Bridgewater, VAS/N LU-04 N94SDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1971 · S/N LM-133 N950AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 3545 N950FDFederal Express Corp · Memphis, TNBuilt 1994 · S/N 25806 N950JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6609 N9516YRanz Mark K · Seattle, WABuilt 1962 · S/N TC-334 N951AMRowan Edward L · Wellington, FLBuilt 1975 · S/N TC 1884 N951AVWilmington Trust Company Trustee · Wilmington, DEBuilt 2008 · S/N 3574 N951BCJah2022a Saab340b Msn 318 LLC · Dallas, TXBuilt 1992 · S/N 340B-318 N951FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28665 N952CAAc Spe 3 LLC · Orlando, FLBuilt 1991 · S/N 25238 N952FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28666 N952JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6663 N953DMMainline Services Co · Wilmington, DEBuilt 1976 · S/N 340A0205 N953FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28667 N953JMAlta Airlines Holdings LLC · Salt Lake City, UTS/N 25151 N9540YRobert Enrique Guerrero De Jesus · Sparta, NJS/N TC-344 N9546QNasair Aviation Services LLC · West Long Branch, NJBuilt 1966 · S/N LC-231 N9549YBiederman Clifton E · Jasper, FLBuilt 1962 · S/N TC-348 N954AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 3699 N954FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 29113 N954JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6725 N954LEBering Air Inc · Nome, AKBuilt 1993 · S/N UE-72 N9555BStern Aviation Inc · N Fort Myers, FLBuilt 1981 · S/N TC-2405 N9555YRegistered aircraftBuilt 1973 · S/N TC-1577 N955AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 3835 N955BESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N TC-1272 N955CAJa Flight Services LLC · Sugar Grove, ILBuilt 1979 · S/N TC-2264 N955DBWeyant Steven R · Bonney Lake, WABuilt 1978 · S/N TC-2195 N955DJGray John Michael · Saint Petersburg, FLBuilt 1967 · S/N TE-300 N955FDFederal Express Corp · Memphis, TNBuilt 1998 · S/N 29114 N955JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6757 N955MBHms Air LLC · Van Nuys, CABuilt 1987 · S/N 1022 N955RHFrenzel Aviation Investments LLC · Brentwood, TNBuilt 1977 · S/N TC-2095

Back to AD 95-26-15 R1