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.

N198GSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N 1098N198KAThompson Benjamin Kyle · Nevada, TXBuilt 1966 · S/N LJ-162N198NVAllegiant Air LLC · Las Vegas, NVBuilt 2016 · S/N 7138N198UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5444N1999JBeech Boys LLC · Peachtree City, GABuilt 1967 · S/N TE-344N199ANAersale Inc · Doral, FLBuilt 2001 · S/N 32393N199CZN199cz LLC · Milwaukee, WIBuilt 1968 · S/N U-30N199DNDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 28456N199FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63129N199NVAllegiant Air LLC · Las Vegas, NVBuilt 2016 · S/N 7207N199UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5475N19EPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N UE326N19RZUas Transervices Inc · Boca Raton, FLBuilt 1989 · S/N UC-75N19UBas Part Sales LLC · Greeley, COBuilt 1979 · S/N ME-294N1AVLeader Nicholas A · Billings, MTBuilt 1962 · S/N TC-366N1BGGlobal Empire Trust LLC · Dover, DEBuilt 2001 · S/N 1436N1CNNothing By Chance LLC · Jackson, WYBuilt 1967 · S/N TE-313N1DWac I LLC · Fort Lauderdale, FLBuilt 1992 · S/N 1209N1FXTl Consulting LLC · Cadiz, KYBuilt 1963 · S/N TC-406N1HBRye-Corp LLC · Lenoir City, TNBuilt 1968 · S/N TC-1069N1HGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 1534N1RTFrost Darrell G · Atlanta, TXBuilt 1966 · S/N TE-185N1TDThreshold Ventures Inc · Scottsdale, AZBuilt 1990 · S/N 1133N1TMMarsico Aviation LLC · Denver, COBuilt 2002 · S/N 1490N1WDBushcraft Aviation LLC · Cypress, TXBuilt 1961 · S/N TC-192N2000EBluebird 2000 LLC · Wilmington, DEBuilt 1966 · S/N LJ-172N2007EWallbirds LLC · San Diego, CABuilt 1978 · S/N ME-60N2007KExecutive Flight Institute LLC · Murrieta, CABuilt 1978 · S/N ME-55N2008ESchrott Bradley S · Federal Way, WABuilt 1978 · S/N ME-73N2009EAce Of Spades Aviation LLC · Las Vegas, NVS/N ME-61N2009XGriffith Aviation Inc · Griffith, INBuilt 1978 · S/N ME-66N2009YFancy Pants Aviation LLC · Fort Worth, TXBuilt 1978 · S/N ME-74N200CBWarburton Patrick · Santa Rosa Valley, CABuilt 1973 · S/N TC-1517N200GCDancy Abram P · Shrewsbury, MABuilt 1978 · S/N 340A0503N200KDQuantum Aero Services LLC · Wilmington, DEBuilt 1958 · S/N TD-176N200LCSn 1067 LLC · Wilmington, DEBuilt 1988 · S/N 1067N200YCShady Aero LLC · Anchorage, KYS/N 340A0285N2010CLegner Leasing LLC · Las Vegas, NVBuilt 1958 · S/N TD-177N2011CTuorila Leo Eric · Anderson, SCBuilt 1958 · S/N TD-178N20125New Horizon Aviation Inc · Warwick, RIBuilt 1978 · S/N ME-94N20148Baron 1-4-8 LLC · Merrimack, NHS/N TC-2159N2016CRavey Guy W · Virginia Beach, VABuilt 1978 · S/N TC-2175N2016KAlp Paul · Falls Church, VABuilt 1978 · S/N TC-2163N2017WDucharme Paul Quin · Lafayette, LABuilt 1965 · S/N TE-12N201FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 3389N201GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-201N201UCSupernova LLC · Kalispell, MTS/N TC-225N201YWUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N 120.201N2021CPray Aviation Inc · Augusta, KSBuilt 1959 · S/N TD-212N2022CCarriere James M · Navarre, FLBuilt 1959 · S/N TD-189
Back to AD 95-26-15 R1