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.

N98747American Skyways Inc · Corning, NYBuilt 1976 · S/N 340A0065N987AMAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7079N987FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28483N987JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7855N988ALAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7154N988DMHart Paul E · El Macero, CABuilt 1981 · S/N 340A1244N988FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26705N988JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7956N989AFBank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 340B-171N989AUAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7307N989CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2002 · S/N 1807N989FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28480N989JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7924N98LT98lt LLC · Austin, TXBuilt 1995 · S/N 1278N98MMSrt Group Inc · Southaven, MSBuilt 1979 · S/N 340A0639N98PA5g Wings LLC · Montgomery, TXBuilt 1960 · S/N TC-18N98RCPegasus LLC · Farmington, NMBuilt 1973 · S/N 340-0187N98SGHamilton Ken · Murfreesboro, TNBuilt 1979 · S/N TC-2249N990AUAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7336N990AVBank Of Utah Trustee · Salt Lake City, UTBuilt 1988 · S/N 099N990BHBig Horn Airways Inc · Sheridan, WYBuilt 1991 · S/N 265N990CMCargo Aircraft Management Inc · Wilmington, OHS/N 1848N990DLCorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53342N990FDFederal Express Corp · Memphis, TNBuilt 1986 · S/N 22909N990JBMurphy George E · Robinson, ILBuilt 1977 · S/N 340A0370N990JLJetblue Airways Corporation · Long Island City, NYBuilt 2017 · S/N 7993N990JMCounty Of Galveston · Dickinson, TXBuilt 1966 · S/N LM-17N990KLaybourn Daniel P · Cheyenne, WYBuilt 1965 · S/N TC-919N991ABSand Benjamin P · Koloa, HIBuilt 1980 · S/N WA-79N991AUAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7131N991BHBig Horn Airways Inc · Sheridan, WYBuilt 1992 · S/N 324N991CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2002 · S/N 1675N991DVance William F · Belgrade, MTBuilt 1966 · S/N TE-222N991FDFederal Express Corp · Memphis, TNBuilt 1986 · S/N 22911N991FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 1958 · S/N 508N991JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7994N9925TFly Bravo LLC · Jasper, TXBuilt 1966 · S/N TE-224N9928FWatermaster Irrigation Supply Inc · Lubbock, TXBuilt 1972 · S/N 340-0165N992AUUmb Bank N A Trustee · Salt Lake City, UTBuilt 2016 · S/N 7157N992AVAircol 7 Trust · Wilmington, DEBuilt 2009 · S/N 3992N992BHBig Horn Airways Inc · Sheridan, WYBuilt 1991 · S/N 258N992FDFederal Express Corp · Memphis, TNBuilt 1986 · S/N 22912N992JBJetblue Airways Corp · Long Island City, NYBuilt 2018 · S/N 8178N993ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7188N993ARBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 0993N993JEJetblue Airways Corp · Long Island City, NYBuilt 2018 · S/N 8143N9940FHarvey Air LLC · Arlington, TNBuilt 1972 · S/N 340-0173N994ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7407N994DLArctic One LLC · Fairbanks, AKS/N 53346N994JLJetblue Airways Corp · Long Island City, NYBuilt 2018 · S/N 8185
Back to AD 95-26-15 R1