How do I get a list of code share flights offered by US Air with other airlines such as Air Newzeland or Singapore Air?

Your best bet is to peruse the pdf timetable.

Option 1: Look at each LH gateway city and see if there is a US codeshare flight leaving that city.

Option 2: Look up the flight number range for LH codeshares. Then check arrival information for those flight numbers.