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 SWAA113747Web · corrodedDURING SCHEDULED 20Y CHECK FOUND, WEB CORRODED BETWEEN BS 727C TO BS 747, STR 17L. REMOVED AND REPLACED WEB PER SRM AND DWG.SDR SWAA113746Stringer Clip · crackedDURING SCHEDULED 12Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 787, STR 23L. REMOVED AND REPLACED CLIP PER DWG.SDR SWAA113745Stringer Clip · crackedDURING SCHEDULED 12Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 787, STR 24L. REMOVED AND REPLACED CLIP PER DWG.SDR SWAA113848Wire · disconnectedDURING SCHEDULED HC1 CHECK FOUND, LT EMERGENCY EXIT LIGHT INOP AT ROW 15. RECONNECTED WIRE PER MM.SDR SWAA113605Attach Angle · corrodedDURING SCHEDULED 22Y CHECK FOUND, R2 DOOR STA 965 TO STA 992 CREASE BEAM ATTACHED ANGLE CORRODED. REPAIRED CHORD PER SRM.SDR SWAA113762Fan · faultyDIVERSION/DECLARED EMERGENCY. FLIGHT ATTENDANTS REPORTED STRONG ELECTRICAL ODOR IN AFT GALLEY AND MID CABIN. STRONG ODOR ALSO NOTICED IN COCK.SDR SWAA113852Connector · disconnectedDURING SCHEDULED SPV CHECK FOUND, LT FWD OVERWING EMERGENCY EXIT LIGHT INOP. RECONNECTED CONNECTOR PER MM.SDR SWAA113851Battery Pack · failedDURING SCHEDULED SPV CHECK FOUND, RT AFT EMERGENCY EXIT LIGHT BATTERY PACK FAILED. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA113850Skin · crackedDURING SCHEDULED SPV CHECK FOUND, SKIN CRACKED AT BS 400, WL 232.5. REPAIRED SKIN PER EA.SDR SWAA113818Skin · crackedDURING SCHEDULED SPV CHECK FOUND, RT FUSELAGE SKIN CRACKED AT BS 400, WL 232.5. REPAIRED SKIN PER EA.SDR SWAA113806Skin · crackedDURING SCHEDULED MV3 CHECK FOUND, SKIN CRACKED AT BS 348, STR 2L. REPAIRED SKIN PER SRM.SDR SWAA113807Skin · crackedDURING SCHEDULED MV3 CHECK FOUND, FUSELAGE SKIN CRACKED AT UPPER HINGE CUTOUT LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA113607Gasper Fan · faultyIN CRUISE, FLIGHT ATTENDANTS REPORTED "BURNING ELECTICAL SMELL" IN FWD GALLEY. REMOVED AND REPLACED GASPER FAN IAW MM.SDR SWAA113544Crease Beam · crackedDURING SCHEDULED 22Y CHECK FOUND, RT CREASE BEAM WEB CRACKED CRACKED AT BS 616. REPAIRED WEB PER SRM.SDR SWAA113543Crease Beam · crackedDURING SCHEDULED SPV CHECK FOUND, RT CREASE BEAM WEB INNER CHORD CRACKED AT BS 639. REPAIRED CHORD PER SRM.SDR SWAA113542Skin · crackedDURING SCHEDULED 22Y CHECK FOUND, FWD CARGO DOOR EXTERIOR SKIN CRACKED AT LOWER FWD CORNER, AT EDGE OF SKIN. REPAIRED SKIN PER SRM.SDR SWAA113541Stringer Clip · crackedDURING SCHEDULED 22Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 277, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113540Stringer Clip · crackedDURING SCHEDULED 22Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 706, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113539Shear Tie · corrodedDURING SCHEDULED OTS CHECK FOUND, SHEAR TIE CORRODED AT BS 807, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA113538Shear Tie · corrodedDURING SCHEDULED OTS CHECK FOUND, SHEAR TIE CORRODED AT BS 787, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA113537Shear Tie · corrodedDURING SCHEDULED OTS CHECK FOUND, SHEAR TIE CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA113536Shear Tie · corrodedDURING SCHEDULED OTS CHECK FOUND, SHEAR TIE CORRODED AT BS 747, BETWEEN STR 26 AND 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA113535Shear Tie · corrodedDURING SCHEDULED OTS CHECK FOUND, SHEAR TIE CORRODED AT BS 727C, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA113534Shear Tie · corrodedDURING SCHEDULED OTS CHECK FOUND, SHEAR TIE CORRODED AT BS 827 BETWEEN STR 27L AND 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA113533Crease Beam · corrodedDURING SCHEDULED OTS CHECK FOUND, CREASE BEAM WEB CORRODED AT BS 450, LBL 65. REMOVED AND REPLACED WEB PER SRM.SDR SWAA113532Skin · crackedDURING SCHEDULED OTS CHECK FOUND, SKIN CRACKED BETWEEN BS 474.4 TO BS 475.9, STR 17L. REPAIRED SKIN PER EA.SDR SWAA113531Skin · delaminatedDURING SCHEDULED OTS CHECK FOUND, RT WING I/B FORE FLAP DELAMINATED ON UPPER SURFACE. REPAIRED FORE FLAP PER MM.SDR SWAA113530Skin · crackedDURING SCHEDULED OTS CHECK FOUND, FUSELAGE SKIN CRACKED AT BS 476, STR 17R. REPAIRED SKIN PER EA.SDR SWAA113529Skin · crackedDURING SCHEDULED OTS CHECK FOUND, L2 DOOR FUSELAGE SKIN CRACKED AT BS 942, STR 24 LT. REPAIRED SKIN PER ER.SDR SWAA113528Skin · crackedDURING SCHEDULED OTS CHECK FOUND, SKIN CRACKED AT BS 767 + 16, STR 24L. REPAIRED SKIN PER ER.SDR SWAA113527Skin · crackedDURING SCHEDULED OTS CHECK FOUND, SKIN CRACKED AT BS 787 + 3.5, STR 18L. REPAIRED SKIN PER ER.SDR SWAA113817Angle · crackedDURING SCHEDULED 20Y CHECK FOUND, CLIP ANGLE CRACKED AT BS 328, WL 181.37. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA113816Angle · crackedDURING SCHEDULED 20Y CHECK FOUND, CLIP ANGLE CRACKED AT BS 320, WL 181.37. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA113815Lens · delaminatedDURING SCHEDULED 20Y CHECK FOUND, R1 DOOR EMERGENCY EXIT LIGHT LENS DELAMINATED. REMOVED AND REPLACED LENS PER MM.SDR SWAA113417Stringer Clip · crackedDURING SCHEDULED 22Y CHECK FOUND, STRINGER CLIP 15R CRACKED AT BS 277, 15R. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA113736Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA113735Door · crackedDURING SCHEDULED M1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT LOWER CORNER. REMOVED AND REPLACED DOOR PER MM.SDR SWAA113710Skin · crackedDURING SCHEDULED MV1 CHECK FOUND, SKIN CRACKED AT BS 807, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA113673Light · inoperativeDURING SCHEDULED MV2 CHECK FOUND, R2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA113711Lens · brokenDURING SCHEDULED 20Y CHECK FOUND, R2 DOOR EMERGENCY EXIT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA113349ABulkhead · crackedDURING SCHEDULED OTS CHECK FOUND, AFT PRESSURE BULKHEAD WEB CRACKED AT LOWER EDGE OF PIE PANEL AT 12 O'CLOCK IN AND OUT OF FASTENER RIGHT ABOVE DOME PLUG BS 1016. REPAIRED WEB IAW SRM.SDR SWAA113348AFailsafe · corrodedDURING SCHEDULED OTS CHECK FOUND, FAIL SAFE CHORD AT STA 747 STR 26 - 27 LT IS CORRODED ON THE VERTICAL AND HORIZONTAL FLANGES. REPAIRED CHORD PER SRM.SDR SWAA113347ASkin · crackedDURING SCHEDULED OTS CHECK FOUND, AFT FUSELAGE CRACK AT BS 767+16 ABOVE STR 24 LEFT. REPAIRED SKIN PER SRM.SDR SWAA113346ASkin · crackedDURING SCHEDULED OTS CHECK FOUND, AFT FUSELAGE CRACKED AT BS 787+3." BELOW STR 18 LEFT. REPAIRED SKIN PER SRM.SDR SWAA113545Skin · crackedDURING SCHEDULED MV2 CHECK FOUND, SKIN CRACKED AT BS 867 + 4, STR 22R. REPAIRED SKIN PER SRM.SDR SWAA113546Bulkhead · crackedDURING SCHEDULED MV2 CHECK FOUND, AFT PRESSURE BULKHEAD WEB CRACKED AT LOWER EDGE OF SIDE PANEL. REMOVED AND REPLACED WEB PER SRM.SDR SWAA113303Cooling Fan · faultyDIVERSION / DECLARED EMERGENCY, WITH EQUIP COOLING FAN IN NORM POSITION, HEARD NOISE AND ELECTRICAL ODOR IN COCKPIT. REMOVED AND REPLACED EQUIP COOLING FAN VALVE PER MM.SDR SWAA113356Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACK AT BS 435.5, STR 17 LT. REPAIRED PER SRM.SDR SWAA113321Flap · delaminatedDURING SCHEDULED MV2 CHECK FOUND DELAMINATION LT OUTBD AFT FLAP. REMOVED AND REPLACED FLAP PER MM.SDR SWAA113320Stringer Clip · crackedDURING SCHEDULED 22Y CHECK FOUND LT CARGO COMPARTMENT STRINGER CLIP CRACKED, BS 767 STR 23L. REMOVED AND REPLACED CLIP PER SRM.
Back to Boeing 737-5H4