Category: Flying

So how’d I do? (Aviation edition)

For 2006 I set myself a few goals for my flying. If I recall correctly, it was

  • Fly 50 hours this year.
  • Do some airwork and get more proficient at smooth flight, especially the use of the rudder.
  • Start work towards a Commercial or Float Plane rating.

Well, it didn’t quite work out that way. I only got 37.9 hours flying time (25.3 complex), although I would have been 5 or so hours closer to my goal if the Lance hadn’t been broken on the day we departed for Oshkosh, and maybe another 3 hours if we’d been able to fly to Albany on Thanksgiving weekend. Oh well. That’s still up for the 20-25 hours I normally put in a year. I also didn’t do much airwork, mostly cross country. So I still finding myself having to look at the ball and putting in rudder as an afterthought rather than feeling what needs be put in. However, I did get training in the Garmin 530, and I think I’m getting more precise in my approaches and IFR en-route flying. I also had a little adventure with ice avoidance and negotiating with ATC for what I needed on my way home from Pinckneyville. So while I didn’t meet my goals, I think I had a pretty satisfying flying year.

I’m not sure if I’m going to get to Oshkosh this year – this is our 10th anniversary and I think I’m going to be spending my vacation time on a cruise or something. So I probably won’t be heading down to Florida for Jack Brown’s Seaplane Base or up to Parry Sound for Georgian Bay Airways for a float rating either.

So my goals for this year remain

  • Become a more proficient yoke and rudder pilot.
  • Continue to fly more than I have been in the past.

Finally, something worked right!

The last thing I’m going to be moving from my linode VPS to my colo box is my Navaid.com waypoint generators. I’ve started doing some work on that – originally I was going to export the MySQL database from the linode, and massage them and import them into PostgreSQL on the colo box. But when I first started doing that, I found no end of trouble – the version of MySQL in Debian Sarge doesn’t have the “compatibility” mode in the dump command, plus I discovered that when I’d originally moved from PostgreSQL to MySQL I’d converted all the boolean fields to tinyint(1) or something, and I’d like to change that. Plus there were fields that were set to “not null default 0” which should really have allowed nulls and the like. Basic clean-up stuff, but time consuming. So I’d decided to bring the database over as MySQL, and maybe bring up the site in MySQL and write a conversion script later on so I could convert to PostgreSQL later.

Thursday evening while experimenting with some of the scripts navaid scripts on the colo site, I discovered some bad values. Investigation proved that the FAA had changed the data format for the “APT” airport record in the last load, and I hadn’t adapted my load script.

So Friday evening I went back to the “real” navaid site and fixed the load script, and ran the two scripts to reload the data. I started the run about 8pm. But it was going *really* slow. So while I was waiting, I copied the changes over to the same scripts on the colo site and ran them there. The two scripts took less than a hour to run, which pleased me immensely, and I was able to verify on that site that the damage was fixed. But the scripts on the real site were still running. I waited and finally went to bed. When I got up this morning, the first script was still running. As a matter of fact, it finally finished and went on to the second script at about 2pm. It’s slowly grinding through the second one.

But I didn’t want my “real” site to be down for this length of time. So I hit on an idea – I enabled remote connections to the MySQL database on my colo box, and made a test version of the generation script on the real site with a slightly different “DBI->connect” line as the only change. And it worked, and it worked amazingly quickly. So I changed the whole site over, and restarted Apache, and so now the web services are running on the “real” site, but the database they are hitting is on the colo box. This will make the ultimate migration easier, and it means that navaid.com’s users are already getting a bit of a speed advantage from this move.

The only hitch, and it’s a small one, is there is a script that runs once a night to expire old saved sessions. It uses subqueries, which the MySQL on my colo box doesn’t support. I’m going to have to re-write that as a script that uses a left inner join to find the ones to delete, and then deletes them one at a time. The reason why this worked on my VPS box and not on my colo box is that on the VPS, I’m connecting to a MySQL server provided by the ISP, not my own. So while Debian Sarge installs MySQL 4.0.24, the server I’m connecting to is newer than that.

Now I’ve *really* had it with this guy.

Back in June, I wrote about how the Maintenance Coordinator for the club’s Lance is downright secretive. Today, Vicki, Laura and I went confidently out to the airport for a flight we’d scheduled last week, taking the Lance out to Albany to spend Thanksgiving at Stevie’s new apartment. We loaded our luggage in the luggage compartment, and Vicki and Laura went back into the FBO while I preflighted. I open the front door and sit down, and there is a sign taped to the yoke saying the plane is grounded. Oh oh. I do a quick walk around and discover that the wingtip appears to have been scraped by somebody or something, and it’s taken off the navlight/strobe fixture, the guts of which are held in place by scotch tape.

