Ok probably you're a bit too soon but there are plans to operate sightseeing flights from Galway which is near enough to Clare, unfortunately not this year.
However there are now two possible options. One is the National Flight Centre (NFC) which is in Dublin. But the other and possibly more interesting is http://www.harbourflights.com/
" onclick="window.open(this.href);return false; They are operating scenic flights based on the NFC AOC in Mountshannon County Clare.
They currently operate a C172 amphibian. Rumour has it that a C206 is on the way.
Mountshannon is a particularly pretty spot.