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 SWAA050830Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA050829Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 895, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA050828Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 25L. REPAIRED SKIN PER SWA EA.SDR SWAA050817Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R1 & L1 DOOR EMERGENCY EVAC SLIDES OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA050816Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER AFT CORNER OF CUTOUT. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA050756Fitting · crackedDURING SCHEDULED RON CHECK, FOUND NLG ACTUATOR UPPER ATTACH FITTING GUSSET CRACKED. REMOVED AND REPLACED GUSSET PER MM.SDR SWAA050767Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT FORWARD EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA050766Lens · missingRIGHT OVERWING EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED LIGHT COVER PER MM.SDR SWAA050765Ballast · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BALLAST ASSY PER MM.SDR SWAA050761Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-INSTALLED SLIDE PER MM.SDR SWAA050747Door Frame · crackedDURING SCHEDULED C3 CHECK, FOUND R1 DOOR LOWER FRAME CRACKED AT AFT DOOR STOP FITTING. REMOVED AND REPLACED R1 DOOR PER MM.SDR SWAA050719Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA050718Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER AFT CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA050717Frame · crackedDURING SCHEDULED C3 CHECK, FOUND R2 DOOR LOWER FRAME CRACKED AT AFT DOOR STOP FITTING. REMOVED AND REPLACED R2 DOOR PER MM.SDR SWAA050710Lens · out of positionDURING SCHEDULED 1/2D CHECK, R1 DOOR EMERGENCY EXIT LIGHT COVER FELL OFF. REINSTALLED COVER PER MM.SDR SWAA050687Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 907, STR 2L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050686Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND NOSE W/W CEILING CRACKS ON LT & RT SIDE AT BRAKE PAD ATTACH POINT, BS 251.6. REPAIRED NOSE W/W CEILING PER SWA EA.SDR SWAA050677Lens · missingLENS MISSING AT AFT GALLEY OVERHEAD EMERGENCY EXIT LIGHT. INSTALLED LIGHT LENS PER MM.SDR SWAA050672Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EXTERIOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA050671Skin · crackedDURING SCHEDULED A2 CHECK, FOUND LT HORIZONTAL STAB LOWER SKIN CRACK AT STA 121.9, FWD OF AFT SPAR. REPAIRED SKIN PER SRM.SDR SWAA050649Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACK AT BS 178 BULKHEAD, WL 198, RBL 5.7. REPAIRED BULKHEAD PER SRM.SDR SWAA050632Floor Support · crackedDURING SCHEDULED 1/2D CHECK, FOUND CENTER CABIN LONGITUDINAL FLOOR SUPPORT CRACKED AT BS 664, BL 0. REPAIRED FLOOR SUPPORT PER SWA EA.SDR SWAA050631Lens · looseLT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED EMERGENCY LIGHT LENS PER MM.SDR SWAA050627Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND R1 DOOR SKIN CRACKED AT LOWER HINGE CUTOUT. REPAIRED R1 DOOR SKIN PER SRM.SDR SWAA050608Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED STRINGER AT BS 360, STR 15L. REPAIRED STRINGER PER SRM.SDR SWAA050607Skin · wornDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN, UPPER LOBE, WORN BETWEEN BS 870 & BS 887, RT SIDE & BETWEEN BS 878 & BS 880, LT SIDE. REPAIRED SKIN PER SRM.SDR SWAA050591Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND R1 DOOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA050579Floor Support · crackedDURING SCHEDULED 1/2D CHECK, FOUND 3 EA CRACKS AT NR 3 LONGITUDINAL FLOOR SUPPORT AT BS 665, BS 662.5, & BS 669. REPAIRED BEAM PER SWA EA.SDR SWAA050578Floor Support · crackedDURING SCHEDULED 1/2D CHECK, FOUND 3 EA CRACKS AT NR 2 LONGITUDINAL FLOOR SUPPORT AT BS 656, BS 665, & BS 669. REPAIRED BEAM PER SWA EA.SDR SWAA050575Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACK AT BS 750, STR 23L. REPAIRED FUSELAGE SKIN PER SRM.SDR SWAA050554Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED STRINGER CLIP AT BS 663, STR 10L AND STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050557Slide · dislodgedL1 DOOR EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED L1 DOOR EVAC SLIDE PER MM.SDR SWAA050553Fitting · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON L1 DOOR EVAC SLIDE, AFT GIRT BAR FITTING AT BS 344. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA050552Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON SHEAR TIE AT BS 787, BETWEEN STR 26R & 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA050527Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND BOTH LT & RT WING LOWER T-CHORDS CRACKED AT WBL 135.5, BETWEEN STR 2 & 3. REPAIRED T-CHORDS PER SWA EA.SDR SWAA050525Shear Web · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT SHEAR WEB, BS 956, RBL 21. REMOVED AND REPLACED SHEAR WEB ANGLE PER SRM.SDR SWAA050524Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON CREASE BEAM Z-ANGLE, RT SIDE, BETWEEN BS 927 AND BS 1006. REMOVED AND REPLACED RT CREASE BEAM Z-ANGLE PER SRM.SDR SWAA050523Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED FRAME AT LT FWD LOWER CORNER EMERGENCY EXIT AT BS 616. REPAIRED FRAME PER TYPICAL REPAIR MANUAL.SDR SWAA050515Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FRAME AT BS 287,STR 16L CRACKED. REPAIRED FRAME SECTION PER EA.SDR SWAA050514Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 287,STR 16L CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050510Wire · brokenDURING SCHEDULED SERVICE CHECK, FOUND L1 DOOR OVERHEAD EMERGENCY EXIT LIGHT INOP. REPAIRED WIRE PER WDM.SDR SWAA050479Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM TEE CAP AT BS 986, FROM RBL 48 TO BL 0, CORRODED. REPAIRED TEE CAP PER EA.SDR SWAA050443Valve · faultyLANDING GEAR HANDLE WOULD NOT RETRACT. REMOVED AND REPLACED RT MLG SNUBBING VALVE PER MM.SDR SWAA050454Tee Fitting · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR AFT LOWER TEE CHORD, CRACKED. REMOVED AND REPLACED TEE CHORD PER SRM.SDR SWAA050441Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 664, RBL 24.75, CRACKED. REPAIRED FLOORBEAM CHORD PER EA.SDR SWAA050440Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND 4 EACH CRACKS ON FLOORBEAM UPPER CHORD BETWEEN BS 659 AND BS 668, RBL 24.82. REPAIRED FLOORBEAM CHORD PER EA.SDR SWAA050424Flap · delaminatedDURING SCHEDULED 1/2D CHECK, FOUND LT WING OUTBOARD FOREFLAP DELAMINATED. REPAIRED FOREFLAP PER SRM.SDR SWAA050417Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER WEB AT BS 295, STRINGER 16L, CRACKED. REMOVED AND REPLACED STRINGER WEB SECTION PER SRM.SDR SWAA050416Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO COMPARTMENT STRINGER CLIP AT BS 807, STRINGER 25L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050413Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 482 + 16, STRINGER 10L, CRACKED. REPAIRED SKIN PER SRM.
Back to Boeing 737-5H4