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.

N266FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66867N266GSchroeder Robert J · Kaukauna, WIBuilt 1966 · S/N TE-205N2673DAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 340A0755N2676BKero Jet Corporation · Montgomery, TXBuilt 1979 · S/N 340A0762N2676RStauter Michael D · Idabel, OKBuilt 1979 · S/N 340A0765N267FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66866N267JRKnight Sky II LLC · Miami, FLBuilt 1986 · S/N 23402N267PDWhite Hat Repair LLC · Greenleaf, IDBuilt 1967 · S/N TE-284N268FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66865N268SAInarayan Inc · Winter Park, FLBuilt 1963 · S/N TC-554N268VTAvire LLC · West Hollywood, CABuilt 1993 · S/N 1220N2696HSunwest Aviation Inc · Santa Ynez, CAFirst renewal noticeBuilt 1979 · S/N 340A0778N2696PBlue Wing Aviation LLC · Tulsa, OKBuilt 1979 · S/N 340A0779N2696UBlack Dragon Consulting LLC · Phoenix, AZS/N 340A0780N2699DN2699d Corp Trustee · Wilmington, DEBuilt 1979 · S/N 340A0787N269CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 25586N269FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66864N269PCSch Aviation Inc Trustee · SporleBuilt 1979 · S/N 340A0785N269TUAero Quest LLC · Olive Branch, MSS/N ME-95N269WTWillis James A · South Jordan, UTBuilt 1972 · S/N 340-0104N26CMLaurel Highlands Aeronautical Academy · Latrobe, PABuilt 1958 · S/N TD-119N26DEContinental Title Trust LLC Trustee · Wichita, KSBuilt 1974 · S/N TC-1796N26DJGulfstream IV-Sp Msn 1206 N26dj LLC · Wilmington, DEBuilt 1992 · S/N 1206N26LMClassic Aviation Inc · Pella, IABuilt 1979 · S/N ME-177N26RZUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N UC-134N2700R-Plane Inc · Wilmington, DEBuilt 1979 · S/N 465-7N2700YEaton Air LLC · Spearfish, SDS/N 340A0793N27015United Airlines Inc · Chicago, ILBuilt 2000 · S/N 28678N2702VAtx Aero LLC · Austin, TXBuilt 1979 · S/N 340A0904N2703TChapman Daniel W · Soldotna, AKS/N TE-342N270ACAlaska Central Express Inc · Anchorage, AKBuilt 1991 · S/N UC-174N270FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66249N270MNardi Greg P · Missoula, MTBuilt 1967 · S/N LJ-288N270SCTrans-Exec Air Service Inc · Van Nuys, CABuilt 1993 · S/N 1229N2710YPink Ibis Air LLC · Vero Beach, FLS/N TD-45N2712TJames Todd E · Lebanon, PAS/N TE-349N2712YCarranza Jorge Oros · Dallas, TXBuilt 1958 · S/N TD-35N2715YEmerson Michael J · Athens, ALBuilt 1958 · S/N TD-62N2717TIberlin James M · Gillette, WYBuilt 1967 · S/N TE-351N271CMCargo Aircraft Management Inc · Wilmington, OHS/N 22319N271FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66250N271NVAllegiant Air LLC · Las Vegas, NVBuilt 2006 · S/N 2932N271SBowker Mark · Bowdoinham, MEBuilt 1974 · S/N TC-1791N271TVJaydak LLC · Tampa, FLBuilt 2004 · S/N 1533N2724TWittenbrader Jeff · Lake Ariel, PABuilt 1967 · S/N TE-354N2726YOlson Ben A · Gig Harbor, WABuilt 1957 · S/N TD-76N2727YFreedom Aviation LLC · Dover, DEBuilt 1958 · S/N TD-79N272AYAersale Inc · Coral Gables, FLBuilt 2000 · S/N 0333N272FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66242N272JMAlta 777 LLC · Salt Lake City, UTS/N 27652
Back to AD 95-26-15 R1