Non-aquatic plants that are marketed as aquatic

Aluminum Plant (Pilea cadierei)
Arrowhead (Syngonium podophyllum)
Baby Doll (Cordyline terminalis)
Bamboo Plant (Bamboo sp.)
Black Pagoda (Aeschynanthus parasiticus)
Borneo/Underwater Fern (Trichomanes javanicum)
Brazilian/Borneo Sword, Peace Lily (Spathiphyllum tasson)
Cardinal Flower (Lobelia cardinalis)
Chameleon Plant (Houttuynia cordata)
Chinese Evergreen (Aglaonema simplex)
Compact/Red Dracaena (Cordyline sp.)
Dragon Flame/Tongue (Hemigraphis repanda)
Dumb Cane (Dieffenbachia sp.)
Elephant Ear (Caladium sp.)
Green/Red/Gold Hedge (Alternanthera sp.)
Japanese Rush (Acorus sp.)
Kelantan Swordplant, Malayan Sword, Silver Queen (Aglaonema sp.)
Lucky Bamboo, Sandy (Dracaena sanderiana)
Mondo Grass, Kyoto Dwarf, Fountain Plant (Ophiopogon japonica)
Neanthebella Palm (Chamaedorea elegans)
Nerve Plant (Fittonia argyronanta)
Peliosanthes (Peliosanthes sp.)
Pickerel Weed/Rush (Pontederia cordata)
Pineapple Plant (Dracaena compacta)
Pongol Sword (Chlorophytum bichettii)
Pothos (Philodendron sp.)
Prayer Plant (Maranta leucoreura)
Princess Pine (Lycopodium obscurum)
Purple Waffle/Temple/Krinkle (Hemigraphis exotica, Hemigraphis colorata)
Scarlet Hygro, Alligator Weed (Alternanthera sessilis) -- However, Alternathera reineckii IS true aquatic!
Schismatoglottia (Schismatoglottia sp.)
Spider Plant (Chlorophytum bichetii)
Stardust Ivy (Syngonium sp.)
Sweet Flag (Acorus calamus)
Umbrella Pine (Sciadopitys verticillata)
Umbrella Plant (Cyperus alternifolius)
Underwater Fern (Selaginella wildenowii)
Underwater Palm, Coconut Plant (Calamus sp.)
Underwater/Ground Pine, Club Moss (Lycopodium sp.)
Variegated Dracaena, Green Dracaena (Dracaena sp.)
White/Pink Lace (Melaleuca thymifolia)

*General rule of thumb: True aquatic plants are usually droopy and can't stand up straight when out of water (unless it's very small). However, there are exceptions like Anubias.

NOTE: Most of these are bog plants or marginals (live close to water), and some of them will survive much better if the leaves are kept out of water. If you have any questions or comments regarding this list please let me know.



Sources:
http://faq.thekrib.com/plant-list.html
http://www.myfishtank.net/reviews/showproduct.php/product/175/sort/7/cat/21/page/1
http://www.wetwebmedia.com/AqBizSubWebIndex/nohsepltsbiz.htm
http://www.frankmgreco.com/plantsno.htm