Worksheet 2017-09-11T03:59:28+00:00

Info and Concepts

Worksheets are the CASA approved forms that your maintenance organisation uses to certify for carrying out maintenance tasks on an aircraft.

The list of tasks that will make up the job comes from the aircraft schedule and draws on the Inspections, Airworthiness Directives , Service Bulletins  and Lifed Components.

The list is created by filtering all the items and selecting those that fall within the filter limits that have been entered.

Once the items have been selected the user can print a workpack containing the tasks and the maintenance can be carried out and certified. As well as the worksheets the Category Coordination and Engineering Work Package cover sheet can be produced from this section. The user can also produce blank worksheets to be included in the workpack for any additional work to be written up during the course of maintenance.


The “Worksheet” tab panel in the maintenance scheduling section of Aerotrack


  1. Ensure that the aircraft hours and related counts such as landings and cycles are up to date, use the “Update this Aircraft” function if a further update is required.
  2. Raise a job number for the maintenance to be carried out, see the “Creating a Job” section of this manual.
  3. From within the Schedule ensure that the current job number is selected in the “Airframe Details” area.Screen Shot 2016-02-22 at 12.25.23 PMCurrentjobScreen Shot 2016-02-22 at 12.25.23 PM
  4. In the “Worksheet” tab panel enter the criteria for your workpack into the “Filters” area. Aerotrack will use these figures to assist in the creation of the work package by selecting all items that fall within the criteria. e.g.: The user enters 100 hours and 180 days. When the “Find & Check Due Items” button is clicked Aerotrack checks all maintenance items that fall due within this period.Screen Shot 2016-02-22 at 12.25.23 PMScreen Shot 2016-02-21 at 10.32.37 AMScreen Shot 2016-02-22 at 12.25.23 PM
  5. Click the “Find & Check Due Items” button. Aerotrack will search for maintenance items that fall within the figures you have entered and check the “Include” box for that line item. A dialog window informing you how many of each type have been found and checked will be displayed.Screen Shot 2016-02-22 at 12.25.23 PMScreen Shot 2016-02-21 at 10.55.52 AMScreen Shot 2016-02-22 at 12.25.23 PM
  6. All the items ticked in the panel will be included in the workpack under the job number showing as the current job.
  7. Click the “Show Lifed Components” button to show the lifespan components that have been found and checked. This button toggles the display between the inspections and the lifespan components.
  8. Any additional items can be added to the workpack by checking the “Include” box. This may be done because although an inspection may not be due it may be convenient to carry it out now as the area of the aircraft will be disassembled.
  9. Allocate each inspection a task number by either typing directly into the “Task #” column or by clicking the Build Task from Defaults button. The workpack will be printed in the task number order.Screen Shot 2016-02-22 at 12.25.23 PMChecked InspectionsScreen Shot 2016-02-22 at 12.25.23 PMWhen allocating task numbers ensure that all single digits are entered in as “01” and not “1”, this will ensure the work pack is sorted correctly. If the number of tasks goes above 100 all double digit tasks should be entered with a leading zero and single digit tasks with two leading zeros.
  10. Print the Worksheet list by selecting the worksheet print type from the drop down list and click the printer icon beside it. A categorised worksheet will print each category of AD’s and inspections per page. This is useful if you have specialist tradesman for each category. See the list at the bottom of this page for examples of the worksheets available.
  11. Use the Additional Functions outlined below to create the Log Book Entry, create the Task List in the job and to create the Maintenance Release Attachment as required.
  12. When the maintenance job has been carried out a user with the correct permissions can run the Complete Checked Items procedure.
  13. It is important to note that the user should ensure that each item ticked has been completed and that the task can be marked as completed and be rescheduled for the next due date or time.
  14. Click the “Complete Checked Items” button, the following window will be displayed.Screen Shot 2016-02-22 at 12.25.23 PMScreen Shot 2016-02-21 at 4.34.28 PMScreen Shot 2016-02-22 at 12.25.23 PM
  15. This window shows the usage figures of the aircraft as it currently is recorded. If these are not the details that are to be used for the completion of these tasks the user can modify them here before proceeding further.
  16. The “Get Details per AF Date” button can be used to retrieve usage figures from a previous date. Click the button to select a date from the calendar. If a record for the chosen date exists in the database it will be retrieved and used. If there is not an exact match for the date selected you must manually enter the figures.
  17. The second tab named “Included Maintenance Items” displays the exact inspections that are going to be updated by this process. Components that have been changed are not updated by this feature and must be transferred from the Component Store or created directly on the aircraft.
  18. Once the user has checked the inspections to be updated and the usage details are correct the “Complete Worksheet” button can be clicked. There is no “Undo” function for completing a worksheet so we advise caution when using this feature.

Worksheet Functions

  • Screen Shot 2016-02-21 at 12.37.40 PMFind & Check Due Items – this button uses the data entered in the filters and checks all maintenance items that fall due within the parameters specified.
  • Show All Items – this button is used to show every maintenance in the panel after the Show Only Checked Items button has been used.
  • Show Only Checked Items – this will remove all the unchecked items from the panel for usability purposes.
  • Uncheck Items – this will remove all checks from all items.
  • Complete Checked Items – this button must only be used when the maintenance has been carried out and certified. It will update all the maintenance items with the hours and calendar times to show that have been completed. There is a special security setting which must be checked for each user to have access to this function.

Additional Functions

  • Screen Shot 2016-02-21 at 12.37.49 PMBuild Log Book Entry – this button will create a log book  entry in the current job and transfer all of the Inspections, Airworthiness Directives and Service Bulletins sorted by task number.
  • Build Task from Defaults – this button takes the “Default Task Code” from each individual inspection and populates the task number field.
  • Build Tasks in the Current Job # – takes each task and transfers them to the job. They will now display from within the Job screen under the Task List tab panel.
  • Clear Listed Task Codes – removes all task numbers from the fields.
  • Build M/R Attachment – this will send the checked items to the MR Info tab panel within the job screen.



Task numbering is very important as it is this field that will be used to sort the workpack as well as the logbook entry. When engineering staff are entering their time cards they also use this task number to allocate their labour to a job. This in turn flows through to the engineering logbook with the task number and a description of the task carried out.

When sending tasks to the jobs it should be noted that only maintenance items with task codes will be transferred to the job.

The colour coding of the maintenance items indicate the status of the tasks in the Job screen.

  • When the item is first selected and the worksheet is saved the colour bar will show in orange.Screen Shot 2016-02-21 at 6.02.43 PM


  • When a task number has been allocated and the tasks have been sent to the job the colour bar will display in green.Screen Shot 2016-02-21 at 6.05.03 PM


  • If the colour bar is displayed in red the task exists on the job with different task number.Screen Shot 2016-02-21 at 6.09.04 PM