Most Photographed?

Ztex · Posted: Tue Mar 08, 2011 11:47 am Post subject: Most Photographed?

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?

Timothy Aanerud · Posted: Tue Mar 08, 2011 10:15 pm Post subject:

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.

Timothy Aanerud · Posted: Tue Mar 08, 2011 10:29 pm Post subject:

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.

Bluedharma · Posted: Wed Mar 09, 2011 4:43 pm Post subject:

Airport-Data · Site Admin

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

Chris Hall · Posted: Sun Mar 13, 2011 6:21 pm Post subject:

Ztex · Posted: Sun Mar 13, 2011 10:26 pm Post subject:

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

Chris Hall · Posted: Sun Mar 13, 2011 10:36 pm Post subject:

Ztex · Posted: Mon Mar 14, 2011 9:55 am Post subject:

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..

Malcolm Clarke · Posted: Tue Mar 15, 2011 6:34 am Post subject:

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

M.

Timothy Aanerud · Posted: Sat Jun 18, 2011 8:44 pm Post subject:

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.

Connor Shepard · Posted: Sat Jun 18, 2011 8:58 pm Post subject:

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

-Connor

Airport-Data · Site Admin

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

Ztex · Posted: Mon Jun 20, 2011 8:29 am Post subject:

Ah! Cool!

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

Timothy Aanerud · Posted: Wed Dec 21, 2016 10:34 am Post subject:

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

	Airport-Data.com Forum Index -> Aircraft	All times are GMT - 5 Hours Goto page 1, 2 Next
Page 1 of 2

		TOP
Home \| Member Section \| Forums \| Articles \| Advertising \| Privacy Policy \| Disclaimer \| About Us \| Contact Us \| Past Logos
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.