NAA P-51D Mustang: Fuselage Lines; Polynomials

NAA P-51D Mustang: Fuselage Lines; Polynomials.

This evening I spent some time looking back through some old notes I had on fuselage design, particularly Conic sections and Setting-out design theory.

Checking through the archives for the Mustang P-51 we have a design set for the wind tunnel model with a line plan showing the Shoulder Points (SP) and the “point of convergence” where the upper line of the Mustang fuselage converges with the lower fuselage line and the Fuselage reference line.

2015-07-31_03-40-50The Wind Tunnel drawings are a quarter scale but are quite accurate.

Here we can see the “point of convergence” actually defined on the the wind tunnel drawing at the scaled sta 92. Technically station 92 does not exist as it is outwith the fabric of the WT aircraft, but for convenience I have defined it!

So with this in mind I decided to undertake an experiment to calculate the “point of convergence” with the fuselage ref line according to the manufactured ordinates.

2015-07-31_12-43-55For this exercise I used the upper line of the fuselage, shown here as X,Y values starting from Station 113 and created a line chart.

I applied an third order polynomial equation to the line chart with a scientific value to 5 decimal places to increase the accuracy.

I recalculated the values of the Y ordinate to check that the formula produced an accurate result; shown in red. As you can see the resulting values are very close to the original Y values.

The last X value is the projected value I want to calculate to achieve a “close to zero” Y coordinate thus by definition being the calculated “point of convergence”. This value is 9518mm (374.725 inches) which compares quite well with the Wind Tunnel drawings showing this to be 92*4=368 inches.

Should I recreate this exercise but instead use a fifth or sixth order polynomial equation I am quite sure the resulting value for the point of convergence would be closer yet to the scaled up wind tunnel value.

Normally for this type of exercise I would work with tangent lines and the start points of the upper and lower fuselage lines from predefined Shoulder Points.

This was a bit of fun just to demonstrate how we can use the power of spreadsheets and mathematical equations to assist with developing our Cad designs.

Bf 109Update: I decided to play about with this a bit more and had a look at the fuselage lines for the Bf109. I don’t have the design “point of convergence” for comparison but decided to do it anyway to find the convergence between the Lower and Upper fuselage lines.

These points are measured from a ground datum at 800mm below the fuselage reference line.

The stations/frames are from 2 – 8 inclusive. As you can see the calculated values verify the existing ordinate dimensions with the projected “point of convergence” calculated at 4832mm from station/frame 2.

These are the fuselage lines on the vertical plane which in theory should share the same convergence point for the fuselage lines on the horizontal plane (technically plan of max width)…an exercise for some other time!

What is even more interesting is that a line equation can be used to generate a spline in both the Inventor & Solidworks cad products… as a check to verify the cad work this is enormously useful!

2015-08-01_00-02-16Another example of application would be for the frames or station profiles.

In this example I have applied a polynomial equation to a set of ordinates for the top section of station 300 for the P-51 Mustang.

This needs a full profile as an arc to achieve an accurate result, which I’ve applied as a sixth order polynomial…you cant get much more accurate than this with Excel!

Ideally we would wish to extend this arc to the max width ordinate, which would add another negative ordinate (below the base line) to the graph…for some unknown reason Excel finds it difficult to compute an acceptable polynomial with 2 sets of negative values, so I would have to transpose the ordinates accordingly.

The Mustang ordinates induce a minuscule negative curvature on the top rear fuselage frames when you create a CAD profile just using the ordinate values from the NAA drawings. Its not detrimental in anyway but it is rather annoying…so to obviate these issues I could utilize a polynomial solution to adjust the ordinates to get a positive curvature. The adjustment is micro millimeters, but hey that’s the way that CAD works.


Mustang P-51CAnother Update:
Out of curiosity I recalculated; to a higher degree of accuracy; the upper fuselage line for the P-51 and contrasted that with a similar calculation for the lower line of the fuselage.

The calculated point of convergence of both lines based on a 4th order polynomial to 5 decimal places is at 9375mm and slightly above the fuselage reference line at +18mm. Factoring in error based on the original ordinates being accurate to 1/16th inch and possible error as a consequence of a higher order polynomial I think this is a reasonable result. Its interesting to note the variation with the results we got before.

This is certainly closer to the expected values based on the wind tunnel data. The squiggly line by the way on the lower part of the fuselage is the plotted max half breadths; which is rather interesting!

Confirmation; have received confirmation that the intended point of convergence for the upper and lower fuselage lines is at Sta 368, which is at 9347.2mm…this is great!!

All CAD profiles included in the P-51 Mustang Ordinate Package now available. Refer promotion here.

NAA P-51D Mustang: Tail Wheel Assembly: Update.

NAA P-51D Mustang: Tail Wheel Assembly: Update.

I shall need to temporarily suspend further work on the assembly model as the remaining parts to achieve a full build are created in a later version of the Inventor cad program and therefore not compatible with the version I currently have access to.

So this is as far as I can go with the assembly, though one could argue that it may be worthwhile including the necessary bolts, washers, turnbuckles etc, but to be honest most of this is planned as the final components in the build. The main reason for this is to ensure that everything aligns properly and works according to the design intent before plugging in all those connecting bits!

p-51d mustang rear fuselage

I have some tidying up to do with the fuselage frames and to develop that library I was talking about for the aeronautical standard parts and components…so perhaps this may be the time to get this done.

I also plan to do some 2d detail drawings for some of this modelling to record some of the key information that I have had to research separately from the archive resource and create the Bill of Materials structure that complies with the existing NAA documents for the complete assembly.

2015-07-15_17-17-08

The 2d drawings will also serve as a dimensional check as these objects were built in mm whereas originally they were designed in inches.

