{"current_page":1,"data":[{"id":11760059,"change_date":"2026-04-27 21:39:00","inspection_id":"87690411","dot_number":"2048081","report_state":"TX","report_number":"7EXE9DJMJO","insp_date":"2026-04-23 00:00:00","insp_start_time":"1439","insp_end_time":"1510","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5800  CLINTON 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":"2026-04-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"9931984","transaction_code":"A","transaction_date":"2026-04-27 00:00:00","upload_date":"2026-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2026-04-27 21:39:00","snet_input_date":"2026-04-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-27 21:39:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2026-04-30T09:39:38.000000Z","updated_at":"2026-05-08T09:31:02.000000Z","inspection_violations":[{"id":20446510,"change_date":"2026-04-27 21:39:00","inspection_id":"87690411","insp_violation_id":"273880758","seq_no":"1","part_no":"393","part_no_section":"75B","insp_viol_unit":"1","insp_unit_id":"213248400","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-30T09:59:06.000000Z","updated_at":"2026-05-08T09:42:22.000000Z","normalized_code":"39375B"}],"inspection_per_units":[{"id":20460278,"change_date":"2026-04-27 21:39:00","inspection_id":"87690411","insp_unit_id":"213248400","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"TSR6522","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS5DHFJ0477","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-30T09:18:38.000000Z","updated_at":"2026-05-08T09:03:47.000000Z"}]},{"id":11771518,"change_date":"2026-04-28 21:39:00","inspection_id":"87702339","dot_number":"2048081","report_state":"TX","report_number":"7EP89DJMJA","insp_date":"2026-04-15 00:00:00","insp_start_time":"0806","insp_end_time":"0855","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","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-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9934029","transaction_code":"A","transaction_date":"2026-04-28 00:00:00","upload_date":"2026-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2026-04-28 21:39:00","snet_input_date":"2026-04-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-28 21:39:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2026-05-01T09:40:31.000000Z","updated_at":"2026-05-09T09:31:11.000000Z","inspection_violations":[{"id":20467867,"change_date":"2026-04-28 21:39:00","inspection_id":"87702339","insp_violation_id":"273909729","seq_no":"1","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"213271680","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-01T10:02:14.000000Z","updated_at":"2026-05-09T09:42:27.000000Z","normalized_code":"3963A1"},{"id":20467868,"change_date":"2026-04-28 21:39:00","inspection_id":"87702339","insp_violation_id":"273909730","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"213271680","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-01T10:02:14.000000Z","updated_at":"2026-05-09T09:42:27.000000Z","normalized_code":"39311"},{"id":20467869,"change_date":"2026-04-28 21:39:00","inspection_id":"87702339","insp_violation_id":"273909731","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"213271680","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-01T10:02:14.000000Z","updated_at":"2026-05-09T09:42:27.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":20479140,"change_date":"2026-04-28 21:39:00","inspection_id":"87702339","insp_unit_id":"213271680","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"WMT7295","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY9FDGK3912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:20:49.000000Z","updated_at":"2026-05-09T09:03:47.000000Z"}]},{"id":11174283,"change_date":"2026-02-19 21:40:00","inspection_id":"87090227","dot_number":"2048081","report_state":"TX","report_number":"7CX89DCAGO","insp_date":"2026-02-10 00:00:00","insp_start_time":"0805","insp_end_time":"0835","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":"2026-02-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9855974","transaction_code":"A","transaction_date":"2026-02-19 00:00:00","upload_date":"2026-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2026-02-19 21:40:00","snet_input_date":"2026-02-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-19 21:40:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2026-02-22T10:38:06.000000Z","updated_at":"2026-03-02T10:31:08.000000Z","inspection_violations":[{"id":18732923,"change_date":"2026-02-19 21:40:00","inspection_id":"87090227","insp_violation_id":"271901843","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"211716515","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:31.000000Z","updated_at":"2026-03-02T10:41:47.000000Z","normalized_code":"39347E"},{"id":18732924,"change_date":"2026-02-19 21:40:00","inspection_id":"87090227","insp_violation_id":"271901844","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"211716515","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:31.000000Z","updated_at":"2026-03-02T10:41:47.000000Z","normalized_code":"39353B"},{"id":18732925,"change_date":"2026-02-19 21:40:00","inspection_id":"87090227","insp_violation_id":"271901845","seq_no":"3","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"211716515","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:31.000000Z","updated_at":"2026-03-02T10:41:47.000000Z","normalized_code":"39375C"},{"id":18732926,"change_date":"2026-02-19 21:40:00","inspection_id":"87090227","insp_violation_id":"271901846","seq_no":"4","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"211716515","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:31.000000Z","updated_at":"2026-03-02T10:41:47.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":19069371,"change_date":"2026-02-19 21:40:00","inspection_id":"87090227","insp_unit_id":"211716515","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"TSY9456","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG5CY7EDFT5491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:29.000000Z","updated_at":"2026-03-02T10:04:05.000000Z"}]},{"id":10837463,"change_date":"2026-01-22 21:39:00","inspection_id":"86865795","dot_number":"2048081","report_state":"TX","report_number":"7C889DCAF3","insp_date":"2026-01-16 00:00:00","insp_start_time":"0805","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"17200  EASTEX FWY WE","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-01-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","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":"9825792","transaction_code":"A","transaction_date":"2026-01-22 00:00:00","upload_date":"2026-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2026-01-22 21:39:00","snet_input_date":"2026-01-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-22 21:39:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2026-01-25T10:37:03.000000Z","updated_at":"2026-02-02T10:30:52.000000Z","inspection_violations":[{"id":18121479,"change_date":"2026-01-22 21:39:00","inspection_id":"86865795","insp_violation_id":"271369247","seq_no":"2","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"211242427","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:47.000000Z","updated_at":"2026-02-02T10:37:19.000000Z","normalized_code":"39375C"},{"id":18121480,"change_date":"2026-01-22 21:39:00","inspection_id":"86865795","insp_violation_id":"271369248","seq_no":"1","part_no":"393","part_no_section":"75B","insp_viol_unit":"1","insp_unit_id":"211242427","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:47.000000Z","updated_at":"2026-02-02T10:37:19.000000Z","normalized_code":"39375B"}],"inspection_per_units":[{"id":18207167,"change_date":"2026-01-22 21:39:00","inspection_id":"86865795","insp_unit_id":"211242427","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"TSR6522","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS5DHFJ0477","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:21.000000Z","updated_at":"2026-02-02T10:03:24.000000Z"}]},{"id":10317559,"change_date":"2025-12-01 21:39:00","inspection_id":"86444186","dot_number":"2048081","report_state":"TX","report_number":"7ANB9DBA9F","insp_date":"2025-11-20 00:00:00","insp_start_time":"1118","insp_end_time":"1145","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1600  ALDINE BENDER","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE STEEL SUPPLY INC","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-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9770833","transaction_code":"A","transaction_date":"2025-12-01 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-12-04T10:30:36.000000Z","updated_at":"2025-12-05T10:31:04.000000Z","inspection_violations":[{"id":17258662,"change_date":"2025-12-01 21:39:00","inspection_id":"86444186","insp_violation_id":"270368792","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"210330795","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-04T10:30:56.000000Z","updated_at":"2025-12-05T10:31:30.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":17230806,"change_date":"2025-12-01 21:39:00","inspection_id":"86444186","insp_unit_id":"210330795","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"TSY9456","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG5CY7EDFT5491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:37.000000Z","updated_at":"2025-12-05T10:01:19.000000Z"}]},{"id":9818333,"change_date":"2025-09-30 21:39:00","inspection_id":"85918616","dot_number":"2048081","report_state":"TX","report_number":"791A9DBA75","insp_date":"2025-09-23 00:00:00","insp_start_time":"1020","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE STEEL SUPPLY INC","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-09-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9710233","transaction_code":"A","transaction_date":"2025-09-30 00:00:00","upload_date":"2025-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2025-09-30 21:39:00","snet_input_date":"2025-09-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-30 21:39:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-10-03T10:01:53.000000Z","updated_at":"2025-10-04T10:01:03.000000Z","inspection_violations":[{"id":16157619,"change_date":"2025-09-30 21:39:00","inspection_id":"85918616","insp_violation_id":"269011978","seq_no":"1","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"209224701","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-03T10:18:05.000000Z","updated_at":"2025-10-04T10:16:56.000000Z","normalized_code":"39330"}],"inspection_per_units":[{"id":16276422,"change_date":"2025-09-30 21:39:00","inspection_id":"85918616","insp_unit_id":"209224701","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"TSY9456","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG5CY7EDFT5491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-03T09:47:25.000000Z","updated_at":"2025-10-04T09:46:25.000000Z"}]},{"id":9251277,"change_date":"2025-07-25 21:40:00","inspection_id":"85323087","dot_number":"2048081","report_state":"TX","report_number":"77B89DJM7V","insp_date":"2025-07-23 00:00:00","insp_start_time":"0812","insp_end_time":"0910","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0249 IN HARRIS CO. (450-470","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE STEEL SUPPLY","shipping_paper_number":"12548","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-07-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9647817","transaction_code":"A","transaction_date":"2025-07-25 00:00:00","upload_date":"2025-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2025-07-25 21:40:00","snet_input_date":"2025-07-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-25 21:40:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-07-30T10:01:23.000000Z","updated_at":"2025-07-30T10:01:23.000000Z","inspection_violations":[{"id":14983423,"change_date":"2025-07-25 21:40:00","inspection_id":"85323087","insp_violation_id":"267661911","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208086769","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:51.000000Z","updated_at":"2025-07-29T10:43:48.000000Z","normalized_code":"39347E"},{"id":14983424,"change_date":"2025-07-25 21:40:00","inspection_id":"85323087","insp_violation_id":"267661912","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208086769","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:51.000000Z","updated_at":"2025-07-29T10:43:48.000000Z","normalized_code":"39347E"},{"id":14983425,"change_date":"2025-07-25 21:40:00","inspection_id":"85323087","insp_violation_id":"267661913","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208086769","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:51.000000Z","updated_at":"2025-07-29T10:43:48.000000Z","normalized_code":"3939"},{"id":14983426,"change_date":"2025-07-25 21:40:00","inspection_id":"85323087","insp_violation_id":"267661914","seq_no":"5","part_no":"393","part_no_section":"201D","insp_viol_unit":"1","insp_unit_id":"208086769","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:51.000000Z","updated_at":"2025-07-29T10:43:48.000000Z","normalized_code":"393201D"},{"id":14983427,"change_date":"2025-07-25 21:40:00","inspection_id":"85323087","insp_violation_id":"267661915","seq_no":"3","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"208086769","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-28T10:49:51.000000Z","updated_at":"2025-07-29T10:43:48.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":15225158,"change_date":"2025-07-25 21:40:00","inspection_id":"85323087","insp_unit_id":"208086769","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"TSY9456","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG5CY7EDFT5491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-28T09:46:37.000000Z","updated_at":"2025-07-29T09:46:06.000000Z"}]},{"id":9289061,"change_date":"2025-07-30 21:40:00","inspection_id":"85363036","dot_number":"2048081","report_state":"TX","report_number":"77BF9DCN1P","insp_date":"2025-07-23 00:00:00","insp_start_time":"1534","insp_end_time":"1550","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9700  NORTH FWY S\/R","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-07-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"9651101","transaction_code":"A","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2025-07-30 21:40:00","snet_input_date":"2025-07-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-30 21:40:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-08-04T10:01:15.000000Z","updated_at":"2025-08-04T10:01:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15293578,"change_date":"2025-07-30 21:40:00","inspection_id":"85363036","insp_unit_id":"208160973","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"TSR6522","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS5DHFJ0477","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-02T09:46:28.000000Z","updated_at":"2025-08-03T09:46:02.000000Z"}]},{"id":8898347,"change_date":"2025-06-13 21:41:00","inspection_id":"84951037","dot_number":"2048081","report_state":"TX","report_number":"76599DIA32","insp_date":"2025-06-11 00:00:00","insp_start_time":"0902","insp_end_time":"0929","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6200 N SHEPHERD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE STEEL SUPPLY","shipping_paper_number":"12369","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-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9606361","transaction_code":"A","transaction_date":"2025-06-13 00:00:00","upload_date":"2025-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2025-06-13 21:41:00","snet_input_date":"2025-06-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-13 21:41:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-06-16T10:01:15.000000Z","updated_at":"2025-06-17T10:00:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14577955,"change_date":"2025-06-13 21:41:00","inspection_id":"84951037","insp_unit_id":"207384527","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"WMT7295","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY9FDGK3912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-16T09:46:42.000000Z","updated_at":"2025-06-17T09:46:02.000000Z"}]},{"id":8345140,"change_date":"2025-04-10 21:42:00","inspection_id":"84367041","dot_number":"2048081","report_state":"TX","report_number":"74889DBS2Q","insp_date":"2025-04-03 00:00:00","insp_start_time":"0811","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SER","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WATCO GREENSPORT INDUSTRIES","shipping_paper_number":"12048","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-04-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9546057","transaction_code":"A","transaction_date":"2025-04-10 00:00:00","upload_date":"2025-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2025-04-10 21:42:00","snet_input_date":"2025-04-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-10 21:42:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-04-14T10:28:36.000000Z","updated_at":"2025-04-14T10:28:36.000000Z","inspection_violations":[{"id":13140293,"change_date":"2025-04-10 21:42:00","inspection_id":"84367041","insp_violation_id":"265551990","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"206252653","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-12T11:00:42.000000Z","updated_at":"2025-04-13T10:53:53.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":13538485,"change_date":"2025-04-10 21:42:00","inspection_id":"84367041","insp_unit_id":"206252653","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"SGY1865","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY9FDGK3912","insp_unit_decal":"Y","insp_unit_decal_number":"35128461","created_at":"2025-04-13T10:20:21.000000Z","updated_at":"2025-04-14T10:06:23.000000Z"}]},{"id":7607582,"change_date":"2025-01-13 21:46:00","inspection_id":"83591842","dot_number":"2048081","report_state":"TX","report_number":"71U79DGT0V","insp_date":"2025-01-07 00:00:00","insp_start_time":"0745","insp_end_time":"0808","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1300  CARROLL OLIVER","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-01-13 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"9471749","transaction_code":"A","transaction_date":"2025-01-13 00:00:00","upload_date":"2025-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2025-01-13 21:46:00","snet_input_date":"2025-01-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-13 21:46:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T20:56:07.000000Z","updated_at":"2025-03-17T20:56:07.000000Z","inspection_violations":[{"id":11892618,"change_date":"2025-01-13 21:46:00","inspection_id":"83591842","insp_violation_id":"263913414","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204784735","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":12275371,"change_date":"2025-01-13 21:46:00","inspection_id":"83591842","insp_unit_id":"204784735","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"TSR6522","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS5DHFJ0477","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:30.000000Z","updated_at":"2025-03-17T23:50:30.000000Z"}]},{"id":7383051,"change_date":"2024-12-12 21:42:00","inspection_id":"83355971","dot_number":"2048081","report_state":"TX","report_number":"70N89DCPP7","insp_date":"2024-11-25 00:00:00","insp_start_time":"0830","insp_end_time":"0850","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":"2024-12-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9442791","transaction_code":"C","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2024-12-10 21:41:00","snet_input_date":"2024-11-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-10 21:41:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T20:50:16.000000Z","updated_at":"2025-03-17T20:50:16.000000Z","inspection_violations":[{"id":11534335,"change_date":"2024-12-12 21:42:00","inspection_id":"83355971","insp_violation_id":"263425400","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204351898","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:07.000000Z","updated_at":"2025-03-17T22:02:07.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":11909951,"change_date":"2024-12-12 21:42:00","inspection_id":"83355971","insp_unit_id":"204351898","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"TSR6522","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS5DHFJ0477","insp_unit_decal":"Y","insp_unit_decal_number":"34553467","created_at":"2025-03-17T23:46:29.000000Z","updated_at":"2025-03-17T23:46:29.000000Z"}]},{"id":7286839,"change_date":"2024-11-26 21:41:00","inspection_id":"83254565","dot_number":"2048081","report_state":"TX","report_number":"70JA9DGTYW","insp_date":"2024-11-21 00:00:00","insp_start_time":"1048","insp_end_time":"1121","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"12900  MARKET ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE STEEL SUPPLY","shipping_paper_number":"77689\/74504","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-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9437272","transaction_code":"A","transaction_date":"2024-11-26 00:00:00","upload_date":"2024-11-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2024-11-26 21:41:00","snet_input_date":"2024-11-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-26 21:41:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T20:48:08.000000Z","updated_at":"2025-03-17T20:48:08.000000Z","inspection_violations":[{"id":11392197,"change_date":"2024-11-26 21:41:00","inspection_id":"83254565","insp_violation_id":"263109536","seq_no":"1","part_no":"393","part_no_section":"104C","insp_viol_unit":"1","insp_unit_id":"204072328","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:19.000000Z","updated_at":"2025-03-17T22:01:19.000000Z","normalized_code":"393104C"},{"id":11392198,"change_date":"2024-11-26 21:41:00","inspection_id":"83254565","insp_violation_id":"263109537","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"204072328","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:19.000000Z","updated_at":"2025-03-17T22:01:19.000000Z","normalized_code":"39311"},{"id":11392199,"change_date":"2024-11-26 21:41:00","inspection_id":"83254565","insp_violation_id":"263109538","seq_no":"3","part_no":"393","part_no_section":"50B","insp_viol_unit":"1","insp_unit_id":"204072328","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:19.000000Z","updated_at":"2025-03-17T22:01:19.000000Z","normalized_code":"39350B"}],"inspection_per_units":[{"id":11753911,"change_date":"2024-11-26 21:41:00","inspection_id":"83254565","insp_unit_id":"204072328","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3A","insp_unit_license":"SGY1685","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY9FDGK3912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:49.000000Z","updated_at":"2025-03-17T23:44:49.000000Z"}]},{"id":7104396,"change_date":"2024-11-04 21:40:00","inspection_id":"83061592","dot_number":"2048081","report_state":"TX","report_number":"6ZX99DJVSQ","insp_date":"2024-10-30 00:00:00","insp_start_time":"0932","insp_end_time":"1006","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","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-11-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"9416746","transaction_code":"C","transaction_date":"2024-11-01 00:00:00","upload_date":"2024-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2024-11-01 21:40:00","snet_input_date":"2024-10-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-01 21:40:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T20:44:15.000000Z","updated_at":"2025-03-17T20:44:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11458110,"change_date":"2024-11-04 21:40:00","inspection_id":"83061592","insp_unit_id":"203725448","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"TSR6522","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS5DHFJ0477","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:39.000000Z","updated_at":"2025-03-17T23:41:39.000000Z"}]},{"id":6760268,"change_date":"2024-09-18 21:43:00","inspection_id":"82695717","dot_number":"2048081","report_state":"TX","report_number":"6YP89DCPLT","insp_date":"2024-09-16 00:00:00","insp_start_time":"0810","insp_end_time":"0835","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":"2024-09-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9379989","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2024-09-18 21:43:00","snet_input_date":"2024-09-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-18 21:43:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T20:37:17.000000Z","updated_at":"2025-03-17T20:37:17.000000Z","inspection_violations":[{"id":10526864,"change_date":"2024-09-18 21:43:00","inspection_id":"82695717","insp_violation_id":"261901119","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"203011022","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"39311"},{"id":10526865,"change_date":"2024-09-18 21:43:00","inspection_id":"82695717","insp_violation_id":"261901120","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"203011022","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"39311"},{"id":10526866,"change_date":"2024-09-18 21:43:00","inspection_id":"82695717","insp_violation_id":"261901121","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203011022","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10901233,"change_date":"2024-09-18 21:43:00","inspection_id":"82695717","insp_unit_id":"203011022","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"SGY1685","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY9FDGK3912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:56.000000Z","updated_at":"2025-03-17T23:35:56.000000Z"}]},{"id":6517358,"change_date":"2024-08-20 21:43:00","inspection_id":"82437156","dot_number":"2048081","report_state":"TX","report_number":"6XUA9DCAMQ","insp_date":"2024-08-16 00:00:00","insp_start_time":"1037","insp_end_time":"1115","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-08-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9355542","transaction_code":"A","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2024-08-20 21:43:00","snet_input_date":"2024-08-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-20 21:43:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T20:32:00.000000Z","updated_at":"2025-03-17T20:32:00.000000Z","inspection_violations":[{"id":10123464,"change_date":"2024-08-20 21:43:00","inspection_id":"82437156","insp_violation_id":"261301637","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202492434","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"3939A"},{"id":10123465,"change_date":"2024-08-20 21:43:00","inspection_id":"82437156","insp_violation_id":"261301638","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"202492434","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":10506353,"change_date":"2024-08-20 21:43:00","inspection_id":"82437156","insp_unit_id":"202492434","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"SGY1685","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY9FDGK3912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:50.000000Z","updated_at":"2025-03-17T23:31:50.000000Z"}]},{"id":6467438,"change_date":"2024-08-14 21:39:00","inspection_id":"82383879","dot_number":"2048081","report_state":"TX","report_number":"6XG89DCALR","insp_date":"2024-08-02 00:00:00","insp_start_time":"0830","insp_end_time":"0916","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SER","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-08-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9349704","transaction_code":"A","transaction_date":"2024-08-14 00:00:00","upload_date":"2024-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2024-08-14 21:39:00","snet_input_date":"2024-08-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-14 21:39:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T20:31:06.000000Z","updated_at":"2025-03-17T20:31:06.000000Z","inspection_violations":[{"id":10044109,"change_date":"2024-08-14 21:39:00","inspection_id":"82383879","insp_violation_id":"261192111","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202392085","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:37.000000Z","updated_at":"2025-03-17T21:54:37.000000Z","normalized_code":"3963A1"},{"id":10044110,"change_date":"2024-08-14 21:39:00","inspection_id":"82383879","insp_violation_id":"261192112","seq_no":"2","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"202392085","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:37.000000Z","updated_at":"2025-03-17T21:54:37.000000Z","normalized_code":"393205C"},{"id":10044111,"change_date":"2024-08-14 21:39:00","inspection_id":"82383879","insp_violation_id":"261192113","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202392085","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:37.000000Z","updated_at":"2025-03-17T21:54:37.000000Z","normalized_code":"3922"},{"id":10044112,"change_date":"2024-08-14 21:39:00","inspection_id":"82383879","insp_violation_id":"261192114","seq_no":"4","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"202392085","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:37.000000Z","updated_at":"2025-03-17T21:54:37.000000Z","normalized_code":"393203C"},{"id":10044113,"change_date":"2024-08-14 21:39:00","inspection_id":"82383879","insp_violation_id":"261192115","seq_no":"5","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"202392085","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:54:37.000000Z","updated_at":"2025-03-17T21:54:37.000000Z","normalized_code":"3929A2"},{"id":10044114,"change_date":"2024-08-14 21:39:00","inspection_id":"82383879","insp_violation_id":"261192116","seq_no":"6","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"202392085","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:37.000000Z","updated_at":"2025-03-17T21:54:37.000000Z","normalized_code":"39348A"},{"id":10044115,"change_date":"2024-08-14 21:39:00","inspection_id":"82383879","insp_violation_id":"261192117","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202392085","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:54:37.000000Z","updated_at":"2025-03-17T21:54:37.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10424542,"change_date":"2024-08-14 21:39:00","inspection_id":"82383879","insp_unit_id":"202392085","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"TRAB","insp_unit_company":"FREIGHT","insp_unit_license":"TSY9456","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG5CY7EDFT5491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:00.000000Z","updated_at":"2025-03-17T23:31:00.000000Z"}]},{"id":6008829,"change_date":"2024-06-17 21:46:00","inspection_id":"81892081","dot_number":"2048081","report_state":"TX","report_number":"6VO79DCJ0G","insp_date":"2024-05-30 00:00:00","insp_start_time":"0758","insp_end_time":"0823","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"700 W GULF BANK RD","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-06-17 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9301414","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2024-06-17 21:46:00","snet_input_date":"2024-05-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-17 21:46:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T20:21:52.000000Z","updated_at":"2025-03-17T20:21:52.000000Z","inspection_violations":[{"id":9322809,"change_date":"2024-06-17 21:46:00","inspection_id":"81892081","insp_violation_id":"260150481","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"201449184","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39378"},{"id":9322810,"change_date":"2024-06-17 21:46:00","inspection_id":"81892081","insp_violation_id":"260150482","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201449184","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39347E"},{"id":9322811,"change_date":"2024-06-17 21:46:00","inspection_id":"81892081","insp_violation_id":"260150483","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"201449184","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":9678129,"change_date":"2024-06-17 21:46:00","inspection_id":"81892081","insp_unit_id":"201449184","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"TSY9456","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG5CY7EDFT5491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:18.000000Z","updated_at":"2025-03-17T23:23:18.000000Z"}]},{"id":4850583,"change_date":"2024-01-17 21:44:00","inspection_id":"80629772","dot_number":"2048081","report_state":"TX","report_number":"6RR89DCROD","insp_date":"2024-01-10 00:00:00","insp_start_time":"0802","insp_end_time":"0900","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","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-01-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"9175018","transaction_code":"A","transaction_date":"2024-01-17 00:00:00","upload_date":"2024-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2024-01-17 21:44:00","snet_input_date":"2024-01-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-17 21:44:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T19:58:50.000000Z","updated_at":"2025-03-17T19:58:50.000000Z","inspection_violations":[{"id":7478418,"change_date":"2024-01-17 21:44:00","inspection_id":"80629772","insp_violation_id":"257381928","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198999349","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:03.000000Z","updated_at":"2025-03-17T21:42:03.000000Z","normalized_code":"3922"},{"id":7478419,"change_date":"2024-01-17 21:44:00","inspection_id":"80629772","insp_violation_id":"257381929","seq_no":"2","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"198999349","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:42:03.000000Z","updated_at":"2025-03-17T21:42:03.000000Z","normalized_code":"3929A2"},{"id":7478420,"change_date":"2024-01-17 21:44:00","inspection_id":"80629772","insp_violation_id":"257381930","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"198999349","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:03.000000Z","updated_at":"2025-03-17T21:42:03.000000Z","normalized_code":"3965B"},{"id":7478421,"change_date":"2024-01-17 21:44:00","inspection_id":"80629772","insp_violation_id":"257381931","seq_no":"4","part_no":"393","part_no_section":"75(a)(4)","insp_viol_unit":"1","insp_unit_id":"198999349","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:03.000000Z","updated_at":"2025-03-17T21:42:03.000000Z","normalized_code":"39375A4"}],"inspection_per_units":[{"id":7804522,"change_date":"2024-01-17 21:44:00","inspection_id":"80629772","insp_unit_id":"198999349","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1L44135","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS5DHFJ0477","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:44.000000Z","updated_at":"2025-03-17T23:05:44.000000Z"}]},{"id":4840306,"change_date":"2024-01-16 21:45:00","inspection_id":"80618643","dot_number":"2048081","report_state":"TX","report_number":"6RQE9DCCEZ","insp_date":"2024-01-09 00:00:00","insp_start_time":"1440","insp_end_time":"1510","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9300  NORTH FWY SER","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WATCO GREENSPORT INDUSTRIAL","shipping_paper_number":"9131","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-16 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"9172722","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2024-01-16 21:45:00","snet_input_date":"2024-01-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-16 21:45:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T19:58:47.000000Z","updated_at":"2025-03-17T19:58:47.000000Z","inspection_violations":[{"id":7462294,"change_date":"2024-01-16 21:45:00","inspection_id":"80618643","insp_violation_id":"257355687","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198976128","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:01.000000Z","updated_at":"2025-03-17T21:42:01.000000Z","normalized_code":"3939A"},{"id":7462295,"change_date":"2024-01-16 21:45:00","inspection_id":"80618643","insp_violation_id":"257355688","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198976128","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:01.000000Z","updated_at":"2025-03-17T21:42:01.000000Z","normalized_code":"39375A3"},{"id":7462296,"change_date":"2024-01-16 21:45:00","inspection_id":"80618643","insp_violation_id":"257355689","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198976128","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:01.000000Z","updated_at":"2025-03-17T21:42:01.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":7787689,"change_date":"2024-01-16 21:45:00","inspection_id":"80618643","insp_unit_id":"198976128","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1L44135","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS5DHFJ0477","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:36.000000Z","updated_at":"2025-03-17T23:05:36.000000Z"}]},{"id":4287037,"change_date":"2023-10-25 21:42:00","inspection_id":"80010912","dot_number":"2048081","report_state":"TX","report_number":"6PKA9DBY3L","insp_date":"2023-10-23 00:00:00","insp_start_time":"1008","insp_end_time":"1039","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8900  NORTH FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARGOWAYS","shipping_paper_number":"273918","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-10-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9109613","transaction_code":"A","transaction_date":"2023-10-25 00:00:00","upload_date":"2023-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2023-10-25 21:42:00","snet_input_date":"2023-10-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-25 21:42:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T19:47:51.000000Z","updated_at":"2025-03-17T19:47:51.000000Z","inspection_violations":[{"id":6632740,"change_date":"2023-10-25 21:42:00","inspection_id":"80010912","insp_violation_id":"256051781","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197752138","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:56.000000Z","updated_at":"2025-03-17T21:37:56.000000Z","normalized_code":"3965B"},{"id":6632741,"change_date":"2023-10-25 21:42:00","inspection_id":"80010912","insp_violation_id":"256051782","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197752138","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:56.000000Z","updated_at":"2025-03-17T21:37:56.000000Z","normalized_code":"3939A"},{"id":6632742,"change_date":"2023-10-25 21:42:00","inspection_id":"80010912","insp_violation_id":"256051783","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197752138","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:56.000000Z","updated_at":"2025-03-17T21:37:56.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6894893,"change_date":"2023-10-25 21:42:00","inspection_id":"80010912","insp_unit_id":"197752138","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"SGY1685","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY9FDGK3912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:47.000000Z","updated_at":"2025-03-17T22:57:47.000000Z"}]},{"id":4274809,"change_date":"2023-10-24 21:40:00","inspection_id":"79997409","dot_number":"2048081","report_state":"TX","report_number":"6PGE9DBZTE","insp_date":"2023-10-19 00:00:00","insp_start_time":"1409","insp_end_time":"1423","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"500  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":"2023-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9108533","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2023-10-24 21:40:00","snet_input_date":"2023-10-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-24 21:40:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T19:47:28.000000Z","updated_at":"2025-03-17T19:47:28.000000Z","inspection_violations":[{"id":6612450,"change_date":"2023-10-24 21:40:00","inspection_id":"79997409","insp_violation_id":"256020419","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197726358","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6875229,"change_date":"2023-10-24 21:40:00","inspection_id":"79997409","insp_unit_id":"197726358","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"SGY1685","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY9FDGK3912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:40.000000Z","updated_at":"2025-03-17T22:57:40.000000Z"}]},{"id":4026084,"change_date":"2023-09-21 21:41:00","inspection_id":"79721721","dot_number":"2048081","report_state":"TX","report_number":"6OIE9DJVMZ","insp_date":"2023-09-15 00:00:00","insp_start_time":"1404","insp_end_time":"1429","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6500  GREENS 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":"2023-09-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"9080959","transaction_code":"A","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2023-09-21 21:41:00","snet_input_date":"2023-09-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-21 21:41:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T19:42:23.000000Z","updated_at":"2025-03-17T19:42:23.000000Z","inspection_violations":[{"id":6231807,"change_date":"2023-09-21 21:41:00","inspection_id":"79721721","insp_violation_id":"255407561","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197172525","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:04.000000Z","updated_at":"2025-03-17T21:36:04.000000Z","normalized_code":"3939A"},{"id":6231808,"change_date":"2023-09-21 21:41:00","inspection_id":"79721721","insp_violation_id":"255407562","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197172525","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:04.000000Z","updated_at":"2025-03-17T21:36:04.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":6473659,"change_date":"2023-09-21 21:41:00","inspection_id":"79721721","insp_unit_id":"197172525","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1L44135","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS5DHFJ0477","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:19.000000Z","updated_at":"2025-03-17T22:54:19.000000Z"}]},{"id":3336690,"change_date":"2023-06-21 21:43:00","inspection_id":"78950661","dot_number":"2048081","report_state":"TX","report_number":"6M2G9DCP03","insp_date":"2023-06-19 00:00:00","insp_start_time":"1608","insp_end_time":"1620","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5500  SONORA","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-06-21 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9010681","transaction_code":"A","transaction_date":"2023-06-21 00:00:00","upload_date":"2023-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2023-06-21 21:43:00","snet_input_date":"2023-06-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-21 21:43:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T19:28:57.000000Z","updated_at":"2025-03-17T19:28:57.000000Z","inspection_violations":[{"id":5145792,"change_date":"2023-06-21 21:43:00","inspection_id":"78950661","insp_violation_id":"253629829","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195611838","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5364605,"change_date":"2023-06-21 21:43:00","inspection_id":"78950661","insp_unit_id":"195611838","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"SGY1685","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY9FDGK3912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:18.000000Z","updated_at":"2025-03-17T22:45:18.000000Z"}]},{"id":2555660,"change_date":"2023-03-10 21:41:00","inspection_id":"78065969","dot_number":"2048081","report_state":"TX","report_number":"6J6C0VHE8P","insp_date":"2023-03-07 00:00:00","insp_start_time":"1240","insp_end_time":"1258","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE STEEL","shipping_paper_number":"62928","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":"N","pen_cen_match":null,"final_status_date":"2023-03-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8926186","transaction_code":"A","transaction_date":"2023-03-10 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2023-03-10 21:41:00","snet_input_date":"2023-03-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-10 21:41:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T19:13:44.000000Z","updated_at":"2025-03-17T19:13:44.000000Z","inspection_violations":[{"id":3931665,"change_date":"2023-03-10 21:41:00","inspection_id":"78065969","insp_violation_id":"251604609","seq_no":"1","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"193820732","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39395B"},{"id":3931666,"change_date":"2023-03-10 21:41:00","inspection_id":"78065969","insp_violation_id":"251604610","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193820733","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"3939A"},{"id":3931667,"change_date":"2023-03-10 21:41:00","inspection_id":"78065969","insp_violation_id":"251604611","seq_no":"3","part_no":"392","part_no_section":"8","insp_viol_unit":"1","insp_unit_id":"193820732","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"3928"},{"id":3931668,"change_date":"2023-03-10 21:41:00","inspection_id":"78065969","insp_violation_id":"251604612","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193820733","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4113665,"change_date":"2023-03-10 21:41:00","inspection_id":"78065969","insp_unit_id":"193820732","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1L36315","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF5GT8BEC48737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:29.000000Z","updated_at":"2025-03-17T22:35:29.000000Z"},{"id":4113666,"change_date":"2023-03-10 21:41:00","inspection_id":"78065969","insp_unit_id":"193820733","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KEAR","insp_unit_company":null,"insp_unit_license":"091B309","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5LCFT2728E1035680","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:29.000000Z","updated_at":"2025-03-17T22:35:29.000000Z"}]},{"id":2328670,"change_date":"2023-02-08 21:40:00","inspection_id":"77807204","dot_number":"2048081","report_state":"TX","report_number":"6IAB9DGTOO","insp_date":"2023-02-03 00:00:00","insp_start_time":"1103","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1100  KEYPORT LN","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-02-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"8898807","transaction_code":"A","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2023-02-08 21:40:00","snet_input_date":"2023-02-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-08 21:40:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T19:09:37.000000Z","updated_at":"2025-03-17T19:09:37.000000Z","inspection_violations":[{"id":3587226,"change_date":"2023-02-08 21:40:00","inspection_id":"77807204","insp_violation_id":"251026063","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":3747843,"change_date":"2023-02-08 21:40:00","inspection_id":"77807204","insp_unit_id":"193301110","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3A","insp_unit_license":"SGY1685","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY9FDGK3912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:50.000000Z","updated_at":"2025-03-17T22:32:50.000000Z"}]},{"id":2011112,"change_date":"2022-12-23 21:33:00","inspection_id":"77444724","dot_number":"2048081","report_state":"TX","report_number":"6H399DBY20","insp_date":"2022-12-22 00:00:00","insp_start_time":"0901","insp_end_time":"0931","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10400  GULF FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE STEEL SUPPLY","shipping_paper_number":"64408","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":"2022-12-23 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"8860344","transaction_code":"A","transaction_date":"2022-12-23 00:00:00","upload_date":"2022-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2022-12-23 21:33:00","snet_input_date":"2022-12-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-23 21:33:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T19:03:41.000000Z","updated_at":"2025-03-17T19:03:41.000000Z","inspection_violations":[{"id":3121819,"change_date":"2022-12-23 21:33:00","inspection_id":"77444724","insp_violation_id":"250257968","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"192571725","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:49.000000Z","updated_at":"2025-03-17T21:21:49.000000Z","normalized_code":"39347E"},{"id":3121820,"change_date":"2022-12-23 21:33:00","inspection_id":"77444724","insp_violation_id":"250257969","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"192571725","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:49.000000Z","updated_at":"2025-03-17T21:21:49.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":3235451,"change_date":"2022-12-23 21:33:00","inspection_id":"77444724","insp_unit_id":"192571725","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"SGY1685","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY9FDGK3912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:10.000000Z","updated_at":"2025-03-17T22:29:10.000000Z"}]},{"id":1824799,"change_date":"2022-11-28 21:41:00","inspection_id":"77231809","dot_number":"2048081","report_state":"TX","report_number":"6G1E9DBZ9S","insp_date":"2022-11-14 00:00:00","insp_start_time":"1414","insp_end_time":"1425","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"600  DE WALT ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE STEEL","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":"2022-11-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"8836062","transaction_code":"A","transaction_date":"2022-11-28 00:00:00","upload_date":"2022-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2022-11-28 21:41:00","snet_input_date":"2022-11-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-28 21:41:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T19:00:19.000000Z","updated_at":"2025-03-17T19:00:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2936026,"change_date":"2022-11-28 21:41:00","inspection_id":"77231809","insp_unit_id":"192151518","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1L44135","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS5DHFJ0477","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:06.000000Z","updated_at":"2025-03-17T22:27:06.000000Z"}]},{"id":1149675,"change_date":"2022-09-07 21:41:00","inspection_id":"76452341","dot_number":"2048081","report_state":"TX","report_number":"6DJ99DCG8N","insp_date":"2022-08-16 00:00:00","insp_start_time":"0945","insp_end_time":"1005","registration_date":"2022-09-07 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"12100  HEMPSTEAD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE STEEL","shipping_paper_number":"59774","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":"2022-08-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"41500","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":"8754252","transaction_code":"C","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":"M","census_search_date":"2022-08-26 21:40:00","snet_input_date":"2022-08-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-26 21:40:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T18:47:55.000000Z","updated_at":"2025-03-17T18:47:55.000000Z","inspection_violations":[{"id":1822042,"change_date":"2022-09-07 21:41:00","inspection_id":"76452341","insp_violation_id":"248266128","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190771997","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"39617C"},{"id":1822043,"change_date":"2022-09-07 21:41:00","inspection_id":"76452341","insp_violation_id":"248266129","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190771997","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"3922"},{"id":1822044,"change_date":"2022-09-07 21:41:00","inspection_id":"76452341","insp_violation_id":"248266130","seq_no":"3","part_no":"392","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"190771998","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"3929"},{"id":1822045,"change_date":"2022-09-07 21:41:00","inspection_id":"76452341","insp_violation_id":"248266131","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"190771998","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":1848375,"change_date":"2022-09-07 21:41:00","inspection_id":"76452341","insp_unit_id":"190771997","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1L36315","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF5GT8BEC48737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:44.000000Z","updated_at":"2025-03-17T22:19:44.000000Z"},{"id":1848376,"change_date":"2022-09-07 21:41:00","inspection_id":"76452341","insp_unit_id":"190771998","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KEAR","insp_unit_company":null,"insp_unit_license":"091B309","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5LCFT2728E1035680","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:44.000000Z","updated_at":"2025-03-17T22:19:44.000000Z"}]},{"id":56349,"change_date":"2022-03-31 21:41:00","inspection_id":"75157182","dot_number":"2048081","report_state":"TX","report_number":"69IA9DBFKE","insp_date":"2022-03-24 00:00:00","insp_start_time":"1031","insp_end_time":"1112","registration_date":"2022-03-31 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","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":"2022-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"8603145","transaction_code":"C","transaction_date":"2022-03-28 00:00:00","upload_date":"2022-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02048081","upload_search_indicator":null,"census_search_date":"2022-03-28 21:41:00","snet_input_date":"2022-03-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-03-28 21:41:00","insp_carrier_name":"ACE STEEL SUPPLY INC","insp_carrier_street":"203 BLUE BELL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257205","created_at":"2025-03-17T18:28:28.000000Z","updated_at":"2025-03-17T18:28:28.000000Z","inspection_violations":[{"id":81144,"change_date":"2022-03-31 21:41:00","inspection_id":"75157182","insp_violation_id":"244899437","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"187929772","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:30.000000Z","updated_at":"2025-03-17T21:07:30.000000Z","normalized_code":"3939A"},{"id":81145,"change_date":"2022-03-31 21:41:00","inspection_id":"75157182","insp_violation_id":"244899438","seq_no":"2","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"187929772","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:07:30.000000Z","updated_at":"2025-03-17T21:07:30.000000Z","normalized_code":"39341"},{"id":81146,"change_date":"2022-03-31 21:41:00","inspection_id":"75157182","insp_violation_id":"244899439","seq_no":"3","part_no":"393","part_no_section":"75(a)(4)","insp_viol_unit":"2","insp_unit_id":"187929773","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:30.000000Z","updated_at":"2025-03-17T21:07:30.000000Z","normalized_code":"39375A4"},{"id":81147,"change_date":"2022-03-31 21:41:00","inspection_id":"75157182","insp_violation_id":"244899440","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"187929772","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:30.000000Z","updated_at":"2025-03-17T21:07:30.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":91622,"change_date":"2022-03-31 21:41:00","inspection_id":"75157182","insp_unit_id":"187929772","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2","insp_unit_license":"1L36315","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF5GT8BEC48737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:48.000000Z","updated_at":"2025-03-17T22:08:48.000000Z"},{"id":91623,"change_date":"2022-03-31 21:41:00","inspection_id":"75157182","insp_unit_id":"187929773","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KEAR","insp_unit_company":"5","insp_unit_license":"037B196","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5LCFT3628F1037129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:48.000000Z","updated_at":"2025-03-17T22:08:48.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2048081\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2048081\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2048081\/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\/2048081\/inspections","per_page":100,"prev_page_url":null,"to":30,"total":30}