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 SWAA991506Battery · dischargedDURING SCHEDULED C1 CHECK, FOUND WEAK BATTERY AT EMERGENCY EXIT RT CEILING LIGHT. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA991505Light · inopDURING SCHEDULED C2 CHECK, FOUND AFT EEPLS LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA991488Slide · detachedAFT SERVICE DOOR SLIDE ASSY FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA991484Temp Bulb · failedIN FLIGHT ENGINE SHUTDOWN, NR 1 ENGINE OIL TEMP CLIMBED ABOVE RED BAND DURING FLIGHT. ALL OTHER ENGINE INDICATIONS NORMAL. REMOVED AND REPLACED NR 1 ENG OIL SYSTEM AND SCAVANGE FILTERS, OIL, FUEL/OIL HEAT EXCHANGER AND OIL TEMP BULB. RAN ENGINE, OPS CHECKEDSDR SWAA991451Cover · missingEEPLS COVER MISSING AT ROW 10. REPLACED COVER PER MM.SDR SWAA991446Lens · missingDURING SCHEDULED SERVICE CHECK, FOUND EEPLS LENS MISSING. REPLACED LENS PER MM.SDR SWAA991445Light · inopDURING SCHEDULED SERVICE CHECK, FOUND 7 EA EEPLS LIGHTS INOP NEAR OVERWING EXIT. RECONNECTED WIRING AND OPS CHECK GOOD PER MM.SDR SWAA991368Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND LEFT OVERWING EXTERIOR EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA991363Light · looseSEVERAL EEPLS LIGHTS PULLED LOOSE. SECURED LIGHTS PER MM.SDR SWAA991348Bulkhead Chord · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD RT CHORD CRACKED, RBL 28.5. REMOVED AND REPLACED RT CHORD PER SRM.SDR SWAA991347Gusset · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR AFT LOWER STUB FRAME GUSSET CRACKED. REMOVED AND REPLACED STUB FRAME GUSSET PER SRM.SDR SWAA991335Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND THROUGH ULTRASONIC INSPECTION 3 EACH CRACKS AT BS 178 BULKHEAD, LBL 5 - RBL 5. REPAIRED BULKHEAD PER SRM.SDR SWAA991334Casting · crackedDURING SCHEDULED 1/4D CHECK, FOUND CRACKED CASTING FOR NR 4 GROUND SPOILER ACTUATOR ATTACH FITTING. REPAIRED CASTING PER SWA RA NR 1-A57-0571.SDR SWAA991333Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND LEFT OUTBOARD AFT FLAP DELAMINATED. REMOVED AND REPLACED LEFT OUTBOARD AFT FLAP PER MM.SDR SWAA991330Light · inopDURING SCHEDULED C1 CHECK, FOUND EEPLS LIGHT AT ROW 20 INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA991320Door · gougedDURING SCHEDULED C2 CHECK, FOUND 2 EACH SMALL GOUGES ON RT EMERGENCY OVERWING DOOR AT FWD SKIN. REPAIRED SKIN PER SRM.SDR SWAA991313Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHT INOP AT ROW 8-10. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA991312Slide · low pressDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991311Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND NR 5 L/E SLAT DELAMINATED ON UPPER AFT INBOARD CORNER. REPAIRED SLAT PER SRM.SDR SWAA991298Wire · brokenEEPLS WIRE BROKEN AT ROWS 6-7. REMOVED AND REPLACED EEPLS ASSY PER MM.SDR SWAA991282Light · looseDURING SCHEDULED C2 CHECK, FOUND 3 EACH BULLNOSE EMERGENCY EGRESS LIGHTS LENSES LOOSE AT ROWS 7 ABC, 11 ABC, AND 19 ABC. SECURED LIGHT LENSES PER MM.SDR SWAA991259Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND THROUGH UT INSPECTION, A 1 INCH LONG CRACK AT BS 178 BULKHEAD RH SIDE, WL 200. REPAIRED PER SRM.SDR SWAA991254Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD CRACKED ON RBL 5.7, WL 213-214. REPAIRED BULKHEAD PER SRM.SDR SWAA991253Light · looseDURING SCHEDULED C4 CHECK, FOUND EEPLS LIGHT STRIPS LOOSE AND WIRES EXPOSED. RESECURED STRIPS, WIRES, AND REPLACED DAMAGED COVERS.SDR SWAA991246Light · missingDURING SCHEDULED C1 CHECK, FOUND EEPLS TRACK CAP END MISSING AT FWD END. REPLACED CAP END PER MM.SDR SWAA991245Lens · missingDURING SCHEDULED C1 CHECK, FOUND EEPLS TRACK LENS MISSING AT FWD AND AFT ENDS. REPLACED LENSES PER MM.SDR SWAA991244Light · brokenDURING SCHEDULED C1 CHECK, FOUND EEPLS TRACK COVER BROKEN AT ROW 1. REMOVED AND REPLACED COVER PER MM.SDR SWAA991243Lens · crackedDURING SCHEDULED C1 CHECK, FOUND EMERGENCY EXIT LIGHT LENS CRACKED AT MID CABIN. REMOVED AND REPLACED LENS PER MM.SDR SWAA991230Slide · detachedFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY INTO CONTAINER PER MM.SDR SWAA991221Wire · exposedDURING SCHEDULED C1 CHECK, FOUND EEPLS WIRING EXPOSED AND LENS COVER MISSING. REROUTED WIRES AND REPLACED LENS COVER PER MM.SDR SWAA991213Pump · inopNR 2 ENG HYD PUMP FAILED. REMOVED AND REPLACED NR 2 ENG HYD PUMP AND DRAIN FILTER PER MM.SDR SWAA991199Light · out of trackEEPLS LIGHTS PULLED OUT OF TRACK. RE-INSTALLED LIGHTS PER MM.SDR SWAA991196Lens · looseSEVERAL EEPLS LIGHT LENS CAME OUT OF TRACK DURING LANDING. RE-INSTALLED LENS PER MM.SDR SWAA991177Slide · looseFWD ENTRY DOOR SLIDE CAME OUT OF CONTAINER. RESTOWED SLIDE ASSY PER MM.SDR SWAA991168Connector · failedIN FLIGHT/ ENGINE SHUT DOWN--- DURING CLIMB NR 2 ENG OIL TEMP INDICATOR READ 150 DEGREES, 12 MINUTES LATER TEMP WENT UP TO 195 DEGREES. ALL OTHER ENG INDICATIONS NORMAL. REMOVED AND REPLACED NR 2 ENG OIL TEMP BULB CANNON PLUG AND OIL TEMP BULB AS A PRECAUTISDR SWAA991157Wire · exposedEEPLS LIGHT HAS EXPOSED WIRES AND MISSING LENS. REPAIRED WIRES AND REPLACED LENS PER MM.SDR SWAA991134Slide · low pressureDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESSURE BELOW LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991131Light · damagedEMERGENCY ESCAPE FLOOR LIGHT PULLED OUT OF TRACK AT ROW 8. REPLACED WITH NEW TRACK LIGHT ASSY PER MM.SDR SWAA991115Frame · crackedDURING SCHEDULED C2 CHECK, FOUND FWD CARGO DOOR, FWD LOWER FRAME CRACKED. REMOVED AND REPLACED FWD CARGO DOOR ASSY.SDR SWAA991054Light · missingEMERGENCY ESCAPE FLOOR TACK LIGHT BULB AND LENS MISSING AT ROW 7. REPLACED LIGHT BULB AND LENS PER MM.SDR SWAA991050Light · inoperativeROW 18 LT FLOOR PROXIMITY LIGHT INOP AND COVER MISSING. REPAIRED WIRE AND REPLACED COVER PER MM.SDR SWAA991038Wire · looseEMERGENCY ESCAPE FLOOR TRACK LIGHTS INOP FWD OF ROW 3. RECONNECTED WIRE TO LIGHT PER MM.SDR SWAA991031Solenoid · malfunctionedLANDING GEAR WOULD NOT RETRACT NORMALLY AFTER TAKEOFF FROM SMF. LANDING GEAR OVERRIDE TRIGGER WAS UTILIZED. AFTER DETERMINING THERE WAS NOT AN AIR/GROUND SENSOR PROBLEM, GEAR RETRACTED NORMALLY. REMOVED AND REPLACED LANDING GEAR SAFETY SOLENOID PER MM.SDR SWAA990999Bracket · looseDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR GIRT BAR, AFT FLOOR ATTACH BRACKET LOOSE. TIGHTENED ATTACH BRACKET PER MM.SDR SWAA990985Light · inoperativeEMERGENCY ESCAPE FLOOR TRACK LIGHT INOP AT ROWS 6 AND 7. RELAMPED 2 EA LIGHTS PER MM.SDR SWAA990951Light · inoperativeDURING SCHEDULED C3 CHECK, FOUND RT OVERWING DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA990950Light · disconnectedDURING SCHEDULED C3 CHECK, FOUND 2 MOST FWD EMERGENCY ESCAPE FLOOR TRACK LIGHTS INOP. RECONNECTED LEADS TO UNIT PER MM.SDR SWAA990940Light · disconnectedEMERGENCY ESCAPE FLOOR TRACK LIGHT, FWD SECTION INOP. RECONNECTED TRACK SECTION, OPS CHECKED GOOD PER MM.SDR SWAA990930Cover · brokenFWD ENTRY DOOR EMERGENCY EXIT LIGHT COVER BROKEN. REMOVED AND REPLACED COVER PER MM.SDR SWAA990920Slide · low pressFWD SERVICE DOOR EVACUATION SLIDE PRESSURE BELOW LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.
Back to Boeing 737-5H4