Aircraft
Army and Air Force aircraft are identified by a unique Serial Number assigned to each. Navy and Marine Corps aircraft are similarly identified by a Bureau Number. The Coast Guard also identifies its aircraft by Serial Number.
The best available source on the Web for information about individual military aircraft is Joe Baugher’s web site. Joe has made a point of trying to identify and list all such aircraft individually by their identifying numbers, as well as providing much further information on a lot of aircraft, and has made this information available on his site in very clear fashion.
The site is Joe Baugher’s site
The searchable table for aircraft on our site includes a little information about some aircraft (like a few nicknames and the disposition of some) that is not available on Joe Baugher’s site. However, overall no one is going to come close to the wealth of aircraft information that is on his site.
Another excellent source of information about all but recent years’ aircraft is “U.S. Military Aircraft Designations and Serials, 1909 to 1979” by John M. Andrade. This book includes lots of data about specific aircraft as well as background on the various types and groups.
| TYPE | MODEL | ARMY_AF_NUM | NAVY_SERIES | NAVY_MC_NUM | CONTRNUM | NICKNAME | MFGLOC | HIST_NOTES | DISPOSITION | DISPDATE | C1 | C2 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| C-87 | CF | 42-107250 | – | – | – | – | Consolidated Fort Worth | WW II | – | – | – | – |
| C-87 | CF | 42-107251 | – | – | – | – | Consolidated Fort Worth | WW II | – | – | – | – |
| C-87 | CF | 42-107252 | – | – | – | – | Consolidated Fort Worth | WW II | – | – | – | – |
| C-87 | CF | 42-107253 | – | – | – | – | Consolidated Fort Worth | WW II | – | – | – | – |
| C-87 | CF | 42-107254 | – | – | – | – | Consolidated Fort Worth | WW II | – | – | – | – |
| C-87 | CF | 42-107255 | – | – | – | – | Consolidated Fort Worth | WW II | – | – | – | – |
| C-87 | CF | 42-107256 | – | – | – | – | Consolidated Fort Worth | WW II | – | – | – | – |
| C-87 | CF | 42-107257 | – | – | – | – | Consolidated Fort Worth | WW II | – | – | – | – |
| C-87 | CF | 42-107258 | – | – | – | – | Consolidated Fort Worth | WW II | – | – | – | – |
| C-87 | CF | 42-107259 | – | – | – | – | Consolidated Fort Worth | WW II 22nd Troop Carrier Group Lost Aug 9 1943, India |
Lost | 1943-08-09 | – | – |