This!
Bought the above book with my DSLR and it is worth its weight in gold. I went straight to using manual mode and I honestly can't see why anyone would buy a DLSR only to use it like a compact, leave the auto mode alone and go a find out what you and your camera can really do. You'll be surprised how easy the basics are. Aperture and Shutter priority modes have their place, but the full auto modes are the spawn of Satan.
The technical stuff is easy imho, it's the composition and artistic aspects that take time to master.
I agree with that but some of the other modes will be extremely useful for what phil wants to actually use the camera for. S mode with direct control over the shutter speed will probably be best for the airshow as the amount of light going into the lens will vary massively depending on where you point the camera in relation to the suns position, especially when your trying to take a photo of a flying plane. You need a fast shutter speed to get a decent plane picture in motion anyway so that setting would make more sense than going full manual and probably coming home with hundreds of useless photos.