{"current_page":1,"data":[{"id":12031775,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","dot_number":"2630438","report_state":"TX","report_number":"V262345434","insp_date":"2026-05-26 00:00:00","insp_start_time":"1533","insp_end_time":"1626","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 59 NB SERVICE RD","county_code_state":"TX","county_code":"157","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"15","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9971735","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2026-05-27 21:41:00","snet_input_date":"2026-05-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-27 21:41:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2026-05-30T09:39:37.000000Z","updated_at":"2026-06-07T09:31:28.000000Z","inspection_violations":[{"id":20936324,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_violation_id":"274536919","seq_no":"9","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"213781196","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:07.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"39617C"},{"id":20936316,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_violation_id":"274536911","seq_no":"1","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"213781195","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:07.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"39311TU"},{"id":20936317,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_violation_id":"274536912","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"213781196","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:07.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"39347E"},{"id":20936318,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_violation_id":"274536913","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213781195","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:07.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"39347E"},{"id":20936319,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_violation_id":"274536914","seq_no":"4","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"213781195","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:07.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"39353B"},{"id":20936320,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_violation_id":"274536915","seq_no":"5","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"213781196","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:07.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"39353B"},{"id":20936321,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_violation_id":"274536916","seq_no":"6","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"213781196","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:07.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"39355E"},{"id":20936322,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_violation_id":"274536917","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213781196","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-05-30T09:58:07.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"3939"},{"id":20936323,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_violation_id":"274536918","seq_no":"8","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"213781195","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:07.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"39617C"},{"id":20936325,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_violation_id":"274536920","seq_no":"10","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"213781195","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-05-30T09:58:07.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"3963A1BOS"},{"id":20936326,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_violation_id":"274536921","seq_no":"11","part_no":"396","part_no_section":"3A1-TC","insp_viol_unit":"1","insp_unit_id":"213781195","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-05-30T09:58:07.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"3963A1TC"},{"id":20936327,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_violation_id":"274536922","seq_no":"12","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213781195","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:07.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"3922RG"},{"id":20936328,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_violation_id":"274536923","seq_no":"13","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"213781196","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:07.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"3922RG"},{"id":20936329,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_violation_id":"274536924","seq_no":"14","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"213781196","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:07.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"3922RG"},{"id":20936330,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_violation_id":"274536925","seq_no":"15","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213781195","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:07.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":20913031,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_unit_id":"213781195","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"585","insp_unit_license":"1M36822","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X9TR724180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:47.000000Z","updated_at":"2026-06-07T09:03:24.000000Z"},{"id":20913032,"change_date":"2026-05-27 21:41:00","inspection_id":"87972019","insp_unit_id":"213781196","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"172B094","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU34322XMS000236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:47.000000Z","updated_at":"2026-06-07T09:03:24.000000Z"}]},{"id":11267718,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","dot_number":"2630438","report_state":"TX","report_number":"7DAD9DBCEY","insp_date":"2026-02-23 00:00:00","insp_start_time":"1342","insp_end_time":"1438","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"12253  GRANT 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 SANCHEZ","shipping_paper_number":"13170","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"14","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"14","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9867714","transaction_code":"A","transaction_date":"2026-03-02 00:00:00","upload_date":"2026-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2026-03-02 21:38:00","snet_input_date":"2026-02-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-02 21:38:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2026-03-05T10:39:03.000000Z","updated_at":"2026-03-13T09:31:36.000000Z","inspection_violations":[{"id":18937514,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_violation_id":"272143916","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"211923636","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:07.000000Z","updated_at":"2026-03-13T09:45:25.000000Z","normalized_code":"39360C"},{"id":18937515,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_violation_id":"272143917","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211923636","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:07.000000Z","updated_at":"2026-03-13T09:45:25.000000Z","normalized_code":"3922RG"},{"id":18937516,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_violation_id":"272143918","seq_no":"3","part_no":"393","part_no_section":"55C2","insp_viol_unit":"2","insp_unit_id":"211923637","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:07.000000Z","updated_at":"2026-03-13T09:45:25.000000Z","normalized_code":"39355C2"},{"id":18937517,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_violation_id":"272143919","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"211923636","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:07.000000Z","updated_at":"2026-03-13T09:45:25.000000Z","normalized_code":"39311"},{"id":18937518,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_violation_id":"272143920","seq_no":"5","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"211923637","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:07.000000Z","updated_at":"2026-03-13T09:45:25.000000Z","normalized_code":"39348A"},{"id":18937519,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_violation_id":"272143921","seq_no":"6","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"211923637","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:07.000000Z","updated_at":"2026-03-13T09:45:25.000000Z","normalized_code":"3922RG"},{"id":18937520,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_violation_id":"272143922","seq_no":"7","part_no":"393","part_no_section":"203","insp_viol_unit":"1","insp_unit_id":"211923636","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:07.000000Z","updated_at":"2026-03-13T09:45:25.000000Z","normalized_code":"393203"},{"id":18937521,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_violation_id":"272143923","seq_no":"8","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"211923636","insp_violation_category_id":"27","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-05T10:57:07.000000Z","updated_at":"2026-03-13T09:45:25.000000Z","normalized_code":"39383G"},{"id":18937522,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_violation_id":"272143924","seq_no":"9","part_no":"393","part_no_section":"84","insp_viol_unit":"1","insp_unit_id":"211923636","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:07.000000Z","updated_at":"2026-03-13T09:45:25.000000Z","normalized_code":"39384"},{"id":18937523,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_violation_id":"272143925","seq_no":"10","part_no":"393","part_no_section":"50D","insp_viol_unit":"1","insp_unit_id":"211923636","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:07.000000Z","updated_at":"2026-03-13T09:45:25.000000Z","normalized_code":"39350D"},{"id":18937524,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_violation_id":"272143926","seq_no":"11","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"211923637","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:07.000000Z","updated_at":"2026-03-13T09:45:25.000000Z","normalized_code":"39347E"},{"id":18937525,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_violation_id":"272143927","seq_no":"12","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"211923637","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:07.000000Z","updated_at":"2026-03-13T09:45:25.000000Z","normalized_code":"39347E"},{"id":18937526,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_violation_id":"272143928","seq_no":"13","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"211923637","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:07.000000Z","updated_at":"2026-03-13T09:45:25.000000Z","normalized_code":"39353B"},{"id":18937527,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_violation_id":"272143929","seq_no":"14","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"211923637","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-05T10:57:07.000000Z","updated_at":"2026-03-13T09:45:25.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":19268238,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_unit_id":"211923636","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"69","insp_unit_license":"1M61880","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9XX6J129061","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:46.000000Z","updated_at":"2026-03-13T09:07:18.000000Z"},{"id":19268239,"change_date":"2026-03-02 21:38:00","inspection_id":"87181863","insp_unit_id":"211923637","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BR32B7MM011608","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:46.000000Z","updated_at":"2026-03-13T09:07:18.000000Z"}]},{"id":11267527,"change_date":"2026-03-02 21:38:00","inspection_id":"87181664","dot_number":"2630438","report_state":"TX","report_number":"7D6E9DBCEV","insp_date":"2026-02-19 00:00:00","insp_start_time":"1426","insp_end_time":"1505","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13060  GRANT RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"A. SANCHEZ","shipping_paper_number":"1811-0110","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"12","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9867667","transaction_code":"A","transaction_date":"2026-03-02 00:00:00","upload_date":"2026-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2026-03-02 21:38:00","snet_input_date":"2026-02-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-02 21:38:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2026-03-05T10:39:03.000000Z","updated_at":"2026-03-13T09:31:32.000000Z","inspection_violations":[{"id":18936832,"change_date":"2026-03-02 21:38:00","inspection_id":"87181664","insp_violation_id":"272143016","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211923273","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:05.000000Z","updated_at":"2026-03-13T09:45:20.000000Z","normalized_code":"3922RG"},{"id":18936833,"change_date":"2026-03-02 21:38:00","inspection_id":"87181664","insp_violation_id":"272143017","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"211923274","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:05.000000Z","updated_at":"2026-03-13T09:45:20.000000Z","normalized_code":"3922RG"},{"id":18936834,"change_date":"2026-03-02 21:38:00","inspection_id":"87181664","insp_violation_id":"272143018","seq_no":"4","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"211923273","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:05.000000Z","updated_at":"2026-03-13T09:45:20.000000Z","normalized_code":"39360C"},{"id":18936835,"change_date":"2026-03-02 21:38:00","inspection_id":"87181664","insp_violation_id":"272143019","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"211923273","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:05.000000Z","updated_at":"2026-03-13T09:45:20.000000Z","normalized_code":"39378"},{"id":18936836,"change_date":"2026-03-02 21:38:00","inspection_id":"87181664","insp_violation_id":"272143020","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"211923273","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:05.000000Z","updated_at":"2026-03-13T09:45:20.000000Z","normalized_code":"39311"},{"id":18936837,"change_date":"2026-03-02 21:38:00","inspection_id":"87181664","insp_violation_id":"272143021","seq_no":"7","part_no":"393","part_no_section":"26","insp_viol_unit":"1","insp_unit_id":"211923273","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:05.000000Z","updated_at":"2026-03-13T09:45:20.000000Z","normalized_code":"39326"},{"id":18936838,"change_date":"2026-03-02 21:38:00","inspection_id":"87181664","insp_violation_id":"272143022","seq_no":"8","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"211923273","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:05.000000Z","updated_at":"2026-03-13T09:45:20.000000Z","normalized_code":"39311TU"},{"id":18936839,"change_date":"2026-03-02 21:38:00","inspection_id":"87181664","insp_violation_id":"272143023","seq_no":"9","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"211923273","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:05.000000Z","updated_at":"2026-03-13T09:45:20.000000Z","normalized_code":"39311TL"},{"id":18936840,"change_date":"2026-03-02 21:38:00","inspection_id":"87181664","insp_violation_id":"272143024","seq_no":"10","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"211923273","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:05.000000Z","updated_at":"2026-03-13T09:45:20.000000Z","normalized_code":"3939"},{"id":18936841,"change_date":"2026-03-02 21:38:00","inspection_id":"87181664","insp_violation_id":"272143025","seq_no":"11","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211923274","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:05.000000Z","updated_at":"2026-03-13T09:45:20.000000Z","normalized_code":"3939"},{"id":18936842,"change_date":"2026-03-02 21:38:00","inspection_id":"87181664","insp_violation_id":"272143026","seq_no":"12","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"211923273","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-05T10:57:05.000000Z","updated_at":"2026-03-13T09:45:20.000000Z","normalized_code":"393209D"},{"id":18936843,"change_date":"2026-03-02 21:38:00","inspection_id":"87181664","insp_violation_id":"272143027","seq_no":"13","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211923273","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:57:05.000000Z","updated_at":"2026-03-13T09:45:20.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":19267939,"change_date":"2026-03-02 21:38:00","inspection_id":"87181664","insp_unit_id":"211923273","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"69","insp_unit_license":"1M61880","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9XX6J129061","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:46.000000Z","updated_at":"2026-03-13T09:07:16.000000Z"},{"id":19267940,"change_date":"2026-03-02 21:38:00","inspection_id":"87181664","insp_unit_id":"211923274","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BR32B7MM011608","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:46.000000Z","updated_at":"2026-03-13T09:07:16.000000Z"}]},{"id":10499328,"change_date":"2025-12-22 21:39:00","inspection_id":"86634111","dot_number":"2630438","report_state":"TX","report_number":"V252155270","insp_date":"2025-12-18 00:00:00","insp_start_time":"0700","insp_end_time":"0740","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH69 NB","county_code_state":"TX","county_code":"291","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SH105 SITE","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-12-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9794169","transaction_code":"A","transaction_date":"2025-12-22 00:00:00","upload_date":"2025-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2025-12-22 21:39:00","snet_input_date":"2025-12-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-22 21:39:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-12-25T10:37:48.000000Z","updated_at":"2026-01-02T10:31:07.000000Z","inspection_violations":[{"id":17623583,"change_date":"2025-12-22 21:39:00","inspection_id":"86634111","insp_violation_id":"270849602","seq_no":"1","part_no":"396","part_no_section":"7A-UO","insp_viol_unit":"1","insp_unit_id":"210760000","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:58.000000Z","updated_at":"2026-01-02T10:31:55.000000Z","normalized_code":"3967AUO"},{"id":17623584,"change_date":"2025-12-22 21:39:00","inspection_id":"86634111","insp_violation_id":"270849603","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"210760001","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:58.000000Z","updated_at":"2026-01-02T10:31:55.000000Z","normalized_code":"3939"},{"id":17623585,"change_date":"2025-12-22 21:39:00","inspection_id":"86634111","insp_violation_id":"270849604","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"210760001","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:58.000000Z","updated_at":"2026-01-02T10:31:55.000000Z","normalized_code":"3939"},{"id":17623586,"change_date":"2025-12-22 21:39:00","inspection_id":"86634111","insp_violation_id":"270849605","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"210760001","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:58.000000Z","updated_at":"2026-01-02T10:31:55.000000Z","normalized_code":"3939"},{"id":17623587,"change_date":"2025-12-22 21:39:00","inspection_id":"86634111","insp_violation_id":"270849606","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"210760001","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:58.000000Z","updated_at":"2026-01-02T10:31:55.000000Z","normalized_code":"3922RG"},{"id":17623588,"change_date":"2025-12-22 21:39:00","inspection_id":"86634111","insp_violation_id":"270849607","seq_no":"6","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"210760000","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:58.000000Z","updated_at":"2026-01-02T10:31:55.000000Z","normalized_code":"3922RG"},{"id":17623589,"change_date":"2025-12-22 21:39:00","inspection_id":"86634111","insp_violation_id":"270849608","seq_no":"7","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"210760000","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:58.000000Z","updated_at":"2026-01-02T10:31:55.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":17580711,"change_date":"2025-12-22 21:39:00","inspection_id":"86634111","insp_unit_id":"210760000","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"911","insp_unit_license":"1M75245","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9XXVR748622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-25T10:08:45.000000Z","updated_at":"2026-01-02T10:01:10.000000Z"},{"id":17580712,"change_date":"2025-12-22 21:39:00","inspection_id":"86634111","insp_unit_id":"210760001","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CPS","insp_unit_company":"T911","insp_unit_license":"73M194N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC513225CP012711","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-25T10:08:45.000000Z","updated_at":"2026-01-02T10:01:10.000000Z"}]},{"id":9987492,"change_date":"2025-10-20 21:39:00","inspection_id":"86097091","dot_number":"2630438","report_state":"TX","report_number":"79OH9DCN5Z","insp_date":"2025-10-16 00:00:00","insp_start_time":"1702","insp_end_time":"1727","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","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-10-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"9","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9730536","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2025-10-20 21:39:00","snet_input_date":"2025-10-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-20 21:39:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-10-23T10:00:43.000000Z","updated_at":"2025-10-24T10:01:05.000000Z","inspection_violations":[{"id":16502303,"change_date":"2025-10-20 21:39:00","inspection_id":"86097091","insp_violation_id":"269404543","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209559570","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:16:02.000000Z","updated_at":"2025-10-24T10:16:46.000000Z","normalized_code":"3922RG"},{"id":16502304,"change_date":"2025-10-20 21:39:00","inspection_id":"86097091","insp_violation_id":"269404544","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"209559571","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:16:02.000000Z","updated_at":"2025-10-24T10:16:46.000000Z","normalized_code":"3922RG"},{"id":16502305,"change_date":"2025-10-20 21:39:00","inspection_id":"86097091","insp_violation_id":"269404545","seq_no":"3","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"209559570","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:16:02.000000Z","updated_at":"2025-10-24T10:16:46.000000Z","normalized_code":"39360D"},{"id":16502306,"change_date":"2025-10-20 21:39:00","inspection_id":"86097091","insp_violation_id":"269404546","seq_no":"4","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"209559570","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:16:02.000000Z","updated_at":"2025-10-24T10:16:46.000000Z","normalized_code":"999"},{"id":16502307,"change_date":"2025-10-20 21:39:00","inspection_id":"86097091","insp_violation_id":"269404547","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209559570","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:16:02.000000Z","updated_at":"2025-10-24T10:16:46.000000Z","normalized_code":"3939"},{"id":16502308,"change_date":"2025-10-20 21:39:00","inspection_id":"86097091","insp_violation_id":"269404548","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209559570","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:16:02.000000Z","updated_at":"2025-10-24T10:16:46.000000Z","normalized_code":"3939"},{"id":16502309,"change_date":"2025-10-20 21:39:00","inspection_id":"86097091","insp_violation_id":"269404549","seq_no":"7","part_no":"393","part_no_section":"9T","insp_viol_unit":"1","insp_unit_id":"209559570","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:16:02.000000Z","updated_at":"2025-10-24T10:16:46.000000Z","normalized_code":"3939T"},{"id":16502310,"change_date":"2025-10-20 21:39:00","inspection_id":"86097091","insp_violation_id":"269404550","seq_no":"8","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"209559570","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:16:02.000000Z","updated_at":"2025-10-24T10:16:46.000000Z","normalized_code":"39311"},{"id":16502311,"change_date":"2025-10-20 21:39:00","inspection_id":"86097091","insp_violation_id":"269404551","seq_no":"9","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209559570","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:16:02.000000Z","updated_at":"2025-10-24T10:16:46.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":16584889,"change_date":"2025-10-20 21:39:00","inspection_id":"86097091","insp_unit_id":"209559570","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M36822","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X9TR724180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:46.000000Z","updated_at":"2025-10-24T09:46:20.000000Z"},{"id":16584890,"change_date":"2025-10-20 21:39:00","inspection_id":"86097091","insp_unit_id":"209559571","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"172B094","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU34322XMS000236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:46.000000Z","updated_at":"2025-10-24T09:46:20.000000Z"}]},{"id":8806783,"change_date":"2025-06-03 21:40:00","inspection_id":"84853881","dot_number":"2630438","report_state":"TX","report_number":"75JB9DBF2M","insp_date":"2025-05-20 00:00:00","insp_start_time":"1054","insp_end_time":"1139","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-0008 IN HARRIS CO. (690-758","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"111000","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":"9597564","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2025-06-03 21:40:00","snet_input_date":"2025-05-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-03 21:40:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-06-06T10:01:07.000000Z","updated_at":"2025-06-07T10:00:42.000000Z","inspection_violations":[{"id":14089041,"change_date":"2025-06-03 21:40:00","inspection_id":"84853881","insp_violation_id":"266640244","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207206093","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:46.000000Z","updated_at":"2025-06-07T10:17:46.000000Z","normalized_code":"3922RG"},{"id":14089042,"change_date":"2025-06-03 21:40:00","inspection_id":"84853881","insp_violation_id":"266640245","seq_no":"2","part_no":"393","part_no_section":"55C2","insp_viol_unit":"2","insp_unit_id":"207206094","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:46.000000Z","updated_at":"2025-06-07T10:17:46.000000Z","normalized_code":"39355C2"},{"id":14089043,"change_date":"2025-06-03 21:40:00","inspection_id":"84853881","insp_violation_id":"266640246","seq_no":"3","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"207206094","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:46.000000Z","updated_at":"2025-06-07T10:17:46.000000Z","normalized_code":"39375C"},{"id":14089044,"change_date":"2025-06-03 21:40:00","inspection_id":"84853881","insp_violation_id":"266640247","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207206093","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:46.000000Z","updated_at":"2025-06-07T10:17:46.000000Z","normalized_code":"39347E"},{"id":14089045,"change_date":"2025-06-03 21:40:00","inspection_id":"84853881","insp_violation_id":"266640248","seq_no":"5","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"207206093","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:46.000000Z","updated_at":"2025-06-07T10:17:46.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":14414621,"change_date":"2025-06-03 21:40:00","inspection_id":"84853881","insp_unit_id":"207206093","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KNNW","insp_unit_company":"102","insp_unit_license":"1M36822","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X9TR724180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:51.000000Z","updated_at":"2025-06-07T09:45:53.000000Z"},{"id":14414622,"change_date":"2025-06-03 21:40:00","inspection_id":"84853881","insp_unit_id":"207206094","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"172B094","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU34322XMS000236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:51.000000Z","updated_at":"2025-06-07T09:45:53.000000Z"}]},{"id":8632866,"change_date":"2025-05-14 21:42:00","inspection_id":"84670052","dot_number":"2630438","report_state":"TX","report_number":"75889DGR7L","insp_date":"2025-05-09 00:00:00","insp_start_time":"0933","insp_end_time":"1010","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY S SR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SANCHEZ 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":"2025-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9577289","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2025-05-14 21:42:00","snet_input_date":"2025-05-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-14 21:42:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-05-17T10:05:22.000000Z","updated_at":"2025-05-18T10:06:18.000000Z","inspection_violations":[{"id":13728493,"change_date":"2025-05-14 21:42:00","inspection_id":"84670052","insp_violation_id":"266223188","seq_no":"1","part_no":"393","part_no_section":"60E-WS","insp_viol_unit":"1","insp_unit_id":"206859018","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:25.000000Z","updated_at":"2025-05-18T10:34:00.000000Z","normalized_code":"39360EWS"},{"id":13728494,"change_date":"2025-05-14 21:42:00","inspection_id":"84670052","insp_violation_id":"266223189","seq_no":"2","part_no":"393","part_no_section":"24A","insp_viol_unit":"1","insp_unit_id":"206859018","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:25.000000Z","updated_at":"2025-05-18T10:34:00.000000Z","normalized_code":"39324A"},{"id":13728495,"change_date":"2025-05-14 21:42:00","inspection_id":"84670052","insp_violation_id":"266223190","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"206859018","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:25.000000Z","updated_at":"2025-05-18T10:34:00.000000Z","normalized_code":"39378"},{"id":13728496,"change_date":"2025-05-14 21:42:00","inspection_id":"84670052","insp_violation_id":"266223191","seq_no":"4","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"206859019","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:25.000000Z","updated_at":"2025-05-18T10:34:00.000000Z","normalized_code":"39375C"},{"id":13728497,"change_date":"2025-05-14 21:42:00","inspection_id":"84670052","insp_violation_id":"266223192","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"206859019","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:25.000000Z","updated_at":"2025-05-18T10:34:00.000000Z","normalized_code":"3939"},{"id":13728498,"change_date":"2025-05-14 21:42:00","inspection_id":"84670052","insp_violation_id":"266223193","seq_no":"6","part_no":"393","part_no_section":"47A","insp_viol_unit":"2","insp_unit_id":"206859019","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:25.000000Z","updated_at":"2025-05-18T10:34:00.000000Z","normalized_code":"39347A"}],"inspection_per_units":[{"id":14096600,"change_date":"2025-05-14 21:42:00","inspection_id":"84670052","insp_unit_id":"206859018","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"187","insp_unit_license":"1M15511","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y7TW065992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:19.000000Z","updated_at":"2025-05-18T09:51:55.000000Z"},{"id":14096601,"change_date":"2025-05-14 21:42:00","inspection_id":"84670052","insp_unit_id":"206859019","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"9112LA","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU343220FS000636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:19.000000Z","updated_at":"2025-05-18T09:51:55.000000Z"}]},{"id":7027134,"change_date":"2024-10-23 21:42:00","inspection_id":"82979713","dot_number":"2630438","report_state":"TX","report_number":"6ZLF9DCAQM","insp_date":"2024-10-18 00:00:00","insp_start_time":"1518","insp_end_time":"1551","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7807 W FM 1960 RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"62600","viol_total":"11","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9409403","transaction_code":"A","transaction_date":"2024-10-23 00:00:00","upload_date":"2024-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2024-10-23 21:42:00","snet_input_date":"2024-10-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-23 21:42:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T20:42:38.000000Z","updated_at":"2025-03-17T20:42:38.000000Z","inspection_violations":[{"id":10968272,"change_date":"2024-10-23 21:42:00","inspection_id":"82979713","insp_violation_id":"262519356","seq_no":"1","part_no":"393","part_no_section":"203E","insp_viol_unit":"1","insp_unit_id":"203551317","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"393203E"},{"id":10968273,"change_date":"2024-10-23 21:42:00","inspection_id":"82979713","insp_violation_id":"262519357","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"203551318","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39311"},{"id":10968274,"change_date":"2024-10-23 21:42:00","inspection_id":"82979713","insp_violation_id":"262519358","seq_no":"3","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"203551317","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"999"},{"id":10968275,"change_date":"2024-10-23 21:42:00","inspection_id":"82979713","insp_violation_id":"262519359","seq_no":"4","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"203551317","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39395A"},{"id":10968276,"change_date":"2024-10-23 21:42:00","inspection_id":"82979713","insp_violation_id":"262519360","seq_no":"5","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"203551317","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39375A3"},{"id":10968277,"change_date":"2024-10-23 21:42:00","inspection_id":"82979713","insp_violation_id":"262519361","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"203551318","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3939"},{"id":10968278,"change_date":"2024-10-23 21:42:00","inspection_id":"82979713","insp_violation_id":"262519362","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"203551318","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3939"},{"id":10968279,"change_date":"2024-10-23 21:42:00","inspection_id":"82979713","insp_violation_id":"262519363","seq_no":"8","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"203551318","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3922RG"},{"id":10968280,"change_date":"2024-10-23 21:42:00","inspection_id":"82979713","insp_violation_id":"262519364","seq_no":"9","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"203551318","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39375C"},{"id":10968281,"change_date":"2024-10-23 21:42:00","inspection_id":"82979713","insp_violation_id":"262519365","seq_no":"10","part_no":"393","part_no_section":"203C","insp_viol_unit":"1","insp_unit_id":"203551317","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"393203C"},{"id":10968282,"change_date":"2024-10-23 21:42:00","inspection_id":"82979713","insp_violation_id":"262519366","seq_no":"11","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"203551317","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":11333391,"change_date":"2024-10-23 21:42:00","inspection_id":"82979713","insp_unit_id":"203551317","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"911","insp_unit_license":"1M75245","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9XXVR748622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"},{"id":11333392,"change_date":"2024-10-23 21:42:00","inspection_id":"82979713","insp_unit_id":"203551318","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC513225CP012711","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"}]},{"id":6963797,"change_date":"2024-10-15 21:43:00","inspection_id":"82912327","dot_number":"2630438","report_state":"TX","report_number":"6ZBE9DJNB3","insp_date":"2024-10-08 00:00:00","insp_start_time":"1458","insp_end_time":"1511","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6800  LIBERTY RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9401873","transaction_code":"A","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2024-10-15 21:43:00","snet_input_date":"2024-10-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-15 21:43:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T20:41:23.000000Z","updated_at":"2025-03-17T20:41:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11231594,"change_date":"2024-10-15 21:43:00","inspection_id":"82912327","insp_unit_id":"203421257","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"187","insp_unit_license":"1M15511","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y7TW065992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:17.000000Z","updated_at":"2025-03-17T23:39:17.000000Z"},{"id":11231595,"change_date":"2024-10-15 21:43:00","inspection_id":"82912327","insp_unit_id":"203421258","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"9112LA","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU343220FS000636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:17.000000Z","updated_at":"2025-03-17T23:39:17.000000Z"}]},{"id":6576581,"change_date":"2024-08-27 21:43:00","inspection_id":"82500177","dot_number":"2630438","report_state":"TX","report_number":"6Y179DCOAQ","insp_date":"2024-08-23 00:00:00","insp_start_time":"0734","insp_end_time":"0746","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5600 S SHAVER ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"A SANCHEZ TRUCKING","shipping_paper_number":"187","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9361526","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2024-08-27 21:43:00","snet_input_date":"2024-08-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-27 21:43:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T20:33:13.000000Z","updated_at":"2025-03-17T20:33:13.000000Z","inspection_violations":[{"id":10223563,"change_date":"2024-08-27 21:43:00","inspection_id":"82500177","insp_violation_id":"261443475","seq_no":"1","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"202612310","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:31.000000Z","updated_at":"2025-03-17T21:55:31.000000Z","normalized_code":"39379"},{"id":10223564,"change_date":"2024-08-27 21:43:00","inspection_id":"82500177","insp_violation_id":"261443476","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202612310","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:31.000000Z","updated_at":"2025-03-17T21:55:31.000000Z","normalized_code":"3939A"},{"id":10223565,"change_date":"2024-08-27 21:43:00","inspection_id":"82500177","insp_violation_id":"261443477","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"202612311","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:31.000000Z","updated_at":"2025-03-17T21:55:31.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":10602394,"change_date":"2024-08-27 21:43:00","inspection_id":"82500177","insp_unit_id":"202612310","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"187","insp_unit_license":"1M15511","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y7TW065992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:50.000000Z","updated_at":"2025-03-17T23:32:50.000000Z"},{"id":10602395,"change_date":"2024-08-27 21:43:00","inspection_id":"82500177","insp_unit_id":"202612311","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"9112LA","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU343220FS000636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:50.000000Z","updated_at":"2025-03-17T23:32:50.000000Z"}]},{"id":4712644,"change_date":"2024-12-10 21:41:00","inspection_id":"80479339","dot_number":"2630438","report_state":"TX","report_number":"6R6A9DCEHJ","insp_date":"2023-12-20 00:00:00","insp_start_time":"0952","insp_end_time":"1045","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"845 W 28TH ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"9","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9155787","transaction_code":"C","transaction_date":"2024-12-10 00:00:00","upload_date":"2024-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2023-12-27 21:42:00","snet_input_date":"2023-12-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-27 21:42:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T19:56:11.000000Z","updated_at":"2025-03-17T19:56:11.000000Z","inspection_violations":[{"id":7275998,"change_date":"2024-12-10 21:41:00","inspection_id":"80479339","insp_violation_id":"263365273","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204300450","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3922RG"},{"id":7275999,"change_date":"2024-12-10 21:41:00","inspection_id":"80479339","insp_violation_id":"263365274","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204300450","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3939"},{"id":7276000,"change_date":"2024-12-10 21:41:00","inspection_id":"80479339","insp_violation_id":"263365275","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204300450","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3939"},{"id":7276001,"change_date":"2024-12-10 21:41:00","inspection_id":"80479339","insp_violation_id":"263365276","seq_no":"4","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"204300450","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39360D"},{"id":7276002,"change_date":"2024-12-10 21:41:00","inspection_id":"80479339","insp_violation_id":"263365277","seq_no":"5","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"204300450","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3939H"},{"id":7276003,"change_date":"2024-12-10 21:41:00","inspection_id":"80479339","insp_violation_id":"263365278","seq_no":"6","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"204300451","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39375C"},{"id":7276004,"change_date":"2024-12-10 21:41:00","inspection_id":"80479339","insp_violation_id":"263365279","seq_no":"7","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"204300451","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39375C"},{"id":7276005,"change_date":"2024-12-10 21:41:00","inspection_id":"80479339","insp_violation_id":"263365280","seq_no":"8","part_no":"393","part_no_section":"207A","insp_viol_unit":"1","insp_unit_id":"204300450","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"393207A"},{"id":7276006,"change_date":"2024-12-10 21:41:00","inspection_id":"80479339","insp_violation_id":"263365281","seq_no":"9","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"204300450","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":7580068,"change_date":"2024-12-10 21:41:00","inspection_id":"80479339","insp_unit_id":"204300450","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"585","insp_unit_license":"1M36822","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X9TR724180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:47.000000Z","updated_at":"2025-03-17T23:03:47.000000Z"},{"id":7580069,"change_date":"2024-12-10 21:41:00","inspection_id":"80479339","insp_unit_id":"204300451","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"172B094","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU34322XMS000236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:47.000000Z","updated_at":"2025-03-17T23:03:47.000000Z"}]},{"id":4634276,"change_date":"2024-12-04 21:42:00","inspection_id":"80393561","dot_number":"2630438","report_state":"TX","report_number":"6QU79DCEGF","insp_date":"2023-12-08 00:00:00","insp_start_time":"0654","insp_end_time":"0740","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3300  BRINKMAN ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"9146823","transaction_code":"C","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2023-12-14 21:43:00","snet_input_date":"2023-12-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-14 21:43:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T19:54:35.000000Z","updated_at":"2025-03-17T19:54:35.000000Z","inspection_violations":[{"id":7162759,"change_date":"2024-12-04 21:42:00","inspection_id":"80393561","insp_violation_id":"263233104","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204184224","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"3922RG"},{"id":7162760,"change_date":"2024-12-04 21:42:00","inspection_id":"80393561","insp_violation_id":"263233105","seq_no":"2","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"204184224","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"3939H"},{"id":7162761,"change_date":"2024-12-04 21:42:00","inspection_id":"80393561","insp_violation_id":"263233106","seq_no":"3","part_no":"393","part_no_section":"75A1","insp_viol_unit":"1","insp_unit_id":"204184224","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"39375A1"},{"id":7162762,"change_date":"2024-12-04 21:42:00","inspection_id":"80393561","insp_violation_id":"263233107","seq_no":"4","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"204184224","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"39375C"},{"id":7162763,"change_date":"2024-12-04 21:42:00","inspection_id":"80393561","insp_violation_id":"263233108","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204184224","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"3939"},{"id":7162764,"change_date":"2024-12-04 21:42:00","inspection_id":"80393561","insp_violation_id":"263233109","seq_no":"6","part_no":"393","part_no_section":"205C","insp_viol_unit":"1","insp_unit_id":"204184224","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"393205C"},{"id":7162765,"change_date":"2024-12-04 21:42:00","inspection_id":"80393561","insp_violation_id":"263233110","seq_no":"7","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"204184224","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"39379"},{"id":7162766,"change_date":"2024-12-04 21:42:00","inspection_id":"80393561","insp_violation_id":"263233111","seq_no":"8","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"204184224","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"39360D"},{"id":7162767,"change_date":"2024-12-04 21:42:00","inspection_id":"80393561","insp_violation_id":"263233112","seq_no":"9","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"204184225","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"39355E"},{"id":7162768,"change_date":"2024-12-04 21:42:00","inspection_id":"80393561","insp_violation_id":"263233113","seq_no":"10","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"204184225","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7453761,"change_date":"2024-12-04 21:42:00","inspection_id":"80393561","insp_unit_id":"204184224","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"187","insp_unit_license":"1M15511","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y7TW065992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:39.000000Z","updated_at":"2025-03-17T23:02:39.000000Z"},{"id":7453762,"change_date":"2024-12-04 21:42:00","inspection_id":"80393561","insp_unit_id":"204184225","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"9112LA","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU343220FS000636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:39.000000Z","updated_at":"2025-03-17T23:02:39.000000Z"}]},{"id":4426183,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","dot_number":"2630438","report_state":"TX","report_number":"6Q1D9DCOW6","insp_date":"2023-11-09 00:00:00","insp_start_time":"1328","insp_end_time":"1355","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3800 N SHEPHERD DR","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"A SANCHEZ TRUCKING","shipping_paper_number":"187","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"22","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"22","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9125159","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2023-11-14 21:42:00","snet_input_date":"2023-11-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-14 21:42:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T19:50:42.000000Z","updated_at":"2025-03-17T19:50:42.000000Z","inspection_violations":[{"id":6850494,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399608","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198063823","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3922"},{"id":6850495,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399609","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198063823","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39378"},{"id":6850496,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399610","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"198063823","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39360C"},{"id":6850497,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399611","seq_no":"4","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"198063823","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39360D"},{"id":6850498,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399612","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198063823","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3939A"},{"id":6850499,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399613","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"198063823","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39375C"},{"id":6850500,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399614","seq_no":"7","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"198063823","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"393205C"},{"id":6850501,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399615","seq_no":"8","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"198063823","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39383G"},{"id":6850502,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399616","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198063823","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3963A1"},{"id":6850503,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399617","seq_no":"10","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"198063823","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3965B"},{"id":6850504,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399618","seq_no":"11","part_no":"393","part_no_section":"47(c)","insp_viol_unit":"1","insp_unit_id":"198063823","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39347C"},{"id":6850505,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399619","seq_no":"12","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198063823","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39347E"},{"id":6850506,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399620","seq_no":"13","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198063823","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39347E"},{"id":6850507,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399621","seq_no":"14","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"198063823","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39353B"},{"id":6850508,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399622","seq_no":"15","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198063824","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39617C"},{"id":6850509,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399623","seq_no":"16","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"198063824","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39355E"},{"id":6850510,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399624","seq_no":"17","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198063824","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3939A"},{"id":6850511,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399625","seq_no":"18","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"198063824","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39345B2"},{"id":6850512,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399626","seq_no":"19","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"198063824","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39345B2"},{"id":6850513,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399627","seq_no":"20","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"198063824","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39345B2"},{"id":6850514,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399628","seq_no":"21","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"198063824","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39343"},{"id":6850515,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_violation_id":"256399629","seq_no":"22","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198063823","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7118314,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_unit_id":"198063823","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"187","insp_unit_license":"1M15511","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y7TW065992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:46.000000Z","updated_at":"2025-03-17T22:59:46.000000Z"},{"id":7118315,"change_date":"2023-11-14 21:42:00","inspection_id":"80164798","insp_unit_id":"198063824","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"9112LA","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU343220FS000636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:46.000000Z","updated_at":"2025-03-17T22:59:46.000000Z"}]},{"id":4426443,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","dot_number":"2630438","report_state":"TX","report_number":"6Q1E9DCOW7","insp_date":"2023-11-09 00:00:00","insp_start_time":"1439","insp_end_time":"1505","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3800 N SHEPHERD DR","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SCR","shipping_paper_number":"585","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"16","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"16","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9125160","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2023-11-14 21:42:00","snet_input_date":"2023-11-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-14 21:42:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T19:50:42.000000Z","updated_at":"2025-03-17T19:50:42.000000Z","inspection_violations":[{"id":6851230,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400792","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198064408","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39378"},{"id":6851231,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400793","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198064408","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39378"},{"id":6851232,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400794","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"198064408","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39360D"},{"id":6851233,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400795","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"198064408","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39345B2"},{"id":6851234,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400796","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"198064408","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39345B2"},{"id":6851235,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400797","seq_no":"6","part_no":"393","part_no_section":"43(a)","insp_viol_unit":"1","insp_unit_id":"198064408","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39343A"},{"id":6851236,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400798","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198064408","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39347E"},{"id":6851237,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400799","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198064408","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39347E"},{"id":6851238,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400800","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198064408","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39347E"},{"id":6851239,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400801","seq_no":"10","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"198064408","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39353B"},{"id":6851240,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400802","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198064408","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3922"},{"id":6851241,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400803","seq_no":"12","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198064408","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3922"},{"id":6851242,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400804","seq_no":"13","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"198064409","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39345B2"},{"id":6851243,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400805","seq_no":"14","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"198064409","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39347E"},{"id":6851244,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400806","seq_no":"15","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"198064409","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39353B"},{"id":6851245,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_violation_id":"256400807","seq_no":"16","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198064408","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7118745,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_unit_id":"198064408","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"585","insp_unit_license":"1M36822","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X9TR724180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:46.000000Z","updated_at":"2025-03-17T22:59:46.000000Z"},{"id":7118746,"change_date":"2023-11-14 21:42:00","inspection_id":"80165082","insp_unit_id":"198064409","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"172B094","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU34322XMS000236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:46.000000Z","updated_at":"2025-03-17T22:59:46.000000Z"}]},{"id":4364991,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","dot_number":"2630438","report_state":"TX","report_number":"6PS99DAP5R","insp_date":"2023-10-31 00:00:00","insp_start_time":"0924","insp_end_time":"1041","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"900  PRESTON AVE SB","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"111000","viol_total":"24","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"24","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9117958","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2023-11-06 21:42:00","snet_input_date":"2023-10-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-06 21:42:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T19:49:30.000000Z","updated_at":"2025-03-17T19:49:30.000000Z","inspection_violations":[{"id":6752828,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245059","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39360D"},{"id":6752829,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245060","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3963A1"},{"id":6752830,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245061","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3965B"},{"id":6752831,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245062","seq_no":"4","part_no":"393","part_no_section":"65(f)","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39365F"},{"id":6752832,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245063","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197930016","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39347E"},{"id":6752833,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245064","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"197930016","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39353B"},{"id":6752834,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245065","seq_no":"7","part_no":"393","part_no_section":"47(b)","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39347B"},{"id":6752835,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245066","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39347E"},{"id":6752836,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245067","seq_no":"24","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"},{"id":6752837,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245068","seq_no":"9","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39353B"},{"id":6752838,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245069","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3963A1"},{"id":6752839,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245070","seq_no":"11","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"197930016","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39355D3"},{"id":6752840,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245071","seq_no":"12","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"2","insp_unit_id":"197930016","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39355D2"},{"id":6752841,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245072","seq_no":"13","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39378"},{"id":6752842,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245073","seq_no":"14","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39378"},{"id":6752843,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245074","seq_no":"15","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39395B"},{"id":6752844,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245075","seq_no":"16","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39345B2"},{"id":6752845,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245076","seq_no":"17","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39345B2"},{"id":6752846,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245077","seq_no":"18","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3963A1"},{"id":6752847,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245078","seq_no":"19","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"},{"id":6752848,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245079","seq_no":"20","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197930016","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"},{"id":6752849,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245080","seq_no":"21","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197930015","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"},{"id":6752850,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245081","seq_no":"22","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197930016","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"},{"id":6752851,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_violation_id":"256245082","seq_no":"23","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197930016","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7020502,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_unit_id":"197930015","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"585","insp_unit_license":"1M36822","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X9TR724180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:56.000000Z","updated_at":"2025-03-17T22:58:56.000000Z"},{"id":7020503,"change_date":"2023-11-06 21:42:00","inspection_id":"80096929","insp_unit_id":"197930016","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"172B094","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU34322XMS000236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:56.000000Z","updated_at":"2025-03-17T22:58:56.000000Z"}]},{"id":4365018,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","dot_number":"2630438","report_state":"TX","report_number":"6PSA9DGXMF","insp_date":"2023-10-31 00:00:00","insp_start_time":"1041","insp_end_time":"1139","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1800 E SAM HOUSTON P","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"27","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"27","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9117976","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2023-11-06 21:42:00","snet_input_date":"2023-10-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-06 21:42:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T19:49:30.000000Z","updated_at":"2025-03-17T19:49:30.000000Z","inspection_violations":[{"id":6753013,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245285","seq_no":"20","part_no":"393","part_no_section":"65(f)","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39365F"},{"id":6753014,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245286","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"},{"id":6753015,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245287","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197930065","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"},{"id":6753016,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245288","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3939A"},{"id":6753017,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245289","seq_no":"4","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39360D"},{"id":6753018,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245290","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3939A"},{"id":6753019,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245291","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197930065","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3963A1"},{"id":6753020,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245292","seq_no":"7","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"393209D"},{"id":6753021,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245293","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39347E"},{"id":6753022,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245294","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39347E"},{"id":6753023,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245295","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197930065","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39347E"},{"id":6753024,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245296","seq_no":"11","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197930065","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39347E"},{"id":6753025,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245297","seq_no":"12","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39353B"},{"id":6753026,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245298","seq_no":"13","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"197930065","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39353B"},{"id":6753027,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245299","seq_no":"14","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3963A1"},{"id":6753028,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245300","seq_no":"15","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39348A"},{"id":6753029,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245301","seq_no":"16","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39360C"},{"id":6753030,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245302","seq_no":"17","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39355C1"},{"id":6753031,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245303","seq_no":"18","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39345B2"},{"id":6753032,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245304","seq_no":"19","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39383G"},{"id":6753033,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245305","seq_no":"21","part_no":"393","part_no_section":"28","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39328"},{"id":6753034,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245306","seq_no":"22","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"197930065","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39345"},{"id":6753035,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245307","seq_no":"23","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"197930065","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39345"},{"id":6753036,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245308","seq_no":"24","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3965B"},{"id":6753037,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245309","seq_no":"25","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197930064","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"},{"id":6753038,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245310","seq_no":"26","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197930065","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"},{"id":6753039,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_violation_id":"256245311","seq_no":"27","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197930065","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7020542,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_unit_id":"197930064","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"911","insp_unit_license":"1M75245","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9XXVR748622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:56.000000Z","updated_at":"2025-03-17T22:58:56.000000Z"},{"id":7020543,"change_date":"2023-11-06 21:42:00","inspection_id":"80096961","insp_unit_id":"197930065","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":"02","insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC513225CP012711","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:56.000000Z","updated_at":"2025-03-17T22:58:56.000000Z"}]},{"id":4106180,"change_date":"2023-10-02 21:41:00","inspection_id":"79811092","dot_number":"2630438","report_state":"TX","report_number":"6OSD9DBA07","insp_date":"2023-09-25 00:00:00","insp_start_time":"1315","insp_end_time":"1415","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN HARRIS CO. (115-151","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"A SANCHEZ 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":"2023-10-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9088970","transaction_code":"A","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2023-10-02 21:41:00","snet_input_date":"2023-09-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-02 21:41:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T19:44:02.000000Z","updated_at":"2025-03-17T19:44:02.000000Z","inspection_violations":[{"id":6353647,"change_date":"2023-10-02 21:41:00","inspection_id":"79811092","insp_violation_id":"255607194","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197354015","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:37.000000Z","updated_at":"2025-03-17T21:36:37.000000Z","normalized_code":"3939A"},{"id":6353648,"change_date":"2023-10-02 21:41:00","inspection_id":"79811092","insp_violation_id":"255607195","seq_no":"9","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"197354014","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:37.000000Z","updated_at":"2025-03-17T21:36:37.000000Z","normalized_code":"39355D1"},{"id":6353649,"change_date":"2023-10-02 21:41:00","inspection_id":"79811092","insp_violation_id":"255607196","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197354014","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:37.000000Z","updated_at":"2025-03-17T21:36:37.000000Z","normalized_code":"3922"},{"id":6353650,"change_date":"2023-10-02 21:41:00","inspection_id":"79811092","insp_violation_id":"255607197","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197354015","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:37.000000Z","updated_at":"2025-03-17T21:36:37.000000Z","normalized_code":"3922"},{"id":6353651,"change_date":"2023-10-02 21:41:00","inspection_id":"79811092","insp_violation_id":"255607198","seq_no":"3","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"197354014","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:37.000000Z","updated_at":"2025-03-17T21:36:37.000000Z","normalized_code":"393203C"},{"id":6353652,"change_date":"2023-10-02 21:41:00","inspection_id":"79811092","insp_violation_id":"255607199","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197354014","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:37.000000Z","updated_at":"2025-03-17T21:36:37.000000Z","normalized_code":"3939A"},{"id":6353653,"change_date":"2023-10-02 21:41:00","inspection_id":"79811092","insp_violation_id":"255607200","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"197354014","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:37.000000Z","updated_at":"2025-03-17T21:36:37.000000Z","normalized_code":"39375A3"},{"id":6353654,"change_date":"2023-10-02 21:41:00","inspection_id":"79811092","insp_violation_id":"255607201","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197354015","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:37.000000Z","updated_at":"2025-03-17T21:36:37.000000Z","normalized_code":"3939A"},{"id":6353655,"change_date":"2023-10-02 21:41:00","inspection_id":"79811092","insp_violation_id":"255607202","seq_no":"7","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"197354014","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:37.000000Z","updated_at":"2025-03-17T21:36:37.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":6602274,"change_date":"2023-10-02 21:41:00","inspection_id":"79811092","insp_unit_id":"197354014","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M75245","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9XXVR748622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:23.000000Z","updated_at":"2025-03-17T22:55:23.000000Z"},{"id":6602275,"change_date":"2023-10-02 21:41:00","inspection_id":"79811092","insp_unit_id":"197354015","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":null,"insp_unit_license":"012C724","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC513225CP012711","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:23.000000Z","updated_at":"2025-03-17T22:55:23.000000Z"}]},{"id":4026353,"change_date":"2023-09-21 21:41:00","inspection_id":"79722021","dot_number":"2630438","report_state":"TX","report_number":"6OLF9DJVND","insp_date":"2023-09-18 00:00:00","insp_start_time":"1528","insp_end_time":"1556","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":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9080991","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":"02630438","upload_search_indicator":"M","census_search_date":"2023-09-21 21:41:00","snet_input_date":"2023-09-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-21 21:41:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T19:42:24.000000Z","updated_at":"2025-03-17T19:42:24.000000Z","inspection_violations":[{"id":6232511,"change_date":"2023-09-21 21:41:00","inspection_id":"79722021","insp_violation_id":"255408777","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197173302","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:05.000000Z","updated_at":"2025-03-17T21:36:05.000000Z","normalized_code":"3922"},{"id":6232512,"change_date":"2023-09-21 21:41:00","inspection_id":"79722021","insp_violation_id":"255408778","seq_no":"2","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"197173302","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:05.000000Z","updated_at":"2025-03-17T21:36:05.000000Z","normalized_code":"999"},{"id":6232513,"change_date":"2023-09-21 21:41:00","inspection_id":"79722021","insp_violation_id":"255408779","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"197173303","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:05.000000Z","updated_at":"2025-03-17T21:36:05.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":6474111,"change_date":"2023-09-21 21:41:00","inspection_id":"79722021","insp_unit_id":"197173302","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"1M15511","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y7TW065992","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":6474112,"change_date":"2023-09-21 21:41:00","inspection_id":"79722021","insp_unit_id":"197173303","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"9112LA","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU343220FS000636","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":3286778,"change_date":"2023-06-14 21:42:00","inspection_id":"78894390","dot_number":"2630438","report_state":"TX","report_number":"6LVF9DJVC2","insp_date":"2023-06-12 00:00:00","insp_start_time":"1453","insp_end_time":"1523","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-06-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9005238","transaction_code":"A","transaction_date":"2023-06-14 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2023-06-14 21:42:00","snet_input_date":"2023-06-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-14 21:42:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T19:28:08.000000Z","updated_at":"2025-03-17T19:28:08.000000Z","inspection_violations":[{"id":5069609,"change_date":"2023-06-14 21:42:00","inspection_id":"78894390","insp_violation_id":"253511497","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195502644","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:34.000000Z","updated_at":"2025-03-17T21:30:34.000000Z","normalized_code":"39617C"},{"id":5069610,"change_date":"2023-06-14 21:42:00","inspection_id":"78894390","insp_violation_id":"253511498","seq_no":"2","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"195502644","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:34.000000Z","updated_at":"2025-03-17T21:30:34.000000Z","normalized_code":"999"},{"id":5069611,"change_date":"2023-06-14 21:42:00","inspection_id":"78894390","insp_violation_id":"253511499","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195502644","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:34.000000Z","updated_at":"2025-03-17T21:30:34.000000Z","normalized_code":"3939A"},{"id":5069612,"change_date":"2023-06-14 21:42:00","inspection_id":"78894390","insp_violation_id":"253511500","seq_no":"4","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"195502644","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:34.000000Z","updated_at":"2025-03-17T21:30:34.000000Z","normalized_code":"39319"},{"id":5069613,"change_date":"2023-06-14 21:42:00","inspection_id":"78894390","insp_violation_id":"253511501","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195502644","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:34.000000Z","updated_at":"2025-03-17T21:30:34.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5284771,"change_date":"2023-06-14 21:42:00","inspection_id":"78894390","insp_unit_id":"195502644","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"1M15511","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y7TW065992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:38.000000Z","updated_at":"2025-03-17T22:44:38.000000Z"},{"id":5284772,"change_date":"2023-06-14 21:42:00","inspection_id":"78894390","insp_unit_id":"195502645","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"9112LA","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU343220FS000636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:38.000000Z","updated_at":"2025-03-17T22:44:38.000000Z"}]},{"id":3251527,"change_date":"2023-06-09 21:41:00","inspection_id":"78854442","dot_number":"2630438","report_state":"TX","report_number":"6LQ79DCGRP","insp_date":"2023-06-07 00:00:00","insp_start_time":"0725","insp_end_time":"0813","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2800  CAVALCADE","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-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"11","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9001016","transaction_code":"A","transaction_date":"2023-06-09 00:00:00","upload_date":"2023-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2023-06-09 21:41:00","snet_input_date":"2023-06-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-09 21:41:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T19:27:21.000000Z","updated_at":"2025-03-17T19:27:21.000000Z","inspection_violations":[{"id":5014794,"change_date":"2023-06-09 21:41:00","inspection_id":"78854442","insp_violation_id":"253417765","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195423077","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:19.000000Z","updated_at":"2025-03-17T21:30:19.000000Z","normalized_code":"3922"},{"id":5014795,"change_date":"2023-06-09 21:41:00","inspection_id":"78854442","insp_violation_id":"253417766","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195423077","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:19.000000Z","updated_at":"2025-03-17T21:30:19.000000Z","normalized_code":"39617C"},{"id":5014796,"change_date":"2023-06-09 21:41:00","inspection_id":"78854442","insp_violation_id":"253417767","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195423077","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:19.000000Z","updated_at":"2025-03-17T21:30:19.000000Z","normalized_code":"39378"},{"id":5014797,"change_date":"2023-06-09 21:41:00","inspection_id":"78854442","insp_violation_id":"253417768","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195423077","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:19.000000Z","updated_at":"2025-03-17T21:30:19.000000Z","normalized_code":"3939A"},{"id":5014798,"change_date":"2023-06-09 21:41:00","inspection_id":"78854442","insp_violation_id":"253417769","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195423077","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:19.000000Z","updated_at":"2025-03-17T21:30:19.000000Z","normalized_code":"39395A"},{"id":5014799,"change_date":"2023-06-09 21:41:00","inspection_id":"78854442","insp_violation_id":"253417770","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195423077","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:19.000000Z","updated_at":"2025-03-17T21:30:19.000000Z","normalized_code":"3922"},{"id":5014800,"change_date":"2023-06-09 21:41:00","inspection_id":"78854442","insp_violation_id":"253417771","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195423077","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:19.000000Z","updated_at":"2025-03-17T21:30:19.000000Z","normalized_code":"3922"},{"id":5014801,"change_date":"2023-06-09 21:41:00","inspection_id":"78854442","insp_violation_id":"253417772","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"195423078","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:19.000000Z","updated_at":"2025-03-17T21:30:19.000000Z","normalized_code":"39617C"},{"id":5014802,"change_date":"2023-06-09 21:41:00","inspection_id":"78854442","insp_violation_id":"253417773","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195423078","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:19.000000Z","updated_at":"2025-03-17T21:30:19.000000Z","normalized_code":"3922"},{"id":5014803,"change_date":"2023-06-09 21:41:00","inspection_id":"78854442","insp_violation_id":"253417774","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195423078","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:19.000000Z","updated_at":"2025-03-17T21:30:19.000000Z","normalized_code":"3922"},{"id":5014804,"change_date":"2023-06-09 21:41:00","inspection_id":"78854442","insp_violation_id":"253417775","seq_no":"11","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"195423078","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:30:19.000000Z","updated_at":"2025-03-17T21:30:19.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":5229693,"change_date":"2023-06-09 21:41:00","inspection_id":"78854442","insp_unit_id":"195423077","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M75245","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9XXVR748622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:12.000000Z","updated_at":"2025-03-17T22:44:12.000000Z"},{"id":5229694,"change_date":"2023-06-09 21:41:00","inspection_id":"78854442","insp_unit_id":"195423078","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC513225CP012711","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:12.000000Z","updated_at":"2025-03-17T22:44:12.000000Z"}]},{"id":3276525,"change_date":"2023-06-13 21:42:00","inspection_id":"78882817","dot_number":"2630438","report_state":"TX","report_number":"6LOC9DBAVQ","insp_date":"2023-06-05 00:00:00","insp_start_time":"1210","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN HARRIS CO. (115-151","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"A SANCHEZ 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":"2023-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9003115","transaction_code":"A","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2023-06-13 21:42:00","snet_input_date":"2023-06-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-13 21:42:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T19:27:45.000000Z","updated_at":"2025-03-17T19:27:45.000000Z","inspection_violations":[{"id":5052616,"change_date":"2023-06-13 21:42:00","inspection_id":"78882817","insp_violation_id":"253482752","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195479143","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"39378"},{"id":5052617,"change_date":"2023-06-13 21:42:00","inspection_id":"78882817","insp_violation_id":"253482753","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195479143","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"39395A"},{"id":5052618,"change_date":"2023-06-13 21:42:00","inspection_id":"78882817","insp_violation_id":"253482754","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195479143","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"3939A"},{"id":5052619,"change_date":"2023-06-13 21:42:00","inspection_id":"78882817","insp_violation_id":"253482755","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195479143","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"39311"},{"id":5052620,"change_date":"2023-06-13 21:42:00","inspection_id":"78882817","insp_violation_id":"253482756","seq_no":"5","part_no":"393","part_no_section":"13(c)(1)","insp_viol_unit":"2","insp_unit_id":"195479144","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"39313C1"},{"id":5052621,"change_date":"2023-06-13 21:42:00","inspection_id":"78882817","insp_violation_id":"253482757","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195479144","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"3939A"},{"id":5052622,"change_date":"2023-06-13 21:42:00","inspection_id":"78882817","insp_violation_id":"253482758","seq_no":"7","part_no":"393","part_no_section":"13(c)(2)","insp_viol_unit":"2","insp_unit_id":"195479144","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"39313C2"},{"id":5052623,"change_date":"2023-06-13 21:42:00","inspection_id":"78882817","insp_violation_id":"253482759","seq_no":"8","part_no":"393","part_no_section":"13(c)(3)","insp_viol_unit":"2","insp_unit_id":"195479144","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"39313C3"},{"id":5052624,"change_date":"2023-06-13 21:42:00","inspection_id":"78882817","insp_violation_id":"253482760","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195479143","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"3922"},{"id":5052625,"change_date":"2023-06-13 21:42:00","inspection_id":"78882817","insp_violation_id":"253482761","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195479144","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"3922"},{"id":5052626,"change_date":"2023-06-13 21:42:00","inspection_id":"78882817","insp_violation_id":"253482762","seq_no":"11","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"195479143","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"39355D1"},{"id":5052627,"change_date":"2023-06-13 21:42:00","inspection_id":"78882817","insp_violation_id":"253482763","seq_no":"12","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"195479143","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"393203C"}],"inspection_per_units":[{"id":5268506,"change_date":"2023-06-13 21:42:00","inspection_id":"78882817","insp_unit_id":"195479143","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"1M75245","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9XXVR748622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:31.000000Z","updated_at":"2025-03-17T22:44:31.000000Z"},{"id":5268507,"change_date":"2023-06-13 21:42:00","inspection_id":"78882817","insp_unit_id":"195479144","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"9112LA","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU343220FS000636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:31.000000Z","updated_at":"2025-03-17T22:44:31.000000Z"}]},{"id":2802269,"change_date":"2023-04-13 21:43:00","inspection_id":"78346867","dot_number":"2630438","report_state":"TX","report_number":"6JZD9DJNI3","insp_date":"2023-04-05 00:00:00","insp_start_time":"1337","insp_end_time":"1356","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":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-04-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"11","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8952719","transaction_code":"A","transaction_date":"2023-04-13 00:00:00","upload_date":"2023-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2023-04-13 21:43:00","snet_input_date":"2023-04-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-13 21:43:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T19:18:28.000000Z","updated_at":"2025-03-17T19:18:28.000000Z","inspection_violations":[{"id":4301258,"change_date":"2023-04-13 21:43:00","inspection_id":"78346867","insp_violation_id":"252218776","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194382051","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:08.000000Z","updated_at":"2025-03-17T21:27:08.000000Z","normalized_code":"39378"},{"id":4301259,"change_date":"2023-04-13 21:43:00","inspection_id":"78346867","insp_violation_id":"252218777","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194382051","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:08.000000Z","updated_at":"2025-03-17T21:27:08.000000Z","normalized_code":"3939A"},{"id":4301260,"change_date":"2023-04-13 21:43:00","inspection_id":"78346867","insp_violation_id":"252218778","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"194382051","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:08.000000Z","updated_at":"2025-03-17T21:27:08.000000Z","normalized_code":"39345B2"},{"id":4301261,"change_date":"2023-04-13 21:43:00","inspection_id":"78346867","insp_violation_id":"252218779","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"194382051","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:08.000000Z","updated_at":"2025-03-17T21:27:08.000000Z","normalized_code":"39347E"},{"id":4301262,"change_date":"2023-04-13 21:43:00","inspection_id":"78346867","insp_violation_id":"252218780","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"194382051","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:08.000000Z","updated_at":"2025-03-17T21:27:08.000000Z","normalized_code":"39347E"},{"id":4301263,"change_date":"2023-04-13 21:43:00","inspection_id":"78346867","insp_violation_id":"252218781","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"194382052","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:08.000000Z","updated_at":"2025-03-17T21:27:08.000000Z","normalized_code":"39347E"},{"id":4301264,"change_date":"2023-04-13 21:43:00","inspection_id":"78346867","insp_violation_id":"252218782","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"194382051","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:08.000000Z","updated_at":"2025-03-17T21:27:08.000000Z","normalized_code":"39353B"},{"id":4301265,"change_date":"2023-04-13 21:43:00","inspection_id":"78346867","insp_violation_id":"252218783","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194382051","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:27:08.000000Z","updated_at":"2025-03-17T21:27:08.000000Z","normalized_code":"3963A1"},{"id":4301266,"change_date":"2023-04-13 21:43:00","inspection_id":"78346867","insp_violation_id":"252218784","seq_no":"9","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"194382051","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:08.000000Z","updated_at":"2025-03-17T21:27:08.000000Z","normalized_code":"39360D"},{"id":4301267,"change_date":"2023-04-13 21:43:00","inspection_id":"78346867","insp_violation_id":"252218785","seq_no":"10","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"194382052","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:08.000000Z","updated_at":"2025-03-17T21:27:08.000000Z","normalized_code":"39345B2"},{"id":4301268,"change_date":"2023-04-13 21:43:00","inspection_id":"78346867","insp_violation_id":"252218786","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194382051","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:08.000000Z","updated_at":"2025-03-17T21:27:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4510305,"change_date":"2023-04-13 21:43:00","inspection_id":"78346867","insp_unit_id":"194382051","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"585","insp_unit_license":"1M36822","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X9TR724180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:34.000000Z","updated_at":"2025-03-17T22:38:34.000000Z"},{"id":4510306,"change_date":"2023-04-13 21:43:00","inspection_id":"78346867","insp_unit_id":"194382052","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"172B094","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU34322XMS000236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:34.000000Z","updated_at":"2025-03-17T22:38:34.000000Z"}]},{"id":2159882,"change_date":"2023-01-17 21:42:00","inspection_id":"77615465","dot_number":"2630438","report_state":"TX","report_number":"6HIE9DCGJ0","insp_date":"2023-01-06 00:00:00","insp_start_time":"1408","insp_end_time":"1428","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN HARRIS CO. (115-151","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-01-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8877774","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2023-01-17 21:42:00","snet_input_date":"2023-01-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-17 21:42:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T19:06:18.000000Z","updated_at":"2025-03-17T19:06:18.000000Z","inspection_violations":[{"id":3338971,"change_date":"2023-01-17 21:42:00","inspection_id":"77615465","insp_violation_id":"250613304","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192910493","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:22:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"3963A1"},{"id":3338972,"change_date":"2023-01-17 21:42:00","inspection_id":"77615465","insp_violation_id":"250613305","seq_no":"2","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"2","insp_unit_id":"192910494","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"39355C2"}],"inspection_per_units":[{"id":3476126,"change_date":"2023-01-17 21:42:00","inspection_id":"77615465","insp_unit_id":"192910493","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"1M15511","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y7TW065992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:56.000000Z","updated_at":"2025-03-17T22:30:56.000000Z"},{"id":3476127,"change_date":"2023-01-17 21:42:00","inspection_id":"77615465","insp_unit_id":"192910494","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"9112LA","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU343220FS000636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:56.000000Z","updated_at":"2025-03-17T22:30:56.000000Z"}]},{"id":1595751,"change_date":"2022-10-25 21:41:00","inspection_id":"76968978","dot_number":"2630438","report_state":"TX","report_number":"6EWD9DJN83","insp_date":"2022-10-04 00:00:00","insp_start_time":"1311","insp_end_time":"1354","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1600  MEMORIAL DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-10-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8808828","transaction_code":"A","transaction_date":"2022-10-25 00:00:00","upload_date":"2022-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":null,"census_search_date":"2022-10-25 21:41:00","snet_input_date":"2022-10-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-25 21:41:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T18:55:58.000000Z","updated_at":"2025-03-17T18:55:58.000000Z","inspection_violations":[{"id":2507493,"change_date":"2022-10-25 21:41:00","inspection_id":"76968978","insp_violation_id":"249240034","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191631319","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:47.000000Z","updated_at":"2025-03-17T21:18:47.000000Z","normalized_code":"3939A"},{"id":2507494,"change_date":"2022-10-25 21:41:00","inspection_id":"76968978","insp_violation_id":"249240035","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191631319","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:47.000000Z","updated_at":"2025-03-17T21:18:47.000000Z","normalized_code":"3939A"},{"id":2507495,"change_date":"2022-10-25 21:41:00","inspection_id":"76968978","insp_violation_id":"249240036","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"191631318","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:47.000000Z","updated_at":"2025-03-17T21:18:47.000000Z","normalized_code":"39395F"},{"id":2507496,"change_date":"2022-10-25 21:41:00","inspection_id":"76968978","insp_violation_id":"249240037","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191631318","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:47.000000Z","updated_at":"2025-03-17T21:18:47.000000Z","normalized_code":"39378"},{"id":2507497,"change_date":"2022-10-25 21:41:00","inspection_id":"76968978","insp_violation_id":"249240038","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191631318","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:47.000000Z","updated_at":"2025-03-17T21:18:47.000000Z","normalized_code":"39378"},{"id":2507498,"change_date":"2022-10-25 21:41:00","inspection_id":"76968978","insp_violation_id":"249240039","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191631319","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:47.000000Z","updated_at":"2025-03-17T21:18:47.000000Z","normalized_code":"3922"},{"id":2507499,"change_date":"2022-10-25 21:41:00","inspection_id":"76968978","insp_violation_id":"249240040","seq_no":"7","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"191631318","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:47.000000Z","updated_at":"2025-03-17T21:18:47.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":2567778,"change_date":"2022-10-25 21:41:00","inspection_id":"76968978","insp_unit_id":"191631318","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"585","insp_unit_license":"1M36822","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X9TR72418","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:36.000000Z","updated_at":"2025-03-17T22:24:36.000000Z"},{"id":2567779,"change_date":"2022-10-25 21:41:00","inspection_id":"76968978","insp_unit_id":"191631319","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"172B094","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU34322XMS000236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:36.000000Z","updated_at":"2025-03-17T22:24:36.000000Z"}]},{"id":1149263,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","dot_number":"2630438","report_state":"TX","report_number":"6DKA9DCG8R","insp_date":"2022-08-17 00:00:00","insp_start_time":"1022","insp_end_time":"1110","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6600  RANKIN","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-08-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"13","oos_total":"4","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8754384","transaction_code":"A","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2022-08-26 21:40:00","snet_input_date":"2022-08-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-26 21:40:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T18:47:55.000000Z","updated_at":"2025-03-17T18:47:55.000000Z","inspection_violations":[{"id":1821018,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","insp_violation_id":"248038265","seq_no":"1","part_no":"383","part_no_section":"51(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"38351A"},{"id":1821019,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","insp_violation_id":"248038266","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"190574204","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"39378"},{"id":1821020,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","insp_violation_id":"248038267","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190574204","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"3963A1"},{"id":1821021,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","insp_violation_id":"248038268","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190574204","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"3939A"},{"id":1821022,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","insp_violation_id":"248038269","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190574204","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"3939A"},{"id":1821023,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","insp_violation_id":"248038270","seq_no":"6","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"190574204","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"39319"},{"id":1821024,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","insp_violation_id":"248038271","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"190574204","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"3965B"},{"id":1821025,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","insp_violation_id":"248038272","seq_no":"8","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"190574204","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"3965B"},{"id":1821026,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","insp_violation_id":"248038273","seq_no":"9","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"190574204","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"39345"},{"id":1821027,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","insp_violation_id":"248038274","seq_no":"11","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"190574205","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"39355E"},{"id":1821028,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","insp_violation_id":"248038275","seq_no":"12","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"2","insp_unit_id":"190574205","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"39355C2"},{"id":1821029,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","insp_violation_id":"248038276","seq_no":"13","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"190574205","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"393207A"},{"id":1821030,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","insp_violation_id":"248038277","seq_no":"14","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"2","insp_unit_id":"190574205","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"3929A2"}],"inspection_per_units":[{"id":1847648,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","insp_unit_id":"190574204","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"1M15511","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y7TW065992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:43.000000Z","updated_at":"2025-03-17T22:19:43.000000Z"},{"id":1847649,"change_date":"2022-08-26 21:40:00","inspection_id":"76451885","insp_unit_id":"190574205","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"9112LA","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU343220FS000636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:43.000000Z","updated_at":"2025-03-17T22:19:43.000000Z"}]},{"id":1048005,"change_date":"2022-08-16 21:39:00","inspection_id":"76333324","dot_number":"2630438","report_state":"TX","report_number":"6DCE9DJVBH","insp_date":"2022-08-09 00:00:00","insp_start_time":"1407","insp_end_time":"1436","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-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8743784","transaction_code":"A","transaction_date":"2022-08-16 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2022-08-16 21:39:00","snet_input_date":"2022-08-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-16 21:39:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T18:46:10.000000Z","updated_at":"2025-03-17T18:46:10.000000Z","inspection_violations":[{"id":1650974,"change_date":"2022-08-16 21:39:00","inspection_id":"76333324","insp_violation_id":"247747820","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190336851","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39395A"},{"id":1650975,"change_date":"2022-08-16 21:39:00","inspection_id":"76333324","insp_violation_id":"247747821","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190336851","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3939A"},{"id":1650976,"change_date":"2022-08-16 21:39:00","inspection_id":"76333324","insp_violation_id":"247747822","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190336851","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3939A"},{"id":1650977,"change_date":"2022-08-16 21:39:00","inspection_id":"76333324","insp_violation_id":"247747823","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190336851","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3939A"},{"id":1650978,"change_date":"2022-08-16 21:39:00","inspection_id":"76333324","insp_violation_id":"247747824","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190336851","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3939A"},{"id":1650979,"change_date":"2022-08-16 21:39:00","inspection_id":"76333324","insp_violation_id":"247747825","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190336851","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3939A"},{"id":1650980,"change_date":"2022-08-16 21:39:00","inspection_id":"76333324","insp_violation_id":"247747826","seq_no":"8","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"190336851","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"999"},{"id":1650981,"change_date":"2022-08-16 21:39:00","inspection_id":"76333324","insp_violation_id":"247747827","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190336852","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3939A"},{"id":1650982,"change_date":"2022-08-16 21:39:00","inspection_id":"76333324","insp_violation_id":"247747828","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190336852","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3939A"},{"id":1650983,"change_date":"2022-08-16 21:39:00","inspection_id":"76333324","insp_violation_id":"247747829","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190336852","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3939A"},{"id":1650984,"change_date":"2022-08-16 21:39:00","inspection_id":"76333324","insp_violation_id":"247747830","seq_no":"12","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190336852","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3939A"},{"id":1650985,"change_date":"2022-08-16 21:39:00","inspection_id":"76333324","insp_violation_id":"247747831","seq_no":"13","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"190336851","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":1686356,"change_date":"2022-08-16 21:39:00","inspection_id":"76333324","insp_unit_id":"190336851","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"1M15511","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y7TW065992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:38.000000Z","updated_at":"2025-03-17T22:18:38.000000Z"},{"id":1686357,"change_date":"2022-08-16 21:39:00","inspection_id":"76333324","insp_unit_id":"190336852","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"9112LA","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU343220FS000636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:38.000000Z","updated_at":"2025-03-17T22:18:38.000000Z"}]},{"id":868934,"change_date":"2022-07-21 21:40:00","inspection_id":"76124157","dot_number":"2630438","report_state":"TX","report_number":"6CSG9DCO1Y","insp_date":"2022-07-20 00:00:00","insp_start_time":"1612","insp_end_time":"1630","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"15600  ALDINE WESTFI","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-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"8720465","transaction_code":"A","transaction_date":"2022-07-21 00:00:00","upload_date":"2022-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2022-07-21 21:40:00","snet_input_date":"2022-07-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-21 21:40:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T18:43:02.000000Z","updated_at":"2025-03-17T18:43:02.000000Z","inspection_violations":[{"id":1368791,"change_date":"2022-07-21 21:40:00","inspection_id":"76124157","insp_violation_id":"247244503","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"189907309","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"39378"},{"id":1368792,"change_date":"2022-07-21 21:40:00","inspection_id":"76124157","insp_violation_id":"247244504","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"189907309","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"39360D"},{"id":1368793,"change_date":"2022-07-21 21:40:00","inspection_id":"76124157","insp_violation_id":"247244505","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189907310","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"3922"},{"id":1368794,"change_date":"2022-07-21 21:40:00","inspection_id":"76124157","insp_violation_id":"247244506","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"189907310","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":1398952,"change_date":"2022-07-21 21:40:00","inspection_id":"76124157","insp_unit_id":"189907309","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"585","insp_unit_license":"1M36822","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X9TR724180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:47.000000Z","updated_at":"2025-03-17T22:16:47.000000Z"},{"id":1398953,"change_date":"2022-07-21 21:40:00","inspection_id":"76124157","insp_unit_id":"189907310","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"172B094","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU34322XMS000236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:47.000000Z","updated_at":"2025-03-17T22:16:47.000000Z"}]},{"id":608419,"change_date":"2022-06-15 21:41:00","inspection_id":"75818383","dot_number":"2630438","report_state":"TX","report_number":"6B9E9DBAKS","insp_date":"2022-05-26 00:00:00","insp_start_time":"1453","insp_end_time":"1531","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"18933  ALDINE WESTFI","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"A SANCHEZ 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":"2022-06-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8678128","transaction_code":"C","transaction_date":"2022-06-15 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02630438","upload_search_indicator":"M","census_search_date":"2022-06-14 21:43:00","snet_input_date":"2022-05-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-14 21:43:00","insp_carrier_name":"ANDRES SANCHEZ","insp_carrier_street":"12707 CRATER LAKE CT","insp_carrier_city":"HUMBLE","insp_carrier_state":"TX","insp_carrier_zip_code":"77346","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0892804","created_at":"2025-03-17T18:38:26.000000Z","updated_at":"2025-03-17T18:38:26.000000Z","inspection_violations":[{"id":955145,"change_date":"2022-06-15 21:41:00","inspection_id":"75818383","insp_violation_id":"246491312","seq_no":"3","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"189273469","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:27.000000Z","updated_at":"2025-03-17T21:11:27.000000Z","normalized_code":"39351"},{"id":955146,"change_date":"2022-06-15 21:41:00","inspection_id":"75818383","insp_violation_id":"246491313","seq_no":"4","part_no":"393","part_no_section":"47(b)","insp_viol_unit":"1","insp_unit_id":"189273469","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:27.000000Z","updated_at":"2025-03-17T21:11:27.000000Z","normalized_code":"39347B"}],"inspection_per_units":[{"id":978586,"change_date":"2022-06-15 21:41:00","inspection_id":"75818383","insp_unit_id":"189273469","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M36822","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X9TR724180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:12.000000Z","updated_at":"2025-03-17T22:14:12.000000Z"},{"id":978587,"change_date":"2022-06-15 21:41:00","inspection_id":"75818383","insp_unit_id":"189273470","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"172B094","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU34322XMS000236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:12.000000Z","updated_at":"2025-03-17T22:14:12.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2630438\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2630438\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2630438\/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\/2630438\/inspections","per_page":100,"prev_page_url":null,"to":28,"total":28}