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 SWAA992018Bracket · corrodedDURING SCHEDULED D CHECK, FOUND FWD ENTRY DOOR BOTH EVACUATION SLIDE ATTACH FLOOR BRACKETS CORRODED. REMOVED AND REPLACED BOTH BRACKETS PER SRM.SDR SWAA992017Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER SPLICES CRACKED, BS 907, STRINGERS 4L AND 4R. REPAIRED SPLICES PER SRM.SDR SWAA992012Bulkhead · crackedDURING SCHEDULED D CHECK, FOUND BS 178 BULKHEAD CRACKED AT 5 EACH PLACES, BETWEEN LBL 7 AND RBL 7. REPAIRED BULKHEAD PER SRM.SDR SWAA992009Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED, BS 312, STRINGER 6L. REPAIRED FRAME PER SRM.SDR SWAA991989Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 328 FLOORBEAM CORRODED ON UPPER SURFACE, LBL 27 TO RBL 49. REPAIRED BEAM PER SRM.SDR SWAA992001Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 312 FLOORBEAM UPPER SURFACE CORRODED, LBL 1 TO LBL 19. REPAIRED BEAM PER SRM.SDR SWAA991966Light · inoperativeEEPLS LIGHTS INOP NEAR OVERWING EXIT. RESECURED EEPLS LIGHTS PER MM. OPS CK GOOD.SDR SWAA991964Blade · bird strikeABORTED TAKEOFF, BIRD STRIKE ON NR 1 ENG INLET. FOUND 4 FAN BLADES DAMAGED. REMOVED AND REPLACED NR 1 ENG FAN BLADES PER MM.SDR SWAA991952Keel Beam · crackedDURING SCHEDULED C2 CHECK, FOUND KEEL BEAM CRACKED AT LOWER SKIN, BS 717. REPAIRED BEAM PER SRM.SDR SWAA991919Rudder · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT SIDE OF RUDDER DELAMINATED JUST BELOW CENTER HINGE NEAR L/E. REMOVED AND REPLACED RUDDER ASSY PER MM.SDR SWAA991897Slides · out of adjustDURING SCHEDULED SERVICE CHECK, FOUND BOTH ENTRY DOOR EVACUATION SLIDE GIRT ASSY'S EXTENDING OUT OF LIMITS. ADJUSTED SLIDE ASSY'S PER MM.SDR SWAA991880Light · inop3 EACH MOST FWD EEPLS LIGHTS INOP. REMOVED AND REPLACED LIGHT ASSY'S PER MM.SDR SWAA991879Light · looseEEPLS FWD END LOOSE. REINSTALLED LIGHT ASSY PER MM.SDR SWAA991870Compressor · stalledAIR TURNBACK, IN FLIGHT SHUT DOWN, NR 1 ENG COMPRESSOR STALLED AT 27,000 FEET AND THEN AGAIN AT 16,000 FEET FOLLOWED BY OIL PRESS IND DECREASE AND ENG VIBRATION. REMOVED AND REPLACED NR 1 ENG PER MM.SDR SWAA991869Mec · erraticAIR TURNBACK, IN FLIGHT SHUT DOWN, NR 2 ENG WOULD NOT GET OUT OF FULL POWER. REMOVED AND REPLACED NR 2 ENG T2 AND T12 SENSORS AND REMOVED AND REPLACED NR 2 ENG MEC PER MM..SDR SWAA991859Slide · looseDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT DRAGGING ON THRESHOLD AND PRESS INDICATOR WINDOW LOOSE. REINSTALLED SLIDE AND WINDOW ASSY'S PER MM.SDR SWAA991858Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER 4R CRACKED, BS 907. REPAIRED STRINGER PER SRM.SDR SWAA991842Skin · delaminatedDURING SCHEDULED D CHECK, FOUND NR 2 L/E SLAT DELAMINATED ON OUTBOARD END. REPAIRED SLAT PER SRM.SDR SWAA991839Slide · detachedFWD ENTRY DOOR EVACUATON SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA991812Cover · missingEEPLS TRACK COVER MISSING AT MID CABIN. REPLACED TRACK COVER PER MM.SDR SWAA991803Cover · crackedDURING SCHEDULED C1 CHECK, FOUND EEPLS TRACK COVER CRACKED AT ROW 4. REMOVED AND REPLACED TRACK COVER PER MM.SDR SWAA991793Frame · crackedDURING SCHEDULED D CHECK, FOUND DOORWAY FRAME CRACKED, BS 299, RBL 62. REPAIRED FRAME PER SRM.SDR SWAA991792Frame · crackedDURING SCHEDULED D CHECK, FOUND 3 EACH FRAMES CRACKED, BS 482, BS 400, STRINGER 8L, AND BS 380, STRINGER 8R. REPAIRED FRAMES PER ER NR 99-6247.SDR SWAA991791Frame · crackedDURING SCHEDULED D CHECK, FOUND 3 EACH FRAMES CRACKED, BS 827, BS 787, STRINGER 8L, AND BS 867, STRINGER 8R. REPAIRED FRAMES PER ER NR 99-6247.SDR SWAA991788Keel Beam · corrodedDURING SCHEDULED D CHECK, FOUND KEEL BEAM LT LOWER CHORD CORRODED, BS 482B+4. REPAIRED BEAM PER SRM.SDR SWAA991780Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER 5A LT CRACKED AT BS 1140. REPAIRED STRINGER SECTION PER SRM AND ER NR 99-6236PI.SDR SWAA991771Beam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL CENTER WING BOX BEAM CRACKED, BS 663, RBL 25. REMOVED AND REPLACED BEAM SECTION PER BAC DRAWING AND SRM.SDR SWAA991764Coalescer · dirtyOIL SMELL IN CABIN DURING TAKEOFF, CLIMB AND DESCENT. REMOVED AND REPLACE LT A/C WATER SEPARATOR PER MM.SDR SWAA991760Slide · looseDURING SCHEDULED C3 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT DRAGGING ON FLOOR. REINSTALLED SLIDE ASSY PER MM.SDR SWAA991745Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 967 FLOORBEAM CORRODED ON UPPER AND LOWER FACES, RBL 27. REPAIRED BEAM PER SRM.SDR SWAA991744Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 328 FLOORBEAM CORRODED ON UPPER FACE. REPAIRED BEAM PER SRM.SDR SWAA991736Light · brokenDURING SCHEDULED RON, FOUND EEPLS FWD LIGHT ASSY BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA991726Lens · brokenLT OVERWING EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS ASSY PER MM.SDR SWAA991724Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND LT MLG WHEEL WELL PRESSURE WEB CRACKED NEXT TO TOWER SHAFT. REPAIRED WEB PER ER NR 99-6239.SDR SWAA991711Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD CRACKED, LBL 8 - RBL 6.7. REPAIRED BULKHEAD PER SRM.SDR SWAA991691Latch · brokenF/O'S EMERGENCY ESCAPE ROPE DOOR LATCH BROKEN. REMOVED AND REPLACED PANEL ASSY PER MM.SDR SWAA991641Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED ON AFT SERVICE DOOR LOWER FWD CUT OUT. REPAIRED SKIN PER SWA RA NR 1-553-2164.SDR SWAA991637Light · detachedEEPLS DETACHED AT FWD END. REMOVED AND REPLACED EEPLS FWD SECTION PER MM.SDR SWAA991621Bulkhead Chord · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178, RT SIDE CHORD CRACKED, RBL 26. REMOVED AND REPLACED CHORD SECTION PER SRM.SDR SWAA991603Light · looseEEPLS TRACK LOOSE AT MID CABIN. REINSTALLED EEPLS TRACK LIGHT ASSY PER MM.SDR SWAA991587Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD CRACKED, RBL 1. REPAIRED BULKHEAD PER SRM.SDR SWAA991565Bulkhead Angle · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD LT OUTBOARD CHORD ANGLE CRACKED, LBL 29, WL 207. REMOVED AND REPLACED CHORD ANGLE SECTION PER SRM.SDR SWAA991553Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD CRACKED, LBL 10. REPAIRED BULKHEAD PER SRM.SDR SWAA991534Light · looseEEPLS LOOSE AT MID CABIN. REPOSITIONED WIRES AND REINSTALLED LIGHT ASSY PER MM.SDR SWAA991527Lens · missingDURING SCHEDULED RON, FOUND OVERHEAD EMERGENCY EXIT LIGHT LENS MISSING NEXT TO ROW 15. REPLACED LENS PER MM.SDR SWAA991511Battery Pack · dischargedDURING SCHEDULED BC1 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA991510Skin · crackedDURING SCHEDULED BC1 CHECK, FOUND RT HORIZONTALSTABILIZER LOWER SKIN CRACKED FWD OF 1ST BALANCE PANEL ALONG REAR SPAR. REPAIRED SKIN PER SWA RA NR 1-555-0313.SDR SWAA991509Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND THROUGH HFEC INSPECTION CRACKED L-1 COCKPIT WINDOW FRAME, UPPER OUTBOARD CORNER. REPAIRED FRAME PER SRM.SDR SWAA991508Bulkhead Chord · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD LT SIDE CHORD ANGLE CRACKED, LBL26.5. REMOVED AND REPLACED CHORD ANGLE PER SRM.SDR SWAA991507Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD CRACKED, LBL10.5. REPAIRED BULKHEAD PER SRM.
Back to Boeing 737-5H4