Call of Duty: Modern Warfare II.
However, you don’t play a terrorist. In the airport scenario “No Russian” you’re an American operative who’s killed at the end of the end of the level, allowing the Russian mafia who orchestrated the attack to fool the Russian government into believing that it was an attack by the United States government. It sets up the pretext for an imagined Russian invasion which is central to the story line where you kill a gazillion Russians with a variety of weapons.
Thanks for the info. Sounds pretty cool, actually.