aircraft
4,898 rows sorted by lat
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3524 | 2018-02-13 20:02:55.581741 | 4CA869 | 1000 | BEL1TE | 51.146292 | 4.451599 | 3125 | 0 | 73 | 222 | 51.1552335 | 4.452079 | 995 |
3721 | 2018-06-29 20:01:23.861753 | 44846F | 4065 | OOACO | 51.146301 | 4.453323 | 1675 | -960 | 275 | 209 | 51.1552335 | 4.452079 | 997 |
5344 | 2021-05-03 05:47:37.104048 | 448525 | 2250 | AAB458 | 51.146301 | 4.450428 | 5600 | -1280 | 93 | 263 | 51.1552335 | 4.452079 | 1000 |
6962 | 2023-01-14 08:17:52.473821 | 491D83 | 3406 | NJE218Q | 51.146301 | 4.450502 | 4650 | -448 | 94 | 255 | 51.1552335 | 4.452079 | 999 |
3296 | 2017-06-30 10:52:09.21404 | 44D0A1 | 5501 | JAF2DV | 51.146339 | 4.450226 | 2500 | -448 | 106 | 205 | 51.1552335 | 4.452079 | 997 |
5917 | 2021-11-22 15:51:56.992642 | 406AA8 | 5110 | GOXFF | 51.146339 | 4.452286 | 3625 | 0 | 277 | 161 | 51.1552335 | 4.452079 | 989 |
3332 | 2017-07-24 16:26:58.582295 | 44B994 | 7000 | OONLT | 51.146347 | 4.450205 | 2300 | -768 | 276 | 201 | 51.1552335 | 4.452079 | 997 |
5204 | 2021-02-13 12:34:10.484384 | 3E3D01 | 1000 | ECA3C | 51.146347 | 4.453026 | 5250 | 1856 | 264 | 274 | 51.1552335 | 4.452079 | 990 |
6904 | 2022-12-18 09:47:31.903377 | 398895 | 1000 | CALIBRA | 51.146347 | 4.450354 | 3700 | 0 | 77 | 202 | 51.1552335 | 4.452079 | 995 |
3677 | 2018-06-03 18:14:19.960304 | 44D0A1 | 7131 | JAF6TX | 51.146385 | 4.454651 | 3975 | 2048 | 258 | 179 | 51.1552335 | 4.452079 | 1000 |
5848 | 2021-10-21 12:33:17.608132 | 44A0B9 | 7000 | 51.146385 | 4.453583 | 1200 | -64 | 37 | 107 | 51.1552335 | 4.452079 | 990 | |
3845 | 2018-09-17 15:49:21.136534 | 44A8A2 | 7147 | JAF4KY | 51.146393 | 4.452506 | 4150 | 896 | 279 | 217 | 51.1552335 | 4.452079 | 983 |
6132 | 2022-03-03 09:35:12.767515 | 406A99 | 1000 | GOXFB | 51.146393 | 4.451467 | 3450 | 1024 | 275 | 118 | 51.1552335 | 4.452079 | 984 |
7212 | 2023-05-22 15:08:57.231867 | 3D06EE | 5102 | DEAWK | 51.146393 | 4.451541 | 6000 | 0 | 96 | 172 | 51.1552335 | 4.452079 | 984 |
7900 | 2024-01-21 11:16:29.361630 | 3D31D6 | 7114 | DERCW | 51.146393 | 4.452655 | 4750 | 512 | 71 | 187 | 51.1552335 | 4.452079 | 984 |
6315 | 2022-04-12 08:31:22.961931 | 406AA7 | 1000 | GOXFE | 51.146432 | 4.451447 | 3450 | -448 | 276 | 172 | 51.1552335 | 4.452079 | 980 |
7230 | 2023-05-26 16:44:41.953958 | 4B1F14 | 7000 | SFS11 | 51.146432 | 4.449234 | 775 | -192 | 35 | 117 | 51.1552335 | 4.452079 | 999 |
3901 | 2018-10-24 08:19:10.230549 | 4848DF | 4403 | PHTXA | 51.146439 | 4.454733 | 2650 | 64 | 83 | 246 | 51.1552335 | 4.452079 | 995 |
3856 | 2018-09-25 16:06:22.712704 | 4CA58E | 4425 | STK99Q | 51.146478 | 4.455261 | 3250 | 2368 | 271 | 178 | 51.1552335 | 4.452079 | 999 |
4197 | 2019-04-30 15:07:57.28622 | A0CBEC | 7000 | N150TV | 51.146478 | 4.449081 | 800 | 0 | 59 | 73 | 51.1552335 | 4.452079 | 996 |
4960 | 2020-08-23 21:09:18.772064 | A3D78D | 1163 | AJT929 | 51.146478 | 4.455338 | 2850 | -64 | 106 | 261 | 51.1552335 | 4.452079 | 1000 |
5474 | 2021-06-09 12:47:16.589658 | 449CA5 | 6012 | OOGEE | 51.146478 | 4.450073 | 2025 | -64 | 70 | 192 | 51.1552335 | 4.452079 | 984 |
7894 | 2024-01-19 09:12:09.474706 | 44844B | 2000 | OOABK | 51.146478 | 4.454803 | 975 | 0 | 58 | 137 | 51.1552335 | 4.452079 | 992 |
3592 | 2018-04-06 18:45:30.580277 | 4CA2FE | 5543 | RYR71AA | 51.146484 | 4.450279 | 4400 | -448 | 84 | 240 | 51.1552335 | 4.452079 | 981 |
4615 | 2019-11-11 11:58:14.210342 | 44CDC3 | 4737 | BEL54G | 51.146484 | 4.451616 | 4725 | -1024 | 73 | 267 | 51.1552335 | 4.452079 | 973 |
5237 | 2021-02-25 16:52:35.825068 | 4494AA | 7000 | OOEEJ | 51.146484 | 4.451319 | 650 | 320 | 31 | 147 | 51.1552335 | 4.452079 | 974 |
5369 | 2021-05-11 11:00:13.659773 | 406A98 | 5173 | GOXFA | 51.146484 | 4.449314 | 2175 | -192 | 278 | 122 | 51.1552335 | 4.452079 | 992 |
5442 | 2021-06-01 12:55:30.675888 | 44CA0F | 2000 | OORPO | 51.146484 | 4.452209 | 950 | -192 | 33 | 75 | 51.1552335 | 4.452079 | 973 |
6286 | 2022-04-05 08:41:15.862109 | 44A0B9 | 7000 | OOHEY | 51.146484 | 4.448869 | 900 | 64 | 37 | 116 | 51.1552335 | 4.452079 | 998 |
6983 | 2023-01-28 10:13:15.129192 | 4488B4 | 2000 | 51.146484 | 4.450354 | 475 | 64 | 17 | 77 | 51.1552335 | 4.452079 | 980 | |
5274 | 2021-03-31 12:58:01.69862 | 406A9B | 5136 | GOXFD | 51.146525 | 4.450531 | 3775 | 192 | 277 | 127 | 51.1552335 | 4.452079 | 974 |
5384 | 2021-05-14 07:54:44.702508 | A1C4E4 | 5161 | N213CL | 51.146525 | 4.451141 | 3150 | 0 | 277 | 152 | 51.1552335 | 4.452079 | 971 |
5913 | 2021-11-21 12:40:08.998057 | 3D6C9D | 7131 | DFNJP | 51.146525 | 4.449158 | 6025 | 2944 | 74 | 168 | 51.1552335 | 4.452079 | 990 |
6933 | 2022-12-28 18:56:40.703736 | 44CE72 | 2271 | BEL93B | 51.146525 | 4.452972 | 3475 | -512 | 83 | 294 | 51.1552335 | 4.452079 | 970 |
4124 | 2019-03-22 11:37:05.470951 | 44AAC1 | 7107 | JAF32M | 51.14653 | 4.451913 | 3350 | 704 | 279 | 222 | 51.1552335 | 4.452079 | 968 |
4598 | 2019-11-05 10:33:54.96874 | 44DA74 | 7000 | OOVST | 51.14653 | 4.452729 | 1750 | -128 | 281 | 91 | 51.1552335 | 4.452079 | 969 |
5005 | 2020-09-07 11:53:50.214181 | 44D841 | 2000 | OOVBA | 51.14653 | 4.450873 | 800 | -192 | 91 | 95 | 51.1552335 | 4.452079 | 971 |
5380 | 2021-05-13 10:08:25.696953 | 406A98 | 5150 | GOXFA | 51.14653 | 4.45555 | 3200 | 256 | 278 | 132 | 51.1552335 | 4.452079 | 998 |
5443 | 2021-06-01 13:08:02.706371 | 40667E | 2000 | GOZZE | 51.14653 | 4.452506 | 875 | 0 | 352 | 84 | 51.1552335 | 4.452079 | 968 |
6806 | 2022-11-06 15:38:41.399263 | 486442 | 4411 | PHGHZ | 51.14653 | 4.452952 | 5975 | 4160 | 272 | 212 | 51.1552335 | 4.452079 | 970 |
6905 | 2022-12-18 10:15:37.495598 | 398895 | 1000 | CALIBRA | 51.14653 | 4.449463 | 3700 | 0 | 78 | 202 | 51.1552335 | 4.452079 | 985 |
7835 | 2023-12-06 13:33:08.165982 | 440A1F | 7000 | OEXAP | 51.14653 | 4.453546 | 1650 | -704 | 40 | 131 | 51.1552335 | 4.452079 | 973 |
3672 | 2018-05-31 13:38:13.457101 | 44B994 | 2000 | OONLT | 51.146571 | 4.452133 | 2000 | -64 | 96 | 204 | 51.1552335 | 4.452079 | 963 |
5382 | 2021-05-13 12:27:12.290953 | 406A98 | 5155 | GOXFA | 51.146571 | 4.455566 | 3750 | 896 | 257 | 116 | 51.1552335 | 4.452079 | 994 |
6935 | 2022-12-29 20:09:18.06392 | 44AAC1 | 5577 | JAF1EL | 51.146571 | 4.449081 | 2500 | -512 | 106 | 181 | 51.1552335 | 4.452079 | 986 |
3598 | 2018-04-11 12:15:35.406453 | 4CA58D | 4416 | STK99Q | 51.146576 | 4.454659 | 4925 | 1472 | 277 | 184 | 51.1552335 | 4.452079 | 979 |
6201 | 2022-03-18 09:40:36.09189 | 406AA8 | 1000 | GOXFF | 51.146576 | 4.45555 | 2475 | 1152 | 260 | 128 | 51.1552335 | 4.452079 | 993 |
6817 | 2022-11-08 08:20:15.855296 | 4CAD2B | 1000 | RYR8MC | 51.146576 | 4.451616 | 5575 | -640 | 92 | 259 | 51.1552335 | 4.452079 | 963 |
3635 | 2018-05-02 14:08:51.38172 | 495235 | 1000 | JAF2MG | 51.146618 | 4.454803 | 5450 | -960 | 92 | 223 | 51.1552335 | 4.452079 | 977 |
4537 | 2019-09-30 04:34:36.218446 | 44D0A1 | 1000 | JAF30J | 51.146618 | 4.453964 | 3850 | -512 | 93 | 212 | 51.1552335 | 4.452079 | 967 |
4813 | 2020-06-01 11:59:33.729599 | 44CE85 | 6313 | OOSTE | 51.146618 | 4.455872 | 1300 | 640 | 30 | 118 | 51.1552335 | 4.452079 | 994 |
5950 | 2021-12-17 10:57:42.71643 | 398895 | 1000 | CALIBRA | 51.146618 | 4.455414 | 3275 | 0 | 259 | 210 | 51.1552335 | 4.452079 | 986 |
7413 | 2023-06-17 10:53:05.191896 | 44CD75 | 2000 | OOSKU | 51.146618 | 4.45015 | 950 | 0 | 44 | 96 | 51.1552335 | 4.452079 | 967 |
4290 | 2019-06-16 10:03:43.202494 | 44AAC1 | 5541 | JAF4CP | 51.146622 | 4.448498 | 1925 | -320 | 97 | 200 | 51.1552335 | 4.452079 | 990 |
4353 | 2019-07-16 17:52:08.632297 | 44D0A1 | 1000 | JAF3VE | 51.146622 | 4.448201 | 1725 | -384 | 93 | 185 | 51.1552335 | 4.452079 | 995 |
4804 | 2020-04-09 09:50:08.237339 | 44DA74 | 2000 | OOVST | 51.146622 | 4.452358 | 1225 | 320 | 296 | 102 | 51.1552335 | 4.452079 | 958 |
5508 | 2021-06-20 09:14:19.110126 | AC7E2F | 5160 | N904BP | 51.146622 | 4.452878 | 1200 | -640 | 51 | 100 | 51.1552335 | 4.452079 | 959 |
5635 | 2021-08-15 11:44:52.492832 | 44D0A1 | 5375 | JAF1EL | 51.146622 | 4.44924 | 3650 | -1536 | 106 | 257 | 51.1552335 | 4.452079 | 978 |
7470 | 2023-07-03 09:58:56.890216 | 44A0B9 | 2000 | OOHEY | 51.146622 | 4.452432 | 900 | -64 | 33 | 122 | 51.1552335 | 4.452079 | 958 |
5128 | 2020-11-21 03:26:40.937676 | 3C71A4 | 2253 | BCS923 | 51.146664 | 4.4487 | 5850 | -2560 | 89 | 289 | 51.1552335 | 4.452079 | 982 |
6616 | 2022-08-22 10:32:04.567476 | 44D0A1 | 1000 | JAF6LV | 51.146664 | 4.455338 | 2375 | -448 | 300 | 225 | 51.1552335 | 4.452079 | 980 |
6823 | 2022-11-08 16:51:27.138786 | 4D2389 | 1000 | FJO64J | 51.146664 | 4.452362 | 4500 | -832 | 277 | 235 | 51.1552335 | 4.452079 | 953 |
7107 | 2023-04-18 15:00:56.014061 | A8164D | 7000 | FALCO | 51.146664 | 4.448166 | 525 | 0 | 32 | 136 | 51.1552335 | 4.452079 | 991 |
3666 | 2018-05-28 12:33:16.898375 | 4CA6B2 | 4411 | STK99Q | 51.146667 | 4.449611 | 3125 | 1536 | 281 | 184 | 51.1552335 | 4.452079 | 968 |
5761 | 2021-09-21 11:41:55.333025 | 406A98 | 2000 | GOXFA | 51.146667 | 4.45117 | 2900 | 832 | 282 | 128 | 51.1552335 | 4.452079 | 955 |
7288 | 2023-06-07 12:35:32.87671 | 486265 | 1000 | PHTDX | 51.146667 | 4.451987 | 4150 | 832 | 276 | 137 | 51.1552335 | 4.452079 | 953 |
3800 | 2018-08-19 18:47:56.785277 | 44AAC1 | 2321 | JAF5KH | 51.146711 | 4.449615 | 1975 | -448 | 93 | 242 | 51.1552335 | 4.452079 | 963 |
4245 | 2019-05-30 18:26:22.513698 | 44A8A2 | 1000 | JAF3VE | 51.146711 | 4.447784 | 1900 | -320 | 100 | 218 | 51.1552335 | 4.452079 | 994 |
5895 | 2021-11-05 09:19:42.906436 | 44A0B9 | 7000 | OOHEY | 51.146711 | 4.454575 | 800 | 0 | 35 | 101 | 51.1552335 | 4.452079 | 964 |
7239 | 2023-05-29 09:40:11.473697 | 407E87 | 7114 | GCMKJ | 51.146711 | 4.453735 | 3400 | 832 | 278 | 93 | 51.1552335 | 4.452079 | 955 |
4703 | 2020-01-15 10:25:10.225863 | 76CCD1 | 1162 | SIA7979 | 51.146713 | 4.450057 | 4775 | -1024 | 63 | 277 | 51.1552335 | 4.452079 | 958 |
5857 | 2021-10-24 09:22:14.822021 | 44C14D | 1000 | OOPJM | 51.146713 | 4.454808 | 4275 | 2048 | 280 | 172 | 51.1552335 | 4.452079 | 966 |
6104 | 2022-02-26 10:48:19.337441 | 44868F | 2000 | OOATO | 51.146713 | 4.448424 | 400 | 192 | 26 | 83 | 51.1552335 | 4.452079 | 981 |
7706 | 2023-10-16 17:54:48.101321 | 44B430 | 1000 | PGC13P | 51.146713 | 4.449983 | 2750 | 256 | 276 | 250 | 51.1552335 | 4.452079 | 959 |
4148 | 2019-04-05 14:00:37.956449 | 4D0249 | 3013 | FYL351E | 51.146757 | 4.45137 | 4850 | -1088 | 277 | 232 | 51.1552335 | 4.452079 | 944 |
7806 | 2023-11-17 08:23:18.275602 | 44F6A5 | 2000 | ARES501 | 51.146757 | 4.449081 | 275 | 64 | 22 | 87 | 51.1552335 | 4.452079 | 966 |
7951 | 2024-02-23 20:12:13.331007 | 449681 | 1000 | JAF1612 | 51.146757 | 4.454956 | 4025 | -2048 | 13 | 294 | 51.1552335 | 4.452079 | 964 |
4920 | 2020-07-28 10:01:20.350793 | 38A71B | 7000 | FAZXK | 51.146759 | 4.449834 | 1200 | 384 | 278 | 130 | 51.1552335 | 4.452079 | 955 |
8043 | 2024-03-26 13:21:56.385839 | 3D137A | 1000 | DEFPY | 51.146759 | 4.456441 | 3975 | 64 | 255 | 95 | 51.1552335 | 4.452079 | 990 |
4139 | 2019-04-02 05:04:48.363378 | 44A8AD | 7101 | JAF3GD | 51.146804 | 4.455795 | 4050 | 1024 | 268 | 181 | 51.1552335 | 4.452079 | 973 |
4671 | 2019-12-21 12:14:02.390808 | 4CABA3 | 1000 | RYR48VE | 51.146804 | 4.450684 | 5575 | -1280 | 101 | 253 | 51.1552335 | 4.452079 | 942 |
7020 | 2023-02-26 09:39:35.991278 | 4D02D9 | 4131 | JFA43W | 51.146804 | 4.454269 | 1475 | -960 | 329 | 187 | 51.1552335 | 4.452079 | 950 |
4870 | 2020-07-14 12:19:10.400215 | 34560D | 5353 | VLG99BR | 51.146805 | 4.456886 | 6250 | -1216 | 45 | 296 | 51.1552335 | 4.452079 | 996 |
4903 | 2020-07-23 21:19:35.648019 | 44D076 | 1000 | BEL36T | 51.146805 | 4.449389 | 4225 | -384 | 60 | 256 | 51.1552335 | 4.452079 | 956 |
5352 | 2021-05-05 17:06:10.532099 | 44AAC1 | 1061 | JAF1EL | 51.146805 | 4.450354 | 2950 | -128 | 113 | 197 | 51.1552335 | 4.452079 | 945 |
5875 | 2021-10-30 10:18:15.291972 | AAB9B0 | 1000 | N790TB | 51.146805 | 4.454882 | 5025 | 1600 | 267 | 132 | 51.1552335 | 4.452079 | 957 |
6548 | 2022-08-06 17:12:22.271552 | 44D0A1 | 1000 | JAF37C | 51.146805 | 4.451913 | 1175 | -384 | 96 | 224 | 51.1552335 | 4.452079 | 937 |
8139 | 2024-05-04 11:14:03.453703 | 44A3F7 | 7000 | OOH59 | 51.146805 | 4.451244 | 6025 | 64 | 277 | 129 | 51.1552335 | 4.452079 | 939 |
3895 | 2018-10-21 12:27:42.855842 | A0CBEC | 7000 | N150TV | 51.146851 | 4.448646 | 600 | 0 | 333 | 81 | 51.1552335 | 4.452079 | 963 |
3950 | 2018-11-10 23:40:27.014601 | 44D1A2 | 1000 | JAF2032 | 51.146851 | 4.451141 | 6000 | -64 | 64 | 258 | 51.1552335 | 4.452079 | 934 |
4732 | 2020-02-07 09:10:39.936683 | 44A8A2 | 1000 | JAF77B | 51.146851 | 4.45503 | 1475 | -576 | 295 | 203 | 51.1552335 | 4.452079 | 955 |
5002 | 2020-09-07 09:36:29.200202 | 39802B | 2000 | FHABL | 51.146851 | 4.452803 | 700 | -192 | 39 | 111 | 51.1552335 | 4.452079 | 933 |
6446 | 2022-07-16 14:59:16.642516 | 44CE86 | 2000 | OOSTF | 51.146851 | 4.454346 | 700 | -128 | 62 | 104 | 51.1552335 | 4.452079 | 945 |
6812 | 2022-11-07 07:36:49.147027 | 44D1A2 | 1000 | JAF032F | 51.146851 | 4.455105 | 6000 | 0 | 96 | 269 | 51.1552335 | 4.452079 | 956 |
7437 | 2023-06-24 07:02:50.749797 | 44DA62 | 2000 | OOVSB | 51.146851 | 4.446939 | 1675 | 0 | 79 | 124 | 51.1552335 | 4.452079 | 999 |
7931 | 2024-02-12 14:39:33.944781 | 44866C | 1000 | OOASL | 51.146851 | 4.446939 | 1875 | 0 | 72 | 166 | 51.1552335 | 4.452079 | 999 |
5694 | 2021-09-05 10:00:46.217961 | 449052 | 7000 | OODBR | 51.146896 | 4.450651 | 1300 | 64 | 305 | 109 | 51.1552335 | 4.452079 | 932 |
4567 | 2019-10-20 10:20:43.832632 | 39B415 | 1000 | CALIBRA | 51.146897 | 4.455109 | 4150 | 0 | 79 | 184 | 51.1552335 | 4.452079 | 951 |
4629 | 2019-11-21 11:46:28.268213 | 44C14D | 1000 | OOPJM | 51.146897 | 4.453278 | 5750 | 1984 | 277 | 149 | 51.1552335 | 4.452079 | 931 |
4825 | 2020-06-16 09:11:48.838471 | 44AD2E | 1000 | FYG72N | 51.146897 | 4.456558 | 1700 | 64 | 72 | 216 | 51.1552335 | 4.452079 | 978 |
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 );