{"current_page":1,"data":[{"id":10484073,"change_date":"2025-12-19 21:40:00","inspection_id":"86618183","dot_number":"3230800","report_state":"CA","report_number":"ND00004982","insp_date":"2025-10-23 00:00:00","insp_start_time":"0700","insp_end_time":"0757","registration_date":null,"region":"PT","ci_status_code":"C","location":"630","location_desc":"46155 DILLON RD","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"N","pen_cen_match":null,"final_status_date":"2025-12-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"142470","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":"16103427","transaction_code":"A","transaction_date":"2025-10-23 00:00:00","upload_date":"2025-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2025-12-19 21:40:00","snet_input_date":"2025-10-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-19 21:40:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"543755","created_at":"2025-12-22T10:32:10.000000Z","updated_at":"2025-12-30T10:34:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17553821,"change_date":"2025-12-19 21:40:00","inspection_id":"86618183","insp_unit_id":"210730100","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5","insp_unit_license":"ZP57184","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV3GSGS7484","insp_unit_decal":"Y","insp_unit_decal_number":"35631973","created_at":"2025-12-22T10:02:09.000000Z","updated_at":"2025-12-30T10:01:30.000000Z"},{"id":17553822,"change_date":"2025-12-19 21:40:00","inspection_id":"86618183","insp_unit_id":"210730101","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"T3","insp_unit_license":"4NH7903","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4WW5482A9F6623121","insp_unit_decal":"Y","insp_unit_decal_number":"35631974","created_at":"2025-12-22T10:02:09.000000Z","updated_at":"2025-12-30T10:01:30.000000Z"}]},{"id":10484074,"change_date":"2025-12-19 21:40:00","inspection_id":"86618184","dot_number":"3230800","report_state":"CA","report_number":"ND00004983","insp_date":"2025-10-23 00:00:00","insp_start_time":"0800","insp_end_time":"0900","registration_date":null,"region":"PT","ci_status_code":"C","location":"630","location_desc":"46155 DILLON RD","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"N","pen_cen_match":null,"final_status_date":"2025-12-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16103428","transaction_code":"A","transaction_date":"2025-10-23 00:00:00","upload_date":"2025-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2025-12-19 21:40:00","snet_input_date":"2025-10-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-19 21:40:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"543755","created_at":"2025-12-22T10:32:10.000000Z","updated_at":"2025-12-30T10:34:21.000000Z","inspection_violations":[{"id":17594777,"change_date":"2025-12-19 21:40:00","inspection_id":"86618184","insp_violation_id":"270815915","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"210730102","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-22T10:33:08.000000Z","updated_at":"2025-12-30T10:35:24.000000Z","normalized_code":"39345DB"},{"id":17594778,"change_date":"2025-12-19 21:40:00","inspection_id":"86618184","insp_violation_id":"270815916","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"210730103","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-22T10:33:08.000000Z","updated_at":"2025-12-30T10:35:24.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":17553823,"change_date":"2025-12-19 21:40:00","inspection_id":"86618184","insp_unit_id":"210730102","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6","insp_unit_license":"YP85917","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD54GSHB1065","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-22T10:02:09.000000Z","updated_at":"2025-12-30T10:01:30.000000Z"},{"id":17553824,"change_date":"2025-12-19 21:40:00","inspection_id":"86618184","insp_unit_id":"210730103","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"T5","insp_unit_license":"4TP9917","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF5320662016831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-22T10:02:09.000000Z","updated_at":"2025-12-30T10:01:30.000000Z"}]},{"id":9410523,"change_date":"2025-08-14 21:40:00","inspection_id":"85490438","dot_number":"3230800","report_state":"AZ","report_number":"1135800067","insp_date":"2025-08-12 00:00:00","insp_start_time":"2050","insp_end_time":"2140","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"PHOENIX AZ","county_code_state":"AZ","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PROTRANS SYSTEMS","shipping_paper_number":"FB061","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":"U","pen_cen_match":"I","final_status_date":"2025-08-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2128483","transaction_code":"A","transaction_date":"2025-08-14 00:00:00","upload_date":"2025-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2025-08-14 21:40:00","snet_input_date":"2025-08-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-14 21:40:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236-7331","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-17T10:01:17.000000Z","updated_at":"2025-08-20T10:43:49.000000Z","inspection_violations":[{"id":15308177,"change_date":"2025-08-14 21:40:00","inspection_id":"85490438","insp_violation_id":"268022972","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"208393383","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-17T10:45:14.000000Z","updated_at":"2025-08-18T10:43:46.000000Z","normalized_code":"39378AWS"},{"id":15308178,"change_date":"2025-08-14 21:40:00","inspection_id":"85490438","insp_violation_id":"268022973","seq_no":"2","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"208393384","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-17T10:45:14.000000Z","updated_at":"2025-08-18T10:43:46.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":15511917,"change_date":"2025-08-14 21:40:00","inspection_id":"85490438","insp_unit_id":"208393383","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"001","insp_unit_license":"YP85917","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD54GSHB1065","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:24.000000Z","updated_at":"2025-08-18T09:45:39.000000Z"},{"id":15511918,"change_date":"2025-08-14 21:40:00","inspection_id":"85490438","insp_unit_id":"208393384","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANSCRAFT","insp_unit_company":null,"insp_unit_license":"4TP9917","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF5320662016831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:24.000000Z","updated_at":"2025-08-18T09:45:39.000000Z"}]},{"id":9146019,"change_date":"2025-07-14 21:41:00","inspection_id":"85212543","dot_number":"3230800","report_state":"CA","report_number":"ND6V007692","insp_date":"2025-07-11 00:00:00","insp_start_time":"0616","insp_end_time":"0706","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"SIDEWINDER PLATFORM SCALE","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GYPSUM","shipping_paper_number":"11738433","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"15896677","transaction_code":"A","transaction_date":"2025-07-11 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2025-07-14 21:41:00","snet_input_date":"2025-07-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-14 21:41:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:51.000000Z","updated_at":"2025-07-18T10:45:51.000000Z","inspection_violations":[{"id":14753821,"change_date":"2025-07-14 21:41:00","inspection_id":"85212543","insp_violation_id":"267399488","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"1","insp_unit_id":"207865093","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:21.000000Z","updated_at":"2025-07-18T10:47:48.000000Z","normalized_code":"39355EB"},{"id":14753822,"change_date":"2025-07-14 21:41:00","inspection_id":"85212543","insp_violation_id":"267399489","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"207865093","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:21.000000Z","updated_at":"2025-07-18T10:47:48.000000Z","normalized_code":"3922SLLEWA1"},{"id":14753823,"change_date":"2025-07-14 21:41:00","inspection_id":"85212543","insp_violation_id":"267399490","seq_no":"3","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"2","insp_unit_id":"207865094","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:21.000000Z","updated_at":"2025-07-18T10:47:48.000000Z","normalized_code":"3963A1BALAC"},{"id":14753824,"change_date":"2025-07-14 21:41:00","inspection_id":"85212543","insp_violation_id":"267399491","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"207865094","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:21.000000Z","updated_at":"2025-07-18T10:47:48.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":15019544,"change_date":"2025-07-14 21:41:00","inspection_id":"85212543","insp_unit_id":"207865093","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5\/WHT","insp_unit_license":"ZP57184","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV3GSGS7484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:35.000000Z","updated_at":"2025-07-18T09:46:18.000000Z"},{"id":15019545,"change_date":"2025-07-14 21:41:00","inspection_id":"85212543","insp_unit_id":"207865094","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"F2\/ALU","insp_unit_license":"4NH7903","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4WW5482A9F6623121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:35.000000Z","updated_at":"2025-07-18T09:46:18.000000Z"}]},{"id":7712573,"change_date":"2025-01-27 21:39:00","inspection_id":"83701907","dot_number":"3230800","report_state":"US","report_number":"1943000666","insp_date":"2025-01-16 00:00:00","insp_start_time":"1908","insp_end_time":"1957","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","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":"U","pen_cen_match":"I","final_status_date":"2025-01-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1292206","transaction_code":"A","transaction_date":"2025-01-27 00:00:00","upload_date":"2025-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2025-01-27 21:39:00","snet_input_date":"2025-01-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-27 21:39:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236-7331","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:19.000000Z","updated_at":"2025-03-17T20:58:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12445977,"change_date":"2025-01-27 21:39:00","inspection_id":"83701907","insp_unit_id":"205012983","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"5\/WHITE\/3X","insp_unit_license":"XP98038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV3GSGS7484","insp_unit_decal":"Y","insp_unit_decal_number":"34937003","created_at":"2025-03-17T23:52:21.000000Z","updated_at":"2025-03-17T23:52:21.000000Z"}]},{"id":7414890,"change_date":"2024-12-16 21:40:00","inspection_id":"83389343","dot_number":"3230800","report_state":"TX","report_number":"V241636577","insp_date":"2024-12-08 00:00:00","insp_start_time":"1339","insp_end_time":"1423","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"EXIT 55 AT IH10 EB","county_code_state":"TX","county_code":"141","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"D.S","shipping_paper_number":"2","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"141250","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":"9449206","transaction_code":"C","transaction_date":"2024-12-16 00:00:00","upload_date":"2024-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":"M","census_search_date":"2024-12-13 21:41:00","snet_input_date":"2024-12-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-13 21:41:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236-7331","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1083800","created_at":"2025-03-17T20:50:47.000000Z","updated_at":"2025-03-17T20:50:47.000000Z","inspection_violations":[{"id":11586701,"change_date":"2024-12-16 21:40:00","inspection_id":"83389343","insp_violation_id":"263496050","seq_no":"3","part_no":"393","part_no_section":"25A","insp_viol_unit":"2","insp_unit_id":"204411921","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:26.000000Z","updated_at":"2025-03-17T22:02:26.000000Z","normalized_code":"39325A"},{"id":11586702,"change_date":"2024-12-16 21:40:00","inspection_id":"83389343","insp_violation_id":"263496051","seq_no":"4","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"204411920","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:26.000000Z","updated_at":"2025-03-17T22:02:26.000000Z","normalized_code":"39375C"},{"id":11586703,"change_date":"2024-12-16 21:40:00","inspection_id":"83389343","insp_violation_id":"263496052","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204411920","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:26.000000Z","updated_at":"2025-03-17T22:02:26.000000Z","normalized_code":"39378"},{"id":11586704,"change_date":"2024-12-16 21:40:00","inspection_id":"83389343","insp_violation_id":"263496053","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204411921","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:26.000000Z","updated_at":"2025-03-17T22:02:26.000000Z","normalized_code":"3939"},{"id":11586705,"change_date":"2024-12-16 21:40:00","inspection_id":"83389343","insp_violation_id":"263496054","seq_no":"1","part_no":"393","part_no_section":"104B","insp_viol_unit":"2","insp_unit_id":"204411921","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:26.000000Z","updated_at":"2025-03-17T22:02:26.000000Z","normalized_code":"393104B"},{"id":11586706,"change_date":"2024-12-16 21:40:00","inspection_id":"83389343","insp_violation_id":"263496055","seq_no":"2","part_no":"393","part_no_section":"104F4\/R","insp_viol_unit":"2","insp_unit_id":"204411921","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:26.000000Z","updated_at":"2025-03-17T22:02:26.000000Z","normalized_code":"393104F4\/R"}],"inspection_per_units":[{"id":11962019,"change_date":"2024-12-16 21:40:00","inspection_id":"83389343","insp_unit_id":"204411920","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6","insp_unit_license":"YP85917","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD54GSHB1065","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:03.000000Z","updated_at":"2025-03-17T23:47:03.000000Z"},{"id":11962020,"change_date":"2024-12-16 21:40:00","inspection_id":"83389343","insp_unit_id":"204411921","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILS","insp_unit_company":"3","insp_unit_license":"4NH7903","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4WW5482A9F6623121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:03.000000Z","updated_at":"2025-03-17T23:47:03.000000Z"}]},{"id":6497644,"change_date":"2025-07-23 21:41:00","inspection_id":"82416165","dot_number":"3230800","report_state":"AZ","report_number":"5925000222","insp_date":"2024-08-12 00:00:00","insp_start_time":"0616","insp_end_time":"0706","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"BUCKEYE AZ","county_code_state":"AZ","county_code":"013","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INTERIORWORX MOULDING","shipping_paper_number":"SO-RG77935","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"756774","transaction_code":"C","transaction_date":"2024-08-19 00:00:00","upload_date":"2025-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2024-08-19 21:41:00","snet_input_date":"2024-08-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-19 21:41:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236-7331","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:37.000000Z","updated_at":"2025-07-27T10:41:16.000000Z","inspection_violations":[{"id":14913235,"change_date":"2025-07-23 21:41:00","inspection_id":"82416165","insp_violation_id":"267587407","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":15163192,"change_date":"2025-07-23 21:41:00","inspection_id":"82416165","insp_unit_id":"208025429","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1","insp_unit_license":"ZP18904","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDR5GDGW7830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:20.000000Z","updated_at":"2025-07-27T09:45:10.000000Z"},{"id":15163193,"change_date":"2025-07-23 21:41:00","inspection_id":"82416165","insp_unit_id":"208025430","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANSCRAFT","insp_unit_company":null,"insp_unit_license":"4TP9917","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF5320662016831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:20.000000Z","updated_at":"2025-07-27T09:45:10.000000Z"}]},{"id":5987832,"change_date":"2024-06-13 21:42:00","inspection_id":"81869297","dot_number":"3230800","report_state":"CA","report_number":"NBAB002678","insp_date":"2024-06-12 00:00:00","insp_start_time":"0600","insp_end_time":"0630","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"N","pen_cen_match":null,"final_status_date":"2024-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"139250","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":"15402035","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"543755","created_at":"2025-03-17T20:21:27.000000Z","updated_at":"2025-03-17T20:21:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9644847,"change_date":"2024-06-13 21:42:00","inspection_id":"81869297","insp_unit_id":"201387785","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"XP50872","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X9EJ392335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"},{"id":9644848,"change_date":"2024-06-13 21:42:00","inspection_id":"81869297","insp_unit_id":"201387786","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"3","insp_unit_license":"4NH7903","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4WW5482A9F6623121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"}]},{"id":5987833,"change_date":"2024-06-13 21:42:00","inspection_id":"81869298","dot_number":"3230800","report_state":"CA","report_number":"NBAB002679","insp_date":"2024-06-12 00:00:00","insp_start_time":"0630","insp_end_time":"0700","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"N","pen_cen_match":null,"final_status_date":"2024-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132350","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":"15401712","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"543755","created_at":"2025-03-17T20:21:27.000000Z","updated_at":"2025-03-17T20:21:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9644849,"change_date":"2024-06-13 21:42:00","inspection_id":"81869298","insp_unit_id":"201387787","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5","insp_unit_license":"XP98038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV3GSGS7484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"},{"id":9644850,"change_date":"2024-06-13 21:42:00","inspection_id":"81869298","insp_unit_id":"201387788","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"5","insp_unit_license":"4TP9917","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF5320662016831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"}]},{"id":5987834,"change_date":"2024-06-13 21:42:00","inspection_id":"81869299","dot_number":"3230800","report_state":"CA","report_number":"NBAB002680","insp_date":"2024-06-12 00:00:00","insp_start_time":"0700","insp_end_time":"0730","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"N","pen_cen_match":null,"final_status_date":"2024-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15400914","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"543755","created_at":"2025-03-17T20:21:27.000000Z","updated_at":"2025-03-17T20:21:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9644851,"change_date":"2024-06-13 21:42:00","inspection_id":"81869299","insp_unit_id":"201387789","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2","insp_unit_license":"XP98963","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD5XESFN2117","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"},{"id":9644852,"change_date":"2024-06-13 21:42:00","inspection_id":"81869299","insp_unit_id":"201387790","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"2","insp_unit_license":"4UH5126","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF4820932009898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"}]},{"id":5832310,"change_date":"2024-05-23 21:41:00","inspection_id":"81700419","dot_number":"3230800","report_state":"CA","report_number":"NBED006024","insp_date":"2024-05-22 00:00:00","insp_start_time":"0803","insp_end_time":"1117","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"VOLUNTEER","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"139250","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15375409","transaction_code":"A","transaction_date":"2024-05-22 00:00:00","upload_date":"2024-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2024-05-23 21:41:00","snet_input_date":"2024-05-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-23 21:41:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"543755","created_at":"2025-03-17T20:18:17.000000Z","updated_at":"2025-03-17T20:18:17.000000Z","inspection_violations":[{"id":9037627,"change_date":"2024-05-23 21:41:00","inspection_id":"81700419","insp_violation_id":"259705428","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201063733","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:40.000000Z","updated_at":"2025-03-17T21:49:40.000000Z","normalized_code":"3922"},{"id":9037628,"change_date":"2024-05-23 21:41:00","inspection_id":"81700419","insp_violation_id":"259705429","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201063733","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:40.000000Z","updated_at":"2025-03-17T21:49:40.000000Z","normalized_code":"3922"},{"id":9037629,"change_date":"2024-05-23 21:41:00","inspection_id":"81700419","insp_violation_id":"259705430","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"201063734","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:40.000000Z","updated_at":"2025-03-17T21:49:40.000000Z","normalized_code":"3965B"},{"id":9037630,"change_date":"2024-05-23 21:41:00","inspection_id":"81700419","insp_violation_id":"259705431","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"201063734","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KN86747","created_at":"2025-03-17T21:49:40.000000Z","updated_at":"2025-03-17T21:49:40.000000Z","normalized_code":"3965B"},{"id":9037631,"change_date":"2024-05-23 21:41:00","inspection_id":"81700419","insp_violation_id":"259705432","seq_no":"5","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"201063734","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:49:40.000000Z","updated_at":"2025-03-17T21:49:40.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":9393076,"change_date":"2024-05-23 21:41:00","inspection_id":"81700419","insp_unit_id":"201063733","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3 BLUE","insp_unit_license":"XP50872","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X9EJ392335","insp_unit_decal":"Y","insp_unit_decal_number":"33849092","created_at":"2025-03-17T23:20:30.000000Z","updated_at":"2025-03-17T23:20:30.000000Z"},{"id":9393077,"change_date":"2024-05-23 21:41:00","inspection_id":"81700419","insp_unit_id":"201063734","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"F2 ALUM","insp_unit_license":"4NH7903","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4WW5482A9F6623121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:30.000000Z","updated_at":"2025-03-17T23:20:30.000000Z"}]},{"id":5759558,"change_date":"2024-05-15 21:44:00","inspection_id":"81621472","dot_number":"3230800","report_state":"CA","report_number":"NBBJ005804","insp_date":"2024-05-15 00:00:00","insp_start_time":"0855","insp_end_time":"0914","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15363901","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2024-05-15 21:44:00","snet_input_date":"2024-05-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-15 21:44:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:44.000000Z","updated_at":"2025-03-17T20:16:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9276787,"change_date":"2024-05-15 21:44:00","inspection_id":"81621472","insp_unit_id":"200915124","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5\/WHT","insp_unit_license":"XP98038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV3GSGS7484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:21.000000Z","updated_at":"2025-03-17T23:19:21.000000Z"}]},{"id":5759996,"change_date":"2024-05-15 21:44:00","inspection_id":"81621924","dot_number":"3230800","report_state":"CA","report_number":"NE2Z003646","insp_date":"2024-05-14 00:00:00","insp_start_time":"1725","insp_end_time":"1805","registration_date":null,"region":"PT","ci_status_code":"C","location":"881","location_desc":"WB PERALTA SCALE","county_code_state":"CA","county_code":"059","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15362460","transaction_code":"A","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2024-05-15 21:44:00","snet_input_date":"2024-05-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-15 21:44:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"543755","created_at":"2025-03-17T20:16:45.000000Z","updated_at":"2025-03-17T20:16:45.000000Z","inspection_violations":[{"id":8915910,"change_date":"2024-05-15 21:44:00","inspection_id":"81621924","insp_violation_id":"259530735","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200915908","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"39347E"},{"id":8915911,"change_date":"2024-05-15 21:44:00","inspection_id":"81621924","insp_violation_id":"259530736","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"200915908","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"39353B"},{"id":8915909,"change_date":"2024-05-15 21:44:00","inspection_id":"81621924","insp_violation_id":"259530734","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":9277510,"change_date":"2024-05-15 21:44:00","inspection_id":"81621924","insp_unit_id":"200915907","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"XP98963","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD5XESFN2117","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:21.000000Z","updated_at":"2025-03-17T23:19:21.000000Z"},{"id":9277511,"change_date":"2024-05-15 21:44:00","inspection_id":"81621924","insp_unit_id":"200915908","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"2020","insp_unit_license":"4UH5126","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF4820932009898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:21.000000Z","updated_at":"2025-03-17T23:19:21.000000Z"}]},{"id":5704197,"change_date":"2024-05-08 21:43:00","inspection_id":"81561396","dot_number":"3230800","report_state":"CA","report_number":"UEBO000979","insp_date":"2024-05-08 00:00:00","insp_start_time":"0415","insp_end_time":"0437","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CB PIPING","shipping_paper_number":"1500330","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15353496","transaction_code":"A","transaction_date":"2024-05-08 00:00:00","upload_date":"2024-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2024-05-08 21:43:00","snet_input_date":"2024-05-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-08 21:43:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"543755","created_at":"2025-03-17T20:15:52.000000Z","updated_at":"2025-03-17T20:15:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9187610,"change_date":"2024-05-08 21:43:00","inspection_id":"81561396","insp_unit_id":"200800024","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5\/WHT","insp_unit_license":"XP98038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV3GSGS7484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:30.000000Z","updated_at":"2025-03-17T23:18:30.000000Z"},{"id":9187611,"change_date":"2024-05-08 21:43:00","inspection_id":"81561396","insp_unit_id":"200800025","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"5\/YEL","insp_unit_license":"4TP9917","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF5320662016831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:30.000000Z","updated_at":"2025-03-17T23:18:30.000000Z"}]},{"id":5486017,"change_date":"2024-04-10 21:43:00","inspection_id":"81323882","dot_number":"3230800","report_state":"CA","report_number":"NDM1006059","insp_date":"2024-04-09 00:00:00","insp_start_time":"1532","insp_end_time":"1628","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"SIDEWINDER PLATFORM SCALE","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DEPLOYED RESOURCES","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"4","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15313263","transaction_code":"A","transaction_date":"2024-04-09 00:00:00","upload_date":"2024-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2024-04-10 21:43:00","snet_input_date":"2024-04-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-10 21:43:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"543755","created_at":"2025-03-17T20:11:30.000000Z","updated_at":"2025-03-17T20:11:30.000000Z","inspection_violations":[{"id":8472112,"change_date":"2024-04-10 21:43:00","inspection_id":"81323882","insp_violation_id":"258867778","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200343543","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"3922"},{"id":8472113,"change_date":"2024-04-10 21:43:00","inspection_id":"81323882","insp_violation_id":"258867779","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200343543","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"KU51884","created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"3922"},{"id":8472114,"change_date":"2024-04-10 21:43:00","inspection_id":"81323882","insp_violation_id":"258867780","seq_no":"3","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"200343544","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"KU51883","created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"393110B"},{"id":8472115,"change_date":"2024-04-10 21:43:00","inspection_id":"81323882","insp_violation_id":"258867781","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"200343544","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CW928462","created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":8837212,"change_date":"2024-04-10 21:43:00","inspection_id":"81323882","insp_unit_id":"200343543","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/05","insp_unit_license":"XP98038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV3GSGS7484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:12.000000Z","updated_at":"2025-03-17T23:15:12.000000Z"},{"id":8837213,"change_date":"2024-04-10 21:43:00","inspection_id":"81323882","insp_unit_id":"200343544","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"ALU","insp_unit_license":"4TP9917","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF5320662016831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:12.000000Z","updated_at":"2025-03-17T23:15:12.000000Z"}]},{"id":5441774,"change_date":"2024-04-04 21:43:00","inspection_id":"81275172","dot_number":"3230800","report_state":"CA","report_number":"NCVH005505","insp_date":"2024-04-03 00:00:00","insp_start_time":"1309","insp_end_time":"1401","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-04 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"136250","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15305746","transaction_code":"A","transaction_date":"2024-04-03 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2024-04-04 21:43:00","snet_input_date":"2024-04-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-04 21:43:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"543755","created_at":"2025-03-17T20:10:39.000000Z","updated_at":"2025-03-17T20:10:39.000000Z","inspection_violations":[{"id":8400126,"change_date":"2024-04-04 21:43:00","inspection_id":"81275172","insp_violation_id":"258761357","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200250694","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:42.000000Z","updated_at":"2025-03-17T21:46:42.000000Z","normalized_code":"3922"},{"id":8400127,"change_date":"2024-04-04 21:43:00","inspection_id":"81275172","insp_violation_id":"258761358","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200250694","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:42.000000Z","updated_at":"2025-03-17T21:46:42.000000Z","normalized_code":"3939A"},{"id":8400128,"change_date":"2024-04-04 21:43:00","inspection_id":"81275172","insp_violation_id":"258761359","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200250694","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:46:42.000000Z","updated_at":"2025-03-17T21:46:42.000000Z","normalized_code":"39345B2"},{"id":8400129,"change_date":"2024-04-04 21:43:00","inspection_id":"81275172","insp_violation_id":"258761360","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200250694","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:42.000000Z","updated_at":"2025-03-17T21:46:42.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8765589,"change_date":"2024-04-04 21:43:00","inspection_id":"81275172","insp_unit_id":"200250694","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3\/BLUE","insp_unit_license":"XP50872","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X9EJ392335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:33.000000Z","updated_at":"2025-03-17T23:14:33.000000Z"},{"id":8765590,"change_date":"2024-04-04 21:43:00","inspection_id":"81275172","insp_unit_id":"200250695","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"F2","insp_unit_license":"4NH7903","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4WW5482A9F6623121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:33.000000Z","updated_at":"2025-03-17T23:14:33.000000Z"}]},{"id":5250130,"change_date":"2024-03-11 21:42:00","inspection_id":"81066200","dot_number":"3230800","report_state":"AZ","report_number":"7254000130","insp_date":"2024-03-04 00:00:00","insp_start_time":"0915","insp_end_time":"1008","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"MARANA AZ","county_code_state":"AZ","county_code":"019","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"U","pen_cen_match":"I","final_status_date":"2024-03-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","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":"305023","transaction_code":"A","transaction_date":"2024-03-10 00:00:00","upload_date":"2024-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2024-03-11 21:42:00","snet_input_date":"2024-03-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-11 21:42:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236-7331","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:41.000000Z","updated_at":"2025-03-17T20:06:41.000000Z","inspection_violations":[{"id":8096285,"change_date":"2024-03-11 21:42:00","inspection_id":"81066200","insp_violation_id":"258297121","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"199835751","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:06.000000Z","updated_at":"2025-03-17T21:45:06.000000Z","normalized_code":"39617CPI"},{"id":8096286,"change_date":"2024-03-11 21:42:00","inspection_id":"81066200","insp_violation_id":"258297122","seq_no":"2","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"199835751","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:06.000000Z","updated_at":"2025-03-17T21:45:06.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":8096287,"change_date":"2024-03-11 21:42:00","inspection_id":"81066200","insp_violation_id":"258297123","seq_no":"3","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:06.000000Z","updated_at":"2025-03-17T21:45:06.000000Z","normalized_code":"3922SLLSIV"},{"id":8096288,"change_date":"2024-03-11 21:42:00","inspection_id":"81066200","insp_violation_id":"258297124","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"199835752","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:06.000000Z","updated_at":"2025-03-17T21:45:06.000000Z","normalized_code":"39617CPI"},{"id":8096289,"change_date":"2024-03-11 21:42:00","inspection_id":"81066200","insp_violation_id":"258297125","seq_no":"5","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:06.000000Z","updated_at":"2025-03-17T21:45:06.000000Z","normalized_code":"3922SLLMF"}],"inspection_per_units":[{"id":8454085,"change_date":"2024-03-11 21:42:00","inspection_id":"81066200","insp_unit_id":"199835751","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"5","insp_unit_license":"XP98038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV3GSGS7484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:36.000000Z","updated_at":"2025-03-17T23:11:36.000000Z"},{"id":8454086,"change_date":"2024-03-11 21:42:00","inspection_id":"81066200","insp_unit_id":"199835752","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAILMOBIL","insp_unit_company":"T5","insp_unit_license":"4TP9917","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF5320662016831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:36.000000Z","updated_at":"2025-03-17T23:11:36.000000Z"}]},{"id":4009009,"change_date":"2023-09-20 21:39:00","inspection_id":"79702683","dot_number":"3230800","report_state":"AZ","report_number":"XF03900074","insp_date":"2023-09-20 00:00:00","insp_start_time":"0833","insp_end_time":"0945","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"BENSONAZ","county_code_state":"AZ","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RIVAS","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-09-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"7","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":"55849","transaction_code":"A","transaction_date":"2023-09-20 00:00:00","upload_date":"2023-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2023-09-20 21:39:00","snet_input_date":"2023-09-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-20 21:39:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236-7331","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:01.000000Z","updated_at":"2025-03-17T19:42:01.000000Z","inspection_violations":[{"id":6203834,"change_date":"2023-09-20 21:39:00","inspection_id":"79702683","insp_violation_id":"255363723","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"197135314","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39395A4EEUS"},{"id":6203835,"change_date":"2023-09-20 21:39:00","inspection_id":"79702683","insp_violation_id":"255363724","seq_no":"2","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"197135314","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"3939AHLLH"},{"id":6203836,"change_date":"2023-09-20 21:39:00","inspection_id":"79702683","insp_violation_id":"255363725","seq_no":"3","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"197135314","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"3939ALBL"},{"id":6203837,"change_date":"2023-09-20 21:39:00","inspection_id":"79702683","insp_violation_id":"255363726","seq_no":"4","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"197135314","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39378AWS"},{"id":6203838,"change_date":"2023-09-20 21:39:00","inspection_id":"79702683","insp_violation_id":"255363727","seq_no":"5","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"197135314","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39355C1"},{"id":6203839,"change_date":"2023-09-20 21:39:00","inspection_id":"79702683","insp_violation_id":"255363728","seq_no":"6","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"197135315","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"3939ALLPL"},{"id":6203840,"change_date":"2023-09-20 21:39:00","inspection_id":"79702683","insp_violation_id":"255363729","seq_no":"7","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"197135315","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":6446537,"change_date":"2023-09-20 21:39:00","inspection_id":"79702683","insp_unit_id":"197135314","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"XP98963","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD5XESFN2117","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:07.000000Z","updated_at":"2025-03-17T22:54:07.000000Z"},{"id":6446538,"change_date":"2023-09-20 21:39:00","inspection_id":"79702683","insp_unit_id":"197135315","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANSCRAFT","insp_unit_company":null,"insp_unit_license":"4UH5126","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF4820932009898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:07.000000Z","updated_at":"2025-03-17T22:54:07.000000Z"}]},{"id":3515074,"change_date":"2023-07-14 21:41:00","inspection_id":"79151048","dot_number":"3230800","report_state":"CA","report_number":"UEOH001883","insp_date":"2023-07-12 00:00:00","insp_start_time":"0910","insp_end_time":"0929","registration_date":null,"region":"PT","ci_status_code":"C","location":"852","location_desc":"I-15 NB\/HODGE ROAD","county_code_state":"CA","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ARIZONA TILE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14981741","transaction_code":"A","transaction_date":"2023-07-12 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2023-07-14 21:41:00","snet_input_date":"2023-07-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-14 21:41:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:29.000000Z","updated_at":"2025-03-17T19:32:29.000000Z","inspection_violations":[{"id":5421478,"change_date":"2023-07-14 21:41:00","inspection_id":"79151048","insp_violation_id":"254080729","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5652216,"change_date":"2023-07-14 21:41:00","inspection_id":"79151048","insp_unit_id":"196015671","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4","insp_unit_license":"XP98963","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD5XESFN2117","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:37.000000Z","updated_at":"2025-03-17T22:47:37.000000Z"},{"id":5652217,"change_date":"2023-07-14 21:41:00","inspection_id":"79151048","insp_unit_id":"196015672","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"2020","insp_unit_license":"4UH5126","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF4820932009898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:37.000000Z","updated_at":"2025-03-17T22:47:37.000000Z"}]},{"id":2639710,"change_date":"2023-03-22 21:43:00","inspection_id":"78161522","dot_number":"3230800","report_state":"CA","report_number":"NC2K005884","insp_date":"2023-03-22 00:00:00","insp_start_time":"1101","insp_end_time":"1138","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14828776","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2023-03-22 21:43:00","snet_input_date":"2023-03-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-22 21:43:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"543755","created_at":"2025-03-17T19:15:14.000000Z","updated_at":"2025-03-17T19:15:14.000000Z","inspection_violations":[{"id":4058132,"change_date":"2023-03-22 21:43:00","inspection_id":"78161522","insp_violation_id":"251817771","seq_no":"1","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"194015675","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KD07350","created_at":"2025-03-17T21:25:59.000000Z","updated_at":"2025-03-17T21:25:59.000000Z","normalized_code":"39375A1"},{"id":4058133,"change_date":"2023-03-22 21:43:00","inspection_id":"78161522","insp_violation_id":"251817772","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"194015675","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:59.000000Z","updated_at":"2025-03-17T21:25:59.000000Z","normalized_code":"3963A1"},{"id":4058134,"change_date":"2023-03-22 21:43:00","inspection_id":"78161522","insp_violation_id":"251817773","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"194015675","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KD07350","created_at":"2025-03-17T21:25:59.000000Z","updated_at":"2025-03-17T21:25:59.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4249660,"change_date":"2023-03-22 21:43:00","inspection_id":"78161522","insp_unit_id":"194015674","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5\/WHT","insp_unit_license":"XP98038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV3GSGS7484","insp_unit_decal":"Y","insp_unit_decal_number":"32193080","created_at":"2025-03-17T22:36:28.000000Z","updated_at":"2025-03-17T22:36:28.000000Z"},{"id":4249661,"change_date":"2023-03-22 21:43:00","inspection_id":"78161522","insp_unit_id":"194015675","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"5\/YLW","insp_unit_license":"4TP9917","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF5320662016831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:28.000000Z","updated_at":"2025-03-17T22:36:28.000000Z"}]},{"id":2651127,"change_date":"2023-03-23 21:44:00","inspection_id":"78174462","dot_number":"3230800","report_state":"CA","report_number":"UCZ9001450","insp_date":"2023-03-22 00:00:00","insp_start_time":"1415","insp_end_time":"1457","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-23 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14829808","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2023-03-23 21:44:00","snet_input_date":"2023-03-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-23 21:44:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:33.000000Z","updated_at":"2025-03-17T19:15:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4268268,"change_date":"2023-03-23 21:44:00","inspection_id":"78174462","insp_unit_id":"194042626","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5\/WHT","insp_unit_license":"XP98038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV3GSGS7484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:37.000000Z","updated_at":"2025-03-17T22:36:37.000000Z"},{"id":4268269,"change_date":"2023-03-23 21:44:00","inspection_id":"78174462","insp_unit_id":"194042627","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"5\/YLW","insp_unit_license":"4TP9917","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF5320662016831","insp_unit_decal":"Y","insp_unit_decal_number":"32194846","created_at":"2025-03-17T22:36:37.000000Z","updated_at":"2025-03-17T22:36:37.000000Z"}]},{"id":2504747,"change_date":"2023-03-03 21:41:00","inspection_id":"78008228","dot_number":"3230800","report_state":"CA","report_number":"NBAB001999","insp_date":"2023-03-03 00:00:00","insp_start_time":"0600","insp_end_time":"0630","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"N","pen_cen_match":null,"final_status_date":"2023-03-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"139250","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14805998","transaction_code":"A","transaction_date":"2023-03-03 00:00:00","upload_date":"2023-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2023-03-03 21:41:00","snet_input_date":"2023-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-03 21:41:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"543755","created_at":"2025-03-17T19:12:54.000000Z","updated_at":"2025-03-17T19:12:54.000000Z","inspection_violations":[{"id":3853426,"change_date":"2023-03-03 21:41:00","inspection_id":"78008228","insp_violation_id":"251477645","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193705622","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:05.000000Z","updated_at":"2025-03-17T21:25:05.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4030818,"change_date":"2023-03-03 21:41:00","inspection_id":"78008228","insp_unit_id":"193705622","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"XP50872","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X9EJ392335","insp_unit_decal":"Y","insp_unit_decal_number":"32205624","created_at":"2025-03-17T22:34:54.000000Z","updated_at":"2025-03-17T22:34:54.000000Z"},{"id":4030819,"change_date":"2023-03-03 21:41:00","inspection_id":"78008228","insp_unit_id":"193705623","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"T-3","insp_unit_license":"4NH7903","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4WW5482A9F6623121","insp_unit_decal":"Y","insp_unit_decal_number":"32205625","created_at":"2025-03-17T22:34:54.000000Z","updated_at":"2025-03-17T22:34:54.000000Z"}]},{"id":2504748,"change_date":"2023-07-26 21:41:00","inspection_id":"78008229","dot_number":"3230800","report_state":"CA","report_number":"NBAB002000","insp_date":"2023-03-03 00:00:00","insp_start_time":"0630","insp_end_time":"0700","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"N","pen_cen_match":null,"final_status_date":"2023-03-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"111310","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14806179","transaction_code":"C","transaction_date":"2023-07-25 00:00:00","upload_date":"2023-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2023-03-03 21:41:00","snet_input_date":"2023-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-03 21:41:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"543755","created_at":"2025-03-17T19:12:54.000000Z","updated_at":"2025-03-17T19:12:54.000000Z","inspection_violations":[{"id":3853427,"change_date":"2023-07-26 21:41:00","inspection_id":"78008229","insp_violation_id":"254301728","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196214861","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:05.000000Z","updated_at":"2025-03-17T21:25:05.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":4030820,"change_date":"2023-07-26 21:41:00","inspection_id":"78008229","insp_unit_id":"196214861","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4","insp_unit_license":"XP98963","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD5XESFN2117","insp_unit_decal":"Y","insp_unit_decal_number":"32205622","created_at":"2025-03-17T22:34:54.000000Z","updated_at":"2025-03-17T22:34:54.000000Z"},{"id":4030821,"change_date":"2023-07-26 21:41:00","inspection_id":"78008229","insp_unit_id":"196214862","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"T-4","insp_unit_license":"4RL6570","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"13N253202G1518989","insp_unit_decal":"Y","insp_unit_decal_number":"32205623","created_at":"2025-03-17T22:34:54.000000Z","updated_at":"2025-03-17T22:34:54.000000Z"}]},{"id":2504749,"change_date":"2023-03-03 21:41:00","inspection_id":"78008230","dot_number":"3230800","report_state":"CA","report_number":"NBAB002001","insp_date":"2023-03-03 00:00:00","insp_start_time":"0700","insp_end_time":"0730","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"N","pen_cen_match":null,"final_status_date":"2023-03-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133250","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":"14806026","transaction_code":"A","transaction_date":"2023-03-03 00:00:00","upload_date":"2023-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2023-03-03 21:41:00","snet_input_date":"2023-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-03 21:41:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"543755","created_at":"2025-03-17T19:12:54.000000Z","updated_at":"2025-03-17T19:12:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4030822,"change_date":"2023-03-03 21:41:00","inspection_id":"78008230","insp_unit_id":"193705626","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5","insp_unit_license":"XP98038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV3GSGS7484","insp_unit_decal":"Y","insp_unit_decal_number":"32205626","created_at":"2025-03-17T22:34:54.000000Z","updated_at":"2025-03-17T22:34:54.000000Z"},{"id":4030823,"change_date":"2023-03-03 21:41:00","inspection_id":"78008230","insp_unit_id":"193705627","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"T-5","insp_unit_license":"4TP9916","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"13N148203K1533165","insp_unit_decal":"Y","insp_unit_decal_number":"32205627","created_at":"2025-03-17T22:34:54.000000Z","updated_at":"2025-03-17T22:34:54.000000Z"}]},{"id":2347764,"change_date":"2023-02-10 21:40:00","inspection_id":"77829345","dot_number":"3230800","report_state":"AZ","report_number":"0499001017","insp_date":"2023-02-09 00:00:00","insp_start_time":"0739","insp_end_time":"0857","registration_date":null,"region":"MT","ci_status_code":"C","location":"I10","location_desc":"INTERSTATE 10","county_code_state":"AZ","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"PEGASUS","shipping_paper_number":"6372215","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132500","viol_total":"9","oos_total":"4","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1797146","transaction_code":"A","transaction_date":"2023-02-09 00:00:00","upload_date":"2023-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2023-02-10 21:40:00","snet_input_date":"2023-02-10 00:00:00","source_office":"4AZS001","mcmis_add_date":"2023-02-10 21:40:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236-7331","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:57.000000Z","updated_at":"2025-03-17T19:09:57.000000Z","inspection_violations":[{"id":3615517,"change_date":"2023-02-10 21:40:00","inspection_id":"77829345","insp_violation_id":"251073990","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193344997","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:01.000000Z","updated_at":"2025-03-17T21:24:01.000000Z","normalized_code":"3939A"},{"id":3615518,"change_date":"2023-02-10 21:40:00","inspection_id":"77829345","insp_violation_id":"251073991","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193344997","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:01.000000Z","updated_at":"2025-03-17T21:24:01.000000Z","normalized_code":"39395A"},{"id":3615519,"change_date":"2023-02-10 21:40:00","inspection_id":"77829345","insp_violation_id":"251073992","seq_no":"3","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"193344997","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:01.000000Z","updated_at":"2025-03-17T21:24:01.000000Z","normalized_code":"3929A2"},{"id":3615520,"change_date":"2023-02-10 21:40:00","inspection_id":"77829345","insp_violation_id":"251073993","seq_no":"4","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"193344998","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:01.000000Z","updated_at":"2025-03-17T21:24:01.000000Z","normalized_code":"393104B"},{"id":3615521,"change_date":"2023-02-10 21:40:00","inspection_id":"77829345","insp_violation_id":"251073994","seq_no":"5","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193344998","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:01.000000Z","updated_at":"2025-03-17T21:24:01.000000Z","normalized_code":"3929A"},{"id":3615522,"change_date":"2023-02-10 21:40:00","inspection_id":"77829345","insp_violation_id":"251073995","seq_no":"6","part_no":"393","part_no_section":"104(f)(4)","insp_viol_unit":"2","insp_unit_id":"193344998","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:01.000000Z","updated_at":"2025-03-17T21:24:01.000000Z","normalized_code":"393104F4"},{"id":3615523,"change_date":"2023-02-10 21:40:00","inspection_id":"77829345","insp_violation_id":"251073996","seq_no":"7","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:01.000000Z","updated_at":"2025-03-17T21:24:01.000000Z","normalized_code":"38351A"},{"id":3615524,"change_date":"2023-02-10 21:40:00","inspection_id":"77829345","insp_violation_id":"251073997","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193344997","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:01.000000Z","updated_at":"2025-03-17T21:24:01.000000Z","normalized_code":"39617C"},{"id":3615525,"change_date":"2023-02-10 21:40:00","inspection_id":"77829345","insp_violation_id":"251073998","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193344998","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:01.000000Z","updated_at":"2025-03-17T21:24:01.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":3778237,"change_date":"2023-02-10 21:40:00","inspection_id":"77829345","insp_unit_id":"193344997","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"YP32156","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD5XGSGN4052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:03.000000Z","updated_at":"2025-03-17T22:33:03.000000Z"},{"id":3778238,"change_date":"2023-02-10 21:40:00","inspection_id":"77829345","insp_unit_id":"193344998","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"4TP9916","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"13N148203K1533165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:03.000000Z","updated_at":"2025-03-17T22:33:03.000000Z"}]},{"id":976972,"change_date":"2022-08-05 21:41:00","inspection_id":"76250799","dot_number":"3230800","report_state":"CA","report_number":"ND0G002416","insp_date":"2022-08-01 00:00:00","insp_start_time":"1054","insp_end_time":"1139","registration_date":null,"region":"PT","ci_status_code":"C","location":"802","location_desc":"CAJON PLATFORM SCALES","county_code_state":"CA","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ARIZONA TILE","shipping_paper_number":"3642503","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120543","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14533967","transaction_code":"A","transaction_date":"2022-08-01 00:00:00","upload_date":"2022-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2022-08-05 21:41:00","snet_input_date":"2022-08-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-05 21:41:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:48.000000Z","updated_at":"2025-03-17T18:44:48.000000Z","inspection_violations":[{"id":1542076,"change_date":"2022-08-05 21:41:00","inspection_id":"76250799","insp_violation_id":"247555072","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"190167126","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:14:17.000000Z","updated_at":"2025-03-17T21:14:17.000000Z","normalized_code":"39375A3"},{"id":1542077,"change_date":"2022-08-05 21:41:00","inspection_id":"76250799","insp_violation_id":"247555073","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190167126","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:17.000000Z","updated_at":"2025-03-17T21:14:17.000000Z","normalized_code":"3963A1"},{"id":1542078,"change_date":"2022-08-05 21:41:00","inspection_id":"76250799","insp_violation_id":"247555074","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190167126","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:17.000000Z","updated_at":"2025-03-17T21:14:17.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1572162,"change_date":"2022-08-05 21:41:00","inspection_id":"76250799","insp_unit_id":"190167126","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3\/BLU","insp_unit_license":"XP50872","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X9EJ392335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:54.000000Z","updated_at":"2025-03-17T22:17:54.000000Z"},{"id":1572163,"change_date":"2022-08-05 21:41:00","inspection_id":"76250799","insp_unit_id":"190167127","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"F9019\/BLK","insp_unit_license":"4TP9916","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"13N148203K1533165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:54.000000Z","updated_at":"2025-03-17T22:17:54.000000Z"}]},{"id":838925,"change_date":"2022-07-18 21:42:00","inspection_id":"76089134","dot_number":"3230800","report_state":"AZ","report_number":"0331000176","insp_date":"2022-07-15 00:00:00","insp_start_time":"0549","insp_end_time":"0630","registration_date":null,"region":"MT","ci_status_code":"C","location":"1630","location_desc":"TONOPAH","county_code_state":"AZ","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"CEROGLASS TECHNOLOGIES","shipping_paper_number":"OL-33981-1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-07-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120543","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1759153","transaction_code":"A","transaction_date":"2022-07-15 00:00:00","upload_date":"2022-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03230800","upload_search_indicator":null,"census_search_date":"2022-07-18 21:42:00","snet_input_date":"2022-07-18 00:00:00","source_office":"4AZS001","mcmis_add_date":"2022-07-18 21:42:00","insp_carrier_name":"ET TRANSPORT LLC","insp_carrier_street":"49-858 CALLE QUINTERRA","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236-7331","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:21.000000Z","updated_at":"2025-03-17T18:42:21.000000Z","inspection_violations":[{"id":1322508,"change_date":"2022-07-18 21:42:00","inspection_id":"76089134","insp_violation_id":"247153999","seq_no":"1","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"189829299","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:13:15.000000Z","updated_at":"2025-03-17T21:13:15.000000Z","normalized_code":"393110B"},{"id":1322509,"change_date":"2022-07-18 21:42:00","inspection_id":"76089134","insp_violation_id":"247154000","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"189829298","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:15.000000Z","updated_at":"2025-03-17T21:13:15.000000Z","normalized_code":"39378"},{"id":1322510,"change_date":"2022-07-18 21:42:00","inspection_id":"76089134","insp_violation_id":"247154001","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"189829299","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:15.000000Z","updated_at":"2025-03-17T21:13:15.000000Z","normalized_code":"39355E"},{"id":1322511,"change_date":"2022-07-18 21:42:00","inspection_id":"76089134","insp_violation_id":"247154002","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"189829299","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:15.000000Z","updated_at":"2025-03-17T21:13:15.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":1349974,"change_date":"2022-07-18 21:42:00","inspection_id":"76089134","insp_unit_id":"189829298","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"XP50872","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X9EJ392335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:28.000000Z","updated_at":"2025-03-17T22:16:28.000000Z"},{"id":1349975,"change_date":"2022-07-18 21:42:00","inspection_id":"76089134","insp_unit_id":"189829299","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"F9019","insp_unit_license":"4TP9916","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"13N148203K1533165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:28.000000Z","updated_at":"2025-03-17T22:16:28.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3230800\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3230800\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3230800\/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\/3230800\/inspections","per_page":100,"prev_page_url":null,"to":27,"total":27}