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 SWAA116427Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME OUTER CHORD CRACKED AT BS 639, STR 16L. REPAIRED CHORD IAW EA.SDR SWAA116426Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT S 747, BETWEEN STR 26R TO STR 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA116410Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING T/E FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP IAW MM.SDR SWAA116387Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 959.5, STR 17L. REPAIRED SKIN IAW EA.SDR SWAA116416Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 794, BETWEEN STR 27R TO STR 25R. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA116370Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUINDAL FLOORBEAM UPPER O/B CHORD CRACKED AT BS 727B, RBL 24. REPAIRED CHORD PER ER AND EA.SDR SWAA116369Floor Support · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO FLOOR SUPPORT CORRODED AT BS 772, LBL 12. REPAIRED SUPPORT IAW EA.SDR SWAA116368Floor Support · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO FLOOR SUPPORT CORRODED AT BS 772, LBL 8. REPAIRED SUPPORT IAW EA.SDR SWAA116367Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA116366Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 827+6.5, STR 18L. REPAIRED SKIN IAW SRM.SDR SWAA116365Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 927, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA116364Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING AFT O/B FLAP DELAMINATED. REPAIRED AFT FLAP PER MM.SDR SWAA116363Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED BETWEEN BS 827+4 TO BS 827+14, STR 16L. REPAIRED SKIN IAW SRM.SDR SWAA116362Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND L2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW MM.SDR SWAA116361Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 947, STR 18L. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA116360Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 910.5, STR 23R. REPAIRED SKIN IAW EA.SDR SWAA116359Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 923, STR 21R. REPAIRED SKIN IAW EA.SDR SWAA116358Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 927+8, STR 18L. REPAIRED SKIN IAW EA.SDR SWAA116357Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM T-CAP CORRODED AT BS 344, BETWEEN LBL 24 TO RBL 2. REPAIRED T-CAP PER SRM AND DWG.SDR SWAA116356Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER FORWARD CORNER. REPAIRED SKIN IAW EA.SDR SWAA116355Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 375, STR 17R. REPAIRED SKIN IAW ER.SDR SWAA116354Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 947, STR 19R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA116353Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT SHEAR TIE CORRODED AT BS 727C, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA116352Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 967, BETWEEN STR 6L TO STR 7L. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA116351Lens · missingDURING SCHEDULED 22Y CHECK, FOUND FWD LAV EMERGENCY EXIT SIGN LENS MISSING. REMOVED AND REPLACED SIGN IAW MM.SDR SWAA116350Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 665, LBL 24. REPAIRED CHORD IAW EA.SDR SWAA116349Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 669, LBL 24. REPAIRED CHORD IAW EA.SDR SWAA116348Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 21L. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA116347Stringer Clip · crackedDURING SCHEDULE 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA116346Stringer Clip · crackedDURING SCHEDULE 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 967, STR 26R. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA116329Actuator · faultyRIGHT MAIN LANDING GEAR "RED INTRANSIT" LIGHT REMAINS ON AFTER TAKEOFF RETRACTION. GOES OUT AFTER RECYCLE TO "OFF" THEN "UP". REMOVED AND REPLACED UPLOCK ACTUATOR PER MM.SDR SWAA116328Circuit Card · faultyAFTER TAKEOFF WITH GEAR IN UP POSITION "RIGHT GEAR" RED & GREEN LIGHTS ON. HANDLE IN OFF POSITION ONLY RED LIGHT ON. RECYCLED GEAR AND NORMAL INDICATIONS. REMOVED AND REPLACED MAIN GEAR RED LIGHT CARD PER MM.SDR SWAA116469Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 749, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA116267Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND RT HORIZONTAL STABILIZER LOWER SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA116266Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 727C+8, STR 23L. REPAIRED SKIN IAW SRM.SDR SWAA116265Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 420 TO BS 440. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA116264Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM T-CAP CORRODED AT BS 986, BL 0. REMOVED AND REPLACED T-CAP IAW EA.SDR SWAA116263Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 45. REPAIRED CHORD PER ER AND ER.SDR SWAA116262Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 273, STR 16L. REPAIRED SKIN IAW SRM.SDR SWAA116237Frame · crackedDURING SCHEDULED SPV CHECK, FOUND RT FRAME INNER CHORD CRACKED AT BS 616, STR 17R. REPAIRED CHORD IAW EA.SDR SWAA116236Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 986.5, STR 20R. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA116235Floor Support · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 859, RBL 3. REPAIRED SUPPORT IAW EA.SDR SWAA116234Floor Support · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 772, LBL 8. REPAIRED SUPPORT IAW EA.SDR SWAA116279Slide · low pressureR1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE LOW. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA116209Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING O/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA116208Rib · crackedDURING SCHEDULED 20Y CHECK, FOUND RT HORIZONTAL STABILIZER L/E RIB CRACKED AT STA 1883.94. REMOVED AND REPLACED RIB IAW SRM AND DWG.SDR SWAA116207Web · corrodedDURING SCHEDULED 22Y CHECK, FOUND FWD CARGO COMPARTMENT WEB CORRODED AT BS 400, BETWEEN STR 23R TO STR 24R. REPAIRED WEB IAW EA.SDR SWAA116206Floor Support · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT FLOOR SUPPORT CORRODED AT BS 772, LBL 12. REPAIRED SUPPORT IAW EA.SDR SWAA116193Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 752, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA2013090919962Skin · crackedFS SKIN CRACKED BETWEEN STATION 747 TO STATION 767, STRINGER 22L. REPAIRED SKIN IAW SRM.
Back to Boeing 737-5H4