Go to Modjive.com, and download the Modjive application...you can use that to obtain all the major mods.
If you want to get rid of the red maps, click the 'same mod' filter below the server list, but bear in mind this will also stop you seeing SF servers while in normal BF2 and vice versa