aircraft
4,898 rows sorted by altitude_in_ft
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8088 | 2024-04-14 18:13:17.042241 | 4488F2 | 6362 | OOBGR | 51.149132 | 4.456329 | 0 | 0 | 158 | 5 | 51.1552335 | 4.452079 | 741 |
6013 | 2022-01-14 15:21:59.848025 | 44CE85 | 6305 | OOSTE | 51.162781 | 4.447459 | 75 | -64 | 214 | 135 | 51.1552335 | 4.452079 | 899 |
5742 | 2021-09-16 16:45:47.768872 | 4488CD | 6364 | OOBFM | 51.150389 | 4.463196 | 100 | 0 | 123 | 7 | 51.1552335 | 4.452079 | 946 |
5744 | 2021-09-16 16:50:50.932316 | 4488CD | 6364 | OOBFM | 51.150389 | 4.463196 | 100 | 0 | 123 | 7 | 51.1552335 | 4.452079 | 946 |
6031 | 2022-01-23 13:11:28.628418 | 44D88D | 7000 | OOVDM | 51.162352 | 4.451294 | 100 | -64 | 167 | 99 | 51.1552335 | 4.452079 | 793 |
8086 | 2024-04-14 18:03:10.955430 | 4488F2 | 0000 | 51.159233 | 4.44809 | 100 | 0 | 153 | 6 | 51.1552335 | 4.452079 | 525 | |
5740 | 2021-09-16 16:35:42.071282 | 4488CD | 6364 | OOBFM | 51.158066 | 4.451244 | 125 | 0 | 128 | 6 | 51.1552335 | 4.452079 | 320 |
6036 | 2022-01-24 16:13:11.227019 | 44CE85 | 6312 | 51.161608 | 4.445419 | 125 | -128 | 216 | 134 | 51.1552335 | 4.452079 | 848 | |
6035 | 2022-01-24 15:29:37.138125 | 44CE85 | 6312 | OOSTE | 51.153275 | 4.441681 | 175 | -128 | 30 | 130 | 51.1552335 | 4.452079 | 759 |
7528 | 2023-07-18 18:54:13.060703 | 4489D4 | 6367 | OOBNT | 51.148956 | 4.455995 | 175 | 0 | 163 | 10 | 51.1552335 | 4.452079 | 750 |
7850 | 2023-12-15 13:24:33.247467 | A8164D | 6307 | FALCO | 51.156921 | 4.438031 | 200 | 64 | 20 | 135 | 51.1552335 | 4.452079 | 1000 |
6203 | 2022-03-18 11:26:14.329976 | 398274 | 7000 | FHATU | 51.159805 | 4.464309 | 225 | 128 | 314 | 98 | 51.1552335 | 4.452079 | 995 |
6208 | 2022-03-18 17:19:13.959676 | 44C069 | 2000 | OOPCI | 51.158615 | 4.457183 | 225 | 960 | 212 | 184 | 51.1552335 | 4.452079 | 518 |
7526 | 2023-07-18 18:49:12.50695 | 4489D4 | 6367 | OOBNT | 51.164017 | 4.451764 | 225 | 0 | 0 | 1 | 51.1552335 | 4.452079 | 977 |
5739 | 2021-09-16 16:30:39.175426 | 4488CD | 6364 | 51.162598 | 4.447384 | 250 | 0 | 130 | 9 | 51.1552335 | 4.452079 | 882 | |
5741 | 2021-09-16 16:40:44.910498 | 4488CD | 6364 | OOBFM | 51.154159 | 4.458389 | 275 | 0 | 153 | 4 | 51.1552335 | 4.452079 | 457 |
7806 | 2023-11-17 08:23:18.275602 | 44F6A5 | 2000 | ARES501 | 51.146757 | 4.449081 | 275 | 64 | 22 | 87 | 51.1552335 | 4.452079 | 966 |
4681 | 2019-12-28 11:07:46.95867 | 44D841 | 2000 | OOVBA | 51.158386 | 4.46275 | 300 | 0 | 217 | 87 | 51.1552335 | 4.452079 | 824 |
5136 | 2020-11-29 13:58:35.929884 | 44D88D | 7000 | OOVDM | 51.163051 | 4.448013 | 300 | -192 | 174 | 114 | 51.1552335 | 4.452079 | 915 |
5238 | 2021-02-27 15:51:01.266759 | 448423 | 2000 | OOAAC | 51.160263 | 4.462379 | 300 | 0 | 219 | 108 | 51.1552335 | 4.452079 | 912 |
5981 | 2022-01-01 09:27:33.671332 | 44D88D | 7000 | OOVDM | 51.16333 | 4.453397 | 300 | -64 | 182 | 91 | 51.1552335 | 4.452079 | 905 |
6017 | 2022-01-17 13:49:35.60038 | 44CA0F | 2000 | OORPO | 51.162958 | 4.451447 | 300 | -256 | 108 | 107 | 51.1552335 | 4.452079 | 860 |
7001 | 2023-02-12 10:10:41.661989 | 39B415 | 1000 | CALIBRA | 51.163702 | 4.451141 | 300 | 0 | 117 | 183 | 51.1552335 | 4.452079 | 944 |
7100 | 2023-04-17 06:43:28.915238 | 44A0B9 | 0000 | OOHEY | 51.162048 | 4.456292 | 300 | 256 | 210 | 102 | 51.1552335 | 4.452079 | 813 |
6829 | 2022-11-11 07:29:45.382864 | 44CA0F | 2000 | OORPO | 51.154345 | 4.464569 | 325 | 0 | 220 | 79 | 51.1552335 | 4.452079 | 879 |
6980 | 2023-01-24 11:48:46.71952 | 44B5AD | 5177 | BCG01 | 51.162781 | 4.457331 | 325 | 0 | 267 | 119 | 51.1552335 | 4.452079 | 916 |
3852 | 2018-09-24 11:04:25.136852 | 44AA58 | 2000 | OOJRX | 51.157059 | 4.442782 | 350 | -64 | 122 | 128 | 51.1552335 | 4.452079 | 681 |
5686 | 2021-09-02 11:44:09.503129 | 44CE85 | 6305 | OOSTE | 51.15914 | 4.450226 | 350 | 192 | 207 | 131 | 51.1552335 | 4.452079 | 453 |
5916 | 2021-11-22 14:21:32.114345 | 44CE85 | 0000 | OOSTE | 51.160071 | 4.457626 | 350 | 576 | 205 | 124 | 51.1552335 | 4.452079 | 663 |
5919 | 2021-11-23 06:54:23.642937 | A8164D | 2000 | N620AR | 51.162872 | 4.458519 | 350 | 64 | 207 | 146 | 51.1552335 | 4.452079 | 961 |
6018 | 2022-01-17 14:14:54.650277 | 44CA0F | 2000 | OORPO | 51.16333 | 4.449692 | 350 | 192 | 111 | 106 | 51.1552335 | 4.452079 | 916 |
4119 | 2019-03-20 15:28:34.981586 | 44AA58 | 2000 | OOJRX | 51.149225 | 4.442368 | 375 | 0 | 37 | 110 | 51.1552335 | 4.452079 | 953 |
5400 | 2021-05-20 08:15:36.035906 | 44CE85 | 6310 | OOSTE | 51.155182 | 4.439739 | 375 | 0 | 32 | 139 | 51.1552335 | 4.452079 | 863 |
5745 | 2021-09-16 16:55:39.935244 | 48463D | 6366 | PHKOK | 51.152252 | 4.465497 | 375 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 995 |
6213 | 2022-03-19 15:12:26.709138 | 44CA0F | 2000 | OORPO | 51.149643 | 4.442708 | 375 | -512 | 39 | 85 | 51.1552335 | 4.452079 | 903 |
4064 | 2019-02-13 14:40:03.258675 | 448CAA | 7000 | OOCEJ | 51.14834 | 4.449081 | 400 | 0 | 82 | 152 | 51.1552335 | 4.452079 | 795 |
4078 | 2019-02-23 11:29:36.504881 | 44D841 | 2000 | OOVBA | 51.147502 | 4.453888 | 400 | 64 | 355 | 96 | 51.1552335 | 4.452079 | 869 |
6033 | 2022-01-24 11:20:14.704322 | 44A0B9 | 2000 | OOHEY | 51.147875 | 4.45549 | 400 | 256 | 34 | 100 | 51.1552335 | 4.452079 | 852 |
6104 | 2022-02-26 10:48:19.337441 | 44868F | 2000 | OOATO | 51.146713 | 4.448424 | 400 | 192 | 26 | 83 | 51.1552335 | 4.452079 | 981 |
6105 | 2022-02-26 11:23:13.623765 | 44868F | 2000 | OOATO | 51.151785 | 4.463577 | 400 | -64 | 236 | 81 | 51.1552335 | 4.452079 | 891 |
6199 | 2022-03-17 12:32:03.112866 | 44A0B9 | 7000 | OOHEY | 51.147949 | 4.457703 | 400 | 64 | 35 | 106 | 51.1552335 | 4.452079 | 900 |
6550 | 2022-08-07 10:05:19.767517 | 44CE85 | 0000 | 51.159485 | 4.462676 | 400 | 320 | 204 | 126 | 51.1552335 | 4.452079 | 879 | |
7201 | 2023-05-18 09:35:18.264352 | 44D88D | 7000 | OOVDM | 51.162094 | 4.44397 | 400 | 192 | 189 | 109 | 51.1552335 | 4.452079 | 950 |
7256 | 2023-06-01 06:10:44.824244 | 44A0B9 | 2000 | OOHEY | 51.163422 | 4.451838 | 400 | -64 | 221 | 97 | 51.1552335 | 4.452079 | 911 |
7914 | 2024-01-27 13:18:20.017748 | 484B40 | 7000 | PHSRP | 51.156326 | 4.438105 | 400 | 0 | 16 | 89 | 51.1552335 | 4.452079 | 985 |
7915 | 2024-01-27 14:14:41.145795 | 44ADEB | 7000 | OOKOK | 51.163051 | 4.44603 | 400 | -128 | 71 | 107 | 51.1552335 | 4.452079 | 967 |
7924 | 2024-02-01 16:01:25.311069 | A8164D | 1447 | FALCO | 51.147223 | 4.447174 | 400 | -64 | 38 | 148 | 51.1552335 | 4.452079 | 954 |
5266 | 2021-03-30 05:39:12.314116 | 44CE85 | 6313 | OOSTE | 51.160863 | 4.441681 | 425 | 0 | 207 | 125 | 51.1552335 | 4.452079 | 959 |
5764 | 2021-09-21 15:38:10.677746 | 44CE85 | 7000 | OOSTE | 51.16198 | 4.460907 | 425 | 64 | 219 | 133 | 51.1552335 | 4.452079 | 971 |
5864 | 2021-10-27 07:04:36.313052 | A8164D | 2000 | N620AR | 51.15683 | 4.466017 | 425 | -64 | 178 | 131 | 51.1552335 | 4.452079 | 991 |
7151 | 2023-05-03 06:17:23.039965 | 44CE85 | 6312 | OOSTE | 51.162827 | 4.45889 | 425 | -1152 | 16 | 130 | 51.1552335 | 4.452079 | 969 |
5235 | 2021-02-24 16:45:09.439416 | 44CE85 | 7000 | OOSTE | 51.161865 | 4.448424 | 450 | 448 | 205 | 113 | 51.1552335 | 4.452079 | 780 |
6026 | 2022-01-20 07:24:56.143766 | 44CE85 | 6305 | OOSTE | 51.148433 | 4.456711 | 450 | 256 | 16 | 116 | 51.1552335 | 4.452079 | 823 |
6029 | 2022-01-22 10:26:45.726306 | 448423 | 2000 | OOAAC | 51.161701 | 4.445114 | 450 | 192 | 115 | 99 | 51.1552335 | 4.452079 | 868 |
6042 | 2022-01-28 12:23:43.961387 | 44C06A | 1000 | OOPCJ | 51.14859 | 4.449389 | 450 | -64 | 49 | 187 | 51.1552335 | 4.452079 | 762 |
6070 | 2022-02-11 15:56:38.628386 | 448423 | 2000 | OOAAC | 51.162771 | 4.449234 | 450 | -128 | 110 | 99 | 51.1552335 | 4.452079 | 861 |
6145 | 2022-03-07 08:06:18.920732 | 44CE85 | 6312 | OOSTE | 51.162399 | 4.454041 | 450 | 256 | 210 | 121 | 51.1552335 | 4.452079 | 808 |
6726 | 2022-10-07 12:30:05.896941 | 44CE86 | 7000 | OOSTF | 51.151552 | 4.439392 | 450 | 512 | 122 | 60 | 51.1552335 | 4.452079 | 977 |
7007 | 2023-02-13 16:23:49.620863 | 44CA0F | 2000 | OORPO | 51.15807 | 4.46434 | 450 | 64 | 215 | 87 | 51.1552335 | 4.452079 | 913 |
7211 | 2023-05-21 17:51:09.181575 | 44CE85 | 6311 | OOSTE | 51.158524 | 4.439219 | 450 | 64 | 30 | 131 | 51.1552335 | 4.452079 | 971 |
6164 | 2022-03-10 07:00:02.066401 | 44CE85 | 7000 | OOSTE | 51.161453 | 4.447756 | 475 | 0 | 211 | 110 | 51.1552335 | 4.452079 | 755 |
6251 | 2022-03-26 11:37:53.251898 | 44D872 | 7000 | OOVCR | 51.163656 | 4.44931 | 475 | -256 | 206 | 105 | 51.1552335 | 4.452079 | 956 |
6860 | 2022-11-26 10:20:49.137451 | 4488B4 | 2000 | OOBET | 51.147549 | 4.447632 | 475 | -64 | 14 | 105 | 51.1552335 | 4.452079 | 909 |
6928 | 2022-12-27 11:43:49.74861 | 3E0610 | 7000 | DHTMM | 51.151878 | 4.441833 | 475 | -256 | 28 | 132 | 51.1552335 | 4.452079 | 808 |
6983 | 2023-01-28 10:13:15.129192 | 4488B4 | 2000 | 51.146484 | 4.450354 | 475 | 64 | 17 | 77 | 51.1552335 | 4.452079 | 980 | |
6985 | 2023-01-28 15:15:01.357467 | 3D3B6D | 2000 | DEUTH | 51.163651 | 4.456441 | 475 | 64 | 293 | 112 | 51.1552335 | 4.452079 | 984 |
7010 | 2023-02-15 16:03:42.979461 | 44CE85 | 6310 | OOSTE | 51.153787 | 4.441605 | 475 | 0 | 28 | 132 | 51.1552335 | 4.452079 | 750 |
8078 | 2024-04-12 09:04:01.983360 | 44D872 | 7000 | OOVCR | 51.152949 | 4.439163 | 475 | -128 | 21 | 102 | 51.1552335 | 4.452079 | 938 |
8087 | 2024-04-14 18:08:14.007021 | 4488F2 | 6362 | OOBGR | 51.15271 | 4.453991 | 475 | 0 | 141 | 6 | 51.1552335 | 4.452079 | 310 |
4118 | 2019-03-20 14:03:43.149214 | 44D841 | 2000 | OOVBA | 51.160995 | 4.445009 | 500 | 192 | 94 | 99 | 51.1552335 | 4.452079 | 809 |
4128 | 2019-03-23 15:00:23.685954 | 402B27 | 7000 | GBOOL | 51.147176 | 4.451141 | 500 | -320 | 66 | 89 | 51.1552335 | 4.452079 | 898 |
5057 | 2020-10-12 06:35:50.308193 | 44CE85 | 6313 | OOSTE | 51.154392 | 4.439774 | 500 | 0 | 35 | 131 | 51.1552335 | 4.452079 | 865 |
5239 | 2021-02-28 08:18:49.715922 | 448423 | 2000 | OOAAC | 51.158116 | 4.465256 | 500 | 192 | 223 | 107 | 51.1552335 | 4.452079 | 976 |
5665 | 2021-08-27 13:43:39.246655 | 44CE83 | 2000 | OOSTC | 51.15402 | 4.4384 | 500 | 128 | 28 | 64 | 51.1552335 | 4.452079 | 966 |
5763 | 2021-09-21 15:30:56.569446 | 44CE85 | 7000 | OOSTE | 51.156738 | 4.43907 | 500 | -192 | 80 | 105 | 51.1552335 | 4.452079 | 925 |
6008 | 2022-01-11 13:20:36.361033 | 448423 | 2000 | OOAAC | 51.15509 | 4.464458 | 500 | 128 | 296 | 85 | 51.1552335 | 4.452079 | 866 |
6032 | 2022-01-23 16:19:47.330578 | 448C42 | 7000 | OOCBB | 51.159393 | 4.439887 | 500 | -128 | 32 | 133 | 51.1552335 | 4.452079 | 970 |
6034 | 2022-01-24 15:25:29.731716 | 448423 | 2000 | OOAAC | 51.158844 | 4.440184 | 500 | 384 | 101 | 82 | 51.1552335 | 4.452079 | 924 |
6067 | 2022-02-11 09:45:59.503902 | 44ADEB | 2000 | OOKOK | 51.159439 | 4.443153 | 500 | 192 | 104 | 103 | 51.1552335 | 4.452079 | 780 |
6209 | 2022-03-18 17:34:37.487483 | A4D7B6 | 2000 | N4109C | 51.148852 | 4.461365 | 500 | 0 | 310 | 125 | 51.1552335 | 4.452079 | 962 |
6212 | 2022-03-19 14:28:32.480355 | 44CA0F | 2000 | OORPO | 51.158249 | 4.463122 | 500 | 576 | 217 | 100 | 51.1552335 | 4.452079 | 842 |
6219 | 2022-03-21 12:46:16.181101 | 44A0B9 | 2000 | OOHEY | 51.151474 | 4.442485 | 500 | -192 | 6 | 103 | 51.1552335 | 4.452079 | 790 |
6228 | 2022-03-22 13:09:31.907128 | 44A0B9 | 7000 | OOHEY | 51.147171 | 4.458222 | 500 | 0 | 28 | 102 | 51.1552335 | 4.452079 | 994 |
6245 | 2022-03-25 09:35:23.03229 | 44CD75 | 6365 | OOSKU | 51.147537 | 4.44538 | 500 | -384 | 27 | 85 | 51.1552335 | 4.452079 | 976 |
6399 | 2022-07-08 14:09:56.624996 | 448423 | 2000 | OOAAC | 51.163467 | 4.45748 | 500 | -448 | 135 | 96 | 51.1552335 | 4.452079 | 990 |
6555 | 2022-08-08 06:15:15.859857 | 449893 | 7000 | OOFDS | 51.161819 | 4.456441 | 500 | 0 | 231 | 105 | 51.1552335 | 4.452079 | 793 |
6834 | 2022-11-12 10:14:17.90962 | 44CA0F | 2000 | OORPO | 51.157562 | 4.440481 | 500 | 192 | 82 | 84 | 51.1552335 | 4.452079 | 851 |
6863 | 2022-11-26 11:21:22.849906 | 44B60C | 2000 | OOMPL | 51.15976 | 4.463493 | 500 | 64 | 247 | 78 | 51.1552335 | 4.452079 | 944 |
6991 | 2023-02-03 13:15:18.53551 | 44A0B9 | 2000 | OOHEY | 51.15239 | 4.439219 | 500 | 0 | 6 | 97 | 51.1552335 | 4.452079 | 953 |
7227 | 2023-05-26 13:31:50.377322 | A8164D | 2000 | FALCO | 51.149039 | 4.442062 | 500 | 128 | 25 | 135 | 51.1552335 | 4.452079 | 982 |
7808 | 2023-11-17 11:31:01.926135 | 44A0B9 | 2000 | 51.14713 | 4.452972 | 500 | -64 | 7 | 95 | 51.1552335 | 4.452079 | 903 | |
7854 | 2023-12-18 12:37:10.677011 | 44A0B9 | 2000 | OOHEY | 51.148132 | 4.455624 | 500 | 192 | 16 | 109 | 51.1552335 | 4.452079 | 828 |
7920 | 2024-01-29 08:29:31.989351 | A8164D | 2000 | 51.163651 | 4.455179 | 500 | 192 | 211 | 132 | 51.1552335 | 4.452079 | 961 | |
7922 | 2024-01-31 09:47:10.793924 | 448423 | 2000 | OOAAC | 51.163982 | 4.450378 | 500 | 64 | 116 | 90 | 51.1552335 | 4.452079 | 980 |
7947 | 2024-02-20 12:44:18.443118 | 40448C | 7000 | GCBJZ | 51.163559 | 4.44731 | 500 | 0 | 21 | 130 | 51.1552335 | 4.452079 | 984 |
4038 | 2019-01-02 09:58:35.779777 | 44DA74 | 2000 | OOVST | 51.148911 | 4.442188 | 525 | -128 | 13 | 83 | 51.1552335 | 4.452079 | 986 |
5269 | 2021-03-30 07:33:10.387546 | 448423 | 2000 | OOAAC | 51.162446 | 4.460449 | 525 | -128 | 288 | 92 | 51.1552335 | 4.452079 | 993 |
5297 | 2021-04-13 14:28:45.945602 | 448423 | 2000 | OOAAC | 51.152802 | 4.464161 | 525 | 0 | 1 | 91 | 51.1552335 | 4.452079 | 887 |
5808 | 2021-10-08 10:18:01.293699 | 485C5B | 7000 | PHKIO | 51.157046 | 4.461899 | 525 | 192 | 215 | 115 | 51.1552335 | 4.452079 | 716 |
6253 | 2022-03-26 12:47:21.597318 | 448423 | 2000 | OOAAC | 51.14862 | 4.444122 | 525 | 448 | 62 | 69 | 51.1552335 | 4.452079 | 922 |
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 );