I think it is on either Gamecube or PS2 (maybe even N64 but I don't think so), but don't remember for sure. It is from that era though. Anyways, so it had this mission where you flew around in a makeshift propeller airplane and you were flying around a farm where there were a bunch of tornadoes wrecking stuff. I think you had to shoot down airships that were creating the tornadoes but I'm not 100% sure. I legit don't remember anything else about the game and I don't think any of the other missions involved flying. Total shot in the dark here but does this ring a bell with anyone?