Skip to content

Instantly share code, notes, and snippets.

@kingkastle
Last active August 29, 2015 14:17
Show Gist options
  • Save kingkastle/7188565a417968331fda to your computer and use it in GitHub Desktop.
Save kingkastle/7188565a417968331fda to your computer and use it in GitHub Desktop.

Summary:

This project is part of the Udacity Data Analyst Nanodegree Project 5, with the aim of sharing knowledge with others. This is a dimplejs example based on the flight data from RITA that you can find at:

http://stat-computing.org/dataexpo/2009/the-data.html

The graph represents the evolution in terms of number of flights per year versus total distance accumulated per airline per year for the period between 1988 to 2008.

Check it out in b.locks: http://bl.ocks.org/kingkastle/raw/7188565a417968331fda/

Story:

This graph represents the evolution of the commercial aviation, in particular US airlines during the period 1988-2008, the main parameters represented are:

  • Total flights per year
  • Average Flight Distance per year
  • Total Airlines per year

Based on these variables and its evolution during the period, the following conclusions can be made:

  1. Constant increase of the Average flight distance: While years pass there is a constant increase of the average flight distance for all airlines, a probable reason for this would be the technological evolution of the aircrafts. It seems airlines compete each other to reach new destinations further away or create new further appart connections.
  2. Increase of the Number of Flights: In the overall, the amount of flights per year gradually increases except for two particular years: 2002 and 2008. As we know, 11-September 2002 and economical crisis in 2008 could be the events to explain this decrease in the overall number of flights.
  3. Market fragmentation: What happend after 2002? there are a bunch of new airlines into play, after the aviation crisis in 2002 new investors invested in new airlines?... These questions go beyond the scope of this graph.

Older Versions

The files: · output_previous.tsv · index_previous.html

Correspond to the previous dimple graph submmited, but after instructors' notes, this version was disregarded.

Design

This current version is much simpler, in terms of coding, than the previous version. However it is much easier to interpretate.

This current version is motivated by the comment of the last instructor's review: "I do think this visualization (Previous visualization, in this case) is explanatory and that you've found a really interesting story to tell (average flight distance is increasing and airlines are flying more flights). My only criticism is on the design choices and how the information is displayed. This project can be very subjective to grade, but I think there is a clearer way to encode the information so that your story really comes through. I made a rough draft plot in R that I'd like you to consider. http://postimg.org/image/dbgq31bb9/ My version is quite over plotted, but I've changed the encoding so that year is on the x-axis, plot type is a line chart, average flight is on the y-axis, and point radius is the number of flights. Your main conclusions about the data have to do with time (story section 1, 2 and 5). It's important to feature the time variable as a position encoding because it's so important to your story (position is usually the most important encoding for a reader). To avoid over plotting, you could actually make multiple plots based on market strategy: one plot for the big legacy airlines, one plot for regional short distance airlines. Or categorize airline by market type and give airlines with the same market type the same color. Right now, it's really hard for me to follow the trends over time. I have to mentally choose an airline, and with each new year try to locate its color as it skips around. But I can't really follow two airlines at once to compare them or see general trends over time because so many airlines come in and out of the data set. But again, I like the story you're telling."

So, starting from instructor's example, I decided to focus on the main bullets that the graph wants to convey:

  1. Evolution of the flight per year
  2. Evolution of the average flight distance per year
  3. Evolution in the number of airlines

Based on these points, I created this simple graph which clearly shows the evolution of this points. At this stage, I don't try to create a fancy graph, like the previous one, but a graph that conveys the right message in the simplest possible way. So in the x-axis is represented the time variable, the first y-axis includes the total flights per year computed for all airlines, secondary y-axis includes the averaged flight distance averaged for all airlines per year and the bar chart includes the total number of airlines per year.

To end, contrary to the instructor's recomendation of representing all the airlines, I prefer to represent the resulting numbers of all of them, as I think this is a better way to convey the right message and of course, avoid overplotting issues that may confuse readers.

How to use it

  1. Download the data from the RITA portal: http://stat-computing.org/dataexpo/2009/the-data.html
  2. Download the carriers.csv file from: http://stat-computing.org/dataexpo/2009/carriers.csv
  3. In the Python file, on line 4, change the path to use the one where all your downloaded files from the previous points are
  4. The Python file creates the file: "output3.tsv", place this file where index.html is
  5. Open index.html and enjoy!

Resources

Main resource used is: http://dimplejs.org/advanced_examples_viewer.html?id=advanced_storyboard_control

Feedback

Here are some comments I received from some colleagues:

Colleague 1: What do you notice in the visualization? Every year is quite different for each airline. What questions do you have about the data? It looks there is a lot of variation from year to year What relationships do you notice? Flights increase per year What do you think is the main takeaway from this visualization? Everything changes each year. Is there something you don’t understand in the graphic? Everything is clear for me, all is easy to see in this graph.

Colleague 2: What do you notice in the visualization? There is an almost linear increase of the flights per year except for 2002, probably due to September 11? … What questions do you have about the data? None, it is clear info. … What relationships do you notice?

  1. Seems to be a linear correlation between flight number and distance per airline
  2. Seems not to be any correlation between average delay per flight and number of flights per year or distance. … What do you think is the main takeaway from this visualization? Basically, the selection of these 3 variables. … Is there something you don’t understand in the graphic? No

Colleague 3: What do you notice in the visualization? You can see how airlines increase their business (number of flights) and how airlines evolve through the years. What questions do you have about the data? I can find a correlation between delay and distance or number of flights. What relationships do you notice? Number of flights and distance are correlated. What do you think is the main takeaway from this visualization? See the market evolution Is there something you don’t understand in the graphic? Everything is clear

Udacity Coach: He inspired most of the changes since the first version.

