I'll summarize for you.

I'm the classic gifted underachiever, but now I've decided to get my ass in gear and work towards either aerospace engineering or medicine. Trouble is, I can only start with community college and I need to learn good study habits. What do you advise in terms of colleges and in terms of getting into a good school.

I don't know anything about getting into med school, but I think you want to first decide whether engineering or medicine are your preferred option. In terms of learning how to study and applying yourself, I found that once I was motivated by the end goal and more mature (about 25) I could buckle down and ace everything, despite never being able to manage homework before.

Good luck!