See Apertus: https://apertus.rlp.de/ for digitized records. See learning videos: https://www.landeshauptarchiv.de/bestaende
Link to St.Johann: https://apertus.rlp.de/index.php?PLINK=1&ID=eb61c325-3645-40ba-a6d9-b3769a9d32c9
Landesarchiv Speyer: http://www.landeshauptarchiv.de/landesarchivverwaltung/
Landeshauptarchiv Koblenz. www.landeshauptarchiv.de. To see an inventory of the available civil and church records in Koblenz click on "Personenstandsarchiv Rheinland-Pfalz" then download the "Kurzuebersicht Personenstandsunterlagen" on the download item of this web page.
Sources in print:
Minert, Roger P. "The State Archive (Landesarchiv) at Speyer". In The Palatine Immigrant. Volume XXX, No. 4 (September 2005); pp. 3-4.