murphey
Touchdown! Greaser!
I've come to the conclusion that anyone who buys a computer and uses any search engine, needs to learn the basics of search concepts. Of course I've always been of the opinion that the unwashed masses should never have been allowed access or even knowledge of the Internet. There are times I curse TimBL for his brilliance.
To keep this aviation related ... before you start begging for answers, try a bit of common sense.
1) You want to know about flying in your area?
- There are state and local flying associations & clubs - do a search for them. Try search words such as "aviation [your state] flying club pilot association" or any combination. Be surprised what you can find. Another option is the [your state] Dept of Transportation, Div of Aeronautics (or whateve it's called)
2) You want to know other owners of your type aircraft or one you're interested in?
- Search the FAA Aircraft database. For every aircraft in your county:
http://registry.faa.gov/aircraftinquiry/statecounty_inquiry.aspx
For a specific make & model of aircraft:
http://registry.faa.gov/aircraftinquiry/acftref_inquiry.aspx
Download the results into a spreadsheet (there's a button for that), slice & dice to your hearts content.
3) Need to find a [CFI, CFII, ATP, whatever] - This one is NOT for the faint of heart or beginners. Best way is the local flying clubs. But, if you really want to spend some time playing with MS Access and really, really, REALLY are good at it....
- Another FAA database. This one's not easy. You really need to understand relational database with multiple records per person. But if you're adventurous, download the zipped plain text file at:
https://www.faa.gov/licenses_certificates/airmen_certification/releasable_airmen_download/
The instructions suggest MS Access (which makes it really difficult for us Mac/*nix people unless you're running MS Access in a VM) but you really need to understand it well. Because each person has multiple lines of text, it's not a simple import (even tho the instructions claim it's easy). There's only a couple search values you care about - "Cert Type" is P (for pilot) or F (for flight instructor) and then "Cert Level" is A, C, P, T, S (ATP, Comm, Private, sporT, Student)
One of these days I'll write up the instructions for MySQL or even MongoDB but not right now.
To keep this aviation related ... before you start begging for answers, try a bit of common sense.
1) You want to know about flying in your area?
- There are state and local flying associations & clubs - do a search for them. Try search words such as "aviation [your state] flying club pilot association" or any combination. Be surprised what you can find. Another option is the [your state] Dept of Transportation, Div of Aeronautics (or whateve it's called)
2) You want to know other owners of your type aircraft or one you're interested in?
- Search the FAA Aircraft database. For every aircraft in your county:
http://registry.faa.gov/aircraftinquiry/statecounty_inquiry.aspx
For a specific make & model of aircraft:
http://registry.faa.gov/aircraftinquiry/acftref_inquiry.aspx
Download the results into a spreadsheet (there's a button for that), slice & dice to your hearts content.
3) Need to find a [CFI, CFII, ATP, whatever] - This one is NOT for the faint of heart or beginners. Best way is the local flying clubs. But, if you really want to spend some time playing with MS Access and really, really, REALLY are good at it....
- Another FAA database. This one's not easy. You really need to understand relational database with multiple records per person. But if you're adventurous, download the zipped plain text file at:
https://www.faa.gov/licenses_certificates/airmen_certification/releasable_airmen_download/
The instructions suggest MS Access (which makes it really difficult for us Mac/*nix people unless you're running MS Access in a VM) but you really need to understand it well. Because each person has multiple lines of text, it's not a simple import (even tho the instructions claim it's easy). There's only a couple search values you care about - "Cert Type" is P (for pilot) or F (for flight instructor) and then "Cert Level" is A, C, P, T, S (ATP, Comm, Private, sporT, Student)
One of these days I'll write up the instructions for MySQL or even MongoDB but not right now.
Last edited: