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.

N930UPBoeing Co · Renton, WAS/N 70805N931AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7541N931BCBank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 340B-187N931EJetco Leasing · Salinas, CABuilt 1966 · S/N TC-1009N931RDMorgan Gabriel A Sr · Newport News, VAFirst renewal noticeBuilt 1963 · S/N TC-436N931UPBoeing Co · Renton, WAS/N 70806N931VBaker Matthew T · Shipman, ILBuilt 1974 · S/N TC-1764N9320QT-Wing Aviation LLC · Pompton Plains, NJBuilt 1971 · S/N TC-1413N932AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7419N932UPBoeing Co · Renton, WAS/N 70807N933AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7564N933UPBoeing Co · Renton, WAS/N 70808N9340QH O C Investments LLC · Garden City, KSBuilt 1971 · S/N TC-1412N934AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7500N934JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6130N934ZBAnduze Helicopter LLC · Royal Palm Beach, FLS/N TE-314N935JBJet Blue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6185N935RWelcome Grove LLC · West Sacramento, CABuilt 2000 · S/N 1405N936AM936am LLC · Mount Pleasant, SCBuilt 2002 · S/N 1488N936CAAc Spe 8 LLC · Orlando, FLBuilt 1991 · S/N 25308N936JBHunt Air LLC · Anderson, SCBuilt 1977 · S/N 340A0263N936JLConcrete Structures LLC · Jupiter, FLBuilt 1980 · S/N 465-43N9377YReiland Andrew W · Boaz, ALBuilt 1960 · S/N TC-5N937JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6245N937VNabarrette Angel · Odessa, TXBuilt 1975 · S/N TC-1879N938QBowers Enterprises LLC · Peachtree City, GABuilt 1961 · S/N TC-184N938VParlin Troy W · Wills Point, TXBuilt 1975 · S/N TC-1835N939AVAircol 24 · Wilmington, DEBuilt 2011 · S/N 4939N939PGUrnxtjet LLC · Deland, FLBuilt 1993 · S/N 1212N93JDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1970 · S/N LM-128N93TSky Masters Inc · Bonner Springs, KSS/N TC-1051N93VDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LU-03N940FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24772N9415SWasson-Ece Instrumentation · Fort Collins, COBuilt 1965 · S/N TE-41N941FDFederal Express Corp · Memphis, TNBuilt 1987 · S/N 22691N941MBUmb Bank Na Trustee · Salt Lake City, UTS/N 0941N9420YPremier One Express LLC · Orlando, FLBuilt 1964 · S/N TC-582N942FDFederal Express Corp · Memphis, TNBuilt 1986 · S/N 22612N942JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6279N9430Cochise College · Douglas, AZBuilt 1968 · S/N TC-1194N9436SShrauner Harry Scott Trustee · Elkhart, KSS/N TE-48N943BCrawford Alan R · Buchanan Dam, TXBuilt 1966 · S/N TE-88N943JTJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6326N943PWRegistered aircraftAssigned, pending cancellationS/N TC-627N944AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4730N944JTJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6359N945AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4733N945BRegistered aircraftBuilt 1974 · S/N TC-1826N945JTJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6390N945XCStratton Ventures LLC · Dover, DES/N 1019
Back to AD 95-26-15 R1