Individual Aircraft, by Serial Number

This table lists more than 414,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, and the table is growing constantly. 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 gernerally 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, including over 14,000 P-47s, and a great many Navy and Marine Corps aircraft. Many older and newer aircraft, such as JN-4s (Curtiss Jennys) F-86s, UH-1s and F-15s, which were built in smaller numbers, are included. For many aircraft that were lost in combat, information about the loss is shown. The unit (squadron and/or group) is shown for quite a few. The list includes a great many World War II craft and representative planes of Korean War, Vietnam War, and other eras.

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

PART ONE (Updated February 29 2008). 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 211,907 aircraft. This file, named aircraft-1, is 1.29 mb, and expands when decompressed into two file totalling about 30.1 mb. THIS FILE IS IN MICROSOFT ACCESS 2003 FORMAT.

To download this file, Click Here

PART TWO (Updated June 23 2007). 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 202,772 aircraft. This file, named aircraft-2, is 1.07 mb, and expands when decompressed into two files totalling about 28.6 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