Posts Tagged ‘license’

Licensed Amateurs by State

 How Extra is Your State?

My amateur radio license was set to expire early in 2026, so I sat down to navigate the FCC’s renewal process. I don’t recall a separate payment system (CORES) needing to be tethered to an FRN a decade ago, but it’s there now, and hopefully at your next renewal you will enjoy the game of Bureaucratic Twister as much as I did. I'll spare you that particular headache for this post.

While I was clicking through the digital maze, it reminded me of the time I spent a decade ago studying to upgrade from General to Extra. I wanted the extra band privileges and the ability to help out as a VE, but it made me wonder: how many amateurs actually bother with the climb to the top of the licensing hill?

Back in 2006, the upgrade from Technician to General still required the 5 WPM Morse test. If I’d had the audacity to try for Extra at that time, I would have needed to demonstrate 20 WPM. Since I was already struggling to keep my head above water at 5 WPM, the prospect of hitting 20 felt about as realistic as me winning the lottery.

The FCC eventually dropped the Morse requirement in 2007, but I didn't give the upgrade serious thought until 2015 when I started playing with QRP rigs and CW again. The reality is that if you enjoy working CW, there are exclusive neighborhoods in the bands that you simply can’t enter without an Extra ticket—and that’s usually where the best DX is hiding.
Amateur Extras - Percentage by State




Show me the data

That was a wordy intro, so what’s this really about? I wanted to be able to query the FCC database. There was supposedly an API at one time, but that seems to be defunct now. However, you can still download the entire FCC database as a zip file: https://data.fcc.gov/download/pub/uls/complete/l_amat.zip That download provides a collection of pipe-delimited files containing the raw data from the FCC amateur license database. Many of these are large files, containing data that is related by call sign or fccid records.

If you were so inclined, you could load those records into the database of your choice, a Jupyter Notebook, or any other tool to query it.  I would guess they are too large for Excel but not having Excel I can't be sure. Fortunately, a helpful ham created a bash script that downloads and parses these files into a MySQL database. You can find the repository for that script at: https://github.com/k3ng/hamdb

I had to modify the script slightly to get it running under Windows, but otherwise, it worked as expected. The script includes some simple commands to send SQL to the database server to look up a record by call sign or return all call signs for a specific zip code. In my initial testing, I found it interesting that there are 257 licensed operators in my zip code.

However, if you want to obtain interesting insights that requires writing SQL (Structured Query Language), which is the standard for relational databases like MySQL or PostgreSQL. If you haven’t spent time as a software developer, that might seem a little daunting. 

But in this bold new age of "I don't need to know nothin because I have an AI assistant" 

Anyone can now generate a SQL script to return the results they are looking for.

Specifically, I wanted to know how many amateur operators held Extra Class licenses across all states. It was a bit tricky to pull the correct data because the operator class is part of a table that contains every upgrade and renewal. Since there are multiple records for many call signs, you have to build a query that returns only the most recent result from the updates (hd) table.

Example SQL Query:

SELECT 
    e.state,
    -- Total count of all active licenses in the state
    COUNT(*) AS total_licenses,
    -- Count of Extra Class specifically
    SUM(CASE WHEN a.class = 'E' THEN 1 ELSE 0 END) AS extra_class_count,
    -- Percentage of the state's total that is Extra Class
    ROUND(SUM(CASE WHEN a.class = 'E' THEN 1 ELSE 0 END) * 100.0 / COUNT(*), 2) AS state_extra_percentage,
    -- Distribution of other classes (optional context)
    SUM(CASE WHEN a.class = 'G' THEN 1 ELSE 0 END) AS general_count,
    SUM(CASE WHEN a.class = 'T' THEN 1 ELSE 0 END) AS technician_count
FROM fcc_amateur.am AS a
JOIN fcc_amateur.en AS e ON a.fccid = e.fccid
INNER JOIN (
    -- Get the single highest fccid (most recent) for every callsign
    SELECT MAX(fccid) AS latest_fccid
    FROM fcc_amateur.hd
    WHERE status = 'A'
    GROUP BY callsign
) AS latest ON a.fccid = latest.latest_fccid
WHERE e.state IS NOT NULL AND e.state != ''
GROUP BY e.state
ORDER BY extra_class_count DESC;

