1.Data preparation part.
In this part, I built the dataframe using data from the csv files I have created.
SMO <- data.frame(label = 'SMO', lon=-118.456667, lat=34.010167)
smo <- c(SMO$lon, SMO$lat)
data_0426_day<-read.csv('RTL150426_day.csv')
names(data_0426_day) <- c('number','timestamp','flight','code', 'track','id', 'lon','lat', 'alt','dist' )
data_0426_day$number <- NULL
data_0426_night<-read.csv('RTL150426_night.csv')
data_1129_day<-read.csv('RTL151129_day.csv')
data_1129_night<-read.csv('RTL151129_night.csv')
1.Airline numbers comparation.
In those coxcomb charts, each sector shows an airline during that period. The first and second coxcomb chart respectively represent the airlines in day-time and night-time of 04/26/2015. The third and forth coxcomb chart represent the airlines in day-time and night-time of 11/29/2015. Those chart shows that November is much busier than April for this airport.
#ggplot(data_0426_day, aes(code)) + geom_bar() + #counts of cars by code
# coord_polar()
ggplot(data_0426_day, aes(code, fill = code)) + #color the bars
geom_bar(width = 1) + coord_polar()

ggplot(data_0426_night, aes(code, fill = code)) + #color the bars
geom_bar(width = 1) + coord_polar()

ggplot(data_1129_day, aes(code)) + geom_bar(width = 1) + coord_polar()

ggplot(data_1129_night, aes(code, fill = code)) + #color the bars
geom_bar(width = 1) + coord_polar()

2.Airplane landing timeline.
In this chart, different color represents different flights, the chart shows the airplanes’ landing, first two charts shows the day-time and night-time of landing in 04/26/2015. The last two shows the day-time and night-time of landing in 11/29/2015. This chart shows day-time is always busier than night-time, and november is busier than April.
p <- ggplot(data_0426_day, aes(timestamp, alt))
p + geom_point(aes(color = factor(flight)))

q <- ggplot(data_0426_night, aes(timestamp, alt))
q + geom_point(aes(color = factor(flight)))

r <- ggplot(data_1129_day, aes(timestamp, alt))
r + geom_point()

#r + geom_point(aes(color = factor(flight)))
s <- ggplot(data_1129_night, aes(timestamp, alt))
s + geom_point(aes(color = factor(flight)))

