Editing

11. EDITING

11.1 Add New Record Before adding a new record, do a search on the c/n to ensure that the airframe is not already in the database under a previous registration. 11.2 Add New Operator Fill out as much information as possible. Note that the Operator is not necessarily the owner, which is often a leasing company for an airliner and which may sell the aircvraft on to another organisation while an airline is operating it. Often a company trades under a different name e.g. the G-INFO website notes for G-BXOK: ‘FB HELISERVICES LTD Trading as: DRAKEN EUROPE’. Enter the trading name as this will normally be better known. If in doubt, add a note in the ‘Op Note’ field.   Sometimes an individual person is recorded in a register (e.g. G-INFO website) as being a Trustee of a group of joint-owners e.g. “J.Smith t/o G-ABCD Group”. Enter the group/syndicate name i.e. “G-ABCD Group” if it is a significant/notable group, else ‘Private’. In this case, “t/o” means “Trustee Of”. For reasons of data protection, individual people should not be uniquely identified. Since about 2020, individuals have been noted as ‘Private’ and small, generally unknown companies as ‘Corporate’. Notable individuals may occasionally be noted with one initial e.g. J.Smith – these may be celebrities or major operators of aircraft fleets or of an airfield. Major, more well-known companies are noted with their full names. 11.3 Update Review

This lists your updates. After about 50 changes, say, send your updates to Steve Hambleton – choose Create Update, go to C:\DataAir where you will find a new update file such as 123ABoutupdate.mdb (123 = next update number, AB = your initials). – right click the filename and select Send to > – then Compressed (zipped) folder (this saves your update as a zipped file in C:\DataAir) – go to C:\DataAir – highlight 123ABoutupdate.zip – right click the filename and select Send to > – select Mail recipient – open your email program – send the filled-out email to Steve Hambleton at c17moose@googlemail.com 11.4 Duplicate Civil Regs This lists airframes with duplicated civil registrations with your input airframes highlighted. Identify how the duplicate arose and try to resolve it. It is often that a registration has been reissued after sale abroad and all that is needed is to update the ‘Use’ value e.g. for a second use set ‘Use’ to ‘2’. 11.5 Possible Duplicate Frames This lists airframes with potential duplicate registration or c/n. Identify how the duplicate could arise and try to resolve it. 11.6 Check DB for Orphans Lists historic records that are not associated to a current airframe. It is safe to delete them but it would be wise to check that the entry exists against the correct frame before doing so. 11.7 Duplicate Hex Codes If ‘Hex duplicates with my name on them’ shows a number, press Duplicate Hex Codes for a list to be resolved. Click the registration to go to the record for editing. Often caused by multiple use of test registrations by manufacturers or reissue of a registration by certain countries necessitating amending the ‘Use’ value.. 11.8 Cancelled without History Lists cancelled/stored airframes without histories – no registration is given. 11.9 Data Cleansing

• Defunct Ops (Operators) Any Defunct Operators that fall under your remit will be highlighted. Tread carefully though, as it’s not all straightforward. Some (a few) operators are showing as defunct because they have been entered incorrectly

12. EDITING – TIPS & POINTS TO NOTE

• 12.1 Tips

  

  Where this icon is shown, press it for more information on the feature. Tab One excellent feature to speed up editing is to use the Tab key to quickly move to the next required input field. Wherever you seem to be stuck, try tab. It will usually take you to the next step Hex Place the cursor in the Year field of the date and press Tab. Otherwise the cursor may not be at the start of the Hex field and you have to move it to left-align. Copy Down On certain tables Ctrl + ‘ is a useful shortcut to copy down the contents of the cell above it. Read the Notes on the ‘Edit Aircraft Details’ Screen Familiarise yourself with the notes given on thes main editing screen by hovering the cursor above titles and dropdown icons for any explanatory notes.

  12.2 Points to Note (for editing the ‘Edit Aircraft Details’ Screen)

