{"current_page":1,"data":[{"id":11744112,"change_date":"2026-05-15 21:45:00","inspection_id":"87673503","dot_number":"3684206","report_state":"IL","report_number":"5005290171","insp_date":"2026-04-20 00:00:00","insp_start_time":"0632","insp_end_time":"0742","registration_date":"2026-05-14 00:00:00","region":"CT","ci_status_code":"C","location":"033","location_desc":"033 - WILLIAMSVILLE - I-55 S\/B","county_code_state":"IL","county_code":"167","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"51200","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":"2468482","transaction_code":"C","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2026-04-24 21:41:00","snet_input_date":"2026-04-20 00:00:00","source_office":"3ILS001","mcmis_add_date":"2026-04-24 21:41:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:42:32.000000Z","updated_at":"2026-05-26T09:30:04.000000Z","inspection_violations":[{"id":20417847,"change_date":"2026-05-15 21:45:00","inspection_id":"87673503","insp_violation_id":"274298219","seq_no":"1","part_no":"393","part_no_section":"45D","insp_viol_unit":"1","insp_unit_id":"213587983","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T10:06:24.000000Z","updated_at":"2026-05-26T09:45:44.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":20433849,"change_date":"2026-05-15 21:45:00","inspection_id":"87673503","insp_unit_id":"213587983","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5977","insp_unit_license":"48KT0M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EH1EN155977","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:21:33.000000Z","updated_at":"2026-05-26T09:01:51.000000Z"}]},{"id":11598008,"change_date":"2026-04-08 21:38:00","inspection_id":"87524773","dot_number":"3684206","report_state":"IL","report_number":"4182870508","insp_date":"2026-04-07 00:00:00","insp_start_time":"1658","insp_end_time":"1702","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-57","county_code_state":"IL","county_code":"197","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-08 21:38: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":"2465388","transaction_code":"A","transaction_date":"2026-04-07 00:00:00","upload_date":"2026-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2026-04-08 21:38:00","snet_input_date":"2026-04-07 00:00:00","source_office":"3ILS001","mcmis_add_date":"2026-04-08 21:38:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-11T09:42:42.000000Z","updated_at":"2026-04-19T09:33:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19879909,"change_date":"2026-04-08 21:38:00","inspection_id":"87524773","insp_unit_id":"212610310","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0456","insp_unit_license":"40KT4T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR2KSKJ0456","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-11T09:19:46.000000Z","updated_at":"2026-04-18T09:38:03.000000Z"}]},{"id":11328988,"change_date":"2026-03-10 21:38:00","inspection_id":"87245979","dot_number":"3684206","report_state":"MO","report_number":"5745003086","insp_date":"2026-03-09 00:00:00","insp_start_time":"1520","insp_end_time":"1536","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"50531","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":"2984134","transaction_code":"A","transaction_date":"2026-03-09 00:00:00","upload_date":"2026-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2026-03-10 21:38:00","snet_input_date":"2026-03-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-10 21:38:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-13T09:43:38.000000Z","updated_at":"2026-03-21T09:30:12.000000Z","inspection_violations":[{"id":19070670,"change_date":"2026-03-10 21:38:00","inspection_id":"87245979","insp_violation_id":"272297758","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:04:39.000000Z","updated_at":"2026-03-21T09:47:34.000000Z","normalized_code":"3922SLLS4"},{"id":19070671,"change_date":"2026-03-10 21:38:00","inspection_id":"87245979","insp_violation_id":"272297759","seq_no":"2","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":"2026-03-13T10:04:39.000000Z","updated_at":"2026-03-21T09:47:34.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":19385939,"change_date":"2026-03-10 21:38:00","inspection_id":"87245979","insp_unit_id":"212052814","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"7033","insp_unit_license":"63KT4T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4N99EH3GN947033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:14.000000Z","updated_at":"2026-03-21T09:09:12.000000Z"}]},{"id":10807161,"change_date":"2026-01-20 21:39:00","inspection_id":"86834101","dot_number":"3684206","report_state":"MO","report_number":"0672002484","insp_date":"2026-01-14 00:00:00","insp_start_time":"1418","insp_end_time":"1444","registration_date":null,"region":"CS","ci_status_code":"C","location":"F815J","location_desc":"NEW BLOOMFIELD MO","county_code_state":"MO","county_code":"027","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","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-01-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"127370","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":"2788727","transaction_code":"A","transaction_date":"2026-01-19 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2026-01-20 21:39:00","snet_input_date":"2026-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-20 21:39:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-23T10:36:10.000000Z","updated_at":"2026-01-31T10:30:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18146577,"change_date":"2026-01-20 21:39:00","inspection_id":"86834101","insp_unit_id":"211169010","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"0456","insp_unit_license":"40KT4T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR2KSKJ0456","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:14.000000Z","updated_at":"2026-01-31T10:02:32.000000Z"},{"id":18146578,"change_date":"2026-01-20 21:39:00","inspection_id":"86834101","insp_unit_id":"211169011","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DI-MOND TR","insp_unit_company":"AZNG DV500270","insp_unit_license":"PE28906","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"2DM42JA47SS212773","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:14.000000Z","updated_at":"2026-01-31T10:02:32.000000Z"}]},{"id":10812513,"change_date":"2026-05-01 21:40:00","inspection_id":"86839691","dot_number":"3684206","report_state":"IA","report_number":"000P13JBDD","insp_date":"2026-01-13 00:00:00","insp_start_time":"1130","insp_end_time":"1215","registration_date":null,"region":"CS","ci_status_code":"C","location":"45","location_desc":"IA","county_code_state":"IA","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON LOAD","shipping_paper_number":"AMAZON","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3243942","transaction_code":"C","transaction_date":"2026-05-01 00:00:00","upload_date":"2026-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2026-01-20 21:40:00","snet_input_date":"2026-01-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-20 21:40:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-23T10:36:26.000000Z","updated_at":"2026-05-12T09:30:03.000000Z","inspection_violations":[{"id":18072862,"change_date":"2026-05-01 21:40:00","inspection_id":"86839691","insp_violation_id":"273990779","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7RAM26011312003","created_at":"2026-01-23T10:42:37.000000Z","updated_at":"2026-05-12T09:41:42.000000Z","normalized_code":"3922"},{"id":18072863,"change_date":"2026-05-01 21:40:00","inspection_id":"86839691","insp_violation_id":"273990780","seq_no":"2","part_no":"392","part_no_section":"80A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"PCV7RAM26011312","created_at":"2026-01-23T10:42:37.000000Z","updated_at":"2026-05-12T09:41:42.000000Z","normalized_code":"39280A"},{"id":18072864,"change_date":"2026-05-01 21:40:00","inspection_id":"86839691","insp_violation_id":"273990781","seq_no":"3","part_no":"392","part_no_section":"4A-UI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"9","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"PCV7RAM26011312","created_at":"2026-01-23T10:42:37.000000Z","updated_at":"2026-05-12T09:41:42.000000Z","normalized_code":"3924AUI"}],"inspection_per_units":[{"id":18157894,"change_date":"2026-05-01 21:40:00","inspection_id":"86839691","insp_unit_id":"213337191","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"HV2502065","insp_unit_license":"PD76798","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K5SJ079421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:21.000000Z","updated_at":"2026-05-12T09:01:37.000000Z"},{"id":18157893,"change_date":"2026-05-01 21:40:00","inspection_id":"86839691","insp_unit_id":"213337190","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"0241","insp_unit_license":"62KT5T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NB9EH8HN990241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:21.000000Z","updated_at":"2026-05-12T09:01:37.000000Z"}]},{"id":10376546,"change_date":"2025-12-08 21:38:00","inspection_id":"86505711","dot_number":"3684206","report_state":"KY","report_number":"CV43955842","insp_date":"2025-12-08 00:00:00","insp_start_time":"0939","insp_end_time":"1037","registration_date":null,"region":"CT","ci_status_code":"C","location":"9815","location_desc":"FRANKLIN","county_code_state":"KY","county_code":"213","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"114QHBSC7","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":"2025-12-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2320920","transaction_code":"A","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2025-12-08 21:38:00","snet_input_date":"2025-12-08 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-12-08 21:38:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-11T10:30:31.000000Z","updated_at":"2025-12-12T10:30:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17345009,"change_date":"2025-12-08 21:38:00","inspection_id":"86505711","insp_unit_id":"210475497","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5357","insp_unit_license":"36KS7N","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FUJHHDR8MLMJ5357","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-11T10:00:29.000000Z","updated_at":"2025-12-12T10:00:39.000000Z"},{"id":17345010,"change_date":"2025-12-08 21:38:00","inspection_id":"86505711","insp_unit_id":"210475498","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"P5181168","insp_unit_license":"AN2192","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAP0629JK284944","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-11T10:00:29.000000Z","updated_at":"2025-12-12T10:00:39.000000Z"}]},{"id":10171531,"change_date":"2025-11-12 21:41:00","inspection_id":"86290817","dot_number":"3684206","report_state":"IL","report_number":"5002940052","insp_date":"2025-11-10 00:00:00","insp_start_time":"1557","insp_end_time":"1616","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-74","county_code_state":"IL","county_code":"143","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"112X4JYHF","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":"2025-11-11 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"123300","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":"2442525","transaction_code":"C","transaction_date":"2025-11-10 00:00:00","upload_date":"2025-11-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-11-11 21:34:00","snet_input_date":"2025-11-10 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-11-11 21:34:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-14T10:31:19.000000Z","updated_at":"2025-11-16T10:30:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16950338,"change_date":"2025-11-12 21:41:00","inspection_id":"86290817","insp_unit_id":"209978288","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STO","insp_unit_company":"SV2603854","insp_unit_license":"PF25828","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1DW1A5326TSC18090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:38.000000Z","updated_at":"2025-11-16T10:01:07.000000Z"},{"id":16950337,"change_date":"2025-11-12 21:41:00","inspection_id":"86290817","insp_unit_id":"209978287","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2473","insp_unit_license":"47KT5M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR1LSLS2473","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:38.000000Z","updated_at":"2025-11-16T10:01:07.000000Z"}]},{"id":10067478,"change_date":"2025-11-05 21:41:00","inspection_id":"86181142","dot_number":"3684206","report_state":"IL","report_number":"5005080309","insp_date":"2025-10-27 00:00:00","insp_start_time":"1035","insp_end_time":"1107","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"SEE LITERAL","county_code_state":"IL","county_code":"149","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","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":"2025-10-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2440924","transaction_code":"C","transaction_date":"2025-10-27 00:00:00","upload_date":"2025-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-10-29 21:40:00","snet_input_date":"2025-10-27 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-10-29 21:40:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:02:30.000000Z","updated_at":"2025-11-09T10:30:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16854810,"change_date":"2025-11-05 21:41:00","inspection_id":"86181142","insp_unit_id":"209861063","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GTD","insp_unit_company":"AZNG V524916","insp_unit_license":"P894141","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A0627MB234324","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-08T10:02:10.000000Z","updated_at":"2025-11-09T10:01:11.000000Z"},{"id":16854809,"change_date":"2025-11-05 21:41:00","inspection_id":"86181142","insp_unit_id":"209861062","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"83KT5T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FUJHHDR5MLMJ5395","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-08T10:02:10.000000Z","updated_at":"2025-11-09T10:01:11.000000Z"}]},{"id":9866137,"change_date":"2025-10-06 21:40:00","inspection_id":"85968896","dot_number":"3684206","report_state":"IL","report_number":"4182280102","insp_date":"2025-09-26 00:00:00","insp_start_time":"1726","insp_end_time":"1757","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"INTERSTATE 94","county_code_state":"IL","county_code":"031","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TON3","shipping_paper_number":"TON3DOOR207","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":"2025-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"2436139","transaction_code":"A","transaction_date":"2025-09-26 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-10-06 21:40:00","snet_input_date":"2025-09-26 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-10-06 21:40:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-09T10:00:50.000000Z","updated_at":"2025-10-10T10:01:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16364582,"change_date":"2025-10-06 21:40:00","inspection_id":"85968896","insp_unit_id":"209320245","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0456","insp_unit_license":"40KT4T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR2KSKJ0456","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:47.000000Z","updated_at":"2025-10-10T09:46:33.000000Z"}]},{"id":9695252,"change_date":"2025-09-16 21:39:00","inspection_id":"85789733","dot_number":"3684206","report_state":"KY","report_number":"CV44900149","insp_date":"2025-09-16 00:00:00","insp_start_time":"0700","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"KUTTAWA","county_code_state":"KY","county_code":"143","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"09162025","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":"2025-09-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","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":"2303440","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2025-09-16 21:39:00","snet_input_date":"2025-09-16 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-09-16 21:39:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:01:00.000000Z","updated_at":"2025-09-23T10:00:57.000000Z","inspection_violations":[{"id":15905131,"change_date":"2025-09-16 21:39:00","inspection_id":"85789733","insp_violation_id":"268728254","seq_no":"1","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"208979721","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:29.000000Z","updated_at":"2025-09-20T10:15:42.000000Z","normalized_code":"39348ABIBD"},{"id":15905132,"change_date":"2025-09-16 21:39:00","inspection_id":"85789733","insp_violation_id":"268728255","seq_no":"2","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"208979721","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:29.000000Z","updated_at":"2025-09-20T10:15:42.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":16048602,"change_date":"2025-09-16 21:39:00","inspection_id":"85789733","insp_unit_id":"208979720","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"9131","insp_unit_license":"62KT2T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR0JSJW9131","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:41.000000Z","updated_at":"2025-09-20T09:45:25.000000Z"},{"id":16048603,"change_date":"2025-09-16 21:39:00","inspection_id":"85789733","insp_unit_id":"208979721","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"V572472","insp_unit_license":"PB44686","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAP0624FD461850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:41.000000Z","updated_at":"2025-09-20T09:45:25.000000Z"}]},{"id":9450261,"change_date":"2025-08-19 21:40:00","inspection_id":"85532396","dot_number":"3684206","report_state":"IL","report_number":"4181130471","insp_date":"2025-08-18 00:00:00","insp_start_time":"0700","insp_end_time":"0722","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-55","county_code_state":"IL","county_code":"167","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"114VZK4HQ","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":"2025-08-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2425789","transaction_code":"A","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-08-19 21:40:00","snet_input_date":"2025-08-18 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-08-19 21:40:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:30.000000Z","updated_at":"2025-08-23T10:46:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15582906,"change_date":"2025-08-19 21:40:00","inspection_id":"85532396","insp_unit_id":"208471564","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1704","insp_unit_license":"62KT8T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDRDJSJX7410","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-22T09:46:42.000000Z","updated_at":"2025-08-23T09:46:00.000000Z"}]},{"id":9439045,"change_date":"2025-08-18 21:39:00","inspection_id":"85520681","dot_number":"3684206","report_state":"IA","report_number":"000P14RQGX","insp_date":"2025-08-16 00:00:00","insp_start_time":"2107","insp_end_time":"2150","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 218 DONNELLSON","county_code_state":"IA","county_code":"111","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"112XTFCYR","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":"2025-08-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1370815","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":"03684206","upload_search_indicator":"M","census_search_date":"2025-08-18 21:39:00","snet_input_date":"2025-08-16 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-08-18 21:39:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:45:57.000000Z","updated_at":"2025-08-23T10:45:57.000000Z","inspection_violations":[{"id":15364823,"change_date":"2025-08-18 21:39:00","inspection_id":"85520681","insp_violation_id":"268090360","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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-08-21T10:42:29.000000Z","updated_at":"2025-08-22T10:43:50.000000Z","normalized_code":"3922SLLS2"},{"id":15364824,"change_date":"2025-08-18 21:39:00","inspection_id":"85520681","insp_violation_id":"268090361","seq_no":"2","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"208449787","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"8ROH25081621392","created_at":"2025-08-21T10:42:29.000000Z","updated_at":"2025-08-22T10:43:50.000000Z","normalized_code":"3939ALSLIWR"},{"id":15364825,"change_date":"2025-08-18 21:39:00","inspection_id":"85520681","insp_violation_id":"268090362","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"208449787","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:29.000000Z","updated_at":"2025-08-22T10:43:50.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":15562592,"change_date":"2025-08-18 21:39:00","inspection_id":"85520681","insp_unit_id":"208449786","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"0241","insp_unit_license":"62KT5T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NB9EH8HN990241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:42.000000Z","updated_at":"2025-08-22T09:45:59.000000Z"},{"id":15562593,"change_date":"2025-08-18 21:39:00","inspection_id":"85520681","insp_unit_id":"208449787","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"V512740","insp_unit_license":"TN2480","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1DW1A5325LSA40849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:42.000000Z","updated_at":"2025-08-22T09:45:59.000000Z"}]},{"id":9347744,"change_date":"2025-08-07 21:39:00","inspection_id":"85424590","dot_number":"3684206","report_state":"TN","report_number":"I030H31807","insp_date":"2025-08-05 00:00:00","insp_start_time":"1835","insp_end_time":"1856","registration_date":null,"region":"ED","ci_status_code":"C","location":"KNXEN","location_desc":"KNOXVILLE TN","county_code_state":"TN","county_code":"093","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"US FOODS","shipping_paper_number":"045-89804","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-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2094794","transaction_code":"A","transaction_date":"2025-08-06 00:00:00","upload_date":"2025-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-08-07 21:39:00","snet_input_date":"2025-08-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-07 21:39:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:29.000000Z","updated_at":"2025-08-12T10:42:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15398938,"change_date":"2025-08-07 21:39:00","inspection_id":"85424590","insp_unit_id":"208273055","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"2473","insp_unit_license":"47KT5M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR1LSLS2473","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-10T09:46:15.000000Z","updated_at":"2025-08-11T09:45:13.000000Z"},{"id":15398939,"change_date":"2025-08-07 21:39:00","inspection_id":"85424590","insp_unit_id":"208273056","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":"V2012","insp_unit_license":"P719460","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"5V8VC5328LM001639","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-10T09:46:15.000000Z","updated_at":"2025-08-11T09:45:13.000000Z"}]},{"id":9287619,"change_date":"2025-07-30 21:40:00","inspection_id":"85361413","dot_number":"3684206","report_state":"IL","report_number":"4243470119","insp_date":"2025-07-29 00:00:00","insp_start_time":"0024","insp_end_time":"0040","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-55 NB","county_code_state":"IL","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"1142CSMS1","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":"2025-07-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"2422877","transaction_code":"A","transaction_date":"2025-07-29 00:00:00","upload_date":"2025-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-07-30 21:40:00","snet_input_date":"2025-07-29 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-07-30 21:40:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:14.000000Z","updated_at":"2025-08-04T10:01:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15291167,"change_date":"2025-07-30 21:40:00","inspection_id":"85361413","insp_unit_id":"208157978","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"9520","insp_unit_license":"62KT6T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR5LSLP9520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-02T09:46:26.000000Z","updated_at":"2025-08-03T09:45:53.000000Z"},{"id":15291168,"change_date":"2025-07-30 21:40:00","inspection_id":"85361413","insp_unit_id":"208157979","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"AZNGHV2306756","insp_unit_license":"PD98713","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532KXRS024614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-02T09:46:26.000000Z","updated_at":"2025-08-03T09:45:53.000000Z"}]},{"id":9172052,"change_date":"2025-07-17 21:41:00","inspection_id":"85239659","dot_number":"3684206","report_state":"MO","report_number":"3698001976","insp_date":"2025-07-16 00:00:00","insp_start_time":"1021","insp_end_time":"1052","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"2025-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2003519","transaction_code":"A","transaction_date":"2025-07-16 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-07-17 21:41:00","snet_input_date":"2025-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-17 21:41:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:06.000000Z","updated_at":"2025-07-21T10:43:06.000000Z","inspection_violations":[{"id":14810115,"change_date":"2025-07-17 21:41:00","inspection_id":"85239659","insp_violation_id":"267460556","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-07-21T10:45:27.000000Z","updated_at":"2025-07-21T10:45:27.000000Z","normalized_code":"3922SLLLR"},{"id":14810116,"change_date":"2025-07-17 21:41:00","inspection_id":"85239659","insp_violation_id":"267460557","seq_no":"2","part_no":"383","part_no_section":"51A-SIN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:27.000000Z","updated_at":"2025-07-21T10:45:27.000000Z","normalized_code":"38351ASIN"},{"id":14810117,"change_date":"2025-07-17 21:41:00","inspection_id":"85239659","insp_violation_id":"267460558","seq_no":"3","part_no":"383","part_no_section":"71H","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:27.000000Z","updated_at":"2025-07-21T10:45:27.000000Z","normalized_code":"38371H"}],"inspection_per_units":[{"id":15070413,"change_date":"2025-07-17 21:41:00","inspection_id":"85239659","insp_unit_id":"207917119","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"5395","insp_unit_license":"83KT5T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FUJHHDR5MLMJ5395","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:25.000000Z","updated_at":"2025-07-21T09:45:25.000000Z"}]},{"id":8934437,"change_date":"2025-06-19 21:37:00","inspection_id":"84987322","dot_number":"3684206","report_state":"IL","report_number":"5004970189","insp_date":"2025-06-16 00:00:00","insp_start_time":"0906","insp_end_time":"0928","registration_date":null,"region":"CT","ci_status_code":"C","location":"033","location_desc":"033 - WILLIAMSVILLE - I-55 S\/B","county_code_state":"IL","county_code":"167","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","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":"2025-06-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2414319","transaction_code":"C","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-06-18 21:41:00","snet_input_date":"2025-06-16 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-06-18 21:41:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-22T10:01:10.000000Z","updated_at":"2025-06-23T10:00:07.000000Z","inspection_violations":[{"id":14339814,"change_date":"2025-06-19 21:37:00","inspection_id":"84987322","insp_violation_id":"266937347","seq_no":"1","part_no":"393","part_no_section":"75A3","insp_viol_unit":"2","insp_unit_id":"207465595","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-06-22T10:16:37.000000Z","updated_at":"2025-06-23T10:15:09.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":14643138,"change_date":"2025-06-19 21:37:00","inspection_id":"84987322","insp_unit_id":"207465594","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"9520","insp_unit_license":"62KT6T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR5LSLP9520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:24.000000Z","updated_at":"2025-06-23T09:45:08.000000Z"},{"id":14643139,"change_date":"2025-06-19 21:37:00","inspection_id":"84987322","insp_unit_id":"207465595","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"V571316","insp_unit_license":"P897901","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532C3MR734091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:24.000000Z","updated_at":"2025-06-23T09:45:08.000000Z"}]},{"id":8943663,"change_date":"2025-06-20 21:36:00","inspection_id":"84999143","dot_number":"3684206","report_state":"IN","report_number":"6361005475","insp_date":"2025-06-13 00:00:00","insp_start_time":"1513","insp_end_time":"1545","registration_date":null,"region":"ED","ci_status_code":"C","location":"636101","location_desc":"WEST TERRE HAUTE IN","county_code_state":"IN","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"E BILLS","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-20 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","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":"1890847","transaction_code":"A","transaction_date":"2025-06-20 00:00:00","upload_date":"2025-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-06-20 21:36:00","snet_input_date":"2025-06-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-20 21:36:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-23T10:00:42.000000Z","updated_at":"2025-06-24T10:00:17.000000Z","inspection_violations":[{"id":14358618,"change_date":"2025-06-20 21:36:00","inspection_id":"84999143","insp_violation_id":"266947197","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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-06-23T10:16:14.000000Z","updated_at":"2025-06-24T10:15:27.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":14658557,"change_date":"2025-06-20 21:36:00","inspection_id":"84999143","insp_unit_id":"207473127","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"2473\/WHITE","insp_unit_license":"47KT5M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR1LSLS2473","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-23T09:45:50.000000Z","updated_at":"2025-06-24T09:45:21.000000Z"},{"id":14658558,"change_date":"2025-06-20 21:36:00","inspection_id":"84999143","insp_unit_id":"207473128","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"AZNGHV2504850","insp_unit_license":"PD77614","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K7SS076451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-23T09:45:50.000000Z","updated_at":"2025-06-24T09:45:21.000000Z"}]},{"id":8852882,"change_date":"2025-06-09 21:41:00","inspection_id":"84902758","dot_number":"3684206","report_state":"IA","report_number":"000P16C4FF","insp_date":"2025-06-08 00:00:00","insp_start_time":"0729","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 218\/27, SALEM IOWA","county_code_state":"IA","county_code":"087","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"1144GK7PT","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":"2025-06-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1363231","transaction_code":"A","transaction_date":"2025-06-09 00:00:00","upload_date":"2025-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2025-06-09 21:41:00","snet_input_date":"2025-06-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-06-09 21:41:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:33.000000Z","updated_at":"2025-06-14T10:00:33.000000Z","inspection_violations":[{"id":14178829,"change_date":"2025-06-09 21:41:00","inspection_id":"84902758","insp_violation_id":"266741350","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6CAV25060807382","created_at":"2025-06-12T10:15:52.000000Z","updated_at":"2025-06-13T10:17:41.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":14496709,"change_date":"2025-06-09 21:41:00","inspection_id":"84902758","insp_unit_id":"207294758","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5357","insp_unit_license":"36KS7N","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FUJHHDR8MLMJ5357","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:34.000000Z","updated_at":"2025-06-13T09:45:34.000000Z"},{"id":14496710,"change_date":"2025-06-09 21:41:00","inspection_id":"84902758","insp_unit_id":"207294759","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"V508548","insp_unit_license":"HV45404","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3H3V532C1LR439604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:34.000000Z","updated_at":"2025-06-13T09:45:34.000000Z"}]},{"id":8566038,"change_date":"2025-05-07 21:43:00","inspection_id":"84599876","dot_number":"3684206","report_state":"MO","report_number":"3958000864","insp_date":"2025-05-06 00:00:00","insp_start_time":"0855","insp_end_time":"0923","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"113WH52YC","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-07 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1695482","transaction_code":"A","transaction_date":"2025-05-07 00:00:00","upload_date":"2025-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-05-07 21:43:00","snet_input_date":"2025-05-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-07 21:43:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-10T10:52:21.000000Z","updated_at":"2025-05-11T10:11:40.000000Z","inspection_violations":[{"id":13584342,"change_date":"2025-05-07 21:43:00","inspection_id":"84599876","insp_violation_id":"266051326","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"206679236","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T11:11:08.000000Z","updated_at":"2025-05-10T11:22:49.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":13937892,"change_date":"2025-05-07 21:43:00","inspection_id":"84599876","insp_unit_id":"206679237","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"AZNGHV2503686","insp_unit_license":"PD75100","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K4SS075287","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:14:55.000000Z","updated_at":"2025-05-11T02:51:45.000000Z"},{"id":13937891,"change_date":"2025-05-07 21:43:00","inspection_id":"84599876","insp_unit_id":"206679236","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"6297","insp_unit_license":"62KT9T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR7JSJU6297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:14:55.000000Z","updated_at":"2025-05-11T02:51:45.000000Z"}]},{"id":8311070,"change_date":"2025-04-07 21:40:00","inspection_id":"84331253","dot_number":"3684206","report_state":"IA","report_number":"000P10L5BB","insp_date":"2025-04-03 00:00:00","insp_start_time":"0733","insp_end_time":"0948","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"NB I 35 30MM","county_code_state":"IA","county_code":"039","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"11554TN6V","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":"Y","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1355508","transaction_code":"A","transaction_date":"2025-04-07 00:00:00","upload_date":"2025-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2025-04-07 21:40:00","snet_input_date":"2025-04-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-04-07 21:40:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-11T10:11:19.000000Z","updated_at":"2025-04-11T10:11:19.000000Z","inspection_violations":[{"id":13075068,"change_date":"2025-04-07 21:40:00","inspection_id":"84331253","insp_violation_id":"265476620","seq_no":"1","part_no":"392","part_no_section":"4A-POS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"9","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"9MAJ25040307560","created_at":"2025-04-10T10:26:31.000000Z","updated_at":"2025-04-11T10:30:57.000000Z","normalized_code":"3924APOS"},{"id":13075069,"change_date":"2025-04-07 21:40:00","inspection_id":"84331253","insp_violation_id":"265476621","seq_no":"2","part_no":"392","part_no_section":"2C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9MAJ25040307581","created_at":"2025-04-10T10:26:31.000000Z","updated_at":"2025-04-11T10:30:57.000000Z","normalized_code":"3922C"}],"inspection_per_units":[{"id":13477805,"change_date":"2025-04-07 21:40:00","inspection_id":"84331253","insp_unit_id":"206186296","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"7033","insp_unit_license":"46KT5M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4N99EH3GN947033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-10T09:55:01.000000Z","updated_at":"2025-04-11T09:57:56.000000Z"},{"id":13477806,"change_date":"2025-04-07 21:40:00","inspection_id":"84331253","insp_unit_id":"206186297","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"V562141","insp_unit_license":"TL6295","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"3H3V532C6LT443196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-10T09:55:01.000000Z","updated_at":"2025-04-11T09:57:56.000000Z"}]},{"id":8173243,"change_date":"2025-03-21 21:39:00","inspection_id":"84186007","dot_number":"3684206","report_state":"MO","report_number":"3698001656","insp_date":"2025-03-20 00:00:00","insp_start_time":"1632","insp_end_time":"1658","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-21 21:39: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":"1495187","transaction_code":"A","transaction_date":"2025-03-20 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-03-21 21:39:00","snet_input_date":"2025-03-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-21 21:39:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-24T10:27:26.000000Z","updated_at":"2025-03-25T10:09:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13210121,"change_date":"2025-03-21 21:39:00","inspection_id":"84186007","insp_unit_id":"205917558","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"6297","insp_unit_license":"47KT4M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR7JSJU6297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-24T10:08:21.000000Z","updated_at":"2025-03-25T09:48:45.000000Z"}]},{"id":7956231,"change_date":"2025-02-25 21:40:00","inspection_id":"83957810","dot_number":"3684206","report_state":"KS","report_number":"HP03470409","insp_date":"2025-02-25 00:00:00","insp_start_time":"0103","insp_end_time":"0150","registration_date":null,"region":"CT","ci_status_code":"C","location":"BU","location_desc":"BUTLER COUNTY - 015","county_code_state":"KS","county_code":"015","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"HMC9-116F1WJSK","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":"2025-02-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1352677","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-02-25 21:40:00","snet_input_date":"2025-02-25 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-02-25 21:40:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:18.000000Z","updated_at":"2025-03-17T21:03:18.000000Z","inspection_violations":[{"id":12431823,"change_date":"2025-02-25 21:40:00","inspection_id":"83957810","insp_violation_id":"264689466","seq_no":"1","part_no":"393","part_no_section":"11A1-LHLM","insp_viol_unit":"1","insp_unit_id":"205490308","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:44.000000Z","updated_at":"2025-03-17T22:06:44.000000Z","normalized_code":"39311A1LHLM"},{"id":12431824,"change_date":"2025-02-25 21:40:00","inspection_id":"83957810","insp_violation_id":"264689467","seq_no":"2","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"205490308","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:44.000000Z","updated_at":"2025-03-17T22:06:44.000000Z","normalized_code":"39311A1CSLRR"}],"inspection_per_units":[{"id":12843616,"change_date":"2025-02-25 21:40:00","inspection_id":"83957810","insp_unit_id":"205490308","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0486","insp_unit_license":"84KT5M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR0KSKJ0486","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:52.000000Z","updated_at":"2025-03-17T23:56:52.000000Z"},{"id":12843617,"change_date":"2025-02-25 21:40:00","inspection_id":"83957810","insp_unit_id":"205490309","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MOND","insp_unit_company":"85124","insp_unit_license":"U687464","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"2MN01JAH481002405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:52.000000Z","updated_at":"2025-03-17T23:56:52.000000Z"}]},{"id":7944748,"change_date":"2025-02-24 21:40:00","inspection_id":"83945837","dot_number":"3684206","report_state":"IL","report_number":"5004970033","insp_date":"2025-02-23 00:00:00","insp_start_time":"1024","insp_end_time":"1048","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-55","county_code_state":"IL","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","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":"2025-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2386493","transaction_code":"A","transaction_date":"2025-02-23 00:00:00","upload_date":"2025-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-02-24 21:40:00","snet_input_date":"2025-02-23 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-02-24 21:40:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:14.000000Z","updated_at":"2025-03-17T21:03:14.000000Z","inspection_violations":[{"id":12412677,"change_date":"2025-02-24 21:40:00","inspection_id":"83945837","insp_violation_id":"264664165","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"1","insp_unit_id":"205468153","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"4","citation_number":"0049700006","created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":12825046,"change_date":"2025-02-24 21:40:00","inspection_id":"83945837","insp_unit_id":"205468153","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"4394","insp_unit_license":"46KT9M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EH5JN994394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:42.000000Z","updated_at":"2025-03-17T23:56:42.000000Z"},{"id":12825047,"change_date":"2025-02-24 21:40:00","inspection_id":"83945837","insp_unit_id":"205468154","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"910781","insp_unit_license":"438946T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3H3V532K9RS198268","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:42.000000Z","updated_at":"2025-03-17T23:56:42.000000Z"}]},{"id":7738907,"change_date":"2025-01-29 21:41:00","inspection_id":"83729457","dot_number":"3684206","report_state":"IL","report_number":"4289310074","insp_date":"2025-01-28 00:00:00","insp_start_time":"1703","insp_end_time":"1712","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-55","county_code_state":"IL","county_code":"113","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"STL8112BMDBJC","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":"2025-01-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"131350","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":"2382513","transaction_code":"A","transaction_date":"2025-01-28 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-01-29 21:41:00","snet_input_date":"2025-01-28 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-01-29 21:41:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:46.000000Z","updated_at":"2025-03-17T20:58:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12488595,"change_date":"2025-01-29 21:41:00","inspection_id":"83729457","insp_unit_id":"205064485","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7401","insp_unit_license":"47KT3M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR0JSJX7410","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:46.000000Z","updated_at":"2025-03-17T23:52:46.000000Z"},{"id":12488596,"change_date":"2025-01-29 21:41:00","inspection_id":"83729457","insp_unit_id":"205064486","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"528948","insp_unit_license":"82982AC","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3H3V532C2GT241106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:46.000000Z","updated_at":"2025-03-17T23:52:46.000000Z"}]},{"id":7718051,"change_date":"2025-01-27 21:40:00","inspection_id":"83707660","dot_number":"3684206","report_state":"IL","report_number":"4178570135","insp_date":"2025-01-25 00:00:00","insp_start_time":"0128","insp_end_time":"0139","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-57","county_code_state":"IL","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"2382277","transaction_code":"A","transaction_date":"2025-01-25 00:00:00","upload_date":"2025-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-01-27 21:40:00","snet_input_date":"2025-01-25 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-01-27 21:40:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:21.000000Z","updated_at":"2025-03-17T20:58:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12454783,"change_date":"2025-01-27 21:40:00","inspection_id":"83707660","insp_unit_id":"205023141","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"47KT3M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR0JSJX7410","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:24.000000Z","updated_at":"2025-03-17T23:52:24.000000Z"}]},{"id":7691793,"change_date":"2025-01-23 21:38:00","inspection_id":"83680101","dot_number":"3684206","report_state":"IN","report_number":"8758002755","insp_date":"2025-01-18 00:00:00","insp_start_time":"0939","insp_end_time":"1038","registration_date":null,"region":"ES","ci_status_code":"C","location":"5370E","location_desc":"TERRE HAUTE IN","county_code_state":"IN","county_code":"167","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":"2025-01-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"3","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":"1280330","transaction_code":"A","transaction_date":"2025-01-23 00:00:00","upload_date":"2025-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-01-23 21:38:00","snet_input_date":"2025-01-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-23 21:38:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:54.000000Z","updated_at":"2025-03-17T20:57:54.000000Z","inspection_violations":[{"id":12018912,"change_date":"2025-01-23 21:38:00","inspection_id":"83680101","insp_violation_id":"264140130","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"204972209","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:32.000000Z","updated_at":"2025-03-17T22:04:32.000000Z","normalized_code":"39355EB"},{"id":12018913,"change_date":"2025-01-23 21:38:00","inspection_id":"83680101","insp_violation_id":"264140131","seq_no":"2","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"204972208","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:32.000000Z","updated_at":"2025-03-17T22:04:32.000000Z","normalized_code":"39345DBAAL"},{"id":12018914,"change_date":"2025-01-23 21:38:00","inspection_id":"83680101","insp_violation_id":"264140132","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"204972208","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:32.000000Z","updated_at":"2025-03-17T22:04:32.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":12411860,"change_date":"2025-01-23 21:38:00","inspection_id":"83680101","insp_unit_id":"204972208","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"0918","insp_unit_license":"47KT7M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR6KSKX0918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:58.000000Z","updated_at":"2025-03-17T23:51:58.000000Z"},{"id":12411861,"change_date":"2025-01-23 21:38:00","inspection_id":"83680101","insp_unit_id":"204972209","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"WV2500343","insp_unit_license":"PE20783","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D4SL554465","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:58.000000Z","updated_at":"2025-03-17T23:51:58.000000Z"}]},{"id":7651849,"change_date":"2025-01-17 21:40:00","inspection_id":"83638196","dot_number":"3684206","report_state":"IA","report_number":"000P151VDQ","insp_date":"2025-01-15 00:00:00","insp_start_time":"0826","insp_end_time":"0905","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"MSP1113WH72XW","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":"2025-01-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1345907","transaction_code":"A","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2025-01-17 21:40:00","snet_input_date":"2025-01-15 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-01-17 21:40:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:02.000000Z","updated_at":"2025-03-17T20:57:02.000000Z","inspection_violations":[{"id":11954438,"change_date":"2025-01-17 21:40:00","inspection_id":"83638196","insp_violation_id":"264059289","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"204896338","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0NEL25011508490","created_at":"2025-03-17T22:04:13.000000Z","updated_at":"2025-03-17T22:04:13.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":12346782,"change_date":"2025-01-17 21:40:00","inspection_id":"83638196","insp_unit_id":"204896337","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6297","insp_unit_license":"47KT4M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR7JSJU6297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:16.000000Z","updated_at":"2025-03-17T23:51:16.000000Z"},{"id":12346783,"change_date":"2025-01-17 21:40:00","inspection_id":"83638196","insp_unit_id":"204896338","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"GV2201088","insp_unit_license":"PA88818","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A0626NB333766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:16.000000Z","updated_at":"2025-03-17T23:51:16.000000Z"}]},{"id":7621175,"change_date":"2025-01-15 21:41:00","inspection_id":"83605996","dot_number":"3684206","report_state":"IN","report_number":"7968000968","insp_date":"2025-01-11 00:00:00","insp_start_time":"1336","insp_end_time":"1353","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"LAFAYETTE IN","county_code_state":"IN","county_code":"157","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"IND-MSP1-B6A882","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1247913","transaction_code":"A","transaction_date":"2025-01-14 00:00:00","upload_date":"2025-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2025-01-15 21:41:00","snet_input_date":"2025-01-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-15 21:41:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:29.000000Z","updated_at":"2025-03-17T20:56:29.000000Z","inspection_violations":[{"id":11913049,"change_date":"2025-01-15 21:41:00","inspection_id":"83605996","insp_violation_id":"264005914","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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:04:01.000000Z","updated_at":"2025-03-17T22:04:01.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":12297133,"change_date":"2025-01-15 21:41:00","inspection_id":"83605996","insp_unit_id":"204837784","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"9520","insp_unit_license":"92KT7M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR5LSLP9520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:43.000000Z","updated_at":"2025-03-17T23:50:43.000000Z"},{"id":12297134,"change_date":"2025-01-15 21:41:00","inspection_id":"83605996","insp_unit_id":"204837785","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"GV2201059","insp_unit_license":"PA88289","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A062XNB333737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:43.000000Z","updated_at":"2025-03-17T23:50:43.000000Z"}]},{"id":7516604,"change_date":"2024-12-30 21:38:00","inspection_id":"83496161","dot_number":"3684206","report_state":"MO","report_number":"W128000272","insp_date":"2024-12-28 00:00:00","insp_start_time":"0857","insp_end_time":"0950","registration_date":null,"region":"CS","ci_status_code":"C","location":"C5S","location_desc":"ST GENEVIEVE MO","county_code_state":"MO","county_code":"186","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"11R476VJH","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","viol_total":"2","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":"1203667","transaction_code":"A","transaction_date":"2024-12-30 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2024-12-30 21:38:00","snet_input_date":"2024-12-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-30 21:38:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:43.000000Z","updated_at":"2025-03-17T20:52:43.000000Z","inspection_violations":[{"id":11748230,"change_date":"2024-12-30 21:38:00","inspection_id":"83496161","insp_violation_id":"263688042","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"204587133","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"39375A3TAOL"},{"id":11748231,"change_date":"2024-12-30 21:38:00","inspection_id":"83496161","insp_violation_id":"263688043","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"204587133","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":12126744,"change_date":"2024-12-30 21:38:00","inspection_id":"83496161","insp_unit_id":"204587133","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"7257","insp_unit_license":"47KT8M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FUJGLD55GLHB7257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:53.000000Z","updated_at":"2025-03-17T23:48:53.000000Z"},{"id":12126745,"change_date":"2024-12-30 21:38:00","inspection_id":"83496161","insp_unit_id":"204587134","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"V569927","insp_unit_license":"P895143","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532C9MR732216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:53.000000Z","updated_at":"2025-03-17T23:48:53.000000Z"}]},{"id":7519241,"change_date":"2024-12-30 21:39:00","inspection_id":"83498961","dot_number":"3684206","report_state":"IL","report_number":"5001480030","insp_date":"2024-12-27 00:00:00","insp_start_time":"2331","insp_end_time":"2347","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-57","county_code_state":"IL","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"2378777","transaction_code":"A","transaction_date":"2024-12-27 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2024-12-30 21:39:00","snet_input_date":"2024-12-27 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-12-30 21:39:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:44.000000Z","updated_at":"2025-03-17T20:52:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12130768,"change_date":"2024-12-30 21:39:00","inspection_id":"83498961","insp_unit_id":"204592869","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7410","insp_unit_license":"47KT3M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR0JSJX7410","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:56.000000Z","updated_at":"2025-03-17T23:48:56.000000Z"}]},{"id":7484604,"change_date":"2025-01-14 21:53:00","inspection_id":"83462667","dot_number":"3684206","report_state":"AR","report_number":"7880000532","insp_date":"2024-12-22 00:00:00","insp_start_time":"0655","insp_end_time":"0740","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"TUCKERMAN AR","county_code_state":"AR","county_code":"067","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"116LXQTKZ","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1188735","transaction_code":"C","transaction_date":"2024-12-23 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2024-12-23 21:39:00","snet_input_date":"2024-12-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-23 21:39:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:18.000000Z","updated_at":"2025-03-17T20:52:18.000000Z","inspection_violations":[{"id":11700442,"change_date":"2025-01-14 21:53:00","inspection_id":"83462667","insp_violation_id":"263936981","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"204798000","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"3939ALHLI"},{"id":11700443,"change_date":"2025-01-14 21:53:00","inspection_id":"83462667","insp_violation_id":"263936982","seq_no":"2","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"204798001","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":12074851,"change_date":"2025-01-14 21:53:00","inspection_id":"83462667","insp_unit_id":"204798000","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"9520","insp_unit_license":"92KT7M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR5LSLP9520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:19.000000Z","updated_at":"2025-03-17T23:48:19.000000Z"},{"id":12074852,"change_date":"2025-01-14 21:53:00","inspection_id":"83462667","insp_unit_id":"204798001","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"V504853","insp_unit_license":"HV38911","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3H3V532C6KT710111","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:19.000000Z","updated_at":"2025-03-17T23:48:19.000000Z"}]},{"id":7269646,"change_date":"2024-11-24 21:33:00","inspection_id":"83236392","dot_number":"3684206","report_state":"IN","report_number":"8928000521","insp_date":"2024-11-19 00:00:00","insp_start_time":"1146","insp_end_time":"1224","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"LAFAYETTE IN","county_code_state":"IN","county_code":"157","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-24 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1088267","transaction_code":"A","transaction_date":"2024-11-24 00:00:00","upload_date":"2024-11-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2024-11-24 21:33:00","snet_input_date":"2024-11-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-24 21:33:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5605 GREENTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:43.000000Z","updated_at":"2025-03-17T20:47:43.000000Z","inspection_violations":[{"id":11363722,"change_date":"2024-11-24 21:33:00","inspection_id":"83236392","insp_violation_id":"263062973","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:01:13.000000Z","updated_at":"2025-03-17T22:01:13.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":11726029,"change_date":"2024-11-24 21:33:00","inspection_id":"83236392","insp_unit_id":"204031470","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"0918","insp_unit_license":"47KT7M","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"3AKJHHDR6KSKX0918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:32.000000Z","updated_at":"2025-03-17T23:44:32.000000Z"},{"id":11726030,"change_date":"2024-11-24 21:33:00","inspection_id":"83236392","insp_unit_id":"204031471","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"P5220527","insp_unit_license":"233916T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1P0621NT432729","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:32.000000Z","updated_at":"2025-03-17T23:44:32.000000Z"}]},{"id":5370241,"change_date":"2024-03-27 21:42:00","inspection_id":"81197164","dot_number":"3684206","report_state":"IL","report_number":"4037140083","insp_date":"2024-03-25 00:00:00","insp_start_time":"1221","insp_end_time":"1229","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-70","county_code_state":"IL","county_code":"119","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"140000","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":"2313574","transaction_code":"C","transaction_date":"2024-03-25 00:00:00","upload_date":"2024-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2024-03-26 21:43:00","snet_input_date":"2024-03-25 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-03-26 21:43:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:04.000000Z","updated_at":"2025-03-17T20:09:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8648756,"change_date":"2024-03-27 21:42:00","inspection_id":"81197164","insp_unit_id":"200114150","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1300","insp_unit_license":"72KS1J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKGGLDR4HSHY1300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:26.000000Z","updated_at":"2025-03-17T23:13:26.000000Z"},{"id":8648757,"change_date":"2024-03-27 21:42:00","inspection_id":"81197164","insp_unit_id":"200114151","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"V504992","insp_unit_license":"PD67063","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532C5KR686400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:26.000000Z","updated_at":"2025-03-17T23:13:26.000000Z"}]},{"id":4866634,"change_date":"2024-01-19 21:44:00","inspection_id":"80647433","dot_number":"3684206","report_state":"IL","report_number":"4069050616","insp_date":"2024-01-16 00:00:00","insp_start_time":"0940","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I70","county_code_state":"IL","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"1111G27DB","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2301939","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2024-01-19 21:44:00","snet_input_date":"2024-01-16 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-01-19 21:44:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:13.000000Z","updated_at":"2025-03-17T19:59:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7830216,"change_date":"2024-01-19 21:44:00","inspection_id":"80647433","insp_unit_id":"199033077","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5977","insp_unit_license":"72KS8S","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EH1EN155977","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:59.000000Z","updated_at":"2025-03-17T23:05:59.000000Z"},{"id":7830217,"change_date":"2024-01-19 21:44:00","inspection_id":"80647433","insp_unit_id":"199033078","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"V510872","insp_unit_license":"TM5122","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1DW1A5325LBA33500","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:59.000000Z","updated_at":"2025-03-17T23:05:59.000000Z"}]},{"id":4838341,"change_date":"2024-01-16 21:44:00","inspection_id":"80616513","dot_number":"3684206","report_state":"IA","report_number":"000P131TS0","insp_date":"2024-01-15 00:00:00","insp_start_time":"0903","insp_end_time":"0940","registration_date":null,"region":"CT","ci_status_code":"C","location":"45","location_desc":"45 - HWY 218 NB MM 29 PILOT GR","county_code_state":"IA","county_code":"111","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZONE","shipping_paper_number":"114QK5XC4","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1300014","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2024-01-16 21:44:00","snet_input_date":"2024-01-15 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-01-16 21:44:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:29.000000Z","updated_at":"2025-03-17T19:58:29.000000Z","inspection_violations":[{"id":7459007,"change_date":"2024-01-16 21:44:00","inspection_id":"80616513","insp_violation_id":"257350129","seq_no":"1","part_no":"395","part_no_section":"30(b)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:58.000000Z","updated_at":"2025-03-17T21:41:58.000000Z","normalized_code":"39530B1"},{"id":7459008,"change_date":"2024-01-16 21:44:00","inspection_id":"80616513","insp_violation_id":"257350130","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198971431","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:58.000000Z","updated_at":"2025-03-17T21:41:58.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7784347,"change_date":"2024-01-16 21:44:00","inspection_id":"80616513","insp_unit_id":"198971431","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"8515","insp_unit_license":"13KS3K","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EJ1FN188515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:33.000000Z","updated_at":"2025-03-17T23:05:33.000000Z"},{"id":7784348,"change_date":"2024-01-16 21:44:00","inspection_id":"80616513","insp_unit_id":"198971432","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"W91180","insp_unit_license":"441963Z","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1M1AN4GY0LM014566","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:33.000000Z","updated_at":"2025-03-17T23:05:33.000000Z"}]},{"id":4690991,"change_date":"2023-12-22 21:40:00","inspection_id":"80455644","dot_number":"3684206","report_state":"MO","report_number":"1645000491","insp_date":"2023-12-21 00:00:00","insp_start_time":"0734","insp_end_time":"0754","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-12-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"141460","transaction_code":"A","transaction_date":"2023-12-21 00:00:00","upload_date":"2023-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2023-12-22 21:40:00","snet_input_date":"2023-12-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-22 21:40:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:47.000000Z","updated_at":"2025-03-17T19:55:47.000000Z","inspection_violations":[{"id":7249501,"change_date":"2023-12-22 21:40:00","inspection_id":"80455644","insp_violation_id":"257026747","seq_no":"1","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"198635916","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"39311A1CSURR"}],"inspection_per_units":[{"id":7545237,"change_date":"2023-12-22 21:40:00","inspection_id":"80455644","insp_unit_id":"198635916","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"6297","insp_unit_license":"88KS2Z","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHHDR7JSJU6297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:28.000000Z","updated_at":"2025-03-17T23:03:28.000000Z"}]},{"id":4281665,"change_date":"2023-11-01 21:43:00","inspection_id":"80004874","dot_number":"3684206","report_state":"KY","report_number":"B916000124","insp_date":"2023-10-24 00:00:00","insp_start_time":"1651","insp_end_time":"1757","registration_date":"2023-11-01 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"PETERSBURG","county_code_state":"KY","county_code":"015","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"GANDALF 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":"Y","pen_cen_match":null,"final_status_date":"2023-10-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"2192503","transaction_code":"C","transaction_date":"2023-10-25 00:00:00","upload_date":"2023-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2023-10-25 21:42:00","snet_input_date":"2023-10-25 00:00:00","source_office":"2KYS001","mcmis_add_date":"2023-10-25 21:42:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:49.000000Z","updated_at":"2025-03-17T19:47:49.000000Z","inspection_violations":[{"id":6623560,"change_date":"2023-11-01 21:43:00","inspection_id":"80004874","insp_violation_id":"256162203","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197853940","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:56.000000Z","updated_at":"2025-03-17T21:37:56.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":6885858,"change_date":"2023-11-01 21:43:00","inspection_id":"80004874","insp_unit_id":"197853940","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"4394","insp_unit_license":"93KS9L","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH5JN994394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:45.000000Z","updated_at":"2025-03-17T22:57:45.000000Z"},{"id":6885859,"change_date":"2023-11-01 21:43:00","inspection_id":"80004874","insp_unit_id":"197853941","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"W22468","insp_unit_license":"314580Z","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3H3V532C1HT371556","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:45.000000Z","updated_at":"2025-03-17T22:57:45.000000Z"}]},{"id":3801996,"change_date":"2023-08-22 21:43:00","inspection_id":"79472183","dot_number":"3684206","report_state":"IL","report_number":"4182630049","insp_date":"2023-08-22 00:00:00","insp_start_time":"0100","insp_end_time":"0105","registration_date":null,"region":"CT","ci_status_code":"C","location":"032","location_desc":"032 - LITCHFIELD - I-55 N\/B","county_code_state":"IL","county_code":"135","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","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":"2270326","transaction_code":"A","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2023-08-22 21:43:00","snet_input_date":"2023-08-22 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-08-22 21:43:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:01.000000Z","updated_at":"2025-03-17T19:38:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6112957,"change_date":"2023-08-22 21:43:00","inspection_id":"79472183","insp_unit_id":"196663241","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1300","insp_unit_license":"72KS1J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKGGLDR4HSHY1300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:21.000000Z","updated_at":"2025-03-17T22:51:21.000000Z"}]},{"id":3427735,"change_date":"2023-07-04 21:32:00","inspection_id":"79052694","dot_number":"3684206","report_state":"IN","report_number":"9109001313","insp_date":"2023-06-30 00:00:00","insp_start_time":"0644","insp_end_time":"0707","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD SIDE LAFAYETTE","county_code_state":"IN","county_code":"157","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-07-04 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2195548","transaction_code":"A","transaction_date":"2023-07-04 00:00:00","upload_date":"2023-07-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2023-07-04 21:32:00","snet_input_date":"2023-07-03 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-07-04 21:32:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:56.000000Z","updated_at":"2025-03-17T19:30:56.000000Z","inspection_violations":[{"id":5285531,"change_date":"2023-07-04 21:32:00","inspection_id":"79052694","insp_violation_id":"253853810","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:33.000000Z","updated_at":"2025-03-17T21:31:33.000000Z","normalized_code":"3922"},{"id":5285532,"change_date":"2023-07-04 21:32:00","inspection_id":"79052694","insp_violation_id":"253853811","seq_no":"2","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:33.000000Z","updated_at":"2025-03-17T21:31:33.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":5511161,"change_date":"2023-07-04 21:32:00","inspection_id":"79052694","insp_unit_id":"195813598","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"8515","insp_unit_license":"13KS3K","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EJ1FN188515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:30.000000Z","updated_at":"2025-03-17T22:46:30.000000Z"},{"id":5511162,"change_date":"2023-07-04 21:32:00","inspection_id":"79052694","insp_unit_id":"195813599","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"564375","insp_unit_license":"TM779","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"3H3V532C2LR445430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:30.000000Z","updated_at":"2025-03-17T22:46:30.000000Z"}]},{"id":3259210,"change_date":"2023-06-12 21:40:00","inspection_id":"78863052","dot_number":"3684206","report_state":"IL","report_number":"4182020056","insp_date":"2023-06-12 00:00:00","insp_start_time":"0910","insp_end_time":"0924","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-70","county_code_state":"IL","county_code":"119","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"116W2CRW3","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"2252141","transaction_code":"A","transaction_date":"2023-06-12 00:00:00","upload_date":"2023-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2023-06-12 21:40:00","snet_input_date":"2023-06-12 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-06-12 21:40:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:23.000000Z","updated_at":"2025-03-17T19:27:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5241303,"change_date":"2023-06-12 21:40:00","inspection_id":"78863052","insp_unit_id":"195440413","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1300","insp_unit_license":"72KS1J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKGGLDR4HSHY1300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:19.000000Z","updated_at":"2025-03-17T22:44:19.000000Z"},{"id":5241304,"change_date":"2023-06-12 21:40:00","inspection_id":"78863052","insp_unit_id":"195440414","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"V567768","insp_unit_license":"TN3560","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"3H3V532CXLR294837","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:19.000000Z","updated_at":"2025-03-17T22:44:19.000000Z"}]},{"id":3229774,"change_date":"2023-06-07 21:42:00","inspection_id":"78829929","dot_number":"3684206","report_state":"IA","report_number":"000TT8B2HD","insp_date":"2023-06-06 00:00:00","insp_start_time":"1120","insp_end_time":"1145","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I80","county_code_state":"IA","county_code":"153","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"1132HG2Q9","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1278088","transaction_code":"A","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2023-06-07 21:42:00","snet_input_date":"2023-06-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-06-07 21:42:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:54.000000Z","updated_at":"2025-03-17T19:26:54.000000Z","inspection_violations":[{"id":4977920,"change_date":"2023-06-07 21:42:00","inspection_id":"78829929","insp_violation_id":"253353148","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:08.000000Z","updated_at":"2025-03-17T21:30:08.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5194165,"change_date":"2023-06-07 21:42:00","inspection_id":"78829929","insp_unit_id":"195370138","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3222","insp_unit_license":"13KS5J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJGLD5XGSGW3222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:55.000000Z","updated_at":"2025-03-17T22:43:55.000000Z"},{"id":5194166,"change_date":"2023-06-07 21:42:00","inspection_id":"78829929","insp_unit_id":"195370139","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"HV2302522","insp_unit_license":"PB46715","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532KXPS061580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:55.000000Z","updated_at":"2025-03-17T22:43:55.000000Z"}]},{"id":3118172,"change_date":"2023-06-01 21:42:00","inspection_id":"78704047","dot_number":"3684206","report_state":"IN","report_number":"8758001107","insp_date":"2023-05-22 00:00:00","insp_start_time":"0627","insp_end_time":"0649","registration_date":"2023-05-31 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"I 70 EB @ 11 MM","county_code_state":"IN","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"STL6-1129-1H19R","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2190832","transaction_code":"C","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2023-05-23 21:42:00","snet_input_date":"2023-05-23 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-05-23 21:42:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:38.000000Z","updated_at":"2025-03-17T19:24:38.000000Z","inspection_violations":[{"id":4799753,"change_date":"2023-06-01 21:42:00","inspection_id":"78704047","insp_violation_id":"253213524","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:18.000000Z","updated_at":"2025-03-17T21:29:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5015466,"change_date":"2023-06-01 21:42:00","inspection_id":"78704047","insp_unit_id":"195260168","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"8011","insp_unit_license":"30KS7S","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EH7GN948011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:33.000000Z","updated_at":"2025-03-17T22:42:33.000000Z"},{"id":5015467,"change_date":"2023-06-01 21:42:00","inspection_id":"78704047","insp_unit_id":"195260169","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"AZNGHV220158","insp_unit_license":"PA83944","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532KXNS885589","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:33.000000Z","updated_at":"2025-03-17T22:42:33.000000Z"}]},{"id":3067332,"change_date":"2023-06-01 21:42:00","inspection_id":"78646612","dot_number":"3684206","report_state":"IL","report_number":"4005241507","insp_date":"2023-05-16 00:00:00","insp_start_time":"1110","insp_end_time":"1155","registration_date":"2023-06-01 00:00:00","region":"CT","ci_status_code":"C","location":"999","location_desc":"IL-3 @ YELLOW BRICK RD","county_code_state":"IL","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","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":"2244736","transaction_code":"C","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2023-05-17 21:43:00","snet_input_date":"2023-05-16 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-05-17 21:43:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:46.000000Z","updated_at":"2025-03-17T19:23:46.000000Z","inspection_violations":[{"id":4712313,"change_date":"2023-06-01 21:42:00","inspection_id":"78646612","insp_violation_id":"253211790","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"195258111","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:57.000000Z","updated_at":"2025-03-17T21:28:57.000000Z","normalized_code":"39375A"},{"id":4712314,"change_date":"2023-06-01 21:42:00","inspection_id":"78646612","insp_violation_id":"253211791","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"195258111","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:57.000000Z","updated_at":"2025-03-17T21:28:57.000000Z","normalized_code":"39021TB"},{"id":4712315,"change_date":"2023-06-01 21:42:00","inspection_id":"78646612","insp_violation_id":"253211792","seq_no":"3","part_no":"395","part_no_section":"24(c)(2)(iii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:57.000000Z","updated_at":"2025-03-17T21:28:57.000000Z","normalized_code":"39524C2III"},{"id":4712316,"change_date":"2023-06-01 21:42:00","inspection_id":"78646612","insp_violation_id":"253211793","seq_no":"4","part_no":"395","part_no_section":"22(h)(3)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:57.000000Z","updated_at":"2025-03-17T21:28:57.000000Z","normalized_code":"39522H3"},{"id":4712317,"change_date":"2023-06-01 21:42:00","inspection_id":"78646612","insp_violation_id":"253211794","seq_no":"5","part_no":"395","part_no_section":"22(h)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:57.000000Z","updated_at":"2025-03-17T21:28:57.000000Z","normalized_code":"39522H1"},{"id":4712318,"change_date":"2023-06-01 21:42:00","inspection_id":"78646612","insp_violation_id":"253211795","seq_no":"6","part_no":"395","part_no_section":"24(c)(2)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:57.000000Z","updated_at":"2025-03-17T21:28:57.000000Z","normalized_code":"39524C2II"}],"inspection_per_units":[{"id":4934345,"change_date":"2023-06-01 21:42:00","inspection_id":"78646612","insp_unit_id":"195258111","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRET","insp_unit_company":"3222","insp_unit_license":"13KS5J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJGLD5XGSGW3222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:53.000000Z","updated_at":"2025-03-17T22:41:53.000000Z"}]},{"id":2987981,"change_date":"2023-05-08 21:42:00","inspection_id":"78557145","dot_number":"3684206","report_state":"IL","report_number":"3998321345","insp_date":"2023-05-07 00:00:00","insp_start_time":"0905","insp_end_time":"0920","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-55","county_code_state":"IL","county_code":"167","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"ORD9113HRQ9DJ","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-05-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"2242567","transaction_code":"A","transaction_date":"2023-05-07 00:00:00","upload_date":"2023-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2023-05-08 21:42:00","snet_input_date":"2023-05-07 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-05-08 21:42:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:15.000000Z","updated_at":"2025-03-17T19:22:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4807081,"change_date":"2023-05-08 21:42:00","inspection_id":"78557145","insp_unit_id":"194802116","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"8515","insp_unit_license":"13KS3K","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EJ1FN188515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:52.000000Z","updated_at":"2025-03-17T22:40:52.000000Z"},{"id":4807082,"change_date":"2023-05-08 21:42:00","inspection_id":"78557145","insp_unit_id":"194802117","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"AZNG3999","insp_unit_license":"HV38007","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3H3V532C7KT709257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:52.000000Z","updated_at":"2025-03-17T22:40:52.000000Z"}]},{"id":2412998,"change_date":"2023-02-21 21:41:00","inspection_id":"77903994","dot_number":"3684206","report_state":"MO","report_number":"1507019779","insp_date":"2023-02-14 00:00:00","insp_start_time":"1142","insp_end_time":"1215","registration_date":null,"region":"CT","ci_status_code":"C","location":"C370","location_desc":"MO 370 @ ELM","county_code_state":"MO","county_code":"183","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-21 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":"2058815","transaction_code":"A","transaction_date":"2023-02-14 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2023-02-21 21:41:00","snet_input_date":"2023-02-21 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-02-21 21:41:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128-3809","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:05.000000Z","updated_at":"2025-03-17T19:11:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3882809,"change_date":"2023-02-21 21:41:00","inspection_id":"77903994","insp_unit_id":"193495903","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0717","insp_unit_license":"30KS8S","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FUJGLD52GLGR0717","insp_unit_decal":"Y","insp_unit_decal_number":"32377212","created_at":"2025-03-17T22:33:48.000000Z","updated_at":"2025-03-17T22:33:48.000000Z"}]},{"id":2304066,"change_date":"2023-02-06 21:41:00","inspection_id":"77779539","dot_number":"3684206","report_state":"IN","report_number":"8477002694","insp_date":"2023-02-05 00:00:00","insp_start_time":"2305","insp_end_time":"2345","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"71 MM I-70 WB","county_code_state":"IN","county_code":"097","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"NUMEROUS SHIPPERS","shipping_paper_number":"AZNG","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2174137","transaction_code":"A","transaction_date":"2023-02-06 00:00:00","upload_date":"2023-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2023-02-06 21:41:00","snet_input_date":"2023-02-06 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-02-06 21:41:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:13.000000Z","updated_at":"2025-03-17T19:09:13.000000Z","inspection_violations":[{"id":3550511,"change_date":"2023-02-06 21:41:00","inspection_id":"77779539","insp_violation_id":"250967101","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"42","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3708736,"change_date":"2023-02-06 21:41:00","inspection_id":"77779539","insp_unit_id":"193244771","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3222","insp_unit_license":null,"insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJGLD5XGSGW3222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:33.000000Z","updated_at":"2025-03-17T22:32:33.000000Z"},{"id":3708737,"change_date":"2023-02-06 21:41:00","inspection_id":"77779539","insp_unit_id":"193244772","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BREI","insp_unit_company":"AZNGHV230506","insp_unit_license":"P63669","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"10BFB72T94F0B5549","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:33.000000Z","updated_at":"2025-03-17T22:32:33.000000Z"}]},{"id":2254449,"change_date":"2023-04-11 12:04:00","inspection_id":"77723234","dot_number":"3684206","report_state":"IN","report_number":"7809002966","insp_date":"2023-01-27 00:00:00","insp_start_time":"1517","insp_end_time":"1547","registration_date":"2023-02-03 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"I-64 W\/B @ 10.5 MM","county_code_state":"IN","county_code":"129","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"1113M8JC7","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2172907","transaction_code":"C","transaction_date":"2023-04-10 00:00:00","upload_date":"2023-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2023-01-30 21:43:00","snet_input_date":"2023-01-30 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-01-30 21:43:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:09.000000Z","updated_at":"2025-03-17T19:08:09.000000Z","inspection_violations":[{"id":3479864,"change_date":"2023-04-11 12:04:00","inspection_id":"77723234","insp_violation_id":"252127803","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:23:25.000000Z","updated_at":"2025-03-17T21:23:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3628676,"change_date":"2023-04-11 12:04:00","inspection_id":"77723234","insp_unit_id":"194302865","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"8515","insp_unit_license":"13KS3K","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EJ1FN188515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:00.000000Z","updated_at":"2025-03-17T22:32:00.000000Z"},{"id":3628677,"change_date":"2023-04-11 12:04:00","inspection_id":"77723234","insp_unit_id":"194302866","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"HV2301022","insp_unit_license":"PB10696","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532KXPS027204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:00.000000Z","updated_at":"2025-03-17T22:32:00.000000Z"}]},{"id":2075138,"change_date":"2023-01-25 21:42:00","inspection_id":"77517638","dot_number":"3684206","report_state":"IN","report_number":"5796007105","insp_date":"2023-01-03 00:00:00","insp_start_time":"1420","insp_end_time":"1443","registration_date":"2023-01-23 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"I65SB","county_code_state":"IN","county_code":"097","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"11663S33G","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2168475","transaction_code":"C","transaction_date":"2023-01-04 00:00:00","upload_date":"2023-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2023-01-05 21:40:00","snet_input_date":"2023-01-04 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-01-05 21:40:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:47.000000Z","updated_at":"2025-03-17T19:04:47.000000Z","inspection_violations":[{"id":3211530,"change_date":"2023-01-25 21:42:00","inspection_id":"77517638","insp_violation_id":"250771676","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:13.000000Z","updated_at":"2025-03-17T21:22:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3338622,"change_date":"2023-01-25 21:42:00","inspection_id":"77517638","insp_unit_id":"193059739","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"13KS3K","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EJ1FN188515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:53.000000Z","updated_at":"2025-03-17T22:29:53.000000Z"},{"id":3338623,"change_date":"2023-01-25 21:42:00","inspection_id":"77517638","insp_unit_id":"193059740","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"29991Z","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D2KL143369","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:53.000000Z","updated_at":"2025-03-17T22:29:53.000000Z"}]},{"id":2016441,"change_date":"2023-01-05 21:40:00","inspection_id":"77450839","dot_number":"3684206","report_state":"IL","report_number":"4181540019","insp_date":"2022-12-22 00:00:00","insp_start_time":"0117","insp_end_time":"0137","registration_date":"2023-01-05 00:00:00","region":"CT","ci_status_code":"C","location":"999","location_desc":"US 67","county_code_state":"IL","county_code":"083","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NO CARGO","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-27 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"51200","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":"2215774","transaction_code":"C","transaction_date":"2022-12-22 00:00:00","upload_date":"2023-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2022-12-27 21:39:00","snet_input_date":"2022-12-22 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-12-27 21:39:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:43.000000Z","updated_at":"2025-03-17T19:03:43.000000Z","inspection_violations":[{"id":3127451,"change_date":"2023-01-05 21:40:00","inspection_id":"77450839","insp_violation_id":"250404090","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"48","out_of_service_indicator":"N","defect_verification_id":"4","citation_number":"81540175","created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3244149,"change_date":"2023-01-05 21:40:00","inspection_id":"77450839","insp_unit_id":"192716351","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"001","insp_unit_license":"72KS83","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EH1EN155977","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:12.000000Z","updated_at":"2025-03-17T22:29:12.000000Z"}]},{"id":1925637,"change_date":"2022-12-12 21:43:00","inspection_id":"77347189","dot_number":"3684206","report_state":"IL","report_number":"3913090162","insp_date":"2022-12-11 00:00:00","insp_start_time":"2236","insp_end_time":"2244","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-55","county_code_state":"IL","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"2214576","transaction_code":"A","transaction_date":"2022-12-11 00:00:00","upload_date":"2022-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2022-12-12 21:43:00","snet_input_date":"2022-12-11 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-12-12 21:43:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:12.000000Z","updated_at":"2025-03-17T19:02:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3098215,"change_date":"2022-12-12 21:43:00","inspection_id":"77347189","insp_unit_id":"192379523","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"4394","insp_unit_license":"93KS9L","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EH5JN994394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:13.000000Z","updated_at":"2025-03-17T22:28:13.000000Z"},{"id":3098216,"change_date":"2022-12-12 21:43:00","inspection_id":"77347189","insp_unit_id":"192379524","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"V509838","insp_unit_license":"TL3292","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"3H3V532C6LR440893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:13.000000Z","updated_at":"2025-03-17T22:28:13.000000Z"}]},{"id":1542304,"change_date":"2022-11-04 21:38:00","inspection_id":"76907336","dot_number":"3684206","report_state":"IN","report_number":"8290012358","insp_date":"2022-10-17 00:00:00","insp_start_time":"0540","insp_end_time":"0620","registration_date":"2022-11-02 00:00:00","region":"ET","ci_status_code":"C","location":"5570W","location_desc":"#55  I-70  WB  WAYNE","county_code_state":"IN","county_code":"177","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"HILLS PET NUTRITION INC","shipping_paper_number":"7001219681","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-10-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2154992","transaction_code":"C","transaction_date":"2022-10-18 00:00:00","upload_date":"2022-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2022-10-18 21:40:00","snet_input_date":"2022-10-18 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-10-18 21:40:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:10.000000Z","updated_at":"2025-03-17T18:55:10.000000Z","inspection_violations":[{"id":2426687,"change_date":"2022-11-04 21:38:00","inspection_id":"76907336","insp_violation_id":"249443183","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191815077","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2481906,"change_date":"2022-11-04 21:38:00","inspection_id":"76907336","insp_unit_id":"191815076","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"4394","insp_unit_license":"93KS9L","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EH5JN994394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:01.000000Z","updated_at":"2025-03-17T22:24:01.000000Z"},{"id":2481907,"change_date":"2022-11-04 21:38:00","inspection_id":"76907336","insp_unit_id":"191815077","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"SV2201905","insp_unit_license":"PA97544","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1DW1A5324NBA86787","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:01.000000Z","updated_at":"2025-03-17T22:24:01.000000Z"}]},{"id":1435940,"change_date":"2022-10-04 21:41:00","inspection_id":"76784398","dot_number":"3684206","report_state":"MI","report_number":"STRAL01471","insp_date":"2022-10-03 00:00:00","insp_start_time":"2125","insp_end_time":"2200","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B SCALE","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1097140","transaction_code":"A","transaction_date":"2022-10-03 00:00:00","upload_date":"2022-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2022-10-04 21:41:00","snet_input_date":"2022-10-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-04 21:41:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:06.000000Z","updated_at":"2025-03-17T18:53:06.000000Z","inspection_violations":[{"id":2259151,"change_date":"2022-10-04 21:41:00","inspection_id":"76784398","insp_violation_id":"248816218","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191257953","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:20.000000Z","updated_at":"2025-03-17T21:17:20.000000Z","normalized_code":"3939A"},{"id":2259152,"change_date":"2022-10-04 21:41:00","inspection_id":"76784398","insp_violation_id":"248816219","seq_no":"2","part_no":"383","part_no_section":"71(h)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:20.000000Z","updated_at":"2025-03-17T21:17:20.000000Z","normalized_code":"38371H"}],"inspection_per_units":[{"id":2311626,"change_date":"2022-10-04 21:41:00","inspection_id":"76784398","insp_unit_id":"191257953","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1300","insp_unit_license":"72KS1J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKGGLDR4HSHY1300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:50.000000Z","updated_at":"2025-03-17T22:22:50.000000Z"}]},{"id":659470,"change_date":"2022-07-05 21:42:00","inspection_id":"75878874","dot_number":"3684206","report_state":"IN","report_number":"6144012746","insp_date":"2022-06-21 00:00:00","insp_start_time":"0500","insp_end_time":"0533","registration_date":"2022-07-05 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"INTERSTATE 70 8 MM EB","county_code_state":"IN","county_code":"167","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2134687","transaction_code":"C","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-21 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:13.000000Z","updated_at":"2025-03-17T18:39:13.000000Z","inspection_violations":[{"id":1037742,"change_date":"2022-07-05 21:42:00","inspection_id":"75878874","insp_violation_id":"246882327","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1059906,"change_date":"2022-07-05 21:42:00","inspection_id":"75878874","insp_unit_id":"189598145","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3222","insp_unit_license":"13KS5J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJGLD5XGSGW3222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:42.000000Z","updated_at":"2025-03-17T22:14:42.000000Z"},{"id":1059907,"change_date":"2022-07-05 21:42:00","inspection_id":"75878874","insp_unit_id":"189598146","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"V504330","insp_unit_license":"HV38338","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3H3V532C8KT709588","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:42.000000Z","updated_at":"2025-03-17T22:14:42.000000Z"}]},{"id":531521,"change_date":"2022-06-02 21:42:00","inspection_id":"75726789","dot_number":"3684206","report_state":"IL","report_number":"4068110204","insp_date":"2022-05-30 00:00:00","insp_start_time":"2357","insp_end_time":"0028","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-64","county_code_state":"IL","county_code":"191","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GANDALF INC","shipping_paper_number":"T111MY1M5J","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"2174775","transaction_code":"A","transaction_date":"2022-05-30 00:00:00","upload_date":"2022-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":null,"census_search_date":"2022-06-02 21:42:00","snet_input_date":"2022-05-30 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-06-02 21:42:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"128269","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:04.000000Z","updated_at":"2025-03-17T18:37:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":855202,"change_date":"2022-06-02 21:42:00","inspection_id":"75726789","insp_unit_id":"189036136","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1300","insp_unit_license":"72KS1J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKGGLDR4HSHY1300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:29.000000Z","updated_at":"2025-03-17T22:13:29.000000Z"},{"id":855203,"change_date":"2022-06-02 21:42:00","inspection_id":"75726789","insp_unit_id":"189036137","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"7504340","insp_unit_license":"HV38348","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3H3V532C0KT709598","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:29.000000Z","updated_at":"2025-03-17T22:13:29.000000Z"}]},{"id":111652,"change_date":"2022-04-18 21:41:00","inspection_id":"75224346","dot_number":"3684206","report_state":"IN","report_number":"5422005132","insp_date":"2022-04-05 00:00:00","insp_start_time":"0939","insp_end_time":"1019","registration_date":"2022-04-18 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"I70 WB NEAR 6MM","county_code_state":"IN","county_code":"167","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2123048","transaction_code":"C","transaction_date":"2022-04-05 00:00:00","upload_date":"2022-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03684206","upload_search_indicator":"M","census_search_date":"2022-04-05 21:40:00","snet_input_date":"2022-04-05 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-04-05 21:40:00","insp_carrier_name":"GANDALF INC","insp_carrier_street":"5541 BROOKTON WAY","insp_carrier_city":"SAINT LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63128","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:29.000000Z","updated_at":"2025-03-17T18:29:29.000000Z","inspection_violations":[{"id":163560,"change_date":"2022-04-18 21:41:00","inspection_id":"75224346","insp_violation_id":"245207723","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:51.000000Z","updated_at":"2025-03-17T21:07:51.000000Z","normalized_code":"3922"},{"id":163561,"change_date":"2022-04-18 21:41:00","inspection_id":"75224346","insp_violation_id":"245207724","seq_no":"2","part_no":"395","part_no_section":"15(i)(9)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:51.000000Z","updated_at":"2025-03-17T21:07:51.000000Z","normalized_code":"39515I9"},{"id":163562,"change_date":"2022-04-18 21:41:00","inspection_id":"75224346","insp_violation_id":"245207725","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:51.000000Z","updated_at":"2025-03-17T21:07:51.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":180815,"change_date":"2022-04-18 21:41:00","inspection_id":"75224346","insp_unit_id":"188196311","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"8515","insp_unit_license":"13KS3K","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EJ1FN188515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:19.000000Z","updated_at":"2025-03-17T22:09:19.000000Z"},{"id":180816,"change_date":"2022-04-18 21:41:00","inspection_id":"75224346","insp_unit_id":"188196312","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"V560075","insp_unit_license":"TL4229","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"3H3V532C3LR441130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:19.000000Z","updated_at":"2025-03-17T22:09:19.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3684206\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3684206\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3684206\/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\/3684206\/inspections","per_page":100,"prev_page_url":null,"to":55,"total":55}