In Duke Nukem Forever for the PS3 and Xbox 360, you get the “Sunday, Black Sunday” achievement / trophy by shooting down a blimp.
You’ll find the blimp in the Duke Lives chapter near the beginning in the background. Shoot it down to get your achievement / trophy.