dlflyer00

Like many, I have been in inconvenient positions lately where Delta representatives make incorrect changes to my reservations, be it for upgrades or IRROPS or otherwise. As a result I started working on a tool for Delta similar to Air Canada's PNR viewer. It turns out that the Delta mobile app retrieves a lot of information on your reservation that it doesn't show you, including reservation remarks, SSRs, ticketing information, etc.

I built pnr.sh to help show this information; you can use it here: https://pnr.sh

It shows all of the above; you can use it to calculate estimated MQM/MQD, see your fare basis, view automated and manual notes left on your reservation, and more. Given I built it over a weekend, it will probably break, get blocked, etc so I'll maintain it as I have time, but I figure it will be useful for most people. It's also open source if you are familiar with the programming language Go and want to run it yourself: https://github.com/pnrsh/pnrsh

Let me know if you find it useful or want it to show anything in particular! Here's part of what it looks like today, but it displays a lot of other info as well:

matchbox20_is

So cool! Thank you!

aacar

This is fascinating, and I can't imagine it'll last, but thanks!

paterwdb

Shhh... don't any of you breathe a word of this to an agent!
Great work OP... bravo!

henrus

This got me thinking, I wonder how hard a United one would be? The United website when doing a my booking search does XHR fetch at united.com/api/myTrips/lookup, this reveals a similar amount of information in json format.

I just had a look at a UA booking ref I've got an it reveals some interesting information including the ticket numbers, upgrade eligibility per sector, which ticket numbers are attached to each sector, status (including star gold/silver status), eticket control/status, fare basis, SSR comments on the booking, breakdown of taxes/fare.

jhalapin

This is pretty awesome!

Thanks!

woodenshoe101

Great tool, but looks like access is already killed by DL?

Repooc17

United modified the upgrade list coding a few days after people were allowed to see their position weeks and months ahead of time

findark

Still accessible to me, but posting an exploit like this publicly.. can't imagine it will last.

paterwdb

I'm just really wishing I'd had this on some past situations where there seemed to be some sketchy things going on with customer service. But grateful for it now for the time being.

For example, I have a RT XXX-ATL-PHX. I have a separate one way SAN-ATL-XXX on the same day as the return from PHX (I can't cancel only the return leg of that RT until after taking the outbound without forcing a reprice, but need to return from SAN instead of PHX). I can see in the notes that DL has made an auto note of "duplicate bookings" on both itineraries. It hasn't canceled anything yet, but interesting to note that the system has already flagged both itineraries for the duplicate day of flying.

UnevenGray

It's not much different from going to Delta.com and putting in a PNR, first name, and last name.

findark

There's no way Delta intends your PNR notes to be customer-facing. This is part of a wave of low-quality software developers having the backend spit out comically too much information over an unsecured API so that the frontend can filter and display it without needing to change it. This is true across airlines, and the really interesting nuggets of data get trimmed down at the speed of corporate management. (For example, on a different airline you used to be able to see many people's seat assignments, booking classes, and status levels through a similar exploit.)

Fly2Connect

I was wondering the same thing, but for American. hmmm

flyerCO

Most likely no. However, there's numerous laws requiring companies provide any information about you/transactions.

RealHJ

I like how DL describes the status of its customers:
...OK, well actually it's the status of the ticket. And I actually wonder if someone knows what does "HOOKED" status mean for a ticket?