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.

N207NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5638N2087L30 West Pilots LLC · Dover, DEBuilt 1976 · S/N TC-2007N2089WBaron 2089w LLC · Jupiter, FLBuilt 1966 · S/N TE-60N208MLAngelo Sorce Md Pllc · Dandridge, TNBuilt 1962 · S/N LF-34N208NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5640N208QPetersen Robert Trustee · Harrodsburg, KYBuilt 1965 · S/N TC-898N2099CFrazier Jon A · Vista, CAS/N TD-276N209NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5901N209TRCareer Aviation Co Inc · Wilmington, DEBuilt 1976 · S/N 20994N209UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 30215N20DJBeach Bum Airways LLC · Saint Petersburg, FLBuilt 1966 · S/N TE-191N20JNGana Trucking & Excavating Inc · Martell, NES/N 340A0050N20JWRocky Mountain Triangle LLC · Castle Rock, COBuilt 1962 · S/N TC-258N20RADepartment Of The Air Force · Hill Afb, UTBuilt 1985 · S/N UB-42N20TYSuziki Shoji · San Jose, CABuilt 1962 · S/N TC-254N2100DL A M Capital Management LLC · Sheridan, WYBuilt 1978 · S/N ME-41N2103LMcgregor Steve · Oil City, PABuilt 1977 · S/N TC-2023N2107ZAir Prestigio LLC · Aliso Viejo, CAS/N 1211N210NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5540N210UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 30216N210WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N TC-1073N21108United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27298N2113KCalvin B Wiley · Summer Shade, KYS/N TD-283N211BStone Air LLC · Carrollton, GABuilt 1964 · S/N TC-714N211DRegistered aircraftBuilt 1966 · S/N TC-995N211DHHagadone Aviation LLC · Coeur D Alene, IDBuilt 2000 · S/N 1432N211FStoltzfus Calvin J · Great Falls, MTBuilt 1963 · S/N TC-514N211GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-211N211NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5442N211SVMatthews Aviation LLC · Greensboro, NCS/N 340A1000N211UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 30217N211YRegistered aircraftBuilt 1966 · S/N TE-169N2120LN2120l LLC · Kansas City, MOBuilt 1976 · S/N TC-1985N21234Positive Rate LLC · Kenosha, WIBuilt 1982 · S/N 340A1207N212NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5498N212UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 30218N213CNCullem Daniel F · Soquel, CABuilt 1980 · S/N TC-2298N213EOliver Craig J · Orion, MIBuilt 1965 · S/N TE-40N213EFMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1996 · S/N 1283N213UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 30219N213USMuseum Of Flight Foundation · Seattle, WABuilt 1969 · S/N 20213N213ZWhite Gregory D · Enterprise, ALBuilt 1964 · S/N TC-672N214DMGrueninger Mark J · Benton, ILBuilt 1962 · S/N TC-285N214UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 30220N215CBKw Bradley Associates LLC · Manlius, NYBuilt 1980 · S/N 340A1019N215NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1292N215UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 30221N216UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 30549N2172LU S Aviator LLC · Eugene, ORBuilt 1976 · S/N TC-2020N217KEpps Ernest P Jr · Atlanta, GABuilt 1965 · S/N TC-891
Back to AD 95-26-15 R1