Web Hosting, Design, & Coding forum


Looking for script to pull airline timetables

by russianspd / January 5, 2013 4:20 PM PST

Hello there,
I am requesting a script that can pull airline information from this program:

I would like to be able to pull data from a specific date between multiple airport pairs. I would like to be able to put a txt file together with airport codes and have the program download all flights for the day between all airport codes.

Example is as follow:
Depart=LAS Arrival=SMF Date=Jan 6

It would look like this:
Flight From Depart To Arrive Via Aircraft Duration Itinerary
WN752 LAS 10:40am SMF 12:20pm 73W 1h40m
WN387 LAS 1:50pm SMF 3:20pm 733 1h30m
WN749 LAS 4:10pm SMF 5:40pm 73W 1h30m
WN3879 LAS 6:45pm SMF 8:15pm 733 1h30m
WN154 LAS 7:55pm SMF 9:25pm 73W 1h30m
WN1874 LAS 9:00pm SMF 10:30pm 73W 1h30m
WN1409/WN1409 LAS 8:35am SMF 11:50am SAN 733 3h15m
DL1820/DL4702~ LAS 11:19am SMF 2:40pm LAX 319/CR7 3h21m
AA1308/AA2628~ LAS 1:35pm SMF 5:20pm LAX 738/CRJ 3h45m
BA4839*/BA4721* LAS 1:35pm SMF 5:20pm LAX 738/CRJ 3h45m
UA233/UA6510~ LAS 2:27pm SMF 6:10pm LAX 752/CR7 3h43m
US6478*/US7013* LAS 2:27pm SMF 6:10pm LAX 752/CR7 3h43m
UA5523~/UA5402~ LAS 4:56pm SMF 8:30pm SFO CR7/EM2 3h34m
AA776/AA2623~ LAS 7:00pm SMF 10:05pm LAX 738/CRJ 3h05m

If I could have this data put into a excel format I can then change it and put it in a format I can make a Flightsim Flightplan with.

This is for Flightsimming purposes.


Answer This Ask For Clarification
Discussion is locked
You are posting a reply to: Looking for script to pull airline timetables
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: Looking for script to pull airline timetables
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.

All Answers

Collapse -
First you need to find
by Sovereign Forum moderator / January 6, 2013 10:24 AM PST

out whether they offer an API that provides you with access to that data.


Collapse -
No API key from listed software
by russianspd / January 6, 2013 2:44 PM PST
In reply to: First you need to find

No they don't. The program I listed doesn't offer an API. I can however get an API key from FlightAware.com, would that help you?

Collapse -
If you've found a company
by Sovereign Forum moderator / January 7, 2013 10:34 PM PST

that has the data you're looking for and they offer an API to interface with that data, then you'd be able to build a spreadsheet from it.

You're best bet is to get in touch with a local development company or freelance developer, and see how much they quote you on this project.


Popular Forums
Computer Help 51,224 discussions
Computer Newbies 10,453 discussions
Laptops 20,090 discussions
Security 30,722 discussions
TVs & Home Theaters 20,937 discussions
Windows 10 1,295 discussions
Phones 16,252 discussions
Windows 7 7,684 discussions
Networking & Wireless 15,215 discussions

Finding the best 360 camera

GoPro, Pixpro, or Ricoh?

You can spend hundreds or even thousands of dollars on a 360-degree camera. We tested three of them to find out what kind of quality and ease of use you can expect at each price point.