Boeing 737-5H4
Service difficulty reports · 8,230
Newest first. General aviation reporting is voluntary.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = '7375H4' ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = '7375H4' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR SWAA073434Fitting · corrodedDURING SCHEDULED 18Y CHECK, FOUND VERTICAL FIN PRIMARY FITTING CLEVIS LUGS CORRODED. REPAIRED FITTING CLEVIS LUGS PER ER.SDR SWAA073439Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073436Shear Tie · crackedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CRACKED AT BS 967, STR 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073441Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073438Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073442Shear Tie · corrodedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482A, BL 0, WL 148. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073433Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 406, RBL 1. REPAIRED SKIN PER ER.SDR SWAA073391Bearing · wornDURING SCHEDULED C4 CHECK, RIGHT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED CONTROL PUSHROD BEARING PER MM.SDR SWAA073390Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA073380Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA073377Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073376Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073375Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073359Stringer · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER 7L CRACKED AT BS 1011. REPAIRED STRINGER PER SRM.SDR SWAA073358Wedge · delaminatedDURING SCHEDULED 18Y CHECK, FOUND RIGHT WING INBOARD MID FLAP T/E WEDGE DELAMINATED AT OUTBOARD LOWER SURFACE. REPAIRED FLAP PER SRM.SDR SWAA073335Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073337Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073336Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073340Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073339Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073338Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073320Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA073322Tab · crackedDURING SCHEDULED C4 CHECK, FOUND LT ELEVATOR TAB CRACKED AT UPPER OUTBOARD END. REMOVED AND REPLACED ELEVATOR TAB PER MM.SDR SWAA073323Hinge · wornDURING SCHEDULED C4 CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REPAIRED NR 1 HINGE PER SWA EA.SDR SWAA073321Skin · crackedDURING SCHEDULED C4 CHECK, FOUND AFT CARGO DOOR HANDLE CUTOUT CRACKED AT AFT UPPER RADIUS. REPAIRED DOOR PER SWA EA.SDR SWAA073324Rod End · wornDURING SCHEDULED C4 CHECK, FOUND RT ELEVATOR TAB CONTROL ROD TO ELEVATOR TAB MAST FITTING EXCESSIVE PLAY. REMOVED AND REPLACED TAB CONTROL ROD ENDS PER MM.SDR SWAA073296Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073295Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073303Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073308Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073307Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073306Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073304Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073293Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073305Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073301Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073302Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073289Slat · crackedDURING SCHEDULED 18Y CHECK, FOUND LT WING NR 1 LEADING EDGE SLAT LOWER TRAILING EDGE CRACKED AT INBOARD AUX TRACK. REPAIRED SLAT PER SRM.SDR SWAA073299Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA073300Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA073297Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073298Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073294Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073290Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT LOWER LT SIDE. REPAIRED SKIN PER SWA EA.SDR SWAA073292Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT LOWER END. REPAIRED SKIN PER SWA EA.SDR SWAA073291Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 927, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA073245Cable · brokenDURING SCHEDULED 18Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE CABLE BROKEN. R&R EVAC SLIDE CABLE PER MM.SDR SWAA073246Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. R&R STRINGER CLIP PER SRM.SDR SWAA073244Hook · looseDURING SCHEDULED 18Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR HOOK LOOSE. SECURED HOOK PER SRM.SDR SWAA073243Hook · looseDURING SCHEDULED 18Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR HOOK LOOSE. SECURED HOOK PER SRM.
Back to Boeing 737-5H4