Hiya,
Don't ever confuse mathematical theory with reality. The reality is what you are dealing with - the imperfect gas. If it is natural atmosphere it will contain moisture, as well as a mix of Nitrogen, Oxygen, and other gasses and/or pollutants. That will have pressure, density, and humidity (which can cause internal corrosion).
By some fluke of nature most of the gasses approximately follow Bernoulli's equation. If you assume the gas to be "incompressible" it will act more like a liquid. Then you can make more simplifying assumptions. That approach is usually used in the design of Air Conditioning and Ventilation applications.
When you start looking at viscous effects, then the gasses approximately follow Reynolds equation, and viscous effects are approximated by the effects of Reynold's number. In that case you can use the Darcy Weisbach formula, together with the Moody Diagram. By some fluke of nature this is applicable in a general way to both liquids and gases, provided that your assumption of "incompressability" is adequate. The tables published in the ASHRAE Guide, and other air handling text, are based on an interpretation of the Moody Chart.
The same approach is used in the published tables for the flow of compressed air and other gases. Steam tables, however, are used to allow for the effect of partial pressure of water vapour in the air, and hence a "humidity ratio" - i.e. what part of the volume of gas follows the steam table.
When you put a magnifying glass on the flow effects, you have to ask - "Does the gas, in the range I am interested in, follow Newton's Formula, or is it non-Newtonian?"
You see - the real world is much more amazing that your engineering Professors would have you believe. Everything in nature is calculable. But do your numbers make sense in the range you are interested in? Most suprises come from making assumptions which ain't necessarily so.
Enjoy life - that's what it is all about.
Regards - Sgt John.Rz
Johnp.Rz