Community
Wiki Posts
Search

timetable analysis

Thread Tools
 
Search this Thread
 
Old Jul 7, 2014 | 7:41 pm
  #1  
Original Poster
10 Countries Visited
20 Countries Visited
30 Countries Visited
All eyes on you!
 
Join Date: Dec 2009
Location: New York, NY
Programs: Hyatt GLOB, Marriott Lifetime PLT, UA 1K 1MM.
Posts: 1,752
timetable analysis

so i was looking for a pet project to practice my programming on as i try to do side tasks so my programming doesn't get rusty, and i was looking at FT and ran across some thread asking which UA RJ flight is the longest.

hey, i figured, this sounds like something i could figure out without reading the entire timetable!

so i took a day and wrote a python script that parsed the july pdf timetable for UA and loaded it into the analytics tool that i used... and came up with this.

https://cloud.saplumira.com/open?key...type=HANALYTIC

according to the data, it looks like the longest RJ flight that UA has is... IAH-YUL at (holy ....) 4h5m on an E70, and lo and behold, i found that flight on united.com... for $771 one way.

jeez.

anyway, if you want to play around with the data i did make the dataset public, but there's something happening that's not letting people access it via the link, so if you want to actually play with the data and poke around, just create an account and pm me and i'll invite you over (below is what it looks like).



i'm working in my spare time to get something cool going since it's actually a big interest of mine, but thought i'd share. the data is pretty interesting (i also didn't know that the 777 is actually being flown further than the 788, although since it's new i guess it makes sense).

and jeez, my programming skills are rusty.

Last edited by bob_the_d; Jul 7, 2014 at 8:11 pm Reason: wrong plane
bob_the_d is offline  
Old Jul 7, 2014 | 7:58 pm
  #2  
 
Join Date: Feb 2014
Location: ORD/MKE
Programs: UA General Member, AA Gold, SPG (Bonvoy) Gold; IHG Plat. Ambassador
Posts: 399
really cool analysis, thanks for sharing!
danhunterpost is offline  
Old Jul 7, 2014 | 8:07 pm
  #3  
FlyerTalk Evangelist
10 Countries Visited
All eyes on you!
15 Years on Site
 
Join Date: May 2007
Location: Houston
Programs: UA Plat, Marriott Plat
Posts: 13,342
Originally Posted by bob_the_d
according to the data, it looks like the longest RJ flight that UA has is... IAH-YUL at (holy ....) 4h5m on an E75, and lo and behold, i found that flight on united.com... for $771 one way.
The plot you linked to has the E70 at 265 min (4h25m).

Originally Posted by bob_the_d
i'm working in my spare time to get something cool going since it's actually a big interest of mine, but thought i'd share. the data is pretty interesting (i also didn't know that the 777 is actually being flown further than the 788, although since it's new i guess it makes sense).
Nominal range for the 772ER is longer than the 788.
mduell is offline  
Old Jul 7, 2014 | 8:11 pm
  #4  
Original Poster
10 Countries Visited
20 Countries Visited
30 Countries Visited
All eyes on you!
 
Join Date: Dec 2009
Location: New York, NY
Programs: Hyatt GLOB, Marriott Lifetime PLT, UA 1K 1MM.
Posts: 1,752
Originally Posted by mduell
The plot you linked to has the E70 at 265 min (4h25m).
er, sorry, you're right, it's the E70 that's listed on united.com, not the E75, typo of mine.
bob_the_d is offline  
Old Jul 7, 2014 | 9:47 pm
  #5  
 
Join Date: Oct 2012
Location: ORD/IND
Programs: UA Platinum, Avis Preferred, Hertz PC, Hyatt Discoverist , Marriott Titanium
Posts: 742
Originally Posted by mduell
Nominal range for the 772ER is longer than the 788.
Not according to Boeing...

772ER - 7725 NM

788 - 7850 NM
JDS747 is offline  
Old Jul 7, 2014 | 11:37 pm
  #6  
FlyerTalk Evangelist
10 Countries Visited
All eyes on you!
15 Years on Site
 
Join Date: May 2007
Location: Houston
Programs: UA Plat, Marriott Plat
Posts: 13,342
Originally Posted by JDS747
Not according to Boeing...

772ER - 7725 NM

788 - 7850 NM
I don't think the early builds like UA took have quite that range; this article references ranges as short as 7600nm which is what I was recalling.
mduell is offline  


Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.