{"current_page":1,"data":[{"id":12262214,"change_date":"2026-06-23 21:39:00","inspection_id":"88221108","dot_number":"1890260","report_state":"TX","report_number":"V262433222","insp_date":"2026-06-21 00:00:00","insp_start_time":"1518","insp_end_time":"1540","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 10 @ 723","county_code_state":"TX","county_code":"015","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INSPECTION OILFIELD SERIVES","shipping_paper_number":"421681","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10004089","transaction_code":"A","transaction_date":"2026-06-23 00:00:00","upload_date":"2026-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2026-06-23 21:39:00","snet_input_date":"2026-06-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-23 21:39:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"7702 FITZHUGH STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0764888","created_at":"2026-06-26T09:41:01.000000Z","updated_at":"2026-07-04T09:31:17.000000Z","inspection_violations":[{"id":21344698,"change_date":"2026-06-23 21:39:00","inspection_id":"88221108","insp_violation_id":"275086516","seq_no":"1","part_no":"393","part_no_section":"104F3","insp_viol_unit":"2","insp_unit_id":"214248472","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-26T10:01:48.000000Z","updated_at":"2026-07-04T09:44:19.000000Z","normalized_code":"393104F3"},{"id":21344699,"change_date":"2026-06-23 21:39:00","inspection_id":"88221108","insp_violation_id":"275086517","seq_no":"2","part_no":"393","part_no_section":"110","insp_viol_unit":"2","insp_unit_id":"214248472","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-26T10:01:48.000000Z","updated_at":"2026-07-04T09:44:19.000000Z","normalized_code":"393110"}],"inspection_per_units":[{"id":21293546,"change_date":"2026-06-23 21:39:00","inspection_id":"88221108","insp_unit_id":"214248471","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"109","insp_unit_license":"48U804N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR99LAB3259","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:33.000000Z","updated_at":"2026-07-05T09:05:04.000000Z"},{"id":21293547,"change_date":"2026-06-23 21:39:00","inspection_id":"88221108","insp_unit_id":"214248472","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"00","insp_unit_license":"98R807N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRDM9627JH101810","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:33.000000Z","updated_at":"2026-07-05T09:05:04.000000Z"}]},{"id":12236528,"change_date":"2026-06-19 21:38:00","inspection_id":"88194268","dot_number":"1890260","report_state":"TX","report_number":"V262369660","insp_date":"2026-06-17 00:00:00","insp_start_time":"1219","insp_end_time":"1240","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"332M IH20 EB","county_code_state":"TX","county_code":"133","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"A & H TRANSPORTATION","shipping_paper_number":"NONE","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-19 21:38: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":"10000600","transaction_code":"A","transaction_date":"2026-06-19 00:00:00","upload_date":"2026-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2026-06-19 21:38:00","snet_input_date":"2026-06-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-19 21:38:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"7702 FITZHUGH STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0764888","created_at":"2026-06-22T09:41:32.000000Z","updated_at":"2026-06-30T09:31:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21250356,"change_date":"2026-06-19 21:38:00","inspection_id":"88194268","insp_unit_id":"214197646","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"357","insp_unit_license":"1M77468","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR7CSBP0578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-22T09:18:50.000000Z","updated_at":"2026-06-30T09:02:24.000000Z"},{"id":21250357,"change_date":"2026-06-19 21:38:00","inspection_id":"88194268","insp_unit_id":"214197647","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"NH335148","insp_unit_license":"206B979","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GR4M9624NH335148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-22T09:18:50.000000Z","updated_at":"2026-06-30T09:02:24.000000Z"}]},{"id":12054114,"change_date":"2026-05-29 21:40:00","inspection_id":"87995443","dot_number":"1890260","report_state":"TX","report_number":"V262368780","insp_date":"2026-05-27 00:00:00","insp_start_time":"0644","insp_end_time":"0725","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A102","location_desc":"IH10 WB KINGSBURY SCALE","county_code_state":"TX","county_code":"187","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NIELCO STEEL WAREHOUSE, INC","shipping_paper_number":"119469","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"9973550","transaction_code":"A","transaction_date":"2026-05-29 00:00:00","upload_date":"2026-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2026-05-29 21:40:00","snet_input_date":"2026-05-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-29 21:40:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"7702 FITZHUGH STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0764888","created_at":"2026-06-02T09:40:02.000000Z","updated_at":"2026-06-09T09:31:29.000000Z","inspection_violations":[{"id":20974249,"change_date":"2026-05-29 21:40:00","inspection_id":"87995443","insp_violation_id":"274587907","seq_no":"2","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"213825503","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-02T09:58:31.000000Z","updated_at":"2026-06-09T09:43:14.000000Z","normalized_code":"39355E"},{"id":20974248,"change_date":"2026-05-29 21:40:00","inspection_id":"87995443","insp_violation_id":"274587906","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"213825502","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-02T09:58:31.000000Z","updated_at":"2026-06-09T09:43:14.000000Z","normalized_code":"39345B2UV"}],"inspection_per_units":[{"id":20949975,"change_date":"2026-05-29 21:40:00","inspection_id":"87995443","insp_unit_id":"213825502","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"35","insp_unit_license":"1M18927","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK09DAE7219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-02T09:17:04.000000Z","updated_at":"2026-06-09T09:03:18.000000Z"},{"id":20949976,"change_date":"2026-05-29 21:40:00","inspection_id":"87995443","insp_unit_id":"213825503","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"108","insp_unit_license":"206B980","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GR4M9622NH335147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-02T09:17:04.000000Z","updated_at":"2026-06-09T09:03:18.000000Z"}]},{"id":11851724,"change_date":"2026-05-07 21:40:00","inspection_id":"87787876","dot_number":"1890260","report_state":"TX","report_number":"7EAD9DCJCH","insp_date":"2026-03-31 00:00:00","insp_start_time":"1258","insp_end_time":"1324","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"400 E LOOP N","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122350","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":"0","hazmat_oos_total":"0","snet_sequence_id":"9946080","transaction_code":"A","transaction_date":"2026-05-07 00:00:00","upload_date":"2026-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2026-05-07 21:40:00","snet_input_date":"2026-03-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-07 21:40:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"7702 FITZHUGH STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0764888","created_at":"2026-05-10T09:39:37.000000Z","updated_at":"2026-05-18T09:31:12.000000Z","inspection_violations":[{"id":20611806,"change_date":"2026-05-07 21:40:00","inspection_id":"87787876","insp_violation_id":"274115376","seq_no":"2","part_no":"393","part_no_section":"201D","insp_viol_unit":"1","insp_unit_id":"213436552","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:59:02.000000Z","updated_at":"2026-05-18T09:42:53.000000Z","normalized_code":"393201D"},{"id":20611805,"change_date":"2026-05-07 21:40:00","inspection_id":"87787876","insp_violation_id":"274115375","seq_no":"1","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"213436552","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:59:02.000000Z","updated_at":"2026-05-18T09:42:53.000000Z","normalized_code":"3939H"},{"id":20611807,"change_date":"2026-05-07 21:40:00","inspection_id":"87787876","insp_violation_id":"274115377","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"213436553","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:59:02.000000Z","updated_at":"2026-05-18T09:42:53.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":20609878,"change_date":"2026-05-07 21:40:00","inspection_id":"87787876","insp_unit_id":"213436552","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"015","insp_unit_license":"69P678N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDJSJR3CN365315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:57.000000Z","updated_at":"2026-05-18T09:03:51.000000Z"},{"id":20609879,"change_date":"2026-05-07 21:40:00","inspection_id":"87787876","insp_unit_id":"213436553","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"108","insp_unit_license":"206B980","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GR4M9622NH335147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:57.000000Z","updated_at":"2026-05-18T09:03:51.000000Z"}]},{"id":11335286,"change_date":"2026-03-10 21:39:00","inspection_id":"87252622","dot_number":"1890260","report_state":"TX","report_number":"7DJ99DCREZ","insp_date":"2026-03-04 00:00:00","insp_start_time":"0837","insp_end_time":"0918","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0610 IN HARRIS CO. (0-37)","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9876877","transaction_code":"A","transaction_date":"2026-03-09 00:00:00","upload_date":"2026-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2026-03-10 21:39:00","snet_input_date":"2026-03-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-10 21:39:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"7702 FITZHUGH STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0764888","created_at":"2026-03-13T09:43:55.000000Z","updated_at":"2026-03-21T09:31:34.000000Z","inspection_violations":[{"id":19084550,"change_date":"2026-03-10 21:39:00","inspection_id":"87252622","insp_violation_id":"272313363","seq_no":"1","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"212065797","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:05:08.000000Z","updated_at":"2026-03-21T09:49:35.000000Z","normalized_code":"3939H"},{"id":19084551,"change_date":"2026-03-10 21:39:00","inspection_id":"87252622","insp_violation_id":"272313364","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"212065797","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-03-13T10:05:08.000000Z","updated_at":"2026-03-21T09:49:35.000000Z","normalized_code":"39375A3TAOL"},{"id":19084552,"change_date":"2026-03-10 21:39:00","inspection_id":"87252622","insp_violation_id":"272313365","seq_no":"3","part_no":"393","part_no_section":"201D","insp_viol_unit":"1","insp_unit_id":"212065797","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:05:08.000000Z","updated_at":"2026-03-21T09:49:35.000000Z","normalized_code":"393201D"},{"id":19084553,"change_date":"2026-03-10 21:39:00","inspection_id":"87252622","insp_violation_id":"272313366","seq_no":"4","part_no":"393","part_no_section":"47A","insp_viol_unit":"2","insp_unit_id":"212065798","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:05:08.000000Z","updated_at":"2026-03-21T09:49:35.000000Z","normalized_code":"39347A"},{"id":19084554,"change_date":"2026-03-10 21:39:00","inspection_id":"87252622","insp_violation_id":"272313367","seq_no":"5","part_no":"393","part_no_section":"47A","insp_viol_unit":"2","insp_unit_id":"212065798","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:05:08.000000Z","updated_at":"2026-03-21T09:49:35.000000Z","normalized_code":"39347A"}],"inspection_per_units":[{"id":19397513,"change_date":"2026-03-10 21:39:00","inspection_id":"87252622","insp_unit_id":"212065797","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"79M608N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDJSJR3CN365315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:26.000000Z","updated_at":"2026-03-21T09:11:39.000000Z"},{"id":19397514,"change_date":"2026-03-10 21:39:00","inspection_id":"87252622","insp_unit_id":"212065798","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"81M608N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TR14830372011167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:26.000000Z","updated_at":"2026-03-21T09:11:39.000000Z"}]},{"id":11152003,"change_date":"2026-02-18 21:38:00","inspection_id":"87066671","dot_number":"1890260","report_state":"TX","report_number":"V262201868","insp_date":"2026-02-10 00:00:00","insp_start_time":"0829","insp_end_time":"0858","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH137 MP 434","county_code_state":"TX","county_code":"105","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"A & H TRANSPORTATION","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-02-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9852261","transaction_code":"C","transaction_date":"2026-02-18 00:00:00","upload_date":"2026-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2026-02-17 21:39:00","snet_input_date":"2026-02-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-17 21:39:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"7702 FITZHUGH STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0764888","created_at":"2026-02-20T10:37:51.000000Z","updated_at":"2026-03-01T10:30:16.000000Z","inspection_violations":[{"id":18703960,"change_date":"2026-02-18 21:38:00","inspection_id":"87066671","insp_violation_id":"271877723","seq_no":"1","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"211692769","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-21T10:53:31.000000Z","updated_at":"2026-03-01T10:39:44.000000Z","normalized_code":"39375C"},{"id":18703961,"change_date":"2026-02-18 21:38:00","inspection_id":"87066671","insp_violation_id":"271877724","seq_no":"2","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"211692769","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:31.000000Z","updated_at":"2026-03-01T10:39:44.000000Z","normalized_code":"39375C"},{"id":18703962,"change_date":"2026-02-18 21:38:00","inspection_id":"87066671","insp_violation_id":"271877725","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"211692768","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:31.000000Z","updated_at":"2026-03-01T10:39:44.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":19036968,"change_date":"2026-02-18 21:38:00","inspection_id":"87066671","insp_unit_id":"211692768","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"67T600N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X0EJ319968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:13:57.000000Z","updated_at":"2026-03-01T10:02:51.000000Z"},{"id":19036969,"change_date":"2026-02-18 21:38:00","inspection_id":"87066671","insp_unit_id":"211692769","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"84W213W","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRDM9627JH101810","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:13:57.000000Z","updated_at":"2026-03-01T10:02:51.000000Z"}]},{"id":11096400,"change_date":"2026-02-10 21:39:00","inspection_id":"87008287","dot_number":"1890260","report_state":"TX","report_number":"V262215054","insp_date":"2026-02-09 00:00:00","insp_start_time":"1250","insp_end_time":"1333","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A301","location_desc":"IH45 SB CENTERVILLE SCALE","county_code_state":"TX","county_code":"289","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"A & H TRANSPORTATION","shipping_paper_number":"N\/A","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-02-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"131200","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9845580","transaction_code":"A","transaction_date":"2026-02-10 00:00:00","upload_date":"2026-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2026-02-10 21:39:00","snet_input_date":"2026-02-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-10 21:39:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"7702 FITZHUGH STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0764888","created_at":"2026-02-13T10:37:55.000000Z","updated_at":"2026-02-21T10:30:54.000000Z","inspection_violations":[{"id":18579507,"change_date":"2026-02-10 21:39:00","inspection_id":"87008287","insp_violation_id":"271712717","seq_no":"1","part_no":"392","part_no_section":"60A","insp_viol_unit":"1","insp_unit_id":"211546685","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:52:25.000000Z","updated_at":"2026-02-21T10:39:49.000000Z","normalized_code":"39260A"},{"id":18579508,"change_date":"2026-02-10 21:39:00","inspection_id":"87008287","insp_violation_id":"271712718","seq_no":"2","part_no":"395","part_no_section":"8A-ELD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:52:25.000000Z","updated_at":"2026-02-21T10:39:49.000000Z","normalized_code":"3958AELD"},{"id":18579509,"change_date":"2026-02-10 21:39:00","inspection_id":"87008287","insp_violation_id":"271712719","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211546685","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:52:25.000000Z","updated_at":"2026-02-21T10:39:49.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":18923188,"change_date":"2026-02-10 21:39:00","inspection_id":"87008287","insp_unit_id":"211546685","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"110","insp_unit_license":"69W209W","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X0EJ319968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-13T10:15:40.000000Z","updated_at":"2026-02-21T10:03:49.000000Z"},{"id":18923189,"change_date":"2026-02-10 21:39:00","inspection_id":"87008287","insp_unit_id":"211546686","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"T110","insp_unit_license":"81T582N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N148209G1514580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-13T10:15:40.000000Z","updated_at":"2026-02-21T10:03:49.000000Z"}]},{"id":10450564,"change_date":"2025-12-16 21:38:00","inspection_id":"86583085","dot_number":"1890260","report_state":"TX","report_number":"V252135472","insp_date":"2025-12-09 00:00:00","insp_start_time":"1501","insp_end_time":"1521","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"408 E GRAND AVE","county_code_state":"TX","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MSD BUILDING CORP","shipping_paper_number":"SIT162459145","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-12-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"122513","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":"9787720","transaction_code":"A","transaction_date":"2025-12-16 00:00:00","upload_date":"2025-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2025-12-16 21:38:00","snet_input_date":"2025-12-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-16 21:38:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"7702 FITZHUGH STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0764888","created_at":"2025-12-19T10:31:55.000000Z","updated_at":"2025-12-27T10:31:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17487624,"change_date":"2025-12-16 21:38:00","inspection_id":"86583085","insp_unit_id":"210642836","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"102","insp_unit_license":"1L38229","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X13J708703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-19T10:02:21.000000Z","updated_at":"2025-12-27T10:01:08.000000Z"},{"id":17487625,"change_date":"2025-12-16 21:38:00","inspection_id":"86583085","insp_unit_id":"210642837","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"102","insp_unit_license":"073C600","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N148205F1567727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-19T10:02:21.000000Z","updated_at":"2025-12-27T10:01:08.000000Z"}]},{"id":10390121,"change_date":"2025-12-09 21:39:00","inspection_id":"86519871","dot_number":"1890260","report_state":"TX","report_number":"7B0F9DCG5X","insp_date":"2025-12-03 00:00:00","insp_start_time":"1520","insp_end_time":"1606","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7900  ROMEA","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SUNBELT GROUP","shipping_paper_number":"415299","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-12-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"131860","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9779707","transaction_code":"A","transaction_date":"2025-12-09 00:00:00","upload_date":"2025-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2025-12-09 21:39:00","snet_input_date":"2025-12-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-09 21:39:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"7702 FITZHUGH STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0764888","created_at":"2025-12-12T10:31:41.000000Z","updated_at":"2025-12-13T10:30:59.000000Z","inspection_violations":[{"id":17403121,"change_date":"2025-12-09 21:39:00","inspection_id":"86519871","insp_violation_id":"270567210","seq_no":"1","part_no":"393","part_no_section":"205A","insp_viol_unit":"1","insp_unit_id":"210508299","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-12T10:32:45.000000Z","updated_at":"2025-12-13T10:31:31.000000Z","normalized_code":"393205A"},{"id":17403122,"change_date":"2025-12-09 21:39:00","inspection_id":"86519871","insp_violation_id":"270567211","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"210508300","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-12T10:32:45.000000Z","updated_at":"2025-12-13T10:31:31.000000Z","normalized_code":"3939"},{"id":17403123,"change_date":"2025-12-09 21:39:00","inspection_id":"86519871","insp_violation_id":"270567212","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"210508300","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-12T10:32:45.000000Z","updated_at":"2025-12-13T10:31:31.000000Z","normalized_code":"3939"},{"id":17403124,"change_date":"2025-12-09 21:39:00","inspection_id":"86519871","insp_violation_id":"270567213","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"210508300","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-12T10:32:45.000000Z","updated_at":"2025-12-13T10:31:31.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":17370306,"change_date":"2025-12-09 21:39:00","inspection_id":"86519871","insp_unit_id":"210508299","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"101","insp_unit_license":"1M37579","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK67LW52379","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-12T10:01:31.000000Z","updated_at":"2025-12-13T10:01:16.000000Z"},{"id":17370307,"change_date":"2025-12-09 21:39:00","inspection_id":"86519871","insp_unit_id":"210508300","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"121C562","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2486YA197005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-12T10:01:31.000000Z","updated_at":"2025-12-13T10:01:16.000000Z"}]},{"id":10220759,"change_date":"2025-11-17 21:40:00","inspection_id":"86342530","dot_number":"1890260","report_state":"TX","report_number":"V252102525","insp_date":"2025-11-12 00:00:00","insp_start_time":"0803","insp_end_time":"0828","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH45 NB NEW WAVERLY SCALE","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"EDGEN","shipping_paper_number":"919479","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":"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":"131200","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9761088","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":"01890260","upload_search_indicator":"M","census_search_date":"2025-11-17 21:40:00","snet_input_date":"2025-11-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-17 21:40:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"7702 FITZHUGH STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0764888","created_at":"2025-11-20T10:30:39.000000Z","updated_at":"2025-11-21T10:31:09.000000Z","inspection_violations":[{"id":16988308,"change_date":"2025-11-17 21:40:00","inspection_id":"86342530","insp_violation_id":"270014358","seq_no":"1","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"2","insp_unit_id":"210077590","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-20T10:31:09.000000Z","updated_at":"2025-11-21T10:32:04.000000Z","normalized_code":"3929A2C"},{"id":16988309,"change_date":"2025-11-17 21:40:00","inspection_id":"86342530","insp_violation_id":"270014359","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"210077590","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-20T10:31:09.000000Z","updated_at":"2025-11-21T10:32:04.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":17028106,"change_date":"2025-11-17 21:40:00","inspection_id":"86342530","insp_unit_id":"210077590","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"T110","insp_unit_license":"86U456N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N148209G1514580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:40.000000Z","updated_at":"2025-11-21T10:01:22.000000Z"},{"id":17028105,"change_date":"2025-11-17 21:40:00","inspection_id":"86342530","insp_unit_id":"210077589","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"110","insp_unit_license":"1N66695","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X0EJ319968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:40.000000Z","updated_at":"2025-11-21T10:01:22.000000Z"}]},{"id":9524015,"change_date":"2025-08-27 21:40:00","inspection_id":"85609914","dot_number":"1890260","report_state":"TX","report_number":"V251998586","insp_date":"2025-08-25 00:00:00","insp_start_time":"0645","insp_end_time":"0729","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A102","location_desc":"IH10 WB KINGSBURY SCALE","county_code_state":"TX","county_code":"187","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NIELCO STEEL WAREHOUSE","shipping_paper_number":"113360","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-27 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":"9678308","transaction_code":"A","transaction_date":"2025-08-27 00:00:00","upload_date":"2025-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2025-08-27 21:40:00","snet_input_date":"2025-08-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-27 21:40:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"7702 FITZHUGH STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0764888","created_at":"2025-09-05T10:47:24.000000Z","updated_at":"2025-09-06T10:41:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15718298,"change_date":"2025-08-27 21:40:00","inspection_id":"85609914","insp_unit_id":"208617836","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"357","insp_unit_license":"1M77468","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR7CSBP0578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:41.000000Z","updated_at":"2025-09-09T09:46:09.000000Z"},{"id":15718299,"change_date":"2025-08-27 21:40:00","inspection_id":"85609914","insp_unit_id":"208617837","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"NH335148","insp_unit_license":"206B979","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GR4M9624NH335148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:41.000000Z","updated_at":"2025-09-09T09:46:09.000000Z"}]},{"id":9309230,"change_date":"2025-08-01 21:39:00","inspection_id":"85384066","dot_number":"1890260","report_state":"TX","report_number":"77999DAPTQ","insp_date":"2025-07-21 00:00:00","insp_start_time":"0942","insp_end_time":"1041","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"11","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9653202","transaction_code":"A","transaction_date":"2025-08-01 00:00:00","upload_date":"2025-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2025-08-01 21:39:00","snet_input_date":"2025-07-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-01 21:39:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"7702 FITZHUGH STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0764888","created_at":"2025-08-04T10:01:48.000000Z","updated_at":"2025-08-06T10:43:25.000000Z","inspection_violations":[{"id":15100714,"change_date":"2025-08-01 21:39:00","inspection_id":"85384066","insp_violation_id":"267793772","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"208199832","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-04T10:46:09.000000Z","updated_at":"2025-08-05T10:44:19.000000Z","normalized_code":"3922RG"},{"id":15100715,"change_date":"2025-08-01 21:39:00","inspection_id":"85384066","insp_violation_id":"267793773","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"208199831","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-04T10:46:09.000000Z","updated_at":"2025-08-05T10:44:19.000000Z","normalized_code":"3922RG"},{"id":15100716,"change_date":"2025-08-01 21:39:00","inspection_id":"85384066","insp_violation_id":"267793774","seq_no":"3","part_no":"393","part_no_section":"203E","insp_viol_unit":"1","insp_unit_id":"208199831","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-04T10:46:09.000000Z","updated_at":"2025-08-05T10:44:19.000000Z","normalized_code":"393203E"},{"id":15100717,"change_date":"2025-08-01 21:39:00","inspection_id":"85384066","insp_violation_id":"267793775","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"208199832","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-04T10:46:09.000000Z","updated_at":"2025-08-05T10:44:19.000000Z","normalized_code":"3939"},{"id":15100718,"change_date":"2025-08-01 21:39:00","inspection_id":"85384066","insp_violation_id":"267793776","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"208199832","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-04T10:46:09.000000Z","updated_at":"2025-08-05T10:44:19.000000Z","normalized_code":"3939"},{"id":15100719,"change_date":"2025-08-01 21:39:00","inspection_id":"85384066","insp_violation_id":"267793777","seq_no":"6","part_no":"392","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"208199832","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-08-04T10:46:09.000000Z","updated_at":"2025-08-05T10:44:19.000000Z","normalized_code":"3929"},{"id":15100720,"change_date":"2025-08-01 21:39:00","inspection_id":"85384066","insp_violation_id":"267793778","seq_no":"7","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"208199831","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-04T10:46:09.000000Z","updated_at":"2025-08-05T10:44:19.000000Z","normalized_code":"3965B"},{"id":15100721,"change_date":"2025-08-01 21:39:00","inspection_id":"85384066","insp_violation_id":"267793779","seq_no":"8","part_no":"393","part_no_section":"45DLPC","insp_viol_unit":"2","insp_unit_id":"208199832","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-04T10:46:09.000000Z","updated_at":"2025-08-05T10:44:19.000000Z","normalized_code":"39345DLPC"},{"id":15100722,"change_date":"2025-08-01 21:39:00","inspection_id":"85384066","insp_violation_id":"267793780","seq_no":"9","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"208199831","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-04T10:46:09.000000Z","updated_at":"2025-08-05T10:44:19.000000Z","normalized_code":"3963A1B"},{"id":15100723,"change_date":"2025-08-01 21:39:00","inspection_id":"85384066","insp_violation_id":"267793781","seq_no":"10","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"208199832","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-08-04T10:46:09.000000Z","updated_at":"2025-08-05T10:44:19.000000Z","normalized_code":"39345B2UV"},{"id":15100724,"change_date":"2025-08-01 21:39:00","inspection_id":"85384066","insp_violation_id":"267793782","seq_no":"11","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"208199832","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-04T10:46:09.000000Z","updated_at":"2025-08-05T10:44:19.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":15329874,"change_date":"2025-08-01 21:39:00","inspection_id":"85384066","insp_unit_id":"208199831","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"007","insp_unit_license":"16N253N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGHDV1GSHF4937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-04T09:46:31.000000Z","updated_at":"2025-08-05T09:45:55.000000Z"},{"id":15329875,"change_date":"2025-08-01 21:39:00","inspection_id":"85384066","insp_unit_id":"208199832","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"X43199","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2480XA839510","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-04T09:46:31.000000Z","updated_at":"2025-08-05T09:45:55.000000Z"}]},{"id":8946523,"change_date":"2025-06-20 21:36:00","inspection_id":"85002173","dot_number":"1890260","report_state":"TX","report_number":"76C79DIA38","insp_date":"2025-06-18 00:00:00","insp_start_time":"0701","insp_end_time":"0728","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8000  EAST FWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-20 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"9612112","transaction_code":"A","transaction_date":"2025-06-20 00:00:00","upload_date":"2025-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2025-06-20 21:36:00","snet_input_date":"2025-06-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-20 21:36:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"7702 FITZHUGH STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0764888","created_at":"2025-06-23T10:00:45.000000Z","updated_at":"2025-06-24T10:00:30.000000Z","inspection_violations":[{"id":14361837,"change_date":"2025-06-20 21:36:00","inspection_id":"85002173","insp_violation_id":"266951356","seq_no":"1","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"207478705","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-23T10:16:18.000000Z","updated_at":"2025-06-24T10:15:40.000000Z","normalized_code":"999"},{"id":14361838,"change_date":"2025-06-20 21:36:00","inspection_id":"85002173","insp_violation_id":"266951357","seq_no":"2","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"207478705","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-23T10:16:18.000000Z","updated_at":"2025-06-24T10:15:40.000000Z","normalized_code":"39311TU"}],"inspection_per_units":[{"id":14663398,"change_date":"2025-06-20 21:36:00","inspection_id":"85002173","insp_unit_id":"207478705","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"35","insp_unit_license":"1M18927","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK09DAE7219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-23T09:45:53.000000Z","updated_at":"2025-06-24T09:45:38.000000Z"},{"id":14663399,"change_date":"2025-06-20 21:36:00","inspection_id":"85002173","insp_unit_id":"207478706","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"108","insp_unit_license":"206B980","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GR4M9622NH335147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-23T09:45:53.000000Z","updated_at":"2025-06-24T09:45:38.000000Z"}]},{"id":8535191,"change_date":"2025-05-02 21:41:00","inspection_id":"84567396","dot_number":"1890260","report_state":"TX","report_number":"V251850431","insp_date":"2025-05-01 00:00:00","insp_start_time":"1018","insp_end_time":"1112","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A101","location_desc":"IH10 EB KINGSBURY SCALE","county_code_state":"TX","county_code":"187","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"A AND H TRANSPORT","shipping_paper_number":"NONE","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"0","hazmat_oos_total":"0","snet_sequence_id":"9568370","transaction_code":"A","transaction_date":"2025-05-02 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2025-05-02 21:41:00","snet_input_date":"2025-05-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-02 21:41:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0764888","created_at":"2025-05-05T10:16:11.000000Z","updated_at":"2025-05-06T10:06:32.000000Z","inspection_violations":[{"id":13518423,"change_date":"2025-05-02 21:41:00","inspection_id":"84567396","insp_violation_id":"265979596","seq_no":"1","part_no":"393","part_no_section":"45B2PC","insp_viol_unit":"1","insp_unit_id":"206619291","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:54:57.000000Z","updated_at":"2025-05-06T10:34:05.000000Z","normalized_code":"39345B2PC"},{"id":13518424,"change_date":"2025-05-02 21:41:00","inspection_id":"84567396","insp_violation_id":"265979597","seq_no":"2","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"206619291","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:54:57.000000Z","updated_at":"2025-05-06T10:34:05.000000Z","normalized_code":"3963A1"},{"id":13518425,"change_date":"2025-05-02 21:41:00","inspection_id":"84567396","insp_violation_id":"265979598","seq_no":"3","part_no":"396","part_no_section":"5B-HLIW","insp_viol_unit":"2","insp_unit_id":"206619292","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:54:57.000000Z","updated_at":"2025-05-06T10:34:05.000000Z","normalized_code":"3965BHLIW"}],"inspection_per_units":[{"id":13878393,"change_date":"2025-05-02 21:41:00","inspection_id":"84567396","insp_unit_id":"206619291","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"102","insp_unit_license":"1L38229","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X13J708703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T10:06:27.000000Z","updated_at":"2025-05-07T10:04:56.000000Z"},{"id":13878394,"change_date":"2025-05-02 21:41:00","inspection_id":"84567396","insp_unit_id":"206619292","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"FB110","insp_unit_license":"073C600","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N148205F1567727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T10:06:27.000000Z","updated_at":"2025-05-07T10:04:56.000000Z"}]},{"id":7295664,"change_date":"2024-11-27 21:40:00","inspection_id":"83263929","dot_number":"1890260","report_state":"TX","report_number":"V241706355","insp_date":"2024-11-25 00:00:00","insp_start_time":"1455","insp_end_time":"1530","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"602M TX6 NB SVC RD","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ENSTRUCTURE RICHARDSON LLC","shipping_paper_number":"RV_1666533","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-11-27 21:40: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":"9439076","transaction_code":"A","transaction_date":"2024-11-27 00:00:00","upload_date":"2024-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2024-11-27 21:40:00","snet_input_date":"2024-11-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-27 21:40:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T20:48:11.000000Z","updated_at":"2025-03-17T20:48:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11768231,"change_date":"2024-11-27 21:40:00","inspection_id":"83263929","insp_unit_id":"204090331","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"102","insp_unit_license":"1L38229","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X13J708703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:58.000000Z","updated_at":"2025-03-17T23:44:58.000000Z"},{"id":11768232,"change_date":"2024-11-27 21:40:00","inspection_id":"83263929","insp_unit_id":"204090332","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"FB-110","insp_unit_license":"073C600","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N148205F1567727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:58.000000Z","updated_at":"2025-03-17T23:44:58.000000Z"}]},{"id":7177193,"change_date":"2024-11-12 21:42:00","inspection_id":"83138714","dot_number":"1890260","report_state":"TX","report_number":"V241691087","insp_date":"2024-11-08 00:00:00","insp_start_time":"1030","insp_end_time":"1103","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH45 NB NEW WAVERLY SCALE","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUNBELT GROUP","shipping_paper_number":"0038041398","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-11-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121250","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":"9425838","transaction_code":"A","transaction_date":"2024-11-12 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2024-11-12 21:42:00","snet_input_date":"2024-11-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-12 21:42:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T20:45:37.000000Z","updated_at":"2025-03-17T20:45:37.000000Z","inspection_violations":[{"id":11215571,"change_date":"2024-11-12 21:42:00","inspection_id":"83138714","insp_violation_id":"262857458","seq_no":"1","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"203847610","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:25.000000Z","updated_at":"2025-03-17T22:00:25.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":11576930,"change_date":"2024-11-12 21:42:00","inspection_id":"83138714","insp_unit_id":"203847609","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"T108","insp_unit_license":"206B980","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GR4M9622NH335147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:58.000000Z","updated_at":"2025-03-17T23:42:58.000000Z"},{"id":11576931,"change_date":"2024-11-12 21:42:00","inspection_id":"83138714","insp_unit_id":"203847610","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"35","insp_unit_license":"1M18927","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK09DAE7219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:58.000000Z","updated_at":"2025-03-17T23:42:58.000000Z"}]},{"id":7073643,"change_date":"2024-10-29 21:42:00","inspection_id":"83028949","dot_number":"1890260","report_state":"TX","report_number":"6ZPD9DCOE5","insp_date":"2024-10-22 00:00:00","insp_start_time":"1318","insp_end_time":"1330","registration_date":"2024-10-29 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132350","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":"9413514","transaction_code":"A","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2024-10-29 21:42:00","snet_input_date":"2024-10-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-29 21:42:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T20:43:28.000000Z","updated_at":"2025-03-17T20:43:28.000000Z","inspection_violations":[{"id":11042336,"change_date":"2024-10-29 21:42:00","inspection_id":"83028949","insp_violation_id":"262619255","seq_no":"1","part_no":"393","part_no_section":"55E","insp_viol_unit":"1","insp_unit_id":"203641693","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":11408095,"change_date":"2024-10-29 21:42:00","inspection_id":"83028949","insp_unit_id":"203641693","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"015","insp_unit_license":"21T793M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDJSJR3CN365315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:07.000000Z","updated_at":"2025-03-17T23:41:07.000000Z"},{"id":11408096,"change_date":"2024-10-29 21:42:00","inspection_id":"83028949","insp_unit_id":"203641694","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"50008","insp_unit_license":"22T793M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TR14830372011167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:07.000000Z","updated_at":"2025-03-17T23:41:07.000000Z"}]},{"id":5419483,"change_date":"2024-04-02 21:43:00","inspection_id":"81250958","dot_number":"1890260","report_state":"TX","report_number":"V241353720","insp_date":"2024-03-28 00:00:00","insp_start_time":"0850","insp_end_time":"0914","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:30   31' 28.86N","county_code_state":"TX","county_code":"471","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-04-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"9237197","transaction_code":"A","transaction_date":"2024-04-02 00:00:00","upload_date":"2024-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2024-04-02 21:43:00","snet_input_date":"2024-03-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-02 21:43:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T20:09:55.000000Z","updated_at":"2025-03-17T20:09:55.000000Z","inspection_violations":[{"id":8366948,"change_date":"2024-04-02 21:43:00","inspection_id":"81250958","insp_violation_id":"258711604","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200202983","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:30.000000Z","updated_at":"2025-03-17T21:46:30.000000Z","normalized_code":"39311"},{"id":8366949,"change_date":"2024-04-02 21:43:00","inspection_id":"81250958","insp_violation_id":"258711605","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200202983","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:30.000000Z","updated_at":"2025-03-17T21:46:30.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8729084,"change_date":"2024-04-02 21:43:00","inspection_id":"81250958","insp_unit_id":"200202983","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"357","insp_unit_license":"1M77468","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR7CSBP0578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:10.000000Z","updated_at":"2025-03-17T23:14:10.000000Z"}]},{"id":5320517,"change_date":"2024-03-19 21:45:00","inspection_id":"81143220","dot_number":"1890260","report_state":"TX","report_number":"V241344958","insp_date":"2024-03-14 00:00:00","insp_start_time":"1058","insp_end_time":"1140","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A102","location_desc":"IH 10 WESTBOUND KINGSBURY","county_code_state":"TX","county_code":"187","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ARROW STEEL","shipping_paper_number":"66642","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-19 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"119239","viol_total":"9","oos_total":"4","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9227473","transaction_code":"A","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2024-03-19 21:45:00","snet_input_date":"2024-03-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-19 21:45:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T20:08:14.000000Z","updated_at":"2025-03-17T20:08:14.000000Z","inspection_violations":[{"id":8210107,"change_date":"2024-03-19 21:45:00","inspection_id":"81143220","insp_violation_id":"258470580","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"199987556","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:42.000000Z","updated_at":"2025-03-17T21:45:42.000000Z","normalized_code":"39345"},{"id":8210108,"change_date":"2024-03-19 21:45:00","inspection_id":"81143220","insp_violation_id":"258470581","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"199987555","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:42.000000Z","updated_at":"2025-03-17T21:45:42.000000Z","normalized_code":"39375A3"},{"id":8210109,"change_date":"2024-03-19 21:45:00","inspection_id":"81143220","insp_violation_id":"258470582","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199987555","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:42.000000Z","updated_at":"2025-03-17T21:45:42.000000Z","normalized_code":"39378"},{"id":8210110,"change_date":"2024-03-19 21:45:00","inspection_id":"81143220","insp_violation_id":"258470583","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199987556","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:42.000000Z","updated_at":"2025-03-17T21:45:42.000000Z","normalized_code":"3939A"},{"id":8210111,"change_date":"2024-03-19 21:45:00","inspection_id":"81143220","insp_violation_id":"258470584","seq_no":"5","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:42.000000Z","updated_at":"2025-03-17T21:45:42.000000Z","normalized_code":"3958A1"},{"id":8210112,"change_date":"2024-03-19 21:45:00","inspection_id":"81143220","insp_violation_id":"258470585","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199987555","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:42.000000Z","updated_at":"2025-03-17T21:45:42.000000Z","normalized_code":"3965B"},{"id":8210113,"change_date":"2024-03-19 21:45:00","inspection_id":"81143220","insp_violation_id":"258470586","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199987556","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:42.000000Z","updated_at":"2025-03-17T21:45:42.000000Z","normalized_code":"3922"},{"id":8210114,"change_date":"2024-03-19 21:45:00","inspection_id":"81143220","insp_violation_id":"258470587","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199987555","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:42.000000Z","updated_at":"2025-03-17T21:45:42.000000Z","normalized_code":"3922"},{"id":8210115,"change_date":"2024-03-19 21:45:00","inspection_id":"81143220","insp_violation_id":"258470588","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199987555","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:42.000000Z","updated_at":"2025-03-17T21:45:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8568834,"change_date":"2024-03-19 21:45:00","inspection_id":"81143220","insp_unit_id":"199987555","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"015","insp_unit_license":"76V348V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDJSJR3CN365315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:39.000000Z","updated_at":"2025-03-17T23:12:39.000000Z"},{"id":8568835,"change_date":"2024-03-19 21:45:00","inspection_id":"81143220","insp_unit_id":"199987556","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"50008","insp_unit_license":"77V348V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TR14830372011167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:39.000000Z","updated_at":"2025-03-17T23:12:39.000000Z"}]},{"id":4946080,"change_date":"2024-01-31 21:42:00","inspection_id":"80734288","dot_number":"1890260","report_state":"TX","report_number":"V241310143","insp_date":"2024-01-30 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"KELLEY ST AT TX6 NB","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ENSTRUCTURE RICHARDSON LLC","shipping_paper_number":"RV_1531356","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-01-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9185480","transaction_code":"A","transaction_date":"2024-01-31 00:00:00","upload_date":"2024-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2024-01-31 21:42:00","snet_input_date":"2024-01-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-31 21:42:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T20:00:49.000000Z","updated_at":"2025-03-17T20:00:49.000000Z","inspection_violations":[{"id":7618732,"change_date":"2024-01-31 21:42:00","inspection_id":"80734288","insp_violation_id":"257594564","seq_no":"1","part_no":"393","part_no_section":"67(c)(7)(v)","insp_viol_unit":"1","insp_unit_id":"199202888","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:45.000000Z","updated_at":"2025-03-17T21:42:45.000000Z","normalized_code":"39367C7V"},{"id":7618733,"change_date":"2024-01-31 21:42:00","inspection_id":"80734288","insp_violation_id":"257594565","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199202888","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:45.000000Z","updated_at":"2025-03-17T21:42:45.000000Z","normalized_code":"3939A"},{"id":7618734,"change_date":"2024-01-31 21:42:00","inspection_id":"80734288","insp_violation_id":"257594566","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199202888","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:42:45.000000Z","updated_at":"2025-03-17T21:42:45.000000Z","normalized_code":"3963A1"},{"id":7618735,"change_date":"2024-01-31 21:42:00","inspection_id":"80734288","insp_violation_id":"257594567","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199202888","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:45.000000Z","updated_at":"2025-03-17T21:42:45.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":7959930,"change_date":"2024-01-31 21:42:00","inspection_id":"80734288","insp_unit_id":"199202888","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"008","insp_unit_license":"76S420M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X4CJ305018","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:07.000000Z","updated_at":"2025-03-17T23:07:07.000000Z"},{"id":7959931,"change_date":"2024-01-31 21:42:00","inspection_id":"80734288","insp_unit_id":"199202889","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"77S420M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N148209G1514580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:07.000000Z","updated_at":"2025-03-17T23:07:07.000000Z"}]},{"id":4989758,"change_date":"2024-02-06 21:42:00","inspection_id":"80782135","dot_number":"1890260","report_state":"TX","report_number":"6SB89DCCGT","insp_date":"2024-01-30 00:00:00","insp_start_time":"0838","insp_end_time":"0923","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"400 E LOOP N SER W F","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"9189227","transaction_code":"A","transaction_date":"2024-02-06 00:00:00","upload_date":"2024-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2024-02-06 21:42:00","snet_input_date":"2024-01-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-06 21:42:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T20:01:38.000000Z","updated_at":"2025-03-17T20:01:38.000000Z","inspection_violations":[{"id":7684799,"change_date":"2024-02-06 21:42:00","inspection_id":"80782135","insp_violation_id":"257693336","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199295394","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"3939A"},{"id":7684800,"change_date":"2024-02-06 21:42:00","inspection_id":"80782135","insp_violation_id":"257693337","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199295394","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8030983,"change_date":"2024-02-06 21:42:00","inspection_id":"80782135","insp_unit_id":"199295393","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M37579","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK67LW52379","insp_unit_decal":"Y","insp_unit_decal_number":"33618279","created_at":"2025-03-17T23:07:48.000000Z","updated_at":"2025-03-17T23:07:48.000000Z"},{"id":8030984,"change_date":"2024-02-06 21:42:00","inspection_id":"80782135","insp_unit_id":"199295394","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"121C562","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2486YA197005","insp_unit_decal":"Y","insp_unit_decal_number":"33618280","created_at":"2025-03-17T23:07:48.000000Z","updated_at":"2025-03-17T23:07:48.000000Z"}]},{"id":4334886,"change_date":"2023-11-02 21:42:00","inspection_id":"80063803","dot_number":"1890260","report_state":"TX","report_number":"6PLI9DJMML","insp_date":"2023-10-24 00:00:00","insp_start_time":"1755","insp_end_time":"1817","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8000  EAST FWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COOPER","shipping_paper_number":"1252655","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9114757","transaction_code":"C","transaction_date":"2023-11-02 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2023-11-01 21:44:00","snet_input_date":"2023-10-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-01 21:44:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0764888","created_at":"2025-03-17T19:48:45.000000Z","updated_at":"2025-03-17T19:48:45.000000Z","inspection_violations":[{"id":6704828,"change_date":"2023-11-02 21:42:00","inspection_id":"80063803","insp_violation_id":"256196255","seq_no":"1","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"197885588","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:17.000000Z","updated_at":"2025-03-17T21:38:17.000000Z","normalized_code":"393104F3"},{"id":6704829,"change_date":"2023-11-02 21:42:00","inspection_id":"80063803","insp_violation_id":"256196256","seq_no":"2","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"197885588","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:38:17.000000Z","updated_at":"2025-03-17T21:38:17.000000Z","normalized_code":"393110B"}],"inspection_per_units":[{"id":6971574,"change_date":"2023-11-02 21:42:00","inspection_id":"80063803","insp_unit_id":"197885587","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"35","insp_unit_license":"1M18927","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK09DAE7219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:32.000000Z","updated_at":"2025-03-17T22:58:32.000000Z"},{"id":6971575,"change_date":"2023-11-02 21:42:00","inspection_id":"80063803","insp_unit_id":"197885588","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"108","insp_unit_license":"206B980","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GR4M9622NH335147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:32.000000Z","updated_at":"2025-03-17T22:58:32.000000Z"}]},{"id":3726214,"change_date":"2023-08-11 21:39:00","inspection_id":"79387687","dot_number":"1890260","report_state":"TX","report_number":"6NI79DBTRX","insp_date":"2023-08-10 00:00:00","insp_start_time":"0730","insp_end_time":"0806","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY S SR","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"150000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9050403","transaction_code":"A","transaction_date":"2023-08-11 00:00:00","upload_date":"2023-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T19:36:29.000000Z","updated_at":"2025-03-17T19:36:29.000000Z","inspection_violations":[{"id":5747288,"change_date":"2023-08-11 21:39:00","inspection_id":"79387687","insp_violation_id":"254614459","seq_no":"1","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"196495151","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"393201A"},{"id":5747289,"change_date":"2023-08-11 21:39:00","inspection_id":"79387687","insp_violation_id":"254614460","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"196495151","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39345D"},{"id":5747290,"change_date":"2023-08-11 21:39:00","inspection_id":"79387687","insp_violation_id":"254614461","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196495151","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39347E"},{"id":5747291,"change_date":"2023-08-11 21:39:00","inspection_id":"79387687","insp_violation_id":"254614462","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196495151","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39347E"},{"id":5747292,"change_date":"2023-08-11 21:39:00","inspection_id":"79387687","insp_violation_id":"254614463","seq_no":"5","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"196495151","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39347A"},{"id":5747293,"change_date":"2023-08-11 21:39:00","inspection_id":"79387687","insp_violation_id":"254614464","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196495151","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3963A1"},{"id":5747294,"change_date":"2023-08-11 21:39:00","inspection_id":"79387687","insp_violation_id":"254614465","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196495151","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39353B"},{"id":5747295,"change_date":"2023-08-11 21:39:00","inspection_id":"79387687","insp_violation_id":"254614466","seq_no":"8","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"2","insp_unit_id":"196495152","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3929A2"}],"inspection_per_units":[{"id":5991485,"change_date":"2023-08-11 21:39:00","inspection_id":"79387687","insp_unit_id":"196495151","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M18927","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK09DAE7219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:21.000000Z","updated_at":"2025-03-17T22:50:21.000000Z"},{"id":5991486,"change_date":"2023-08-11 21:39:00","inspection_id":"79387687","insp_unit_id":"196495152","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":null,"insp_unit_license":"206B980","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GR4M9622NH335147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:21.000000Z","updated_at":"2025-03-17T22:50:21.000000Z"}]},{"id":3708687,"change_date":"2023-08-09 21:43:00","inspection_id":"79368228","dot_number":"1890260","report_state":"TX","report_number":"V231065952","insp_date":"2023-08-01 00:00:00","insp_start_time":"1030","insp_end_time":"1055","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH20 EB IH20 EB","county_code_state":"TX","county_code":"133","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"A & H TRANSPORTATION","shipping_paper_number":"NONE","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","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":"9048913","transaction_code":"A","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2023-08-09 21:43:00","snet_input_date":"2023-08-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-09 21:43:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T19:36:07.000000Z","updated_at":"2025-03-17T19:36:07.000000Z","inspection_violations":[{"id":5719127,"change_date":"2023-08-09 21:43:00","inspection_id":"79368228","insp_violation_id":"254565421","seq_no":"1","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"196452116","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:28.000000Z","updated_at":"2025-03-17T21:33:28.000000Z","normalized_code":"39375A1"}],"inspection_per_units":[{"id":5963211,"change_date":"2023-08-09 21:43:00","inspection_id":"79368228","insp_unit_id":"196452115","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"018","insp_unit_license":"12T211M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X6WR749785","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:07.000000Z","updated_at":"2025-03-17T22:50:07.000000Z"},{"id":5963212,"change_date":"2023-08-09 21:43:00","inspection_id":"79368228","insp_unit_id":"196452116","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"T38","insp_unit_license":"34R209M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482W7XS571344","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:07.000000Z","updated_at":"2025-03-17T22:50:07.000000Z"}]},{"id":3390439,"change_date":"2023-06-28 21:43:00","inspection_id":"79011051","dot_number":"1890260","report_state":"TX","report_number":"V231042189","insp_date":"2023-06-26 00:00:00","insp_start_time":"0951","insp_end_time":"1033","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"PENINSULA ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GULF STREAM","shipping_paper_number":"510120975","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-06-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9016173","transaction_code":"A","transaction_date":"2023-06-28 00:00:00","upload_date":"2023-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2023-06-28 21:43:00","snet_input_date":"2023-06-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-28 21:43:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T19:30:10.000000Z","updated_at":"2025-03-17T19:30:10.000000Z","inspection_violations":[{"id":5227237,"change_date":"2023-06-28 21:43:00","inspection_id":"79011051","insp_violation_id":"253762391","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"195732067","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"39311"},{"id":5227238,"change_date":"2023-06-28 21:43:00","inspection_id":"79011051","insp_violation_id":"253762392","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195732066","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"39311"},{"id":5227239,"change_date":"2023-06-28 21:43:00","inspection_id":"79011051","insp_violation_id":"253762393","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195732066","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"39347E"},{"id":5227240,"change_date":"2023-06-28 21:43:00","inspection_id":"79011051","insp_violation_id":"253762394","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"195732066","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"39353B"},{"id":5227241,"change_date":"2023-06-28 21:43:00","inspection_id":"79011051","insp_violation_id":"253762395","seq_no":"5","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"3958"}],"inspection_per_units":[{"id":5451054,"change_date":"2023-06-28 21:43:00","inspection_id":"79011051","insp_unit_id":"195732066","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"018","insp_unit_license":"55U141M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X6WR749785","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:01.000000Z","updated_at":"2025-03-17T22:46:01.000000Z"},{"id":5451055,"change_date":"2023-06-28 21:43:00","inspection_id":"79011051","insp_unit_id":"195732067","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"38T","insp_unit_license":"54S133M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482W7XS571344","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:01.000000Z","updated_at":"2025-03-17T22:46:01.000000Z"}]},{"id":3134519,"change_date":"2023-05-24 21:41:00","inspection_id":"78722300","dot_number":"1890260","report_state":"TX","report_number":"6L579DCGPR","insp_date":"2023-05-17 00:00:00","insp_start_time":"0705","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0610 IN HARRIS CO. (0-37)","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COOPER PORTS","shipping_paper_number":"1113893","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-05-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8987480","transaction_code":"A","transaction_date":"2023-05-24 00:00:00","upload_date":"2023-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2023-05-24 21:41:00","snet_input_date":"2023-05-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-24 21:41:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T19:24:59.000000Z","updated_at":"2025-03-17T19:24:59.000000Z","inspection_violations":[{"id":4825734,"change_date":"2023-05-24 21:41:00","inspection_id":"78722300","insp_violation_id":"253062453","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195128076","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39378"},{"id":4825735,"change_date":"2023-05-24 21:41:00","inspection_id":"78722300","insp_violation_id":"253062454","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195128076","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39347E"},{"id":4825736,"change_date":"2023-05-24 21:41:00","inspection_id":"78722300","insp_violation_id":"253062455","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"195128076","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39353B"},{"id":4825737,"change_date":"2023-05-24 21:41:00","inspection_id":"78722300","insp_violation_id":"253062456","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195128076","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3963A1"},{"id":4825738,"change_date":"2023-05-24 21:41:00","inspection_id":"78722300","insp_violation_id":"253062457","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"195128077","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39347E"},{"id":4825739,"change_date":"2023-05-24 21:41:00","inspection_id":"78722300","insp_violation_id":"253062458","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"195128077","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39353B"},{"id":4825740,"change_date":"2023-05-24 21:41:00","inspection_id":"78722300","insp_violation_id":"253062459","seq_no":"7","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"195128077","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":5041663,"change_date":"2023-05-24 21:41:00","inspection_id":"78722300","insp_unit_id":"195128076","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"59P103M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X82N581421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"},{"id":5041664,"change_date":"2023-05-24 21:41:00","inspection_id":"78722300","insp_unit_id":"195128077","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"NABO","insp_unit_company":null,"insp_unit_license":"61P103M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5BAFD4824Y12B0293","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"}]},{"id":3134823,"change_date":"2023-05-24 21:41:00","inspection_id":"78722631","dot_number":"1890260","report_state":"TX","report_number":"6L589DCGPS","insp_date":"2023-05-17 00:00:00","insp_start_time":"0810","insp_end_time":"0850","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0610 IN HARRIS CO. (0-37)","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BUDGET READY MIX","shipping_paper_number":"8124","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-05-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8987481","transaction_code":"A","transaction_date":"2023-05-24 00:00:00","upload_date":"2023-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2023-05-24 21:41:00","snet_input_date":"2023-05-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-24 21:41:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T19:24:59.000000Z","updated_at":"2025-03-17T19:24:59.000000Z","inspection_violations":[{"id":4826678,"change_date":"2023-05-24 21:41:00","inspection_id":"78722631","insp_violation_id":"253063822","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"195128817","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3965B"},{"id":4826679,"change_date":"2023-05-24 21:41:00","inspection_id":"78722631","insp_violation_id":"253063823","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195128817","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39347E"},{"id":4826680,"change_date":"2023-05-24 21:41:00","inspection_id":"78722631","insp_violation_id":"253063824","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195128817","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39347E"},{"id":4826681,"change_date":"2023-05-24 21:41:00","inspection_id":"78722631","insp_violation_id":"253063825","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"195128817","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39353B"},{"id":4826682,"change_date":"2023-05-24 21:41:00","inspection_id":"78722631","insp_violation_id":"253063826","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195128817","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3963A1"},{"id":4826683,"change_date":"2023-05-24 21:41:00","inspection_id":"78722631","insp_violation_id":"253063827","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195128817","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3963A1"},{"id":4826684,"change_date":"2023-05-24 21:41:00","inspection_id":"78722631","insp_violation_id":"253063828","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195128817","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3922"},{"id":4826685,"change_date":"2023-05-24 21:41:00","inspection_id":"78722631","insp_violation_id":"253063829","seq_no":"8","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"195128817","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39375G"},{"id":4826686,"change_date":"2023-05-24 21:41:00","inspection_id":"78722631","insp_violation_id":"253063830","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195128817","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3922"},{"id":4826687,"change_date":"2023-05-24 21:41:00","inspection_id":"78722631","insp_violation_id":"253063831","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195128817","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5042188,"change_date":"2023-05-24 21:41:00","inspection_id":"78722631","insp_unit_id":"195128817","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"MKL4312","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDLU0X67J195893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"}]},{"id":3055692,"change_date":"2023-05-16 21:42:00","inspection_id":"78633717","dot_number":"1890260","report_state":"TX","report_number":"6KYG9DJNK8","insp_date":"2023-05-10 00:00:00","insp_start_time":"1652","insp_end_time":"1715","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1900  MCCARTY ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-05-16 21:42: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":"8979966","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2023-05-16 21:42:00","snet_input_date":"2023-05-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-16 21:42:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T19:23:25.000000Z","updated_at":"2025-03-17T19:23:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4916180,"change_date":"2023-05-16 21:42:00","inspection_id":"78633717","insp_unit_id":"194958320","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"012","insp_unit_license":"1L13010","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK44DN36460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:46.000000Z","updated_at":"2025-03-17T22:41:46.000000Z"},{"id":4916181,"change_date":"2023-05-16 21:42:00","inspection_id":"78633717","insp_unit_id":"194958321","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":"202","insp_unit_license":"Z27617","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L01B4829V1127375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:46.000000Z","updated_at":"2025-03-17T22:41:46.000000Z"}]},{"id":2721932,"change_date":"2023-04-03 21:40:00","inspection_id":"78256119","dot_number":"1890260","report_state":"TX","report_number":"6JT89DNN2M","insp_date":"2023-03-30 00:00:00","insp_start_time":"0855","insp_end_time":"0935","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-04-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8944716","transaction_code":"A","transaction_date":"2023-04-03 00:00:00","upload_date":"2023-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2023-04-03 21:40:00","snet_input_date":"2023-03-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-03 21:40:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T19:16:56.000000Z","updated_at":"2025-03-17T19:16:56.000000Z","inspection_violations":[{"id":4182364,"change_date":"2023-04-03 21:40:00","inspection_id":"78256119","insp_violation_id":"252022524","seq_no":"1","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:35.000000Z","updated_at":"2025-03-17T21:26:35.000000Z","normalized_code":"3958"},{"id":4182365,"change_date":"2023-04-03 21:40:00","inspection_id":"78256119","insp_violation_id":"252022525","seq_no":"2","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:35.000000Z","updated_at":"2025-03-17T21:26:35.000000Z","normalized_code":"39145B"}],"inspection_per_units":[{"id":4381539,"change_date":"2023-04-03 21:40:00","inspection_id":"78256119","insp_unit_id":"194201907","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"018","insp_unit_license":"60M047M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X6WR749785","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:30.000000Z","updated_at":"2025-03-17T22:37:30.000000Z"},{"id":4381540,"change_date":"2023-04-03 21:40:00","inspection_id":"78256119","insp_unit_id":"194201908","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"38T","insp_unit_license":"62M047M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS248XWA402001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:30.000000Z","updated_at":"2025-03-17T22:37:30.000000Z"}]},{"id":2722395,"change_date":"2023-04-03 21:41:00","inspection_id":"78256625","dot_number":"1890260","report_state":"TX","report_number":"6JTG9DJMCJ","insp_date":"2023-03-30 00:00:00","insp_start_time":"1625","insp_end_time":"1650","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MCCARTY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-04-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","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":"8944915","transaction_code":"A","transaction_date":"2023-04-03 00:00:00","upload_date":"2023-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2023-04-03 21:41:00","snet_input_date":"2023-03-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-03 21:41:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T19:16:56.000000Z","updated_at":"2025-03-17T19:16:56.000000Z","inspection_violations":[{"id":4183381,"change_date":"2023-04-03 21:41:00","inspection_id":"78256625","insp_violation_id":"252023758","seq_no":"1","part_no":"393","part_no_section":"205(a)","insp_viol_unit":"1","insp_unit_id":"194202830","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:36.000000Z","updated_at":"2025-03-17T21:26:36.000000Z","normalized_code":"393205A"},{"id":4183382,"change_date":"2023-04-03 21:41:00","inspection_id":"78256625","insp_violation_id":"252023759","seq_no":"2","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"194202830","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:36.000000Z","updated_at":"2025-03-17T21:26:36.000000Z","normalized_code":"39355D1"}],"inspection_per_units":[{"id":4382318,"change_date":"2023-04-03 21:41:00","inspection_id":"78256625","insp_unit_id":"194202830","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"70Y026V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X4CJ305018","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:30.000000Z","updated_at":"2025-03-17T22:37:30.000000Z"},{"id":4382319,"change_date":"2023-04-03 21:41:00","inspection_id":"78256625","insp_unit_id":"194202831","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RAVE","insp_unit_company":null,"insp_unit_license":"730Y26M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1R1F248274K540066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:30.000000Z","updated_at":"2025-03-17T22:37:30.000000Z"}]},{"id":2668371,"change_date":"2023-03-27 21:40:00","inspection_id":"78194019","dot_number":"1890260","report_state":"TX","report_number":"6JL99DNJL3","insp_date":"2023-03-22 00:00:00","insp_start_time":"0930","insp_end_time":"1020","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KSW STEEL","shipping_paper_number":"LT075654","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8937963","transaction_code":"A","transaction_date":"2023-03-27 00:00:00","upload_date":"2023-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2023-03-27 21:40:00","snet_input_date":"2023-03-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-27 21:40:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T19:15:52.000000Z","updated_at":"2025-03-17T19:15:52.000000Z","inspection_violations":[{"id":4102304,"change_date":"2023-03-27 21:40:00","inspection_id":"78194019","insp_violation_id":"251888184","seq_no":"1","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"194081967","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"393110B"},{"id":4102305,"change_date":"2023-03-27 21:40:00","inspection_id":"78194019","insp_violation_id":"251888185","seq_no":"2","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"194081967","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"393104F3"},{"id":4102306,"change_date":"2023-03-27 21:40:00","inspection_id":"78194019","insp_violation_id":"251888186","seq_no":"3","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"194081967","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"393104B"}],"inspection_per_units":[{"id":4296766,"change_date":"2023-03-27 21:40:00","inspection_id":"78194019","insp_unit_id":"194081966","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"012","insp_unit_license":"1L13010","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK44DN36460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:51.000000Z","updated_at":"2025-03-17T22:36:51.000000Z"},{"id":4296767,"change_date":"2023-03-27 21:40:00","inspection_id":"78194019","insp_unit_id":"194081967","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":"202","insp_unit_license":"Z27617","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L01B4829V1127375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:51.000000Z","updated_at":"2025-03-17T22:36:51.000000Z"}]},{"id":2678425,"change_date":"2023-03-28 21:41:00","inspection_id":"78205175","dot_number":"1890260","report_state":"TX","report_number":"6JK89DCPTZ","insp_date":"2023-03-21 00:00:00","insp_start_time":"0815","insp_end_time":"0900","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SOUT","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"93200","viol_total":"11","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8939191","transaction_code":"A","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2023-03-28 21:41:00","snet_input_date":"2023-03-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-28 21:41:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T19:15:55.000000Z","updated_at":"2025-03-17T19:15:55.000000Z","inspection_violations":[{"id":4115759,"change_date":"2023-03-28 21:41:00","inspection_id":"78205175","insp_violation_id":"251910194","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194104610","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"39378"},{"id":4115760,"change_date":"2023-03-28 21:41:00","inspection_id":"78205175","insp_violation_id":"251910195","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"194104611","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"39355E"},{"id":4115761,"change_date":"2023-03-28 21:41:00","inspection_id":"78205175","insp_violation_id":"251910196","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194104611","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"3939A"},{"id":4115762,"change_date":"2023-03-28 21:41:00","inspection_id":"78205175","insp_violation_id":"251910197","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194104611","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"3939A"},{"id":4115763,"change_date":"2023-03-28 21:41:00","inspection_id":"78205175","insp_violation_id":"251910198","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"194104610","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"3965B"},{"id":4115764,"change_date":"2023-03-28 21:41:00","inspection_id":"78205175","insp_violation_id":"251910199","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"194104610","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"39345B2"},{"id":4115765,"change_date":"2023-03-28 21:41:00","inspection_id":"78205175","insp_violation_id":"251910200","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194104610","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"3963A1"},{"id":4115766,"change_date":"2023-03-28 21:41:00","inspection_id":"78205175","insp_violation_id":"251910201","seq_no":"9","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"194104610","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"39348A"},{"id":4115767,"change_date":"2023-03-28 21:41:00","inspection_id":"78205175","insp_violation_id":"251910202","seq_no":"10","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"38323A2"},{"id":4115768,"change_date":"2023-03-28 21:41:00","inspection_id":"78205175","insp_violation_id":"251910203","seq_no":"11","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"39111B4"},{"id":4115769,"change_date":"2023-03-28 21:41:00","inspection_id":"78205175","insp_violation_id":"251910204","seq_no":"12","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194104611","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4312731,"change_date":"2023-03-28 21:41:00","inspection_id":"78205175","insp_unit_id":"194104610","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1M18253","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB8X2TD393017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:58.000000Z","updated_at":"2025-03-17T22:36:58.000000Z"},{"id":4312732,"change_date":"2023-03-28 21:41:00","inspection_id":"78205175","insp_unit_id":"194104611","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"X43199","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2480XA839510","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:58.000000Z","updated_at":"2025-03-17T22:36:58.000000Z"}]},{"id":2659117,"change_date":"2023-03-24 21:41:00","inspection_id":"78183541","dot_number":"1890260","report_state":"TX","report_number":"6JJI9DJMC5","insp_date":"2023-03-20 00:00:00","insp_start_time":"1755","insp_end_time":"1815","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MCCARTY","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RICHARDSON RRC","shipping_paper_number":"1409771","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"8936819","transaction_code":"A","transaction_date":"2023-03-24 00:00:00","upload_date":"2023-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2023-03-24 21:41:00","snet_input_date":"2023-03-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-24 21:41:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T19:15:35.000000Z","updated_at":"2025-03-17T19:15:35.000000Z","inspection_violations":[{"id":4088106,"change_date":"2023-03-24 21:41:00","inspection_id":"78183541","insp_violation_id":"251866489","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"1","insp_unit_id":"194060843","insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":4281239,"change_date":"2023-03-24 21:41:00","inspection_id":"78183541","insp_unit_id":"194060843","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M37579","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK67LW52379","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:43.000000Z","updated_at":"2025-03-17T22:36:43.000000Z"},{"id":4281240,"change_date":"2023-03-24 21:41:00","inspection_id":"78183541","insp_unit_id":"194060844","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"121C562","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2486YA197005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:43.000000Z","updated_at":"2025-03-17T22:36:43.000000Z"}]},{"id":2484939,"change_date":"2023-03-01 21:42:00","inspection_id":"77985780","dot_number":"1890260","report_state":"TX","report_number":"6IX99DJMAR","insp_date":"2023-02-26 00:00:00","insp_start_time":"0930","insp_end_time":"0947","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7500  MESA","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"130350","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":"8917772","transaction_code":"A","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2023-03-01 21:42:00","snet_input_date":"2023-02-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-01 21:42:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T19:12:30.000000Z","updated_at":"2025-03-17T19:12:30.000000Z","inspection_violations":[{"id":3824412,"change_date":"2023-03-01 21:42:00","inspection_id":"77985780","insp_violation_id":"251427921","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:59.000000Z","updated_at":"2025-03-17T21:24:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3999008,"change_date":"2023-03-01 21:42:00","inspection_id":"77985780","insp_unit_id":"193659728","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5","insp_unit_license":"873714G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X4CJ305018","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:38.000000Z","updated_at":"2025-03-17T22:34:38.000000Z"},{"id":3999009,"change_date":"2023-03-01 21:42:00","inspection_id":"77985780","insp_unit_id":"193659729","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"75W004V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N148209G1514580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:38.000000Z","updated_at":"2025-03-17T22:34:38.000000Z"}]},{"id":2720854,"change_date":"2023-04-03 21:40:00","inspection_id":"78254904","dot_number":"1890260","report_state":"TX","report_number":"6HNF9DBTDR","insp_date":"2023-01-11 00:00:00","insp_start_time":"1555","insp_end_time":"1616","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-04-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64300","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":"8943619","transaction_code":"A","transaction_date":"2023-04-03 00:00:00","upload_date":"2023-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01890260","upload_search_indicator":"M","census_search_date":"2023-04-03 21:40:00","snet_input_date":"2023-01-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-03 21:40:00","insp_carrier_name":"ALFARO HERNANDEZ ARROYO","insp_carrier_street":"11502 RADFORD LAND","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0764888","created_at":"2025-03-17T19:16:55.000000Z","updated_at":"2025-03-17T19:16:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4379718,"change_date":"2023-04-03 21:40:00","inspection_id":"78254904","insp_unit_id":"194199749","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1L13010","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK44DN36460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:28.000000Z","updated_at":"2025-03-17T22:37:28.000000Z"},{"id":4379719,"change_date":"2023-04-03 21:40:00","inspection_id":"78254904","insp_unit_id":"194199750","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":null,"insp_unit_license":"Z27617","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L01B4829V1127375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:28.000000Z","updated_at":"2025-03-17T22:37:28.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1890260\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1890260\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1890260\/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\/1890260\/inspections","per_page":100,"prev_page_url":null,"to":35,"total":35}