Data Qualities Issues Detection
Kiranna Indy 5052241014
2025-05-20
Team: Kiranna Indy 5052241014 Shafa Agnia Ramadhan 5052241029 Muhammad Razan Thariq Aqil 5052241025
Checking Data Quality Issues
Datasets
We will be using the flights datasets for this case
library(tidyverse)## Warning: package 'tidyverse' was built under R version 4.4.3## Warning: package 'ggplot2' was built under R version 4.4.3## Warning: package 'tibble' was built under R version 4.4.3## Warning: package 'tidyr' was built under R version 4.4.3## Warning: package 'readr' was built under R version 4.4.3## Warning: package 'purrr' was built under R version 4.4.3## Warning: package 'dplyr' was built under R version 4.4.3## Warning: package 'stringr' was built under R version 4.4.3## Warning: package 'forcats' was built under R version 4.4.3## Warning: package 'lubridate' was built under R version 4.4.3## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.4 ✔ readr 2.1.5
## ✔ forcats 1.0.0 ✔ stringr 1.5.1
## ✔ ggplot2 3.5.2 ✔ tibble 3.2.1
## ✔ lubridate 1.9.4 ✔ tidyr 1.3.1
## ✔ purrr 1.0.4
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errorslibrary(nycflights13)## Warning: package 'nycflights13' was built under R version 4.4.3data("flights")
glimpse(flights)## Rows: 336,776
## Columns: 19
## $ year <int> 2013, 2013, 2013, 2013, 2013, 2013, 2013, 2013, 2013, 2…
## $ month <int> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1…
## $ day <int> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1…
## $ dep_time <int> 517, 533, 542, 544, 554, 554, 555, 557, 557, 558, 558, …
## $ sched_dep_time <int> 515, 529, 540, 545, 600, 558, 600, 600, 600, 600, 600, …
## $ dep_delay <dbl> 2, 4, 2, -1, -6, -4, -5, -3, -3, -2, -2, -2, -2, -2, -1…
## $ arr_time <int> 830, 850, 923, 1004, 812, 740, 913, 709, 838, 753, 849,…
## $ sched_arr_time <int> 819, 830, 850, 1022, 837, 728, 854, 723, 846, 745, 851,…
## $ arr_delay <dbl> 11, 20, 33, -18, -25, 12, 19, -14, -8, 8, -2, -3, 7, -1…
## $ carrier <chr> "UA", "UA", "AA", "B6", "DL", "UA", "B6", "EV", "B6", "…
## $ flight <int> 1545, 1714, 1141, 725, 461, 1696, 507, 5708, 79, 301, 4…
## $ tailnum <chr> "N14228", "N24211", "N619AA", "N804JB", "N668DN", "N394…
## $ origin <chr> "EWR", "LGA", "JFK", "JFK", "LGA", "EWR", "EWR", "LGA",…
## $ dest <chr> "IAH", "IAH", "MIA", "BQN", "ATL", "ORD", "FLL", "IAD",…
## $ air_time <dbl> 227, 227, 160, 183, 116, 150, 158, 53, 140, 138, 149, 1…
## $ distance <dbl> 1400, 1416, 1089, 1576, 762, 719, 1065, 229, 944, 733, …
## $ hour <dbl> 5, 5, 5, 5, 6, 5, 6, 6, 6, 6, 6, 6, 6, 6, 6, 5, 6, 6, 6…
## $ minute <dbl> 15, 29, 40, 45, 0, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 59, 0…
## $ time_hour <dttm> 2013-01-01 05:00:00, 2013-01-01 05:00:00, 2013-01-01 0…There are 6 common data qualities issues:
Checking Missing values
flights %>%
summarise(across(everything(),~sum(is.na(.))))## # A tibble: 1 × 19
## year month day dep_time sched_dep_time dep_delay arr_time sched_arr_time
## <int> <int> <int> <int> <int> <int> <int> <int>
## 1 0 0 0 8255 0 8255 8713 0
## # ℹ 11 more variables: arr_delay <int>, carrier <int>, flight <int>,
## # tailnum <int>, origin <int>, dest <int>, air_time <int>, distance <int>,
## # hour <int>, minute <int>, time_hour <int>With the function above, we can see that there is a lot of missing values in the dep_time, dep_delay, arr_time, arr_delay, tailnum, and air_time. To clean this missing values we will drop them later.
Checking for duplicate rows
flights%>%
duplicated()%>%
sum()## [1] 0It can be seen that there is no duplicates in the datasets.
Checking for outliers in distance
Boxplot
library(ggplot2)
ggplot(flights,aes(y=distance))+
geom_boxplot()
One of the method to see if there are outliers is using boxplot to
visualize the datas. It is shown that there is outlier in the distance
column.
IQR Method
Q1 = quantile(flights$distance,0.25,na.rm=T)
Q3 = quantile(flights$distance,0.75,na.rm=T)
IQR = Q3-Q1
flights %>%
filter(distance < (Q1-1.5*IQR) | distance > (Q3 + 1.5*IQR))## # A tibble: 715 × 19
## year month day dep_time sched_dep_time dep_delay arr_time sched_arr_time
## <int> <int> <int> <int> <int> <dbl> <int> <int>
## 1 2013 1 1 857 900 -3 1516 1530
## 2 2013 1 1 1344 1344 0 2005 1944
## 3 2013 1 2 909 900 9 1525 1530
## 4 2013 1 2 1344 1344 0 1940 1944
## 5 2013 1 3 914 900 14 1504 1530
## 6 2013 1 3 1418 1341 37 2006 1935
## 7 2013 1 4 900 900 0 1516 1530
## 8 2013 1 4 1343 1341 2 1932 1935
## 9 2013 1 5 858 900 -2 1519 1530
## 10 2013 1 5 1329 1335 -6 1850 1935
## # ℹ 705 more rows
## # ℹ 11 more variables: arr_delay <dbl>, carrier <chr>, flight <int>,
## # tailnum <chr>, origin <chr>, dest <chr>, air_time <dbl>, distance <dbl>,
## # hour <dbl>, minute <dbl>, time_hour <dttm>Using the IQR method, we can filter out the outliers to fix the data.
Check for incorrect data types
flights %>%
summarise(across(everything(),class))## Warning: Returning more (or less) than 1 row per `summarise()` group was deprecated in
## dplyr 1.1.0.
## ℹ Please use `reframe()` instead.
## ℹ When switching from `summarise()` to `reframe()`, remember that `reframe()`
## always returns an ungrouped data frame and adjust accordingly.
## Call `lifecycle::last_lifecycle_warnings()` to see where this warning was
## generated.## # A tibble: 2 × 19
## year month day dep_time sched_dep_time dep_delay arr_time sched_arr_time
## <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
## 1 integer integ… inte… integer integer numeric integer integer
## 2 integer integ… inte… integer integer numeric integer integer
## # ℹ 11 more variables: arr_delay <chr>, carrier <chr>, flight <chr>,
## # tailnum <chr>, origin <chr>, dest <chr>, air_time <chr>, distance <chr>,
## # hour <chr>, minute <chr>, time_hour <chr>Using this check, it can be summarized that all data types are correct.
Check for inconsistent formatting
Checking inconsistent case in column with character data, which is carrier, tailnum, origin, and dest
unique(flights$carrier)## [1] "UA" "AA" "B6" "DL" "EV" "MQ" "US" "WN" "VX" "FL" "AS" "9E" "F9" "HA" "YV"
## [16] "OO"unique(flights$tailnum)## [1] "N14228" "N24211" "N619AA" "N804JB" "N668DN" "N39463" "N516JB" "N829AS"
## [9] "N593JB" "N3ALAA" "N793JB" "N657JB" "N29129" "N53441" "N3DUAA" "N708JB"
## [17] "N76515" "N595JB" "N542MQ" "N644JB" "N971DL" "N730MQ" "N633AA" "N3739P"
## [25] "N53442" "N9EAMQ" "N532UA" "N635JB" "N794JB" "N326NB" "N807AW" "N3EMAA"
## [33] "N459UA" "N11107" "N518MQ" "N535UW" "N3BAAA" "N33289" "N3CYAA" "N273WN"
## [41] "N426US" "N13553" "N3GKAA" "N709JB" "N805JB" "N497UA" "N178US" "N75435"
## [49] "N796JB" "N569UA" "N38727" "N558JB" "N178JB" "N327NW" "N3763D" "N705TW"
## [57] "N997DL" "N4WNAA" "N5FMAA" "N722MQ" "N24212" "N318NB" "N6703D" "N627VA"
## [65] "N3EKAA" "N646JB" "N998DL" "N838UA" "N77296" "N779JB" "N26226" "N651JB"
## [73] "N3ETAA" "N841UA" "N978AT" "N562JB" "N514UA" "N541AA" "N594AS" "N4WRAA"
## [81] "N37462" "N488UA" "N635VA" "N304JB" "N563JB" "N37456" "N552JB" "N625JB"
## [89] "N4WPAA" "N37408" "N633JB" "N338AA" "N624JB" "N3760C" "N336AA" "N24224"
## [97] "N508MQ" "N325US" "N511UA" "N543UW" "N3HMAA" "N935DL" "N789SW" "N645JB"
## [105] "N955DL" "N317US" "N828MQ" "N206JB" "N3GEAA" "N510UA" "N947DL" "N273JB"
## [113] "N570JB" "N739MQ" "N308DE" "N14542" "N915XJ" "N349NW" "N11193" "N531MQ"
## [121] "N654AW" "N17108" "N375NC" "N977AT" "N228JB" "N527JB" "N324US" "N900PC"
## [129] "N521JB" "N846MQ" "N12540" "N655AW" "N39728" "N573AA" "N292JB" "N3GVAA"
## [137] "N76522" "N274JB" "N76528" "N554UA" "N75425" "N4YCAA" "N513MQ" "N13969"
## [145] "N725MQ" "N203FR" "N3BDAA" "N711MQ" "N5FSAA" "N926DL" "N564JB" "N942MQ"
## [153] "N27724" "N19966" "N361NB" "N39297" "N777QC" "N184JB" "N646DL" "N324AA"
## [161] "N970DL" "N75426" "N380HA" "N321NB" "N371NB" "N45440" "N737MQ" "N360NB"
## [169] "N846VA" "N19130" "N820UA" "N532MQ" "N77525" "N281JB" "N17139" "N203JB"
## [177] "N959UW" "N12216" "N5EXAA" "N5CRAA" "N38403" "N24715" "N517AA" "N810UA"
## [185] "N596AA" "N568JB" "N216JB" "N346JB" "N527MQ" "N713TW" "N580JB" "N775JB"
## [193] "N534JB" "N27733" "N951DL" "N11551" "N957WN" "N57439" "N508JB" "N479UA"
## [201] "N641VA" "N503JB" "N579JB" "N487WN" "N975DL" "N900DE" "N615JB" "N729SW"
## [209] "N4WJAA" "N525MQ" "N806JB" "N15912" "N306JB" "N12567" "N6EAMQ" "N586UA"
## [217] "N642AW" "N956DL" "N534UA" "N965DL" "N765US" "N565JB" "N541UW" "N81449"
## [225] "N503MQ" "N933DL" "N162UW" "N712US" "N820AS" "N399DA" "N942AT" "N14905"
## [233] "N719MQ" "N3FXAA" "N437UA" "N328AA" "N76508" "N325AA" "N11189" "N625VA"
## [241] "N77258" "N13955" "N849UA" "N581AA" "N423UA" "N529JB" "N15555" "N667UA"
## [249] "N76503" "N3AVAA" "N3748Y" "N537MQ" "N520JB" "N920DE" "N11544" "N917DL"
## [257] "N951UW" "N505SW" "N509MQ" "N451UA" "N630JB" "N339NW" "N521UA" "N3GSAA"
## [265] "N279JB" "N517UA" "N320NB" "N76502" "N16561" "N469WN" "N587UA" "N590JB"
## [273] "N376NW" "N169UW" "N14180" "N518UA" "N14118" "N496UA" "N3DEAA" "N343NB"
## [281] "N856MQ" "N652JB" "N839VA" "N3EYAA" "N999DN" "N39726" "N695CA" "N932AT"
## [289] "N21144" "N29917" "N712TW" "N8EGMQ" "N322AA" "N969DL" "N904DL" "N16546"
## [297] "N723MQ" "N13113" "N426AA" "N783SW" "N588UA" "N755US" "N11536" "N13978"
## [305] "N843VA" "N612JB" "N39418" "N14168" "N239JB" "N21537" "N517MQ" "N573UA"
## [313] "N545AA" "N342NB" "N254WN" "N14916" "N192JB" "N38459" "N741EV" "N920DL"
## [321] "N402UA" "N3EGAA" "N297WN" "N14543" "N3BUAA" "N36915" "N711ZX" "N670DN"
## [329] "N26210" "N3FTAA" "N576UA" "N644DL" "N732SW" "N540UW" "N957UW" "N717JL"
## [337] "N511AA" "N544AA" "N825UA" "N78511" "N5DMAA" "N773SA" "N177US" "N13538"
## [345] "N19554" "N537JB" "N58101" "N3736C" "N318US" "N642VA" "N847UA" "N14558"
## [353] "N13988" "N636JB" "N510JB" "N339AA" "N3CFAA" "N76065" "N900WN" "N13566"
## [361] "N14105" "N23139" "N344NB" "N13958" "N7704B" "N17128" "N840UA" "N26906"
## [369] "N748EV" "N6704Z" "N13123" "N895AT" "N456UA" "N37464" "N500MQ" "N502UA"
## [377] "N835AS" "N15574" "N678CA" "N563UA" "N452UA" "N327NB" "N722TW" "N319NB"
## [385] "N13908" "N4UCAA" "N5EWAA" "N560UW" "N853MQ" "N8444F" "N920XJ" "N610MQ"
## [393] "N8409N" "N702TW" "N802UA" "N401UA" "N539UW" "N736MQ" "N15572" "N406UA"
## [401] "N17984" "N734MQ" "N513UA" "N8631E" "N803MQ" "N76529" "N678DL" "N13914"
## [409] "N635MQ" "N589AA" "N13750" "N378NW" "N902MQ" "N512UA" "N18112" "N504JB"
## [417] "N231JB" "N280WN" "N3HYAA" "N607JB" "N69059" "N738US" "N913XJ" "N13975"
## [425] "N17115" "N226WN" "N372DA" "N342AA" "N319AA" "N14250" "N3750D" "N688DL"
## [433] "N413UA" "N904XJ" "N994DL" "N21197" "N54241" "N934XJ" "N825AS" "N997AT"
## [441] "N910XJ" "N3CGAA" "N931XJ" "N918DE" "N606MQ" "N761ND" "N487UA" "N826AS"
## [449] "N374DA" "N8968E" "N484UA" "N301NB" "N316JB" "N965WN" "N0EGMQ" "N569AA"
## [457] "N435UA" "N3DYAA" "N712JB" "N362NW" "N76504" "N18119" "N704X" "N550UW"
## [465] "N630AA" "N361NW" "N599JB" "N847VA" "N14959" "N331NW" "N22909" "N14972"
## [473] "N649AW" "N258WN" "N507MQ" "N27213" "N16701" "N190JB" "N604LR" "N3BYAA"
## [481] "N17229" "N14960" "N665JB" "N565AA" "N980DL" "N27962" "N5DRAA" "N626VA"
## [489] "N3CAAA" "N462WN" "N17105" "N688MQ" "N3FUAA" "N418UA" "N16632" "N188US"
## [497] "N3730B" "N543UA" "N778SW" "N15986" "N485UA" "N3CVAA" "N263AV" "N539AA"
## [505] "N507JB" "N713MQ" "N723TW" "N680AW" "N17122" "N386AA" "N557UA" "N377AA"
## [513] "N13903" "N14120" "N967AT" "N618JB" "N16911" "N329JB" "N3761R" "N369NW"
## [521] "N8515F" "N661JB" "N658JB" "N8324A" "N525UA" "N764SW" "N523UA" "N14998"
## [529] "N643DL" "N663JB" "N37274" "N294JB" "N16703" "N359NB" "N75429" "N504MQ"
## [537] "N510UW" "N31412" "N553AS" "N592JB" "N482UA" "N569JB" "N17185" "N266WN"
## [545] "N522UA" "N3AXAA" "N3FMAA" "N337NW" "N906XJ" "N460UW" "N3DWAA" "N3772H"
## [553] "N11119" "N33714" "N8894A" "N18220" "N467UA" "N508UA" "N18120" "N14214"
## [561] "N594AA" "N3ESAA" "N5BYAA" "N332AA" "N920AT" "N908XJ" "N638VA" "N36207"
## [569] "N323AA" "N505JB" "N173DZ" "N905WN" "N329NW" "N523JB" "N3758Y" "N14242"
## [577] "N727TW" "N922DL" "N559JB" "N6710E" "N925XJ" "N432UA" "N633DL" "N3CUAA"
## [585] "N375DA" "N833AS" "N624AG" "N4XFAA" "N8611A" "N27205" "N3764D" "N909MQ"
## [593] "N12157" "N327AA" "N18557" "N905XJ" "N580UA" "N632JB" "N835MQ" "N34110"
## [601] "N640JB" "N11194" "N640VA" "N76523" "N8598B" "N817UA" "N76514" "N836AY"
## [609] "N11206" "N12218" "N14143" "N3BNAA" "N13718" "N602LR" "N3740C" "N76516"
## [617] "N14203" "N267JB" "N822UA" "N486UA" "N38268" "N916XJ" "N414UA" "N536JB"
## [625] "N535JB" "N441UA" "N521MQ" "N14953" "N509SW" "N587JB" "N3738B" "N17245"
## [633] "N924XJ" "N603JB" "N307JB" "N1EAMQ" "N810MQ" "N198JB" "N284JB" "N5DNAA"
## [641] "N608JB" "N547JB" "N531JB" "N594JB" "N639JB" "N591JB" "N588JB" "N3EHAA"
## [649] "N3EVAA" "N621AA" "N493UA" "N637JB" "N3BEAA" "N366NB" "N836AS" "N618DL"
## [657] "N896AT" "N505UA" "N12225" "N760EV" "N8946A" "N8311Q" "N62631" "N3CRAA"
## [665] "N832UA" "N387DA" "N915DE" "N5ELAA" "N740EV" "N304DQ" "N235WN" "N629JB"
## [673] "N19141" "N745VJ" "N461UA" "N445US" "N912DE" "N961WN" "N11565" "N837AW"
## [681] "N7735A" "N16987" "N545UW" "N807JB" "N37267" "N12996" "N766JB" "N538UW"
## [689] "N821UA" "N565UW" "N464UA" "N78285" "N5EUAA" "N656JB" "N945UW" "N436AA"
## [697] "N3JJAA" "N339NB" "N574UA" "N236JB" "N974DL" "N512MQ" "N583JB" "N541US"
## [705] "N76254" "N33284" "N520MQ" "N592AS" "N529UA" "N982AT" "N3768" "N506JB"
## [713] "N73291" "N337JB" "N485WN" "N528AA" "N19117" "N468WN" "N533UA" "N902XJ"
## [721] "N989DL" "N455AA" "N37287" "N79521" "N8869B" "N21130" "N430UA" "N703JB"
## [729] "N509JB" "N660DL" "N918DL" "N537UW" "N3CNAA" "N309JB" "N995DL" "N487AA"
## [737] "N837MQ" "N528UA" "N5FTAA" "N322US" "N656AW" "N358NW" "N328NW" "N305DQ"
## [745] "N335NW" "N339JB" "N586JB" "N3743H" "N73259" "N593AA" "N336NB" "N211FR"
## [753] "N901XJ" "N3JPAA" "N448UA" "N26549" "N923WN" "N841AY" "N829AY" "N918XJ"
## [761] "N930XJ" "N35204" "N11547" "N37434" "N213WN" "N338NB" "N710TW" "N5ENAA"
## [769] "N348NB" "N665DN" "N577UA" "N469UA" "N843UA" "N988DL" "N23708" "N624VA"
## [777] "N747UW" "N561UA" "N546AA" "N589JB" "N838VA" "N14219" "N651AW" "N936DL"
## [785] "N24702" "N14102" "N495WN" "N372NW" "N421UA" "N14993" "N353JB" "N812AY"
## [793] "N403WN" "N707TW" "N12922" "N905DE" "N667AW" "N706JB" "N702UW" "N515MQ"
## [801] "N547UW" "N3DFAA" "N621JB" "N14704" "N337NB" "N855VA" "N655JB" "N811UA"
## [809] "N675DL" "N526UA" "N73275" "N3JMAA" "N940DL" "N546MQ" "N67134" "N784JB"
## [817] "N677UA" "N701GS" "N3BXAA" "N370NW" "N730EV" "N983DL" "N3DLAA" "N738EV"
## [825] "N8783E" "N77510" "N325NB" "N894AT" "N548AA" "N323NB" "N908DL" "N764US"
## [833] "N364SW" "N578AA" "N510MQ" "N16919" "N752EV" "N37290" "N927DA" "N486WN"
## [841] "N502MQ" "N941WN" "N3BHAA" "N4XRAA" "N3751B" "N679DA" "N3FBAA" "N3AUAA"
## [849] "N8432A" "N185UW" "N334NB" "N936WN" "N301DQ" "N24706" "N291WN" "N13248"
## [857] "N935AT" "N12125" "N950WN" "N21154" "N41104" "N14153" "N187JB" "N613JB"
## [865] "N25705" "N31131" "N973DL" "N77066" "N5CYAA" "N917WN" "N14920" "N45905"
## [873] "N926AT" "N474UA" "N16559" "N830AS" "N721TW" "N7738A" "N38443" "N364NB"
## [881] "N601MQ" "N320US" "N36247" "N11548" "N3GDAA" "N8501F" "N554AA" "N180US"
## [889] "N521US" "N718TW" "N4XTAA" "N481UA" "N524JB" "N845MQ" "N8908D" "N707SA"
## [897] "N3FYAA" "N14107" "N76054" "N37298" "N8416B" "N516MQ" "N760JB" "N751UW"
## [905] "N3HLAA" "N636MQ" "N87512" "N344AA" "N360NW" "N8390A" "N385DN" "N933XJ"
## [913] "N322NB" "N601LR" "N10575" "N371CA" "N371DA" "N977DL" "N3CKAA" "N33266"
## [921] "N627MQ" "N16732" "N16976" "N922XJ" "N17138" "N13968" "N8646A" "N877AS"
## [929] "N535MQ" "N437AA" "N541UA" "N14115" "N600LR" "N26215" "N3745B" "N15712"
## [937] "N312US" "N836VA" "N530UA" "N450WN" "N648AW" "N324JB" "N4WTAA" "N523MQ"
## [945] "N14106" "N3HPAA" "N841VA" "N907XJ" "N442WN" "N3BTAA" "N830UA" "N631AA"
## [953] "N557AA" "N24633" "N578UA" "N597UA" "N723EV" "N483WN" "N556JB" "N600MQ"
## [961] "N3CWAA" "N605MQ" "N936AT" "N6707A" "N380DA" "N371AA" "N438UA" "N668AW"
## [969] "N21129" "N201FR" "N804UA" "N34131" "N519JB" "N598AA" "N3754A" "N15910"
## [977] "N87513" "N770SA" "N8316H" "N5FFAA" "N597JB" "N839AY" "N17730" "N13550"
## [985] "N12116" "N3FPAA" "N809JB" "N901WN" "N233LV" "N552AS" "N820AY" "N717TW"
## [993] "N808UA" "N449US" "N346NB" "N613DL" "N729JB" "N24729" "N552UW" "N662JB"
## [1001] "N461WN" "N8412F" "N3DNAA" "N590AA" "N628VA" "N971AT" "N658DL" "N178DZ"
## [1009] "N703TW" "N752SW" "N3752" "N76288" "N73299" "N73283" "N335NB" "N948DL"
## [1017] "N3ENAA" "N637DL" "N407UA" "N3GRAA" "N12135" "N11181" "N37263" "N746JB"
## [1025] "N8516C" "N689DL" "N622VA" "N369NB" "N14204" "N503UA" "N3CEAA" "N704SW"
## [1033] "N3GCAA" "N929AT" "N605LR" "N389DA" "N919XJ" "N818MQ" "N829UA" "N506MQ"
## [1041] "N539UA" "N443WN" "N445UA" "N454UA" "N77520" "N74856" "N593UA" "N265JB"
## [1049] "N368NW" "N12221" "N8976E" "N606JB" "N821JB" "N283JB" "N789JB" "N13949"
## [1057] "N759EV" NA "N763JB" "N172US" "N618AA" "N954DL" "N828AS" "N526MQ"
## [1065] "N13995" "N641DL" "N8329B" "N638AA" "N755EV" "N365NB" "N767UW" "N3ADAA"
## [1073] "N438US" "N520UW" "N565UA" "N171US" "N22971" "N33182" "N801AW" "N447WN"
## [1081] "N403UA" "N3ERAA" "N412UA" "N612QX" "N18556" "N526JB" "N324NB" "N34455"
## [1089] "N604DL" "N952UW" "N5ETAA" "N348NW" "N76269" "N296JB" "N7740A" "N938AT"
## [1097] "N534MQ" "N37255" "N533AS" "N556AA" "N316NB" "N470UA" "N446UA" "N8794B"
## [1105] "N699DL" "N14977" "N77871" "N326US" "N723SW" "N480UA" "N925DL" "N476WN"
## [1113] "N196UW" "N552UA" "N954AT" "N351JB" "N5FJAA" "N307DQ" "N396DA" "N914XJ"
## [1121] "N356NW" "N601AW" "N845UA" "N842UA" "N249WN" "N585JB" "N77261" "N13133"
## [1129] "N3EWAA" "N11127" "N631VA" "N17104" "N612AA" "N79402" "N431UA" "N768JB"
## [1137] "N535UA" "N332NW" "N201AA" "N444UA" "N73276" "N513AA" "N852VA" "N14952"
## [1145] "N3BLAA" "N938WN" "N641JB" "N8492C" "N8877A" "N831UA" "N676AW" "N77430"
## [1153] "N603DL" "N466UA" "N760US" "N494AA" "N561UW" "N8475B" "N3HFAA" "N957AT"
## [1161] "N719EV" "N302NB" "N524MQ" "N673UA" "N36280" "N674DL" "N555UA" "N785SW"
## [1169] "N3HCAA" "N3ACAA" "N3756" "N621VA" "N938DL" "N73251" "N480WN" "N358NB"
## [1177] "N306DQ" "N965AT" "N21723" "N383SW" "N710UW" "N25134" "N692DL" "N36272"
## [1185] "N716SW" "N33262" "N12126" "N619SW" "N4WAAA" "N276WN" "N397DA" "N3HVAA"
## [1193] "N433UA" "N754EV" "N602XJ" "N492AA" "N758EV" "N270WN" "N35260" "N924AT"
## [1201] "N922WN" "N949DL" "N163US" "N12552" "N14121" "N458WN" "N3FVAA" "N3JHAA"
## [1209] "N228WN" "N3GUAA" "N555NW" "N12564" "N34137" "N5PBMQ" "N570UA" "N76064"
## [1217] "N12109" "N509MJ" "N514AA" "N71411" "N641MQ" "N5FAAA" "N579AA" "N13965"
## [1225] "N197UW" "N12238" "N835UA" "N13989" "N491UA" "N669MQ" "N354NW" "N564AA"
## [1233] "N612MQ" "N14125" "N236WN" "N916WN" "N584JB" "N26123" "N14171" "N8940E"
## [1241] "N826AY" "N78501" "N249JB" "N508MJ" "N648JB" "N3BKAA" "N374NW" "N37253"
## [1249] "N13970" "N76517" "N439UA" "N3767" "N893AT" "N7730A" "N645MQ" "N16918"
## [1257] "N392DA" "N8924B" "N355NW" "N473UA" "N664AW" "N426WN" "N724EV" "N8974C"
## [1265] "N542AA" "N3HKAA" "N851VA" "N11184" "N660MQ" "N14991" "N792SW" "N909XJ"
## [1273] "N3753" "N648DL" "N924WN" "N961DL" "N27722" "N363NW" "N396AA" "N229JB"
## [1281] "N33103" "N48127" "N460UA" "N386DA" "N480AA" "N3CXAA" "N19136" "N710SW"
## [1289] "N3JAAA" "N422UA" "N39423" "N5CCAA" "N328JB" "N8315C" "N449WN" "N708EV"
## [1297] "N37293" "N303DQ" "N357AA" "N406US" "N257WN" "N522MQ" "N552AA" "N923DL"
## [1305] "N517JB" "N617AA" "N181DN" "N630MQ" "N391CA" "N928AT" "N317NB" "N834AS"
## [1313] "N482WN" "N11113" "N3734B" "N3AFAA" "N855UA" "N3769L" "N8884E" "N8836A"
## [1321] "N79279" "N3765" "N261AV" "N833AY" "N14162" "N3ELAA" "N917XJ" "N991DL"
## [1329] "N341NB" "N338NW" "N14902" "N11140" "N903XJ" "N3GYAA" "N623VA" "N8506C"
## [1337] "N329NB" "N16954" "N13994" "N87527" "N449UA" "N494UA" "N928XJ" "N12967"
## [1345] "N427UA" "N832AS" "N34222" "N634JB" "N13118" "N193JB" "N3AMAA" "N3GXAA"
## [1353] "N554JB" "N186US" "N78506" "N5DVAA" "N638DL" "N251WN" "N963AT" "N8322X"
## [1361] "N813UA" "N713EV" "N5BSAA" "N3DGAA" "N342NW" "N73256" "N347NB" "N12114"
## [1369] "N232PQ" "N420US" "N825AW" "N170US" "N508AY" "N357SW" "N11137" "N424UA"
## [1377] "N824UA" "N816UA" "N377NW" "N405UA" "N967DL" "N633VA" "N277WN" "N77431"
## [1385] "N75432" "N76505" "N3DVAA" "N904DE" "N436UA" "N582AA" "N4YJAA" "N579AS"
## [1393] "N854VA" "N659JB" "N8525B" "N75854" "N553AA" "N627DL" "N269WN" "N317JB"
## [1401] "N979DL" "N192UW" "N209WN" "N899AT" "N26545" "N315US" "N677AW" "N179JB"
## [1409] "N299WN" "N214FR" "N4WWAA" "N720EV" "N629VA" "N384HA" "N54711" "N16178"
## [1417] "N76055" "N455UA" "N478UA" "N16709" "N75851" "N827AY" "N7726A" "N656SW"
## [1425] "N8914A" "N714CB" "N75428" "N623DL" "N379DA" "N758US" "N29906" "N38257"
## [1433] "N756US" "N8855A" "N933AT" "N14570" "N671UA" "N948UW" "N705JB" "N659DL"
## [1441] "N3JEAA" "N700GS" "N909DL" "N634VA" "N3ASAA" "N357NB" "N921WN" "N370SW"
## [1449] "N706TW" "N915AT" "N651DL" "N584AA" "N566AA" "N272WN" "N319US" "N467AA"
## [1457] "N41140" "N187PQ" "N456AA" "N945AT" "N57857" "N286WN" "N281WN" "N3BRAA"
## [1465] "N13124" "N540UA" "N501AA" "N511MJ" "N179UW" "N921XJ" "N644MQ" "N522AA"
## [1473] "N14923" "N8710A" "N555AY" "N14568" "N937XJ" "N562UA" "N3GLAA" "N5FNAA"
## [1481] "N309US" "N66056" "N679MQ" "N723UW" "N3ANAA" "N14186" "N8903A" "N932XJ"
## [1489] "N336NW" "N15710" "N436WN" "N8948B" "N3AHAA" "N3757D" "N13956" "N615QX"
## [1497] "N3HXAA" "N394DA" "N373AA" "N4WKAA" "N3GFAA" "N76153" "N849VA" "N8828D"
## [1505] "N3FJAA" "N8659B" "N456WN" "N923MQ" "N3JDAA" "N799SW" "N839MQ" "N310DE"
## [1513] "N3771K" "N990DL" "N553UA" "N673MQ" "N940AT" "N658AW" "N513MJ" "N358AA"
## [1521] "N21108" "N371NW" "N3JTAA" "N479WN" "N16234" "N8309C" "N544UW" "N848UA"
## [1529] "N919DL" "N8674A" "N960WN" "N38417" "N807UA" "N13913" "N3FAAA" "N819UA"
## [1537] "N430US" "N15983" "N26208" "N209FR" "N214WN" "N27239" "N515AA" "N13997"
## [1545] "N344NW" "N611QX" "N827AS" "N609DL" "N958WN" "N14179" "N632VA" "N471UA"
## [1553] "N951AT" "N8932C" "N907DL" "N37252" "N3744F" "N14177" "N835MH" "N929XJ"
## [1561] "N411UA" "N635DL" "N8886A" "N33203" "N426UA" "N14237" "N963WN" "N8970D"
## [1569] "N561JB" "N323JB" "N33292" "N3BGAA" "N200AA" "N419UA" "N5DBAA" "N506UA"
## [1577] "N600QX" "N969AT" "N5ECAA" "N12145" "N425UA" "N8306H" "N721UW" "N11535"
## [1585] "N909WN" "N3HBAA" "N821AW" "N643JB" "N905DL" "N12136" "N38454" "N37281"
## [1593] "N911DL" "N964AT" "N546AS" "N175DN" "N653JB" "N417UA" "N554UW" "N429UA"
## [1601] "N5EHAA" "N840MQ" "N183JB" "N720WN" "N673AW" "N429WN" "N675AW" "N636DL"
## [1609] "N8747B" "N293WN" "N14907" "N37420" "N457UA" "N381HA" "N7BFAA" "N408UA"
## [1617] "N470AA" "N845VA" "N935WN" "N571JB" "N550WN" "N3FLAA" "N4XWAA" "N57864"
## [1625] "N908DE" "N540US" "N814UA" "N548UW" "N763US" "N730US" "N428UA" "N987AT"
## [1633] "N8921B" "N964DL" "N669UA" "N24103" "N37427" "N167US" "N359SW" "N854UA"
## [1641] "N756SA" "N3CHAA" "N16541" "N948AT" "N737US" "N646SW" "N912XJ" "N575AA"
## [1649] "N760SW" "N3FHAA" "N439AA" "N453WN" "N3733Z" "N523US" "N18102" "N990AT"
## [1657] "N329AA" "N17133" "N506SW" "N176UW" "N466AA" "N472WN" "N216WR" "N18223"
## [1665] "N906AT" "N41135" "N24128" "N923XJ" "N835AY" "N489WN" "N491WN" "N174US"
## [1673] "N66057" "N3HNAA" "N78448" "N385AA" "N357NW" "N4UBAA" "N382DA" "N919DE"
## [1681] "N972AT" "N615AA" "N8751D" "N4YEAA" "N3731T" "N17196" "N964WN" "N373NW"
## [1689] "N12924" "N68159" "N433AA" "N247JB" "N208WN" "N705SW" "N590NW" "N173US"
## [1697] "N4XJAA" "N906DL" "N639AA" "N3DBAA" "N918MQ" "N992AT" "N603MQ" "N208FR"
## [1705] "N7714B" "N33132" "N288WN" "N321US" "N381DN" "N712EV" "N558AS" "N753SW"
## [1713] "N433US" "N8980A" "N3759" "N347NW" "N180DN" "N38446" "N839UA" "N12900"
## [1721] "N335AA" "N519MQ" "N744SW" "N8936A" "N8672A" "N5BRAA" "N998AT" "N8943A"
## [1729] "N320AA" "N15973" "N649JB" "N543US" "N3GAAA" "N947AT" "N5DCAA" "N749US"
## [1737] "N567UA" "N17560" "N103US" "N87507" "N769US" "N5BVAA" "N463UA" "N47414"
## [1745] "N571UA" "N595UA" "N568AS" "N540AA" "N519UW" "N617DL" "N246LV" "N416UA"
## [1753] "N805UA" "N267AT" "N334JB" "N650AW" "N37422" "N3DSAA" "N8883E" "N298JB"
## [1761] "N12172" "N5EGAA" "N566JB" "N552WN" "N3GNAA" "N14731" "N11106" "N8577D"
## [1769] "N544MQ" "N804AW" "N664DN" "N193UW" "N546UW" "N348JB" "N909EV" "N117UW"
## [1777] "N934DL" "N709EV" "N385HA" "N3JRAA" "N844VA" "N674UA" "N34282" "N283WN"
## [1785] "N16112" "N3DCAA" "N16151" "N409UA" "N956WN" "N3GBAA" "N353NB" "N577AA"
## [1793] "N463WN" "N551AA" "N78509" "N219WN" "N13202" "N471AA" "N350NA" "N851UA"
## [1801] "N404WN" "N947UW" "N753EV" "N478AA" "N743SW" "N892AT" "N14904" "N3GGAA"
## [1809] "N197JB" "N433LV" "N69063" "N709SW" "N975AT" "N591AA" "N916DN" "N859AS"
## [1817] "N564UW" "N13964" "N48901" "N672MQ" "N8554A" "N12921" "N944DL" "N259WN"
## [1825] "N584UA" "N18101" "N458UA" "N932MQ" "N597AA" "N27200" "N716UW" "N617MQ"
## [1833] "N67058" "N462UA" "N11164" "N633MQ" "N366NW" "N956AT" "N8423C" "N3CLAA"
## [1841] "N13132" "N364AA" "N224WN" "N68160" "N78524" "N207WN" "N915WN" "N39450"
## [1849] "N803UA" "N483AA" "N610DL" "N683MQ" "N4WLAA" "N16170" "N187US" "N5DSAA"
## [1857] "N790SW" "N210FR" "N927AT" "N4XSAA" "N742SW" "N537UA" "N3JSAA" "N996DL"
## [1865] "N645DL" "N363AA" "N501MQ" "N509AY" "N354AA" "N497WN" "N8913A" "N818UA"
## [1873] "N551AS" "N717EV" "N316US" "N8896A" "N409US" "N391DA" "N5EBAA" "N349NB"
## [1881] "N12142" "N4YLAA" "N1613B" "N398DA" "N8847A" "N3GMAA" "N434WN" "N11539"
## [1889] "N13161" "N3EUAA" "N3DAAA" "N755SA" "N17719" "N318JB" "N605JB" "N598JB"
## [1897] "N566UW" "N5DTAA" "N607AT" "N663DN" "N754UW" "N815UA" "N925WN" "N524UW"
## [1905] "N146PQ" "N8323C" "N752US" "N762SW" "N690DL" "N184US" "N473WN" "N12122"
## [1913] "N14562" "N826UA" "N473AA" "N722US" "N3AEMQ" "N73270" "N3JLAA" "N628AA"
## [1921] "N16217" "N4XEAA" "N537AS" "N75858" "N507UA" "N958UW" "N37273" "N770UW"
## [1929] "N592UA" "N413WN" "N669AW" "N947WN" "N8907A" "N34460" "N467WN" "N33294"
## [1937] "N604QX" "N753US" "N837VA" "N498UA" "N353NW" "N340NB" "N14231" "N575UA"
## [1945] "N8837B" "N78866" "N6712B" "N4XVAA" "N252WN" "N4XNAA" "N8505Q" "N944UW"
## [1953] "N659AW" "N434UA" "N713UW" "N7739A" "N657AW" "N614QX" "N3773D" "N475AA"
## [1961] "N3GJAA" "N658UA" "N229WN" "N912DL" "N642DL" "N846UA" "N3EFAA" "N3755D"
## [1969] "N607SW" "N996AT" "N6711M" "N441WN" "N3DPAA" "N3BMAA" "N398CA" "N8944B"
## [1977] "N260WN" "N662DN" "N759GS" "N13138" "N29124" "N3FSAA" "N848VA" "N627JB"
## [1985] "N558UA" "N472UA" "N993DL" "N507MJ" "N4YUAA" "N937AT" "N76519" "N618MQ"
## [1993] "N367NW" "N557UW" "N504UA" "N735SA" "N345NW" "N23721" "N73278" "N4XBAA"
## [2001] "N3766" "N615MQ" "N837UA" "N936XJ" "N351NW" "N241WN" "N364NW" "N69154"
## [2009] "N602AW" "N952WN" "N8688C" "N279WN" "N476UA" "N762US" "N3CJAA" "N6714Q"
## [2017] "N309DE" "N464WN" "N638JB" "N963DL" "N625AA" "N3BBAA" "N667MQ" "N206FR"
## [2025] "N281AT" "N356AA" "N33286" "N474WN" "N711HK" "N87531" "N3FFAA" "N453UA"
## [2033] "N428WN" "N663AW" "N333NW" "N3ARAA" "N3JUAA" "N408AS" "N355NB" "N983AT"
## [2041] "N186DN" "N419WN" "N388DA" "N945DL" "N377DA" "N446WN" "N265WN" "N11109"
## [2049] "N474AA" "N33264" "N3JBAA" "N950AT" "N710EV" "N8308K" "N153PQ" "N439WN"
## [2057] "N27190" "N701UW" "N693DL" "N14230" "N35407" "N3GWAA" "N278WN" "N33209"
## [2065] "N942DL" "N512AA" "N11187" "N680DA" "N937DL" "N949AT" "N527UA" "N924DL"
## [2073] "N3GTAA" "N476AA" "N16149" "N824AY" "N3ATAA" "N202FR" "N408WN" "N724UW"
## [2081] "N17233" "N137EV" "N12201" "N443UA" "N965UW" "N389HA" "N515UA" "N481AA"
## [2089] "N469AA" "N76265" "N242WN" "N835VA" "N423WN" "N539MQ" "N914DL" "N768US"
## [2097] "N812AW" "N993AT" "N384AA" "N440UA" "N668UA" "N3BCAA" "N928DL" "N344SW"
## [2105] "N805AY" "N767SW" "N3BWAA" "N722EV" "N823AY" "N536AA" "N37413" "N12175"
## [2113] "N3CDAA" "N13979" "N5EAAA" "N563UW" "N922MQ" "N341NW" "N959WN" "N361AA"
## [2121] "N8971A" "N376DA" "N579UA" "N5DUAA" "N506MJ" "N935XJ" "N8918B" "N176DN"
## [2129] "N38451" "N570AA" "N776WN" "N3ABAA" "N900MQ" "N652DL" "N491AA" "N5CBAA"
## [2137] "N680MQ" "N213FR" "N780SW" "N653AW" "N211WN" "N976DL" "N604AW" "N546UA"
## [2145] "N8458A" "N409WN" "N775SW" "N1611B" "N620MQ" "N407AS" "N5CDAA" "N981AT"
## [2153] "N523VA" "N227WN" "N195DN" "N3762Y" "N8964E" "N3JNAA" "N334NW" "N812UA"
## [2161] "N77530" "N8888D" "N583AA" "N921AT" "N3CCAA" "N12569" "N484AA" "N247WN"
## [2169] "N17627" "N5CSAA" "N955AT" "N8600F" "N5CKAA" "N222WN" "N809UA" "N161PQ"
## [2177] "N14629" "N478WN" "N11192" "N123UW" "N670UA" "N14173" "N294WN" "N827UA"
## [2185] "N852UA" "N32404" "N17169" "N953DL" "N239WN" "N5CFAA" "N979AT" "N68453"
## [2193] "N563AS" "N4XMAA" "N427WN" "N791SW" "N5FLAA" "N16571" "N302DQ" "N12167"
## [2201] "N134EV" "N11191" "N637VA" "N623JB" "N4XYAA" "N77865" "N624AW" "N8965E"
## [2209] "N831AY" "N18243" "N909DE" "N652AW" "N675UA" "N834AY" "N6701" "N352AA"
## [2217] "N183UW" "N639SW" "N3DXAA" "N669DN" "N576AA" "N708SW" "N750SA" "N181UW"
## [2225] "N711UW" "N748SW" "N238WN" "N505MJ" "N11150" "N826MQ" "N15980" "N788SA"
## [2233] "N623MQ" "N348AA" "N744P" "N73152" "N5DWAA" "N985AT" "N8905F" "N503MJ"
## [2241] "N801AY" "N78060" "N365NW" "N466WN" "N726SW" "N602DL" "N8604C" "N638MQ"
## [2249] "N754SW" "N685MQ" "N953FR" "N362AA" "N329AT" "N585UA" "N3746H" "N76526"
## [2257] "N798SW" "N553UW" "N3EJAA" "N403AS" "N8969A" "N991AT" "N475UA" "N343NW"
## [2265] "N4YHAA" "N3BJAA" "N27152" "N828UA" "N8808H" "N960AT" "N4WSAA" "N715JB"
## [2273] "N77518" "N594UA" "N465UA" "N3BVAA" "N740UW" "N3FRAA" "N3APAA" "N8327A"
## [2281] "N968AT" "N12195" "N215WN" "N170PQ" "N906WN" "N110UW" "N10156" "N383DN"
## [2289] "N75436" "N77295" "N494WN" "N73406" "N957DL" "N513AS" "N4YGAA" "N687DL"
## [2297] "N949UW" "N545UA" "N400WN" "N16961" "N647AW" "N854MQ" "N221WN" "N14158"
## [2305] "N410UA" "N388HA" "N5DEAA" "N8623A" "N4YKAA" "N7702A" "N665AW" "N725UW"
## [2313] "N559UW" "N961UW" "N913DE" "N651SW" "N966AT" "N245WN" "N253WN" "N445WN"
## [2321] "N744EV" "N3BFAA" "N430WN" "N515MJ" "N834UA" "N189UW" "N631MQ" "N8797A"
## [2329] "N5FPAA" "N715SW" "N528MQ" "N16183" "N395AA" "N3BSAA" "N323US" "N37700"
## [2337] "N952DL" "N825AY" "N37437" "N736SA" "N800AY" "N15985" "N599AA" "N655DL"
## [2345] "N330NW" "N659MQ" "N318AT" "N216FR" "N231WN" "N351AA" "N16713" "N14148"
## [2353] "N3JWAA" "N3DHAA" "N402AS" "N523UW" "N519UA" "N3749D" "N1602" "N3HAAA"
## [2361] "N490UA" "N11155" "N3ECAA" "N8533D" "N17244" "N954UW" "N980AT" "N8310C"
## [2369] "N3DMAA" "N704US" "N16147" "N194UW" "N442UA" "N38458" "N612DL" "N35271"
## [2377] "N78438" "N508AS" "N4YMAA" "N906DE" "N16963" "N345NB" "N5EYAA" "N660AW"
## [2385] "N499AA" "N703SW" "N135EV" "N383HA" "N4XDAA" "N8694A" "N8698A" "N672AW"
## [2393] "N3747D" "N434AA" "N399AA" "N3HUAA" "N787SA" "N181PQ" "N695DL" "N432WN"
## [2401] "N853UA" "N13992" "N232WN" "N566UA" "N966DL" "N315NB" "N844UA" "N11165"
## [2409] "N345AA" "N3JGAA" "N8800G" "N666DN" "N734SA" "N521LR" "N438AA" "N548US"
## [2417] "N819AY" "N20904" "N451WN" "N8709A" "N656MQ" "N14628" "N634AA" "N3AKAA"
## [2425] "N558UW" "N4YAAA" "N5DXAA" "N176AT" "N393DA" "N437WN" "N551UW" "N758SW"
## [2433] "N320AS" "N8758D" "N495UA" "N370NB" "N4XPAA" "N830AY" "N8930E" "N654DL"
## [2441] "N727SW" "N14573" "N3EAAA" "N518LR" "N266JB" "N285WN" "N982DL" "N630VA"
## [2449] "N5CAAA" "N67171" "N667DN" "N544UA" "N26141" "N486AA" "N5EVAA" "N950UW"
## [2457] "N640DL" "N5EJAA" "N57111" "N525AA" "N420WN" "N595AA" "N12166" "N678AW"
## [2465] "N623SW" "N953AT" "N751SW" "N314NB" "N709TW" "N714US" "N556NW" "N443US"
## [2473] "N415UA" "N202WN" "N525US" "N929WN" "N4YBAA" "N368NB" "N23707" "N8495B"
## [2481] "N415WN" "N454AA" "N613MQ" "N8580A" "N784SW" "N836UA" "N411WN" "N5CPAA"
## [2489] "N404UA" "N521AA" "N3737C" "N3HEAA" "N14188" "N3EPAA" "N636VA" "N264LV"
## [2497] "N926XJ" "N73445" "N639MQ" "N343AA" "N556UW" "N290WN" "N359NW" "N565AS"
## [2505] "N107US" "N174DZ" "N930DL" "N915DL" "N8775A" "N538UA" "N3AAAA" "N353SW"
## [2513] "N5DDAA" "N3DDAA" "N195UW" "N373DA" "N520UA" "N5EKAA" "N639DL" "N76062"
## [2521] "N402WN" "N39461" "N554NW" "N509AA" "N926WN" "N452UW" "N608QX" "N390AA"
## [2529] "N553WN" "N8305E" "N3AWAA" "N113UW" "N934AT" "N14974" "N230WN" "N12160"
## [2537] "N3FWAA" "N750EV" "N733SA" "N585AA" "N3GPAA" "N961AT" "N962DL" "N567AA"
## [2545] "N394AA" "N68061" "N774SW" "N953UW" "N3CTAA" "N205WN" "N5DYAA" "N203WN"
## [2553] "N490WN" "N769SW" "N944WN" "N207FR" "N349AA" "N819MQ" "N542UW" "N3AJAA"
## [2561] "N104UW" "N3EXAA" "N1609" "N649DL" "N927WN" "N901DE" "N751EV" "N8718E"
## [2569] "N988AT" "N14117" "N271LV" "N652SW" "N5FKAA" "N3FEAA" "N502MJ" "N655MQ"
## [2577] "N420UA" "N946UW" "N298WN" "N16981" "N950DL" "N384DA" "N919WN" "N531AS"
## [2585] "N4YFAA" "N853VA" "N3FDAA" "N956UW" "N970AT" "N679AW" "N529AA" "N568AA"
## [2593] "N382HA" "N715UW" "N57868" "N12163" "N902WN" "N418WN" "N842VA" "N374AA"
## [2601] "N317WN" "N3JFAA" "N918WN" "N530MQ" "N220WN" "N8696C" "N930WN" "N944AT"
## [2609] "N258JB" "N483UA" "N571AA" "N547AA" "N946WN" "N628MQ" "N8891A" "N696DL"
## [2617] "N3EBAA" "N661AW" "N718EV" "N641SW" "N284AT" "N782SA" "N238JB" "N274WN"
## [2625] "N850UA" "N619MQ" "N488AA" "N1201P" "N635AA" "N468UA" "N518AA" "N287WN"
## [2633] "N37277" "N13716" "N766US" "N8318F" "N703UW" "N17159" "N959DL" "N596AS"
## [2641] "N3JKAA" "N746SW" "N5FHAA" "N995AT" "N676DL" "N37409" "N691CA" "N39416"
## [2649] "N509UA" "N447UA" "N484WN" "N8736A" "N767NC" "N262WN" "N930AT" "N698DL"
## [2657] "N475WN" "N4YRAA" "N3HDAA" "N3FCAA" "N455WN" "N4XUAA" "N8488D" "N519AA"
## [2665] "N912DN" "N538AA" "N3HJAA" "N836MQ" "N4YTAA" "N401WN" "N987DL" "N543MQ"
## [2673] "N955WN" "N624AA" "N477AA" "N17126" "N662AW" "N149AT" "N949WN" "N349SW"
## [2681] "N560AA" "N1608" "N5BTAA" "N8923A" "N489UA" "N559AA" "N452WN" "N5EEAA"
## [2689] "N757UW" "N108UW" "N3AGAA" "N5FGAA" "N243WN" "N589AS" "N4XLAA" "N444WN"
## [2697] "N672DL" "N746UW" "N4WVAA" "N5CGAA" "N766SW" "N202AA" "N757LV" "N748UW"
## [2705] "N390SW" "N741UW" "N470WN" "N490AA" "N709UW" "N459WN" "N182UW" "N943WN"
## [2713] "N989AT" "N965DN" "N616DL" "N397SW" "N66051" "N388AA" "N959AT" "N36447"
## [2721] "N931MQ" "N952FR" "N946DL" "N174AT" "N796SW" "N609SW" "N635SW" "N28457"
## [2729] "N536UW" "N907DE" "N933WN" "N8933B" "N514MQ" "N8982A" "N865DA" "N8604K"
## [2737] "N176PQ" "N3HRAA" "N275WN" "N506AS" "N967WN" "N8477R" "N946AT" "N505AA"
## [2745] "N719SW" "N29717" "N16999" "N39415" "N574AA" "N8790A" "N212WN" "N4XXAA"
## [2753] "N431WN" "N3JCAA" "N14174" "N380SW" "N527AA" "N460WN" "N628SW" "N352NW"
## [2761] "N3BPAA" "N939WN" "N801UA" "N8673D" "N592AA" "N12957" "N607MQ" "N742PS"
## [2769] "N3EDAA" "N642WN" "N504MJ" "N781WN" "N465WN" "N686DA" "N3HWAA" "N560UA"
## [2777] "N550UA" "N4XHAA" "N291AT" "N362SW" "N931WN" "N204WN" "N3DRAA" "N624MQ"
## [2785] "N510MJ" "N521UW" "N604SW" "N8319F" "N622AA" "N737JW" "N12563" "N708UW"
## [2793] "N493AA" "N228PQ" "N3735D" "N5FRAA" "N72405" "N518AS" "N425AA" "N210WN"
## [2801] "N903DE" "N825MQ" "N57870" "N370AA" "N672UA" "N658SW" "N931DL" "N605SW"
## [2809] "N8683B" "N840AY" "N654SW" "N468AA" "N572UA" "N768SW" "N435AA" "N609MQ"
## [2817] "N4YNAA" "N550AA" "N290AT" "N365AA" "N910DL" "N405WN" "N8541D" "N37465"
## [2825] "N986AT" "N499WN" "N4XKAA" "N289CT" "N3FKAA" "N934WN" "N994AT" "N240WN"
## [2833] "N8312C" "N360AA" "N535AS" "N205FR" "N386HA" "N3HGAA" "N477UA" "N831AW"
## [2841] "N355AA" "N112US" "N382SW" "N218WN" "N414WN" "N914WN" "N75410" "N444US"
## [2849] "N542US" "N829MQ" "N27421" "N601XJ" "N496WN" "N632MQ" "N3AYAA" "N699MQ"
## [2857] "N765SW" "N978DL" "N4XCAA" "N657MQ" "N410WN" "N597AS" "N559UA" "N118US"
## [2865] "N185DN" "N832AY" "N922AT" "N125UW" "N556AS" "N613AA" "N951WN" "N747SA"
## [2873] "N133EV" "N432US" "N383AA" "N664UA" "N524UA" "N745SW" "N4WYAA" "N481WN"
## [2881] "N4XGAA" "N425LV" "N562UW" "N8588D" "N614MQ" "N832MQ" "N842MQ" "N590UA"
## [2889] "N823UA" "N4WMAA" "N671DN" "N438WN" "N953WN" "N549UW" "N237WN" "N407WN"
## [2897] "N806UA" "N124US" "N653MQ" "N1605" "N390DA" "N543AA" "N305AS" "N136EV"
## [2905] "N5DPAA" "N577AS" "N57869" "N520AA" "N730SW" "N8839E" "N840VA" "N587AA"
## [2913] "N380AA" "N3CBAA" "N505MQ" "N3FGAA" "N389SW" "N697DL" "N733UW" "N250WN"
## [2921] "N16951" "N716EV" "N5EPAA" "N717UW" "N581UA" "N681MQ" "N310NW" "N913DL"
## [2929] "N902DE" "N725SW" "N954WN" "N943FR" "N354AT" "N36444" "N694MQ" "N11176"
## [2937] "N661DN" "N422WN" "N8302F" "N295WN" "N5EFAA" "N910DE" "N30401" "N548AS"
## [2945] "N4YPAA" "N57852" "N962WN" "N676CA" "N530AA" "N700UW" "N891AT" "N4YSAA"
## [2953] "N907WN" "N477WN" "N8543F" "N786SW" "N516LR" "N234WN" "N929DN" "N642MQ"
## [2961] "N391AA" "N75433" "N650MQ" "N928WN" "N940WN" "N155DL" "N272AT" "N8960A"
## [2969] "N440LV" "N5CEAA" "N424WN" "N640AA" "N8313F" "N296WN" "N200PQ" "N3GHAA"
## [2977] "N489AA" "N132EV" "N526AA" "N498WN" "N914DE" "N7734H" "N955UW" "N3CSAA"
## [2985] "N630WN" "N551WN" "N8972E" "N603AT" "N960DL" "N138EV" "N519LR" "N693MQ"
## [2993] "N8532G" "N393AA" "N981DL" "N651MQ" "N472AA" "N797MX" "N201LV" "N198DN"
## [3001] "N332NB" "N161UW" "N943AT" "N8665A" "N197PQ" "N126UW" "N511MQ" "N529AS"
## [3009] "N916DE" "N516UA" "N496AA" "N3FNAA" "N396SW" "N910AT" "N378DA" "N6715C"
## [3017] "N3CPAA" "N815MQ" "N603SW" "N917DE" "N168AT" "N549AS" "N34111" "N642AA"
## [3025] "N712SW" "N346AA" "N838AW" "N3EEAA" "N693SW" "N3HSAA" "N805MQ" "N24202"
## [3033] "N454WN" "N731SA" "N162PQ" "N5DFAA" "N522LR" "N966WN" "N821AY" "N913WN"
## [3041] "N307AS" "N634MQ" "N921DL" "N11199" "N406WN" "N8326F" "N937WN" "N8587E"
## [3049] "N555LV" "N923AT" "N927XJ" "N551NW" "N561AA" "N903WN" "N503US" "N38424"
## [3057] "N244WN" "N906MQ" "N398AA" "N925AT" "N611MQ" "N3732J" "N421LV" "N724SW"
## [3065] "N648MQ" "N323AS" "N127UW" "N11121" "N111US" "N584AS" "N537AA" "N56859"
## [3073] "N855MQ" "N582CA" "N8560F" "N519US" "N424AA" "N109UW" "N67052" "N14950"
## [3081] "N694DL" "N808MQ" "N5CLAA" "N114UW" "N268WN" "N1612T" "N482AA" "N824MQ"
## [3089] "N166PQ" "N833UA" "N968DL" "N952AT" "N8938A" "N685DA" "N13110" "N353AT"
## [3097] "N68452" "N176DZ" "N911DA" "N395DN" "N621SW" "N14198" "N14116" "N17146"
## [3105] "N523AS" "N75861" "N705UW" "N833MQ" "N939AT" "N920WN" "N292WN" "N448WN"
## [3113] "N622MQ" "N916DL" "N248WN" "N261AT" "N171DN" "N492UA" "N607LR" "N3JVAA"
## [3121] "N347SW" "N732US" "N3DJAA" "N381AA" "N984DL" "N3741S" "N617SW" "N741SA"
## [3129] "N978SW" "N740SW" "N326AT" "N992DL" "N910WN" "N951FR" "N614DL" "N602MQ"
## [3137] "N102UW" "N3HHAA" "N691WN" "N6702" "N508AA" "N661MQ" "N261WN" "N503AA"
## [3145] "N3JXAA" "N175DZ" "N586AA" "N3DTAA" "N4YDAA" "N556UA" "N338AT" "N986DL"
## [3153] "N8307K" "N598UA" "N355JB" "N37471" "N5EMAA" "N8745B" "N6700" "N806MQ"
## [3161] "N848MQ" "N807MQ" "N292PQ" "N816MQ" "N811MQ" "N354JB" "N363NB" "N589UA"
## [3169] "N311US" "N605QX" "N373JB" "N556WN" "N724MQ" "N549UA" "N3KGAA" "N770NC"
## [3177] "N923DN" "N3KAAA" "N374JB" "N763SW" "N554WN" "N368JB" "N156UW" "N813MQ"
## [3185] "N698MQ" "N157UW" "N169DZ" "N37419" "N397AA" "N191DN" "N3HTAA" "N57862"
## [3193] "N3KYAA" "N812MQ" "N154UW" "N358JB" "N3KUAA" "N928LR" "N551UA" "N344AT"
## [3201] "N204FR" "N187DN" "N596UA" "N7746C" "N178DN" "N526VA" "N910FJ" "N18114"
## [3209] "N186PQ" "N330AT" "N538CA" "N8321D" "N568UW" "N28478" "N536UA" "N387AA"
## [3217] "N804MQ" "N37474" "N6705Y" "N857MQ" "N504AA" "N8977A" "N198UW" "N782NC"
## [3225] "N36472" "N958DL" "N7741C" "N3KJAA" "N904WN" "N761RR" "N682MQ" "N362NB"
## [3233] "N182DN" "N190DN" "N3JYAA" "N912WN" "N128UW" "N925MQ" "N985DL" "N507AY"
## [3241] "N787NC" "N493WN" "N3KNAA" "N924FJ" "N36476" "N283AT" "N684DA" "N340NW"
## [3249] "N1604R" "N521VA" "N3KSAA" "N941DL" "N827JB" "N606LR" "N728SW" "N353AA"
## [3257] "N650DL" "N6716C" "N911DE" "N3AEAA" "N639VA" "N681DA" "N199UW" "N793SA"
## [3265] "N38467" "N3KVAA" "N908MQ" "N641UA" "N131EV" "N16065" "N361VA" "N684MQ"
## [3273] "N3KLAA" "N762NC" "N909FJ" "N347AA" "N169AT" "N583AS" "N939DL" "N502AA"
## [3281] "N3KEAA" "N567UW" "N165US" "N520AS" "N676UA" "N640AW" "N8328A" "N773NC"
## [3289] "N3KCAA" "N3KKAA" "N3KWAA" "N191UW" "N378SW" "N121UW" "N564UA" "N435WN"
## [3297] "N8928A" "N779NC" "N3LBAA" "N922FJ" "N417WN" "N336AT" "N27477" "N772SW"
## [3305] "N526AS" "N37470" "N932WN" "N419AS" "N6708D" "N963UW" "N313US" "N492WN"
## [3313] "N57855" "N479AA" "N3KPAA" "N284WN" "N972DL" "N676MQ" "N39475" "N713SW"
## [3321] "N193DN" "N3KHAA" "N37468" "N423AS" "N37466" "N6706Q" "N3CMAA" "N943DL"
## [3329] "N314US" "N557NW" "N184DN" "N668MQ" "N939MQ" "N8771A" "N485AA" "N38473"
## [3337] "N525VA" "N929LR" "N223WN" "N632SW" "N151UW" "N188DN" "N5FDAA" "N3KMAA"
## [3345] "N190UW" "N8733G" "N555AA" "N390HA" "N550NW" "N3KTAA" "N150UW" "N59053"
## [3353] "N218FR" "N416WN" "N548UA" "N929DL" "N628AW" "N308AT" "N36469" "N153UW"
## [3361] "N926LR" "N152UW" "N828JB" "N316AT" "N813AY" "N196DN" "N766NC" "N206WN"
## [3369] "N717SA" "N658MQ" "N1200K" "N933LR" "N333NB" "N488WN" "N932DL" "N184AT"
## [3377] "N948WN" "N643SW" "N197DN" "N391HA" "N779SW" "N366AA" "N7811F" "N956LR"
## [3385] "N750UW" "N942WN" "N739GB" "N403AA" "N369AA" "N5FEAA" "N569UW" "N847MQ"
## [3393] "N57863" "N771SA" "N3KRAA" "N172DZ" "N914DN" "N608AT" "N834MQ" "N8608N"
## [3401] "N738CB" "N192DN" "N409AS" "N75853" "N534UW" "N834JB" "N122US" "N784NC"
## [3409] "N179DN" "N534US" "N3742C" "N255WN" "N279AT" "N263WN" "N8609A" "N524AS"
## [3417] "N375AA" "N8942A" "N189DN" "N147PQ" "N155UW" "N558AA" "N643MQ" "N517AS"
## [3425] "N665UA" "N683DA" "N119US" "N967UW" "N928MQ" "N172DN" "N225WN" "N677MQ"
## [3433] "N7732A" "N413AS" "N958AT" "N914FJ" "N8325D" "N6709" "N969WN" "N802MQ"
## [3441] "N77867" "N7724A" "N7812G" "N3KDAA" "N689MQ" "N625MQ" "N920FJ" "N856NW"
## [3449] "N278AT" "N435US" "N3KXAA" "N656UA" "N6713Y" "N547UA" "N968WN" "N514MJ"
## [3457] "N931LR" "N195PQ" "N908WN" "N194DN" "N538AS" "N606SW" "N902FJ" "N707EV"
## [3465] "N282WN" "N604MQ" "N907FJ" "N368AA" "N306AS" "N8721B" "N8616C" "N457WN"
## [3473] "N666UA" "N3KBAA" "N644UA" "N671MQ" "N923FJ" "N285AT" "N267WN" "N8602F"
## [3481] "N154DL" "N392HA" "N927LR" "N200WN" "N175AT" "N706SW" "N171DZ" "N8303R"
## [3489] "N822MQ" "N174DN" "N794SW" "N817MQ" "N1603" "N412WN" "N522US" "N915FJ"
## [3497] "N615SW" "N295AT" "N8610A" "N217JC" "N69804" "N810AW" "N903FJ" "N919AT"
## [3505] "N623AA" "N945DN" "N303AS" "N918FJ" "N512AS" "N673DL" "N105UW" "N549AA"
## [3513] "N375SW" "N276AT" "N177DZ" "N974AT" "N795SW" "N393HA" "N919FJ" "N905MQ"
## [3521] "N440US" "N7744A" "N376AA" "N240AT" "N939LR" "N431AS" "N5CHAA" "N945WN"
## [3529] "N821MQ" "N916FJ" "N616MQ" "N687MQ" "N906FJ" "N367AA" "N854NW" "N814MQ"
## [3537] "N828MH" "N646MQ" "N620SW" "N663UA" "N780NC" "N615DL" "N199DN" "N608MQ"
## [3545] "N839MH" "N293PQ" "N809NW" "N379AA" "N749SW" "N910DN" "N522VA" "N8606C"
## [3553] "N941UW" "N649MQ" "N3KFAA" "N177DN" "N256WN" "N831MQ" "N935MQ" "N652MQ"
## [3561] "N73860" "N512MJ" "N718SW" "N68801" "N621MQ" "N434US" "N594NW" "N279PQ"
## [3569] "N697SW" "N433AS" "N375JB" "N633AW" "N813SK" "N663MQ" "N501MJ" "N8615E"
## [3577] "N662MQ" "N529VA" "N294PQ" "N774NC" "N684WN" "N272PQ" "N942LR" "N295PQ"
## [3585] "N8612K" "N69806" "N637SW" "N602SW" "N553NW" "N912FJ" "N692MQ" "N627SW"
## [3593] "N665WN" "N647SW" "N571UW" "N625SW" "N568UA" "N358SW" "N655UA" "N570UW"
## [3601] "N935LR" "N764NC" "N346SW" "N911FJ" "N904DA" "N633SW" "N8986B" "N531US"
## [3609] "N849MQ" "N66803" "N953DN" "N827MQ" "N622SW" "N645SW" "N68802" "N392AA"
## [3617] "N938LR" "N691MQ" "N8617E" "N183DN" "N611SW" "N376SW" "N786NC" "N68805"
## [3625] "N695MQ" "N637MQ" "N359AA" "N961DN" "N657UA" "N907MQ" "N372AA" "N664MQ"
## [3633] "N8320J" "N378AA" "N156DL" "N439US" "N450UW" "N527VA" "N629MQ" "N296PQ"
## [3641] "N8614M" "N693CA" "N941MQ" "N389AA" "N363SW" "N355SW" "N382AA" "N925FJ"
## [3649] "N371SW" "N659UA" "N618WN" "N8618N" "N5CNAA" "N365SW" "N3LAAA" "N610WN"
## [3657] "N852MQ" "N440AS" "N657SW" "N367SW" "N644SW" "N941DN" "N820MQ" "N356SW"
## [3665] "N933MQ" "N309AT" "N652UA" "N8613K" "N435AS" "N374SW" "N386SW" "N803SK"
## [3673] "N685SW" "N299AT" "N682DA" "N8601C" "N653SW" "N674MQ" "N8603F" "N881AS"
## [3681] "N640SW" "N395HA" "N8619F" "N649SW" "N915DN" "N245AY" "N395SW" "N802AW"
## [3689] "N427US" "N66808" "N746SK" "N8607M" "N368SW" "N844MQ" "N7AYAA" "N932LR"
## [3697] "N8317M" "N775NC" "N297PQ" "N659SW" "N934FJ" "N697MQ" "N8301J" "N5DLAA"
## [3705] "N345SA" "N8620H" "N687SW" "N298PQ" "N928DN" "N686MQ" "N273AT" "N369SW"
## [3713] "N319AS" "N299PQ" "N373SW" "N930LR" "N387SW" "N354SW" "N352SW" "N372SW"
## [3721] "N8314L" "N442AS" "N613SW" "N690MQ" "N360SW" "N57016" "N670MQ" "N8621A"
## [3729] "N902DA" "N829MH" "N662SW" "N173AT" "N5DHAA" "N958DN" "N337AT" "N7715E"
## [3737] "N379SW" "N340LV" "N388SW" "N1501P" "N903JB" "N533US" "N848AS" "N7AAAA"
## [3745] "N908FJ" "N907JB" "N392SW" "N68807" "N900EV" "N665MQ" "N913FJ" "N824AW"
## [3753] "N3LEAA" "N626SW" "N858AS" "N913JB" "N221FR" "N905FJ" "N871AS" "N840AS"
## [3761] "N511SW" "N678MQ" "N572UW" "N870AS" "N3LGAA" "N928EV" "N660SW" "N683BR"
## [3769] "N669SW" "N834AW" "N525SW" "N64809" "N655WN" "N3LFAA" "N7713A" "N399WN"
## [3777] "N394SW" "N514AS" "N926EV" "N7BMAA" "N640MQ" "N3LDAA" "N696MQ" "N647DL"
## [3785] "N528AS" "N457UW" "N5FBAA" "N77012" "N5DAAA" "N455UW" "N593AS" "N532AS"
## [3793] "N627AW" "N32626" "N459UW" "N516AA" "N569AS" "N519AS" "N506AA" "N614SW"
## [3801] "N910FR" "N391SW" "N289AT" "N590AS" "N850MQ" "N842MH" "N863DA" "N629SW"
## [3809] "N906DA" "D942DN" "N694SW" "N530AS" "N638SW" "N562AS" "N7AEAA" "N552NW"
## [3817] "N419US" "N858MQ" "N7ACAA" "N302AS" "N59630" "N585AS" "N7AXAA" "N851MQ"
## [3825] "N907DA" "N600WN" "N941FR" "N350SW" "N830MQ" "N5DKAA" "N919DN" "N7BAAA"
## [3833] "N624SW" "N612SW" "N566AS" "N366SW" "N1607B" "N959DN" "N830AW" "N350AA"
## [3841] "N581AS" "N1610D" "N663SW" "N7BVAA" "N661UA" "N626MQ" "N532US" "N206UA"
## [3849] "N814AW" "N675MQ" "N549US" "N660UA" "N587AS" "N580AA" "N309AS" "N136DL"
## [3857] "N717MQ" "N384SW" "N507US" "N608DA" "N738MQ" "N8611F" "N720MQ" "N530US"
## [3865] "N905DA" "N626AW" "N570AS" "N634SW" "N501US" "N7ASAA" "N932DN" "N328AT"
## [3873] "N735MQ" "N559AS" "N318AS" "N963DN" "N651UA" "N516AS" "N5EDAA" "N78013"
## [3881] "N5DJAA" "N831MH" "N7ALAA" "N750AT" "N8605E" "N721MQ" "N7BGAA" "N647UA"
## [3889] "N453UW" "N5ESAA" "N632AW" "N527AS" "N601WN" "N456UW" "N315AT" "N441US"
## [3897] "N525AS" "N670SW" "N646UA" "N964DN" "N530VA" "N838MQ" "N650SW" "N524VA"
## [3905] "N921FJ" "N631AW" "N757AT" "N442US" "N586AS" "N653UA" "N502SW" "N903DA"
## [3913] "N777NC" "N917FJ" "N670US" "N527SW" "N944DN" "N508SW" "N836AW" "N521SW"
## [3921] "N394DL" "N515SW" "N451UW" "N351NB" "N777UA" "N917DN" "N522SW" "N675MC"
## [3929] "N510SW" "N523SW" "N315AS" "N287AT" "N528VA" "N943DN" "N512SW" "N649UA"
## [3937] "N7BKAA" "N526SW" "N524SW" "N78003" "N920DN" "N846AS" "N956DN" "N960DN"
## [3945] "N937DN" "N955DN" "N514SW" "N27901" "N827AW" "N825MH" "N328NB" "N625AW"
## [3953] "N600TR" "N654UA" "N137DL" "N800MQ" "N539US" "N361SW" "N828AW" "N648SW"
## [3961] "N921DN" "N330NB" "N787UA" "N7CAAA" "N622AW" "N534AS" "N354NB" "N838MH"
## [3969] "N913EV" "N820AW" "N564AS" "N809AW" "N427SW" "N595NW" "N837MH" "N398SW"
## [3977] "N608SW" "N648UA" "N826MH" "N331NB" "N826AW" "N587NW" "N352NB" "N817AW"
## [3985] "N948FR" "N547US" "N862DA" "N851NW" "N834MH" "N819AW" "N962DN" "N823MQ"
## [3993] "N827MH" "N844MH" "N939DN" "N841MH" "N913DN" "N121DE" "N153DL" "N845MH"
## [4001] "N918DH" "N815AW" "N536AS" "N616SW" "N835AW" "N940UW" "N5FCAA" "N904FJ"
## [4009] "N5ERAA" "N957DN" "N840MH" "N228UA" "N654MQ" "N789SK" "N152DL" "N790SK"
## [4017] "N843MH" "N797SK" "N762SK" "N933DN" "N768SK" "N795SK" "N780SK" "N143DA"
## [4025] "N740SK" "N726SK" "N705SK" "N728SK" "N824AS" "N702SK" "N560AS" "N778SK"
## [4033] "N922EV" "N710SK" "N647MQ" "N794SK" "N636WN" "N701SK" "N760SK" "N766SK"
## [4041] "N772SK" "N776SK" "N785SK" "N557AS"unique(flights$origin)## [1] "EWR" "LGA" "JFK"unique(flights$dest)## [1] "IAH" "MIA" "BQN" "ATL" "ORD" "FLL" "IAD" "MCO" "PBI" "TPA" "LAX" "SFO"
## [13] "DFW" "BOS" "LAS" "MSP" "DTW" "RSW" "SJU" "PHX" "BWI" "CLT" "BUF" "DEN"
## [25] "SNA" "MSY" "SLC" "XNA" "MKE" "SEA" "ROC" "SYR" "SRQ" "RDU" "CMH" "JAX"
## [37] "CHS" "MEM" "PIT" "SAN" "DCA" "CLE" "STL" "MYR" "JAC" "MDW" "HNL" "BNA"
## [49] "AUS" "BTV" "PHL" "STT" "EGE" "AVL" "PWM" "IND" "SAV" "CAK" "HOU" "LGB"
## [61] "DAY" "ALB" "BDL" "MHT" "MSN" "GSO" "CVG" "BUR" "RIC" "GSP" "GRR" "MCI"
## [73] "ORF" "SAT" "SDF" "PDX" "SJC" "OMA" "CRW" "OAK" "SMF" "TUL" "TYS" "OKC"
## [85] "PVD" "DSM" "PSE" "BHM" "CAE" "HDN" "BZN" "MTJ" "EYW" "PSP" "ACK" "BGR"
## [97] "ABQ" "ILM" "MVY" "SBN" "LEX" "CHO" "TVC" "ANC" "LGA"There is no inconsistent case in all column therefore its safe
Check for logical inconsistencies
Depart time should be smaller than arrive time
flights %>%
filter(arr_time<dep_time)## # A tibble: 10,633 × 19
## year month day dep_time sched_dep_time dep_delay arr_time sched_arr_time
## <int> <int> <int> <int> <int> <dbl> <int> <int>
## 1 2013 1 1 1929 1920 9 3 7
## 2 2013 1 1 1939 1840 59 29 2151
## 3 2013 1 1 2058 2100 -2 8 2359
## 4 2013 1 1 2102 2108 -6 146 158
## 5 2013 1 1 2108 2057 11 25 39
## 6 2013 1 1 2120 2130 -10 16 18
## 7 2013 1 1 2121 2040 41 6 2323
## 8 2013 1 1 2128 2135 -7 26 50
## 9 2013 1 1 2134 2045 49 20 2352
## 10 2013 1 1 2136 2145 -9 25 39
## # ℹ 10,623 more rows
## # ℹ 11 more variables: arr_delay <dbl>, carrier <chr>, flight <int>,
## # tailnum <chr>, origin <chr>, dest <chr>, air_time <dbl>, distance <dbl>,
## # hour <dbl>, minute <dbl>, time_hour <dttm>Logically, depart time should have smaller value than arrive time because a flight can’t arrive before it departs. To clean the datas with logical inconsistencies, we will use filter(arr_time)<dep_time.
Data Cleaning summary
Before summarizing, we will first drop row with the missing values(NA) and input it in the new variable “flights_cleaned”
flights_cleaned = flights%>%
drop_na()Here is the summary of the cleaned data.
summary(flights_cleaned)## year month day dep_time sched_dep_time
## Min. :2013 Min. : 1.000 Min. : 1.00 Min. : 1 Min. : 500
## 1st Qu.:2013 1st Qu.: 4.000 1st Qu.: 8.00 1st Qu.: 907 1st Qu.: 905
## Median :2013 Median : 7.000 Median :16.00 Median :1400 Median :1355
## Mean :2013 Mean : 6.565 Mean :15.74 Mean :1349 Mean :1340
## 3rd Qu.:2013 3rd Qu.:10.000 3rd Qu.:23.00 3rd Qu.:1744 3rd Qu.:1729
## Max. :2013 Max. :12.000 Max. :31.00 Max. :2400 Max. :2359
## dep_delay arr_time sched_arr_time arr_delay
## Min. : -43.00 Min. : 1 Min. : 1 Min. : -86.000
## 1st Qu.: -5.00 1st Qu.:1104 1st Qu.:1122 1st Qu.: -17.000
## Median : -2.00 Median :1535 Median :1554 Median : -5.000
## Mean : 12.56 Mean :1502 Mean :1533 Mean : 6.895
## 3rd Qu.: 11.00 3rd Qu.:1940 3rd Qu.:1944 3rd Qu.: 14.000
## Max. :1301.00 Max. :2400 Max. :2359 Max. :1272.000
## carrier flight tailnum origin
## Length:327346 Min. : 1 Length:327346 Length:327346
## Class :character 1st Qu.: 544 Class :character Class :character
## Mode :character Median :1467 Mode :character Mode :character
## Mean :1943
## 3rd Qu.:3412
## Max. :8500
## dest air_time distance hour
## Length:327346 Min. : 20.0 Min. : 80 Min. : 5.00
## Class :character 1st Qu.: 82.0 1st Qu.: 509 1st Qu.: 9.00
## Mode :character Median :129.0 Median : 888 Median :13.00
## Mean :150.7 Mean :1048 Mean :13.14
## 3rd Qu.:192.0 3rd Qu.:1389 3rd Qu.:17.00
## Max. :695.0 Max. :4983 Max. :23.00
## minute time_hour
## Min. : 0.00 Min. :2013-01-01 05:00:00.00
## 1st Qu.: 8.00 1st Qu.:2013-04-05 06:00:00.00
## Median :29.00 Median :2013-07-04 09:00:00.00
## Mean :26.23 Mean :2013-07-03 17:56:45.44
## 3rd Qu.:44.00 3rd Qu.:2013-10-01 18:00:00.00
## Max. :59.00 Max. :2013-12-31 23:00:00.00