FlyerTalk Forums - View Single Post - Southwest Routes, By Flight Number
View Single Post
Old Jul 3, 2021 | 11:32 am
  #17  
djp98374
FlyerTalk Evangelist
Community Builder
All eyes on you!
10 Years on Site
 
Join Date: May 2012
Location: DCA, lived MCI, SEA/PDX,BUF (born/raised)
Programs: Marriott, IHG, Hyatt, Choice, AS, UA, WN
Posts: 10,672
Originally Posted by FCfree
American, Delta and United now available. More complicated than I thought. Just doing Southwest, I did what they did, adjusting everything to Central Time (known to them as Herb Time). However, for travel all over the world, had to figure out the true take off day. FlightAware gives the UTC time. Had to add data for time zones of various airports.

Still looking at the data and cleaning up a few spots, but this is mostly correct.

American: https://github.com/MarkRLV/SWAroutes.../AALroutes.txt
Delta: https://github.com/MarkRLV/SWAroutes.../DALroutes.txt
Southwest: https://github.com/MarkRLV/SWAroutes.../SWAroutes.txt
United: https://github.com/MarkRLV/SWAroutes.../UALroutes.txt

Coming soon: Cathay Pacific, Frontier, Jet Blue, Air North, Spirit, Allegiant

Also added Airport's city. Example: AAL 14 is KEWR(New York) EGLL(London)

Still doing some analysis to be sure I know the right time zone for each airport.
whyid just operate on UTC time
djp98374 is offline