Flight Log

Here is my flight log. I maintain a Microsoft Access Database that is a duplicate of my paper log. At some point I will make the blank database available here for other users. The web site here pulls the data live from a copy of the database running under mySQL - the table and totals are dynamically generated by PHP.

The frequency that I update the web copy from the source Access database will vary greatly.

I still need to complete some more reports and to come up with a data export and import functions. This is so I can distribute updated databases with new forms and reports and bring over the underlying data from the old version.

BTW - this was _UGLY_. Microsoft Access does a poor job of HTML export of reports - what I have now is much prettier (if simple).

Aircraft
Flight Number of
Aircraft Category

Flight Conditions
Piloting Type
Date Type ID From Via To Inst App Day Night Single-
Engine
Land Night Actual
Inst. Sim.
Inst. Cross
Country Dual
Received PIC/
Solo Total Remarks
TO Ldg TO Ldg
13-Jan-20 C-172 N6443E LVK LVK 1 1 0.9 0.9 0.9 Intro flight to Bay Area, Cimbs, Descent, Turns, Lvl

22-Jan-20 C-172 N8477E LVK LVK 2 2 1.4 1.4 1.4 clmbs, descents, turning, high/og drag config, landing config

2-Feb-20 PA28-161 N8052T LVK LVK 2 2 1.3 1.3 1.3 slow flt, stalls, steep turns, pattern

3-Feb-20 C-172 N738HY LVK WVI LVK 2 2 1.6 1.6 1.6 pilotage, ADF, radio comm, uncontrolled airport

9-Feb-20 C-172 N99603 LVK LVK 1 1 1.6 1.6 1.6 slw flt, stalls, grnd ref3), steep turns, radio comm

10-Feb-20 PA28-161 N8052T LVK LVK 1 1 1.6 0.3 1.6 1.6 Slow flt, stalls, BAI

12-Feb-20 PA28-161 N8052T LVK C83 LVK 5 5 1.6 1.6 1.6 Ground ref., pattern, radio, com, touch-n-go

19-Feb-20 PA28-161 N8052T LVK LVK 5 5 1.5 1.5 1.5 Grndref, pattern, x-wind landings

23-Feb-20 C-172 N99603 LVK LVK 3 3 1.2 1.2 1.2 Emerg. App & lndg, emgerg descent

3-Mar-20 PA28-161 N8052T LVK C83 LVK 5 5 1.6 1.6 1.6 Slw flt cln, stall, steep turns, patterns, normal landings

11-Mar-20 PA28-161 N8052T LVK CCR LVK 6 6 1.6 1.6 1.6 G-ref, concord Class D, normal landings

20-Mar-20 PA28-161 N8052T LVK APC LVK 6 6 1.7 1.7 1.7 VOR nav, pilotage, radio comm, landings

23-Mar-20 PA28-161 N8052T LVK LVK 1 1 1.0 1.0 1.0 Stalls, sharp turns, emerg. App. & landing

Page 1 Sub-Total 40 40 18.6 0.3 18.6 18.6
Page 1 Total to Date 40 40 18.6 0.3 18.6 18.6
24-Mar-20 PA28-161 N8052T LVK LVK 7 7 0.8 0.8 0.8 normal & x-wind t/o & lndg

30-Mar-20 PA28-161 N8052T LVK OAK LVK 3 3 1.2 0.3 1.2 1.2 Class C, touch & go, go around, BAI

5-Apr-20 PA28-161 N8052T LVK LVK 7 7 1.1 1.1 1.1 Stalls, slow flight dirty, touch-n-go

7-Apr-20 PA28-161 N8052T LVK LVK 5 5 1.0 1.0 1.0 Gref, touch & go, normal landings

13-Apr-20 PA28-161 N2909Q LVK RHV LVK 5 5 1.4 1.4 1.4 Emerg. App. & lndg, no flap, forward slips

