Database Update Requests

[DaveReid]

"ms" – 00A27F
"ar" – ZS-NBA
"cn" – 7702
"ai" – CL60
"at" – BOMBARDIER CL600-2B19

Aircraft imported into the country by SA Express airline and just started its scheduled flying - was N484CA (I think)

Yes, it was fornerly N484CA with Continental Express.  However it's an ICAO CRJ2, not a CL60.

[Chris11]

The South African Express Airlines has about 15 of these aircraft. They are all registered on the SA Civil Aviation Authority's register as CL60's but the description of the aircraft (on the register) varies and is sometimes
CANADAIR CL-600-2B19
and sometimes
BOMBARDIER CL600-2B19

For those that need information on South African registered aircraft the website is http://www.avdex.co.za/saregister/
(free registration) This website is fed information from the SACAA and is endirsed by them

[DaveReid]

The South African Express Airlines has about 15 of these aircraft. They are all registered on the SA Civil Aviation Authority's register as CL60's but the description of the aircraft (on the register) varies and is sometimes
CANADAIR CL-600-2B19
and sometimes
BOMBARDIER CL600-2B19

For those that need information on South African registered aircraft the website is http://www.avdex.co.za/saregister/
(free registration) This website is fed information from the SACAA and is endorsed by them

It may be endorsed by the SACAA, but it's still wrong :-)

If it helps, Canadair/Bombardier designations and marketing names are as follows:

CL-600-1A11 (ICAO CL60) "Challenger 600"
CL-600-2A12 (ICAO CL60) "Challenger 601-1"
CL-600-2B16 (ICAO CL60) "Challenger 601-3A/-3R/604/605"
CL-600-2B19 (ICAO CRJ1/CRJ2) "Regional Jet 100/200/440/Challenger 800/850/SE"
CL-600-2C10 (ICAO CRJ7) "Regional Jet 700/701/Challenger 870"
CL-600-2D15 (ICAO CRJ9) "Regional Jet 705"
CL-600-2D24 (ICAO CRJ9) "Regional Jet 900"
CL-600-2E25 (ICAO CRJX) "Regional Jet 1000"

[Chris11]

Thanks Dave

PS - I agree that the SACAA is probably not the "best" reference. It is staffed with Government officials :)

[Runway 31]

Updated 2 of them.  A27347 is a reserved code and has not yet been updated on the FAA database but is showing as for N257UF

[Runway 31]

Both now on

[Runway 31]

Ist and last done, middle on finding difficulty to get details other than reg D-EFUC

[Marpleman]

Ist and last done, middle on finding difficulty to get details other than reg D-EFUC

Hi Alan

It's a Cessna 172 S (cn 172S-8003) suprisingly based at Breighton Yorks

Regards

Rich

[Runway 31]

Ta Rich, now also updated.

Alan

[ACW367]

Alan

This website may be of help to you with the foreign registered UK based aircraft

http://www.laasdata.com/fra/

[John Hargreaves]

MS : A27347 is a long standing miscode. Being used by UPS MD11F N257UP instead of A2734F.

[Marpleman]

Cheers John

One of the team has been looking at MD11's so hopefully its been corrected over the last 24 hours - will check the details this evening

Regards

Rich

[DaveReid]

One of the team has been looking at MD11's so hopefully its been corrected over the last 24 hours - will check the details this evening

Out of interest, what's going to be the policy on miscodes ?

[DaveG]

Out of interest, what's going to be the policy on miscodes ?

As I have no policy either way (not thought about it), do you have something already in mind?

[DaveReid]

Out of interest, what's going to be the policy on miscodes ?

As I have no policy either way (not thought about it), do you have something already in mind?

I don't have a strong view one way or the other either.  My question was prompted by Rich's comment

One of the team has been looking at MD11's so hopefully its been corrected over the last 24 hours - will check the details this evening

which I didn't really understand.

The AirNav database schema, unless it has changed, doesn't allow for recording a miscode if that code is also used, correctly, by another aircraft (since MS is a PK in the Aircraft table).

That's the only PK, so it doesn't preclude recording both the allocated code and a miscode as long as no other aircraft are using the same code.

Your call.