The MOD (Maximum operating Depth) for air is 187 feet.
Of course this is too deep for a recreational diver. When using air, the limiting factors will be your no-decompression limit, narcosis, and the diver's experience level.
I love going deep, but then my dives are very short. It's better to stay at a reasonable depth and stay under water longer