trips
Data license: PDDL
- id
- Trip ID (assigned by the vendor)
- date
- Date of trip (a date range separated with a semicolon for multi-day trips)
- route
- Route of trip
- billing_amount
- Billing Amount (flight_hours * hourly_rate)
- fuel
- Fuel Surcharge
- crew_expense
- Crew Expenses
- landing
- Landing & De-icing Fees
- dom_tax
- Domestic Segment Tax
- justification
- Justification
- distance
- Distance (in nautical miles)
- flight_hours
- Flight hours
816 rows sorted by justification
This data as json, CSV (advanced)
Suggested facets: aircraft, reg_no, num_pax, crew_expense, signed_by_name, approved_by_name, notes, date (date)
id | date | route | aircraft | reg_no | num_pax | justification ▼ | distance | fuel | landing | crew_expense | dom_tax | flight_hours | hourly_rate | billing_amount | signed_by_name | approved_by_name | carbon_footprint | notes | itinerary | reservation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
X20200303 | 2020-03-03 | LBE-MGW-CRW-MGW-LBE | Citation CJ3 | N40WV | 5 | 307.849061 nmi | 202.24 | 308.0 | 150.0 | 0.0 | 2.2 h | 2710.0 | 5962.0 | 3343373 | ||||||
X20200304 | 2020-03-04 | LBE-MGW-CRW | Citation CJ3 | N40WV | 2 | 153.92453 nmi | 61.44 | 218.0 | 150.0 | 0.0 | 2.0 h | 2710.0 | 5420.0 | 3039430 | ||||||
X20200317 | 2020-03-17 | LBE-MGW-CRW-MGW-LBE | Citation V Ultra | N6NY | 1 | 307.849061 nmi | 190.8 | 308.0 | 150.0 | 0.0 | 2.0 h | 2565.0 | 5130.0 | 3486405 | ||||||
X20200319 | 2020-03-19 | LBE-MGW-CRW-MGW-LBE | Citation CJ3 | N40WV | 1 | 307.849061 nmi | 123.2 | 260.0 | 150.0 | 0.0 | 2.0 h | 2710.0 | 5420.0 | 3039430 | ||||||
X20200326 | 2020-03-26 | LBE-MGW-CRW-MGW-LBE | Citation CJ3 | N40WV | 1 | 307.849061 nmi | 92.4 | 308.0 | 150.0 | 0.0 | 2.0 h | 2710.0 | 5420.0 | 3039430 | ||||||
X20200330 | 2020-03-30 | LBE-MGW-CRW-MGW-LBE | Citation Encore | N511TH | 2 | 307.849061 nmi | 146.4 | 308.0 | 150.0 | 0.0 | 2.0 h | 2615.0 | 5230.0 | 3218220 | ||||||
X20210714 | 2021-07-14 | LBE-MGW-CRW-MGW-LBE | Citation Sovereign | N680RB | 6 | 307.849061 nmi | 829.17 | 680.0 | 150.0 | 0.0 | 2.0 h | 2850.0 | 5700.0 | 5059757 | ||||||
X20210715 | 2021-07-15 | LBE-MGW-CNW-MGW-LBE | Challenger 350 | N468CE | 1 | 2.014899 knmi | 1595.08 | 240.0 | 150.0 | 0.0 | 5.6 h | 4745.25 | 26573.4 | 15118482 | ||||||
X20210716 | 2021-07-16 | LBE-MGW-LWB-MGW-LBE | Citation Sovereign | N680RB | 5 | 308.474886 nmi | 384.06 | 486.0 | 150.0 | 0.0 | 2.0 h | 3942.5 | 7885.0 | 5059757 | ||||||
X20210720 | 2021-07-20 | LBE-MGW-BKW-LBE | Citation Encore | N511TH | 2 | 339.231248 nmi | 430.68 | 125.0 | 150.0 | 0.0 | 2.0 h | 2612.5 | 5225.0 | 3218220 | ||||||
X20210721 | 2021-07-21 | LBE-BKW-MGW-LBE | Citation Encore | N511TH | 2 | 339.231248 nmi | 408.12 | 125.0 | 150.0 | 0.0 | 2.0 h | 2612.5 | 5225.0 | 3218220 | ||||||
X20210723 | 2021-07-23 | LBE-MGW-MDW-LBE | Citation Encore | N511TH | 1 | 812.215057 nmi | 936.42 | 637.13 | 150.0 | 0.0 | 2.8 h | 2612.5 | 7315.0 | 4505507 | ||||||
X20210729 | 2021-07-29 | LBE-MGW-CRW-MGW-LBE | Citation Excel | N504LV | 2 | 307.849061 nmi | 568.16 | 560.0 | 150.0 | 0.0 | 2.0 h | 3372.5 | 6745.0 | 4433992 | ||||||
X20210819 | 2021-08-19 | LBE-MGW-CRW-MGW-LBE | Citation CJ3 | N40WV | 3 | 307.849061 nmi | 474.12 | 410.0 | 750.0 | 0.0 | 2.0 h | 2707.5 | 5415.0 | 3039430 | ||||||
X20210821 | 2021-08-21 | LBE-MGW-LWB-MGW-LBE | Citation Encore | N511TH | 2 | 308.474886 nmi | 579.96 | 333.0 | 150.0 | 0.0 | 2.0 h | 2612.5 | 5225.0 | 3218220 | ||||||
X20210901 | 2021-09-01 | LBE-MGW-LWB-LBE | Citation CJ3 | N40WV | 2 | 306.614507 nmi | 507.18 | 166.5 | 150.0 | 0.0 | 2.0 h | 2707.5 | 5415.0 | 3039430 | ||||||
X20210902 | 2021-09-02 | LBE-MGW-LWB-MGW-LBE | Citation XLS+ | N47EK | 5 | 308.474886 nmi | 462.24 | 333.0 | 150.0 | 0.0 | 2.0 h | 3467.5 | 6935.0 | 4308839 | ||||||
X20210903 | 2021-09-03 | LBE-LWB-MGW-LBE | Citation Encore | N511TH | 1 | 306.614507 nmi | 467.64 | 243.0 | 150.0 | 0.0 | 2.0 h | 2612.5 | 5225.0 | 3218220 | ||||||
X20210920 | 2021-09-20 | LBE-MGW-CRW-MGW-LBE | Citation Excel | N504LV | 2 | 307.849061 nmi | 604.2 | 560.0 | 150.0 | 0.0 | 2.5 h | 3372.5 | 8431.25 | 5542490 | ||||||
X20210922 | 2021-09-22 | PIT-MGW-IAD-MGW-LBE | Citation CJ3 | N369MN | 2 | 341.333884 nmi | 660.79 | 652.43 | 150.0 | 0.0 | 2.1 h | 2707.5 | 5685.75 | 3191401 | ||||||
X20190109 | 2019-01-09 | LBE-MGW-CRW-MGW-LBE | Citation CJ3 | N369MN | 4 | 307.849061 nmi | 303.36 | 296.0 | 150.0 | 0.0 | 2.0 h | 2615.0 | 5230.0 | 3039430 | ||||||
X20190110 | 2019-01-10 | LBE-MGW-CMH-MGW-LBE | Citation Encore | N511TH | 1 | 367.019897 nmi | 430.08 | 555.0 | 150.0 | 0.0 | 2.0 h | 2520.0 | 5040.0 | 3218220 | ||||||
X20190114-1 | 2019-01-14 | LBE-MGW-CRW-MGW-LBE | Citation CJ3 | N369MN | 2 | 307.849061 nmi | 321.6 | 296.0 | 150.0 | 0.0 | 2.0 h | 2615.0 | 5230.0 | 3039430 | ||||||
X20190114-2 | 2019-01-14 | LBE-MGW-DFW-MGW-LBE | Hawker 900XP | N819JR | 7 | 1.930105 knmi | 1423.85 | 492.62 | 150.0 | 0.0 | 5.8 h | 3685.0 | 21373.0 | 13532615 | ||||||
X20190115 | 2019-01-15 | LBE-MGW-SWW-MGW-LBE | Hawker 900XP | N819JR | 8 | 2.255958 knmi | 2177.52 | 190.0 | 150.0 | 0.0 | 6.7 h | 3685.0 | 24689.5 | 15632503 | ||||||
X20190117 | 2019-01-17 | LBE-MGW-CRW-MGW-LBE | Citation V Ultra | N6NY | 2 | 307.849061 nmi | 488.15 | 318.0 | 150.0 | 0.0 | 2.1 h | 2470.0 | 5187.0 | 3660725 | ||||||
X20190122 | 2019-01-22 | LBE-MGW-CRW-MGW-LBE | Citation Bravo | N26AP | 1 | 307.849061 nmi | 551.31 | 318.0 | 150.0 | 0.0 | 2.0 h | 2375.0 | 4750.0 | 3057309 | ||||||
X20190124 | 2019-01-24 | LBE-MGW-CRW-MGW-LBE | Citation Excel | N504LV | 3 | 307.849061 nmi | 691.2 | 318.0 | 150.0 | 0.0 | 2.0 h | 3230.0 | 6460.0 | 4433992 | ||||||
X20190129 | 2019-01-29 | LBE-MGW-CRW-MGW-LBE | Citation V Ultra | N6NY | 1 | 307.849061 nmi | 360.8 | 318.0 | 150.0 | 0.0 | 2.1 h | 2470.0 | 5187.0 | 3660725 | ||||||
X20190130 | 2019-01-30 | LBE-MGW-CMH-LBE | Citation V Ultra | N6NY | 1 | 344.428873 nmi | 530.2 | 460.0 | 150.0 | 0.0 | 2.1 h | 2470.0 | 5187.0 | 3660725 | ||||||
X20220910 | 2022-09-10 | LBE-MGW-CEF-MGW-LBE | Citation Excel | N30EK | 4 | 825.687062 nmi | 2119.35 | 220.0 | 155.0 | 0.0 | 3.2 h | 3472.25 | 11111.2 | 7094387 | ||||||
X20220913 | 2022-09-13 | LBE-MGW-IAD-LBE | Citation CJ3 | N40WV | 1 | 287.033374 nmi | 1262.08 | 446.57 | 155.0 | 0.0 | 2.0 h | 2788.25 | 5576.5 | 3039430 | ||||||
X20220914 | 2022-09-14 | LBE-IAD-MGW | Citation CJ3 | N40WV | 1 | 242.317597 nmi | 870.4 | 416.57 | 0.0 | 0.0 | 2.0 h | 2788.25 | 5576.5 | 3039430 | ||||||
X20220914-2 | 2022-09-14;2022-09-15 | RON(1)-MGW-CRW-MGW-LBE | Citation CJ3 | N40WV | 6 | 263.133284 nmi | 870.4 | 290.0 | 1700.0 | 0.0 | 2.0 h | 2788.25 | 5576.5 | 3039430 | ||||||
X20220915 | 2022-09-15 | LBE-MGW-CRW-MGW-LBE | Citation XLS+ | N47EK | 2 | 307.849061 nmi | 1657.63 | 470.0 | 155.0 | 0.0 | 2.0 h | 3572.0 | 7144.0 | 4308839 | ||||||
X20220918-1 | 2022-09-18 | LBE-MGW-CMH-LBE | Citation XLS+ | N47EK | 1 | 344.428873 nmi | 1379.04 | 120.0 | 155.0 | 0.0 | 2.0 h | 3572.0 | 7144.0 | 4308839 | ||||||
X20220918-2 | 2022-09-18 | LBE-CMH-MGW-LBE | Citation CJ3 | N369MN | 1 | 344.428873 nmi | 1231.34 | 90.0 | 155.0 | 0.0 | 2.0 h | 2788.25 | 5576.5 | 3039430 | ||||||
X20220925 | 2022-09-25;2022-09-26 | LBE-MGW-HOU-RON(1)-AUS-MGW-LBE | Challenger 350 | N468CE | 1 | 2.221371 knmi | 4815.98 | 395.0 | 850.0 | 0.0 | 6.1 h | 4864.0 | 29670.4 | 16468346 | ||||||
X20220927 | 2022-09-27 | LBE-MGW-CRW-MGW-LBE | Citation CJ3 | N369MN | 2 | 307.849061 nmi | 826.88 | 367.35 | 155.0 | 0.0 | 2.0 h | 2788.25 | 5576.5 | 3039430 | ||||||
X20220929 | 2022-09-29 | LBE-MGW-IAD-LWB-MGW-LBE | Citation CJ3 | N40WV | 6 | 473.871572 nmi | 1283.16 | 558.07 | 155.0 | 0.0 | 2.7 h | 2788.25 | 7528.28 | 4103230 | ||||||
X20220501 | 2022-05-01 | LBE-MGW-LWB-MGW-LBE | Citation CJ3 | N40WV | 2 | 308.474886 nmi | 1020.0 | 333.0 | 150.0 | 0.0 | 2.0 h | 2788.25 | 5576.5 | 3039430 | ||||||
X20220507 | 2022-05-07 | LBE-MGW-PKB-MGW-LBE | Citation CJ3 | N40WV | 2 | 234.904994 nmi | 1089.2 | 286.0 | 150.0 | 0.0 | 2.0 h | 2788.25 | 5576.5 | 3039430 | ||||||
X20220516 | 2022-05-16 | LBE-MGW-CRW-MGW-LBE | Citation CJ3 | N40WV | 5 | 307.849061 nmi | 1580.38 | 560.0 | 155.0 | 0.0 | 2.0 h | 2788.25 | 5576.5 | 3039430 | ||||||
X20220518 | 2022-05-18 | LBE-MGW-MRB-MGW-LBE | Citation CJ3 | N40WV | 3 | 270.807801 nmi | 1716.0 | 425.81 | 155.0 | 0.0 | 2.0 h | 2788.25 | 5576.5 | 3039430 | ||||||
X20220519-1 | 2022-05-19 | LBE-MGW-LWB-MGW | Citation CJ3 | N40WV | 6 | 263.759109 nmi | 1201.2 | 206.5 | 77.5 | 0.0 | 1.4 h | 2788.25 | 3903.55 | 2127600 | ||||||
X20220519-2 | 2022-05-19 | MGW-CRW-MGW-LBE | Citation CJ3 | N40WV | 2 | 263.133284 nmi | 897.72 | 320.0 | 77.5 | 0.0 | 1.3 h | 2788.25 | 3624.72 | 1975629 | ||||||
X20220519-3 | 2022-05-19 | LBE-MGW-CRW-LBE | Citation CJ4 | N6NY | 2 | 306.828192 nmi | 1693.12 | 470.0 | 155.0 | 0.0 | 2.0 h | 2897.5 | 5795.0 | 3897622 | ||||||
X20220405 | 2022-04-05 | LBE-MGW-CRW-MGW-LBE | Citation CJ3 | N40WV | 2 | 307.849061 nmi | 1588.44 | 308.0 | 150.0 | 0.0 | 2.0 h | 2788.25 | 5576.5 | 3039430 | ||||||
X20220411 | 2022-04-11 | LBE-MGW-CRW-MGW-LBE | Citation CJ3 | N40WV | 4 | 307.849061 nmi | 1532.93 | 330.0 | 150.0 | 0.0 | 2.0 h | 2788.25 | 5576.5 | 3039430 | ||||||
X20220416 | 2022-04-16 | LBE-BCT-MGW-LBE | Citation Sovereign | N680RB | 2 | 1.67634 knmi | 8300.95 | 1371.9 | 150.0 | 0.0 | 5.0 h | 4042.25 | 20211.25 | 12649392 | ||||||
X20220414 | 2022-04-14 | LBE-MGW-BCT-LBE | Citation Sovereign | N680RB | 2 | 1.67634 knmi | 7423.21 | 120.0 | 150.0 | 0.0 | 4.9 h | 4042.25 | 19807.03 | 12396404 | ||||||
X20220421 | 2022-04-21 | LBE-MGW-CRW-MGW-LBE | Citation CJ4 | N75HF | 3 | 307.849061 nmi | 2574.9 | 470.0 | 750.0 | 0.0 | 2.0 h | 2897.5 | 5795.0 | 3897622 | ||||||
X20220425 | 2022-04-25 | LBE-MGW-CRW-MGW-LBE | Citation CJ3 | N369MN | 5 | 307.849061 nmi | 1463.62 | 410.0 | 150.0 | 0.0 | 2.0 h | 2788.25 | 5576.5 | 3039430 | ||||||
X20220428 | 2022-04-28 | LBE-MGW-LWB-LBE | Citation CJ3 | N40WV | 3 | 306.614507 nmi | 1007.88 | 153.0 | 150.0 | 0.0 | 2.0 h | 2788.25 | 5576.5 | 3039430 | ||||||
X20190808 | 2019-08-08 | LBE-MGW-LWB-LBE | Citation Encore | N511TH | 7 | 306.614507 nmi | 533.52 | 243.0 | 150.0 | 0.0 | 2.0 h | 2520.0 | 5040.0 | 3218220 | ||||||
X20190809 | 2019-08-09 | LBE-LWB-MGW-LBE | Citation Encore | N511TH | 5 | 306.614507 nmi | 253.0 | 243.0 | 150.0 | 0.0 | 2.0 h | 2520.0 | 5040.0 | 3218220 | ||||||
X20190811 | 2019-08-11 | LBE-LWB-MGW-LBE | Citation Encore | N511TH | 2 | 306.614507 nmi | 412.5 | 243.0 | 150.0 | 0.0 | 2.0 h | 2520.0 | 5040.0 | 3218220 | ||||||
X20190815 | 2019-08-15 | LBE-MGW-CRW-MGW-LBE | Citation V Ultra | N6NY | 6 | 307.849061 nmi | 552.47 | 308.0 | 150.0 | 0.0 | 2.0 h | 2470.0 | 4940.0 | 3486405 | ||||||
X20190820-1 | 2019-08-20;2019-08-21 | LBE-MGW-MSP-RON(1)-MGW-LBE | Citation Encore | N511TH | 5 | 1.426359 knmi | 1701.28 | 1054.53 | 750.0 | 0.0 | 4.7 h | 2520.0 | 11844.0 | 7562817 | ||||||
X20190820-2 | 2019-08-20 | LBE-MGW-CRW-MGW-LBE | Citation V Ultra | N6NY | 4 | 307.849061 nmi | 361.58 | 308.0 | 150.0 | 0.0 | 2.0 h | 2470.0 | 4940.0 | 3486405 | ||||||
X20190821 | 2019-08-21 | LBE-MGW-CRW-MGW-LBE | Citation Excel | N504LV | 7 | 307.849061 nmi | 562.57 | 308.0 | 150.0 | 0.0 | 2.0 h | 3230.0 | 6460.0 | 4433992 | ||||||
X20190823 | 2019-08-23 | LBE-MGW-CRW-MGW-LBE | Citation Bravo | N26AP | 2 | 307.849061 nmi | 257.55 | 308.0 | 150.0 | 0.0 | 2.0 h | 2375.0 | 4750.0 | 3057309 | ||||||
X20190824 | 2019-08-24 | LBE-MGW-IAD-MGW-LBE | Citation Encore | N511TH | 5 | 333.103034 nmi | 441.37 | 791.43 | 150.0 | 0.0 | 2.0 h | 2520.0 | 5040.0 | 3218220 | ||||||
X20190827 | 2019-08-27 | LBE-MGW-LWB-LBE | Citation V Ultra | N6NY | 4 | 306.614507 nmi | 452.48 | 243.0 | 150.0 | 0.0 | 2.0 h | 2470.0 | 4940.0 | 3486405 | ||||||
X20190830 | 2019-08-30 | LBE-LWB-MGW-LBE | Citation V Ultra | N6NY | 6 | 306.614507 nmi | 291.49 | 243.0 | 150.0 | 0.0 | 2.0 h | 2470.0 | 4940.0 | 3486405 | ||||||
X20160401 | 2016-03-31;2016-04-01 | LBE-MGW-CRW-MGW-CRW-RON(1)-MGW-LBE | King Air B200 | N5AE | 5 | 526.266567 nmi | 129.22 | 292.0 | 700.0 | 0.0 | 3.6 h | 1825.0 | 6570.0 | 3282584 | ||||||
X20160402 | 2016-04-02 | LBE-MGW-HXD-MGW-LBE | Citation Encore | N511TH | 7 | 983.510304 nmi | 838.46 | 507.0 | 100.0 | 0.0 | 3.7 h | 2420.0 | 8954.0 | 5953707 | ||||||
X20160404 | 2016-04-03;2016-04-04 | LBE-MGW-OUN-RON(1)-MGW-LBE | Citation V Ultra | N60KM | 1 | 1.840966 knmi | 869.32 | 75.0 | 700.0 | 0.0 | 5.9 h | 2370.0 | 13983.0 | 10284894 | ||||||
X20160406 | 2016-04-06 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 2 | 307.849061 nmi | 0.0 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160407 | 2016-04-07 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 7 | 307.849061 nmi | 0.0 | 106.0 | 700.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160408 | 2016-04-08;2016-04-09 | RON(1)-MGW-PHF-MGW-LBE | Citation Encore | N511TH | 2 | 486.059383 nmi | 400.42 | 480.0 | 700.0 | 0.0 | 2.2 h | 2420.0 | 5324.0 | 3540042 | ||||||
X20160411 | 2016-04-11 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 3 | 307.849061 nmi | 0.0 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160412 | 2016-04-12;2016-04-13 | LBE-MGW-PBX-MGW-IAD-RON(1)-MGW-LBE | Citation V Ultra | N6NY | 4 | 685.57638 nmi | 232.5 | 755.16 | 700.0 | 0.0 | 4.0 h | 2370.0 | 9480.0 | 6972810 | ||||||
X20160414 | 2016-04-14 | LBE-MGW-CRW-MGW-LBE | Citation Bravo | N26AP | 1 | 307.849061 nmi | 0.0 | 216.0 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | 3057309 | ||||||
X20160416-1 | 2016-04-16 | LBE-MGW-IAD-MGW | King Air B200 | N5AE | 6 | 288.387257 nmi | 89.28 | 292.01 | 50.0 | 0.0 | 1.9 h | 1825.0 | 3467.5 | 1732475 | ||||||
X20160416-2 | 2016-04-16 | MGW-IAD-LBE | King Air B200 | N5AE | 4 | 242.317597 nmi | 19.2 | 581.3 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | 1823658 | ||||||
X20160424 | 2016-04-24 | LBE-LWB-MGW-LBE | King Air B200 | N5AE | 6 | 306.614507 nmi | 12.9 | 76.5 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | 1823658 | ||||||
X20160426 | 2016-04-26 | LBE-MGW-IAD-MGW-LBE | King Air B200 | N5AE | 3 | 333.103034 nmi | 22.41 | 456.51 | 100.0 | 0.0 | 2.4 h | 1825.0 | 4380.0 | 2188389 | ||||||
X20160428 | 2016-04-28 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 0 | 307.849061 nmi | 130.14 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160302 | 2016-03-02 | LBE-MGW-IAD-MGW-LBE | King Air B200 | N5AE | 1 | 333.103034 nmi | 0.0 | 456.51 | 700.0 | 0.0 | 2.4 h | 1825.0 | 4380.0 | 2188389 | ||||||
X20160302-2 | 2016-03-02 | LBE-MGW-BOS-MGW-LBE | Citation V Ultra | N60KM | 2 | 960.115194 nmi | 478.72 | 1031.31 | 100.0 | 0.0 | 3.6 h | 2430.0 | 8748.0 | 6275529 | ||||||
X20160303 | 2016-03-03 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 6 | 307.849061 nmi | 0.0 | 2632.19 | 700.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160304 | 2016-03-04 | LBE-MGW-IAD-MGW-LBE | Citation V Ultra | N60KM | 2 | 333.103034 nmi | 0.0 | 755.16 | 100.0 | 0.0 | 2.0 h | 2370.0 | 4740.0 | 3486405 | ||||||
X20160305 | 2016-03-05 | LBE-MGW-CMH-MGW-LBE | King Air B200 | N5AE | 1 | 367.019897 nmi | 0.0 | 268.0 | 100.0 | 0.0 | 2.3 h | 1825.0 | 4197.5 | 2097206 | ||||||
X20160309-1 | 2016-03-09 | LBE-MGW-IAD-MGW-LBE | Citation Bravo | N26AP | 4 | 333.103034 nmi | 0.0 | 744.3 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | 3057309 | ||||||
X20160309-2 | 2016-03-09 | LBE-MGW-CMH-LBE | King Air B200 | N5AE | 1 | 344.428873 nmi | 0.0 | 75.0 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | 1823658 | ||||||
X20160311 | 2016-03-11;2016-03-13 | LBE-MGW-CMH-SFO-RON(2)-MGW-LBE | Hawker 900XP | N819JR | 2 | 4.042388 knmi | 2675.24 | 1078.0 | 1400.0 | 8.0 | 11.4 h | 3500.0 | 39900.0 | 26598588 | ||||||
X20160316 | 2016-03-16;2016-03-17 | LBE-MGW-IAD-MDW-RON(1)-MGW-LBE | Citation Excel | N58LQ | 1 | 1.090729 knmi | 450.42 | 1553.8 | 700.0 | 4.0 | 4.0 h | 3150.0 | 12600.0 | 8867984 | ||||||
X20160318 | 2016-03-18 | LBE-MGW-PKB-MGW-LBE | King Air B200 | N5AE | 4 | 234.904994 nmi | 6.51 | 63.6 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | 1823658 | ||||||
X20160320 | 2016-03-20 | LBE-MGW-LWB-MGW-LBE | King Air B200 | N5AE | 1 | 308.474886 nmi | 5.37 | 76.5 | 100.0 | 0.0 | 2.4 h | 1825.0 | 4380.0 | 2188389 | ||||||
X20160322 | 2016-03-22 | LBE-MGW-BKW-MGW-LBE | Citation Bravo | N26AP | 6 | 339.328971 nmi | 12.4 | 185.0 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | 3057309 | ||||||
X20160330 | 2016-03-30 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 6 | 307.849061 nmi | 7.96 | 106.0 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | 1823658 | ||||||
X20160204-1 | 2016-02-04 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 6 | 307.849061 nmi | 0.0 | 106.0 | 700.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160204-2 | 2016-02-04 | LBE-MGW-DFW-RON(1)-MGW-LBE | Citation Encore | N511TH | 1 | 1.930105 knmi | 156.24 | 130.64 | 700.0 | 0.0 | 5.8 h | 2420.0 | 14036.0 | 9332838 | ||||||
X20160207 | 2016-02-07 | LBE-MGW-CMH-MGW-LBE | King Air B200 | N5AE | 2 | 367.019897 nmi | 0.0 | 75.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160209 | 2016-02-09;2016-02-10 | LBE-MGW-DFW-RON(1)-SRQ-PBI-LBE | Citation Encore | N511TH | 1 | 2.740489 knmi | 447.06 | 1949.72 | 700.0 | 8.0 | 8.3 h | 2420.0 | 20086.0 | 13355613 | ||||||
X20160212 | 2016-02-12 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 2 | 307.849061 nmi | 0.0 | 373.12 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160217-1 | 2016-02-17 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 3 | 307.849061 nmi | 0.0 | 888.28 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160217-2 | 2016-02-17 | LBE-CRW-MGW-LBE | Citation Bravo | N26AP | 1 | 306.828192 nmi | 0.0 | 181.0 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | 3057309 | ||||||
X20160219-1 | 2016-02-19 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 3 | 307.849061 nmi | 0.0 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trips" ( "id" text, "date" text, "route" text, "aircraft" text, "reg_no" text, "num_pax" integer, "justification" text, "distance" real, "fuel" real, "landing" real, "crew_expense" real, "dom_tax" real, "flight_hours" real, "hourly_rate" real, "billing_amount" real, "signed_by_name" text, "approved_by_name" text, "carbon_footprint" integer, "notes" text, "itinerary" blob, "reservation" blob, PRIMARY KEY("id"), CONSTRAINT "fk_trips_signed_by" FOREIGN KEY("signed_by_name") REFERENCES "people"("name"), CONSTRAINT "fk_trips_approved_by" FOREIGN KEY("approved_by_name") REFERENCES "people"("name") );