I too mourn the passing of the Leuchars Airshow, first flight ever was there as a lad in the 60's in a C172 and probably led to my decision to join the RAF.
As to its replacement, perhaps an enterprising Edinburgh City Council could follow the success of Bournemouth, Sunderland and Blackpool and put on a 'free' seaside airshow at somewhere like Portobello, say around the 18th of September next year