Posts: 133
Joined: Sat Sep 30, 2006 6:10 pm

Spotting Database (Logbook)

Fri Aug 22, 2008 6:59 pm

Hi all!

I have one question for regspotters: What software do you use to log your sightings on PC?
If you create your custom DB in access, ... could you please post some screenshots?

I am trying to find the right solution for myself.

Thanks for reply.

Best regards, Keishi Nukina
Posts: 447
Joined: Thu Oct 26, 2006 12:12 am

RE: Spotting Database (Logbook)

Wed Oct 08, 2008 4:22 pm

I would also like to know what other software people use.

I currently just use MS Excel, tracking the operator, type, registration, MSN, date, location and "comments". Unfortunately with around 4,000 entries at this point, auto-filters tend to drop certain data from searches, so I would be interested to know what others use.

Most Flown:- G-BUVA (20 Flights), EI-DEB (12 Flights), EI-JFK (11 Flights)
Posts: 133
Joined: Sat Sep 30, 2006 6:10 pm

RE: Spotting Database (Logbook)

Wed Oct 08, 2008 6:47 pm


I started using Access recently. I have created a set of tables, one for airframes which includes ID, which is the CN with a prefix, so I can set it as a unique value (for eg. A32S.2143), then it has the CN itself, LN, Manufacturer, Type and Subtype. It also includes frame type (jet, prop,...) and the registration it was wearing when last seen.

The second table is called Sightings and it includes data about each sightings of a particular airframe - ID to relate it to the previous table, Registration, Operator, Location, Date, Remark and a * if it is first time seen.

Last main table is table Photos, which is unrelated to the other two, however I have an auto-fill on my form, so it automatically fills remaining data after entering registration of the plane on the photos. It also contains location of the photo on the disc, so it can display it.

Beside that, I have a couple of forms and reports, which help me organizing/browsing the data.

Firstly there is the main form, which just has buttons to go to the others.

Then there is the 'logging tool', which I use to input data about the sightings. The upper part contains detail about the frame selected in the bottom part. The default data for the new sightings can be set on the main page for the ease of inputting frames from one trip.

Finally, there are two forms for managing/browsing the photos table.
First is a form for adding them. And the second is for browsing. The browsing form isnt great, but Im working on making it better.

I also have created some report, for the ease of browsing.

That's it. Firstly I wanted to buy ADU or some other commercial product, but then, I found iout, that I dont need tens of thousands of airframes already in, so I decided to craete my own one and Im happy with that decision to say.

Now I only have to input three years worth of frames/sightings/photos.

Best regards, Keishi
Posts: 3945
Joined: Tue Jun 01, 2004 12:33 am

RE: Spotting Database (Logbook)

Thu Oct 09, 2008 3:48 am

The word "used" to describe the condition of my copy is an absolute understatement. Page after page of my markings on the reg numbers-sightings, aircraft I flew on, additions, retirements. It's WEEEEEEEEEEEEEEEEEEEELLLLLLLLLLLLLLLLLLLLLLLLLLLLLL used!!!
I convert Jet A and 100LL into noise.
Posts: 548
Joined: Tue Jun 14, 2005 12:19 am

RE: Spotting Database (Logbook)

Tue Nov 04, 2008 6:21 am

I use Notebook v1.0. It was going well, but then I decided to get the pencil / eraser addon, so I could fix mistakes more easily Big grin
Posts: 548
Joined: Tue Jun 14, 2005 12:19 am

RE: Spotting Database (Logbook)

Tue Jan 20, 2009 5:47 am

Quoting Ketko2 (Reply 2):
I started using Access recently do you get it to look like what you have? I would love to use that, but from what I've seen, it's completely different...
Posts: 133
Joined: Sat Sep 30, 2006 6:10 pm

RE: Spotting Database (Logbook)

Fri Jan 23, 2009 5:10 pm


What do you mean by "its completely different'?

Regards, Keishi
Posts: 548
Joined: Tue Jun 14, 2005 12:19 am

RE: Spotting Database (Logbook)

Sat Jan 24, 2009 2:23 am

Quoting Ketko2 (Reply 6):
"its completely different'

I mean, it does not look like that. Unless I saw a different version... I would love to use the program that he posted pictures of. What is it, and how do I make it like that?
Posts: 5
Joined: Sun Jul 08, 2012 7:35 pm

RE: Spotting Database (Logbook)

Sun Aug 18, 2013 10:11 pm


I know this thread is old now but I guess there are still some people looking for this. What about this website,

Really good website for logging planes you see and its free too. Filter and search on logged aircraft is really useful.

Check it out!
User avatar
Posts: 4802
Joined: Sun Sep 16, 2001 2:33 am

RE: Spotting Database (Logbook)

Fri Aug 23, 2013 10:10 pm

There's also

They have their own database so you don't need to enter the information yourself - just enter the reg and it will look it up for you.

It's also a great site just for looking up registrations, they have one of the largest databases of regs on the net - pretty much every aircraft that's ever been built since the end of WWII. They've got everything from Comets to 787's. Even the Space Shuttle and Spruce Goose are in there!

Who is online

Users browsing this forum: No registered users and 1 guest

Popular Searches On

Top Photos of Last:   24 Hours  •  48 Hours  •  7 Days  •  30 Days  •  180 Days  •  365 Days  •  All Time

Military Aircraft Every type from fighters to helicopters from air forces around the globe

Classic Airliners Props and jets from the good old days

Flight Decks Views from inside the cockpit

Aircraft Cabins Passenger cabin shots showing seat arrangements as well as cargo aircraft interior

Cargo Aircraft Pictures of great freighter aircraft

Government Aircraft Aircraft flying government officials

Helicopters Our large helicopter section. Both military and civil versions

Blimps / Airships Everything from the Goodyear blimp to the Zeppelin

Night Photos Beautiful shots taken while the sun is below the horizon

Accidents Accident, incident and crash related photos

Air to Air Photos taken by airborne photographers of airborne aircraft

Special Paint Schemes Aircraft painted in beautiful and original liveries

Airport Overviews Airport overviews from the air or ground

Tails and Winglets Tail and Winglet closeups with beautiful airline logos