Very interesting findings, Milian! Excel can do wonders to a database, just recently I did a bit work on Mark V and MkIX operations in `42. Well, as much as the MkIX is celebrated being introduced in mid42, in reality it flew only a handful of sorties in that year, MkVs flying the vast majority and the combat effectiveness (kills/sortie, losses/sortie) of the two types don`t differ at all. Moreover, appearantly they couldn`t claim a single Bf 109 during the whole of 1942, it was a bit one sided.
The vast majority of engagements were with FW 190s however. I`d happily send over the XLS if you are interested!
Your findings regarding the MkXIV very much agree what I found. Production was terribly slow, the first Sqn to begin to equip with them in Jan 1944 did not complete the conversion until THREE months passed, and did not see action until May... appearantly their operational use was limited to a few sorties in May-June, then they went shooting target drones on high boost, reverting to normal boost in September and transferring to the continent, where appearantly they again saw little action until the Ardennes offensive, and some action on varying scale in 1945. Alltogether, not much - the vast majority of fighters were still MkIXs in 1945.
And then it seems that the Belgian Squadron 350, and 610 Squadron, along with 402 and 130, then 2 and 41 squadrons, were really the only ones to see any action. Well, considering you have listed practically all RAF Sqns in WW2 that received MkXIVs...
Yep, a mere 6 Sqns, plus one recce unit with a mixed Allison Mustang/FRXIV combo.
I wonder if you have similiar info on MkIX production (ie. per month/delivered)? I suppose that would be equally interesting.