|
-
POSTING RULES

-
Donate yearly (please).
-
Advertise in here!
-
Today's Posts
|
Insert Pics
|

01-10-2012, 10:57 AM
|
|
|
|
Join Date: Aug 2010
Location: Rochester, NY
Posts: 174
|
|
Quote:
Originally Posted by David_Nelson
I'm glad to see that it's proving useful!
Hi Phlyan Pan - It seems to be working correctly as '38TS', '61TS' and '68TS' are reported as being available. The sorting could use some work; I'll give that some thought and see what develops.
Regards,
|
You're right....it worked this time. I swear last time I went through the whole darned list and didn't see them.
|

01-10-2012, 11:00 AM
|
 |
|
|
Join Date: Feb 2006
Location: Austin, TX
Posts: 433
|
|
Fixed the sort order
I found the relevant bits to fix the sorting. Results are sorted by length followed by binary (kinda alphanumerical). Let me know if this seems a reasonable solution.
Number of returned entries: 458
46PH
69PH
74PH
80PH
86PH
175PH
176PH
178PH
.
.
. Darwin - I'll do better in the future. 
__________________
/\/elson
RV-7A Tip-Up
NW Austin, TX
|

01-10-2012, 11:30 AM
|
|
|
|
Join Date: Feb 2007
Location: San Diego, CA
Posts: 1,670
|
|
PM
Sent you a PM.
__________________
Pete Hunt, [San Diego] VAF #1069
RV-6, RV-6A, T-6G
ATP, CFII, A&P
2020 Donation+, Gladly Sent
|

01-10-2012, 11:48 AM
|
 |
|
|
Join Date: Sep 2009
Location: Aloha, or
Posts: 282
|
|
How is this different from the FAA n-numbers inquiry application?
http://registry.faa.gov/aircraftinqu...V_Inquiry.aspx
Are you querying their system live? Or do you have the the static database?
I think there are some interesting ways this data could be leveraged. I'll send you a PM with a few ideas.
__________________
James Bagley Jr
RV6A flying
RV6 #2 tail done and wings done
|

01-10-2012, 03:39 PM
|
 |
|
|
Join Date: May 2005
Posts: 502
|
|
Well Done!
Slick, Elegant tool
Let's see..... I can build a 3, 6, 7 & 8 N134CR, N164CR, N174CR, N184CR to compliment N194CR
__________________
Carl Raichle
Lutz, FL
RV-9A N194CR
RV-14A Under construction
Based at KZPH
AA4SR
|

01-10-2012, 04:56 PM
|
|
Super Moderator
|
|
Join Date: Dec 2011
Location: Dallas/Fort Worth
Posts: 40
|
|
David,
Very nice application. Thanks for sharing.
Clayton
|

01-10-2012, 05:19 PM
|
 |
|
|
Join Date: Feb 2006
Location: Austin, TX
Posts: 433
|
|
Quote:
Originally Posted by jbagley
|
Hi James,
The FAA's DB doesn't allow you to do substring searches/matches. It's also a one-at-a-time submission while you are left trying to think of possible combinations to try out.
Quote:
Originally Posted by jbagley
Are you querying their system live? Or do you have the the static database?
I think there are some interesting ways this data could be leveraged. I'll send you a PM with a few ideas.
|
I d/l the FAA's data and then massage a bit with a backend SQL database. Other than the data (re)loading and manipulation, it's pretty much static.
I liked your ideas. Depending on where this "pet project" goes in the long term, I think they are interesting and could be further developed.
Regards,
__________________
/\/elson
RV-7A Tip-Up
NW Austin, TX
|

01-10-2012, 05:37 PM
|
 |
|
|
Join Date: Jan 2005
Location: Round Rock, TX
Posts: 3,778
|
|
Okay David... Nice work! Now get back to flying... and wheel pants. 
__________________
Reiley
Retired N622DR - Serial #V7A1467
VAF# 671
Repeat Offender / Race 007
Friend of the RV-1
|

01-10-2012, 07:47 PM
|
|
|
|
Join Date: Feb 2005
Location: Chesterfield, Missouri
Posts: 4,514
|
|
It ain't all that simple....
I reserved and paid for a number on line via the FAA web site on December 10, 2011. The number still has not been assigned to me (or anyone else). I called the FAA Registration Branch in Oklahoma today and asked how come. Here is the deal.
Just because you select a number and register it on line, you do not own it until the FAA gets around to processing the registration data submitted on line. As of today, they are processing data received on December 7, 2011. If your request came in before any other requests for that number and the number is unassigned, you get it. If not, they send you a refund and you get to do it all over again.
Selecting a number that is unassigned is not yours, whether it be directly with the FAA or via another route like this program, until the FAA gets around to finalizing the deal and that could take up to 6 weeks.
__________________
RV-12 Build Helper
RV-7A...Sold #70374
The RV-8...Sold #83261
I'm in, dues paid 2019 This place is worth it!
Last edited by David-aviator : 01-11-2012 at 08:06 AM.
Reason: 2012 CHANGED TO 2011
|

01-11-2012, 06:35 AM
|
 |
VAF Moderator / Line Boy
|
|
Join Date: Jan 2005
Location: Dayton, NV
Posts: 12,256
|
|
Quote:
Originally Posted by David-aviator
I reserved and paid for a number on line via the FAA web site on December 10, 2012. The number still has not been assigned to me (or anyone else). I called the FAA Registration Branch in Oklahoma today and asked how come. Here is the deal.
Just because you select a number and register it on line, you do not own it until the FAA gets around to processing the registration data submitted on line. As of today, they are processing data received on December 7, 2012. If your request came in before any other requests for that number and the number is unassigned, you get it. If not, they send you a refund and you get to do it all over again.
Selecting a number that is unassigned is not yours, whether it be directly with the FAA or via another route like this program, until the FAA gets around to finalizing the deal and that could take up to 6 weeks.
|
We had the same experience last year when someone alerted us to a VERY COOL N-number that was appropriate to our new airplane. I jumed on the FAA site in less than half a minute and put in the reservation. Credit card wsa charged within the hour. Two months later, we were informed that we didn't get it, and a month after that, we got the refund....
__________________
Paul F. Dye
Editor at Large - KITPLANES Magazine
RV-8 - N188PD - "Valkyrie"
RV-6 (By Marriage) - N164MS - "Mikey"
RV-3B - N13PL - "Tsamsiyu"
A&P, EAA Tech Counselor/Flight Advisor
Dayton Valley Airpark (A34)
http://Ironflight.com
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -6. The time now is 12:45 AM.
|