We (at Exyst) have recently launched an Adobe AIR application called DataSpear. DataSpear is a modernized replacement for a Random Access Database system written around 15 years ago. The application does real time automatic syncing with other users changes from a server application written in CakePHP.
My role on this project, in the beginning, was User Interface designer, and Server API development. Halfway through the project I was moved up to development lead and completed the programming. My contributions to the final development was improved system performance, automatic syncing with the server app, and offline access.
The application is not available to the public, however I am planning on taking what I have learned to develop publicly available AIR apps in the future. Definitely a good learning experience, and I look forward to working with Adobe AIR again.