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.

N904ARUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 33097 N904TMax Q Aviation LLC · Cocoa Beach, FLBuilt 1974 · S/N TC-1755 N9054SWhiskey Lima Aviation LLC · Duluth, GABuilt 1978 · S/N TC-2160 N9057QCurrier Justin B · Rixeyville, VABuilt 1971 · S/N TC-1366 N9058STeam Training Institute LLC · Atlanta, GABuilt 1978 · S/N TC-2161 N905AUBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7700 N905JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5854 N905LPChateau Aviation LLC · Wilmington, DEBuilt 1997 · S/N 1321 N905NANational Aeronautics And Space Administration · Houston, TXBuilt 1970 · S/N 20107 N906AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7651 N906FXFederal Express Corp · Memphis, TNS/N 280 N906HFCavanaugh Air LLC · Addison, TXBuilt 1971 · S/N LM-140 N906MRMarc Aircraft Holding LLC · Soldotna, AKS/N LM-136 N906RARyan Air Inc · Anchorage, AKS/N 340A-109 N907AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7732 N907FXFederal Express Corp · Memphis, TNBuilt 1992 · S/N 286 N907JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5865 N907RARyan Air Inc · Anchorage, AKBuilt 1987 · S/N 340A-111 N908AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7775 N908CKNew Tex Capital LLC · Plains, TXBuilt 1978 · S/N 340A0445 N908JTValiair Lc Trustee · Casper, WYBuilt 1990 · S/N 1145 N909AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7756 N909DCTwin Piston Aviation LLC · Salisbury, NCBuilt 1980 · S/N 340A0998 N909FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 275 N909TBCrawford Greg · Humnoke, ARBuilt 1971 · S/N TC-1387 N90DDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1970 · S/N LU-10 N90DMDel Martin Lp · Spring, TXBuilt 1972 · S/N 340-0048 N90FAFox Valley Technical College · Appleton, WIBuilt 1966 · S/N LJ-133 N90RGRobtoria Aircraft Leasing LLC · Wilmington, DEBuilt 2000 · S/N 1410 N90VLBank Of Utah Trustee · Salt Lake City, UTS/N 39091 N91011Orbital Sciences LLC · Mojave, CAS/N 1241 N91053Garvin Lee E · Brookings, ORS/N 340A1039 N910AFAfh Aviation LLC · Mineola, NYBuilt 1997 · S/N 1312 N910AUWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7876 N910FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25054 N910FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 277 N910TN910t LLC · Newark, OHBuilt 1970 · S/N TC-1361 N910UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67980 N9119QPrestige Worldwide Aviation LLC · Kalispell, MTBuilt 1970 · S/N TC-1375 N911PYOrchtrans Inc Trustee · Wilmington, DEBuilt 1960 · S/N LF-21 N911UT9sixteen Motorsports · Lusby, MDS/N TC-928 N911YDoggett Jack E Jr · Kingwood, TXBuilt 1959 · S/N TD-182 N9122SMercer Warren G · Bogart, GABuilt 1976 · S/N TC-1939 N912DFSmith Doyle Cecil · Prattville, ALS/N TC-177 N912FXFederal Express Corp · Memphis, TNBuilt 1987 · S/N 047 N912HCivil Aviation Group LLC · Ada, OKBuilt 1966 · S/N TE-143 N912UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67981 N912UYAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6264 N912WTNew Tech Construction LLC · Wilmington, DEBuilt 1977 · S/N 340A0353 N913DECorsair Two LLC · Hillsboro, ORBuilt 1993 · S/N 49956

Back to AD 95-26-15 R1