I don't know in general any flute playing bands besides Jethro Tull (highly recommended -- check out the recent remaster of
Stand Up with the classic, "Bouree'") and PFM, but here's a couple albums that contain some flute playing in at least one of the songs:
Golden Earring -
Moontan (don't remember which track, but I know it's one of the two on side 2; there's an import remaster)
Nightwish -
Wishmaster (one of the songs has a flute solo)
Joe Walsh -
You Can't Argue with a Sick Mind (Jay Ferguson has a memorable solo during my favourite version of his signature song, "Turn to Stone")
If you want some tango/classical flute playing, there's an Astor Piazzolla record with a flautist featured prominently, I forget the name of it, though, sorry.
History of something? No, he's got something else entirely different called "History of the Tango", that's not it. Hold on...alright, it
is called
Histoire du Tango, but make sure you get the right version, I think the cover was white with a girl (the flautist) featured prominently, and a guy further in the background...let me know if you want me to look for it...otherwise will leave it at that...