aircraft
4,898 rows sorted by lon
This data as json, CSV (advanced)
Suggested facets: timestamp (date)
id | timestamp | hex | squawk | flight | lat | lon ▼ | altitude_in_ft | vert_rate_in_ft_per_minute | track_in_degrees | speed_in_mph | origin_lat | origin_lon | distance_in_m |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4410 | 2019-08-09 19:44:43.374936 | 4911EC | 5352 | VVV664 | 51.155502 | 4.437808 | 2925 | -1280 | 40 | 245 | 51.1552335 | 4.452079 | 998 |
5177 | 2021-01-25 10:20:40.498311 | 44D841 | 2000 | OOVBA | 51.155182 | 4.437808 | 700 | -128 | 171 | 91 | 51.1552335 | 4.452079 | 998 |
4484 | 2019-09-07 12:44:57.882413 | 49528C | 1000 | TAP648L | 51.155823 | 4.437883 | 4750 | -512 | 99 | 243 | 51.1552335 | 4.452079 | 995 |
3708 | 2018-06-24 13:59:45.422121 | 44D841 | 2000 | OOVBA | 51.154904 | 4.437943 | 600 | -256 | 46 | 86 | 51.1552335 | 4.452079 | 989 |
6098 | 2022-02-24 13:47:53.150446 | 448C6A | 1000 | OOCCJ | 51.154066 | 4.437943 | 2150 | -64 | 78 | 211 | 51.1552335 | 4.452079 | 997 |
6522 | 2022-08-03 09:49:04.433101 | 44CE85 | 7000 | OOSTE | 51.155649 | 4.437943 | 850 | 0 | 38 | 145 | 51.1552335 | 4.452079 | 990 |
3497 | 2018-01-18 14:31:50.308518 | 44B824 | 5616 | FYG194 | 51.155319 | 4.437957 | 2000 | 0 | 110 | 208 | 51.1552335 | 4.452079 | 988 |
4938 | 2020-08-06 21:45:19.79514 | 3C70AE | 5375 | BCS8049 | 51.156281 | 4.437957 | 4350 | -960 | 37 | 199 | 51.1552335 | 4.452079 | 994 |
6917 | 2022-12-19 12:24:06.904075 | 44CDCB | 3420 | BEL1LH | 51.154587 | 4.437957 | 3950 | 0 | 84 | 265 | 51.1552335 | 4.452079 | 990 |
5174 | 2021-01-21 22:12:18.283399 | 3C70AF | 1000 | BCS1929 | 51.156394 | 4.438019 | 5575 | -1920 | 78 | 345 | 51.1552335 | 4.452079 | 992 |
5697 | 2021-09-06 10:26:58.208573 | 44CE85 | 6304 | OOSTE | 51.154951 | 4.438019 | 1225 | 0 | 23 | 130 | 51.1552335 | 4.452079 | 984 |
7524 | 2023-07-18 16:15:02.181393 | 44CD75 | 2000 | OOSKU | 51.155463 | 4.438019 | 900 | -64 | 10 | 96 | 51.1552335 | 4.452079 | 984 |
7654 | 2023-09-30 17:12:12.660762 | 448ED2 | 2000 | OOCVR | 51.156254 | 4.438019 | 1150 | -64 | 179 | 101 | 51.1552335 | 4.452079 | 990 |
4293 | 2019-06-17 16:47:22.869459 | A1CC8D | 1000 | N215EV | 51.154129 | 4.438031 | 1300 | -448 | 131 | 134 | 51.1552335 | 4.452079 | 990 |
5600 | 2021-07-27 10:00:30.688769 | 44D0A1 | 5373 | JAF1EL | 51.153854 | 4.438031 | 1700 | -192 | 88 | 195 | 51.1552335 | 4.452079 | 994 |
7117 | 2023-04-22 08:21:26.585435 | 4486F4 | 7000 | OOAWT | 51.156876 | 4.438031 | 1700 | -128 | 32 | 110 | 51.1552335 | 4.452079 | 999 |
7850 | 2023-12-15 13:24:33.247467 | A8164D | 6307 | FALCO | 51.156921 | 4.438031 | 200 | 64 | 20 | 135 | 51.1552335 | 4.452079 | 1000 |
5625 | 2021-08-11 16:45:02.767198 | 4D0261 | 1000 | FYL85GF | 51.155928 | 4.438095 | 1875 | 256 | 95 | 213 | 51.1552335 | 4.452079 | 981 |
7538 | 2023-07-21 20:14:52.232585 | 44D0A1 | 1000 | JAF1HA | 51.155602 | 4.438095 | 2525 | -256 | 76 | 217 | 51.1552335 | 4.452079 | 979 |
7799 | 2023-11-12 14:03:06.766299 | 4494E8 | 2000 | OOEGH | 51.15402 | 4.438095 | 1000 | 0 | 147 | 73 | 51.1552335 | 4.452079 | 987 |
3859 | 2018-09-28 05:25:02.389565 | 44C06B | 5160 | OOPCK | 51.15477 | 4.438105 | 875 | -1344 | 63 | 149 | 51.1552335 | 4.452079 | 979 |
4231 | 2019-05-23 11:34:41.718965 | 44A8AD | 1001 | JAF61X | 51.155136 | 4.438105 | 1625 | -64 | 116 | 194 | 51.1552335 | 4.452079 | 977 |
6093 | 2022-02-17 16:26:35.323938 | 44AD2E | 2023 | FYG75N | 51.156006 | 4.438105 | 1550 | -64 | 115 | 195 | 51.1552335 | 4.452079 | 981 |
6305 | 2022-04-10 17:08:01.943123 | 3E47C9 | 1000 | ECA2JP | 51.154266 | 4.438105 | 2675 | -512 | 103 | 202 | 51.1552335 | 4.452079 | 983 |
6728 | 2022-10-08 13:34:48.923453 | 44D86C | 2000 | OOVCL | 51.153854 | 4.438105 | 1075 | -320 | 19 | 96 | 51.1552335 | 4.452079 | 989 |
7622 | 2023-09-19 15:02:39.60197 | A2AB4F | 1000 | N271MJ | 51.155869 | 4.438105 | 3100 | 1280 | 173 | 75 | 51.1552335 | 4.452079 | 980 |
7914 | 2024-01-27 13:18:20.017748 | 484B40 | 7000 | PHSRP | 51.156326 | 4.438105 | 400 | 0 | 16 | 89 | 51.1552335 | 4.452079 | 985 |
3468 | 2017-12-07 14:05:09.113078 | 44CE68 | 1000 | BEL3714 | 51.153182 | 4.438171 | 4850 | -448 | 46 | 297 | 51.1552335 | 4.452079 | 999 |
4657 | 2019-12-14 19:09:54.509831 | 44A8AD | 1000 | JAF8MY | 51.155696 | 4.438171 | 2400 | 448 | 106 | 224 | 51.1552335 | 4.452079 | 974 |
4850 | 2020-07-02 10:54:31.984294 | 448423 | 2000 | OOAAC | 51.155277 | 4.438171 | 1300 | 576 | 33 | 115 | 51.1552335 | 4.452079 | 973 |
3305 | 2017-07-08 09:28:30.496629 | 44D0A1 | 5511 | JAF1CT | 51.154587 | 4.43818 | 1875 | -256 | 113 | 160 | 51.1552335 | 4.452079 | 975 |
4229 | 2019-05-22 15:51:47.107884 | A0CBEC | 7000 | N150TV | 51.155457 | 4.43818 | 1000 | 0 | 106 | 82 | 51.1552335 | 4.452079 | 972 |
4800 | 2020-04-06 08:58:12.924067 | 449D8D | 1174 | OOGLM | 51.154861 | 4.43818 | 1950 | -256 | 109 | 204 | 51.1552335 | 4.452079 | 973 |
6946 | 2023-01-06 17:49:17.959796 | ABF09B | 1000 | N869DK | 51.153854 | 4.43818 | 2450 | -960 | 30 | 238 | 51.1552335 | 4.452079 | 984 |
3519 | 2018-02-13 11:54:26.727566 | 44CE75 | 4740 | BEL69C | 51.152949 | 4.438248 | 4925 | -640 | 99 | 290 | 51.1552335 | 4.452079 | 1000 |
3580 | 2018-03-30 12:30:20.908756 | 44D068 | 1000 | BEL3722 | 51.15658 | 4.438248 | 4525 | -704 | 117 | 204 | 51.1552335 | 4.452079 | 979 |
5475 | 2021-06-09 15:23:07.455113 | 448C42 | 2000 | OOCBB | 51.154206 | 4.438248 | 750 | -64 | 5 | 111 | 51.1552335 | 4.452079 | 974 |
6339 | 2022-04-20 10:58:08.192546 | 44A0B9 | 2000 | OOHEY | 51.157325 | 4.438248 | 1200 | 0 | 9 | 92 | 51.1552335 | 4.452079 | 995 |
6683 | 2022-09-04 17:29:43.5409 | 4D0261 | 1000 | FYL62GF | 51.154113 | 4.438248 | 1750 | -832 | 108 | 170 | 51.1552335 | 4.452079 | 975 |
7124 | 2023-04-24 12:05:25.333578 | 44D0A1 | 5551 | JAF4CK | 51.155789 | 4.438248 | 2800 | -448 | 98 | 192 | 51.1552335 | 4.452079 | 969 |
8012 | 2024-03-15 09:33:11.396024 | 39B146 | 2000 | FHMKG | 51.156254 | 4.438248 | 950 | -320 | 19 | 109 | 51.1552335 | 4.452079 | 974 |
3226 | 2017-05-19 18:40:00.686634 | 44A8AD | 5127 | JAF578 | 51.15303 | 4.438254 | 2950 | 64 | 108 | 197 | 51.1552335 | 4.452079 | 997 |
4499 | 2019-09-15 10:07:49.546029 | 44D0A1 | 5354 | JAF4CP | 51.154266 | 4.438254 | 2200 | -1152 | 111 | 244 | 51.1552335 | 4.452079 | 973 |
5458 | 2021-06-06 11:58:36.725591 | 44CA0F | 2000 | OORPO | 51.154633 | 4.438254 | 700 | 192 | 14 | 97 | 51.1552335 | 4.452079 | 969 |
6516 | 2022-07-31 18:14:15.228499 | 4491E3 | 1000 | OODOC | 51.156601 | 4.438254 | 1400 | 0 | 114 | 192 | 51.1552335 | 4.452079 | 979 |
6517 | 2022-08-01 09:46:33.206026 | 44CC4F | 1000 | FYG31S | 51.156326 | 4.438254 | 3200 | 960 | 96 | 197 | 51.1552335 | 4.452079 | 974 |
6925 | 2022-12-26 11:25:12.030184 | A1CC8D | 1000 | N215EV | 51.153168 | 4.438254 | 1425 | -832 | 108 | 161 | 51.1552335 | 4.452079 | 994 |
8116 | 2024-04-26 18:28:35.573714 | 3E175B | 1000 | AZE13YS | 51.156281 | 4.438254 | 4050 | 1728 | 126 | 158 | 51.1552335 | 4.452079 | 974 |
3447 | 2017-11-03 10:45:13.991849 | 44AAC1 | 5530 | JAF60Z | 51.15658 | 4.438324 | 1975 | -512 | 118 | 188 | 51.1552335 | 4.452079 | 973 |
3568 | 2018-03-20 19:02:03.579267 | 402B27 | 7000 | GBOOL | 51.156347 | 4.438324 | 1300 | 192 | 178 | 118 | 51.1552335 | 4.452079 | 970 |
3798 | 2018-08-18 09:36:14.916802 | 44D0A1 | 5521 | JAF23E | 51.152809 | 4.438324 | 1400 | -192 | 105 | 190 | 51.1552335 | 4.452079 | 999 |
4409 | 2019-08-08 18:17:48.563028 | 44AAC1 | 1000 | JAF3VE | 51.155742 | 4.438324 | 1925 | -448 | 110 | 229 | 51.1552335 | 4.452079 | 963 |
5834 | 2021-10-14 16:28:15.447421 | 44D1F9 | 2000 | OOTOY | 51.156766 | 4.438324 | 700 | 0 | 25 | 121 | 51.1552335 | 4.452079 | 977 |
6606 | 2022-08-20 16:54:59.746139 | 3924A0 | 5155 | ASR982 | 51.153508 | 4.438324 | 1325 | -1152 | 66 | 204 | 51.1552335 | 4.452079 | 981 |
3566 | 2018-03-20 18:31:46.608993 | 402B27 | 7000 | GBOOL | 51.157516 | 4.438328 | 1200 | 64 | 126 | 84 | 51.1552335 | 4.452079 | 994 |
4887 | 2020-07-18 18:26:38.055851 | 44A8AD | 1000 | JAF64D | 51.15596 | 4.438328 | 1775 | -256 | 103 | 213 | 51.1552335 | 4.452079 | 965 |
5608 | 2021-07-31 05:56:10.686665 | 4858C7 | 1000 | JNL0999 | 51.156967 | 4.438328 | 3100 | 704 | 126 | 229 | 51.1552335 | 4.452079 | 981 |
5760 | 2021-09-21 11:38:28.302026 | 44CE86 | 2000 | OOSTF | 51.154861 | 4.438328 | 625 | -256 | 59 | 102 | 51.1552335 | 4.452079 | 962 |
6172 | 2022-03-11 16:29:12.999639 | 345643 | 5362 | VLG38SF | 51.155594 | 4.438328 | 4025 | -1280 | 99 | 229 | 51.1552335 | 4.452079 | 962 |
4029 | 2018-12-21 15:29:58.26848 | 484173 | 7133 | PHDIX | 51.156347 | 4.4384 | 3500 | 1344 | 154 | 150 | 51.1552335 | 4.452079 | 964 |
5665 | 2021-08-27 13:43:39.246655 | 44CE83 | 2000 | OOSTC | 51.15402 | 4.4384 | 500 | 128 | 28 | 64 | 51.1552335 | 4.452079 | 966 |
5980 | 2021-12-31 12:04:12.660766 | 448ED2 | 2000 | OOCVR | 51.155137 | 4.4384 | 1325 | 768 | 22 | 85 | 51.1552335 | 4.452079 | 957 |
7042 | 2023-03-03 14:01:29.832067 | 44D872 | 2000 | OOVCR | 51.154392 | 4.4384 | 775 | 0 | 0 | 84 | 51.1552335 | 4.452079 | 961 |
3898 | 2018-10-21 21:54:59.796668 | 44CE66 | 1000 | BEL22X | 51.154083 | 4.438402 | 4100 | -2112 | 94 | 276 | 51.1552335 | 4.452079 | 965 |
5019 | 2020-09-13 21:16:18.894122 | 44CDCC | 1000 | BEL36T | 51.155228 | 4.438402 | 4275 | -1216 | 69 | 254 | 51.1552335 | 4.452079 | 956 |
5104 | 2020-11-03 14:47:30.02354 | A63B7C | 1000 | N500RW | 51.155548 | 4.438402 | 1225 | -832 | 74 | 191 | 51.1552335 | 4.452079 | 957 |
6131 | 2022-03-02 14:05:44.352307 | 44CE86 | 2000 | OOSTF | 51.153625 | 4.438402 | 800 | -192 | 137 | 81 | 51.1552335 | 4.452079 | 973 |
6720 | 2022-09-28 01:07:31.926799 | 451D99 | 2003 | BCS453 | 51.156097 | 4.438402 | 5875 | -1152 | 101 | 295 | 51.1552335 | 4.452079 | 961 |
3213 | 2017-05-12 18:53:36.227814 | 44A8AD | 5323 | JAF5VD | 51.154392 | 4.438477 | 2550 | -640 | 88 | 235 | 51.1552335 | 4.452079 | 956 |
3245 | 2017-05-31 11:11:49.305229 | 44D0A1 | 2322 | JAF7WH | 51.156647 | 4.438477 | 1450 | -384 | 98 | 198 | 51.1552335 | 4.452079 | 964 |
3511 | 2018-02-06 14:02:23.051322 | 440261 | 7000 | OEFDI | 51.155183 | 4.438477 | 800 | -64 | 11 | 96 | 51.1552335 | 4.452079 | 951 |
3624 | 2018-04-26 13:27:42.394236 | 44BC61 | 5113 | OOOCA | 51.155975 | 4.438477 | 1825 | -512 | 102 | 219 | 51.1552335 | 4.452079 | 955 |
3664 | 2018-05-27 11:18:23.528266 | 44D841 | 2000 | OOVBA | 51.155045 | 4.438477 | 900 | -64 | 45 | 88 | 51.1552335 | 4.452079 | 951 |
3685 | 2018-06-07 12:42:29.067046 | 44D0A1 | 5507 | 51.152809 | 4.438477 | 1500 | -768 | 100 | 190 | 51.1552335 | 4.452079 | 989 | |
4339 | 2019-07-10 11:36:58.270156 | 44A8A2 | 5353 | 51.152483 | 4.438477 | 1450 | 448 | 98 | 180 | 51.1552335 | 4.452079 | 999 | |
4369 | 2019-07-26 21:01:30.926233 | 44D0A1 | 1000 | JAF322 | 51.153228 | 4.438477 | 3175 | -64 | 135 | 208 | 51.1552335 | 4.452079 | 977 |
4854 | 2020-07-05 17:35:25.234449 | 44CE85 | 6303 | OOSTE | 51.154037 | 4.438477 | 1200 | -384 | 36 | 168 | 51.1552335 | 4.452079 | 960 |
5398 | 2021-05-19 12:48:18.741616 | 4855A3 | 5554 | PHCJM | 51.154904 | 4.438477 | 1450 | -256 | 94 | 166 | 51.1552335 | 4.452079 | 952 |
6402 | 2022-07-08 19:30:38.307249 | 44CD75 | 2000 | OOSKU | 51.15388 | 4.438477 | 550 | 64 | 44 | 88 | 51.1552335 | 4.452079 | 963 |
7542 | 2023-07-25 08:41:40.950367 | 43E7A0 | 3412 | MARTY | 51.154678 | 4.438477 | 1400 | -832 | 102 | 188 | 51.1552335 | 4.452079 | 953 |
7797 | 2023-11-10 16:57:32.556582 | 44D068 | 1000 | BEL3HE | 51.156254 | 4.438477 | 5575 | -2176 | 44 | 295 | 51.1552335 | 4.452079 | 958 |
8055 | 2024-04-01 10:36:07.991990 | 449682 | 1000 | JAF2EW | 51.153122 | 4.438477 | 2975 | -640 | 85 | 209 | 51.1552335 | 4.452079 | 980 |
4252 | 2019-06-01 17:53:14.070871 | 44D0A1 | 1000 | JAF3VE | 51.155823 | 4.438551 | 2150 | -576 | 109 | 222 | 51.1552335 | 4.452079 | 948 |
4794 | 2020-03-29 08:38:30.142811 | 44D88D | 7000 | OOVDM | 51.153351 | 4.438551 | 600 | -576 | 154 | 118 | 51.1552335 | 4.452079 | 969 |
5558 | 2021-07-09 20:16:57.438602 | 44D0A1 | 1000 | JAF696 | 51.156967 | 4.438551 | 2300 | -576 | 106 | 211 | 51.1552335 | 4.452079 | 965 |
5639 | 2021-08-17 11:41:40.306424 | 503CB8 | 1000 | KLJ3006 | 51.158112 | 4.438551 | 2275 | 640 | 165 | 180 | 51.1552335 | 4.452079 | 999 |
6807 | 2022-11-06 15:55:45.874679 | 44B1B0 | 1000 | AAB977 | 51.152847 | 4.438551 | 5150 | -1344 | 86 | 267 | 51.1552335 | 4.452079 | 983 |
3354 | 2017-08-06 16:19:57.685571 | A1777B | 7000 | N194ER | 51.154718 | 4.438553 | 750 | 64 | 58 | 176 | 51.1552335 | 4.452079 | 948 |
3365 | 2017-08-20 04:42:18.610091 | 44D0A1 | 2334 | JAF7LG | 51.156254 | 4.438553 | 1875 | -768 | 109 | 178 | 51.1552335 | 4.452079 | 953 |
4098 | 2019-03-08 10:39:55.562923 | 44A8A2 | 5522 | JAF9PC | 51.155044 | 4.438553 | 1750 | -256 | 99 | 212 | 51.1552335 | 4.452079 | 946 |
4432 | 2019-08-17 17:02:01.775806 | 406798 | 7000 | GAWWO | 51.153554 | 4.438553 | 1325 | 0 | 13 | 95 | 51.1552335 | 4.452079 | 964 |
4463 | 2019-08-28 05:13:18.929994 | 44CCC2 | 0533 | 51.158116 | 4.438553 | 6150 | -1152 | 110 | 283 | 51.1552335 | 4.452079 | 999 | |
4867 | 2020-07-14 04:32:58.605298 | A05629 | 1143 | UAL950 | 51.155323 | 4.438553 | 5675 | -1344 | 87 | 251 | 51.1552335 | 4.452079 | 946 |
6886 | 2022-12-13 14:16:20.490773 | 485C5B | 2000 | PHKIO | 51.153368 | 4.438553 | 1475 | -832 | 17 | 125 | 51.1552335 | 4.452079 | 968 |
7228 | 2023-05-26 14:39:17.623066 | 4488B4 | 2000 | OOBET | 51.156301 | 4.438553 | 1000 | -256 | 12 | 75 | 51.1552335 | 4.452079 | 953 |
3441 | 2017-10-26 12:54:19.532334 | 484F50 | 5137 | FYG75V | 51.154312 | 4.438625 | 3475 | -1280 | 31 | 226 | 51.1552335 | 4.452079 | 946 |
3954 | 2018-11-12 14:19:46.237819 | 44846F | 2333 | OOACO | 51.156693 | 4.438625 | 1475 | 0 | 114 | 158 | 51.1552335 | 4.452079 | 955 |
4843 | 2020-06-27 09:36:42.871122 | 44D841 | 2000 | OOVBA | 51.157471 | 4.438625 | 900 | 64 | 191 | 65 | 51.1552335 | 4.452079 | 973 |
5831 | 2021-10-14 09:31:30.893777 | 44A8AD | 5527 | JAF1EL | 51.157013 | 4.438625 | 3100 | -1024 | 104 | 253 | 51.1552335 | 4.452079 | 961 |
6830 | 2022-11-11 09:35:14.483137 | 44CA0F | 5172 | OORPO | 51.152298 | 4.438625 | 525 | -64 | 29 | 93 | 51.1552335 | 4.452079 | 996 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE aircraft ( id INTEGER PRIMARY KEY, timestamp TEXT NOT NULL, hex TEXT, squawk TEXT, flight TEXT, lat REAL, lon REAL, altitude_in_ft INTEGER, vert_rate_in_ft_per_minute INTEGER, track_in_degrees INTEGER, speed_in_mph INTEGER, origin_lat REAL, origin_lon REAL, distance_in_m INTEGER );