20-Apr-20 PA28-161 N2909Q LVK LVK 2 2 1.2 1.2 1.2 Slow flt, steep turns, emerg desc, g-ref, norm lndgs

29-Apr-20 PA28-161 N2909Q LVK LVK 3 3 1.0 1.0 1.0 Steep Turns, Normal Landings (1 Go-Around)

29-Apr-20 PA28-161 N2909Q LVK HWD LVK 2 2 1.6 0.4 1.6 1.6 Stage 1 Check - Satisfact.

8-May-20 PA28-161 N2909T LVK TCY LVK 9 9 2.0 1.5 0.5 2.0 Normal & wind touch n go
FIRST SOLO

12-May-20 PA28-161 N8052T LVK 1Q4 LVK 8 8 1.3 1.3 1.3 shorts/softs t/o & ldg

15-May-20 PA28-161 N2909Q LVK LVK 1 5 5 1.2 0.7 1.2 1.2 BAI, unusual attitudees, VOR/NDB int & tch, shorts/softs

17-May-20 PA28-161 N2909Q LVK LVK 8 8 0.9 0.9 0.9 Touch-n-go, short+soft, pattern, unatt solo

25-May-20 PA28-161 N8052T LVK Q68 LVK 2 2 2.3 2.3 2.3 2.3 Ilotage, dead reconing, VOR navigation

Page 2 Sub-Total 1 66 66 17 1.4 2.3 15.6 1.4 17
Page 2 Total to Date 1 106 106 35.6 1.7 2.3 34.2 1.4 35.6
26-May-20 PA28-161 N4126N LVK SCK LVK 7 7 1.5 1.5 1.5 Diversion, Short fields, soft fields, crosswind landing

27-May-20 PA28-161 N4126N LVK C83 LVK 6 6 1.6 1.6 1.6 Emer. Desc+app, stalls, steep turns, short+soft ldgs+TO, Xwind Ldg

29-May-20 PA28-161 N2929Q LVK LVK 8 8 8 8 1.4 1.4 1.4 1.4 slow flt, stall, steep turns, no flaps, back+go

1-Jun-20 PA28-161 N8052T LVK C83 LVK 5 5 1.6 1.6 1.6 Stalls, Emer. Desc & App, Touch-n-go, X-wind Ldg, Steep Turns, VOR Nav

4-Jun-20 PA28-161 N8052T LVK * LVK 6 6 1.9 1.9 1.9 radio comm, bay area familiarization
LVK-OAK-HWD-PAO-SQL-HAF-LVK

5-Jun-20 PA28-161 N4126N LVK MRY LVK 2 2 2 2 2.3 2.3 2.3 2.3 2.3 Pilotage, dead reckoning, VOR nav, radio comm

10-Jun-20 PA28-161 N2909Q LVK O20 LVK 4 4 1.3 1.3 1.3 Pilotage, Dead Reckoning, diversion, shorts, softs

12-Jun-20 PA28-161 N2909Q LVK TCY LVK 4 4 1.6 0.5 1.6 1.6 Pvt. Pilot Stage II - Good Job

14-Jun-20 PA28-161 N8052T LVK STS LVK 2 2 2.2 2.2 2.2 2.2 XC, Pilotage, Class D, VOR Nav, ATC/FSS

19-Jun-20 PA28-161 N8052T LVK LVK 1 1 1.4 0.3 1.4 1.4 Pwr on/pwr off turning stalls, BAI, emerg app & ldg

23-Jun-20 PA28-161 N4126N LVK * LVK 6 6 3.6 3.6 3.6 3.6 XC long solo, ATC, FSS, pilotage, GPS nav
(LVK-MOD-PVF-SAC-2Q3-LVK)

24-Jun-20 PA28-161 N2909Q LVK LVK 4 4 1.2 1.2 1.2 Stalls fr/turn, Short/Soft TO&Ldg

27-Jun-20 PA28-161 N8052T LVK C83 LVK 8 8 2.0 2.0 2.0 softs+shorts; emer. Desc. App+ldg, stalls, ground-ref, steep turns

