 |
Matronics Email Lists
Web Forum Interface to the Matronics Email Lists
|
| View previous topic :: View next topic |
| Author |
Message |
gus.fraser(at)gs.com
Guest
|
 Posted: Fri Jan 13, 2006 2:39 pm Post subject: Family numbers |
 |
|
Craig,
I got bored again so I ran my own numbers. I upload the registration database to my server so I ran this query
SELECT faa_ar.modelname, count(*) as Total
FROM faa_ar, faa_master
WHERE ((faa_ar.mmscode = faa_master.mmscode))
AND((faa_ar.modelname like "YAK%") or
(faa_ar.modelname like "CJ6%") or
(faa_ar.modelname like "CJ-6%") or
(faa_ar.modelname like "SU-%") or
(faa_ar.modelname in ("E-3","I-3")) or
(faa_ar.modelname like "YAK%")
)
Group by faa_ar.modelname
Order by faa_ar.modelname
It yielded the following. These figures are valid as of today. I tell you what I will put this query into a web page with a drill down for each group how about that. TJ would you be interested in growth of the stock over time ?
CJ-6 53
CJ-6A 129
CJ6A (YAK 18A) 4
E-3 5
I-3 2
SU-1 1
SU-26 11
SU-26M 8
SU-26MX 7
SU-29 30
SU-31 10
SU-31M 1
YAK 1
YAK 11 1
YAK 18 6
YAK 18PS 1
YAK 18T 12
YAK 3 UPW 1
YAK 3UPW 1
YAK 3UR 2000 1
YAK 3UR-2000 1
YAK 50 3
YAK 52 175
YAK C-11 1
YAK-11 9
YAK-11-R2000 1
YAK-12M 1
YAK-18A 20
YAK-3 1
YAK-3M 6
YAK-3U/R-200 1
YAK-3UA 2
YAK-40 1
YAK-50 33
YAK-52 53
YAK-52TW 29
YAK-52W 14
YAK-53 1
YAK-54 4
YAK-55 5
YAK-55M 69
YAK-9U-M 7
YAKOLEV YAK 11 1
YAKOVLEV 1
YAKOVLEV 52 S 2
Gus
"Craig Payne" <cpayne(at)joimail.com> Subject: Re: Family Numbers Date: Dec 19, 2005
Correction! I did some more searching on Yaks. You sneaky guys use different A/C
codes for the Yak-52 as well as variations on "Aerostar".
Add:
SC Aerostar Yak-52TW 1 (Oh..that Dalton guy)
Aerostar Yak-52 38 (+10 that I listed from another Aerostar code)
Aerostar Yak-52TW 28
-------------------------------------
Total Yak-52's of various flavors 175 + 67 = 242
Total Yak's of the M-14 variety = 378
Craig Payne
End Msg: #34
| | - The Matronics Yak-List Email Forum - | | | Use the List Feature Navigator to browse the many List utilities available such as the Email Subscriptions page, Archive Search & Download, 7-Day Browse, Chat, FAQ, Photoshare, and much more:
http://www.matronics.com/Navigator?Yak-List |
|
|
|
| Back to top |
|
 |
cpayne(at)joimail.com
Guest
|
| Posted: Fri Jan 13, 2006 3:37 pm Post subject: Family numbers |
|
|
Gus
I followed up with a world-wide survey for CJ's and Yaks of the 620 cu in. variety. I combined those into tables and wrote an article for the RPA Newsletter. Just submitted a few days ago. Your search includes lots of A/C that I didn't include but neglects other aircraft codes that the same kind of airplane may have been certified as. Some folks added their own names to the type so it may not show up unless you used a UNIX expression/script to cover lots of variations.
Craig Payne
| | - The Matronics Yak-List Email Forum - | | | Use the List Feature Navigator to browse the many List utilities available such as the Email Subscriptions page, Archive Search & Download, 7-Day Browse, Chat, FAQ, Photoshare, and much more:
http://www.matronics.com/Navigator?Yak-List |
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
Get Email Distribution Too!
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
