Wow, I'm actually using FT for something pertaining to my schoolwork. This is a first

I didn't see obvious forum for an odd request (feel free to move as necessary) like this but here it goes...

I'm working on a project for a class that I'm taking this term and am looking for source data for some of my simulations. I realize that I could harvest this data from published schedules by hand but I'm hoping that someone here on FT has a quick an easy way to gather this information.

First of all, I'm really only interested in non-stop flights between the US and Europe. For these flights, I'm hoping to make a fairly comprehensive list (a CSV list would be ideal) of flights which includes the following information:

• Flight number, including carrier (ex: UA902)
• Origin airport code
• Destination airport code
• Departure time (scheduled, not actual time for a specific flight on a certain day)
• Arrival time (scheduled, not actual time for a specific flight on a certain day)
• Frequency (optional)

It would even be OK if this data were only available for one alliance, or even one or two airlines. Anything would help!

I thought I could massage the information I'm after into a convenient form on ITA but that doesn't seem to be the case. So far, the most convenient form of information that I've found (for manual gathering) is to use an ITA many-city to many-city search constrained in the the following ways:

• Source city: list of major US gateways (NYC,WAS,PHL,CLT,ORD,ATL,etc.)
• Dest city: major European gateways
• Non-stops only
• Text view, sort by departure time (helps to eliminate code-shares*)

* Using the "O:UA,LH,SK,etc" advanced route language option doesn't seem to eliminate some code shares (like LH scheduled flights on UA metal)

Obviously the ITA search reveals nothing about frequency of service and also getting the flight number is pain (you must mouse-hover over the bar in the graphical display). Maybe there are some ITA gurus out there that know better

In any case, that's the gist of what I'm looking for. I'm sure I've left something out those so feel free to ask for clarification!

PS: I'm fairly handing with scripting and parsing tools so if anyone has anything close to what I'm looking for, I'd certainly be interested in hearing about it!