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 SWAA114013Angle · crackedDURING SCHEDULED 20Y CHECK FOUND, CLIP ANGLE CRACKED AT BS 312, WL 181.37. REPAIRED ANGLE PER SRM.SDR SWAA114012Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 860, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA114011Stringer Clip · crackedDURING SCHEDULED 20Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 747, STR 18L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA114010Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 482, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA113991Stringer Clip · crackedDURING SCHEDULED 20Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 947.5, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113990Lens · brokenDURING SCHEDULED 20Y CHECK FOUND, FWD LAV WALL EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA113989Stringer Clip · crackedDURING SCHEDULED 20Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 727A, STR 21R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113988Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+5, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA113987Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+5, LBL 3. REPAIRED CHANNEL PER EA.SDR SWAA113986Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+5, LBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA113985Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+5, LBL 12.50. REPAIRED CHANNEL PER EA.SDR SWAA113984Shear Tie · crackedDURING SCHEDULED 22Y CHECK FOUND, SHEAR TIE CRACKED AT BS 294.5, STR 12L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA113911Stiffener · crackedDURING SCHEDULED 22Y CHECK FOUND, BULKHEAD STIFFENER ATTACH BRACKET CRACKED AT BS 728, RBL 18. REMOVED AND REPLACED T-ANGLE PER SRM.SDR SWAA113936Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 860, LBL 8.10. REMOVED AND REPLACED CHANNEL PER SRM.SDR SWAA113935Stringer Clip · crackedDURING SCHEDULED 20Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 400, STR 27L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113921Skin · crackedDURING SCHEDULED MV2 CHECK FOUND, SKIN CRACKED AT BS 360+5, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA113920ASkin · crackedDURING SCHEDULED MV2 CHECK FOUND, SKIN CRACKED AT BS 360+10, STR 15L. REPAIRED SKIN PER SRM.SDR SWAA113919Skin · crackedDURING SCHEDULED MV2 CHECK FOUND, SKIN CRACKED AT BS 380+10, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA113918ASkin · crackedDURING SCHEDULED MV2 CHECK FOUND, SKIN CRACKED AT BS 400+10, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA113897Filter · leakingDECLARED EMERGENCY, A SYSTEM HYDRAULIC FAILURE WITH ASSOCIATE A SYSTEM LOW PRESSURE LIGHT. R&R A SYSTEM ACOUSTIC FILTER ASSY AND A SYSTEM HYDRAULIC FILTERS PER MM.SDR SWAA113929ASpoiler · delaminatedRT WING NR 6 FLIGHT SPOILER DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA113925Skin · crackedDURING SCHEDULED CV CHECK FOUND, SKIN CRACKED AT BS 927+4, STR 23L. REPAIRED SKIN PER EA.SDR SWAA113924ASkin · crackedDURING SCHEDULED CV CHECK FOUND, SKIN CRACKED AT BS 887+13, STR 25R. REPAIRED SKIN PER EA.SDR SWAA113923Skin · crackedDURING SCHEDULED CV CHECK FOUND, SKIN CRACKED AT BS 927+15, STR 25R. REPAIRED SKIN PER EA.SDR SWAA113922ASkin · crackedDURING SCHEDULED CV CHECK FOUND, SKIN CRACKED AT BS 847+4, STR 15R. REPAIRED SKIN PER EA.SDR SWAA113931Skin · crackedDURING SCHEDULED 20Y CHECK FOUND, FUSELAGE SKIN CRACKED AT BS R1 DOOR UPPER FWD CORNER BETWEEN BS 291.5 TO BS 303.9. REPAIRED SKIN PER SRM.SDR SWAA113929Lens · brokenDURING SCHEDULED 20Y CHECK FOUND, FWD LAVATORY WALL EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA113917Battery · dischargedDURING SCHEDULED OTS CHECK FOUND, LT AFT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. CHARGED BATTERY PER MM.SDR SWAA113916ABattery · dischargedDURING SCHEDULED OTS CHECK FOUND, RT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. CHARGED BATTERY PER MM.SDR SWAA113915Light · inoperativeDURING SCHEDULED OTS CHECK FOUND, RT EEPLS INOP BETWEEN ROW 16 TO ROW 17. RELAMPED PER MM.SDR SWAA113914ALight · inoperativeDURING SCHEDULED OTS CHECK FOUND, LT EEPLS INOP BETWEEN ROW 14 TO ROW 15. RELAMPED PER MM.SDR SWAA113913Light · inoperativeDURING SCHEDULED OTS CHECK FOUND, RT EEPLS INOP AT ROW 20. RELAMPED PER MM.SDR SWAA113912AStringer · corrodedDURING SCHEDULED OTS CHECK FOUND, STRINGER CORRODED AT BS 947.5, STR 25L. REPAIRED STRINGER PER EA.SDR SWAA113917AStringer Clip · crackedDURING SCHEDULED SPV CHECK FOUND, STRINGER CLIP CRACKED AT BS 727C, STR 20L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113916Stringer Clip · crackedDURING SCHEDULED SPV CHECK FOUND, STRINGER CLIP CRACKED AT BS 727B, STR 20L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113876Skin · damagedDURING SCHEDULED 20Y CHECK, FOUND LT HORIZONTAL STABILIZER SKIN MISSING MATERIAL BETWEEN STA 161.04 TO STA 170.34. REPAIRED SKIN PER SRM.SDR SWAA113875Angle · corrodedDURING SCHEDULED 20Y CHECK, FOUND ANGLE CORRODED BETWEEN BS 294.5 TO BS 328 STR 17R. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA113874Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT WING NR 6 SLAT L/E SKIN CRACKED. REPAIRED SLAT PER SRM.SDR SWAA113873Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM. REPAIRED FRAME PER SRM.SDR SWAA114009Wire · brokenDURING SCHEDULED OTS CHECK FOUND, LT EEPLS WIRE BROKEN. REMOVED AND REPLACED WIRE PER MM.SDR SWAA114008Crease Beam · corrodedDURING SCHEDULED OTS CHECK FOUND, LT CREASE BEAM WEB CORRODED AT BS 747+4, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA114007Crease Beam · corrodedDURING SCHEDULED OTS CHECK FOUND, LT CREASE BEAM WEB CORRODED AT BS 767+10. REMOVED AND REPLACED WEB PER SRM.SDR SWAA113903AStringer Clip · crackedDURING SCHEDULED OTS CHECK FOUND, STRINGER CLIP CRACKED AT BS 727C, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113814Stringer Clip · crackedDURING SCHEDULED 20Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 927, STR 25R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113813Stringer Clip · crackedDURING SCHEDULED 20Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 747, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113812Stringer Clip · crackedDURING SCHEDULED 20Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 767, STR 21L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113811Crease Beam · crackedDURING SCHEDULED 12Y CHECK FOUND, CREASE BEAM CHORD CRACKED BETWEEN BS 663+10 TO BS 727+4, STR 17L. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA113810Crease Beam · crackedDURING SCHEDULED 12Y CHECK FOUND, CREASE BEAM CRACKED BETWEEN BS 616 TO BS 639, STR 17R. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA113849Skin · crackedDURING SCHEDULED MV2 CHECK FOUND, SKIN CRACKED AT BS 406, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA113765Shear Tie · crackedDURING SCHEDULED 20Y CHECK FOUND, SHEAR TIE CRACKED AT BS 360, BETWEEN STR 13L TO STR 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.
Back to Boeing 737-5H4