Airport-Data.com Forum Index  
  Airport-Data.com » Forums  Guest: Log in |  Register |  Search |  Memberlist |  Usergroups |  Profile |  Private messages |  FAQ 
Most Photographed?      Goto page 1, 2  Next 
Post new topic   Reply to topic    Airport-Data.com Forum Index -> Aircraft
  Display posts from previous 
Display posts from previous:   

  Most Photographed? 
Author Message
Ztex



Joined: 28 Aug 2007
Posts: 646
Location: DFW - GKY

PostPosted: Tue Mar 08, 2011 11:47 am    Post subject: Most Photographed? Reply with quote

So...what is the most photographed aircraft here on A-D?

I would venture to guess it might be the EAA's B-17G N5017N with @ 326 photos uploaded so far...

Any other ideas?

_________________
There I was at 20,000 ft, upside down and out of ammunition.

   
Author Message
Timothy Aanerud



Joined: 09 Jul 2006
Posts: 175
Location: KMIC

PostPosted: Tue Mar 08, 2011 10:15 pm    Post subject: Reply with quote

The answer to your question can be found here:

SELECT TAIL_NUMBER, COUNT(*) as 'PHOTO_COUNT' FROM AIRPORT_DATA GROUP BY TAIL_NUMBER ORDER BY PHOTO_COUNT;

But, you'll need access to the web site's database.


Last edited by Timothy Aanerud on Sat Jun 18, 2011 8:36 pm; edited 1 time in total

   
Author Message
Timothy Aanerud



Joined: 09 Jul 2006
Posts: 175
Location: KMIC

PostPosted: Tue Mar 08, 2011 10:29 pm    Post subject: Reply with quote

There's a few (16) photos filed under N5017N that should be moved to N9323Z. I've sent a message to the photographer asking him to correct the error.

   
Author Message
Bluedharma



Joined: 25 May 2007
Posts: 476
Location: Littleton, CO

PostPosted: Wed Mar 09, 2011 4:43 pm    Post subject: Reply with quote

Timothy Aanerud wrote:
There's a few (16) photos filed under N5017N that should be moved to N9323Z. I've sent a message to the photographer asking him to correct the error.

I see them Timothy. On page 13 right?

_________________
Live the Good Life
Bluedharma
http://flickr.com/photos/bluedharma/
http://www.airport-data.com/photographers/Bluedharma;1045/
bluedharmaairportdata@gmail.com

   
Author Message
Airport-Data
Site Admin


Joined: 05 Aug 2005
Posts: 1436
Location: Toronto, ON

PostPosted: Sun Mar 13, 2011 3:23 am    Post subject: Reply with quote

Top 30:

UNKNOWN 1877
NONE 463
N5017N 310
OE-LBP 260
N93012 242
D-AIMA 215
N224J 198
OE-LAE 187
F-WWDD 173
J-015 166
OE-LPC 162
OE-LAY 156
N273MD 148
D-CDLH 142
OE-LAW 138
OE-LAT 137
OE-LPD 134
UR-09307 132
OE-LNM 131
G-APSA 131
OE-LBC 127
N541HA 122
N9323Z 118
OE-LNN 118
N251MX 118
N996DM 117
N24927 116
OE-LAZ 116
OE-LPA 115
N865F 112

Unfortunately UNKNOWS wins hands down.

Ken

   
Author Message
Chris Hall



Joined: 18 Jul 2008
Posts: 1125
Location: Airport-Data Admin Team

PostPosted: Sun Mar 13, 2011 6:21 pm    Post subject: Reply with quote

Airport-Data wrote:
Top 30:

UNKNOWN 1877
NONE 463

Unfortunately UNKNOWS wins hands down.

Ken


NONE is now down to 348 Wink Wink

but UNKNOWN has gone up to 1909

_________________
My Photo's on Airport-Data

   
Author Message
Ztex



Joined: 28 Aug 2007
Posts: 646
Location: DFW - GKY

PostPosted: Sun Mar 13, 2011 10:26 pm    Post subject: Reply with quote

Cool! Thanks Ken!

It's amazing (to me anyway) that airliners are so high on the list.

What's up with F-WWDD? 11 profiles...this stuff is nuts. hehe

http://www.airport-data.com/search/search2.html?field=tail&code=F-WWDD&search=Search

_________________
There I was at 20,000 ft, upside down and out of ammunition.

   
Author Message
Chris Hall



