Best way to know would be to calculate the kinetic energy. Assuming double-digit energy conversion you can just ignore it and use the full amount with reasonable accuracy, since dB is a log scale. Then, use the inverse-square law to wherever you’re standing in the cylinder.

A meter-sized asteroid is going to blow a hole big enough the sound won’t be the main concern, though. Probably you have two cylinders after that. Thankfully space is empty, and those are rare enough you can steer around them. Grape size impactors are the main thing they worry about on modern space stations.