Thunderpants (2002)
Thunderpants is a 2002 family film about a boy whose incredible capacity for flatulence gets him a job as an astronaut. The film was directed by Pete Hewitt, whose previous work included Bill & Ted's Bogus Journey (1991), and The Borrowers (1997). The script was written by Phil Hughes, based on a story by Peter Hewitt about a boy who dreams to be a spaceman, but has a problem with flatulence.
More at Wikipedia.