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 SWAA061864Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA061860Battery · inoperativeFOUND LT FWD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA061858Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD LOWER SERVICE DOOR CUTOUT, BS 957, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA061857Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA061806Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 986, LBL 30 TO RBL 35. REPAIRED FLOORBEAM PER SRM.SDR SWAA061805Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA061793Fitting · corrodedDURING SCHEDULED 1/4D CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE GIRT BAR ATTACH ANCHOR FLOOR SUPPORT CORRODED. REMOVED AND REPLACED ATTACH SUPPORT PER MM.SDR SWAA061792Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT SERVICE DOOR UPPER HINGE CUTOUT, BS 951, STR 7R. REPAIRED SKIN PER SWA EA.SDR SWAA061732Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 771, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA061722Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. RE-INSTALLED EVAC SLIDE PER MM.SDR SWAA061638Slide · low pressureR1 DOOR EMERGENCY EXIT EVAC SLIDE PRESSURE INDICATES LOW. REMOVED AND REPLACED R1 EVAC SLIDE PER MM.SDR SWAA061632Bulb · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT BULL NOSE LIGHT INOP AT ROW 3 ABC. RELAMPED LIGHT PER MM.SDR SWAA061615Web · crackedDURING SCHEDULED C1 CHECK, FOUND NOSE GEAR WHEEL WELL PRESSURE WEB CRACKED AT BS 251.625, FROM LBL 7.75 TO RBL 7.75. REPAIRED PRESSURE WEB PER SWA EA.SDR SWAA061627Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 766, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA061602Slide · out of adjustL1 DOOR EMERGENCY EXIT EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 EVAC SLIDE PER MM.SDR SWAA061591Terminal · brokenDURING SCHEDULED MV1 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHTS AND R1 DOOR EMERGENCY EXIT EXTERIOR LIGHTS INOP. REPAIRED TERMINAL END AT R1 DOOR EMERGENCY EXTERIOR LIGHT PER MM.SDR SWAA061587Cover · looseEEPLS COVER LOOSE AT ROW 14 ABC. SECURED EEPLS COVER PER MM.SDR SWAA061586Slide · out of adjustL1 DOOR EMERGENCY EXIT EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA061566Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 790, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA061521Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FRAME CRACKED AT UPPER AFT CORNER LOWER DOOR STOP. REPAIRED FRAME PER ER.SDR SWAA061518Skin · crackedFUSELAGE SKIN CRACKED AT BS 747, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA061495Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 941, STR 25R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA061494Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 882, STR 25R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA061480Stringer · crackedDURING SCHEDULED SERVICE CHECK, FOUND STRINGER 25R CRACKED AT BS 885. REPAIRED STRINGER PER SWA EA.SDR SWAA061452Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA061451Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 816, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA061460Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 382, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA061459Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA061335Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 312, WL 208 RT SIDE. REPAIRED SKIN PER SRM AND SWA EA.SDR SWAA061327Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED EVAC SLIDE CABLE PER MM.SDR SWAA061326Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 930, STR 21R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA061325Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 884, STR 24R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA061309Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA061271Light · brokenDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA061270Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 10. RELAMPED LIGHT PER MM.SDR SWAA061308Pressure Panel · crackedDURING SCHEDULED A1 CHECK, FOUND NLG W/W CEILING PANELS CUTOUT WEB CRACKED AT BS 251.625 LBL 7.75 AND RBL 7.75. REPAIRED WEB PER SWA EA.SDR SWAA061151Glowstrip · wornDURING SCHEDULED A1 CHECK, FOUND CABIN EEPLS PHOTOLUMINESCENT STRIP WORN. R&R STRIP PER MM.SDR SWAA061122Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME #5 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA061097Stringer Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER SPLICE CRACKED AT BS 361, STR 4L. R&R STRINGER SPLICE PER SRM.SDR SWAA061096Buttstrap · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME BUTT STRAP CRACKED AT BS 907, BETWEEN STR 4L TO STR 4R. R & R BUTT STRAP PER SRM.SDR SWAA061095Stringer · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CRACKED AT BS 356, STR 4L. REPAIRED STRINGER PER SRM.SDR SWAA061094Stringer · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CRACKED BETWEEN BS 400 TO BS 440, STR 4L. REPAIRED STRINGER PER SRM.SDR SWAA061150Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT GALLEY EMERGENCY EXIT LIGHTS BATTERY INOP. R&R BATTERY PACK PER MM.SDR SWAA061121Pressure Panel · crackedDURING SCHEDULED C2 CHECK, FOUND NLG W/W CEILING PANEL CUTOUT CRACKED AT BS 251.625, LBL 7.75 & RBL 7.75. REPAIRED PANELS PER SWA EA.SDR SWAA061093Flap · delaminatedDURING SCHEDULED C2 CHECK, FOUND LH WING OUTBD T/E AFT FLAP DELAMINATED. R&R FLAP PER MM.SDR SWAA061084Light · inoperativeDURING SCHEDULED C2 CHECK, FOUND LH EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA061074Cable Assy · misroutedDURING SCHEDULED C1 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE ASSY MISROUTED. REROUTED CABLE ASSY PER MM.SDR SWAA061073Skin · crackedDURING SCHEDULED C1 CHECK, FOUND LT HORIZONTAL STAB LOWER SKIN CRACKED AT AFT SPAR, STAB STA 125. REPAIRED HORIZONTAL STAB PER SRM.SDR SWAA061072Skin · crackedDURING SCHEDULED C1 CHECK, FOUND RT HORIZONTAL STAB LOWER SKIN CRACKED AT AFT SPAR BETWEEN STAB STA 96 & STAB STA 118. REPAIRED HORIZONTAL STAB PER SRM.SDR SWAA061071Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 513D, STR 16R. REPAIRED SKIN PER SRM.
Back to Boeing 737-5H4