1. Which airplanes fly LGA to XNA (1 POINT)
## # A tibble: 4 × 3
## tailnum manufacturer model
## <chr> <chr> <chr>
## 1 N711MQ GULFSTREAM AEROSPACE G1159B
## 2 N737MQ CESSNA 172N
## 3 N840MQ CANADAIR LTD CF-5D
## 4 N713EV BOMBARDIER INC CL-600-2C10
2. 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. Which airports have no commercial flights (1 POINT)
## # A tibble: 1,337 × 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,327 more rows
4. EXTRA CREDIT - (2 POINTS) - NO HELP - NO PARTIAL CREDIT Create a
table with the names of the airports with the most winds (wind_speed
> 30). The table must contain only the airport name (airports$name)
and no duplicate rows
## # A tibble: 3 × 1
## name
## <chr>
## 1 Newark Liberty Intl
## 2 John F Kennedy Intl
## 3 La Guardia