Some profiles to clean up

GlennE.Chatfield

There are three IDs for the same aircraft, which is okay because they applied to it at different times of its life. The problem is that linking the profiles has added lots of profiles! Here's the thing. My shots and Bookie's shots were taken when the aircraft was active duty military as 72-21509, and that profile was the first up, I believe, because I posted it three years ago before old civil registrations showed up. The aircraft was then retired from the military and given the civil registration of N41574 for transportation to England, where it has been fully restored (perhaps restored prior to transport) and bears the registration of G-UHIH. There is a photo posted on N41574 because it was apparently photographed with that registration. All new photos are posted as G-UHIH. There should be only three profiles for this aircraft, all linked. But you will notice multiple profiles for each.

I know you guys have a lot of backlogs (I noticed some c/n corrections I posted a week or so ago, e.g, aren't fixed yet, and I saw the note to another poster about the backlog), but when you get a chance, this is one that can clean up a bit of extra stuff!

Thanks for all your hard work.

ChrisHall

Hi Glenn,

In my short time on the admin team, I have noticed that when a profile is linked to another reg number, if all the data fields are not the same, them another profile is generated.

for instance, if you look at the profile for N41574

http://www.airport-data.com/aircraft/N41574.html

the first profile reads as

Manufacturer: Bell

Model: UH-1H

Year built: 1972

Construction Number (C/N): 72-21509

Number of Seats: 15

Number of Engines: 1

Engine Manufacturer and Model: Lycoming T53-L-13

while the second reads as

Manufacturer: Bell

Model: UH-1H

Year built: 1972

Construction Number (C/N): 13208

Number of Seats: Unknown

Number of Engines: 1

Engine Type: None

Engine Manufacturer and Model: Lycoming T53-L13B

as you can see, the c/n number in the first profile is incorrect, the number of seats differ as does the engine type and Engine Manufacturer and Model. All these need to be identical in each profile for N41574, G-UHIH and 72-21509 to link together.

Fairly straight forward to fix, just takes a bit of time.

Please keep posting the corrections and we will sort them as quickly as we can.

Thanks for you help

cheers

Chris

ChrisHall

now fixed

thanks

Chris

GlennE.Chatfield

Thanks a lot Chris. If I was a computer geek, I'd volunteer to help!

Ken Wang

In my short time on the admin team, I have noticed that when a profile is linked to another reg number, if all the data fields are not the same, them another profile is generated.

Correction: the program checks 3 fileds to determin if if a new profile is generated: manufacturer, model, c/n. In Glenn's case, c/n's are different so a new profile was created.

And big thanks to our new admin team members, they unloaded a lot of work from me.

Ken

GlennE.Chatfield

I notice for N41574, there are still two entries for the same UH-1H, one with a photo. The bottom one with the photo has the links, but I wonder if all that could be put with the top profile by adjusting the entries? With the same call sign are two profiles for a Piper PA-28-151 - same plane but two profiles, which I don't see difference except the second one has comments.

Just thought it would help to have these four profiles reduced down to two.

ChrisHall

I notice for N41574, there are still two entries for the same UH-1H, one with a photo. The bottom one with the photo has the links, but I wonder if all that could be put with the top profile by adjusting the entries? With the same call sign are two profiles for a Piper PA-28-151 - same plane but two profiles, which I don't see difference except the second one has comments.

Just thought it would help to have these four profiles reduced down to two.

Strange :?, I sorted this one yesterday and the duplicate profiles have reappeared.

Duplicates deleted again

GlennE.Chatfield

Must be gremlins! :

Ken Wang

Strange :?, I sorted this one yesterday and the duplicate profiles have reappeared.

Duplicates deleted again

It must be the FAA data auto-import script,which runs every tuesday morning eastern time. I will take a look.

Thanks,

Ken

Ken Wang

I found the reason why two new profiles are created for N41574:

For piper, FAA data shows PA-28-151 while our database shows PA28-151, this different will cause a new profile.

For Bell, FAA data shows 72-21509 as c/n while our database shows 13208. this also triggers a new profile.

Reference: http://registry.faa.gov/aircraftinquiry/NNum_Results.aspx?NNumbertxt=41574

So to conclude, when it comes to USA aircraft, never change manufacturer, model or c/n in database directly. Use additional data to correct it otherwise it will end up with dups like this.

I will fix the database later so you guys can have a look first.

Ken