aircraft
4,898 rows sorted by hex
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4051 | 2019-01-31 14:07:38.412352 | 0100A2 | 6603 | MSX520 | 51.153076 | 4.446642 | 4475 | -64 | 97 | 254 | 51.1552335 | 4.452079 | 449 |
7766 | 2023-11-04 16:51:14.652445 | 020025 | 1000 | RAM832B | 51.156533 | 4.454117 | 6350 | -2240 | 31 | 310 | 51.1552335 | 4.452079 | 203 |
4736 | 2020-02-08 14:56:17.561329 | 020053 | 1000 | RAM832L | 51.163788 | 4.452581 | 6250 | -896 | 43 | 277 | 51.1552335 | 4.452079 | 952 |
5936 | 2021-12-07 17:30:50.374819 | 02005A | 1000 | RAM2678 | 51.151459 | 4.443207 | 5925 | -576 | 99 | 234 | 51.1552335 | 4.452079 | 749 |
6821 | 2022-11-08 15:07:14.541769 | 02006F | 1000 | RAM832B | 51.161362 | 4.451838 | 4550 | -896 | 84 | 299 | 51.1552335 | 4.452079 | 682 |
6782 | 2022-10-31 16:15:05.024379 | 02007A | 1000 | RAM678Q | 51.153854 | 4.438996 | 4550 | -1728 | 84 | 273 | 51.1552335 | 4.452079 | 928 |
4516 | 2019-09-24 08:33:55.707557 | 02007B | 1000 | MAC191 | 51.161561 | 4.450073 | 6425 | -1856 | 84 | 255 | 51.1552335 | 4.452079 | 717 |
3989 | 2018-11-29 11:59:57.499413 | 02009F | 1000 | RAM352 | 51.162259 | 4.448013 | 5950 | -1408 | 92 | 304 | 51.1552335 | 4.452079 | 831 |
7122 | 2023-04-23 17:02:16.119442 | 02009F | 1000 | RAM352 | 51.152158 | 4.457169 | 5350 | -1856 | 84 | 231 | 51.1552335 | 4.452079 | 493 |
5161 | 2020-12-27 11:55:14.061963 | 0200AE | 1000 | RAM834 | 51.157288 | 4.441594 | 5975 | -640 | 55 | 304 | 51.1552335 | 4.452079 | 768 |
3583 | 2018-04-01 11:50:23.809394 | 0200EC | 1000 | RAM838J | 51.148806 | 4.442978 | 5125 | -448 | 96 | 274 | 51.1552335 | 4.452079 | 957 |
8000 | 2024-03-09 15:40:56.208457 | 020104 | 1000 | RAM832B | 51.148453 | 4.450502 | 5150 | -1152 | 39 | 241 | 51.1552335 | 4.452079 | 762 |
4951 | 2020-08-12 11:10:42.640568 | 020105 | 1000 | RAM2830 | 51.155777 | 4.444712 | 5075 | -2048 | 94 | 287 | 51.1552335 | 4.452079 | 518 |
5794 | 2021-10-02 17:13:05.316876 | 020108 | 1000 | MAC113N | 51.148911 | 4.457183 | 3500 | -960 | 83 | 246 | 51.1552335 | 4.452079 | 788 |
6912 | 2022-12-19 09:05:37.01319 | 02010D | 1000 | MAC115D | 51.151692 | 4.441986 | 2925 | -192 | 86 | 280 | 51.1552335 | 4.452079 | 808 |
4613 | 2019-11-11 10:44:13.372673 | 020118 | 1000 | MAC111 | 51.161133 | 4.442782 | 5250 | -1216 | 84 | 278 | 51.1552335 | 4.452079 | 924 |
4905 | 2020-07-25 17:35:46.985627 | 020118 | 1000 | MAC115Y | 51.147263 | 4.451319 | 3700 | -832 | 85 | 264 | 51.1552335 | 4.452079 | 888 |
4913 | 2020-07-27 11:19:40.378037 | 020118 | 1000 | MAC119 | 51.151785 | 4.440918 | 3125 | -960 | 101 | 231 | 51.1552335 | 4.452079 | 870 |
5139 | 2020-12-03 18:27:17.408479 | 020124 | 1000 | MAC113D | 51.156052 | 4.440629 | 4800 | -576 | 63 | 249 | 51.1552335 | 4.452079 | 806 |
5569 | 2021-07-15 18:33:44.615039 | 020127 | 1000 | MAC110Z | 51.161316 | 4.446494 | 6000 | -128 | 105 | 271 | 51.1552335 | 4.452079 | 781 |
3632 | 2018-04-30 16:29:07.482843 | 02012B | 1000 | MAC111 | 51.151154 | 4.4531 | 4425 | 0 | 65 | 236 | 51.1552335 | 4.452079 | 459 |
4104 | 2019-03-12 10:35:51.932749 | 02012B | 1000 | MAC113 | 51.153833 | 4.441147 | 4025 | -896 | 46 | 271 | 51.1552335 | 4.452079 | 780 |
6111 | 2022-02-26 16:30:58.673696 | 020140 | 2302 | MAC110H | 51.159531 | 4.445232 | 3525 | -320 | 55 | 224 | 51.1552335 | 4.452079 | 676 |
5078 | 2020-10-21 09:55:46.952183 | 020145 | 1000 | MAC117L | 51.147828 | 4.453964 | 4375 | -64 | 70 | 269 | 51.1552335 | 4.452079 | 834 |
6469 | 2022-07-19 17:05:10.184667 | 020145 | 1000 | MAC113C | 51.149876 | 4.457245 | 4500 | -512 | 25 | 258 | 51.1552335 | 4.452079 | 697 |
6956 | 2023-01-10 17:08:30.192715 | 020145 | 1000 | MAC113G | 51.151108 | 4.440926 | 4875 | -960 | 103 | 277 | 51.1552335 | 4.452079 | 905 |
7719 | 2023-10-18 18:50:55.683712 | 020175 | 1000 | MAC117C | 51.147828 | 4.453888 | 4300 | -1024 | 87 | 228 | 51.1552335 | 4.452079 | 833 |
6950 | 2023-01-07 17:33:01.522346 | 020177 | 1000 | MAC851F | 51.151566 | 4.443524 | 4225 | -64 | 82 | 267 | 51.1552335 | 4.452079 | 724 |
4086 | 2019-03-03 20:15:01.63882 | 040142 | 5220 | ETH729 | 51.162352 | 4.456177 | 5350 | -1216 | 94 | 308 | 51.1552335 | 4.452079 | 842 |
5089 | 2020-10-27 18:45:37.114384 | 06A1A5 | 5225 | QTR8245 | 51.159233 | 4.440002 | 4175 | -960 | 110 | 216 | 51.1552335 | 4.452079 | 954 |
6187 | 2022-03-14 13:10:41.732766 | 06A1E8 | 2260 | QTR8871 | 51.153927 | 4.442139 | 6450 | -768 | 72 | 255 | 51.1552335 | 4.452079 | 710 |
5160 | 2020-12-27 06:06:42.319181 | 06A1EA | 2255 | QTR8440 | 51.160538 | 4.445603 | 4850 | -1600 | 113 | 219 | 51.1552335 | 4.452079 | 743 |
4808 | 2020-05-24 04:50:03.868782 | 06A1ED | 1163 | QTR8440 | 51.162323 | 4.447236 | 4275 | -1216 | 84 | 286 | 51.1552335 | 4.452079 | 858 |
3996 | 2018-12-01 19:20:46.133278 | 06E010 | 7313 | RWD701 | 51.148061 | 4.454041 | 3425 | -832 | 104 | 256 | 51.1552335 | 4.452079 | 809 |
6809 | 2022-11-06 16:33:36.94942 | 0A0018 | 1034 | DAH2200 | 51.151108 | 4.439664 | 5650 | -2560 | 103 | 284 | 51.1552335 | 4.452079 | 982 |
4057 | 2019-02-08 11:51:50.683377 | 0A008D | 1033 | DAH2062 | 51.148636 | 4.442708 | 4100 | 64 | 26 | 278 | 51.1552335 | 4.452079 | 984 |
5577 | 2021-07-18 14:10:31.948821 | 0D0C90 | 1000 | XACHG | 51.154997 | 4.447632 | 2725 | -128 | 133 | 210 | 51.1552335 | 4.452079 | 312 |
3890 | 2018-10-15 07:56:20.226459 | 3003D0 | 7546 | SSR258 | 51.156464 | 4.462453 | 3050 | -64 | 274 | 213 | 51.1552335 | 4.452079 | 738 |
7087 | 2023-03-21 17:17:48.654227 | 300641 | 2000 | VOR03 | 51.162872 | 4.447533 | 1300 | -64 | 76 | 150 | 51.1552335 | 4.452079 | 907 |
7203 | 2023-05-18 10:18:47.489914 | 300641 | 2000 | VOR03 | 51.151566 | 4.463567 | 1600 | -576 | 230 | 138 | 51.1552335 | 4.452079 | 901 |
7562 | 2023-08-07 10:02:26.63945 | 300641 | 7000 | VOR03 | 51.150742 | 4.44152 | 1500 | -448 | 66 | 137 | 51.1552335 | 4.452079 | 891 |
7889 | 2024-01-11 14:32:10.087507 | 300641 | 2000 | VOR03 | 51.157883 | 4.464829 | 1400 | 0 | 273 | 123 | 51.1552335 | 4.452079 | 939 |
7994 | 2024-03-08 15:26:49.180405 | 300641 | 7000 | VOR03 | 51.157092 | 4.464798 | 2600 | 896 | 274 | 145 | 51.1552335 | 4.452079 | 913 |
7778 | 2023-11-06 22:57:38.127756 | 341119 | 1053 | BCS8049 | 51.150879 | 4.445454 | 6025 | -1664 | 66 | 287 | 51.1552335 | 4.452079 | 670 |
6915 | 2022-12-19 10:54:47.51331 | 34150E | 1000 | IBE32WK | 51.15537 | 4.43924 | 6000 | -832 | 14 | 278 | 51.1552335 | 4.452079 | 898 |
3936 | 2018-11-07 16:11:21.142842 | 341583 | 1000 | AEA17SN | 51.15239 | 4.443895 | 4725 | -768 | 59 | 266 | 51.1552335 | 4.452079 | 654 |
3494 | 2018-01-15 16:52:47.016696 | 342090 | 1000 | IBE32BT | 51.152847 | 4.442559 | 4525 | 0 | 44 | 277 | 51.1552335 | 4.452079 | 717 |
3931 | 2018-11-07 10:35:34.275097 | 342091 | 1000 | IBE32GG | 51.158535 | 4.44252 | 4900 | -1344 | 90 | 246 | 51.1552335 | 4.452079 | 762 |
4695 | 2020-01-13 21:07:03.086613 | 3420CA | 1000 | IBE3208 | 51.158386 | 4.43959 | 4250 | -896 | 67 | 271 | 51.1552335 | 4.452079 | 941 |
4269 | 2019-06-07 16:56:56.245928 | 3420CE | 1000 | IBE2840 | 51.155835 | 4.439468 | 4375 | -128 | 98 | 235 | 51.1552335 | 4.452079 | 884 |
4061 | 2019-02-08 21:00:45.92373 | 342106 | 1000 | IBE3208 | 51.158209 | 4.439621 | 6500 | -1920 | 36 | 316 | 51.1552335 | 4.452079 | 932 |
3197 | 2017-04-30 13:09:04.478607 | 342581 | 5576 | VLG13KL | 51.155183 | 4.442749 | 3225 | -128 | 106 | 217 | 51.1552335 | 4.452079 | 652 |
3544 | 2018-03-02 20:38:36.089983 | 34258F | 1016 | VLG8990 | 51.157371 | 4.440079 | 6075 | -1280 | 68 | 216 | 51.1552335 | 4.452079 | 872 |
3918 | 2018-11-03 08:15:29.065685 | 3430CC | 5347 | VLG8988 | 51.157604 | 4.439011 | 3575 | -64 | 89 | 198 | 51.1552335 | 4.452079 | 951 |
4517 | 2019-09-24 09:15:53.860398 | 343141 | 1000 | IBE32WY | 51.150284 | 4.443895 | 5800 | -1216 | 64 | 269 | 51.1552335 | 4.452079 | 794 |
7769 | 2023-11-06 12:00:14.966838 | 343194 | 5377 | VLG12NR | 51.159302 | 4.444118 | 4350 | -128 | 122 | 241 | 51.1552335 | 4.452079 | 717 |
7785 | 2023-11-08 12:14:49.876575 | 34409A | 5516 | VLG12NR | 51.149085 | 4.447021 | 4150 | -1216 | 90 | 257 | 51.1552335 | 4.452079 | 770 |
6968 | 2023-01-16 09:23:43.694416 | 344157 | 5514 | VLG11UZ | 51.148014 | 4.443665 | 5275 | -1664 | 84 | 268 | 51.1552335 | 4.452079 | 995 |
4180 | 2019-04-24 15:21:57.088669 | 344297 | 1000 | AEA37GP | 51.163423 | 4.447632 | 5600 | -448 | 103 | 235 | 51.1552335 | 4.452079 | 962 |
3582 | 2018-03-30 15:42:17.378403 | 344417 | 1000 | IBE32KB | 51.156533 | 4.449768 | 4675 | -448 | 84 | 222 | 51.1552335 | 4.452079 | 216 |
6785 | 2022-10-31 17:55:30.76947 | 344417 | 1000 | IBE32YK | 51.162446 | 4.450607 | 4075 | -64 | 102 | 240 | 51.1552335 | 4.452079 | 808 |
6763 | 2022-10-27 07:18:12.899398 | 344445 | 1000 | AEA1171 | 51.159027 | 4.440629 | 3850 | -320 | 87 | 243 | 51.1552335 | 4.452079 | 905 |
6955 | 2023-01-10 16:16:56.706053 | 344445 | 1000 | AEA1173 | 51.150558 | 4.454585 | 4200 | -448 | 57 | 279 | 51.1552335 | 4.452079 | 548 |
4675 | 2019-12-21 13:54:38.337502 | 3444DA | 5536 | VLG857Q | 51.150714 | 4.444199 | 5825 | -2496 | 58 | 297 | 51.1552335 | 4.452079 | 746 |
3925 | 2018-11-04 07:54:08.300353 | 344501 | 5512 | VLG8988 | 51.150249 | 4.452515 | 5000 | -896 | 67 | 247 | 51.1552335 | 4.452079 | 555 |
4420 | 2019-08-11 21:53:00.037059 | 344508 | 1000 | JAF2642 | 51.150284 | 4.443079 | 5400 | -2496 | 69 | 276 | 51.1552335 | 4.452079 | 836 |
6735 | 2022-10-09 16:16:10.839693 | 344644 | 5545 | VLG732C | 51.14713 | 4.446411 | 5150 | -640 | 83 | 247 | 51.1552335 | 4.452079 | 984 |
3924 | 2018-11-03 21:02:52.476119 | 344648 | 1000 | IBE3208 | 51.157104 | 4.442634 | 4125 | -2752 | 91 | 269 | 51.1552335 | 4.452079 | 692 |
6951 | 2023-01-07 19:25:33.565258 | 345042 | 5363 | VLG4MP | 51.149318 | 4.441605 | 4975 | -1024 | 59 | 275 | 51.1552335 | 4.452079 | 984 |
6118 | 2022-02-27 17:17:32.161741 | 3450D6 | 2311 | IBE32BF | 51.148154 | 4.446106 | 3600 | 192 | 70 | 237 | 51.1552335 | 4.452079 | 891 |
4096 | 2019-03-06 18:13:55.850052 | 345108 | 5340 | VLG13KZ | 51.148992 | 4.455109 | 4975 | -576 | 76 | 258 | 51.1552335 | 4.452079 | 726 |
4183 | 2019-04-25 08:40:26.492646 | 345245 | 1000 | JAF099P | 51.162918 | 4.448795 | 4275 | 0 | 144 | 193 | 51.1552335 | 4.452079 | 885 |
7962 | 2024-03-01 15:58:07.625123 | 345249 | 5373 | VLG8982 | 51.156952 | 4.443207 | 5475 | -1024 | 104 | 277 | 51.1552335 | 4.452079 | 649 |
4764 | 2020-02-16 13:16:32.973501 | 345313 | 5355 | VLG857Q | 51.151552 | 4.439468 | 4300 | -704 | 80 | 289 | 51.1552335 | 4.452079 | 972 |
4111 | 2019-03-12 17:54:06.491961 | 34538E | 1000 | AEA17SN | 51.155685 | 4.444712 | 4375 | -576 | 65 | 290 | 51.1552335 | 4.452079 | 517 |
6082 | 2022-02-13 17:10:24.87853 | 3455D5 | 2302 | IBE32BF | 51.153927 | 4.443512 | 3275 | -192 | 108 | 231 | 51.1552335 | 4.452079 | 616 |
4870 | 2020-07-14 12:19:10.400215 | 34560D | 5353 | VLG99BR | 51.146805 | 4.456886 | 6250 | -1216 | 45 | 296 | 51.1552335 | 4.452079 | 996 |
6172 | 2022-03-11 16:29:12.999639 | 345643 | 5362 | VLG38SF | 51.155594 | 4.438328 | 4025 | -1280 | 99 | 229 | 51.1552335 | 4.452079 | 962 |
6077 | 2022-02-13 14:10:20.171912 | 345646 | 5373 | VLG38SF | 51.157013 | 4.447607 | 4325 | -1408 | 76 | 267 | 51.1552335 | 4.452079 | 370 |
6762 | 2022-10-27 07:12:59.943527 | 34568A | 5512 | VLG2LW | 51.15065 | 4.441223 | 3925 | -832 | 95 | 272 | 51.1552335 | 4.452079 | 914 |
5881 | 2021-10-31 16:24:49.570828 | 346083 | 1000 | AEA1173 | 51.155869 | 4.440332 | 5075 | -1024 | 125 | 255 | 51.1552335 | 4.452079 | 824 |
4655 | 2019-12-12 20:02:29.334251 | 34608B | 5513 | VLG96EW | 51.155365 | 4.43959 | 5275 | -768 | 101 | 237 | 51.1552335 | 4.452079 | 873 |
4179 | 2019-04-24 12:40:36.813566 | 34610E | 5530 | VLG857Q | 51.150854 | 4.441376 | 4075 | -2304 | 106 | 233 | 51.1552335 | 4.452079 | 893 |
6160 | 2022-03-08 17:40:49.211775 | 346147 | 2305 | IBE32BF | 51.162492 | 4.444885 | 3925 | -704 | 98 | 267 | 51.1552335 | 4.452079 | 951 |
6874 | 2022-12-10 07:26:28.569964 | 346186 | 5555 | VLG2AN | 51.154066 | 4.440842 | 5125 | -1088 | 97 | 226 | 51.1552335 | 4.452079 | 796 |
4936 | 2020-07-31 09:18:40.306879 | 346316 | 1000 | IBE32FL | 51.148773 | 4.447607 | 5700 | -1920 | 99 | 233 | 51.1552335 | 4.452079 | 783 |
5402 | 2021-05-20 10:58:00.630346 | 346355 | 5356 | VLG710V | 51.152577 | 4.441986 | 3900 | -1152 | 88 | 274 | 51.1552335 | 4.452079 | 765 |
6786 | 2022-10-31 20:55:29.906262 | 347287 | 1000 | IBE32HH | 51.15644 | 4.44191 | 5675 | -1664 | 82 | 266 | 51.1552335 | 4.452079 | 723 |
7841 | 2023-12-07 22:58:07.607918 | 347301 | 5504 | BCS8049 | 51.160397 | 4.441757 | 5925 | -1664 | 79 | 255 | 51.1552335 | 4.452079 | 922 |
7779 | 2023-11-07 01:51:38.977674 | 347302 | 2001 | BCS453 | 51.163605 | 4.449389 | 4450 | -960 | 105 | 234 | 51.1552335 | 4.452079 | 950 |
7950 | 2024-02-22 16:10:02.327327 | 347307 | 1000 | AEA13VK | 51.148224 | 4.448349 | 5800 | -2240 | 81 | 281 | 51.1552335 | 4.452079 | 822 |
7788 | 2023-11-08 16:34:48.272110 | 34750F | 1000 | AEA13VK | 51.154764 | 4.449158 | 4175 | -64 | 68 | 274 | 51.1552335 | 4.452079 | 210 |
7790 | 2023-11-08 21:00:14.926152 | 3475D5 | 1000 | IBE32SD | 51.158442 | 4.445724 | 4200 | -2176 | 61 | 314 | 51.1552335 | 4.452079 | 570 |
6432 | 2022-07-13 12:29:45.296741 | 38973B | 7000 | FAZHG | 51.154485 | 4.438705 | 950 | -128 | 29 | 108 | 51.1552335 | 4.452079 | 939 |
6433 | 2022-07-13 12:34:48.194449 | 38973B | 2000 | FAZHG | 51.154858 | 4.439011 | 650 | -128 | 30 | 105 | 51.1552335 | 4.452079 | 915 |
4920 | 2020-07-28 10:01:20.350793 | 38A71B | 7000 | FAZXK | 51.146759 | 4.449834 | 1200 | 384 | 278 | 130 | 51.1552335 | 4.452079 | 955 |
5575 | 2021-07-18 10:23:01.618863 | 38A71B | 7000 | FAZXK | 51.151785 | 4.461365 | 900 | -128 | 278 | 136 | 51.1552335 | 4.452079 | 754 |
5641 | 2021-08-18 11:45:39.881262 | 38A71B | 7000 | FAZXK | 51.148178 | 4.457331 | 1000 | -128 | 272 | 125 | 51.1552335 | 4.452079 | 866 |
8138 | 2024-05-04 10:26:06.948780 | 38A71B | 7000 | FAZXK | 51.14699 | 4.455261 | 1100 | -64 | 276 | 133 | 51.1552335 | 4.452079 | 943 |
6900 | 2022-12-16 13:54:33.089585 | 38E89C | 2000 | FJDZL | 51.150389 | 4.443359 | 1900 | 128 | 33 | 110 | 51.1552335 | 4.452079 | 814 |
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 );