A couple of months ago, Google Maps quietly added a Terrain layer to their maps. I’ve enabled that in OurAirports now, so that you can get at least a rough idea of the terrain around an airport (or in a region, country, etc.).
For example, here’s why there are so many accidents around Hope, BC when the weather gets low.
I’ve finally gotten around to adding free data downloads to OurAirports. You can now download nightly CSV-formatted data dumps of all the airports, countries, and regions in OurAirports at
http://www.ourairports.com/data/
These will open with most spreadsheet and database programs (make sure you import them as UTF-8).
All data is released into the Public Domain and comes with no warranty. If you have any corrections or additions, please make them in the spreadsheet and then send them back to me.
I’ve written a web site called OurAirports that lets you make a map of the airports you’ve visited (either as a pilot or as a passenger, your choice). Here’s my personal map — note that you can share your maps with anyone, not just other members:
http://www.ourairports.com/members/david/
To make your own map, set up a free account (takes about 30 seconds), then just click in the “I’ve been here!” box on each airport’s page. You can also browse the airports of the world on The Big Map or drill down geographically. My favourite, though, is warping to a random airport.
This is just a web site, not a startup — sadly, there aren’t enough of us to build a real business out of this. But there’s no point spending any more time on it if the site’s not fun, so if you don’t do anything else please visit the site and let me know what I could do to make it more fun for you as a pilot, airline passenger, GA passenger, etc.
If you feel like helping even more, I’d be grateful if you could show the site to other people who like flying and find out what they think of it. The site lets you leave comments on airports, like AirNav.com does, except that it includes airports outside the U.S. and doesn’t force you to attach comments to a specific FBO. The more comments people leave, the more useful the site is.
Finally, if you’re really hardcore helpful (or you’re stuck in a long layover with nothing else to do), here are some of the things I’m thinking about for the next step, and I’d love to hear people’s preferences:
Let people categorize airport comments (FBO, wifi, fuel, food, ground transpo, etc.) so that it’s easier to find information.
Set up editing and moderation privileges, so that members can add and correct airport (and maybe navaid?) data to keep it current.
Add forums for organizing fly-ins, buying or selling used stuff (tools, GPS, plane, whatever), or even ride boards linked to individual airports, so that you can see what’s going on in your area.
Add navaids, fixes, and basic flight-planning support (draw lines on the map) — this would appeal only to pilots, of course.
Add bulk entry of airports, so that you can just type all the IDs of the airports you’ve visited into a textarea instead of going to each airport page and clicking.
Export airport data in GPX format, so that you can load it into your GPS.
Let members upload GPS tracks to the site, so that they can be displayed on the map and shared with other people.
Add the usual airport data that other sites have (runway lengths, frequencies, etc.)
Try to dig up information on airline schedules and link it to the site.
Give up on the whole idea and do something useful with my free time.
Let me know what you think, and please help me let other pilots know about the site. If you want to send me private email instead of commenting here, my GMail id is david.megginson, and the domain for GMail addresses is gmail.com.
I was reading through an article on pilotage [Wikipedia] in the December AOPA Pilot. In general, I found the article enjoyable, but one thing stuck out like a wart — the author’s assumption that people should always read a chart track up (with the chart rotated for the direction they’re heading) rather than north up.
I have no objection to the suggestion that people try using a chart track up, but frequent claim that it’s easier — and some pundits’ and instructors’ insistence that it’s the only proper way — grates a bit. In informal surveys on aviation mailing lists, I’ve found people split about 50:50 between north up and track up, and I suspect that it has to do with how different people’s brains work, something along the lines of left-handedness and right-handedness.
Personally, if I’m flying west, my mind already pictures me flying right to left, so it’s by far easier to hold the chart north up so that it lines up with what I’m seeing in my head. Track up would be a double annoyance, since (1) I’d have to rotate everything in my head, and (2) all the text on the chart might be sideways or upside down. Likewise, when I’m walking, cycling, or driving around a city, I think of myself as heading northwest, south, etc. — I never memorize a trip as a series of left or right turns. I imagine that people who do navigate that way probably also find track up easier.
So if you fly, hike, boat, or whatever, do you prefer to hold your charts (or set your GPS display) north up or track up? Why? If you’re an instructor (aviation, seach-and-rescue, orienteering, etc.), have your students generally found one or the other easier? Has anyone every done a proper scientific study?
[Update 2006-11-20: it looks like they've pulled even the small amount of Canadian data that they can get from the FAA database — there's nothing but US airports and navaids in there now.]
Well, the DAFIF — the free database of worldwide aeronautical information that used to be available free from the U.S. Department of Defense — has been gone for a few weeks, and it’s having repercussions that I hadn’t anticipated. It turns out that the most popular flight planning web site, Aeroplanner, was using the DAFIF for their non-U.S. data, so Canada has suddenly gone blank: aside from a few major airports and navaids that happen to be in the FAA database, and the segments of a few airways crossing the border, the airways, intersections, navaids, airports, terminal airspace, control zones, restricted airspace, and everything else that used to crowed their online maps is gone, leaving the site useless for anyone (Canadian or American) planning a flight that doesn’t stay entirely within U.S. airspace. The company graciously offered me a pro-rated refund for my subscription, though I decided not to take them up on it.
Lots of other people use the DAFIF for cheap or free flight planning, for controlling aircraft in flight simulators, and much more. In many cases, they can keep using the last public edition, which will slowly get more and more out of date, but that obviously wouldn’t be a responsible choice for a real-world online flight planning service like Aeroplanner.
So who should we be mad at? The U.S. DoD is an obvious target, since they’re the ones who pulled the data from public use, but let’s step back and think for a second:
Sure, I wish they still published the DAFIF (and I suspect their reasons for stopping are silly), but the real villains here are the Canadian government, the British government, the Australian government, and every other government that refuses to release free information to their own citizens about their own airspace. We were lucky that the U.S. DoD was willing to help cover that disgraceful gap for so many years, and that they have given us a good starting point for a free,collaborative airnav database (we still have the last DAFIF edition to start from), but our years of living off American charity have now ended.
Speaking of free, collaborative databases, Paul Tomblin has set up a wiki to start discussing life after DAFIF. Why not swing by and take a look. And don’t be surprised if, in the meantime, your favorite flight planning tool suddenly turns Canada into the huge, empty white space that the rest of the world always imagined it was.
I flew from Ottawa to Sault Ste. Marie yesterday, then flew a Hope Air patient from the Soo to Kingston this morning, before making the short hop back to Ottawa in the afternoon.
Flying westbound to the Soo is a slow prospect in the Warrior. The trip is a bit under 400 nm, but due to the headwinds, it generally takes around four hours. This time, it was all IFR, but at least it was smooth, the icing levels were well above me, and all the thunderstorm activity was about 50 miles to the north of my route. Everytime Toronto Centre gave me a new altimeter setting, it was significantly lower, sometimes requiring an altitude change of a couple of hundred feet, as I flew towards the big low parked over Lake Superior and the nasty weather around it. The IMC on my route from Ottawa, however, had a different cause: the tropical storms and hurricanes had pushed a huge amount of hot, humid air north above them, leaving a stationary front a bit south of James Bay (north of my route). Because the front was there for so long, what had been supposed to be nice and clear became cloudy and hazy, plunging us into unseasonable IMC of the summer variety.
A cold front was be blowing through overnight, and I know that I’d have to fly through that cold front from the back side in the morning. For those who don’t fly, you need to understand that cold fonts suck — they mean lots of rain, thunderstorms, turbulence, fog, cloud, and just about anything else you don’t like (in the summer, they even bring tornados). Lying awake in my hotel room at 5:00 am I heard the rain pounding outside, and knew that the front was on its way through.
When I walked out of my hotel in the morning, I found an airplane sitting in the parking lot right outside the door. I wasn’t sure whether to take this as an omen of good luck (the flight will go fine) or a warning (it’s a good day to tow your plane on a trailer) — I guess superstition is too complicated. Here’s a second cellphone photo of the plane, this time from behind, the way I saw it when I walked outside.
IMC and thunderstorms are a bad combination, because when you’re in cloud, there’s no way to see a storm coming. Before I left, weather radar showed that all the activity was well north of my route, though the GFA called for isolated thunderstorms all over ahead of the cold front. I evaluated the situation, and decided to list every way I had to avoid storms:
None of these is 100% reliable: between cloud layers (and the layers go very high ahead of a cold front), it’s often hard to make out buildups ahead, since everything fades to white; the Stormscope is a very blunt instrument and misses intense weather that doesn’t happen to produce lightning; and Flight Services is looking at outdated and and low-res lightning and radar pictures, when I can reach them by radio at all. As a result, I made a couple of rules for my flight:
It turned out a bit bumpy, with a lot of rain, but nothing more disturbing. Three hours of hand-flown IMC has left me a bit tired now, though. As usual, the weather cleared up just before my destination, so I didn’t get to log an approach.
With the tailwind from the southwest, I flew into Ottawa like a rocket: the whole flight from Kingston took about a half hour, and I made it home before the front hit Eastern Ontario. Unfortunately, I then had to wait 35 minutes for a cab to take me the last 10 km home. The wind’s starting to shake the leaves outside my window now, so I guess the weather’s on it’s way in our game of leapfrog.
Google Earth is a 3D geographical visualization program available for Windows, MacOS X, and Linux.
DAFIF is a free (soon-to-be-closed) database of major airports, airways, airspace, etc. around the world.
Now, the Russian Academy of Science has created a mashup of the two (via the Google Earth Blog), so that you can see airways, navaids, etc. while you’re flying around Google Earth. If you have Google Earth installed, here’s the link to the DAFIF information.
How long until we can get satellite weather overlayed on Google Earth?
The U.S. government has released its 2005 Federal Radionavigation Plan [PDF, 74 pages]. Here is what they are proposing for each type of aviation-related navigation aid:
So, I’ll be good for IFR in my Warrior for a few more years without an IFR-certified GPS, but I’d better start a savings fund if I want to do precision approaches after 2015. It looks like the DME receiver in my panel will be useful for a while longer, though.
Thanks to a posting by Paul Tomblin, I just discovered a new aviation Google-maps mashup. Normally, Google maps lets you switch among a map view, a satellite photo, and a satellite photo with map info superimposed (called a hybrid view). In this mashup, Runway Finder, an anonymous developer (”dave”) has added a view based on tiled and geo-referenced US sectional charts. So now you can go anywhere covered by US sectionals — including many Canadian cities — and zoom in or out, and switch among sectional, road map, and satellite views. Very nice. Unlike other free online sectional viewers, this one gives you a decent size viewing window, on top of all the Google Maps bells and whistles.
The site also shows airports near your current location, with colour coding for weather conditions reported in METARs, as well as TFR outlines. Unfortunately, all of this is available only for the U.S. right now (hint to dave: Paul Tomblin maintains a free database with worldwide airport, navaid, and intersection data). Looking at the sectionals makes me even sadder that the U.S. is the only country with the decency to make geodata and charts available free to the public — it would be nice if VNCs were available for full Canadian chart coverage.
One current shortcoming is that it’s not possible to bookmark a view and come back to it, but I’m sure that will be fixed soon.
I’ve thrown together a quick demo of several segments (almost 400 miles worth) of the V316 low-level airway westbound from the Ottawa VORTAC to the Sault Ste. Marie VOR/DME. The best part, in my opinion, is the ability to switch to a satellite view and then zoom in on different parts of the route — for example, switch to satellite, zoom in on the Killaloe VOR, and you will be able to see the abandoned airfield beside the VOR.
There is no server-side code involved in this demo: everything happens inside your browser (as a result, it won’t work without a fairly new browser). The demo consists of a simple HTML page, a few lines of JavaScript, and a short CSS stylesheet.
Google has just made an announcement that could have a profound effect on the resources available for flight planning online: they have created a free API (application programming interface) to Google Maps.
The flying geeks who read this blog will understand the implications of this immediately; for the rest of you, it means that any web site (any free one, anyway) can now reliably build web applications integrating Google’s maps and satellite photos. Do you want to see a scrollable, zoomable satellite photo of British Columbia with victor airways overlaid? See an outline of the newest TFR on top of a detailed street map of New York? Web site designers with only the most basic LAMP and Javascript skills can now deliver sites that do that with days or weeks, rather than months or years of work, and people with advanced skills — Paul Tomblin knows I’m talking about him — will be able to do much, much more. With wireless Internet in the cockpit, we could even have live Google maps with weather overlays on a tablet PC in the our cockpits, and laugh at glass-cockpit pilots for their primitive technology.
Seriously, expect to see some interesting aviation-related applications appear in the next few months. I’ll link to them from my blog if I hear about them.
As I’ve mentioned before, I’m often frustrated at the lack of freely-available data for Canadian airports and airspace (and stung by the irony that most of what is available comes from the U.S.). Over the past couple of years, I’ve repeatedly started trying to put data for all airports in the Canada Flight Supplement (CFS) into an XML file or spreadsheet, but have always either given up or ran out of time before the next CFS cycle came out.
As a result, I am happy to report that someone else has succeeded where I failed. George Plews, of North Battleford SK, has managed to get all of the airports, ICAO identifiers, latitudes, and longitudes from the CFS into an excel spreadsheet, and also has it available for viewing on the web on his page Airports in Canada, together with lots of totals and statistics (for example, Ontario has 218 airports, while PEI has 4). Give his page a visit or grab the spreadsheet. Maybe the rest of us can find a way to contribute to make the spreadsheet more useful; at very least, people could commit to scanning part of the CFS each cycle for change bars, so that George can keep is spreadsheet up to date without redoing the whole thing. It would also be nice to add altitudes for the airports. Then there’s the runway data …
I flew back from Timmins yesterday after a Hope Air flight via Toronto (Timmins is the home of singer Shania Twain, as the signs there constantly remind you). The airspace around Timmins is controlled, but there is little or no radar coverage below 10,000 feet and just an FSS on the field — that means that Toronto Centre has to sequence IFR arrivals and departures based on position reports, the old-fashioned way, and both Wednesday and Thursday were IFR days. On the way in there were four of us with very different speeds (me, a piston twin, a helicopter, and a turboprop) scheduled to arrive at the airport within a few minutes of each other, so ATC had me giving position reports every 10 DME: clearing me for an approach too early would close off the airport to everyone else until the FSS reported me on the ground, since no radar means one in/one out.
On the way out, I took off just before a Dash-8 heading for Toronto. We were flying south on different airways (by 20 degrees), but the protected airspace initially overlapped. That meant that the Dash-8 had to stay 1,000 feet below me to maintain safe separation — when I reported 4,000 ft, the Dash-8 was cleared to 3,000; when I reported 6,000, the Dash-8 was cleared to 5,000; and so on. Fortunately, I was alone in the plane and climbing at 700-800 fpm; a fully-loaded Warrior is lucky to see 200-300 fpm above 5,000 feet, and often goes negative when it hits a downdraft. Finally, the airways diverged far enough that the protected areas no longer overlapped, and the Dash-8 was cleared to climb quickly into the oxygen altitudes and then fly GPS-direct towards Toronto. I applaud the crew for their patience climbing underneath me at Cherokee speed. ATC picked them up on radar climbing through 11,000 feet, and I levelled out at 9,000, still hand flying in IMC, and making position reports until I was half way to North Bay and finally showed up on Centre radar.
(Update: Michael Oxner, an air traffic controller in Moncton, has posted about exactly how this kind ofVOR/DME, non-radar separation works.)
Timmins is at 48° latitude — south of the 49th parallel that forms much of the Canada/US border, and only slightly north of Seattle — but in Ontario, that counts as pretty far north. Once you pass Sudbury, the population density drops so dramatically that every single building (such as a cabin) is depicted on the aviation charts, and there are surprisingly few of them. Not far beyond Timmins, the roads stop completely, and most communities are accessible only by plane. In the end, I think, the idea of north in Canada has more to do with population density and accessibility that it does with latitude, and while Timmins itself is a perfectly normal small city with a nice downtown, malls and fast food chains, you get the impression that you’re sitting right on the edge of something huge and completely different stretching thousands of kilometers beyond you.
In fact, one distinguishing feature of north in Canada is how important (and ordinary) general aviation is in day-to-day life. Along a river just outside of town, every third or fourth dock had a floatplane tied to it (they’re probably all on skis in the winter). One house had, not a rusty pickup truck, but a Piper Cub sitting in the yard (does he take off from the dirt lane out back?). Everyone who doesn’t fly has a boss or friend who does, and non-pilots seem quite comfortable talking about things like instrument ratings. Toronto is 13 hours away by train, probably 10 hours by car (I haven’t checked), but only 2:30-3:30 in my Warrior (depending on winds) and probably 2 hours or less in a high-performance single or twin. Many of the nearby communities have no roads or railroads at all, and a round-trip ticket for a very short scheduled flight to one of those communities is at least $900. As a result, even small business people like insurance brokers and real estate agents find that it makes enormous business sense to learn to fly and buy a small plane.
People who spend time in Edmonton, Yellowknife, or Iqaluit can laugh when I call Timmins “north”, but what it lacks in latitude it seems to make up in attitude.
The U.S. makes most of its aeronautical data available for free in electronic form; other countries hoard the information and charge money (sometimes, a lot of money) for a peek at it. This distinction used to matter mainly to cartographers working with giant mainframe computers, but now that almost everyone flies with a GPS (handheld or panel-mount) our airplanes have become flying databases and they’re getting hungry for information, preferably information that’s free (as in speech).
There are two projects currently underway that will not help to feed our GPS’s directly, but will, at least, give pilots a chance to share more information with each other. First, the Wikipedia has a large number of airport articles underway, and anyone can contribute to any of the articles (or start a new one). The best place to start is the Airports category, which has a top-level entry for each country, and then drill down. Coverage is uneven, representing the interests of the people who happen to have contributed so far — for example, there are currently only 7 airports listed for New Jersey, but 22 airports listed for Nunavut — and many of the airport articles are short stubs, but those are problems that more contributors can easily fix. Please go over and add information (and pictures) for airports that you know well, or start new articles. Since most of Wikipedia’s readers are not pilots, this is a great chance to educate the public about general aviation.
Another new collaborative resource is the COPA Places to Fly directory. Unlike the freeform Wikipedia, the COPA directory is set up to be highly structured, closely mimicking the layout of the Canada Flight Supplement, and its audience is clearly pilots. There’s not much there yet, but it holds the promise of some day providing a free electronic replacement for the CFS, assuming that there’s some way to export it to portable devices, and that people find some way of ensuring data quality in a collaborative environment (i.e. some kind of peer review and reputation management).
In his most recent posting, Moncton Centre controller Michael Oxner makes some friendly but justifiable complaints about summer recreational pilots who don’t bring paper charts in the plane and tie up ATC time when their handheld GPS’s fail (for those pilots’ sake, I hope that their GPS’s had terrain information when they were working — there are mountains pushing above 5,000 ft MSL in Maine on the way from central Canada to the Maritimes).
Here’s a trick I thought of after arriving at the airport once for a long (VFR) family trip, loading up the plane, then realizing that I had left my charts at home: I always, always, carry a couple of 1:1,000,000 scale World Aeronautical Charts (WACs) in my flight bag. WACs have lousy detail but very wide coverage — just two Canadian WACs (F-21 and F-22) cover nearly any single-day trip I’d fly inside Canadian airspace, and add no appreciable bulk or weight. The problem with Canadian WACs, though, is that they’re not updated very often — they may be legal, but most of them haven’t been amended for 10 years or more, so their airspace information is of historical interest only. For that reason, I actually carry American WACs (CF-18 and CF-19), which are updated regularly and happen to include a lot of Canadian airspace.
Since I own my own plane, I also keep a bunch of charts and approach plates for Ontario and Quebec in a small bag under the pilot’s seat — the WACs are actually the backup to my backup now — but for a renter, a couple of WACs in the flight bag seems like a no-brainer, though 1:500,000 scale VNCs/Sectionals and 1:250,000 scale terminal-area charts are, obviously, preferable.
For anyone with time to kill, a high-speed Internet connection, and no concept of the cost of inkjet toner, you can download the U.S. sectional charts here and print them out on your own.
Sometimes it’s hard to love the Canada Flight Supplement or its U.S. equivalent, the Airport and Facility Directory, printed on cheap, easy-to-rip newsprint in tiny smudged type, going out of date every seven weeks, and filled with abbreviations you have trouble remembering. Still, I was looking at the entry from Hearst, ON, where I’ll be flying for Hope Air next week (see this posting about my last trip), and I thought it might be interesting to see how the (very short) entry would look written out in proper English prose. First, a scan of the entry, with a link to a larger image:
Now, the same thing written out in proper English prose.
The Hearst airport is located at latitude 49 degrees 42 minutes 51 seconds north, longitude 83 degrees 41 minutes 10 seconds west, 1.5 nautical miles northwest of the town. The magnetic variation is nine degrees west, and the time zone is five hours behind UTC (four hours during daylight savings time). The elevation of the airfield is 827 feet above mean sea level. The airport appears in the AIR5008 Visual Navigation Chart (Thunder Bay), the E-18 World Aeronautical Chart, and the LO-4 low-altitude IFR enroute chart. It has at least one published instrument approach in the Canada Air Pilot.
The airport operator is the Corporation of the Town of Hearst, which can be reached by phone at (705) 362-4341. The airport can be reached directly at (705) 372-2842. The airport is certified by Transport Canada.
The airport has a terminal building with telephone and taxi services available. Food, medical facilities, accomodation, and car rental are available within five nautical miles of the airport.
NOTAMs for this airport are available in the NOTAM file CYHF. Flight planning services are available through the London Flight Information Centre at (866) WXBRIEF.
Services are available from 9:00 am to 5:00 pm local time (1400-2200z, 1300-2100z during daylight savings time) Monday to Friday. At other times, a callout charge may be levied for one or more services. 100 low lead avgas and Jet-A fuel are available, as well as all grades of engine oil. Airplane storage, services and minor repairs, long-term parking, airplane tie-downs, and airplane plug-ins are also available. The airport offers supplementary de-icing fluid and 1000/1500 amp jet starting units.
The airport has one runway surface, serving as runways 04 (magnetic heading 41 degrees) and 22 (magnetic heading 221 degrees). The surface is 4500 feet long, 100 feet wide, and paved with asphalt. Runway condition reports are available from the operator, and there is only limited winter maintenance.
Both runways 04 and 22 have flashing strobes serving as runway identification lights, together with green/red threshold and runway end lights and three-position, medium intensity edge lights. There is also PAPI approach path lighting at each end of the runway designed for an eye-to-wheel height of up to 10 feet. The pilot must key the microphone seven times within five seconds on the frequency 122.8 MHz to activate the runway lights. The pilot may then select the brightness by keying the microphone seven times for maximum brightness, five times for medium brightness, or three times for minimum brightness, also within five seconds.
The unmonitored aerodrome traffic frequency is 122.8 MHz. It is in effect for a five nautical mile radius up to 3800 feet above sea level.
The nearest navigation aid is the Hearst NDB, on the frequency 241 KHz broadcasting the Morse code identifier “HF”. It is a medium-power (50-2000 watt) transmitter located at latitude 49 degrees 40 minutes 2 seconds north, longitude 83 degrees 43 minutes 28 seconds west. From the NDB, the airport is 2.8 nautical miles on a magnetic track of 38 degrees.
Right-hand circuits are in effect for runway 22, in accordance with the Canadian Aviation Regulations, section 602.96.
There is a possibility of winter maintenance equipment on the runway outside of operational hours. There is also a possibility of wildlife on the runway. There is bird activity during the months of April to October.
That is a lot of information packed into a tiny space (and I left out the information printed on the diagram, including the safe altitudes around the airport). There is a certain ugly beauty about it. Now, if only I could remember all of those abbreviations …