Last edit by: canadiancow
https://acpnr.cowtool.com/
Feature Requests / Bug Reports
Feature Requests / Bug Reports
- More direct links to partner airline "manage booking" pages
- For points bookings, show how many points were used
- Sometimes when you have UN segments, it doesn't show the entire PNR
- How about a one tool using the other: PNR lookup tool could show R space available Y/N if pax isn't already upgraded.
- Can seat # be a clickable link to carrier manage booking/seat?
- Display ticket create date/time, helpful to know when reticketed due to schedule change.
Unofficial AC PNR Viewing Tool (cowtool)
#136
A FlyerTalk Posting Legend
Original Poster
Join Date: Sep 2012
Location: SFO
Programs: AC SE MM, AA PPro, UA Gold, Bonvoy Tit LT Sil, Hyatt Glob, HH Diamond, Accor Silver
Posts: 43,531
I checked in for the IAH-YYC flight this morning, and found that I’d lost my seat assignment. But, I was able to select 12D myself without issues, this time. Cow’s tool shows my status is back to E50K.
This does seem to match others’ observation that perhaps AC did something. It’s also looking like our statuses can now be updated without removing/re-adding FF numbers.
This does seem to match others’ observation that perhaps AC did something. It’s also looking like our statuses can now be updated without removing/re-adding FF numbers.

#137
Join Date: Aug 2019
Location: YVR
Programs: Marriot Gold, Hilton Gold, Aeroplan Black
Posts: 37
Cow, as a web developer who also likes to explore/playing w/ open API like this,
I just want to say this tool is super simple but incredibly useful to check all our upcoming flights need (especially mRTW).
All our bookings & seats also immediately show up in your tool!
Big Kudos & Thank you very much for doing this!
I just want to say this tool is super simple but incredibly useful to check all our upcoming flights need (especially mRTW).
All our bookings & seats also immediately show up in your tool!
Big Kudos & Thank you very much for doing this!
#138
Join Date: May 2014
Posts: 154
I am not a web developer, but I can appreciate the simplicity yet usefulness of this tool. Thank you from our family as well, Cow. Your elegant tool has cleared up some annoying items on our mRTW itineraries, which would otherwise have been more difficult to see at AC.com and in our PDF Aeroplan itineraries. More free time for us on this Family Day long weekend!

#139
FlyerTalk Evangelist
Join Date: Jun 2003
Location: YYC
Posts: 23,551
Now checked in. As I half expected, ticket numbers shown on the boarding pass are the original 014, i.e. not the ticket numbers that the tool (and aircanada.com) were showing.
#140
Join Date: Sep 2017
Programs: AC E50K (MM) FB (Gold)
Posts: 206
So, a further DP. Ms SWMBO Stanbury just attempted web check in for her flight to CDG tomorrow, which had 2 TK and 2 HK status flights. I advised her that this would almost certainly be a fruitless exercise, and we would have to either call AC or wait until she is at YWG tomorrow.
Result: the check-in worked like a charm! She now has BP's both printed and in her iPhone wallet - the latter obtained through the app.
Cow's tool still shows the 2 TK's.
I don't begin to understand this, but "ours not to reason why" I guess.
Result: the check-in worked like a charm! She now has BP's both printed and in her iPhone wallet - the latter obtained through the app.
Cow's tool still shows the 2 TK's.
I don't begin to understand this, but "ours not to reason why" I guess.
#142
A FlyerTalk Posting Legend
Original Poster
Join Date: Sep 2012
Location: SFO
Programs: AC SE MM, AA PPro, UA Gold, Bonvoy Tit LT Sil, Hyatt Glob, HH Diamond, Accor Silver
Posts: 43,531
Well now that the thread title has changed, I guess that name is stuck 
I've added a couple new columns. Distance, base fare, and surcharges.
Distance is based on some "old" data pulled from Adam Smith 's spreadsheet (along with a Haversine calculator). I'll update it at some point if things look good.
The fare/surcharges fields are the pro-rated amounts based on distance, calculated from the information I can find. I have some PNRs with YQ and YR, but I don't have one with Y to test, but it should be fine.
This does not yet calculate your earnings, since I have not stolen Adam's list of *A airlines or bonus calculations. Though since I know whether it's an AC ticket and I know your status, it should be a bit simpler to determine everything.
I hope this is a useful addition, and I'd love to see any PNRs this doesn't work with.
One thing that's harder to see in this screenshot is that if you hover over an amount, it says "USD". Not super relevant since this isn't quite AQD, but I'm not sure a good way to figure out the exchange rate AC will use.

