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.

N798UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 26928N7998RSolberg Kevin L · West Fargo, NDBuilt 1969 · S/N TC-1241N799ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30258N799CZN799cz LLC · Milwaukee, WIBuilt 1969 · S/N U-68N799FDFederal Express Corp · Memphis, TNBuilt 1996 · S/N 28145N799MWSabre 42 Inc · Lewes, DEBuilt 1980 · S/N 465-42N799UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 26926N79ASPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N 340A1248N79DFMei Multi-Engine Instruction LLC · York, PABuilt 1975 · S/N TC-1883N79WDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-77N7DKAerotrust Services Corp Trustee · Wilmington, DEBuilt 1995 · S/N 1260N7EWMidas Aviation LLC · Royal Palm Beach, FLBuilt 1964 · S/N TC-764N7RMJasper Aviation Inc · Jasper, ALBuilt 1967 · S/N TE-347N7WPPoole Wesley Page · Young Harris, GABuilt 1967 · S/N TC-1044N8007RSpath Terry L · Helena, MTBuilt 1969 · S/N TC-1244N8008RClancey Maloney Aviation LLC · Lawrence, KSBuilt 1969 · S/N TC-1245N800ADOkadaful LLC · Torrance, CABuilt 1978 · S/N ME-96N800ARPerpetual Aviation LLC · Arlington, VABuilt 2002 · S/N 1496N800BCN800bc LLC · Columbia, PAS/N 340A0232N800BGBlaikie Thomas B · Kenner, LAS/N 340A0346N800BHHabib Aviation LLC · West Palm Beach, FLBuilt 2000 · S/N 1407N800EQMccauley Kerry D · Menomonie, WIBuilt 1960 · S/N LF-24N800FXFederal Express Corp · Memphis, TNS/N 336N800QACitadelle Holdings LLC · Palmetto Bay, FLBuilt 1962 · S/N LD-29N800UOhio University · Albany, OHBuilt 1979 · S/N TC-2276N800VMN800vm LLC · Wilton Manors, FLBuilt 1980 · S/N ME-318N8013YSunking Aviation LLC · Plano, TXS/N ME-413N801DMParallel Express LLC · Las Vegas, NVS/N 26240N801FXFederal Express Corp · Memphis, TNS/N 338N801HCAirline Contract Maintenance And Equipment Inc · Honolulu, HIBuilt 2004 · S/N 629N801NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0524N801QPrecision Flight Service Inc · Ponchatoula, LABuilt 1965 · S/N TC-897N801USwint Mark S · Henderson, NVBuilt 1965 · S/N TC-715N801YLand Management Of New York LLC · Highland, NYBuilt 1979 · S/N WA-59N802BAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-29N802FXFederal Express Corp · Memphis, TNS/N 344N802NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0533N802TDodson International Parts Inc · Rantoul, KSS/N TC-1548N803FXFederal Express Corp · Memphis, TNS/N 362N803NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0542N803TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1993 · S/N 27156N804DJBovender Richard S · Nashville, TNBuilt 1979 · S/N TC-2239N804FXFederal Express Corp · Memphis, TNS/N 370N804JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5142N804NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0549N804TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1989 · S/N 23988N805FTG4sp Blackbox Holdings LLC · North Palm Beach, FLBuilt 1999 · S/N 1374N805FXFederal Express Corp · Memphis, TNS/N 372N805JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5148N805NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0552
Back to AD 95-26-15 R1