aircraft
4,898 rows sorted by track_in_degrees
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3832 | 2018-09-10 14:25:07.064101 | 44AA58 | 7000 | OOJRX | 51.150016 | 4.449844 | 700 | -320 | 0 | 121 | 51.1552335 | 4.452079 | 601 |
4352 | 2019-07-16 09:32:38.713481 | 44BC61 | 1000 | 51.162506 | 4.448275 | 1300 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 851 | |
5010 | 2020-09-10 11:53:32.094501 | 44D841 | 2000 | OOVBA | 51.147995 | 4.455773 | 700 | 128 | 0 | 90 | 51.1552335 | 4.452079 | 845 |
5257 | 2021-03-24 14:03:05.942423 | 406A98 | 2000 | GOXFA | 51.150761 | 4.441833 | 875 | -256 | 0 | 126 | 51.1552335 | 4.452079 | 872 |
5540 | 2021-07-05 16:18:20.909413 | 44C06D | 2000 | OOPCM | 51.150295 | 4.447708 | 1200 | 256 | 0 | 138 | 51.1552335 | 4.452079 | 628 |
5672 | 2021-08-29 09:04:20.438142 | 39B415 | 1000 | CALIBRA | 51.14983 | 4.44725 | 6000 | 64 | 0 | 204 | 51.1552335 | 4.452079 | 689 |
5743 | 2021-09-16 16:50:35.538544 | 48463D | 6366 | 51.162872 | 4.456515 | 1100 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 904 | |
5745 | 2021-09-16 16:55:39.935244 | 48463D | 6366 | PHKOK | 51.152252 | 4.465497 | 375 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 995 |
5821 | 2021-10-11 15:13:41.483379 | 448423 | 7000 | OOAAC | 51.149048 | 4.44538 | 800 | -64 | 0 | 99 | 51.1552335 | 4.452079 | 832 |
6327 | 2022-04-16 09:17:38.386564 | 4043BA | 7000 | 51.160263 | 4.46082 | 1000 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 828 | |
6506 | 2022-07-30 05:33:18.825804 | 4864BD | 6363 | PHVIT | 51.163239 | 4.446048 | 1300 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 985 |
6507 | 2022-07-30 05:38:21.668975 | 4864BD | 6363 | PHVIT | 51.15358 | 4.459113 | 1475 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 525 |
6659 | 2022-08-29 13:08:14.14779 | 448423 | 2000 | OOAAC | 51.148453 | 4.447459 | 825 | 128 | 0 | 89 | 51.1552335 | 4.452079 | 820 |
6918 | 2022-12-20 11:06:46.480237 | 44A0B9 | 7000 | OOHEY | 51.147675 | 4.44976 | 800 | -192 | 0 | 114 | 51.1552335 | 4.452079 | 856 |
7042 | 2023-03-03 14:01:29.832067 | 44D872 | 2000 | OOVCR | 51.154392 | 4.4384 | 775 | 0 | 0 | 84 | 51.1552335 | 4.452079 | 961 |
7101 | 2023-04-17 11:43:24.082795 | 44A0B9 | 7000 | OOHEY | 51.14699 | 4.447174 | 600 | 192 | 0 | 100 | 51.1552335 | 4.452079 | 979 |
7526 | 2023-07-18 18:49:12.50695 | 4489D4 | 6367 | OOBNT | 51.164017 | 4.451764 | 225 | 0 | 0 | 1 | 51.1552335 | 4.452079 | 977 |
7647 | 2023-09-28 09:46:20.528864 | 44CA0F | 2000 | OORPO | 51.14978 | 4.443079 | 1250 | 192 | 0 | 100 | 51.1552335 | 4.452079 | 874 |
7732 | 2023-10-25 07:38:19.753026 | 44A0B9 | 2000 | OOHEY | 51.147263 | 4.448572 | 1400 | 320 | 0 | 107 | 51.1552335 | 4.452079 | 920 |
5297 | 2021-04-13 14:28:45.945602 | 448423 | 2000 | OOAAC | 51.152802 | 4.464161 | 525 | 0 | 1 | 91 | 51.1552335 | 4.452079 | 887 |
7444 | 2023-06-24 14:27:57.696482 | 3DD37D | 7000 | DHAIN | 51.149644 | 4.459991 | 850 | 320 | 1 | 96 | 51.1552335 | 4.452079 | 832 |
6437 | 2022-07-14 08:15:38.041363 | 44A0B9 | 7000 | OOHEY | 51.149918 | 4.444267 | 800 | -128 | 2 | 99 | 51.1552335 | 4.452079 | 805 |
6610 | 2022-08-21 16:39:23.781658 | A1C3F3 | 2000 | N21246 | 51.151245 | 4.441075 | 900 | 64 | 2 | 103 | 51.1552335 | 4.452079 | 888 |
7478 | 2023-07-05 13:20:44.091994 | 39B415 | 1000 | CALIBR1 | 51.147354 | 4.453323 | 4050 | -64 | 2 | 223 | 51.1552335 | 4.452079 | 880 |
3473 | 2017-12-14 12:07:44.99425 | 39B415 | 5143 | CALIBRA | 51.150238 | 4.450651 | 4525 | 0 | 3 | 205 | 51.1552335 | 4.452079 | 564 |
3503 | 2018-01-25 12:41:22.808008 | 44AAC1 | 1031 | JAF3CX | 51.151978 | 4.454585 | 6050 | 64 | 3 | 258 | 51.1552335 | 4.452079 | 402 |
4569 | 2019-10-20 11:18:25.69321 | 39B415 | 1000 | CALIBRA | 51.149132 | 4.449692 | 4150 | 0 | 3 | 195 | 51.1552335 | 4.452079 | 699 |
6216 | 2022-03-20 12:52:32.182264 | 4488B4 | 2000 | OOBET | 51.148544 | 4.458593 | 625 | 0 | 3 | 95 | 51.1552335 | 4.452079 | 872 |
7208 | 2023-05-20 10:52:00.969862 | 44D2CF | 7000 | OOTVO | 51.151703 | 4.439887 | 700 | 256 | 3 | 76 | 51.1552335 | 4.452079 | 939 |
4513 | 2019-09-22 13:08:47.953044 | 44D841 | 2000 | OOVBA | 51.148666 | 4.443207 | 1300 | 128 | 4 | 111 | 51.1552335 | 4.452079 | 958 |
4570 | 2019-10-20 11:46:00.930653 | 39B415 | 1000 | CALIBRA | 51.147491 | 4.445826 | 4125 | -64 | 4 | 191 | 51.1552335 | 4.452079 | 966 |
5921 | 2021-11-25 13:34:08.038184 | 484FA2 | 7000 | PHTGL | 51.152763 | 4.439316 | 1400 | 0 | 4 | 97 | 51.1552335 | 4.452079 | 934 |
6568 | 2022-08-10 08:02:35.490475 | 406AA7 | 2000 | GOXFE | 51.154495 | 4.438848 | 675 | -64 | 4 | 122 | 51.1552335 | 4.452079 | 929 |
7134 | 2023-04-27 08:35:38.366952 | 44A0B9 | 7000 | OOHEY | 51.148154 | 4.458618 | 900 | 64 | 4 | 94 | 51.1552335 | 4.452079 | 910 |
7456 | 2023-06-28 09:35:49.472594 | 44A0B9 | 7000 | OOHEY | 51.147308 | 4.450279 | 900 | -640 | 4 | 111 | 51.1552335 | 4.452079 | 890 |
7477 | 2023-07-05 12:54:39.546886 | 39B415 | 1000 | CALIBR1 | 51.150467 | 4.458519 | 4050 | 0 | 4 | 220 | 51.1552335 | 4.452079 | 695 |
3218 | 2017-05-15 04:28:36.424796 | 44D0A1 | 5121 | JAF901 | 51.152204 | 4.464035 | 4575 | -1088 | 5 | 217 | 51.1552335 | 4.452079 | 901 |
3875 | 2018-10-08 05:05:35.841414 | 44D9A6 | 5126 | OOVMF | 51.148992 | 4.459152 | 2775 | -192 | 5 | 185 | 51.1552335 | 4.452079 | 852 |
5475 | 2021-06-09 15:23:07.455113 | 448C42 | 2000 | OOCBB | 51.154206 | 4.438248 | 750 | -64 | 5 | 111 | 51.1552335 | 4.452079 | 974 |
6191 | 2022-03-15 14:14:14.184504 | 44AAE2 | 1000 | OOJWB | 51.152802 | 4.460227 | 1225 | -320 | 5 | 187 | 51.1552335 | 4.452079 | 630 |
3306 | 2017-07-10 11:56:35.325277 | 44C24D | 5151 | OOPRM | 51.153508 | 4.464874 | 2125 | -576 | 6 | 238 | 51.1552335 | 4.452079 | 915 |
3472 | 2017-12-14 11:39:14.210229 | 39B415 | 5143 | CALIBRA | 51.150947 | 4.449158 | 4525 | -192 | 6 | 206 | 51.1552335 | 4.452079 | 518 |
3724 | 2018-07-01 13:36:26.998495 | 44D841 | 2000 | OOVBA | 51.154764 | 4.438782 | 900 | -128 | 6 | 85 | 51.1552335 | 4.452079 | 931 |
4981 | 2020-09-02 08:30:50.083314 | 44DA62 | 2000 | OOVSB | 51.147595 | 4.449768 | 1800 | 128 | 6 | 91 | 51.1552335 | 4.452079 | 865 |
5154 | 2020-12-19 18:04:50.438176 | AE11FA | 1000 | BOXER41 | 51.154206 | 4.465179 | 3025 | -128 | 6 | 233 | 51.1552335 | 4.452079 | 923 |
5900 | 2021-11-08 11:29:51.447073 | 44A0B9 | 7000 | OOHEY | 51.151749 | 4.440481 | 700 | 0 | 6 | 96 | 51.1552335 | 4.452079 | 899 |
6219 | 2022-03-21 12:46:16.181101 | 44A0B9 | 2000 | OOHEY | 51.151474 | 4.442485 | 500 | -192 | 6 | 103 | 51.1552335 | 4.452079 | 790 |
6991 | 2023-02-03 13:15:18.53551 | 44A0B9 | 2000 | OOHEY | 51.15239 | 4.439219 | 500 | 0 | 6 | 97 | 51.1552335 | 4.452079 | 953 |
7483 | 2023-07-07 10:26:04.584484 | 39B415 | 1000 | CALIBRA | 51.14848 | 4.448547 | 3850 | 64 | 6 | 226 | 51.1552335 | 4.452079 | 790 |
3858 | 2018-09-27 16:18:08.399019 | 44AA58 | 2000 | OOJRX | 51.148544 | 4.454956 | 650 | 0 | 7 | 89 | 51.1552335 | 4.452079 | 770 |
4980 | 2020-09-02 08:09:38.298555 | 44DA62 | 2000 | OOVSB | 51.1539 | 4.439219 | 1850 | 0 | 7 | 96 | 51.1552335 | 4.452079 | 911 |
7808 | 2023-11-17 11:31:01.926135 | 44A0B9 | 2000 | 51.14713 | 4.452972 | 500 | -64 | 7 | 95 | 51.1552335 | 4.452079 | 903 | |
7993 | 2024-03-08 11:41:59.982312 | 44D86C | 7000 | OOVCL | 51.149185 | 4.445083 | 1100 | -64 | 7 | 86 | 51.1552335 | 4.452079 | 832 |
4174 | 2019-04-20 09:09:19.339161 | 402B27 | 7000 | GBOOL | 51.147875 | 4.444427 | 600 | 0 | 8 | 90 | 51.1552335 | 4.452079 | 978 |
4568 | 2019-10-20 10:50:40.364761 | 39B415 | 1000 | CALIBRA | 51.149644 | 4.446869 | 4150 | -64 | 8 | 200 | 51.1552335 | 4.452079 | 720 |
4783 | 2020-03-09 12:37:04.513009 | 44A0B9 | 7000 | OOHEY | 51.147642 | 4.457092 | 1000 | 0 | 8 | 103 | 51.1552335 | 4.452079 | 914 |
5617 | 2021-08-04 08:35:42.853806 | 3D374D | 7163 | DETER | 51.150467 | 4.443227 | 4825 | 1088 | 8 | 135 | 51.1552335 | 4.452079 | 815 |
5855 | 2021-10-23 09:23:28.187758 | 398895 | 1000 | CALIBRA | 51.150513 | 4.462157 | 2600 | 0 | 8 | 223 | 51.1552335 | 4.452079 | 879 |
7147 | 2023-05-01 13:25:13.422413 | 38E89C | 2000 | FJDZL | 51.149458 | 4.44191 | 1400 | -384 | 8 | 106 | 51.1552335 | 4.452079 | 958 |
7302 | 2023-06-10 09:56:23.297751 | 44D2CF | 7000 | OOTVO | 51.148682 | 4.443747 | 900 | -64 | 8 | 97 | 51.1552335 | 4.452079 | 933 |
7457 | 2023-06-28 10:11:29.403728 | 4488B4 | 2000 | OOBET | 51.147171 | 4.449092 | 1375 | 64 | 8 | 98 | 51.1552335 | 4.452079 | 920 |
7495 | 2023-07-11 06:13:58.388447 | A8164D | 6304 | FALCO | 51.154541 | 4.465052 | 925 | -64 | 8 | 175 | 51.1552335 | 4.452079 | 910 |
5109 | 2020-11-07 11:46:04.145338 | 3DD37D | 2000 | DHAIN | 51.148773 | 4.447978 | 875 | -256 | 9 | 104 | 51.1552335 | 4.452079 | 773 |
5354 | 2021-05-06 04:53:19.705725 | 44C06A | 1000 | OOPCJ | 51.149318 | 4.462204 | 2225 | -960 | 9 | 180 | 51.1552335 | 4.452079 | 966 |
5671 | 2021-08-29 08:38:05.932084 | 39B415 | 1000 | CALIBRA | 51.150146 | 4.444044 | 6000 | -64 | 9 | 201 | 51.1552335 | 4.452079 | 797 |
5929 | 2021-12-01 17:50:12.571433 | 4D024C | 1000 | FYL84F | 51.14969 | 4.461823 | 3475 | 0 | 9 | 166 | 51.1552335 | 4.452079 | 919 |
6339 | 2022-04-20 10:58:08.192546 | 44A0B9 | 2000 | OOHEY | 51.157325 | 4.438248 | 1200 | 0 | 9 | 92 | 51.1552335 | 4.452079 | 995 |
6753 | 2022-10-22 08:34:22.912111 | 4488B4 | 2000 | OOBET | 51.151506 | 4.463425 | 1350 | 256 | 9 | 111 | 51.1552335 | 4.452079 | 895 |
6851 | 2022-11-22 11:15:44.865476 | A325AF | 4402 | N3012H | 51.14997 | 4.442444 | 4575 | 0 | 9 | 182 | 51.1552335 | 4.452079 | 892 |
7000 | 2023-02-12 09:19:03.143173 | 39B415 | 1000 | CALIBRA | 51.149783 | 4.461288 | 2300 | 64 | 9 | 179 | 51.1552335 | 4.452079 | 884 |
7659 | 2023-10-01 14:37:36.514195 | 44CA0F | 2000 | OORPO | 51.146942 | 4.447384 | 775 | 256 | 9 | 101 | 51.1552335 | 4.452079 | 979 |
8111 | 2024-04-23 09:20:25.395437 | 39A58E | 2000 | FHJMO | 51.148992 | 4.442978 | 1050 | 128 | 9 | 124 | 51.1552335 | 4.452079 | 942 |
3463 | 2017-12-04 10:23:34.165468 | 4485B2 | 5162 | OOAMR | 51.14978 | 4.460375 | 2525 | 0 | 10 | 177 | 51.1552335 | 4.452079 | 839 |
5383 | 2021-05-13 12:53:31.893147 | 406A9B | 2000 | GOXFD | 51.148992 | 4.449692 | 1225 | 0 | 10 | 158 | 51.1552335 | 4.452079 | 714 |
5685 | 2021-09-02 11:09:00.043816 | 406A98 | 2000 | GOXFA | 51.150482 | 4.463348 | 600 | -384 | 10 | 120 | 51.1552335 | 4.452079 | 949 |
7031 | 2023-02-28 12:25:22.513523 | 44A0B9 | 7000 | OOHEY | 51.148544 | 4.44976 | 600 | 128 | 10 | 95 | 51.1552335 | 4.452079 | 761 |
7428 | 2023-06-22 09:20:39.375585 | 3D3B6D | 2000 | DEUTH | 51.147583 | 4.454659 | 925 | 0 | 10 | 85 | 51.1552335 | 4.452079 | 870 |
7438 | 2023-06-24 10:14:26.602402 | 392C1B | 2000 | FPMTV | 51.150063 | 4.441147 | 1150 | 0 | 10 | 97 | 51.1552335 | 4.452079 | 957 |
7524 | 2023-07-18 16:15:02.181393 | 44CD75 | 2000 | OOSKU | 51.155463 | 4.438019 | 900 | -64 | 10 | 96 | 51.1552335 | 4.452079 | 984 |
7831 | 2023-12-06 11:39:25.154243 | A8164D | 6311 | FALCO | 51.147875 | 4.446106 | 850 | -64 | 10 | 130 | 51.1552335 | 4.452079 | 919 |
3511 | 2018-02-06 14:02:23.051322 | 440261 | 7000 | OEFDI | 51.155183 | 4.438477 | 800 | -64 | 11 | 96 | 51.1552335 | 4.452079 | 951 |
3557 | 2018-03-14 20:17:42.963065 | 402B27 | 2000 | GBOOL | 51.147629 | 4.445157 | 1800 | 128 | 11 | 90 | 51.1552335 | 4.452079 | 974 |
3908 | 2018-10-26 12:30:41.402081 | 449CA5 | 5115 | OOGEE | 51.152437 | 4.46167 | 3000 | -1472 | 11 | 223 | 51.1552335 | 4.452079 | 739 |
4226 | 2019-05-18 15:11:13.973614 | 44D841 | 2000 | OOVBA | 51.149178 | 4.445877 | 1200 | -320 | 11 | 98 | 51.1552335 | 4.452079 | 801 |
4359 | 2019-07-19 10:44:55.492704 | 4B0F72 | 1000 | HBFWC | 51.148956 | 4.458074 | 4075 | -1024 | 11 | 199 | 51.1552335 | 4.452079 | 814 |
4455 | 2019-08-23 13:00:50.973746 | 44DA62 | 2000 | OOVSB | 51.148499 | 4.459558 | 1625 | -128 | 11 | 87 | 51.1552335 | 4.452079 | 913 |
5353 | 2021-05-06 04:48:26.903647 | 44CE85 | 6307 | OOSTE | 51.147217 | 4.451541 | 1025 | 0 | 11 | 132 | 51.1552335 | 4.452079 | 892 |
5670 | 2021-08-29 08:11:51.429122 | 39B415 | 1000 | CALIBRA | 51.15793 | 4.448853 | 6000 | 128 | 11 | 202 | 51.1552335 | 4.452079 | 375 |
6285 | 2022-04-04 10:11:38.45371 | 44A0B9 | 7000 | OOHEY | 51.147083 | 4.455109 | 1200 | 64 | 11 | 120 | 51.1552335 | 4.452079 | 931 |
6520 | 2022-08-02 11:14:39.147119 | 44CD75 | 2000 | OOSKU | 51.156487 | 4.438782 | 1050 | -704 | 11 | 118 | 51.1552335 | 4.452079 | 940 |
6592 | 2022-08-16 10:56:36.58431 | 4076F1 | 1000 | VOR09 | 51.150901 | 4.444199 | 2425 | 64 | 11 | 165 | 51.1552335 | 4.452079 | 732 |
6930 | 2022-12-27 15:58:14.96065 | 45C10B | 2000 | OYPHK | 51.150421 | 4.44011 | 800 | -256 | 11 | 140 | 51.1552335 | 4.452079 | 993 |
7668 | 2023-10-04 06:45:21.795687 | 44CA0F | 2000 | OORPO | 51.15184 | 4.44345 | 1075 | -192 | 11 | 111 | 51.1552335 | 4.452079 | 712 |
7849 | 2023-12-14 11:08:20.637144 | 44D2CF | 5155 | OOTVO | 51.147903 | 4.458965 | 2800 | 0 | 11 | 89 | 51.1552335 | 4.452079 | 947 |
4008 | 2018-12-11 11:04:58.38324 | 44DA74 | 2000 | OOVST | 51.148526 | 4.443741 | 1050 | 384 | 12 | 84 | 51.1552335 | 4.452079 | 947 |
4647 | 2019-12-07 10:54:27.451475 | 402B27 | 7000 | GBOOL | 51.148224 | 4.453991 | 1500 | -64 | 12 | 109 | 51.1552335 | 4.452079 | 791 |
5157 | 2020-12-24 11:19:53.303863 | 485190 | 1000 | PHPKF | 51.148178 | 4.458371 | 2750 | -1088 | 12 | 188 | 51.1552335 | 4.452079 | 899 |
5365 | 2021-05-08 17:03:21.715406 | 44CA0F | 2000 | OORPO | 51.148759 | 4.452744 | 1625 | 64 | 12 | 120 | 51.1552335 | 4.452079 | 721 |
6254 | 2022-03-26 13:14:06.456858 | 3FF9AC | 7000 | DMCPG | 51.150101 | 4.440407 | 700 | 0 | 12 | 117 | 51.1552335 | 4.452079 | 996 |
6505 | 2022-07-29 13:26:41.894122 | 44CE86 | 2000 | OOSTF | 51.150575 | 4.440765 | 850 | -320 | 12 | 72 | 51.1552335 | 4.452079 | 946 |
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 );