Hello sorry to hear about your son. The good news is that you caught it early! I have very mild scoliosis that was somehow missed when I was younger and was caught just this year at the age of 25! (which is a big problem since I've stopped growing!) There a lot of things that can be done to stop the curve from progressing at your sons age, I don't know if it ever go back to "normal" without surgery though. (surgery usually isn't done unless the curve is very severe from what I understand)
A few treatment options are bracing and/or physical therapy. I know PT has helped me a lot. You do very specific exercises to help straighten the curve out and also build up your upper back muscles. They will also teach your son how to have better posture! Mine was all over the place until I started PT and learned how to sit without leaning over so much.
Like you said, it is very common in teenage boys. If the curve isn't that severe right now the drs may just want to watch it and moniter it over a period of time to see what happens. I don't think it will hinder his airforce dreams as long as you just keep an eye on it. I know a lot of people live perfectly normal lives with scoliosis and you'd never know that they had it unless they told you. Good luck to you and your son