Ok, now I’m mad, because when the plane is grounded, the Maintanance Coordinator is supposed to mark the plane as grounded in ScheduleMaster, our on-line scheduling system so that people don’t expect that they’re going to be able to use it for a trip and don’t find out until they get to the airport that there is a known problem with it.

I head back to the ops room to check ScheduleMaster to see if any of the other planes are available. That’s when I discover something that made me 300% madder still – the squawk list shows that this wing navlight/strobe was squawked on 10/8, over 6 weeks ago! The squawk says that the person reporting it immediately called the Maintenance Coordinator. But the Maintenance Coordinator has let this plane sit there grounded for 6 fucking weeks without letting anybody know!

I called the VP of Maintenance, and he didn’t know either. He says that when it happened, Bill, the Maintenance Coordinator, said he would get it fixed that very week, and he’d assumed Bill had done that. I told him that this is totally unacceptable, and either he removes Bill as Maintenance Coordinator, or I’m going to join Artisan club instead. He asked me if I wanted to “move up” to Maintenance Coordinator, and I said sure.

Meanwhile, none of the other club planes are booked for a long trip, just for a few hours here and there. I call the guy who has the Dakota booked for Friday morning when we are planning to return, and he says he is booked to have some instruction in it so he can’t easily reschedule. One of the Archers is free except that somebody has it right now and isn’t due to return for a few hours. So the choice is to wait three hours and then fly, or drive now. Both options won’t get us there until after dark. So we elect to drive.

I think it’s time to check out the costs at Artisan. I know they’re a smaller, more expensive club and I don’t like their fleet balance quite as much (other than a Lance, they’ve got a couple of Arrows and a Warrior, and an Arrow doesn’t haul anywhere near what a Dakota does), but they actually put money into their Lance (including a Garmin 530) and it gets flown.

AOPA Online – Enough is enough

Phil Boyer, president of the Aircraft Owners and Pilots Association (AOPA) has a great response to the latest fear-mongering over the Liddle crash. It’s addressed mostly at Mayor Dailey in Chicago, but also takes swipes at other General Aviation (GA) bashers like Hillary Clinton.

AOPA Online – Enough is enough

You know, for a Republican, New York’s Mayor Bloomberg is a pretty good guy. And he’s also a pilot with more ratings and experience than me. When he says that GA is not a threat to his city, why can’t other people, especially New York Senators and Congresscritters listen to him?

Leaf Peeping Flight

One of the things that Vicki and I have never done is go up and look at the fall colours from the air. Today was a wonderful day, severe clear and not very windy. The leaves aren’t at their peak yet, but we’re there, the plane is there, and we don’t have anything else to do. So when we got back from Buttonville and cleared customs, we headed off again.

I wanted to stay low to get a better view, unlike the flight across the lake, where we kept very high for a smoother ride and better glide distance while over the lake. That made it a bit bumpy. But not unbearably so.

We left Rochester airspace going south at 2500 feet. As soon as we got out of the airspace, I punched my user waypoint for the local wind farm into my GPS, and we headed out to look at the windmills. Not only are the windmills scenic themselves, but they’re near a nice valley. That was good. Then I headed towards Letchworth Canyon and cruised along it down to the famous Upper and Lower Falls and railway trestle.

After that, we cruised back up the canyon in the other direction. Then Vicki had a nifty idea – to go fly over our house. The Rochester airport hadn’t been too busy when we’d come in – they’d cleared me to land while I was still 15 miles out. So I figured what the hell, I’ll ask for it.

First thing is to try to find something that the controller would recognize. I zoomed in the hand-held GPS to try to find a waypoint near our house – I had an idea that we were near the outer marker for the ILS 28 approach. But I couldn’t find anything. So I told him that we weren’t too far south of the southern tip of the Irondequoit Bay – I figured they’d know where where that is because of the seaplane operations there. The controller approved our request, so I descended to pattern altitude, because I knew it would put us below where the airplanes on ILS 28 would be at that point. Vicki spotted our house, and I did a steep turn around it so we could get a good view. After our turn, I thanked Rochester Approach and they cleared me for a straight in to runway 25.

That was really nice. I hope we can do that again some time.