For a little more explanation:
AF = AirFlow. It pushes a large volume of air, but doesn't push it very hard. Great for moving air from one place to another when there's nothing in the way. Put something in the way, however, and because the air isn't being pushed very hard, it reduces the airflow a LOT.
SP = Static Pressure. It pushes a smaller volume of air, but pushes it harder. Great for moving air past a surface to remove heat, as it forces the air through obstacles. Less air to start with, but it reduces by a much smaller amount than AF if you have resistance.
Which, as Resident says, makes the AF series good for pulling air into/out of the case to keep the air inside as fresh/cool as possible; and the SF good for pushing air through radiators, heatsinks etc.
If you read reviews of other products you'll see Static Pressure and Airflow readings, so you can tell what they are best used for, but Corsair make things easy by labelling them for you.
If in doubt, I'd go for SP for anything except a grill-only exhaust. Push the air in hard (SP), push it through the heatsink/radiator hard (SP), then exhaust it fast (AF).
It depends on your setup, but for the most part don't sweat it, fans don't make a huge amount of difference. It's worth getting the best you can find/afford, because there are differences in price/performance/sound, but not so much that fans can usually make/break a rig.