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.

N783ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30004N783AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 23016N783BWestside Air Inc Renton · Renton, WABuilt 1958 · S/N TD-55N783CKKalitta Air LLC · Ypsilanti, MIBuilt 1990 · S/N 24782N783FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 26678N783HWSpectre Air Capital LLC · Horseshoe Bay, TXS/N 1817N783PTJones Kenneth C · Newark, DEBuilt 1965 · S/N TC-808N783SPKalitta Charters II LLC · Ypsilanti, MIBuilt 1985 · S/N 22611N783UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26950N7841QExigo Capital LLC · Miami Beach, FLBuilt 1973 · S/N 340-0222N7841RMadariaga Gregory M · San Diego, CABuilt 1969 · S/N TC-1202N7845QReading Jared · Uvalde, TXBuilt 1973 · S/N 340-0225N7846RLewis Paul Randell · Eastman, GABuilt 1969 · S/N TC-1205N784ANUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 29588N784FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 26681N784JBJetblue Airways Corp · Long Island City, NYBuilt 2011 · S/N 4578N784UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26951N785ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30005N785FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 26682N785UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26954N7862RUas Transervices Inc · Boca Raton, FLFirst renewal noticeBuilt 1969 · S/N U-85N7869RRegistered aircraftBuilt 1969 · S/N TC-1209N786ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30250N786FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 24995N786UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26938N7870LCnf LLC · Ada, OKBuilt 1967 · S/N TE-336N7873LMcguire David · Sandston, VABuilt 1966 · S/N TC-1018N787ALAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30010N787CKKalitta Air LLC · Ypsilanti, MIBuilt 1997 · S/N 28838N787FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 26685N787GSwirsding David J · Chalfont, PABuilt 1979 · S/N 340A0961N787UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26939N7885CS Tec Corp · Mineral Wells, TXBuilt 1966 · S/N TE-72N788ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30011N788DMSts Aviation LLC · Daytona Beach, FLBuilt 1978 · S/N 340A0461N788FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 26686N788UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26942N789ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30252N789FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26689N789JBJetblue Airways Corp · Long Island, NYBuilt 2011 · S/N 4612N789MD340a1021 Inc Trustee · Wilmington, DEBuilt 1980 · S/N 340A1021N789SCTransport Drive Man LLC · Encino, CAS/N 340-0175N789TNNorth Bristol Partners LLC · Santa Monica, CABuilt 1994 · S/N 1240N78AGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 1362N78DDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-78N78DDKutzner Richard W · Bakersfield, CAFirst renewal noticeBuilt 1961 · S/N TC-208N78ETSteven Brothers Aviation LLC · Wichita, KSBuilt 1993 · S/N 1217N78HMBoufaire LLC · Heathrow, FLBuilt 1979 · S/N TC-2267N78SBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 340-0151N79011United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29859
Back to AD 95-26-15 R1