Page 3 Sub-Total 63 63 10 10 23.6 3.7 0.8 8.1 12.6 11 23.6
Page 3 Total to Date 1 169 169 10 10 59.2 3.7 2.5 10.4 46.8 12.4 59.2
29-Jun-20 PA28-161 N8052T LVK DVO LVK 4 4 1.8 0.5 1.8 1.8 Stage III Pvt. Satisfactory Good Job

30-Jun-20 PA28-161 N2909Q LVK HAF LVK 2 2 1.6 1.6 1.6 Last Dual for PPSEL

4-Jul-20 PA28-161 N8052T LVK * LVK 6 6 2.2 2.2 2.2 Via CCR, TCY; Stalls, slow flt, shorts&softs, emer desc&ldg, turning stalls

11-Jul-20 PA28-161 N2909Q LVK CCR 1 1 0.5 0.5 0.5 Flight to checkride

11-Jul-20 PA28-161 N2909Q CCR O88 CCR 3 3 1.3 0.3 1.3 1.3 FAA SEL Practical Satisfactory - Woo HOO

11-Jul-20 PA28-161 N2909Q CCR LVK 1 1 0.8 0.8 0.8 Short Ldg, Private Pilot First Flight

13-Jul-20 C-172 N378HY LVK LVK 6 6 1.6 1.6 1.6 1.6 PNE On/OFF Stass, MCA, Various Ldgs/TO, C172 Checkout

13-Jul-20 C-172 N64204 LVK UKI 1 1 1.3 1.3 1.3 1.3 Xcntry, Pilotage, GPS

13-Jul-20 C-172 N64204 UKI LVK 4 4 3 4 1.7 1.0 1.7 1.7 1.7 X-cntry, GPS, Night TO/Ldg, Night Current

20-Jul-20 C-172 N64204 LVK 1Q4 SAC 5 5 1.6 1.6 1.6 1.6 X-cntry, Touch-n-Go, Xwnd, Emer Desc&Ldg, stalls

20-Jul-20 C-172 N64204 SAC TCY LVK 6 6 3 3 1.4 0.6 1.4 1.4 1.4 X-cntry, softs, shorts, night current

3-Aug-20 PA28-161 N8052T LVK * LVK 5 5 3.6 3.6 3.6 3.6 LVK-AUN-O22-LVK X-cntry, ATC, VOR, Dens Alt Ops

7-Aug-20 C-172 N64204 LVK C83 LVK 6 6 1.0 1.0 1.0 Touch-n-Go

Page 4 Sub-Total 50 50 6 7 20.4 1.6 0.8 9.6 5 17 20.4
Page 4 Total to Date 1 219 219 16 17 79.6 5.3 3.3 20 51.8 29.4 79.6
12-Aug-20 C-172 N4212R OAK LVK OAK 1 4 4 1.5 0.2 1.5 1.5 1.5 Oak VOR 27L App, C-172 Checkout AAC, ILS Dep

16-Aug-20 Express2k N511EA OLM OLM 4 4 1.0 1.0 1.0 Express2k Test Ride, Complex, Touch-n-go@100kts HighPerf

25-Aug-20 PA28-161 N8052T LVK * LVK 4 4 3.0 3.0 3.0 3.0 Via LSN, MER, O68; XC, Touch-n-go, Pilotage, GPS

30-Aug-20 C-172 N89503 MIC MIC 4 4 0.6 0.6 0.6 0.6 Steep turns, Stalls, Slow Flt, Go around, C-172 Checkout @ Northland

30-Aug-20 C-172 N89503 MIC IIB MIC 3 3 3.6 3.6 3.6 3.6 Xcntry - Pick up Candy in Iowa

31-Aug-20 C-172 N89503 MIC * MIC 6 6 4.3 4.3 4.3 4.3 ROS-ASX-4R5-RNH
Xcntry, Pireps, Flightwatch, XC w/John & Patrick

