Hi, I’m dawn from dawn drones on, as many of you know, I’ve created a simple Excel spreadsheet called the Canadian drone pilot logbook. There’S a link to this logbook in the description below the video. What the drone pilot logbook is is a simple way for drone fliers to meet all of the well, let’s say procedural requirements of the 2019 Canadian ARP as regulations. Things like checklists having your drone registration number and pilot certification, number handy and keeping maintenance logs things like that. I’Ve had a number of people.

Ask me questions about the logbook, so what I’ve done is put together. This short video to show, what’s in the logbook, how to use it and how to customize it to your own needs, let’s dive in alright. So here’s the the Canadian drone pilot logbook, I’m going to assume that you’re fairly familiar with Microsoft, Excel spreadsheets, but just as a you know, in case you are a complete novice. A spreadsheet is essentially a piece of software that has rows and columns in it. They, the columns, have letters at the top, ABC and so forth, and the rows have have numbers and you can type things in the various cells.

The things in the at the intersections of the rows and columns are called cells. You can type stuff in there and you can do all sorts of fancy stuff, of course, but for this purpose it’s it’s really just text. There’S nothing else in there. There’S no macros, there’s no, adding and subtracting anything like that, all of which you can do with a spreadsheet, but a spreadsheet is a handy way to keep things neatly organized as well, and that’s why I chose this platform for doing this. The other thing about a spreadsheet is that you can have different tabs.

The tabs are these things along the bottom here and it allows you basically to have multiple spreadsheets all in one neat package, so you can see, as you click on the tabs, you can navigate your way from one piece of information to another, so the first tab That I have here is called the instructions – I guess what’s in there and instructions, much like I’m going to talk to you in this video, but it is there as a reminder. So the let’s walk through some of these tabs, I’m not going to go through. All of them, but I’ll I’ll, walk through the key ones. The i-10 identification tab is intended as a place where you can keep all of your personal pilot information and aircraft information all in one spot. So your name and address phone number, email, kind of stuff, information about your certification level, there’s three levels of certification, basic operations and advanced operations and flight reviewers.

I thought well hey. Why not have flight reviewer in here as well? So you can put your exam past day your certificate, the date your certificate was issued. The certificate number you’re expected to have this at hand. At any point, if you were to be accosted, you can show them that you have a certificate, and that would be your.

The number the date of your flight review, which isn’t applicable for basic ops, but it is for advanced ops and for the flight, reviewer and also recency of activities. This would be things like additional training that you’ve taken and things things of that nature. Transport. Canada hasn’t been very specific about what they consider recency activity, but I gave you a few rows here to keep track of at least training and similarly, your aircraft information – you would keep down here in terms of the model and description like a DJI Mavic tube pro For example, I do this column here: called aircraft is intended to be just a shorthand, so if you wanted just to have in the aircraft log or the flight log, you just didn’t want to say Mavic to pro all the time you could just type in avoc. Mavic here, and that would be short for your Mavic to pro, and you would put your registration number here – the number that you would stick on your drone purchase data.

If it is approved for ops, you can indicate that here and you can have a URL link to your operating manual, and you can stick that in this all over here now. If this isn’t a regulatory requirement, but I also put a place in here for emergency contact numbers so that well nine on one you’re suppose I thought that would be a good one to have in here. The general aviation emergency number, the one eight seven seven number. This is a number that you’re intended to use if there is literally, this is the the words in the car if there is an imminent and immediate threat to aviation and Public Safety. So if your drones on a fly away – and you don’t know who else to call call these guys – I also left some room, of course, for additional numbers.

You know if you’re always flying in the same area, for example, you might want to put the numbers of the local airports that you are anywhere near. You might want to put the fire department in there or that or something like that. Well, I guess that’d be covered by 911, but any other emergency numbers that even remotely you might need this. It might be a handy place to keep them okay. So this is the the pilot and identification aircraft identification tab the night.

The next tab is actually the the key tab, and that is your flight log, so this is would be where you keep the attract track all of your flights, so the date the aircraft. This is where you would just type Mavic the location where you’re flying additional crew that you have onboard like a visual observer, for example, the flight time. I think keeping it in minutes is sufficient. This is what manned aircraft do. I would round it up to the closest the next minute, the number of flights.

If you, if, on a particular day, you did three flights or something like five slides of flights in the same area, then it would be sensible just to put one one record here with the number of flights, and you can put a comment here about any incidence Or something that happened during your flight that you might want to record alright. So the idea is you, you literally just type it in so April. Whatever it is today, 15, the aircraft would be the abbreviation that I put on the other side location. You probably want to put exactly where you are, but I mean my my location where I normally fly is near Tamworth additional flight crew – I maybe I didn’t have any flight time. You would record this afterwards say two minutes and it was one flight and saw a bear whatever.

Okay – and you would just type this in or by the way these things are designed, so that they can be easily printed off and you can keep a paper log without is more your style and that’s more convenient for you. You can do that. One of the other things that you’re required to log is any maintenance activity that you take on your aircraft. Things like you know, if your, if your perhaps your prop broke, then you could indicate that you replace the prop. You could indicate the supplier and part number of that prop and if there were any instructions that need to needed to be followed to do that, you could list them off here and have any comments again.

