For a while now I've been spending my spare time writing about AIR for an upcoming book titled "Adobe AIR in Action" published by Manning.
I've had the pleasure of working with three very talented co-authors, Joey Lott, Sam Ahn, and Kathryn Rotondo. I'm psyched about the release since I think we've put together a very solid guide to Adobe AIR from a Flash and Flex perspective, and we've come up with some great examples that utilize each individual aspect of the new API.
My chapters are centered around utilizing databases in your AIR application, including some primers on SQL, and integrating HTML and JS content into your app.
The book will be released in a few months, but if you can't wait that long, you can actually read chapters in their 'uncut' format in Manning's Early Access Program. You can also pre-order the book on Amazon, here.