EFTA00027585.pdf

Type: pdf
Source set: data-set-8
Extracted text

From: 
To: 
Cc: 
Subject: RE: Aircraft info 
Date: Tue, 28 Jan 2020 17:04:47 +0000 
Attachments: SIMPLEFLIGHTPLANSN331JE (2010-2020).xlsx; 
SIMPLE FLIGHT PLANS N491GM (2000-2009).xlsx; 
SIMPLE FLIGHT PLANS N491GM (2010-2020).xlsx; 
SIMPLE FLIGHT PLANS N722JE (2010-2014).xlsx; 
SIMPLE FLIGHT PLANS N722JE (2015-2020).xlsx 
I am sending some of the Flight Plan information that you requested. This information pertains to the helicopters that we 
discussed, including N491GM (for which we are still uncertain on the exact dates of ownership.) I hope that there is some 
useful information in here. Hopefully, you have someone who is good with Excel. That's the best way to be able to analyze 
or quickly find the information you might be looking for. 
I have included a few notes here to help you understand the information, but if you have questions, you can give me a 
call. 
The first thing you are probably going to wonder about are the dates which are part of the Dept Time, Dest Time columns, 
but also system tracking dates (more easily understandable) all the way to the right. You'll eventually notice that the 
earliest information on this batch of information is from 2007. It was around that time that we started keeping these 
records. 
The Airport Codes are the ICAO codes. The easiest way to figure out the departure and destination is to either google the 
airport identifier or use the list at this site: https://en.wikipedia.org/wiki/ICAO airport code 
All airports in the continental US begin with the ICAO code K. So if you see a three letter code, it is likely in the US, and 
would be prefaced with "K" in the ICAO code. For example, BOS (Boston Logan International Airport is KBOS). JFK is KJFK. 
All times (DEPT TIME, DEST TIME, ETA) are in Universal Coordinated Time (UTC) which we use in aviation. The format in 
these columns is: CDDTTTT. "C" is an internal code, "DD" is the day, and "TTTT" is the time, UTC, in 24-hour format. 
DEPT DOM and DEST DOM reflect whether the De…
Open in the interactive archive →