Ballinger's printout in .CSV format

Wednesday, February 15, 2012

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:





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:



[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.