Geoffrey Sinclair
Staff Sergeant
- 931
- Sep 30, 2021
Trying again after spending some more time untangling the file. Air 22/268, Middle East Command Aircraft state, several pages per month, the file to find out how many Harvards, Valettas and other types were around as well as the combat forces. S.H.Q. Ismailia had a Do17 being returned to a Maintenance Unit for example. Unfortunately some months are missing, some pages are out of order and the number of squadrons is not given. Miscellaneous units include the PRU. Not all the combat units listed below were in the desert.As I understand this, could be wrong.
July 1st.................................103 Kittyhawks (1 and 1A) something as establishment drop from 178 to 112, but actual strength only dropped two planes, change in paper strength or wrong word?
Sept 1st ............................... 101 Kittyhawk Is, 11 Kittyhawk IIs (P-40Fs), 4 Kittyhawk IIIs (P-40Ks)
Oct 1st ...................................57 Kittyhawk Is, 19 Kittyhawk IIs (P-40Fs), 59 Kittyhawk IIIs (P-40Ks)
Strength as of 30 June, plus arrivals and losses for June
Hurricane Total establishment of 192 in the fighter and 54 in the Army Co-operation squadrons, 76 in the OTU's and 32 miscellaneous, total 354. Strength in the units 129 I and 185 II, total 324 of which 90 I and 126 II, total 216, were serviceable, there were another 144 I and 158 II in the repair system, arrivals 4 I and 73 II, losses 5 I and 37 II.
Kittyhawk. Total establishment 160 in the fighter squadrons and 18 miscellaneous, total 178, Strength in the units 103, of which 68 were serviceable. There were another 228 in the repair system, arrivals 55, losses 63.
Spitfire Total establishment 128 including miscellaneous, strength in the units 2 I and 34 V of which 21 V were serviceable. There were another 16 V in the repair system, arrivals 41 V, losses 5 V.
Tomahawk Total establishment of 32 in the fighter squadrons, 90 in the OTU's and 6 miscellaneous, total 128. Strength in the units 46 of which 25 were serviceable, there were another 237 in the repair system, arrivals none, losses 31.
Strength as of 30 September, plus arrivals and losses for September, training unit totals now separated
Hurricane Total establishment of 248 in the squadrons, Strength 64 I and 309 II, total 373 of which 40 I and 267 II, total 307, were serviceable, there were another 84 I and 206 II in the repair system, arrivals 1 I and 116 II, losses 8 I and 51 II.
Kittyhawk. Total establishment 112 in the squadrons, Strength 101 I, 13 II and 4 III, total 118, of which 95 I, 13 II and 4 III were serviceable, total 110. There were another 235 I, 9 I and 31 III in the repair system, all marks arrivals 74, losses 41.
Spitfire Total establishment 96 in the squadrons, strength 57 V of which 47 were serviceable. There were another 46 V in the repair system, arrivals 13 V, losses 19 V.
Tomahawk Total establishment of 64 in the fighter squadrons, Strength 21 of which 20 were serviceable, there were another 104 in the repair system, arrivals 2, losses 13.
Strength as of 31 October, plus arrivals and losses for October.
Hurricane Total establishment of 298 in the squadrons, Strength 47 I and 317 II, total 364 of which 35 I and 278 II, total 313, were serviceable, there were another 86 I and 314 II in the repair system, arrivals 2 I and 107 II, losses 38 II.
Kittyhawk. Total establishment 112 in the squadrons, Strength 47 I, 19 II and 59 III, total 125, of which 39 I, 13 II and 57 III were serviceable, total 109. There were another 257 I, 32 I and 18 III in the repair system, arrivals 1 I, 47 II, 67 III, losses 16 I, 2 II and 7 III.
Spitfire Total establishment 80 in the squadrons, strength 66 V of which 58 were serviceable. There were another 38 V in the repair system, arrivals 31 V, losses 12 V.
Tomahawk Total establishment of 34 in the fighter squadrons, Strength 19 of which 17 were serviceable, there were another 104 in the repair system, no arrivals, losses 4.
Air 22/401 is a daily tally of fighter sorties by type and mission, 39 columns of data for the October and November 1942 reports. As a control it has 1,748 P-40 sorties, the 9th Air Force Operations Summary says 1,829, there were 110 sweep sorties on 5 November by unknown aircraft types which easily accounts for the difference in the RAF and USAAF records. All up 15,692 sorties though the report total is given as 15,689. If you define the air battle dates as 24 October to 4 November, on those 12 days, 7,549 sorties.
Day sorties totals by mission
5,739 Sweep, 2,359 Bombing, 1,193 Strafing, 1,705 Shipping protection, 4,493 Bomber Escort, 185 Defensive/Rescue, 19 Anti Shipping, sorties by aircraft type 1,951 Spitfire, 4,845 Hurricane, 5,934 Kittyhawk, 819 Tomahawk, 227 Beaufighter, 58 Fulmar, 1,748 P-40. Hurricanes did the most sweeps, 2,137 sorties and almost all shipping protection 1,397 sorties, Kittyhawks the most escort, 2,228 sorties, bombing, 1,778 sorties and strafing, 462 sorties.
For all its obsolescence Tomahawk, 240 Sweep, 35 strafing, 40 Shipping protection, 504 escort sorties.
Night missions, 364 night offensive, 148 night defensive, 485 Hurricane, 27 Beaufighter. Not much mention of these in the histories.
British Archives AIR 20/1929 operational hours, Middle East.
Aircraft | Jan-42 | Feb-42 | Mar-42 | Apr-42 | May-42 | Jun-42 | Jul-42 | Aug-42 | Sep-42 | Oct-42 | Nov-42 |
Baltimore | 0 | 0 | 0 | 0 | 214 | 420 | n/a | 446 | 737 | 1508 | 1115 |
Beaufighter | 442 | 625 | 967 | 714 | 652 | 947 | n/a | 1697 | 1211 | 1127 | 927 |
Beaufort | 0 | 82 | 326 | 312 | 80 | 347 | n/a | 285 | 28 | 102 | 24 |
Blenheim | 1535 | 676 | 388 | 435 | 304 | 514 | n/a | 960 | 1038 | 630 | 600 |
Bombay | 0 | 0 | 0 | 0 | 0 | 0 | n/a | 217 | 374 | 566 | 258 |
Boston | 0 | 11 | 91 | 27 | 63 | 0 | n/a | 0 | 845 | 737 | 446 |
Catalina | 0 | 0 | 0 | 0 | 0 | 0 | n/a | 119 | 529 | 64 | 27 |
Fortress | 30 | 39 | 0 | 0 | 0 | 0 | n/a | 0 | 0 | 0 | 0 |
Halifax | 0 | 0 | 0 | 0 | 0 | 0 | n/a | 1093 | 664 | 335 | 484 |
Hudson | 0 | 0 | 17 | 28 | 0 | 275 | n/a | 714 | 939 | 1265 | 836 |
Hurricane | 2845 | 1871 | 1901 | 2695 | 2562 | 3652 | n/a | 3580 | 4047 | 4645 | 4530 |
Kittyhawk | 769 | 633 | 879 | 790 | 1723 | 3036 | n/a | 1332 | 1801 | 4505 | 4421 |
Liberator | 0 | 0 | 0 | 0 | 0 | 0 | n/a | 614 | 921 | 583 | 649 |
Marauder | 0 | 0 | 0 | 0 | 0 | 0 | n/a | 0 | 0 | 8 | 131 |
Maryland | 733 | 585 | 503 | 465 | 488 | 430 | n/a | 306 | 264 | 171 | 88 |
Spitfire | 0 | 0 | 0 | 240 | 376 | 1941 | n/a | 3150 | 2712 | 1000 | 1653 |
Sunderland | 209 | 81 | 191 | 375 | 314 | 331 | n/a | 643 | 143 | 130 | 117 |
Tomahawk | 734 | 63 | 1074 | 1167 | 1077 | 798 | n/a | 408 | 309 | 597 | 576 |
Wellington | 4566 | 3983 | 4539 | 4126 | 4630 | 6360 | n/a | 9188 | 6268 | 4998 | 4611 |
P.R.U. | 87 | 10 | 20 | 10 | 197 | 158 | n/a | 214 | 404 | 160 | 157 |
Total | 11950 | 8659 | 10896 | 11384 | 12680 | 19209 | n/a | 24966 | 23234 | 23131 | 21650 |
SEF Total | 3614 | 2504 | 2780 | 3725 | 4661 | 8629 | n/a | 8062 | 8560 | 10150 | 10604 |
US archives Record Group 18 Entry 7 Box 5939, Ninth U.S. Air Force Operations Summary.
Type | Month | Feb-42 | Mar-42 | Apr-42 | May-42 | Jun-42 | Jul-42 | Aug-42 | Sep-42 | Oct-42 | Nov-42 |
B-24 | Missions | 0 | 0 | 0 | 0 | 8 | 22 | 18 | 25 | 27 | 25 |
B-24 | Sorties | 0 | 0 | 0 | 0 | 70 | 166 | 180 | 217 | 280 | 244 |
B-24 | Hours | 0 | 0 | 0 | 0 | 454 | 1576 | 1531 | 2103 | 2529 | 2546 |
B-25 | Missions | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 14 | 38 | 17 |
B-25 | Sorties | 0 | 0 | 0 | 0 | 0 | 0 | 71 | 73 | 299 | 149 |
B-25 | Hours | 0 | 0 | 0 | 0 | 0 | 0 | 233 | 222 | 467 | 238 |
P-40 | Missions | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 45 | 81 | 112 |
P-40 | Sorties | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 286 | 940 | 889 |
P-40 | Hours | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 363 | 1202 | 1582 |