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.

N834USUSA Jet Airlines Inc · Belleville, MIBuilt 1990 · S/N 53115N835USUSA Jet Airlines Inc · Belleville, MIBuilt 1990 · S/N 53172N836USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53214N837EXBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeS/N 217N837USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53257N837VABank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4558N839EXBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeBuilt 1990 · S/N 226N83CLPalmer Robert E · Cedar Key, FLBuilt 1970 · S/N TC-1315N83ERMike Smith Aviation International Inc · Rancho Murieta, CABuilt 1979 · S/N ME-201N83JBHuie Ag Service LLC · Beeville, TXS/N 3400061N83ZCrittenden William F · Spokane Valley, WAS/N TD-199N840ERTikchik LLC · Anchorage, AKBuilt 1988 · S/N 1049N840KWAlta 777 LLC · Salt Lake City, UTS/N 32890N840STransnational Aviation LLC · Arlington, TXBuilt 1962 · S/N LF-38N841LAvery Adam · Edmonton, KYBuilt 1963 · S/N TC-458N842EElectric Boat Corp · Groton, CTBuilt 1998 · S/N UE-336N842PAValiair Ltd Co Trustee · Casper, WYBuilt 1988 · S/N 1057N842USUSA Jet Airlines Inc · Belleville, MIBuilt 1992 · S/N 53380N843EElectric Boat Corp · Groton, CTBuilt 1998 · S/N UE339N844NBemidji Aviation Services Inc · Bemidji, MNS/N LF-42N8456NBowling Green Aviation LLC · Germantown, TNBuilt 1968 · S/N TC-1103N845LMarshall Timothy Trustee · Tucson, AZBuilt 1982 · S/N 340A1511N8493NSoderblom Edward J · Ferndale, WABuilt 1968 · S/N TC-1112N8494NLemons Hayden · Conway, ARS/N TC-1113N8496NIsaacs Brandon · Homedale, IDS/N TC-1115N84CGGuardian Angel Homes LLC · Hayden, IDBuilt 1981 · S/N 340A1274N84GDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-33N84HCJeffcoat Roy B · Anderson, SCBuilt 1976 · S/N 340A0052N84JBPremise Aviation LLC · Elizabeth, COS/N 340A1009N84TAAnderson Wallace A · Melbourne, FLBuilt 1974 · S/N TC-1769N84ZRomeo Aviation Ltd · East Sparta, OHBuilt 1959 · S/N TD-232N850CCSunshine Aero Industries Inc · Crestview, FLBuilt 1980 · S/N 465-38N850RTFlying Owl Aviation LLC · Lewisville, TXBuilt 1997 · S/N 1324N8511MJ & J Aviation Services LLC · Simpsonville, SCBuilt 1963 · S/N TC-472N8516GTri-State Management Corp · Thomasville, GABuilt 1979 · S/N 340A0702N851ASUmb Bank Na Trustee · Salt Lake City, UTS/N 1185N852SPStephens Pipe & Steel LLC · Jamestown, KYBuilt 1997 · S/N 1309N8540MMcdaniel David S · Madill, OKBuilt 1963 · S/N TC-510N85516United States Department Of State · Melbourne, FLBuilt 1993 · S/N UE-61N8557RC & G Enterprises LLC · Chesterfield, VABuilt 1974 · S/N TC-1768N855CZimmerman Walker D · Nashville, TNS/N TC-796N8577MSkyfix International Inc · Fort Lauderdale, FLBuilt 1963 · S/N TC-479N857STSeminole Tribe Of Florida · Hollywood, FLBuilt 1998 · S/N 1345N8580RHabanero One Express Inc · Ann Arbor, MIBuilt 1974 · S/N TC-1771N8589RRegistered aircraftBuilt 1974 · S/N TC-1775N858FTLogistic Air Inc · Reno, NVBuilt 1970 · S/N 20109N858JMDebergalis Matt · San Francisco, CABuilt 1965 · S/N TE-17N8596RTjh Aviation · Greenville, TXBuilt 1974 · S/N TC-1780N859BEBlue Eagle Airways Inc · San Juan, PRBuilt 1983 · S/N 120147N85CMRuggles Don C · Texarkana, ARS/N TC-1092
Back to AD 95-26-15 R1