AirNav RadarBox
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 


Author Topic: Aircraft rankings from NavData.db3  (Read 3684 times)

0 Members and 1 Guest are viewing this topic.

tailplane

  • New Member
  • *
  • Posts: 10
Aircraft rankings from NavData.db3
« 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

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: Aircraft rankings from NavData.db3
« Reply #1 on: February 11, 2010, 04:35:54 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) ?
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Aircraft rankings from NavData.db3
« Reply #2 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
« Last Edit: February 11, 2010, 04:51:35 PM by tarbat »

tailplane

  • New Member
  • *
  • Posts: 10
Re: Aircraft rankings from NavData.db3
« Reply #3 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

viking9

  • Hero Member
  • *****
  • Posts: 823
    • Aircraft Photography
Re: Aircraft rankings from NavData.db3
« Reply #4 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
Tom
Bury St Edmunds, Suffolk UK
15 miles SE of EGUN
32 miles SE of MAM > DIKAS track
http://www.viking9.co.uk

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: Aircraft rankings from NavData.db3
« Reply #5 on: February 13, 2010, 08:16:34 AM »
>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
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour