A Thread for Data Files

Ad: This forum contains affiliate links to products on Amazon and eBay. More information in Terms and rules

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
 
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.)
 

Attachments

  • USAAF squadron details ETO and MTO.xlsx
    155 KB · Views: 31
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.
 

Attachments

  • Statistical_Digest_Tables_WWII.xlsx
    511.3 KB · Views: 36
Last edited:
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.
 

Attachments

  • WW2 Bomb Specifications.xlsx
    254.4 KB · Views: 25
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 . . .
 
Here's a drawing I did of a P-51D-20-NA

P51D Red Nose Southwest Border.jpg


Cheers!
 
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.
 

Attachments

  • British Jettison tank production.xlsx
    26 KB · Views: 2
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
 
Here's the one I did first in grayscale:

Hurricane_IV.jpg


and here's the one I did recently:

Hurricane Mk II.jpg


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

Hurricane Mk II.jpg


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.

Hurricane Mk II.jpg


Better ...
 
Last edited:

Users who are viewing this thread

Back