Peculiar flow of water from an aerated faucet Let me acknowledge that my friend found out about this effect first, who later showed it to me.
When you slowly open an aerated tap, bubbles that form near the opening of the tap start to merge to form a big cavity inside the water flow.

This is normal water flow before cavity formation


Water flow after cavity formation

What's more interesting is that the cavity pulsates as it grows bigger. (Hopefully, it is visible in this gif)

Oscillations of the cavity

Updates
I couldn't see this effect when the tap was fully open. So the effect, as correctly mentioned by @niels, has something to do with the velocity of water flow.
Furthermore, I couldn't see this effect for taps without aerators.
Video samples

*

*(Cavity formation in water).

*(Cavity formation in water flowing at slightly higher speed)

*(Cavity oscillation - angle 1)

*(Cavity oscillation - angle 2)

So what is going on here? How does the cavity form, and why does it pulsate?
 A: an aerator nozzle contains air passages that draw outside air in through slits in the sides of the nozzle into a mixing chamber inside, where the air is mixed with the water and then squirted out through a series of small holes in the outlet of the nozzle. Those holes break up the air bubbles into small ones, giving the water a fizzy appearance.
The air inlets into the mixing cavity are so designed that by Bernoulli's law, a suction is created in the mixing chamber which actively draws the air in when the water is flowing fast through the assembly.
But when the water is not flowing fast enough, a suction is not created and the air entering the mixing chamber does not get pulled in and swirled around with the water. Instead it populates the center of the mixing chamber while the water dribbles past it around the periphery of the mixing chamber (where the little water nozzles are distributed).
So in this case you get a slow-moving water stream with a hollow core in it. I'll have to think some more about the oscillation phenomenon.
BTW most aerator nozzles are made to be disassembled for cleaning, and so you can take yours apart and inspect all the tiny features that are molded into the parts inside which let the nozzle do its job.
