It's possible to use the ATO's free super fund lookup to access publicly available information about all self-managed super funds (SMSFs) with an ABN. It includes SMSFs as well as funds regulated by the Australian Prudential Regulation Authority (APRA).
The lookup provides a status. The details of each status is detailed in the following article from the ATO: