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.

N272NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 2995N272QFlying Docs LLC · Tomball, TXBuilt 1966 · S/N TE-236N2739YEnnis Michael J · Eminence, MOBuilt 1958 · S/N TD-92N273FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66243N273NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3076N273QTrident Aircraft Leasing LLC · Easton, MDBuilt 1966 · S/N TC-1020N273SFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 1346N2741YCoelum LLC · Lake Mary, FLBuilt 1958 · S/N TD-94N2742HWilbert John W III · Plaquemine, LABuilt 1979 · S/N 340A0929N2744PTouchdown LLC · Pls Vrds Est, CABuilt 1979 · S/N 340A0941N2744YDe Vuyst Richard C · Pampa, TXBuilt 1979 · S/N 340A0943N2745FAlexander Production Co · San Antonio, TXBuilt 1979 · S/N 340A0949N2746YDavenport Jimmy J · Hayesville, NCBuilt 1958 · S/N TD-104N2747YJennflight Inc · Chagrin Falls, OHS/N TD-96N2749YBaker Paul D · Grand Prairie, TXBuilt 1958 · S/N TD-105N274DCMaggie 288 LLC · Quincy, WAS/N 340A0923N274FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66244N274NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3079N2755YNancy Aviation LLC · Fayston, VTBuilt 1958 · S/N TD-106N2758TLinn Anthony B · Westborough, MABuilt 1967 · S/N TE-367N275DJBank Of Utah Trustee · Salt Lake City, UTBuilt 1991 · S/N 1167N275FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66245N275NVSunrise Asset Management LLC · Las Vegas, NVS/N 2807N275RBlue Card Aviation LLC · Conifer, COS/N TC-1885N275RMRodgers Kenneth · Appleton, WIBuilt 1974 · S/N 340-0511N2760YSanders Flight Training Inc · Jasper, ALBuilt 1958 · S/N TD-126N2762YFisher Global LLC · Conway, ARBuilt 1958 · S/N TD-129N2764YChennault Flying Services LLC · North Las Vegas, NVBuilt 1958 · S/N TD-128N276FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66251N276GXFalcon Msn 2695 Trust · Wilmington, DEBuilt 2006 · S/N 2695N276JMAlta 777 LLC · Salt Lake City, UTS/N 27636N276NVAllegiant Air LLC · Las Vegas, NVBuilt 2019 · S/N 8671N2772TRybakov Sergey N · Honolulu, HIBuilt 1967 · S/N TC-1032N2773TPovilaitis Carl A · Glendale, CABuilt 1967 · S/N TE-376N2776YMadlener Michael J · Las Vegas, NVBuilt 1958 · S/N TD-145N2778THavrick Jason T · Bridgeport, TXBuilt 1967 · S/N TE-378N277FCRegistered aircraftAssigned (import), pending cancellationS/N WA-308N277FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66246N277GXWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 2480N277JMN541mg Inc · Big Pine Key, FLBuilt 1966 · S/N TE-215N277LTBeechnutz Aviation LLC · Atlanta, GABuilt 1981 · S/N WA277N277MDRegistered aircraftBuilt 1966 · S/N TE-223N277MRSchab Davis Margaret A · Spangle, WABuilt 1966 · S/N TC-1012N277NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3205N2787TBombero Aviation LLC · Childress, TXBuilt 1967 · S/N TE-388N278FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66247N278GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 1954N278NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4253N2791TJoyce George E · Franklinville, NCS/N TE-384N2793Y3y Leasing LLC · Englewood, COBuilt 1958 · S/N TD-166
Back to AD 95-26-15 R1