Wikiposts
Search
Engineers & Technicians In this day and age of increased CRM and safety awareness, a forum for the guys and girls who keep our a/c serviceable.

Headaches with records?

Thread Tools
 
Search this Thread
 
Old 25th Jan 2006, 12:38
  #1 (permalink)  
Thread Starter
 
Join Date: Mar 2003
Location: Brighton
Posts: 210
Likes: 0
Received 0 Likes on 0 Posts
Headaches with records?

Hello there

Before I thought about this I had a look at some posts from the database so mods please let me know if I'm stepping over the line here...

We have developed a system to manage aircraft records - thats everything from delivery docs from the manufactuer to the maintenance history and tech logs. Our system is pretty nifty and already we have scanned 50 entire aircraft back to birth for customers all over the world.

What we have allows you to type in a component serial number and search for any item containing that number - so in seconds you could get the Form One for example and print it or email it.

I'm wondering how you guys in the tech records areas manage this at the moment? Do you scan already and is it in PDF format or microfilm?

Are you aware of any similar systems that do this at all?

Cheers
Irishwingz is offline  
Old 26th Jan 2006, 14:06
  #2 (permalink)  
 
Join Date: Jan 2006
Location: Durkadurkastan
Posts: 91
Likes: 0
Received 0 Likes on 0 Posts
The RAF use a network called the Logistic Information Technology System, otherwise known as LITS (or Lost In Time and Space) for ac engineering and asset management. It's not quite up to scanning documents but (aircrew: commence uncontrollable laughter) it is quite good at locating items by component number and calculating rolled-up remaining life on significant components or assemblies, including entire ac. It's based on a Sth African Defence Force system called OSIS and coded by a bunch of geekoids at IBM UK in Stevenage.

Sounds like you might have one over us there. How long did it take to do 50 ac?
4Foxtrot is offline  
Old 26th Jan 2006, 17:06
  #3 (permalink)  
Thread Starter
 
Join Date: Mar 2003
Location: Brighton
Posts: 210
Likes: 0
Received 0 Likes on 0 Posts
Hi Fox

We can scan, index and deliver a searchable DVD just about onsite. A 2 person team can get through between 6000-8000 records per day. Thats about a years worth of typical narrowbody records. Its a bit quicker if its done at our office.

As an example a 5 year old A320/B737 would take us 5 days.

I'll PM you more info...

Cheers
Irishwingz is offline  
Old 26th Jan 2006, 19:26
  #4 (permalink)  
 
Join Date: Feb 2002
Location: UK
Age: 59
Posts: 3,549
Received 239 Likes on 133 Posts
Oh please! Talk to BA. Their new system is just fab!

It's called EWS (Engineering Without Spares or Enormous Waste System) It's very cheap, only about £3M spent on it so far in the last 5 years and it still doesn't work!

So if you think you can come on here and tell us all that you have a system that actually works........

Nurse!

I'm going to my happy place now....wibble!
TURIN is offline  
Old 27th Jan 2006, 06:43
  #5 (permalink)  
 
Join Date: May 2004
Location: Balmullo,Scotland
Posts: 933
Likes: 0
Received 0 Likes on 0 Posts
Originally Posted by Irishwingz
Hello there
Before I thought about this I had a look at some posts from the database so mods please let me know if I'm stepping over the line here...
We have developed a system to manage aircraft records - thats everything from delivery docs from the manufactuer to the maintenance history and tech logs. Our system is pretty nifty and already we have scanned 50 entire aircraft back to birth for customers all over the world.
What we have allows you to type in a component serial number and search for any item containing that number - so in seconds you could get the Form One for example and print it or email it.
I'm wondering how you guys in the tech records areas manage this at the moment? Do you scan already and is it in PDF format or microfilm?
Are you aware of any similar systems that do this at all?
Cheers
There are several such systems around and wonder why Yours is diffrent? generally speaking They are scanned into PDF format PM Me details of Your system
matkat is offline  
Old 27th Jan 2006, 09:18
  #6 (permalink)  
 
Join Date: Jan 2006
Location: Durkadurkastan
Posts: 91
Likes: 0
Received 0 Likes on 0 Posts
I'm not saying that ours actually works but you can sleep easy at night that you've only spent £3m on it.
4Foxtrot is offline  
Old 27th Jan 2006, 10:27
  #7 (permalink)  
 
Join Date: Feb 2002
Location: UK
Age: 59
Posts: 3,549
Received 239 Likes on 133 Posts
Sorry, I meant to say £300,000,000.

TURIN is offline  
Old 27th Jan 2006, 10:48
  #8 (permalink)  
 
Join Date: Jan 2006
Location: Durkadurkastan
Posts: 91
Likes: 0
Received 0 Likes on 0 Posts
£300,000,000!

And here's me worried about wasting taxpayers money. I guess £300m on a duff EAM system goes some way to explaining BA's pension deficit or have I opened up a can of worms? Perhaps not the right forum...
4Foxtrot is offline  
Old 27th Jan 2006, 13:35
  #9 (permalink)  
 
Join Date: Mar 2005
Location: England
Posts: 730
Likes: 0
Received 0 Likes on 0 Posts
Where did you get £300m from Turin? Last rumour I heard was that it was approaching £100m and that was only a few months ago.
Still appalling though

