{"current_page":1,"data":[{"id":11778774,"change_date":"2026-04-29 21:39:00","inspection_id":"87709924","dot_number":"2203949","report_state":"NY","report_number":"0L12400313","insp_date":"2026-04-23 00:00:00","insp_start_time":"1152","insp_end_time":"1212","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"JERICHO NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","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":"2026-04-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"3230231","transaction_code":"A","transaction_date":"2026-04-29 00:00:00","upload_date":"2026-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2026-04-29 21:39:00","snet_input_date":"2026-04-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-29 21:39:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-02T09:41:00.000000Z","updated_at":"2026-05-10T09:30:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20491086,"change_date":"2026-04-29 21:39:00","inspection_id":"87709924","insp_unit_id":"213285876","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"55362NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AV2S5T51492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-02T09:19:12.000000Z","updated_at":"2026-05-10T09:03:06.000000Z"}]},{"id":11474660,"change_date":"2026-04-21 21:38:00","inspection_id":"87393521","dot_number":"2203949","report_state":"NY","report_number":"N840701069","insp_date":"2026-03-20 00:00:00","insp_start_time":"0636","insp_end_time":"0702","registration_date":"2026-04-20 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"BRONX NY","county_code_state":"NY","county_code":"005","insp_level_id":"2","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2026-03-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3067163","transaction_code":"C","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2026-03-25 21:39:00","snet_input_date":"2026-03-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-25 21:39:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:37:05.000000Z","updated_at":"2026-05-02T09:30:05.000000Z","inspection_violations":[{"id":20350057,"change_date":"2026-04-21 21:38:00","inspection_id":"87393521","insp_violation_id":"273742856","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"213132729","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455727630","created_at":"2026-04-27T09:54:25.000000Z","updated_at":"2026-05-02T09:42:08.000000Z","normalized_code":"39395A1"},{"id":20350058,"change_date":"2026-04-21 21:38:00","inspection_id":"87393521","insp_violation_id":"273742857","seq_no":"2","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455727600","created_at":"2026-04-27T09:54:25.000000Z","updated_at":"2026-05-02T09:42:08.000000Z","normalized_code":"3922SLLLR"},{"id":20350059,"change_date":"2026-04-21 21:38:00","inspection_id":"87393521","insp_violation_id":"273742858","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"213132729","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455727627","created_at":"2026-04-27T09:54:25.000000Z","updated_at":"2026-05-02T09:42:08.000000Z","normalized_code":"39360C"},{"id":20350060,"change_date":"2026-04-21 21:38:00","inspection_id":"87393521","insp_violation_id":"273742859","seq_no":"4","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"213132729","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455727613","created_at":"2026-04-27T09:54:25.000000Z","updated_at":"2026-05-02T09:42:08.000000Z","normalized_code":"39355D1B"}],"inspection_per_units":[{"id":19654192,"change_date":"2026-04-21 21:38:00","inspection_id":"87393521","insp_unit_id":"213132729","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"12","insp_unit_license":"55362NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AV2S5T51492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:13:00.000000Z","updated_at":"2026-05-02T09:02:07.000000Z"}]},{"id":10282500,"change_date":"2025-12-10 21:37:00","inspection_id":"86407259","dot_number":"2203949","report_state":"CT","report_number":"3017002113","insp_date":"2025-11-25 00:00:00","insp_start_time":"1412","insp_end_time":"1440","registration_date":"2025-12-10 00:00:00","region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","pen_cen_match":null,"final_status_date":"2025-11-25 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"758988","transaction_code":"C","transaction_date":"2025-11-25 00:00:00","upload_date":"2025-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2025-11-25 21:38:00","snet_input_date":"2025-11-25 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-11-25 21:38:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-28T10:31:44.000000Z","updated_at":"2025-12-14T10:30:03.000000Z","inspection_violations":[{"id":17409755,"change_date":"2025-12-10 21:37:00","inspection_id":"86407259","insp_violation_id":"270574611","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V137190-6","created_at":"2025-12-13T10:32:12.000000Z","updated_at":"2025-12-14T10:30:05.000000Z","normalized_code":"3922SLLS2"},{"id":17409756,"change_date":"2025-12-10 21:37:00","inspection_id":"86407259","insp_violation_id":"270574612","seq_no":"2","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V137190-6","created_at":"2025-12-13T10:32:12.000000Z","updated_at":"2025-12-14T10:30:05.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":17375845,"change_date":"2025-12-10 21:37:00","inspection_id":"86407259","insp_unit_id":"210514306","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"1543","insp_unit_license":"42777ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JT9J4S58473","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-13T10:01:41.000000Z","updated_at":"2025-12-14T10:00:04.000000Z"}]},{"id":9411503,"change_date":"2025-10-27 21:38:00","inspection_id":"85491488","dot_number":"2203949","report_state":"NY","report_number":"D012003786","insp_date":"2025-08-13 00:00:00","insp_start_time":"1150","insp_end_time":"1230","registration_date":"2025-10-27 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"OLD WESTBURY NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COMERCIAL MEXICANA INTERNACIONAL","shipping_paper_number":"185687","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2129948","transaction_code":"C","transaction_date":"2025-08-14 00:00:00","upload_date":"2025-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2025-08-14 21:40:00","snet_input_date":"2025-08-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-14 21:40:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-17T10:01:18.000000Z","updated_at":"2025-11-01T10:00:08.000000Z","inspection_violations":[{"id":16608865,"change_date":"2025-10-27 21:38:00","inspection_id":"85491488","insp_violation_id":"269531982","seq_no":"1","part_no":"391","part_no_section":"11B2-Q","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-10-30T10:15:36.000000Z","updated_at":"2025-10-31T10:15:12.000000Z","normalized_code":"39111B2Q"},{"id":16608866,"change_date":"2025-10-27 21:38:00","inspection_id":"85491488","insp_violation_id":"269531983","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"SRV2KNH8M6","created_at":"2025-10-30T10:15:36.000000Z","updated_at":"2025-10-31T10:15:12.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":16680428,"change_date":"2025-10-27 21:38:00","inspection_id":"85491488","insp_unit_id":"209668068","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"5","insp_unit_license":"62665MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV8L4S59932","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-30T09:45:35.000000Z","updated_at":"2025-10-31T09:45:07.000000Z"}]},{"id":12168548,"change_date":"2026-06-12 21:41:00","inspection_id":"88122953","dot_number":"2203949","report_state":"NY","report_number":"D012003787","insp_date":"2025-08-13 00:00:00","insp_start_time":"1301","insp_end_time":"1310","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"OLD WESTBURY NY","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COMERCIAL MEXICANA INTERNACIONAL","shipping_paper_number":"185687","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":"2026-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"3527192","transaction_code":"A","transaction_date":"2026-06-11 00:00:00","upload_date":"2026-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2026-06-12 21:41:00","snet_input_date":"2025-08-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-12 21:41:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-16T09:43:26.000000Z","updated_at":"2026-06-23T09:30:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21136982,"change_date":"2026-06-12 21:41:00","inspection_id":"88122953","insp_unit_id":"214063569","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"5","insp_unit_license":"62665MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV8L4S59932","insp_unit_decal":"Y","insp_unit_decal_number":"35490291","created_at":"2026-06-16T09:20:25.000000Z","updated_at":"2026-06-23T09:01:30.000000Z"}]},{"id":7990668,"change_date":"2025-02-28 21:41:00","inspection_id":"83993954","dot_number":"2203949","report_state":"NY","report_number":"0L10600035","insp_date":"2025-02-28 00:00:00","insp_start_time":"1136","insp_end_time":"1152","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"GARDEN CITY NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","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-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1413985","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2025-02-28 21:41:00","snet_input_date":"2025-02-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-28 21:41:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:05.000000Z","updated_at":"2025-03-17T21:04:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12900191,"change_date":"2025-02-28 21:41:00","inspection_id":"83993954","insp_unit_id":"205557934","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"24475NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA5RS074245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:31.000000Z","updated_at":"2025-03-17T23:57:31.000000Z"}]},{"id":7591857,"change_date":"2025-01-10 21:39:00","inspection_id":"83575239","dot_number":"2203949","report_state":"NJ","report_number":"SPPYI05114","insp_date":"2025-01-09 00:00:00","insp_start_time":"0853","insp_end_time":"0946","registration_date":null,"region":"ET","ci_status_code":"C","location":"1805","location_desc":"999 US 202","county_code_state":"NJ","county_code":"035","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"COMERCIAL MEXICANA INTERNACIONAL","shipping_paper_number":"167114","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-01-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1257172","transaction_code":"A","transaction_date":"2025-01-09 00:00:00","upload_date":"2025-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2025-01-10 21:39:00","snet_input_date":"2025-01-09 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-01-10 21:39:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:42.000000Z","updated_at":"2025-03-17T20:55:42.000000Z","inspection_violations":[{"id":11868386,"change_date":"2025-01-10 21:39:00","inspection_id":"83575239","insp_violation_id":"263860044","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"204745639","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"3939ALLPL"},{"id":11868387,"change_date":"2025-01-10 21:39:00","inspection_id":"83575239","insp_violation_id":"263860045","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWG2","insp_viol_unit":"1","insp_unit_id":"204745639","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1805E25000001","created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"3922SLLEWG2"},{"id":11868388,"change_date":"2025-01-10 21:39:00","inspection_id":"83575239","insp_violation_id":"263860046","seq_no":"3","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"204745639","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"3922SLLIRP"},{"id":11868389,"change_date":"2025-01-10 21:39:00","inspection_id":"83575239","insp_violation_id":"263860047","seq_no":"4","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"204745639","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"3922SLLIFTA"},{"id":11868390,"change_date":"2025-01-10 21:39:00","inspection_id":"83575239","insp_violation_id":"263860048","seq_no":"5","part_no":"391","part_no_section":"11B5-LNCDLNVE","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-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"39111B5LNCDLNVE"}],"inspection_per_units":[{"id":12249621,"change_date":"2025-01-10 21:39:00","inspection_id":"83575239","insp_unit_id":"204745639","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"8","insp_unit_license":"42660ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AV2R5T50479","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:11.000000Z","updated_at":"2025-03-17T23:50:11.000000Z"}]},{"id":7484534,"change_date":"2025-01-13 21:45:00","inspection_id":"83462596","dot_number":"2203949","report_state":"NY","report_number":"0L95001309","insp_date":"2024-12-23 00:00:00","insp_start_time":"0711","insp_end_time":"0811","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"HICKSVILLE NY","county_code_state":"NY","county_code":"059","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"166135-166228","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-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1188613","transaction_code":"C","transaction_date":"2024-12-23 00:00:00","upload_date":"2025-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2024-12-23 21:39:00","snet_input_date":"2024-12-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-23 21:39:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:18.000000Z","updated_at":"2025-03-17T20:52:18.000000Z","inspection_violations":[{"id":11700288,"change_date":"2025-01-13 21:45:00","inspection_id":"83462596","insp_violation_id":"263884972","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"204767912","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K070JTM0P5","created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"3939ALLPL"},{"id":11700289,"change_date":"2025-01-13 21:45:00","inspection_id":"83462596","insp_violation_id":"263884973","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"204767912","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K070JTM0RP","created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"3939ALSML"},{"id":11700290,"change_date":"2025-01-13 21:45:00","inspection_id":"83462596","insp_violation_id":"263884974","seq_no":"3","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"204767912","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K070JTLZWP","created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"3939ALCL"},{"id":11700291,"change_date":"2025-01-13 21:45:00","inspection_id":"83462596","insp_violation_id":"263884975","seq_no":"4","part_no":"391","part_no_section":"15A-LNCDLNSRW","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"K070JTM5F9","created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"39115ALNCDLNSRW"},{"id":11700292,"change_date":"2025-01-13 21:45:00","inspection_id":"83462596","insp_violation_id":"263884976","seq_no":"5","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"204767912","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K070JTLZR2","created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"39021TCMC"},{"id":11700293,"change_date":"2025-01-13 21:45:00","inspection_id":"83462596","insp_violation_id":"263884977","seq_no":"6","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"204767912","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K070JTLXB7","created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"3939AHLLH"},{"id":11700294,"change_date":"2025-01-13 21:45:00","inspection_id":"83462596","insp_violation_id":"263884978","seq_no":"7","part_no":"391","part_no_section":"41A-MCPC","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-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"39141AMCPC"},{"id":11700295,"change_date":"2025-01-13 21:45:00","inspection_id":"83462596","insp_violation_id":"263884979","seq_no":"8","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"204767912","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K070JTM03B","created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"3939ALIL"},{"id":11700296,"change_date":"2025-01-13 21:45:00","inspection_id":"83462596","insp_violation_id":"263884980","seq_no":"9","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"1","insp_unit_id":"204767912","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"K070JTM1R5","created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":12074740,"change_date":"2025-01-13 21:45:00","inspection_id":"83462596","insp_unit_id":"204767912","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4","insp_unit_license":"68649NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV8L5S59956","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:19.000000Z","updated_at":"2025-03-17T23:48:19.000000Z"}]},{"id":7317604,"change_date":"2024-12-02 21:39:00","inspection_id":"83287057","dot_number":"2203949","report_state":"NJ","report_number":"SPPYI05008","insp_date":"2024-11-29 00:00:00","insp_start_time":"0839","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":"1805","location_desc":"999 US 202","county_code_state":"NJ","county_code":"035","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"COMERCIAL MEXCANA INT INC","shipping_paper_number":"163908","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1249129","transaction_code":"A","transaction_date":"2024-11-29 00:00:00","upload_date":"2024-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2024-12-02 21:39:00","snet_input_date":"2024-11-29 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-12-02 21:39:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:37.000000Z","updated_at":"2025-03-17T20:48:37.000000Z","inspection_violations":[{"id":11439025,"change_date":"2024-12-02 21:39:00","inspection_id":"83287057","insp_violation_id":"263169665","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"204130749","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1805E24000021","created_at":"2025-03-17T22:01:35.000000Z","updated_at":"2025-03-17T22:01:35.000000Z","normalized_code":"3922SLLEWG3"},{"id":11439026,"change_date":"2024-12-02 21:39:00","inspection_id":"83287057","insp_violation_id":"263169666","seq_no":"2","part_no":"391","part_no_section":"11B5-LNCDLNVE","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-03-17T22:01:35.000000Z","updated_at":"2025-03-17T22:01:35.000000Z","normalized_code":"39111B5LNCDLNVE"},{"id":11439027,"change_date":"2024-12-02 21:39:00","inspection_id":"83287057","insp_violation_id":"263169667","seq_no":"3","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"204130749","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:35.000000Z","updated_at":"2025-03-17T22:01:35.000000Z","normalized_code":"3922SLLIRP"},{"id":11439028,"change_date":"2024-12-02 21:39:00","inspection_id":"83287057","insp_violation_id":"263169668","seq_no":"4","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"204130749","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:35.000000Z","updated_at":"2025-03-17T22:01:35.000000Z","normalized_code":"3922SLLIFTA"},{"id":11439029,"change_date":"2024-12-02 21:39:00","inspection_id":"83287057","insp_violation_id":"263169669","seq_no":"5","part_no":"393","part_no_section":"60E","insp_viol_unit":"1","insp_unit_id":"204130749","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:35.000000Z","updated_at":"2025-03-17T22:01:35.000000Z","normalized_code":"39360E"}],"inspection_per_units":[{"id":11804208,"change_date":"2024-12-02 21:39:00","inspection_id":"83287057","insp_unit_id":"204130749","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"8 \/ 1104","insp_unit_license":"42660ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AV2R5T50479","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:20.000000Z","updated_at":"2025-03-17T23:45:20.000000Z"}]},{"id":7273167,"change_date":"2024-11-25 21:43:00","inspection_id":"83240117","dot_number":"2203949","report_state":"NY","report_number":"D012101495","insp_date":"2024-11-25 00:00:00","insp_start_time":"1301","insp_end_time":"1318","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"GLEN COVE NY","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","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":"2024-11-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1092202","transaction_code":"A","transaction_date":"2024-11-25 00:00:00","upload_date":"2024-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2024-11-25 21:43:00","snet_input_date":"2024-11-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-25 21:43:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:44.000000Z","updated_at":"2025-03-17T20:47:44.000000Z","inspection_violations":[{"id":11369464,"change_date":"2024-11-25 21:43:00","inspection_id":"83240117","insp_violation_id":"263072888","seq_no":"1","part_no":"393","part_no_section":"75B-TFV","insp_viol_unit":"1","insp_unit_id":"204041089","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040BD4G9","created_at":"2025-03-17T22:01:13.000000Z","updated_at":"2025-03-17T22:01:13.000000Z","normalized_code":"39375BTFV"},{"id":11369465,"change_date":"2024-11-25 21:43:00","inspection_id":"83240117","insp_violation_id":"263072889","seq_no":"2","part_no":"396","part_no_section":"3A1-ALBV","insp_viol_unit":"1","insp_unit_id":"204041089","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040BD5G9","created_at":"2025-03-17T22:01:13.000000Z","updated_at":"2025-03-17T22:01:13.000000Z","normalized_code":"3963A1ALBV"}],"inspection_per_units":[{"id":11731710,"change_date":"2024-11-25 21:43:00","inspection_id":"83240117","insp_unit_id":"204041089","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"28827ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWDT1GHGV5032","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:35.000000Z","updated_at":"2025-03-17T23:44:35.000000Z"}]},{"id":6841307,"change_date":"2024-09-28 21:33:00","inspection_id":"82782146","dot_number":"2203949","report_state":"CT","report_number":"3063006754","insp_date":"2024-09-26 00:00:00","insp_start_time":"0800","insp_end_time":"0917","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"COMERCIAL MEXICANA INTERNACIONAL INC","shipping_paper_number":"158246","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-28 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"6","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"719201","transaction_code":"A","transaction_date":"2024-09-27 00:00:00","upload_date":"2024-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2024-09-28 21:33:00","snet_input_date":"2024-09-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-09-28 21:33:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:57.000000Z","updated_at":"2025-03-17T20:38:57.000000Z","inspection_violations":[{"id":10656418,"change_date":"2024-09-28 21:33:00","inspection_id":"82782146","insp_violation_id":"262082089","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203172975","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:35.000000Z","updated_at":"2025-03-17T21:57:35.000000Z","normalized_code":"3922"},{"id":10656419,"change_date":"2024-09-28 21:33:00","inspection_id":"82782146","insp_violation_id":"262082090","seq_no":"5","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:35.000000Z","updated_at":"2025-03-17T21:57:35.000000Z","normalized_code":"38323A2"},{"id":10656420,"change_date":"2024-09-28 21:33:00","inspection_id":"82782146","insp_violation_id":"262082091","seq_no":"6","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"V130102-2","created_at":"2025-03-17T21:57:35.000000Z","updated_at":"2025-03-17T21:57:35.000000Z","normalized_code":"39141A1"},{"id":10656421,"change_date":"2024-09-28 21:33:00","inspection_id":"82782146","insp_violation_id":"262082092","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203172975","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V130100-0","created_at":"2025-03-17T21:57:35.000000Z","updated_at":"2025-03-17T21:57:35.000000Z","normalized_code":"3922"},{"id":10656422,"change_date":"2024-09-28 21:33:00","inspection_id":"82782146","insp_violation_id":"262082093","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203172975","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:35.000000Z","updated_at":"2025-03-17T21:57:35.000000Z","normalized_code":"3922"},{"id":10656423,"change_date":"2024-09-28 21:33:00","inspection_id":"82782146","insp_violation_id":"262082094","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203172975","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:35.000000Z","updated_at":"2025-03-17T21:57:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11032629,"change_date":"2024-09-28 21:33:00","inspection_id":"82782146","insp_unit_id":"203172975","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9","insp_unit_license":"24475NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA5RS074245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:15.000000Z","updated_at":"2025-03-17T23:37:15.000000Z"}]},{"id":6822130,"change_date":"2024-09-26 21:39:00","inspection_id":"82761833","dot_number":"2203949","report_state":"NY","report_number":"SPB3020167","insp_date":"2024-09-19 00:00:00","insp_start_time":"1236","insp_end_time":"1252","registration_date":null,"region":"ED","ci_status_code":"C","location":"80057M","location_desc":"BEDFORD NY","county_code_state":"NY","county_code":"119","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"886332","transaction_code":"A","transaction_date":"2024-09-26 00:00:00","upload_date":"2024-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2024-09-26 21:39:00","snet_input_date":"2024-09-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-26 21:39:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:33.000000Z","updated_at":"2025-03-17T20:38:33.000000Z","inspection_violations":[{"id":10625129,"change_date":"2024-09-26 21:39:00","inspection_id":"82761833","insp_violation_id":"262040741","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203135482","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11001413,"change_date":"2024-09-26 21:39:00","inspection_id":"82761833","insp_unit_id":"203135482","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"24488NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA3RS074244","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:57.000000Z","updated_at":"2025-03-17T23:36:57.000000Z"}]},{"id":6455047,"change_date":"2024-08-13 21:42:00","inspection_id":"82370708","dot_number":"2203949","report_state":"NY","report_number":"SPK0136613","insp_date":"2024-08-10 00:00:00","insp_start_time":"1110","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":"80018","location_desc":"AMENIA","county_code_state":"NY","county_code":"027","insp_level_id":"3","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2024-08-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2944357","transaction_code":"A","transaction_date":"2024-08-13 00:00:00","upload_date":"2024-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":"M","census_search_date":"2024-08-13 21:42:00","snet_input_date":"2024-08-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-08-13 21:42:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:43.000000Z","updated_at":"2025-03-17T20:30:43.000000Z","inspection_violations":[{"id":10024674,"change_date":"2024-08-13 21:42:00","inspection_id":"82370708","insp_violation_id":"261162756","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202365902","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:31.000000Z","updated_at":"2025-03-17T21:54:31.000000Z","normalized_code":"3922"},{"id":10024675,"change_date":"2024-08-13 21:42:00","inspection_id":"82370708","insp_violation_id":"261162757","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"202365902","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:31.000000Z","updated_at":"2025-03-17T21:54:31.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":10404285,"change_date":"2024-08-13 21:42:00","inspection_id":"82370708","insp_unit_id":"202365902","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"8","insp_unit_license":"42660ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AV2R5T50479","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:48.000000Z","updated_at":"2025-03-17T23:30:48.000000Z"}]},{"id":6383674,"change_date":"2024-08-05 21:41:00","inspection_id":"82294371","dot_number":"2203949","report_state":"CT","report_number":"1229001284","insp_date":"2024-08-03 00:00:00","insp_start_time":"1021","insp_end_time":"1034","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"714450","transaction_code":"A","transaction_date":"2024-08-03 00:00:00","upload_date":"2024-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2024-08-05 21:41:00","snet_input_date":"2024-08-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-08-05 21:41:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:28.000000Z","updated_at":"2025-03-17T20:29:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10287509,"change_date":"2024-08-05 21:41:00","inspection_id":"82294371","insp_unit_id":"202221151","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"42660ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AV2R5T50479","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:33.000000Z","updated_at":"2025-03-17T23:29:33.000000Z"}]},{"id":6030894,"change_date":"2024-06-20 21:42:00","inspection_id":"81915697","dot_number":"2203949","report_state":"CT","report_number":"3070006054","insp_date":"2024-06-20 00:00:00","insp_start_time":"0644","insp_end_time":"0706","registration_date":null,"region":"ET","ci_status_code":"C","location":"057S","location_desc":"GREENWICH SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"150232","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"710408","transaction_code":"A","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2024-06-20 21:42:00","snet_input_date":"2024-06-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-06-20 21:42:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:15.000000Z","updated_at":"2025-03-17T20:22:15.000000Z","inspection_violations":[{"id":9356091,"change_date":"2024-06-20 21:42:00","inspection_id":"81915697","insp_violation_id":"260198088","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:15.000000Z","updated_at":"2025-03-17T21:51:15.000000Z","normalized_code":"38323A2"},{"id":9356092,"change_date":"2024-06-20 21:42:00","inspection_id":"81915697","insp_violation_id":"260198089","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201493575","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V128382-4","created_at":"2025-03-17T21:51:15.000000Z","updated_at":"2025-03-17T21:51:15.000000Z","normalized_code":"3922"},{"id":9356093,"change_date":"2024-06-20 21:42:00","inspection_id":"81915697","insp_violation_id":"260198090","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"201493575","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:15.000000Z","updated_at":"2025-03-17T21:51:15.000000Z","normalized_code":"39395F"},{"id":9356094,"change_date":"2024-06-20 21:42:00","inspection_id":"81915697","insp_violation_id":"260198091","seq_no":"4","part_no":"393","part_no_section":"61","insp_viol_unit":"1","insp_unit_id":"201493575","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:15.000000Z","updated_at":"2025-03-17T21:51:15.000000Z","normalized_code":"39361"},{"id":9356095,"change_date":"2024-06-20 21:42:00","inspection_id":"81915697","insp_violation_id":"260198092","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201493575","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:15.000000Z","updated_at":"2025-03-17T21:51:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9713554,"change_date":"2024-06-20 21:42:00","inspection_id":"81915697","insp_unit_id":"201493575","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"10136","insp_unit_license":"56428NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAAXRS073978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:39.000000Z","updated_at":"2025-03-17T23:23:39.000000Z"}]},{"id":4596632,"change_date":"2023-12-11 21:40:00","inspection_id":"80352137","dot_number":"2203949","report_state":"NY","report_number":"N628600003","insp_date":"2023-12-08 00:00:00","insp_start_time":"1531","insp_end_time":"1554","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BRONX NY","county_code_state":"NY","county_code":"005","insp_level_id":"2","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2023-12-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"125943","transaction_code":"A","transaction_date":"2023-12-11 00:00:00","upload_date":"2023-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2023-12-11 21:40:00","snet_input_date":"2023-12-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-11 21:40:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:49.000000Z","updated_at":"2025-03-17T19:53:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7393285,"change_date":"2023-12-11 21:40:00","inspection_id":"80352137","insp_unit_id":"198434207","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"24475NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA5RS074245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:08.000000Z","updated_at":"2025-03-17T23:02:08.000000Z"}]},{"id":4531911,"change_date":"2023-12-01 21:41:00","inspection_id":"80280967","dot_number":"2203949","report_state":"NY","report_number":"0L97000079","insp_date":"2023-11-29 00:00:00","insp_start_time":"1038","insp_end_time":"1057","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WOODBURY NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","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":"2023-12-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"112339","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2023-12-01 21:41:00","snet_input_date":"2023-11-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-01 21:41:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:35.000000Z","updated_at":"2025-03-17T19:52:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7288665,"change_date":"2023-12-01 21:41:00","inspection_id":"80280967","insp_unit_id":"198292961","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"7","insp_unit_license":"33147ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWDTXEHFV2446","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:13.000000Z","updated_at":"2025-03-17T23:01:13.000000Z"}]},{"id":4337948,"change_date":"2023-11-02 21:41:00","inspection_id":"80067045","dot_number":"2203949","report_state":"CT","report_number":"1162001841","insp_date":"2023-11-02 00:00:00","insp_start_time":"1016","insp_end_time":"1029","registration_date":null,"region":"ET","ci_status_code":"C","location":"015","location_desc":"RIGHT SHOULDER, SOUTH OF X25","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LA PLACITA","shipping_paper_number":"131883","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":"2023-11-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"690529","transaction_code":"A","transaction_date":"2023-11-02 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2023-11-02 21:41:00","snet_input_date":"2023-11-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-11-02 21:41:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:46.000000Z","updated_at":"2025-03-17T19:48:46.000000Z","inspection_violations":[{"id":6710567,"change_date":"2023-11-02 21:41:00","inspection_id":"80067045","insp_violation_id":"256177697","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6976587,"change_date":"2023-11-02 21:41:00","inspection_id":"80067045","insp_unit_id":"197868795","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"19348NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWFC6NHNC8893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:34.000000Z","updated_at":"2025-03-17T22:58:34.000000Z"}]},{"id":4269375,"change_date":"2023-10-24 21:39:00","inspection_id":"79991266","dot_number":"2203949","report_state":"NY","report_number":"SPL0078631","insp_date":"2023-10-03 00:00:00","insp_start_time":"1245","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":"L1050","location_desc":"MERRICK","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COMERCIAL MEXICANA INTERNACIONAL INC","shipping_paper_number":"129572","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-10-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2881833","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":"M","census_search_date":"2023-10-24 21:39:00","snet_input_date":"2023-10-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-24 21:39:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:27.000000Z","updated_at":"2025-03-17T19:47:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6866046,"change_date":"2023-10-24 21:39:00","inspection_id":"79991266","insp_unit_id":"197713452","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"5","insp_unit_license":"62665MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV8L4S59932","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:34.000000Z","updated_at":"2025-03-17T22:57:34.000000Z"}]},{"id":4008690,"change_date":"2023-09-20 21:39:00","inspection_id":"79702347","dot_number":"2203949","report_state":"CT","report_number":"3067003013","insp_date":"2023-09-20 00:00:00","insp_start_time":"0656","insp_end_time":"0711","registration_date":null,"region":"ET","ci_status_code":"C","location":"051","location_desc":"FAIRFIELD","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"686473","transaction_code":"A","transaction_date":"2023-09-20 00:00:00","upload_date":"2023-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2023-09-20 21:39:00","snet_input_date":"2023-09-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-09-20 21:39:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:01.000000Z","updated_at":"2025-03-17T19:42:01.000000Z","inspection_violations":[{"id":6203186,"change_date":"2023-09-20 21:39:00","inspection_id":"79702347","insp_violation_id":"255362946","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","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-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":6446056,"change_date":"2023-09-20 21:39:00","inspection_id":"79702347","insp_unit_id":"197134784","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"62665MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV8L4S59932","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:07.000000Z","updated_at":"2025-03-17T22:54:07.000000Z"}]},{"id":3762170,"change_date":"2023-08-17 21:42:00","inspection_id":"79427433","dot_number":"2203949","report_state":"NY","report_number":"1106015784","insp_date":"2023-08-15 00:00:00","insp_start_time":"1100","insp_end_time":"1116","registration_date":null,"region":"ET","ci_status_code":"C","location":"X2034","location_desc":"THROGS NECK BRIDGE (SB)","county_code_state":"NY","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2023-08-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2859488","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":"M","census_search_date":"2023-08-17 21:42:00","snet_input_date":"2023-08-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-17 21:42:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:15.000000Z","updated_at":"2025-03-17T19:37:15.000000Z","inspection_violations":[{"id":5802162,"change_date":"2023-08-17 21:42:00","inspection_id":"79427433","insp_violation_id":"254701444","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"196573621","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:55.000000Z","updated_at":"2025-03-17T21:33:55.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":6049181,"change_date":"2023-08-17 21:42:00","inspection_id":"79427433","insp_unit_id":"196573621","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"68649NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV8L5S59956","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:50.000000Z","updated_at":"2025-03-17T22:50:50.000000Z"}]},{"id":3762298,"change_date":"2023-08-17 21:42:00","inspection_id":"79427565","dot_number":"2203949","report_state":"NY","report_number":"SPC0192457","insp_date":"2023-08-15 00:00:00","insp_start_time":"0722","insp_end_time":"0813","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096","location_desc":"YAPHANK (EB) ROADSIDE","county_code_state":"NY","county_code":"103","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COMERCIAL MEXICANA INTERNACIONAL INC","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2859188","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":"M","census_search_date":"2023-08-17 21:42:00","snet_input_date":"2023-08-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-17 21:42:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:15.000000Z","updated_at":"2025-03-17T19:37:15.000000Z","inspection_violations":[{"id":5802498,"change_date":"2023-08-17 21:42:00","inspection_id":"79427565","insp_violation_id":"254701819","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:55.000000Z","updated_at":"2025-03-17T21:33:55.000000Z","normalized_code":"3922"},{"id":5802499,"change_date":"2023-08-17 21:42:00","inspection_id":"79427565","insp_violation_id":"254701820","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:55.000000Z","updated_at":"2025-03-17T21:33:55.000000Z","normalized_code":"38323A2"},{"id":5802500,"change_date":"2023-08-17 21:42:00","inspection_id":"79427565","insp_violation_id":"254701821","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0H2PTH8","created_at":"2025-03-17T21:33:55.000000Z","updated_at":"2025-03-17T21:33:55.000000Z","normalized_code":"3922"},{"id":5802501,"change_date":"2023-08-17 21:42:00","inspection_id":"79427565","insp_violation_id":"254701822","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196573815","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0H2PV01","created_at":"2025-03-17T21:33:55.000000Z","updated_at":"2025-03-17T21:33:55.000000Z","normalized_code":"3922"},{"id":5802502,"change_date":"2023-08-17 21:42:00","inspection_id":"79427565","insp_violation_id":"254701823","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196573815","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:55.000000Z","updated_at":"2025-03-17T21:33:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6049355,"change_date":"2023-08-17 21:42:00","inspection_id":"79427565","insp_unit_id":"196573815","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"19348NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWFC6NHNC8893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:50.000000Z","updated_at":"2025-03-17T22:50:50.000000Z"}]},{"id":3484442,"change_date":"2023-07-12 21:40:00","inspection_id":"79116804","dot_number":"2203949","report_state":"NY","report_number":"0L79000526","insp_date":"2023-07-11 00:00:00","insp_start_time":"1452","insp_end_time":"1502","registration_date":null,"region":"ET","ci_status_code":"C","location":"3052","location_desc":"135 N\/B FROM SUNRISE","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2023-07-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2845636","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2023-07-12 21:40:00","snet_input_date":"2023-07-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-12 21:40:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:03.000000Z","updated_at":"2025-03-17T19:32:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5603054,"change_date":"2023-07-12 21:40:00","inspection_id":"79116804","insp_unit_id":"195947008","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"33147ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWDTXEHFV2446","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:13.000000Z","updated_at":"2025-03-17T22:47:13.000000Z"}]},{"id":3340071,"change_date":"2023-06-22 21:41:00","inspection_id":"78954361","dot_number":"2203949","report_state":"NY","report_number":"SPA0275357","insp_date":"2023-06-13 00:00:00","insp_start_time":"0620","insp_end_time":"0643","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2023-06-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2839507","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":"M","census_search_date":"2023-06-22 21:41:00","snet_input_date":"2023-06-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-22 21:41:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:18.000000Z","updated_at":"2025-03-17T19:29:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5369519,"change_date":"2023-06-22 21:41:00","inspection_id":"78954361","insp_unit_id":"195617898","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"81495MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV3J4S69566","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:21.000000Z","updated_at":"2025-03-17T22:45:21.000000Z"}]},{"id":3227136,"change_date":"2023-06-07 21:41:00","inspection_id":"78826912","dot_number":"2203949","report_state":"NY","report_number":"1020001714","insp_date":"2023-06-06 00:00:00","insp_start_time":"1131","insp_end_time":"1152","registration_date":null,"region":"ET","ci_status_code":"C","location":"00780","location_desc":"COMMACK SCPD INSPECTION SITE","county_code_state":"NY","county_code":"103","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","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":"I","final_status_date":"2023-06-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2834334","transaction_code":"A","transaction_date":"2023-06-06 00:00:00","upload_date":"2023-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2023-06-07 21:41:00","snet_input_date":"2023-06-07 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-07 21:41:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:53.000000Z","updated_at":"2025-03-17T19:26:53.000000Z","inspection_violations":[{"id":4974457,"change_date":"2023-06-07 21:41:00","inspection_id":"78826912","insp_violation_id":"253347071","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195364065","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:08.000000Z","updated_at":"2025-03-17T21:30:08.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":5189848,"change_date":"2023-06-07 21:41:00","inspection_id":"78826912","insp_unit_id":"195364065","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1103","insp_unit_license":"28827ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWDT1GHGV5032","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:52.000000Z","updated_at":"2025-03-17T22:43:52.000000Z"}]},{"id":902755,"change_date":"2022-07-27 21:40:00","inspection_id":"76163396","dot_number":"2203949","report_state":"NY","report_number":"SPWK031221","insp_date":"2022-07-26 00:00:00","insp_start_time":"1124","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789A","location_desc":"SOUTHEAST (NB)","county_code_state":"NY","county_code":"079","insp_level_id":"3","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2022-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2731512","transaction_code":"A","transaction_date":"2022-07-27 00:00:00","upload_date":"2022-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":"M","census_search_date":"2022-07-27 21:40:00","snet_input_date":"2022-07-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-27 21:40:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:40.000000Z","updated_at":"2025-03-17T18:43:40.000000Z","inspection_violations":[{"id":1424474,"change_date":"2022-07-27 21:40:00","inspection_id":"76163396","insp_violation_id":"247341296","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:45.000000Z","updated_at":"2025-03-17T21:13:45.000000Z","normalized_code":"3922"},{"id":1424475,"change_date":"2022-07-27 21:40:00","inspection_id":"76163396","insp_violation_id":"247341297","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189986713","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:45.000000Z","updated_at":"2025-03-17T21:13:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1453015,"change_date":"2022-07-27 21:40:00","inspection_id":"76163396","insp_unit_id":"189986713","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"19348NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWFC6NHNC8893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:08.000000Z","updated_at":"2025-03-17T22:17:08.000000Z"}]},{"id":600816,"change_date":"2022-06-14 21:41:00","inspection_id":"75809297","dot_number":"2203949","report_state":"CT","report_number":"3090002643","insp_date":"2022-06-14 00:00:00","insp_start_time":"0740","insp_end_time":"0824","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"100873","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"646366","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02203949","upload_search_indicator":null,"census_search_date":"2022-06-14 21:41:00","snet_input_date":"2022-06-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-06-14 21:41:00","insp_carrier_name":"COMERCIAL MEXICANA INTERNACIONAL INC","insp_carrier_street":"999 S OYSTER BAY RD","insp_carrier_city":"BETHPAGE","insp_carrier_state":"NY","insp_carrier_zip_code":"11714","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:24.000000Z","updated_at":"2025-03-17T18:38:24.000000Z","inspection_violations":[{"id":944251,"change_date":"2022-06-14 21:41:00","inspection_id":"75809297","insp_violation_id":"246435662","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:26.000000Z","updated_at":"2025-03-17T21:11:26.000000Z","normalized_code":"39141A"},{"id":944252,"change_date":"2022-06-14 21:41:00","inspection_id":"75809297","insp_violation_id":"246435663","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189225052","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y989388 6","created_at":"2025-03-17T21:11:26.000000Z","updated_at":"2025-03-17T21:11:26.000000Z","normalized_code":"3922"},{"id":944253,"change_date":"2022-06-14 21:41:00","inspection_id":"75809297","insp_violation_id":"246435664","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189225052","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:26.000000Z","updated_at":"2025-03-17T21:11:26.000000Z","normalized_code":"3922"},{"id":944254,"change_date":"2022-06-14 21:41:00","inspection_id":"75809297","insp_violation_id":"246435665","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189225052","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y989388 6","created_at":"2025-03-17T21:11:26.000000Z","updated_at":"2025-03-17T21:11:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":965866,"change_date":"2022-06-14 21:41:00","inspection_id":"75809297","insp_unit_id":"189225052","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"19348NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWFC6NHNC8893","insp_unit_decal":"Y","insp_unit_decal_number":"31374951","created_at":"2025-03-17T22:14:09.000000Z","updated_at":"2025-03-17T22:14:09.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2203949\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2203949\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2203949\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/2203949\/inspections","per_page":100,"prev_page_url":null,"to":27,"total":27}