• Is it a New Aircraft? Check a potentially new aircraft by searching firstly on its c/n and thus avoid creating duplications.
• Unlisted Model For types which are scarce and will be low priority for adding to the database as specific types, enter them as Unlisted Model – add c/n etc as fully as possible and put the Type name at the start of the Group Notes. That way, if you search Group Notes, just enter OK at the ‘Enter Parameter Value’ message box leaving the box empty, sort the resulting list by Type and scroll down for Unlisted Model, you can see which types are often occurring and therefore are worth requesting their addition as specific, significant types.
• Use This the number of times the registration has been used on a different airframe e.g. if ‘2’, it is the second airframe to carry that registration.
• Registration Date Note that this is the date that the current registration/owner/operator combination was registered. If the registration stays the same but the aircraft passes to a new owner/operator then it becomes the date it passed to the new owner/operator. NOTE: It is NOT the first date that the same registration was carried by a series of owners in continuous succession – it will change when the owner/operator changes. This ensures that loggings can reflect the correct owner/operator when seen. Please amend any records that do not adhere to this guidance. Country The country of registration, not the nationality of the owner/operator.
• TC Total Cycles (cycle = take-off & landing i.e. flights)
• TT Total Time (flight hours)
• Order & Sequence Numbers The Order and Sequence numbers against each Operator can be understood by examining the following example.

  Order	Sequence	Registration	Operator
  1	1	G-ABCD	Alpha Airways
  1	2	G-ABCD	Bravo Airlines
  1	3	G-ABCD	Alpha Airways
  2	1	N1234	Yankee Airlines
  2	2	N1234	American Falcon
  3	1	N67890	Capital Airways
  3	2	N67890	United Air
  4	1	G-ABCD	Alpha Airways
  4	2	G-ABCD	Bravo Airlines
  4	3	G-ABCD	Alpha Airways

  Note that the Order relates to the order in which each new registration is carried, and the Sequence relates to the sequence of each Operator for any registration or later re-use of a registration. Reregister Used where an aircraft is reregistered with a different registration. This is normally when it moves to a new country’s register or gains a new personalised registration. Operator Change Used when a new operator takes over but keeps the existing registration.
• Editing an Operator’s Details Note that you can only edit an operator’s details via the ‘View Operator’ button in this Editing screen – You cannot edit them by double-clicking an Operator on the ‘Aircraft Details’ screen. Cancel If cancelled by the CAA or equivalent, cancel and leave status as ‘Status Unsure’. If PWFU (Permanently Withdrawn From Use) add ‘ – PWFU’ after the ‘Cancelled from register’ filled-in text, change Status from ‘Status Unsure’ to ‘Withdrawn’ and Final Fate from ‘Fate unknown’ to ‘Withdrawn’. Subsequent Restoration If a ‘cancelled by issuing authority’ record subsequently gets updated with a registration restoration (Reregister), the cancelled record doesn’t then appear in the history table. You should not record a cancellation in the operator history. That is just for recording the operators, squadron changes, variant changes etc. not status like ‘cancelled’. The difference in the ‘from’ and ‘to’ dates would indicate if there was a gap between cancellation and reregistration. If you really think it is important to record that a frame had been cancelled at some stage then you could make a note at the end of the history line for the last operator e.g. “Cancelled by CAA 10-12-22” or in the Group Notes. As for the final fate, it means that and it should not be present on an active frame. Now there is the ability to record accidents there is no need to have a final fate on an active record. Consequently it should be deleted. Write Off (W/O, w/o) Refers to an aircraft that has been destroyed or is beyond economic repair. There will be two dates associated with this – the date of the accident and the date that the Country Authority (e.g. the CAA) actually formally records the deregistration of the aircraft. These can be months, even years, apart. The accident date is used with the w/o details. The cancellation date can usefully be noted as a Group Note. If the accident date is not known, add a note that the date given is the cancellation date. Not Taken Up (NTU) NTU registrations are omitted from the database. Manufacturer / Initial Operator When new GA frames are entered into the database and the operator is set to the manufacturer, unless the registration changes, the aircraft appears to belong to the manufacturer for the rest of its life. This is clearly not the case and when it is delivered to the customer it will become ‘Private’, or in the case of larger types ‘Corporate’. Therefore, all new GA entries should be entered as Private (or Corporate) from the start. This will include Cessnas, Pipers, Beechcrafts, Mooneys, Cirrus, etc, etc Owner or Trading Name Where aircraft are registered to an owner who trades under a different name, the trading name should be used as the operator e.g. UK Flying Clubs Ltd who trade as Blackbushe Flying Group. The trading name is likely to be more widely known than that of the actual owner. Bases Check that when selecting a base that you have the correct country as many airfields have the same primary name e.g. Aberdeen, Perth. Accidents Add accident information in the ACCIDENTS box. If badly damaged, change status to ‘Status Unsure’. UPD Flag This is a system-supplied flag which indicates if that part of the record has changed. (It is a different table to the main detail.) N = New, A = Unchanged, U = Updated