EAAAirVenture OshkoshShopJoin

E-LSA and S-LSA Headcount

Posted By:
Rick Daniels
42
Posts
7
#1 Posted: 11/19/2009 09:15:14

I am trying to get an estimate on the number of E-LSA and S-LSA aircraft in existence, preferably by State.  I have contacted FAA and they said that if the data was not accessible from their web site the data wasn't available.  I checked their search options and found none.  Anyone know of a resource for this information?



Rick N51149
John Traynor
8
Posts
1
#2 Posted: 11/19/2009 19:32:23

Not sure about the E-LSA's but for the LSA's check out ByDanJohnson.com . He has a count of all U.S. registered LSA's by Brand on his website. Look for the Yellow tab marked "LSA Market info" , then click on "Market share data throught August 2009".

Total S-LSA is 1688 (Note: S-SLA are factory built aircraft)

Hope this helps,

J.T.

Hayward,CA

 



J.T. Hayward,Ca
Ron Wanttaja
246
Posts
98
#3 Posted: 11/19/2009 20:27:35

Download the FAA Registration Database , unzip it, load the file called MASTER into your favorite database program, then search the "Certification" column for "9*" (Special Light Sport) or "48*" (Experimental Light Sport), then sort by the "STATE" column.  The Zip file includes a PDF that explains all the columns.

I can dump you the results for the 2 January 2009 database, if it's any use.   Or wait a month and a half and I'll do the same thing on the January 2010 database.

 

Ron Wanttaja



Ron Wanttaja
Rick Daniels
42
Posts
7
#4 Posted: 11/19/2009 20:37:28

Thanks to both.  I will give both resources a try.  If I need further help I will shout.



Rick N51149
Rick Daniels
42
Posts
7
#5 Posted: 11/19/2009 21:04:49

I got as far as loading the file called "MASTER" and it loaded in windows notebook.  Did not load in a sortable format.  I use excel.  Beyond that my computer knowledge dies.  If you will, please send me the 2 January 2009 Database.  Send to rick@rickdaniels.com.  Thanks in advance. 



Rick N51149
Ron Wanttaja
246
Posts
98
#6 Posted: 11/20/2009 11:00:53
Rick Daniels wrote:

 


I got as far as loading the file called "MASTER" and it loaded in windows notebook.  Did not load in a sortable format.  I use excel.  Beyond that my computer knowledge dies.  If you will, please send me the 2 January 2009 Database.  Send to rick@rickdaniels.com.  Thanks in advance. 

"Excel" is limited to ~65,000 records, and the FAA registration database is over 300,000 entries. I've generated an Excel file with the state-by-state totals of ELSAs and SLSAs.  Note that the ELSAs include the "Grandfathered" fat ultralights as well as the production-type ELSAs.

I was curious about the "Attachment" function here, so it's attached to this messsage....

 

 



Files Attachment(s):
LSAs_by_State.xls (16896 bytes)
Ron Wanttaja
Jerry Rosie
Young Eagles Pilot or Volunteer
482
Posts
101
#7 Posted: 11/20/2009 11:52:57

 "I was curious about the "Attachment" function here, so it's attached to this messsage...."

Thanks for that.  Now it is available to all of us.

 



Cheers, Jerry NC22375 out of 07N
Rick Daniels
42
Posts
7
#8 Posted: 11/20/2009 12:20:31

Thank you, Thank you, Thank you. 



Rick N51149
Ron Wanttaja
246
Posts
98
#9 Posted: 11/21/2009 17:55:20 Modified: 11/25/2009 12:10:20
Gerald Rosie wrote:

 

 "I was curious about the "Attachment" function here, so it's attached to this messsage...."

Thanks for that.  Now it is available to all of us.

 

Since there's interest, here's another version that includes the Experimental Amateur-Built registries for each state.  Again, note this is based on January 2009 data.

Interesting to note that 15 homebuilts are registered in the District of Columbia.  Two are owned by the National Air and Space Museum (Leo Loudenslager's Stephens Acro and the Pitts Special S/N 2).  Of the remainder, there are a couple of RV-7s, a couple more Pitts', and a couple of Lancair 320s.   One is a rare Flying Plank EPB-2.  There's also a Spencer Aircar; a bit more common but still a fairly rare bird.

Three of the planes' "Manufacturer Name" matches the current registered owner, which indicates that the plane is still owned by its builder.   Most are registered in Washington itself, though one has a Chevy Chase address, and one each list Andrews and Bolling Air Force Bases.  These are possibly owned by service members. 


Post of the Week: 11/26/09

Ron -

The goal of Oshkosh365 is, as the name implies, to capture some of the things that happen here for one week every summer and use the power of the web to keep them going the rest of the year. Members sharing information and finding ways to help each other out are a big part of that; and your spreadsheet, along with the highlights you called out, is a pitch-perfect example.

Thanks for the value you've brought to Oshkosh365!

- Hal Bryan

EAA Online Community Manager

 

 



Files Attachment(s):
by_state.xls (12800 bytes)
Ron Wanttaja