Why are small single engined airplanes so noisy?

The air cooled engines are also somewhat louder than the water cooled ones aren’t they?

Water jackets around the cylinders tend to reduce some of the mechanical noise of the engine. That noise is insignificant compared to the propeller noise, though.