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.

N707BWDrago Air LLC · Mulberry, INBuilt 1984 · S/N 340A1812N707CPBaron Aviation LLC · Jesup, IABuilt 1965 · S/N TC-864N707DJSun City Aviation LLC · Davie, FLBuilt 1980 · S/N ME-367N707FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 1741N707TGBerry Aviation Inc · San Marcos, TXBuilt 1990 · S/N 120.182N707VVAb Jet Co V LLC · Metairie, LAS/N 1342N707WESofi Air LLC · Roslyn Heights, NYBuilt 1998 · S/N 1356N707WSIsland Air Leasing LLC · Columbus, OHBuilt 1974 · S/N TC-1803N708AAWorld Aviation Services LLC · Medley, FLBuilt 1981 · S/N 22465N708FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 1744N708FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 7042N708JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3479N708SSierra Pacific Airlines Inc · Tucson, AZBuilt 1995 · S/N 27424N708SVJah2022a Atr72 Msn 1092 LLC · Dallas, TXBuilt 2013 · S/N 1092N708YAltenbaumer Max Allen · Texarkana, TXBuilt 1958 · S/N TD-39N70926Dynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-84N709DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 40559N709FEFederal Express Corporation · Memphis, TNBuilt 2023 · S/N 1750N709FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7097N709JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3488N709RMJci Marketing And Consulting LLC · Wilmington, DEBuilt 1975 · S/N TC-1863N709SSierra Pacific Airlines Inc · Tucson, AZBuilt 1997 · S/N 28722N70EERoot Shane G · Dighton, KSFirst renewal noticeBuilt 1966 · S/N TE-13N70GAbj Holdings LLC · Buckeye, AZBuilt 1973 · S/N TC-1540N70LNMassachusetts Institute Of Technology · Lexington, MABuilt 1989 · S/N 1101N70MBCastro Gary Clinton · Visalia, CABuilt 1968 · S/N TC-1193N70MFMoyer Aviation Inc · Tobyhanna, PABuilt 1962 · S/N TC-382N70NPBemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U-14N70SKDylan Dublin Air LLC · Hobe Sound, FLBuilt 1980 · S/N 465-33N70UDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-51N70VLBank Of Utah Trustee · Salt Lake City, UTS/N 30440N710DNJetran LLC · Horseshoe Bay, TXBuilt 2010 · S/N 40560N710DRGo 2 Guys Inc · Fresno, CABuilt 1966 · S/N TC-986N710FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 1753N710FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7179N710FSCaddis Flyers LLC · Kalispell, MTS/N 340-0355N710MVTailspin Management LLC · Los Angeles, CABuilt 1999 · S/N 1370N7112TDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-88N711CBRoundhive Corp · New York, NYBuilt 1979 · S/N 340A0913N711CMPonderosa Aviation LLC · Safford, AZS/N TC-171N711FEFederal Express Corp · Memphis, TNS/N 1755N711FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7184N711HPUhlig Paul Nelson · Wichita, KSBuilt 1978 · S/N TC-2127N711MLShuff James S II · Victor, WVS/N 340-0090N711PZOffroute Aero LLC · Lake Oswego, ORBuilt 1973 · S/N TC-1491N711SDMundy William L · Proctorville, OHS/N 340A0958N711TRAtomic Cat LLC · Hamilton, MTS/N TE-350N711WRLaxmi Jet Holdings LLC · Miami Beach, FLBuilt 1991 · S/N 1171N711YLBurkett Gary L Trustee · Murfreesboro, TNBuilt 1979 · S/N 340A0955N711ZXDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28481
Back to AD 95-26-15 R1