LS0tCnRpdGxlOiAiWWlmYW5ZYW5nX0E0X25vdGVib29rIgpvdXRwdXQ6CiAgaHRtbF9ub3RlYm9vazogZGVmYXVsdAogIGh0bWxfZG9jdW1lbnQ6IGRlZmF1bHQKICB3b3JkX2RvY3VtZW50OiBkZWZhdWx0Ci0tLQoKCiMgMS5EYXRhIHByZXBhcmF0aW9uIHBhcnQuCgpJbiB0aGlzIHBhcnQsIEkgYnVpbHQgdGhlIGRhdGFmcmFtZSB1c2luZyBkYXRhIGZyb20gdGhlIGNzdiBmaWxlcyBJIGhhdmUgY3JlYXRlZC4KCgpgYGB7Un0KClNNTyA8LSBkYXRhLmZyYW1lKGxhYmVsID0gJ1NNTycsIGxvbj0tMTE4LjQ1NjY2NywgbGF0PTM0LjAxMDE2NykKc21vIDwtIGMoU01PJGxvbiwgU01PJGxhdCkKZGF0YV8wNDI2X2RheTwtcmVhZC5jc3YoJ1JUTDE1MDQyNl9kYXkuY3N2JykKbmFtZXMoZGF0YV8wNDI2X2RheSkgPC0gYygnbnVtYmVyJywndGltZXN0YW1wJywnZmxpZ2h0JywnY29kZScsICd0cmFjaycsJ2lkJywgJ2xvbicsJ2xhdCcsICdhbHQnLCdkaXN0JyApCmRhdGFfMDQyNl9kYXkkbnVtYmVyIDwtIE5VTEwKZGF0YV8wNDI2X25pZ2h0PC1yZWFkLmNzdignUlRMMTUwNDI2X25pZ2h0LmNzdicpCmRhdGFfMTEyOV9kYXk8LXJlYWQuY3N2KCdSVEwxNTExMjlfZGF5LmNzdicpCmRhdGFfMTEyOV9uaWdodDwtcmVhZC5jc3YoJ1JUTDE1MTEyOV9uaWdodC5jc3YnKQoKYGBgCgoKIyAxLkFpcmxpbmUgbnVtYmVycyBjb21wYXJhdGlvbi4KCkluIHRob3NlIGNveGNvbWIgY2hhcnRzLCBlYWNoIHNlY3RvciBzaG93cyBhbiBhaXJsaW5lIGR1cmluZyB0aGF0IHBlcmlvZC4gVGhlIGZpcnN0IGFuZCBzZWNvbmQgY294Y29tYiBjaGFydCByZXNwZWN0aXZlbHkgcmVwcmVzZW50IHRoZSBhaXJsaW5lcyBpbiBkYXktdGltZSBhbmQgbmlnaHQtdGltZSBvZiAwNC8yNi8yMDE1LiBUaGUgdGhpcmQgYW5kIGZvcnRoIGNveGNvbWIgY2hhcnQgcmVwcmVzZW50IHRoZSBhaXJsaW5lcyBpbiBkYXktdGltZSBhbmQgbmlnaHQtdGltZSBvZiAxMS8yOS8yMDE1LiBUaG9zZSBjaGFydCBzaG93cyB0aGF0IE5vdmVtYmVyIGlzIG11Y2ggYnVzaWVyIHRoYW4gQXByaWwgZm9yIHRoaXMgYWlycG9ydC4KCgpgYGB7Un0KI2dncGxvdChkYXRhXzA0MjZfZGF5LCBhZXMoY29kZSkpICsgZ2VvbV9iYXIoKSArICNjb3VudHMgb2YgY2FycyBieSBjb2RlCiMgIGNvb3JkX3BvbGFyKCkKZ2dwbG90KGRhdGFfMDQyNl9kYXksIGFlcyhjb2RlLCBmaWxsID0gY29kZSkpICsgI2NvbG9yIHRoZSBiYXJzCiAgZ2VvbV9iYXIod2lkdGggPSAxKSArIGNvb3JkX3BvbGFyKCkKCgpnZ3Bsb3QoZGF0YV8wNDI2X25pZ2h0LCBhZXMoY29kZSwgZmlsbCA9IGNvZGUpKSArICNjb2xvciB0aGUgYmFycwogIGdlb21fYmFyKHdpZHRoID0gMSkgKyBjb29yZF9wb2xhcigpCgoKZ2dwbG90KGRhdGFfMTEyOV9kYXksIGFlcyhjb2RlKSkgKyBnZW9tX2Jhcih3aWR0aCA9IDEpICsgY29vcmRfcG9sYXIoKQoKCmdncGxvdChkYXRhXzExMjlfbmlnaHQsIGFlcyhjb2RlLCBmaWxsID0gY29kZSkpICsgI2NvbG9yIHRoZSBiYXJzCiAgZ2VvbV9iYXIod2lkdGggPSAxKSArIGNvb3JkX3BvbGFyKCkKYGBgCgoKCgojIDIuQWlycGxhbmUgbGFuZGluZyB0aW1lbGluZS4KCkluIHRoaXMgY2hhcnQsIGRpZmZlcmVudCBjb2xvciByZXByZXNlbnRzIGRpZmZlcmVudCBmbGlnaHRzLCB0aGUgY2hhcnQgc2hvd3MgdGhlIGFpcnBsYW5lcycgbGFuZGluZywgZmlyc3QgdHdvIGNoYXJ0cyBzaG93cyB0aGUgZGF5LXRpbWUgYW5kIG5pZ2h0LXRpbWUgb2YgbGFuZGluZyBpbiAwNC8yNi8yMDE1LiBUaGUgbGFzdCB0d28gc2hvd3MgdGhlIGRheS10aW1lIGFuZCBuaWdodC10aW1lIG9mIGxhbmRpbmcgaW4gMTEvMjkvMjAxNS4gVGhpcyBjaGFydCBzaG93cyBkYXktdGltZSBpcyBhbHdheXMgYnVzaWVyIHRoYW4gbmlnaHQtdGltZSwgYW5kIG5vdmVtYmVyIGlzIGJ1c2llciB0aGFuIEFwcmlsLgoKYGBge3J9CnAgPC0gZ2dwbG90KGRhdGFfMDQyNl9kYXksIGFlcyh0aW1lc3RhbXAsIGFsdCkpIApwICsgZ2VvbV9wb2ludChhZXMoY29sb3IgPSBmYWN0b3IoZmxpZ2h0KSkpCgpxIDwtIGdncGxvdChkYXRhXzA0MjZfbmlnaHQsIGFlcyh0aW1lc3RhbXAsIGFsdCkpIApxICsgZ2VvbV9wb2ludChhZXMoY29sb3IgPSBmYWN0b3IoZmxpZ2h0KSkpCgpyIDwtIGdncGxvdChkYXRhXzExMjlfZGF5LCBhZXModGltZXN0YW1wLCBhbHQpKSAKciArIGdlb21fcG9pbnQoKQojciArIGdlb21fcG9pbnQoYWVzKGNvbG9yID0gZmFjdG9yKGZsaWdodCkpKQoKcyA8LSBnZ3Bsb3QoZGF0YV8xMTI5X25pZ2h0LCBhZXModGltZXN0YW1wLCBhbHQpKSAKcyArIGdlb21fcG9pbnQoYWVzKGNvbG9yID0gZmFjdG9yKGZsaWdodCkpKQoKCmBgYAoKCgo=