{"current_page":1,"data":[{"id":12728714,"change_date":"2026-08-14 21:40:00","inspection_id":"88698656","dot_number":"4569075","report_state":"MI","report_number":"EVANT03449","insp_date":"2026-08-13 00:00:00","insp_start_time":"0850","insp_end_time":"1230","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"009","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"YES","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-08-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132350","viol_total":"7","oos_total":"2","driver_viol_total":"7","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3983750","transaction_code":"A","transaction_date":"2026-08-14 00:00:00","upload_date":"2026-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"04569075","upload_search_indicator":null,"census_search_date":"2026-08-14 21:40:00","snet_input_date":"2026-08-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-14 21:40:00","insp_carrier_name":"DAVID EDWARD PICKETT","insp_carrier_street":"12633 RESEARCH BLVD","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78759-2218","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-17T09:40:03.000000Z","updated_at":"2026-08-25T09:30:29.000000Z","inspection_violations":[{"id":22158955,"change_date":"2026-08-14 21:40:00","inspection_id":"88698656","insp_violation_id":"276128249","seq_no":"1","part_no":"383","part_no_section":"25A1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4736461","created_at":"2026-08-17T09:58:18.000000Z","updated_at":"2026-08-25T09:39:29.000000Z","normalized_code":"38325A1"},{"id":22158956,"change_date":"2026-08-14 21:40:00","inspection_id":"88698656","insp_violation_id":"276128250","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4736379","created_at":"2026-08-17T09:58:18.000000Z","updated_at":"2026-08-25T09:39:29.000000Z","normalized_code":"3922SLLSR"},{"id":22158957,"change_date":"2026-08-14 21:40:00","inspection_id":"88698656","insp_violation_id":"276128251","seq_no":"3","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4736379","created_at":"2026-08-17T09:58:18.000000Z","updated_at":"2026-08-25T09:39:29.000000Z","normalized_code":"3922SLLSIV"},{"id":22158958,"change_date":"2026-08-14 21:40:00","inspection_id":"88698656","insp_violation_id":"276128252","seq_no":"4","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-17T09:58:18.000000Z","updated_at":"2026-08-25T09:39:29.000000Z","normalized_code":"3922SLLUCR"},{"id":22158959,"change_date":"2026-08-14 21:40:00","inspection_id":"88698656","insp_violation_id":"276128253","seq_no":"5","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-17T09:58:18.000000Z","updated_at":"2026-08-25T09:39:29.000000Z","normalized_code":"39021TB1MC"},{"id":22158960,"change_date":"2026-08-14 21:40:00","inspection_id":"88698656","insp_violation_id":"276128254","seq_no":"6","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-17T09:58:18.000000Z","updated_at":"2026-08-25T09:39:29.000000Z","normalized_code":"3922SLLIFTA"},{"id":22158961,"change_date":"2026-08-14 21:40:00","inspection_id":"88698656","insp_violation_id":"276128255","seq_no":"7","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-17T09:58:18.000000Z","updated_at":"2026-08-25T09:39:29.000000Z","normalized_code":"39111B2Q"}],"inspection_per_units":[{"id":22095454,"change_date":"2026-08-14 21:40:00","inspection_id":"88698656","insp_unit_id":"215153573","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"614315E","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDWTZR7LN184200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-17T09:16:14.000000Z","updated_at":"2026-08-25T09:01:34.000000Z"},{"id":22095455,"change_date":"2026-08-14 21:40:00","inspection_id":"88698656","insp_unit_id":"215153574","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"015713A25","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"4M9DS2321T1017193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-17T09:16:14.000000Z","updated_at":"2026-08-25T09:01:34.000000Z"}]},{"id":12699105,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","dot_number":"4569075","report_state":"MI","report_number":"STRAL05021","insp_date":"2026-08-11 00:00:00","insp_start_time":"2146","insp_end_time":"2253","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","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":"1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"114000","viol_total":"13","oos_total":"4","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"11","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3962674","transaction_code":"A","transaction_date":"2026-08-12 00:00:00","upload_date":"2026-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04569075","upload_search_indicator":null,"census_search_date":"2026-08-12 21:42:00","snet_input_date":"2026-08-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-12 21:42:00","insp_carrier_name":"DAVID EDWARD PICKETT","insp_carrier_street":"12633 RESEARCH BLVD","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78759-2218","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-15T09:41:23.000000Z","updated_at":"2026-08-23T09:30:28.000000Z","inspection_violations":[{"id":22109021,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","insp_violation_id":"276072071","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-15T10:01:46.000000Z","updated_at":"2026-08-23T09:40:10.000000Z","normalized_code":"39141APC"},{"id":22109022,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","insp_violation_id":"276072072","seq_no":"3","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"215106178","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-15T10:01:46.000000Z","updated_at":"2026-08-23T09:40:10.000000Z","normalized_code":"3922SLLIFTA"},{"id":22109023,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","insp_violation_id":"276072073","seq_no":"4","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"215106178","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-15T10:01:46.000000Z","updated_at":"2026-08-23T09:40:10.000000Z","normalized_code":"39021TB1MC"},{"id":22109024,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","insp_violation_id":"276072074","seq_no":"5","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"215106178","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-15T10:01:46.000000Z","updated_at":"2026-08-23T09:40:10.000000Z","normalized_code":"3922SLLUCR"},{"id":22109025,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","insp_violation_id":"276072075","seq_no":"6","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"215106178","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-15T10:01:46.000000Z","updated_at":"2026-08-23T09:40:10.000000Z","normalized_code":"39311A1LLPL"},{"id":22109028,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","insp_violation_id":"276072078","seq_no":"9","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"215106178","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-15T10:01:46.000000Z","updated_at":"2026-08-23T09:40:10.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":22109029,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","insp_violation_id":"276072079","seq_no":"10","part_no":"393","part_no_section":"23-LEU","insp_viol_unit":"2","insp_unit_id":"215106179","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-15T10:01:46.000000Z","updated_at":"2026-08-23T09:40:10.000000Z","normalized_code":"39323LEU"},{"id":22109030,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","insp_violation_id":"276072080","seq_no":"11","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"215106179","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-15T10:01:46.000000Z","updated_at":"2026-08-23T09:40:10.000000Z","normalized_code":"39617CPI"},{"id":22109031,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","insp_violation_id":"276072081","seq_no":"12","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"2","insp_unit_id":"215106179","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-15T10:01:46.000000Z","updated_at":"2026-08-23T09:40:10.000000Z","normalized_code":"3922SLLED"},{"id":22109032,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","insp_violation_id":"276072082","seq_no":"13","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"2","insp_unit_id":"215106179","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-15T10:01:46.000000Z","updated_at":"2026-08-23T09:40:10.000000Z","normalized_code":"3929A2C"},{"id":22109020,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","insp_violation_id":"276072070","seq_no":"1","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-15T10:01:46.000000Z","updated_at":"2026-08-23T09:40:10.000000Z","normalized_code":"3958A1HOSP"},{"id":22109027,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","insp_violation_id":"276072077","seq_no":"8","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"215106178","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-15T10:01:46.000000Z","updated_at":"2026-08-23T09:40:10.000000Z","normalized_code":"3922SLLIRP"},{"id":22109026,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","insp_violation_id":"276072076","seq_no":"7","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"215106178","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-15T10:01:46.000000Z","updated_at":"2026-08-23T09:40:10.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":22039706,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","insp_unit_id":"215106179","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"8903SZ","insp_unit_license_state":"AK","insp_unit_vehicle_id_number":"7SGAP3538RS000489","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-15T09:17:43.000000Z","updated_at":"2026-08-23T09:01:37.000000Z"},{"id":22039705,"change_date":"2026-08-12 21:42:00","inspection_id":"88673574","insp_unit_id":"215106178","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"KMY309","insp_unit_license_state":"AK","insp_unit_vehicle_id_number":"1FUJGEDR8HLJJ8421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-15T09:17:43.000000Z","updated_at":"2026-08-23T09:01:37.000000Z"}]},{"id":12692407,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","dot_number":"4569075","report_state":"MI","report_number":"EVANT03443","insp_date":"2026-08-11 00:00:00","insp_start_time":"1020","insp_end_time":"1300","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"009","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"YES","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"149000","viol_total":"13","oos_total":"5","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3957039","transaction_code":"A","transaction_date":"2026-08-11 00:00:00","upload_date":"2026-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"04569075","upload_search_indicator":null,"census_search_date":"2026-08-11 21:41:00","snet_input_date":"2026-08-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-11 21:41:00","insp_carrier_name":"DAVID EDWARD PICKETT","insp_carrier_street":"12633 RESEARCH BLVD","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78759-2218","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-14T09:40:44.000000Z","updated_at":"2026-08-22T09:32:57.000000Z","inspection_violations":[{"id":22098226,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","insp_violation_id":"276058150","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"215092983","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-14T10:00:26.000000Z","updated_at":"2026-08-22T09:44:20.000000Z","normalized_code":"39021TB1MC"},{"id":22098237,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","insp_violation_id":"276058161","seq_no":"5","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"215092983","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4734801","created_at":"2026-08-14T10:00:26.000000Z","updated_at":"2026-08-22T09:44:20.000000Z","normalized_code":"3922SLLIRP"},{"id":22098228,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","insp_violation_id":"276058152","seq_no":"7","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"215092983","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-14T10:00:26.000000Z","updated_at":"2026-08-22T09:44:20.000000Z","normalized_code":"39375GTAOW"},{"id":22098229,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","insp_violation_id":"276058153","seq_no":"8","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"215092983","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-14T10:00:26.000000Z","updated_at":"2026-08-22T09:44:20.000000Z","normalized_code":"39375GTAOW"},{"id":22098230,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","insp_violation_id":"276058154","seq_no":"9","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"215092983","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-14T10:00:26.000000Z","updated_at":"2026-08-22T09:44:20.000000Z","normalized_code":"39375GTAOW"},{"id":22098231,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","insp_violation_id":"276058155","seq_no":"10","part_no":"393","part_no_section":"130C-CHVE","insp_viol_unit":"2","insp_unit_id":"215092984","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-14T10:00:26.000000Z","updated_at":"2026-08-22T09:44:20.000000Z","normalized_code":"393130CCHVE"},{"id":22098232,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","insp_violation_id":"276058156","seq_no":"11","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"2","insp_unit_id":"215092984","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4736019","created_at":"2026-08-14T10:00:26.000000Z","updated_at":"2026-08-22T09:44:20.000000Z","normalized_code":"3922SLLED"},{"id":22098233,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","insp_violation_id":"276058157","seq_no":"12","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"2","insp_unit_id":"215092984","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4736019","created_at":"2026-08-14T10:00:26.000000Z","updated_at":"2026-08-22T09:44:20.000000Z","normalized_code":"3922SLLED"},{"id":22098234,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","insp_violation_id":"276058158","seq_no":"13","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"215092983","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-14T10:00:26.000000Z","updated_at":"2026-08-22T09:44:20.000000Z","normalized_code":"3922SLLSR"},{"id":22098235,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","insp_violation_id":"276058159","seq_no":"3","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"215092983","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4734801","created_at":"2026-08-14T10:00:26.000000Z","updated_at":"2026-08-22T09:44:20.000000Z","normalized_code":"3922SLLUCR"},{"id":22098236,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","insp_violation_id":"276058160","seq_no":"4","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"215092983","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4734801","created_at":"2026-08-14T10:00:26.000000Z","updated_at":"2026-08-22T09:44:20.000000Z","normalized_code":"3922SLLIFTA"},{"id":22098238,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","insp_violation_id":"276058162","seq_no":"6","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"215092983","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-14T10:00:26.000000Z","updated_at":"2026-08-22T09:44:20.000000Z","normalized_code":"39375GTAOW"},{"id":22098227,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","insp_violation_id":"276058151","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"215092983","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4736019","created_at":"2026-08-14T10:00:26.000000Z","updated_at":"2026-08-22T09:44:20.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":22028375,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","insp_unit_id":"215092983","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1222159","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1NKZX4TX4SJ180923","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-14T09:19:14.000000Z","updated_at":"2026-08-22T09:02:23.000000Z"},{"id":22028376,"change_date":"2026-08-11 21:41:00","inspection_id":"88666563","insp_unit_id":"215092984","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"F490451","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"7SGAP3537RS000659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-14T09:19:14.000000Z","updated_at":"2026-08-22T09:02:23.000000Z"}]},{"id":12681617,"change_date":"2026-08-10 21:40:00","inspection_id":"88655288","dot_number":"4569075","report_state":"MI","report_number":"KILYJ03009","insp_date":"2026-08-10 00:00:00","insp_start_time":"1409","insp_end_time":"1437","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NON3","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"8","oos_total":"4","driver_viol_total":"4","driver_oos_total":"4","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3949294","transaction_code":"A","transaction_date":"2026-08-10 00:00:00","upload_date":"2026-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"04569075","upload_search_indicator":null,"census_search_date":"2026-08-10 21:40:00","snet_input_date":"2026-08-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-10 21:40:00","insp_carrier_name":"DAVID EDWARD PICKETT","insp_carrier_street":"12633 RESEARCH BLVD","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78759-2218","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-13T09:40:25.000000Z","updated_at":"2026-08-22T09:31:29.000000Z","inspection_violations":[{"id":22078904,"change_date":"2026-08-10 21:40:00","inspection_id":"88655288","insp_violation_id":"276033529","seq_no":"1","part_no":"391","part_no_section":"11B5-LNCDLNVL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4746024","created_at":"2026-08-13T10:00:58.000000Z","updated_at":"2026-08-22T09:41:39.000000Z","normalized_code":"39111B5LNCDLNVL"},{"id":22078905,"change_date":"2026-08-10 21:40:00","inspection_id":"88655288","insp_violation_id":"276033530","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4746024","created_at":"2026-08-13T10:00:58.000000Z","updated_at":"2026-08-22T09:41:39.000000Z","normalized_code":"39141APC"},{"id":22078906,"change_date":"2026-08-10 21:40:00","inspection_id":"88655288","insp_violation_id":"276033531","seq_no":"3","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"215072227","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-13T10:00:58.000000Z","updated_at":"2026-08-22T09:41:39.000000Z","normalized_code":"39021TB2DOT"},{"id":22078907,"change_date":"2026-08-10 21:40:00","inspection_id":"88655288","insp_violation_id":"276033532","seq_no":"4","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"215072227","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-13T10:00:58.000000Z","updated_at":"2026-08-22T09:41:39.000000Z","normalized_code":"39021TB1MC"},{"id":22078908,"change_date":"2026-08-10 21:40:00","inspection_id":"88655288","insp_violation_id":"276033533","seq_no":"5","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"215072227","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-13T10:00:58.000000Z","updated_at":"2026-08-22T09:41:39.000000Z","normalized_code":"3922SLLUCR"},{"id":22078909,"change_date":"2026-08-10 21:40:00","inspection_id":"88655288","insp_violation_id":"276033534","seq_no":"6","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"215072227","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4746024","created_at":"2026-08-13T10:00:58.000000Z","updated_at":"2026-08-22T09:41:39.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":22078910,"change_date":"2026-08-10 21:40:00","inspection_id":"88655288","insp_violation_id":"276033535","seq_no":"7","part_no":"395","part_no_section":"8K2-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-13T10:00:58.000000Z","updated_at":"2026-08-22T09:41:39.000000Z","normalized_code":"3958K2HOSP"},{"id":22078911,"change_date":"2026-08-10 21:40:00","inspection_id":"88655288","insp_violation_id":"276033536","seq_no":"8","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-13T10:00:58.000000Z","updated_at":"2026-08-22T09:41:39.000000Z","normalized_code":"39111B2Q"}],"inspection_per_units":[{"id":22010485,"change_date":"2026-08-10 21:40:00","inspection_id":"88655288","insp_unit_id":"215072227","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"RJY0920","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GB3WRE77NF142537","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-13T09:18:08.000000Z","updated_at":"2026-08-21T09:02:21.000000Z"}]},{"id":12652871,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","dot_number":"4569075","report_state":"MI","report_number":"BENNK01248","insp_date":"2026-08-06 00:00:00","insp_start_time":"0800","insp_end_time":"1129","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"055","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"149000","viol_total":"22","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"22","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3923031","transaction_code":"A","transaction_date":"2026-08-06 00:00:00","upload_date":"2026-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"04569075","upload_search_indicator":null,"census_search_date":"2026-08-06 21:42:00","snet_input_date":"2026-08-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-06 21:42:00","insp_carrier_name":"DAVID EDWARD PICKETT","insp_carrier_street":"12633 RESEARCH BLVD","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78759-2218","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-09T09:42:18.000000Z","updated_at":"2026-08-17T09:30:54.000000Z","inspection_violations":[{"id":22028822,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970093","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"215017743","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4740002","created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"3922SLLSR"},{"id":22028825,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970096","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"215017743","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"3939ALIL"},{"id":22028826,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970097","seq_no":"5","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"215017743","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"3922SLLIFTA"},{"id":22028827,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970098","seq_no":"6","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"215017743","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"3922SLLUCR"},{"id":22028828,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970099","seq_no":"7","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"215017743","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"39345B2BAIR"},{"id":22028829,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970100","seq_no":"8","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"215017743","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"39345DB"},{"id":22028830,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970101","seq_no":"9","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"215017743","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"39345DBAAL"},{"id":22028831,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970102","seq_no":"10","part_no":"387","part_no_section":"301A","insp_viol_unit":"1","insp_unit_id":"215017743","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"387301A"},{"id":22028832,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970103","seq_no":"11","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"2","insp_unit_id":"215017744","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"3922SLLED"},{"id":22028833,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970104","seq_no":"12","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"215017744","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"3922SLLSR"},{"id":22028834,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970105","seq_no":"13","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"2","insp_unit_id":"215017744","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"3929A2C"},{"id":22028835,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970106","seq_no":"14","part_no":"393","part_no_section":"130C-CHVE","insp_viol_unit":"2","insp_unit_id":"215017744","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"393130CCHVE"},{"id":22028836,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970107","seq_no":"15","part_no":"393","part_no_section":"100C-C","insp_viol_unit":"2","insp_unit_id":"215017744","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"393100CC"},{"id":22028837,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970108","seq_no":"16","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"215017744","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"39345B2BAIR"},{"id":22028838,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970109","seq_no":"17","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"215017744","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"39345B2BAIR"},{"id":22028839,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970110","seq_no":"18","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"215017744","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"39345B2BAIR"},{"id":22028840,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970111","seq_no":"19","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"215017744","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"39345B2BAIR"},{"id":22028841,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970112","seq_no":"20","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"215017744","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"39345B2BAIR"},{"id":22028842,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970113","seq_no":"21","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"215017744","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"39345B2BAIR"},{"id":22028843,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970114","seq_no":"22","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"215017744","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"39617CPI"},{"id":22028823,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970094","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"215017743","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4739973","created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"39021TB2DOT"},{"id":22028824,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_violation_id":"275970095","seq_no":"3","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"215017743","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:30.000000Z","updated_at":"2026-08-17T09:41:51.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":21962766,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_unit_id":"215017743","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1230874","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1NKZX4TX4SJ180923","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-09T09:20:36.000000Z","updated_at":"2026-08-17T09:02:16.000000Z"},{"id":21962767,"change_date":"2026-08-06 21:42:00","inspection_id":"88625189","insp_unit_id":"215017744","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APPAL","insp_unit_company":null,"insp_unit_license":"303434N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7SGAP3537RS000659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-09T09:20:36.000000Z","updated_at":"2026-08-17T09:02:16.000000Z"}]},{"id":12273362,"change_date":"2026-06-25 21:50:00","inspection_id":"88232767","dot_number":"4569075","report_state":"MI","report_number":"KIRKB05620","insp_date":"2026-06-24 00:00:00","insp_start_time":"1505","insp_end_time":"1715","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"045","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"246693","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-06-25 21:50:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3614716","transaction_code":"A","transaction_date":"2026-06-25 00:00:00","upload_date":"2026-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"04569075","upload_search_indicator":null,"census_search_date":"2026-06-25 21:50:00","snet_input_date":"2026-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-25 21:50:00","insp_carrier_name":"DAVID EDWARD PICKETT","insp_carrier_street":"12633 RESEARCH BLVD","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78759-2218","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-28T09:39:33.000000Z","updated_at":"2026-07-06T09:31:32.000000Z","inspection_violations":[{"id":21363269,"change_date":"2026-06-25 21:50:00","inspection_id":"88232767","insp_violation_id":"275111675","seq_no":"1","part_no":"392","part_no_section":"2-SLL","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":"2026-06-28T09:56:10.000000Z","updated_at":"2026-07-06T09:45:41.000000Z","normalized_code":"3922SLL"},{"id":21363270,"change_date":"2026-06-25 21:50:00","inspection_id":"88232767","insp_violation_id":"275111676","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"214272110","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-28T09:56:10.000000Z","updated_at":"2026-07-06T09:45:41.000000Z","normalized_code":"3922SLL"},{"id":21363271,"change_date":"2026-06-25 21:50:00","inspection_id":"88232767","insp_violation_id":"275111677","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214272110","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-28T09:56:10.000000Z","updated_at":"2026-07-06T09:45:41.000000Z","normalized_code":"3922SLLSR"},{"id":21363272,"change_date":"2026-06-25 21:50:00","inspection_id":"88232767","insp_violation_id":"275111678","seq_no":"4","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"214272110","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4712245","created_at":"2026-06-28T09:56:10.000000Z","updated_at":"2026-07-06T09:45:41.000000Z","normalized_code":"3922SLLUCR"},{"id":21363273,"change_date":"2026-06-25 21:50:00","inspection_id":"88232767","insp_violation_id":"275111679","seq_no":"5","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"214272110","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4712245","created_at":"2026-06-28T09:56:10.000000Z","updated_at":"2026-07-06T09:45:41.000000Z","normalized_code":"3922SLL"},{"id":21363274,"change_date":"2026-06-25 21:50:00","inspection_id":"88232767","insp_violation_id":"275111680","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"214272110","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4712245","created_at":"2026-06-28T09:56:10.000000Z","updated_at":"2026-07-06T09:45:41.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":21312263,"change_date":"2026-06-25 21:50:00","inspection_id":"88232767","insp_unit_id":"214272110","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"N\/A","insp_unit_license":"KMY309","insp_unit_license_state":"AK","insp_unit_vehicle_id_number":"1FUJGEDR8HLJJ8421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-28T09:15:01.000000Z","updated_at":"2026-07-06T09:03:07.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4569075\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4569075\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4569075\/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\/4569075\/inspections","per_page":100,"prev_page_url":null,"to":6,"total":6}