Here are some links:

FDA approved drugs by month:

http://www.accessdata.fda.gov/scripts/cder/drugsatfda/index.cfm?fuseaction=Reports.ReportsMenu

Drugs in Clinical trials:

http://clinicaltrials.gov/