{"current_page":1,"data":[{"id":7331883,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","dot_number":"641617","report_state":"CT","report_number":"3064001369","insp_date":"2024-12-04 00:00:00","insp_start_time":"1019","insp_end_time":"1137","registration_date":"2025-01-30 00:00:00","region":"ET","ci_status_code":"C","location":"081","location_desc":"MIDDLEBURY","county_code_state":"CT","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"J P GUERRA 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":"N","pen_cen_match":null,"final_status_date":"2024-12-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"34950","viol_total":"23","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"21","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"725642","transaction_code":"C","transaction_date":"2024-12-04 00:00:00","upload_date":"2025-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00641617","upload_search_indicator":null,"census_search_date":"2024-12-04 21:40:00","snet_input_date":"2024-12-04 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-12-04 21:40:00","insp_carrier_name":"J P GUERRA LLC","insp_carrier_street":"61 ELM STREET","insp_carrier_city":"MONROE","insp_carrier_state":"CT","insp_carrier_zip_code":"06468","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:59.000000Z","updated_at":"2025-03-17T20:48:59.000000Z","inspection_violations":[{"id":11464891,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245038","seq_no":"1","part_no":"392","part_no_section":"7A-D","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-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"3927AD"},{"id":11464892,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245039","seq_no":"2","part_no":"397","part_no_section":"17A-HMDP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"39717AHMDP"},{"id":11464893,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245040","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205071503","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"3922SLLSR"},{"id":11464894,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245041","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205071503","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"3922SLLSR"},{"id":11464895,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245042","seq_no":"5","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"205071503","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"39617CPI"},{"id":11464896,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245043","seq_no":"6","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"205071503","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"39021TB1MC"},{"id":11464897,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245044","seq_no":"7","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"205071503","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"39021TB2DOT"},{"id":11464898,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245045","seq_no":"8","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"205071503","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"3939ALIL"},{"id":11464899,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245046","seq_no":"9","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"205071503","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"3939ALCL"},{"id":11464900,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245047","seq_no":"10","part_no":"393","part_no_section":"9A-LPL","insp_viol_unit":"1","insp_unit_id":"205071503","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"3939ALPL"},{"id":11464901,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245048","seq_no":"11","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"1","insp_unit_id":"205071503","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"39311A1LRR"},{"id":11464902,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245049","seq_no":"12","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"1","insp_unit_id":"205071503","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"39311A1LRR"},{"id":11464903,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245050","seq_no":"13","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"205071503","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"3939ALRLI"},{"id":11464904,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245051","seq_no":"14","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"205071503","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"3939ALTSIR"},{"id":11464905,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245052","seq_no":"15","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"205071503","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"3939ALSLI"},{"id":11464906,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245053","seq_no":"16","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"205071503","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"3939ALBL"},{"id":11464907,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245054","seq_no":"17","part_no":"393","part_no_section":"205C-WRAWFLMIB","insp_viol_unit":"1","insp_unit_id":"205071503","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"393205CWRAWFLMIB"},{"id":11464908,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245055","seq_no":"18","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"205071504","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"3922SLLSR"},{"id":11464909,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245056","seq_no":"19","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"205071504","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"39617CPI"},{"id":11464910,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245057","seq_no":"20","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"205071504","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"3939ALLPL"},{"id":11464911,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245058","seq_no":"21","part_no":"393","part_no_section":"11A1-LSML","insp_viol_unit":"2","insp_unit_id":"205071504","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"39311A1LSML"},{"id":11464912,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245059","seq_no":"22","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"205071504","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"3939ALIL"},{"id":11464913,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_violation_id":"264245060","seq_no":"23","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"205071504","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V131285-2","created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"39343DB"}],"inspection_per_units":[{"id":11827550,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_unit_id":"205071503","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"AE28170","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDAX57R28ED39533","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:36.000000Z","updated_at":"2025-03-17T23:45:36.000000Z"},{"id":11827551,"change_date":"2025-01-30 21:40:00","inspection_id":"83302075","insp_unit_id":"205071504","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ST","insp_unit_company":null,"insp_unit_license":"AE47242","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5VGFD2227HL001148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:36.000000Z","updated_at":"2025-03-17T23:45:36.000000Z"}]},{"id":3959471,"change_date":"2023-09-15 21:39:00","inspection_id":"79647778","dot_number":"641617","report_state":"CT","report_number":"3070005167","insp_date":"2023-09-13 00:00:00","insp_start_time":"1005","insp_end_time":"1040","registration_date":"2023-09-15 00:00:00","region":"ET","ci_status_code":"C","location":"144","location_desc":"TRUMBULL","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0","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-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"72500","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"685895","transaction_code":"C","transaction_date":"2023-09-13 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00641617","upload_search_indicator":null,"census_search_date":"2023-09-13 21:40:00","snet_input_date":"2023-09-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-09-13 21:40:00","insp_carrier_name":"J P GUERRA LLC","insp_carrier_street":"61 ELM STREET","insp_carrier_city":"MONROE","insp_carrier_state":"CT","insp_carrier_zip_code":"06468","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:52.000000Z","updated_at":"2025-03-17T19:40:52.000000Z","inspection_violations":[{"id":6123261,"change_date":"2023-09-15 21:39:00","inspection_id":"79647778","insp_violation_id":"255284785","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197069941","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:37.000000Z","updated_at":"2025-03-17T21:35:37.000000Z","normalized_code":"3939A"},{"id":6123262,"change_date":"2023-09-15 21:39:00","inspection_id":"79647778","insp_violation_id":"255284786","seq_no":"2","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"197069941","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:37.000000Z","updated_at":"2025-03-17T21:35:37.000000Z","normalized_code":"39355D1"},{"id":6123263,"change_date":"2023-09-15 21:39:00","inspection_id":"79647778","insp_violation_id":"255284787","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197069941","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:37.000000Z","updated_at":"2025-03-17T21:35:37.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6366714,"change_date":"2023-09-15 21:39:00","inspection_id":"79647778","insp_unit_id":"197069941","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"AU37217","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTGRSJT3CJ093493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:29.000000Z","updated_at":"2025-03-17T22:53:29.000000Z"}]},{"id":141777,"change_date":"2022-05-17 21:42:00","inspection_id":"75261912","dot_number":"641617","report_state":"CT","report_number":"3029000683","insp_date":"2022-04-08 00:00:00","insp_start_time":"1628","insp_end_time":"1706","registration_date":"2022-05-13 00:00:00","region":"ET","ci_status_code":"C","location":"144","location_desc":"TRUMBULL","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JP GUERRA 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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"72500","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":"641826","transaction_code":"C","transaction_date":"2022-04-27 00:00:00","upload_date":"2022-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00641617","upload_search_indicator":null,"census_search_date":"2022-04-11 21:40:00","snet_input_date":"2022-04-08 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-04-11 21:40:00","insp_carrier_name":"J P GUERRA LLC","insp_carrier_street":"61 ELM STREET","insp_carrier_city":"MONROE","insp_carrier_state":"CT","insp_carrier_zip_code":"06468","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:07.000000Z","updated_at":"2025-03-17T18:30:07.000000Z","inspection_violations":[{"id":209689,"change_date":"2022-05-17 21:42:00","inspection_id":"75261912","insp_violation_id":"245824049","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39216A"},{"id":209690,"change_date":"2022-05-17 21:42:00","inspection_id":"75261912","insp_violation_id":"245824050","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"188714009","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39617C"},{"id":209691,"change_date":"2022-05-17 21:42:00","inspection_id":"75261912","insp_violation_id":"245824051","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188714009","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y988230-3","created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"3922"},{"id":209692,"change_date":"2022-05-17 21:42:00","inspection_id":"75261912","insp_violation_id":"245824052","seq_no":"4","part_no":"393","part_no_section":"95(g)","insp_viol_unit":"1","insp_unit_id":"188714009","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39395G"}],"inspection_per_units":[{"id":229466,"change_date":"2022-05-17 21:42:00","inspection_id":"75261912","insp_unit_id":"188714009","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTER","insp_unit_company":null,"insp_unit_license":"AU37217","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTGRSJT3CJ093493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:35.000000Z","updated_at":"2025-03-17T22:09:35.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/641617\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/641617\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/641617\/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\/641617\/inspections","per_page":100,"prev_page_url":null,"to":3,"total":3}