I've added a couple new columns. Distance, base fare, and surcharges.
Distance is based on some "old" data pulled from Adam Smith 's spreadsheet (along with a Haversine calculator). I'll update it at some point if things look good.
The fare/surcharges fields are the pro-rated amounts based on distance, calculated from the information I can find. I have some PNRs with YQ and YR, but I don't have one with Y to test, but it should be fine.
This does not yet calculate your earnings, since I have not stolen Adam's list of *A airlines or bonus calculations. Though since I know whether it's an AC ticket and I know your status, it should be a bit simpler to determine everything.
I hope this is a useful addition, and I'd love to see any PNRs this doesn't work with.
One thing that's harder to see in this screenshot is that if you hover over an amount, it says "USD". Not super relevant since this isn't quite AQD, but I'm not sure a good way to figure out the exchange rate AC will use.

#143
Join Date: May 2013
Location: west coast best coast
Programs: TINDER GOLD, STARBUCKS GOLD, COSTCO EXECUTIVE!!
Posts: 3,963
Well now that the thread title has changed, I guess that name is stuck 
I've added a couple new columns. Distance, base fare, and surcharges.
Distance is based on some "old" data pulled from Adam Smith 's spreadsheet (along with a Haversine calculator). I'll update it at some point if things look good.
The fare/surcharges fields are the pro-rated amounts based on distance, calculated from the information I can find. I have some PNRs with YQ and YR, but I don't have one with Y to test, but it should be fine.
This does not yet calculate your earnings, since I have not stolen Adam's list of *A airlines or bonus calculations. Though since I know whether it's an AC ticket and I know your status, it should be a bit simpler to determine everything.
I hope this is a useful addition, and I'd love to see any PNRs this doesn't work with.
One thing that's harder to see in this screenshot is that if you hover over an amount, it says "USD". Not super relevant since this isn't quite AQD, but I'm not sure a good way to figure out the exchange rate AC will use.


I've added a couple new columns. Distance, base fare, and surcharges.
Distance is based on some "old" data pulled from Adam Smith 's spreadsheet (along with a Haversine calculator). I'll update it at some point if things look good.
The fare/surcharges fields are the pro-rated amounts based on distance, calculated from the information I can find. I have some PNRs with YQ and YR, but I don't have one with Y to test, but it should be fine.
This does not yet calculate your earnings, since I have not stolen Adam's list of *A airlines or bonus calculations. Though since I know whether it's an AC ticket and I know your status, it should be a bit simpler to determine everything.
I hope this is a useful addition, and I'd love to see any PNRs this doesn't work with.
One thing that's harder to see in this screenshot is that if you hover over an amount, it says "USD". Not super relevant since this isn't quite AQD, but I'm not sure a good way to figure out the exchange rate AC will use.

#144
Join Date: Jan 2009
Location: YOW
Programs: AC-SE100K, AC-3MM, Marriott- LT Titanium, SPG RIP
Posts: 2,924
Nice additions to the tool!! Thanks!
I have a 7 segment itinerary and am just over 50% done the flying... the tool shows negative AQD for under the Base column for the two TPAC segments... the other segments seem to have the correct Base amounts... any ideas on why a negative number would be there? (All YQ numbers are positive, albeit very small).
I have a 7 segment itinerary and am just over 50% done the flying... the tool shows negative AQD for under the Base column for the two TPAC segments... the other segments seem to have the correct Base amounts... any ideas on why a negative number would be there? (All YQ numbers are positive, albeit very small).
#145
A FlyerTalk Posting Legend
Original Poster
Join Date: Sep 2012
Location: SFO
Programs: AC SE MM, AA PPro, UA Gold, Bonvoy Tit LT Sil, Hyatt Glob, HH Diamond, Accor Silver
Posts: 43,531
Nice additions to the tool!! Thanks!
I have a 7 segment itinerary and am just over 50% done the flying... the tool shows negative AQD for under the Base column for the two TPAC segments... the other segments seem to have the correct Base amounts... any ideas on why a negative number would be there? (All YQ numbers are positive, albeit very small).
I have a 7 segment itinerary and am just over 50% done the flying... the tool shows negative AQD for under the Base column for the two TPAC segments... the other segments seem to have the correct Base amounts... any ideas on why a negative number would be there? (All YQ numbers are positive, albeit very small).
#146
Join Date: Apr 2011
Location: YYC
Programs: AC E75K, spouse E75K (MM), National Emerald, various hotel programs
Posts: 357
#147
A FlyerTalk Posting Legend
Original Poster
Join Date: Sep 2012
Location: SFO
Programs: AC SE MM, AA PPro, UA Gold, Bonvoy Tit LT Sil, Hyatt Glob, HH Diamond, Accor Silver
Posts: 43,531
#149
Join Date: Jan 2009
Location: YOW
Programs: AC-SE100K, AC-3MM, Marriott- LT Titanium, SPG RIP
Posts: 2,924