| id | iata_code | airport_name | city_name | country_name | latitude | longitude | |
|---|---|---|---|---|---|---|---|
| 1 | 1655 | CXH | Coal Harbour | Vancouver | Canada | 49.289722 | -123.115833 |
| 2 | 8575 | XEA | Vancouver Rail Stn. | Vancouver | France | 49.273611 | -123.0975 |
| 3 | 8803 | YDT | Boundary Bay | Vancouver | Canada | 49.074167 | -123.012222 |
| 4 | 9117 | YVR | Vancouver Intl | Vancouver, British Columbia | Canada | 49.193889 | -123.184444 |