Its very hard to identify small dimensional discrepancies when just reviewing the 3d model!

So for now I probably wont be posting too much on the modelling side of things but may include some new cad technotes on the techniques I have used in this project.

NAA P-51D Mustang: Document Management

NAA P-51D Mustang: Document Management

An update on the organisation of the document management and archive register.

The USAF Parts catalog for the P-51 is organised by assembly and sub assembly types. For the Tail Wheel assemblies we have one main installation assembly and two sub assemblies for the Shock Strut and Steering Mechanism as follows:

2015-07-02_00-29-57  2015-07-02_00-30-32  2015-07-02_00-32-05

For the document register I have grouped the records and created separate worksheets that comply with the assemblies as setout in the USAF Parts List, listing the assemblies with a Category designation i.e TW-IN (Tail Wheel Installation) TW-SS and TW-SM.

2015-07-02_00-35-30

In the last column I have identified the NAA drawing by type; defining these as follows;

  1. Part: An individual drawing fully detailing a single part or item.
  2. Part Assembly: A fully detailed part drawing that includes additional fitted components like bearings, bushes or rivets.
  3. Main Assembly: A top level assembly listing individual parts, sub assemblies or components.

Note: The Part Assembly is technically a sub assembly which unusually comprise a fully detailed single part to which other elements have been added. Currently for this to work for me in the Cad environment I have maintained the part definition but modeled as a multi-part file. I may decide to change this to an actual Cad assembly file.

To clarify the above and ensure that all parts are accounted for I have created a sub listing of the contents for each Part Assembly as shown in the following scrap view:

2015-07-02_01-02-46

Some of the parts included in the Part Assembly are bushings, which are typically a press fit and reamed to a specified diameter. The bushing included in the Part Assembly is modeled to “as-fitted” condition, but as a matter of record I maintain a separate model file built to the “pre-fitted” manufactured dimensions.

I have also extracted a separate list from the USAF Parts List for the NAA standard parts from which I have identified the information I have in the archive and the data I will need to source elsewhere.

2015-07-02_01-13-08

The NAA standard part drawings in many cases supersede earlier standards for which we have a reference listed. I have these listed in this spreadsheet in 3 columns (on the right); with the first entry being the “Old standard”; the second as the “New Standard” and the final entry being the archive reference. I have had to do this as occasionally the drawings refer to the old superseded standards number.

At this stage I have all the records for the Tail Wheel assembly organised into manageable chunks of information so that I can track progress as marked and manage the eventual build of the final Cad model assemblies.

TechNote: MS Excel Drawing Register P-51

TechNote: MS Excel Pivot Tables: Drawing Register P-51

The drawing archive collection for the Mustang P-51 includes an NAA Document register in PDF that lists all the Scan Index Numbers, Drawings Number, Aircraft Type and Change (Revision)Number.

To make sense of this large archive; containing thousands of scanned images; it is necessary to first transpose the comprehensive NAA document register into a spreadsheet in order to analyse and filter the data according to requirements.

My requirements are simply to be able to group the data per content; Fuselage, Wings, Equipment etc; and per aircraft type; P-51A, P-51B, P-51C etc.

Further breakdown of data would involve isolating the main assemblies and then parts or sub assemblies belonging to each.

2015-06-12_22-06-44From Adobe Acrobat I extracted the pages of data as spreadsheet tables to which I added a Drawing Description and grouped the data sets together by “Content”…that took a long time to do as the extracted data first had to be checked and then sorted accordingly.

The drawing descriptions came from an index already created by Norman Meyers at Chanute Air Museum, so it was relatively easy to enter this data into my spreadsheet. Its a real pity I had not had access to Normans data earlier; could have saved me a lot of work.  My thanks to Norman Meyers.

2015-06-12_23-39-41After sorting the data and inserting descriptions I now have separate worksheets for the content similar to this one.

What I really want now is to identify and organize the drawings belonging to each type of aircraft. For this exercise I use the Pivot Table function in Excel. Pivot Tables are great for organizing and summarizing data according to specific criteria.

2015-06-12_22-34-13Here I have initiated the Pivot Table function and selected the entire data-set of information relating to the Fuselage; as you can see we have a large number of drawings just for this one area!

When working with large data-sets it is good practice to select a new worksheet for inserting this new table.

2015-06-12_22-38-07What we end up with is a new worksheet with the pivot table outline on the left and a selection box on the right. We now select from the latter the columns of data we want…in this case all the main ones plus the P-51D; which will populate the outline table on the left.

Pivot tables by default include a summary row under each entry; I suspect this is more useful for statistics than organizing a document register; which we don’t want.

2015-06-12_22-49-34To remove the summary from the table we just need to select each column in turn using the small arrow as highlighted and turning off this option in “Field Settings” and select “None”.

The final step is to filter the data according to the required criteria; in this case I want all the drawings that have an “X” value in the P-51D column.

2015-06-12_22-54-42This is done by selecting this value from the header drop-down options; which lists by default the unique values in each column from the master table.

We now have a list of all the fuselage drawings and their location in the archive belonging to the P-51D aircraft.

The next step would be to extrapolate all the “assembly” drawings and from there the components that make up each assembly…but that’s for another day.

Pivot Tables are great for this type of job.

  • 846 fuselage drawings for the P-51A
  • 890 fuselage drawings for the P-51B
  • 833 fuselage drawings for the P-51C
  • 923 fuselage drawings for the P-51D
  • 950 fuselage drawings for the P-51H

Many drawings of course are a shared resource for all variants. This drawing register has recently been updated with hyperlinks to all the drawings listed. See this post for details.

For further information on any of these projects please feel free to drop me a line via my contact page or email me at hughtechnotes@gmail.com