{"current_page":1,"data":[{"id":12386790,"change_date":"2026-07-08 21:41:00","inspection_id":"88350030","dot_number":"3073740","report_state":"AR","report_number":"7050001284","insp_date":"2026-07-08 00:00:00","insp_start_time":"1200","insp_end_time":"1245","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"LITTLE ROCK AR","county_code_state":"AR","county_code":"119","insp_level_id":"2","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3710058","transaction_code":"A","transaction_date":"2026-07-08 00:00:00","upload_date":"2026-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":"2026-07-08 21:41:00","snet_input_date":"2026-07-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-08 21:41:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-11T09:39:45.000000Z","updated_at":"2026-07-19T09:31:23.000000Z","inspection_violations":[{"id":21554968,"change_date":"2026-07-08 21:41:00","inspection_id":"88350030","insp_violation_id":"275362836","seq_no":"2","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"214502089","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":"W000108","created_at":"2026-07-11T09:57:09.000000Z","updated_at":"2026-07-19T09:43:32.000000Z","normalized_code":"393100BC"},{"id":21554967,"change_date":"2026-07-08 21:41:00","inspection_id":"88350030","insp_violation_id":"275362835","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"214502089","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-11T09:57:09.000000Z","updated_at":"2026-07-19T09:43:32.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":21508107,"change_date":"2026-07-08 21:41:00","inspection_id":"88350030","insp_unit_id":"214502089","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"034","insp_unit_license":"J26573","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"1FVHG3FM3RHUY3478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-11T09:15:59.000000Z","updated_at":"2026-07-19T09:02:59.000000Z"}]},{"id":12110213,"change_date":"2026-06-05 21:38:00","inspection_id":"88055064","dot_number":"3073740","report_state":"TX","report_number":"7G199DGTKR","insp_date":"2026-06-02 00:00:00","insp_start_time":"0921","insp_end_time":"0952","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2026-06-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9981309","transaction_code":"A","transaction_date":"2026-06-05 00:00:00","upload_date":"2026-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-06-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-05 21:38:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2026-06-08T09:41:10.000000Z","updated_at":"2026-06-16T09:33:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21040878,"change_date":"2026-06-05 21:38:00","inspection_id":"88055064","insp_unit_id":"213937940","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"010","insp_unit_license":"PFP5826","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DV5MDMR5092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-08T09:18:23.000000Z","updated_at":"2026-06-16T09:06:15.000000Z"}]},{"id":11659828,"change_date":"2026-04-16 21:40:00","inspection_id":"87589784","dot_number":"3073740","report_state":"TN","report_number":"I033HJ1384","insp_date":"2026-04-15 00:00:00","insp_start_time":"0640","insp_end_time":"0705","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"GOODLETTSVILLE TN","county_code_state":"TN","county_code":"037","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":"U","pen_cen_match":"I","final_status_date":"2026-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3166334","transaction_code":"A","transaction_date":"2026-04-16 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":"2026-04-16 21:40:00","snet_input_date":"2026-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-16 21:40:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:30:43.000000Z","updated_at":"2026-04-27T09:30:43.000000Z","inspection_violations":[{"id":20250341,"change_date":"2026-04-16 21:40:00","inspection_id":"87589784","insp_violation_id":"273634400","seq_no":"1","part_no":"393","part_no_section":"75A2-TAOBB","insp_viol_unit":"1","insp_unit_id":"213041618","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2026-04-27T09:43:18.000000Z","updated_at":"2026-04-27T09:43:18.000000Z","normalized_code":"39375A2TAOBB"},{"id":20250342,"change_date":"2026-04-16 21:40:00","inspection_id":"87589784","insp_violation_id":"273634401","seq_no":"2","part_no":"393","part_no_section":"134B-CRHLC","insp_viol_unit":"1","insp_unit_id":"213041618","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2026-04-27T09:43:18.000000Z","updated_at":"2026-04-27T09:43:18.000000Z","normalized_code":"393134BCRHLC"},{"id":20250343,"change_date":"2026-04-16 21:40:00","inspection_id":"87589784","insp_violation_id":"273634402","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"213041618","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2026-04-27T09:43:18.000000Z","updated_at":"2026-04-27T09:43:18.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":20282373,"change_date":"2026-04-16 21:40:00","inspection_id":"87589784","insp_unit_id":"213041618","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"039","insp_unit_license":"H916258","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FVHG3FMXRHUY3476","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:03:24.000000Z","updated_at":"2026-04-27T09:03:24.000000Z"}]},{"id":11399518,"change_date":"2026-03-17 21:39:00","inspection_id":"87314485","dot_number":"3073740","report_state":"TX","report_number":"7DIC9DCBI0","insp_date":"2026-03-03 00:00:00","insp_start_time":"1222","insp_end_time":"1307","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8300  MYKAWA RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HAMILTON ALLIANCE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9886466","transaction_code":"A","transaction_date":"2026-03-17 00:00:00","upload_date":"2026-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2026-03-17 21:39:00","snet_input_date":"2026-03-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-17 21:39:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2026-03-20T09:42:39.000000Z","updated_at":"2026-03-28T09:31:29.000000Z","inspection_violations":[{"id":19216645,"change_date":"2026-03-17 21:39:00","inspection_id":"87314485","insp_violation_id":"272456361","seq_no":"1","part_no":"393","part_no_section":"104B","insp_viol_unit":"1","insp_unit_id":"212184732","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-20T10:03:49.000000Z","updated_at":"2026-03-28T09:47:09.000000Z","normalized_code":"393104B"}],"inspection_per_units":[{"id":19522974,"change_date":"2026-03-17 21:39:00","inspection_id":"87314485","insp_unit_id":"212184732","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"043","insp_unit_license":"WHB3074","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DVXSDVJ9089","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:29.000000Z","updated_at":"2026-03-28T09:05:51.000000Z"}]},{"id":11205944,"change_date":"2026-02-23 21:38:00","inspection_id":"87117055","dot_number":"3073740","report_state":"TX","report_number":"7D579DGTC1","insp_date":"2026-02-18 00:00:00","insp_start_time":"0741","insp_end_time":"0817","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2026-02-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9859077","transaction_code":"A","transaction_date":"2026-02-23 00:00:00","upload_date":"2026-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2026-02-23 21:38:00","snet_input_date":"2026-02-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-23 21:38:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2026-02-26T10:36:59.000000Z","updated_at":"2026-03-06T10:30:48.000000Z","inspection_violations":[{"id":18790676,"change_date":"2026-02-23 21:38:00","inspection_id":"87117055","insp_violation_id":"271964930","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211770933","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:53.000000Z","updated_at":"2026-03-06T10:41:19.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":19135569,"change_date":"2026-02-23 21:38:00","inspection_id":"87117055","insp_unit_id":"211770933","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESE","insp_unit_company":null,"insp_unit_license":"SPV8638","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKHAXDV4PPUG9490","insp_unit_decal":"Y","insp_unit_decal_number":"35975216","created_at":"2026-02-26T10:12:13.000000Z","updated_at":"2026-03-06T10:03:30.000000Z"}]},{"id":10557594,"change_date":"2026-01-02 21:35:00","inspection_id":"86694780","dot_number":"3073740","report_state":"TX","report_number":"7BRB9DIP38","insp_date":"2025-12-30 00:00:00","insp_start_time":"1047","insp_end_time":"1121","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-1604 IN BEXAR CO. (488-582)","county_code_state":"TX","county_code":"029","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2026-01-02 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9803518","transaction_code":"A","transaction_date":"2026-01-02 00:00:00","upload_date":"2026-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2026-01-02 21:35:00","snet_input_date":"2025-12-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-02 21:35:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2026-01-05T10:33:37.000000Z","updated_at":"2026-01-13T10:30:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17687812,"change_date":"2026-01-02 21:35:00","inspection_id":"86694780","insp_unit_id":"210888444","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"42","insp_unit_license":"VSC2485","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DV3RDVG8639","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:07.000000Z","updated_at":"2026-01-13T10:00:38.000000Z"}]},{"id":9531254,"change_date":"2025-08-28 21:41:00","inspection_id":"85617574","dot_number":"3073740","report_state":"AR","report_number":"5810000075","insp_date":"2025-08-25 00:00:00","insp_start_time":"1340","insp_end_time":"1425","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BENTON AR","county_code_state":"AR","county_code":"125","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"HAMILTON ALLIANCE","shipping_paper_number":"1163709","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2191056","transaction_code":"A","transaction_date":"2025-08-28 00:00:00","upload_date":"2025-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":"2025-08-28 21:41:00","snet_input_date":"2025-08-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-28 21:41:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:12.000000Z","updated_at":"2025-09-06T10:42:12.000000Z","inspection_violations":[{"id":18467395,"change_date":null,"inspection_id":"85617574","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":15731799,"change_date":"2025-08-28 21:41:00","inspection_id":"85617574","insp_unit_id":"208631050","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"34","insp_unit_license":"J26573","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"1FVHG3FM3RHUY3478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:34.000000Z","updated_at":"2025-09-09T09:46:34.000000Z"}]},{"id":9440679,"change_date":"2025-08-18 21:39:00","inspection_id":"85522425","dot_number":"3073740","report_state":"TX","report_number":"77V79DJS1E","insp_date":"2025-08-12 00:00:00","insp_start_time":"0712","insp_end_time":"0750","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN BEXAR CO. (133-173)","county_code_state":"TX","county_code":"029","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2025-08-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9667778","transaction_code":"A","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2025-08-18 21:39:00","snet_input_date":"2025-08-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-18 21:39:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-08-23T10:46:02.000000Z","updated_at":"2025-08-23T10:46:02.000000Z","inspection_violations":[{"id":15368946,"change_date":"2025-08-18 21:39:00","inspection_id":"85522425","insp_violation_id":"268095803","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"208453261","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-08-21T10:42:36.000000Z","updated_at":"2025-08-22T10:44:09.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":15565386,"change_date":"2025-08-18 21:39:00","inspection_id":"85522425","insp_unit_id":"208453261","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"042","insp_unit_license":"VSC2485","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DV3RDVG8639","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:47.000000Z","updated_at":"2025-08-22T09:46:09.000000Z"}]},{"id":9323944,"change_date":"2025-08-04 21:39:00","inspection_id":"85399618","dot_number":"3073740","report_state":"TX","report_number":"77J79DBA5V","insp_date":"2025-07-31 00:00:00","insp_start_time":"0726","insp_end_time":"0751","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN HARRIS CO. (115-151","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HAMILTON ALLIANCE INC","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":"Y","pen_cen_match":null,"final_status_date":"2025-08-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9654788","transaction_code":"A","transaction_date":"2025-08-04 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2025-08-04 21:39:00","snet_input_date":"2025-07-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-04 21:39:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-08-07T10:44:52.000000Z","updated_at":"2025-08-08T10:00:48.000000Z","inspection_violations":[{"id":15130408,"change_date":"2025-08-04 21:39:00","inspection_id":"85399618","insp_violation_id":"267827481","seq_no":"1","part_no":"392","part_no_section":"2WC","insp_viol_unit":"1","insp_unit_id":"208227362","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-07T10:45:40.000000Z","updated_at":"2025-08-08T10:44:01.000000Z","normalized_code":"3922WC"},{"id":15130409,"change_date":"2025-08-04 21:39:00","inspection_id":"85399618","insp_violation_id":"267827482","seq_no":"2","part_no":"393","part_no_section":"75A1","insp_viol_unit":"1","insp_unit_id":"208227362","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-07T10:45:40.000000Z","updated_at":"2025-08-08T10:44:01.000000Z","normalized_code":"39375A1"},{"id":15130410,"change_date":"2025-08-04 21:39:00","inspection_id":"85399618","insp_violation_id":"267827483","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"208227362","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-07T10:45:40.000000Z","updated_at":"2025-08-08T10:44:01.000000Z","normalized_code":"39375A3TAOL"},{"id":15130411,"change_date":"2025-08-04 21:39:00","inspection_id":"85399618","insp_violation_id":"267827484","seq_no":"4","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"208227362","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-07T10:45:40.000000Z","updated_at":"2025-08-08T10:44:01.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":15355311,"change_date":"2025-08-04 21:39:00","inspection_id":"85399618","insp_unit_id":"208227362","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"SPV8638","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKHAXDV4PPUG9490","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:32.000000Z","updated_at":"2025-08-08T09:45:59.000000Z"}]},{"id":9240047,"change_date":"2025-07-24 21:41:00","inspection_id":"85311245","dot_number":"3073740","report_state":"TX","report_number":"775B9DGRAY","insp_date":"2025-07-17 00:00:00","insp_start_time":"1126","insp_end_time":"1148","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2900  CAVALCADE ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2025-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9646386","transaction_code":"A","transaction_date":"2025-07-24 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2025-07-24 21:41:00","snet_input_date":"2025-07-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-24 21:41:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-07-27T10:41:57.000000Z","updated_at":"2025-07-30T10:01:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15204704,"change_date":"2025-07-24 21:41:00","inspection_id":"85311245","insp_unit_id":"208064810","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"WHB3074","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DVXSDVJ9089","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:34.000000Z","updated_at":"2025-07-28T09:46:16.000000Z"}]},{"id":9078589,"change_date":"2025-07-07 21:40:00","inspection_id":"85141534","dot_number":"3073740","report_state":"TX","report_number":"76RA9DJS0B","insp_date":"2025-07-03 00:00:00","insp_start_time":"1007","insp_end_time":"1110","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN BEXAR CO. (133-173)","county_code_state":"TX","county_code":"029","insp_level_id":"1","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2025-07-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9626854","transaction_code":"A","transaction_date":"2025-07-07 00:00:00","upload_date":"2025-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2025-07-07 21:40:00","snet_input_date":"2025-07-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-07 21:40:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-07-11T10:44:35.000000Z","updated_at":"2025-07-11T10:44:35.000000Z","inspection_violations":[{"id":14618453,"change_date":"2025-07-07 21:40:00","inspection_id":"85141534","insp_violation_id":"267241583","seq_no":"1","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"207731895","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-10T10:42:43.000000Z","updated_at":"2025-07-11T10:46:11.000000Z","normalized_code":"3965B"},{"id":14618454,"change_date":"2025-07-07 21:40:00","inspection_id":"85141534","insp_violation_id":"267241584","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"207731895","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-10T10:42:43.000000Z","updated_at":"2025-07-11T10:46:11.000000Z","normalized_code":"39375A3TAOL"},{"id":14618455,"change_date":"2025-07-07 21:40:00","inspection_id":"85141534","insp_violation_id":"267241585","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207731895","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-10T10:42:43.000000Z","updated_at":"2025-07-11T10:46:11.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":14897994,"change_date":"2025-07-07 21:40:00","inspection_id":"85141534","insp_unit_id":"207731895","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"042","insp_unit_license":"VSC2485","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DV3RDVG8639","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:25.000000Z","updated_at":"2025-07-11T09:45:58.000000Z"}]},{"id":8759712,"change_date":"2025-05-28 21:43:00","inspection_id":"84804015","dot_number":"3073740","report_state":"TX","report_number":"75LC9DBY5N","insp_date":"2025-05-22 00:00:00","insp_start_time":"1246","insp_end_time":"1308","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"400 E LOOP LOOP","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2025-05-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9591345","transaction_code":"A","transaction_date":"2025-05-28 00:00:00","upload_date":"2025-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2025-05-28 21:43:00","snet_input_date":"2025-05-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-28 21:43:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-05-31T10:01:39.000000Z","updated_at":"2025-06-01T10:00:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14327678,"change_date":"2025-05-28 21:43:00","inspection_id":"84804015","insp_unit_id":"207112009","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"24","insp_unit_license":"SPV8638","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKHAXDV4PPUG9490","insp_unit_decal":"Y","insp_unit_decal_number":"35128420","created_at":"2025-05-31T09:46:53.000000Z","updated_at":"2025-06-01T09:47:50.000000Z"}]},{"id":8614169,"change_date":"2025-05-13 21:40:00","inspection_id":"84650426","dot_number":"3073740","report_state":"AR","report_number":"7860000702","insp_date":"2025-05-08 00:00:00","insp_start_time":"1505","insp_end_time":"1535","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"LITTLE ROCK AR","county_code_state":"AR","county_code":"119","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1719386","transaction_code":"A","transaction_date":"2025-05-13 00:00:00","upload_date":"2025-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":"2025-05-13 21:40:00","snet_input_date":"2025-05-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-13 21:40:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:03:50.000000Z","updated_at":"2025-05-17T10:07:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14064739,"change_date":"2025-05-13 21:40:00","inspection_id":"84650426","insp_unit_id":"206822987","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"40","insp_unit_license":"J26085","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"1FVHG3DV3RHVD1505","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-16T09:49:28.000000Z","updated_at":"2025-05-17T09:49:23.000000Z"}]},{"id":8452930,"change_date":"2025-04-23 21:41:00","inspection_id":"84480707","dot_number":"3073740","report_state":"TX","report_number":"74L89DIRAM","insp_date":"2025-04-16 00:00:00","insp_start_time":"0830","insp_end_time":"0859","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-1604 IN BEXAR CO. (488-582)","county_code_state":"TX","county_code":"029","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2025-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9558056","transaction_code":"A","transaction_date":"2025-04-23 00:00:00","upload_date":"2025-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2025-04-23 21:41:00","snet_input_date":"2025-04-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-23 21:41:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-04-26T10:28:42.000000Z","updated_at":"2025-04-27T10:32:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13729795,"change_date":"2025-04-23 21:41:00","inspection_id":"84480707","insp_unit_id":"206459913","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"042","insp_unit_license":"VSC2485","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DV3RDVG8639","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:17:04.000000Z","updated_at":"2025-04-27T10:07:25.000000Z"}]},{"id":8394900,"change_date":"2025-04-16 21:41:00","inspection_id":"84419455","dot_number":"3073740","report_state":"TX","report_number":"74CB9DIRAB","insp_date":"2025-04-07 00:00:00","insp_start_time":"1105","insp_end_time":"1143","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN BEXAR CO. (545-596)","county_code_state":"TX","county_code":"029","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2025-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9551896","transaction_code":"A","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2025-04-16 21:41:00","snet_input_date":"2025-04-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-16 21:41:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-04-19T10:19:33.000000Z","updated_at":"2025-04-20T10:26:16.000000Z","inspection_violations":[{"id":13239865,"change_date":"2025-04-16 21:41:00","inspection_id":"84419455","insp_violation_id":"265663793","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"206348593","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-04-18T11:19:02.000000Z","updated_at":"2025-04-20T10:48:13.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":13627085,"change_date":"2025-04-16 21:41:00","inspection_id":"84419455","insp_unit_id":"206348593","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11","insp_unit_license":"PTN6642","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DV2MDMV9828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-19T10:10:52.000000Z","updated_at":"2025-04-20T10:03:06.000000Z"}]},{"id":8278058,"change_date":"2025-04-02 21:41:00","inspection_id":"84296634","dot_number":"3073740","report_state":"TX","report_number":"74599DJM3E","insp_date":"2025-03-31 00:00:00","insp_start_time":"0912","insp_end_time":"0955","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0059 IN HARRIS CO. (492-528","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HAMILTON ALLIANCE","shipping_paper_number":"1149409","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9539045","transaction_code":"A","transaction_date":"2025-04-02 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2025-04-02 21:41:00","snet_input_date":"2025-03-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-04-06T10:23:58.000000Z","updated_at":"2025-04-06T10:23:58.000000Z","inspection_violations":[{"id":13010960,"change_date":"2025-04-02 21:41:00","inspection_id":"84296634","insp_violation_id":"265405720","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"206124199","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-04T11:10:27.000000Z","updated_at":"2025-04-05T10:44:50.000000Z","normalized_code":"39360D"},{"id":13010961,"change_date":"2025-04-02 21:41:00","inspection_id":"84296634","insp_violation_id":"265405721","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206124199","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-04T11:10:27.000000Z","updated_at":"2025-04-05T10:44:50.000000Z","normalized_code":"3922RG"},{"id":13010962,"change_date":"2025-04-02 21:41:00","inspection_id":"84296634","insp_violation_id":"265405722","seq_no":"3","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"206124199","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-04T11:10:27.000000Z","updated_at":"2025-04-05T10:44:50.000000Z","normalized_code":"39345DLUV"}],"inspection_per_units":[{"id":13400080,"change_date":"2025-04-02 21:41:00","inspection_id":"84296634","insp_unit_id":"206124199","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"021","insp_unit_license":"SYG2388","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYFE3PHUB8107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:14:02.000000Z","updated_at":"2025-04-06T10:01:53.000000Z"}]},{"id":8069979,"change_date":"2025-03-10 21:38:00","inspection_id":"84077459","dot_number":"3073740","report_state":"MA","report_number":"DA00003163","insp_date":"2025-03-09 00:00:00","insp_start_time":"1921","insp_end_time":"1934","registration_date":null,"region":"ET","ci_status_code":"C","location":"208H","location_desc":"H-MILTON","county_code_state":"MA","county_code":"021","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"511662","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":"03073740","upload_search_indicator":"M","census_search_date":"2025-03-10 21:38:00","snet_input_date":"2025-03-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-03-10 21:38:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"626","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:51.000000Z","updated_at":"2025-03-17T21:05:51.000000Z","inspection_violations":[{"id":12613805,"change_date":"2025-03-10 21:38:00","inspection_id":"84077459","insp_violation_id":"264921421","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:43.000000Z","updated_at":"2025-03-17T22:07:43.000000Z","normalized_code":"3922SLLLR"},{"id":12613806,"change_date":"2025-03-10 21:38:00","inspection_id":"84077459","insp_violation_id":"264921422","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:43.000000Z","updated_at":"2025-03-17T22:07:43.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":13030117,"change_date":"2025-03-10 21:38:00","inspection_id":"84077459","insp_unit_id":"205709628","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"16","insp_unit_license":"X89030","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE2PHUB8096","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:01.000000Z","updated_at":"2025-03-17T23:59:01.000000Z"}]},{"id":7983801,"change_date":"2025-02-27 21:41:00","inspection_id":"83986716","dot_number":"3073740","report_state":"TX","report_number":"736C9DCPSP","insp_date":"2025-02-24 00:00:00","insp_start_time":"1240","insp_end_time":"1255","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SOUT","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2025-02-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9508575","transaction_code":"A","transaction_date":"2025-02-27 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2025-02-27 21:41:00","snet_input_date":"2025-02-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-27 21:41:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-03-17T21:04:03.000000Z","updated_at":"2025-03-17T21:04:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12888690,"change_date":"2025-02-27 21:41:00","inspection_id":"83986716","insp_unit_id":"205544907","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"SYG2388","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYFE3PHUB8107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:21.000000Z","updated_at":"2025-03-17T23:57:21.000000Z"}]},{"id":7825380,"change_date":"2025-02-10 21:39:00","inspection_id":"83820633","dot_number":"3073740","report_state":"WI","report_number":"9999000131","insp_date":"2025-02-07 00:00:00","insp_start_time":"1247","insp_end_time":"1309","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"CALEDONIA WI","county_code_state":"WI","county_code":"101","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"ROLLL OFF CONTA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"1344007","transaction_code":"A","transaction_date":"2025-02-10 00:00:00","upload_date":"2025-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":"2025-02-10 21:39:00","snet_input_date":"2025-02-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-10 21:39:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:45.000000Z","updated_at":"2025-03-17T21:00:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12629182,"change_date":"2025-02-10 21:39:00","inspection_id":"83820633","insp_unit_id":"205237613","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"17","insp_unit_license":"38982V","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1FVHCYFE4PHUB8097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:30.000000Z","updated_at":"2025-03-17T23:54:30.000000Z"}]},{"id":7750027,"change_date":"2025-01-30 21:41:00","inspection_id":"83741257","dot_number":"3073740","report_state":"TX","report_number":"72GA9DJVZF","insp_date":"2025-01-29 00:00:00","insp_start_time":"0935","insp_end_time":"1034","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2025-01-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9486602","transaction_code":"A","transaction_date":"2025-01-30 00:00:00","upload_date":"2025-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2025-01-30 21:41:00","snet_input_date":"2025-01-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-30 21:41:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-03-17T20:59:09.000000Z","updated_at":"2025-03-17T20:59:09.000000Z","inspection_violations":[{"id":12109805,"change_date":"2025-01-30 21:41:00","inspection_id":"83741257","insp_violation_id":"264261760","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205086631","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:04.000000Z","updated_at":"2025-03-17T22:05:04.000000Z","normalized_code":"39347E"},{"id":12109806,"change_date":"2025-01-30 21:41:00","inspection_id":"83741257","insp_violation_id":"264261761","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"205086631","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:04.000000Z","updated_at":"2025-03-17T22:05:04.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":12506808,"change_date":"2025-01-30 21:41:00","inspection_id":"83741257","insp_unit_id":"205086631","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"SPV8638","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKHAXDV4PPUG9490","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:03.000000Z","updated_at":"2025-03-17T23:53:03.000000Z"}]},{"id":7594286,"change_date":"2025-01-10 21:40:00","inspection_id":"83577770","dot_number":"3073740","report_state":"TX","report_number":"71WE9DCOI5","insp_date":"2025-01-09 00:00:00","insp_start_time":"1452","insp_end_time":"1505","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0610 IN HARRIS CO. (0-37)","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UPS","shipping_paper_number":"010","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9471111","transaction_code":"A","transaction_date":"2025-01-10 00:00:00","upload_date":"2025-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2025-01-10 21:40:00","snet_input_date":"2025-01-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-10 21:40:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-03-17T20:55:43.000000Z","updated_at":"2025-03-17T20:55:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12253606,"change_date":"2025-01-10 21:40:00","inspection_id":"83577770","insp_unit_id":"204750687","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"010","insp_unit_license":"PFP5826","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DV5MDMR5092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:14.000000Z","updated_at":"2025-03-17T23:50:14.000000Z"}]},{"id":7566817,"change_date":"2025-01-07 21:40:00","inspection_id":"83548966","dot_number":"3073740","report_state":"TX","report_number":"71M99DIP8Z","insp_date":"2024-12-30 00:00:00","insp_start_time":"0904","insp_end_time":"0943","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0016 IN BEXAR CO. (574-618)","county_code_state":"TX","county_code":"029","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2025-01-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9467192","transaction_code":"A","transaction_date":"2025-01-07 00:00:00","upload_date":"2025-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2025-01-07 21:40:00","snet_input_date":"2024-12-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-07 21:40:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-03-17T20:55:16.000000Z","updated_at":"2025-03-17T20:55:16.000000Z","inspection_violations":[{"id":11828857,"change_date":"2025-01-07 21:40:00","inspection_id":"83548966","insp_violation_id":"263798988","seq_no":"1","part_no":"391","part_no_section":"11B4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"39111B4"},{"id":11828858,"change_date":"2025-01-07 21:40:00","inspection_id":"83548966","insp_violation_id":"263798989","seq_no":"2","part_no":"393","part_no_section":"205C","insp_viol_unit":"1","insp_unit_id":"204690884","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"393205C"},{"id":11828859,"change_date":"2025-01-07 21:40:00","inspection_id":"83548966","insp_violation_id":"263798990","seq_no":"3","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"204690884","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":12208928,"change_date":"2025-01-07 21:40:00","inspection_id":"83548966","insp_unit_id":"204690884","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11","insp_unit_license":"PTN6643","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DV2MDMV9828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:46.000000Z","updated_at":"2025-03-17T23:49:46.000000Z"}]},{"id":7268185,"change_date":"2024-11-25 21:42:00","inspection_id":"83234823","dot_number":"3073740","report_state":"FL","report_number":"2297002315","insp_date":"2024-11-20 00:00:00","insp_start_time":"1505","insp_end_time":"1535","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ORLANDO FL","county_code_state":"FL","county_code":"095","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-24 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1087052","transaction_code":"C","transaction_date":"2024-11-24 00:00:00","upload_date":"2024-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":"2024-11-24 21:33:00","snet_input_date":"2024-11-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-24 21:33:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:42.000000Z","updated_at":"2025-03-17T20:47:42.000000Z","inspection_violations":[{"id":11361803,"change_date":"2024-11-25 21:42:00","inspection_id":"83234823","insp_violation_id":"263065646","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","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:01:13.000000Z","updated_at":"2025-03-17T22:01:13.000000Z","normalized_code":"3922SLLTL"},{"id":11361804,"change_date":"2024-11-25 21:42:00","inspection_id":"83234823","insp_violation_id":"263065647","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"204033962","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:13.000000Z","updated_at":"2025-03-17T22:01:13.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":11723575,"change_date":"2024-11-25 21:42:00","inspection_id":"83234823","insp_unit_id":"204033962","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"031","insp_unit_license":"AH42GJ","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"3ALHG3FM8RDUV5276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:30.000000Z","updated_at":"2025-03-17T23:44:30.000000Z"}]},{"id":7253149,"change_date":"2024-11-21 21:41:00","inspection_id":"83218974","dot_number":"3073740","report_state":"TX","report_number":"70HC9DCEU2","insp_date":"2024-11-19 00:00:00","insp_start_time":"1223","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"400 E LOOP N","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"1915 MAPLE LAKES DR","shipping_paper_number":"J298717","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-11-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9433039","transaction_code":"A","transaction_date":"2024-11-21 00:00:00","upload_date":"2024-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2024-11-21 21:41:00","snet_input_date":"2024-11-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-21 21:41:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-03-17T20:47:17.000000Z","updated_at":"2025-03-17T20:47:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11699173,"change_date":"2024-11-21 21:41:00","inspection_id":"83218974","insp_unit_id":"203999095","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"24","insp_unit_license":"SPV8638","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKHAXDV4PPUG9490","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:14.000000Z","updated_at":"2025-03-17T23:44:14.000000Z"}]},{"id":7068044,"change_date":"2024-10-29 21:41:00","inspection_id":"83022984","dot_number":"3073740","report_state":"AR","report_number":"7350000210","insp_date":"2024-10-29 00:00:00","insp_start_time":"1235","insp_end_time":"1250","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CONWAY AR","county_code_state":"AR","county_code":"045","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"997983","transaction_code":"A","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":"2024-10-29 21:41:00","snet_input_date":"2024-10-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-29 21:41:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:26.000000Z","updated_at":"2025-03-17T20:43:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11399300,"change_date":"2024-10-29 21:41:00","inspection_id":"83022984","insp_unit_id":"203630335","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"034","insp_unit_license":"J26573","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"1FVHG3FM3RHUY3478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:01.000000Z","updated_at":"2025-03-17T23:41:01.000000Z"}]},{"id":6789768,"change_date":"2024-09-23 21:40:00","inspection_id":"82727500","dot_number":"3073740","report_state":"AR","report_number":"5140000019","insp_date":"2024-09-23 00:00:00","insp_start_time":"0702","insp_end_time":"0734","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"NORTH LITTLE ROCK AR","county_code_state":"AR","county_code":"119","insp_level_id":"1","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"873737","transaction_code":"A","transaction_date":"2024-09-23 00:00:00","upload_date":"2024-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":"2024-09-23 21:40:00","snet_input_date":"2024-09-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-23 21:40:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:44.000000Z","updated_at":"2025-03-17T20:37:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10949236,"change_date":"2024-09-23 21:40:00","inspection_id":"82727500","insp_unit_id":"203070411","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"40","insp_unit_license":"J26085","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"1FVHG3DV3RHVD1505","insp_unit_decal":"Y","insp_unit_decal_number":"34399869","created_at":"2025-03-17T23:36:25.000000Z","updated_at":"2025-03-17T23:36:25.000000Z"}]},{"id":6789888,"change_date":"2024-09-23 21:40:00","inspection_id":"82727623","dot_number":"3073740","report_state":"AR","report_number":"5140000010","insp_date":"2024-09-19 00:00:00","insp_start_time":"0835","insp_end_time":"0916","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MAYFLOWER AR","county_code_state":"AR","county_code":"045","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME VIA ROUSCH COLEMAN","shipping_paper_number":"NONE LISTED","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-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"873806","transaction_code":"A","transaction_date":"2024-09-23 00:00:00","upload_date":"2024-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":"2024-09-23 21:40:00","snet_input_date":"2024-09-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-23 21:40:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:44.000000Z","updated_at":"2025-03-17T20:37:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10949440,"change_date":"2024-09-23 21:40:00","inspection_id":"82727623","insp_unit_id":"203070626","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"034","insp_unit_license":"J26573","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"1FVHG3FM3RHUY3478","insp_unit_decal":"Y","insp_unit_decal_number":"34399767","created_at":"2025-03-17T23:36:25.000000Z","updated_at":"2025-03-17T23:36:25.000000Z"}]},{"id":6659266,"change_date":"2024-09-05 21:43:00","inspection_id":"82588314","dot_number":"3073740","report_state":"TX","report_number":"6YC79DJVO3","insp_date":"2024-09-03 00:00:00","insp_start_time":"0755","insp_end_time":"0827","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2024-09-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9370190","transaction_code":"A","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2024-09-05 21:43:00","snet_input_date":"2024-09-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-05 21:43:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-03-17T20:34:54.000000Z","updated_at":"2025-03-17T20:34:54.000000Z","inspection_violations":[{"id":10362333,"change_date":"2024-09-05 21:43:00","inspection_id":"82588314","insp_violation_id":"261641802","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202784359","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"39347E"},{"id":10362334,"change_date":"2024-09-05 21:43:00","inspection_id":"82588314","insp_violation_id":"261641803","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"202784359","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":10736684,"change_date":"2024-09-05 21:43:00","inspection_id":"82588314","insp_unit_id":"202784359","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESE","insp_unit_company":"24","insp_unit_license":"SPV8638","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKHAXDV4PPUG9490","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:11.000000Z","updated_at":"2025-03-17T23:34:11.000000Z"}]},{"id":6497290,"change_date":"2024-08-19 21:41:00","inspection_id":"82415785","dot_number":"3073740","report_state":"TN","report_number":"I033HJ0562","insp_date":"2024-08-13 00:00:00","insp_start_time":"0703","insp_end_time":"0729","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"GOODLETTSVILLE TN","county_code_state":"TN","county_code":"037","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":"U","pen_cen_match":"I","final_status_date":"2024-08-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"756487","transaction_code":"A","transaction_date":"2024-08-19 00:00:00","upload_date":"2024-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":"2024-08-19 21:41:00","snet_input_date":"2024-08-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-19 21:41:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:37.000000Z","updated_at":"2025-03-17T20:31:37.000000Z","inspection_violations":[{"id":10089770,"change_date":"2024-08-19 21:41:00","inspection_id":"82415785","insp_violation_id":"261255426","seq_no":"1","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"202452302","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:54:48.000000Z","updated_at":"2025-03-17T21:54:48.000000Z","normalized_code":"3929A2"}],"inspection_per_units":[{"id":10473300,"change_date":"2024-08-19 21:41:00","inspection_id":"82415785","insp_unit_id":"202452302","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"H916258","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FVHG3FMXRHUY3476","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:29.000000Z","updated_at":"2025-03-17T23:31:29.000000Z"}]},{"id":5920071,"change_date":"2024-06-05 21:42:00","inspection_id":"81795634","dot_number":"3073740","report_state":"IL","report_number":"4289780116","insp_date":"2024-06-03 00:00:00","insp_start_time":"0715","insp_end_time":"0729","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"IL 41 NB AT WADSWORTHS RD","county_code_state":"IL","county_code":"097","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAMILTON ALLIANCE INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"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":"66000","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":"2330238","transaction_code":"A","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":"2024-06-05 21:42:00","snet_input_date":"2024-06-03 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-06-05 21:42:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:12.000000Z","updated_at":"2025-03-17T20:20:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9535297,"change_date":"2024-06-05 21:42:00","inspection_id":"81795634","insp_unit_id":"201248710","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"037","insp_unit_license":"38981V","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1FVHG3FM1RHUY3480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:55.000000Z","updated_at":"2025-03-17T23:21:55.000000Z"}]},{"id":5492164,"change_date":"2024-04-11 21:41:00","inspection_id":"81330642","dot_number":"3073740","report_state":"TX","report_number":"6U4E9DJN1T","insp_date":"2024-04-04 00:00:00","insp_start_time":"1451","insp_end_time":"1516","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3100  YELLOWSTONE BL","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2024-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9245673","transaction_code":"A","transaction_date":"2024-04-11 00:00:00","upload_date":"2024-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2024-04-11 21:41:00","snet_input_date":"2024-04-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-11 21:41:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-03-17T20:11:33.000000Z","updated_at":"2025-03-17T20:11:33.000000Z","inspection_violations":[{"id":8482512,"change_date":"2024-04-11 21:41:00","inspection_id":"81330642","insp_violation_id":"258886657","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200358852","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8846976,"change_date":"2024-04-11 21:41:00","inspection_id":"81330642","insp_unit_id":"200358852","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"010","insp_unit_license":"PFP5826","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DV5MDMR5092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:18.000000Z","updated_at":"2025-03-17T23:15:18.000000Z"}]},{"id":5216964,"change_date":"2024-03-11 21:44:00","inspection_id":"81029881","dot_number":"3073740","report_state":"PA","report_number":"E903406430","insp_date":"2024-03-04 00:00:00","insp_start_time":"1035","insp_end_time":"1114","registration_date":"2024-03-11 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"AT GREATER LEBANON REFUSE AUTH","county_code_state":"PA","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"HAMILTON ALLIANCE INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2424860","transaction_code":"C","transaction_date":"2024-03-04 00:00:00","upload_date":"2024-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":"2024-03-05 21:41:00","snet_input_date":"2024-03-04 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-03-05 21:41:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:48.000000Z","updated_at":"2025-03-17T20:05:48.000000Z","inspection_violations":[{"id":8039126,"change_date":"2024-03-11 21:44:00","inspection_id":"81029881","insp_violation_id":"258318736","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199856609","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:49.000000Z","updated_at":"2025-03-17T21:44:49.000000Z","normalized_code":"3922"},{"id":8039127,"change_date":"2024-03-11 21:44:00","inspection_id":"81029881","insp_violation_id":"258318737","seq_no":"2","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"199856609","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA0157185-0","created_at":"2025-03-17T21:44:49.000000Z","updated_at":"2025-03-17T21:44:49.000000Z","normalized_code":"3969D2"},{"id":8039128,"change_date":"2024-03-11 21:44:00","inspection_id":"81029881","insp_violation_id":"258318738","seq_no":"3","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"TA0157186-1","created_at":"2025-03-17T21:44:49.000000Z","updated_at":"2025-03-17T21:44:49.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":8400755,"change_date":"2024-03-11 21:44:00","inspection_id":"81029881","insp_unit_id":"199856609","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"007","insp_unit_license":"ZTX5193","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FVHG3DV6LHKY1687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:08.000000Z","updated_at":"2025-03-17T23:11:08.000000Z"}]},{"id":5217153,"change_date":"2024-03-06 21:40:00","inspection_id":"81030085","dot_number":"3073740","report_state":"TX","report_number":"6T3A9DGAXL","insp_date":"2024-02-27 00:00:00","insp_start_time":"1000","insp_end_time":"1036","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0518 IN GALVESTON CO. (692-","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2024-03-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9214122","transaction_code":"C","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2024-03-05 21:41:00","snet_input_date":"2024-02-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-05 21:41:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-03-17T20:05:48.000000Z","updated_at":"2025-03-17T20:05:48.000000Z","inspection_violations":[{"id":8039894,"change_date":"2024-03-06 21:40:00","inspection_id":"81030085","insp_violation_id":"258240969","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199788051","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:49.000000Z","updated_at":"2025-03-17T21:44:49.000000Z","normalized_code":"3965B"},{"id":8039895,"change_date":"2024-03-06 21:40:00","inspection_id":"81030085","insp_violation_id":"258240970","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199788051","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:49.000000Z","updated_at":"2025-03-17T21:44:49.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":8401053,"change_date":"2024-03-06 21:40:00","inspection_id":"81030085","insp_unit_id":"199788051","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"V-490","insp_unit_license":"SPV8638","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKHAXDV4PPUG9490","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:08.000000Z","updated_at":"2025-03-17T23:11:08.000000Z"}]},{"id":5147141,"change_date":"2024-02-27 21:40:00","inspection_id":"80954159","dot_number":"3073740","report_state":"TX","report_number":"V241195958","insp_date":"2024-02-20 00:00:00","insp_start_time":"0845","insp_end_time":"0936","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A101","location_desc":"IH 45 NORTHBOUND","county_code_state":"TX","county_code":"113","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","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":"Y","pen_cen_match":null,"final_status_date":"2024-02-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9208429","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2024-02-27 21:40:00","snet_input_date":"2024-02-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-27 21:40:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-03-17T20:04:32.000000Z","updated_at":"2025-03-17T20:04:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8287447,"change_date":"2024-02-27 21:40:00","inspection_id":"80954159","insp_unit_id":"199626870","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"036","insp_unit_license":"TMV8037","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHG3FM5RHUY3479","insp_unit_decal":"Y","insp_unit_decal_number":"33614716","created_at":"2025-03-17T23:10:06.000000Z","updated_at":"2025-03-17T23:10:06.000000Z"}]},{"id":5116125,"change_date":"2024-02-22 21:43:00","inspection_id":"80920223","dot_number":"3073740","report_state":"TX","report_number":"V241319936","insp_date":"2024-02-14 00:00:00","insp_start_time":"0713","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"UA 90","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HAMILTON ALLIANCE INC","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":"Y","pen_cen_match":null,"final_status_date":"2024-02-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9204877","transaction_code":"A","transaction_date":"2024-02-22 00:00:00","upload_date":"2024-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":"2024-02-22 21:43:00","snet_input_date":"2024-02-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-22 21:43:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-03-17T20:03:51.000000Z","updated_at":"2025-03-17T20:03:51.000000Z","inspection_violations":[{"id":7889783,"change_date":"2024-02-22 21:43:00","inspection_id":"80920223","insp_violation_id":"257993834","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"199560127","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"393134"},{"id":7889784,"change_date":"2024-02-22 21:43:00","inspection_id":"80920223","insp_violation_id":"257993835","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199560127","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"39617C"},{"id":7889785,"change_date":"2024-02-22 21:43:00","inspection_id":"80920223","insp_violation_id":"257993836","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199560127","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8236851,"change_date":"2024-02-22 21:43:00","inspection_id":"80920223","insp_unit_id":"199560127","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"021","insp_unit_license":"SYG2388","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYFE3PHUB8107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:39.000000Z","updated_at":"2025-03-17T23:09:39.000000Z"}]},{"id":4830323,"change_date":"2024-01-14 21:31:00","inspection_id":"80607692","dot_number":"3073740","report_state":"WI","report_number":"2654002875","insp_date":"2024-01-11 00:00:00","insp_start_time":"1349","insp_end_time":"1419","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"PLEASANT PRAIRIE WI","county_code_state":"WI","county_code":"059","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-01-14 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"175094","transaction_code":"A","transaction_date":"2024-01-13 00:00:00","upload_date":"2024-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":"2024-01-14 21:31:00","snet_input_date":"2024-01-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-14 21:31:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:27.000000Z","updated_at":"2025-03-17T19:58:27.000000Z","inspection_violations":[{"id":7448146,"change_date":"2024-01-14 21:31:00","inspection_id":"80607692","insp_violation_id":"257333955","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":7771432,"change_date":"2024-01-14 21:31:00","inspection_id":"80607692","insp_unit_id":"198955083","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"17","insp_unit_license":"38982V","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1FVHCYFE4PHUB8097","insp_unit_decal":"Y","insp_unit_decal_number":"33732956","created_at":"2025-03-17T23:05:28.000000Z","updated_at":"2025-03-17T23:05:28.000000Z"}]},{"id":4655389,"change_date":"2024-12-06 21:44:00","inspection_id":"80416701","dot_number":"3073740","report_state":"TX","report_number":"V231206953","insp_date":"2023-12-14 00:00:00","insp_start_time":"1145","insp_end_time":"1210","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 610","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HAMILTON ALLIANCE INC","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":"Y","pen_cen_match":null,"final_status_date":"2023-12-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9150619","transaction_code":"C","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-12-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-18 21:42:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-03-17T19:54:59.000000Z","updated_at":"2025-03-17T19:54:59.000000Z","inspection_violations":[{"id":7196216,"change_date":"2024-12-06 21:44:00","inspection_id":"80416701","insp_violation_id":"263294732","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"204236042","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:40:44.000000Z","updated_at":"2025-03-17T21:40:44.000000Z","normalized_code":"393134"},{"id":7196217,"change_date":"2024-12-06 21:44:00","inspection_id":"80416701","insp_violation_id":"263294733","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204236042","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:44.000000Z","updated_at":"2025-03-17T21:40:44.000000Z","normalized_code":"3922RG"},{"id":7196218,"change_date":"2024-12-06 21:44:00","inspection_id":"80416701","insp_violation_id":"263294734","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204236042","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:44.000000Z","updated_at":"2025-03-17T21:40:44.000000Z","normalized_code":"3922RG"},{"id":7196219,"change_date":"2024-12-06 21:44:00","inspection_id":"80416701","insp_violation_id":"263294735","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204236042","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:44.000000Z","updated_at":"2025-03-17T21:40:44.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":7487753,"change_date":"2024-12-06 21:44:00","inspection_id":"80416701","insp_unit_id":"204236042","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"010","insp_unit_license":"PFP5826","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DV5MDMR5092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:57.000000Z","updated_at":"2025-03-17T23:02:57.000000Z"}]},{"id":4364901,"change_date":"2023-11-06 21:42:00","inspection_id":"80096826","dot_number":"3073740","report_state":"PA","report_number":"M236003262","insp_date":"2023-11-03 00:00:00","insp_start_time":"0913","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":"38","location_desc":"NORTH 20TH ST","county_code_state":"PA","county_code":"075","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"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":"Y","pen_cen_match":"I","final_status_date":"2023-11-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2394393","transaction_code":"A","transaction_date":"2023-11-03 00:00:00","upload_date":"2023-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-03 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-11-06 21:42:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:30.000000Z","updated_at":"2025-03-17T19:49:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7020362,"change_date":"2023-11-06 21:42:00","inspection_id":"80096826","insp_unit_id":"197929773","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"007","insp_unit_license":"ZTX5193","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FVHG3DV6LHKY1687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:56.000000Z","updated_at":"2025-03-17T22:58:56.000000Z"}]},{"id":3671178,"change_date":"2023-08-04 21:40:00","inspection_id":"79326373","dot_number":"3073740","report_state":"FL","report_number":"2146003541","insp_date":"2023-08-03 00:00:00","insp_start_time":"0925","insp_end_time":"0949","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB","county_code_state":"FL","county_code":"121","insp_level_id":"3","service_center":"SH","census_source_id":"4","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2531467","transaction_code":"A","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-03 00:00:00","source_office":"2FLS001","mcmis_add_date":"2023-08-04 21:40:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:18.000000Z","updated_at":"2025-03-17T19:35:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5902027,"change_date":"2023-08-04 21:40:00","inspection_id":"79326373","insp_unit_id":"196366085","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"WAJ984","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FVHG3DV7GHHB1862","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:37.000000Z","updated_at":"2025-03-17T22:49:37.000000Z"}]},{"id":3298469,"change_date":"2023-06-15 21:43:00","inspection_id":"78907701","dot_number":"3073740","report_state":"TX","report_number":"6LX89DDWHN","insp_date":"2023-06-14 00:00:00","insp_start_time":"0842","insp_end_time":"0902","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"S RIVERFRONT BLVD","county_code_state":"TX","county_code":"113","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2023-06-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9006224","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-15 21:43:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-03-17T19:28:12.000000Z","updated_at":"2025-03-17T19:28:12.000000Z","inspection_violations":[{"id":5087174,"change_date":"2023-06-15 21:43:00","inspection_id":"78907701","insp_violation_id":"253539969","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"195529004","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"393134"},{"id":5087175,"change_date":"2023-06-15 21:43:00","inspection_id":"78907701","insp_violation_id":"253539970","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195529004","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"39311"},{"id":5087176,"change_date":"2023-06-15 21:43:00","inspection_id":"78907701","insp_violation_id":"253539971","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"195529004","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"39375A3"},{"id":5087177,"change_date":"2023-06-15 21:43:00","inspection_id":"78907701","insp_violation_id":"253539972","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"195529004","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":5303364,"change_date":"2023-06-15 21:43:00","inspection_id":"78907701","insp_unit_id":"195529004","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01","insp_unit_license":"KXD4152","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHG3DV0JHJZ1836","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:50.000000Z","updated_at":"2025-03-17T22:44:50.000000Z"}]},{"id":3219336,"change_date":"2023-07-25 21:41:00","inspection_id":"78818123","dot_number":"3073740","report_state":"AR","report_number":"B545005178","insp_date":"2023-06-06 00:00:00","insp_start_time":"0835","insp_end_time":"0913","registration_date":null,"region":"CT","ci_status_code":"C","location":"23","location_desc":"FAULKNER COUNTY","county_code_state":"AR","county_code":"045","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-06 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1460660","transaction_code":"C","transaction_date":"2023-07-25 00:00:00","upload_date":"2023-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-06 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-06-06 21:44:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:32.000000Z","updated_at":"2025-03-17T19:26:32.000000Z","inspection_violations":[{"id":4962630,"change_date":"2023-07-25 21:41:00","inspection_id":"78818123","insp_violation_id":"254256346","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196175141","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:07.000000Z","updated_at":"2025-03-17T21:30:07.000000Z","normalized_code":"3939A"},{"id":4962631,"change_date":"2023-07-25 21:41:00","inspection_id":"78818123","insp_violation_id":"254256347","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196175141","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:07.000000Z","updated_at":"2025-03-17T21:30:07.000000Z","normalized_code":"3939A"},{"id":4962632,"change_date":"2023-07-25 21:41:00","inspection_id":"78818123","insp_violation_id":"254256348","seq_no":"3","part_no":"393","part_no_section":"134(b)(3)","insp_viol_unit":"1","insp_unit_id":"196175141","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"W001157","created_at":"2025-03-17T21:30:07.000000Z","updated_at":"2025-03-17T21:30:07.000000Z","normalized_code":"393134B3"},{"id":4962633,"change_date":"2023-07-25 21:41:00","inspection_id":"78818123","insp_violation_id":"254256349","seq_no":"4","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"196175141","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:07.000000Z","updated_at":"2025-03-17T21:30:07.000000Z","normalized_code":"39345D"},{"id":4962634,"change_date":"2023-07-25 21:41:00","inspection_id":"78818123","insp_violation_id":"254256350","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196175141","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:07.000000Z","updated_at":"2025-03-17T21:30:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5177292,"change_date":"2023-07-25 21:41:00","inspection_id":"78818123","insp_unit_id":"196175141","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"H37246","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"1FVHG3DV1KHKS1427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:48.000000Z","updated_at":"2025-03-17T22:43:48.000000Z"}]},{"id":3263334,"change_date":"2023-06-20 21:42:00","inspection_id":"78867768","dot_number":"3073740","report_state":"PA","report_number":"L205315699","insp_date":"2023-06-05 00:00:00","insp_start_time":"0851","insp_end_time":"0915","registration_date":"2023-06-20 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"1610 RUSSELL RD LEBANON REFUSE","county_code_state":"PA","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2354366","transaction_code":"C","transaction_date":"2023-06-05 00:00:00","upload_date":"2023-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-05 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-06-12 21:40:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:41.000000Z","updated_at":"2025-03-17T19:27:41.000000Z","inspection_violations":[{"id":5031832,"change_date":"2023-06-20 21:42:00","inspection_id":"78867768","insp_violation_id":"253608267","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195591205","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:23.000000Z","updated_at":"2025-03-17T21:30:23.000000Z","normalized_code":"3922"},{"id":5031833,"change_date":"2023-06-20 21:42:00","inspection_id":"78867768","insp_violation_id":"253608268","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195591205","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:23.000000Z","updated_at":"2025-03-17T21:30:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5248084,"change_date":"2023-06-20 21:42:00","inspection_id":"78867768","insp_unit_id":"195591205","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"007","insp_unit_license":"ZTX5193","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FVHG3DV6LHKY1687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:22.000000Z","updated_at":"2025-03-17T22:44:22.000000Z"}]},{"id":3170668,"change_date":"2023-05-30 21:43:00","inspection_id":"78763186","dot_number":"3073740","report_state":"TX","report_number":"6LB99DGTXR","insp_date":"2023-05-23 00:00:00","insp_start_time":"0951","insp_end_time":"1022","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6500  GRAND BLVD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2023-05-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8991122","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-30 21:43:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"5725 CORPORATE WAY SUITE 107","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33407","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-03-17T19:25:44.000000Z","updated_at":"2025-03-17T19:25:44.000000Z","inspection_violations":[{"id":4886125,"change_date":"2023-05-30 21:43:00","inspection_id":"78763186","insp_violation_id":"253159587","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"195210361","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"393134"},{"id":4886126,"change_date":"2023-05-30 21:43:00","inspection_id":"78763186","insp_violation_id":"253159588","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"195210361","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"39375C"},{"id":4886127,"change_date":"2023-05-30 21:43:00","inspection_id":"78763186","insp_violation_id":"253159589","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"195210361","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":5100282,"change_date":"2023-05-30 21:43:00","inspection_id":"78763186","insp_unit_id":"195210361","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"010","insp_unit_license":"PFP5826","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DV5MDMR5092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:12.000000Z","updated_at":"2025-03-17T22:43:12.000000Z"}]},{"id":2288122,"change_date":"2023-02-07 21:41:00","inspection_id":"77761385","dot_number":"3073740","report_state":"PA","report_number":"E903303016","insp_date":"2023-01-30 00:00:00","insp_start_time":"0950","insp_end_time":"1044","registration_date":"2023-02-06 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"AT GREATER LEBANON REFUSE AUTH","county_code_state":"PA","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"HAMILTON ALLIANCE INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2319222","transaction_code":"C","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-30 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-02-02 21:42:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"PO BOX 361042","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"462361042","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:52.000000Z","updated_at":"2025-03-17T19:08:52.000000Z","inspection_violations":[{"id":3528773,"change_date":"2023-02-07 21:41:00","inspection_id":"77761385","insp_violation_id":"251003075","seq_no":"1","part_no":"393","part_no_section":"134(b)(3)","insp_viol_unit":"1","insp_unit_id":"193280756","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"TA0004262-6","created_at":"2025-03-17T21:23:40.000000Z","updated_at":"2025-03-17T21:23:40.000000Z","normalized_code":"393134B3"},{"id":3528774,"change_date":"2023-02-07 21:41:00","inspection_id":"77761385","insp_violation_id":"251003076","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193280756","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA0004263-0","created_at":"2025-03-17T21:23:40.000000Z","updated_at":"2025-03-17T21:23:40.000000Z","normalized_code":"39617C"},{"id":3528775,"change_date":"2023-02-07 21:41:00","inspection_id":"77761385","insp_violation_id":"251003077","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"193280756","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA0004264-1","created_at":"2025-03-17T21:23:40.000000Z","updated_at":"2025-03-17T21:23:40.000000Z","normalized_code":"39360C"},{"id":3528776,"change_date":"2023-02-07 21:41:00","inspection_id":"77761385","insp_violation_id":"251003078","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"193280756","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:40.000000Z","updated_at":"2025-03-17T21:23:40.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":3682730,"change_date":"2023-02-07 21:41:00","inspection_id":"77761385","insp_unit_id":"193280756","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"007","insp_unit_license":"ZTX5193","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FVHG3DV6LHKY1687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:23.000000Z","updated_at":"2025-03-17T22:32:23.000000Z"}]},{"id":2010811,"change_date":"2022-12-29 21:40:00","inspection_id":"77444387","dot_number":"3073740","report_state":"TX","report_number":"6H1A9DBY1Y","insp_date":"2022-12-20 00:00:00","insp_start_time":"1049","insp_end_time":"1127","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8900  NORTH FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HAMILTON ALLIANCE","shipping_paper_number":"1377120","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-12-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"8860108","transaction_code":"C","transaction_date":"2022-12-29 00:00:00","upload_date":"2022-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":"2022-12-29 21:40:00","snet_input_date":"2022-12-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-23 21:33:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"1601 BELVEDERE RD STE 217S","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33406","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-03-17T19:03:41.000000Z","updated_at":"2025-03-17T19:03:41.000000Z","inspection_violations":[{"id":3120953,"change_date":"2022-12-29 21:40:00","inspection_id":"77444387","insp_violation_id":"250323314","seq_no":"1","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"192637944","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:49.000000Z","updated_at":"2025-03-17T21:21:49.000000Z","normalized_code":"39353B"},{"id":3120954,"change_date":"2022-12-29 21:40:00","inspection_id":"77444387","insp_violation_id":"250323315","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"192637944","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:49.000000Z","updated_at":"2025-03-17T21:21:49.000000Z","normalized_code":"39347E"},{"id":3120955,"change_date":"2022-12-29 21:40:00","inspection_id":"77444387","insp_violation_id":"250323316","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192637944","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:49.000000Z","updated_at":"2025-03-17T21:21:49.000000Z","normalized_code":"39311"},{"id":3120956,"change_date":"2022-12-29 21:40:00","inspection_id":"77444387","insp_violation_id":"250323317","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192637944","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:49.000000Z","updated_at":"2025-03-17T21:21:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3234931,"change_date":"2022-12-29 21:40:00","inspection_id":"77444387","insp_unit_id":"192637944","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"010","insp_unit_license":"PFP5826","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DV5MDMR5092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:08.000000Z","updated_at":"2025-03-17T22:29:08.000000Z"}]},{"id":1707073,"change_date":"2022-11-09 21:40:00","inspection_id":"77096600","dot_number":"3073740","report_state":"TN","report_number":"TFGO000222","insp_date":"2022-11-02 00:00:00","insp_start_time":"0930","insp_end_time":"0948","registration_date":null,"region":"CT","ci_status_code":"C","location":"83","location_desc":"AIRPORT\/COLES FERRY ROAD","county_code_state":"TN","county_code":"149","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"HAMILTON ALLIANCE INC","shipping_paper_number":"1122022","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-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1610392","transaction_code":"A","transaction_date":"2022-11-02 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-09 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"PO BOX 797","insp_carrier_city":"CICERO","insp_carrier_state":"IN","insp_carrier_zip_code":"46034","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[{"id":2675054,"change_date":"2022-11-09 21:40:00","inspection_id":"77096600","insp_violation_id":"249517249","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"191881812","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":2746150,"change_date":"2022-11-09 21:40:00","inspection_id":"77096600","insp_unit_id":"191881812","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"H916243","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHG3DV3MDMJ9595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"}]},{"id":619287,"change_date":"2022-06-15 21:41:00","inspection_id":"75831240","dot_number":"3073740","report_state":"TX","report_number":"6BF79DCR5N","insp_date":"2022-06-01 00:00:00","insp_start_time":"0725","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VA HOSPITAL","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":"Y","pen_cen_match":null,"final_status_date":"2022-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8680626","transaction_code":"A","transaction_date":"2022-06-15 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03073740","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-15 21:41:00","insp_carrier_name":"HAMILTON ALLIANCE INC","insp_carrier_street":"1601 BELVEDERE RD STE 114E","insp_carrier_city":"WEST PALM BEACH","insp_carrier_state":"FL","insp_carrier_zip_code":"33406","insp_colonia":null,"docket_number":"62687","insp_interstate":"Y","insp_carrier_state_id":"0981222","created_at":"2025-03-17T18:38:30.000000Z","updated_at":"2025-03-17T18:38:30.000000Z","inspection_violations":[{"id":972341,"change_date":"2022-06-15 21:41:00","inspection_id":"75831240","insp_violation_id":"246494129","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189275158","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39347E"},{"id":972342,"change_date":"2022-06-15 21:41:00","inspection_id":"75831240","insp_violation_id":"246494130","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"189275158","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39353B"},{"id":972343,"change_date":"2022-06-15 21:41:00","inspection_id":"75831240","insp_violation_id":"246494131","seq_no":"3","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"189275158","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"3929A2"},{"id":972344,"change_date":"2022-06-15 21:41:00","inspection_id":"75831240","insp_violation_id":"246494132","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189275158","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39617C"},{"id":972345,"change_date":"2022-06-15 21:41:00","inspection_id":"75831240","insp_violation_id":"246494133","seq_no":"5","part_no":"393","part_no_section":"106(b)","insp_viol_unit":"1","insp_unit_id":"189275158","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"393106B"},{"id":972346,"change_date":"2022-06-15 21:41:00","inspection_id":"75831240","insp_violation_id":"246494134","seq_no":"6","part_no":"393","part_no_section":"106(b)","insp_viol_unit":"1","insp_unit_id":"189275158","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"393106B"},{"id":972347,"change_date":"2022-06-15 21:41:00","inspection_id":"75831240","insp_violation_id":"246494135","seq_no":"7","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"189275158","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"393134"},{"id":972348,"change_date":"2022-06-15 21:41:00","inspection_id":"75831240","insp_violation_id":"246494136","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189275158","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39617C"},{"id":972349,"change_date":"2022-06-15 21:41:00","inspection_id":"75831240","insp_violation_id":"246494137","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189275158","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":996049,"change_date":"2022-06-15 21:41:00","inspection_id":"75831240","insp_unit_id":"189275158","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"010","insp_unit_license":"PFP5826","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DV5MDMR5092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:20.000000Z","updated_at":"2025-03-17T22:14:20.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3073740\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3073740\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3073740\/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\/3073740\/inspections","per_page":100,"prev_page_url":null,"to":47,"total":47}