Marianne and * Spark* by Tori Amos, along with everything else by her
Goodnight Saigon and anything else by Billy Joel
- I Guess that’s Why They Call it the Blues* and Can You Feel The Love Tonight by Elton John
I personally have a weakness for rock songs with dirty piano, such as The Who’s “Long Live Rock” and David Bowie’s “Suffragette City”.
On the Leonard Cohen tribute CD I’m Your Fan, John Cale does an absolutely astounding cover of “Hallelujah.” Just Cale and his piano. It’s the only song on the CD I would call a piano song-where the piano is the focus-but the rest of the songs are great as well. It’s one of those CDs I wish everyone in the world could hear at least once.
The Rolling Stones’ “Angie”.
IIRC, the album version of The Moody Blues’ “Tuesday Afernoon” has a nice, long piano solo at the end.
‘waiting for the man’ - Velvet Underground and Nico.
L.A. WOMAN!!!
(Mr. Mojo Risin’…)
A third vote for Elton John’s “Funeral For a Friend/Love Lies Bleedin’.”
And another vote for the Beatles.
If you can find it, Al Kooper does a great extended version of “Baby Please Don’t Go” (from the album “Easy Does It”) with some great piano work in it.
You might also want to check out a rather obscure composer named Conlon Nancarrow. 
Thomas Dolby does have some good keyboarding skills.
Dammit, people already beat me to Tori Amos and Ben Folds Five…I’ll add Nine Inch Nails to the list though, but only for The Fragile. The other NIN albums aren’t as piano-ey as The Fragile. If that makes sense.
The Kick Inside & “This Woman’s Work” - Kate Bush
“Someone Saved My Life Tonight” - Elton John
“Evil Woman” - ELO
“Homeward Bound” - Fleetwood Mac (it’s from the album, Bare Trees (and most anything played by Christine McVie)
“Back in the USSR” - Beatles (that’s Nicky Hopkins playing, BTW)
Lots of Billy Joel
The aforementioned Tori Amos stuff, especially “Winter”
The Beatles’ A Day in the Life: Remember that single chord at the end? Fitting ending to a not too shabby album.
Country Comforts by Rod Stewart (cover)
Have a Little Faith in Me by John Hiatt
This Song is Over by the Who
Gettin’ in Tune by the Who
At My Most Beautiful by R.E.M.
Games People Play by the Spinners
Good for You by Hothouse Flowers
Queen of Pain by Alanis Morissette (Unplugged)
Tupelo Honey by Van Morisson
Old Old Woodstock by Van Morisson
Be Thou My Vision by Van Morisson
Carrying a Torch by Van Morisson
Queen of the Slipstream by Van Morisson
In the Garden by Van Morisson
Backstreets by Bruce Springsteen
I’ll have to enthusiastically agree with Odieman that Bruce Springsteen has produced some wonderful rock music with great piano. In particular, the entire Born to Run album has some great tracks, including “Meeting Across the River” and “Jungleland”. I’ll also be the umpteenth person to mention Elton John’s “Love Lies Bleeding/Funeral for a Friend.” an interesting tidbit about that song… an excellent cover of that song has been released by the band Dream Theater on their album “A Change of Seasons.” Anyone who likes Elton John should listen to this version of that song. A few other songs with piano/keyboard:
[list]
[li]Carry On Wayward Son, by Kansas[/li][li]Roll With the Changes, by REO Speedwagon[/li][li]Drowning, by Joe Jackson[/li][li]Getting in Tune, by The Who[/li][li]Whiter Shade of Pale, by Procol Harum[/li][li]21st Century Schizoid Man, by King Crimson[/li][li]I’d Do Anything for Love, by Meatloaf (please excuse me for mentioning this one… I don’t listen to it much, I swear!)[/li]
A lot of other stuff by the same people is also pretty good. Some people that other folks have mentioned already (Billy Joel, Elton John, The Band, ELP, etc) I didn’t add because that would just be repetative now, wouldn’t it. That’s why I didn’t talk about Billy Joel, Elton John, The Band, ELP, etc.
Something in the air - Thunderclap Newman
Riders on the storm - The Doors
Cast your fate to the wind - Sounds Orchestral
To those who know their stuff, and those who don’t,** Nat King Cole**, he could’ve made a huge name just on his piano playing alone.
Anything with Chuck Leavell in it.
He plays on several Stones records, including Steel Wheels, Stripped, Dirty Work, Undercover, Vodoo Lounge, etc. You can also find him on Blues Traveler’s Four, on several Allman Brothers discs, and on the Black Crowes’ Shake Your Moneymaker.
He also has an album out titled *What’s in That Bag ** I haven’t heard it, but CDNow seems to indicate it’s a Christmas album. Chuck is certainly one of the best rock keyboard stylists around.
Another guy who kicks some serious ass is ** Gonzalo Rubalcaba**. That is, if you’re into Cuban jazz. This guys is seriously insane on the ivories. Piano is his third instrument after drums and violin, and he originally came from a classical background. His technique is incredibly clean, his timing impeccible, and plays with great feeling both slow and fast. Everytime I listen to him, he sends chills up my spine. Go to CDNow.com and have a listen, if jazz is your thing. I think he is one of the greatest living pianists of any genre. Please, give him a listen.
If you’re into New Orleans-style piano, Dr. John’s all right, but head a generation back to his teacher, Professor Longhair for some wicked riffs. Also A.J. Croce’s pretty cool, too.
Greg Phillinganes is probably one of the most accomplished sessionists around. You can find his contributions on Eric Clapton’s Journeyman, as well as working with artists such as Venessa Williams, Michael Jackson, Stevie Wonder, Bela Fleck and the Flecktones and, God forbid, Kenny G.
Hope this helps.
Almost forgot:
“I Don’t Like Mondays” - Boomtown Rats
“Lolly, Lolly, Lolly, Get Your Adverbs Here” - Bob Dorough
Hell, nearly all the Schoolhouse Rock songs.
I’ve gotta agree with RealityChuck on Nicky Hopkins work on Edward The Mad Shirt Grinder. Nicky was a piano player that added so much to the recordings of many groups yet got very little attention. His style was so distinctive & driven, that you could usually tell it was him even before reading the credits. When I went to see the Jeff Beck Group with Rod Stewart in '68, the biggest thrill was getting to see Nicky Hopkins. (By the way, I’ve pretty much hated Rod Stewart since then until I heard Pete Townshend say that Rod had quietly been paying Ronnie Lane’s medical bills for years after he was stricken with MS. I still hate his music, but admire his loyalty & kindness.) I also saw Nicky play with Jefferson Airplane & Quicksilver Messenger Service. Alas, he’s gone off to play with the other rockers in Heaven’s Jam Band. But by all means check out Quicksilver’s Edward The Mad Shirt Grinder and track down anything else he played on and you won’t be disappointed.
Two other piano players I would recommend you see play live if you can would be Allen Toussaint and Billy Payne of Little Feat. Make sure you get a seat where you can see their hands on the keyboard then sit back and be amazed.
A great piano solo, albeit hard to find, would be in the song No Big Deal by Ambrosia, off their album/cd One Eighty.
Chris W
I have to second Lynyrd Skynyrd. Billy Powell is a great piano player. Listen to “I Know a Little” - awesome piano work on that.
Another second for “Jessica” by the Allman Brothers.
And yet another second for Warren Zevon. He is classically trained, and studied under Igor Stravinsky. Almost all his music features very complex piano parts.
I believe Nicky Hopkins played piano on the Rolling Stones’ “She Comes in Colors.”
Here are a few more piano songs:
Handbags and Gladrags by Rod Stewart
Morning Song by Jewel
You’ve Really Got a Hold On Me by Smokey & the Miracles (and also the Beatles)