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.

N56LK2 Investment Fund LLC · Zephyr Cove, NVBuilt 1993 · S/N 1213N56LBArlington Flight Services Inc · Arlington, WABuilt 1959 · S/N TD-279N56MAMinuteman Aviation Inc · Missoula, MTBuilt 1976 · S/N 340A0067N56MELuttrell Jabe · Key West, FLBuilt 1977 · S/N 340A0316N56TMPoint Two Mmo Aviation · Lake Stevens, WABuilt 1961 · S/N TC-189N5700KNeel Aviation LLC · Lakeland, FLBuilt 1964 · S/N TC-702N57016United Airlines Inc · Chicago, ILBuilt 2000 · S/N 28679N5701VRuffcorn Aviation · Bettendort, IABuilt 1966 · S/N TE-89N570DCWebster Air LLC · Houston, TXBuilt 1992 · S/N 1185N570JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2099N570LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 40799N570TABank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 3869N57111United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27301N5711VBrack-Ponce Annabelle S · Zephyr Cove, NVBuilt 1966 · S/N TE-95N5713VCaribbean Dental Lab LLC · St Thomas, VIBuilt 1966 · S/N TE-98N571AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30388N571JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2125N5722KBranaman Timothy J · Monument, COBuilt 1964 · S/N TC-737N5729MN5729m LLC · Coral Springs, FLBuilt 1972 · S/N 340-0038N572LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 41747N572UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5899N573UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5939N5742KCygnet Aerospace Corp · Los Osos, CABuilt 1964 · S/N TC-729N5748VB55 Partners LLC · Vero Beach, FLFirst renewal noticeBuilt 1966 · S/N TC-993N5751CRemy H Blanchaert Jr Dds Md Pa · Wichita, KSS/N 340A0974N5755KBrooks Auto Parts Inc · Douglas, GABuilt 1964 · S/N TC-738N5757CRoberts Justin · Livingston, MTBuilt 1980 · S/N 340A0975N575FAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC-99N575GUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-155N575UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5980N5763KNnamsu Enterprises LLC · Walnut Creek, CAS/N TC-748N5768S3c LLC · Waukee, IABuilt 1972 · S/N 3400037N576UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6027N5779KHarris Aircraft Leasing Co · Oklahoma City, OKS/N TC-308N577FCFlight Club · Middle River, MDS/N WA-43N577NANasa Langley Research Center · Hampton, VAS/N 32892N577TABank Of Utah Trustee · Salt Lake City, UTS/N 355N577UV & V LLC · Shenandoah, VABuilt 1966 · S/N TC-984N578SWJahn641bc LLC · Miami, FLBuilt 1998 · S/N 120346N578UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6035N579JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2132N579UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6100N57AWGrey Horizon Group LLC · Sheridan, WYS/N TC-1116N57MPSoleil Aviation LLC · Naples, FLBuilt 1973 · S/N TC-1631N57RTChristiansen Aviation LLC · Wilmington, DEBuilt 1979 · S/N ME-172N5800SRabosky Gary · Frenchtown, NJBuilt 1964 · S/N TC-817N580JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2136N580UPC C & E I LLC · Louisville, KYS/N 25632N580UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6133N58101United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27291
Back to AD 95-26-15 R1