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 SWAA053564Buttstrap · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME BUTT STRAP CRACKED AT BS 360, BETWEEN STR 14R TO STR 15R. REMOVED AND REPLACED BUTT STRAP PER BFG ER.SDR SWAA053566Skin · crackedDURING SCHEDULED C2 CHECK, FOUND NR 4 L/E SLAT LOWER T/E SKIN CRACKED. REPAIRED SLAT PER SRM.SDR SWAA053565Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 927, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA053549Light · looseEEPLS STRIP LOOSE BETWEEN ROW 6 TO ROW 7. SECURED STRIP PER MM.SDR SWAA053517Window · looseR2 DOOR EMERGENCY EVAC SLIDE CONTAINER VIEWING WINDOW LOOSE. SECURED WINDOW PER MM.SDR SWAA053503Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 932, STR 24L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA053471Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053403Bulb · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND CABIN EMERGENCY LIGHT INOP AT ROW 20 DEF. RELAMPED LIGHT PER MM.SDR SWAA053402Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BLKHD WEB CRACKED AT RBL 17.1 & LBL 17.1, WL 227. REPAIRED WEB PER SRM.SDR SWAA053378Stringer · damagedDURING SCHEDULED MAINTENANCE, FOUND FUSELAGE STRINGER DAMAGED AT BS 482, STR 3R. REPAIRED STRINGER IAW SRM.SDR SWAA053347Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 890, STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA053320Skin · crackedFOUND FUSELAGE SKIN CRACKED AT BS 747 TO BS 767, BETWEEN STR 18L TO STR 19L. REPAIRED SKIN PER SRM.SDR SWAA053313Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME SHEAR TIE CRACKED AT BS 360, BETWEEN STR 15R AND STR 16R. REPAIRED SHEAR TIE PER SRM.SDR SWAA053312Fitting · corrodedDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR EVACUATION SLIDE GIRT BAR AFT FLOOR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA053285Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 360, BETWEEN RBL 51 TO RBL 61. REPAIRED FLOORBEAM PER SRM.SDR SWAA053284Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER CAP CORRODED AT BS 986. REMOVED AND REPLACED FLOORBEAM UPPER CAP PER SWA EA.SDR SWAA053272Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 944, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA053248Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053233Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT CARGO DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA053232Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 807, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA053202Skin · delaminatedDURING SCHEDULED 1/2D CHECK, FOUND RT WING NR 5 L/E SLAT DELAMINATED & DISBONDED. REPAIRED SLAT PER SRM.SDR SWAA053201Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA053200Skin · delaminatedDURING SCHEDULED 1/2D CHECK, FOUND LT WING NR 2 L/E SLAT OUTBOARD UPPER CORNER DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA053199Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND RT CREASE BEAM CORRODED BETWEEN BS 616 TO BS 639. REPAIRED CREASE BEAM PER SRM.SDR SWAA053198Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053197Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053196Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 663, STR 14R. REPAIRED STRINGER PER SRM.SDR SWAA053195Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 328, RBL 21, RBL 28 & RBL 36. REPAIRED FLOORBEAM PER SRM.SDR SWAA053194Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FLOORBEAM T-CHORD CORRODED AT BS 312, BETWEEN LBL 54 TO RBL 54. REMOVED AND REPLACED T-CHORD PER SRM.SDR SWAA053193Frame · chafedDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR UPPER AFT FRAME CHAFED AT TOP EDGE. REPAIRED FRAME PER SWA EA.SDR SWAA053192Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT BS 455, STR 24R. REPAIRED FRAME PER BFG ER.SDR SWAA053191Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 24R. REPAIRED FRAME PER BFG ER.SDR SWAA053173Hose · leakingDECLARED EMERGENCY HYDRAULIC B-SYSTEM QUANTITY WENT TO ZERO. ENGINE & ELECTRIC B-PUMP LOW PRESSURE LIGHTS ILLUMINATED. REMOVED AND REPLACED HYDRAULIC B-SYSTEM FLEX HOSE AT HYDRAULIC ACCOUSTIC FILTER PER MM.SDR SWAA053172Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 1016 BULKHEAD WEB CRACKED AT STR 23R, 5 O'CLOCK POSITION. REPAIRED WEB PER SWA EA.SDR SWAA053171Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 1016 BULKHEAD WEB CRACKED AT STR 7R, 2 O'CLOCK POSITION. REPAIRED WEB PER SWA EA.SDR SWAA053170Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR CUTOUT, LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA053169Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND LT WING RIB LOWER CHORD CRACKED AT WBL 135.5, STR 2. REPAIRED RIB PER SWA EA.SDR SWAA053160Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 351, STR 18L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053159Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 348, STR 18L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053153Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 927, STR 25R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053152Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT BOTTOM DOOR STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA053132Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT AFT CARGO DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA053081Gate · leakingAIR TURNBACK, AUTO FAIL LIGHT ILLUMINATED, SELECTED STANDBY, NO HELP. REMOVED AND REPLACED EXTERNAL GROUND AIR CONDITIONING FLAPPER DOOR PER MM.SDR SWAA053070Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND NR 2 L/E SLAT UPPER T/E WEDGE DELAMINATED AT INBD AND OTBD ENDS. REPAIRED SLAT PER SRM.SDR SWAA053025Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 348, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053024Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD BOTTOM DOOR STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA053002Battery Pack · faultyDURING SCHEDULED SERVICE CHECK, FOUND BLOWN FUSES IN LT FWD CABIN EMERGENCY LIGHTS BATTERY PACK. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA053001Wire · shortedDURING SCHEDULED SERVICE CHECK, FOUND FWD GALLEY EMERGENCY EXIT LIGHTS INOP. REPAIRED WIRE NR W1150-011-20 PER WDM.SDR SWAA053000Bulb · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT AFT LOWER EXTERNAL EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA052999Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT BOTTOM DOOR STOP FITTING. REPAIRED FRAME PER BFG ER.
Back to Boeing 737-5H4