Advertisement
Guest User

Flights around Moscow 230619-230625

a guest
Jun 24th, 2023
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.42 KB | None | 0 0
  1. SELECT *, aircraft_type FROM aircraft_data WHERE flight_datetime > '2023-06-19' AND aircraft_type NOT IN ('EC30', 'A310', 'B429', 'R44', 'B39M', 'R66', 'B738', 'SU95', 'A20N', 'A319', 'A320', 'A321', 'A333', 'B735', 'B77L', 'B77W', 'B733', 'B789', 'A35K', 'E190', 'A318', 'A332', 'B763', 'B744', 'B734', 'MD80', 'B772', 'IL76', 'B752', 'B772', 'A21N', 'B737', 'MD83', 'A359', 'E195', 'B38M', 'IL96', 'B739', 'B788', 'T204', 'B748', 'B762', 'B773', 'A388', 'T154', 'IL62', 'A343', 'C208', 'MC23', 'AT75', 'MI8', 'BER2', 'A139');
  2.  
  3. flight_datetime,hex_id,country,callsign,reg,aircraft_type,squawk,altitude,speed,latitude,longitude,data_source,aircraft_count,aircraft_type
  4. 2023-06-24 10:00,68333A,Kazakhstan,EAK5188,UP-EM025,E35L,1563,39000,488,51.9235,50.2153,ADS-B,,E35L
  5. 2023-06-24 09:00,1506AA,Russia,RA67242,RA-67242,GLEX,2460,38000,,55.8642,43.1357,ADS-B,,GLEX
  6. 2023-06-24 07:00,1506A8,Russia,SSF253,RA-67240,CRJ2,2152,11425,320,61.3619,34.6061,ADS-B,,CRJ2
  7. 2023-06-24 06:00,1506AA,Russia,,RA-67242,GLEX,,37000,548,57.3666,42.4081,ADS-B,,GLEX
  8. 2023-06-24 06:00,151F11,Russia,,RA-73489,,,36000,436,57.0961,51.7297,Other,,
  9. 2023-06-24 06:00,142581,Russia,GZP9631,RA-09601,FA7X,2123,16550,410,58.9915,32.0014,Other,,FA7X
  10. 2023-06-24 00:00,150661,Russia,RLA7778,RA-67169,CL60,3417,38000,441,55.8424,44.6767,ADS-B,,CL60
  11. 2023-06-23 23:00,151F6F,Russia,DXT9683,RA-73583,CRJ2,1523,35450,462,53.1636,43.4507,Other,,CRJ2
  12. 2023-06-23 20:00,68333A,Kazakhstan,EAK5189,UP-EM025,E35L,602,35800,409,55.8282,40.5957,ADS-B,,E35L
  13. 2023-06-23 19:00,150641,Russia,RFE9738,RA-67137,CL35,1555,41000,477,56.0639,45.7712,ADS-B,,CL35
  14. 2023-06-23 18:00,14F11C,Russia,71680,RA-61724,A148,5502,32000,386,55.8636,43.1947,ADS-B,,A148
  15. 2023-06-23 18:00,1506A8,Russia,SSF182,RA-67240,CRJ2,5533,32000,387,57.8169,55.9041,Other,,CRJ2
  16. 2023-06-23 18:00,151F4E,Russia,RSJ9650,RA-73550,GLEX,2765,3500,159,59.69,30.753,ADS-B,,GLEX
  17. 2023-06-23 17:00,140B3B,Russia,JSI9156,RA-02875,E35L,5265,39225,410,55.8572,41.4336,Other,,E35L
  18. 2023-06-23 16:00,140B3B,Russia,JSI9156,RA-02875,E35L,5265,39950,445,56.889,54.5552,Other,,E35L
  19. 2023-06-23 16:00,1506A8,Russia,SSF184,RA-67240,CRJ2,5250,33000,442,57.8188,56.4329,Other,,CRJ2
  20. 2023-06-23 16:00,14F117,Russia,,RA-61719,A148,,32000,392,53.7856,39.8448,ADS-B,,A148
  21. 2023-06-23 16:00,150601,Russia,,RA-67073,L410,,11025,194,60.7891,31.9897,ADS-B,,L410
  22. 2023-06-23 15:00,1506A9,Russia,NWC9022,RA-67241,GLEX,5577,43000,487,56.846,45.9816,ADS-B,,GLEX
  23. 2023-06-23 15:00,1506A1,Russia,TUL9734,RA-67233,CRJ2,5554,36000,398,55.8288,40.9483,ADS-B,,CRJ2
  24. 2023-06-23 15:00,1506A7,Russia,SSF116,RA-67239,CRJ2,5252,23600,354,60.3871,44.5428,ADS-B,,CRJ2
  25. 2023-06-23 15:00,140AAE,Russia,,RA-02734,H25B,,13575,,55.5502,48.7135,ADS-B,,H25B
  26. 2023-06-23 14:00,140AE2,Russia,DXT9686,RA-02786,E35L,630,38000,430,55.0836,52.411,Other,,E35L
  27. 2023-06-23 14:00,142582,Russia,GZP9616,RA-09602,FA7X,6720,36000,419,54.5261,47.312,ADS-B,,FA7X
  28. 2023-06-23 14:00,14F110,Russia,,RA-61712,A148,,35000,430,53.7896,56.6328,Other,,A148
  29. 2023-06-23 14:00,142329,Russia,GZP9634,RA-09001,F900,731,6000,249,59.8021,29.9513,ADS-B,,F900
  30. 2023-06-23 14:00,151F36,Russia,TUL9751,RA-73526,GLEX,1533,5100,250,55.4925,49.1141,Other,,GLEX
  31. 2023-06-23 13:00,15063B,Russia,RFE9Z31,RA-67131,GL5T,6733,40000,480,55.8654,42.9913,ADS-B,,GL5T
  32. 2023-06-23 13:00,14F110,Russia,47473,RA-61712,A148,2426,34975,442,51.1279,45.716,ADS-B,,A148
  33. 2023-06-23 13:00,1506A8,Russia,,RA-67240,CRJ2,,32000,370,60.9939,37.9584,Other,,CRJ2
  34. 2023-06-23 12:00,1506A8,Russia,SSF183,RA-67240,CRJ2,5522,32000,417,58.9667,50.4691,Other,,CRJ2
  35. 2023-06-23 12:00,142580,Russia,GZP9625,RA-09600,F900,2127,375,,59.7993,30.3154,ADS-B,,F900
  36. 2023-06-23 11:00,150692,Russia,,RA-67218,CRJ2,,35000,450,56.0384,51.7687,Other,,CRJ2
  37. 2023-06-23 11:00,460555,Finland,,OH-CAN,C172,,2000,,61.2462,28.8468,ADS-B,,C172
  38. 2023-06-23 09:00,6830BB,Kazakhstan,KEJ6496,UP-CS301,C25B,2713,41000,405,55.529,47.0042,ADS-B,,C25B
  39. 2023-06-23 09:00,1506A0,Russia,RFE9721,RA-67232,CRJ2,6734,32000,431,55.8672,42.9305,ADS-B,,CRJ2
  40. 2023-06-23 09:00,150601,Russia,OAO541,RA-67073,L410,3122,10025,189,62.0015,45.4309,ADS-B,,L410
  41. 2023-06-23 08:00,14232B,Russia,GZP9601,RA-09003,F900,2150,35000,465,58.391,51.9005,Other,,F900
  42. 2023-06-23 08:00,A23456,United States,03407,N241GK,,5501,7050,160,53.3604,49.4485,ADS-B,,
  43. 2023-06-23 07:00,A23456,United States,,N241GK,,,13850,180,54.257,54.1094,Other,,
  44. 2023-06-23 06:00,151F3F,Russia,DXT9635,RA-73535,CRJ2,1524,33800,420,56.0461,50.4712,Other,,CRJ2
  45. 2023-06-23 06:00,15069E,Russia,SSF102,RA-67230,CRJ2,6276,31000,354,55.1317,30.5144,ADS-B,,CRJ2
  46. 2023-06-23 04:00,142AFA,Russia,MMM9628,RA-11002,GLF4,5363,43000,470,56.3562,45.4652,ADS-B,,GLF4
  47. 2023-06-23 04:00,14232B,Russia,GZP9602,RA-09003,F900,5265,34000,460,56.8253,51.2662,Other,,F900
  48. 2023-06-22 21:00,14F125,Russia,71679,RA-61733,A148,2737,25900,406,54.665,36.4494,ADS-B,,A148
  49. 2023-06-22 20:00,142AFA,Russia,MMM9627,RA-11002,GLF4,2151,41000,480,56.29,55.8293,Other,,GLF4
  50. 2023-06-22 20:00,1506AA,Russia,,RA-67242,GLEX,,39000,483,60.0067,43.0348,ADS-B,,GLEX
  51. 2023-06-22 20:00,14F115,Russia,SUM9108,RA-61717,A148,1044,21925,302,54.4102,37.7809,ADS-B,,A148
  52. 2023-06-22 19:00,142584,Russia,NWC9002,RA-09604,FA7X,3301,38000,498,56.6716,47.3205,ADS-B,,FA7X
  53. 2023-06-22 18:00,1506A6,Russia,KZN9416,RA-67238,CL60,740,37000,,55.5381,48.8577,ADS-B,,CL60
  54. 2023-06-22 18:00,150692,Russia,RFE9001,RA-67218,CRJ2,1545,33000,,56.2371,45.0215,ADS-B,,CRJ2
  55. 2023-06-22 18:00,14F125,Russia,71679,RA-61733,A148,2737,29975,378,54.5893,32.2145,Other,,A148
  56. 2023-06-22 17:00,1427EE,Russia,SBI8507,RA-10222,GLF5,2755,40000,466,59.3951,28.8882,Other,,GLF5
  57. 2023-06-22 17:00,14F124,Russia,71686,RA-61732,A148,4176,21950,288,54.6012,38.6708,ADS-B,,A148
  58. 2023-06-22 16:00,683087,Kazakhstan,BEC024,UP-C8502,CRJ2,621,32000,425,55.4635,48.481,ADS-B,,CRJ2
  59. 2023-06-22 15:00,150690,Russia,KZN9404,RA-67216,CL60,5554,36025,,56.1905,43.9376,ADS-B,,CL60
  60. 2023-06-22 15:00,1506AD,Russia,NWC9042,RA-67245,CL60,2113,3875,266,59.7614,30.9496,ADS-B,,CL60
  61. 2023-06-22 14:00,1506A7,Russia,SSF229,RA-67239,CRJ2,2324,30000,,60.994,38.4331,Other,,CRJ2
  62. 2023-06-22 14:00,14F116,Russia,71683,RA-61718,A148,4465,2300,,55.8092,38.2118,ADS-B,,A148
  63. 2023-06-22 13:00,142AFA,Russia,MMM9621,RA-11002,GLF4,5510,40000,464,56.2056,45.0717,ADS-B,,GLF4
  64. 2023-06-22 13:00,142582,Russia,GZP9615,RA-09602,FA7X,745,37000,494,55.4126,44.7872,ADS-B,,FA7X
  65. 2023-06-22 13:00,140ACA,Russia,RA02762,RA-02762,H25B,1503,35000,360,57.8286,49.6346,Other,,H25B
  66. 2023-06-22 13:00,14062A,Russia,RA01578,RA-01578,PC12,4151,29000,290,55.7497,52.3826,Other,,PC12
  67. 2023-06-22 13:00,14F116,Russia,71683,RA-61718,A148,4465,20975,348,59.6925,30.4655,ADS-B,,A148
  68. 2023-06-22 12:00,14062A,Russia,,RA-01578,PC12,,38075,,54.2859,48.2318,Other,,PC12
  69. 2023-06-22 12:00,150661,Russia,RLA7778,RA-67169,CL60,601,37975,462,55.8494,44.3001,ADS-B,,CL60
  70. 2023-06-22 11:00,14F116,Russia,,RA-61718,A148,,13625,298,59.6793,31.0293,ADS-B,,A148
  71. 2023-06-22 10:00,14F116,Russia,71683,RA-61718,A148,2116,4375,,55.9614,37.976,ADS-B,,A148
  72. 2023-06-22 09:00,683277,Kazakhstan,EAK5180,UP-EM018,E35L,2744,31000,441,53.2254,45.3059,ADS-B,,E35L
  73. 2023-06-22 09:00,5100E9,Belarus,BYS797,EW-502LL,PC12,2756,16225,257,54.2615,29.3072,ADS-B,,PC12
  74. 2023-06-22 05:00,1506A9,Russia,,RA-67241,GLEX,,41000,506,57.8539,50.0456,Other,,GLEX
  75. 2023-06-22 00:00,06A1D9,Qatar,QQE721,A7-CGU,GLF6,3707,45000,510,56.1228,54.6072,Other,,GLF6
  76. 2023-06-21 21:00,142329,Russia,GZP9633,RA-09001,F900,4143,1475,174,59.8212,30.0752,ADS-B,,F900
  77. 2023-06-21 16:00,151F11,Russia,SBI1158,RA-73489,,5554,38000,456,56.5764,46.708,ADS-B,,
  78. 2023-06-21 16:00,140B40,Russia,,RA-02880,E35L,,12400,320,55.5455,48.7265,ADS-B,,E35L
  79. 2023-06-21 15:00,14F11B,Russia,,RA-61723,A148,,32000,412,55.8667,42.7331,ADS-B,,A148
  80. 2023-06-21 15:00,460603,Finland,JSM550,OH-CHF,C550,223,16875,240,62.3499,29.2726,ADS-B,,C550
  81. 2023-06-21 14:00,1506A9,Russia,,RA-67241,GLEX,,43000,494,55.8683,42.1373,ADS-B,,GLEX
  82. 2023-06-21 13:00,142329,Russia,,RA-09001,F900,,23200,454,52.7733,45.1091,ADS-B,,F900
  83. 2023-06-21 13:00,1803E8,Russia,RA1000G,RA-1000G,C172,3132,ground,,61.6587,50.8522,Other,,C172
  84. 2023-06-21 12:00,150690,Russia,,RA-67216,CL60,,35000,473,56.0895,43.6166,ADS-B,,CL60
  85. 2023-06-21 12:00,14F117,Russia,47474,RA-61719,A148,1510,34000,470,51.2442,44.4151,ADS-B,,A148
  86. 2023-06-21 11:00,762AF3,Pakistan,PFF2,J-755,GLF4,176,43000,434,54.8605,33.8878,ADS-B,,GLF4
  87. 2023-06-21 10:00,762AF3,Pakistan,,J-755,GLF4,,40000,428,52.8436,45.4136,ADS-B,,GLF4
  88. 2023-06-21 10:00,68332F,Kazakhstan,EAK5121,UP-EM024,E35L,2763,37000,,52.6873,47.217,Other,,E35L
  89. 2023-06-21 10:00,150600,Russia,OAO542,RA-67072,L410,6166,950,142,61.2701,46.6396,ADS-B,,L410
  90. 2023-06-21 09:00,150600,Russia,,RA-67072,L410,,8975,175,61.8789,45.6341,ADS-B,,L410
  91. 2023-06-21 08:00,151F11,Russia,SBI2508,RA-73489,,5217,36000,464,55.6146,41.9526,ADS-B,,
  92. 2023-06-21 06:00,150641,Russia,RFE9737,RA-67137,CL35,4160,39975,,55.3729,50.3871,ADS-B,,CL35
  93. 2023-06-21 04:00,151D40,Russia,UTA364,RA-73024,,4167,35975,436,55.8126,45.8394,ADS-B,,
  94. 2023-06-21 02:00,150656,Russia,UVT222,RA-67158,CRJ2,6735,24300,340,56.0498,50.6007,Other,,CRJ2
  95. 2023-06-20 18:00,1506A7,Russia,SSF184,RA-67239,CRJ2,5522,32950,467,57.9438,55.8575,Other,,CRJ2
  96. 2023-06-20 17:00,151F4E,Russia,RSJ9650,RA-73550,GLEX,2137,5600,262,59.6077,30.1902,ADS-B,,GLEX
  97. 2023-06-20 16:00,1506A7,Russia,SSF184,RA-67239,CRJ2,2310,33000,384,57.9915,55.6601,Other,,CRJ2
  98. 2023-06-20 15:00,140B2A,Russia,JSI9162,RA-02858,E35L,5441,38000,438,56.6416,47.1381,ADS-B,,E35L
  99. 2023-06-20 15:00,1506A7,Russia,SSF184,RA-67239,CRJ2,2310,33000,437,59.7238,43.0218,ADS-B,,CRJ2
  100. 2023-06-20 14:00,1506A9,Russia,NWC9021,RA-67241,GLEX,1536,40975,518,55.3719,47.7343,ADS-B,,GLEX
  101. 2023-06-20 14:00,14F124,Russia,71682,RA-61732,A148,2306,17725,316,56.6858,37.1982,ADS-B,,A148
  102. 2023-06-20 13:00,142582,Russia,GZP9627,RA-09602,FA7X,2160,26625,387,59.0411,31.92,ADS-B,,FA7X
  103. 2023-06-20 13:00,1506A7,Russia,SSF183,RA-67239,CRJ2,5516,26350,380,61.0749,36.2852,Other,,CRJ2
  104. 2023-06-20 13:00,150660,Russia,RLA9611,RA-67168,CL60,2733,9050,258,59.5793,30.2843,ADS-B,,CL60
  105. 2023-06-20 13:00,DDE4DC,Unassigned (reserved for future use),,,,,1675,49,61.2497,28.9175,Other,,
  106. 2023-06-20 12:00,14F11C,Russia,71680,RA-61724,A148,2741,32975,,56.2002,55.5431,Other,,A148
  107. 2023-06-20 12:00,1506A7,Russia,SSF183,RA-67239,CRJ2,5516,32000,451,59.0345,50.0226,Other,,CRJ2
  108. 2023-06-20 11:00,06A1CD,Qatar,QQE534,A7-CGH,GLF6,5276,43000,518,61.7311,45.3726,ADS-B,,GLF6
  109. 2023-06-20 11:00,14F110,Russia,47473,RA-61712,A148,2752,33000,,56.0964,43.2832,ADS-B,,A148
  110. 2023-06-20 11:00,14F11C,Russia,71680,RA-61724,A148,2741,33000,460,56.1595,42.7499,ADS-B,,A148
  111. 2023-06-20 11:00,14F116,Russia,,RA-61718,A148,,32025,338,55.6947,41.9455,ADS-B,,A148
  112. 2023-06-20 09:00,1506A7,Russia,SSF181,RA-67239,CRJ2,5735,32450,435,58.7719,48.8819,Other,,CRJ2
  113. 2023-06-20 05:00,14F116,Russia,,RA-61718,A148,,31025,452,53.9264,48.8743,ADS-B,,A148
  114. 2023-06-19 18:00,1506AC,Russia,,RA-67244,CRJ2,,32025,412,55.8367,43.9929,ADS-B,,CRJ2
  115. 2023-06-19 17:00,150658,Russia,RA67160,RA-67160,GLEX,6733,38000,475,55.8193,45.4393,ADS-B,,GLEX
  116. 2023-06-19 15:00,68332F,Kazakhstan,EAK5121,UP-EM024,E35L,2772,37000,493,53.4381,45.2541,ADS-B,,E35L
  117. 2023-06-19 15:00,1506A8,Russia,,RA-67240,CRJ2,,29000,268,60.6928,38.3984,ADS-B,,CRJ2
  118. 2023-06-19 15:00,14F115,Russia,,RA-61717,A148,,700,,55.5314,38.1849,ADS-B,,A148
  119. 2023-06-19 14:00,0088B8,South Africa,,ZS-ZBB,E35L,,25000,446,53.7082,43.7165,ADS-B,,E35L
  120. 2023-06-19 14:00,141E9F,Russia,RA07839,RA-07839,TB21,5540,3600,130,55.4144,52.9504,Other,,TB21
  121. 2023-06-19 13:00,15069E,Russia,SSF51,RA-67230,CRJ2,5736,32000,339,62.4077,36.7472,ADS-B,,CRJ2
  122. 2023-06-19 12:00,1506A0,Russia,,RA-67232,CRJ2,,34025,438,52.7626,47.0598,ADS-B,,CRJ2
  123. 2023-06-19 12:00,141CAF,Russia,RA07343,RA-07343,EC45,7000,350,64,59.8838,30.5415,ADS-B,,EC45
  124. 2023-06-19 09:00,140AE9,Russia,,RA-02793,H25B,,750,153,55.6088,37.2747,ADS-B,,H25B
  125. 2023-06-19 08:00,14232B,Russia,,RA-09003,F900,,35000,469,58.1539,53.9921,Other,,F900
  126. 2023-06-19 08:00,143D17,Russia,,RA-15639,,,950,102,54.4633,39.5846,ADS-B,,
  127. 2023-06-19 07:00,15069E,Russia,,RA-67230,CRJ2,,19150,317,61.4594,34.9853,ADS-B,,CRJ2
  128. 2023-06-19 06:00,142584,Russia,NWC9001,RA-09604,FA7X,2760,39000,515,57.9354,55.4223,Other,,FA7X
  129. 2023-06-19 06:00,1427EE,Russia,SBI8506,RA-10222,GLF5,721,37000,,58.9779,33.1063,ADS-B,,GLF5
  130. 2023-06-19 06:00,151F3F,Russia,DXT9635,RA-73535,CRJ2,2141,35000,,56.0899,45.7702,ADS-B,,CRJ2
  131. 2023-06-19 05:00,14232B,Russia,GZP9602,RA-09003,F900,5265,36000,430,56.7566,39.3787,ADS-B,,F900
  132. 2023-06-19 05:00,1506A8,Russia,SSF119,RA-67240,CRJ2,5736,27800,431,60.0452,32.4485,ADS-B,,CRJ2
  133. 2023-06-19 05:00,1427EE,Russia,SBI8505,RA-10222,GLF5,1513,16775,295,59.3819,30.9995,ADS-B,,GLF5
  134. 2023-06-19 04:00,14232B,Russia,GZP9602,RA-09003,F900,5265,36000,439,56.8293,52.3777,Other,,F900
  135. 2023-06-19 04:00,1506AC,Russia,,RA-67244,CRJ2,,31000,448,56.0475,43.608,ADS-B,,CRJ2
  136. 2023-06-19 03:00,14F115,Russia,SUM9607,RA-61717,A148,2712,1850,,55.5308,38.1862,ADS-B,,A148
  137. 2023-06-19 01:00,140AC5,Russia,DXT9657,RA-02757,E35L,2060,38000,407,51.4227,50.7298,ADS-B,,E35L
  138. 2023-06-24 11:00,142AFA,Russia,MMM9628,RA-11002,GLF4,5335,36450,460,56.7468,49.5933,Other,,GLF4
  139. 2023-06-24 11:00,151F39,Russia,,RA-73529,GLEX,,975,165,55.5871,37.2423,ADS-B,,GLEX
  140. 2023-06-24 12:00,1506A0,Russia,RFE9724,RA-67232,CRJ2,1523,33000,518,56.0529,44.9962,ADS-B,,CRJ2
  141. 2023-06-24 13:00,1506A9,Russia,,RA-67241,GLEX,,40975,500,57.8264,48.8128,Other,,GLEX
  142. 2023-06-24 17:00,150692,Russia,,RA-67218,CRJ2,,36000,398,56.2796,44.5829,ADS-B,,CRJ2
  143. 2023-06-24 19:00,14F115,Russia,SUM9108,RA-61717,A148,1076,6975,,55.0151,38.8127,ADS-B,,A148
  144. 2023-06-24 20:00,14F124,Russia,71681,RA-61732,A148,2131,9125,302,55.6535,38.4769,ADS-B,,A148
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement