VansAirForceForums  
Home > VansAirForceForums

- POSTING RULES
- Donate yearly (please).
- Advertise in here!

- Today's Posts | Insert Pics


Go Back   VAF Forums > Main > RV General Discussion/News
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Display Modes
  #11  
Old 01-10-2012, 10:57 AM
Phlyan Pan Phlyan Pan is offline
 
Join Date: Aug 2010
Location: Rochester, NY
Posts: 174
Default

Quote:
Originally Posted by David_Nelson View Post
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.
Reply With Quote
  #12  
Old 01-10-2012, 11:00 AM
David_Nelson's Avatar
David_Nelson David_Nelson is offline
 
Join Date: Feb 2006
Location: Austin, TX
Posts: 433
Default 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
Reply With Quote
  #13  
Old 01-10-2012, 11:30 AM
PCHunt PCHunt is offline
 
Join Date: Feb 2007
Location: San Diego, CA
Posts: 1,670
Default 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
Reply With Quote
  #14  
Old 01-10-2012, 11:48 AM
jbagley's Avatar
jbagley jbagley is offline
 
Join Date: Sep 2009
Location: Aloha, or
Posts: 282
Default

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
Reply With Quote
  #15  
Old 01-10-2012, 03:39 PM
carlrai's Avatar
carlrai carlrai is offline
 
Join Date: May 2005
Posts: 502
Default 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
Reply With Quote
  #16  
Old 01-10-2012, 04:56 PM
Clayton Clayton is offline
Super Moderator
 
Join Date: Dec 2011
Location: Dallas/Fort Worth
Posts: 40
Default

David,

Very nice application. Thanks for sharing.

Clayton
Reply With Quote
  #17  
Old 01-10-2012, 05:19 PM
David_Nelson's Avatar
David_Nelson David_Nelson is offline
 
Join Date: Feb 2006
Location: Austin, TX
Posts: 433
Default

Quote:
Originally Posted by jbagley View Post
How is this different from the FAA n-numbers inquiry application?

http://registry.faa.gov/aircraftinqu...V_Inquiry.aspx
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 View Post
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
Reply With Quote
  #18  
Old 01-10-2012, 05:37 PM
LifeofReiley's Avatar
LifeofReiley LifeofReiley is offline
 
Join Date: Jan 2005
Location: Round Rock, TX
Posts: 3,778
Default

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
Reply With Quote
  #19  
Old 01-10-2012, 07:47 PM
David-aviator David-aviator is offline
 
Join Date: Feb 2005
Location: Chesterfield, Missouri
Posts: 4,514
Default 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
Reply With Quote
  #20  
Old 01-11-2012, 06:35 AM
Ironflight's Avatar
Ironflight Ironflight is offline
VAF Moderator / Line Boy
 
Join Date: Jan 2005
Location: Dayton, NV
Posts: 12,256
Default

Quote:
Originally Posted by David-aviator View Post
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -6. The time now is 12:45 AM.


The VAFForums come to you courtesy Delta Romeo, LLC. By viewing and participating in them you agree to build your plane using standardized methods and practices and to fly it safely and in accordance with the laws governing the country you are located in.