Fiddling with Certificate Transparency Logs
https://github.com/0xbharath/ctlog-utilities/
crt.sh by Comodo provides direct DB access to it’s CT Logs. There is a 1-12 hours delay though.
psql -h crt.sh -p 5432 -U guest certwatch \
-c "SELECT id, x509_commonname(certificate) AS common_name FROM certificate WHERE identities(certificate) @@ plainto_tsquery('navigalactic.com') AND lower(x509_commonname(certificate)) LIKE '%.navigalactic.com' ;"