A Thread for Data Files

[33k in the air]

The RAF B-25 data is from a mixture of comparing with the Joe Baugher listings and looking into the Atlantic Crossing data, the RAF really only used the B-25 in
Northern Europe and North Africa. It was the closest to readable by others, so only a few more hours work The B-25 listing was meant for the web site mentioned but they did not reply, shown previously, here to pair it with the RAF one.

If you want another reference to check against, you may want to take a look at N.L. Avery's book B-25 Mitchell — The Magnificent Medium (Phalanx Publishing, 1992). It has many appendixes, several of which involve aircraft serial numbers. Some examples:

Appendix C — USN/USAAF PBJ Serial Numbers
Appendix G — Dutch Lend Lease for 60 Aircraft
Appendix I — Royal Netherlands Flying School B-25s
Appendix J — B-25s of 320 Sqn (RAF) Royal Netherlands Naval Air Service
Appendix K — B-25 Allocations to Netherlands East Indies Air Force and Royal Australian Air Force
Appendix O — RCAF Mitchells

 

[33k in the air]

Another file for everyone's consideration. This one puts into a spreadsheet details from the USAF publication Combat Squadrons of the Air Force, World War II.

Specifically, it lists all the USAAF fighter and bombardment squadrons which were stated as having seen combat in the ETO and/or MTO. The information included is squadron number, squadron type, event, base location, date, day of the week, assignment, attachment, and combat. The 'event' column mostly lists when the squadron moved to a new base, but also includes if the squadron was assigned to a different higher unit, or attached to another unit, and so forth. The 'combat' column mostly lists the word combat, but will note if the squadron performed other duties, e.g. a bombardment squadron which switched to weather recon, ECM operations, etc.

The data for each squadron is for the time period between when the squadron was listed as having started and ended combat for the war, as given in the source publication. The combat start row is shaded in light green and the combat end row is shaded in light red to provide a visual break for each squadron. In some cases the 'date' column only shows the month and year as per the source document.

By my count, 149 fighter squadrons and 331 bombardment squadrons (18 light, 60 medium, and 253 heavy) saw combat in the ETO and/or MTO.

(At some point I will add the reconnaissance squadrons.)

 

[GregP]

Thanks, 33k!

Here's one you guys might like. It's not complete, but has many tables from the Statistical Digest of World War Two. So, it's USAAF, but not USN/MC.

If anyone adds tables, please share what you added.

I have found several errors in table math. Can't tell if the data are wrong or the totals are wrong. So. I assumed that, like it was before spreadsheets and easy addition of many numbers, the data were correct and the totals were wrong.

Cheers.

 

[33k in the air]

Another file. This one contains the key specifications for air-dropped ordnance of WW2 from various ordnance manuals available at the Bulletpicker website. It primarily covers bombs, but there are some entries for other devices such as depth bombs, depth charges, mines, etc.

There are six worksheets: Allied Bombs, Allied Clusters, Axis Bombs, Axis Clusters, Rockets, and Abbr (which lists the abbreviations used). The publication from which the data is drawn is listed. The 'Index' column is a convenience to allow the file to be sorted back to its original order. The weaponry is listed in the order it appeared in each source document.

The file is a work-in-progress, so the Axis sheets are somewhat sparse, but the Allied sheets are nearly complete.

 

[GregP]

Thanks!

Here's a file of over 3,000 airfoils.

Cheers!

 

[GregP]

Here's a file of WWII Japanese Aircraft data for both IJN and IJA. It's not complete, but has a lot of data in it.

Cheers.

 

[Geoffrey Sinclair]

As the title suggests, basic charts to calculate fuel and bomb loads.

 

[33k in the air]

As the title suggests, basic charts to calculate fuel and bomb loads.

That is an outstanding file! Thanks very much for posting it, as it contains the kind of data I've been wanting to find. Do you know if similar tables were prepared for the medium bombers, e.g. the Hampden, Mosquito, Wellington, etc.? What about American bombers in British service, e.g. Boston, Liberator, Mitchell, etc.?

Now if only the USAAF had created and published similar tables for its bomber operations . . .

 

[GregP]

Here's a drawing I did of a P-51D-20-NA

Cheers!

 

[SaparotRob]

Those are beautiful images.

 

[GregP]

Those are beautiful images.

Thanks, SparotRob!

 

[Geoffrey Sinclair]

Jettison/drop tanks made by Britain from December 1943 onwards. A request for some of the figures meant a tidy up was done and it now looks presentable, hopefully without typos.

 

[herman1rg]

I have a lot of data, but it also took many years to compile. I sort of wanted to get a feel for what people have and might be willing to share. I was going to share some of this 20 years ago and was ridiculed for even suggesting I had the data. I had hoped the atmosphere was better today. Maybe it is.

