AirNav Systems Forum

AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: tailplane on February 11, 2010, 03:57:06 PM

Title: Aircraft rankings from NavData.db3
Post by: tailplane on February 11, 2010, 03:57:06 PM
I made aircraft rankings from information stored in NavData.db3.
Please refer `ranking201002.xps`
http://www.ne.jp/asahi/nature/kuro/RDBX/exposition/ranking201002.xps
Title: Re: Aircraft rankings from NavData.db3
Post by: DaveReid on February 11, 2010, 04:35:54 PM
Quote from: tailplane on February 11, 2010, 03:57:06 PM
I made aircraft rankings from information stored in NavData.db3.
Please refer ranking201002.xps
http://www.ne.jp/asahi/nature/kuro/RDBX/exposition/ranking201002.xps

Fascinating stuff.

If you don't mind me asking, what's a "Sioux/Troopropellerer" (Page 3) ?
Title: Re: Aircraft rankings from NavData.db3
Post by: tarbat on February 11, 2010, 04:48:44 PM
What's also useful is to look at your MyLog to see what aircraft you see most often.  I'm currently using this SQL to decide what additional 3D models to create:
SELECT DISTINCT 
  Aircraft.AircraftTypeSmall,
  COUNT(Aircraft.ModeS) AS Counter
FROM
 Aircraft
WHERE
  (Aircraft.ADSB = "Y")
GROUP BY
  Aircraft.AircraftTypeSmall
ORDER BY
  Counter DESC


Gives this top 20 of ADS/B aircraft:
B738   428
B744   336
B772   285
B763   275
A319   270
B752   265
A320   221
B733   143
A332   137
MD11   123
B77W   116
B737   110
A343   103
A321   102
A333   77
GLF5   61
A346   48
A310   41
B762   41
F100   37
Title: Re: Aircraft rankings from NavData.db3
Post by: tailplane on February 12, 2010, 11:11:29 PM
Hi DaveReid

>If you don't mind me asking, what's a "Sioux/Troopropellerer" (Page 3) ?

I do not understand in detail.but I confirmed DB.

Busse Helicopters   1
　Agusta AB-47G-2   1
Heliba   1
　Agusta AB-47G-3B-1   1
Heli-Est   1
　Bell 47G   1
Sud-Ouest   1
　Bell 47G-2   1
Untitled   15
　Agusta AB-47G-2   2
　Bell 47G   1
　Bell 47G-2   2
　Bell 47G-4   1
　Bell 47G-4A-T   1
　Westland AB-47G-3B-1   7
　Westland AB-47G-3B-1T   1
blank   166
   blank   166
total   185
Title: Re: Aircraft rankings from NavData.db3
Post by: viking9 on February 13, 2010, 12:13:36 AM
Hi tailplane,

Where are you located that you have so many AB 47s around. The Westland AB-47G-3B1 are probably ex- British Army Air Corps.

Tom
Title: Re: Aircraft rankings from NavData.db3
Post by: DaveReid on February 13, 2010, 08:16:34 AM
Quote from: tailplane on February 12, 2010, 11:11:29 PM
>If you don't mind me asking, what's a "Sioux/Troopropellerer" (Page 3) ?

I do not understand in detail. but I confirmed DB.

Busse Helicopters   1
　Agusta AB-47G-2   1
Heliba   1
　Agusta AB-47G-3B-1   1
Heli-Est   1
　Bell 47G   1
Sud-Ouest   1
　Bell 47G-2   1
Untitled   15
　Agusta AB-47G-2   2
　Bell 47G   1
　Bell 47G-2   2
　Bell 47G-4   1
　Bell 47G-4A-T   1
　Westland AB-47G-3B-1   7
　Westland AB-47G-3B-1T   1
blank   166
   blank   166
total   185

Thanks for that. 

As you rightly say, with 90% of those RadarBox database records having no data in the AN (type description) column, it's hard to work out exactly what they are.

I've just run the B47 registrations from NavData.db3 against the Brand X database, and the actual breakdown is as follows:

73 Agusta-built
91 Bell-built
21 Westland-built

As Tom says, the Westland-built examples (all but one) are ex AAC.

HTH
Dave