Database Search

You are in the database section of the website.

Select a record category from RECORDS above. When you have selected a category, you will see search options for that category above the record list. 

Most fields require at least three characters. When you submit your query, the search engine will return all records that contain your search term.

Note that when searching for an aircraft serial number, you must enter the full serial number without the leading "4" and without a dash in the Aircraft SN search field. For example, you would enter 42-37772 as 237772.

The Personnel name field searches both last and first names, so if you enter the search term, "Russ", the search engine will return both Russell Abel and James Russell.

You narrow the search by entering more characters into the search field. For example, "Russ" returns many hits. "Russell" returns fewer hits. The same principle applies to all queries.

The POW and KIA categories are list only and are not searchable.

Crew PILOT: Frederick H.  SCHAFFHAUSEN

2nd Lt. Frederick Schaffhausen crew Detailed Information (100th Photo Archives)

 Fredrick H. Schaffhausen crew Detailed information (100th Photo Archives) 

Lt Fred Schaffhausen Crew photo ID Stateside and name of Aircraft in training “Huzzy Hutch”

Crew Members:

Crew 1

NBR Person Position Status
1 CAPT Frederick H. SCHAFFHAUSEN P CPT
2 LT Victor A. KOEHLER CP CPT
3 F/O George W. RAY NAV CPT
4 LT Claude W. VAUGHN BOM CPT
5 T/SGT Lewis C. GREEN TTE CPT
6 T/SGT Hobart E. COOK ROG CPT
7 S/SGT Sidney J. BRAUD BTG CPT
8 S/SGT Johnie J. FORTNER WG CPT
9 S/SGT Joseph M. WALTERS WG CPT
10 SGT Alex SOOD TG CPT

PHOTOS:

 Claude W. Vaughn and Sidney J. Braud, Jr. of the Fred Schaffhausen crew Detailed information (100th Photo Archives) 

 Claude W. Vaughn and Victor A. Koehler of the Fred Schaffhausen crew Detailed information (100th Photo Archives) 

 Back row L to R: George Ray, Cook, Kohler, and Green, Front row: Fortner, Broad, Lt. Vaughn, Lt. Schaffhausen and Walters, Sept 1944. Detailed Information Karl Treanor collection