1-Sep-20 C-172 N89503 MIC IIB MIC 3 3 4.2 4.2 4.2 4.2 Xcntry, Candy to Iowa

15-Sep-20 C-172 N99603 LVK MRY LVK 2 2 2.3 2.3 2.3 2.3 X-cntry, sightseeing to MRY, Ldg in 20kt gusts

27-Sep-20 C-172 N4312R OAK RNO 1 1 2.2 2.2 2.2 2.2 Xcntry, Weekend to Tahoe (fr AAC)

29-Sep-20 C-172 N4312R RNO OAK 1 1 3.0 3.0 3.0 3.0 Xcntry, Pireps, Back to Oak, (fr AAC)

6-Oct-20 PA28-161 N2909Q LVK STS LVK 2 2 2.6 2.6 2.6 2.6 Xcntry, flight w/Janine

19-Oct-20 C172 N8477E LVK 203 LVK 2 2 1 2.1 0.2 2.1 2.1 2.1 X-cntry, Sightseeing w/Doug+Lisa, Class B, 20kt windshear on T/O

16-Nov-20 PA28-161 N4126N LVK LVK 4 4 4 4 1.8 1.8 1.8 1.8 25R ILS, Night Flying, Night Current

Page 5 Sub-Total 1 40 40 4 5 32.2 2 0.2 27.3 2.1 32.2 32.2
Page 5 Total to Date 2 259 259 20 22 111.8 7.3 0.2 3.3 47.3 53.9 61.6 111.8
7-Dec-20 C-172 N264QF LVK * LVK 1 5 5 1.8 0.4 1.8 1.8 1.8 SAC-O88, Touch-n-go, Softs, LVK Liv1 SID, Stalls, Steep Turns, LVK ILS25R

20-Dec-20 C-172 N739UL OAK OAK 3 3 0.8 0.8 0.8 Touch-n-Go, Class C, 15-26kt winds

4-Jan-20 C-172 N66204 LVK LVK 1 1 1.5 1.5 1.5 Class B, Bay tour f/Ben

5-Jan-20 PA28-161 N2909Q LVK LVK 3 3 3 3 0.8 0.8 0.8 0.8 Night, Mod. Turbulance in Pattern

1-Feb-20 PA28-161 N4126N LVK * LVK 5 5 1.7 1.7 1.7 LVK-C83-TCY-LVK
Stalls, Steep Turns, Slow Flt, Touch-n-Gos w/20-27kt winds

8-Feb-20 PA28-161 N8052T LVK MER Q68 3 3 1.7 1.7 1.7 1.7 Yosemite Sightseeing

8-Feb-20 PA28-161 N8052T Q68 LVK 1 3 3 3 3 1.1 1.1 1.1 1.1 1.1 Night XC PIC, ILS LVK 25R ctl 7L

23-Feb-20 PA28-161 N4126N LVK LVK 1 1 1.5 1.5 1.5 Bay Tour Cyrs + Carole

1-Mar-20 C-172 N8052T LVK 3O8 1 1 1.5 1.5 1.5 1.5 Harris Ranch - Tasty Steaks!

1-Mar-20 PA28-161 N8052T 3O8 3O8 3 3 3 3 1.7 1.7 1.7 1.7 1.7 Night XC - Beautiful + Boring (Night Currency)

9-Mar-20 PA28-161 N234JG OAK MER OAK 3 3 2.8 2.8 2.8 2.8 Solto to Atwater - 1st w/Folding bike - Class C

17-Mar-20 C-172 N234JG OAK 1O2 STS 5 5 2.1 2.1 2.1 2.1 Bay Tour f/Kev, Very Windy 15G25kts, lots of go-arounds

17-Mar-20 C-172 N234JG STS LVK OAK 3 3 1.8 1.8 1.8 1.8 Bay Tour f/Kev II - Waiting f/wind @LVK

