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.

N18941N18941 LLC · Boynton Beach, FLBuilt 1978 · S/N ME-8N1894EDelvest LLC · Grosse Pointe, MIBuilt 1979 · S/N 340A0662N1897LHrt Aviation LLC · Southlake, TXBuilt 1976 · S/N TC-1971N189ANWyatt Aerospace LLC · Chandler, AZBuilt 2001 · S/N 32383N189CAUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N 120.189N189DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 25990N189FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 63120N189NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5687N189UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1425N189WAAmeriflight LLC · Dallas, TXBuilt 1969 · S/N U-76N18JHGarnet Aerospace LLC · Windsor, COBuilt 1963 · S/N TC-495N18MRMorey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 340A0557N18TVJax G Enterprises LLC · Scottsdale, AZS/N 1315N1902DBoeing Co · Berkeley, MOBuilt 1998 · S/N UE327N1902STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 26244N1902UUnited Airlines Inc · Chicago, ILBuilt 2006 · S/N 2714N1905ERusso Louis A Jr · Houston, TXBuilt 1979 · S/N 340A0664N190AAWyatt Aerospace LLC · Chandler, AZBuilt 2001 · S/N 32384N190AWCsi 135 Division LLC · Albuquerque, NMBuilt 1999 · S/N UE-382N190DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28447N190FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 63121N190GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-1N190NVAllegiant Air LLC · Las Vegas, NVBuilt 2015 · S/N 6669N190PMPlanemasters Ltd · West Chicago, ILBuilt 1986 · S/N UB66N190UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1436N19117United Airlines Inc · Chicago, ILBuilt 1996 · S/N 27559N19130United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28970N19136United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29285N19141United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30354N1914UUnited Airlines Inc · Chicago, ILS/N 2223N1918EGuano Air LLC · Palmetto Bay, FLBuilt 1979 · S/N 340A0668N191ANWyatt Aerospace LLC · Chandler, AZBuilt 2001 · S/N 32385N191AWCsi 135 Division LLC · Albuquerque, NMBuilt 1996 · S/N UE-251N191CSTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N UE-392N191CZPlanemasters Ltd · West Chicago, ILBuilt 1986 · S/N UB-59N191DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28448N191FPravin Aturalita · Duluth, MNBuilt 1964 · S/N TC-716N191FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63122N191NVAllegiant Air LLC · Las Vegas, NVBuilt 2015 · S/N 6704N191UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1447N191WFletcher Flying Service 419 LLC · Labelle, FLBuilt 1964 · S/N TC-577N191WAAmeriflight LLC · Dallas, TXBuilt 1970 · S/N U136N1920EHappy Trails Flight Training & Charters LLC · Helena, MTBuilt 1979 · S/N 340A0669N1924TUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-115N192DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28449N192FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63123N192GAAlpine Aviation Inc · Provo, UTS/N UB-17N192JERegistered aircraftBuilt 2002 · S/N 1491N192NVAllegiant Air LLC · Las Vegas, NVBuilt 2015 · S/N 6787N192PAPhoenix Air Group Inc · Cartersville, GABuilt 1964 · S/N 149
Back to AD 95-26-15 R1