{"current_page":1,"data":[{"id":12697330,"change_date":"2026-08-12 21:42:00","inspection_id":"88671709","dot_number":"1111734","report_state":"NY","report_number":"SPB3031659","insp_date":"2026-08-05 00:00:00","insp_start_time":"1547","insp_end_time":"1558","registration_date":null,"region":"ED","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN NY","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"KIMPEX INC","shipping_paper_number":"CBL-000006695","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-08-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"3960246","transaction_code":"A","transaction_date":"2026-08-11 00:00:00","upload_date":"2026-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":null,"census_search_date":"2026-08-12 21:42:00","snet_input_date":"2026-08-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-12 21:42:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"QC","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-15T09:41:19.000000Z","updated_at":"2026-08-23T09:30:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":22036780,"change_date":"2026-08-12 21:42:00","inspection_id":"88671709","insp_unit_id":"215103059","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"2024","insp_unit_license":"LE21162","insp_unit_license_state":"QC","insp_unit_vehicle_id_number":"JALE5W161R7307595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-15T09:17:16.000000Z","updated_at":"2026-08-23T09:01:17.000000Z"}]},{"id":12024137,"change_date":"2026-05-27 21:39:00","inspection_id":"87963871","dot_number":"1111734","report_state":"NY","report_number":"SPB3111411","insp_date":"2026-05-20 00:00:00","insp_start_time":"1610","insp_end_time":"1626","registration_date":null,"region":"ED","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN NY","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"KIMPEX","shipping_paper_number":"905","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-05-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"3406778","transaction_code":"A","transaction_date":"2026-05-26 00:00:00","upload_date":"2026-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":null,"census_search_date":"2026-05-27 21:39:00","snet_input_date":"2026-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-27 21:39:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"QC","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-30T09:39:26.000000Z","updated_at":"2026-06-07T09:30:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20900677,"change_date":"2026-05-27 21:39:00","inspection_id":"87963871","insp_unit_id":"213765692","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"2024","insp_unit_license":"LE21162","insp_unit_license_state":"QC","insp_unit_vehicle_id_number":"JALE5W161R7307595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:26.000000Z","updated_at":"2026-06-07T09:01:35.000000Z"}]},{"id":11054374,"change_date":"2026-02-12 21:39:00","inspection_id":"86964594","dot_number":"1111734","report_state":"NY","report_number":"D700301444","insp_date":"2026-02-04 00:00:00","insp_start_time":"0838","insp_end_time":"0909","registration_date":"2026-02-11 00:00:00","region":"ES","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN NY","county_code_state":"NY","county_code":"019","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ABZAC CANADA INC","shipping_paper_number":"091905","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-02-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"126673","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":"2849336","transaction_code":"C","transaction_date":"2026-02-05 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":null,"census_search_date":"2026-02-05 21:38:00","snet_input_date":"2026-02-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-05 21:38:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"QC","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-08T10:37:18.000000Z","updated_at":"2026-02-23T10:30:03.000000Z","inspection_violations":[{"id":18605959,"change_date":"2026-02-12 21:39:00","inspection_id":"86964594","insp_violation_id":"271745363","seq_no":"1","part_no":"393","part_no_section":"55D2-B","insp_viol_unit":"1","insp_unit_id":"211575621","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:54:50.000000Z","updated_at":"2026-02-23T10:38:01.000000Z","normalized_code":"39355D2B"}],"inspection_per_units":[{"id":18947737,"change_date":"2026-02-12 21:39:00","inspection_id":"86964594","insp_unit_id":"211575621","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"26000","insp_unit_license":"LE59568","insp_unit_license_state":"QC","insp_unit_vehicle_id_number":"3AKJHLDR9TSWT7458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:19:58.000000Z","updated_at":"2026-02-23T10:02:07.000000Z"},{"id":18947738,"change_date":"2026-02-12 21:39:00","inspection_id":"86964594","insp_unit_id":"211575622","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANAC","insp_unit_company":"L1943","insp_unit_license":"RM0561N","insp_unit_license_state":"QC","insp_unit_vehicle_id_number":"2M5921612K1178425","insp_unit_decal":"Y","insp_unit_decal_number":"36049418","created_at":"2026-02-15T10:19:58.000000Z","updated_at":"2026-02-23T10:02:07.000000Z"}]},{"id":8351276,"change_date":"2025-04-11 21:40:00","inspection_id":"84373506","dot_number":"1111734","report_state":"NY","report_number":"D700300956","insp_date":"2025-04-08 00:00:00","insp_start_time":"0731","insp_end_time":"0751","registration_date":null,"region":"ED","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN NY","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"DHL","shipping_paper_number":"090031","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"826673","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":"1583475","transaction_code":"A","transaction_date":"2025-04-11 00:00:00","upload_date":"2025-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":null,"census_search_date":"2025-04-11 21:40:00","snet_input_date":"2025-04-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-11 21:40:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"QC","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:29:33.000000Z","updated_at":"2025-04-15T10:14:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13550261,"change_date":"2025-04-11 21:40:00","inspection_id":"84373506","insp_unit_id":"206264103","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"25000","insp_unit_license":"L789107","insp_unit_license_state":"QC","insp_unit_vehicle_id_number":"3AKJHLDR8SSVZ7615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:12:53.000000Z","updated_at":"2025-04-15T09:57:12.000000Z"},{"id":13550262,"change_date":"2025-04-11 21:40:00","inspection_id":"84373506","insp_unit_id":"206264104","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANAC","insp_unit_company":"L-1943","insp_unit_license":"RM0561N","insp_unit_license_state":"QC","insp_unit_vehicle_id_number":"2M5921612K1178425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:12:53.000000Z","updated_at":"2025-04-15T09:57:12.000000Z"}]},{"id":7387856,"change_date":"2024-12-11 21:40:00","inspection_id":"83360956","dot_number":"1111734","report_state":"NY","report_number":"SPF3030328","insp_date":"2024-12-04 00:00:00","insp_start_time":"1545","insp_end_time":"1600","registration_date":null,"region":"ES","ci_status_code":"C","location":"70144S","location_desc":"CHAMPLAIN NY","county_code_state":"NY","county_code":"019","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-12-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1142827","transaction_code":"A","transaction_date":"2024-12-11 00:00:00","upload_date":"2024-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":null,"census_search_date":"2024-12-11 21:40:00","snet_input_date":"2024-12-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-11 21:40:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"QC","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:17.000000Z","updated_at":"2025-03-17T20:50:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11917792,"change_date":"2024-12-11 21:40:00","inspection_id":"83360956","insp_unit_id":"204314392","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"2024","insp_unit_license":"LE21162","insp_unit_license_state":"QC","insp_unit_vehicle_id_number":"JALE5W161R7307595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:35.000000Z","updated_at":"2025-03-17T23:46:35.000000Z"}]},{"id":6966776,"change_date":"2024-10-16 21:40:00","inspection_id":"82915421","dot_number":"1111734","report_state":"NY","report_number":"D700200812","insp_date":"2024-10-09 00:00:00","insp_start_time":"0906","insp_end_time":"0930","registration_date":null,"region":"ED","ci_status_code":"C","location":"70144N","location_desc":"CHAMPLAIN NY","county_code_state":"NY","county_code":null,"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-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","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":"949548","transaction_code":"A","transaction_date":"2024-10-16 00:00:00","upload_date":"2024-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":null,"census_search_date":"2024-10-16 21:40:00","snet_input_date":"2024-10-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-16 21:40:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"QC","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:24.000000Z","updated_at":"2025-03-17T20:41:24.000000Z","inspection_violations":[{"id":10864083,"change_date":"2024-10-16 21:40:00","inspection_id":"82915421","insp_violation_id":"262370737","seq_no":"1","part_no":"393","part_no_section":"55D2-B","insp_viol_unit":"1","insp_unit_id":"203426735","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"39355D2B"}],"inspection_per_units":[{"id":11236474,"change_date":"2024-10-16 21:40:00","inspection_id":"82915421","insp_unit_id":"203426735","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"L986068","insp_unit_license_state":"QC","insp_unit_vehicle_id_number":"3AKJHLDR3RSUY1622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:20.000000Z","updated_at":"2025-03-17T23:39:20.000000Z"},{"id":11236475,"change_date":"2024-10-16 21:40:00","inspection_id":"82915421","insp_unit_id":"203426736","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"RJ8458P","insp_unit_license_state":"QC","insp_unit_vehicle_id_number":"2M5921614K1181083","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:20.000000Z","updated_at":"2025-03-17T23:39:20.000000Z"}]},{"id":6463266,"change_date":"2024-08-14 21:38:00","inspection_id":"82379428","dot_number":"1111734","report_state":"NY","report_number":"D700300577","insp_date":"2024-08-13 00:00:00","insp_start_time":"0819","insp_end_time":"0836","registration_date":null,"region":"ED","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN NY","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ABZAC CANADA INC","shipping_paper_number":"005442-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":"U","pen_cen_match":"I","final_status_date":"2024-08-14 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"744448","transaction_code":"A","transaction_date":"2024-08-14 00:00:00","upload_date":"2024-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":null,"census_search_date":"2024-08-14 21:38:00","snet_input_date":"2024-08-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-14 21:38:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"QC","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:05.000000Z","updated_at":"2025-03-17T20:31:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10417677,"change_date":"2024-08-14 21:38:00","inspection_id":"82379428","insp_unit_id":"202383274","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"24000","insp_unit_license":"L985074","insp_unit_license_state":"QC","insp_unit_vehicle_id_number":"3AKJHLDR1RSUY1621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:57.000000Z","updated_at":"2025-03-17T23:30:57.000000Z"},{"id":10417678,"change_date":"2024-08-14 21:38:00","inspection_id":"82379428","insp_unit_id":"202383275","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"L1203","insp_unit_license":"RG1974R","insp_unit_license_state":"QC","insp_unit_vehicle_id_number":"1JJV532D2CL685430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:57.000000Z","updated_at":"2025-03-17T23:30:57.000000Z"}]},{"id":6332844,"change_date":"2024-07-29 21:41:00","inspection_id":"82240014","dot_number":"1111734","report_state":"NY","report_number":"SPB0333561","insp_date":"2024-07-23 00:00:00","insp_start_time":"1631","insp_end_time":"1647","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN (CVIF)","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"KIMPEX","shipping_paper_number":"0015413","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-07-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2940798","transaction_code":"A","transaction_date":"2024-07-29 00:00:00","upload_date":"2024-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-29 21:41:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:16.000000Z","updated_at":"2025-03-17T20:28:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10204495,"change_date":"2024-07-29 21:41:00","inspection_id":"82240014","insp_unit_id":"202118455","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"220","insp_unit_license":"L827015","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2AYSDM2H8L1003768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:40.000000Z","updated_at":"2025-03-17T23:28:40.000000Z"}]},{"id":6174889,"change_date":"2024-07-09 21:43:00","inspection_id":"82070771","dot_number":"1111734","report_state":"NY","report_number":"SPG0225594","insp_date":"2024-06-26 00:00:00","insp_start_time":"1645","insp_end_time":"1700","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN CVIF","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"0015373","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-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2935152","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-09 21:43:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:02.000000Z","updated_at":"2025-03-17T20:25:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9947372,"change_date":"2024-07-09 21:43:00","inspection_id":"82070771","insp_unit_id":"201792915","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"L827015","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2AYSDM2H8L1003768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:05.000000Z","updated_at":"2025-03-17T23:26:05.000000Z"}]},{"id":5790048,"change_date":"2024-05-20 21:42:00","inspection_id":"81654340","dot_number":"1111734","report_state":"NY","report_number":"SPL0156808","insp_date":"2024-05-15 00:00:00","insp_start_time":"1522","insp_end_time":"1541","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144A","location_desc":"CHAMPLAIN (US CUSTOMS)","county_code_state":"NY","county_code":"019","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":"2024-05-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2924669","transaction_code":"A","transaction_date":"2024-05-20 00:00:00","upload_date":"2024-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-05-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-20 21:42:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:30.000000Z","updated_at":"2025-03-17T20:17:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9325521,"change_date":"2024-05-20 21:42:00","inspection_id":"81654340","insp_unit_id":"200976245","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"L827015","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2AYSDM2H8L1003768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:50.000000Z","updated_at":"2025-03-17T23:19:50.000000Z"}]},{"id":5458836,"change_date":"2024-04-08 21:43:00","inspection_id":"81293856","dot_number":"1111734","report_state":"NY","report_number":"SPF0167493","insp_date":"2024-04-02 00:00:00","insp_start_time":"1545","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN CVIF","county_code_state":"NY","county_code":"019","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":"2024-04-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2915701","transaction_code":"A","transaction_date":"2024-04-08 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-04-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-04-08 21:43:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:44.000000Z","updated_at":"2025-03-17T20:10:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8792844,"change_date":"2024-04-08 21:43:00","inspection_id":"81293856","insp_unit_id":"200285839","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"220","insp_unit_license":"L827015","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2AYSDM2H8L1003768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:47.000000Z","updated_at":"2025-03-17T23:14:47.000000Z"}]},{"id":5432340,"change_date":"2024-04-04 21:41:00","inspection_id":"81265074","dot_number":"1111734","report_state":"NY","report_number":"SPB0333290","insp_date":"2024-04-01 00:00:00","insp_start_time":"1603","insp_end_time":"1621","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN (CVIF)","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"KIMPEX","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-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2914803","transaction_code":"A","transaction_date":"2024-04-04 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-04-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-04-04 21:41:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:18.000000Z","updated_at":"2025-03-17T20:10:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8750232,"change_date":"2024-04-04 21:41:00","inspection_id":"81265074","insp_unit_id":"200231504","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"220","insp_unit_license":"L827015","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2AYSDM2H8L1003768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:24.000000Z","updated_at":"2025-03-17T23:14:24.000000Z"}]},{"id":3730173,"change_date":"2023-08-14 21:41:00","inspection_id":"79391957","dot_number":"1111734","report_state":"NY","report_number":"SPB0332798","insp_date":"2023-08-09 00:00:00","insp_start_time":"1639","insp_end_time":"1657","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN (CVIF)","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"KIMPEX","shipping_paper_number":"13341","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-08-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2857473","transaction_code":"A","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":null,"census_search_date":"2023-08-14 21:41:00","snet_input_date":"2023-08-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-14 21:41:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C6X8","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:30.000000Z","updated_at":"2025-03-17T19:36:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5997386,"change_date":"2023-08-14 21:41:00","inspection_id":"79391957","insp_unit_id":"196502321","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"220","insp_unit_license":"L827015","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2AYSDM2H8L1003768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:24.000000Z","updated_at":"2025-03-17T22:50:24.000000Z"}]},{"id":3077112,"change_date":"2023-05-18 21:42:00","inspection_id":"78657552","dot_number":"1111734","report_state":"NY","report_number":"0120000893","insp_date":"2023-05-17 00:00:00","insp_start_time":"1625","insp_end_time":"1645","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN INSPECTION FACILITY","county_code_state":"NY","county_code":"019","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"KIMPEX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2827018","transaction_code":"A","transaction_date":"2023-05-18 00:00:00","upload_date":"2023-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-18 21:42:00","insp_carrier_name":"LETARTE DRUMMONDVILLE","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:49.000000Z","updated_at":"2025-03-17T19:23:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4949650,"change_date":"2023-05-18 21:42:00","inspection_id":"78657552","insp_unit_id":"195000678","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"220","insp_unit_license":"L827015","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2AYSDM2H8L1003768","insp_unit_decal":"Y","insp_unit_decal_number":"32702237","created_at":"2025-03-17T22:42:01.000000Z","updated_at":"2025-03-17T22:42:01.000000Z"}]},{"id":2755423,"change_date":"2023-04-07 21:38:00","inspection_id":"78293878","dot_number":"1111734","report_state":"NY","report_number":"SPT0432998","insp_date":"2023-04-05 00:00:00","insp_start_time":"1613","insp_end_time":"1632","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN (CVIF)","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"KIMPEX","shipping_paper_number":"12999","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-04-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2814189","transaction_code":"A","transaction_date":"2023-04-07 00:00:00","upload_date":"2023-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-07 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-04-07 21:38:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:23.000000Z","updated_at":"2025-03-17T19:17:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4434731,"change_date":"2023-04-07 21:38:00","inspection_id":"78293878","insp_unit_id":"194275515","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"220","insp_unit_license":"L827015","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2AYSDM2H8L1003768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:54.000000Z","updated_at":"2025-03-17T22:37:54.000000Z"}]},{"id":2453130,"change_date":"2023-02-27 21:41:00","inspection_id":"77949436","dot_number":"1111734","report_state":"NY","report_number":"SPT0432896","insp_date":"2023-02-21 00:00:00","insp_start_time":"0957","insp_end_time":"1023","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN CVIF","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ABZAC CANADA INC","shipping_paper_number":"345373","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-02-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"126523","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":"2802518","transaction_code":"A","transaction_date":"2023-02-27 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-27 21:41:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:48.000000Z","updated_at":"2025-03-17T19:11:48.000000Z","inspection_violations":[{"id":3776772,"change_date":"2023-02-27 21:41:00","inspection_id":"77949436","insp_violation_id":"251345341","seq_no":"1","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"193586506","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:45.000000Z","updated_at":"2025-03-17T21:24:45.000000Z","normalized_code":"39355C1"}],"inspection_per_units":[{"id":3947447,"change_date":"2023-02-27 21:41:00","inspection_id":"77949436","insp_unit_id":"193586506","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"9000","insp_unit_license":"L780955","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"3AKJHLDR5KSJY5894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:16.000000Z","updated_at":"2025-03-17T22:34:16.000000Z"},{"id":3947448,"change_date":"2023-02-27 21:41:00","inspection_id":"77949436","insp_unit_id":"193586507","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":"L2263","insp_unit_license":"RN0280C","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2M5921618N1212694","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:16.000000Z","updated_at":"2025-03-17T22:34:16.000000Z"}]},{"id":2453223,"change_date":"2023-02-27 21:41:00","inspection_id":"77949536","dot_number":"1111734","report_state":"NY","report_number":"SPT0432903","insp_date":"2023-02-21 00:00:00","insp_start_time":"1607","insp_end_time":"1625","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN (US CUSTOMS)","county_code_state":"NY","county_code":"019","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-02-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2802065","transaction_code":"A","transaction_date":"2023-02-27 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-27 21:41:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:48.000000Z","updated_at":"2025-03-17T19:11:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3947590,"change_date":"2023-02-27 21:41:00","inspection_id":"77949536","insp_unit_id":"193586667","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"220","insp_unit_license":"L827015","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2AYSDM2H8L1003768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:16.000000Z","updated_at":"2025-03-17T22:34:16.000000Z"}]},{"id":2354493,"change_date":"2023-02-13 21:42:00","inspection_id":"77836930","dot_number":"1111734","report_state":"NY","report_number":"SPB0391288","insp_date":"2023-02-02 00:00:00","insp_start_time":"0849","insp_end_time":"0913","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN CVIF","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ABZAC CANADA INC","shipping_paper_number":"066332","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-02-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2798465","transaction_code":"A","transaction_date":"2023-02-02 00:00:00","upload_date":"2023-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":null,"census_search_date":"2023-02-13 21:42:00","snet_input_date":"2023-02-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-13 21:42:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C6X8","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:00.000000Z","updated_at":"2025-03-17T19:10:00.000000Z","inspection_violations":[{"id":3626739,"change_date":"2023-02-13 21:42:00","inspection_id":"77836930","insp_violation_id":"251089970","seq_no":"1","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"39524D"},{"id":3626740,"change_date":"2023-02-13 21:42:00","inspection_id":"77836930","insp_violation_id":"251089971","seq_no":"2","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"193358695","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"39355C1"},{"id":3626741,"change_date":"2023-02-13 21:42:00","inspection_id":"77836930","insp_violation_id":"251089972","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193358695","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":3789143,"change_date":"2023-02-13 21:42:00","inspection_id":"77836930","insp_unit_id":"193358695","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"9000","insp_unit_license":"L780955","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"3AKJHLDR5KSJY5894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:07.000000Z","updated_at":"2025-03-17T22:33:07.000000Z"},{"id":3789144,"change_date":"2023-02-13 21:42:00","inspection_id":"77836930","insp_unit_id":"193358696","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"L413","insp_unit_license":"RG0333K","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"1UYVS253XGG460106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:07.000000Z","updated_at":"2025-03-17T22:33:07.000000Z"}]},{"id":1794009,"change_date":"2022-11-22 21:40:00","inspection_id":"77196264","dot_number":"1111734","report_state":"NY","report_number":"SPL0155156","insp_date":"2022-11-15 00:00:00","insp_start_time":"1616","insp_end_time":"1632","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144A","location_desc":"CHAMPLAIN (US CUSTOMS)","county_code_state":"NY","county_code":"019","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":"2022-11-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2773272","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-22 21:40:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:40.000000Z","updated_at":"2025-03-17T18:59:40.000000Z","inspection_violations":[{"id":2805757,"change_date":"2022-11-22 21:40:00","inspection_id":"77196264","insp_violation_id":"249733625","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"192079040","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":2885704,"change_date":"2022-11-22 21:40:00","inspection_id":"77196264","insp_unit_id":"192079040","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"L827015","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2AYSDM2H8L1003768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:46.000000Z","updated_at":"2025-03-17T22:26:46.000000Z"}]},{"id":1419024,"change_date":"2022-10-03 21:39:00","inspection_id":"76764814","dot_number":"1111734","report_state":"NY","report_number":"SPB0313590","insp_date":"2022-09-30 00:00:00","insp_start_time":"0755","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN CVIF","county_code_state":"NY","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ABZAC CANADA INC","shipping_paper_number":"T3277","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-10-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"126523","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":"2755310","transaction_code":"A","transaction_date":"2022-10-03 00:00:00","upload_date":"2022-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-03 21:39:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:45.000000Z","updated_at":"2025-03-17T18:52:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2284259,"change_date":"2022-10-03 21:39:00","inspection_id":"76764814","insp_unit_id":"191217019","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"9000","insp_unit_license":"L780955","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"3AKJHLDR5KSJY5894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:37.000000Z","updated_at":"2025-03-17T22:22:37.000000Z"},{"id":2284260,"change_date":"2022-10-03 21:39:00","inspection_id":"76764814","insp_unit_id":"191217020","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":"L2243","insp_unit_license":"RN0282C","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2M5921614N1212692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:37.000000Z","updated_at":"2025-03-17T22:22:37.000000Z"}]},{"id":1032404,"change_date":"2022-08-15 21:37:00","inspection_id":"76315208","dot_number":"1111734","report_state":"NY","report_number":"SPF0195857","insp_date":"2022-08-11 00:00:00","insp_start_time":"0902","insp_end_time":"0927","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144A","location_desc":"CHAMPLAIN (US CUSTOMS)","county_code_state":"NY","county_code":"019","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":"2022-08-15 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2739675","transaction_code":"A","transaction_date":"2022-08-15 00:00:00","upload_date":"2022-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-15 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-15 21:37:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:50.000000Z","updated_at":"2025-03-17T18:45:50.000000Z","inspection_violations":[{"id":1626976,"change_date":"2022-08-15 21:37:00","inspection_id":"76315208","insp_violation_id":"247701131","seq_no":"1","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"190297573","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"39355D3"}],"inspection_per_units":[{"id":1661377,"change_date":"2022-08-15 21:37:00","inspection_id":"76315208","insp_unit_id":"190297572","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"L780895","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"3AKJHLDR5KSJY5894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:28.000000Z","updated_at":"2025-03-17T22:18:28.000000Z"},{"id":1661378,"change_date":"2022-08-15 21:37:00","inspection_id":"76315208","insp_unit_id":"190297573","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":null,"insp_unit_license":"RY42492","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2M592161851100770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:28.000000Z","updated_at":"2025-03-17T22:18:28.000000Z"}]},{"id":613717,"change_date":"2022-06-15 21:40:00","inspection_id":"75824326","dot_number":"1111734","report_state":"NY","report_number":"SPB0380928","insp_date":"2022-06-13 00:00:00","insp_start_time":"1807","insp_end_time":"1834","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144A","location_desc":"CHAMPLAIN (NB)","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"KIMPEX","shipping_paper_number":"66028","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-06-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"126523","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":"2716781","transaction_code":"A","transaction_date":"2022-06-15 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-15 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-15 21:40:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:28.000000Z","updated_at":"2025-03-17T18:38:28.000000Z","inspection_violations":[{"id":964670,"change_date":"2022-06-15 21:40:00","inspection_id":"75824326","insp_violation_id":"246475119","seq_no":"1","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"1","insp_unit_id":"189258093","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":986958,"change_date":"2022-06-15 21:40:00","inspection_id":"75824326","insp_unit_id":"189258093","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"9000","insp_unit_license":"L780955","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"3AKJHLDR5KSJY5894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:16.000000Z","updated_at":"2025-03-17T22:14:16.000000Z"},{"id":986959,"change_date":"2022-06-15 21:40:00","inspection_id":"75824326","insp_unit_id":"189258094","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":"L2003MC","insp_unit_license":"RJ7441Z","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2M5921619L1189875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:16.000000Z","updated_at":"2025-03-17T22:14:16.000000Z"}]},{"id":578869,"change_date":"2022-06-10 21:40:00","inspection_id":"75782569","dot_number":"1111734","report_state":"NY","report_number":"SPB0274305","insp_date":"2022-06-09 00:00:00","insp_start_time":"1513","insp_end_time":"1551","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144A","location_desc":"CHAMPLAIN CVIF","county_code_state":"NY","county_code":"019","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-06-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2715726","transaction_code":"A","transaction_date":"2022-06-10 00:00:00","upload_date":"2022-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-10 21:40:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:49.000000Z","updated_at":"2025-03-17T18:37:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":930066,"change_date":"2022-06-10 21:40:00","inspection_id":"75782569","insp_unit_id":"189167238","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"220","insp_unit_license":"L827015","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2AYSDM2H8L1003768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:56.000000Z","updated_at":"2025-03-17T22:13:56.000000Z"}]},{"id":274136,"change_date":"2022-04-28 21:39:00","inspection_id":"75420004","dot_number":"1111734","report_state":"NY","report_number":"MC74000328","insp_date":"2022-04-27 00:00:00","insp_start_time":"1545","insp_end_time":"1619","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144M","location_desc":"CHAMPLAIN  (US CUSTOMS) SB","county_code_state":"NY","county_code":"019","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"KIMPEX","shipping_paper_number":"011889","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2700292","transaction_code":"A","transaction_date":"2022-04-28 00:00:00","upload_date":"2022-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-28 21:39:00","insp_carrier_name":"LETARTE DRUMMONDVILLE","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:15.000000Z","updated_at":"2025-03-17T18:32:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":443886,"change_date":"2022-04-28 21:39:00","inspection_id":"75420004","insp_unit_id":"188389810","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"L827015","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2AYSDM2H8L1003768","insp_unit_decal":"Y","insp_unit_decal_number":"31442225","created_at":"2025-03-17T22:10:55.000000Z","updated_at":"2025-03-17T22:10:55.000000Z"}]},{"id":142133,"change_date":"2022-04-11 21:40:00","inspection_id":"75262318","dot_number":"1111734","report_state":"NY","report_number":"SPF0195232","insp_date":"2022-04-05 00:00:00","insp_start_time":"1512","insp_end_time":"1639","registration_date":null,"region":"ET","ci_status_code":"C","location":"70144A","location_desc":"CHAMPLAIN (US CUSTOMS)","county_code_state":"NY","county_code":"019","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":"2022-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2694459","transaction_code":"A","transaction_date":"2022-04-11 00:00:00","upload_date":"2022-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01111734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-11 21:40:00","insp_carrier_name":"SERVICE LOUIS LETARTE INC","insp_carrier_street":"2800 POWER ST","insp_carrier_city":"DRUMMONDVILLE","insp_carrier_state":"PQ","insp_carrier_zip_code":"J2C 6X8","insp_colonia":null,"docket_number":"457345","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:07.000000Z","updated_at":"2025-03-17T18:30:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":229996,"change_date":"2022-04-11 21:40:00","inspection_id":"75262318","insp_unit_id":"188072089","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"L827015","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2AYSDM2H8L1003768","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\/1111734\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1111734\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1111734\/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\/1111734\/inspections","per_page":100,"prev_page_url":null,"to":25,"total":25}