According to Box Office Mojo, here is how the Bond movies rank according to box office revenue in the US (although Casino Royale wins the worldwide total $594.2 million to $586 million):
Quantum of Solace $168,368,427
Casino Royale $167,445,960
Die Another Day $160,942,139
The World Is Not Enough $126,943,684
Tomorrow Never Dies $125,304,276
GoldenEye $106,429,941
Moonraker $70,308,099
Octopussy $67,893,619
Thunderball $63,595,658
Never Say Never Again $55,432,841
For Your Eyes Only $54,812,802
The Living Daylights $51,185,897
Goldfinger $51,081,062
A View to a Kill $50,327,960
The Spy Who Loved Me $46,838,673
Diamonds Are Forever $43,819,547
You Only Live Twice $43,084,787
Live and Let Die $35,377,836
License to Kill $34,667,015
From Russia, with Love $24,796,765
On Her Majesty's Secret Service $22,774,493
The Man with the Golden Gun $20,972,000
Dr. No $16,067,035