This is a regulatory requirement to keep a log of all of your. Your maintenance activities on your aircraft. I’D say: propeller changing is the lowest level of maintenance. You’D probably ever be expected to track. You know if you brushed dust off of one of the arms, I don’t think that counts.

If you have to take your drone in to have the gimbal repaired on the camera, I would say that that certainly counts or if a motor needed to be replaced, or something like that. This is where you would track that kind of information, and if there was, if you’re, flying a drone, that’s on the advanced operations permitted list, the manufacturer of those drones are expected to keep track of the there. The customers like you, and if there are any mandatory instructions, such as you, must put upload to this firmware layer level by you know January the third. You could indicate that you did upgrade your firmware on January, the first or something, and by the way I would put firmware upgrades on here as well. If you can, I think that’s a particularly important one to keep track of the next few.

Our next two tabs on here are checklists. Both of them are preflight check lists. The first one is for basic operations. The other one is for advanced operations, I’m not going to go through the whole thing, but essentially the format here is. I have a checklist.

You have there’s a little spot over here where you can put a little X or whatever you choose to put in that mark, to indicate to indicate that you’ve gone through the checklist at the beginning of each operation of this using the checklist, you would just clear All of the things out of those boxes so that you could start new and freshmen all right, so there’s a advanced operations. One you’re also required to have procedures for how to take off how to land and an emergency procedures. So this is an example of the takeoff and launch procedure. It’S fairly simple and and of course it would depend a lot on what kind of drone you’re flying to determine exactly what sorts of steps might make sense. So, for example, activating the drone control unit and display unit if the display unit is built into the control unit.

Obviously you don’t have to activate two separate things and again I’ll show you how to update these things in a minute. So, there’s a landing procedure: emergency procedures again fairly generic. You know because, given that it’s an emergency, it’s kind of hard to predict in advance what is appropriate to to take care of, but I have put in all of the examples that they used in the Transport Canada used in their regulations and as reminders. I’Ve put in the key rules for basic operations and advanced operations, as well as the definition notes of SFO seas or situations where you need an SF. Osi has reminders – and these are things that are directly in my videos – that you might recognize, and I’ve just put them in this sort of checklist II kind of format, because I think that’s quite a handy way to do it all right.

So that’s! What’S in the logbook, so the next thing is: how would you use it? I kind of indicated here in the flight log what you would do you would type in the the flight says you were using them you would. You would maintain your information about maintenance activities by typing into the fields here on the checklist, as I said, you’d put I’ll, say an X as you’re going through and noting each of these items and at the end of your or at the beginning of a new Flight, you would simply select all of those fields and if you right-click on the mouse, you can clear the contents all right so fairly simple to do that. So that’s the same sort of thing that you would do on all of these checklists.

If you wanted, and and again, if you were to print these off, all you need to do is have a little pencil and you just put a tick mark in each of these checklist locations, and you can maintain these these checklists. As long as you wish, the main ones that you want to keep for an extended period of time are the flight logs and the maintenance logs. Those are regulatory requirements to keep those and I’m sorry I can’t remember at this incident, but it’s I think it’s two years for each of those one of them might be only one year, all right. So that’s how to use these these various tabs. The last thing is: how do I change them?

So, let’s, let’s take one of these things and customize it for my particular use. So let’s look at the pre-flight checklist. I’Ve got a thing here about being away from airports and not in controlled airspace, but suppose you’re flying in a known, UFO sighting zone. And you don’t want to be flying when there’s UFOs in the air. I’M sorry for the ludicrous example, but just as an example of something you might want to add in all you do.

Is you right-click on the row here over here and so I’m right-clicking? You hit the word insert and a new row materializes in here, and you just type in whatever you want in your check list so check for you have posed in visual range and that’s that’s all you’d have to do. You can type as much or as little as you think, is appropriate and then just renumber these things, like literally putting a 3 here and a four and a five and a six and just renumber them if it makes sense. And similarly, you can delete something that makes no sense to you, for example, while all of these make sense to me, but maybe if there is a check for UFOs in your visual range – and you don’t like that anymore again, you you select the row by clicking It in the on the the row number over here and hit the right-hand right mouse button and delete, and it’s gone all right fairly simple to do that. Similarly, you can, if you want to change the text in here, so it says: check NAV, CANADA, not m.

Our note am site, maybe you want to put the exact URL for that right into this checkbox here. So all you do, is you select that spot? You double click and your cursor is flashing and you can type the HTTP colon slash, slash or whatever it is into that into that cell and up here by the way you can also see – and you can edit up in the in this top bar up here And if you like, what you want, you hit check box check mark. If you don’t like it, you hit the X and it takes it away again, alright and when you’re done making it any edits, like that, sorry, I’ve zoomed in a little bit, but up in the top there there’s a Save button and you can save the file As whatever you want to call it, you know your your own check list, file or whatever all right so there’s an overview of the Canadian drone pilot logbook. What’S in it, how to use it and how to customize it.

Thank you very much for watching. If you would like to purchase a soft copy of the Canadian drone pilot logbook, please follow the link in the description below. Thank you for your support. I hope you found this video useful, please like and comment below the video and, if you haven’t already done so, please subscribe to my channel thanks again for watching.