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.

N30GDCarol City Air LLC · Hialeah, FLBuilt 1993 · S/N 1228N30HBN30hb LLC · North Miami, FLS/N 340-0786N30JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 1517N30LHHillier Giv LLC · Va Beach, VABuilt 1992 · S/N 1207N31019Save A Connie Inc DBA · Kansas City, MOBuilt 1974 · S/N 193B-1066N310DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7293N3110ATalon Group LLC · Marietta, GABuilt 1979 · S/N TC-2207N311AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25316N311DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7304N311FTR&D Land And Air LLC · St Simons Is, GABuilt 1964 · S/N TC-744N311GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 1995 · S/N 26316N311KMDream Flight Florida LLC · Wellington, FLBuilt 1979 · S/N 340A0757N3120WWiese Chuck F · Portland, ORBuilt 1973 · S/N TC-1645N3127TSouth Valley Internet Inc · San Martin, CAS/N 340A-0025N312AACargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 22315N312CMChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-103N312DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7364N312VFCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1967 · S/N LJ-299N31309Meadowlake Airpark LLC · Lenoir City, TNS/N TC-1524N3130WWarbirds East Inc · Fairhope, ALBuilt 1973 · S/N TC-1635N313AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-313N313ARDora 13 LLC · North Bergen, NJBuilt 1997 · S/N 1317N313AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1990 · S/N 24930N313DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7381N313XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1991 · S/N 25313N314DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7281N314GRVice One LLC · Las Vegas, NVS/N 340A1028N314MGSummit Aviation LLC · Las Vegas, NVS/N 340A0284N314XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1991 · S/N 25314N315BPKing Logistics LLC · Ridgeland, MSBuilt 1979 · S/N TC-2230N315DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7436N315GVancleve Cole · Cotulla, TXBuilt 1965 · S/N TC-907N316DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7327N316VBLiving Word Christian Center · Forest Park, ILBuilt 1999 · S/N 1377N31701Uas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N UB-2N31702Uas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N UB-3N31703Uas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N UB-10N31704Uas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N UB-12N31705Uas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N UB-60N3172Bank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N 340B172N3175WKristoffer & Co · Jacksonville, FLBuilt 1973 · S/N TC-1614N317AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-317N317AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25445N317BDRegistered aircraftBuilt 1967 · S/N TE-317N317CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24317N317DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7373N318ALeaders Robert O · Clear Lake, MNBuilt 1966 · S/N TE-229N318DSchutes John T · Brimfield, MABuilt 1967 · S/N TE-311N318DXDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 7441N3197WMoskin Jeffrey M · Culver City, CAS/N TC-1658
Back to AD 95-26-15 R1