import bz2, math
import json, csv
import pandas
import numpy as np
data_path = r"C:\Users\sesa219988\Desktop\TRABAJO\Udacity\Pt5\data\\"
### Define the variables of interest:
Year = "Year"
DepDelay = "DepDelay"
UniqueCarrier = "UniqueCarrier"
Distance = "Distance"
Cancelled = "Cancelled"
CancellationCode = "CancellationCode"
### Create the object stores all the data in the right format:
per_year = {}
def carrierfinder(UniqueCarrier):
with open(data_path + "carriers.csv") as carrier_file:
for line in carrier_file:
if UniqueCarrier in line: return line.split(",")[1].strip()[1:-1]
return "Carrier Not found"
def fill_Data(Year,UniqueCarrier,DepDelay,Distance,Cancelled,CancellationCode):
# Next two fields could be "NA", in that cesa, these are transformed to 0:
if DepDelay == "NA": DepDelay = 0
if Distance == "NA": Distance = 0
if Cancelled == "NA": Cancelled = 0
if Year not in per_year: per_year[Year] = {}
if UniqueCarrier in per_year[Year]:
per_year[Year][UniqueCarrier]["Accumulated_Delay"] += int(DepDelay)
per_year[Year][UniqueCarrier]["Distance"] += int(Distance)
per_year[Year][UniqueCarrier]["Number_of_Flights"] += 1
per_year[Year][UniqueCarrier]["Cancelled"] += int(Cancelled)
#if Cancelled != "0": print "OK",Cancelled,per_year[Year][UniqueCarrier]["Cancelled"],Year,UniqueCarrier
else:
per_year[Year][UniqueCarrier] = {"Cancelled": 0, "Accumulated_Delay": int(DepDelay), "Distance": int(Distance),"Number_of_Flights": 1}
return per_year
"""
for year in range(1987,2009):
input_file = bz2.BZ2File(data_path + "{0}.csv.bz2".format(str(year)), 'rb')
for i,line in enumerate(input_file):
#if i > 3000: break
valores = line.split(",")
if i == 0:
idx_year = valores.index(Year)
idx_DepDelay = valores.index(DepDelay)
idx_UniqueCarrier = valores.index(UniqueCarrier)
idx_Distance = valores.index(Distance)
idx_Cancelled = valores.index(Cancelled)
idx_CancellationCode = valores.index(CancellationCode)
continue
fill_Data(valores[idx_year],carrierfinder(valores[idx_UniqueCarrier]),valores[idx_DepDelay],valores[idx_Distance],valores[idx_Cancelled],valores[idx_CancellationCode])
# print str(i) + " " + "Year: {0}, DepDelay: {1}, UniqueCarrier: {2}, Distance: {3}, Cancelled: {4}, CancelationCode: {5}".\
# format(valores[idx_year],valores[idx_DepDelay],carrierfinder(valores[idx_UniqueCarrier]),valores[idx_Distance],valores[idx_Cancelled],valores[idx_CancellationCode])
#break
with open(data_path + 'data.txt', 'w') as outfile:
json.dump(per_year, outfile)
"""
with open(data_path + 'data.txt','r') as data_file:
data = json.load(data_file)
field_names = ['Year', 'UniqueCarrier', 'Delay_per_Flight (minutes)', 'Distance', 'Number_of_Flights', 'Accumulated_Delay',"Cancelled", 'Cancel_per_Flight', 'Distance_per_Flight','Distance/Flights']
with open(data_path + 'output2.tsv', 'w') as output_file:
dw = csv.DictWriter(output_file, fieldnames = field_names, delimiter='\t')
dw.writeheader()
for year in data.keys():
for UniqueCarrier in data[year].keys():
temp_row = data[year][UniqueCarrier]
temp_row['Year'] = year
temp_row['UniqueCarrier'] = UniqueCarrier
temp_row['Delay_per_Flight (minutes)'] = round(float(temp_row['Accumulated_Delay'])/float(temp_row['Number_of_Flights']),2)
temp_row['Cancel_per_Flight'] = round(float(temp_row['Cancelled'])/float(temp_row['Number_of_Flights']),2)
temp_row['Distance_per_Flight'] = round(float(temp_row['Distance'])/float(temp_row['Number_of_Flights']),2)
temp_row['Distance/Flights'] = round(float(temp_row['Distance'])/float(temp_row['Number_of_Flights']),2)
dw.writerow(temp_row)
df = pandas.read_csv(data_path + 'output2.tsv',sep = "\t")
df_final = df.groupby('Year').agg({'Distance_per_Flight' : np.mean, 'Number_of_Flights' : np.sum, 'UniqueCarrier': np.size})
df_final['Distance_per_Flight'] = df_final['Distance_per_Flight'].apply(lambda x: int(x))
df_final['Number_of_Flights'] = df_final['Number_of_Flights'].apply(lambda x: int(x))
df_final = df_final.reset_index()
df_final.to_json(data_path + 'output3.tsv',orient = 'records')
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
</head>
<body>
<div>
<h1 style="text-align: center;"><span style="color:#696969;"><em><span style="font-size:18px;"><span style="font-family:comic sans ms,cursive;"><span style="background-color:#FFFFFF;">Commercial Aviation Evolution:</span><br />
<span style="background-color:#FFFFFF;">Average Flight Distance and Number of Flights per Year</span></span></span></em></span></h1>
</div>
<div id="chartContainer">
<script src="http://d3js.org/d3.v3.min.js"></script>
<script src="http://dimplejs.org/dist/dimple.v2.1.2.min.js"></script>
<script type="text/javascript">
var svg = dimple.newSvg("#chartContainer", 1300, 550);
d3.json("output3.tsv", function (data) {
var myChart = new dimple.chart(svg, data);
var x = myChart.addCategoryAxis("x", "Year");
var y1 = myChart.addMeasureAxis("y", "Number_of_Flights");
y1.overrideMin = 3000000;
var y2 = myChart.addMeasureAxis("y", "Distance_per_Flight");
y2.overrideMin = 500;
// Plot the bars first - the order of series determines their dom position
// from back to front, this means bars are at the back.
var y3 = myChart.addMeasureAxis("y", "UniqueCarrier");
var s3 = myChart.addSeries("Number of Airlines", dimple.plot.bar, [x, y3]);
s3.afterDraw = function (shape, data) {
var s = d3.select(shape),
rect = {
x: parseFloat(s.attr("x")),
y: parseFloat(s.attr("y")),
width: parseFloat(s.attr("width")),
height: parseFloat(s.attr("height"))
};
if (rect.height >= 1) {
svg.append("text")
.attr("x", rect.x + rect.width / 2)
.attr("y", rect.y + rect.height / 2)
.attr("dy", "0.35em")
.style("text-anchor", "middle")
.style("font-size", "11px")
.style("font-family", "sans-serif")
.attr("fill", "white")
.style("opacity", 0.8)
.attr("dy", "0.35em")
.text(d3.format(",")(data.yValue));
}
};
var s1 = myChart.addSeries("Total Flights", dimple.plot.line, [x, y1]);
var s2 = myChart.addSeries("Averaged Flight Distance", dimple.plot.line, [x, y2]);
myChart.addLegend(100, 10, 1200, 60);
myChart.assignColor("Number of Airlines", "teal", "teal", 0.50);
myChart.assignColor("Total Flights", "red", "red", 0.95);
myChart.assignColor("Averaged Flight Distance", "green", "green", 0.95);
myChart.draw();
d3.select("text[y = '275']").text("Total Flights (1m = 1000000)");
d3.select("text[x = '1217']").text("Averaged Flight Distance in miles");
d3.select("text[x = '1190']").remove();
// Set some custom display elements for each series shape
});
</script>
</div>
</body>
</html>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
</head>
<body>
<div>
<h1 style="text-align: center;"><span style="color:#696969;"><em><span style="font-size:18px;"><span style="font-family:comic sans ms,cursive;"><span style="background-color:#FFFFFF;">Commercial Aviation Evolution:</span><br />
<span style="background-color:#FFFFFF;">Average Flight Distance and Number of Flights per Airline per Year</span></span></span></em></span></h1>
</div>
<div id="chartContainer">
<script src="http://d3js.org/d3.v3.min.js"></script>
<script src="http://dimplejs.org/dist/dimple.v2.1.2.min.js"></script>
<script type="text/javascript">
var svg = dimple.newSvg("#chartContainer", 1400, 650);
d3.tsv("output_previous.tsv", function (data) {
// Filter for 1 year
data = dimple.filterData(data, "Year", [
"1988", "1989", "1990", "1991", "1992",
"1993", "1994", "1995", "1996", "1997", "1998",
"1999", "2000", "2001", "2002", "2003", "2004",
"2005", "2006", "2007", "2008"
]);
// console.table(data);
// Create the indicator chart on the right of the main chart
var indicator = new dimple.chart(svg, data);
// Pick blue as the default and orange for the selected month
var defaultColor = indicator.defaultColors[0];
var indicatorColor = indicator.defaultColors[2];
// The frame duration for the animation in milliseconds
var firstclick = false;
// Place the indicator bar chart to the right
indicator.setBounds(980, 150, 200, 311);
// Add dates along the y axis
var y = indicator.addCategoryAxis("y", "Year");
y.addOrderRule("Date", "Desc");
// Use sales for bar size and hide the axis
var x = indicator.addMeasureAxis("x", "Distance");
x.hidden = true;
// Add the bars to the indicator and add event handlers
var s = indicator.addSeries(null, dimple.plot.bar);
s.addEventHandler("click", onClick);
// Draw the side chart
indicator.draw();
// Remove the title from the y axis
y.titleShape.remove();
// Remove the lines from the y axis
y.shapes.selectAll("line,path").remove();
// Move the y axis text inside the plot area
y.shapes.selectAll("text")
.style("text-anchor", "start")
.style("font-size", "11px")
.attr("transform", "translate(18, 0.5)");
// This block simply adds the legend title. I put it into a d3 data
// object to split it onto 2 lines. This technique works with any
// number of lines, it isn't dimple specific.
svg.selectAll("title_text")
.data(["Click bar to select",
"and stop animation."])
.enter()
.append("text")
.attr("x", 980)
.attr("y", function (d, i) { return 110 + i * 12; })
.style("font-family", "sans-serif")
.style("font-size", "10px")
.style("color", "Black")
.text(function (d) { return d; });
// Manually set the bar colors
s.shapes
.attr("rx", 10)
.attr("ry", 10)
.style("fill", defaultColor.fill)
.style("stroke", defaultColor.stroke)
.style("opacity", 0.4);
// Draw the initial plot for the first year in the serie: 1988
var Year = 1988;
draw_airlines(Year.toString());
s.shapes
.style("fill", function (d) { return (d.y != Year ? defaultColor.fill : indicatorColor.fill) })
.style("stroke", function (d) { return (d.y != Year ? defaultColor.stroke : indicatorColor.stroke) });
// Update plot every 2 seconds while user doesn't click on the bars:
setInterval(run_update, 2000);
// Define update runner function:
function run_update(){
if(!firstclick){
Year++;
if (Year > 2008){Year = 1988};
update_chart(Year.toString());
s.shapes
.style("fill", function (d) { return (d.y != Year ? defaultColor.fill : indicatorColor.fill) })
.style("stroke", function (d) { return (d.y != Year ? defaultColor.stroke : indicatorColor.stroke) });
};
};
// Draw the main chart Number of Flights Delay_per_Flight (minutes) Cancelled Distance_per_Flight Cancel_per_Flight
function draw_airlines(Year){
datay = dimple.filterData(data, "Year", [Year]);
bubbles = new dimple.chart(svg, datay);
bubbles.setBounds(70, 80, 900, 500)
var myXAxis = bubbles.addMeasureAxis("x", "Distance_per_Flight");
var myYAxis = bubbles.addMeasureAxis("y", "Number of Flights");
myXAxis.overrideMax = 1500 //1000000000;
myYAxis.overrideMax = 1300000;
//bubbles.addMeasureAxis("z", "Delay_per_Flight (minutes)");
bubbles.addSeries("UniqueCarrier", dimple.plot.bubble);
bubbles.addLegend(10, 10, 1200, 60,"UniqueCarrier");
bubbles.draw();
d3.select("text[y = '330']").text("Number of Flights (1m = 1000000)");
d3.select("text[x = '520']").text("Average Distance per Flight in k·miles ( 1k = 1000)");
//console.table(datay);
update_color();
};
// Define update function:
function update_chart(Year){
d3.selectAll("g.dimple-legend").remove();
d3.selectAll("circle.dimple-bubble").remove();
d3.selectAll(".dimple-custom-axis-line").remove();
d3.selectAll("text[y='0'].dimple-custom-axis-label").remove()
d3.selectAll("text[x='0'].dimple-custom-axis-label").remove()
d3.selectAll(".dimple-gridline").remove();
d3.selectAll(".dimple-title").remove();
d3.selectAll(".dimple-tooltip").remove();
d3.selectAll("circle").remove();
d3.selectAll("line").remove();
draw_airlines(Year)
//bubbles.series.forEach(function(series){series.shapes.remove();});
//datay = dimple.filterData(data, "Year", [Year]);
//bubbles.data = datay;
//bubbles.addSeries("UniqueCarrier", dimple.plot.bubble);
//bubbles.draw();
//console.table(datay);
//update_color();
};
// On click of the side chart
function onClick(e) {
firstclick = true;
s.shapes
.style("fill", function (d) { return (d.y != e.yValue ? defaultColor.fill : indicatorColor.fill) })
.style("stroke", function (d) { return (d.y != e.yValue ? defaultColor.stroke : indicatorColor.stroke) });
update_chart(e.yValue.toString());
};
// Since d3 color palets are up to 20 elements and there are 29 Airlines, we need to create a custom palet:
function update_color(){
var airlines = ["dimple-arizona-pacific-inc-", "dimple-custom-air-service", "dimple-manu-a-air-transport", "dimple-dawn-air", "dimple-pan-american-world-airways--1-", "dimple-stateswest-airlines", "dimple-business-express-airlines", "dimple-air-cargo-enterprises-inc-", "dimple-american-airlines-inc-", "dimple-delta-air-lines-inc-", "dimple-alaska-airlines-inc-", "dimple-freedom-airlines-d-b-a-hp-expr", "dimple-northwest-airlines-inc-", "dimple-psa-airlines-inc-", "dimple-midway-airlines-inc---1-", "dimple-advance-air-charters", "dimple-multi-aer", "dimple-independence-air", "dimple-atlantic-southeast-airlines", "dimple-airtran-airways-corporation", "dimple-jetblue-airways", "dimple-skywest-airlines-inc-", "dimple-air-america-inc-", "dimple-trans-air--hawaii-", "dimple-acm-air-charter-gmbh", "dimple-comair-inc-", "dimple-frontier-airlines-inc-", "dimple-mesa-airlines-inc-", "dimple-pinnacle-airlines-inc-"];
var colors = d3.scale.category20().range().concat(d3.scale.category20b().range());
var current_airlines_obj = d3.selectAll("g.dimple-legend")[0];
var current_airlines = [];
current_airlines_obj.forEach(function getairline(element){
var new_airline = (element['classList'][1]);
if (current_airlines.indexOf(new_airline) == -1){current_airlines.push(new_airline);}
});
for (var i = 0; i < current_airlines.length ; i++){
var airline = current_airlines[i];
var color = colors[airlines.indexOf(airline)];
d3.select("rect." + airline).style('fill', color);
d3.select("circle." + airline).attr('fill',color);
d3.select("rect." + airline).style('stroke', color);
d3.select("circle." + airline).attr('stroke',color);
d3.select("circle." + airline).attr('r',40);
};
};
});
</script>
</div>
</body>
</html>
We can make this file beautiful and searchable if this error is corrected: No tabs found in this TSV file in line 0.
[{"Year":1988,"Number_of_Flights":5202096,"UniqueCarrier":14,"Distance_per_Flight":561},{"Year":1989,"Number_of_Flights":5041200,"UniqueCarrier":13,"Distance_per_Flight":594},{"Year":1990,"Number_of_Flights":5270893,"UniqueCarrier":12,"Distance_per_Flight":622},{"Year":1991,"Number_of_Flights":5076925,"UniqueCarrier":12,"Distance_per_Flight":646},{"Year":1992,"Number_of_Flights":5092157,"UniqueCarrier":10,"Distance_per_Flight":648},{"Year":1993,"Number_of_Flights":5070501,"UniqueCarrier":10,"Distance_per_Flight":660},{"Year":1994,"Number_of_Flights":5180048,"UniqueCarrier":10,"Distance_per_Flight":670},{"Year":1995,"Number_of_Flights":5327435,"UniqueCarrier":10,"Distance_per_Flight":701},{"Year":1996,"Number_of_Flights":5351983,"UniqueCarrier":10,"Distance_per_Flight":722},{"Year":1997,"Number_of_Flights":5411843,"UniqueCarrier":10,"Distance_per_Flight":738},{"Year":1998,"Number_of_Flights":5384721,"UniqueCarrier":10,"Distance_per_Flight":756},{"Year":1999,"Number_of_Flights":5527884,"UniqueCarrier":10,"Distance_per_Flight":773},{"Year":2000,"Number_of_Flights":5683047,"UniqueCarrier":11,"Distance_per_Flight":732},{"Year":2001,"Number_of_Flights":5967780,"UniqueCarrier":12,"Distance_per_Flight":713},{"Year":2002,"Number_of_Flights":5271359,"UniqueCarrier":10,"Distance_per_Flight":775},{"Year":2003,"Number_of_Flights":6488540,"UniqueCarrier":18,"Distance_per_Flight":738},{"Year":2004,"Number_of_Flights":7129270,"UniqueCarrier":19,"Distance_per_Flight":743},{"Year":2005,"Number_of_Flights":7140596,"UniqueCarrier":20,"Distance_per_Flight":766},{"Year":2006,"Number_of_Flights":7141922,"UniqueCarrier":20,"Distance_per_Flight":760},{"Year":2007,"Number_of_Flights":7453215,"UniqueCarrier":20,"Distance_per_Flight":715},{"Year":2008,"Number_of_Flights":7009728,"UniqueCarrier":20,"Distance_per_Flight":717}]
Year UniqueCarrier Delay_per_Flight (minutes) Distance Number of Flights Accumulated_Delay Cancelled Cancel_per_Flight Distance_per_Flight
1987 Pan American World Airways (1) 4.89 10068007 16785 82124 199 0.01 599.82
1987 Manu'a Air Transport 8.1 117710719 152624 1236426 3436 0.02 771.25
1987 Freedom Airlines d/b/a HP Expr 6.12 20926761 45399 277978 536 0.01 460.95
1987 PSA Airlines Inc. 13.04 15129925 41706 543799 879 0.02 362.78
1987 Alaska Airlines Inc. 8.22 10262253 21406 175947 215 0.01 479.41
1987 Custom Air Service 7.32 41474053 94814 694465 755 0.01 437.43
1987 American Airlines Inc. 5.86 117098261 165121 967855 1956 0.01 709.17
1987 Northwest Airlines Inc. 6.76 62943199 108273 731537 1587 0.01 581.34
1987 Arizona Pacific Inc. 7.64 41522106 116482 890276 1229 0.01 356.47
1987 Dawn Air 8.38 22667532 61975 519240 631 0.01 365.75
1987 Stateswest Airlines 6.97 45747887 69650 485575 1243 0.02 656.83
1987 Business Express Airlines 8.63 66829625 108776 939117 2454 0.02 614.38
1987 Delta Air Lines Inc. 7.29 112128146 185813 1354304 2057 0.01 603.45
1987 Air Cargo Enterprises Inc. 12.36 90500798 123002 1520714 2508 0.02 735.77
1988 Pan American World Airways (1) 6.16 43610538 72264 444828 863 0.01 603.49
1988 Manu'a Air Transport 7.43 468568904 587144 4360216 5766 0.01 798.05
1988 Freedom Airlines d/b/a HP Expr 4.2 81974990 180871 758834 973 0.01 453.22
1988 PSA Airlines Inc. 4.59 15144865 41911 192466 272 0.01 361.36
1988 Alaska Airlines Inc. 5.75 45020465 89822 516603 699 0.01 501.22
1988 Custom Air Service 7.32 218733461 494383 3618503 4562 0.01 442.44
1988 American Airlines Inc. 5.64 490624035 694757 3917608 6611 0.01 706.18
1988 Northwest Airlines Inc. 5.83 259851910 431440 2514446 6174 0.01 602.29
1988 Arizona Pacific Inc. 7.88 174913457 470957 3710592 4314 0.01 371.4
1988 Dawn Air 5.95 99152826 262422 1561903 1465 0.01 377.84
1988 Stateswest Airlines 7.07 186781826 275819 1949371 2466 0.01 677.19
1988 Business Express Airlines 8.66 237088574 389292 3370105 6606 0.02 609.03
1988 Delta Air Lines Inc. 5.05 460202093 753983 3806765 4469 0.01 610.36
1988 Air Cargo Enterprises Inc. 8.38 341060782 457031 3830578 4923 0.01 746.25
1989 Pan American World Airways (1) 7.69 53379180 79333 609988 974 0.01 672.85
1989 Manu'a Air Transport 10.57 461671701 574674 6076703 8912 0.02 803.36
1989 Delta Air Lines Inc. 6.53 482548479 783320 5112434 4708 0.01 616.03
1989 Alaska Airlines Inc. 5.88 46955949 89122 524206 1027 0.01 526.87
1989 Custom Air Service 10.57 319526922 712342 7530879 12406 0.02 448.56
1989 American Airlines Inc. 7.01 533359630 723252 5066846 9969 0.01 737.45
1989 Northwest Airlines Inc. 5.52 287155386 451752 2493364 5017 0.01 635.65
1989 Arizona Pacific Inc. 12.81 115366630 286518 3669272 3367 0.01 402.65
1989 Dawn Air 8.31 106972169 288802 2400844 2079 0.01 370.4
1989 Stateswest Airlines 7.28 190771565 276471 2012739 3153 0.01 690.02
1989 Business Express Airlines 7.21 99415524 169704 1223888 17516 0.1 585.82
1989 Freedom Airlines d/b/a HP Expr 5.52 93470285 195588 1079756 1126 0.01 477.89
1989 Air Cargo Enterprises Inc. 7.17 309652538 410322 2942785 3911 0.01 754.66
1991 Pan American World Airways (1) 3.28 48134936 64729 212128 825 0.01 743.64
1991 Custom Air Service 4.73 443792474 907184 4286942 6932 0.01 489.2
1991 Delta Air Lines Inc. 6.95 544305369 874791 6076045 5990 0.01 622.21
1991 Midway Airlines Inc. (1) 6.11 47795815 70622 431592 1342 0.02 676.78
1991 Alaska Airlines Inc. 4.3 54706190 98952 425218 858 0.01 552.86
1991 Manu'a Air Transport 7.52 496374950 630093 4737274 8732 0.01 787.78
1991 American Airlines Inc. 4.67 567507715 725191 3389403 4951 0.01 782.56
1991 Northwest Airlines Inc. 3.1 312097356 460230 1425349 2741 0.01 678.13
1991 Dawn Air 7.03 135417401 368734 2591113 2459 0.01 367.25
1991 Stateswest Airlines 5.55 167637076 231769 1286348 2870 0.01 723.29
1991 Freedom Airlines d/b/a HP Expr 6.95 128179520 219896 1527674 2204 0.01 582.91
1991 Air Cargo Enterprises Inc. 6.06 317729854 424734 2572117 3600 0.01 748.07
1990 Pan American World Airways (1) 4.58 58717695 83056 380628 660 0.01 706.97
1990 Custom Air Service 6.1 465972357 1002485 6111558 10496 0.01 464.82
1990 Delta Air Lines Inc. 7.48 494201392 824062 6160471 6242 0.01 599.71
1990 Alaska Airlines Inc. 5.44 52875329 97934 532986 945 0.01 539.91
1990 Manu'a Air Transport 7.65 487674537 606713 4638938 7894 0.01 803.8
1990 American Airlines Inc. 6.58 517738706 712060 4688295 6764 0.01 727.1
1990 Northwest Airlines Inc. 4.89 303488967 461745 2258154 5071 0.01 657.27
1990 Dawn Air 8.72 117721885 322759 2814056 2150 0.01 364.74
1990 Stateswest Airlines 7.14 187464660 264182 1886618 3457 0.01 709.6
1990 Business Express Airlines 8.71 154102111 252013 2196189 2126 0.01 611.48
1990 Freedom Airlines d/b/a HP Expr 6.39 116938068 216314 1381193 1605 0.01 540.59
1990 Air Cargo Enterprises Inc. 7.03 317981463 427570 3007383 5048 0.01 743.69
1993 Custom Air Service 6.34 435096905 833131 5278039 14562 0.02 522.24
1993 Delta Air Lines Inc. 7.71 563244691 898896 6928395 8381 0.01 626.6
1993 Alaska Airlines Inc. 3.51 58777940 98431 345658 639 0.01 597.15
1993 Manu'a Air Transport 7.07 544308789 649086 4588380 6913 0.01 838.58
1993 American Airlines Inc. 5.68 668582565 786696 4465156 9269 0.01 849.86
1993 Northwest Airlines Inc. 2.97 329998934 474831 1411647 7881 0.02 694.98
1993 Dawn Air 5.18 183052326 488332 2529691 2265 0.0 374.85
1993 Stateswest Airlines 5.11 168328697 244782 1251996 3532 0.01 687.67
1993 Freedom Airlines d/b/a HP Expr 6.32 113169123 176756 1117417 1033 0.01 640.26
1993 Air Cargo Enterprises Inc. 6.58 326188051 419560 2761768 5370 0.01 777.45
1992 Custom Air Service 6.33 445658190 886305 5609312 18987 0.02 502.83
1992 Delta Air Lines Inc. 7.35 571377297 916593 6738874 6499 0.01 623.37
1992 Alaska Airlines Inc. 4.19 58769173 102207 428723 959 0.01 575.0
1992 Manu'a Air Transport 5.75 514302250 639349 3675325 7996 0.01 804.42
1992 American Airlines Inc. 5.2 632696671 782371 4069980 5031 0.01 808.69
1992 Northwest Airlines Inc. 3.18 331249203 474931 1509183 3930 0.01 697.47
1992 Dawn Air 4.01 159512380 422912 1695768 1373 0.0 377.18
1992 Stateswest Airlines 5.55 172455300 246449 1368473 2537 0.01 699.76
1992 Freedom Airlines d/b/a HP Expr 5.08 123889922 199066 1011715 999 0.01 622.36
1992 Air Cargo Enterprises Inc. 6.06 327287436 421974 2557676 4525 0.01 775.61
1995 Manu'a Air Transport 10.05 621849199 724807 7282295 13326 0.02 857.95
1995 Freedom Airlines d/b/a HP Expr 7.86 132070386 194508 1528205 3030 0.02 679.0
1995 Alaska Airlines Inc. 6.41 96104161 135124 865690 1928 0.01 711.23
1995 Custom Air Service 7.88 426550655 778835 6138434 13898 0.02 547.68
1995 American Airlines Inc. 7.39 683619691 688471 5090204 11295 0.02 992.95
1995 Northwest Airlines Inc. 6.27 356173635 521693 3268744 13112 0.03 682.73
1995 Dawn Air 8.21 275938737 693101 5691202 8140 0.01 398.12
1995 Stateswest Airlines 9.25 197919256 272452 2520010 6331 0.02 726.44
1995 Delta Air Lines Inc. 9.04 576699652 884019 7993449 12090 0.01 652.36
1995 Air Cargo Enterprises Inc. 6.83 334020121 434425 2965493 8755 0.02 768.88
1994 Custom Air Service 8.4 449688918 857906 7208478 19659 0.02 524.17
1994 Delta Air Lines Inc. 6.78 540487369 874526 5927278 9536 0.01 618.03
1994 Alaska Airlines Inc. 3.89 77047716 117475 456761 881 0.01 655.86
1994 Manu'a Air Transport 6.73 558059500 638750 4300614 8028 0.01 873.67
1994 American Airlines Inc. 5.56 660321329 722277 4015394 8195 0.01 914.22
1994 Northwest Airlines Inc. 3.67 330070533 482798 1772807 5214 0.01 683.66
1994 Dawn Air 6.4 217738899 565426 3619691 2465 0.0 385.09
1994 Stateswest Airlines 6.48 187316743 258205 1674074 3886 0.02 725.46
1994 Freedom Airlines d/b/a HP Expr 7.37 119145135 177851 1311473 1394 0.01 669.92
1994 Air Cargo Enterprises Inc. 7.77 319197943 484834 3767660 7482 0.02 658.37
1997 Custom Air Service 6.04 406207731 718751 4341189 12778 0.02 565.16
1997 Delta Air Lines Inc. 8.62 636831246 921850 7942948 13743 0.01 690.82
1997 Alaska Airlines Inc. 8.14 103802685 147750 1203119 3072 0.02 702.56
1997 Manu'a Air Transport 9.7 659011615 743847 7212661 16867 0.02 885.95
1997 American Airlines Inc. 7.2 688356659 663954 4779906 13479 0.02 1036.75
1997 Northwest Airlines Inc. 9.14 376954508 537152 4908255 13392 0.02 701.77
1997 Dawn Air 8.47 337104723 794849 6730358 9139 0.01 424.11
1997 Stateswest Airlines 7.12 201350310 274037 1951362 5785 0.02 734.76
1997 Freedom Airlines d/b/a HP Expr 7.68 158173093 206304 1583525 2767 0.01 766.7
1997 Air Cargo Enterprises Inc. 7.71 351488922 403349 3111134 6741 0.02 871.43
1996 Custom Air Service 8.84 406447998 728534 6440732 20191 0.03 557.9
1996 Delta Air Lines Inc. 10.28 606310150 888306 9130025 17119 0.02 682.55
1996 Alaska Airlines Inc. 10.66 102122436 144291 1538771 3225 0.02 707.75
1996 Manu'a Air Transport 12.16 644655733 735266 8938005 19819 0.03 876.77
1996 American Airlines Inc. 9.74 676145869 655539 6387015 14494 0.02 1031.44
1996 Northwest Airlines Inc. 7.96 375281041 543041 4324202 18476 0.03 691.07
1996 Dawn Air 8.76 310118387 757419 6638287 9459 0.01 409.44
1996 Stateswest Airlines 11.6 205981670 282176 3272407 11254 0.04 729.98
1996 Freedom Airlines d/b/a HP Expr 10.08 145689003 203001 2045833 4721 0.02 717.68
1996 Air Cargo Enterprises Inc. 8.38 341789218 414410 3472572 9778 0.02 824.76
1999 Custom Air Service 9.94 411028763 714430 7100165 32309 0.05 575.32
1999 Delta Air Lines Inc. 7.87 664521973 914130 7194471 21743 0.02 726.94
1999 Alaska Airlines Inc. 10.51 114528715 156098 1641096 5363 0.03 733.7
1999 Manu'a Air Transport 9.55 709191347 774370 7394945 27359 0.04 915.83
1999 American Airlines Inc. 9.43 710649551 692653 6532386 28960 0.04 1025.98
1999 Northwest Airlines Inc. 6.56 389477109 537180 3524816 12505 0.02 725.04
1999 Dawn Air 10.0 396279192 853683 8539608 7606 0.01 464.2
1999 Stateswest Airlines 8.05 207980931 275830 2221541 5009 0.02 754.02
1999 Freedom Airlines d/b/a HP Expr 11.71 180094162 209496 2452820 5162 0.02 859.65
1999 Air Cargo Enterprises Inc. 8.93 379935612 400014 3571745 8294 0.02 949.81
1998 Custom Air Service 7.22 392581913 696030 5025702 17214 0.02 564.03
1998 Freedom Airlines d/b/a HP Expr 13.6 164900616 203071 2762271 4479 0.02 812.03
1998 Alaska Airlines Inc. 9.05 109537336 152220 1376900 3510 0.02 719.6
1998 Manu'a Air Transport 11.4 676393243 748459 8535054 20684 0.03 903.71
1998 American Airlines Inc. 7.28 682695862 653919 4760992 14662 0.02 1044.01
1998 Northwest Airlines Inc. 9.63 376380175 527512 5078052 44270 0.08 713.5
1998 Dawn Air 9.47 358919180 815069 7721419 8940 0.01 440.35
1998 Stateswest Airlines 8.83 206544228 274073 2418764 6563 0.02 753.61
1998 Delta Air Lines Inc. 6.93 644600128 915095 6339623 16925 0.02 704.41
1998 Air Cargo Enterprises Inc. 8.19 364224634 399273 3271835 7262 0.02 912.22
2002 Multi-Aer 5.39 132234557 439984 2369391 12777 0.03 300.54
2002 Custom Air Service 3.64 315386496 511664 1860425 5632 0.01 616.39
2002 Delta Air Lines Inc. 5.5 571459930 728758 4011043 8065 0.01 784.16
2002 Alaska Airlines Inc. 7.19 126360807 159194 1144349 3553 0.02 793.75
2002 Manu'a Air Transport 4.63 588480440 587887 2720805 4622 0.01 1001.01
2002 American Airlines Inc. 4.42 845801567 852439 3770725 9621 0.01 992.21
2002 Northwest Airlines Inc. 4.75 379226160 513331 2439309 7315 0.01 738.76
2002 Dawn Air 8.83 512696665 956745 8447603 10238 0.01 535.88
2002 Freedom Airlines d/b/a HP Expr 6.2 185726579 196111 1216779 2023 0.01 947.05
2002 Air Cargo Enterprises Inc. 2.53 340771758 325246 821796 1297 0.0 1047.74
2003 Multi-Aer 4.87 143263376 429098 2089144 13673 0.03 333.87
2003 Manu'a Air Transport 4.62 565395453 543957 2512578 5919 0.01 1039.41
2003 Delta Air Lines Inc. 4.5 533271871 660617 2973962 6943 0.01 807.23
2003 ACM AIR CHARTER GmbH 1.03 4776545 7831 8062 37 0.0 609.95
2003 Skywest Airlines Inc. 5.36 130128864 396801 2125532 6501 0.02 327.94
2003 Custom Air Service 4.11 274720596 411956 1693836 6358 0.02 666.87
2003 Alaska Airlines Inc. 5.67 134600560 161594 916855 3483 0.02 832.96
2003 AirTran Airways Corporation 6.83 86251075 144700 988221 1614 0.01 596.07
2003 Independence Air 9.05 104531297 291600 2638536 11012 0.04 358.47
2003 American Airlines Inc. 4.6 784930194 752241 3459811 12080 0.02 1043.46
2003 Air America Inc. 4.73 78977471 69176 327166 855 0.01 1141.69
2003 Northwest Airlines Inc. 2.16 368539061 499160 1077871 6114 0.01 738.32
2003 Trans Air (Hawaii) 4.06 159509398 328086 1332807 6026 0.02 486.18
2003 Dawn Air 6.64 533593672 958566 6360097 9718 0.01 556.66
2003 Freedom Airlines d/b/a HP Expr 5.76 189239126 189519 1092074 1983 0.01 998.52
2003 Air Cargo Enterprises Inc. 3.87 327606672 302742 1171639 2339 0.01 1082.13
2003 Atlantic Southeast Airlines 8.67 111226973 273712 2374338 6505 0.02 406.36
2003 JetBlue Airways 5.63 85579777 67184 378292 308 0.0 1273.81
2000 Custom Air Service 8.8 444985060 748624 6586411 28054 0.04 594.4
2000 Freedom Airlines d/b/a HP Expr 13.82 191005263 219160 3028721 9422 0.04 871.53
2000 Alaska Airlines Inc. 12.32 116785792 154171 1899553 7506 0.05 757.51
2000 Manu'a Air Transport 16.61 715927123 776559 12895873 44159 0.06 921.92
2000 American Airlines Inc. 10.6 747904093 742265 7865606 29677 0.04 1007.6
2000 Northwest Airlines Inc. 7.51 400846694 551337 4140802 15340 0.03 727.04
2000 Dawn Air 12.58 447356171 911699 11470445 9039 0.01 490.68
2000 Stateswest Airlines 9.4 212105822 267131 2512354 5254 0.02 794.01
2000 Delta Air Lines Inc. 9.13 677138954 908029 8287197 31569 0.03 745.72
2000 Air Cargo Enterprises Inc. 8.37 387716408 393036 3289400 7296 0.02 986.47
2000 Advance Air Charters 1.56 1827830 11036 17268 173 0.02 165.62
2001 Multi-Aer 9.69 131817371 489418 4744165 35382 0.07 269.33
2001 Custom Air Service 5.62 420479722 688748 3870767 30616 0.04 610.5
2001 Delta Air Lines Inc. 7.21 639844061 835236 6018513 32826 0.04 766.06
2001 Advance Air Charters 4.08 12206200 53798 219683 1489 0.03 226.89
2001 Manu'a Air Transport 10.5 669138699 704977 7399741 34522 0.05 949.16
2001 American Airlines Inc. 8.62 733691525 716985 6181171 32230 0.04 1023.3
2001 Northwest Airlines Inc. 5.61 392744195 533045 2989737 17494 0.03 736.79
2001 Dawn Air 8.6 490914269 957145 8230629 17692 0.02 512.89
2001 Stateswest Airlines 5.87 194988032 244721 1437045 5747 0.02 796.78
2001 Freedom Airlines d/b/a HP Expr 9.56 186583998 209979 2007274 6379 0.03 888.58
2001 Air Cargo Enterprises Inc. 5.38 382726381 377281 2029647 10996 0.03 1014.43
2001 Alaska Airlines Inc. 10.56 119423173 156447 1652522 5825 0.04 763.35
2006 Multi-Aer 11.04 226234557 550088 6075136 19990 0.04 411.27
2006 Custom Air Service 7.8 424539071 504844 3939983 5511 0.01 840.93
2006 Mesa Airlines Inc. 13.8 124121170 304764 4206546 9544 0.03 407.27
2006 Skywest Airlines Inc. 8.63 216557423 548109 4729541 12844 0.02 395.1
2006 Alaska Airlines Inc. 9.24 141610317 159404 1473647 2429 0.02 888.37
2006 Air Cargo Enterprises Inc. 10.97 351681979 309389 3393126 1649 0.01 1136.7
2006 Comair Inc. 9.15 131716279 278099 2544892 6875 0.02 473.63
2006 Atlantic Southeast Airlines 16.01 134767125 273143 4371670 6783 0.02 493.39
2006 Frontier Airlines Inc. 5.03 79275188 90181 453707 902 0.01 879.07
2006 Manu'a Air Transport 11.66 548162230 500008 5831704 10238 0.02 1096.31
2006 American Airlines Inc. 10.53 693419014 643597 6776914 10127 0.02 1077.41
2006 ACM AIR CHARTER GmbH -1.21 30675864 52173 -63173 253 0.0 587.96
2006 Northwest Airlines Inc. 6.94 330962751 432880 3005005 4854 0.01 764.56
2006 Trans Air (Hawaii) 9.68 236250267 441470 4271628 9716 0.02 535.14
2006 Dawn Air 10.21 682975022 1099321 11224333 8951 0.01 621.27
2006 Delta Air Lines Inc. 7.98 464314553 506086 4039668 7695 0.02 917.46
2006 Air America Inc. 12.71 28193870 19602 249165 227 0.01 1438.32
2006 Advance Air Charters -0.11 14781351 35387 -3908 745 0.02 417.71
2006 JetBlue Airways 11.25 184301996 155732 1751381 659 0.0 1183.46
2006 AirTran Airways Corporation 10.88 154760543 237645 2586282 1941 0.01 651.23
2007 Multi-Aer 12.64 224000420 540494 6830165 22792 0.04 414.44
2007 Manu'a Air Transport 13.57 529872242 490002 6648458 11929 0.02 1081.37
2007 Pinnacle Airlines Inc. 8.83 116904239 258851 2285792 7939 0.03 451.63
2007 Mesa Airlines Inc. 11.86 115405015 294362 3489825 11287 0.04 392.05
2007 Skywest Airlines Inc. 8.11 254654475 597882 4848850 14185 0.02 425.93
2007 Alaska Airlines Inc. 10.56 143155532 160185 1691897 2563 0.02 893.69
2007 Comair Inc. 12.13 112363280 233787 2835919 8851 0.04 480.62
2007 Atlantic Southeast Airlines 19.59 136346293 286234 5607544 8920 0.03 476.35
2007 Frontier Airlines Inc. 7.38 87466490 97760 721561 398 0.0 894.71
2007 Custom Air Service 11.92 404932885 485447 5787520 8942 0.02 834.14
2007 American Airlines Inc. 14.3 675105592 633857 9066828 17924 0.03 1065.08
2007 ACM AIR CHARTER GmbH -0.88 35337234 56175 -49390 238 0.0 629.06
2007 Northwest Airlines Inc. 8.76 318162390 414526 3630596 7814 0.02 767.53
2007 AirTran Airways Corporation 8.95 182646240 263159 2354142 2602 0.01 694.05
2007 Dawn Air 10.35 735264809 1168871 12094777 9993 0.01 629.04
2007 Trans Air (Hawaii) 11.58 242279090 434773 5035103 10800 0.02 557.25
2007 Delta Air Lines Inc. 7.75 447856024 475889 3686443 6521 0.01 941.09
2007 Air Cargo Enterprises Inc. 11.68 369480546 323151 3774557 2951 0.01 1143.37
2007 Advance Air Charters 0.44 19882075 46360 20168 388 0.01 428.86
2007 JetBlue Airways 14.45 213752433 191450 2767110 3710 0.02 1116.49
2004 Multi-Aer 8.16 176625169 483088 3943791 17787 0.04 365.62
2004 Manu'a Air Transport 7.16 592067318 555812 3978918 6548 0.01 1065.23
2004 Delta Air Lines Inc. 7.55 570594518 687638 5193312 10717 0.02 829.79
2004 ACM AIR CHARTER GmbH -0.22 27801132 48077 -10680 162 0.0 578.26
2004 Skywest Airlines Inc. 6.44 158682290 463448 2982997 9783 0.02 342.4
2004 Custom Air Service 6.74 284748509 419919 2830401 6778 0.02 678.1
2004 Comair Inc. 8.44 176075486 373346 3149903 13616 0.04 471.61
2004 AirTran Airways Corporation 9.86 101743795 162558 1602802 2013 0.01 625.89
2004 Atlantic Southeast Airlines 9.87 118739046 278861 2752684 7542 0.03 425.8
2004 Independence Air 11.07 94602968 264955 2932459 8287 0.03 357.05
2004 American Airlines Inc. 8.87 767069407 698548 6196410 12402 0.02 1098.09
2004 Air America Inc. 4.91 84723441 75533 370663 717 0.01 1121.67
2004 Northwest Airlines Inc. 4.15 375884993 507286 2102740 6010 0.01 740.97
2004 Trans Air (Hawaii) 5.23 189718254 367703 1921948 6103 0.02 515.96
2004 Dawn Air 10.05 570071702 990404 9955591 10103 0.01 575.6
2004 Freedom Airlines d/b/a HP Expr 7.93 203622782 195939 1553263 3108 0.02 1039.22
2004 Air Cargo Enterprises Inc. 5.93 331502782 299329 1775949 1898 0.01 1107.49
2004 Alaska Airlines Inc. 8.79 143215203 166992 1468593 3670 0.02 857.62
2004 JetBlue Airways 6.19 119957986 89834 556397 511 0.01 1335.33
2005 Multi-Aer 7.37 211059565 532032 3921978 16746 0.03 396.7
2005 Manu'a Air Transport 9.49 532116122 485918 4612759 6296 0.01 1095.07
2005 Delta Air Lines Inc. 7.93 564268170 658302 5218108 17731 0.03 857.16
2005 ACM AIR CHARTER GmbH -1.11 28642799 48183 -53692 69 0.0 594.46
2005 Skywest Airlines Inc. 5.68 195573943 517454 2941282 9639 0.02 377.95
2005 Custom Air Service 8.26 288955635 425609 3515474 8426 0.02 678.92
2005 Comair Inc. 6.44 170772547 381337 2457561 11370 0.03 447.83
2005 AirTran Airways Corporation 15.03 127526045 195392 2936370 2448 0.01 652.67
2005 Atlantic Southeast Airlines 12.59 139250724 304647 3836495 13900 0.05 457.09
2005 Frontier Airlines Inc. 5.69 48562429 53255 303223 175 0.0 911.88
2005 Independence Air 6.43 60671620 136492 877846 2877 0.02 444.51
2005 American Airlines Inc. 9.36 722852274 673569 6307716 9752 0.01 1073.17
2005 Air America Inc. 4.48 47556475 44109 197806 508 0.01 1078.16
2005 Northwest Airlines Inc. 7.73 365044151 480832 3716396 6937 0.01 759.19
2005 Trans Air (Hawaii) 6.68 213291464 403767 2698243 9353 0.02 528.25
2005 Dawn Air 10.06 628492880 1036034 10423665 8759 0.01 606.63
2005 Freedom Airlines d/b/a HP Expr 6.57 200373825 197853 1299227 2487 0.01 1012.74
2005 Air Cargo Enterprises Inc. 7.83 334136379 296661 2323384 2739 0.01 1126.32
2005 Alaska Airlines Inc. 13.32 138031164 158100 2106401 2630 0.02 873.06
2005 JetBlue Airways 10.26 150758132 111050 1139506 888 0.01 1357.57
2008 Multi-Aer 10.3 201593203 490693 5054033 18331 0.04 410.83
2008 Manu'a Air Transport 13.78 484785762 449515 6196282 10541 0.02 1078.46
2008 Pinnacle Airlines Inc. 6.59 118168788 262208 1726803 7100 0.03 450.67
2008 Mesa Airlines Inc. 11.57 100334283 254930 2950054 9219 0.04 393.58
2008 Skywest Airlines Inc. 7.3 243546417 567159 4137595 12436 0.02 429.41
2008 Alaska Airlines Inc. 6.75 144742019 151102 1020350 2139 0.01 957.91
2008 Comair Inc. 11.16 96362582 197607 2205401 6462 0.03 487.65
2008 Atlantic Southeast Airlines 11.71 124538592 280575 3285923 5026 0.02 443.87
2008 Frontier Airlines Inc. 5.9 84291468 95762 565097 303 0.0 880.22
2008 Custom Air Service 5.64 388224541 453589 2556181 6582 0.01 855.89
2008 American Airlines Inc. 12.9 637069849 604885 7802966 17440 0.03 1053.21
2008 ACM AIR CHARTER GmbH 0.45 34688791 61826 27887 570 0.01 561.07
2008 Northwest Airlines Inc. 6.41 279436146 347652 2228375 2906 0.01 803.78
2008 AirTran Airways Corporation 9.18 190280649 261684 2403285 2236 0.01 727.14
2008 Dawn Air 10.28 763307895 1201754 12349540 12389 0.01 635.16
2008 Trans Air (Hawaii) 11.09 220656045 374510 4154705 9992 0.03 589.19
2008 Delta Air Lines Inc. 7.89 416476755 451931 3564817 6813 0.02 921.55
2008 Air Cargo Enterprises Inc. 13.02 344201013 298455 3886953 3702 0.01 1153.28
2008 Advance Air Charters -1.39 3324846 7800 -10844 42 0.01 426.26
2008 JetBlue Airways 12.45 215745855 196091 2440878 3205 0.02 1100.23
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment