Use Query Builder

Sample Query Builder URL:

http://localhost:4502/libs/cq/search/content/querydebug.html?_charset_=UTF-8&query=path%3D%2Fcontent%2Fus%2Fen%0D%0A1_property%3Dsling%3AresourceType%0D%0A1_property.value%3Dcomponents%2Fstructure%2Fmy-template-page

OR

http://<hostname>/bin/querybuilder.json?path=/content/project/wwwv2&1_property=sling:resourceType&1_property.value=projectv2/www/component/content/banner

Note:

     1)      Update property.value with component resource type

Eg:  projectv2/www/component/content/banner

If resource type mentioned in sheet starts with /apps/ , just ignore /aaps/ and copy from Project/www/component/… as shown above.

Hit this URL to get results. 

      2)      Results will contain pages which contains this component

Eg: In result we got page

"path": "/content/project/wwwv2/test123/jcr:content/center-column-parsys/banner",

Then copy URL till path before where /jcr:content starts and append .html in the end

Now to open page in classic UI:

https://<hostname>/cf#/content/project/wwwv2/test123.html

To open page in touch UI:

https://<hostname>/editor.html/content/project/wwwv2/test123.html

For more details on query builder API, please refer below link

https://docs.adobe.com/content/help/en/experience-manager-65/developing/platform/query-builder/querybuilder-api.html