aircraft
4,898 rows sorted by speed_in_mph
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4352 | 2019-07-16 09:32:38.713481 | 44BC61 | 1000 | 51.162506 | 4.448275 | 1300 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 851 | |
5743 | 2021-09-16 16:50:35.538544 | 48463D | 6366 | 51.162872 | 4.456515 | 1100 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 904 | |
5745 | 2021-09-16 16:55:39.935244 | 48463D | 6366 | PHKOK | 51.152252 | 4.465497 | 375 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 995 |
6327 | 2022-04-16 09:17:38.386564 | 4043BA | 7000 | 51.160263 | 4.46082 | 1000 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 828 | |
6506 | 2022-07-30 05:33:18.825804 | 4864BD | 6363 | PHVIT | 51.163239 | 4.446048 | 1300 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 985 |
6507 | 2022-07-30 05:38:21.668975 | 4864BD | 6363 | PHVIT | 51.15358 | 4.459113 | 1475 | 0 | 0 | 0 | 51.1552335 | 4.452079 | 525 |
7526 | 2023-07-18 18:49:12.50695 | 4489D4 | 6367 | OOBNT | 51.164017 | 4.451764 | 225 | 0 | 0 | 1 | 51.1552335 | 4.452079 | 977 |
5741 | 2021-09-16 16:40:44.910498 | 4488CD | 6364 | OOBFM | 51.154159 | 4.458389 | 275 | 0 | 153 | 4 | 51.1552335 | 4.452079 | 457 |
6537 | 2022-08-06 05:16:52.684464 | 448B4D | 6365 | OOBZM | 51.155416 | 4.454269 | 625 | 0 | 202 | 5 | 51.1552335 | 4.452079 | 154 |
6538 | 2022-08-06 05:21:55.530566 | 448B4D | 6365 | OOBZM | 51.147766 | 4.448646 | 825 | 0 | 211 | 5 | 51.1552335 | 4.452079 | 864 |
8088 | 2024-04-14 18:13:17.042241 | 4488F2 | 6362 | OOBGR | 51.149132 | 4.456329 | 0 | 0 | 158 | 5 | 51.1552335 | 4.452079 | 741 |
5740 | 2021-09-16 16:35:42.071282 | 4488CD | 6364 | OOBFM | 51.158066 | 4.451244 | 125 | 0 | 128 | 6 | 51.1552335 | 4.452079 | 320 |
6536 | 2022-08-06 05:11:49.788032 | 448B4D | 6365 | OOBZM | 51.162771 | 4.45961 | 750 | 0 | 199 | 6 | 51.1552335 | 4.452079 | 990 |
8086 | 2024-04-14 18:03:10.955430 | 4488F2 | 0000 | 51.159233 | 4.44809 | 100 | 0 | 153 | 6 | 51.1552335 | 4.452079 | 525 | |
8087 | 2024-04-14 18:08:14.007021 | 4488F2 | 6362 | OOBGR | 51.15271 | 4.453991 | 475 | 0 | 141 | 6 | 51.1552335 | 4.452079 | 310 |
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 |
5739 | 2021-09-16 16:30:39.175426 | 4488CD | 6364 | 51.162598 | 4.447384 | 250 | 0 | 130 | 9 | 51.1552335 | 4.452079 | 882 | |
7528 | 2023-07-18 18:54:13.060703 | 4489D4 | 6367 | OOBNT | 51.148956 | 4.455995 | 175 | 0 | 163 | 10 | 51.1552335 | 4.452079 | 750 |
6301 | 2022-04-09 16:05:40.124282 | 44CAAE | 2000 | OORUN | 51.14859 | 4.461563 | 850 | -64 | 337 | 45 | 51.1552335 | 4.452079 | 993 |
3692 | 2018-06-13 14:12:40.679918 | 44AA58 | 7000 | OOJRX | 51.14997 | 4.462204 | 600 | 0 | 359 | 54 | 51.1552335 | 4.452079 | 919 |
6961 | 2023-01-13 09:46:23.907922 | 44CA0F | 2000 | OORPO | 51.154358 | 4.465942 | 1050 | 128 | 294 | 54 | 51.1552335 | 4.452079 | 974 |
7513 | 2023-07-16 07:06:43.103748 | 44CAAE | 2000 | OORUN | 51.162598 | 4.445083 | 1075 | -128 | 207 | 54 | 51.1552335 | 4.452079 | 954 |
5364 | 2021-05-08 16:00:01.753502 | 44CA0F | 2000 | OORPO | 51.155742 | 4.465256 | 2050 | 832 | 221 | 55 | 51.1552335 | 4.452079 | 923 |
6865 | 2022-11-26 14:45:45.566597 | 44CAAE | 7000 | OORUN | 51.162958 | 4.449997 | 725 | 256 | 202 | 56 | 51.1552335 | 4.452079 | 871 |
6723 | 2022-10-06 07:54:51.9576 | 44CAAE | 2000 | OORUN | 51.163467 | 4.454585 | 625 | 0 | 216 | 58 | 51.1552335 | 4.452079 | 932 |
7624 | 2023-09-20 14:09:33.320907 | 44CA0F | 2000 | OORPO | 51.154312 | 4.46572 | 2125 | 192 | 223 | 58 | 51.1552335 | 4.452079 | 959 |
6726 | 2022-10-07 12:30:05.896941 | 44CE86 | 7000 | OOSTF | 51.151552 | 4.439392 | 450 | 512 | 122 | 60 | 51.1552335 | 4.452079 | 977 |
3766 | 2018-07-29 09:44:51.803494 | 44D841 | 2000 | OOVBA | 51.163422 | 4.454956 | 800 | 128 | 213 | 62 | 51.1552335 | 4.452079 | 932 |
5095 | 2020-10-31 10:09:28.030051 | 44D841 | 2000 | OOVBA | 51.160812 | 4.462899 | 700 | 192 | 211 | 62 | 51.1552335 | 4.452079 | 978 |
6997 | 2023-02-08 18:30:02.594757 | 44CA0F | 2000 | OORPO | 51.157185 | 4.465179 | 1325 | 512 | 217 | 62 | 51.1552335 | 4.452079 | 941 |
5703 | 2021-09-08 09:32:43.273771 | 4494E8 | 7000 | OOEGH | 51.157371 | 4.465942 | 900 | -768 | 168 | 63 | 51.1552335 | 4.452079 | 998 |
6587 | 2022-08-15 10:30:14.556127 | 44CE86 | 2000 | OOSTF | 51.164028 | 4.45015 | 1400 | -256 | 254 | 63 | 51.1552335 | 4.452079 | 987 |
5665 | 2021-08-27 13:43:39.246655 | 44CE83 | 2000 | OOSTC | 51.15402 | 4.4384 | 500 | 128 | 28 | 64 | 51.1552335 | 4.452079 | 966 |
7084 | 2023-03-18 16:18:39.572804 | 45C10B | 2000 | OYPHK | 51.163101 | 4.458148 | 1400 | 640 | 205 | 64 | 51.1552335 | 4.452079 | 972 |
7450 | 2023-06-26 08:00:50.87748 | 44CAAE | 2000 | OORUN | 51.162827 | 4.455105 | 1475 | -64 | 204 | 64 | 51.1552335 | 4.452079 | 870 |
4733 | 2020-02-07 09:26:59.04377 | 44D841 | 2000 | OOVBA | 51.160034 | 4.46186 | 600 | 128 | 211 | 65 | 51.1552335 | 4.452079 | 868 |
4843 | 2020-06-27 09:36:42.871122 | 44D841 | 2000 | OOVBA | 51.157471 | 4.438625 | 900 | 64 | 191 | 65 | 51.1552335 | 4.452079 | 973 |
5120 | 2020-11-13 08:57:15.029183 | 44D841 | 2000 | OOVBA | 51.160767 | 4.462973 | 800 | 256 | 206 | 65 | 51.1552335 | 4.452079 | 979 |
7488 | 2023-07-09 07:01:28.181959 | 44CAAE | 2000 | OORUN | 51.163696 | 4.448424 | 925 | 0 | 195 | 65 | 51.1552335 | 4.452079 | 975 |
4122 | 2019-03-21 15:40:03.502522 | A0CBEC | 7000 | N150TV | 51.154587 | 4.464532 | 600 | 0 | 294 | 66 | 51.1552335 | 4.452079 | 874 |
6183 | 2022-03-13 16:45:42.516333 | 44ADEB | 7000 | OOKOK | 51.163842 | 4.450836 | 2050 | 448 | 239 | 67 | 51.1552335 | 4.452079 | 961 |
6989 | 2023-02-02 13:31:55.400742 | 449893 | 7000 | OOFDS | 51.16198 | 4.460144 | 825 | -448 | 302 | 67 | 51.1552335 | 4.452079 | 938 |
5837 | 2021-10-16 14:47:09.487301 | 448423 | 2000 | OOAAC | 51.157418 | 4.464722 | 1750 | 256 | 240 | 68 | 51.1552335 | 4.452079 | 917 |
5941 | 2021-12-11 08:57:21.913526 | 448423 | 2000 | OOAAC | 51.154953 | 4.466314 | 975 | 0 | 303 | 68 | 51.1552335 | 4.452079 | 996 |
6843 | 2022-11-16 10:49:52.067657 | 44D872 | 2000 | OOVCR | 51.162735 | 4.448721 | 1800 | 192 | 201 | 68 | 51.1552335 | 4.452079 | 866 |
6887 | 2022-12-13 17:55:26.141621 | 448649 | 2000 | OOARI | 51.162958 | 4.452744 | 1700 | -128 | 207 | 68 | 51.1552335 | 4.452079 | 860 |
6982 | 2023-01-27 15:21:22.417328 | 44CD75 | 7000 | OOSKU | 51.148727 | 4.442634 | 625 | 64 | 27 | 68 | 51.1552335 | 4.452079 | 980 |
7700 | 2023-10-13 07:59:07.694047 | 44CD75 | 2000 | OOSKU | 51.156189 | 4.464309 | 2100 | -512 | 213 | 68 | 51.1552335 | 4.452079 | 862 |
6253 | 2022-03-26 12:47:21.597318 | 448423 | 2000 | OOAAC | 51.14862 | 4.444122 | 525 | 448 | 62 | 69 | 51.1552335 | 4.452079 | 922 |
6929 | 2022-12-27 14:40:52.308592 | 448ED2 | 2000 | OOCVR | 51.161911 | 4.459187 | 1175 | -512 | 224 | 70 | 51.1552335 | 4.452079 | 893 |
4652 | 2019-12-11 13:35:44.459958 | 44CE86 | 2000 | OOSTF | 51.152856 | 4.440765 | 950 | -64 | 76 | 71 | 51.1552335 | 4.452079 | 834 |
4665 | 2019-12-19 12:12:40.493777 | 44D841 | 2000 | OOVBA | 51.161934 | 4.460907 | 1200 | -128 | 216 | 71 | 51.1552335 | 4.452079 | 968 |
6482 | 2022-07-24 15:57:16.321502 | 44CD75 | 2000 | OOSKU | 51.160767 | 4.462379 | 1775 | 448 | 211 | 71 | 51.1552335 | 4.452079 | 947 |
7918 | 2024-01-28 11:05:04.934190 | 44D86C | 7000 | OOVCL | 51.161794 | 4.443665 | 1075 | -64 | 203 | 71 | 51.1552335 | 4.452079 | 937 |
6505 | 2022-07-29 13:26:41.894122 | 44CE86 | 2000 | OOSTF | 51.150575 | 4.440765 | 850 | -320 | 12 | 72 | 51.1552335 | 4.452079 | 946 |
6633 | 2022-08-24 17:50:36.928054 | 44CE86 | 7000 | OOSTF | 51.160397 | 4.44046 | 875 | 0 | 60 | 72 | 51.1552335 | 4.452079 | 995 |
7466 | 2023-07-01 13:43:24.764113 | 44CAAE | 2000 | OORUN | 51.164028 | 4.449615 | 1400 | -128 | 174 | 72 | 51.1552335 | 4.452079 | 993 |
7913 | 2024-01-27 10:10:11.133422 | 44D872 | 2000 | OOVCR | 51.162689 | 4.456589 | 1350 | -64 | 209 | 72 | 51.1552335 | 4.452079 | 887 |
4197 | 2019-04-30 15:07:57.28622 | A0CBEC | 7000 | N150TV | 51.146478 | 4.449081 | 800 | 0 | 59 | 73 | 51.1552335 | 4.452079 | 996 |
4978 | 2020-09-01 13:01:11.268958 | 44DA62 | 2000 | OOVSB | 51.148806 | 4.442902 | 1750 | 320 | 352 | 73 | 51.1552335 | 4.452079 | 961 |
5986 | 2022-01-02 11:45:57.559351 | 4486F4 | 7000 | OOAWT | 51.163055 | 4.449389 | 1075 | -576 | 197 | 73 | 51.1552335 | 4.452079 | 890 |
6990 | 2023-02-03 10:59:43.876026 | 3D3B6D | 1000 | DEUTH | 51.150342 | 4.462738 | 2550 | 128 | 273 | 73 | 51.1552335 | 4.452079 | 923 |
7799 | 2023-11-12 14:03:06.766299 | 4494E8 | 2000 | OOEGH | 51.15402 | 4.438095 | 1000 | 0 | 147 | 73 | 51.1552335 | 4.452079 | 987 |
3381 | 2017-09-05 10:10:27.191507 | 44B5AD | 5172 | BCG02 | 51.163696 | 4.456366 | 2275 | 640 | 274 | 74 | 51.1552335 | 4.452079 | 988 |
5240 | 2021-02-28 10:30:22.135321 | 448423 | 2000 | OOAAC | 51.147537 | 4.450725 | 650 | 384 | 22 | 74 | 51.1552335 | 4.452079 | 861 |
5592 | 2021-07-24 12:51:07.379135 | 44CA0F | 2000 | OORPO | 51.150947 | 4.464645 | 2125 | 448 | 242 | 74 | 51.1552335 | 4.452079 | 1000 |
5623 | 2021-08-10 12:21:30.415834 | 448423 | 7000 | OOAAC | 51.156208 | 4.464264 | 975 | 0 | 247 | 74 | 51.1552335 | 4.452079 | 859 |
5813 | 2021-10-09 12:45:50.237545 | 448423 | 2000 | OOAAC | 51.160263 | 4.461192 | 1050 | 320 | 209 | 74 | 51.1552335 | 4.452079 | 848 |
6278 | 2022-04-02 09:52:53.296226 | 44CAAE | 2000 | OORUN | 51.150668 | 4.461594 | 1400 | -64 | 308 | 74 | 51.1552335 | 4.452079 | 837 |
7271 | 2023-06-02 17:20:47.120901 | 44CA0F | 2000 | OORPO | 51.150421 | 4.443227 | 775 | 0 | 37 | 74 | 51.1552335 | 4.452079 | 818 |
7430 | 2023-06-23 09:14:34.42613 | 44CAAE | 2000 | OORUN | 51.163051 | 4.459076 | 1350 | 512 | 161 | 74 | 51.1552335 | 4.452079 | 997 |
7999 | 2024-03-09 13:44:01.632049 | 44CA0F | 2000 | 51.163377 | 4.452972 | 2000 | 448 | 213 | 74 | 51.1552335 | 4.452079 | 908 | |
5309 | 2021-04-18 14:04:50.280934 | AC7E2F | 2000 | N904BP | 51.1474 | 4.455105 | 1000 | 64 | 342 | 75 | 51.1552335 | 4.452079 | 896 |
5442 | 2021-06-01 12:55:30.675888 | 44CA0F | 2000 | OORPO | 51.146484 | 4.452209 | 950 | -192 | 33 | 75 | 51.1552335 | 4.452079 | 973 |
5751 | 2021-09-18 14:56:49.480839 | 448423 | 2000 | OOAAC | 51.158954 | 4.462738 | 1525 | 640 | 215 | 75 | 51.1552335 | 4.452079 | 852 |
6182 | 2022-03-13 14:58:28.460784 | 4486F4 | 2000 | OOAWT | 51.160863 | 4.444122 | 1625 | 0 | 178 | 75 | 51.1552335 | 4.452079 | 837 |
6582 | 2022-08-14 06:27:13.068653 | 44CD75 | 0000 | OOSKU | 51.161453 | 4.457925 | 2050 | 896 | 226 | 75 | 51.1552335 | 4.452079 | 803 |
6828 | 2022-11-10 17:14:39.854752 | 4861D7 | 1000 | PHBAR | 51.162166 | 4.449005 | 1850 | 832 | 168 | 75 | 51.1552335 | 4.452079 | 800 |
6842 | 2022-11-16 09:05:24.541728 | 44CA0F | 2000 | OORPO | 51.157139 | 4.465332 | 1600 | -192 | 219 | 75 | 51.1552335 | 4.452079 | 951 |
7228 | 2023-05-26 14:39:17.623066 | 4488B4 | 2000 | OOBET | 51.156301 | 4.438553 | 1000 | -256 | 12 | 75 | 51.1552335 | 4.452079 | 953 |
7622 | 2023-09-19 15:02:39.60197 | A2AB4F | 1000 | N271MJ | 51.155869 | 4.438105 | 3100 | 1280 | 173 | 75 | 51.1552335 | 4.452079 | 980 |
7636 | 2023-09-25 13:36:21.00384 | 44CA0F | 2000 | OORPO | 51.155777 | 4.466314 | 775 | -192 | 280 | 75 | 51.1552335 | 4.452079 | 997 |
7690 | 2023-10-10 10:32:19.830201 | 44CD75 | 2000 | OOSKU | 51.155731 | 4.465052 | 900 | 64 | 244 | 75 | 51.1552335 | 4.452079 | 909 |
7956 | 2024-02-25 15:16:41.362286 | 448423 | 2000 | OOAAC | 51.152069 | 4.465052 | 2425 | 0 | 221 | 75 | 51.1552335 | 4.452079 | 973 |
4024 | 2018-12-19 11:35:28.808551 | A0CBEC | 2000 | N150TV | 51.160309 | 4.463864 | 1300 | 0 | 264 | 76 | 51.1552335 | 4.452079 | 999 |
5112 | 2020-11-08 12:04:21.619554 | 44D841 | 2000 | OOVBA | 51.158752 | 4.464235 | 800 | 64 | 211 | 76 | 51.1552335 | 4.452079 | 936 |
5651 | 2021-08-21 12:29:56.685755 | 44CE83 | 2000 | OOSTC | 51.147689 | 4.459839 | 700 | 128 | 240 | 76 | 51.1552335 | 4.452079 | 999 |
5802 | 2021-10-05 06:13:24.742672 | 406A98 | 4410 | GOXFA | 51.152158 | 4.463425 | 4200 | 1280 | 244 | 76 | 51.1552335 | 4.452079 | 864 |
5984 | 2022-01-01 17:28:23.498515 | 45C10B | 2000 | OYPHK | 51.158707 | 4.439145 | 1300 | 128 | 180 | 76 | 51.1552335 | 4.452079 | 983 |
6120 | 2022-02-28 09:58:12.8024 | 448ED2 | 2000 | OOCVR | 51.147446 | 4.454362 | 825 | 960 | 318 | 76 | 51.1552335 | 4.452079 | 880 |
6352 | 2022-04-24 08:28:30.783823 | 44D872 | 7000 | OOVCR | 51.147308 | 4.448869 | 1250 | 128 | 19 | 76 | 51.1552335 | 4.452079 | 909 |
7072 | 2023-03-15 18:51:20.853525 | 44CD75 | 2000 | OOSKU | 51.159094 | 4.462128 | 1925 | -256 | 219 | 76 | 51.1552335 | 4.452079 | 823 |
7208 | 2023-05-20 10:52:00.969862 | 44D2CF | 7000 | OOTVO | 51.151703 | 4.439887 | 700 | 256 | 3 | 76 | 51.1552335 | 4.452079 | 939 |
7243 | 2023-05-30 11:03:04.724874 | 44A0B9 | 7000 | OOHEY | 51.152716 | 4.439545 | 700 | -128 | 28 | 76 | 51.1552335 | 4.452079 | 920 |
7761 | 2023-11-03 08:43:12.905547 | 448ED2 | 7000 | 51.163051 | 4.451218 | 1775 | 64 | 155 | 76 | 51.1552335 | 4.452079 | 871 | |
7811 | 2023-11-18 08:01:04.431937 | 44CA0F | 2000 | OORPO | 51.161636 | 4.458965 | 1350 | 64 | 255 | 76 | 51.1552335 | 4.452079 | 859 |
7887 | 2024-01-10 18:01:52.830338 | 44CA0F | 2000 | OORPO | 51.163051 | 4.451065 | 1350 | 896 | 232 | 76 | 51.1552335 | 4.452079 | 872 |
3203 | 2017-05-06 12:42:40.310041 | A0CBEC | 7000 | N150TV | 51.151133 | 4.442444 | 1100 | 0 | 63 | 77 | 51.1552335 | 4.452079 | 813 |
4121 | 2019-03-21 15:34:25.180652 | A0CBEC | 7000 | N150TV | 51.148087 | 4.445306 | 600 | 0 | 334 | 77 | 51.1552335 | 4.452079 | 925 |
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 );