I use my company issued photo ID when I fly within the US. No one has ever said anything about it or asked for anything else. It makes no claim to being in any way official or government issued. I'm really important (not) so mine has a red border. It has a pin click so I can wear it. A really big deal!
At about any flea market in Texas you can get a photo ID made for a few bucks. I'm thinking of getting a variety of them. Queen of England for a start.
To answer the question: haven't tried to use my COSCO card as yet.