This is possible, you have to use the Viewers category to collect them.
#Sean Page, 2024
import clr
clr.AddReference('RevitAPI')
from Autodesk.Revit.DB import *
clr.AddReference('System')
from System.Collections.Generic import List
clr.AddReference('RevitNodes')
import Revit
clr.ImportExtensions(Revit.Elements)
clr.AddReference('RevitServices')
import RevitServices
from RevitServices.Persistence import DocumentManager
doc = DocumentManager.Instance.CurrentDBDocument
#Select a View (This test is an Exterior Elevation
check = UnwrapElement(IN[0])
res = []
#Collect All Views
allViews = FilteredElementCollector(doc).OfCategory(BuiltInCategory.OST_Views).WhereElementIsNotElementType()
for view in allViews:
#Check to make sure it isn't a View Template
if not view.IsTemplate:
#Collect Viewers that are within the Views Collector
viewers = FilteredElementCollector(doc, view.Id).OfCategory(BuiltInCategory.OST_Viewers).WhereElementIsNotElementType()
for viewer in viewers:
#Check the View and Viewer name to find the matching ones
if viewer.Name == check.Name and viewer.Name != view.Name:
res.append(f'{view.Name} - {view.get_Parameter(BuiltInParameter.VIEWPORT_DETAIL_NUMBER).AsString()}/{view.get_Parameter(BuiltInParameter.VIEWPORT_SHEET_NUMBER).AsString()}')
OUT = res
List of Views the Elevation Shows up in and the Detail / Sheet of those Views if placed.

Sean Page, AIA, NCARB, LEED APPartner, Computational Designer, Architect