Page 6 Sub-Total 2 39 39 9 9 20.8 3.6 0.4 14.5 20.8 20.8
Page 6 Total to Date 4 298 298 29 31 132.6 10.9 0.2 3.7 61.8 53.9 82.4 132.6
30-Mar-20 PA28-161 N8052T LVK * LVK 3 3 1.7 1.7 1.7 1.7 WVI-3O8, Prop. Vibration, Cut Short

10-Apr-20 PA28-161 N8052T LVK LVK 1 1 1 1.0 0.2 1.0 1.0 Mt. Diablo Loop w/Andy

11-Apr-20 PA28-161 N2909Q LVK HAF LVK 1 1 1 1 1.8 0.3 1.8 1.8 Bay Tour + Dinner w/Lisa, ILS 25R

5-May-20 PA28-161 N8052T LVK C83 LVK 5 5 1.4 1.4 1.4 Airwork, Cround Ref, Touch-n-Go

19-May-20 C-172 N854AC OAK DVO OAK 4 4 1.3 1.3 1.3 Class C, Touch-n-Go

1-Jun-20 PA28-161 N4126N LVK MRY 2 2 1.0 1.0 1.0 1.0 Class C, Dinner to MRY

2-Jun-20 PA28-161 N4126N MRY OAR LVK 1 3 3 3 3 1.3 1.3 1.3 1.3 1.3 Class C, Night XC & Current, LVK ILS 25R, Windy OAR

10-Jun-20 PA28-161 N2909Q LVK TCY LVK 1 2 2 2 2 1.1 0.6 1.1 1.1 LVK ILS 25R, Wings Sem

21-Jun-20 PA28-161 N8052T LVK MYV 2 2 1.4 1.4 1.4 1.4 XC to Golden West, _Busy_ Traffic

21-Jun-20 PA28-161 N8052T MYV AUN LVK 5 5 1.8 1.2 1.8 1.8 1.8 XC from GoldenWest, 1.2 Night XC, Dinner @ Auburn, Night Home

29-Jun-20 PA28-161 N8052T LVK 3O8 LVK 5 5 1.9 1.9 1.9 1.9 Mt. Ham + Diablo Range, Windy

4-Jul-20 PA28-161 N2909Q LVK LVK 1 5 5 3 3 1.8 1.5 1.8 1.8 Class B over SFO, Fireworks, GPS 25R

20-Jul-20 C-172 N172AR OAK O48 OAK 5 5 3 3 3.8 1.6 3.8 3.8 3.8 Up the Coast & Wine Country, Tricky Winds

Page 7 Sub-Total 4 43 43 11 13 21.3 6.7 12.9 21.3 21.3
Page 7 Total to Date 8 341 341 40 44 153.9 17.6 0.2 3.7 74.7 53.9 103.7 153.9
16-Aug-20 PA28-161 N8052T LVK * LVK 7 7 2.7 2.7 2.7 2.7 1Q4-O17-MER
T/O & Landings, HOT and bumpy

19-Aug-20 PA28-161 N8052T LVK C83 LVK 6 6 1.7 1.7 1.7 Touch-n-Gos, Xwind, Airwork

23-Aug-20 PA28-161 N4126N LVK LVK 1 1 1.7 1.7 1.7 Bay Tour, Class B, SFO

7-Sep-20 PA28-161 N8052T LVK * LVK 5 5 2.0 2.0 2.0 2.0 Touch-N-Gos, Xwind, Cloudy, Fires & Smoke

23-Sep-20 PA28-161 N8097H LVK TCY LVK 8 8 1.9 1.9 1.9 Touch-n-Gos, Airwork, Fire Scars

12-Oct-20 PA28-161 N8097H LVK HAF LVK 2 2 1 1 1.8 0.3 1.8 1.8 Dinner @ Half Moon Bay

17-Oct-20 C-172 N234JG OAK LVK OAK 4 4 1.5 1.5 1.5 Class C, Touch-N-Gos

