I used a CD to file my return. I had to mail it due some issues trying to e-file. The IRS is saying they never got my return. How do I pull it up with or without the CD?

Your tax file is not stored on the CD.  If you used desktop software the tax file is on your own hard drive or any back up device you used like a flash drive.

https://ttlc.intuit.com/questions/1901659-find-your-tax-data-file-in-mac

https://ttlc.intuit.com/questions/1900721-find-your-tax-data-file-tax-file-in-windows

When you mail a tax return, it is a good idea to use a mailing service that will track it like UPS or certified mail.  Then you will know the IRS received it. When you mail your tax return, wait about 4 weeks and then check the IRS site: 

https://www.irs.gov/refunds

The tax file is usually stored in Documents in a TurboTax folder. If you saved a pdf copy, you don't need the TurboTax program installed on your computer to open it and print it. If you only saved a .tax file, you need the TurboTax program installed on your computer to be able to open it and print it.  Search your Documents file or do a search using the search feature on your computer. You don't actually need the CD if you left the program installed on your computer after preparing your return. 

Did you do a state return too?  You didn't happen to mail both federal and state in the same envelope to the state?  When you mail it again be sure to get a tracking number from the post office so you know they got it.