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.

N694NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8632N69506Satko Frank G · Chesapeake, VABuilt 1974 · S/N 340-0343N69522Kpk Enterprises Inc · Pasadena, CABuilt 1974 · S/N 340-0354N69542Dirty Side Down LLC · Hobbs, NMBuilt 1974 · S/N 340-0362N69555Obanion John William · Powder Springs, GABuilt 1974 · S/N 340-0370N695ATL And P Air 2 LLC · Lees Summit, MOBuilt 1974 · S/N 340-0344N695DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29727N696ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 26976N696DLDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29728N696NKSpirit Airlines LLC · Dania Beach, FLBuilt 2019 · S/N 8824N697ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 26977N697DLDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30318N697USAlanis Armando Jr · Mcallen, TXBuilt 1980 · S/N 465-49N698ACRaging Thermal Sky Sports LLC · Brighton, COS/N TC-1304N698DLDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29911N699DLDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29970N69FPPatten Air LLC · Fort Lauderdale, FLBuilt 1991 · S/N 1180N69PGBaird Mark · Fort Jones, CABuilt 1972 · S/N 340-0062N69RLindstrom Troy D · Las Vegas, NVFirst renewal noticeBuilt 1972 · S/N TC-1438N69YMCaraway Michael · Saint Anne, ILBuilt 1962 · S/N TC-315N6AQNyerges James · Midland, TXBuilt 1964 · S/N LD-214N6KBrewer Aviation LLC · West Fork, ARBuilt 1969 · S/N TC-1254N6KZDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N LJ-238N6MKSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 340-0322N6QKRobb Jeffery A · Hebron, OHBuilt 1982 · S/N WA-306N6TXPrillinger Richard J · Redwood City, CABuilt 1973 · S/N TC-1598N6WFAxis Equipment LLC · Fuquay Varina, NCBuilt 1964 · S/N TC-794N7000BBeechcraft Heritage Museum Inc · Tullahoma, TNS/N LM-01N7007GDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-02N70088School Of Missionary Aviation Technology · Ionia, MIS/N LM-06N700AVYates Melvin Jones · Duck River, TNBuilt 1973 · S/N TC-1519N700DKFlysix Oregon LLC · Salem, ORBuilt 1980 · S/N 340A1038N700DNJohnson Bruce W · Portland, ORBuilt 1965 · S/N TC-967N700FJBizav Aircraft Management LLC · Fort Lauderdale, FLBuilt 1999 · S/N 1400N700JCSalameh Aviation LLC · Bethlehem, PABuilt 1981 · S/N 465-74N700KWEastern Airlines LLC · Kansas City, MOBuilt 1992 · S/N 25443N700MWSome Beech LLC · Bolivar, MOBuilt 1978 · S/N ME-134N700NYFour M Aviation LLC · White Plains, NYBuilt 2004 · S/N 1526N700SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 1471N7010LDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-07N7014LDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-10N7018FDynamic Aviation Group Inc · Bridgewater, VAS/N LM-13N7019KAmazon.Com Services LLC · Seattle, WAS/N 1359N701DBKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1987 · S/N 1036N701FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 1680N701FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6793N701FWDodson International Parts Inc · Rantoul, KSFirst renewal noticeS/N 465-21N701MEGofly Trading LLC · Opa Locka, FLBuilt 1968 · S/N TC-1159N7022GSamarth Aviation LLC · Yuma, AZBuilt 1979 · S/N 340A0695N70283J And D Petroleum Co · Tallahassee, FLBuilt 1965 · S/N TF45
Back to AD 95-26-15 R1