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.

N655JDaum Colton A · Scottsbluff, NEBuilt 1968 · S/N TC-1090 N655JBJetblue Airways Corp · Long Island, NYBuilt 2007 · S/N 3072 N655MWMarvin Lumber And Cedar Company · Warroad, MNBuilt 1999 · S/N UE-377 N655NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8376 N655RJBostic Curtis E · Prestonsburg, KYBuilt 1970 · S/N TC-1331 N655UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25393 N656AWU S Bank N A Trustee · Boston, MABuilt 1999 · S/N 1079 N656FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 745 N656GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23017 N656JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3091 N656NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8400 N656UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 25394 N657AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1083 N657FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 748 N657GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23018 N657JBJetblue Airways Corp · Long Island, NYBuilt 2007 · S/N 3119 N657UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27112 N6582Phoenix Aviation LLC · Bonaire, GABuilt 1976 · S/N 340A0125 N658AWWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 1110 N658DLDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24420 N658FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 752 N658JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3150 N658NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6736 N658UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27113 N659Gulf South America Air Transport Inc · Mobile, ALS/N LC72 N659AWUS Bank Na Trustee · Boston, MABuilt 2000 · S/N 1166 N659DLDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24421 N659FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 757 N659GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23140 N659JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3190 N659NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6770 N659UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27114 N65ACCraft Charles Edward · Shepherdstown, WVBuilt 1966 · S/N TE-242 N65BTDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 465-3 N65CSChallans Robert F · Hesston, KSS/N LC-82 N65DBrowndog LLC · Lksid Marblhd, OHBuilt 1972 · S/N 3400092 N65MLBae Systems Technology Solutions & Services Inc · Mojave, CABuilt 1981 · S/N 465-69 N65QAGulf States Air Inc · Bossier City, LAS/N LC-165 N65UDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-87 N65VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1968 · S/N LM-113 N65WROneill Patrick John · Red Wing, MNS/N TC-923 N660AWUS Bank Na Trustee · Boston, MABuilt 2000 · S/N 1234 N660DLDelta Air Lines Inc · Atlanta, GAFirst renewal noticeBuilt 1990 · S/N 24422 N660FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 759 N660MWMarvin Lumber And Cedar Co · Warroad, MNBuilt 1996 · S/N UE-215 N660NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6804 N660UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27115 N661AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1284 N661AZAmazon.Com Services LLC · Seattle, WAS/N 29384 N661DAHalladay Roy · Erie, COBuilt 1964 · S/N TC-807

Back to AD 95-26-15 R1