Wednesday, February 15, 2012

Ballinger's printout in .CSV format

Posted by bambooboy

This article is to announce the release of the Ballinger's ACARS Printout in .csv format. I merely hand copied the data from the original .pdf file Team7/Box13 - FBI 302s ACARS into an OpenOffice spreadsheet, then saved it with a .CSV extension. From that, I also produced a tabular version of the same data to make things easier for 9/11 researchers. As a result, two files were created.

In the first one, Ballinger_TEXTUAL_CSV.csv, I simply created a text version from the scanned version. In the second one, Ballinger_LINEAR_CSV.csv, I have reorganized the same data in a linear format to visually help the reader spotting similarities and differences between the various messages.

In the "Ballinger_LINEAR_CSV.csv" file, I have added 3 columns at the beginning of each data row: the first 2 are related to "scan" and "time" messages order. The third is for quick reference to "uplink/downlink direction" of communication. I didn't add any heading for data fields (except those for "neutral voices" such as Flag_01, Flag_02, and so on), because some are still under debate.

Note. The linear comparison allows to highlight some new interesting points, especially the values shown under the column "flag_31". This column shows that the messages uplinked to United 93 are marked by a value in front of the aircraft flight number [UA93], whereas such value can be [1], [2] or blank [ ] (example. 1UA93).

These are other interesting points:
  • messages with a "blank" [ ] value (time ordered list "2" 13:22; "11" 13:50; "12" 13:50; "13" 13:51; "14" 13:51) are all transmitted in "AGM mode" (to the printer). Note: The downlink (time ordered message: "1" 13:21) is also transmitted in "AGM mode"
  • the value "1" values appear for all the uplinks sent in "CMD mode" (to the cockpit screen)
  • the value "1" value appears to be related to messages positively received by UA93 (such as message time ordered "3" at 13:23 UTC)
  • the value "2" value only appears once and is associated to the only message which was certainly received/undelivered( time ordered "18" 14:20 UTC). This uplink (#24 in Winter's list)is a CMD message (to the cockpit's screen).
  • the uplink ordered as "18" was sent by "ROB" (ROBERT BRITTAIN), and contains RGS the indication "/GL DEC"



Finally, I made a cross-reference to the data from the ARINC logs. The results are shown in the table below:

FLoc BEPts Target Stn Stn Org TimeStamp Reason Code Block Type /GL
365464105 20010911 14:13:30

IADA6


ULBLK CMI
365550345 20010911 14:13:40

IADA6


ULBLK CMI
365612804 20010911 14:13:50

IADA6


ULBLK CMI
365678382 20010911 14:14:00



311
ICPUL CMI
365678701 20010911 14:14:00



231
ICPUL CMI
367059755 20010911 14:17:39
CMI<00><00>

20010911 14:17:00

ULMSG CMI
367059889 20010911 14:17:39



231
ICPUL CMI
367187539 20010911 14:18:03
CMI<00><00>

20010911 14:17:00

ULMSG CMI
367187673 20010911 14:18:03



231
ICPUL CMI
367542701 20010911 14:19:04
CMI<00><00>

20010911 14:19:00

ULMSG CMI
367542835 20010911 14:19:04



231
ICPUL CMI
368197741 20010911 14:21:06
DEC<00><00>

20010911 14:20:00

ULMSG DEC
368197875 20010911 14:21:06



231
ICPUL DEC




UAL communication marked as "TIME_ORDER_18" in my list above, which matches Message #24 in Winter's list and the ULMSG block "FLoc 368197741... BEPts 20010911 14:21:06 ICPUL... Reason Code 231" in the ARINC logs shows "/GL DEC" as target station and "ROB" (Robert Brittain) as dispatcher. If we look at column "Flag_31", we notice that this is the only message reporting the value "2".
Unfortunately we have no clear indication from the ARINC specifications or any other official document what these values ("blank","1" and "2") are referred to. Therefore, we can only speculate trying to draw logical conclusions based on the available data:

  • Ballinger's printout, as printed at his UAL workstation, reflect the data as returned by ARINC to UAL after an uplink is sent [1]
  • Only one message from Ballinger's printout is surely unreceived/undelivered: this is the last message (marked as "TIME_ORDER_18" in my list and referred as Message #24 by Winter) and this shows the value "2", which is not a direct function of "CMD" or "AGM"
  • In the ARINC logs for United 93 there are five ICPUL blocks with Reason Code 231 ("No Station To")
  • Both in ARINC logs and in Ballinger's printout there are three ULMSG blocks showing "GL/CMI" as target RGS
  • Both in ARINC logs and in Ballinger's printout there is only one ULMSG block showing "GL/DEC" as target RGS
  • The last three ULMSG blocks showing "GL/CMI" as target station in the ARINC logs are also apparently followed by an ICPUL block with Reason Code 231 (see above)
  • The corresponding three messages in Ballinger's printout with target station "GL/CMI", however, show "1" as value, as shown in the column "FLAG_31" above
  • In the ARINC logs the last ULMSG block also shows "GL/DEC" as RGS and is also followed by an ICPUL block with Reason Code 231

[1] This appears clear from last uplink (asterisks, no second timestamp, no counter number)  and from the statement by Steve Ledger, Director of AQP services, in MFR04020032:

MFR 04020032, p. 2



Original post (in Italian) here.