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.

N5328JKahler Automation Corp · Fairmont, MNBuilt 1977 · S/N 340A0412N532QRoush James L · Medina, WABuilt 1968 · S/N TC-1160N533CHSwenson Roger A · Pahrump, NVS/N 340-0056N533WPJacobs Aviation LLC · Mt Juliet, TNS/N 340A0328N5340GLegal Limit Motor Sports LLC · Anderson, CAS/N 340A0421N5346JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1977 · S/N 340A0419N534JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1705N534LAChirihue Leasing Trust · Wilmington, DEBuilt 2001 · S/N 32572N534QKenney Aviation LLC · Osterburg, PABuilt 1968 · S/N TC-1176N534UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3989N535JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1739N535JMWhiskey Uniform LLC · Wichita Falls, TXBuilt 1997 · S/N 1304N535KWFlying Squirrel Aviation LLC · Bozeman, MTS/N 340A0710N535RARich Aviation Services LLC · Fort Worth, TXBuilt 1968 · S/N TC-1126N535UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3993N536AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5360N536JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1784N536LAChirihue Leasing Trust · Wilmington, DEBuilt 2001 · S/N 32573N536UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4025N537CAAc Spe 10 LLC · Orlando, FLBuilt 2004 · S/N 33749N537JTJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1785N537UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4041N5383Treefo Bravo LLC · Hawkins, TXBuilt 1964 · S/N TC-755N538AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 5398N538LAQuetro Aircraft Leasing Trust · Wilmington, DEBuilt 2006 · S/N 34628N538UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4050N53993United States Government · Fort Belvoir, VAFirst renewal noticeBuilt 1985 · S/N 104N539USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26486N539UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4082N53AUJoachim Peter · Grafton, WIBuilt 1974 · S/N 340-0356N53DQSwair LLC · Denver, COS/N TC-983N53QMWings Enterprizes Ltd Co · Yukon, OKBuilt 1967 · S/N TE-312N53UPSarratt Curtis · Annapolis, MDBuilt 1964 · S/N TC-708N53WGAlliance Aviation Group LLC · Lawrence, KSBuilt 2003 · S/N 1505N5409UCosco & Associates Inc · Crestview, FLBuilt 1967 · S/N TC-1033N540LACaiquen Leasing LLC · Wilmington, DEBuilt 2006 · S/N 35229N540USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26487N540UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4107N541CMAero Parts LLC · Roselle, ILS/N 340-0338N541MCDynamic Avlease Inc · Bridgewater, VAS/N LM-39N541USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26488N5421JPeruzzi John DBA · Los Angeles, CABuilt 1976 · S/N 340A0108N5422ULeft Base LLC · Austin, TXBuilt 1967 · S/N TE-407N542AXAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-192N542LAQuetro Aircraft Leasing Trust · Wilmington, DEBuilt 2008 · S/N 34629N542MNKeeler Aviation LLC · Plattsmouth, NEFirst renewal noticeBuilt 1976 · S/N 340A0109N542USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26489N542UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4134N5432JSouthampton Wing LLC · Southampton, NYBuilt 1976 · S/N 340A0110N5432MWorthington Loren D · Caldwell, IDBuilt 1972 · S/N 340-0033
Back to AD 95-26-15 R1