PIREP Debug View

Detailed inspection of PIREP #5a3d2951-0907-4e8c-b8a9-45dcb2942c12

← Back to PIREP
🔍 Core Attributes
ID 5a3d2951-0907-4e8c-b8a9-45dcb2942c12
Raw Text 
SAN UA /OV 4 EAST OF SAN/TM 0630/FL011/TP B738/SK OVC/WX RA/RM BASES 011 ON APPROACH TO RWY 9
Urgent NO
Observation Time 2023-01-10 06:30:00 UTC
Aircraft Ref B738
🌍 Geographic Data
Latitude 32.7336
Longitude -117.19
Altitude (ft MSL) 1100
🌤️ Weather Conditions
Sky Condition [{"sky_cover" => "OVC"}]
Turbulence Condition nil
Icing Condition nil
Visibility (statute mi) nil
Weather String RA
Temperature (°C) nil
Wind Direction (°) nil
Wind Speed (kt) nil
Vertical Gust (kt) nil
💬 Remarks & Additional
Remarks 
BASES 011 ON APPROACH TO RWY 9
Receipt Time 2023-01-10 06:45:03 UTC
Data (JSONB) nil
🔗 Associations
Batch ID 14e53a92-882e-46ec-a5f2-03584f592beb tds/aircraftreports/production/2023/1/10/h07_m29_aircraftreports.cache.csv.gz
Station ID 28948c0b-5e62-4419-b93e-edf3411723d9 SAN
Aircraft Type Designator ID ae9ed3e8-1ff1-42d0-81b4-1c76d8825a1d B738
⏰ Timestamps
Created At 2023-03-01 20:02:51 UTC
Updated At 2023-03-01 20:02:51 UTC
📄 Raw YAML Dump
---
id: 5a3d2951-0907-4e8c-b8a9-45dcb2942c12
batch_id: 14e53a92-882e-46ec-a5f2-03584f592beb
station_id: 28948c0b-5e62-4419-b93e-edf3411723d9
aircraft_type_designator_id: ae9ed3e8-1ff1-42d0-81b4-1c76d8825a1d
raw_text: SAN UA /OV 4 EAST OF SAN/TM 0630/FL011/TP B738/SK OVC/WX RA/RM BASES 011
  ON APPROACH TO RWY 9
urgent: false
remarks: BASES 011 ON APPROACH TO RWY 9
receipt_time: !ruby/object:ActiveSupport::TimeWithZone
  utc: 2023-01-10 06:45:03.000000000 Z
  zone: &1 !ruby/object:ActiveSupport::TimeZone
    name: Etc/UTC
  time: 2023-01-10 06:45:03.000000000 Z
observation_time: !ruby/object:ActiveSupport::TimeWithZone
  utc: 2023-01-10 06:30:00.000000000 Z
  zone: *1
  time: 2023-01-10 06:30:00.000000000 Z
aircraft_ref: B738
latitude: 32.7336
longitude: -117.19
altitude_ft_msl: 1100
sky_condition:
- sky_cover: OVC
turbulence_condition:
icing_condition:
visibility_statute_mi:
wx_string: RA
temp_c:
wind_dir_degrees:
wind_speed_kt:
vert_gust_kt:
data: {}
created_at: !ruby/object:ActiveSupport::TimeWithZone
  utc: 2023-03-01 20:02:51.980513000 Z
  zone: *1
  time: 2023-03-01 20:02:51.980513000 Z
updated_at: !ruby/object:ActiveSupport::TimeWithZone
  utc: 2023-03-01 20:02:51.980513000 Z
  zone: *1
  time: 2023-03-01 20:02:51.980513000 Z
talk