Some interesting ASC licensing stats for 2025

[cpursley]

I decided to pull down the ASC appraiser licensing data which has exactly 91,291 records and analyze them. As you all are aware of by now, government data is really messy and varies wildly. So I converted the CSV into SQL and spent some time deduplicating and cleaning it up then splitting into appraisers and licenses (as many are licensed in multiple states). The data is nowhere near perfect, but thought y'all would still find it interesting:

General Statistics​

• Total Appraisers: 61,379
• Total Licenses: 91,273
• Average Licenses per Appraiser: 1.49

License Distribution​

• Certified Residential: 44,516 (48.77% of all licenses)
• Certified General: 40,225 (44.07% of all licenses)
• Licensed Residential: 6,532 (7.16% of all licenses)

Multiple Licenses​

• Appraisers with Multiple Licenses: 12,582 (20.5% of all appraisers)
• License Count Distribution:
  • 1 license: 48,797 appraisers (79.5%)
  • 2 licenses: 7,654 appraisers (12.5%)
  • 3 licenses: 2,227 appraisers (3.6%)
  • 4 licenses: 894 appraisers (1.5%)
  • 5+ licenses: 1,807 appraisers (2.9%)
  • Maximum licenses for a single appraiser: 51 (4 appraisers have this many)

Geographic Distribution​

• Top 10 States by Appraiser Count:
  1. California (CA): 6,686
  2. Florida (FL): 4,653
  3. New York (NY): 2,287
  4. Illinois (IL): 2,242
  5. North Carolina (NC): 2,159
  6. Georgia (GA): 2,143
  7. Pennsylvania (PA): 1,989
  8. Ohio (OH): 1,950
  9. Colorado (CO): 1,881

 

[Tom D]

In Pa #1,989. Year it started, Pa was less than 700. Still too many, but even going down it is too late to bring back the living dead.

 

[Terrel L. Shields]

Lots of 2 and 3 license appraisers are border appraisers. I license in 2 states and do more work in OK than my home state. Above 4 you are a specialist or an AMC reviewer I bet.

 

[cpursley]

Above 4 you are a specialist or an AMC reviewer I bet.

Yeah, when I was a senior housing appraiser the MAI I worked for had licenses in a ton of states.

 

[Joe Flacco]

I have 3 licenses. I think most appraisers around here have at least 2.

 

[Terrel L. Shields]

r the MAI I worked for had licenses in a ton of states.

I know an appraiser who covers 7 states as a poultry farm specialist.

 

[Joe Flacco]

I read somewhere that Maryland has the most appraisers per capita.

Since you have the data cleaned up, can you do a table with appraisers per capita?

 

[cpursley]

Since you have the data cleaned up, can you do a table with appraisers per capita?

​

That's a neat idea, won't be able to get to it until probably tomorrow. If you don't hear back, feel free to remind me. Open to other stats as well.

Query still needs some refinement - someone pointed out elsewhere that Texas was missing from top ten (the ASC data is pretty bad quality).

 

[Joe Flacco]

That's a neat idea, won't be able to get to it until probably tomorrow. If you don't hear back, feel free to remind me. Open to other stats as well.

Query still needs some refinement - someone pointed out elsewhere that Texas was missing from top ten (the ASC data is pretty bad quality).

I will. I will remind you every time I see you.

 

[Non Sequitur]

Pretty sure I read the CA numbers are the lowest since licensing started.