黄色电影在线

黄色电影在线The building anthology of a Van's Aircraft RV-14A

02 May 2020

Avionics: New GRT flight data analysis tool (for Garmin and Dynon too).

Do you have a GRT EFIS (and/or Garmin/Dynon)?  I have a GRT.  These EFISs record a lot of data but we don't have good tools available to view those data, especially for GRT.  To that end, I have created a comprehensive and very simple to use Microsoft Excel-based flight data log display tool.  The most up-to-date version will always be found here (use the download icon in the upper right after clicking on the link). 
  • Version 4.0 released 9-Jun-20.
    • A myriad of bug, stability and speed improvements.
    • LOG functions:
      • Automatically create a master database of all aircraft identified by ADS-B.
        • Count number of unique dates each aircraft was found (a "hit").
        • Track dates of each "hit"
        • Single click access to all dates any aircraft was identified (see example at the bottom of this post)..
        • Independent master databases for each aircraft you fly.
        • A new yellow tabbed sheet is maintained to show the records in the master database. 
          • Each aircraft you fly gets its own tab.
      • Aircraft list includes accurate silhouette of aircraft type (see example at the bottom of this post).
        • The aircraft-to-silhouette mapping can be exported and imported to support updates to the mapping.
      •  Magnetic variation is calculated using the IGRF model.
        • Allows wind vector to be now calculated under all conditions.
      • Analog input decoding now supported for HXr, HX, Horizon HS and Horizon WS.
  • Version 3.1 released 3-May-20.
    • LOG functions:
      • Tighter handling of various GPS types and any misalignment between ADS-B source time and GPS source time.
      • Other minor improvements.
  • Version 3.0 released 2-May-20.
    • FDL functions:
      • Squashed bugs.
      • Code optimization yielding speed improvements.
      • Added status bar updates.
      • Added lots more parameters from GRT LOG/demo data.
      • KMZ output
        • Added animation and tour to KMZ output, including "virtual pilot" mode.
          • Includes wind vector and flight director.
          • Added network-linked FAA charts to KMZ.
      • Added Dynon support for CSV files.
    • LOG functions:
      • Initial release.
Late last year, I released my GRT (and later, Garmin) flight data logging (FDL) analysis tool that would take the CSV filerecorded from flight, calculate some statistics, graph variousparameters and plot your flight in Google Earth.  Below are views from the original tool.





I've since made thecode much faster, added a myriad of new parameters and added a "virtual pilot" view so you canwatch your flight in Google Earth, rewind, fast-forward, pause, etc., complete with a wind vector representation and a ground courseindicator. Example flight over the Sierra Nevadas and Lake Tahoe (from a GRT CSV file).



Here's a 4.5-hour flight from 03PR to KEIK compressed to 4 minutes.  Again, note the flight director crosshairs and wind vector indicator (from a Garmin CSV file).


If you're into aerobatics, here are two aileron rolls (from a Garmin CSV file).

 
Now, only for GRT users, this is whereit gets really fun. We all recall that we can record our flightusing a "demo recording", for later playback on any GRT EFIS.In those LOG filesare all the data from all serial port inputs.Thus, a nearlycomplete capture of flight data is retained in the LOG files.

GRT kindly provides the format of thosebinary files.The files can include data from yourADS-B receiver (Stratux, SkyRadar or any GDL90 compliant device likethe GTX-345), should you have it connected to your EFIS.So the demofiles have a full record of every ADS-B packet received during yourflight.Which means that you can visualize other aircraft with Google Earth and rewind, fast-forward, pause, etc.  Let's take a look at what we can now do.

First, you get a lot more parameters to view.


You can get a list of all aircraft in the sky during your flight.A full list is constructed including callsign, registration, type,manufacturer, owner, etc.



Allaircraft flight paths can be rendered in Google Earth at the click of a button. Here are two examples fromKDEN.Red is a descending flight path, green is ascending.


KDEN Traffic 0436 - 1800 UTC.



KDEN Traffic 1800 - 0441 UTC.

Here'san example from very late at night through to in the morning, showing theflight paths of mainly cargo aircraft and passenger transcons.


Front Range, CO traffic 0436-1300 UTC.

Youcan click on any aircraft and get a plethora of data about it,including its past flights, owner, type, etc. and even an actualpicture of that specific aircraft uniquely determined by itsregistration. Many aircraft are accurately represented by the more than 30 icons I include.


You can simply get a handle on how many planes are in the sky during yourflight.


Youcan animate your flight with all other aircraft in the sky. “Ownship” is always the green RV icon.Here's a flight from KMCKto KOIN.


