question on US schedule from 2003

[JS]

Can anyone help me with this puzzle? This was the last trip I took before I started a spreadsheet. I remember the outbound flights but not the return.

I took off from LGA in the mid-afternoon on the first Friday in April 2003. I know that I landed in GSO on a Dornier 328 turboprop.

US used to fly DC-9's LGA-GSO but those were gone by 2003.

I don't think I flew this non-stop. I probably connected in DCA or PIT. I'm pretty sure it wasn't CLT or PHL.

Anyone know what the schedule was in early April 2003? (other than "better" 🙂 )

 

[BoeingBoy]

If nobody else has anything, go to the BTS webside and download the on-time database for April 2003. You won't need to download every field - day of month, carrier, flight number, departure airport, arrival airport, crs departure time, and crs arrival time should be the minimum you'll need. Unfortunately, this database doesn't have equipment type.

BTS On-Time Database

Then sort it by departure and arrival airport and pick out your flights.

Jim

 

[flyJOE]

Can anyone help me with this puzzle? This was the last trip I took before I started a spreadsheet. I remember the outbound flights but not the return.

I took off from LGA in the mid-afternoon on the first Friday in April 2003. I know that I landed in GSO on a Dornier 328 turboprop.


I don't think I flew this non-stop. I probably connected in DCA or PIT. I'm pretty sure it wasn't CLT or PHL.

Anyone know what the schedule was in early April 2003? (other than "better" 🙂 )

I don't have a timetable, but I would bet it was through PIT. I know that US was running 328s from PIT to GSP, CAE, and I think CHS. So it's likely they were running them to GSO too.

 

[jimcfs]

I don't have a timetable, but I would bet it was through PIT. I know that US was running 328s from PIT to GSP, CAE, and I think CHS. So it's likely they were running them to GSO too.

IIRC, they were flown to TRI also, but I don't know if it was as late as 2003.

Which express operator(s) flew the 328 for US?

 

[JS]

Holy cow, I just remembered something unique about this flight... the flight attendant made a no-pee announcement but neglected to make the pee-now-allowed announcement. So it must have been DCA! Wow, a silver lining to the 30 minute no-pee rule that thankfully has gone by the wayside! 🙂

 

[TBONEJ4J]

Which express operator(s) flew the 328 for US?

PSA - the wholly-owned JIA, not the real PSA.

 

[zethya]

There were 5 LGA-GSO non-stops. Aircraft types not available.

4 April 2003
XXX to
Lv Arr Flight# Freq Stops Distance

LGA to GSO (Non-Stops)
GSO 850a 1038a E4904 0 461
GSO 115p 305p E4846 X67 0 461
GSO 250p 435p E4810 0 461
GSO 430p 620p E4796 0 461
GSO 700p 850p E4799 X6 0 461

LGA to
DCA 600a 659a S2661 X67 0 214
DCA 700a 804a S2663 X6 0 214
DCA 800a 905a S2665 X7 0 214
DCA 900a 1007a S2667 X6 0 214
DCA 1000a 1107a S2669 0 214
DCA 1100a 1203p S2671 X6 0 214
DCA 1200p 1259p S2673 0 214
DCA 100p 205p S2675 X6 0 214
DCA 200p 307p S2677 0 214
DCA 300p 411p S2679 X6 0 214
DCA 400p 510p S2681 0 214
DCA 500p 611p S2683 X6 0 214
DCA 600p 707p S2685 0 214
DCA 700p 809p S2687 X6 0 214
DCA 800p 911p S2689 0 214
DCA to
GSO 1245p 205p E3243 X67 0 248
GSO 159p 320p E3054 X7 0 248
GSO 420p 540p E3117 X6 0 248
GSO 735p 849p E3372 X6 0 248

LGA to
PIT 655a 822a 73 0 335
PIT 905a 1042a 1177 0 335
PIT 310p 442p 545 0 335
PIT 559p 733p 135 X6 0 335
PIT 615p 746p 85 X67 0 335
PIT 745p 919p 977 X6 0 335
PIT to
GSO 745a 855a E4778 0 304
GSO 115p 230p E5736 0 304
GSO 400p 515p E5783 0 304
GSO 1000p 1110p E5863 X6 0 304

