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.

N234PSTkn Holdings LLC · Pima, AZBuilt 1977 · S/N 340A0368N234RBMoyer Thomas L · Fayetteville, GABuilt 1976 · S/N TC-1950N23573Rolrice Family Limited Partnership · Tulsa, OKBuilt 1977 · S/N TC-2107N235FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7272N235NVSunrise Asset Management LLC · Las Vegas, NVS/N 1130N235SWBerry Aviation Inc · San Marcos, TXS/N 120310N235ULAircraft Endeavors LLC · San Antonio, TXBuilt 1976 · S/N 46956N23614Great American Jet Inc · Cincinnati, OHBuilt 1978 · S/N TC-2153N2367PCrowley Steven J · Burlington, IABuilt 1981 · S/N TC-2367N236CACypress Cove Air LLC · Phoenix, AZBuilt 1992 · S/N 1202N236FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7389N236JEGunnels Farms Inc · Amarillo, TXS/N TC-2092N237CMCargo Aircraft Management Inc · Wilmington, OHS/N 25584N238FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7458N238NVUmb Bank Na Trustee · Salt Lake City, UTS/N 2133N239AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27450N239DGTabares Alain · Zephyrhills, FLBuilt 1968 · S/N TC-1187N239NVUmb Bank N A Trustee · Salt Lake City, UTS/N 2144N23ECDenver Aero Service Marine Inc · Wilmington, DEBuilt 1975 · S/N TC-1894N23MFTriay Services LLC · Metairie, LABuilt 1974 · S/N TC-1684N2402ALaurelton Village Inc · Alamance, NCS/N TC-1931N24089Ploutz Lloyd · Modesto, CAS/N 20455N240GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-240N241AXTailwind Investments LLC · Anchorage, AKBuilt 1988 · S/N UC-24N241AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27451N242AXTailwind Investments LLC · Anchorage, AKBuilt 1989 · S/N UC-72N242GDodson International Parts Inc · Rantoul, KSS/N 340A0799N242KABig River Air LLC · Jackson, MSBuilt 1983 · S/N 340A1802N244AXTailwind Investments LLC · Anchorage, AKBuilt 1989 · S/N UC-78N244FEFederal Express Corp · Memphis, TNBuilt 2026 · S/N 67549N245AXTailwind Investments LLC · Anchorage, AKBuilt 1989 · S/N UC-83N245FEFederal Express Corp · Memphis, TNBuilt 2026 · S/N 67548N245GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-245N245NVSunrise Asset Management LLC · Las Vegas, NVS/N 1550N246ASUas Transervices Inc · Boca Raton, FLBuilt 1988 · S/N 120.100N246AXTailwind Investments LLC · Anchorage, AKBuilt 1990 · S/N UC-114N246FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67547N246JWPierson Janice R Trustee · Scio, ORBuilt 1981 · S/N 340A1253N246KAStahl Richard J · Gainesville, TXBuilt 1984 · S/N 340A1817N246NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7664N247AXTailwind Investments LLC · Anchorage, AKBuilt 1990 · S/N UC-136N247CSTeam Aero LLC · Shawnee, KSBuilt 1994 · S/N 465-27N247FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67546N247GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-247N247GNTommy Hanka Farms LLC · Mission, TXBuilt 1968 · S/N TC-1119N247LMLive Mas Enterprises LLC · Greenwood Village, COBuilt 1994 · S/N 1258N247NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7704N248AXTailwind Investments LLC · Anchorage, AKBuilt 1991 · S/N UC-154N248DDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1966 · S/N TE-171N248FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67545
Back to AD 95-26-15 R1