{"current_page":1,"data":[{"id":12839776,"change_date":"2026-08-27 21:47:00","inspection_id":"88816810","dot_number":"2781752","report_state":"NY","report_number":"SPE3081669","insp_date":"2026-08-20 00:00:00","insp_start_time":"1235","insp_end_time":"1252","registration_date":null,"region":"ED","ci_status_code":"C","location":"40857E","location_desc":"VICTOR NY","county_code_state":"NY","county_code":"069","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":"2026-08-27 21:47: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":"4096993","transaction_code":"A","transaction_date":"2026-08-26 00:00:00","upload_date":"2026-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":null,"census_search_date":"2026-08-27 21:47:00","snet_input_date":"2026-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-27 21:47:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-30T09:40:44.000000Z","updated_at":"2026-09-03T09:36:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":22282201,"change_date":"2026-08-27 21:47:00","inspection_id":"88816810","insp_unit_id":"215386799","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"421091","insp_unit_license":"51579NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC0RDUZ2280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-30T09:17:08.000000Z","updated_at":"2026-09-03T09:09:30.000000Z"}]},{"id":11382053,"change_date":"2026-03-16 21:38:00","inspection_id":"87296210","dot_number":"2781752","report_state":"NY","report_number":"SPT3101390","insp_date":"2026-03-09 00:00:00","insp_start_time":"0948","insp_end_time":"0955","registration_date":null,"region":"ED","ci_status_code":"C","location":"20854W","location_desc":"VERONA NY","county_code_state":"NY","county_code":"065","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":"2026-03-16 21:38: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":"3009711","transaction_code":"A","transaction_date":"2026-03-15 00:00:00","upload_date":"2026-03-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":null,"census_search_date":"2026-03-16 21:38:00","snet_input_date":"2026-03-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-16 21:38:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-19T09:37:40.000000Z","updated_at":"2026-03-27T09:30:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19490730,"change_date":"2026-03-16 21:38:00","inspection_id":"87296210","insp_unit_id":"212148248","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"421091","insp_unit_license":"51579NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC0RDUZ2280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-19T09:12:34.000000Z","updated_at":"2026-03-27T09:04:00.000000Z"}]},{"id":10911172,"change_date":"2026-03-04 21:40:00","inspection_id":"86943002","dot_number":"2781752","report_state":"NY","report_number":"SPD3061507","insp_date":"2026-01-27 00:00:00","insp_start_time":"1106","insp_end_time":"1135","registration_date":"2026-03-02 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"TULLY NY","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SQUARE ONE COATING SYSTEMS","shipping_paper_number":"55096","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-02-03 21:38: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":"2838664","transaction_code":"C","transaction_date":"2026-02-02 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":null,"census_search_date":"2026-02-03 21:38:00","snet_input_date":"2026-01-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-03 21:38:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-06T10:35:11.000000Z","updated_at":"2026-03-15T09:30:47.000000Z","inspection_violations":[{"id":18964196,"change_date":"2026-03-04 21:40:00","inspection_id":"86943002","insp_violation_id":"272185499","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"S260248136","created_at":"2026-03-07T10:57:12.000000Z","updated_at":"2026-03-15T09:40:08.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":19302988,"change_date":"2026-03-04 21:40:00","inspection_id":"86943002","insp_unit_id":"211958875","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"421092","insp_unit_license":"78394NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC2RDUZ2281","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:44.000000Z","updated_at":"2026-03-15T09:03:11.000000Z"}]},{"id":10774217,"change_date":"2026-01-15 21:40:00","inspection_id":"86799602","dot_number":"2781752","report_state":"NY","report_number":"SPT3031820","insp_date":"2026-01-08 00:00:00","insp_start_time":"1209","insp_end_time":"1225","registration_date":null,"region":"ES","ci_status_code":"C","location":"30223B","location_desc":"EAST SYRACUSE NY","county_code_state":"NY","county_code":"067","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SQUARE ONE","shipping_paper_number":"55150","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-01-15 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":"2768331","transaction_code":"A","transaction_date":"2026-01-14 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":null,"census_search_date":"2026-01-15 21:40:00","snet_input_date":"2026-01-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-15 21:40:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-18T10:44:25.000000Z","updated_at":"2026-01-26T10:30:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18086882,"change_date":"2026-01-15 21:40:00","inspection_id":"86799602","insp_unit_id":"211101429","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"421092","insp_unit_license":"78394NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC2RDUZ2281","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:16:46.000000Z","updated_at":"2026-01-26T10:00:24.000000Z"}]},{"id":10491021,"change_date":"2025-12-22 21:38:00","inspection_id":"86625433","dot_number":"2781752","report_state":"NY","report_number":"SPD3051449","insp_date":"2025-12-15 00:00:00","insp_start_time":"1035","insp_end_time":"1050","registration_date":null,"region":"ES","ci_status_code":"C","location":"30445S","location_desc":"TULLY NY","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SQUARE 1","shipping_paper_number":"54657","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-12-22 21:38: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":"2686739","transaction_code":"A","transaction_date":"2025-12-21 00:00:00","upload_date":"2025-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":null,"census_search_date":"2025-12-22 21:38:00","snet_input_date":"2025-12-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-22 21:38:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-25T10:37:37.000000Z","updated_at":"2026-01-02T10:30:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17566667,"change_date":"2025-12-22 21:38:00","inspection_id":"86625433","insp_unit_id":"210742698","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"421091","insp_unit_license":"51579NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC0RDUZ2280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-25T10:08:35.000000Z","updated_at":"2026-01-02T10:00:16.000000Z"}]},{"id":10476008,"change_date":"2025-12-19 21:38:00","inspection_id":"86609671","dot_number":"2781752","report_state":"NY","report_number":"D103101398","insp_date":"2025-12-12 00:00:00","insp_start_time":"1143","insp_end_time":"1205","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"FULTONVILLE NY","county_code_state":"NY","county_code":"057","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":"U","pen_cen_match":"I","final_status_date":"2025-12-19 21:38: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":"2676902","transaction_code":"A","transaction_date":"2025-12-19 00:00:00","upload_date":"2025-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":null,"census_search_date":"2025-12-19 21:38:00","snet_input_date":"2025-12-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-19 21:38:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-22T10:31:42.000000Z","updated_at":"2025-12-30T10:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17536544,"change_date":"2025-12-19 21:38:00","inspection_id":"86609671","insp_unit_id":"210705384","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"51579NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC0RDUZ2280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-22T10:01:55.000000Z","updated_at":"2025-12-30T10:00:14.000000Z"}]},{"id":9982838,"change_date":"2025-10-20 21:39:00","inspection_id":"86092157","dot_number":"2781752","report_state":"NY","report_number":"D305400999","insp_date":"2025-10-20 00:00:00","insp_start_time":"0920","insp_end_time":"0936","registration_date":null,"region":"ED","ci_status_code":"C","location":"20854W","location_desc":"VERONA NY","county_code_state":"NY","county_code":"065","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SQUARE ONE COATING SYSTEMS LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-20 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":"2435285","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":null,"census_search_date":"2025-10-20 21:39:00","snet_input_date":"2025-10-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-20 21:39:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-23T10:00:37.000000Z","updated_at":"2025-10-24T10:00:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16577006,"change_date":"2025-10-20 21:39:00","inspection_id":"86092157","insp_unit_id":"209549460","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"421091","insp_unit_license":"51579NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC0RDUZ2280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:35.000000Z","updated_at":"2025-10-24T09:45:44.000000Z"}]},{"id":7850461,"change_date":"2025-02-12 21:38:00","inspection_id":"83846976","dot_number":"2781752","report_state":"NY","report_number":"M608200017","insp_date":"2025-02-11 00:00:00","insp_start_time":"1305","insp_end_time":"1322","registration_date":null,"region":"ES","ci_status_code":"C","location":"40857E","location_desc":"VICTOR NY","county_code_state":"NY","county_code":"069","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":"2025-02-12 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19501","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":"1353432","transaction_code":"A","transaction_date":"2025-02-12 00:00:00","upload_date":"2025-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":null,"census_search_date":"2025-02-12 21:38:00","snet_input_date":"2025-02-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-12 21:38:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:11.000000Z","updated_at":"2025-03-17T21:01:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12670062,"change_date":"2025-02-12 21:38:00","inspection_id":"83846976","insp_unit_id":"205285589","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"421091","insp_unit_license":"51579NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC0RDUZ2280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:58.000000Z","updated_at":"2025-03-17T23:54:58.000000Z"}]},{"id":7753293,"change_date":"2025-01-31 21:39:00","inspection_id":"83744631","dot_number":"2781752","report_state":"NY","report_number":"SPT3100371","insp_date":"2025-01-24 00:00:00","insp_start_time":"1133","insp_end_time":"1137","registration_date":null,"region":"ES","ci_status_code":"C","location":"20330R","location_desc":"FULTONVILLE NY","county_code_state":"NY","county_code":"057","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-01-31 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":"1306246","transaction_code":"A","transaction_date":"2025-01-31 00:00:00","upload_date":"2025-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":null,"census_search_date":"2025-01-31 21:39:00","snet_input_date":"2025-01-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-31 21:39:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:10.000000Z","updated_at":"2025-03-17T20:59:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12512070,"change_date":"2025-01-31 21:39:00","inspection_id":"83744631","insp_unit_id":"205092568","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"421091","insp_unit_license":"51579NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC0RDUZ2280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:07.000000Z","updated_at":"2025-03-17T23:53:07.000000Z"}]},{"id":7532852,"change_date":"2025-01-02 21:38:00","inspection_id":"83513221","dot_number":"2781752","report_state":"NY","report_number":"D507500648","insp_date":"2025-01-02 00:00:00","insp_start_time":"1231","insp_end_time":"1247","registration_date":null,"region":"ES","ci_status_code":"C","location":"40857E","location_desc":"VICTOR NY","county_code_state":"NY","county_code":"069","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":"2025-01-02 21:38: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":"1210863","transaction_code":"A","transaction_date":"2025-01-02 00:00:00","upload_date":"2025-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":null,"census_search_date":"2025-01-02 21:38:00","snet_input_date":"2025-01-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-02 21:38:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:53:12.000000Z","updated_at":"2025-03-17T20:53:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12152914,"change_date":"2025-01-02 21:38:00","inspection_id":"83513221","insp_unit_id":"204619239","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"421091","insp_unit_license":"51579NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC0RDUZ2280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:10.000000Z","updated_at":"2025-03-17T23:49:10.000000Z"}]},{"id":7492100,"change_date":"2024-12-24 21:34:00","inspection_id":"83470519","dot_number":"2781752","report_state":"NY","report_number":"SPE3060257","insp_date":"2024-12-17 00:00:00","insp_start_time":"1231","insp_end_time":"1246","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ROCHESTER NY","county_code_state":"NY","county_code":"055","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"1217","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-24 21:34: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":"1190170","transaction_code":"A","transaction_date":"2024-12-24 00:00:00","upload_date":"2024-12-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":null,"census_search_date":"2024-12-24 21:34:00","snet_input_date":"2024-12-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-24 21:34:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:20.000000Z","updated_at":"2025-03-17T20:52:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12086766,"change_date":"2024-12-24 21:34:00","inspection_id":"83470519","insp_unit_id":"204540683","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"421091","insp_unit_license":"51579NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC0RDUZ2280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:28.000000Z","updated_at":"2025-03-17T23:48:28.000000Z"}]},{"id":6248016,"change_date":"2024-07-18 21:40:00","inspection_id":"82149270","dot_number":"2781752","report_state":"NY","report_number":"SPT0580270","insp_date":"2024-07-17 00:00:00","insp_start_time":"1405","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":"22058A","location_desc":"UTICA (EXIT 31)","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SQUARE ONE COATING SYSTEMS LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-18 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":"2937726","transaction_code":"A","transaction_date":"2024-07-18 00:00:00","upload_date":"2024-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":"M","census_search_date":"2024-07-18 21:40:00","snet_input_date":"2024-07-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-18 21:40:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:36.000000Z","updated_at":"2025-03-17T20:26:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10066968,"change_date":"2024-07-18 21:40:00","inspection_id":"82149270","insp_unit_id":"201945416","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421092","insp_unit_license":"78394NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC2RDUZ2281","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:17.000000Z","updated_at":"2025-03-17T23:27:17.000000Z"}]},{"id":6091876,"change_date":"2024-06-27 21:40:00","inspection_id":"81981499","dot_number":"2781752","report_state":"NY","report_number":"SPT0541767","insp_date":"2024-06-26 00:00:00","insp_start_time":"1301","insp_end_time":"1316","registration_date":null,"region":"ET","ci_status_code":"C","location":"20895R","location_desc":"WESTMORELAND (EXIT 32)","county_code_state":"NY","county_code":"065","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BITZER SCROLL, INC","shipping_paper_number":"6262024","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-27 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":"2933300","transaction_code":"A","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":"M","census_search_date":"2024-06-27 21:40:00","snet_input_date":"2024-06-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-27 21:40:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:23.000000Z","updated_at":"2025-03-17T20:23:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9811887,"change_date":"2024-06-27 21:40:00","inspection_id":"81981499","insp_unit_id":"201622433","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"51579NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC0RDUZ2280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:39.000000Z","updated_at":"2025-03-17T23:24:39.000000Z"}]},{"id":5917818,"change_date":"2024-06-05 21:41:00","inspection_id":"81793195","dot_number":"2781752","report_state":"NY","report_number":"SPE0321820","insp_date":"2024-06-04 00:00:00","insp_start_time":"1047","insp_end_time":"1113","registration_date":null,"region":"ET","ci_status_code":"C","location":"30637","location_desc":"T\/PALMYRA","county_code_state":"NY","county_code":"117","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SQUARE ONE COATING","shipping_paper_number":"45059","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-05 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":"2928221","transaction_code":"A","transaction_date":"2024-06-05 00:00:00","upload_date":"2024-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":"M","census_search_date":"2024-06-05 21:41:00","snet_input_date":"2024-06-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-05 21:41:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:53.000000Z","updated_at":"2025-03-17T20:19:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9531528,"change_date":"2024-06-05 21:41:00","inspection_id":"81793195","insp_unit_id":"201243724","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421091","insp_unit_license":"51579NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC0RDUZ2280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:52.000000Z","updated_at":"2025-03-17T23:21:52.000000Z"}]},{"id":5789990,"change_date":"2024-05-20 21:42:00","inspection_id":"81654280","dot_number":"2781752","report_state":"NY","report_number":"SPT0532152","insp_date":"2024-05-17 00:00:00","insp_start_time":"1124","insp_end_time":"1146","registration_date":null,"region":"ET","ci_status_code":"C","location":"12001","location_desc":"ALBANY SB","county_code_state":"NY","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"44819","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":"26000","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":"2924749","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":"02781752","upload_search_indicator":"M","census_search_date":"2024-05-20 21:42:00","snet_input_date":"2024-05-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-20 21:42:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","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":[{"id":8967337,"change_date":"2024-05-20 21:42:00","inspection_id":"81654280","insp_violation_id":"259602321","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:49:22.000000Z","updated_at":"2025-03-17T21:49:22.000000Z","normalized_code":"3922"},{"id":8967338,"change_date":"2024-05-20 21:42:00","inspection_id":"81654280","insp_violation_id":"259602322","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200976141","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:22.000000Z","updated_at":"2025-03-17T21:49:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9325431,"change_date":"2024-05-20 21:42:00","inspection_id":"81654280","insp_unit_id":"200976141","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421091","insp_unit_license":"51579NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC0RDUZ2280","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":5585069,"change_date":"2024-04-24 21:41:00","inspection_id":"81431655","dot_number":"2781752","report_state":"NY","report_number":"SPE0340703","insp_date":"2024-04-23 00:00:00","insp_start_time":"1130","insp_end_time":"1152","registration_date":null,"region":"ET","ci_status_code":"C","location":"40045","location_desc":"AVON","county_code_state":"NY","county_code":"051","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"D.P. TOOL AND MACHINE INC","shipping_paper_number":"107864","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-24 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":"2919007","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":"M","census_search_date":"2024-04-24 21:41:00","snet_input_date":"2024-04-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-04-24 21:41:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:29.000000Z","updated_at":"2025-03-17T20:13:29.000000Z","inspection_violations":[{"id":8633990,"change_date":"2024-04-24 21:41:00","inspection_id":"81431655","insp_violation_id":"259104761","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200548059","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:48.000000Z","updated_at":"2025-03-17T21:47:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8996162,"change_date":"2024-04-24 21:41:00","inspection_id":"81431655","insp_unit_id":"200548059","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421091","insp_unit_license":"51579NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC0RDUZ2280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:43.000000Z","updated_at":"2025-03-17T23:16:43.000000Z"}]},{"id":4793136,"change_date":"2024-01-09 21:43:00","inspection_id":"80566961","dot_number":"2781752","report_state":"NY","report_number":"SPT0541245","insp_date":"2024-01-08 00:00:00","insp_start_time":"1429","insp_end_time":"1448","registration_date":null,"region":"ET","ci_status_code":"C","location":"20854A","location_desc":"VERONA","county_code_state":"NY","county_code":"065","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-01-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2898089","transaction_code":"A","transaction_date":"2024-01-09 00:00:00","upload_date":"2024-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":"M","census_search_date":"2024-01-09 21:43:00","snet_input_date":"2024-01-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-09 21:43:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:40.000000Z","updated_at":"2025-03-17T19:57:40.000000Z","inspection_violations":[{"id":7395560,"change_date":"2024-01-09 21:43:00","inspection_id":"80566961","insp_violation_id":"257253265","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198876788","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:41.000000Z","updated_at":"2025-03-17T21:41:41.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7711138,"change_date":"2024-01-09 21:43:00","inspection_id":"80566961","insp_unit_id":"198876788","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"336145","insp_unit_license":"2823038","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMML4LL123051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:56.000000Z","updated_at":"2025-03-17T23:04:56.000000Z"}]},{"id":4428727,"change_date":"2023-11-15 21:41:00","inspection_id":"80167522","dot_number":"2781752","report_state":"NY","report_number":"D103000050","insp_date":"2023-11-15 00:00:00","insp_start_time":"0957","insp_end_time":"1011","registration_date":null,"region":"ES","ci_status_code":"C","location":"20854W","location_desc":"VERONA NY","county_code_state":"NY","county_code":"065","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":"2023-11-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"96769","transaction_code":"A","transaction_date":"2023-11-15 00:00:00","upload_date":"2023-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":null,"census_search_date":"2023-11-15 21:41:00","snet_input_date":"2023-11-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-15 21:41:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:42.000000Z","updated_at":"2025-03-17T19:50:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7122185,"change_date":"2023-11-15 21:41:00","inspection_id":"80167522","insp_unit_id":"198068343","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"2823038","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMML4LL123051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:48.000000Z","updated_at":"2025-03-17T22:59:48.000000Z"}]},{"id":4370612,"change_date":"2023-11-07 21:40:00","inspection_id":"80102998","dot_number":"2781752","report_state":"NY","report_number":"SPT0541026","insp_date":"2023-11-06 00:00:00","insp_start_time":"1012","insp_end_time":"1031","registration_date":null,"region":"ET","ci_status_code":"C","location":"20854","location_desc":"VERONA","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BITZER SCROLL, 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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2884939","transaction_code":"A","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":"M","census_search_date":"2023-11-07 21:40:00","snet_input_date":"2023-11-07 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-07 21:40:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:32.000000Z","updated_at":"2025-03-17T19:49:32.000000Z","inspection_violations":[{"id":6761942,"change_date":"2023-11-07 21:40:00","inspection_id":"80102998","insp_violation_id":"256256692","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197940220","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:34.000000Z","updated_at":"2025-03-17T21:38:34.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":7029214,"change_date":"2023-11-07 21:40:00","inspection_id":"80102998","insp_unit_id":"197940220","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"336145","insp_unit_license":"2823038","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMML4LL123051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:59.000000Z","updated_at":"2025-03-17T22:58:59.000000Z"}]},{"id":3372198,"change_date":"2023-06-27 21:40:00","inspection_id":"78990333","dot_number":"2781752","report_state":"NY","report_number":"SPT0540636","insp_date":"2023-06-26 00:00:00","insp_start_time":"1050","insp_end_time":"1106","registration_date":null,"region":"ET","ci_status_code":"C","location":"20895","location_desc":"WESTMORELAND (EXIT 32)","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BITZER SCROLL, INC.","shipping_paper_number":"6262023","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-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2841532","transaction_code":"A","transaction_date":"2023-06-27 00:00:00","upload_date":"2023-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":"M","census_search_date":"2023-06-27 21:40:00","snet_input_date":"2023-06-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-27 21:40:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:46.000000Z","updated_at":"2025-03-17T19:29:46.000000Z","inspection_violations":[{"id":5200435,"change_date":"2023-06-27 21:40:00","inspection_id":"78990333","insp_violation_id":"253717368","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195689074","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:09.000000Z","updated_at":"2025-03-17T21:31:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5420779,"change_date":"2023-06-27 21:40:00","inspection_id":"78990333","insp_unit_id":"195689074","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"336145","insp_unit_license":"2823038","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMML4LL123051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:47.000000Z","updated_at":"2025-03-17T22:45:47.000000Z"}]},{"id":3049761,"change_date":"2023-05-16 21:41:00","inspection_id":"78626882","dot_number":"2781752","report_state":"NY","report_number":"SPC0205632","insp_date":"2023-05-15 00:00:00","insp_start_time":"1043","insp_end_time":"1107","registration_date":null,"region":"ET","ci_status_code":"C","location":"90356","location_desc":"GUILFORD","county_code_state":"NY","county_code":"017","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SQUARE ONE COATING SYSTEMS LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2825248","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":"M","census_search_date":"2023-05-16 21:41:00","snet_input_date":"2023-05-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-16 21:41:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:23.000000Z","updated_at":"2025-03-17T19:23:23.000000Z","inspection_violations":[{"id":4687399,"change_date":"2023-05-16 21:41:00","inspection_id":"78626882","insp_violation_id":"252847639","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"3922"},{"id":4687400,"change_date":"2023-05-16 21:41:00","inspection_id":"78626882","insp_violation_id":"252847640","seq_no":"2","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"194942457","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1GQWV6W","created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"39021B"}],"inspection_per_units":[{"id":4906323,"change_date":"2023-05-16 21:41:00","inspection_id":"78626882","insp_unit_id":"194942457","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"586226","insp_unit_license":"3258601","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC4PDNT2261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:41.000000Z","updated_at":"2025-03-17T22:41:41.000000Z"}]},{"id":2550124,"change_date":"2023-03-10 21:40:00","inspection_id":"78059554","dot_number":"2781752","report_state":"NY","report_number":"SPD0290632","insp_date":"2023-03-09 00:00:00","insp_start_time":"0850","insp_end_time":"0941","registration_date":null,"region":"ET","ci_status_code":"C","location":"20895","location_desc":"WESTMORELAND","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BITZER SCROLL INC","shipping_paper_number":"38313","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2805049","transaction_code":"A","transaction_date":"2023-03-10 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":"M","census_search_date":"2023-03-10 21:40:00","snet_input_date":"2023-03-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-10 21:40:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:42.000000Z","updated_at":"2025-03-17T19:13:42.000000Z","inspection_violations":[{"id":3922081,"change_date":"2023-03-10 21:40:00","inspection_id":"78059554","insp_violation_id":"251587268","seq_no":"1","part_no":"390","part_no_section":"21(e)","insp_viol_unit":"1","insp_unit_id":"193806419","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39021E"},{"id":3922082,"change_date":"2023-03-10 21:40:00","inspection_id":"78059554","insp_violation_id":"251587269","seq_no":"2","part_no":"393","part_no_section":"203(b)","insp_viol_unit":"1","insp_unit_id":"193806419","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8GHR7XW","created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"393203B"},{"id":3922083,"change_date":"2023-03-10 21:40:00","inspection_id":"78059554","insp_violation_id":"251587270","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4104405,"change_date":"2023-03-10 21:40:00","inspection_id":"78059554","insp_unit_id":"193806419","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"336145","insp_unit_license":"2823038","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMML4LL123051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:24.000000Z","updated_at":"2025-03-17T22:35:24.000000Z"}]},{"id":2453083,"change_date":"2023-02-27 21:41:00","inspection_id":"77949387","dot_number":"2781752","report_state":"NY","report_number":"SPT0540319","insp_date":"2023-02-20 00:00:00","insp_start_time":"1020","insp_end_time":"1037","registration_date":null,"region":"ET","ci_status_code":"C","location":"20895","location_desc":"WESTMORELAND (EXIT 32)","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BITZER SCROLL, INC.","shipping_paper_number":"2202023","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":"25999","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":"2802665","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":"02781752","upload_search_indicator":"M","census_search_date":"2023-02-27 21:41:00","snet_input_date":"2023-02-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-27 21:41:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","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":3947366,"change_date":"2023-02-27 21:41:00","inspection_id":"77949387","insp_unit_id":"193586420","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"336145","insp_unit_license":"2823038","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMML4LL123051","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":1815342,"change_date":"2022-11-28 21:40:00","inspection_id":"77220917","dot_number":"2781752","report_state":"NY","report_number":"SPT0461789","insp_date":"2022-11-23 00:00:00","insp_start_time":"1110","insp_end_time":"1125","registration_date":null,"region":"ET","ci_status_code":"C","location":"30223B","location_desc":"DEWITT (EXIT 35)","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SQUARE ONE COATING SYSTEMS LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-28 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":"2774401","transaction_code":"A","transaction_date":"2022-11-28 00:00:00","upload_date":"2022-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":"M","census_search_date":"2022-11-28 21:40:00","snet_input_date":"2022-11-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-28 21:40:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:01.000000Z","updated_at":"2025-03-17T19:00:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2919813,"change_date":"2022-11-28 21:40:00","inspection_id":"77220917","insp_unit_id":"192129095","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"37677NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWDTXEDFW4733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:58.000000Z","updated_at":"2025-03-17T22:26:58.000000Z"}]},{"id":993696,"change_date":"2022-08-09 21:40:00","inspection_id":"76270049","dot_number":"2781752","report_state":"NY","report_number":"SPT0461369","insp_date":"2022-08-08 00:00:00","insp_start_time":"0848","insp_end_time":"0903","registration_date":null,"region":"ET","ci_status_code":"C","location":"30223B","location_desc":"DEWITT (EXIT 35)","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SQUARE ONE COATING SYSTEMS LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-09 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":"2737099","transaction_code":"A","transaction_date":"2022-08-09 00:00:00","upload_date":"2022-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":"M","census_search_date":"2022-08-09 21:40:00","snet_input_date":"2022-08-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-09 21:40:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:07.000000Z","updated_at":"2025-03-17T18:45:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1598799,"change_date":"2022-08-09 21:40:00","inspection_id":"76270049","insp_unit_id":"190203997","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"37677NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWDTXEDFW4733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:04.000000Z","updated_at":"2025-03-17T22:18:04.000000Z"}]},{"id":654084,"change_date":"2022-06-21 21:41:00","inspection_id":"75872238","dot_number":"2781752","report_state":"NY","report_number":"SPT0345221","insp_date":"2022-06-16 00:00:00","insp_start_time":"0922","insp_end_time":"0937","registration_date":null,"region":"ET","ci_status_code":"C","location":"30223B","location_desc":"DEWITT (EXIT 35)","county_code_state":"NY","county_code":"067","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-21 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":"2718780","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02781752","upload_search_indicator":"M","census_search_date":"2022-06-21 21:41:00","snet_input_date":"2022-06-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-21 21:41:00","insp_carrier_name":"SQUARE ONE COATING SYSTEMS LLC","insp_carrier_street":"170 BASE ROAD","insp_carrier_city":"ORISKANY","insp_carrier_state":"NY","insp_carrier_zip_code":"13424","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:12.000000Z","updated_at":"2025-03-17T18:39:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1051247,"change_date":"2022-06-21 21:41:00","inspection_id":"75872238","insp_unit_id":"189363363","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"37677NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWDTXEDFW4733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:40.000000Z","updated_at":"2025-03-17T22:14:40.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2781752\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2781752\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2781752\/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\/2781752\/inspections","per_page":100,"prev_page_url":null,"to":26,"total":26}