25-Oct-20 PA28-161 N4126N LVK C83 LVK 1 8 8 8 8 1.6 1.6 0.3 1.6 1.6 ISL 25R LVK, Night Practice, Winds light but odd (Santa Anas)

1-Nov-20 PA28-161 N4126N LVK APC LVK 4 4 3 3 1.7 1.0 1.7 1.7 Dinner to Jonesys, Night

22-Nov-20 PA28-161 N8097H LVK WVI LVK 5 5 3 3 1.9 0.7 1.9 1.9 1.9 Local VFR, Candy - Straight & Level, Turns, Descents, 0.4 Hrs

1-Dec-20 Velocity RG N271TC X26 X26 1 1 0.8 0.8 0.8

6-Dec-20 C-172 N234JG OAK STS OAK 5 5 4 5 1.8 1.1 1.8 1.8 1.8 Night Practice, Night XC Mtns, Stop and Gos, Windy

13-Dec-20 PA28-161 N4126N LVK MRY LVK 2 2 1.9 1.9 1.9 1.9 Bay Tour f/Andy+Candy, Lots of Clouds, Tricky VFR

Page 8 Sub-Total 1 58 58 19 20 23 4.7 0.3 10.3 23 23
Page 8 Total to Date 9 399 399 59 64 176.9 22.3 0.2 4 85 53.9 126.7 176.9
3-Jan-20 PA28-161 N8097H LVK O88 LVK 1 6 6 1.8 0.3 1.8 1.8 1.8 Airwork, Shorts+Softs, App GPS 24R LVK

25-Jan-20 PA28-161 N8097H LVK TCY LVK 1 6 6 1.5 0.3 1.5 1.5 1.5 Airwork, App, Holds, Xwind, NDB 25 TCY

29-Jan-20 C-172 N21215 KOA KOA 5 5 0.9 0.9 0.9 Hawaii Checkout, Stalls, Steep Turns, Touch-n-Gos

2-Feb-20 C-172 N21215 KOA ITO 1 1 1.5 1.5 1.5 1.5 Big Island Loop, Volcano

2-Feb-20 C-172 N21215 ITO KOA 1 1 1.4 1.4 1.4 1.4 Big Island Loop, Volcano

8-Feb-20 PA28-161 N8097H LVK LVK 1 1 1.7 1.7 1.7 Bay Tour f/Andy + Lynn, Class B

29-Feb-20 PA28-161 N4126N LVK LVK 4 4 2.1 2.1 2.1 Touch-n-Gos, Xwind, Bay Tour f/Amie & Darin

7-Mar-20 PA28-161 N4126N LVK MRY LVK 2 2 1 2.2 0.4 2.2 2.2 2.2 Day Trip to Montery w/Candy's Mom, Xwind 10G14

24-Apr-20 PA28-161 N4126N LVK HAF LVK 4 4 3 3 2.1 1.2 2.1 2.1 Dinner to Half Moon Bay w/Andy and Linn

25-Jun-20 PA28-161 N4126N LVK LVK 3 3 3 3 1.7 1.7 1.7 1.7 Night Bay Tour w/Teddy & Charlie

26-Jun-20 PA28-161 N2909Q LVK 1Q4 LVK 8 8 1.2 1.2 1.2 1.2 BFR, Emer Landing, John 2716242CFI Exp 12/04

3-Jul-20 C-172 N624QF LVK STS LVK 3 3 1.8 1.8 1.8 1.8 Wine Country, Pt. Reyes, Xwinds, Bumpy

20-Jul-20 PA28-161 N8097H LVK MRY LVK 1 3 3 3 3 1.7 1.7 1.7 1.7 1.7 Night to Monterey w/Andy, Smooth

Page 9 Sub-Total 3 47 47 9 10 21.6 5 0.6 11.9 2.1 20.7 21.6
Page 9 Total to Date 12 446 446 68 74 198.5 27.3 0.2 4.6 96.9 56 147.4 198.5
TOTAL 12 446 446 68 74 198.5 27.3 0.2 4.6 96.9 56 147.4 198.5