I joined those results with census data into a Google Sheet to provide the following:

Results



Conclusion

That table shows that Idaho has the highest percentage of Amateur Radio licenses  by population but one of the lowest percentage of operators upgraded to Extra class. 

The column "One out of every" I find interesting just to demonstrate how rare licensed operators are in the population.  For example, in the state of North Carolina where I reside while there are 25,924 licensed operators, given the total population of the state only one out of every 42,609 persons are a licensed operator.  There are more doctors in the state than licensed amateur operators.

As to my original question of how many upgraded to Extra there are only 5,705 amateurs in NC or 22% of the licensed operators.  So almost a quarter of operators in NC upgraded to Extra.  It ranks slightly better than other states in that regard (see map above).

Play around with the table and let me know in a comment if you find anything surprising or interesting.



That's all for now

72/73 de Richard AA4OO

About That (Expletive) ARRL Proposal to Give Technicians The Whole World

It is my observation that by enabling someone a taste of what can be accomplished on HF (shortwave) spectrum, especially using one of the newer digital modes, that someone has an opportunity for inspiration, perhaps enough to catch the HF fever that is required to move that someone from entry-level to experienced, skilled expert. Right now, the regulations limit the Technician-level license holder to digital operation only on bands that barely propagate (if at all!) during the weak solar cycles. It is a far stretch to postulate that having privileges on dead bands will inspire exploration and tempt the operator to upgrade to a higher license class.

I believe that Technician-class priveledges should be expanded so that entry-level amateur radio operators can get a practical taste of effectively-propagating HF signals on lower frequencies than those frequencies currently available to them for digital operation. And, the allowed mode on these subbands should include digital modes. This “would encourage a sustained interest in Amateur Radio and encourage further development of knowledge and operating skills,” a concept already proven by General-class operators that get enough of a taste that they then pursue the Amateur Extra license.

Comments to me are below the following video section. I also include my response.

In the following video, I share my opinion regarding the ARRL asking the FCC to grant more operating privileges across the many amateur radio allocations on shortwave (HF, or, High Frequencies). The video is my brief takeaway of ARRL’s petition: What is the issue, as a whole, and what the ARRL is addressing–the lack of desire by most current Techs to upgrade. The logic of my perspective concludes that if you give them a taste of lower-shortwave propagation and excitement, then they will want to upgrade. This logic is already proven as applicable by the fact that the General class exists. All this proposal will do is allow the tech to experience what could be very attractive. Just like for the General.

[embedyt]https://www.youtube.com/watch?v=BWSAvDWE3Js[/embedyt]

The next two videos are addendums to the first video:

[embedyt]https://www.youtube.com/watch?v=ty9HINa3nAg[/embedyt]

[embedyt]https://www.youtube.com/watch?v=83I3EEQxfZA[/embedyt]

I made a few technical mistakes in the first video. The last video contains corrections and further comments.

Comments Received, and My Response

I have received many responses–some in opposition, some in support. Here are example contrarian responses along with my reply:

[Dear] Tomas David Hood[:] Something for absolutely nothing has never taught anyone anything good, but to want another free lunch. 35 multiple guess easy questions was all that was asked to get general class privileges, but that’s just too hard for the current class. Something for nothing is what sell today, and the ARRL, and probably half the country thinks socialism is the way to reach the new hams I guess. But the ARRL will never get another dime from me. You want a trophy or additional privileges, Get them as everyone else did,, Work for them, study, just a little is all that was asked. Remember, If it didn’t cost anything, it probably isn’t worth anything!

If they are not willing to take a simple test, and yet they want to upgrade, then yes they are the same as saying that we are asking too much, but would participate, you are suggesting, as long as it didn’t require any work or effort on their part, Its a shame.. And I am embarrassed on their behalf… Alexandria Ocasio-Cortez could pass that test, but she would probably agree with you, that people are asking them to be smart and study, and that’s somehow probably racist and just over the line for you.

