There are plenty of community campaigns around as well as the DCG freeware campaign generator
Campaign generator (lets you choose among other things the type of plane you can fly):
http://www.lowengrin.com./news.php
Good sites for scripted campaigns and missions and skins:
http://mission4today.com/index.php
http://www.netwings.org/
http://www.flying-legends.net/