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 SWAA062280Door Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FWD CARGO DOOR FRAME CUTOUT, FWD FRAME CRACKED AT INBOARD STOP AT STR 24R. REPAIRED FRAME SECTION PER EA.SDR SWAA062253Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE CORRODED AT BS 482B, STR 28R. REMOVED AND REPLACED SHEAR TIE PER BOEING DRAWING AND SRM.SDR SWAA062255Fitting · corrodedDURING SCHEDULED 14Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD FITTING CORRODED. REMOVED AND REPLACED L1 DOOR GIRT BAR FWD FITTING PER SRM.SDR SWAA062250Hinge · crackedDURING SCHEDULED 14Y CHECK, FOUND R1 DOOR LOWER HINGE CRACKED. REMOVED AND REPLACED DOOR HINGE PER MM.SDR SWAA062249Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 303, STR 16L. REPAIRED FRAME WEB PER EA.SDR SWAA062238Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, LBL 45. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA062239Pressure Panel · crackedDURING SCHEDULED PM CHECK, FOUND NLG W/W CEILING PANELS CRACKED AT RT BS 250 AND LT BS 250. REPAIRED CEILING PANELS PER SWA EA.SDR SWAA062225Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 11L. REPAIRED STRINGER CLIP PER SRM.SDR SWAA062224Lens · brokenDURING SCHEDULED C1 CHECK, FOUND BULL NOSE EMERGENCY EXIT LIGHT LENS BROKEN AT ROW 11 ABC. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA062216Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 32. REPAIRED FLOORBEAM PER SRM.SDR SWAA062215Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE CRACKED AT BS 420, STR 15R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA062214Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 14R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA062213Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA062212Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT NR 2 RADIO ANTENNA CUTOUT, BS 406, RBL 1.5. REPAIRED SKIN PER SWA EA.SDR SWAA062211Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR BRACKET CORRODED. REMOVED AND REPLACED AFT GIRT BAR BRACKET PER SRM.SDR SWAA062210Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR BRACKET CORRODED. REMOVED AND REPLACED FWD GIRT BAR BRACKET PER SRM.SDR SWAA062209Stringer Splice · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA062159Stringer · damagedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER 28R DAMAGED AT BS 380. REPAIRED STRINGER PER SRM.SDR SWAA062156Flap · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DELAMINATED ON T/E EDGE. REMOVED AND REPLACED RT WING FLAP PER MM.SDR SWAA062116Clamp · brokenDIVERSION, FL 250 CABIN WARNING HORN SOUNDED, DESCENDED ONLY ABLE TO MAINTAIN 1 PSI CABIN DIFFERENTIAL. REMOVED AND REPLACED APU SUPPLY DUCT BOOT CLAMP PER MM.SDR SWAA062092Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA062053Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 931, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA062014Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA062013Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER WEB CRACKED AT BS 294, LBL 57. REPAIRED WEB PER SWA EA.SDR SWAA062011Web · crackedDURING SCHEDULED C2 CHECK, FOUND BULKHEAD WEB CRACKED AT BS 1016, STR 6L. REPAIRED WEB SECTION PER SRM.SDR SWAA061981Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BULKHEAD WEB CRACKED AT BS 1016, RBL 50. REMOVED AND REPLACED WEB SECTION PER SRM.SDR SWAA061980Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 294.5, LBL 57. REPAIRED WEB PER SWA EA.SDR SWAA061979Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 882, STR 25R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA061963Tee Fitting · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR LOWER TEE CHORD CRACKED AT LOWER AFT CORNER. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA061962Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM WEB CORRODED AT BS 986, RBL 44. REPAIRED FLOORBEAM WEB PER SRM.SDR SWAA061959Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED EVAC SLIDE CABLE PER MM.SDR SWAA061958Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 882, STR 25R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA061939Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD SERVICE DOOR STUB FRAME CORRODED AT ZEE ANGLE LOWER END, BS 294.5, RBL 55. REPAIRED STUB FRAME PER SRM.SDR SWAA061938Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA061937Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT SB379, LBL 3, EQUIPMENT COOLING EXHAUST DUCT. REPAIRED SKIN PER SRM.SDR SWAA061931Bracket · crackedDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE DOOR MOUNTING AFT BRACKET CRACKED. REMOVED AND REPLACED DOOR AFT BRACKET PER MM.SDR SWAA061925Pressure Panel · crackedDURING SCHEDULED C4 CHECK, FOUND NLG W/W CEILING PANELS CRACKED AT RT BS 250 AND LT BS 250. REPAIRED CEILING PANELS PER SWA EA.SDR SWAA061921Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 445, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA061909Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 486, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA061896Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT OVERWING EMERGENCY EXIT DOOR FRAME CUTOUT CRACKED AT BS 620, RBL 64, BOTTOM FASTENER. REPAIRED FRAME SECTION PER TYPICAL REPAIR MANUAL.SDR SWAA061895Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND LT OVERWING EMERGENCY EXIT DOOR FRAME CUTOUT CRACKED AT BS 620, LBL 64, BOTTOM FASTENER. REPAIRED FRAME SECTION PER TYPICAL REPAIR MANUAL.SDR SWAA061894Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 19L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA061893Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492, STR 19L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA061892Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 312, RBL 8. REPAIRED BEAM PER SRM.SDR SWAA061891Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND NLG W/W CEILING WEB CRACKED AT LT BRAKE STOP PAD. REPAIRED WEB PER SWA EA.SDR SWAA061887Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 765, STR 23L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA061875Crease Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 620, RBL 64. REPAIRED WEB PER SWA EA AND SRM.SDR SWAA061874Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND BEADED PRESSURE WEB CRACKED AT BS 664, RBL 38. REPAIRED PRESSURE WEB PER SRM.SDR SWAA061873Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD ENTRY DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA061865Frame · crackedDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR CUTOUT CENTER STUB FRAME CRACKED BENEATH UPPER HINGE. REPAIRED STUB FRAME PER SWA EA.
Back to Boeing 737-5H4