The state-to-state (StS) model can accurately describe high-temperature thermochemical nonequilibrium flows. For the five-species air gas mixture, we develop a comprehensive database for the state-specific rate coefficients for temperatures 300–25 000 K in this paper. The database incorporates recent molecular dynamics simulations (based on the ab initio potential energy surfaces) in the literature, and theoretical methods, including the forced harmonic oscillator model and the Marrone–Treanor model, are employed to complement the rate coefficients that are unavailable from molecular dynamics calculations. The post-shock StS simulations using the present database agree with the experimental NO infrared radiation. Based on this updated StS kinetics database, we investigate the post-shock high-enthalpy air flows by employing both the StS and coarse-grained models (CGM). The CGM, which lumps molecular vibrational states into groups, shows results that align with the StS model, even utilizing only two groups for each molecule. However, the CGM-1G model, with only one group per molecule and belonging to the multi-temperature model (but uses StS kinetics), fails to reproduce the StS results. Analysis of vibrational energy source terms for different kinetic processes and fractions of vibrational groups reveals that the deficiency of the CGM-1G model stems from the overestimation of high-lying vibrational states, leading to higher dissociation rates and increased consumption of vibrational energy in dissociation. Furthermore, the presence of the Zeldovich-exchange processes indirectly facilitates energy transfer in N2 and O2, a phenomenon not observed in binary gas systems. These findings have important implications for developing the reduced-order model based on coarse-grained treatment.