search

jpatokal / openflights

Website for storing flight information, rendering paths on a zoomable world map and calculating statistics, with plenty of free airline, airport and route data.
http://openflights.org
GNU Affero General Public License v3.0
1.41k stars 395 forks source link

[Feature] Import from Flightdiary [sf#102] #320

Closed jpatokal closed 9 years ago

jpatokal commented 9 years ago

*Reported by anonymous on 2014-08-22 18:52 UTC* Hello. Will it be possible to make an import of flight statistisc with .csv file from Flightdiary.net

jpatokal commented 9 years ago

Updated by jpatokal on 2014-08-25 06:10 UTC

jpatokal commented 9 years ago

Commented by jpatokal on 2014-08-25 06:10 UTC As far as I'm aware, Flightdiary's CSV format is not documented and uses only numeric codes for airports, airlines etc, so it's not possible for us to read it. If you have links to documentation, I would love to be proved wrong ;)

jpatokal commented 9 years ago

*Commented by anonymous on 2014-08-25 11:46 UTC** It uses IATA\ICAO codes as I can see in the file. csv example is attached. Attached file flightdiary_2014_08_22_20_22.csv:

Date,"Flight number",From,To,"Dep time","Arr time",Duration,Airline,Aircraft,Registration,"Seat number","Seat type","Flight class","Flight reason",Note,Dep_id,Arr_id,Airline_id,Aircraft_id
2011-12-31,SU-764,"Krasnodar / Pashkovsky (KRR/URKK)","Moscow / Sheremetyevo (SVO/UUEE)",11:50:00,13:50:00,02:00:00,"Aeroflot (SU/AFL)","Airbus A319 (A319)",VQ-BCO,10A,1,1,2,,1493,2816,33,26
2011-12-31,SU-859,"Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",15:50:00,17:20:00,01:30:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)",VP-BMF,15A,1,1,2,,2816,1591,33,27
2011-12-07,SU-846,"St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",16:30:00,17:50:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A330 (A330)",VQ-BQX,31G,3,1,2,,1591,2816,33,29
2011-12-11,SU-4306,"Moscow / Sheremetyevo (SVO/UUEE)","Rostov-Na-Donu / Rostov-Na-Donu (ROV/URRR)",13:15:00,15:20:00,02:05:00,"Donavia (D9/DNV)","Boeing 737 (B73X)",VQ-BCS,09A,1,1,2,,2816,2553,241,2009
2011-09-12,FV-4166,"St Petersburg / Pulkovo (LED/ULLI)","Helsinki / Vantaa (HEL/EFHK)",12:35:00,12:30:00,01:55:00,"Finnair (AY/FIN)","Airbus A319 (A319)",OH-LVI,14A,1,1,2,,1591,1110,304,26
2011-09-17,"FV 230","Helsinki / Vantaa (HEL/EFHK)","St Petersburg / Pulkovo (LED/ULLI)",19:40:00,21:45:00,00:05:00,"Rossiya (FV/SDM)","Boeing 737 (B73X)",EI-CDE,19F,1,1,2,,1110,1591,687,2009
2011-09-12,AF-1799,"Helsinki / Vantaa (HEL/EFHK)","Paris / Charles de Gaulle (CDG/LFPG)",16:05:00,18:10:00,03:05:00,"Finnair (AY/FIN)","Airbus A321 (A321)",OH-LZF,12A,1,1,2,,1110,509,304,28
2011-09-17,"AF 2298","Paris / Charles de Gaulle (CDG/LFPG)","Helsinki / Vantaa (HEL/EFHK)",10:50:00,14:50:00,03:00:00,"Finnair (AY/FIN)","Airbus A320 (A320)",OH-LXB,16F,1,1,2,,509,1110,304,27
2012-01-22,SU-4530,"St Petersburg / Pulkovo (LED/ULLI)","Krasnodar / Pashkovsky (KRR/URKK)",12:45:00,16:00:00,03:15:00,"Rossiya (FV/SDM)","Airbus A319 (A319)",VP-BIQ,6A,1,1,2,,1591,1493,687,26
2012-01-25,SU-764,"Krasnodar / Pashkovsky (KRR/URKK)","Moscow / Sheremetyevo (SVO/UUEE)",12:00:00,14:20:00,02:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)",VQ-BHL,15F,1,1,2,,1493,2816,33,27
2012-01-25,SU-859,"Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",15:50:00,17:20:00,01:30:00,"Aeroflot (SU/AFL)","Airbus A321 (A321)",VP-BQX,10F,1,1,2,,2816,1591,33,28
2011-08-20,"SU 833","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",08:15:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)",VQ-BIV,20A,1,1,2,,2816,1591,33,27
2011-08-20,"SU 2072","Surgut / Surgut (SGC/USRR)","Moscow / Sheremetyevo (SVO/UUEE)",05:15:00,00:00:00,03:20:00,"Nordavia (5N/AUL)","Boeing 737 (B73X)",VP-BRN,10A,1,1,2,,2648,2816,891,2009
2011-08-08,"SU 2071","Moscow / Sheremetyevo (SVO/UUEE)","Surgut / Surgut (SGC/USRR)",23:00:00,00:00:00,02:55:00,"Nordavia (5N/AUL)","Boeing 737 (B73X)",VP-BXN,17C,3,1,1,,2816,2648,891,2009
2011-08-08,"SU 856","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",20:30:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A319 (A319)",VP-BDM,15F,3,1,1,,1591,2816,33,26
2011-08-05,"SU 833","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",08:15:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)",VP-BQX,20A,1,1,1,,2816,1591,33,27
2011-08-05,"SU 2072","Surgut / Surgut (SGC/USRR)","Moscow / Sheremetyevo (SVO/UUEE)",05:15:00,00:00:00,03:20:00,"Nordavia (5N/AUL)","Boeing 737 (B73X)",VP-BRP,15C,3,1,1,,2648,2816,891,2009
2011-07-19,"SU 2071","Moscow / Sheremetyevo (SVO/UUEE)","Surgut / Surgut (SGC/USRR)",23:00:00,00:00:00,02:55:00,"Nordavia (5N/AUL)","Boeing 737 (B73X)",VP-BQI,19D,3,1,2,,2816,2648,891,2009
2011-07-19,"SU 856","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",20:30:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A321 (A321)",VQ-BIR,7D,3,1,2,,1591,2816,33,28
2011-07-16,"SU 855","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",17:50:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)",VQ-BEH,23C,3,1,2,,2816,1591,33,27
2011-07-16,"SU 2092","Kaliningrad / Khrabrovo (KGD/UMKK)","Moscow / Sheremetyevo (SVO/UUEE)",13:20:00,00:00:00,01:45:00,"Donavia (D9/DNV)","Boeing 737 (B73X)",VP-BLF,10F,1,1,2,,1413,2816,241,2009
2011-07-14,"SU 759","Moscow / Sheremetyevo (SVO/UUEE)","Kaliningrad / Khrabrovo (KGD/UMKK)",19:10:00,00:00:00,01:45:00,"Aeroflot (SU/AFL)","Airbus A321 (A321)",VP-BQR,6C,3,2,2,,2816,1413,33,28
2011-07-14,"SU 844","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",14:55:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)",VQ-BIT,10C,3,1,2,,1591,2816,33,27
2011-06-04,SU-851,"Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",16:25:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)",VQ-BHL,21A,1,1,2,,2816,1591,33,27
2011-06-04,SU-602,"Rostov-Na-Donu / Rostov-Na-Donu (ROV/URRR)","Moscow / Sheremetyevo (SVO/UUEE)",12:45:00,00:00:00,01:50:00,"Aeroflot (SU/AFL)","Boeing 737 (B73X)",VP-BLF,11A,1,1,2,,2553,2816,33,2009
2011-05-04,"SU 2247","St Petersburg / Pulkovo (LED/ULLI)","Krasnodar / Pashkovsky (KRR/URKK)",12:30:00,00:00:00,03:05:00,"Rossiya (FV/SDM)","Boeing 737 (B73X)",EI-CDF,17C,3,1,2,,1591,1493,687,2009
2011-04-09,AF-1152,"Paris / Charles de Gaulle (CDG/LFPG)","St Petersburg / Pulkovo (LED/ULLI)",16:05:00,00:00:00,03:15:00,"Air France (AF/AFR)","Airbus A319 (A319)",F-GRHZ,10C,3,1,2,,509,1591,34,26
2011-04-05,AF-2253,"St Petersburg / Pulkovo (LED/ULLI)","Paris / Charles de Gaulle (CDG/LFPG)",16:30:00,00:00:00,03:25:00,"Air France (AF/AFR)","Airbus A319 (A319)",F-GRHN,18F,1,1,2,,1591,509,34,26
2011-04-01,SU-2210,"Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",23:00:00,00:00:00,01:30:00,"Rossiya (FV/SDM)","Boeing 737 (B73X)",EI-CDF,13A,1,1,2,,2816,1591,687,2009
2011-03-20,SU-860,"St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",17:25:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)",VP-BKY,16F,1,1,2,,1591,2816,33,27
2011-03-12,"AY 6850","Helsinki / Vantaa (HEL/EFHK)","St Petersburg / Pulkovo (LED/ULLI)",19:40:00,00:00:00,01:05:00,"Finnair (AY/FIN)","Boeing 737 (B73X)",EI-CDE,9A,1,1,2,,1110,1591,304,2009
2011-03-12,"AY 872","Paris / Charles de Gaulle (CDG/LFPG)","Helsinki / Vantaa (HEL/EFHK)",10:50:00,00:00:00,03:00:00,"Finnair (AY/FIN)","Airbus A321 (A321)",OH-LZA,24A,1,1,2,,509,1110,304,28
2011-03-06,"AY 3677","Helsinki / Vantaa (HEL/EFHK)","Paris / Charles de Gaulle (CDG/LFPG)",19:30:00,00:00:00,03:05:00,"Finnair (AY/FIN)","Embraer ERJ-190 (E190)",OH-LKL,23F,1,1,2,,1110,509,304,655
2011-03-06,"AY 170","St Petersburg / Pulkovo (LED/ULLI)","Helsinki / Vantaa (HEL/EFHK)",16:25:00,00:00:00,00:55:00,"Finnair (AY/FIN)","Embraer ERJ-170 (E170)",OH-LEG,16A,1,1,2,,1591,1110,304,654
2011-02-21,"SU 857","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",23:20:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A321 (A321)",VP-BUM,25A,1,1,2,,2816,1591,33,28
2011-01-24,"SU 852","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",18:25:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)",VP-BWM,24D,3,1,2,,1591,2816,33,27
2010-12-29,"FV 462","Chelyabinsk / Chelyabinsk (CEK/USCC)","St Petersburg / Pulkovo (LED/ULLI)",05:15:00,00:00:00,03:25:00,"Rossiya (FV/SDM)","Boeing 737 (B73X)",EI-CDH,16C,3,1,2,,518,1591,687,2009
2010-12-23,"S7 015","Moscow / Domodedovo (DME/UUDD)","Chelyabinsk / Chelyabinsk (CEK/USCC)",19:00:00,00:00:00,02:15:00,"S7 Airlines (S7/SBI)","Airbus A319 (A319)",VP-BHG,19D,3,1,2,,3651,518,680,26
2010-12-23,"SU 2275","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Domodedovo (DME/UUDD)",14:00:00,00:00:00,01:30:00,"Rossiya (FV/SDM)","Airbus A320 (A320)",EI-DXY,12C,3,1,2,,1591,3651,687,27
2010-12-18,"SU 2234","Chelyabinsk / Chelyabinsk (CEK/USCC)","St Petersburg / Pulkovo (LED/ULLI)",05:15:00,00:00:00,03:25:00,"Rossiya (FV/SDM)","Airbus A319 (A319)",VP-BIT,18C,3,1,2,,518,1591,687,26
2010-12-03,"SU 899","Moscow / Sheremetyevo (SVO/UUEE)","Chelyabinsk / Chelyabinsk (CEK/USCC)",22:30:00,00:00:00,02:30:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)",VQ-BCN,22A,1,1,2,,2816,518,33,27
2010-12-03,"SU 852","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",18:25:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)",VP-BZP,9A,1,1,2,,1591,2816,33,27
2010-11-19,SU-833,"Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",18:00:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)",VP-BRX,17B,2,1,1,,2816,1591,33,27
2010-11-18,SU-334,"Havana / Jose Marti (HAV/MUHA)","Moscow / Sheremetyevo (SVO/UUEE)",19:05:00,00:00:00,11:35:00,"Aeroflot (SU/AFL)","Airbus A330 (A330)",VQ-BBG,29F,3,1,1,,1098,2816,33,29
2010-10-30,SU-333,"Moscow / Sheremetyevo (SVO/UUEE)","Havana / Jose Marti (HAV/MUHA)",13:30:00,00:00:00,12:40:00,"Aeroflot (SU/AFL)","Airbus A330 (A330)",VQ-BBF,30K,1,1,1,,2816,1098,33,29
2010-10-30,SU-840,"St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",10:35:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)",VP-BWM,17B,2,1,1,,1591,2816,33,27
2010-10-24,AY-6850,"Helsinki / Vantaa (HEL/EFHK)","St Petersburg / Pulkovo (LED/ULLI)",19:40:00,00:00:00,01:05:00,"Rossiya (FV/SDM)","Airbus A319 (A319)",VQ-BAV,21E,2,1,2,,1110,1591,687,26
2010-10-24,AY-3658,"Milan / Malpensa (MXP/LIMC)","Helsinki / Vantaa (HEL/EFHK)",11:30:00,00:00:00,03:05:00,"Finnair (AY/FIN)","Airbus A321 (A321)",OH-LZF,31E,2,1,2,,1983,1110,304,28
2010-10-15,AY-793,"Helsinki / Vantaa (HEL/EFHK)","Milan / Malpensa (MXP/LIMC)",08:00:00,00:00:00,03:05:00,"Finnair (AY/FIN)","Airbus A319 (A319)",OH-LVE,3E,2,2,2,,1110,1983,304,26
2010-10-14,AY-6849,"St Petersburg / Pulkovo (LED/ULLI)","Helsinki / Vantaa (HEL/EFHK)",18:50:00,00:00:00,01:05:00,"Finnair (AY/FIN)","Airbus A319 (A319)",VQ-BAV,12A,1,1,2,,1591,1110,304,26
2010-09-29,"SU 845","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",13:30:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A319 (A319)",VP-BWJ,17A,1,1,2,,2816,1591,33,26
2010-09-29,"SU 616","Rostov-Na-Donu / Rostov-Na-Donu (ROV/URRR)","Moscow / Sheremetyevo (SVO/UUEE)",10:30:00,00:00:00,01:40:00,"Aeroflot (SU/AFL)","Boeing 737 (B73X)",VP-BLG,16A,1,1,2,,2553,2816,33,2009
2010-07-27,"SU 2258","Volgograd / Volgograd (VOG/URWW)","St Petersburg / Pulkovo (LED/ULLI)",05:00:00,00:00:00,02:50:00,"Rossiya (FV/SDM)","Antonov AN-148 (A148)",RA-61703,14A,1,1,2,,3217,1591,687,2039
2010-07-23,"SU 729","Moscow / Sheremetyevo (SVO/UUEE)","Volgograd / Volgograd (VOG/URWW)",22:05:00,00:00:00,01:50:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)",VP-BZP,19A,1,1,2,,2816,3217,33,27
2010-07-18,"SU 2205","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Domodedovo (DME/UUDD)",11:50:00,00:00:00,01:30:00,"Rossiya (FV/SDM)","Antonov AN-148 (A148)",RA-61703,6A,1,1,2,,1591,3651,687,2039
2010-07-15,"SU 845","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",13:30:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A319 (A319)",VP-BWG,19D,3,1,2,,2816,1591,33,26
2010-07-09,"SU 833","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",14:35:00,00:00:00,01:25:00,"Aeroflot (SU/AFL)","Airbus A319 (A319)",VQ-BBD,17A,1,1,2,,2816,1591,33,26
2010-07-06,"SU 850","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",20:05:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A319 (A319)",VQ-BBA,17A,1,1,2,,1591,2816,33,26
2010-06-30,"SU 847","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",16:25:00,00:00:00,01:25:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)",VP-BWM,20F,1,1,2,,2816,1591,33,27
2010-06-27,"SU 850","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",20:05:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VQ-BCM G. ",20A,1,1,2,,1591,2816,33,27
2010-06-21,"SU 841","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",10:10:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BZP E. ",20A,1,1,2,,2816,1591,33,27
2010-06-21,"SU 730","Volgograd / Volgograd (VOG/URWW)","Moscow / Sheremetyevo (SVO/UUEE)",07:05:00,00:00:00,01:50:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BKC I. ",20A,1,1,2,,3217,2816,33,27
2010-06-07,"SU 771","Moscow / Sheremetyevo (SVO/UUEE)","Krasnodar / Pashkovsky (KRR/URKK)",17:25:00,00:00:00,02:15:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BZO V. ",1A,1,2,2,,2816,1493,33,27
2010-06-07,"SU 864","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",14:25:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BQW V. ",19F,1,1,2,,1591,2816,33,27
2010-06-02,"SU 823","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",11:20:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BWI A. ",21F,1,1,2,,2816,1591,33,27
2010-06-02,"KC 871","Almaty / Almaty (ALA/UAAA)","Moscow / Sheremetyevo (SVO/UUEE)",06:05:00,00:00:00,04:40:00,"Air Astana (KC/KZR)","Airbus A321 (A321)",P4-OAS,25A,1,1,2,,100,2816,978,28
2010-05-16,"KC 872","Moscow / Sheremetyevo (SVO/UUEE)","Almaty / Almaty (ALA/UAAA)",09:50:00,00:00:00,04:25:00,"Air Astana (KC/KZR)","Airbus A320 (A320)",P4-WAS,26A,1,1,2,,2816,100,978,27
2010-05-16,"SU 858","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",06:15:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A319 (A319)",VP-BWA,19A,1,1,2,,1591,2816,33,26
2010-04-26,"SU 838","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",09:05:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BQW V. ",20F,1,1,2,,1591,2816,33,27
2010-04-23,"4G 923","Moscow / Vnukovo (VKO/UUWW)","St Petersburg / Pulkovo (LED/ULLI)",20:15:00,00:00:00,01:45:00,"Gazpromavia Aviation (4G/GZP)","Yakovlev Yak-42 (YK42)",RA-42425,6A,1,1,2,,3190,1591,952,1986
2010-04-23,"UT 576","Krasnodar / Pashkovsky (KRR/URKK)","Moscow / Vnukovo (VKO/UUWW)",16:00:00,00:00:00,01:50:00,"UTair Aviation (UT/UTA)","Tupolev TU-154 (T154)","RA-85796 V",20C,1,1,2,,1493,3190,778,1774
2010-04-22,"SU 2085","Moscow / Sheremetyevo (SVO/UUEE)","Krasnodar / Pashkovsky (KRR/URKK)",07:40:00,00:00:00,02:20:00,"Nordavia (5N/AUL)","Boeing 737 (B73X)",VP-BKT,20C,1,1,2,,2816,1493,891,2009
2010-04-21,"SU 774","Krasnodar / Pashkovsky (KRR/URKK)","Moscow / Sheremetyevo (SVO/UUEE)",06:00:00,00:00:00,02:15:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BZO V. ",23F,1,1,2,,1493,2816,33,27
2010-04-12,"SU 771","Moscow / Sheremetyevo (SVO/UUEE)","Krasnodar / Pashkovsky (KRR/URKK)",17:25:00,00:00:00,02:15:00,"Aeroflot (SU/AFL)","Airbus A319 (A319)","VP-BWG A. ",17F,1,1,2,,2816,1493,33,26
2010-04-12,"SU 730","Volgograd / Volgograd (VOG/URWW)","Moscow / Sheremetyevo (SVO/UUEE)",07:05:00,00:00:00,01:50:00,"Aeroflot (SU/AFL)","Airbus A319 (A319)","VQ-BBD V. ",17F,1,1,2,,3217,2816,33,26
2010-03-24,"SU 601","Moscow / Sheremetyevo (SVO/UUEE)","Rostov-Na-Donu / Rostov-Na-Donu (ROV/URRR)",15:45:00,00:00:00,01:50:00,"Aeroflot (SU/AFL)","Boeing 737 (B73X)",VP-BYV,15A,1,1,2,,2816,2553,33,2009
2010-03-24,"SU 842","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",12:30:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BZS M. ",19F,1,1,2,,1591,2816,33,27
2010-02-21,"SU 837","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",06:45:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BQW V. ",22D,3,1,2,,2816,1591,33,27
2010-02-20,"SU 710","Astrakhan / Astrakhan (ASF/URWA)","Moscow / Sheremetyevo (SVO/UUEE)",20:00:00,00:00:00,02:20:00,"Aeroflot (SU/AFL)","Airbus A319 (A319)","VQ-BBD V. ",12D,3,1,2,,164,2816,33,26
2010-02-14,"SU 709","Moscow / Sheremetyevo (SVO/UUEE)","Astrakhan / Astrakhan (ASF/URWA)",16:10:00,00:00:00,02:20:00,"Aeroflot (SU/AFL)","Airbus A319 (A319)","VP-BUK Yu.",17F,1,1,2,,2816,164,33,26
2010-02-14,"SU 844","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",13:50:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BZS M. ",20F,1,1,2,,1591,2816,33,27
2009-12-24,"SU 1407","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",11:40:00,00:00:00,01:20:00,"Rossiya (FV/SDM)","Airbus A320 (A320)",VQ-BDY,8F,1,1,2,,2816,1591,687,27
2009-12-24,"SU 818","Omsk / Omsk (OMS/UNOO)","Moscow / Sheremetyevo (SVO/UUEE)",07:35:00,00:00:00,03:30:00,"Aeroflot (SU/AFL)","Airbus A319 (A319)","VP-BDO I. ",4D,1,2,2,,2193,2816,33,26
2009-12-06,"SU 629","Moscow / Sheremetyevo (SVO/UUEE)","Omsk / Omsk (OMS/UNOO)",10:30:00,00:00:00,03:40:00,"Aeroflot (SU/AFL)","Boeing 737 (B73X)",VP-BRG,9B,1,1,2,,2816,2193,33,2009
2009-12-06,"SU 2084","Astrakhan / Astrakhan (ASF/URWA)","Moscow / Sheremetyevo (SVO/UUEE)",06:30:00,00:00:00,02:30:00,"Nordavia (5N/AUL)","Boeing 737 (B73X)",VP-BRG,14C,1,1,2,,164,2816,891,2009
2009-12-02,"SU 2083","Moscow / Sheremetyevo (SVO/UUEE)","Astrakhan / Astrakhan (ASF/URWA)",21:15:00,00:00:00,02:30:00,"Nordavia (5N/AUL)","Boeing 737 (B73X)",VP-BKV,19A,1,1,2,,2816,164,891,2009
2009-12-02,"SU 852","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",18:25:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A319 (A319)","VP-BDM A. ",17F,1,1,2,,1591,2816,33,26
2009-11-28,"SU 855","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",21:25:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BWD A. ",19E,2,1,2,,2816,1591,33,27
2009-11-28,"SU 630","Omsk / Omsk (OMS/UNOO)","Moscow / Sheremetyevo (SVO/UUEE)",19:00:00,00:00:00,04:00:00,"Aeroflot (SU/AFL)","Boeing 737 (B73X)",VP-BRP,16F,1,1,2,,2193,2816,33,2009
2009-11-18,"SU 629","Moscow / Sheremetyevo (SVO/UUEE)","Omsk / Omsk (OMS/UNOO)",10:30:00,00:00:00,03:40:00,"Aeroflot (SU/AFL)","Boeing 737 (B73X)",VP-BRP,11A,1,1,2,,2816,2193,33,2009
2009-11-18,"SU 856","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",07:20:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BRX V. ",16A,1,1,2,,1591,2816,33,27
2009-10-31,"SU 845","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",13:10:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BRY K. ",22F,1,1,2,,2816,1591,33,27
2009-10-31,"SU 782","Krasnojarsk / Yemelyanovo (KJA/UNKL)","Moscow / Sheremetyevo (SVO/UUEE)",11:00:00,00:00:00,05:00:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VQ-BCN V. ",22F,1,1,2,,3937,2816,33,27
2009-10-14,"SU 781","Moscow / Sheremetyevo (SVO/UUEE)","Krasnojarsk / Yemelyanovo (KJA/UNKL)",01:40:00,00:00:00,04:40:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BWM S. ",20F,1,1,2,,2816,3937,33,27
2009-10-13,"SU 854","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",22:10:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A330 (A330)","VQ-BBF A. ",28K,1,1,2,,1591,2816,33,29
2009-10-11,"SU 839","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",08:35:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BZO V. ",20F,1,1,2,,2816,1591,33,27
2009-10-11,"SU 886","Tyumen / Roshchino (TJM/USTR)","Moscow / Sheremetyevo (SVO/UUEE)",06:35:00,00:00:00,03:00:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BZO V. ",20F,1,1,2,,3704,2816,33,27
2009-09-21,"SU 809","Moscow / Sheremetyevo (SVO/UUEE)","Novosibirsk / Tolmachevo (OVB/UNNT)",22:35:00,00:00:00,03:55:00,"Aeroflot (SU/AFL)","Airbus A321 (A321)","VP-BQS I. ",14A,1,1,2,,2816,3678,33,28
2009-09-21,"SU 850","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",20:05:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BDK G. ",13A,1,1,2,,1591,2816,33,27
2009-09-13,"SU 847","Moscow / Sheremetyevo (SVO/UUEE)","St Petersburg / Pulkovo (LED/ULLI)",14:15:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A330 (A330)","VP-BLX E. ",15A,1,1,1,,2816,1591,33,29
2009-09-13,"SU 874","Sochi / Sochi (AER/URSS)","Moscow / Sheremetyevo (SVO/UUEE)",08:50:00,00:00:00,02:15:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BWF D. ",14C,3,1,1,,52,2816,33,27
2009-08-23,"SU 871","Moscow / Sheremetyevo (SVO/UUEE)","Sochi / Sochi (AER/URSS)",14:10:00,00:00:00,02:30:00,"Aeroflot (SU/AFL)","Airbus A320 (A320)","VP-BZR F. ",15E,2,1,1,,2816,52,33,27
2009-08-23,"SU 838","St Petersburg / Pulkovo (LED/ULLI)","Moscow / Sheremetyevo (SVO/UUEE)",09:05:00,00:00:00,01:20:00,"Aeroflot (SU/AFL)","Airbus A319 (A319)","VQ-BCP D. ",15E,2,1,1,,1591,2816,33,26

The file could not be attached: 'ascii' codec can't decode byte 0xc3 in position 183: ordinal not in range(128)