Nintendo software planning and development
SPD 1 (2d metroid/warioware team)
made: metroid fusion, metroid zero mission, warioware twisted/Touvhed!/Smooth moves
making: card hero DS(and hopfully another 2D metroid)
SPD2 (puzzle team)
made: Tetris DS, puzzle planet league, Dr mario
making: unknown
SPD3 (team for monitoring second party and overseas games)
helped make: battalion wars series, Geist, metroid prime series
helping make: has several unknown projects. im guessing one of them is the conduit
SPD 4( wii channel team)
made: voting channel, nintendo channel, mii contest channel
Nintendo Entertainment Analysis and Development
EAD1 ( mario kart team)
made: mario kart double dash/ DS/ Wii, nintendogs
making: unknown
EAD2 (casual team)
made: wii sports, wii play, animal crossing
making: wii music, wii sports resort (maybe animal crossing wii)
EAD3 (ZELDA TEAM FTW)
made: basically every zelda game ever made including four swords and crossbow training
making: zelda wii
EAD4 (MARIO TEAM FTW)
made: super maio advance 1/2/3/4, super mario 64 DS, brain training, new super mario bros
making: new mario game (maybe)
EAD 5(worst team to be in)
made: wii fit
making: unknown
EAD software (galaxy team)
made: jungle beat, super mario galaxy
making: could be making new mario
one of those teams is probably the pikmin team miyamoto refers to but we dont no which one because of the reshuffle
Intelligent systems
made: fire emblem GBA/DS/Wii, advance wars series, paper mario series
Consolidated
Retro Studios
made: metroid prime series
making: an unknown game
Monolith Soft
made: Baten Kaitos series, Xenosaga series
making: Disaster:day of crisis (most likely another project as well)
Nintendo software technology ( USA based first party team)
made : 1080 avalanche, metroid prime hunters, mario vs donkey knog
making: Project H.A.M.M.E.R (if reconfirmed rumours are true)
other projects
Second Parties
Game Freak: The Pokemon Series. No other known plans.
HAL Laboratories: Super Smash Brothers, Kirby and EarthBound (you managed to forget this?)
Skip: Captain Rainbow, Chibi robot
Good Feel: wario land shake it
(Factor 5): one wii game (rumoured to be Kid Icarus)
Techmo: fatal frame IV. and rygar/techmo bowl although they are self published
Camelot:mario sports series ( rumoured new golden sun or shining force for wii)
Headstrong games: battalion wars series, now making house of the dead for sega
I made it a bit more readable, and added some stuff.
http://www.vgchartz.com/games/userreviewdisp.php?id=261
That is VGChartz LONGEST review. And it's NOT Cute Kitten DS