Alright guys I got a 94 accord cd7. The car has an after market sunroof that leaks like no other. When it rains water gets trapped under the visor that covers the sunroof and leaks out. I’m debating on replacing it with sheet metal or maybe plexi glass any suggestions?

 

Did the aftermarket unit come with drain tubes?
Check that they are clean.
Only the pop-up style are usually water tight. Even factory roofs leak a little and have the tray and hoses to catch the water.