Last Trip:

January 21 - 26, 2013

Next Trip:

February 3 - 8, 2013

January 29 - February 2, 2013

Trip #392

January 29, 2013

18:45-21:26 LAX-SEA
Alaska Airlines 473

Commuting - Crew
Flight / N305AS
Seat 29D / Aisle / Coach Class

954 mi / 2 hours 41 minutes
<1 sec in SEA
20:40-22:04 SEA-MFR
Horizon Air 2461

Commuting - Crew
Flight / N431QX
Seat 11E / Window / Coach Class

352 mi / 1 hour 24 minutes
6 h 49 m in MFR dark_mode 1 Night

January 30, 2013

04:53-05:50 MFR-PDX
Horizon Air 2092

Crew
Flight / N431QX

222 mi / 57 minutes
33 m in PDX
06:23-07:18 PDX-SEA
Horizon Air 2092

Crew
Flight / N431QX

129 mi / 55 minutes
44 m in SEA
08:02-10:42 SEA-SUN
Horizon Air 2345

Crew
Flight / N431QX

475 mi / 1 hour 40 minutes
20 m in SUN
11:02-12:39 SUN-LAX
Horizon Air 2343

Crew
Flight / N431QX

696 mi / 2 hours 37 minutes
21 h 39 m in LAX dark_mode 1 Night

January 31, 2013

10:18-13:28 LAX-LAP
Horizon Air 2603

Crew
Flight / N409QX

836 mi / 2 hours 10 minutes
1 h 7 m in LAP
14:35-15:45 LAP-LAX
Horizon Air 2604

Crew
Flight / N409QX

836 mi / 2 hours 10 minutes
3 h 38 m in LAX
19:23-20:58 LAX-STS
Horizon Air 2472

Crew
Flight / N429QX

400 mi / 1 hour 35 minutes
20 h 55 m in STS dark_mode 1 Night

February 1, 2013

17:53-19:30 STS-LAX
Horizon Air 2475

Crew
Flight / N420QX

400 mi / 1 hour 37 minutes
50 m in LAX
20:20-22:26 LAX-MFR
Horizon Air 2420

Crew
Flight / N420QX

630 mi / 2 hours 6 minutes
7 h 44 m in MFR dark_mode 1 Night

February 2, 2013

06:10-08:23 MFR-LAX
Horizon Air 2421

Commuting - Crew
Flight / N410QX
Seat 19A / Window / Coach Class

630 mi / 2 hours 13 minutes

12

flights

7

airports

2

airlines

6

aircraft

Flight Time 22 h 5 m
Flight Time (w/ layovers) 1 d 4 h 31 m
Trip Length 3 d 13 h 38 m
% Flying 25.8% of trip
% Flying (w/ layovers) 33.3% of trip
Flight Types
Crew 9
Commuting - Crew 3
Flying
SEA
MFR
PDX
SUN
LAX
LAP
STS
Query
Template: /flights/trips/include_trip.cfm:39
Execution Time: 1.76 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
SELECT *, convert_tz(startdate, 'UTC', 'America/Los_Angeles') AS startdate_local, convert_tz(enddate, 'UTC', 'America/Los_Angeles') AS enddate_local
FROM blog.trips
WHERE tripnumber = 392
entrytripnumberstartdateenddateflts_numairports_numairports_listfull_routingflt_length_minstrip_length_minscal_days_flownmiles_totalmiles_avgmiles_per_flight_avgairlines_numairlines_listaircraft_numaircraft_listuq_fieldty_persty_crewty_co_uty_co_cty_comptimesstartdate_localenddate_local
1391392{ts '2013-01-30 02:45:00'}{ts '2013-02-02 16:23:00'}127LAX,SEA,MFR,PDX,SUN,LAP,STSLAX,SEA,MFR,PDX,SEA,SUN,LAX,LAP,LAX,STS,LAX,MFR,LAX7950030828056560547
Empty:null
2Alaska Airlines,Horizon Air6N305AS,N431QX,N409QX,N429QX,N420QX,N410QX2013013002452013020208237950030828056560547726090301209030{"COLUMNS":["city","secondshere","ord"],"DATA":[["SEA",5400,2222],["MFR",52380,2223],["PDX",1980,2224],["SUN",1200,2226],["LAX",94020,2227],["LAP",4020,2228],["STS",75300,2230]]}{ts '2013-01-29 18:45:00'}{ts '2013-02-02 08:23:00'}
Time Spent
Flight Time 22 h 5 m 25.33%
SEA 1 h 30 m 1.72%
MFR 14 h 33 m 16.69%
PDX 33 m 0.63%
SUN 20 m 0.38%
LAX 1 d 2 h 7 m 29.96%
LAP 1 h 7 m 1.28%
STS 20 h 55 m 24%