At this point the ARRL should just say, we are not protecting the spectrum, but about selling the ham radio spectrum to the highest bidders. In this case, they be;live that will be the techs who will purchase HF gear, and of course, the ARRL will benefit hugely from the equipment makers desire to market to the group.

My response is:

What the heck is wrong with selling radios?

But, seriously, which of the many Technicians say that they want to upgrade? That’s the point: the majority of Technician-class amateur radio operators are not upgrading. They get on VHF and above, and are stationary, with few realizing that there’s so much more than the aspect of the hobby evident in their local community.

With little to no exposure to other aspects of the hobby, the typical ham in the current ham-radio culture settles for what is presented by local mentors. Weather spotting, DMR, etc.

Because they have current HF privileges that have so little practical use (CW only on lower frequencies; voice on 10 meters which doesn’t propagate well during this period of no sunspot activity…), they see no incentive to delve into what appears like a waste of time.

The proposal is not giving away the farm. It simply adds a small slice on a limited set of HF bands (but where a signal has a better chance of propagation), allowing for Technician-class operators to get a real sense of the potential waiting for them if they pursue the General.

Then, once upgraded to General, they get even more exposure, and hopefully, see why it is great to be an Amateur Extra.

Tomas David Hood what’s wrong with selling radios. Nothing at all, but if I removed the test that drivers take to show they understand the rules and how to drive, then I can sell more cars and more insurance to poor drivers. Do you or anyone else think that’s a good idea. A few tech’s putting their hands on the plate of those high voltage amps, and maybe, just maybe, someone will believe me when I say some basic testing should be required for HF privileges. Now, all they will have is a cereal box license in my book, and in the opinion of many of my friends, so it;s not just me. If I am wrong, then there are a lot of people that are wrong like me, and they will fight for there hobby. I am a ARRL VE, but I will never test another Ham if this goes through, and I will spend the rest of my days making sure any newcomers realize what the ARRL did to what once was a good hobby, and how a few people didn’t seem to understand why giving away free privileges is always bad for our society, and always bad for our hobby.

Actually I have a real case study that is local,, and yes the guy doid put his hand on the plate, and yes he hit the floor.. and yes, after I found out he was ok,, I think it’s plenty funny,, Yes, they need to study more than that.

Me:

Your argument that Technician-class operators will kill themselves because the test is so easy that they will end up electrocuting themselves is yet another Red Herring. Technicians play with dangerous VHF, UHF, SHF equipment, with ominous dangerous aspects deserving respect. If you really think that the General test is the difference between life and death, why even worry? The number of technicians will be nicely reduced to a more acceptable, comfortable number.

I’ve seen Amateur Extra-class operators do the same sort of dangerous, life-threatening stunts.

The issue you are highlighting is a different problem that must be solved separately from the idea of creating a more practical incentive; all tests should be improved in such a way as to foster greater technical knowledge and awareness of all aspects of the hobby.

Better mentoring. Less us-vs-them. More education. More community. All of these should be explored and enhanced. Solve the problem, instead of ostracizing. And, realize that this proposed change is NOT a dumbing-down maneuver to give away the ham radio hobby to the unclean.

My Rebuttal Regarding the Petition by ARRL to the FCC to Expand Technician-Class Privileges

