Individual Aircraft, by Serial Number

This table lists more than 439,000 individual aircraft, including drones and missiles that have been used by U.S. military forces or otherwise built under defense contracts for allies. Many more are still to be added. Included currently are such as the Wright Flyer the Enola Gay and the Memphis Belle. The names of several others (mostly big bombers) are also shown. These are generally names that their pilots or crews gave them. Over 17,000 B-24s and over 12,000 B-17s, as well as almost all of the nearly 4,000 B-29s, are included so far. Large numbers of other aircraft are also shown, such as JN-4s (Curtiss Jennys) F-86s, UH-1s and F-15s, which were built in smaller numbers, are included. For some aircraft that were lost in combat, information about the loss is shown. The unit (squadron and/or group) is shown for quite a few.

For download purposes, this Aircraft table is divided into two files.

PART ONE (Updated August 22, 2009). The first part of the Aircraft table lists aircraft of types whose first letter is A thru F. For example, it contains the B-17s and F-4s, and lists a total of 220,411 aircraft. This file, named aircraft-1, is 1.33 mb, and expands when decompressed into two file totalling about 31.3 mb. THIS FILE IS IN MICROSOFT ACCESS 2003 FORMAT.

To download this file, Click Here

PART TWO (Updated August 11 2009). The second part of the Aircraft table lists aircraft of types whose first letter is G thru Z. For example, it contains the P-51s, Navy PBYs and SBDs, and the UH-1s (Huey helicpoters), and lists a total of 219,532 aircraft. This file, named aircraft-2, is 1.14 mb, and expands when decompressed into two files totalling about 31 MB. THIS IS IN MICROSOFT ACCESS 2003 FORMAT.

To download this file, Click Here

My major source for this table is Joe Baugher's web site To visit his site, Click here. Joe's site shows virtually a complete listing, in text format, of all of the aircraft of all of our military services, from the Wright Flyer to today, by serial number groupings, and lists the disposition of a great many. It also has links to many other aviation sites. It is a remarkable site, and is linked here with his permission

Another excellent vehicle for information on aircraft (military and civilian) is AirNet, operated by Howard Curtis, which lists over 15,000 aviation-related sites, and is linked with Howard's permission. Go to AirNet



Return to Home Page