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

Latest ADS-B: Unavailable · 59.8B messages · 2.3TB | Latest flights: Unavailable · 139.3M flights | 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
timeicaocallsignregistrationaircraft_typelatlonradius_of_containment_mon_groundbaro_altitude_ftgeom_altitude_ftbaro_rate_fpmgeom_rate_fpmground_speed_ktindicated_airspeed_kttrue_airspeed_ktmachtrack_degtrack_rate_deg_sroll_degmagnetic_heading_degtrue_heading_degnav_qnh_hpanav_altitude_mcp_ftnav_altitude_fms_ftnav_heading_degnav_modessquawkemergencyalertspiversionnicnic_baronac_pnac_vsilsil_typegvasdatypeflagsrssi_dbfssourceno_reg_datapialaddmilitaryinterestingowneraircraft_descriptioncategorywind_direction_degwind_speed_ktoutside_air_temp_ctotal_air_temp_cmlattisb
2025-05-03 21:43:34.380000 UTC151f15UTA395RA-73493B73855.59008837.254805186false925675-192-96143.2144.0NULL0.22248.3NULLNULL239.77251.611002.47008NULL236.95[]1501NULLfalsefalse281913perhour22adsb_icao0NULLadsb.lolNULLfalsefalsefalsefalseNULLBOEING 737-800A3NULLNULLNULLNULL[][]
2025-05-03 21:43:41.910000 UTC151f15UTA395RA-73493B73855.58779437.244596186false105080017921696180.9181.0NULL0.28248.3NULLNULL239.59251.431002.47008NULL236.95[]1501nonefalsefalse281913perhour22adsb_icao0NULLadsb.lolNULLfalsefalsefalsefalseNULLBOEING 737-800A3NULLNULLNULLNULL[][]
2025-07-28 21:05:43.580000 UTCa57341N450MTN450MTEC3545.892868-89.7053120false16001675640NULL39.4NULLNULLNULL204.0NULLNULLNULLNULLNULLNULLNULLNULL[]NULLNULLfalsefalseNULL0NULL000perhourNULLNULLtisb_icao0NULLadsb.lolNULLfalsefalsefalsefalseMED-TRANS CORPAIRBUS HELICOPTERS EC-135/635A7NULLNULLNULLNULL[][]
2025-07-28 21:06:14.860000 UTCa57341N450MTN450MTEC3545.884857-89.7091970false20502175832NULL62.1NULLNULLNULL194.9NULLNULLNULLNULLNULLNULLNULLNULL[]NULLNULLfalsefalseNULL0NULL000perhourNULLNULLtisb_icao0NULLadsb.lolNULLfalsefalsefalsefalseMED-TRANS CORPAIRBUS HELICOPTERS EC-135/635A7NULLNULLNULLNULL[][]
2025-07-28 21:06:19.680000 UTCa57341N450MTN450MTEC3545.883392-89.7100680false21252275832NULL71.7NULLNULLNULL203.0NULLNULLNULLNULLNULLNULLNULLNULL[]NULLNULLfalsefalseNULL0NULL000perhourNULLNULLtisb_icao0NULLadsb.lolNULLfalsefalsefalsefalseMED-TRANS CORPAIRBUS HELICOPTERS EC-135/635A7NULLNULLNULLNULL[][]
2025-07-28 21:06:29.560000 UTCa57341N450MTN450MTEC3545.880234-89.7122120false22502400768NULL74.3NULLNULLNULL203.8NULLNULLNULLNULLNULLNULLNULLNULL[]NULLNULLfalsefalseNULL0NULL000perhourNULLNULLtisb_icao0NULLadsb.lolNULLfalsefalsefalsefalseMED-TRANS CORPAIRBUS HELICOPTERS EC-135/635A7NULLNULLNULLNULL[][]
2025-07-28 21:07:09.470000 UTCa57341N450MTN450MTEC3545.866455-89.7231980false27002875640NULL85.5NULLNULLNULL208.7NULLNULLNULLNULLNULLNULLNULLNULL[]NULLNULLfalsefalseNULL0NULL000perhourNULLNULLtisb_icao1NULLadsb.lolNULLfalsefalsefalsefalseMED-TRANS CORPAIRBUS HELICOPTERS EC-135/635A7NULLNULLNULLNULL[][]
2025-07-28 21:20:56.690000 UTCacc85eCXK653N9223EC17229.251694-98.42936675false25252750-704NULL80.5NULLNULLNULL122.3NULLNULLNULLNULL1019.22112NULLNULL[]NULLNULLfalsefalse2911023perhour22adsb_icao0NULLadsb.lolNULLfalsetruefalsefalseDHS OPERATIONS LLCCESSNA 172 SkyhawkA1NULLNULLNULLNULL[][]
2025-07-28 21:21:00.410000 UTCacc85eCXK653N9223EC17229.250912-98.42791475false24752700-768NULL81.1NULLNULLNULL120.4NULLNULLNULLNULL1019.22112NULLNULL[]NULLNULLfalsefalse2911023perhour22adsb_icao0NULLadsb.lolNULLfalsetruefalsefalseDHS OPERATIONS LLCCESSNA 172 SkyhawkA1NULLNULLNULLNULL[][]
2025-07-28 21:21:02.610000 UTCacc85eCXK653N9223EC17229.250549-98.42714775false24502675-704NULL81.5NULLNULLNULL119.4NULLNULLNULLNULL1019.22112NULLNULL[]NULLnonefalsefalse2911023perhour22adsb_icao0NULLadsb.lolNULLfalsetruefalsefalseDHS OPERATIONS LLCCESSNA 172 SkyhawkA1NULLNULLNULLNULL[][]