Johnny Knoxville's riotous comedy Bad Grandpa has ended George Clooney and Sandra Bullock's reign atop the U.S. box office.

The film, in which Knoxville serves up pranks as an irreverent old man aided by nine-year-old child star Jackson Nicholl, raked in $32 million (£21.3 million) in its first weekend on release, and took over at the top from Bullock and Clooney's space drama Gravity, which has edged close to a $200 million (£133.3 million) take since its 4 October (13) opening.

Tom Hanks' Captain Phillips takes third place on the new box office countdown, while Ridley Scott's star-studded drama The Counselor, which features Cameron Diaz, Javier Bardem, Penelope Cruz, Michael Fassbender and Brad Pitt, debuts at four with a disappointing $8 million (£5.3 million).

Cloudy with a Chance of Meatballs 2 rounds out the new top five.