Well that was an absolutely ignorant post!
As a few 170/190 pilots who actually know what the heck is going on have said before, the noise comes from a rubber piece that attaches to the top of the doors. It follows the contour of the doors, and is about 1/2 to 3/4 of an inch thick. This piece does not affect pressurization, or structural integrity. The leading edge of these rubber pieces fray over time as they are exposed to the slipstream and to the high speed dirt kicked up by other planes' jet blast while taxiing. When these leading edges fray, they begin to vibrate, and eventually airflow can get under the entire leading edge and really make some noise. Depending on where the fray is occuring, different airspeeds and angels of attack will trigger the noise. Some planes will make noise in the climb, some in slow cruise flight, some in fast cruise, some in the decent, some at 270kts, some at 310 kts. Each occurance is different, as each rubber piece frays at a somewhat different spot, and may have been left unfixed for a longer time. Aft door vibrations are not easily heard up front, and we need the FAs to notify us of the problem- super reliable. The front door problems are easily detectable by the flight crew. When Mx comes out, they often just trim the deteriorating piece with a pair of scissors, which is surprisingly effective.
When you board a 170/190 next time, look at the door. Along the top, fixed to the door itself, is a grey piece of textured rubber that follows the curve of the door. This is the culprit.
Hard to believe were talking about the same issue. This noise literally sounds of the airplane vibrating it's way apart. A door seal would have a higher pitched whine upwards of 1-8khtz this sound is a low pitch square waveform sound below 300htz that resonates and vibrates the entire front cabin. Again like an N1 vibration or out of sync bypass fans.