{"current_page":1,"data":[{"id":10110378,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","dot_number":"3927519","report_state":"TX","report_number":"V252098230","insp_date":"2025-10-31 00:00:00","insp_start_time":"0650","insp_end_time":"0738","registration_date":null,"region":"CT","ci_status_code":"C","location":"3B101","location_desc":"LINCOLN JUAREZ POE","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"19","oos_total":"8","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"18","vehicle_oos_total":"7","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9745846","transaction_code":"C","transaction_date":"2025-11-06 00:00:00","upload_date":"2025-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":"M","census_search_date":"2025-11-03 21:40:00","snet_input_date":"2025-10-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-03 21:40:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1069759","created_at":"2025-11-06T10:30:46.000000Z","updated_at":"2025-11-09T10:31:38.000000Z","inspection_violations":[{"id":16816265,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789087","seq_no":"1","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"393209D"},{"id":16816266,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789088","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"39347E"},{"id":16816267,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789089","seq_no":"3","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"39375C"},{"id":16816268,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789090","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"39378"},{"id":16816269,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789091","seq_no":"5","part_no":"393","part_no_section":"83D","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"27","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"39383D"},{"id":16816270,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789092","seq_no":"6","part_no":"393","part_no_section":"84","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"39384"},{"id":16816271,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789093","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"3939"},{"id":16816272,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789094","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"3939"},{"id":16816273,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789095","seq_no":"9","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"3939TS"},{"id":16816274,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789096","seq_no":"10","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"3939TS"},{"id":16816275,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789097","seq_no":"11","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"39395F"},{"id":16816276,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789098","seq_no":"12","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"3958E"},{"id":16816277,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789099","seq_no":"13","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"3963A1B"},{"id":16816278,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789100","seq_no":"14","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"3963A1BOS"},{"id":16816279,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789101","seq_no":"15","part_no":"396","part_no_section":"3A1BL","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"3963A1BL"},{"id":16816280,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789102","seq_no":"16","part_no":"396","part_no_section":"5B-HLIW","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"3965BHLIW"},{"id":16816281,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789103","seq_no":"17","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"3965B"},{"id":16816282,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789104","seq_no":"19","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"3922RG"},{"id":16816283,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_violation_id":"269789105","seq_no":"21","part_no":"392","part_no_section":"2UCR","insp_viol_unit":"1","insp_unit_id":"209888481","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:46.000000Z","updated_at":"2025-11-09T10:32:46.000000Z","normalized_code":"3922UCR"}],"inspection_per_units":[{"id":16870459,"change_date":"2025-11-06 21:40:00","inspection_id":"86226389","insp_unit_id":"209888481","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"1966","insp_unit_license":"K127324","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M83JMPAX3P061966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-09T10:01:51.000000Z","updated_at":"2025-11-09T10:01:51.000000Z"}]},{"id":9262873,"change_date":"2025-07-28 21:39:00","inspection_id":"85335332","dot_number":"3927519","report_state":"US","report_number":"1111001325","insp_date":"2025-07-26 00:00:00","insp_start_time":"0342","insp_end_time":"0428","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"EL PASO TX","county_code_state":"TX","county_code":"141","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-07-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2052660","transaction_code":"A","transaction_date":"2025-07-28 00:00:00","upload_date":"2025-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2025-07-28 21:39:00","snet_input_date":"2025-07-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-28 21:39:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-31T10:00:24.000000Z","updated_at":"2025-08-01T10:41:12.000000Z","inspection_violations":[{"id":15005439,"change_date":"2025-07-28 21:39:00","inspection_id":"85335332","insp_violation_id":"267686611","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"208107780","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-31T10:43:15.000000Z","updated_at":"2025-08-01T10:42:47.000000Z","normalized_code":"39345DB"},{"id":15005440,"change_date":"2025-07-28 21:39:00","inspection_id":"85335332","insp_violation_id":"267686612","seq_no":"2","part_no":"393","part_no_section":"62-BEI","insp_viol_unit":"1","insp_unit_id":"208107780","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-31T10:43:15.000000Z","updated_at":"2025-08-01T10:42:47.000000Z","normalized_code":"39362BEI"},{"id":15005441,"change_date":"2025-07-28 21:39:00","inspection_id":"85335332","insp_violation_id":"267686613","seq_no":"3","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"208107780","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-31T10:43:15.000000Z","updated_at":"2025-08-01T10:42:47.000000Z","normalized_code":"3929AA1"},{"id":15005442,"change_date":"2025-07-28 21:39:00","inspection_id":"85335332","insp_violation_id":"267686614","seq_no":"4","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"208107780","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-31T10:43:15.000000Z","updated_at":"2025-08-01T10:42:47.000000Z","normalized_code":"3939ALSLI"}],"inspection_per_units":[{"id":15244848,"change_date":"2025-07-28 21:39:00","inspection_id":"85335332","insp_unit_id":"208107780","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"UNKNOWN","insp_unit_company":"3103","insp_unit_license":"52RC3S","insp_unit_license_state":"DG","insp_unit_vehicle_id_number":"3MBFAJMB0PM075485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:27.000000Z","updated_at":"2025-08-01T09:45:27.000000Z"}]},{"id":8609624,"change_date":"2025-05-12 21:41:00","inspection_id":"84645680","dot_number":"3927519","report_state":"TX","report_number":"V251872646","insp_date":"2025-05-08 00:00:00","insp_start_time":"0415","insp_end_time":"0512","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C501","location_desc":"CAMINO REAL POE","county_code_state":"TX","county_code":"323","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ESTRELLA TRANSPORTATION LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-05-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9574084","transaction_code":"A","transaction_date":"2025-05-12 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":"M","census_search_date":"2025-05-12 21:41:00","snet_input_date":"2025-05-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-12 21:41:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1069759","created_at":"2025-05-15T10:01:22.000000Z","updated_at":"2025-05-17T10:06:28.000000Z","inspection_violations":[{"id":13683983,"change_date":"2025-05-12 21:41:00","inspection_id":"84645680","insp_violation_id":"266173655","seq_no":"1","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"206815015","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:23:42.000000Z","updated_at":"2025-05-16T10:30:56.000000Z","normalized_code":"393209E"},{"id":13683984,"change_date":"2025-05-12 21:41:00","inspection_id":"84645680","insp_violation_id":"266173656","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"206815015","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:23:42.000000Z","updated_at":"2025-05-16T10:30:56.000000Z","normalized_code":"39378"},{"id":13683985,"change_date":"2025-05-12 21:41:00","inspection_id":"84645680","insp_violation_id":"266173657","seq_no":"3","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"206815015","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:23:42.000000Z","updated_at":"2025-05-16T10:30:56.000000Z","normalized_code":"3939H"},{"id":13683986,"change_date":"2025-05-12 21:41:00","inspection_id":"84645680","insp_violation_id":"266173658","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"206815015","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:23:42.000000Z","updated_at":"2025-05-16T10:30:56.000000Z","normalized_code":"39617C"},{"id":13683987,"change_date":"2025-05-12 21:41:00","inspection_id":"84645680","insp_violation_id":"266173659","seq_no":"5","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"206815015","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:23:42.000000Z","updated_at":"2025-05-16T10:30:56.000000Z","normalized_code":"3965B"},{"id":13683988,"change_date":"2025-05-12 21:41:00","inspection_id":"84645680","insp_violation_id":"266173660","seq_no":"6","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206815015","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:23:42.000000Z","updated_at":"2025-05-16T10:30:56.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":14055502,"change_date":"2025-05-12 21:41:00","inspection_id":"84645680","insp_unit_id":"206815015","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"1066","insp_unit_license":"K127324","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M83JMPAX3P061966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:24.000000Z","updated_at":"2025-05-16T09:52:00.000000Z"}]},{"id":8609648,"change_date":"2025-05-12 21:41:00","inspection_id":"84645706","dot_number":"3927519","report_state":"TX","report_number":"V251872656","insp_date":"2025-05-08 00:00:00","insp_start_time":"0559","insp_end_time":"0657","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:28\u00bf\u00bf41'55.40\"N","county_code_state":"TX","county_code":"323","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ESTRELLA TRANSPORTATION LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-05-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9574064","transaction_code":"A","transaction_date":"2025-05-12 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":"M","census_search_date":"2025-05-12 21:41:00","snet_input_date":"2025-05-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-12 21:41:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1069759","created_at":"2025-05-15T10:01:22.000000Z","updated_at":"2025-05-17T10:06:28.000000Z","inspection_violations":[{"id":13684033,"change_date":"2025-05-12 21:41:00","inspection_id":"84645706","insp_violation_id":"266173717","seq_no":"1","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"206815058","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:23:42.000000Z","updated_at":"2025-05-16T10:30:56.000000Z","normalized_code":"3963A1"},{"id":13684034,"change_date":"2025-05-12 21:41:00","inspection_id":"84645706","insp_violation_id":"266173718","seq_no":"2","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"206815058","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:23:42.000000Z","updated_at":"2025-05-16T10:30:56.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":14055540,"change_date":"2025-05-12 21:41:00","inspection_id":"84645706","insp_unit_id":"206815058","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"3233","insp_unit_license":"34850K","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"2M93JMPAX6W063233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:24.000000Z","updated_at":"2025-05-16T09:52:00.000000Z"}]},{"id":8567147,"change_date":"2025-05-07 21:43:00","inspection_id":"84601057","dot_number":"3927519","report_state":"US","report_number":"1600001364","insp_date":"2025-05-05 00:00:00","insp_start_time":"1730","insp_end_time":"1750","registration_date":null,"region":"PD","ci_status_code":"C","location":"USSANY","location_desc":"SAN DIEGO CA","county_code_state":"CA","county_code":"073","insp_level_id":"2","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-07 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33069","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":"1696535","transaction_code":"A","transaction_date":"2025-05-07 00:00:00","upload_date":"2025-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2025-05-07 21:43:00","snet_input_date":"2025-05-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-07 21:43:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-10T10:52:26.000000Z","updated_at":"2025-05-11T10:12:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13939675,"change_date":"2025-05-07 21:43:00","inspection_id":"84601057","insp_unit_id":"206681216","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MASTER ROA","insp_unit_company":"099 WHITE","insp_unit_license":"16311X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ABGJFHA4CS029819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:16:57.000000Z","updated_at":"2025-05-11T02:54:34.000000Z"}]},{"id":8543176,"change_date":"2025-05-04 21:33:00","inspection_id":"84575927","dot_number":"3927519","report_state":"IL","report_number":"5000240009","insp_date":"2025-05-03 00:00:00","insp_start_time":"1610","insp_end_time":"1626","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"31","county_code_state":"IL","county_code":"089","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-05-04 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2402474","transaction_code":"A","transaction_date":"2025-05-03 00:00:00","upload_date":"2025-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2025-05-04 21:33:00","snet_input_date":"2025-05-03 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-05-04 21:33:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"145465","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-08T10:02:38.000000Z","updated_at":"2025-05-08T10:02:38.000000Z","inspection_violations":[{"id":13532586,"change_date":"2025-05-04 21:33:00","inspection_id":"84575927","insp_violation_id":"265996305","seq_no":"1","part_no":"395","part_no_section":"8A-ELD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-06T10:45:50.000000Z","updated_at":"2025-05-08T10:22:45.000000Z","normalized_code":"3958AELD"},{"id":13532587,"change_date":"2025-05-04 21:33:00","inspection_id":"84575927","insp_violation_id":"265996306","seq_no":"2","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-06T10:45:50.000000Z","updated_at":"2025-05-08T10:22:45.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":13891634,"change_date":"2025-05-04 21:33:00","inspection_id":"84575927","insp_unit_id":"206634131","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"1406","insp_unit_license":"130RR3","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3MBFAJMB6HM060278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-07T10:13:59.000000Z","updated_at":"2025-05-08T09:54:26.000000Z"}]},{"id":8532536,"change_date":"2025-05-02 21:41:00","inspection_id":"84564602","dot_number":"3927519","report_state":"US","report_number":"1630001488","insp_date":"2025-05-01 00:00:00","insp_start_time":"1615","insp_end_time":"1700","registration_date":null,"region":"PD","ci_status_code":"C","location":"0005","location_desc":"SAN DIEGO CA","county_code_state":"CA","county_code":"073","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ESTRELLA TRANSPORTATION","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33069","viol_total":"3","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":"1676536","transaction_code":"A","transaction_date":"2025-05-02 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2025-05-02 21:41:00","snet_input_date":"2025-05-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-02 21:41:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-05T10:15:58.000000Z","updated_at":"2025-05-06T10:05:49.000000Z","inspection_violations":[{"id":13514583,"change_date":"2025-05-02 21:41:00","inspection_id":"84564602","insp_violation_id":"265973500","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"206613687","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:53:00.000000Z","updated_at":"2025-05-06T10:29:58.000000Z","normalized_code":"39360C"},{"id":13514584,"change_date":"2025-05-02 21:41:00","inspection_id":"84564602","insp_violation_id":"265973501","seq_no":"2","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"206613687","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:53:00.000000Z","updated_at":"2025-05-06T10:29:58.000000Z","normalized_code":"3969D2FTF"},{"id":13514585,"change_date":"2025-05-02 21:41:00","inspection_id":"84564602","insp_violation_id":"265973502","seq_no":"3","part_no":"390","part_no_section":"21TE-LCMVINFO","insp_viol_unit":"1","insp_unit_id":"206613687","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:53:00.000000Z","updated_at":"2025-05-06T10:29:58.000000Z","normalized_code":"39021TELCMVINFO"}],"inspection_per_units":[{"id":13874164,"change_date":"2025-05-02 21:41:00","inspection_id":"84564602","insp_unit_id":"206613687","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MASTER ROA","insp_unit_company":"099 WHITE","insp_unit_license":"16311X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ABGJFHA4CS029819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T10:03:20.000000Z","updated_at":"2025-05-07T10:00:20.000000Z"}]},{"id":8527113,"change_date":"2025-05-01 21:41:00","inspection_id":"84558810","dot_number":"3927519","report_state":"CA","report_number":"UCC6002637","insp_date":"2025-04-25 00:00:00","insp_start_time":"1010","insp_end_time":"1040","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"660 E. SAN YSIDRO BLVD.","county_code_state":"CA","county_code":"073","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33750","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":"15803467","transaction_code":"A","transaction_date":"2025-04-25 00:00:00","upload_date":"2025-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2025-05-01 21:41:00","snet_input_date":"2025-04-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-01 21:41:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-04T10:35:17.000000Z","updated_at":"2025-05-05T10:14:55.000000Z","inspection_violations":[{"id":13502662,"change_date":"2025-05-01 21:41:00","inspection_id":"84558810","insp_violation_id":"265961819","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206603597","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-03T11:28:33.000000Z","updated_at":"2025-05-04T11:01:45.000000Z","normalized_code":"39347E"},{"id":13502663,"change_date":"2025-05-01 21:41:00","inspection_id":"84558810","insp_violation_id":"265961820","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"206603597","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-03T11:28:33.000000Z","updated_at":"2025-05-04T11:01:45.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":13863794,"change_date":"2025-05-01 21:41:00","inspection_id":"84558810","insp_unit_id":"206603597","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MASTE","insp_unit_company":"099\/ WHT","insp_unit_license":"16311X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ABGJFHA4CS029819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-04T10:24:44.000000Z","updated_at":"2025-05-05T10:03:11.000000Z"}]},{"id":8527078,"change_date":"2025-06-09 21:42:00","inspection_id":"84558773","dot_number":"3927519","report_state":"CA","report_number":"UCC6002636","insp_date":"2025-04-25 00:00:00","insp_start_time":"0840","insp_end_time":"0910","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"660 E. SAN YSIDRO BLVD.","county_code_state":"CA","county_code":"073","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"7","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15803453","transaction_code":"C","transaction_date":"2025-06-09 00:00:00","upload_date":"2025-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2025-06-09 21:42:00","snet_input_date":"2025-04-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-01 21:41:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-04T10:35:16.000000Z","updated_at":"2025-06-14T10:00:36.000000Z","inspection_violations":[{"id":14182850,"change_date":"2025-06-09 21:42:00","inspection_id":"84558773","insp_violation_id":"266747746","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207300506","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:59.000000Z","normalized_code":"39347E"},{"id":14182851,"change_date":"2025-06-09 21:42:00","inspection_id":"84558773","insp_violation_id":"266747747","seq_no":"2","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"207300506","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:59.000000Z","normalized_code":"39345B2BHTD"},{"id":14182852,"change_date":"2025-06-09 21:42:00","inspection_id":"84558773","insp_violation_id":"266747748","seq_no":"3","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"207300506","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:59.000000Z","normalized_code":"3922SLLEQP"},{"id":14182853,"change_date":"2025-06-09 21:42:00","inspection_id":"84558773","insp_violation_id":"266747749","seq_no":"4","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"207300506","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:59.000000Z","normalized_code":"39395F"},{"id":14182854,"change_date":"2025-06-09 21:42:00","inspection_id":"84558773","insp_violation_id":"266747750","seq_no":"5","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"207300506","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:59.000000Z","normalized_code":"3922SLLEQP"},{"id":14182855,"change_date":"2025-06-09 21:42:00","inspection_id":"84558773","insp_violation_id":"266747751","seq_no":"6","part_no":"391","part_no_section":"11B4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:59.000000Z","normalized_code":"39111B4"},{"id":14182856,"change_date":"2025-06-09 21:42:00","inspection_id":"84558773","insp_violation_id":"266747752","seq_no":"7","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"207300506","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:59.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":14500757,"change_date":"2025-06-09 21:42:00","inspection_id":"84558773","insp_unit_id":"207300506","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCI","insp_unit_company":"137\/ WHT","insp_unit_license":"84312A4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ABGJFHA4CS029819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:36.000000Z","updated_at":"2025-06-13T09:45:36.000000Z"}]},{"id":8412402,"change_date":"2025-04-18 21:40:00","inspection_id":"84437910","dot_number":"3927519","report_state":"US","report_number":"2037000111","insp_date":"2025-04-17 00:00:00","insp_start_time":"0740","insp_end_time":"0942","registration_date":null,"region":"CD","ci_status_code":"C","location":"USTX07","location_desc":"HIDALGO TX","county_code_state":"TX","county_code":"215","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"13","oos_total":"6","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1613428","transaction_code":"A","transaction_date":"2025-04-18 00:00:00","upload_date":"2025-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2025-04-18 21:40:00","snet_input_date":"2025-04-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-18 21:40:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-21T10:25:59.000000Z","updated_at":"2025-04-23T10:02:49.000000Z","inspection_violations":[{"id":13274287,"change_date":"2025-04-18 21:40:00","inspection_id":"84437910","insp_violation_id":"265700856","seq_no":"8","part_no":"393","part_no_section":"48A-BIAD","insp_viol_unit":"1","insp_unit_id":"206381481","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:10:55.000000Z","updated_at":"2025-04-22T10:26:29.000000Z","normalized_code":"39348ABIAD"},{"id":13274288,"change_date":"2025-04-18 21:40:00","inspection_id":"84437910","insp_violation_id":"265700857","seq_no":"9","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"206381481","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-20T11:10:55.000000Z","updated_at":"2025-04-22T10:26:29.000000Z","normalized_code":"39375A3TAOL"},{"id":13274289,"change_date":"2025-04-18 21:40:00","inspection_id":"84437910","insp_violation_id":"265700858","seq_no":"10","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"206381481","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-20T11:10:55.000000Z","updated_at":"2025-04-22T10:26:29.000000Z","normalized_code":"3963A1BOS"},{"id":13274290,"change_date":"2025-04-18 21:40:00","inspection_id":"84437910","insp_violation_id":"265700859","seq_no":"11","part_no":"395","part_no_section":"8A-HOSPVI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:10:55.000000Z","updated_at":"2025-04-22T10:26:29.000000Z","normalized_code":"3958AHOSPVI"},{"id":13274291,"change_date":"2025-04-18 21:40:00","inspection_id":"84437910","insp_violation_id":"265700860","seq_no":"12","part_no":"393","part_no_section":"209D-STSM","insp_viol_unit":"1","insp_unit_id":"206381481","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-20T11:10:55.000000Z","updated_at":"2025-04-22T10:26:29.000000Z","normalized_code":"393209DSTSM"},{"id":13274292,"change_date":"2025-04-18 21:40:00","inspection_id":"84437910","insp_violation_id":"265700861","seq_no":"13","part_no":"393","part_no_section":"62-BEMEI","insp_viol_unit":"1","insp_unit_id":"206381481","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-20T11:10:55.000000Z","updated_at":"2025-04-22T10:26:29.000000Z","normalized_code":"39362BEMEI"},{"id":13274293,"change_date":"2025-04-18 21:40:00","inspection_id":"84437910","insp_violation_id":"265700862","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"206381481","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:10:55.000000Z","updated_at":"2025-04-22T10:26:30.000000Z","normalized_code":"39378AWS"},{"id":13274294,"change_date":"2025-04-18 21:40:00","inspection_id":"84437910","insp_violation_id":"265700863","seq_no":"2","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"206381481","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:10:55.000000Z","updated_at":"2025-04-22T10:26:30.000000Z","normalized_code":"3939AHLLH"},{"id":13274295,"change_date":"2025-04-18 21:40:00","inspection_id":"84437910","insp_violation_id":"265700864","seq_no":"3","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"206381481","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:10:55.000000Z","updated_at":"2025-04-22T10:26:30.000000Z","normalized_code":"3965BL"},{"id":13274296,"change_date":"2025-04-18 21:40:00","inspection_id":"84437910","insp_violation_id":"265700865","seq_no":"4","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"206381481","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-20T11:10:55.000000Z","updated_at":"2025-04-22T10:26:30.000000Z","normalized_code":"3939ALTSI"},{"id":13274297,"change_date":"2025-04-18 21:40:00","inspection_id":"84437910","insp_violation_id":"265700866","seq_no":"5","part_no":"393","part_no_section":"81-H","insp_viol_unit":"1","insp_unit_id":"206381481","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:10:55.000000Z","updated_at":"2025-04-22T10:26:30.000000Z","normalized_code":"39381H"},{"id":13274298,"change_date":"2025-04-18 21:40:00","inspection_id":"84437910","insp_violation_id":"265700867","seq_no":"6","part_no":"393","part_no_section":"55C2-B","insp_viol_unit":"1","insp_unit_id":"206381481","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:10:55.000000Z","updated_at":"2025-04-22T10:26:30.000000Z","normalized_code":"39355C2B"},{"id":13274299,"change_date":"2025-04-18 21:40:00","inspection_id":"84437910","insp_violation_id":"265700868","seq_no":"7","part_no":"393","part_no_section":"48A-BIAD","insp_viol_unit":"1","insp_unit_id":"206381481","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:10:55.000000Z","updated_at":"2025-04-22T10:26:30.000000Z","normalized_code":"39348ABIAD"}],"inspection_per_units":[{"id":13658709,"change_date":"2025-04-18 21:40:00","inspection_id":"84437910","insp_unit_id":"206381481","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MOTOR COAC","insp_unit_company":"2790","insp_unit_license":"U14166","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M8TRMPA91P061527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:11:38.000000Z","updated_at":"2025-04-22T09:55:47.000000Z"}]},{"id":8379855,"change_date":"2025-04-15 21:40:00","inspection_id":"84403689","dot_number":"3927519","report_state":"US","report_number":"2053000084","insp_date":"2025-04-14 00:00:00","insp_start_time":"1557","insp_end_time":"1714","registration_date":null,"region":"CD","ci_status_code":"C","location":"USTX07","location_desc":"HIDALGO TX","county_code_state":"TX","county_code":"215","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","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":"1598494","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2025-04-15 21:40:00","snet_input_date":"2025-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-15 21:40:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-18T10:25:52.000000Z","updated_at":"2025-04-19T10:15:35.000000Z","inspection_violations":[{"id":13208032,"change_date":"2025-04-15 21:40:00","inspection_id":"84403689","insp_violation_id":"265628347","seq_no":"3","part_no":"393","part_no_section":"48A-BSRFSAD","insp_viol_unit":"1","insp_unit_id":"206319341","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:55:19.000000Z","updated_at":"2025-04-18T11:00:36.000000Z","normalized_code":"39348ABSRFSAD"},{"id":13208033,"change_date":"2025-04-15 21:40:00","inspection_id":"84403689","insp_violation_id":"265628348","seq_no":"1","part_no":"393","part_no_section":"91-BU","insp_viol_unit":"1","insp_unit_id":"206319341","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:55:19.000000Z","updated_at":"2025-04-18T11:00:36.000000Z","normalized_code":"39391BU"},{"id":13208034,"change_date":"2025-04-15 21:40:00","inspection_id":"84403689","insp_violation_id":"265628349","seq_no":"2","part_no":"393","part_no_section":"30-B","insp_viol_unit":"1","insp_unit_id":"206319341","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:55:19.000000Z","updated_at":"2025-04-18T11:00:36.000000Z","normalized_code":"39330B"},{"id":13208035,"change_date":"2025-04-15 21:40:00","inspection_id":"84403689","insp_violation_id":"265628350","seq_no":"4","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"206319341","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:55:19.000000Z","updated_at":"2025-04-18T11:00:36.000000Z","normalized_code":"39360C"},{"id":13208036,"change_date":"2025-04-15 21:40:00","inspection_id":"84403689","insp_violation_id":"265628351","seq_no":"5","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"206319341","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:55:19.000000Z","updated_at":"2025-04-18T11:00:36.000000Z","normalized_code":"39395A1"},{"id":13208037,"change_date":"2025-04-15 21:40:00","inspection_id":"84403689","insp_violation_id":"265628352","seq_no":"6","part_no":"395","part_no_section":"22G-ELDMFV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:55:19.000000Z","updated_at":"2025-04-18T11:00:36.000000Z","normalized_code":"39522GELDMFV"}],"inspection_per_units":[{"id":13599848,"change_date":"2025-04-15 21:40:00","inspection_id":"84403689","insp_unit_id":"206319341","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"7733","insp_unit_license":"96RC1H","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3CET2P620G5172583","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:10:21.000000Z","updated_at":"2025-04-19T09:54:49.000000Z"}]},{"id":8356153,"change_date":"2025-04-11 21:41:00","inspection_id":"84378610","dot_number":"3927519","report_state":"TX","report_number":"V251837408","insp_date":"2025-04-10 00:00:00","insp_start_time":"0645","insp_end_time":"0714","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C501","location_desc":"CAMINO REAL POE","county_code_state":"TX","county_code":"323","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TERMINAL","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54500","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9547445","transaction_code":"A","transaction_date":"2025-04-11 00:00:00","upload_date":"2025-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":"M","census_search_date":"2025-04-11 21:41:00","snet_input_date":"2025-04-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-11 21:41:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1069759","created_at":"2025-04-14T10:29:52.000000Z","updated_at":"2025-04-15T10:16:06.000000Z","inspection_violations":[{"id":13163527,"change_date":"2025-04-11 21:41:00","inspection_id":"84378610","insp_violation_id":"265578194","seq_no":"1","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"206274352","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-13T11:06:28.000000Z","updated_at":"2025-04-15T10:38:13.000000Z","normalized_code":"39348A"},{"id":13163528,"change_date":"2025-04-11 21:41:00","inspection_id":"84378610","insp_violation_id":"265578195","seq_no":"2","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"206274352","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-04-13T11:06:28.000000Z","updated_at":"2025-04-15T10:38:13.000000Z","normalized_code":"39375C"},{"id":13163529,"change_date":"2025-04-11 21:41:00","inspection_id":"84378610","insp_violation_id":"265578196","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"206274352","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-13T11:06:28.000000Z","updated_at":"2025-04-15T10:38:13.000000Z","normalized_code":"39378"},{"id":13163530,"change_date":"2025-04-11 21:41:00","inspection_id":"84378610","insp_violation_id":"265578197","seq_no":"4","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"206274352","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-04-13T11:06:28.000000Z","updated_at":"2025-04-15T10:38:13.000000Z","normalized_code":"3939TS"},{"id":13163531,"change_date":"2025-04-11 21:41:00","inspection_id":"84378610","insp_violation_id":"265578198","seq_no":"5","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"206274352","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-13T11:06:28.000000Z","updated_at":"2025-04-15T10:38:13.000000Z","normalized_code":"3963A1"},{"id":13163532,"change_date":"2025-04-11 21:41:00","inspection_id":"84378610","insp_violation_id":"265578199","seq_no":"6","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"206274352","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-13T11:06:28.000000Z","updated_at":"2025-04-15T10:38:13.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":13558451,"change_date":"2025-04-11 21:41:00","inspection_id":"84378610","insp_unit_id":"206274352","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"1841","insp_unit_license":"K127323","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M83JMPA32P061841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:19:24.000000Z","updated_at":"2025-04-15T10:05:47.000000Z"}]},{"id":8395018,"change_date":"2025-04-16 21:41:00","inspection_id":"84419576","dot_number":"3927519","report_state":"TX","report_number":"74D89DIEA2","insp_date":"2025-04-08 00:00:00","insp_start_time":"0826","insp_end_time":"0846","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0030 IN DALLAS CO. (32-64)","county_code_state":"TX","county_code":"113","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","viol_total":"5","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9551913","transaction_code":"A","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":"M","census_search_date":"2025-04-16 21:41:00","snet_input_date":"2025-04-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-16 21:41:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1069759","created_at":"2025-04-19T10:19:33.000000Z","updated_at":"2025-04-20T10:26:20.000000Z","inspection_violations":[{"id":13240262,"change_date":"2025-04-16 21:41:00","inspection_id":"84419576","insp_violation_id":"265664299","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206348831","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:19:02.000000Z","updated_at":"2025-04-20T10:48:42.000000Z","normalized_code":"3922RG"},{"id":13240263,"change_date":"2025-04-16 21:41:00","inspection_id":"84419576","insp_violation_id":"265664300","seq_no":"2","part_no":"395","part_no_section":"22H4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:19:02.000000Z","updated_at":"2025-04-20T10:48:42.000000Z","normalized_code":"39522H4"},{"id":13240264,"change_date":"2025-04-16 21:41:00","inspection_id":"84419576","insp_violation_id":"265664301","seq_no":"3","part_no":"395","part_no_section":"24D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:19:02.000000Z","updated_at":"2025-04-20T10:48:42.000000Z","normalized_code":"39524D"},{"id":13240265,"change_date":"2025-04-16 21:41:00","inspection_id":"84419576","insp_violation_id":"265664302","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"206348831","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:19:02.000000Z","updated_at":"2025-04-20T10:48:42.000000Z","normalized_code":"39617C"},{"id":13240266,"change_date":"2025-04-16 21:41:00","inspection_id":"84419576","insp_violation_id":"265664303","seq_no":"5","part_no":"395","part_no_section":"22H2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:19:02.000000Z","updated_at":"2025-04-20T10:48:42.000000Z","normalized_code":"39522H2"}],"inspection_per_units":[{"id":13627286,"change_date":"2025-04-16 21:41:00","inspection_id":"84419576","insp_unit_id":"206348831","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"PREO","insp_unit_company":null,"insp_unit_license":"T08619","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2PCH3349461010404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-19T10:11:10.000000Z","updated_at":"2025-04-20T10:03:08.000000Z"}]},{"id":8280347,"change_date":"2025-04-03 21:40:00","inspection_id":"84299036","dot_number":"3927519","report_state":"US","report_number":"0981001861","insp_date":"2025-04-02 00:00:00","insp_start_time":"1825","insp_end_time":"1856","registration_date":null,"region":"CD","ci_status_code":"C","location":"USTX17","location_desc":"LAREDO TX","county_code_state":"TX","county_code":"479","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1546308","transaction_code":"A","transaction_date":"2025-04-03 00:00:00","upload_date":"2025-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2025-04-03 21:40:00","snet_input_date":"2025-04-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-03 21:40:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:24:11.000000Z","updated_at":"2025-04-07T10:16:29.000000Z","inspection_violations":[{"id":13014660,"change_date":"2025-04-03 21:40:00","inspection_id":"84299036","insp_violation_id":"265410096","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"206128390","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:46:41.000000Z","updated_at":"2025-04-07T10:27:48.000000Z","normalized_code":"39360C"},{"id":13014661,"change_date":"2025-04-03 21:40:00","inspection_id":"84299036","insp_violation_id":"265410097","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"206128390","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:46:41.000000Z","updated_at":"2025-04-07T10:27:48.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":13404892,"change_date":"2025-04-03 21:40:00","inspection_id":"84299036","insp_unit_id":"206128390","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"6373","insp_unit_license":"50RC7H","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3CEU3W523T5220228","insp_unit_decal":"Y","insp_unit_decal_number":"35254247","created_at":"2025-04-06T10:03:40.000000Z","updated_at":"2025-04-07T09:49:36.000000Z"}]},{"id":8266686,"change_date":"2025-04-03 21:41:00","inspection_id":"84284534","dot_number":"3927519","report_state":"TX","report_number":"V251829890","insp_date":"2025-03-28 00:00:00","insp_start_time":"0802","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"JC LOMER TRANSPORTS INTERNACI","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"59083","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9538651","transaction_code":"C","transaction_date":"2025-04-03 00:00:00","upload_date":"2025-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":"M","census_search_date":"2025-04-01 21:40:00","snet_input_date":"2025-03-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-01 21:40:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1069759","created_at":"2025-04-04T10:21:28.000000Z","updated_at":"2025-04-07T10:17:13.000000Z","inspection_violations":[{"id":13017950,"change_date":"2025-04-03 21:41:00","inspection_id":"84284534","insp_violation_id":"265428994","seq_no":"1","part_no":"393","part_no_section":"203","insp_viol_unit":"1","insp_unit_id":"206143866","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:48:00.000000Z","updated_at":"2025-04-07T10:30:43.000000Z","normalized_code":"393203"},{"id":13017951,"change_date":"2025-04-03 21:41:00","inspection_id":"84284534","insp_violation_id":"265428995","seq_no":"2","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"206143866","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-04-05T10:48:00.000000Z","updated_at":"2025-04-07T10:30:43.000000Z","normalized_code":"39345B2UV"},{"id":13017952,"change_date":"2025-04-03 21:41:00","inspection_id":"84284534","insp_violation_id":"265428996","seq_no":"3","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"206143866","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:48:00.000000Z","updated_at":"2025-04-07T10:30:43.000000Z","normalized_code":"39345DLUV"},{"id":13017953,"change_date":"2025-04-03 21:41:00","inspection_id":"84284534","insp_violation_id":"265428997","seq_no":"4","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"206143866","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:48:00.000000Z","updated_at":"2025-04-07T10:30:43.000000Z","normalized_code":"39345DLUV"},{"id":13017954,"change_date":"2025-04-03 21:41:00","inspection_id":"84284534","insp_violation_id":"265428998","seq_no":"5","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"206143866","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:48:00.000000Z","updated_at":"2025-04-07T10:30:43.000000Z","normalized_code":"39345DLUV"},{"id":13017955,"change_date":"2025-04-03 21:41:00","inspection_id":"84284534","insp_violation_id":"265428999","seq_no":"6","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"206143866","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:48:00.000000Z","updated_at":"2025-04-07T10:30:43.000000Z","normalized_code":"39348A"},{"id":13017956,"change_date":"2025-04-03 21:41:00","inspection_id":"84284534","insp_violation_id":"265429000","seq_no":"7","part_no":"393","part_no_section":"62C","insp_viol_unit":"1","insp_unit_id":"206143866","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:48:00.000000Z","updated_at":"2025-04-07T10:30:43.000000Z","normalized_code":"39362C"},{"id":13017957,"change_date":"2025-04-03 21:41:00","inspection_id":"84284534","insp_violation_id":"265429001","seq_no":"8","part_no":"393","part_no_section":"62E","insp_viol_unit":"1","insp_unit_id":"206143866","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:48:00.000000Z","updated_at":"2025-04-07T10:30:43.000000Z","normalized_code":"39362E"},{"id":13017958,"change_date":"2025-04-03 21:41:00","inspection_id":"84284534","insp_violation_id":"265429002","seq_no":"9","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"206143866","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:48:00.000000Z","updated_at":"2025-04-07T10:30:43.000000Z","normalized_code":"39378"},{"id":13017959,"change_date":"2025-04-03 21:41:00","inspection_id":"84284534","insp_violation_id":"265429003","seq_no":"10","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"206143866","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:48:00.000000Z","updated_at":"2025-04-07T10:30:43.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":13409923,"change_date":"2025-04-03 21:41:00","inspection_id":"84284534","insp_unit_id":"206143866","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"OTHR","insp_unit_company":"5753","insp_unit_license":"76RC2E","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"WMARR4ZZ5DC018670","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-06T10:05:31.000000Z","updated_at":"2025-04-07T09:52:14.000000Z"}]},{"id":8321566,"change_date":"2025-04-08 21:40:00","inspection_id":"84342186","dot_number":"3927519","report_state":"TX","report_number":"V251819284","insp_date":"2025-03-28 00:00:00","insp_start_time":"0630","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH35 NB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ESTRELLA TRANSPORTATION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9543739","transaction_code":"A","transaction_date":"2025-04-08 00:00:00","upload_date":"2025-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":"M","census_search_date":"2025-04-08 21:40:00","snet_input_date":"2025-03-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-08 21:40:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1069759","created_at":"2025-04-11T10:12:25.000000Z","updated_at":"2025-04-12T10:22:35.000000Z","inspection_violations":[{"id":13096913,"change_date":"2025-04-08 21:40:00","inspection_id":"84342186","insp_violation_id":"265502976","seq_no":"1","part_no":"395","part_no_section":"8A-ELD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:41:29.000000Z","updated_at":"2025-04-11T10:50:37.000000Z","normalized_code":"3958AELD"},{"id":13096914,"change_date":"2025-04-08 21:40:00","inspection_id":"84342186","insp_violation_id":"265502977","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206207142","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:41:29.000000Z","updated_at":"2025-04-11T10:50:37.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":13496301,"change_date":"2025-04-08 21:40:00","inspection_id":"84342186","insp_unit_id":"206207142","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1414","insp_unit_license":"54RC4A","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3CET2M622A5138053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-11T10:06:23.000000Z","updated_at":"2025-04-12T10:02:11.000000Z"}]},{"id":8205088,"change_date":"2025-03-26 21:41:00","inspection_id":"84219635","dot_number":"3927519","report_state":"CA","report_number":"UCC6002481","insp_date":"2025-03-21 00:00:00","insp_start_time":"0915","insp_end_time":"0945","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"660 E. SAN YSIDRO BLVD.","county_code_state":"CA","county_code":"073","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54425","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":"15754572","transaction_code":"C","transaction_date":"2025-03-21 00:00:00","upload_date":"2025-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2025-03-25 21:41:00","snet_input_date":"2025-03-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-25 21:41:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-28T10:15:15.000000Z","updated_at":"2025-03-30T10:36:28.000000Z","inspection_violations":[{"id":12885124,"change_date":"2025-03-26 21:41:00","inspection_id":"84219635","insp_violation_id":"265269249","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"206003788","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:59:41.000000Z","updated_at":"2025-03-29T10:41:31.000000Z","normalized_code":"3939ALIL"},{"id":12885125,"change_date":"2025-03-26 21:41:00","inspection_id":"84219635","insp_violation_id":"265269250","seq_no":"2","part_no":"393","part_no_section":"209E-SPSLA","insp_viol_unit":"1","insp_unit_id":"206003788","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:59:41.000000Z","updated_at":"2025-03-29T10:41:31.000000Z","normalized_code":"393209ESPSLA"}],"inspection_per_units":[{"id":13283765,"change_date":"2025-03-26 21:41:00","inspection_id":"84219635","insp_unit_id":"206003788","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"98\/ WHT","insp_unit_license":"84440A4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3CET2P526C5150938","insp_unit_decal":"Y","insp_unit_decal_number":"34801014","created_at":"2025-03-29T10:11:10.000000Z","updated_at":"2025-03-30T10:08:00.000000Z"}]},{"id":8117376,"change_date":"2025-03-14 21:40:00","inspection_id":"84127230","dot_number":"3927519","report_state":"US","report_number":"1132000927","insp_date":"2025-03-13 00:00:00","insp_start_time":"1051","insp_end_time":"1216","registration_date":null,"region":"CD","ci_status_code":"C","location":"USTX17","location_desc":"LAREDO TX","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ESTRELLA TRANSPORTATION LLC","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-03-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1471314","transaction_code":"A","transaction_date":"2025-03-14 00:00:00","upload_date":"2025-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2025-03-14 21:40:00","snet_input_date":"2025-03-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-14 21:40:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:54.000000Z","updated_at":"2025-03-17T21:06:54.000000Z","inspection_violations":[{"id":12693431,"change_date":"2025-03-14 21:40:00","inspection_id":"84127230","insp_violation_id":"265040990","seq_no":"1","part_no":"393","part_no_section":"62-BENM","insp_viol_unit":"1","insp_unit_id":"205802836","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T22:08:09.000000Z","updated_at":"2025-03-17T22:08:09.000000Z","normalized_code":"39362BENM"},{"id":12693432,"change_date":"2025-03-14 21:40:00","inspection_id":"84127230","insp_violation_id":"265040991","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"205802836","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:09.000000Z","updated_at":"2025-03-17T22:08:09.000000Z","normalized_code":"3922SLLUCR"},{"id":12693433,"change_date":"2025-03-14 21:40:00","inspection_id":"84127230","insp_violation_id":"265040992","seq_no":"3","part_no":"393","part_no_section":"55C2-B","insp_viol_unit":"1","insp_unit_id":"205802836","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:09.000000Z","updated_at":"2025-03-17T22:08:09.000000Z","normalized_code":"39355C2B"}],"inspection_per_units":[{"id":13106369,"change_date":"2025-03-14 21:40:00","inspection_id":"84127230","insp_unit_id":"205802836","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"7733","insp_unit_license":"96RC1H","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3CET2P620G5172583","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:54.000000Z","updated_at":"2025-03-17T23:59:54.000000Z"}]},{"id":8050098,"change_date":"2025-03-07 21:38:00","inspection_id":"84056311","dot_number":"3927519","report_state":"US","report_number":"1674001087","insp_date":"2025-03-06 00:00:00","insp_start_time":"1833","insp_end_time":"1924","registration_date":null,"region":"CS","ci_status_code":"C","location":"USTX17","location_desc":"LAREDO TX","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ESTRELLA TRANSPORTATION LLC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","viol_total":"3","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":"1439697","transaction_code":"A","transaction_date":"2025-03-07 00:00:00","upload_date":"2025-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2025-03-07 21:38:00","snet_input_date":"2025-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-07 21:38:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:25.000000Z","updated_at":"2025-03-17T21:05:25.000000Z","inspection_violations":[{"id":12580715,"change_date":"2025-03-07 21:38:00","inspection_id":"84056311","insp_violation_id":"264881829","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"205671781","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:36.000000Z","updated_at":"2025-03-17T22:07:36.000000Z","normalized_code":"39360C"},{"id":12580716,"change_date":"2025-03-07 21:38:00","inspection_id":"84056311","insp_violation_id":"264881830","seq_no":"2","part_no":"396","part_no_section":"3A1-ALBV","insp_viol_unit":"1","insp_unit_id":"205671781","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:36.000000Z","updated_at":"2025-03-17T22:07:36.000000Z","normalized_code":"3963A1ALBV"},{"id":12580717,"change_date":"2025-03-07 21:38:00","inspection_id":"84056311","insp_violation_id":"264881831","seq_no":"3","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"205671781","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:36.000000Z","updated_at":"2025-03-17T22:07:36.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":12996776,"change_date":"2025-03-07 21:38:00","inspection_id":"84056311","insp_unit_id":"205671781","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"SCANIA","insp_unit_company":"9520","insp_unit_license":"07RA4U","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"9BSK4X208J3909520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:35.000000Z","updated_at":"2025-03-17T23:58:35.000000Z"}]},{"id":7947967,"change_date":"2025-06-09 21:42:00","inspection_id":"83949150","dot_number":"3927519","report_state":"CA","report_number":"UCC6002398","insp_date":"2025-02-22 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"660 E. SAN YSIDRO BLVD.","county_code_state":"CA","county_code":"073","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"15715174","transaction_code":"C","transaction_date":"2025-06-09 00:00:00","upload_date":"2025-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2025-06-09 21:42:00","snet_input_date":"2025-02-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-24 21:40:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:15.000000Z","updated_at":"2025-06-14T10:00:36.000000Z","inspection_violations":[{"id":14182846,"change_date":"2025-06-09 21:42:00","inspection_id":"83949150","insp_violation_id":"266747742","seq_no":"1","part_no":"393","part_no_section":"62-BEMEI","insp_viol_unit":"1","insp_unit_id":"207300505","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:59.000000Z","normalized_code":"39362BEMEI"},{"id":14182847,"change_date":"2025-06-09 21:42:00","inspection_id":"83949150","insp_violation_id":"266747743","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"207300505","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:59.000000Z","normalized_code":"3922SLLEQP"},{"id":14182848,"change_date":"2025-06-09 21:42:00","inspection_id":"83949150","insp_violation_id":"266747744","seq_no":"3","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"207300505","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:59.000000Z","normalized_code":"3922SLLEQP"},{"id":14182849,"change_date":"2025-06-09 21:42:00","inspection_id":"83949150","insp_violation_id":"266747745","seq_no":"4","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"207300505","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:59.000000Z","normalized_code":"39341BNPB"}],"inspection_per_units":[{"id":14500756,"change_date":"2025-06-09 21:42:00","inspection_id":"83949150","insp_unit_id":"207300505","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"98\/ WHT","insp_unit_license":"84440A4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3CET2P526C5150938","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:36.000000Z","updated_at":"2025-06-13T09:45:36.000000Z"}]},{"id":7846737,"change_date":"2025-06-09 21:42:00","inspection_id":"83843058","dot_number":"3927519","report_state":"CA","report_number":"NEIL002286","insp_date":"2025-02-08 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"660 E SAN YSIDRO BLVD","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":"2025-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"3","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15700128","transaction_code":"C","transaction_date":"2025-06-09 00:00:00","upload_date":"2025-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2025-06-09 21:42:00","snet_input_date":"2025-02-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-11 21:40:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:10.000000Z","updated_at":"2025-06-14T10:00:36.000000Z","inspection_violations":[{"id":14182843,"change_date":"2025-06-09 21:42:00","inspection_id":"83843058","insp_violation_id":"266747405","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207300010","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:59.000000Z","normalized_code":"39360C"},{"id":14182844,"change_date":"2025-06-09 21:42:00","inspection_id":"83843058","insp_violation_id":"266747406","seq_no":"2","part_no":"393","part_no_section":"62-BEI","insp_viol_unit":"1","insp_unit_id":"207300010","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:59.000000Z","normalized_code":"39362BEI"},{"id":14182845,"change_date":"2025-06-09 21:42:00","inspection_id":"83843058","insp_violation_id":"266747407","seq_no":"3","part_no":"391","part_no_section":"41A-MCPVI","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-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:59.000000Z","normalized_code":"39141AMCPVI"}],"inspection_per_units":[{"id":14500755,"change_date":"2025-06-09 21:42:00","inspection_id":"83843058","insp_unit_id":"207300010","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"98 WHITE","insp_unit_license":"84440A4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3CET2P526C5150938","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:36.000000Z","updated_at":"2025-06-13T09:45:36.000000Z"}]},{"id":7788255,"change_date":"2025-06-09 21:41:00","inspection_id":"83781616","dot_number":"3927519","report_state":"CA","report_number":"ND4C006466","insp_date":"2025-02-01 00:00:00","insp_start_time":"0645","insp_end_time":"0715","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"660 E. SAN YSIDRO","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"35200","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":"15691879","transaction_code":"C","transaction_date":"2025-06-09 00:00:00","upload_date":"2025-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2025-06-09 21:41:00","snet_input_date":"2025-02-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-04 21:40:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:55.000000Z","updated_at":"2025-06-14T10:00:25.000000Z","inspection_violations":[{"id":14170337,"change_date":"2025-06-09 21:41:00","inspection_id":"83781616","insp_violation_id":"266746351","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"207298698","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-12T10:15:40.000000Z","updated_at":"2025-06-13T10:17:02.000000Z","normalized_code":"3939ALTSI"},{"id":14170338,"change_date":"2025-06-09 21:41:00","inspection_id":"83781616","insp_violation_id":"266746352","seq_no":"2","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"207298698","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:40.000000Z","updated_at":"2025-06-13T10:17:02.000000Z","normalized_code":"39345DBAAL"},{"id":14170339,"change_date":"2025-06-09 21:41:00","inspection_id":"83781616","insp_violation_id":"266746353","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207298698","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:40.000000Z","updated_at":"2025-06-13T10:17:02.000000Z","normalized_code":"39347E"},{"id":14170340,"change_date":"2025-06-09 21:41:00","inspection_id":"83781616","insp_violation_id":"266746354","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"207298698","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:40.000000Z","updated_at":"2025-06-13T10:17:02.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":14488218,"change_date":"2025-06-09 21:41:00","inspection_id":"83781616","insp_unit_id":"207298698","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"180 WHT","insp_unit_license":"98324C4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3CER8G613E5009939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:28.000000Z","updated_at":"2025-06-13T09:45:28.000000Z"}]},{"id":7686493,"change_date":"2025-01-22 21:39:00","inspection_id":"83674562","dot_number":"3927519","report_state":"TX","report_number":"V251758246","insp_date":"2025-01-17 00:00:00","insp_start_time":"0740","insp_end_time":"0811","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH35 NB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ESTRELLA TRANSPORTATION LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"43290","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":"9481060","transaction_code":"A","transaction_date":"2025-01-22 00:00:00","upload_date":"2025-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":"M","census_search_date":"2025-01-22 21:39:00","snet_input_date":"2025-01-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-22 21:39:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1069759","created_at":"2025-03-17T20:57:53.000000Z","updated_at":"2025-03-17T20:57:53.000000Z","inspection_violations":[{"id":12010430,"change_date":"2025-01-22 21:39:00","inspection_id":"83674562","insp_violation_id":"264130150","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204962591","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:31.000000Z","updated_at":"2025-03-17T22:04:31.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":12403292,"change_date":"2025-01-22 21:39:00","inspection_id":"83674562","insp_unit_id":"204962591","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"OTHR","insp_unit_company":"9520","insp_unit_license":"07RA4U","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"9BSK4X208J3909520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:52.000000Z","updated_at":"2025-03-17T23:51:52.000000Z"}]},{"id":7352886,"change_date":"2024-12-06 21:43:00","inspection_id":"83324242","dot_number":"3927519","report_state":"GA","report_number":"1450000142","insp_date":"2024-11-29 00:00:00","insp_start_time":"1315","insp_end_time":"1415","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BRASELTON GA","county_code_state":"GA","county_code":"157","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ESTRELLA TRANSPORTATION","shipping_paper_number":"NA","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-12-06 21:43:00","post_acc_ind":"Y","gross_comb_veh_wt":"56000","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":"1125593","transaction_code":"A","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2024-12-06 21:43:00","snet_input_date":"2024-11-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-06 21:43:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:25.000000Z","updated_at":"2025-03-17T20:49:25.000000Z","inspection_violations":[{"id":11492014,"change_date":"2024-12-06 21:43:00","inspection_id":"83324242","insp_violation_id":"263280930","seq_no":"1","part_no":"392","part_no_section":"2-SLLML","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W01E499968","created_at":"2025-03-17T22:01:55.000000Z","updated_at":"2025-03-17T22:01:55.000000Z","normalized_code":"3922SLLML"},{"id":11492015,"change_date":"2024-12-06 21:43:00","inspection_id":"83324242","insp_violation_id":"263280931","seq_no":"2","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:55.000000Z","updated_at":"2025-03-17T22:01:55.000000Z","normalized_code":"39530B1ELDDFR"},{"id":11492016,"change_date":"2024-12-06 21:43:00","inspection_id":"83324242","insp_violation_id":"263280932","seq_no":"3","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:55.000000Z","updated_at":"2025-03-17T22:01:55.000000Z","normalized_code":"39530B1ELDDFR"},{"id":11492017,"change_date":"2024-12-06 21:43:00","inspection_id":"83324242","insp_violation_id":"263280933","seq_no":"4","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:55.000000Z","updated_at":"2025-03-17T22:01:55.000000Z","normalized_code":"39530B1ELDDFR"},{"id":11492018,"change_date":"2024-12-06 21:43:00","inspection_id":"83324242","insp_violation_id":"263280934","seq_no":"5","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:55.000000Z","updated_at":"2025-03-17T22:01:55.000000Z","normalized_code":"39530B1ELDDFR"},{"id":11492019,"change_date":"2024-12-06 21:43:00","inspection_id":"83324242","insp_violation_id":"263280935","seq_no":"6","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:55.000000Z","updated_at":"2025-03-17T22:01:55.000000Z","normalized_code":"39530B1ELDDFR"},{"id":11492020,"change_date":"2024-12-06 21:43:00","inspection_id":"83324242","insp_violation_id":"263280936","seq_no":"7","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:55.000000Z","updated_at":"2025-03-17T22:01:55.000000Z","normalized_code":"39530B1ELDDFR"}],"inspection_per_units":[{"id":11861144,"change_date":"2024-12-06 21:43:00","inspection_id":"83324242","insp_unit_id":"204224263","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"PREVOST","insp_unit_company":"610","insp_unit_license":"1MBP421","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2PCH334938C711099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:58.000000Z","updated_at":"2025-03-17T23:45:58.000000Z"}]},{"id":6675556,"change_date":"2024-09-09 21:39:00","inspection_id":"82605644","dot_number":"3927519","report_state":"GA","report_number":"1429000550","insp_date":"2024-09-02 00:00:00","insp_start_time":"1116","insp_end_time":"1131","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LAVONIA GA","county_code_state":"GA","county_code":"119","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ESTRELLA TRANSPORTATION LLC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52060","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":"828009","transaction_code":"A","transaction_date":"2024-09-09 00:00:00","upload_date":"2024-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2024-09-09 21:39:00","snet_input_date":"2024-09-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-09 21:39:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:16.000000Z","updated_at":"2025-03-17T20:35:16.000000Z","inspection_violations":[{"id":10389381,"change_date":"2024-09-09 21:39:00","inspection_id":"82605644","insp_violation_id":"261679715","seq_no":"1","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"39524"},{"id":10389382,"change_date":"2024-09-09 21:39:00","inspection_id":"82605644","insp_violation_id":"261679716","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202817254","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10763370,"change_date":"2024-09-09 21:39:00","inspection_id":"82605644","insp_unit_id":"202817254","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"PREVOST","insp_unit_company":"7","insp_unit_license":"85RC3N","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"2PCH33491A1013527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:26.000000Z","updated_at":"2025-03-17T23:34:26.000000Z"}]},{"id":6611621,"change_date":"2024-08-30 21:40:00","inspection_id":"82537625","dot_number":"3927519","report_state":"IL","report_number":"0940440004","insp_date":"2024-08-25 00:00:00","insp_start_time":"0823","insp_end_time":"0833","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-88","county_code_state":"IL","county_code":"043","insp_level_id":"3","service_center":"MW","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54999","viol_total":"3","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":"2351881","transaction_code":"A","transaction_date":"2024-08-25 00:00:00","upload_date":"2024-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2024-08-30 21:40:00","snet_input_date":"2024-08-25 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-08-30 21:40:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"145465","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:04.000000Z","updated_at":"2025-03-17T20:34:04.000000Z","inspection_violations":[{"id":10281280,"change_date":"2024-08-30 21:40:00","inspection_id":"82537625","insp_violation_id":"261526858","seq_no":"1","part_no":"392","part_no_section":"2","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-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"3922"},{"id":10281281,"change_date":"2024-08-30 21:40:00","inspection_id":"82537625","insp_violation_id":"261526859","seq_no":"2","part_no":"392","part_no_section":"2","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-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"3922"},{"id":10281282,"change_date":"2024-08-30 21:40:00","inspection_id":"82537625","insp_violation_id":"261526860","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202685826","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10659557,"change_date":"2024-08-30 21:40:00","inspection_id":"82537625","insp_unit_id":"202685826","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCI","insp_unit_company":"2224","insp_unit_license":"K040838","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2M93JMPAX3W062224","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:22.000000Z","updated_at":"2025-03-17T23:33:22.000000Z"}]},{"id":6392607,"change_date":"2024-08-05 21:43:00","inspection_id":"82303958","dot_number":"3927519","report_state":"TX","report_number":"V241492967","insp_date":"2024-07-31 00:00:00","insp_start_time":"0915","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C501","location_desc":"CAMINO REAL POE","county_code_state":"TX","county_code":"323","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TERMINAL","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54999","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":"9340728","transaction_code":"A","transaction_date":"2024-08-05 00:00:00","upload_date":"2024-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":"M","census_search_date":"2024-08-05 21:43:00","snet_input_date":"2024-07-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-05 21:43:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1069759","created_at":"2025-03-17T20:29:31.000000Z","updated_at":"2025-03-17T20:29:31.000000Z","inspection_violations":[{"id":9923775,"change_date":"2024-08-05 21:43:00","inspection_id":"82303958","insp_violation_id":"261019219","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202239945","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"3963A1"},{"id":9923776,"change_date":"2024-08-05 21:43:00","inspection_id":"82303958","insp_violation_id":"261019220","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"202239945","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"3965B"},{"id":9923777,"change_date":"2024-08-05 21:43:00","inspection_id":"82303958","insp_violation_id":"261019221","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"202239945","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"39375A3"},{"id":9923778,"change_date":"2024-08-05 21:43:00","inspection_id":"82303958","insp_violation_id":"261019222","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"202239945","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":10302359,"change_date":"2024-08-05 21:43:00","inspection_id":"82303958","insp_unit_id":"202239945","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"3992","insp_unit_license":"K130354","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2M93JMPA87W063992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:45.000000Z","updated_at":"2025-03-17T23:29:45.000000Z"}]},{"id":6157020,"change_date":"2024-07-07 21:33:00","inspection_id":"82051374","dot_number":"3927519","report_state":"US","report_number":"1126000679","insp_date":"2024-07-05 00:00:00","insp_start_time":"1053","insp_end_time":"1204","registration_date":null,"region":"CD","ci_status_code":"C","location":"USTX17","location_desc":"LAREDO TX","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ESTRELLA TRANSPORTATION LLC","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-07-07 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","viol_total":"6","oos_total":"4","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"630579","transaction_code":"A","transaction_date":"2024-07-07 00:00:00","upload_date":"2024-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":"2024-07-07 21:33:00","snet_input_date":"2024-07-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-07 21:33:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:39.000000Z","updated_at":"2025-03-17T20:24:39.000000Z","inspection_violations":[{"id":9555841,"change_date":"2024-07-07 21:33:00","inspection_id":"82051374","insp_violation_id":"260490467","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201755823","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"3922"},{"id":9555842,"change_date":"2024-07-07 21:33:00","inspection_id":"82051374","insp_violation_id":"260490468","seq_no":"2","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"C","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"3958A1"},{"id":9555843,"change_date":"2024-07-07 21:33:00","inspection_id":"82051374","insp_violation_id":"260490469","seq_no":"3","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"3958A1"},{"id":9555844,"change_date":"2024-07-07 21:33:00","inspection_id":"82051374","insp_violation_id":"260490470","seq_no":"4","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"201755823","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"39375A1"},{"id":9555845,"change_date":"2024-07-07 21:33:00","inspection_id":"82051374","insp_violation_id":"260490471","seq_no":"5","part_no":"393","part_no_section":"62","insp_viol_unit":"1","insp_unit_id":"201755823","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"39362"},{"id":9555846,"change_date":"2024-07-07 21:33:00","inspection_id":"82051374","insp_violation_id":"260490472","seq_no":"6","part_no":"393","part_no_section":"62","insp_viol_unit":"1","insp_unit_id":"201755823","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"39362"}],"inspection_per_units":[{"id":9918069,"change_date":"2024-07-07 21:33:00","inspection_id":"82051374","insp_unit_id":"201755823","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"SCANIA","insp_unit_company":"9520","insp_unit_license":"07RA4U","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"9BSK4X208J3909520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:48.000000Z","updated_at":"2025-03-17T23:25:48.000000Z"}]},{"id":5373369,"change_date":"2024-03-28 21:41:00","inspection_id":"81200572","dot_number":"3927519","report_state":"TX","report_number":"V241369412","insp_date":"2024-03-19 00:00:00","insp_start_time":"1625","insp_end_time":"1730","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 E SB MM 391","county_code_state":"TX","county_code":"139","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BUS STOP","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"5","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9233030","transaction_code":"C","transaction_date":"2024-03-28 00:00:00","upload_date":"2024-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":"M","census_search_date":"2024-03-26 21:43:00","snet_input_date":"2024-03-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-26 21:43:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"1415 W INDIAN SCHOOL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85013","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1069759","created_at":"2025-03-17T20:09:05.000000Z","updated_at":"2025-03-17T20:09:05.000000Z","inspection_violations":[{"id":8293634,"change_date":"2024-03-28 21:41:00","inspection_id":"81200572","insp_violation_id":"258646194","seq_no":"1","part_no":"385","part_no_section":"337(b)","insp_viol_unit":"1","insp_unit_id":"200144096","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:46:07.000000Z","updated_at":"2025-03-17T21:46:07.000000Z","normalized_code":"385337B"},{"id":8293635,"change_date":"2024-03-28 21:41:00","inspection_id":"81200572","insp_violation_id":"258646195","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"200144096","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:07.000000Z","updated_at":"2025-03-17T21:46:07.000000Z","normalized_code":"39360C"},{"id":8293636,"change_date":"2024-03-28 21:41:00","inspection_id":"81200572","insp_violation_id":"258646196","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200144096","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:07.000000Z","updated_at":"2025-03-17T21:46:07.000000Z","normalized_code":"39378"},{"id":8293637,"change_date":"2024-03-28 21:41:00","inspection_id":"81200572","insp_violation_id":"258646197","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200144096","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:46:07.000000Z","updated_at":"2025-03-17T21:46:07.000000Z","normalized_code":"3939A"},{"id":8293638,"change_date":"2024-03-28 21:41:00","inspection_id":"81200572","insp_violation_id":"258646198","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200144096","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:46:07.000000Z","updated_at":"2025-03-17T21:46:07.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8653918,"change_date":"2024-03-28 21:41:00","inspection_id":"81200572","insp_unit_id":"200144096","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"PREO","insp_unit_company":null,"insp_unit_license":"68U467M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2PCH33499Y1013527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:29.000000Z","updated_at":"2025-03-17T23:13:29.000000Z"}]},{"id":4647516,"change_date":"2024-01-04 21:47:00","inspection_id":"80407961","dot_number":"3927519","report_state":"NM","report_number":"4033N9P4G5","insp_date":"2023-12-15 00:00:00","insp_start_time":"0300","insp_end_time":"0406","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ANTHONY PORT OF ENTRY","county_code_state":"NM","county_code":"013","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS ABOVE","shipping_paper_number":"NA","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-12-17 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"55000","viol_total":"3","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2049363","transaction_code":"C","transaction_date":"2023-12-15 00:00:00","upload_date":"2024-01-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03927519","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-16 00:00:00","source_office":"2NMS001","mcmis_add_date":"2023-12-17 21:31:00","insp_carrier_name":"ESTRELLA TRANSPORTATION LLC","insp_carrier_street":"2948 W. MCDOWELL RD","insp_carrier_city":"PHOENIX","insp_carrier_state":"AZ","insp_carrier_zip_code":"85009","insp_colonia":null,"docket_number":"1454653","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:57.000000Z","updated_at":"2025-03-17T19:54:57.000000Z","inspection_violations":[{"id":7185007,"change_date":"2024-01-04 21:47:00","inspection_id":"80407961","insp_violation_id":"257188584","seq_no":"1","part_no":"385","part_no_section":"337(b)","insp_viol_unit":"1","insp_unit_id":"198816654","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:40:43.000000Z","updated_at":"2025-03-17T21:40:43.000000Z","normalized_code":"385337B"},{"id":7185008,"change_date":"2024-01-04 21:47:00","inspection_id":"80407961","insp_violation_id":"257188585","seq_no":"2","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:40:43.000000Z","updated_at":"2025-03-17T21:40:43.000000Z","normalized_code":"3958A1"},{"id":7185009,"change_date":"2024-01-04 21:47:00","inspection_id":"80407961","insp_violation_id":"257188586","seq_no":"3","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"198816654","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:40:43.000000Z","updated_at":"2025-03-17T21:40:43.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":7474684,"change_date":"2024-01-04 21:47:00","inspection_id":"80407961","insp_unit_id":"198816654","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"SCAN","insp_unit_company":"UNIT 2131","insp_unit_license":"43RC3S","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"YS2K6X20XN1921427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:49.000000Z","updated_at":"2025-03-17T23:02:49.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3927519\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3927519\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3927519\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/3927519\/inspections","per_page":100,"prev_page_url":null,"to":30,"total":30}