{"current_page":1,"data":[{"id":8912275,"change_date":"2025-06-16 21:40:00","inspection_id":"84965908","dot_number":"2047542","report_state":"TX","report_number":"V251913111","insp_date":"2025-06-13 00:00:00","insp_start_time":"0850","insp_end_time":"0929","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I-10 MP 790","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"A L TRUCKING","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-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"2","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9608232","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-06-19T10:00:25.000000Z","updated_at":"2025-06-20T10:00:36.000000Z","inspection_violations":[{"id":14292114,"change_date":"2025-06-16 21:40:00","inspection_id":"84965908","insp_violation_id":"266872751","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:39.000000Z","updated_at":"2025-06-20T10:16:06.000000Z","normalized_code":"38323A2"},{"id":14292115,"change_date":"2025-06-16 21:40:00","inspection_id":"84965908","insp_violation_id":"266872752","seq_no":"2","part_no":"391","part_no_section":"11B4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:39.000000Z","updated_at":"2025-06-20T10:16:06.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":14602518,"change_date":"2025-06-16 21:40:00","inspection_id":"84965908","insp_unit_id":"207411799","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"1M19560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:47.000000Z"}]},{"id":8649058,"change_date":"2025-05-15 21:44:00","inspection_id":"84687060","dot_number":"2047542","report_state":"TX","report_number":"75889DGABQ","insp_date":"2025-05-09 00:00:00","insp_start_time":"0854","insp_end_time":"0932","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4000  MULDOON PKWY E","county_code_state":"TX","county_code":"167","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-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","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":"9578566","transaction_code":"A","transaction_date":"2025-05-15 00:00:00","upload_date":"2025-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2025-05-15 21:44:00","snet_input_date":"2025-05-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-15 21:44:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-05-18T10:04:42.000000Z","updated_at":"2025-05-19T10:06:39.000000Z","inspection_violations":[{"id":13761960,"change_date":"2025-05-15 21:44:00","inspection_id":"84687060","insp_violation_id":"266260974","seq_no":"1","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"206890259","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:32:22.000000Z","updated_at":"2025-05-19T10:33:10.000000Z","normalized_code":"3965B"},{"id":13761962,"change_date":"2025-05-15 21:44:00","inspection_id":"84687060","insp_violation_id":"266260976","seq_no":"3","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"206890259","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:32:22.000000Z","updated_at":"2025-05-19T10:33:10.000000Z","normalized_code":"39021A"},{"id":13761961,"change_date":"2025-05-15 21:44:00","inspection_id":"84687060","insp_violation_id":"266260975","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"206890260","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:32:22.000000Z","updated_at":"2025-05-19T10:33:10.000000Z","normalized_code":"3939"},{"id":13761963,"change_date":"2025-05-15 21:44:00","inspection_id":"84687060","insp_violation_id":"266260977","seq_no":"4","part_no":"393","part_no_section":"45DLPC","insp_viol_unit":"2","insp_unit_id":"206890260","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:32:22.000000Z","updated_at":"2025-05-19T10:33:10.000000Z","normalized_code":"39345DLPC"}],"inspection_per_units":[{"id":14125416,"change_date":"2025-05-15 21:44:00","inspection_id":"84687060","insp_unit_id":"206890259","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"V-009","insp_unit_license":"1M06680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPFDB9X24D832009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-18T09:50:27.000000Z","updated_at":"2025-05-19T09:52:39.000000Z"},{"id":14125417,"change_date":"2025-05-15 21:44:00","inspection_id":"84687060","insp_unit_id":"206890260","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"V-120","insp_unit_license":"15997L","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1A1V29203F16PT120","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-18T09:50:27.000000Z","updated_at":"2025-05-19T09:52:39.000000Z"}]},{"id":8169481,"change_date":"2025-03-20 21:42:00","inspection_id":"84182118","dot_number":"2047542","report_state":"TX","report_number":"73P79DJV3P","insp_date":"2025-03-15 00:00:00","insp_start_time":"0738","insp_end_time":"0810","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":"2025-03-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9527647","transaction_code":"A","transaction_date":"2025-03-20 00:00:00","upload_date":"2025-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2025-03-20 21:42:00","snet_input_date":"2025-03-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-20 21:42:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-23T10:52:51.000000Z","updated_at":"2025-03-24T10:26:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13203723,"change_date":"2025-03-20 21:42:00","inspection_id":"84182118","insp_unit_id":"205910655","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"1M19560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:17:27.000000Z","updated_at":"2025-03-24T10:06:27.000000Z"}]},{"id":7673598,"change_date":"2025-01-21 21:40:00","inspection_id":"83661134","dot_number":"2047542","report_state":"TX","report_number":"724C9DJW0R","insp_date":"2025-01-17 00:00:00","insp_start_time":"1205","insp_end_time":"1230","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNK","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-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9477725","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2025-01-21 21:40:00","snet_input_date":"2025-01-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-21 21:40:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T20:57:28.000000Z","updated_at":"2025-03-17T20:57:28.000000Z","inspection_violations":[{"id":11989752,"change_date":"2025-01-21 21:40:00","inspection_id":"83661134","insp_violation_id":"264104339","seq_no":"1","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"204938186","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":12382327,"change_date":"2025-01-21 21:40:00","inspection_id":"83661134","insp_unit_id":"204938186","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1M06680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPFDB9X24D832009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:39.000000Z","updated_at":"2025-03-17T23:51:39.000000Z"}]},{"id":7451112,"change_date":"2024-12-18 21:41:00","inspection_id":"83427426","dot_number":"2047542","report_state":"TX","report_number":"V241478195","insp_date":"2024-12-09 00:00:00","insp_start_time":"1200","insp_end_time":"1335","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 242 NEAR SPEED ST","county_code_state":"TX","county_code":"339","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AL TRUCKING","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":"2024-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9454210","transaction_code":"A","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2024-12-18 21:41:00","snet_input_date":"2024-12-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-18 21:41:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T20:51:33.000000Z","updated_at":"2025-03-17T20:51:33.000000Z","inspection_violations":[{"id":11643398,"change_date":"2024-12-18 21:41:00","inspection_id":"83427426","insp_violation_id":"263549192","seq_no":"1","part_no":"393","part_no_section":"45PC","insp_viol_unit":"1","insp_unit_id":"204458553","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"39345PC"},{"id":11643399,"change_date":"2024-12-18 21:41:00","inspection_id":"83427426","insp_violation_id":"263549193","seq_no":"2","part_no":"393","part_no_section":"45PC","insp_viol_unit":"1","insp_unit_id":"204458553","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"39345PC"},{"id":11643400,"change_date":"2024-12-18 21:41:00","inspection_id":"83427426","insp_violation_id":"263549194","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204458553","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"39347E"},{"id":11643401,"change_date":"2024-12-18 21:41:00","inspection_id":"83427426","insp_violation_id":"263549195","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204458553","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"39347E"},{"id":11643402,"change_date":"2024-12-18 21:41:00","inspection_id":"83427426","insp_violation_id":"263549196","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204458553","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3939"},{"id":11643403,"change_date":"2024-12-18 21:41:00","inspection_id":"83427426","insp_violation_id":"263549197","seq_no":"6","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"204458553","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3939TS"},{"id":11643404,"change_date":"2024-12-18 21:41:00","inspection_id":"83427426","insp_violation_id":"263549198","seq_no":"7","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"204458553","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3963A1B"},{"id":11643405,"change_date":"2024-12-18 21:41:00","inspection_id":"83427426","insp_violation_id":"263549199","seq_no":"8","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"204458553","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3963A1"},{"id":11643406,"change_date":"2024-12-18 21:41:00","inspection_id":"83427426","insp_violation_id":"263549200","seq_no":"9","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"204458553","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3963A1BOS"},{"id":11643407,"change_date":"2024-12-18 21:41:00","inspection_id":"83427426","insp_violation_id":"263549201","seq_no":"10","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"204458553","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":12020476,"change_date":"2024-12-18 21:41:00","inspection_id":"83427426","insp_unit_id":"204458553","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1","insp_unit_license":"1M06680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPFDB9X24D832009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:43.000000Z","updated_at":"2025-03-17T23:47:43.000000Z"},{"id":12020477,"change_date":"2024-12-18 21:41:00","inspection_id":"83427426","insp_unit_id":"204458554","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONT","insp_unit_company":"1","insp_unit_license":"15997L","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1A1V29203F16PT120","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:43.000000Z","updated_at":"2025-03-17T23:47:43.000000Z"}]},{"id":7186054,"change_date":"2024-11-14 21:41:00","inspection_id":"83148091","dot_number":"2047542","report_state":"TX","report_number":"V241676097","insp_date":"2024-11-12 00:00:00","insp_start_time":"0826","insp_end_time":"0848","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH45 SB @ SH 96","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ARCOSA","shipping_paper_number":"1362024574","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-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9427094","transaction_code":"C","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2024-11-13 21:40:00","snet_input_date":"2024-11-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-13 21:40:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T20:46:00.000000Z","updated_at":"2025-03-17T20:46:00.000000Z","inspection_violations":[{"id":11230441,"change_date":"2024-11-14 21:41:00","inspection_id":"83148091","insp_violation_id":"262898131","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"203883843","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":11590864,"change_date":"2024-11-14 21:41:00","inspection_id":"83148091","insp_unit_id":"203883843","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"1M19560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:07.000000Z","updated_at":"2025-03-17T23:43:07.000000Z"},{"id":11590865,"change_date":"2024-11-14 21:41:00","inspection_id":"83148091","insp_unit_id":"203883844","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"179B547","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1C9DB12B0VM110024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:07.000000Z","updated_at":"2025-03-17T23:43:07.000000Z"}]},{"id":6990974,"change_date":"2024-10-18 21:42:00","inspection_id":"82941240","dot_number":"2047542","report_state":"TX","report_number":"6ZI89DGBKR","insp_date":"2024-10-15 00:00:00","insp_start_time":"0953","insp_end_time":"1019","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1100  BALLPARK WAY","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9405420","transaction_code":"A","transaction_date":"2024-10-18 00:00:00","upload_date":"2024-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2024-10-18 21:42:00","snet_input_date":"2024-10-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-18 21:42:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T20:41:48.000000Z","updated_at":"2025-03-17T20:41:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11275970,"change_date":"2024-10-18 21:42:00","inspection_id":"82941240","insp_unit_id":"203477131","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"1M19560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:46.000000Z","updated_at":"2025-03-17T23:39:46.000000Z"},{"id":11275971,"change_date":"2024-10-18 21:42:00","inspection_id":"82941240","insp_unit_id":"203477132","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"0000","insp_unit_license":"179B547","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1C9DB12B0VM110024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:46.000000Z","updated_at":"2025-03-17T23:39:46.000000Z"}]},{"id":4767203,"change_date":"2024-12-09 21:41:00","inspection_id":"80538609","dot_number":"2047542","report_state":"TX","report_number":"6R679DGAW2","insp_date":"2023-12-20 00:00:00","insp_start_time":"0834","insp_end_time":"0923","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2900  CALDER DR SB","county_code_state":"TX","county_code":"167","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-01-04 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"85280","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":"9165282","transaction_code":"C","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2024-01-04 21:47:00","snet_input_date":"2023-12-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-04 21:47:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T19:57:15.000000Z","updated_at":"2025-03-17T19:57:15.000000Z","inspection_violations":[{"id":7356234,"change_date":"2024-12-09 21:41:00","inspection_id":"80538609","insp_violation_id":"263334428","seq_no":"1","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"204273435","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:30.000000Z","updated_at":"2025-03-17T21:41:30.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":7669192,"change_date":"2024-12-09 21:41:00","inspection_id":"80538609","insp_unit_id":"204273434","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"V-575","insp_unit_license":"1M19560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:32.000000Z","updated_at":"2025-03-17T23:04:32.000000Z"},{"id":7669193,"change_date":"2024-12-09 21:41:00","inspection_id":"80538609","insp_unit_id":"204273435","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"V-024","insp_unit_license":"179B547","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1C9DB12B0VM110024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:32.000000Z","updated_at":"2025-03-17T23:04:32.000000Z"}]},{"id":4026662,"change_date":"2023-09-21 21:41:00","inspection_id":"79722348","dot_number":"2047542","report_state":"TX","report_number":"6OO49DJVNP","insp_date":"2023-09-21 00:00:00","insp_start_time":"0406","insp_end_time":"0432","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":"86000","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":"9081105","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":"02047542","upload_search_indicator":"M","census_search_date":"2023-09-21 21:41:00","snet_input_date":"2023-09-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-21 21:41:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T19:42:24.000000Z","updated_at":"2025-03-17T19:42:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6474630,"change_date":"2023-09-21 21:41:00","inspection_id":"79722348","insp_unit_id":"197174095","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M19560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","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":6474631,"change_date":"2023-09-21 21:41:00","inspection_id":"79722348","insp_unit_id":"197174096","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"179B547","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1C9DB12B0VM110024","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":3792423,"change_date":"2023-08-21 21:42:00","inspection_id":"79461515","dot_number":"2047542","report_state":"TX","report_number":"6NM79DBCL8","insp_date":"2023-08-14 00:00:00","insp_start_time":"0738","insp_end_time":"0805","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETT MATERIALS","shipping_paper_number":"2032290","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"12","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9056518","transaction_code":"A","transaction_date":"2023-08-21 00:00:00","upload_date":"2023-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2023-08-21 21:42:00","snet_input_date":"2023-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-21 21:42:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T19:37:42.000000Z","updated_at":"2025-03-17T19:37:42.000000Z","inspection_violations":[{"id":5849735,"change_date":"2023-08-21 21:42:00","inspection_id":"79461515","insp_violation_id":"254780119","seq_no":"1","part_no":"393","part_no_section":"26","insp_viol_unit":"1","insp_unit_id":"196643907","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39326"},{"id":5849736,"change_date":"2023-08-21 21:42:00","inspection_id":"79461515","insp_violation_id":"254780120","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"196643907","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39360C"},{"id":5849737,"change_date":"2023-08-21 21:42:00","inspection_id":"79461515","insp_violation_id":"254780121","seq_no":"3","part_no":"393","part_no_section":"203","insp_viol_unit":"1","insp_unit_id":"196643907","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"393203"},{"id":5849738,"change_date":"2023-08-21 21:42:00","inspection_id":"79461515","insp_violation_id":"254780122","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"196643908","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39311"},{"id":5849739,"change_date":"2023-08-21 21:42:00","inspection_id":"79461515","insp_violation_id":"254780123","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"196643908","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"3965B"},{"id":5849740,"change_date":"2023-08-21 21:42:00","inspection_id":"79461515","insp_violation_id":"254780124","seq_no":"6","part_no":"393","part_no_section":"70(c)","insp_viol_unit":"2","insp_unit_id":"196643908","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39370C"},{"id":5849741,"change_date":"2023-08-21 21:42:00","inspection_id":"79461515","insp_violation_id":"254780125","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"196643908","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39345B2"},{"id":5849742,"change_date":"2023-08-21 21:42:00","inspection_id":"79461515","insp_violation_id":"254780126","seq_no":"8","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196643907","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39345B2"},{"id":5849743,"change_date":"2023-08-21 21:42:00","inspection_id":"79461515","insp_violation_id":"254780127","seq_no":"9","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"196643907","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"393209E"},{"id":5849744,"change_date":"2023-08-21 21:42:00","inspection_id":"79461515","insp_violation_id":"254780128","seq_no":"10","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196643907","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39617C"},{"id":5849745,"change_date":"2023-08-21 21:42:00","inspection_id":"79461515","insp_violation_id":"254780129","seq_no":"11","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196643908","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39617C"},{"id":5849746,"change_date":"2023-08-21 21:42:00","inspection_id":"79461515","insp_violation_id":"254780130","seq_no":"12","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196643908","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6098005,"change_date":"2023-08-21 21:42:00","inspection_id":"79461515","insp_unit_id":"196643907","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"1M19560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:14.000000Z","updated_at":"2025-03-17T22:51:14.000000Z"},{"id":6098006,"change_date":"2023-08-21 21:42:00","inspection_id":"79461515","insp_unit_id":"196643908","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"179B547","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1C9DB12B0VM110024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:14.000000Z","updated_at":"2025-03-17T22:51:14.000000Z"}]},{"id":3215301,"change_date":"2023-06-05 21:43:00","inspection_id":"78813672","dot_number":"2047542","report_state":"TX","report_number":"6LJE9DCPYQ","insp_date":"2023-05-31 00:00:00","insp_start_time":"1420","insp_end_time":"1435","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3000  JEWEL","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-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"8995354","transaction_code":"A","transaction_date":"2023-06-05 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2023-06-05 21:43:00","snet_input_date":"2023-05-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-05 21:43:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T19:26:31.000000Z","updated_at":"2025-03-17T19:26:31.000000Z","inspection_violations":[{"id":4954900,"change_date":"2023-06-05 21:43:00","inspection_id":"78813672","insp_violation_id":"253292682","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195324136","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:03.000000Z","updated_at":"2025-03-17T21:30:03.000000Z","normalized_code":"3939A"},{"id":4954901,"change_date":"2023-06-05 21:43:00","inspection_id":"78813672","insp_violation_id":"253292683","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195324136","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:03.000000Z","updated_at":"2025-03-17T21:30:03.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5171240,"change_date":"2023-06-05 21:43:00","inspection_id":"78813672","insp_unit_id":"195324136","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1M06680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPFDB9X24D832009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:45.000000Z","updated_at":"2025-03-17T22:43:45.000000Z"}]},{"id":2229074,"change_date":"2023-01-25 21:43:00","inspection_id":"77694291","dot_number":"2047542","report_state":"TX","report_number":"6H8E9DBBXQ","insp_date":"2022-12-27 00:00:00","insp_start_time":"1417","insp_end_time":"1439","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"11000  KATY HOCKLEY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETT MATERIALS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-01-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8887297","transaction_code":"A","transaction_date":"2023-01-25 00:00:00","upload_date":"2023-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2023-01-25 21:43:00","snet_input_date":"2022-12-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-25 21:43:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T19:07:44.000000Z","updated_at":"2025-03-17T19:07:44.000000Z","inspection_violations":[{"id":3443842,"change_date":"2023-01-25 21:43:00","inspection_id":"77694291","insp_violation_id":"250784372","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3587975,"change_date":"2023-01-25 21:43:00","inspection_id":"77694291","insp_unit_id":"193070694","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M19560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:43.000000Z","updated_at":"2025-03-17T22:31:43.000000Z"},{"id":3587976,"change_date":"2023-01-25 21:43:00","inspection_id":"77694291","insp_unit_id":"193070695","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"179B547","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1C9DB12B0VM110024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:43.000000Z","updated_at":"2025-03-17T22:31:43.000000Z"}]},{"id":1998952,"change_date":"2022-12-21 21:40:00","inspection_id":"77430972","dot_number":"2047542","report_state":"TX","report_number":"6GWA9DBVCF","insp_date":"2022-12-15 00:00:00","insp_start_time":"1020","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2200  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"A L TRUCKING","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-12-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"8857881","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2022-12-21 21:40:00","snet_input_date":"2022-12-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-21 21:40:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T19:03:22.000000Z","updated_at":"2025-03-17T19:03:22.000000Z","inspection_violations":[{"id":3103300,"change_date":"2022-12-21 21:40:00","inspection_id":"77430972","insp_violation_id":"250229024","seq_no":"1","part_no":"393","part_no_section":"67(c)(7)(v)","insp_viol_unit":"1","insp_unit_id":"192545217","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:44.000000Z","updated_at":"2025-03-17T21:21:44.000000Z","normalized_code":"39367C7V"},{"id":3103301,"change_date":"2022-12-21 21:40:00","inspection_id":"77430972","insp_violation_id":"250229025","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"192545217","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:44.000000Z","updated_at":"2025-03-17T21:21:44.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":3216022,"change_date":"2022-12-21 21:40:00","inspection_id":"77430972","insp_unit_id":"192545217","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"1M19560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:02.000000Z","updated_at":"2025-03-17T22:29:02.000000Z"}]},{"id":1894231,"change_date":"2022-12-07 21:41:00","inspection_id":"77310915","dot_number":"2047542","report_state":"TX","report_number":"6FV99DBC6A","insp_date":"2022-11-08 00:00:00","insp_start_time":"0921","insp_end_time":"1013","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0099 IN HARRIS CO. (698-750","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETT MATERIALS","shipping_paper_number":"1011941","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-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"7","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8844199","transaction_code":"A","transaction_date":"2022-12-07 00:00:00","upload_date":"2022-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2022-12-07 21:41:00","snet_input_date":"2022-11-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-07 21:41:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T19:01:31.000000Z","updated_at":"2025-03-17T19:01:31.000000Z","inspection_violations":[{"id":2947622,"change_date":"2022-12-07 21:41:00","inspection_id":"77310915","insp_violation_id":"249976762","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"192311740","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"3965B"},{"id":2947623,"change_date":"2022-12-07 21:41:00","inspection_id":"77310915","insp_violation_id":"249976763","seq_no":"6","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"2","insp_unit_id":"192311740","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"39375A2"},{"id":2947624,"change_date":"2022-12-07 21:41:00","inspection_id":"77310915","insp_violation_id":"249976764","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192311740","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"3939A"},{"id":2947625,"change_date":"2022-12-07 21:41:00","inspection_id":"77310915","insp_violation_id":"249976765","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"38323A2"},{"id":2947626,"change_date":"2022-12-07 21:41:00","inspection_id":"77310915","insp_violation_id":"249976766","seq_no":"2","part_no":"393","part_no_section":"203","insp_viol_unit":"1","insp_unit_id":"192311739","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"393203"},{"id":2947627,"change_date":"2022-12-07 21:41:00","inspection_id":"77310915","insp_violation_id":"249976767","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"192311739","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"39345B2"},{"id":2947628,"change_date":"2022-12-07 21:41:00","inspection_id":"77310915","insp_violation_id":"249976768","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"192311740","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":3048658,"change_date":"2022-12-07 21:41:00","inspection_id":"77310915","insp_unit_id":"192311739","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"1M19560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:52.000000Z","updated_at":"2025-03-17T22:27:52.000000Z"},{"id":3048659,"change_date":"2022-12-07 21:41:00","inspection_id":"77310915","insp_unit_id":"192311740","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"179B547","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1C9DB12B0VM110024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:52.000000Z","updated_at":"2025-03-17T22:27:52.000000Z"}]},{"id":1606900,"change_date":"2022-10-26 21:39:00","inspection_id":"76981706","dot_number":"2047542","report_state":"TX","report_number":"6FD89DNAO4","insp_date":"2022-10-21 00:00:00","insp_start_time":"0800","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2900  PITTS RD","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETT MATERIALS","shipping_paper_number":"1009432","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-10-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"8811772","transaction_code":"A","transaction_date":"2022-10-26 00:00:00","upload_date":"2022-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2022-10-26 21:39:00","snet_input_date":"2022-10-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-26 21:39:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T18:56:17.000000Z","updated_at":"2025-03-17T18:56:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2585901,"change_date":"2022-10-26 21:39:00","inspection_id":"76981706","insp_unit_id":"191657184","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"1M19560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:44.000000Z","updated_at":"2025-03-17T22:24:44.000000Z"},{"id":2585902,"change_date":"2022-10-26 21:39:00","inspection_id":"76981706","insp_unit_id":"191657185","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"179B547","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:44.000000Z","updated_at":"2025-03-17T22:24:44.000000Z"}]},{"id":1836087,"change_date":"2022-11-29 21:41:00","inspection_id":"77244602","dot_number":"2047542","report_state":"TX","report_number":"6EXA9DJX20","insp_date":"2022-10-05 00:00:00","insp_start_time":"1049","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0059 IN HARRIS CO. (492-528","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EAGLE SORTERS","shipping_paper_number":"109973","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-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"8837580","transaction_code":"A","transaction_date":"2022-11-29 00:00:00","upload_date":"2022-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2022-11-29 21:41:00","snet_input_date":"2022-10-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-29 21:41:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T19:00:23.000000Z","updated_at":"2025-03-17T19:00:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2954271,"change_date":"2022-11-29 21:41:00","inspection_id":"77244602","insp_unit_id":"192177716","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1M06680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPFDB9X24D832009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:12.000000Z","updated_at":"2025-03-17T22:27:12.000000Z"},{"id":2954272,"change_date":"2022-11-29 21:41:00","inspection_id":"77244602","insp_unit_id":"192177717","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"15007L","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1A1V29203F16PT120","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:12.000000Z","updated_at":"2025-03-17T22:27:12.000000Z"}]},{"id":1391538,"change_date":"2022-10-03 21:41:00","inspection_id":"76732795","dot_number":"2047542","report_state":"TX","report_number":"6EP99DBV79","insp_date":"2022-09-27 00:00:00","insp_start_time":"0930","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6700  RANKIN","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"A L TRUCKING","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-09-28 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":"8784818","transaction_code":"C","transaction_date":"2022-10-03 00:00:00","upload_date":"2022-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2022-09-28 21:41:00","snet_input_date":"2022-09-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-28 21:41:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T18:52:21.000000Z","updated_at":"2025-03-17T18:52:21.000000Z","inspection_violations":[{"id":2199147,"change_date":"2022-10-03 21:41:00","inspection_id":"76732795","insp_violation_id":"248794086","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"191236135","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:02.000000Z","updated_at":"2025-03-17T21:17:02.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":2241030,"change_date":"2022-10-03 21:41:00","inspection_id":"76732795","insp_unit_id":"191236135","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"1M19560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDB9X3FS322837","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:20.000000Z","updated_at":"2025-03-17T22:22:20.000000Z"}]},{"id":1318600,"change_date":"2022-09-19 21:40:00","inspection_id":"76648226","dot_number":"2047542","report_state":"TX","report_number":"6E6G9DCO58","insp_date":"2022-09-08 00:00:00","insp_start_time":"1609","insp_end_time":"1640","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6700  RANKIN","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETT MATERIALS","shipping_paper_number":"1000386","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-09-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"85280","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":"8775243","transaction_code":"A","transaction_date":"2022-09-19 00:00:00","upload_date":"2022-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2022-09-19 21:40:00","snet_input_date":"2022-09-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-19 21:40:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T18:50:53.000000Z","updated_at":"2025-03-17T18:50:53.000000Z","inspection_violations":[{"id":2086856,"change_date":"2022-09-19 21:40:00","inspection_id":"76648226","insp_violation_id":"248509550","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190981246","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"39345B2"},{"id":2086857,"change_date":"2022-09-19 21:40:00","inspection_id":"76648226","insp_violation_id":"248509551","seq_no":"3","part_no":"392","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"190981246","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"3929"},{"id":2086858,"change_date":"2022-09-19 21:40:00","inspection_id":"76648226","insp_violation_id":"248509552","seq_no":"4","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"190981247","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"393100A"},{"id":2086859,"change_date":"2022-09-19 21:40:00","inspection_id":"76648226","insp_violation_id":"248509553","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190981247","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"3939A"},{"id":2086860,"change_date":"2022-09-19 21:40:00","inspection_id":"76648226","insp_violation_id":"248509554","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190981247","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"3922"},{"id":2086861,"change_date":"2022-09-19 21:40:00","inspection_id":"76648226","insp_violation_id":"248509555","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"190981247","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"39353B"},{"id":2086862,"change_date":"2022-09-19 21:40:00","inspection_id":"76648226","insp_violation_id":"248509556","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"190981247","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":2123099,"change_date":"2022-09-19 21:40:00","inspection_id":"76648226","insp_unit_id":"190981246","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"1M19560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:33.000000Z","updated_at":"2025-03-17T22:21:33.000000Z"},{"id":2123100,"change_date":"2022-09-19 21:40:00","inspection_id":"76648226","insp_unit_id":"190981247","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"179B547","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1C9DB12B0VM110024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:33.000000Z","updated_at":"2025-03-17T22:21:33.000000Z"}]},{"id":1338171,"change_date":"2022-09-21 21:39:00","inspection_id":"76670977","dot_number":"2047542","report_state":"TX","report_number":"6DSA9DBBJG","insp_date":"2022-08-25 00:00:00","insp_start_time":"1001","insp_end_time":"1051","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-2978 IN HARRIS CO. (446-448","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETT MATERIALS","shipping_paper_number":"25034","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-09-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"67000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8777905","transaction_code":"A","transaction_date":"2022-09-21 00:00:00","upload_date":"2022-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2022-09-21 21:39:00","snet_input_date":"2022-08-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-21 21:39:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T18:51:17.000000Z","updated_at":"2025-03-17T18:51:17.000000Z","inspection_violations":[{"id":2117809,"change_date":"2022-09-21 21:39:00","inspection_id":"76670977","insp_violation_id":"248564118","seq_no":"1","part_no":"390","part_no_section":"21(c)","insp_viol_unit":"1","insp_unit_id":"191027754","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"39021C"},{"id":2117810,"change_date":"2022-09-21 21:39:00","inspection_id":"76670977","insp_violation_id":"248564119","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"191027754","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"39360C"},{"id":2117811,"change_date":"2022-09-21 21:39:00","inspection_id":"76670977","insp_violation_id":"248564120","seq_no":"3","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"191027754","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"39355D2"},{"id":2117812,"change_date":"2022-09-21 21:39:00","inspection_id":"76670977","insp_violation_id":"248564121","seq_no":"4","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"191027754","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"393209D"},{"id":2117813,"change_date":"2022-09-21 21:39:00","inspection_id":"76670977","insp_violation_id":"248564122","seq_no":"5","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"191027754","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"39383G"},{"id":2117814,"change_date":"2022-09-21 21:39:00","inspection_id":"76670977","insp_violation_id":"248564123","seq_no":"6","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"2","insp_unit_id":"191027755","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"39347G"},{"id":2117815,"change_date":"2022-09-21 21:39:00","inspection_id":"76670977","insp_violation_id":"248564124","seq_no":"7","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"191027754","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"39379"},{"id":2117816,"change_date":"2022-09-21 21:39:00","inspection_id":"76670977","insp_violation_id":"248564125","seq_no":"8","part_no":"393","part_no_section":"28","insp_viol_unit":"2","insp_unit_id":"191027755","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"39328"}],"inspection_per_units":[{"id":2154657,"change_date":"2022-09-21 21:39:00","inspection_id":"76670977","insp_unit_id":"191027754","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1M06680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPFDB9X24D832009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:44.000000Z","updated_at":"2025-03-17T22:21:44.000000Z"},{"id":2154658,"change_date":"2022-09-21 21:39:00","inspection_id":"76670977","insp_unit_id":"191027755","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"15997L","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1A1V29203F16PT120","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:44.000000Z","updated_at":"2025-03-17T22:21:44.000000Z"}]},{"id":1207793,"change_date":"2022-09-02 21:39:00","inspection_id":"76519666","dot_number":"2047542","report_state":"TX","report_number":"6DK89DGPB1","insp_date":"2022-08-17 00:00:00","insp_start_time":"0835","insp_end_time":"0858","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"100  SORTERS MCCLELL","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":"2022-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"84000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8761633","transaction_code":"A","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2022-09-02 21:39:00","snet_input_date":"2022-08-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-02 21:39:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T18:48:58.000000Z","updated_at":"2025-03-17T18:48:58.000000Z","inspection_violations":[{"id":1915653,"change_date":"2022-09-02 21:39:00","inspection_id":"76519666","insp_violation_id":"248203760","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"190713819","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"39360C"},{"id":1915654,"change_date":"2022-09-02 21:39:00","inspection_id":"76519666","insp_violation_id":"248203761","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190713819","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"3939A"},{"id":1915655,"change_date":"2022-09-02 21:39:00","inspection_id":"76519666","insp_violation_id":"248203762","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190713819","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"3939A"},{"id":1915656,"change_date":"2022-09-02 21:39:00","inspection_id":"76519666","insp_violation_id":"248203763","seq_no":"4","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"190713819","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"39319"},{"id":1915657,"change_date":"2022-09-02 21:39:00","inspection_id":"76519666","insp_violation_id":"248203764","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190713819","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1942504,"change_date":"2022-09-02 21:39:00","inspection_id":"76519666","insp_unit_id":"190713819","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1M06680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPFDB9X24D832009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"},{"id":1942505,"change_date":"2022-09-02 21:39:00","inspection_id":"76519666","insp_unit_id":"190713820","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"15997L","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1A1V29203F16PT120","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"}]},{"id":988120,"change_date":"2022-08-08 21:40:00","inspection_id":"76263778","dot_number":"2047542","report_state":"TX","report_number":"6D749DJVAX","insp_date":"2022-08-04 00:00:00","insp_start_time":"0418","insp_end_time":"0445","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":"2022-08-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8736835","transaction_code":"A","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2022-08-08 21:40:00","snet_input_date":"2022-08-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-08 21:40:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T18:45:05.000000Z","updated_at":"2025-03-17T18:45:05.000000Z","inspection_violations":[{"id":1559324,"change_date":"2022-08-08 21:40:00","inspection_id":"76263778","insp_violation_id":"247585049","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190194449","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"3939A"},{"id":1559325,"change_date":"2022-08-08 21:40:00","inspection_id":"76263778","insp_violation_id":"247585050","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190194449","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"3939A"},{"id":1559326,"change_date":"2022-08-08 21:40:00","inspection_id":"76263778","insp_violation_id":"247585051","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190194449","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"3939A"},{"id":1559327,"change_date":"2022-08-08 21:40:00","inspection_id":"76263778","insp_violation_id":"247585052","seq_no":"5","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"190194449","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"39319"},{"id":1559328,"change_date":"2022-08-08 21:40:00","inspection_id":"76263778","insp_violation_id":"247585053","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190194449","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1590694,"change_date":"2022-08-08 21:40:00","inspection_id":"76263778","insp_unit_id":"190194449","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1M06680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPFDB9X24D832009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:02.000000Z","updated_at":"2025-03-17T22:18:02.000000Z"},{"id":1590695,"change_date":"2022-08-08 21:40:00","inspection_id":"76263778","insp_unit_id":"190194450","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"15997L","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1A1V29203F16PT120","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:02.000000Z","updated_at":"2025-03-17T22:18:02.000000Z"}]},{"id":925486,"change_date":"2022-07-29 21:39:00","inspection_id":"76190650","dot_number":"2047542","report_state":"TX","report_number":"6CY49DJV92","insp_date":"2022-07-26 00:00:00","insp_start_time":"0407","insp_end_time":"0431","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":"2022-07-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","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":"8727763","transaction_code":"A","transaction_date":"2022-07-29 00:00:00","upload_date":"2022-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2022-07-29 21:39:00","snet_input_date":"2022-07-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-29 21:39:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T18:44:02.000000Z","updated_at":"2025-03-17T18:44:02.000000Z","inspection_violations":[{"id":1460647,"change_date":"2022-07-29 21:39:00","inspection_id":"76190650","insp_violation_id":"247410335","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"190045463","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"39617C"},{"id":1460648,"change_date":"2022-07-29 21:39:00","inspection_id":"76190650","insp_violation_id":"247410336","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190045463","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1490242,"change_date":"2022-07-29 21:39:00","inspection_id":"76190650","insp_unit_id":"190045462","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M19560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:23.000000Z","updated_at":"2025-03-17T22:17:23.000000Z"},{"id":1490243,"change_date":"2022-07-29 21:39:00","inspection_id":"76190650","insp_unit_id":"190045463","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"Y53431","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1C9DB12B0VM110024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:23.000000Z","updated_at":"2025-03-17T22:17:23.000000Z"}]},{"id":492741,"change_date":"2022-05-26 21:43:00","inspection_id":"75680844","dot_number":"2047542","report_state":"TX","report_number":"6B1A9DCC4U","insp_date":"2022-05-18 00:00:00","insp_start_time":"1035","insp_end_time":"1101","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2000  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-05-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"8667750","transaction_code":"A","transaction_date":"2022-05-26 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","census_search_date":"2022-05-26 21:43:00","snet_input_date":"2022-05-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-26 21:43:00","insp_carrier_name":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T18:36:21.000000Z","updated_at":"2025-03-17T18:36:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":792317,"change_date":"2022-05-26 21:43:00","inspection_id":"75680844","insp_unit_id":"188938798","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"1M19560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:04.000000Z","updated_at":"2025-03-17T22:13:04.000000Z"}]},{"id":56188,"change_date":"2022-03-31 21:41:00","inspection_id":"75156992","dot_number":"2047542","report_state":"TX","report_number":"69I79DCBXE","insp_date":"2022-03-24 00:00:00","insp_start_time":"0759","insp_end_time":"0821","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"16000  EASTEX FWY I\/","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETT MATERIALS","shipping_paper_number":"967310","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":"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":"8603125","transaction_code":"C","transaction_date":"2022-03-31 00:00:00","upload_date":"2022-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02047542","upload_search_indicator":"M","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":"ARISTEO LOPEZ","insp_carrier_street":"9122 MADERA","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0160756","created_at":"2025-03-17T18:28:28.000000Z","updated_at":"2025-03-17T18:28:28.000000Z","inspection_violations":[{"id":80701,"change_date":"2022-03-31 21:41:00","inspection_id":"75156992","insp_violation_id":"244900610","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"187930387","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"},{"id":80702,"change_date":"2022-03-31 21:41:00","inspection_id":"75156992","insp_violation_id":"244900611","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"187930387","insp_violation_category_id":"26","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":"39360C"},{"id":80703,"change_date":"2022-03-31 21:41:00","inspection_id":"75156992","insp_violation_id":"244900612","seq_no":"3","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"187930387","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":"39324A"}],"inspection_per_units":[{"id":91343,"change_date":"2022-03-31 21:41:00","inspection_id":"75156992","insp_unit_id":"187930387","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"NSP9422","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X27J192575","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\/2047542\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2047542\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2047542\/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\/2047542\/inspections","per_page":100,"prev_page_url":null,"to":24,"total":24}