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.

N8237QAircon LLC · New Franklin, OHBuilt 1974 · S/N 340-0524N823NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1628N823UWalkowicz Eddie F · Garland, TXFirst renewal noticeBuilt 1961 · S/N TC-45N8249Omega Air Inc · Selma, TXS/N 48249N824BCAonvo Investment LLC · North Miami, FLBuilt 1977 · S/N 340A0306N824NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1637N8251DSwenson Roger A · Pahrump, NVS/N TD-16N825AJJarvis Jayson S · Pinehurst, NCBuilt 1977 · S/N TC-2050N825CPPilgrim Air 2 LLC · Van Nuys, CABuilt 1999 · S/N 1378N825KWEal Asset Holdings LLC · Kansas City, MOBuilt 2003 · S/N 32318N825NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1679N825WBeckett Jesse · Lakeway, TXS/N 340A0728N826KWAlta 777 LLC · Salt Lake City, UTS/N 28521N826NWDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 1701N826RPTbf Group Aviation LLC · Great Neck, NYBuilt 2003 · S/N 1507N8276DMusko Richard · Plains, PABuilt 1958 · S/N TD-22N827GAPpg Industries Inc · West Mifflin, PABuilt 1999 · S/N 1391N827JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5677N827KWAlta 777 LLC · Salt Lake City, UTS/N 28525N827NWBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 1716N827QDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 0827N827VU827vu LLC · Au Gres, MIS/N TC-2104N828JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5723N828MJa Flight Services LLC · Sugar Grove, ILBuilt 1980 · S/N TC-2299N828NWBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 1720N829GWin Win Aviation Inc · Wake Forest, NCBuilt 1967 · S/N TE-379N829NWBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 1721N829RBGlover William Scott · Mount Pleasant, TXBuilt 1980 · S/N TC-2305N829WWHemisphere Aerospace Investments LLC · Waco, TXS/N 27503N82GBAmerican Aviation Inc · Page, AZBuilt 1978 · S/N 340A0463N82MReady Aim Flyer LLC · New Castle, DEBuilt 1958 · S/N TD-167N8306Omega Air Inc · Selma, TXS/N 48306N8306D75s Leasing LLC · Greenwood Village, COBuilt 1958 · S/N TD-30N8308Omega Air Inc · Selma, TXS/N 48308N830BJElm III Operating Company LLC · Edmond, OKBuilt 1979 · S/N 340A0738N830FETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 1239N830KWAlta 777 LLC · Salt Lake City, UTS/N 30870N830NWDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 1769N830TTThuen Douglas · Andover, NJBuilt 1972 · S/N 3400186N830UPixton Christopher T · Oregon City, ORBuilt 1957 · S/N TD-12N8310Omega Air Inc · Selma, TXS/N 48310N8313NSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1968 · S/N TC-1070N831NWDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 1783N832FEFederal Express Corp · Memphis, TNS/N 1472N832USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53259N8331NGlens Pilot Services LLC · Yulee, FLBuilt 1968 · S/N TC-1079N833BEnnis Michael J · Eminence, MOBuilt 1959 · S/N TD-211N833USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53215N834ASAersale Inc · Coral Gables, FLS/N 28834N834JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5782
Back to AD 95-26-15 R1