In this article, they found that ~10% of surveyed Americans used prescription painkillers in the last 30 days, including ~6% on narcotic analgesics.

Trends in Prescription Drug Use Among Adults in the United States From 1999-2012 E. Kantor et al., JAMA 2015

http://jamanetwork.com/journals/jama/fullarticle/2467552