I've never seen mains water with any noticeable amount of air in it. There certainly is some air though because when filling central heating systems it is normal to repeatedly bleed the radiators and top-up the system for a few weeks afterwards.
Perhaps you have a small leak somewhere in the suction pipe system which is not sufficient to prevent lifting the water, but does introduce some air?