Scott, etal,

 

I did a quick check (and a few fixes) of my DB queries.

 

Attached is an XLS extract from my FAA DB extract (so folks check/analyze it themselves).  The xls has four tables 1) the summary counts, 2) the detail listing of all lancairs, 3) the turbines only, and 4) a listing by faa MFGYEAR.  The #2) detail sheet is sorted by family and serial number (zserial2).  You can re-sort it as you want.  zserial2 is my quick attempt to interpret the actual Lancair Kit serial#  where possible.

 

This extract includes everything I found.  Some have A/Wdates, some do not.  This is a little confusing to me, because I do not know how you register an aircraft without an airworthiness inspection.  Note: I know how to “reserve” an N-number and those are not included here, as the faa reservation process does not include make/model information.  You can check it yourself – my reserved number is N727RT.  It can be found in the FAA online web search, but was excluded from the extract since the reservation process does not have a field for make/model.  In looking at the date fields, obviously, there appears to be some “messiness/inconsistency” in the data (especially the dates).

I used two methods for determining a IV-turbine.  Either the NAME mentioned turbine or the faa ENGINE field indicated turbine.  Given that either could be wrong/incomplete, I used both.  In total, I now show 49 turbines, 29 with airworthiness dates.  That would tend to drive to the conclusion that turbines are (approximately ) no less likely to crash than IV’s (based on prior posts).

 

There are also a fair number of records in the FAA database without Registration numbers.  These show up on my extract starting with zzz in the N-number field.  I’m guessing these were either de-registered and/or were duplicates in the FAA make/model table.  Not surprised that the Gov is a bit “messed-up”.

 

For anyone interested, FAA certification code “42” is experimental/amateur-built.  If you look through the data, there are actually a couple Lancairs with a “11” code which are certified in the “Standard/Normal” category  (wow - I guess those couple can legally land anywhere in Southern Calif - LOL).

 

 

PLEASE HELP:

 

For anyone who wants to look up your own plane and email me (off list) with updates, I’ll compile those while eating turkey and watching football next week – and get a revised list out to all.  Would love to confirm flight status and (approx) first flight date if possible.

 

KimL/TimO, - I believe you also have a (company) list.  Any interest in reconciling?  (perhaps by N-Number if name etc is perceived to be too private).

 

Rick Titsworth

RTITSWORTH@MINDSPRING.COM      

 

Cell: 313-506-5604

 

 

 

w / Airworthiness Date
Count of AIR WORTH DATE
FAMILY	TYPE	Total
ES	EP	1
	ES	60
ES Total		61
IV	4	63
	4P	136
	4T	29
IV Total		228
Leg	L	80
	LF	4
Leg Total		84
Orig	1	1
	200	5
	210
	230	74
	290	1
	300
	320	150
	360	82
Orig Total		313
Tig	Tig	1
Tig Total		1
Unknown	?
Unknown Total
Grand Total		687

 

 

 

w / Certificate Issue Date
Count of CERT ISSUE DATE
FAMILY	TYPE	Total
ES	EP	1
	ES	85
ES Total		86
IV	4	87
	4P	182
	4T	42
IV Total		311
Leg	L	116
	LF	7
Leg Total		123
Orig	1	1
	200	5
	210	1
	230	79
	290	1
	300
	320	176
	360	107
Orig Total		370
Tig	Tig
Tig Total
Unknown	?	1
Unknown Total		1
Grand Total		891

 

 

 

Total FAA Data
Count of zserial2
FAMILY	TYPE	Total
ES	EP	1
	ES	94
ES Total		95
IV	4	107
	4P	211
	4T	48
IV Total		366
Leg	L	131
	LF	7
Leg Total		138
Orig	1	1
	200	8
	210	1
	230	106
	290	1
	300	1
	320	214
	360	132
Orig Total		464
Tig	Tig	1
Tig Total		1
Unknown	?	2
Unknown Total		2
Grand Total		1066

 

 

Rick