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.

N248JBRiverode Sales Inc · Pontiac, ILBuilt 1978 · S/N TC-2124N248MHatton Wesley · Murrieta, CABuilt 1964 · S/N TC-558N248NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7781N249AXTailwind Investments LLC · Anchorage, AKBuilt 1991 · S/N UC-160N249BABoeing Aircraft Holding Co · Seattle, WAS/N 24309N249FEFederal Express Corporation · Memphis, TNBuilt 2025 · S/N 67544N249NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7766N249TJF Korbel & Bros · Guerneville, CABuilt 1966 · S/N TE-249N24AKLund Kristoffer B · Encinitas, CABuilt 1968 · S/N TC-1150N24CFAmerica Aviation LLC · Yuma, AZBuilt 1979 · S/N 340A0659N24GHWilliams Mitchell L · Chickasha, OKBuilt 1963 · S/N TC-404N24GMFive X Five Flight Inc · The Woodlands, TXBuilt 1981 · S/N ME-395N24MAMarsh Glen R · Williamson, GABuilt 1972 · S/N TC-1435N250FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67543N250KCFlight 444 LLC · Atlanta, GABuilt 1987 · S/N 1025N250NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7743N250RGAviation Co Inc · Cheyenne, WYBuilt 1986 · S/N 1003N251FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67542N251NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7838N252FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67541N252NJAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 252N252NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7868N252SLone Peak Air LLC · Gillette, WYBuilt 1980 · S/N 340A0984N253ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3690N253AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-253N253FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67540N253GCAerway Capital Management LLC · Waterford, WIS/N 25303N253GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-253N253NVAllegiant Air LLC · Las Vegas, NVBuilt 2017 · S/N 7900N253SFAlpine Aviation Inc · Provo, UTBuilt 1989 · S/N UC53N254CAMmap LLC · Houston, TXBuilt 1987 · S/N 1054N254DAlwin Brandon · Laredo, TXBuilt 1962 · S/N TC-339N254FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67539N254NVAllegiant Air LLC · Las Vegas, NVBuilt 2017 · S/N 7913N254PBNicole Business Group LLC · Hooks, TXBuilt 1982 · S/N 340A1504N255BABgp Realty Inc · Boca Raton, FLBuilt 1967 · S/N TE-364N255CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 22316N255EM255em LLC · Tampa, FLBuilt 1973 · S/N TC-1552N255FEFederal Express Corporation · Memphis, TNBuilt 2024 · S/N 67538N255FSSharpline Converting Inc · Wichita, KSBuilt 1980 · S/N TC-2306N255GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-255N255KBailey Michael S · Sarasota, FLBuilt 1961 · S/N TC-74N255MAKmco Inc · Lenexa, KSBuilt 1967 · S/N TE-318N255NVAllegiant Air LLC · Las Vegas, NVBuilt 2017 · S/N 7989N255RWas Group LLC · Wilmington, DEBuilt 1973 · S/N TC-1518N255WPUnited States Air Force Owner · Hanscom Afb, MAFirst renewal noticeS/N TF-38N255XMS-Tee Corp · Mineri Wells, TXBuilt 1966 · S/N TE-263N25631Myers Robert G · Monument, COBuilt 1973 · S/N TC-1523N25659Greenery LLC · Wilmington, DEBuilt 1973 · S/N TC-1596N25676Ciabattoni David E · Wallingford, PABuilt 1973 · S/N TC-1597
Back to AD 95-26-15 R1