according to another CEGr, Tom, Vachon has one in red.
Wellesley Mazda has only one Miata and its a base model, drove by it today.
Mazda Gallery has about 7 2005s and 3 2004s. the 04s are grey/cloth (the one i almost bought), red/cloth, and red/leather. the 2005s are orange/leather (x2), black/leather (x2), and red/leather (x3)
I'll look into Vachon, Grappone, Ira, Sentry, and Talarico.
Thanks Ryan! I think Ira or Grappone will be my best bets because they have access to Nissan/Infiniti internally or do a ton of volume and will be able to resell the G20 without having to go wholesale.