aircraft
4,898 rows sorted by flight
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3373 | 2017-08-29 11:41:56.146101 | 449A06 | 4755 | 51.158954 | 4.439087 | 1700 | -704 | 118 | 168 | 51.1552335 | 4.452079 | 998 | |
3374 | 2017-08-29 17:57:38.261679 | 44AAC1 | 5324 | 51.160629 | 4.441223 | 2025 | -256 | 114 | 184 | 51.1552335 | 4.452079 | 968 | |
3427 | 2017-10-11 18:27:19.56053 | 44D0A1 | 2336 | 51.151611 | 4.439887 | 1725 | -384 | 116 | 194 | 51.1552335 | 4.452079 | 943 | |
3439 | 2017-10-24 18:37:32.359856 | 44A8A2 | 2334 | 51.153182 | 4.439621 | 1775 | 64 | 111 | 213 | 51.1552335 | 4.452079 | 901 | |
3605 | 2018-04-17 09:58:44.210373 | 44D9A9 | 4411 | 51.161934 | 4.455719 | 4725 | 3584 | 253 | 163 | 51.1552335 | 4.452079 | 787 | |
3685 | 2018-06-07 12:42:29.067046 | 44D0A1 | 5507 | 51.152809 | 4.438477 | 1500 | -768 | 100 | 190 | 51.1552335 | 4.452079 | 989 | |
3719 | 2018-06-28 16:33:51.825172 | A0CBEC | 7000 | 51.163097 | 4.452667 | 600 | 0 | 211 | 85 | 51.1552335 | 4.452079 | 875 | |
3884 | 2018-10-13 13:02:58.496609 | 44D841 | 2000 | 51.160446 | 4.459484 | 900 | 128 | 231 | 78 | 51.1552335 | 4.452079 | 777 | |
3911 | 2018-10-27 11:58:12.059899 | 44AAE2 | 7271 | 51.163147 | 4.448349 | 1675 | -256 | 110 | 130 | 51.1552335 | 4.452079 | 918 | |
4115 | 2019-03-19 12:02:55.254861 | 44D0A1 | 5357 | 51.158066 | 4.446865 | 2075 | -768 | 109 | 192 | 51.1552335 | 4.452079 | 482 | |
4248 | 2019-06-01 11:10:21.918722 | 44BC61 | 0244 | 51.161591 | 4.450205 | 1225 | -768 | 99 | 174 | 51.1552335 | 4.452079 | 719 | |
4294 | 2019-06-18 10:11:52.349438 | 44D9A6 | 1000 | 51.148453 | 4.449092 | 2975 | 64 | 96 | 240 | 51.1552335 | 4.452079 | 782 | |
4304 | 2019-06-19 17:56:40.351745 | 44D0A1 | 1000 | 51.161747 | 4.446564 | 1975 | -768 | 114 | 185 | 51.1552335 | 4.452079 | 820 | |
4308 | 2019-06-21 08:35:26.168649 | 44D841 | 2000 | 51.158386 | 4.43907 | 900 | -64 | 195 | 94 | 51.1552335 | 4.452079 | 975 | |
4330 | 2019-07-05 20:12:40.632845 | 4D024C | 3411 | 51.157104 | 4.444118 | 1450 | 192 | 112 | 183 | 51.1552335 | 4.452079 | 594 | |
4339 | 2019-07-10 11:36:58.270156 | 44A8A2 | 5353 | 51.152483 | 4.438477 | 1450 | 448 | 98 | 180 | 51.1552335 | 4.452079 | 999 | |
4340 | 2019-07-10 11:42:01.192688 | 44A8A2 | 5353 | 51.15152 | 4.444786 | 1475 | -256 | 109 | 154 | 51.1552335 | 4.452079 | 656 | |
4352 | 2019-07-16 09:32:38.713481 | 44BC61 | 1000 | 51.162506 | 4.448275 | 1300 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 851 | |
4357 | 2019-07-18 11:32:44.574567 | 44A8A2 | 5560 | 51.150513 | 4.44976 | 2600 | -768 | 95 | 226 | 51.1552335 | 4.452079 | 549 | |
4405 | 2019-08-06 13:27:19.656622 | 44033D | 3417 | 51.163656 | 4.448242 | 1575 | -64 | 118 | 201 | 51.1552335 | 4.452079 | 974 | |
4425 | 2019-08-13 10:17:26.585489 | 449CA5 | 5162 | 51.161545 | 4.444415 | 900 | 448 | 111 | 176 | 51.1552335 | 4.452079 | 883 | |
4426 | 2019-08-14 10:01:03.777733 | 44AAC1 | 0000 | 51.160071 | 4.440765 | 1900 | 320 | 108 | 193 | 51.1552335 | 4.452079 | 957 | |
4449 | 2019-08-22 13:52:32.289966 | 4848DF | 1000 | 51.157651 | 4.452133 | 1450 | -1408 | 97 | 174 | 51.1552335 | 4.452079 | 268 | |
4463 | 2019-08-28 05:13:18.929994 | 44CCC2 | 0533 | 51.158116 | 4.438553 | 6150 | -1152 | 110 | 283 | 51.1552335 | 4.452079 | 999 | |
4750 | 2020-02-15 11:34:52.948474 | 44A8AD | 5567 | 51.152809 | 4.439011 | 3525 | -2048 | 109 | 221 | 51.1552335 | 4.452079 | 953 | |
4761 | 2020-02-16 11:49:34.753135 | 495290 | 1000 | 51.152939 | 4.438922 | 4050 | -1152 | 59 | 297 | 51.1552335 | 4.452079 | 955 | |
4763 | 2020-02-16 12:58:32.945508 | 44CE64 | 1000 | 51.158752 | 4.439293 | 4575 | -1280 | 43 | 317 | 51.1552335 | 4.452079 | 976 | |
4769 | 2020-02-24 07:28:53.82085 | 44CE85 | 0000 | 51.162872 | 4.448201 | 775 | 256 | 218 | 104 | 51.1552335 | 4.452079 | 892 | |
4770 | 2020-02-26 12:57:28.69621 | 44AAC1 | 5357 | 51.162539 | 4.444122 | 4000 | -1984 | 108 | 291 | 51.1552335 | 4.452079 | 985 | |
4775 | 2020-02-28 15:34:19.536476 | 4075FE | 2056 | 51.152064 | 4.445572 | 5100 | -1664 | 99 | 234 | 51.1552335 | 4.452079 | 575 | |
4778 | 2020-03-01 11:06:06.396175 | 3924A4 | 5126 | 51.159622 | 4.442485 | 1475 | -640 | 77 | 231 | 51.1552335 | 4.452079 | 829 | |
4889 | 2020-07-19 14:48:20.34001 | 4494E8 | 7000 | 51.163879 | 4.455327 | 1000 | -256 | 198 | 95 | 51.1552335 | 4.452079 | 988 | |
4933 | 2020-07-30 11:41:46.53181 | 44CDCA | 0000 | 51.149139 | 4.444638 | 3150 | -960 | 98 | 237 | 51.1552335 | 4.452079 | 854 | |
4958 | 2020-08-23 11:48:50.252802 | 44AAC1 | 5566 | 51.162918 | 4.450873 | 1450 | -128 | 112 | 252 | 51.1552335 | 4.452079 | 859 | |
4972 | 2020-08-28 13:20:32.850752 | 4CA280 | 2053 | 51.15976 | 4.440852 | 3325 | 128 | 96 | 274 | 51.1552335 | 4.452079 | 933 | |
5038 | 2020-09-27 17:06:23.452957 | 4D024D | 1000 | 51.148107 | 4.44458 | 2200 | 0 | 325 | 188 | 51.1552335 | 4.452079 | 950 | |
5045 | 2020-10-01 15:06:51.911233 | 3924A4 | 5133 | 51.163935 | 4.45549 | 1500 | -448 | 103 | 229 | 51.1552335 | 4.452079 | 997 | |
5084 | 2020-10-24 13:17:45.010726 | 44CE86 | 2000 | 51.162735 | 4.457925 | 825 | -256 | 182 | 81 | 51.1552335 | 4.452079 | 929 | |
5103 | 2020-11-02 11:49:33.30112 | 39AC43 | 2000 | 51.150901 | 4.444885 | 850 | -256 | 335 | 119 | 51.1552335 | 4.452079 | 696 | |
5125 | 2020-11-19 15:51:26.046963 | 44B0B4 | 1000 | 51.16214 | 4.447756 | 1150 | 192 | 111 | 170 | 51.1552335 | 4.452079 | 825 | |
5147 | 2020-12-10 15:18:23.996516 | 44B450 | 1000 | 51.148759 | 4.452515 | 2200 | 768 | 336 | 188 | 51.1552335 | 4.452079 | 720 | |
5225 | 2021-02-22 09:03:05.212559 | 44CE85 | 7000 | 51.161087 | 4.455105 | 650 | 128 | 209 | 112 | 51.1552335 | 4.452079 | 684 | |
5330 | 2021-04-26 16:05:05.406849 | A8164D | 2000 | 51.162073 | 4.457779 | 850 | -64 | 208 | 165 | 51.1552335 | 4.452079 | 859 | |
5393 | 2021-05-17 12:16:41.154956 | 4858C7 | 7000 | 51.158628 | 4.438934 | 1225 | 0 | 111 | 198 | 51.1552335 | 4.452079 | 994 | |
5541 | 2021-07-05 18:22:19.208858 | 44B430 | 3505 | 51.150342 | 4.450684 | 4250 | -1536 | 275 | 231 | 51.1552335 | 4.452079 | 552 | |
5633 | 2021-08-14 12:04:40.876362 | AC7E2F | 0000 | 51.162073 | 4.44931 | 1000 | -448 | 188 | 107 | 51.1552335 | 4.452079 | 785 | |
5698 | 2021-09-06 14:05:08.30414 | 44846F | 1000 | 51.155045 | 4.461488 | 5000 | 0 | 281 | 251 | 51.1552335 | 4.452079 | 658 | |
5733 | 2021-09-16 09:33:49.166183 | 44CE86 | 2000 | 51.162073 | 4.45961 | 775 | -192 | 239 | 94 | 51.1552335 | 4.452079 | 925 | |
5739 | 2021-09-16 16:30:39.175426 | 4488CD | 6364 | 51.162598 | 4.447384 | 250 | 0 | 130 | 9 | 51.1552335 | 4.452079 | 882 | |
5743 | 2021-09-16 16:50:35.538544 | 48463D | 6366 | 51.162872 | 4.456515 | 1100 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 904 | |
5752 | 2021-09-18 16:24:37.961114 | 3924A0 | 2000 | 51.154816 | 4.464235 | 1450 | 192 | 226 | 188 | 51.1552335 | 4.452079 | 851 | |
5793 | 2021-10-01 13:48:05.302438 | 44CE85 | 6304 | 51.161957 | 4.451616 | 800 | 64 | 215 | 112 | 51.1552335 | 4.452079 | 748 | |
5798 | 2021-10-03 17:18:10.742071 | 44CE85 | 6306 | 51.163423 | 4.44809 | 1100 | -64 | 191 | 103 | 51.1552335 | 4.452079 | 952 | |
5842 | 2021-10-17 18:39:19.768434 | 44CE85 | 7000 | 51.160816 | 4.458084 | 900 | 64 | 205 | 108 | 51.1552335 | 4.452079 | 749 | |
5848 | 2021-10-21 12:33:17.608132 | 44A0B9 | 7000 | 51.146385 | 4.453583 | 1200 | -64 | 37 | 107 | 51.1552335 | 4.452079 | 990 | |
5872 | 2021-10-29 14:04:57.559351 | 44CE85 | 7000 | 51.159485 | 4.453397 | 1125 | -192 | 215 | 113 | 51.1552335 | 4.452079 | 481 | |
5935 | 2021-12-07 15:59:14.920055 | 44D9B6 | 1000 | 51.154953 | 4.446494 | 3000 | -512 | 305 | 162 | 51.1552335 | 4.452079 | 391 | |
6036 | 2022-01-24 16:13:11.227019 | 44CE85 | 6312 | 51.161608 | 4.445419 | 125 | -128 | 216 | 134 | 51.1552335 | 4.452079 | 848 | |
6115 | 2022-02-27 11:11:00.241246 | 4486F4 | 7000 | 51.163147 | 4.454511 | 625 | -64 | 192 | 84 | 51.1552335 | 4.452079 | 896 | |
6175 | 2022-03-12 16:59:22.138323 | 44C06E | 2000 | 51.154951 | 4.463196 | 1300 | 384 | 219 | 187 | 51.1552335 | 4.452079 | 778 | |
6280 | 2022-04-02 16:29:41.71266 | 44CAAE | 2000 | 51.163796 | 4.448166 | 900 | 192 | 182 | 95 | 51.1552335 | 4.452079 | 991 | |
6327 | 2022-04-16 09:17:38.386564 | 4043BA | 7000 | 51.160263 | 4.46082 | 1000 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 828 | |
6348 | 2022-04-22 13:51:28.699587 | 3D063F | 7000 | 51.160165 | 4.463348 | 1700 | 576 | 237 | 113 | 51.1552335 | 4.452079 | 960 | |
6394 | 2022-07-07 06:00:49.916869 | 44A0B9 | 7000 | 51.162918 | 4.4531 | 800 | 192 | 143 | 113 | 51.1552335 | 4.452079 | 857 | |
6418 | 2022-07-11 10:23:15.042402 | 43EA12 | 1000 | 51.148294 | 4.459381 | 2675 | 0 | 276 | 250 | 51.1552335 | 4.452079 | 925 | |
6425 | 2022-07-12 13:18:19.26576 | 44CD75 | 2000 | 51.158752 | 4.463567 | 1750 | 512 | 218 | 88 | 51.1552335 | 4.452079 | 893 | |
6481 | 2022-07-24 10:41:52.739754 | 407908 | 7000 | 51.159885 | 4.444809 | 1375 | -1152 | 44 | 140 | 51.1552335 | 4.452079 | 725 | |
6550 | 2022-08-07 10:05:19.767517 | 44CE85 | 0000 | 51.159485 | 4.462676 | 400 | 320 | 204 | 126 | 51.1552335 | 4.452079 | 879 | |
6589 | 2022-08-15 17:26:43.854727 | 44B5B4 | 1000 | 51.16212 | 4.460907 | 1700 | -384 | 291 | 179 | 51.1552335 | 4.452079 | 984 | |
6666 | 2022-08-31 13:56:56.216182 | 44B60C | 0000 | 51.160126 | 4.458742 | 875 | 64 | 221 | 124 | 51.1552335 | 4.452079 | 716 | |
6672 | 2022-09-01 13:50:20.313905 | 3CE005 | 2762 | 51.147782 | 4.457397 | 2875 | -1536 | 276 | 258 | 51.1552335 | 4.452079 | 908 | |
6679 | 2022-09-03 15:29:50.007248 | 4850D0 | 1000 | 51.14772 | 4.450428 | 3200 | -1088 | 314 | 290 | 51.1552335 | 4.452079 | 843 | |
6693 | 2022-09-07 07:28:35.478203 | 44CD75 | 2000 | 51.158936 | 4.460449 | 1050 | -64 | 225 | 101 | 51.1552335 | 4.452079 | 715 | |
6841 | 2022-11-16 07:27:40.599536 | 44CE85 | 6302 | 51.162781 | 4.459484 | 1350 | -192 | 215 | 105 | 51.1552335 | 4.452079 | 986 | |
6983 | 2023-01-28 10:13:15.129192 | 4488B4 | 2000 | 51.146484 | 4.450354 | 475 | 64 | 17 | 77 | 51.1552335 | 4.452079 | 980 | |
7033 | 2023-03-01 21:57:54.782016 | A8164D | 6303 | 51.147949 | 4.456218 | 575 | -512 | 348 | 153 | 51.1552335 | 4.452079 | 860 | |
7038 | 2023-03-02 14:39:16.151954 | 44CD75 | 2000 | 51.161407 | 4.460895 | 825 | -256 | 272 | 97 | 51.1552335 | 4.452079 | 923 | |
7114 | 2023-04-20 14:18:07.962702 | 44D9B6 | 1000 | 51.148865 | 4.448498 | 2575 | -960 | 315 | 221 | 51.1552335 | 4.452079 | 751 | |
7179 | 2023-05-12 13:59:36.878208 | 44CD75 | 2000 | 51.159851 | 4.460078 | 1300 | 320 | 213 | 120 | 51.1552335 | 4.452079 | 759 | |
7223 | 2023-05-26 09:03:31.976644 | 403144 | 7000 | 51.153228 | 4.46167 | 800 | 0 | 230 | 122 | 51.1552335 | 4.452079 | 707 | |
7259 | 2023-06-01 12:13:29.635122 | 44CD75 | 2000 | 51.162259 | 4.457397 | 1350 | 0 | 248 | 109 | 51.1552335 | 4.452079 | 865 | |
7313 | 2023-06-11 17:46:55.536867 | 44CE85 | 6303 | 51.158432 | 4.448349 | 800 | 128 | 210 | 134 | 51.1552335 | 4.452079 | 441 | |
7328 | 2023-06-14 08:23:03.33834 | 44CD75 | 2000 | 51.159885 | 4.459076 | 1575 | 448 | 243 | 97 | 51.1552335 | 4.452079 | 712 | |
7583 | 2023-09-07 11:47:28.46267 | 448649 | 2000 | 51.162818 | 4.454117 | 1325 | -64 | 260 | 126 | 51.1552335 | 4.452079 | 855 | |
7761 | 2023-11-03 08:43:12.905547 | 448ED2 | 7000 | 51.163051 | 4.451218 | 1775 | 64 | 155 | 76 | 51.1552335 | 4.452079 | 871 | |
7808 | 2023-11-17 11:31:01.926135 | 44A0B9 | 2000 | 51.14713 | 4.452972 | 500 | -64 | 7 | 95 | 51.1552335 | 4.452079 | 903 | |
7920 | 2024-01-29 08:29:31.989351 | A8164D | 2000 | 51.163651 | 4.455179 | 500 | 192 | 211 | 132 | 51.1552335 | 4.452079 | 961 | |
7999 | 2024-03-09 13:44:01.632049 | 44CA0F | 2000 | 51.163377 | 4.452972 | 2000 | 448 | 213 | 74 | 51.1552335 | 4.452079 | 908 | |
8042 | 2024-03-26 11:21:19.919158 | A280FF | 2000 | 51.161545 | 4.453323 | 1675 | 128 | 229 | 153 | 51.1552335 | 4.452079 | 707 | |
8086 | 2024-04-14 18:03:10.955430 | 4488F2 | 0000 | 51.159233 | 4.44809 | 100 | 0 | 153 | 6 | 51.1552335 | 4.452079 | 525 | |
5660 | 2021-08-26 14:33:56.28668 | 43EE26 | 2252 | 2CAMP | 51.158936 | 4.442485 | 2225 | -1280 | 119 | 247 | 51.1552335 | 4.452079 | 787 |
4480 | 2019-09-06 10:25:03.84331 | 43EC5E | 5725 | 2COOK | 51.163422 | 4.44924 | 1275 | -896 | 110 | 140 | 51.1552335 | 4.452079 | 932 |
3242 | 2017-05-29 12:59:49.377991 | 43EB71 | 7273 | 2MAPP | 51.163651 | 4.455476 | 1900 | -448 | 115 | 156 | 51.1552335 | 4.452079 | 966 |
3246 | 2017-06-01 06:22:57.971988 | 43EB71 | 7134 | 2MAPP | 51.147812 | 4.456589 | 2775 | 0 | 283 | 161 | 51.1552335 | 4.452079 | 883 |
3481 | 2018-01-05 18:24:09.848995 | 43EBCC | 2237 | 2TBMI | 51.155502 | 4.445306 | 2300 | -960 | 111 | 189 | 51.1552335 | 4.452079 | 474 |
3482 | 2018-01-06 16:16:16.879258 | 43EBCC | 4407 | 2TBMI | 51.156143 | 4.459855 | 4125 | 448 | 253 | 188 | 51.1552335 | 4.452079 | 553 |
6701 | 2022-09-11 11:46:01.688604 | 4D404F | 7000 | 3AMFM | 51.15834 | 4.462973 | 775 | 64 | 205 | 107 | 51.1552335 | 4.452079 | 836 |
4709 | 2020-01-18 12:05:32.239653 | 4D224B | 1000 | 9HCFB | 51.160165 | 4.446716 | 1350 | 0 | 108 | 205 | 51.1552335 | 4.452079 | 664 |
3894 | 2018-10-18 12:21:40.552954 | 4D20B2 | 2127 | 9HJDV | 51.15537 | 4.464874 | 1500 | -448 | 254 | 183 | 51.1552335 | 4.452079 | 895 |
3998 | 2018-12-04 14:49:06.434795 | 4D20B2 | 5146 | 9HJDV | 51.1577 | 4.441223 | 1550 | -1152 | 95 | 142 | 51.1552335 | 4.452079 | 807 |
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 );