AustinDizzy
commented
9 months ago So it looks like the average of burning one gallon of AVGAS/jet fuel is 8,939.50 gCO2 emitted, per the US Energy Information Administration: https://www.eia.gov/environment/emissions/co2_vol_mass.php.
And thanks to https://jetadvisors.com/ we now have a mapping for each of these aircrafts' fuel efficiency.
View SQL code
`SELECT DISTINCT aircraft, CASE aircraft WHEN 'Citation Excel' THEN 248 WHEN 'Citation V Ultra' THEN 195 WHEN 'Citation Encore' THEN 180 WHEN 'Citation Bravo' THEN 171 WHEN 'Citation CJ3' THEN 170 WHEN 'Citation CJ4' THEN 218 WHEN 'Citation Sovereign' THEN 283 WHEN 'Challenger 300' THEN 304 WHEN 'Hawker 900XP' THEN 261 WHEN 'Gulfstream 280' THEN 274 WHEN 'Challenger 350' THEN 302 WHEN 'Citation Latitude' THEN 295 WHEN 'King Air B200' THEN 102 WHEN 'Citation XLS+' THEN 241 ELSE '' END as fuel_efficiency FROM trips;`So now we should be able to calculate approximate carbon emissions for each trip ...
Since we know the aircraft type and the approximate distance in nautical miles, we can do some calculations to determine things such as how much CO2 was emitted and its emission intensity.
Would need to find a reliable source for all the plane types used.
select DISTINCT(aircraft) from trips;