Someone PM'd me asking for specific info, so I thought I'd just post it here for general reference.
Firstly I ordered off of Superbrightleds.com so these sizes etc are exactly as I ordered from their website. http://www.superbrightleds.com/mini-wedge.html
Type of LEDs used (ALL 194 type):
Maplights AND license plate (both use the same led): WLED 6-LED Bulb, 4 for maps lights and 2 for license plate @ $3.74 each.
Courtesy Door Lights (only the front doors have lights incase you didn't notice): WLED 5-LED Wide Angle LED bulb, 1 for each door @ $3.94 each.
Total Cost: 6 WLED 6-LED Bulbs for $22.44
2 WLED 5-LED Bulbs for $7.88
+ $5.00 Shipping
TOTAL = $35.32
How to install license plate light:
Just pop of the plastic covers. There are two plastic latches on either side of the plastic cover, just use a flat head and pry them off and pull the plastic cover off, should come off fairly easily.
Then you pull the bulb straight out. My roommate came up with a nifty trick since we were having trouble gripping it (hands are too sweaty). Just wrap a piece of electrical tape around it and it's easier to pull them out. Note: It was humid as hell and we couldn't grip onto the bulb for anything without the tape.
Then just insert the 6-LED bulbs into each side and replace the plastic covers so they snap back into place.
For the door lights, simply use a flat head screwdriver and pop them right off. Here's a picture from the other thread.
Pull out the old bulbs and replace with the 5-LED bulbs.
For info on the map lights go to this thread. http://forum.mazda6club.com/index.php?showtopic=7530