Any generic SCSI-1 CD-ROM drive will work fine. You can find them on ebay fairly easily. Not sure if you're specifically after an exact OEM replacement, though.
I've since switched to a SCSI2SD, and I have my old Plextor SCSI drive if you want to throw me an offer via PM.