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.

N813NWDelta Air Lines Inc · Atlanta, GAS/N 0799N8145RWatch Ya Head Aviation I LLC · Zionsville, INBuilt 1974 · S/N TC-1743N814DBNorth Rock LLC · Wilmington, DEBuilt 1973 · S/N TC-1560N814JCSports Medicine Consulting LLC · Midlothian, VABuilt 1966 · S/N TE-55N814NANasa Neil A Armstrong Flight Research Center · Edwards, CAS/N 1199N814NWDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 0806N814SWWenman Bradford Harris · Johnson, KSS/N 340-0197N8155RLarson James R · Waupaca, WIBuilt 1976 · S/N TC-1948N815BFN815bf LLC · Westlake Village, CABuilt 1974 · S/N TC-1659N815DTAviation Development Group LLC · Kalispell, MTS/N 1085N815KKBristol Aircraft Leasing LLC · Montgomery, ALBuilt 1973 · S/N TC-1521N815KWAlta 777 LLC · Salt Lake City, UTS/N 27640N815NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0817N816FXFederal Express Corp · Memphis, TNS/N 347N816NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0827N816SPJmd Aviation LLC · Jupiter, FLBuilt 2001 · S/N 1452N8175QMillenium Enterprises LLC · Naples, FLS/N 340-0522N8175RShilling Aeronautical Holdings LLC · Bradenton, FLBuilt 1974 · S/N TC-1754N817CMCargo Aircraft Management Inc · Wilmington, OHS/N 1269N817KWAlta 777 LLC · Salt Lake City, UTS/N 27642N817NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0843N818MECape Clear LLC · Westboro, MABuilt 2000 · S/N 1431N818NHAersale Inc · Doral, FLBuilt 2000 · S/N 29311N818NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0857N8194RHouse Of J Inc · Lake Charles, LABuilt 1974 · S/N TC-1763N819FXFederal Express Corp · Memphis, TNBuilt 1993 · S/N 359N819MMPremier Aero LLC · Gonzales, LABuilt 1981 · S/N TC-2401N819NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0858N819VDAdams Aviation Services Inc Owner Trustee · Wilmington, DEBuilt 2004 · S/N 1535N81ABAcceler8 Aviation LLC · Livermore, CABuilt 1969 · S/N TC1247N81RYRedding Dermatology Medical Group Inc · Redding, CABuilt 1981 · S/N 340A1238N8201Omega Air Inc · Selma, TXS/N 48201N8205Omega Air Inc · Selma, TXS/N 48205N8209Omega Air Inc · Selma, TXS/N 48209N820FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 248N820MAMccomas John C · Granbury, TXBuilt 1964 · S/N TC-833N820NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0859N821AUBank Of Utah Trustee · Salt Lake City, UTS/N 24821N821AVAircol 22 · Wilmington, DEBuilt 2011 · S/N 4821N821CMCargo Aircraft Management Inc · Wilmington, OHS/N 1146N821FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 253N821JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5417N821NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0865N821SFAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC-121N8222Omega Air Inc · Selma, TXS/N 48222N82247Omega Air Inc · Selma, TXS/N 48247N822KWAlta 777 LLC · Salt Lake City, UTS/N 28532N822NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1627N822PJNeary Michael John · Tuckerton, NJBuilt 1979 · S/N WA-47N822VWWetherbee Rodney A · Florence, ORBuilt 1978 · S/N 340A0630
Back to AD 95-26-15 R1