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 SWAA000265Cover · missingEEPLS TRACK COVER MISSING AT MID CABIN. REPLACED TRACK COVER PER MM.SDR SWAA000249Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EEPLS INOP AT ROW 14. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA000221Light · inoperativeEEPLS INOP AT ROW 6. RELAMPED PER MM.SDR SWAA000219Cover · looseDURING SCHEDULED C3 CHECK, FOUND EEPLS COVERS LOOSE AT ROWS 3 AND 12. SECURED COVERS PER MM.SDR SWAA000207Guide Arm · out of adjustAIR TURNBACK, LOUD PRESSURIZATION LEAK AROUND FWD ENTRY DOOR. ADJUSTED FWD ENTRY DOOR UPPER GUIDE ARM PER MM.SDR SWAA000201Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000200Web · crackedDURING SCHEDULED D CHECK, FOUND MAIN WHEEL WELL PRESS WEB CRACKED, BS 664.5, LBL 32, WL 200. REPAIRED WEB PER ER 00-0011.SDR SWAA000181Frame · crackedDURING SCHEDULED D CHECK, FOUND 4 EACH FRAMES CRACKED, BS 867, BETWEEN STRINGERS 8L-9L AND STRINGERS 8R-9R, BS 827 BETWEEN STRINGERS 8L-9L AND 8R-9R. REPAIRED FRAMES PER SRM AND ER.SDR SWAA000180Frame · crackedDURING SCHEDULED D-CHECK, FOUND 4 FRAMES CRACKED, BS 747, BETWEEN STRINGERS 8L-9L AND STRINGERS 8R-9R, BS 787 BETWEEN STRINGERS 8L-9L AND 8R-9R. REPAIRED FRAMES PER SRM AND ER.SDR SWAA000179Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 FRAMES CRACKED, BS 482A, WL 153 RT, AND BS 440 BETWEEN STRINGERS 8L-9L. REPAIRED FRAMES PER SRM AND ER.SDR SWAA000178Spar · crackedDURING SCHEDULED D-CHECK, FOUND THRU HFEC INSP INDICATED CRACKED LT WING REAR SPAR UPPER CHORD IN HOLED. REPAIRED SPAR PER SRM AND ER.SDR SWAA000173Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM UPPER SURFACE CORRODED, BS 986, RBL 14-36. REPAIRED BEAM PER ER NR 99-0047A.SDR SWAA000158Lens · missingDURING SCHEDULED C3 CHECK, FOUND EEPLS LENS MISSING AT ROW 21. REPLACED LENS ASSY PER MM.SDR SWAA000157Indicator · looseDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE PRESS IND VIEWING WINDOW LOOSE. SECURED VIEWING WINDOW PER MM.SDR SWAA000151Light · looseEEPLS TRACK LOOSE AT FWD CABIN. RESECURED LIGHT ASSY PER MM.SDR SWAA000119Cover · missingEEPLS TRACK COVER MISSING ON ROWS 9-10. INSTALLED AND SECURED COVER PER MM.SDR SWAA000118Pump · failedAIR TURNBACK, B-SYSTEM HYD PUMP LOW PRESS LIGHT ILLUMINATED DURING CLIMB. REMOVED AND REPLACED B-SYSTEM ELECTRIC HYD PUMP AND CASE DRAIN FILTER PER MM.SDR SWAA000100Bulkhead · crackedDURING SCHEDULED D CHECK, FOUND THROUGH ULTRASONIC INSPECTION BS 178 BULKHEAD CRACKED IN 3 PLACES, LBL 6.7, RBL 6.7 AND RBL 4.7. REPAIRED BULKHEAD PER SRM.SDR SWAA000082Sensor · erraticABORTED TAKEOFF, TAKEOFF WARNING SOUNDED. FLAPS, SPEED BRAKE, AND TRIM SET PROPERLY. CLEANED NR 1 AND NR 4 L/E FLAP EXTEND PROX SENSORS. OPS CK GOOD PER MM.SDR SWAA000067Light · inoperativeEEPLS INOP BY OVERWING DOOR. RECONNECTED LIGHTS AND OPS CK GOOD.SDR SWAA000033Sensor · inoperativeWHEN AUTOPILOT ENGAGED, ACFT WOULD NOT HOLD ALTITUDE (RAPID NOSE DOWN TRIM). REMOVED AND REPLACED ELEVATOR NEUTRAL SHIFT SENSOR PER MM.SDR SWAA000028Frame · crackedDURING SCHEDULED D CHECK, FOUND BS 178 BULKHEAD LT AND RT SIDE CHORDS CRACKED, WL 207. REPAIRED PER SRM.SDR SWAA000027Bulkhead · crackedDURING SCHEDULED D CHECK, FOUND BS 178 BULKHEAD 3 EACH CRACKS, RBL1- LBL 6. REPAIRED BULKHEAD PER SRM.SDR SWAA000019Light · looseEEPLS LOOSE BETWEEN ROWS 17-18. RESECURED LIGHT ASSY PER MM.SDR SWAA000016Light · inoperativeEEPLS INOP BETWEEN ROWS 10-14. RESECURED LOOSE WIRE PER MM.SDR SWAA000002Trim Actuator · inoperativeDUAL CHANNEL TRIM FAIL LIGHT ILLUMINATED AND AUTOPILOT INOP. DIVERTED TO LAS. REMOVED AND REPLACED MACH TRIM ACTUATOR PER MM. C/W BITE CK AND OPS CK GOOD.SDR SWAA992151Slide · looseAFT SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. INSTALLED SLIDE ASSY PER MM.SDR SWAA992139Light · inoperativeDURING SCHEDULED D CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REPAIRED WIRING AT LIGHT'S PIN CONNECTOR PER MM.SDR SWAA992126Frame · crackedDURING SCHEDULED SERVICE CHECK, FOUND FWD CARGO DOOR AFT LOWER T-FRAME CRACKED. REMOVED AND REPLACED CARGO DOOR ASSY PER MM.SDR SWAA992117Light · crackedDURING SCHEDULED C3 CHECK, FOUND EEPLS TRACK CRACKED AT ROW 14. REMOVED AND REPLACED TRACK SECTION PER MM.SDR SWAA992076Coalescer · contaminatedAIR TURNBACK, FWD LAV SMOKE ALARM SOUNDED FOLLWED BY A STRONG ODOR THROUGH OUT CABIN. RESET FWD LAV SMOKE DETECTOR C/B. OPS CK GOOD. REMOVED AND REPLACED BOTH A/C WATER SEPARATOR'S COALESCER BAGS.SDR SWAA992092Spar · crackedDURING SCHEDULED D-CHECK, FOUND RT HORIZONTAL STAB FRONT SPAR CHORD CRACKED, STA 57.93. REPAIRED SPAR CHORD PER ER NR 99-6467.SDR SWAA992091Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER 5L CRACKED, BS 360-386. SPLICED STRINGER SECTION PER SRM.SDR SWAA992090Frame · crackedDURING SCHEDULED D-CHECK, FOUND 6 FUSELAGE FRAME CRACKS, BS 747, LBL 60, BS 827, LBL 60 AND RBL 60, BS 867 LBL 60 AND RBL 60, AND BS 907, LBL 60. REPAIRED FRAMES PER ER NR 99-6438.SDR SWAA992089Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER SURFACE CORRODED, BS 986, LBL 45 TO RBL 45. REPAIRED FLOORBEAM PER RE NR 99-6451.SDR SWAA992088Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPILCE 4L CRACKED, BS 907. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA992087Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED, BS 291, BETWEEN STRINGERS 12R-13R. REPAIRED FRAME PER SRM.SDR SWAA992082Light · inoperativeDURING SCHEDULED SPECIAL VISIT, FOUND EEPLS INOP, ROWS 6 TO 13. REPAIRED WIRING PER WDM.SDR SWAA992081Post · crackedDURING SCHEDULED D-CHECK, FOUND L1 COCKPIT WINDOW POST CRACKED, UPPER LT SECTION. REPAIRED PER SWA RA NR 1-A53-1156.SDR SWAA992064Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED, BS 312, STRINGER 18R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA992054Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED, BS 616, RBL 64, WL 201. REPAIRED FRAME PER SRM.SDR SWAA992061Skin · bird strikeAIR TURNBACK, SEVERAL BIRD STRIKES DURING CLIMB OUT. C/W BIRD STRIKE INSPECTION AND FOUND DAMAGED NOSE RADOME, RADAR ANTENNA, NR 2 KRUGER FLAP BELL CRANK ARM, AND FUSELAGE SKIN STRUCTURE DAMAGED FWD OF E/E DOOR. NO ENGINE INGESTION NOTED. REMOVED AND REPLASDR SWAA992049Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIPS CRACKED, BS 685, STRINGER 11L, AND BS 706, STRINGERS 11L AND 11R. REMOVED AND REPLACED CLIPS PER SRM.SDR SWAA992048Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED, BS 967, STRINGER 6L. REPAIRED SHEAR TIE PER SRM.SDR SWAA992047Angle · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE INNER SKIN WEB ANGLES CRACKED, BS 291, BETWEEN STRINGERS 10R-12R. REMOVED AND REPLACED ANGLES PER SRM.SDR SWAA992036Clip · crackedDURING SCHEDULED D CHECK, FOUND 2 EACH STRINGER CLIPS CRACKED, BS 400, STRINGER 15L, AND BS 277, STRINGER 15R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA992030Skin · delaminatedDURING SCHEDULED D CHECK, FOUND NR 3 L/E SLAT INBOARD END DELAMINATED. REPAIRED SLAT PAR ER NR 99-6418 AND SRM.SDR SWAA992029Frame · crackedDURING SCHEDULED D CHECK, FOUND BS 616 FUSELAGE FRAME CRACKED, LBL 64. REPAIRED FRAME PER SRM.SDR SWAA992028Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 270 FLOORBEAM UPPER SURFACE CORRODED, LBL 11-RBL 11. REMOVED AND REPLACED UPPER CHORD SECTION PER SRM.SDR SWAA992019Skin · creasedDURING SCHEDULED D CHECK, FOUND FUSELAGE EXTERNAL SKIN CREASED BETWEEN BS 183-188, WL 190 RH SIDE. REPAIRED SKIN PER SRM.
Back to Boeing 737-5H4