Joined: 18 Jul 2008
Posts: 1125
Location: Airport-Data Admin Team

PostPosted: Sun Mar 13, 2011 10:36 pm    Post subject: Reply with quote

Ztex wrote:


What's up with F-WWDD? 11 profiles...this stuff is nuts. hehe

http://www.airport-data.com/search/search2.html?field=tail&code=F-WWDD&search=Search


F-WWDD is one of the Airbus test registrations which are used several times on different airframes.
The test numbers at Toulouse run from F-WWAA to F-WWZZ. At Hamburg most of the test regs start as D-AXA? but they also use D-AUB? and D-AVZ?

hope that helps

Chris

_________________
My Photo's on Airport-Data

   
Author Message
Ztex



Joined: 28 Aug 2007
Posts: 646
Location: DFW - GKY

PostPosted: Mon Mar 14, 2011 9:55 am    Post subject: Reply with quote

Chris,

Thanks for that information. I didn't think of that. It's like the Boeing test numbers...

N1786B for example.

http://www.airport-data.com/search/search2.html?field=tail&code=n1786b&search=Search

Zane the Slow..

_________________
There I was at 20,000 ft, upside down and out of ammunition.

   
Author Message
Malcolm Clarke



Joined: 13 Feb 2006
Posts: 2794
Location: England

PostPosted: Tue Mar 15, 2011 6:34 am    Post subject: Reply with quote

Amazing that 737's can fly without any engines! Laughing Laughing

M.

   
Author Message
Timothy Aanerud



Joined: 09 Jul 2006
Posts: 175
Location: KMIC

PostPosted: Sat Jun 18, 2011 8:44 pm    Post subject: Reply with quote

I have a slight variation on the original question.

What aircraft has been spotted at the most airports?

I suspect Aluminum Overcast is probably a good contender. But I'm sure the some airliner is more likely.

   
Author Message
Connor Shepard



Joined: 21 Aug 2008
Posts: 47
Location: Murfreesboro, TN, USA

PostPosted: Sat Jun 18, 2011 8:58 pm    Post subject: Reply with quote

Perhaps there should be a special page on the site dedicated to these statistics.

-Connor

   
Author Message
Airport-Data
Site Admin


Joined: 05 Aug 2005
Posts: 1436
Location: Toronto, ON

PostPosted: Sat Jun 18, 2011 9:36 pm    Post subject: Reply with quote

What aircraft has been spotted at the most airports?

Here's the top 30 aircraft spotted at most airports:

NKNOWN 359
NONE 51
N93012 37
164763 35
N5017N 31
N224J 30
N6776U 27
N9079Z 27
N9323Z 25
N390TH 23
F-AZTE 22
EC-ISY 21
F-GFKJ 21
PA474 21
N24927 20
N1042B 20
N251MX 20
N74189 20
G-PBYA 19
HB-IYS 19
HB-IYV 19
F-GMLK 19
N707TJ 19
D-AILN 19
N7699 19
D-CDLH 19
N996DM 18
D-ABIK 18
N5548N 18
F-WWDD 18

Note this result does not deal with airport code variations, for example, KOSH and OSH count as 2.

Ken

   
Author Message
Ztex



Joined: 28 Aug 2007
Posts: 646
Location: DFW - GKY

PostPosted: Mon Jun 20, 2011 8:29 am    Post subject: Reply with quote

Ah! Cool!

The Collings Foundation B-17 "909" gets the win! Followed by FAAAAAAAT Albert!

_________________
There I was at 20,000 ft, upside down and out of ammunition.

   
Author Message
Timothy Aanerud



Joined: 09 Jul 2006
Posts: 175
Location: KMIC

PostPosted: Wed Dec 21, 2016 10:34 am    Post subject: Reply with quote

This thread has been dormant for a while... Could we get some updated statics on most popular aircraft, airports with the most photos, aircraft seen at the most airports? There's been 5 years of uploads... Or better yet, turn this queries in to URL's Smile

Post new topic   Reply to topic    Airport-Data.com Forum Index -> Aircraft All times are GMT - 5 Hours
Goto page 1, 2  Next
Page 1 of 2
View previous topic :: View next topic  

 
Jump to:  
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

Copyright 2004-2011, Airport-Data.com. All rights reserved.
Airport-Data.com does not guarantee the accuracy or timeliness of any information on this site. Use at your own risk.
Do NOT use these information for navigation, flight planning, or for use in flight.