In addition to viewing other aircraft from your GRT EFIS' LOG file ADS-B data, you can independently look at data from any Beast Raw (dump1090-based receivers such as FlightAware, FlightRadar24, ADSBx,etc.) or GDL90 source (e.g., Stratux).  Here's a nearly 24-hour animation of aircraft along the Front Range starting at 0436 UTC and ending at about 0400 UTC the next day.


Youcan click on any aircraft to see its ADS-B report at that time.


Or, you can take the perspective of your cockpit and see the otheraircraft flying around you, like this:


Or,you can select any aircraft and hop in to their cockpit to see thesituation from their view.


Youcan even project current FAA charts on to the terrain.


In all cases, you can either use Google Earth's terrain or project any FAA aviation chart onto the terraininstead (e.g., VFR, IFR high/low, etc.). 

Here is an example of the silhouette display on the list of aircraft identified by your ADS-B receiver.  You can also see the number of times each aircraft has tracked by your receiver with the last date seen. 


Clicking on the last date seen list each date that the aircraft was identified.


For short flights, the programquite quick on a modern computer.GDL90 data is faster to processthan raw ADS-B data (e.g., from SkyRadar).Though dependent on thenumber of aircraft in the sky with you and/or how much data you choose to process, to give you an idea ofprocessing time, my 2-year old computer can process an hour ofSkyRadar data in a 1 minute.An hour of GDL90 data processes in less than aminute.Older computers or those with a hard drive (rather than asolid state drive) will be slower.

GDL90 data sources restrict the radiusof reported aircraft (to accommodate the typically slower serial connection into the EFIS).TheSkyRadar passes all data regardless of distance so you willsee far more aircraft with a SkyRadar than a GDL90 source.I haverun both simultaneously on the same flight and though the SkyRadarsees more, they generally see the same aircraft in your immediatevicinity.

What's required to use it:
    • Tested on Excel 2010 and 365 in Windows.  Does not work on Macs.
  • For ADS-B analysis (not required if you don't plan to do ADS-B analysis):
    • Three separate aircraft databases that are freely available and are automatically downloaded.Uses 800 MB of disk space for initial setup, then approximately 400 MB afterwards.
    • SQLlite database query support for Excel via freely available database engine that is easily installed.
How to use it:
  • FDL:Record your flight data as explained in your EFIS manual.This files are in CSV format.I suggest 400 ms recording interval for GRT.I don't have a Garmin or Dynon, so I don't know if you can change that interval.
  • LOG:Record your demo LOG files in flight as explained in your GRT EFIS manual.These files have a .LOG extension.This is only available to GRT users.
  • Install Google Earth on your computer from http://www.google.com/earth
  • Download the Excel file here.
    • You will need to "EnableContent" when the security warning for the active contentappears.
    • Read the instructions on the“Welcome” sheet.You built a kit plane so I know you can readthe instructions :)
This program represents several hundred hours of development time by me.  However, it surely has bugs.  If you find a bug, send me your CSV/LOG file(s) and the spreadsheet you used plus information describing the issue.  My contact information is on the spreadsheet.

Here's a mostly-complete accounting ofthe features of this tool.

FDL Functions
  • More than 88 engine and flight parameters available for plotting and viewing.
    • Each graph is one-clickzoomable with user-defined zoom scales.
    • Extrema of all parametersshown.
    • Times on ground and in aircalculated.
  • Integrated UTC offset to set displayed times to local.
  • Nearly all parameters have user-defined names, units and significant digits.
  • Complete instructions provided on spreadsheet, including how to setup your GRT EFIS to record flight data.
  • Plots all data or, to focus on a particular portion of a flight, only a specific time period.
  • KMZ file, for integration into Google Earth, automatically generated.
    • 74 selectable engineparameters and flight data shown at each point on the 3D map, includingdistance and time to next plotted point.
    • All points can be plotted or
      • Four optional user-selectable thresholds to control which points to plot.
      • Plotting at user-defined epochs (e.g., every 30 seconds)
      • Lines colored according to user-defined flight status parameters (ground, climb or descend).
      • Aircraft registration, flight time and date integrated into route names to manage multiple saved flights in Google Earth.
      • Airplane icon points in direction of magnetic heading.
        • Click on any location to getselected flight and engine data.
        • Each point labeled with thetime using user's UTC offset.
      • Google Earth lets you:
        • Plot multiple flights.
        • Animate your flight path.
        • View flight paths in 3dimensions from any angle.
        • View engine and flight dataspecific to aircraft position.
        • Have far greater positionalresolution than FR24 and FlightAware KML files, and includes flight andengine data.
        • Plot against recentgeo-referenced charts on the terrain (e.g., VFR, IFR, TAC, etc.)rather than satellite imagery.
        • Animate wind vector andspeed indication.
        • Animate ground trackindicator.
        • "Virtual pilot"mode lets you view your flight as though you were back in youraircraft.
          • Create a high quality rendered video of your flight for off-line viewing.
 