This is my reply to many responses that I have been receiving on my original blog entry, located at this AmateurRadio.com website,(my shortened URL: https://g.nw7us.us/arrl2fccR2) as well as to the original video, posted in that blog entry.

I wish to reply to all of those who are against the idea of expanding the privileges of the Technician-class licensee, the expansions including the ability to operate Voice and Digital in limited slices in a subset of lower-than-Ten-Meter amateur radio shortwave allocations.

It seems to me, that…

…the issue is not one of Technician-class licensees wanting more privileges, as a whole. What the ARRL is addressing is the *lack* of desire by most current Techs to upgrade.

The logic behind the idea of expanding privileges concludes that if you give them a taste of lower-shortwave propagation and excitement (by moving past the CW-only restriction on the lower tech allocations), then they *will* want to upgrade.

This logic is already proven as applicable by the fact that the General class exists! All that this proposal will do is allow the Tech to experience what could be very attractive–just like for the General.  If it worked in the past with Novice, Technician, General, Advanced, and Amateur Extra (exposing to all of HF, even if by way of a CW-only requirement), then it will work, now.  The difference is that the CW-only requirement on lower HF bands is highly restrictive because the mode is no longer needed to operate on any frequency, and, most will not take the time to learn it just to see if they WANT to explore the lower HF bands, or ever upgrade.

The bottom line is that we should make the Tech ticket more relevant. The expansion is not dumbing down, nor does it give away the farm.

I discuss this original point in the two videos that were lower down in the original post:

[embedyt] https://www.youtube.com/watch?v=ty9HINa3nAg[/embedyt]

and,

[embedyt] https://youtu.be/83I3EEQxfZA[/embedyt]

Thanks for reading, watching the videos, and having a useful dialog about this very important change to the amateur radio regulations in the USA.

P.S., 

That aside: This may, in the long term, reveal one of two possible truths:

1. There is no real need for three license classes. Two would suffice. General and Amateur Extra, or Technician (merged with General) and Amateur Extra.

2. There is no real need for three license classes. One would suffice. Make the test hard enough to cover the Extra-class material, and all material under that class, and merge everyone into one tested class. I believe that this has been tried in other countries, and it appears to work well.

I’ll be crucified for stating those ideas, but, hey, this is just a hobby.

73 de NW7US dit dit

What? ARRL Petitions FCC to Expand Privileges of Technician-Class Amateur Radio Operators

I have my opinion on ARRL asking FCC to grant more HF privileges to Technician-class licensees.

I verbalize them in this video:

[embedyt]https://www.youtube.com/watch?v=BWSAvDWE3Js[/embedyt]

After you hear my comments, please leave your comments.

Thanks, 73 de NW7US dit dit

Complete Version: On How NCIS Maligned the Amateur Radio Service

Some of you wanted to see the complete version, uncut, of this video in which I discuss the differences between CB and the Amateur Radio Service.  This is in response to the recent episode in which the NCIS writers missed a great opportunity to discover the vibrant reality of the current amateur radio service in the United States of America.

The previous version of the video was prematurely cut short by just over three minutes.  This version includes that ending.  I also remove some of the low-end rumblings from the vehicle.  This version should sound a little bit less annoying.  Hopefully, the quality of the video is sharper, as well.  This version was edited by Adobe Premiere CC 2017.

I appreciate the many comments, views, and shares.  Please subscribe, too!

73 from Omaha!

 

 

LHS Episode #164: Ancient Antenna Modeling

AncientAntennaModelingWe're done with the editing of Episode #164 and here it is for your listening pleasure. In this episode, your hosts tackle topics from Bugbook computers to permanent amateur radio licenses, from Turing phones to Raspberry Pi computers and from antenna modeling software to lobster on pizza. We hope everyone will find something to enjoy. Please let us know by sending us feedback. We'd love to hear from you.

73 de The LHS Crew

Amateur Radio Newsline Report 1954 February 27 2015

 

 

  • Ham radio responds as a pair of tropical cyclones hit Australia
  • The FCC and the FDA look the future of medical remote electronics
  • Printed FCC issued ham licenses come to an end
  • Stunning images received from the latest ISS slow-scan television experiment
  • And the nominating period opens for the 2015 Amateur Radio Newsline Young Ham of the Year Award

 

    THIS WEEK'S NEWSCAST

           Script

          Audio

     


    Subscribe FREE to AmateurRadio.com's
    Amateur Radio Newsletter

     
    We never share your e-mail address.


    Do you like to write?
    Interesting project to share?
    Helpful tips and ideas for other hams?

    Submit an article and we will review it for publication on AmateurRadio.com!

    Have a ham radio product or service?
    Consider advertising on our site.

    Are you a reporter covering ham radio?
    Find ham radio experts for your story.

    How to Set Up a Ham Radio Blog
    Get started in less than 15 minutes!


    • Matt W1MST, Managing Editor