Most of what is widely available are the tissue culture plants from one of the major suppliers - white jade, elite gold, Florida special, smooth cayenne, and sugarloaf. I have these. I think not many people on the forum are interested in other varieties of pineapples because md-2 (most grocery store pineapples) is considered superior to the other varieties and it's so easy to get one. The ARS has an extensive collection in Hawaii that you can request small tissue culture plants from if you want some of the rare types. I keep meaning to do this.
There is an edible red variety called Red Spanish that is widely planted in other countries. I've never seen one in the US though. I think I read it tends to be a smaller fruit than md-2, but is supposedly a more durable plant. Not sure about green though.