LOG/Demo Files Functions
  • Select up to 32 additional parameters for plotting and viewing that are not available in the FDL CSV files, such as
    • CO Guardian PPM, temperature and pressurealtitude.
    • AHRS, EIS and EFIS internaltemperatures and voltages.
    • IAS rate of change, roll rateand barometer setting.
  • View higher resolution AHRS and EIS data than available in the FDL CSV files.
  • Extract ASCII and hexadecimal data from any serial input into a separate file.
  • For ADS-B in equipped aircraft
    • Visualize all aircraft aroundyou in GoogleEarth.
      • Use any combination of terrain viewing.
      • Or place geo-referenced charts on the terrain (e.g., VFR, IFR, TAC, etc.) rather than satellite imagery.
      • Select and order the text fields displayed next to icons
        • Callsign, owner,registration, ICAO, type, manufacturer and/or country.
    • Extract aircraft from the data
      • Full list of extracted aircraft provided.
        • Sort based on callsign,registration, ICAO address, position reports, flight distance, emittercategory, type, manufacturer, country of registration.
        • Links to FAA registration,flight history, aircraft type images and owner provided.
      • Extract all aircraft or select aircraft by
        • Radial distance fromownship.
        • Callsign
        • Minimum number of receivedposition reports
        • Extract only certain timeperiod or from entire data set
      • Identifies aircraft on FAA's blocked list.
      • Export list to CSV file.
    • List of aircraft arealphabetized by selected field in Google Earth
      • Callsign, owner, registration, ICAO, type, manufacturer or country
      • Aircraft list includes accurate silhouette of aircraft type.
        • Mapof aircraft to-silhouette can be exported and imported to supportupdates to the mapping.
        • Automaticallycreate a list of aircraft for which a silhouette could not beresolved. 
          • This list can be used to manually update the mapping.
    • Automaticallycreate a master database of all aircraft identified by ADS-B.
      • Count number of unique dates each aircraft was found (a "hit").
      • Track dates of each "hit".
      • Single-click access to all dates any aircraft was identified.
      • Independent master databases for each aircraft you fly (based on its registration).  Useful if you fly more than one aircraft.
      • A new yellow tab is maintained to show the records in the master database.
        • Eachaircraft you fly gets its own tab.
    • Animate movement of allaircraft
      • Sliders move time forward and back
      • Animate in real-time or sped up as desired
      • Pause at any time and move viewing perspective as desired
      • View the theater from any perspective:
        • Overhead
        • Virtual pilot's view fromyour aircraft.
        • Virtual pilot's view fromany other aircraft.
      • Any arbitrary location.
o    Single-click access andsimple portability: Output is a single KMZ file with all necessary data for  Google Earth.
    • Unique icons represent aircrafttype
      • Specify size of icons
      • Icons point in direction of heading
      • Specific type icons
        • Douglas/McDonnell DouglasDC-10/MD-11
        • Airbus A380, A350, A340,A330, A321/320/A319/A318, A300/310
        • Boeing 737, 747, 747, 757,767, 777, 787
        • Most Bombardier aircraft
        • Cessna jets
        • Embraer ERJ-135/145 andEMB-17x series
        • Cirrus SR series
        • Van's series
        • Aerobatic
        • Balloon and blimp
        • Drone
        • Glider
        • Helicopter
        • Ultralight
        • Ground vehicle
        • Parachute
        • Twin prop
        • Four prop
        • Space vehicle
    • Selectable text fields followeach aircraft
    • Select any aircraft extractedand "fly" from its perspective.
      • Select any aircraft extracted and "fly" from its perspective.
    • Click on any aircraft to view:
      • Callsign
      • Registration
      • Type
      • Manufacturer
      • Country of registration
      • Actual photo
      • Owner
      • Links to historical flights and FAA registration
    • Select/deselect flight-pathlines for any aircraft.
    • Click on any location alongthe flight path for detailed information
      • Altitude, speed, track, time, VSI, heading, emitter category, NIC, NACp, priority and misc data
    • Flight-path lines colorizedaccording to selectable VSI rates
      • Red is descending
      • Green is climbing
    • Automatically downloads FAAand community-created aircraft databases.
    • Watch status of program viameaningful updates.
      • In Excel's status bar and a dedicated window on each page.
      • Statistics are updated during processing.
    • Final statistics providedfollowing processing.
    • For computers with minimalmemory resources, databases can be searched from disk rather than copiedinto memory (significantly slows processing).
    • For advanced users (notrelated to data from GRT EFISs so most folks won't use thesecapabilities).