Last edited by Fargoo; 27th Jan 2006 at 16:25.
Fargoo is offline  
Old 28th Jan 2006, 10:54
  #10 (permalink)  
 
Join Date: Jan 2006
Location: LGW
Posts: 3
Likes: 0
Received 0 Likes on 0 Posts
£300,000,000

£70,000,000 initial budget
had to go back to the board and ask for another £150,000,000 to finish the job
plus about £20,000,000 extra over the last 5 years

and it still take 20 A4 pages of paper 20 minutes hunting for the part on the system to get the parts

"but will save the company millions over the long term "
aviation nut is offline  
Old 30th Jan 2006, 10:54
  #11 (permalink)  
 
Join Date: Dec 2005
Location: OVER THE RAINBOW
Age: 74
Posts: 117
Likes: 0
Received 0 Likes on 0 Posts
Scanning the records is great, but has any body checked that whats within them is correct. We have bought aircraft from reputable companies, did a physical check of rotable components s/n and found something else fitted. Its human nature, we find mistakes we made too, so I am not going to throw stones in the glasshouse. The day you trust everything the computer tells you, is the day you are looking for trouble. Sampling checks are a good way to go.
We use IAS system and works great for us (stores is linked to aircraft status, linked to accounts, linked to defects etc) now if it could only make a decent coffee, I'd be happy.
whiskeyflyer is offline  
Old 2nd Feb 2006, 11:36
  #12 (permalink)  
 
Join Date: Feb 2001
Location: Left Field
Posts: 25
Likes: 0
Received 0 Likes on 0 Posts
Originally Posted by whiskeyflyer
We use IAS system and works great for us (stores is linked to aircraft status, linked to accounts, linked to defects etc) now if it could only make a decent coffee, I'd be happy.
Get the ODBC drivers, still won't make a cup of coffee but will give you time to drink it. Maintenance, stores, work orders, reliability, logs, ops, accounts & undocumented features
TT
TeamTerminal is offline  
Old 2nd Feb 2006, 11:58
  #13 (permalink)  
 
Join Date: Dec 2005
Location: OVER THE RAINBOW
Age: 74
Posts: 117
Likes: 0
Received 0 Likes on 0 Posts
would you believe I just got the quote to buy ODBC, last week. Not that expensive for what it does
whiskeyflyer is offline  
Old 2nd Feb 2006, 12:24
  #14 (permalink)  
 
Join Date: Feb 2001
Location: Left Field
Posts: 25
Likes: 0
Received 0 Likes on 0 Posts
They are far less problematic than IQ, but not as quick. A bit daunting for some users to set up, but worth the asking.
Tip #1 When you work out where all the data is, only bring in the data you want. Don't try to bring everything in at once.
TT
TeamTerminal is offline  
Old 14th Feb 2006, 04:28
  #15 (permalink)  
Cunning Artificer
 
Join Date: Jun 2001
Location: The spiritual home of DeHavilland
Age: 76
Posts: 3,127
Likes: 0
Received 0 Likes on 0 Posts
We've been looking at many of these systems but none of them do precisely what our customers demand.

The root of the problem is getting the original paper into the system. Every system we've looked at uses more labour than an old fashioned 'Cardex' system, which surely defeats a major part of the objective.
Blacksheep is offline  
Old 16th Feb 2006, 11:27
  #16 (permalink)  
 
Join Date: Dec 2005
Location: OVER THE RAINBOW
Age: 74
Posts: 117
Likes: 0
Received 0 Likes on 0 Posts
Originally Posted by Blacksheep
We've been looking at many of these systems but none of them do precisely what our customers demand.
The root of the problem is getting the original paper into the system. Every system we've looked at uses more labour than an old fashioned 'Cardex' system, which surely defeats a major part of the objective.
The problem may lie in the specification issued to the system supplier. The spec must be accurate and detailed, then anything is possible (I am in aviation, but friends of mine in the computer industry) The main problems arise due to inaccurate specs, wrong person writing the spec (actually should be all involved and not just the head accountant or chief engineer) and most impoartntly do not change the spec once the programming has started, otherwise you looking for problems. Preferrably purchases an off the shelf programnme. I have been involved in the commissioning of two systems into operators.
Everthing was redone including procedures. Procedures where written around the system bought off the shelf and everybody trained in those procedures. You will never get a system that matches your current procedures, which built up over time based on old systems. I would never go back to cardex (we run a fleet with half the staff of old).
Setting up everything takes times (and accurancy, such as do you use dashes in P/Ns, same format for all ADs on system) but once up and running its a joy to use. And once RFT are common on parts, life will even be easier
whiskeyflyer is offline  
Old 16th Feb 2006, 15:12
  #17 (permalink)  
Thread Starter
 
Join Date: Mar 2003
Location: Brighton
Posts: 210
Likes: 0
Received 0 Likes on 0 Posts
Getting existing info into the system

We handle this by scanning the feed from the legacy/currrent system and use a zonal OCR programme to 'find' whats required from each page and feed this into an excel file or whatever for easy upload to your new system.

Zonal OCR (Optical Character Recognition) is when you define what field/s on the page you want pulled from the old data and it will 'look' in these fields for the data. works well when you have a structured system but not so well when the data is spread with no particular pattern.

Ultimately, if you dont spend time on migrating the old data to your new system properly then you will have problems. turning junk into junk as they say...
Irishwingz is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service

Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.