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.

N764ANBoeing Co · Renton, WAS/N 32439N7651NScarp LLC · Seabrook, TXBuilt 1968 · S/N TC-1148N7652DGunter Scott · Walters, OKBuilt 1981 · S/N TC-2400N7652NCockrell Kenneth D · Friendswood, TXBuilt 1968 · S/N TC-1147N7657NStewart James D · Mesa, AZBuilt 1968 · S/N TC-1130N765ANAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 32879N765JBN765jb LLC · Colorado Springs, COS/N 340A0647N765LTDrj Aviation LLC · Dover, DES/N 340-0181N765RMBd Giv 2 LLC · New York, NYBuilt 1991 · S/N 1170N766ANAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 32880N766CKKalitta Air LLC · Ypsilanti, MIBuilt 2005 · S/N 34016N766JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3724N7672CBank Of Utah Trustee · Salt Lake City, UTS/N 30432N7672DBank Of Utah Trustee · Salt Lake City, UTS/N 30433N7673CCsds Asset Management LLC · Rllng Hls Est, CAS/N 28264N767AJAmerican Airlines Inc · Fort Worth, TXBuilt 2006 · S/N 33539N767AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22785N767BZBank Of Utah Trustee · Salt Lake City, UTS/N 22567N767CKKalitta Air LLC · Ypsilanti, MIBuilt 2005 · S/N 34017N767MWWyatt Aerospace LLC · Chandler, AZBuilt 1982 · S/N 22694N7680NTpc Air LLC · Colleyville, TXBuilt 1968 · S/N TC-1154N768AAAmerican Airlines Inc · Fort Worth, TXBuilt 2006 · S/N 33540N768AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22786N768CKKalitta Air LLC · Ypsilanti, MIS/N 34018N768JBJetblue Airways Corp · Long Island City, NYBuilt 2009 · S/N 3760N768UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 26919N768VACargo Aircraft Management Inc · Wilmington, OHBuilt 1982 · S/N 21869N768WMcwilliams Russell · Flower Mound, TXBuilt 1977 · S/N TC-2108N769MMBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 1369N769RJWings South Inc · Fayetteville, GABuilt 1963 · S/N TC-536N769UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 26921N76DUL&P Of Mke LLC · Milwaukee, WIBuilt 1978 · S/N ME-52N76EJValiair Lc Trustee · Casper, WYS/N 1033N76KWTriple Bee Transport LLC · Leon, WVBuilt 1980 · S/N TC-2318N76MKMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N ME186N76NKNaples Jet Management LLC · Naples, FLS/N ME-334N76NNSale Reported · Middletown, OHSale reported, canceledBuilt 1979 · S/N ME-158N76QDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-15N76RTEmax LLC · Perry, GABuilt 1970 · S/N LB-27N76WDLittle Evin M · Bidwell, OHS/N 340A0099N77006United Airlines Inc · Chicago, ILBuilt 1998 · S/N 29476N77012United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29860N77014United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29862N77019United Airlines Inc · Chicago, ILBuilt 2007 · S/N 35547N77022United Airlines Inc · Chicago, ILBuilt 2010 · S/N 39777N770ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29578N770BBYucaipa Companies LLC · Burbank, CABuilt 1991 · S/N 25220N770FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24743N770KSBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1989 · S/N 1093N7712RJerry T And Beverly H Davis Family Lp · Monticello, ARFirst renewal noticeBuilt 1968 · S/N TC-1167
Back to AD 95-26-15 R1