Rob Boudrie
NES Member
- Joined
- Apr 24, 2005
- Messages
- 49,098
- Likes
- 36,633
I emailed the ATF and confirmed that there is no API for http://fflezcheck.gov . Perhaps they should get busy writing one so they can say "Working an a regulatory compliance API" instead of "Hanging around" when DOGE shows up and asks their software people wtf they are up to, but not tell them they are working on REST.
So, the only logical step is to download the entire FFL database with a nightly cron job so my application can query that directly. The ATF provides this, and includes all FFL types except 03's and 06's. So far, so good.
So, when I go to download there is a bogus FFL number that does not confirm to their numbering convention. The FFL for Sin City Cerakote in Henderson, NV is listed as 98800301VD06947. This is also expressed as 9-88-003-01-VD-06947. The fifth field, "VD" in this case, and should consist of a digit followed by a letter (A-M, excluding I) to encode the eggspiration date.
I reported this to the ATF using the supplied trouble report link. It will be interesting to see show they respond.
Some interesting trivia from the ATF ffl list downloaded (downloaded list excluses 03s and 06s):
More manufacturers (07) than dealers (01) in the DPRM:
Dealer in DDs is Type 09 and MA has exactly one:
Manufacturer of DDs is type 10:
So, the only logical step is to download the entire FFL database with a nightly cron job so my application can query that directly. The ATF provides this, and includes all FFL types except 03's and 06's. So far, so good.
So, when I go to download there is a bogus FFL number that does not confirm to their numbering convention. The FFL for Sin City Cerakote in Henderson, NV is listed as 98800301VD06947. This is also expressed as 9-88-003-01-VD-06947. The fifth field, "VD" in this case, and should consist of a digit followed by a letter (A-M, excluding I) to encode the eggspiration date.
I reported this to the ATF using the supplied trouble report link. It will be interesting to see show they respond.
Some interesting trivia from the ATF ffl list downloaded (downloaded list excluses 03s and 06s):
More manufacturers (07) than dealers (01) in the DPRM:
Code:
mysql> select licType,count(*) from atf_ffl where premise_state='ma' group by licType order by licType;
+---------+----------+
| licType | count(*) |
+---------+----------+
| 01 | 270 |
| 07 | 288 |
| 08 | 9 |
| 09 | 1 |
| 10 | 8 |
| 11 | 4 |
+---------+----------+
6 rows in set (0.03 sec)Dealer in DDs is Type 09 and MA has exactly one:
Code:
mysql> select licType, license_name, business_name, premise_street, premise_city, premise_state, premise_zip from atf_ffl where premise_state='ma' and licType=9;
+---------+-----------------------+---------------+-----------------------+--------------+---------------+-------------+
| licType | license_name | business_name | premise_street | premise_city | premise_state | premise_zip |
+---------+-----------------------+---------------+-----------------------+--------------+---------------+-------------+
| 09 | CENTRAL EQUIPMENT LLC | | 34 BARSTOW ST UNIT 2A | MATTAPOISETT | MA | 02739 |
+---------+-----------------------+---------------+-----------------------+--------------+---------------+-------------+
1 row in set (0.05 sec)Manufacturer of DDs is type 10:
Code:
mysql> select licType, license_name, business_name, premise_street, premise_city, premise_state, premise_zip from atf_ffl where premise_state='ma' and licType=10;
+---------+---------------------------------------+--------------------------------+----------------------------+------------------+---------------+-------------+
| licType | license_name | business_name | premise_street | premise_city | premise_state | premise_zip |
+---------+---------------------------------------+--------------------------------+----------------------------+------------------+---------------+-------------+
| 10 | BROWN, DAVID | NORTHBORO SMALL ARMS | 261 WEST ST | NORTHBOROUGH | MA | 01532 |
| 10 | TEXTRON SYSTEMS CORPORATION | TEXTRON SYSTEMS | 201 LOWELL ST | WILMINGTON | MA | 01887 |
| 10 | CYALUME TECHNOLOGIES INC | CYALUME TECHNOLOGIES | 96 WINDSOR ST | WEST SPRINGFIELD | MA | 01089 |
| 10 | FOSTER-MILLER INC | QINETIQ, QINETIQ NORTH AMERICA | 358 2ND AVE | WALTHAM | MA | 02451 |
| 10 | RAYTHEON COMPANY | | 350 LOWELL STREET | ANDOVER | MA | 01810 |
| 10 | ELECTROMECHANICA INC | | 13 INDUSTRIAL DR UNIT 2R | MATTAPOISETT | MA | 02739 |
| 10 | COLLINGS FOUNDATION, INC | AMERICAN HERITAGE MUSEUM | 137 BARTON RD | STOW | MA | 01775 |
| 10 | GENERAL DYNAMICS MISSION SYSTEMS, INC | GDMS | 400 JOHN QUINCY ADAMS ROAD | TAUNTON | MA | 02780 |
+---------+---------------------------------------+--------------------------------+----------------------------+------------------+---------------+-------------+
8 rows in set (0.07 sec)
Last edited:
