Assignment_5

1. join + filter - Which airplanes fly LGA to XNA (1 POINT)

## # A tibble: 70 × 5
##    tailnum manufacturer         model  plane_year seats
##    <chr>   <chr>                <chr>       <int> <int>
##  1 N722MQ  <NA>                 <NA>           NA    NA
##  2 N719MQ  <NA>                 <NA>           NA    NA
##  3 N739MQ  <NA>                 <NA>           NA    NA
##  4 N711MQ  GULFSTREAM AEROSPACE G1159B       1976    22
##  5 N723MQ  <NA>                 <NA>           NA    NA
##  6 N730MQ  <NA>                 <NA>           NA    NA
##  7 N734MQ  <NA>                 <NA>           NA    NA
##  8 N725MQ  <NA>                 <NA>           NA    NA
##  9 N736MQ  <NA>                 <NA>           NA    NA
## 10 N737MQ  CESSNA               172N         1977     4
## # ℹ 60 more rows

2. join - Add the airline name to the flights table (1 POINT)

## # A tibble: 6 × 8
##    year month   day carrier name                   flight origin dest 
##   <int> <int> <int> <chr>   <chr>                   <int> <chr>  <chr>
## 1  2013     1     1 UA      United Air Lines Inc.    1545 EWR    IAH  
## 2  2013     1     1 UA      United Air Lines Inc.    1714 LGA    IAH  
## 3  2013     1     1 AA      American Airlines Inc.   1141 JFK    MIA  
## 4  2013     1     1 B6      JetBlue Airways           725 JFK    BQN  
## 5  2013     1     1 DL      Delta Air Lines Inc.      461 LGA    ATL  
## 6  2013     1     1 UA      United Air Lines Inc.    1696 EWR    ORD

3. join + select + distinct() - Which airports have no commercial flights (1 POINT)

## # A tibble: 1,339 × 1
##    name                          
##    <chr>                         
##  1 Lansdowne Airport             
##  2 Moton Field Municipal Airport 
##  3 Schaumburg Regional           
##  4 Randall Airport               
##  5 Jekyll Island Airport         
##  6 Elizabethton Municipal Airport
##  7 Williams County Airport       
##  8 Finger Lakes Regional Airport 
##  9 Shoestring Aviation Airfield  
## 10 Jefferson County Intl         
## # ℹ 1,329 more rows

4. EXTRA CREDIT - (2 POINT2) - NO HELP - NO PARTIAL CREDIT

## # A tibble: 3 × 1
##   name               
##   <chr>              
## 1 Newark Liberty Intl
## 2 John F Kennedy Intl
## 3 La Guardia