LGA to
BWI 630a 750a E3773 X67 0 185
BWI 840a 1000a E3525 X67 0 185
BWI 959a 1120a E3826 X7 0 185
BWI 1155a 115p E3971 0 185
BWI 159p 325p E3533 X7 0 185
BWI 400p 525p E3660 0 185
BWI 535p 655p E3920 X7 0 185
BWI 710p 830p E3599 X67 0 185
BWI 855p 1016p E3787 X6 0 185
BWI to
GSO 920a 1055a E5361 X7 0 278
GSO 1245p 217p E5365 0 278
GSO 420p 555p E5371 X6 0 278
GSO 745p 915p E5375 X6 0 278

 

[NCFL]

There were 5 LGA-GSO non-stops. Aircraft types not available.

4 April 2003
XXX to
Lv Arr Flight# Freq Stops Distance

LGA to GSO (Non-Stops)
GSO 850a 1038a E4904 0 461
GSO 115p 305p E4846 X67 0 461
GSO 250p 435p E4810 0 461
GSO 430p 620p E4796 0 461
GSO 700p 850p E4799 X6 0 461

DCA to
GSO 1245p 205p E3243 X67 0 248
GSO 159p 320p E3054 X7 0 248
GSO 420p 540p E3117 X6 0 248
GSO 735p 849p E3372 X6 0 248

PIT to
GSO 745a 855a E4778 0 304
GSO 115p 230p E5736 0 304
GSO 400p 515p E5783 0 304
GSO 1000p 1110p E5863 X6 0 304

BWI to
GSO 920a 1055a E5361 X7 0 278
GSO 1245p 217p E5365 0 278
GSO 420p 555p E5371 X6 0 278
GSO 745p 915p E5375 X6 0 278

I used to have to decipher flight number ranges a lot in my job for the purpose of classifying DOT complaints to the right Express carrier, so I may be able to shed some light on this.

I can tell you with 100% certainty that the middle two DCA-GSO flights (3054 and 3117) were Piedmont, and therefore DH8. So you can eliminate those. I flew them all the time, to boot, especially 3117.

And I can tell you that BWI-GSO flights were not wholly-owned (I believe those were those God-awful J41s operated by TransStates). You can eliminate those, too.

LGA-GSO was operated by TransStates' Jet operation using ERJ. That jives with what I recall their flight number range to be, too - upper 4k.

I don't think there was ever a time that a wholly-owned had flights in the 5k range. I seem to recall the 5k numbered PIT-GSO flights being operated by Chautauqua.

IIRC, EN flights were 3000-3199 and JS were 3200-??, or something close to that. I also remember there being a mixture of DH8 and D38 on DCA-GSO for a while (I recall this because I hated the maintenance-delay/cancellation-prone D38).

All of this to say, through process of elimination, I'd wager that US3243 and US3372 DCA-GSO were operated by JS D38s.

Why the hell that is still in my brain 5 years later, and a year after leaving the company, is beyond me. I need more therapy, apparently.

 

[JS]

...Why the hell that is still in my brain 5 years later, and a year after leaving the company, is beyond me. I need more therapy, apparently.

This board is therapy.

 

[markkus757]

I have access to the April 2003 OAG, so here goes:

1) the only D38 flights into GSO were from DCA, so you must have connected there.
2) the only 2 D38 from DCA to GSO were flights 4050, 11:50a - 1:00p and 4055, 8:50p - 9:59p
3) shuttle service from LGA-DCA 319's. flight 2669, 10:00a - 11:06a seems logical for the first connecting option and flight 2687, 7:00p - 8:08p would fit for the second.


LGA-DCA, #2669, 10:00a - 11:06a, 319
DCA-GSO, #4050, 11:50a - 1:00p, D38

OR

LGA-DCA, #2687, 7:00p - 8:08p, 319
DCA-GSO, #4055, 8:50p - 9:59p, D38

 

[JS]

I have access to the April 2003 OAG, so here goes:

1) the only D38 flights into GSO were from DCA, so you must have connected there.
2) the only 2 D38 from DCA to GSO were flights 4050, 11:50a - 1:00p and 4055, 8:50p - 9:59p
3) shuttle service from LGA-DCA 319's. flight 2669, 10:00a - 11:06a seems logical for the first connecting option and flight 2687, 7:00p - 8:08p would fit for the second.


LGA-DCA, #2669, 10:00a - 11:06a, 319
DCA-GSO, #4050, 11:50a - 1:00p, D38

OR

LGA-DCA, #2687, 7:00p - 8:08p, 319
DCA-GSO, #4055, 8:50p - 9:59p, D38

Thanks! The sun was up when I arrived, so it must have been flight 4050.

I always liked flying on the D38. It seems quite powerful for a turboprop. I didn't like the jet version (FRJ) -- too loud. I wasn't aware the Dorniers were maintenance hogs.