{"current_page":1,"data":[{"id":12150316,"change_date":"2026-06-10 21:44:00","inspection_id":"88099434","dot_number":"2159128","report_state":"AR","report_number":"7230001117","insp_date":"2026-06-10 00:00:00","insp_start_time":"0750","insp_end_time":"0840","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"STAMPS AR","county_code_state":"AR","county_code":"073","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"EL DORADO WATER UTILITIES","shipping_paper_number":"24129053","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3508805","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:31.000000Z","updated_at":"2026-06-21T09:31:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21107007,"change_date":"2026-06-10 21:44:00","inspection_id":"88099434","insp_unit_id":"214018620","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"426923","insp_unit_license":"R802612","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3BHJBWDR4TDWT8923","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:59.000000Z","updated_at":"2026-06-21T09:02:36.000000Z"},{"id":21107008,"change_date":"2026-06-10 21:44:00","inspection_id":"88099434","insp_unit_id":"214018621","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"L5032","insp_unit_license":"DJ4417","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H6KF4221S3173776","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:59.000000Z","updated_at":"2026-06-21T09:02:36.000000Z"}]},{"id":12096014,"change_date":"2026-06-04 21:45:00","inspection_id":"88040178","dot_number":"2159128","report_state":"OK","report_number":"V700173614","insp_date":"2026-06-04 00:00:00","insp_start_time":"0640","insp_end_time":"0709","registration_date":null,"region":"CS","ci_status_code":"C","location":"45070","location_desc":"OK","county_code_state":"OK","county_code":"089","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-04 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"2","hazmat_oos_total":"0","snet_sequence_id":"3466272","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":null,"census_search_date":"2026-06-04 21:45:00","snet_input_date":"2026-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:45:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-07T09:40:50.000000Z","updated_at":"2026-06-16T09:31:19.000000Z","inspection_violations":[{"id":21050698,"change_date":"2026-06-04 21:45:00","inspection_id":"88040178","insp_violation_id":"274691635","seq_no":"1","part_no":"177","part_no_section":"823A-HMRAMTVM","insp_viol_unit":"2","insp_unit_id":"213910616","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:00:51.000000Z","updated_at":"2026-06-16T09:45:49.000000Z","normalized_code":"177823AHMRAMTVM"},{"id":21050699,"change_date":"2026-06-04 21:45:00","inspection_id":"88040178","insp_violation_id":"274691636","seq_no":"2","part_no":"177","part_no_section":"823A-HMPMCM","insp_viol_unit":"2","insp_unit_id":"213910616","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:00:51.000000Z","updated_at":"2026-06-16T09:45:49.000000Z","normalized_code":"177823AHMPMCM"}],"inspection_per_units":[{"id":21018058,"change_date":"2026-06-04 21:45:00","inspection_id":"88040178","insp_unit_id":"213910615","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WEST","insp_unit_company":null,"insp_unit_license":"R802611","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3BHJBWDR2TDWT8922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:17:57.000000Z","updated_at":"2026-06-16T09:03:08.000000Z"},{"id":21018059,"change_date":"2026-06-04 21:45:00","inspection_id":"88040178","insp_unit_id":"213910616","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"DH6183","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3E1AAB235SS517054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:17:57.000000Z","updated_at":"2026-06-16T09:03:08.000000Z"}]},{"id":12088352,"change_date":"2026-06-03 21:36:00","inspection_id":"88032067","dot_number":"2159128","report_state":"TX","report_number":"V262362018","insp_date":"2026-06-01 00:00:00","insp_start_time":"0915","insp_end_time":"0937","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM 3129  MP 224","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AFFINITY CHEMICAL","shipping_paper_number":"24128672","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-03 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"9979259","transaction_code":"A","transaction_date":"2026-06-03 00:00:00","upload_date":"2026-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2026-06-03 21:36:00","snet_input_date":"2026-06-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-03 21:36:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2026-06-06T09:40:47.000000Z","updated_at":"2026-06-15T09:31:03.000000Z","inspection_violations":[{"id":21035895,"change_date":"2026-06-03 21:36:00","inspection_id":"88032067","insp_violation_id":"274672965","seq_no":"1","part_no":"172","part_no_section":"504A","insp_viol_unit":"2","insp_unit_id":"213896244","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-06T10:01:16.000000Z","updated_at":"2026-06-15T09:43:18.000000Z","normalized_code":"172504A"},{"id":21035896,"change_date":"2026-06-03 21:36:00","inspection_id":"88032067","insp_violation_id":"274672966","seq_no":"2","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"213896244","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-06T10:01:16.000000Z","updated_at":"2026-06-15T09:43:18.000000Z","normalized_code":"39375C"},{"id":21035897,"change_date":"2026-06-03 21:36:00","inspection_id":"88032067","insp_violation_id":"274672967","seq_no":"3","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"213896244","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-06T10:01:16.000000Z","updated_at":"2026-06-15T09:43:18.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":21005582,"change_date":"2026-06-03 21:36:00","inspection_id":"88032067","insp_unit_id":"213896243","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"426922","insp_unit_license":"R802611","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3BHJBWDR2TDWT8922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:18:01.000000Z","updated_at":"2026-06-15T09:02:36.000000Z"},{"id":21005583,"change_date":"2026-06-03 21:36:00","inspection_id":"88032067","insp_unit_id":"213896244","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"L5028","insp_unit_license":"DH6183","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3E1AAB235SS517054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:18:01.000000Z","updated_at":"2026-06-15T09:02:36.000000Z"}]},{"id":11644000,"change_date":"2026-04-14 21:39:00","inspection_id":"87573314","dot_number":"2159128","report_state":"TX","report_number":"V262282694","insp_date":"2026-04-10 00:00:00","insp_start_time":"0911","insp_end_time":"0954","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A501","location_desc":"US59 NB QUEEN CITY SCALE","county_code_state":"TX","county_code":"067","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NACOGDOCHES WASTEWATER TREATM","shipping_paper_number":"NA","cargo_tank":"307","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"123200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9918647","transaction_code":"A","transaction_date":"2026-04-14 00:00:00","upload_date":"2026-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2026-04-14 21:39:00","snet_input_date":"2026-04-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-14 21:39:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2026-04-25T09:31:05.000000Z","updated_at":"2026-04-25T09:31:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20254303,"change_date":"2026-04-14 21:39:00","inspection_id":"87573314","insp_unit_id":"213011016","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"L2301","insp_unit_license":"K825860","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"3HSDZAPR7RN758186","insp_unit_decal":"Y","insp_unit_decal_number":"36261527","created_at":"2026-04-25T09:03:51.000000Z","updated_at":"2026-04-25T09:03:51.000000Z"},{"id":20254304,"change_date":"2026-04-14 21:39:00","inspection_id":"87573314","insp_unit_id":"213011017","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"106","insp_unit_license":"119C938","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HLF1D7BXM9C40539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-25T09:03:51.000000Z","updated_at":"2026-04-25T09:03:51.000000Z"}]},{"id":11595888,"change_date":"2026-04-08 21:38:00","inspection_id":"87522063","dot_number":"2159128","report_state":"LA","report_number":"LANMS00908","insp_date":"2026-04-07 00:00:00","insp_start_time":"1052","insp_end_time":"1123","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BOSSIER CITY LA","county_code_state":"LA","county_code":null,"insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"AFFINITY CHEMICAL LLC","shipping_paper_number":"24127043","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3129425","transaction_code":"A","transaction_date":"2026-04-08 00:00:00","upload_date":"2026-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":null,"census_search_date":"2026-04-08 21:38:00","snet_input_date":"2026-04-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-08 21:38:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-11T09:42:39.000000Z","updated_at":"2026-04-19T09:32:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19876327,"change_date":"2026-04-08 21:38:00","inspection_id":"87522063","insp_unit_id":"212604404","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"426922","insp_unit_license":"R802611","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3BHJBWDR2TDWT8922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-11T09:19:42.000000Z","updated_at":"2026-04-18T09:36:09.000000Z"},{"id":19876328,"change_date":"2026-04-08 21:38:00","inspection_id":"87522063","insp_unit_id":"212604405","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"L5028","insp_unit_license":"DH6183","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3E1AAB235SS517054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-11T09:19:42.000000Z","updated_at":"2026-04-18T09:36:09.000000Z"}]},{"id":11595320,"change_date":"2026-04-08 21:38:00","inspection_id":"87521457","dot_number":"2159128","report_state":"LA","report_number":"LAADS00111","insp_date":"2026-04-06 00:00:00","insp_start_time":"0833","insp_end_time":"0901","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CHOUDRANT LA","county_code_state":"LA","county_code":null,"insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"AFFINITY CHEMICAL LLC","shipping_paper_number":"24126983","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3128693","transaction_code":"A","transaction_date":"2026-04-08 00:00:00","upload_date":"2026-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":null,"census_search_date":"2026-04-08 21:38:00","snet_input_date":"2026-04-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-08 21:38:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-11T09:42:39.000000Z","updated_at":"2026-04-19T09:31:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19875361,"change_date":"2026-04-08 21:38:00","inspection_id":"87521457","insp_unit_id":"212603320","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"L2301","insp_unit_license":"K825860","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"3HSDZAPR7RN758186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-11T09:19:42.000000Z","updated_at":"2026-04-18T09:36:00.000000Z"},{"id":19875362,"change_date":"2026-04-08 21:38:00","inspection_id":"87521457","insp_unit_id":"212603321","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"L5032","insp_unit_license":"DJ4417","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H6KF4221S3173776","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-11T09:19:42.000000Z","updated_at":"2026-04-18T09:36:00.000000Z"}]},{"id":11485597,"change_date":"2026-03-26 21:39:00","inspection_id":"87405023","dot_number":"2159128","report_state":"LA","report_number":"LANMS00859","insp_date":"2026-03-24 00:00:00","insp_start_time":"1003","insp_end_time":"1104","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BOSSIER CITY LA","county_code_state":"LA","county_code":null,"insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"AFFINITY CHEMICAL LLC","shipping_paper_number":"24126625","cargo_tank":"307","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"123200","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"3072240","transaction_code":"A","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":null,"census_search_date":"2026-03-26 21:39:00","snet_input_date":"2026-03-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-26 21:39:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-29T09:54:07.000000Z","updated_at":"2026-04-06T09:31:46.000000Z","inspection_violations":[{"id":19391316,"change_date":"2026-03-26 21:39:00","inspection_id":"87405023","insp_violation_id":"272657609","seq_no":"1","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:15.000000Z","updated_at":"2026-04-06T09:52:38.000000Z","normalized_code":"3958EHOSPD"},{"id":19391317,"change_date":"2026-03-26 21:39:00","inspection_id":"87405023","insp_violation_id":"272657610","seq_no":"2","part_no":"177","part_no_section":"834J2-HMBPDV","insp_viol_unit":"2","insp_unit_id":"212351232","insp_violation_category_id":"37","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-29T10:23:15.000000Z","updated_at":"2026-04-06T09:52:38.000000Z","normalized_code":"177834J2HMBPDV"}],"inspection_per_units":[{"id":19674323,"change_date":"2026-03-26 21:39:00","inspection_id":"87405023","insp_unit_id":"212351231","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"L2301","insp_unit_license":"K825860","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"3HSDZAPR7RN758186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:50:56.000000Z","updated_at":"2026-04-06T09:11:47.000000Z"},{"id":19674324,"change_date":"2026-03-26 21:39:00","inspection_id":"87405023","insp_unit_id":"212351232","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"110","insp_unit_license":"119C939","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HLF1D7B1M9C40543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:50:56.000000Z","updated_at":"2026-04-06T09:11:47.000000Z"}]},{"id":11428777,"change_date":"2026-03-20 21:40:00","inspection_id":"87344966","dot_number":"2159128","report_state":"TX","report_number":"V262259541","insp_date":"2026-03-18 00:00:00","insp_start_time":"1046","insp_end_time":"1114","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A501","location_desc":"US59 NB QUEEN CITY SCALE","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NACOGDOCHES WASTEWATER","shipping_paper_number":"24126244","cargo_tank":"307","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"123200","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9890299","transaction_code":"A","transaction_date":"2026-03-20 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:30.000000Z","inspection_violations":[{"id":19281824,"change_date":"2026-03-20 21:40:00","inspection_id":"87344966","insp_violation_id":"272529229","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"212244580","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:50.000000Z","updated_at":"2026-03-31T09:50:57.000000Z","normalized_code":"39021A"},{"id":19281825,"change_date":"2026-03-20 21:40:00","inspection_id":"87344966","insp_violation_id":"272529230","seq_no":"2","part_no":"393","part_no_section":"45B2PC","insp_viol_unit":"1","insp_unit_id":"212244580","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:50.000000Z","updated_at":"2026-03-31T09:50:57.000000Z","normalized_code":"39345B2PC"}],"inspection_per_units":[{"id":19578752,"change_date":"2026-03-20 21:40:00","inspection_id":"87344966","insp_unit_id":"212244581","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"110","insp_unit_license":"119C939","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HLF1D7B1M9C40543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:06.000000Z","updated_at":"2026-03-31T09:11:38.000000Z"},{"id":19578751,"change_date":"2026-03-20 21:40:00","inspection_id":"87344966","insp_unit_id":"212244580","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"L2301","insp_unit_license":"K825860","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"3HSDZAPR7RN758186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:06.000000Z","updated_at":"2026-03-31T09:11:38.000000Z"}]},{"id":11225046,"change_date":"2026-02-25 21:47:00","inspection_id":"87136970","dot_number":"2159128","report_state":"LA","report_number":"LAEMS00048","insp_date":"2026-02-25 00:00:00","insp_start_time":"0957","insp_end_time":"1031","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"CHOUDRANT LA","county_code_state":"LA","county_code":null,"insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"AFFINITY CHEMICAL LLC","shipping_paper_number":"24125850","cargo_tank":"307","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-25 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"110700","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2932398","transaction_code":"A","transaction_date":"2026-02-25 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":null,"census_search_date":"2026-02-25 21:47:00","snet_input_date":"2026-02-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-25 21:47:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:38:37.000000Z","updated_at":"2026-03-08T09:31:14.000000Z","inspection_violations":[{"id":18834383,"change_date":"2026-02-25 21:47:00","inspection_id":"87136970","insp_violation_id":"272016059","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"211819748","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:56:22.000000Z","updated_at":"2026-03-08T09:47:55.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":19177862,"change_date":"2026-02-25 21:47:00","inspection_id":"87136970","insp_unit_id":"211819748","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"L2301","insp_unit_license":"K825860","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"3HSDZAPR7RN758186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:08.000000Z","updated_at":"2026-03-08T09:05:41.000000Z"},{"id":19177863,"change_date":"2026-02-25 21:47:00","inspection_id":"87136970","insp_unit_id":"211819749","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"110","insp_unit_license":"119C939","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HLF1D7B1M9C40543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:08.000000Z","updated_at":"2026-03-08T09:05:41.000000Z"}]},{"id":11120639,"change_date":"2026-02-12 21:41:00","inspection_id":"87033695","dot_number":"2159128","report_state":"TX","report_number":"V262198834","insp_date":"2026-02-09 00:00:00","insp_start_time":"1005","insp_end_time":"1036","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A501","location_desc":"US59 NB QUEEN CITY SCALE","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LAKE PALESTINE WATER PLANT","shipping_paper_number":"24125319","cargo_tank":"307","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"123200","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"9848461","transaction_code":"A","transaction_date":"2026-02-12 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2026-02-12 21:41:00","snet_input_date":"2026-02-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-12 21:41:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2026-02-15T10:38:50.000000Z","updated_at":"2026-02-23T10:31:07.000000Z","inspection_violations":[{"id":18625345,"change_date":"2026-02-12 21:41:00","inspection_id":"87033695","insp_violation_id":"271769595","seq_no":"1","part_no":"172","part_no_section":"504A","insp_viol_unit":"2","insp_unit_id":"211598054","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:28.000000Z","updated_at":"2026-02-23T10:40:06.000000Z","normalized_code":"172504A"},{"id":18625346,"change_date":"2026-02-12 21:41:00","inspection_id":"87033695","insp_violation_id":"271769596","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"211598053","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:28.000000Z","updated_at":"2026-02-23T10:40:06.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":18967011,"change_date":"2026-02-12 21:41:00","inspection_id":"87033695","insp_unit_id":"211598053","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"L2301","insp_unit_license":"K825860","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"3HSDZAPR7RN758186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:20:11.000000Z","updated_at":"2026-02-23T10:03:40.000000Z"},{"id":18967012,"change_date":"2026-02-12 21:41:00","inspection_id":"87033695","insp_unit_id":"211598054","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"106","insp_unit_license":"119C938","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HLF1D7BXM9C40539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:20:11.000000Z","updated_at":"2026-02-23T10:03:40.000000Z"}]},{"id":10530098,"change_date":"2025-12-29 21:38:00","inspection_id":"86666186","dot_number":"2159128","report_state":"TX","report_number":"V252133044","insp_date":"2025-12-23 00:00:00","insp_start_time":"1032","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A501","location_desc":"US59 NB QUEEN CITY SCALE","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AFFINITY CHEMICAL","shipping_paper_number":"24123976","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-12-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"123200","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9797147","transaction_code":"A","transaction_date":"2025-12-29 00:00:00","upload_date":"2025-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2025-12-29 21:38:00","snet_input_date":"2025-12-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-29 21:38:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2026-01-01T10:34:44.000000Z","updated_at":"2026-01-09T10:30:44.000000Z","inspection_violations":[{"id":17681866,"change_date":"2025-12-29 21:38:00","inspection_id":"86666186","insp_violation_id":"270930008","seq_no":"1","part_no":"393","part_no_section":"75A3","insp_viol_unit":"2","insp_unit_id":"210832160","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-01T10:38:15.000000Z","updated_at":"2026-01-09T10:31:26.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":17636929,"change_date":"2025-12-29 21:38:00","inspection_id":"86666186","insp_unit_id":"210832159","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"L2301","insp_unit_license":"K825860","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"3HSDZAPR7RN758186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-01T10:08:41.000000Z","updated_at":"2026-01-09T10:00:56.000000Z"},{"id":17636930,"change_date":"2025-12-29 21:38:00","inspection_id":"86666186","insp_unit_id":"210832160","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"110","insp_unit_license":"119C939","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HLF1D7B1M9C40543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-01T10:08:41.000000Z","updated_at":"2026-01-09T10:00:56.000000Z"}]},{"id":10221834,"change_date":"2025-11-17 21:40:00","inspection_id":"86343637","dot_number":"2159128","report_state":"TX","report_number":"V252116746","insp_date":"2025-11-14 00:00:00","insp_start_time":"1037","insp_end_time":"1054","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A501","location_desc":"US59 NB QUEEN CITY SCALE","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AFFINITY","shipping_paper_number":"24122720","cargo_tank":"307","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"123200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9760314","transaction_code":"A","transaction_date":"2025-11-17 00:00:00","upload_date":"2025-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2025-11-17 21:40:00","snet_input_date":"2025-11-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-17 21:40:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2025-11-20T10:30:40.000000Z","updated_at":"2025-11-21T10:31:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17029976,"change_date":"2025-11-17 21:40:00","inspection_id":"86343637","insp_unit_id":"210079617","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"110","insp_unit_license":"119C939","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HLF1D7B1M9C40543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:41.000000Z","updated_at":"2025-11-21T10:01:31.000000Z"},{"id":17029975,"change_date":"2025-11-17 21:40:00","inspection_id":"86343637","insp_unit_id":"210079616","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"L2301","insp_unit_license":"K825860","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"3HSDZAPR7RN758186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:41.000000Z","updated_at":"2025-11-21T10:01:31.000000Z"}]},{"id":10137955,"change_date":"2025-11-06 21:40:00","inspection_id":"86255466","dot_number":"2159128","report_state":"OK","report_number":"V700173149","insp_date":"2025-11-05 00:00:00","insp_start_time":"0655","insp_end_time":"0735","registration_date":null,"region":"CT","ci_status_code":"C","location":"45070","location_desc":"US 70 \/ CHAPPELL RD","county_code_state":"OK","county_code":"089","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"24122529","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"2","hazmat_oos_total":"0","snet_sequence_id":"802728","transaction_code":"A","transaction_date":"2025-11-05 00:00:00","upload_date":"2025-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":null,"census_search_date":"2025-11-06 21:40:00","snet_input_date":"2025-11-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-11-06 21:40:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-09T10:31:42.000000Z","updated_at":"2025-11-10T10:30:57.000000Z","inspection_violations":[{"id":16821186,"change_date":"2025-11-06 21:40:00","inspection_id":"86255466","insp_violation_id":"269782187","seq_no":"1","part_no":"172","part_no_section":"516C2-HMPMC","insp_viol_unit":"2","insp_unit_id":"209883389","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:54.000000Z","updated_at":"2025-11-10T10:31:55.000000Z","normalized_code":"172516C2HMPMC"},{"id":16821187,"change_date":"2025-11-06 21:40:00","inspection_id":"86255466","insp_violation_id":"269782188","seq_no":"2","part_no":"180","part_no_section":"415-HMTMC","insp_viol_unit":"2","insp_unit_id":"209883389","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:54.000000Z","updated_at":"2025-11-10T10:31:55.000000Z","normalized_code":"180415HMTMC"},{"id":16821188,"change_date":"2025-11-06 21:40:00","inspection_id":"86255466","insp_violation_id":"269782189","seq_no":"3","part_no":"172","part_no_section":"519C1-HMPMC","insp_viol_unit":"2","insp_unit_id":"209883389","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:54.000000Z","updated_at":"2025-11-10T10:31:55.000000Z","normalized_code":"172519C1HMPMC"}],"inspection_per_units":[{"id":16875935,"change_date":"2025-11-06 21:40:00","inspection_id":"86255466","insp_unit_id":"209883389","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"L5032","insp_unit_license":"DJ4417","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H6KF4221S3173776","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-09T10:01:55.000000Z","updated_at":"2025-11-10T10:01:28.000000Z"},{"id":16875936,"change_date":"2025-11-06 21:40:00","inspection_id":"86255466","insp_unit_id":"209883390","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"R802612","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3BHJBWDR4TDWT8923","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-09T10:01:55.000000Z","updated_at":"2025-11-10T10:01:28.000000Z"}]},{"id":9089601,"change_date":"2025-07-22 21:42:00","inspection_id":"85153021","dot_number":"2159128","report_state":"OK","report_number":"V700172827","insp_date":"2025-07-07 00:00:00","insp_start_time":"1555","insp_end_time":"1632","registration_date":null,"region":"CT","ci_status_code":"C","location":"45098","location_desc":"SH 98 \/ BAKER RD","county_code_state":"OK","county_code":"089","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"790397","transaction_code":"C","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2025-07-08 21:38:00","snet_input_date":"2025-07-07 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-07-08 21:38:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:49.000000Z","updated_at":"2025-07-27T10:40:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15152102,"change_date":"2025-07-22 21:42:00","inspection_id":"85153021","insp_unit_id":"208013052","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421980","insp_unit_license":"R474141","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDR5MSMJ7980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:39.000000Z","updated_at":"2025-07-26T09:45:46.000000Z"},{"id":15152103,"change_date":"2025-07-22 21:42:00","inspection_id":"85153021","insp_unit_id":"208013053","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"L5032","insp_unit_license":"DJ4417","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H6KF4221S3173776","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:39.000000Z","updated_at":"2025-07-26T09:45:46.000000Z"}]},{"id":8836671,"change_date":"2025-06-06 21:40:00","inspection_id":"84885437","dot_number":"2159128","report_state":"OK","report_number":"V700172767","insp_date":"2025-06-06 00:00:00","insp_start_time":"0734","insp_end_time":"0809","registration_date":null,"region":"CT","ci_status_code":"C","location":"45070","location_desc":"US 70 1M W SH 98","county_code_state":"OK","county_code":"089","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"787534","transaction_code":"A","transaction_date":"2025-06-06 00:00:00","upload_date":"2025-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2025-06-06 21:40:00","snet_input_date":"2025-06-06 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-06-06 21:40:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-09T10:01:18.000000Z","updated_at":"2025-06-10T10:00:33.000000Z","inspection_violations":[{"id":14148253,"change_date":"2025-06-06 21:40:00","inspection_id":"84885437","insp_violation_id":"266706343","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"207263653","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-09T10:16:49.000000Z","updated_at":"2025-06-10T10:16:00.000000Z","normalized_code":"3922SLLSR"},{"id":14148254,"change_date":"2025-06-06 21:40:00","inspection_id":"84885437","insp_violation_id":"266706344","seq_no":"2","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"2","insp_unit_id":"207263653","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-09T10:16:49.000000Z","updated_at":"2025-06-10T10:16:00.000000Z","normalized_code":"3969D2FTF"},{"id":14148255,"change_date":"2025-06-06 21:40:00","inspection_id":"84885437","insp_violation_id":"266706345","seq_no":"3","part_no":"172","part_no_section":"519C1-HMPMC","insp_viol_unit":"1","insp_unit_id":"207263652","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-09T10:16:49.000000Z","updated_at":"2025-06-10T10:16:00.000000Z","normalized_code":"172519C1HMPMC"},{"id":14148256,"change_date":"2025-06-06 21:40:00","inspection_id":"84885437","insp_violation_id":"266706346","seq_no":"4","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"207263652","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-09T10:16:49.000000Z","updated_at":"2025-06-10T10:16:00.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":14468549,"change_date":"2025-06-06 21:40:00","inspection_id":"84885437","insp_unit_id":"207263652","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"R474140","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDR9MSMJ7979","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-09T09:46:18.000000Z","updated_at":"2025-06-10T09:45:44.000000Z"},{"id":14468550,"change_date":"2025-06-06 21:40:00","inspection_id":"84885437","insp_unit_id":"207263653","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"L5028","insp_unit_license":"DH6177","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3E1AAB235SS517054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-09T09:46:18.000000Z","updated_at":"2025-06-10T09:45:44.000000Z"}]},{"id":8056743,"change_date":"2025-03-07 21:39:00","inspection_id":"84063322","dot_number":"2159128","report_state":"TX","report_number":"V251787338","insp_date":"2025-03-05 00:00:00","insp_start_time":"0946","insp_end_time":"0956","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 20  609","county_code_state":"TX","county_code":"203","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AFFINITY CHEMICAL","shipping_paper_number":null,"cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-03-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9516849","transaction_code":"A","transaction_date":"2025-03-07 00:00:00","upload_date":"2025-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2025-03-07 21:39:00","snet_input_date":"2025-03-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-07 21:39:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2025-03-17T21:05:27.000000Z","updated_at":"2025-03-17T21:05:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13007665,"change_date":"2025-03-07 21:39:00","inspection_id":"84063322","insp_unit_id":"205684392","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421980","insp_unit_license":"R474141","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDR5MSMJ7980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:42.000000Z","updated_at":"2025-03-17T23:58:42.000000Z"},{"id":13007666,"change_date":"2025-03-07 21:39:00","inspection_id":"84063322","insp_unit_id":"205684393","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"L5032","insp_unit_license":"DJ4417","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H6KF4221S3173776","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:42.000000Z","updated_at":"2025-03-17T23:58:42.000000Z"}]},{"id":7957814,"change_date":"2025-03-06 21:40:00","inspection_id":"83959448","dot_number":"2159128","report_state":"TX","report_number":"V251794181","insp_date":"2025-02-21 00:00:00","insp_start_time":"0936","insp_end_time":"0959","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A501","location_desc":"US59 NB QUEEN CITY SCALE","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AFFINITY CHEMICAL","shipping_paper_number":"24114776","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-02-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9507348","transaction_code":"C","transaction_date":"2025-03-06 00:00:00","upload_date":"2025-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2025-02-25 21:40:00","snet_input_date":"2025-02-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-25 21:40:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2025-03-17T21:03:18.000000Z","updated_at":"2025-03-17T21:03:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12846285,"change_date":"2025-03-06 21:40:00","inspection_id":"83959448","insp_unit_id":"205666489","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5032","insp_unit_license":"R474141","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDR5MSMJ7980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:55.000000Z","updated_at":"2025-03-17T23:56:55.000000Z"},{"id":12846286,"change_date":"2025-03-06 21:40:00","inspection_id":"83959448","insp_unit_id":"205666490","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"421980","insp_unit_license":"DJ4417","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H6KF4221S3173776","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:55.000000Z","updated_at":"2025-03-17T23:56:55.000000Z"}]},{"id":7394100,"change_date":"2024-12-13 21:41:00","inspection_id":"83367534","dot_number":"2159128","report_state":"TX","report_number":"V241665487","insp_date":"2024-12-05 00:00:00","insp_start_time":"1015","insp_end_time":"1041","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A501","location_desc":"US59 NB QUEEN CITY SCALE","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AFFINITY CHEMICAL","shipping_paper_number":"24112401","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9447158","transaction_code":"C","transaction_date":"2024-12-13 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2024-12-11 21:41:00","snet_input_date":"2024-12-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-11 21:41:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2025-03-17T20:50:20.000000Z","updated_at":"2025-03-17T20:50:20.000000Z","inspection_violations":[{"id":11552946,"change_date":"2024-12-13 21:41:00","inspection_id":"83367534","insp_violation_id":"263457582","seq_no":"1","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"204378137","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":11927969,"change_date":"2024-12-13 21:41:00","inspection_id":"83367534","insp_unit_id":"204378137","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421980","insp_unit_license":"R474141","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDR5MSMJ7980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:41.000000Z","updated_at":"2025-03-17T23:46:41.000000Z"},{"id":11927970,"change_date":"2024-12-13 21:41:00","inspection_id":"83367534","insp_unit_id":"204378138","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"L5032","insp_unit_license":"DJ4417","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H6KF4221S3173776","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:41.000000Z","updated_at":"2025-03-17T23:46:41.000000Z"}]},{"id":6839534,"change_date":"2024-09-27 21:40:00","inspection_id":"82780304","dot_number":"2159128","report_state":"TX","report_number":"V241532543","insp_date":"2024-09-24 00:00:00","insp_start_time":"1005","insp_end_time":"1024","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A501","location_desc":"US59 NB QUEEN CITY SCALE","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CITY OF LONGVIEW","shipping_paper_number":"24110316","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9388795","transaction_code":"A","transaction_date":"2024-09-27 00:00:00","upload_date":"2024-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2024-09-27 21:40:00","snet_input_date":"2024-09-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-27 21:40:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2025-03-17T20:38:39.000000Z","updated_at":"2025-03-17T20:38:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11029833,"change_date":"2024-09-27 21:40:00","inspection_id":"82780304","insp_unit_id":"203169848","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421980","insp_unit_license":"R474141","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDR5MSMJ7980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:12.000000Z","updated_at":"2025-03-17T23:37:12.000000Z"},{"id":11029834,"change_date":"2024-09-27 21:40:00","inspection_id":"82780304","insp_unit_id":"203169849","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"L5032","insp_unit_license":"DJ4417","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H6KF4221S3173776","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:12.000000Z","updated_at":"2025-03-17T23:37:12.000000Z"}]},{"id":6549978,"change_date":"2024-08-23 21:41:00","inspection_id":"82471845","dot_number":"2159128","report_state":"TX","report_number":"V241483440","insp_date":"2024-08-21 00:00:00","insp_start_time":"1040","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A501","location_desc":"US59 NB QUEEN CITY SCALE","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AFFINITY CHEMICAL","shipping_paper_number":"24109293","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9359031","transaction_code":"A","transaction_date":"2024-08-23 00:00:00","upload_date":"2024-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2024-08-23 21:41:00","snet_input_date":"2024-08-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-23 21:41:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2025-03-17T20:32:47.000000Z","updated_at":"2025-03-17T20:32:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10559146,"change_date":"2024-08-23 21:41:00","inspection_id":"82471845","insp_unit_id":"202559303","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421980","insp_unit_license":"R474141","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDR5MSMJ7980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:22.000000Z","updated_at":"2025-03-17T23:32:22.000000Z"},{"id":10559147,"change_date":"2024-08-23 21:41:00","inspection_id":"82471845","insp_unit_id":"202559304","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"L5032","insp_unit_license":"DJ4417","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H6KF4221S3173776","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:22.000000Z","updated_at":"2025-03-17T23:32:22.000000Z"}]},{"id":5898962,"change_date":"2024-06-03 21:43:00","inspection_id":"81772756","dot_number":"2159128","report_state":"TX","report_number":"V241434142","insp_date":"2024-05-27 00:00:00","insp_start_time":"1050","insp_end_time":"1107","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A501","location_desc":"US59 NB QUEEN CITY SCALE","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CITY OF LONGVIEW","shipping_paper_number":"24106693","cargo_tank":"307","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-06-03 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9290482","transaction_code":"A","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2024-06-03 21:43:00","snet_input_date":"2024-05-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-03 21:43:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2025-03-17T20:19:31.000000Z","updated_at":"2025-03-17T20:19:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9501316,"change_date":"2024-06-03 21:43:00","inspection_id":"81772756","insp_unit_id":"201205216","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421980","insp_unit_license":"R474141","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDR5MSMJ7980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:35.000000Z","updated_at":"2025-03-17T23:21:35.000000Z"},{"id":9501317,"change_date":"2024-06-03 21:43:00","inspection_id":"81772756","insp_unit_id":"201205217","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"106","insp_unit_license":"119C938","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HLF1D7BXM9C40539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:35.000000Z","updated_at":"2025-03-17T23:21:35.000000Z"}]},{"id":5644813,"change_date":"2024-05-01 21:43:00","inspection_id":"81496769","dot_number":"2159128","report_state":"OK","report_number":"V700172002","insp_date":"2024-05-01 00:00:00","insp_start_time":"0856","insp_end_time":"0951","registration_date":null,"region":"CT","ci_status_code":"C","location":"45070","location_desc":"US 70 2M E VALLIANT","county_code_state":"OK","county_code":"089","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"24106073","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"3","hazmat_oos_total":"0","snet_sequence_id":"745547","transaction_code":"A","transaction_date":"2024-05-01 00:00:00","upload_date":"2024-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2024-05-01 21:43:00","snet_input_date":"2024-05-01 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-05-01 21:43:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:41.000000Z","updated_at":"2025-03-17T20:14:41.000000Z","inspection_violations":[{"id":8729225,"change_date":"2024-05-01 21:43:00","inspection_id":"81496769","insp_violation_id":"259253248","seq_no":"1","part_no":"172","part_no_section":"516(c)(6)","insp_viol_unit":"2","insp_unit_id":"200674854","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"172516C6"},{"id":8729226,"change_date":"2024-05-01 21:43:00","inspection_id":"81496769","insp_violation_id":"259253249","seq_no":"2","part_no":"177","part_no_section":"823(a)","insp_viol_unit":"2","insp_unit_id":"200674854","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"177823A"},{"id":8729227,"change_date":"2024-05-01 21:43:00","inspection_id":"81496769","insp_violation_id":"259253250","seq_no":"3","part_no":"177","part_no_section":"823(a)","insp_viol_unit":"2","insp_unit_id":"200674854","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"177823A"},{"id":8729228,"change_date":"2024-05-01 21:43:00","inspection_id":"81496769","insp_violation_id":"259253251","seq_no":"4","part_no":"390","part_no_section":"21T(c)","insp_viol_unit":"1","insp_unit_id":"200674853","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"39021TC"},{"id":8729229,"change_date":"2024-05-01 21:43:00","inspection_id":"81496769","insp_violation_id":"259253252","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200674854","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"3922"},{"id":8729230,"change_date":"2024-05-01 21:43:00","inspection_id":"81496769","insp_violation_id":"259253253","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200674853","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9092322,"change_date":"2024-05-01 21:43:00","inspection_id":"81496769","insp_unit_id":"200674853","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421979","insp_unit_license":"R474140","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDR9MSMJ7979","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:36.000000Z","updated_at":"2025-03-17T23:17:36.000000Z"},{"id":9092323,"change_date":"2024-05-01 21:43:00","inspection_id":"81496769","insp_unit_id":"200674854","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"L5028","insp_unit_license":"DH6177","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3E1AAB235SS517054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:36.000000Z","updated_at":"2025-03-17T23:17:36.000000Z"}]},{"id":3977176,"change_date":"2023-09-14 21:41:00","inspection_id":"79667529","dot_number":"2159128","report_state":"TX","report_number":"V231098194","insp_date":"2023-09-01 00:00:00","insp_start_time":"1105","insp_end_time":"1126","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A501","location_desc":"US 59 QUEEN CITY","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AFFINITY CHEMICAL","shipping_paper_number":"NONE","cargo_tank":"307","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-09-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9075008","transaction_code":"A","transaction_date":"2023-09-14 00:00:00","upload_date":"2023-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2023-09-14 21:41:00","snet_input_date":"2023-09-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-14 21:41:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2025-03-17T19:41:15.000000Z","updated_at":"2025-03-17T19:41:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6395406,"change_date":"2023-09-14 21:41:00","inspection_id":"79667529","insp_unit_id":"197064517","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421980","insp_unit_license":"R474141","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDR5MSMJ7980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:43.000000Z","updated_at":"2025-03-17T22:53:43.000000Z"},{"id":6395407,"change_date":"2023-09-14 21:41:00","inspection_id":"79667529","insp_unit_id":"197064518","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"106","insp_unit_license":"119C938","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HLF1D7BXM9C40539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:43.000000Z","updated_at":"2025-03-17T22:53:43.000000Z"}]},{"id":3402533,"change_date":"2023-06-29 21:42:00","inspection_id":"79024589","dot_number":"2159128","report_state":"OK","report_number":"V700171579","insp_date":"2023-06-29 00:00:00","insp_start_time":"0810","insp_end_time":"0901","registration_date":null,"region":"CT","ci_status_code":"C","location":"45098","location_desc":"SH 98 \/ FARMERS HILL RD","county_code_state":"OK","county_code":"089","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":"307","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"715057","transaction_code":"A","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2023-06-29 21:42:00","snet_input_date":"2023-06-29 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-06-29 21:42:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:32.000000Z","updated_at":"2025-03-17T19:30:32.000000Z","inspection_violations":[{"id":5246259,"change_date":"2023-06-29 21:42:00","inspection_id":"79024589","insp_violation_id":"253791888","seq_no":"1","part_no":"390","part_no_section":"21T(c)","insp_viol_unit":"1","insp_unit_id":"195758364","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:22.000000Z","updated_at":"2025-03-17T21:31:22.000000Z","normalized_code":"39021TC"},{"id":5246260,"change_date":"2023-06-29 21:42:00","inspection_id":"79024589","insp_violation_id":"253791889","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195758365","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:22.000000Z","updated_at":"2025-03-17T21:31:22.000000Z","normalized_code":"3939A"},{"id":5246261,"change_date":"2023-06-29 21:42:00","inspection_id":"79024589","insp_violation_id":"253791890","seq_no":"3","part_no":"173","part_no_section":"24(b)","insp_viol_unit":"2","insp_unit_id":"195758365","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:22.000000Z","updated_at":"2025-03-17T21:31:22.000000Z","normalized_code":"17324B"}],"inspection_per_units":[{"id":5470454,"change_date":"2023-06-29 21:42:00","inspection_id":"79024589","insp_unit_id":"195758364","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421980","insp_unit_license":"R474141","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDR5MSMJ7980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:10.000000Z","updated_at":"2025-03-17T22:46:10.000000Z"},{"id":5470455,"change_date":"2023-06-29 21:42:00","inspection_id":"79024589","insp_unit_id":"195758365","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"106","insp_unit_license":"119C938","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HLFD781M9C40543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:10.000000Z","updated_at":"2025-03-17T22:46:10.000000Z"}]},{"id":2391320,"change_date":"2023-02-17 21:40:00","inspection_id":"77879185","dot_number":"2159128","report_state":"TX","report_number":"6IKD0XHXS8","insp_date":"2023-02-13 00:00:00","insp_start_time":"1345","insp_end_time":"1415","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A501","location_desc":"US 59 QUEEN CITY","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AFFINITY CHEMICAL","shipping_paper_number":"2492582","cargo_tank":"307","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8906668","transaction_code":"C","transaction_date":"2023-02-17 00:00:00","upload_date":"2023-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2023-02-16 21:42:00","snet_input_date":"2023-02-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-16 21:42:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2025-03-17T19:10:44.000000Z","updated_at":"2025-03-17T19:10:44.000000Z","inspection_violations":[{"id":3682401,"change_date":"2023-02-17 21:40:00","inspection_id":"77879185","insp_violation_id":"251214381","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193467965","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:23.000000Z","updated_at":"2025-03-17T21:24:23.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3848151,"change_date":"2023-02-17 21:40:00","inspection_id":"77879185","insp_unit_id":"193467964","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421979","insp_unit_license":"R474140","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDR9MSMJ7979","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:33.000000Z","updated_at":"2025-03-17T22:33:33.000000Z"},{"id":3848152,"change_date":"2023-02-17 21:40:00","inspection_id":"77879185","insp_unit_id":"193467965","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"106","insp_unit_license":"119C938","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HLFD781M9C40543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:33.000000Z","updated_at":"2025-03-17T22:33:33.000000Z"}]},{"id":1221871,"change_date":"2022-09-06 21:43:00","inspection_id":"76535968","dot_number":"2159128","report_state":"TX","report_number":"6DWC0XHWVI","insp_date":"2022-08-29 00:00:00","insp_start_time":"1215","insp_end_time":"1235","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A501","location_desc":"US 59 QUEEN CITY","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CITY","shipping_paper_number":null,"cargo_tank":"307","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8762861","transaction_code":"A","transaction_date":"2022-09-06 00:00:00","upload_date":"2022-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2022-09-06 21:43:00","snet_input_date":"2022-08-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-06 21:43:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2025-03-17T18:49:18.000000Z","updated_at":"2025-03-17T18:49:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1966243,"change_date":"2022-09-06 21:43:00","inspection_id":"76535968","insp_unit_id":"190746920","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"521979","insp_unit_license":"R474140","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDR9MSMJ7979","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:31.000000Z","updated_at":"2025-03-17T22:20:31.000000Z"},{"id":1966244,"change_date":"2022-09-06 21:43:00","inspection_id":"76535968","insp_unit_id":"190746921","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"110","insp_unit_license":"119C939","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HLF1D7B1M9C40543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:31.000000Z","updated_at":"2025-03-17T22:20:31.000000Z"}]},{"id":953996,"change_date":"2022-08-05 21:40:00","inspection_id":"76223870","dot_number":"2159128","report_state":"LA","report_number":"LANL004732","insp_date":"2022-08-02 00:00:00","insp_start_time":"0833","insp_end_time":"0853","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"061","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1139161","transaction_code":"C","transaction_date":"2022-08-05 00:00:00","upload_date":"2022-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2022-08-03 21:42:00","snet_input_date":"2022-08-03 00:00:00","source_office":"2LAS001","mcmis_add_date":"2022-08-03 21:42:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:25.000000Z","updated_at":"2025-03-17T18:44:25.000000Z","inspection_violations":[{"id":1504702,"change_date":"2022-08-05 21:40:00","inspection_id":"76223870","insp_violation_id":"247538336","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:08.000000Z","updated_at":"2025-03-17T21:14:08.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1534890,"change_date":"2022-08-05 21:40:00","inspection_id":"76223870","insp_unit_id":"190152564","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"L1606","insp_unit_license":"K799930","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"3HCDJAPR1HL754180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:39.000000Z","updated_at":"2025-03-17T22:17:39.000000Z"},{"id":1534891,"change_date":"2022-08-05 21:40:00","inspection_id":"76223870","insp_unit_id":"190152565","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"8024","insp_unit_license":"W29512","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HLJ1B7B5L9C40302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:39.000000Z","updated_at":"2025-03-17T22:17:39.000000Z"}]},{"id":774028,"change_date":"2022-07-07 21:42:00","inspection_id":"76013255","dot_number":"2159128","report_state":"TX","report_number":"6C8B0XHWRR","insp_date":"2022-06-30 00:00:00","insp_start_time":"1105","insp_end_time":"1125","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A501","location_desc":"US 59 QUEEN CITY","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SURFACE WATER TREATMENT","shipping_paper_number":null,"cargo_tank":"307","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8706929","transaction_code":"A","transaction_date":"2022-07-07 00:00:00","upload_date":"2022-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2022-07-07 21:42:00","snet_input_date":"2022-06-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-07 21:42:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0833615","created_at":"2025-03-17T18:41:15.000000Z","updated_at":"2025-03-17T18:41:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1245342,"change_date":"2022-07-07 21:42:00","inspection_id":"76013255","insp_unit_id":"189661804","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421980","insp_unit_license":"R474141","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDR5MSMJ7980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:51.000000Z","updated_at":"2025-03-17T22:15:51.000000Z"},{"id":1245343,"change_date":"2022-07-07 21:42:00","inspection_id":"76013255","insp_unit_id":"189661805","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"106","insp_unit_license":"119C938","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HLF1D7BXM9C40539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:51.000000Z","updated_at":"2025-03-17T22:15:51.000000Z"}]},{"id":644906,"change_date":"2022-06-18 21:31:00","inspection_id":"75861485","dot_number":"2159128","report_state":"AR","report_number":"D723001649","insp_date":"2022-06-16 00:00:00","insp_start_time":"0701","insp_end_time":"0735","registration_date":null,"region":"CT","ci_status_code":"C","location":"14","location_desc":"HWY 82E NEAR TRAILER PARK","county_code_state":"AR","county_code":"027","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"AFFINITY CHEMICAL LLC","shipping_paper_number":"2485142","cargo_tank":"407","hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-06-18 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1410313","transaction_code":"A","transaction_date":"2022-06-17 00:00:00","upload_date":"2022-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02159128","upload_search_indicator":"M","census_search_date":"2022-06-18 21:31:00","snet_input_date":"2022-06-17 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-06-18 21:31:00","insp_carrier_name":"AFFINITY CHEMICAL WOODBINE LLC","insp_carrier_street":"9978 FM 3129","insp_carrier_city":"QUEEN CITY","insp_carrier_state":"TX","insp_carrier_zip_code":"75572","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:09.000000Z","updated_at":"2025-03-17T18:39:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1036611,"change_date":"2022-06-18 21:31:00","inspection_id":"75861485","insp_unit_id":"189341708","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421986","insp_unit_license":"R474141","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDR5MSMJ7980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:34.000000Z","updated_at":"2025-03-17T22:14:34.000000Z"},{"id":1036612,"change_date":"2022-06-18 21:31:00","inspection_id":"75861485","insp_unit_id":"189341709","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"106","insp_unit_license":"119C938","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HLF1D7BXM9C40539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:34.000000Z","updated_at":"2025-03-17T22:14:34.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2159128\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2159128\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2159128\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/2159128\/inspections","per_page":100,"prev_page_url":null,"to":29,"total":29}