{"current_page":1,"data":[{"id":12531766,"change_date":"2026-07-23 21:41:00","inspection_id":"88497840","dot_number":"1492847","report_state":"SC","report_number":"0364001497","insp_date":"2026-07-23 00:00:00","insp_start_time":"1011","insp_end_time":"1027","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"TOWNVILLE SC","county_code_state":"SC","county_code":"007","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"5418","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-07-23 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":"3821507","transaction_code":"A","transaction_date":"2026-07-23 00:00:00","upload_date":"2026-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2026-07-23 21:41:00","snet_input_date":"2026-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-23 21:41:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-26T09:42:27.000000Z","updated_at":"2026-08-02T09:32:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21762090,"change_date":"2026-07-23 21:41:00","inspection_id":"88497840","insp_unit_id":"214784850","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"04","insp_unit_license":"YXG829","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC3SHVM8051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-26T09:20:21.000000Z","updated_at":"2026-08-02T09:05:29.000000Z"}]},{"id":12430709,"change_date":"2026-07-13 21:39:00","inspection_id":"88389666","dot_number":"1492847","report_state":"GA","report_number":"1411000989","insp_date":"2026-07-10 00:00:00","insp_start_time":"0910","insp_end_time":"0935","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CARNESVILLE GA","county_code_state":"GA","county_code":"119","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-13 21:39: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":"3737756","transaction_code":"A","transaction_date":"2026-07-12 00:00:00","upload_date":"2026-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2026-07-13 21:39:00","snet_input_date":"2026-07-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-13 21:39:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-16T09:40:22.000000Z","updated_at":"2026-07-24T09:30:16.000000Z","inspection_violations":[{"id":21639835,"change_date":"2026-07-13 21:39:00","inspection_id":"88389666","insp_violation_id":"275458294","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E06083842","created_at":"2026-07-16T09:59:50.000000Z","updated_at":"2026-07-24T09:42:57.000000Z","normalized_code":"3922SLLCP"}],"inspection_per_units":[{"id":21593778,"change_date":"2026-07-13 21:39:00","inspection_id":"88389666","insp_unit_id":"214577523","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"556891","insp_unit_license":"3766327","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJHLDV6TLWH6996","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-16T09:16:26.000000Z","updated_at":"2026-07-24T09:01:24.000000Z"}]},{"id":12359884,"change_date":"2026-07-04 21:34:00","inspection_id":"88321391","dot_number":"1492847","report_state":"GA","report_number":"1480000189","insp_date":"2026-07-02 00:00:00","insp_start_time":"0807","insp_end_time":"0819","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ATLANTA GA","county_code_state":"GA","county_code":"121","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"79947","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-07-04 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":"3684310","transaction_code":"A","transaction_date":"2026-07-04 00:00:00","upload_date":"2026-07-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2026-07-04 21:34:00","snet_input_date":"2026-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-04 21:34:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-07T09:40:59.000000Z","updated_at":"2026-07-15T09:30:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21463606,"change_date":"2026-07-04 21:34:00","inspection_id":"88321391","insp_unit_id":"214449730","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"421177","insp_unit_license":"EVI062","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC5NHNK3057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-07T09:18:49.000000Z","updated_at":"2026-07-15T09:01:32.000000Z"}]},{"id":11333886,"change_date":"2026-03-10 21:38:00","inspection_id":"87251138","dot_number":"1492847","report_state":"NC","report_number":"0006855074","insp_date":"2026-03-10 00:00:00","insp_start_time":"0915","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":"US 23","location_desc":"US 23 AT INGLES PVA","county_code_state":"NC","county_code":"113","insp_level_id":"2","service_center":"SH","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":"2026-03-10 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":"2385280","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":"M","census_search_date":"2026-03-10 21:38:00","snet_input_date":"2026-03-10 00:00:00","source_office":"2NCS001","mcmis_add_date":"2026-03-10 21:38:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-13T09:43:46.000000Z","updated_at":"2026-03-21T09:31:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19393978,"change_date":"2026-03-10 21:38:00","inspection_id":"87251138","insp_unit_id":"212062955","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YPD096","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWRC6RHUV2103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:23.000000Z","updated_at":"2026-03-21T09:11:07.000000Z"}]},{"id":11183739,"change_date":"2026-02-20 21:38:00","inspection_id":"87093627","dot_number":"1492847","report_state":"GA","report_number":"1429001269","insp_date":"2026-02-17 00:00:00","insp_start_time":"1009","insp_end_time":"1021","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BRASELTON GA","county_code_state":"GA","county_code":"157","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-20 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2908664","transaction_code":"A","transaction_date":"2026-02-19 00:00:00","upload_date":"2026-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2026-02-20 21:38:00","snet_input_date":"2026-02-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-20 21:38:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-23T10:37:46.000000Z","updated_at":"2026-03-03T10:30:11.000000Z","inspection_violations":[{"id":18748536,"change_date":"2026-02-20 21:38:00","inspection_id":"87093627","insp_violation_id":"271908765","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-23T10:53:00.000000Z","updated_at":"2026-03-03T10:39:43.000000Z","normalized_code":"39141APC"},{"id":18748537,"change_date":"2026-02-20 21:38:00","inspection_id":"87093627","insp_violation_id":"271908766","seq_no":"2","part_no":"392","part_no_section":"2-SLLILC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-23T10:53:00.000000Z","updated_at":"2026-03-03T10:39:43.000000Z","normalized_code":"3922SLLILC"}],"inspection_per_units":[{"id":19096884,"change_date":"2026-02-20 21:38:00","inspection_id":"87093627","insp_unit_id":"211722461","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"04","insp_unit_license":"YXG829","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC3SHVM8051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-23T10:13:22.000000Z","updated_at":"2026-03-03T10:02:28.000000Z"}]},{"id":10841503,"change_date":"2026-01-23 21:38:00","inspection_id":"86869978","dot_number":"1492847","report_state":"GA","report_number":"1452001040","insp_date":"2026-01-20 00:00:00","insp_start_time":"1015","insp_end_time":"1035","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"JEFFERSON GA","county_code_state":"GA","county_code":"157","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"DRIVER #03","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-01-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2802503","transaction_code":"A","transaction_date":"2026-01-22 00:00:00","upload_date":"2026-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2026-01-23 21:38:00","snet_input_date":"2026-01-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-23 21:38:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-26T10:37:19.000000Z","updated_at":"2026-02-03T10:30:03.000000Z","inspection_violations":[{"id":18131495,"change_date":"2026-01-23 21:38:00","inspection_id":"86869978","insp_violation_id":"271380936","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E058706647","created_at":"2026-01-26T10:43:00.000000Z","updated_at":"2026-02-04T10:34:52.000000Z","normalized_code":"3922SLLCP"},{"id":18131496,"change_date":"2026-01-23 21:38:00","inspection_id":"86869978","insp_violation_id":"271380937","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-26T10:43:00.000000Z","updated_at":"2026-02-04T10:34:52.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":18214283,"change_date":"2026-01-23 21:38:00","inspection_id":"86869978","insp_unit_id":"211250171","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"03","insp_unit_license":"TDD2645","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FDXE4FS8JDC03465","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-26T10:09:47.000000Z","updated_at":"2026-02-03T10:02:09.000000Z"}]},{"id":10777702,"change_date":"2026-01-15 21:41:00","inspection_id":"86803258","dot_number":"1492847","report_state":"US","report_number":"2021000037","insp_date":"2026-01-14 00:00:00","insp_start_time":"1100","insp_end_time":"1126","registration_date":null,"region":"ES","ci_status_code":"C","location":"270","location_desc":"LAVONIA GA","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"ALLIANCE SUPPLY","shipping_paper_number":"76367","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: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":"2771658","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2026-01-15 21:41:00","snet_input_date":"2026-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-15 21:41:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-18T10:45:05.000000Z","updated_at":"2026-01-26T10:30:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18094267,"change_date":"2026-01-15 21:41:00","inspection_id":"86803258","insp_unit_id":"211108566","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YXG829","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC3SHVM8051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:16:55.000000Z","updated_at":"2026-01-26T10:00:53.000000Z"}]},{"id":9246620,"change_date":"2025-07-25 21:39:00","inspection_id":"85318174","dot_number":"1492847","report_state":"US","report_number":"1604000140","insp_date":"2025-07-25 00:00:00","insp_start_time":"1141","insp_end_time":"1207","registration_date":null,"region":"ED","ci_status_code":"C","location":"269","location_desc":"LAVONIA GA","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"ALLIANCE SUPPLY AND PIPING","shipping_paper_number":"73279","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-25 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":"2042396","transaction_code":"A","transaction_date":"2025-07-25 00:00:00","upload_date":"2025-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2025-07-25 21:39:00","snet_input_date":"2025-07-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-25 21:39:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-30T10:01:16.000000Z","updated_at":"2025-07-30T10:01:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15216644,"change_date":"2025-07-25 21:39:00","inspection_id":"85318174","insp_unit_id":"208077425","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YPD096","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC6RHUV2103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-28T09:46:32.000000Z","updated_at":"2025-07-29T09:45:34.000000Z"}]},{"id":9246666,"change_date":"2025-07-25 21:39:00","inspection_id":"85318226","dot_number":"1492847","report_state":"US","report_number":"1604000128","insp_date":"2025-07-24 00:00:00","insp_start_time":"1053","insp_end_time":"1103","registration_date":null,"region":"ED","ci_status_code":"C","location":"270","location_desc":"LAVONIA GA","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"ALLIANCE SUPPLY AND PIPING LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-25 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":"2042383","transaction_code":"A","transaction_date":"2025-07-25 00:00:00","upload_date":"2025-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2025-07-25 21:39:00","snet_input_date":"2025-07-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-25 21:39:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-30T10:01:16.000000Z","updated_at":"2025-07-30T10:01:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15216722,"change_date":"2025-07-25 21:39:00","inspection_id":"85318226","insp_unit_id":"208077517","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"EV10060","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC7NHNK3058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-28T09:46:32.000000Z","updated_at":"2025-07-29T09:45:34.000000Z"}]},{"id":8811562,"change_date":"2025-06-04 21:40:00","inspection_id":"84858978","dot_number":"1492847","report_state":"SC","report_number":"0286005870","insp_date":"2025-06-03 00:00:00","insp_start_time":"0851","insp_end_time":"0911","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"FAIR PLAY SC","county_code_state":"SC","county_code":"073","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ALLIANCEE SUPPLY AND PIPING","shipping_paper_number":"72182","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-06-04 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":"1819295","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2025-06-04 21:40:00","snet_input_date":"2025-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-04 21:40:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-07T10:00:57.000000Z","updated_at":"2025-06-09T10:00:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14423329,"change_date":"2025-06-04 21:40:00","inspection_id":"84858978","insp_unit_id":"207215237","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"4","insp_unit_license":"YXG829","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC3SHVM8051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:10.000000Z","updated_at":"2025-06-08T09:45:18.000000Z"}]},{"id":8566375,"change_date":"2025-05-07 21:43:00","inspection_id":"84600235","dot_number":"1492847","report_state":"SC","report_number":"0399000497","insp_date":"2025-05-06 00:00:00","insp_start_time":"1009","insp_end_time":"1030","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ANDERSON SC","county_code_state":"SC","county_code":"007","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ALLIANCE SUPPLY AND PIPING LLC","shipping_paper_number":"26-9769","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-07 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"1695819","transaction_code":"A","transaction_date":"2025-05-07 00:00:00","upload_date":"2025-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2025-05-07 21:43:00","snet_input_date":"2025-05-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-07 21:43:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-10T10:52:22.000000Z","updated_at":"2025-05-11T10:11:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13938437,"change_date":"2025-05-07 21:43:00","inspection_id":"84600235","insp_unit_id":"206679843","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"4","insp_unit_license":"XYG829","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC3SHVM8051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:15:44.000000Z","updated_at":"2025-05-11T02:52:29.000000Z"}]},{"id":8165695,"change_date":"2025-03-20 21:41:00","inspection_id":"84178123","dot_number":"1492847","report_state":"SC","report_number":"0364000362","insp_date":"2025-03-20 00:00:00","insp_start_time":"1112","insp_end_time":"1153","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"TOWNVILLE SC","county_code_state":"SC","county_code":"007","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ALLIANCE SUPPLY","shipping_paper_number":"03\/20\/2025","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1494698","transaction_code":"A","transaction_date":"2025-03-20 00:00:00","upload_date":"2025-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2025-03-20 21:41:00","snet_input_date":"2025-03-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-20 21:41:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-23T10:47:17.000000Z","updated_at":"2025-03-24T10:24:37.000000Z","inspection_violations":[{"id":12789380,"change_date":"2025-03-20 21:41:00","inspection_id":"84178123","insp_violation_id":"265150766","seq_no":"1","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"205898908","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-22T11:04:20.000000Z","updated_at":"2025-03-23T11:33:11.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":13194799,"change_date":"2025-03-20 21:41:00","inspection_id":"84178123","insp_unit_id":"205898908","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"01","insp_unit_license":"EVI062","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC5NHNK3057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:11:48.000000Z","updated_at":"2025-03-24T09:57:27.000000Z"}]},{"id":8066446,"change_date":"2025-03-10 21:38:00","inspection_id":"84073681","dot_number":"1492847","report_state":"GA","report_number":"1384000774","insp_date":"2025-03-03 00:00:00","insp_start_time":"0915","insp_end_time":"0945","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"CARTERSVILLE GA","county_code_state":"GA","county_code":"015","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ALLIANCE SUPPLY AND PIPING LLC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-10 21:38: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1449942","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2025-03-10 21:38:00","snet_input_date":"2025-03-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-10 21:38:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:50.000000Z","updated_at":"2025-03-17T21:05:50.000000Z","inspection_violations":[{"id":12607044,"change_date":"2025-03-10 21:38:00","inspection_id":"84073681","insp_violation_id":"264913262","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:42.000000Z","updated_at":"2025-03-17T22:07:42.000000Z","normalized_code":"3922SLLCP"}],"inspection_per_units":[{"id":13024307,"change_date":"2025-03-10 21:38:00","inspection_id":"84073681","insp_unit_id":"205702934","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"01","insp_unit_license":"EVI062","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC5NHNK3057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:54.000000Z","updated_at":"2025-03-17T23:58:54.000000Z"}]},{"id":8004828,"change_date":"2025-03-03 21:37:00","inspection_id":"84008815","dot_number":"1492847","report_state":"US","report_number":"1897000057","insp_date":"2025-02-27 00:00:00","insp_start_time":"1313","insp_end_time":"1329","registration_date":null,"region":"ES","ci_status_code":"C","location":"269","location_desc":"LAVONIA GA","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","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-03-03 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25550","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":"1421158","transaction_code":"A","transaction_date":"2025-03-03 00:00:00","upload_date":"2025-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2025-03-03 21:37:00","snet_input_date":"2025-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-03 21:37:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:28.000000Z","updated_at":"2025-03-17T21:04:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12923301,"change_date":"2025-03-03 21:37:00","inspection_id":"84008815","insp_unit_id":"205585445","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"EV1062","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC5NHLV3057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:44.000000Z","updated_at":"2025-03-17T23:57:44.000000Z"}]},{"id":6841596,"change_date":"2024-09-28 21:33:00","inspection_id":"82782454","dot_number":"1492847","report_state":"GA","report_number":"1230000028","insp_date":"2024-09-24 00:00:00","insp_start_time":"1022","insp_end_time":"1034","registration_date":null,"region":"ED","ci_status_code":"C","location":"270","location_desc":"LAVONIA GA","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"ALLIANCE","shipping_paper_number":"67456","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-28 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"892758","transaction_code":"A","transaction_date":"2024-09-28 00:00:00","upload_date":"2024-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2024-09-28 21:33:00","snet_input_date":"2024-09-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-28 21:33:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:57.000000Z","updated_at":"2025-03-17T20:38:57.000000Z","inspection_violations":[{"id":10656989,"change_date":"2024-09-28 21:33:00","inspection_id":"82782454","insp_violation_id":"262082753","seq_no":"1","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"203173502","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:35.000000Z","updated_at":"2025-03-17T21:57:35.000000Z","normalized_code":"39353B"},{"id":10656990,"change_date":"2024-09-28 21:33:00","inspection_id":"82782454","insp_violation_id":"262082754","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"203173502","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:35.000000Z","updated_at":"2025-03-17T21:57:35.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":11033087,"change_date":"2024-09-28 21:33:00","inspection_id":"82782454","insp_unit_id":"203173502","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"04","insp_unit_license":"YXG829","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC3SHVM8051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:15.000000Z","updated_at":"2025-03-17T23:37:15.000000Z"}]},{"id":6519842,"change_date":"2024-08-21 21:41:00","inspection_id":"82439764","dot_number":"1492847","report_state":"GA","report_number":"1356000546","insp_date":"2024-08-15 00:00:00","insp_start_time":"0515","insp_end_time":"0555","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CARNESVILLE GA","county_code_state":"GA","county_code":"119","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ALLIANCE SUPPLY & PIPING","shipping_paper_number":"66847","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-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":"764321","transaction_code":"A","transaction_date":"2024-08-21 00:00:00","upload_date":"2024-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2024-08-21 21:41:00","snet_input_date":"2024-08-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-21 21:41:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:01.000000Z","updated_at":"2025-03-17T20:32:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10510461,"change_date":"2024-08-21 21:41:00","inspection_id":"82439764","insp_unit_id":"202497330","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"0148","insp_unit_license":"2629683","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"5PVNJ7AV9P5T51847","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:53.000000Z","updated_at":"2025-03-17T23:31:53.000000Z"}]},{"id":6521101,"change_date":"2024-08-21 21:41:00","inspection_id":"82441119","dot_number":"1492847","report_state":"GA","report_number":"0395000342","insp_date":"2024-08-14 00:00:00","insp_start_time":"1025","insp_end_time":"1115","registration_date":null,"region":"ED","ci_status_code":"C","location":"274","location_desc":"GROVETOWN GA","county_code_state":"GA","county_code":"073","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-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":"765745","transaction_code":"A","transaction_date":"2024-08-21 00:00:00","upload_date":"2024-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2024-08-21 21:41:00","snet_input_date":"2024-08-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-21 21:41:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:19.000000Z","updated_at":"2025-03-17T20:32:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10512509,"change_date":"2024-08-21 21:41:00","inspection_id":"82441119","insp_unit_id":"202499577","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"07","insp_unit_license":"YPD096","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC6RHUV2103","insp_unit_decal":"Y","insp_unit_decal_number":"34291160","created_at":"2025-03-17T23:31:53.000000Z","updated_at":"2025-03-17T23:31:53.000000Z"}]},{"id":5919355,"change_date":"2024-06-07 21:38:00","inspection_id":"81794847","dot_number":"1492847","report_state":"SC","report_number":"G372000715","insp_date":"2024-06-05 00:00:00","insp_start_time":"1120","insp_end_time":"1145","registration_date":"2024-06-07 00:00:00","region":"ET","ci_status_code":"C","location":"002","location_desc":"I-85 NB CONEE COUNTY","county_code_state":"SC","county_code":"073","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"ALLIANCE SUPPLY AND PIPING 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":"N","pen_cen_match":null,"final_status_date":"2024-06-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1147706","transaction_code":"C","transaction_date":"2024-06-05 00:00:00","upload_date":"2024-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2024-06-05 21:42:00","snet_input_date":"2024-06-05 00:00:00","source_office":"2SCS001","mcmis_add_date":"2024-06-05 21:42:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:53.000000Z","updated_at":"2025-03-17T20:19:53.000000Z","inspection_violations":[{"id":9178789,"change_date":"2024-06-07 21:38:00","inspection_id":"81794847","insp_violation_id":"259963633","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201284451","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"3939A"},{"id":9178790,"change_date":"2024-06-07 21:38:00","inspection_id":"81794847","insp_violation_id":"259963634","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201284451","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"3939A"},{"id":9178791,"change_date":"2024-06-07 21:38:00","inspection_id":"81794847","insp_violation_id":"259963635","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"201284451","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"39378"},{"id":9178792,"change_date":"2024-06-07 21:38:00","inspection_id":"81794847","insp_violation_id":"259963636","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201284451","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9534062,"change_date":"2024-06-07 21:38:00","inspection_id":"81794847","insp_unit_id":"201284451","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"XC1202","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3ALACWFCXKDKV9089","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":5639044,"change_date":"2024-05-01 21:42:00","inspection_id":"81490536","dot_number":"1492847","report_state":"GA","report_number":"1242000112","insp_date":"2024-04-25 00:00:00","insp_start_time":"1432","insp_end_time":"1450","registration_date":null,"region":"ED","ci_status_code":"C","location":"269","location_desc":"FRANKLIN CO I\/S NB","county_code_state":"GA","county_code":"119","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"443461","transaction_code":"A","transaction_date":"2024-05-01 00:00:00","upload_date":"2024-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2024-05-01 21:42:00","snet_input_date":"2024-04-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-01 21:42:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:21.000000Z","updated_at":"2025-03-17T20:14:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9083217,"change_date":"2024-05-01 21:42:00","inspection_id":"81490536","insp_unit_id":"200663141","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"206784","insp_unit_license":"3356225","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EH2PN339882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:30.000000Z","updated_at":"2025-03-17T23:17:30.000000Z"},{"id":9083218,"change_date":"2024-05-01 21:42:00","inspection_id":"81490536","insp_unit_id":"200663142","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"208935","insp_unit_license":"YHY872","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1UYVS2533P7945901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:30.000000Z","updated_at":"2025-03-17T23:17:30.000000Z"}]},{"id":5023802,"change_date":"2024-02-10 21:32:00","inspection_id":"80819450","dot_number":"1492847","report_state":"GA","report_number":"1310000043","insp_date":"2024-02-02 00:00:00","insp_start_time":"1015","insp_end_time":"1100","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"LITHIA SPRINGS GA","county_code_state":"GA","county_code":"097","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-02-10 21:32: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":"232673","transaction_code":"A","transaction_date":"2024-02-10 00:00:00","upload_date":"2024-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2024-02-10 21:32:00","snet_input_date":"2024-02-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-10 21:32:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:21.000000Z","updated_at":"2025-03-17T20:02:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8086107,"change_date":"2024-02-10 21:32:00","inspection_id":"80819450","insp_unit_id":"199365721","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"07","insp_unit_license":"YPD096","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC6RHUV2103","insp_unit_decal":"Y","insp_unit_decal_number":"33655875","created_at":"2025-03-17T23:08:17.000000Z","updated_at":"2025-03-17T23:08:17.000000Z"}]},{"id":4619326,"change_date":"2023-12-13 21:42:00","inspection_id":"80377105","dot_number":"1492847","report_state":"GA","report_number":"1419000699","insp_date":"2023-12-05 00:00:00","insp_start_time":"0947","insp_end_time":"1013","registration_date":"2023-12-13 00:00:00","region":"ET","ci_status_code":"C","location":"HCC","location_desc":"HIGH CRASH CORRIDOR","county_code_state":"GA","county_code":"097","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"3658","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-12-13 21:42: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":"2014949","transaction_code":"A","transaction_date":"2023-12-05 00:00:00","upload_date":"2023-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2023-12-13 21:42:00","snet_input_date":"2023-12-12 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-12-13 21:42:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:14.000000Z","updated_at":"2025-03-17T19:54:14.000000Z","inspection_violations":[{"id":7142072,"change_date":"2023-12-13 21:42:00","inspection_id":"80377105","insp_violation_id":"256861101","seq_no":"1","part_no":"393","part_no_section":"80","insp_viol_unit":"1","insp_unit_id":"198483687","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:32.000000Z","updated_at":"2025-03-17T21:40:32.000000Z","normalized_code":"39380"}],"inspection_per_units":[{"id":7429682,"change_date":"2023-12-13 21:42:00","inspection_id":"80377105","insp_unit_id":"198483687","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"EVI060","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC7NHNK3058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:26.000000Z","updated_at":"2025-03-17T23:02:26.000000Z"}]},{"id":4057974,"change_date":"2023-09-26 21:42:00","inspection_id":"79757207","dot_number":"1492847","report_state":"GA","report_number":"1369003785","insp_date":"2023-09-07 00:00:00","insp_start_time":"0945","insp_end_time":"1005","registration_date":"2023-09-19 00:00:00","region":"ET","ci_status_code":"C","location":"HCC","location_desc":"HIGH CRASH CORRIDOR","county_code_state":"GA","county_code":"119","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"2000951","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2023-09-26 21:42:00","snet_input_date":"2023-09-18 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-09-26 21:42:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:51.000000Z","updated_at":"2025-03-17T19:42:51.000000Z","inspection_violations":[{"id":6281824,"change_date":"2023-09-26 21:42:00","inspection_id":"79757207","insp_violation_id":"255486452","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:36:19.000000Z","updated_at":"2025-03-17T21:36:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6524333,"change_date":"2023-09-26 21:42:00","inspection_id":"79757207","insp_unit_id":"197241412","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"206784","insp_unit_license":"3356225","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EH2PN339882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:44.000000Z","updated_at":"2025-03-17T22:54:44.000000Z"},{"id":6524334,"change_date":"2023-09-26 21:42:00","inspection_id":"79757207","insp_unit_id":"197241413","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"208935","insp_unit_license":"YHY872","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1UYVS2533P7945901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:44.000000Z","updated_at":"2025-03-17T22:54:44.000000Z"}]},{"id":3897402,"change_date":"2023-09-05 21:40:00","inspection_id":"79578737","dot_number":"1492847","report_state":"GA","report_number":"0115002311","insp_date":"2023-08-31 00:00:00","insp_start_time":"1115","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":"269","location_desc":"FRANKLIN CO I\/S NB","county_code_state":"GA","county_code":"119","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-05 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":"1998090","transaction_code":"A","transaction_date":"2023-08-31 00:00:00","upload_date":"2023-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2023-09-05 21:40:00","snet_input_date":"2023-09-01 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-09-05 21:40:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:46.000000Z","updated_at":"2025-03-17T19:39:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6265966,"change_date":"2023-09-05 21:40:00","inspection_id":"79578737","insp_unit_id":"196884889","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421177","insp_unit_license":"EVI062","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC5NHNK3057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:39.000000Z","updated_at":"2025-03-17T22:52:39.000000Z"}]},{"id":3865176,"change_date":"2023-08-30 21:44:00","inspection_id":"79542834","dot_number":"1492847","report_state":"GA","report_number":"1242004704","insp_date":"2023-08-24 00:00:00","insp_start_time":"1200","insp_end_time":"1237","registration_date":null,"region":"ET","ci_status_code":"C","location":"269","location_desc":"FRANKLIN CO I\/S NB","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-30 21:44: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":"1996760","transaction_code":"A","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2023-08-30 21:44:00","snet_input_date":"2023-08-29 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-08-30 21:44:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:21.000000Z","updated_at":"2025-03-17T19:39:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6213945,"change_date":"2023-08-30 21:44:00","inspection_id":"79542834","insp_unit_id":"196805030","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"EVI060","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC7NHNK3058","insp_unit_decal":"Y","insp_unit_decal_number":"33011360","created_at":"2025-03-17T22:52:12.000000Z","updated_at":"2025-03-17T22:52:12.000000Z"}]},{"id":3444772,"change_date":"2023-07-11 21:41:00","inspection_id":"79071791","dot_number":"1492847","report_state":"GA","report_number":"1429000283","insp_date":"2023-06-30 00:00:00","insp_start_time":"1221","insp_end_time":"1252","registration_date":"2023-07-11 00:00:00","region":"ET","ci_status_code":"C","location":"269","location_desc":"FRANKLIN CO I\/S NB","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-07-06 21:42: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":"1984287","transaction_code":"C","transaction_date":"2023-06-30 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2023-07-06 21:42:00","snet_input_date":"2023-07-05 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-07-06 21:42:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:18.000000Z","updated_at":"2025-03-17T19:31:18.000000Z","inspection_violations":[{"id":5311628,"change_date":"2023-07-11 21:41:00","inspection_id":"79071791","insp_violation_id":"253981885","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195928336","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:39.000000Z","updated_at":"2025-03-17T21:31:39.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5539115,"change_date":"2023-07-11 21:41:00","inspection_id":"79071791","insp_unit_id":"195928336","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6","insp_unit_license":"EVI060","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC7NHNK3058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:43.000000Z","updated_at":"2025-03-17T22:46:43.000000Z"}]},{"id":3396085,"change_date":"2023-06-29 21:42:00","inspection_id":"79017275","dot_number":"1492847","report_state":"GA","report_number":"1242004631","insp_date":"2023-06-14 00:00:00","insp_start_time":"1047","insp_end_time":"1107","registration_date":null,"region":"ET","ci_status_code":"C","location":"269","location_desc":"FRANKLIN CO I\/S NB","county_code_state":"GA","county_code":"119","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1980318","transaction_code":"A","transaction_date":"2023-06-14 00:00:00","upload_date":"2023-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2023-06-29 21:42:00","snet_input_date":"2023-06-14 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-06-29 21:42:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:12.000000Z","updated_at":"2025-03-17T19:30:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5459772,"change_date":"2023-06-29 21:42:00","inspection_id":"79017275","insp_unit_id":"195743633","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"03","insp_unit_license":"TDD2645","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FDXE4FS8JDC03465","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:03.000000Z","updated_at":"2025-03-17T22:46:03.000000Z"}]},{"id":3104039,"change_date":"2023-05-27 21:31:00","inspection_id":"78687837","dot_number":"1492847","report_state":"GA","report_number":"1429000198","insp_date":"2023-05-19 00:00:00","insp_start_time":"1553","insp_end_time":"1602","registration_date":"2023-05-26 00:00:00","region":"ET","ci_status_code":"C","location":"HCC","location_desc":"HIGH CRASH CORRIDOR","county_code_state":"GA","county_code":"137","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"EMPTY","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"5","oos_total":"0","driver_viol_total":"5","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1974969","transaction_code":"C","transaction_date":"2023-05-19 00:00:00","upload_date":"2023-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2023-05-22 21:40:00","snet_input_date":"2023-05-22 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-05-22 21:40:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:33.000000Z","updated_at":"2025-03-17T19:24:33.000000Z","inspection_violations":[{"id":4775342,"change_date":"2023-05-27 21:31:00","inspection_id":"78687837","insp_violation_id":"253118521","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":"E04557387","created_at":"2025-03-17T21:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"3922"},{"id":4775343,"change_date":"2023-05-27 21:31:00","inspection_id":"78687837","insp_violation_id":"253118522","seq_no":"2","part_no":"395","part_no_section":"22(h)(1)","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:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"39522H1"},{"id":4775344,"change_date":"2023-05-27 21:31:00","inspection_id":"78687837","insp_violation_id":"253118523","seq_no":"3","part_no":"395","part_no_section":"22(h)(2)","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:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"39522H2"},{"id":4775345,"change_date":"2023-05-27 21:31:00","inspection_id":"78687837","insp_violation_id":"253118524","seq_no":"4","part_no":"395","part_no_section":"22(h)(3)","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:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"39522H3"},{"id":4775346,"change_date":"2023-05-27 21:31:00","inspection_id":"78687837","insp_violation_id":"253118525","seq_no":"5","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:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":4992417,"change_date":"2023-05-27 21:31:00","inspection_id":"78687837","insp_unit_id":"195174872","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"03","insp_unit_license":"TDD2645","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FDXE4FS8JDC03465","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:22.000000Z","updated_at":"2025-03-17T22:42:22.000000Z"}]},{"id":2796056,"change_date":"2023-04-19 21:42:00","inspection_id":"78339677","dot_number":"1492847","report_state":"GA","report_number":"1429000087","insp_date":"2023-04-07 00:00:00","insp_start_time":"1154","insp_end_time":"1222","registration_date":"2023-04-17 00:00:00","region":"ET","ci_status_code":"C","location":"269","location_desc":"FRANKLIN CO I\/S NB","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"PRECISION DUCT SYSTEMS, LLC","shipping_paper_number":"PS23-8758","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-04-13 21:42: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":"1964794","transaction_code":"C","transaction_date":"2023-04-07 00:00:00","upload_date":"2023-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2023-04-13 21:42:00","snet_input_date":"2023-04-12 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-04-13 21:42:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:07.000000Z","updated_at":"2025-03-17T19:18:07.000000Z","inspection_violations":[{"id":4291373,"change_date":"2023-04-19 21:42:00","inspection_id":"78339677","insp_violation_id":"252312283","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194470272","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":4499760,"change_date":"2023-04-19 21:42:00","inspection_id":"78339677","insp_unit_id":"194470272","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6","insp_unit_license":"EVI060","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC7NHNK3058","insp_unit_decal":"Y","insp_unit_decal_number":"32641812","created_at":"2025-03-17T22:38:28.000000Z","updated_at":"2025-03-17T22:38:28.000000Z"}]},{"id":2432468,"change_date":"2023-02-23 21:40:00","inspection_id":"77926063","dot_number":"1492847","report_state":"GA","report_number":"0000481112","insp_date":"2023-02-13 00:00:00","insp_start_time":"1348","insp_end_time":"1500","registration_date":null,"region":"ET","ci_status_code":"C","location":"269","location_desc":"FRANKLIN CO I\/S NB","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-23 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":"1955226","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2023-02-23 21:40:00","snet_input_date":"2023-02-23 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-02-23 21:40:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:27.000000Z","updated_at":"2025-03-17T19:11:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3914348,"change_date":"2023-02-23 21:40:00","inspection_id":"77926063","insp_unit_id":"193538931","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"XC1202","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3ALACWFCXKDKV9089","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:01.000000Z","updated_at":"2025-03-17T22:34:01.000000Z"}]},{"id":2043118,"change_date":"2022-12-30 21:36:00","inspection_id":"77481108","dot_number":"1492847","report_state":"GA","report_number":"1369003069","insp_date":"2022-12-29 00:00:00","insp_start_time":"1157","insp_end_time":"1207","registration_date":null,"region":"ET","ci_status_code":"C","location":"E","location_desc":"TWO LANE RURAL ROAD","county_code_state":"GA","county_code":"147","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-30 21:36: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":"1943238","transaction_code":"A","transaction_date":"2022-12-29 00:00:00","upload_date":"2022-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2022-12-30 21:36:00","snet_input_date":"2022-12-30 00:00:00","source_office":"2GAS001","mcmis_add_date":"2022-12-30 21:36:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:21.000000Z","updated_at":"2025-03-17T19:04:21.000000Z","inspection_violations":[{"id":3165974,"change_date":"2022-12-30 21:36:00","inspection_id":"77481108","insp_violation_id":"250329262","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","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:22:00.000000Z","updated_at":"2025-03-17T21:22:00.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":3286548,"change_date":"2022-12-30 21:36:00","inspection_id":"77481108","insp_unit_id":"192643442","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4","insp_unit_license":"XCI202","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3ALACWFCXKDKV9089","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:32.000000Z","updated_at":"2025-03-17T22:29:32.000000Z"}]},{"id":1887986,"change_date":"2022-12-07 21:40:00","inspection_id":"77303909","dot_number":"1492847","report_state":"GA","report_number":"0396002794","insp_date":"2022-12-06 00:00:00","insp_start_time":"1330","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":"A","location_desc":"INTERSTATE HWY","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-07 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":"1937471","transaction_code":"A","transaction_date":"2022-12-06 00:00:00","upload_date":"2022-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2022-12-07 21:40:00","snet_input_date":"2022-12-06 00:00:00","source_office":"2GAS001","mcmis_add_date":"2022-12-07 21:40:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:29.000000Z","updated_at":"2025-03-17T19:01:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3038322,"change_date":"2022-12-07 21:40:00","inspection_id":"77303909","insp_unit_id":"192297598","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01","insp_unit_license":"EVI062","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC5NHNK3057","insp_unit_decal":"Y","insp_unit_decal_number":"31961170","created_at":"2025-03-17T22:27:48.000000Z","updated_at":"2025-03-17T22:27:48.000000Z"}]},{"id":1849077,"change_date":"2022-12-01 21:41:00","inspection_id":"77259300","dot_number":"1492847","report_state":"GA","report_number":"1356002289","insp_date":"2022-11-30 00:00:00","insp_start_time":"0945","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"270","location_desc":"FRANKLIN CO I\/S SB","county_code_state":"GA","county_code":"119","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"ALLIANCE SUPPLY AND PIPING LLC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1936674","transaction_code":"A","transaction_date":"2022-11-30 00:00:00","upload_date":"2022-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2022-12-01 21:41:00","snet_input_date":"2022-12-01 00:00:00","source_office":"2GAS001","mcmis_add_date":"2022-12-01 21:41:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:44.000000Z","updated_at":"2025-03-17T19:00:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2975055,"change_date":"2022-12-01 21:41:00","inspection_id":"77259300","insp_unit_id":"192206735","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4","insp_unit_license":"XCI202","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3ALACWFCXKDKV9089","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:23.000000Z","updated_at":"2025-03-17T22:27:23.000000Z"}]},{"id":1831818,"change_date":"2022-11-29 21:40:00","inspection_id":"77239648","dot_number":"1492847","report_state":"GA","report_number":"0397002632","insp_date":"2022-11-29 00:00:00","insp_start_time":"1029","insp_end_time":"1101","registration_date":null,"region":"ET","ci_status_code":"C","location":"C","location_desc":"MULTI-LANE RURAL HIGHWAY","county_code_state":"GA","county_code":"257","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1935846","transaction_code":"A","transaction_date":"2022-11-29 00:00:00","upload_date":"2022-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2022-11-29 21:40:00","snet_input_date":"2022-11-29 00:00:00","source_office":"2GAS001","mcmis_add_date":"2022-11-29 21:40:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:22.000000Z","updated_at":"2025-03-17T19:00:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2946988,"change_date":"2022-11-29 21:40:00","inspection_id":"77239648","insp_unit_id":"192165750","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"03","insp_unit_license":"TDD2645","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FDXE4FS8JDC03465","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:10.000000Z","updated_at":"2025-03-17T22:27:10.000000Z"}]},{"id":1569894,"change_date":"2022-10-21 21:39:00","inspection_id":"76939201","dot_number":"1492847","report_state":"GA","report_number":"0396002698","insp_date":"2022-10-21 00:00:00","insp_start_time":"0930","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":"269","location_desc":"FRANKLIN CO I\/S NB","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"PS22-7578","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":"I","final_status_date":"2022-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1927528","transaction_code":"A","transaction_date":"2022-10-21 00:00:00","upload_date":"2022-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2022-10-21 21:39:00","snet_input_date":"2022-10-21 00:00:00","source_office":"2GAS001","mcmis_add_date":"2022-10-21 21:39:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:35.000000Z","updated_at":"2025-03-17T18:55:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2526307,"change_date":"2022-10-21 21:39:00","inspection_id":"76939201","insp_unit_id":"191569739","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"03","insp_unit_license":"TDD2645","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FDXE4FS8JDC03465","insp_unit_decal":"Y","insp_unit_decal_number":"31961221","created_at":"2025-03-17T22:24:19.000000Z","updated_at":"2025-03-17T22:24:19.000000Z"}]},{"id":1398289,"change_date":"2022-09-29 21:40:00","inspection_id":"76740612","dot_number":"1492847","report_state":"GA","report_number":"1333001619","insp_date":"2022-09-29 00:00:00","insp_start_time":"0919","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":"269","location_desc":"FRANKLIN CO I\/S NB","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","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":"2022-09-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1922817","transaction_code":"A","transaction_date":"2022-09-29 00:00:00","upload_date":"2022-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2022-09-29 21:40:00","snet_input_date":"2022-09-29 00:00:00","source_office":"2GAS001","mcmis_add_date":"2022-09-29 21:40:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:23.000000Z","updated_at":"2025-03-17T18:52:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2251205,"change_date":"2022-09-29 21:40:00","inspection_id":"76740612","insp_unit_id":"191170057","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"03","insp_unit_license":"TDD2645","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FDXE4FS8JDC03465","insp_unit_decal":"Y","insp_unit_decal_number":"NODECAL","created_at":"2025-03-17T22:22:25.000000Z","updated_at":"2025-03-17T22:22:25.000000Z"}]},{"id":1060959,"change_date":"2022-08-17 21:40:00","inspection_id":"76348798","dot_number":"1492847","report_state":"GA","report_number":"2008480345","insp_date":"2022-08-08 00:00:00","insp_start_time":"0945","insp_end_time":"1019","registration_date":null,"region":"ET","ci_status_code":"C","location":"269","location_desc":"FRANKLIN CO I\/S NB","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-17 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":"1912392","transaction_code":"A","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2022-08-17 21:40:00","snet_input_date":"2022-08-16 00:00:00","source_office":"2GAS001","mcmis_add_date":"2022-08-17 21:40:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:29.000000Z","updated_at":"2025-03-17T18:46:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1706984,"change_date":"2022-08-17 21:40:00","inspection_id":"76348798","insp_unit_id":"190365858","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6","insp_unit_license":"EVI060","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC7NHNK3058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:46.000000Z","updated_at":"2025-03-17T22:18:46.000000Z"}]},{"id":912701,"change_date":"2022-07-28 21:40:00","inspection_id":"76174976","dot_number":"1492847","report_state":"SC","report_number":"S363000134","insp_date":"2022-07-27 00:00:00","insp_start_time":"0946","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":"107","location_desc":"I-85 NB ROADSIDE","county_code_state":"SC","county_code":"007","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ANDERSON WINNELSON","shipping_paper_number":"644053523","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-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":"1042974","transaction_code":"A","transaction_date":"2022-07-27 00:00:00","upload_date":"2022-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2022-07-28 21:40:00","snet_input_date":"2022-07-27 00:00:00","source_office":"2SCS001","mcmis_add_date":"2022-07-28 21:40:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:44.000000Z","updated_at":"2025-03-17T18:43:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1468940,"change_date":"2022-07-28 21:40:00","inspection_id":"76174976","insp_unit_id":"190010806","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"XC1202","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3ALACWFCXKDKV9089","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:14.000000Z","updated_at":"2025-03-17T22:17:14.000000Z"}]},{"id":486708,"change_date":"2022-05-26 21:42:00","inspection_id":"75673553","dot_number":"1492847","report_state":"GA","report_number":"1369002469","insp_date":"2022-05-24 00:00:00","insp_start_time":"1021","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":"270","location_desc":"FRANKLIN CO I\/S SB","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"1072406","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-05-26 21:42: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":"1895579","transaction_code":"A","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2022-05-26 21:42:00","snet_input_date":"2022-05-26 00:00:00","source_office":"2GAS001","mcmis_add_date":"2022-05-26 21:42:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:19.000000Z","updated_at":"2025-03-17T18:36:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":782447,"change_date":"2022-05-26 21:42:00","inspection_id":"75673553","insp_unit_id":"188922102","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4","insp_unit_license":"XCI202","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3ALACWFCXKDKV9089","insp_unit_decal":"Y","insp_unit_decal_number":"31279937","created_at":"2025-03-17T22:13:00.000000Z","updated_at":"2025-03-17T22:13:00.000000Z"}]},{"id":404673,"change_date":"2022-05-19 21:41:00","inspection_id":"75575680","dot_number":"1492847","report_state":"GA","report_number":"0337006699","insp_date":"2022-05-17 00:00:00","insp_start_time":"1055","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":"269","location_desc":"FRANKLIN CO I\/S NB","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1893641","transaction_code":"C","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2022-05-17 21:42:00","snet_input_date":"2022-05-17 00:00:00","source_office":"2GAS001","mcmis_add_date":"2022-05-17 21:42:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:45.000000Z","updated_at":"2025-03-17T18:34:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":653245,"change_date":"2022-05-19 21:41:00","inspection_id":"75575680","insp_unit_id":"188782791","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"03","insp_unit_license":"TDD2645","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FDXE4FS8JDC03465","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:12.000000Z","updated_at":"2025-03-17T22:12:12.000000Z"}]},{"id":404655,"change_date":"2022-05-17 21:42:00","inspection_id":"75575655","dot_number":"1492847","report_state":"GA","report_number":"1242004028","insp_date":"2022-05-16 00:00:00","insp_start_time":"1359","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":"269","location_desc":"FRANKLIN CO I\/S NB","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"NA","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":"2022-05-17 21:42: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":"1893445","transaction_code":"A","transaction_date":"2022-05-16 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2022-05-17 21:42:00","snet_input_date":"2022-05-17 00:00:00","source_office":"2GAS001","mcmis_add_date":"2022-05-17 21:42:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:45.000000Z","updated_at":"2025-03-17T18:34:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":653216,"change_date":"2022-05-17 21:42:00","inspection_id":"75575655","insp_unit_id":"188718175","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6","insp_unit_license":"EVI060","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC7NHNK3058","insp_unit_decal":"Y","insp_unit_decal_number":"31279974","created_at":"2025-03-17T22:12:12.000000Z","updated_at":"2025-03-17T22:12:12.000000Z"}]},{"id":263570,"change_date":"2022-04-27 21:39:00","inspection_id":"75407538","dot_number":"1492847","report_state":"GA","report_number":"2013000195","insp_date":"2022-04-27 00:00:00","insp_start_time":"1000","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":"269","location_desc":"FRANKLIN CO I\/S NB","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-27 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":"1889294","transaction_code":"A","transaction_date":"2022-04-27 00:00:00","upload_date":"2022-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01492847","upload_search_indicator":null,"census_search_date":"2022-04-27 21:39:00","snet_input_date":"2022-04-27 00:00:00","source_office":"2GAS001","mcmis_add_date":"2022-04-27 21:39:00","insp_carrier_name":"ALLIANCE SUPPLY AND PIPING LLC","insp_carrier_street":"1403 GERRARD RD","insp_carrier_city":"LAVONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"30553","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:12.000000Z","updated_at":"2025-03-17T18:32:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":426403,"change_date":"2022-04-27 21:39:00","inspection_id":"75407538","insp_unit_id":"188363379","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"421177","insp_unit_license":"EV1062","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVACWFC5NHNK3057","insp_unit_decal":"Y","insp_unit_decal_number":"31280303","created_at":"2025-03-17T22:10:50.000000Z","updated_at":"2025-03-17T22:10:50.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1492847\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1492847\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1492847\/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\/1492847\/inspections","per_page":100,"prev_page_url":null,"to":41,"total":41}