OpenAirDocs.org
AD 95-26-15 R1

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
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.

N913FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 250N913JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5909N913UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67982N913USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6255N914FXFederal Express Corp · Memphis, TNBuilt 1992 · S/N 293N914UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67983N914UYAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6337N915Ramsey Brent C · Tulsa, OKBuilt 1980 · S/N 340A0910N915FDFederal Express Corp · Memphis, TNBuilt 1988 · S/N 24120N915FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 269N915UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 67984N915USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6387N915VThomas Robert W · Henderson, NVFirst renewal noticeBuilt 1974 · S/N TC-1785N915WVSmith Aviation LLC · Springer, OKBuilt 1959 · S/N TD-236N9164NDangberg Dennis · Wayne, NEBuilt 1964 · S/N TC-574N916FXFederal Express Corp · Memphis, TNBuilt 1992 · S/N 314N916MTSchumacher Charles · Cambridge, MABuilt 1973 · S/N TC-1623N916UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 67985N916USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6420N917FXFederal Express Corp · Memphis, TNBuilt 1993 · S/N 354N917KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 46917N917MS917ms LLC · Longwood, FLBuilt 1994 · S/N 1241N917UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68363N917UYAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6427N917WMetro Helicopter LLC · Los Angeles, CABuilt 1991 · S/N 1158N9181QWhitfield Timothy D · Fairfield, NCBuilt 1970 · S/N TC-1381N918FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 262N918MRMarc Aircraft Holding LLC · Soldotna, AKS/N LM-138N918SCCharlie November One LLC · Sheridan, WYBuilt 1988 · S/N 1075N918UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68364N918USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6443N919CAAc Spe 2 LLC · Orlando, FLBuilt 1991 · S/N 25302N919FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 266N919UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68365N919USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6479N919YFlow Pro Products Inc · Romeoville, ILS/N TC-408N91EWToussaint David F · Lakeville, MNS/N WA-30N91JSReserve Aircrafts LLC · New York, NYBuilt 2002 · S/N 1485N91SDynamic Avlease Inc · Bridgewater, VABuilt 1972 · S/N LU-15N920FXFederal Express Corp · Memphis, TNBuilt 1992 · S/N 325N920UPBoeing Co · Renton, WABuilt 2026 · S/N 68366N920USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6490N9218Omega Air Inc · Selma, TXS/N 48218N921FXFederal Express Corp · Memphis, TNBuilt 1992 · S/N 319N921KARay Aviation LLC · Carmel, INBuilt 1984 · S/N 340A1803N921UPBoeing Co · Renton, WABuilt 2026 · S/N 68367N921USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6523N922BVander Linden Tom · Fairfield, IABuilt 1966 · S/N TC-994N922QDragonlady Barron LLC · Gardnerville, NVBuilt 1961 · S/N TC-202N922RPink Ibis Air LLC · Vero Beach, FLS/N TE-273
Back to AD 95-26-15 R1