PlaneQuery.comSQL + LLM access to flight data since 2024-01-01

Latest flights: 2026-11-08 · 163.6M flights | Free preview: 1,000 rows / 1 GB scanned limit per queryData provided by ADSB.lol under Open Database License
Ask a question. The assistant will write SQL, run it, and update the results pane.

SQL Query

Athena/Trino dialect
Loading Monaco...
10 rows0 B scanned0 ms
icaocallsignregistrationtakeoff_timetakeoff_airport_identlanding_timelanding_airport_identpialaddmilitaryinterestingaircraft_typeowneraircraft_descriptioncategory
010079EGY1121SU-BAF2026-10-27 12:39:07.170000 UTCLPSC2026-10-27 13:48:48.440000 UTCES-0339falsefalsetruefalseC130NULLLOCKHEED C-130 HerculesA0
0100a3MSR542SU-GCF2026-10-27 01:30:59.340000 UTCHE322026-10-27 03:03:50.720000 UTCLTFMfalsefalsefalsefalseA332NULLAIRBUS A-330-200A5
0100a3MSR543SU-GCF2026-10-27 07:58:46.160000 UTCLTFM2026-10-27 09:24:29.880000 UTCEG-0017falsefalsefalsefalseA332NULLAIRBUS A-330-200A5
0100f3SME590SU-SMK2026-10-27 22:25:44.500000 UTCOKKK2026-10-27 22:33:43.160000 UTCOKAJfalsefalsefalsefalseC680NULLCESSNA 680 Citation SovereignA2
010108MSR728SU-GCZ2026-10-27 00:47:25.420000 UTCHE282026-10-27 12:34:38.760000 UTCEG-0017falsefalsefalsefalseB738NULLBOEING 737-800A3
010109MSR771SU-GDA2026-10-27 00:57:00.460000 UTCLTFM2026-10-27 11:56:41.100000 UTCLSGGfalsefalsefalsefalseB738NULLBOEING 737-800A3
0100a4MSR503SU-GCG2026-10-27 01:25:30.820000 UTCOMDW2026-10-27 02:57:06.100000 UTCOEKKfalsefalsefalsefalseA332NULLAIRBUS A-330-200A5
0100dcMSR711SU-GCN2026-10-27 06:42:53.220000 UTCHEBA2026-10-27 15:57:11.560000 UTCLCLKfalsefalsefalsefalseB738NULLBOEING 737-800A3
0100dcMSR712SU-GCN2026-10-27 17:29:37.900000 UTCOLBA2026-10-27 18:08:08.920000 UTCEG-0017falsefalsefalsefalseB738NULLBOEING 737-800A3
0100dfMSR729SU-GCR2026-10-27 06:36:22.480000 UTCHE322026-10-27 17:36:05.230000 UTCEG-0017falsefalsefalsefalseB738NULLBOEING 737-800A3