The one that you have appears to be intact

I’d be curious to know if it’s the solder joints that failed (less common) or if the pads ripped out of the PCB, which is usually what happens in these cases.

In the latter case, you’re going to have a hard time installing the replacement part. You’ll need to first restore the pads, which falls into “microsoldering” territory that will have a higher tool and skill / precision requirement.