There are currently two AirHockey games on the App Store. We HIGHLY recommend the two-person game by Sea Lion Games.
To play, you hold the iPhone flat and both players control a knob on one side of the phone, pushing the puck around on the virtual air hockey surface.
This game is a ton of fun to play, and well worth the $2.99. The only way it could be improved would be by being free.