aircraft
4,898 rows sorted by squawk
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4058 | 2019-02-08 13:08:19.959075 | 44CE64 | 0000 | BEL17N | 51.15509 | 4.455414 | 6000 | -128 | 107 | 296 | 51.1552335 | 4.452079 | 233 |
4299 | 2019-06-18 14:24:21.274839 | 44DA74 | 0000 | OOVST | 51.160258 | 4.459076 | 1125 | 320 | 178 | 84 | 51.1552335 | 4.452079 | 743 |
4334 | 2019-07-07 13:07:01.162046 | 44C24D | 0000 | OOPRM | 51.156859 | 4.444351 | 1275 | -256 | 95 | 192 | 51.1552335 | 4.452079 | 570 |
4426 | 2019-08-14 10:01:03.777733 | 44AAC1 | 0000 | 51.160071 | 4.440765 | 1900 | 320 | 108 | 193 | 51.1552335 | 4.452079 | 957 | |
4769 | 2020-02-24 07:28:53.82085 | 44CE85 | 0000 | 51.162872 | 4.448201 | 775 | 256 | 218 | 104 | 51.1552335 | 4.452079 | 892 | |
4933 | 2020-07-30 11:41:46.53181 | 44CDCA | 0000 | 51.149139 | 4.444638 | 3150 | -960 | 98 | 237 | 51.1552335 | 4.452079 | 854 | |
5067 | 2020-10-15 10:24:48.745624 | 39B415 | 0000 | CALIBRA | 51.157139 | 4.46106 | 900 | 192 | 165 | 191 | 51.1552335 | 4.452079 | 663 |
5187 | 2021-02-08 13:04:51.768187 | 44CE85 | 0000 | OOSTE | 51.163147 | 4.449389 | 1375 | 704 | 204 | 135 | 51.1552335 | 4.452079 | 900 |
5633 | 2021-08-14 12:04:40.876362 | AC7E2F | 0000 | 51.162073 | 4.44931 | 1000 | -448 | 188 | 107 | 51.1552335 | 4.452079 | 785 | |
5916 | 2021-11-22 14:21:32.114345 | 44CE85 | 0000 | OOSTE | 51.160071 | 4.457626 | 350 | 576 | 205 | 124 | 51.1552335 | 4.452079 | 663 |
6345 | 2022-04-21 18:45:38.084167 | 44CE85 | 0000 | OOSTE | 51.161189 | 4.453583 | 1025 | 256 | 212 | 136 | 51.1552335 | 4.452079 | 670 |
6438 | 2022-07-14 09:17:32.207885 | 44A0B9 | 0000 | OOHEY | 51.162323 | 4.452358 | 700 | 448 | 210 | 101 | 51.1552335 | 4.452079 | 788 |
6550 | 2022-08-07 10:05:19.767517 | 44CE85 | 0000 | 51.159485 | 4.462676 | 400 | 320 | 204 | 126 | 51.1552335 | 4.452079 | 879 | |
6573 | 2022-08-11 16:09:56.184533 | A8167B | 0000 | N620CM | 51.147903 | 4.451096 | 1825 | -448 | 300 | 205 | 51.1552335 | 4.452079 | 818 |
6582 | 2022-08-14 06:27:13.068653 | 44CD75 | 0000 | OOSKU | 51.161453 | 4.457925 | 2050 | 896 | 226 | 75 | 51.1552335 | 4.452079 | 803 |
6666 | 2022-08-31 13:56:56.216182 | 44B60C | 0000 | 51.160126 | 4.458742 | 875 | 64 | 221 | 124 | 51.1552335 | 4.452079 | 716 | |
6670 | 2022-09-01 11:11:22.733931 | 48B216 | 0000 | SPMRX | 51.159119 | 4.458519 | 950 | 448 | 220 | 130 | 51.1552335 | 4.452079 | 624 |
6769 | 2022-10-28 09:04:29.292604 | 44CE85 | 0000 | OOSTE | 51.162352 | 4.446259 | 925 | 448 | 198 | 92 | 51.1552335 | 4.452079 | 890 |
6921 | 2022-12-22 11:33:12.644693 | 44D88D | 0000 | OOVDM | 51.159187 | 4.464722 | 1100 | 384 | 206 | 98 | 51.1552335 | 4.452079 | 987 |
6978 | 2023-01-20 09:56:26.319405 | A8164D | 0000 | FALCO | 51.163284 | 4.455948 | 875 | 0 | 208 | 129 | 51.1552335 | 4.452079 | 935 |
7063 | 2023-03-13 17:02:25.676431 | 44CE85 | 0000 | OOSTE | 51.161002 | 4.441605 | 1325 | -384 | 209 | 114 | 51.1552335 | 4.452079 | 974 |
7100 | 2023-04-17 06:43:28.915238 | 44A0B9 | 0000 | OOHEY | 51.162048 | 4.456292 | 300 | 256 | 210 | 102 | 51.1552335 | 4.452079 | 813 |
7576 | 2023-09-06 12:57:18.024239 | 44CD75 | 0000 | OOSKU | 51.16008 | 4.463715 | 950 | -256 | 213 | 107 | 51.1552335 | 4.452079 | 976 |
7582 | 2023-09-07 09:08:30.564435 | 44CD75 | 0000 | OOSKU | 51.161087 | 4.457554 | 925 | 128 | 219 | 108 | 51.1552335 | 4.452079 | 755 |
8070 | 2024-04-06 15:26:49.732555 | 44CE85 | 0000 | OOSTE | 51.16212 | 4.450302 | 925 | -320 | 219 | 93 | 51.1552335 | 4.452079 | 776 |
8086 | 2024-04-14 18:03:10.955430 | 4488F2 | 0000 | 51.159233 | 4.44809 | 100 | 0 | 153 | 6 | 51.1552335 | 4.452079 | 525 | |
8092 | 2024-04-17 08:04:30.143848 | A8164D | 0000 | FALCO | 51.161591 | 4.458296 | 900 | 128 | 210 | 141 | 51.1552335 | 4.452079 | 830 |
6430 | 2022-07-13 11:33:29.150863 | 3FF851 | 0046 | DMMEH | 51.147766 | 4.449314 | 6025 | 0 | 351 | 131 | 51.1552335 | 4.452079 | 852 |
4974 | 2020-08-30 13:05:28.955336 | 407A35 | 0101 | FLJ613 | 51.147354 | 4.446419 | 4825 | 2112 | 105 | 231 | 51.1552335 | 4.452079 | 961 |
3736 | 2018-07-09 10:57:57.604509 | 44D0A1 | 0102 | JAF3AP | 51.160355 | 4.460227 | 5250 | 1472 | 96 | 232 | 51.1552335 | 4.452079 | 805 |
4203 | 2019-05-06 08:01:27.208728 | A63B7C | 0103 | N500RW | 51.159622 | 4.442634 | 1950 | 2944 | 153 | 155 | 51.1552335 | 4.452079 | 821 |
4030 | 2018-12-22 08:50:58.701049 | 43EA12 | 0104 | MIFFY | 51.150146 | 4.440926 | 4100 | 2944 | 143 | 214 | 51.1552335 | 4.452079 | 963 |
5609 | 2021-07-31 09:22:34.28686 | 4D220E | 0104 | 9HWIT | 51.157425 | 4.438699 | 2550 | 1536 | 165 | 141 | 51.1552335 | 4.452079 | 967 |
6869 | 2022-12-06 15:55:39.881606 | 484F50 | 0106 | FYG80V | 51.156999 | 4.440765 | 4475 | 2112 | 112 | 188 | 51.1552335 | 4.452079 | 815 |
8104 | 2024-04-22 06:08:51.301849 | A92481 | 0106 | TWY312 | 51.161049 | 4.441757 | 4100 | 1216 | 104 | 208 | 51.1552335 | 4.452079 | 969 |
3866 | 2018-10-01 04:46:48.905755 | 44D0A1 | 0107 | JAF2JY | 51.159932 | 4.441299 | 3200 | 2880 | 157 | 170 | 51.1552335 | 4.452079 | 917 |
4097 | 2019-03-07 06:14:28.688865 | A8167B | 0107 | N620CM | 51.155649 | 4.439621 | 4575 | 2688 | 168 | 193 | 51.1552335 | 4.452079 | 872 |
5673 | 2021-08-30 08:18:57.734592 | 4D024D | 0107 | FYL51CB | 51.154449 | 4.439887 | 4625 | 3136 | 95 | 181 | 51.1552335 | 4.452079 | 857 |
7646 | 2023-09-28 05:30:48.996242 | 4858C7 | 0110 | AGR1994 | 51.156876 | 4.441817 | 4925 | 960 | 101 | 219 | 51.1552335 | 4.452079 | 740 |
4287 | 2019-06-15 09:43:24.997484 | 4491E2 | 0111 | FYG51B | 51.1604 | 4.447756 | 3475 | 2624 | 130 | 188 | 51.1552335 | 4.452079 | 649 |
7926 | 2024-02-04 05:45:34.171462 | 449682 | 0111 | JAF3LB | 51.156281 | 4.449166 | 3725 | 1472 | 109 | 233 | 51.1552335 | 4.452079 | 234 |
5507 | 2021-06-20 07:03:57.343161 | 4861DA | 0113 | PHJCV | 51.14997 | 4.441223 | 3950 | 1984 | 137 | 150 | 51.1552335 | 4.452079 | 959 |
6924 | 2022-12-26 10:05:07.79708 | 4D024D | 0113 | FYL22CB | 51.157511 | 4.438705 | 4100 | 3840 | 166 | 186 | 51.1552335 | 4.452079 | 969 |
3857 | 2018-09-27 11:05:20.574443 | 44D0A1 | 0114 | JAF9HB | 51.149178 | 4.46106 | 3600 | 1280 | 253 | 166 | 51.1552335 | 4.452079 | 921 |
4268 | 2019-06-07 15:57:13.342383 | 44AAC1 | 0114 | JAF2975 | 51.153534 | 4.462825 | 4275 | 256 | 247 | 192 | 51.1552335 | 4.452079 | 775 |
6439 | 2022-07-14 13:04:32.161347 | 44846F | 0115 | OOACO | 51.154671 | 4.447937 | 3075 | 1728 | 122 | 204 | 51.1552335 | 4.452079 | 296 |
8106 | 2024-04-22 09:02:06.929439 | 48628C | 0115 | PHEBM | 51.163742 | 4.451096 | 4825 | 4032 | 88 | 203 | 51.1552335 | 4.452079 | 949 |
7187 | 2023-05-13 08:54:07.47129 | 4D0261 | 0116 | FYL71GF | 51.155742 | 4.440079 | 3575 | 3584 | 141 | 181 | 51.1552335 | 4.452079 | 841 |
4431 | 2019-08-17 07:11:42.112232 | A063B7 | 0146 | N124MX | 51.162186 | 4.450651 | 5150 | 0 | 167 | 129 | 51.1552335 | 4.452079 | 779 |
3637 | 2018-05-03 08:55:01.191139 | 4072F7 | 0164 | GZBAV | 51.147034 | 4.451096 | 4275 | -960 | 348 | 249 | 51.1552335 | 4.452079 | 914 |
3995 | 2018-12-01 18:07:40.921705 | 4490C7 | 0214 | OODFG | 51.163656 | 4.450836 | 4500 | -640 | 113 | 244 | 51.1552335 | 4.452079 | 941 |
4248 | 2019-06-01 11:10:21.918722 | 44BC61 | 0244 | 51.161591 | 4.450205 | 1225 | -768 | 99 | 174 | 51.1552335 | 4.452079 | 719 | |
4801 | 2020-04-06 09:03:10.796099 | A63B7C | 0263 | N500RW | 51.163237 | 4.454041 | 1800 | -768 | 108 | 156 | 51.1552335 | 4.452079 | 900 |
3957 | 2018-11-13 12:15:58.039272 | 4485B2 | 0476 | OOAMR | 51.159839 | 4.44313 | 1200 | 0 | 108 | 235 | 51.1552335 | 4.452079 | 809 |
5607 | 2021-07-30 11:39:32.319012 | 44B674 | 0502 | OOMST | 51.162048 | 4.453917 | 1700 | 64 | 108 | 189 | 51.1552335 | 4.452079 | 768 |
6759 | 2022-10-23 22:36:34.10383 | 4952C2 | 0506 | TAP642 | 51.147675 | 4.44538 | 5250 | -768 | 99 | 253 | 51.1552335 | 4.452079 | 962 |
3984 | 2018-11-28 22:26:03.82711 | 4951B7 | 0507 | TAP642 | 51.161453 | 4.451319 | 3875 | -960 | 82 | 258 | 51.1552335 | 4.452079 | 693 |
5294 | 2021-04-12 11:01:19.352679 | 44D068 | 0510 | BEL8M | 51.157471 | 4.442708 | 6250 | -960 | 100 | 318 | 51.1552335 | 4.452079 | 701 |
4879 | 2020-07-17 16:38:40.620081 | A97639 | 0511 | CKS977 | 51.160025 | 4.451675 | 3425 | -1024 | 102 | 231 | 51.1552335 | 4.452079 | 533 |
6847 | 2022-11-17 06:40:42.813086 | 44CCC4 | 0511 | BEL52B | 51.151154 | 4.442188 | 4800 | -128 | 93 | 296 | 51.1552335 | 4.452079 | 827 |
5155 | 2020-12-20 22:14:40.016811 | 44CD8D | 0512 | AAB105 | 51.161515 | 4.445877 | 3225 | -1408 | 96 | 262 | 51.1552335 | 4.452079 | 822 |
3992 | 2018-11-29 17:51:31.399717 | 4951D2 | 0514 | TAP644 | 51.155136 | 4.449166 | 4650 | -320 | 68 | 254 | 51.1552335 | 4.452079 | 204 |
7703 | 2023-10-15 22:09:40.605070 | 495292 | 0516 | TAP642 | 51.159027 | 4.441075 | 3600 | -960 | 62 | 224 | 51.1552335 | 4.452079 | 877 |
8050 | 2024-03-30 16:02:56.935535 | 448C6A | 0523 | OOCCJ | 51.161934 | 4.446106 | 2200 | -448 | 112 | 174 | 51.1552335 | 4.452079 | 854 |
4518 | 2019-09-24 11:31:33.527729 | 4CAB72 | 0527 | RYR1TF | 51.14978 | 4.443079 | 5525 | -2688 | 57 | 266 | 51.1552335 | 4.452079 | 874 |
6713 | 2022-09-17 10:53:26.244702 | 44C069 | 0531 | OOPCI | 51.158249 | 4.441075 | 1050 | -192 | 112 | 159 | 51.1552335 | 4.452079 | 839 |
4743 | 2020-02-12 12:13:37.157823 | 449829 | 0532 | FYG64A | 51.161747 | 4.461288 | 1350 | 256 | 115 | 174 | 51.1552335 | 4.452079 | 969 |
4463 | 2019-08-28 05:13:18.929994 | 44CCC2 | 0533 | 51.158116 | 4.438553 | 6150 | -1152 | 110 | 283 | 51.1552335 | 4.452079 | 999 | |
4370 | 2019-07-27 04:54:46.327977 | 44CCC2 | 0537 | BEL55J | 51.148911 | 4.457925 | 5850 | -896 | 96 | 272 | 51.1552335 | 4.452079 | 813 |
6080 | 2022-02-13 15:23:56.050187 | 4CA56D | 0537 | RYR58MB | 51.160956 | 4.442444 | 4775 | -1152 | 100 | 258 | 51.1552335 | 4.452079 | 927 |
8030 | 2024-03-21 17:42:08.556579 | 4D00D5 | 0542 | LGL43D | 51.162073 | 4.445877 | 1875 | -1280 | 111 | 210 | 51.1552335 | 4.452079 | 875 |
3574 | 2018-03-27 05:19:59.630708 | 44CCD6 | 0550 | BEL52B | 51.15402 | 4.443359 | 5475 | -1280 | 92 | 277 | 51.1552335 | 4.452079 | 624 |
6939 | 2022-12-30 12:03:16.863504 | 44CDC3 | 0552 | BEL1LH | 51.160723 | 4.449921 | 4475 | -960 | 112 | 212 | 51.1552335 | 4.452079 | 629 |
6375 | 2022-07-04 14:48:31.647825 | 4848DF | 0570 | PHTXA | 51.158707 | 4.445677 | 1800 | 0 | 104 | 215 | 51.1552335 | 4.452079 | 591 |
4021 | 2018-12-18 20:05:04.808857 | 4D024C | 0602 | FYL42F | 51.163423 | 4.447098 | 1625 | 64 | 261 | 164 | 51.1552335 | 4.452079 | 975 |
5968 | 2021-12-23 13:17:39.396389 | 4485B2 | 0640 | OOAMR | 51.157558 | 4.445724 | 2475 | -896 | 116 | 233 | 51.1552335 | 4.452079 | 514 |
4624 | 2019-11-17 20:25:20.422702 | A63B7C | 0646 | N500RW | 51.150879 | 4.441743 | 2050 | -1536 | 67 | 214 | 51.1552335 | 4.452079 | 870 |
4760 | 2020-02-16 09:04:28.807969 | 4CA2FE | 0647 | RYR804G | 51.156394 | 4.452667 | 5250 | -1472 | 42 | 259 | 51.1552335 | 4.452079 | 135 |
4871 | 2020-07-14 13:38:29.206794 | 44CDC5 | 0650 | BEL40V | 51.148911 | 4.442114 | 4575 | -2432 | 90 | 287 | 51.1552335 | 4.452079 | 990 |
4849 | 2020-07-01 19:59:49.710286 | 448CD7 | 0653 | OOCFW | 51.147079 | 4.447756 | 1425 | -256 | 94 | 164 | 51.1552335 | 4.452079 | 956 |
5286 | 2021-04-07 10:47:00.244416 | 406A9B | 0670 | GOXFD | 51.153397 | 4.439887 | 1925 | -64 | 77 | 141 | 51.1552335 | 4.452079 | 877 |
4851 | 2020-07-02 11:59:37.89816 | 44C24D | 0671 | OOPRM | 51.15184 | 4.439145 | 1950 | -960 | 98 | 199 | 51.1552335 | 4.452079 | 980 |
5338 | 2021-04-29 13:17:45.630457 | 406AA8 | 0671 | GOXFF | 51.154129 | 4.438922 | 2150 | -384 | 81 | 130 | 51.1552335 | 4.452079 | 928 |
4247 | 2019-05-31 11:04:21.529837 | 484CFE | 0672 | PHTCS | 51.156487 | 4.440308 | 3600 | 64 | 61 | 157 | 51.1552335 | 4.452079 | 835 |
6051 | 2022-02-03 16:56:22.546191 | 406AA8 | 0672 | GOXFF | 51.163147 | 4.45414 | 2200 | -384 | 111 | 146 | 51.1552335 | 4.452079 | 892 |
7028 | 2023-02-27 16:10:59.166982 | 407E87 | 0672 | GCMKJ | 51.161375 | 4.461288 | 2600 | -384 | 267 | 123 | 51.1552335 | 4.452079 | 939 |
4391 | 2019-08-03 15:31:16.451568 | 448C42 | 0673 | OOCBB | 51.163651 | 4.450948 | 1400 | -704 | 110 | 115 | 51.1552335 | 4.452079 | 939 |
5707 | 2021-09-08 13:11:59.231186 | 406AA8 | 0673 | GOXFF | 51.160629 | 4.45941 | 3000 | 320 | 271 | 152 | 51.1552335 | 4.452079 | 789 |
4907 | 2020-07-26 06:03:03.304353 | A2CE75 | 0674 | N280EX | 51.151611 | 4.442856 | 2100 | -64 | 106 | 191 | 51.1552335 | 4.452079 | 760 |
4956 | 2020-08-21 15:08:50.737054 | A2CE75 | 0674 | N280EX | 51.157837 | 4.446869 | 1575 | 320 | 116 | 216 | 51.1552335 | 4.452079 | 465 |
4350 | 2019-07-14 14:06:35.158388 | 448CAA | 0675 | OOCEJ | 51.150787 | 4.443376 | 1550 | -128 | 117 | 184 | 51.1552335 | 4.452079 | 784 |
4548 | 2019-10-12 05:36:15.096825 | 449CA5 | 0675 | OOGEE | 51.162598 | 4.454808 | 2075 | 320 | 105 | 173 | 51.1552335 | 4.452079 | 841 |
6014 | 2022-01-14 16:11:01.943632 | 406AA7 | 0676 | GOXFE | 51.150421 | 4.460375 | 2400 | 64 | 272 | 125 | 51.1552335 | 4.452079 | 789 |
4530 | 2019-09-27 11:07:26.298123 | 44CE6E | 0731 | BEL23Z | 51.161087 | 4.452878 | 6325 | -1728 | 104 | 337 | 51.1552335 | 4.452079 | 653 |
4976 | 2020-08-31 14:32:54.375566 | 448C6A | 0732 | OOCCJ | 51.16347 | 4.454956 | 2675 | -960 | 138 | 187 | 51.1552335 | 4.452079 | 938 |
7255 | 2023-06-01 03:55:50.534726 | 78140E | 0733 | CHH491 | 51.154904 | 4.454651 | 5825 | -1216 | 213 | 288 | 51.1552335 | 4.452079 | 183 |
5937 | 2021-12-07 18:59:49.387981 | 44CE75 | 0735 | BEL2306 | 51.149689 | 4.44924 | 4525 | 0 | 78 | 236 | 51.1552335 | 4.452079 | 648 |
4062 | 2019-02-12 07:42:53.042954 | 44CE78 | 0740 | BEL51J | 51.152756 | 4.449611 | 5950 | -1856 | 75 | 248 | 51.1552335 | 4.452079 | 325 |
5908 | 2021-11-16 18:09:13.822263 | 44D9A6 | 0761 | OOVMF | 51.157837 | 4.449005 | 6300 | -1024 | 102 | 278 | 51.1552335 | 4.452079 | 360 |
3198 | 2017-04-30 13:27:40.00721 | 400AE6 | 1000 | EZY4109 | 51.152527 | 4.441297 | 5075 | -576 | 82 | 216 | 51.1552335 | 4.452079 | 812 |
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 );