Some video of what I believe to be the final Air Day to take place at RNAS Lee-on-Solent on 11th July 1992. The weather was rather low and moist which kept the displays very much in the horizontal plane.

Featured displays were by Fleet Air Arm Lynx HAS.3, Sea King HC.4 and Sea Harrier FRS.1, Royal Air Force Tornado, a privately owned ex-Swiss Air Force Vampire T.55, a group of Tiger Moths and what looks like a Lada.

I can identify the following aircraft in the video, despite not being able to find my notes of the day:

Flying:
BAe Sea Harrier FA.2 - ZD578 "715" of 899 Squadron FAA, now gate guardian at RNAS Yeovilton
DeHavilland Vampire T.55 - U-1230, ex-Swiss Air Force, now based in Norway

Westland Lynx HAS.3 - Fleet Air Arm
Boeing-Vertol CH.47 Chinhook HC.1 - Royal Air Force
Westland Sea King HC.4 - Fleet Air Arm
Panavia Tornado GR.1 - Royal Air Force
Three DeHavilland Tiger Moths


On the ground:
Fairy Gannet T.5 - XG888 - FAA Museum Collection, now on display in Australia
Fairy Gannet AEW.3 - XL500 - FAA, stored, now undergoing restoration at St.Athan
Lockheed C.130K Hercules C.1P - XV192 "192" of the Lyneham Transport Wing - scrapped in 2005
PZL AN-2T - G-BTCU "77", originally a Polish Air Force aircraft, painted in fake Soviet DOOSAF markings
Bristol Sycamore HR.12 - WV783 - RAF Museum Collection, now on display at Hendon
Britten-Norman BN-2B Islander - G-HPAA, operated by Hampshire Constabulary until 2001
Several Westland Wessex HU.5 are visible in the background of some scenes, these were retired airframes allocated to HMS Daedalus Air Engineering School.

[VHS source]