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.

N344NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 388N3450SBoyes Robert Louis · Benton City, MOBuilt 1969 · S/N TC-1264N3456QL & J Aviation Inc · Atwater, CABuilt 1971 · S/N 340-0004N345AVAircol 20 · Wilmington, DEBuilt 2010 · S/N 4345N345BKMckenzie Michael C · Ventura, CABuilt 1976 · S/N 340A0113N345DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8191N345NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 399N346AFAmeriflight LLC · Dallas, TXBuilt 1989 · S/N UC71N346AGBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 340B446N346CJBank Of Utah Trustee · Salt Lake City, UTS/N 340B-346N346DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8227N346DWValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 340A0742N346FSRichard C Reed · Snyder, TXS/N 340A0790N346MCSkyway Aviation LLC · Purvis, MSS/N 340A-0425N347AFAmeriflight LLC · Dallas, TXBuilt 1989 · S/N UC66N347AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 26264N347CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 26995N347DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8250N347JADepete Joseph G · Louisville, KYBuilt 1978 · S/N 340A0448N347NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 408N348AGAviation Inventory Resources Inc · Alvarado, TXBuilt 1998 · S/N 340B-448N348DJMecha Holdings LLC · Newtown Square, PABuilt 1998 · S/N 1348N348DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8258N348NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 410N349CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 26996N349DXBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8233N349NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 417N349YVam Aviation LLC · Edmond, OKBuilt 1962 · S/N TC-389N34AWValiair Lc Trustee · Casper, WYBuilt 1976 · S/N 340A0097N34BWMaintenance Forecasters Inc · Falmouth, MIBuilt 1974 · S/N TC-1691N34HAHarper Aerospace LLC · Murfreesboro, TNS/N LM-120N34HGUnited States Government · Fort Belvoir, VAS/N 34N34NYKeys Robert · Menifee, CABuilt 1973 · S/N 340-0196N34RZUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-151N34TLAmeagle Aviation LLC · Coventry, CTBuilt 1977 · S/N 340A0423N34WWChute Aviation LLC · Prescott, AZBuilt 1973 · S/N 340-0258N350ABierlein Aviation LLC · Midland, MIBuilt 1977 · S/N 340A0325N350DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8207N350NADelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 418N3517AMunoz Pedro L · Ontario, NYBuilt 1969 · S/N TC-1305N351AGBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 340B445N351CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25201N351DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8251N351FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 1955 · S/N 279N351NWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 766N351RRHolder Joiy R · Port Saint Lucie, FLBuilt 1964 · S/N TC-763N352BHGle 1393 LLC · Sunny Isles, FLBuilt 1999 · S/N 1393N352CJAviation Inventory Resources Inc · Alvarado, TXBuilt 1993 · S/N 340B-352N352DJDelawair LLC · Newark, DEBuilt 1998 · S/N 1352N352DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8283
Back to AD 95-26-15 R1