I have:
1) A world list of aerial victories of WWII.
2) A good list of victories in Viet Nam.
3) A rather complete list of data for about 1,000 WWII airplanes of all types. Data in English and metric units, and a lot of ancillary data that goes with that type of list. Been working on this files since 1995.
4) A very complete list of WWII aircraft production by type and variant with a LOT of extraneous data in it about most countries that produced WWII aircraft. Things like designation systems, guns, etc. This file has been in work for 25+ years.
5) A good list of tables from the USAAF Statistical Digest of World War Two. There are many math errors in that document. I assumed the errors were in adding up totals, but they could be in table data entries, too. Without primary sources, there is no way to know or verify.
6) A good list of tables from US Naval Aviation Combat Statistics World War Two.
7) A pretty good spreadsheet of Aerodynamics for Naval Aviators and a few aerodynamics files from other texts.
8) A list of German claims for WWII from the old Tony Woods files, posted above. Summary tab.
9) A list of the individual victories of the top 10 or so German Aces, posted above.
10) A good, accurate list of USAAF Report 85. It's from another member in here and I can't post that one as I promised I wouldn't.
11) A decent list of WWII aero engines and specs.
12) Some files about submarines and ships, specs and losses and victories.
13) CAD files with 3-views for some 318+ WWII aircraft, all drawn by me. I have shared some of them in here. Many have rivets added. Generic markings since any marking can be applied to a drawing. These drawings add up to 7.8 GB of drawings.

Here's an example CAD drawing I did. No rivets, just line drawing. Adding them takes a LOT of time!

View attachment 763684

Hello, I'd love to see the CAD drawings

 

[GregP]

Likely won't post all my CAD drawings (over 320 WWII aircraft), but if you have a few favorites, I'll probably post some of them.

 

[herman1rg]

Likely won't post all my CAD drawings (over 320 WWII aircraft), but if you have a few favorites, I'll probably post some of them.

Hawker Hurricanes,

 

[GregP]

Here's the one I did first in grayscale:

and here's the one I did recently:

perhaps a bit more colorful. Oops! I left in the under-the-prop scoop on the front view!. SO, here's the correction below!

Actually, the sharp-eyed among you will see I left off the underside coloring in the front view, too. Ah well, another thing to fix when I get the time!

OK, fixed it.

Better ...

 

[Geoffrey Sinclair]

The P-47 production and deliveries.

 

[Geoffrey Sinclair]

Hawker Typhoon

 

[fubar57]

Thank you Geoffrey

 

[Geoffrey Sinclair]

From Air 8/218, a monthly listing of all squadrons in existence in Britain with their aircraft and personnel strengths, regular and reserve, operational and non operational. It comes to around 4,300 spreadsheet lines. This is the summary, from 56 squadrons in May 1936 to 121 in August 1939. Limitations: early reports do not have totals, increasing the chances of error, some pages are hard to read making them a source of errors, add typos. Concentrate of the trends but note the big time gap between the third and second last entries. Early returns omit squadrons temporarily overseas due to the Italian invasion of Ethiopia, then others sent overseas on a more permanent basis, like two Blenheim squadrons to the Far East in August 1939.

Some of the big jumps are changes in the designation of reserve units, in May 1936 there was 1 reserve fighter and 16 reserve bomber squadrons, in August 1939 it was 14 fighter, 2 Army Co-Operation and 4 General Reconnaissance.

RAF Scheme L circa Mid 1938.
Bomber Command Role The air offensive against selected targets in enemy territory. Composition 77 squadrons divided between 6 groups, 3 squadrons will be AAF, Characteristics Bomber design a compromise between range, bomb load and gun armament. Minimum operational range acceptable is 750 miles, i.e. Berlin

Fighter Command Role Defence against air attack, Composition 38 squadrons (608 fighters), in 3 groups; the Balloon Barrage Units; and the Observers Corps. C-in-C also has operational control of the AA gun and searchlight units of the Territorial Army, 9 squadrons are AAF, Characteristics In fighters everything sacrificed to speed and armament, particularly the former. Small endurance. Fixed gun single fighters and free gun two seaters (probably cannons)

Coastal Command Role Defence of coasts and shipping in co-operation with the Royal Navy. On occasion might be used to augment bombing offensive. Composition 13 land plane squadrons (245 aircraft) and 6 flying boat squadrons (36 aircraft) in 3 groups. 4 squadrons are AAF, Characteristics The most important factor in the design of the General Reconnaissance aircraft is long range coupled with good view for reconnaissance purposes and good facilities for navigation. A moderate bomb load required. Speed a secondary consideration.

Army Co-Op Role Co-operation with the army by reconnaissance, artillery bombardment observation, photography and a limited amount of close support bombing.. Composition 11 squadrons (132 aircraft) in 22 Group, 4 squadrons are AAF. 2 of the regular squadrons will be twin engined, primarily for night reconnaissance. Under Fighter Command for administration only, Characteristics An AC aircraft must have a good view for reconnaissance and be manoeuvrable. Able to operate from small landing grounds. Speed and bomb load secondary considerations, though a good range of speed is an advantage.

Total Metropolitan Air Force will be 145 squadrons, 2,381 aircraft. This does not include the Fleet Air Arm which is now in the process of being handed over to the Navy.