From dcltribute.com:
Are there rooms on Deck 2 that are noisy?
I had more than one question about the noise on Deck 2 while I maintained a "Let me answer your questions, 'live' from the Magic" thread on the DIS Boards during our 2001 Magic cruise, so I went down to Deck 2 and did my own evaluation.
First of all, let me state that, for the majority of the rooms, Deck 2 is very quiet and you should have no problem staying there. But there are some zones where staterooms are near loud mechanical equipment (electrical lockers, transformer rooms, a/c equipment rooms, ship's propellers, cargo hatches, etc.).
So with the disclaimer that "your mileage may vary" and that you may be willing to put up with the "dull roar" in exchange for a good fare, these are the rooms that are in noisy zones:
Port Starboard
2000 - 2004
2032
2036 - 2047
2078 - 2085
2094 - 2096
2114 - 2129
2139 - 2153
2500 - 2520
2534 - 2547
2586 - 2600
2626
2630 - 2653
Also, on Deck 1, you might want to avoid...
Port
1030 - 1037
1062 - 1064