So I got a bit bored this afternoon (in between conference calls), and wondered which aircraft had the highest message count in MyLog. Here's my top 10 (from the last month):
G-LGNM Flybe - British European (Loganair) SF34 Saab 340B
G-LGNB British Airways (Loganair) SF34 Saab 340B
G-FBEA Flybe - British European E190 Embraer ERJ-190-200LR 195LR
G-LGNJ Flybe - British European (Loganair) SF34 Saab 340B
G-LGNF Loganair SF34 Saab 340B
G-STRN Iceland Express (Astraeus) B737 Boeing 737-7L9
G-EMBN BMI Regional E145 Embraer EMB-145EU (ERJ-145EU)
G-RJXA BMI Regional E145 Embraer EMB-145EP (ERJ-145EP)
G-LGNL Loganair SF34 Saab 340B
F-GITH Air France B744 Boeing 747-428
The only real surprise in my list is the Air France 747.
FYI, here's the SQL:
SELECT
v_Flights.ModeS,
SUM(v_Flights.MsgCount) AS FIELD_1,
Aircraft.Registration,
Aircraft.AircraftTypeLong,
Aircraft.AircraftTypeSmall,
Aircraft.Airline
FROM
v_Flights
LEFT OUTER JOIN Aircraft ON (v_Flights.ModeS=Aircraft.ModeS)
GROUP BY
v_Flights.ModeS,
Aircraft.Registration,
Aircraft.AircraftTypeLong,
Aircraft.AircraftTypeSmall,
Aircraft.Airline
ORDER BY
FIELD_1 DESC