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 SWAA097666Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM ANGLE CRACKED AT BS 727B, LBL 45.5. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA097700Mec · faultyINFLIGHT SHUTDOWN. DURING ILS APPROACH TO MCI, NR 1 ENGINE BEGAN TO ACCELERATE WITH NO THROTTLE MOVEMENT. A/C AT 3000 FEET, ENGINE ACCELERATED TO 95 PERCENT BEFORE SHUT DOWN. ALL PARAMETERS NORMAL, ENGINE APPEARED TO STABILIZE AT 95 PERCENT. REMOVED AND RESDR SWAA097607Window · arcedL1 COCKPIT WINDSHIELD ARCING ON DESCENT AND CRACKED UPON PARKING AT GATE. REMOVED AND REPLACED L1 WINDOW PER MM.SDR SWAA097608Wire · arcedR1 COCKPIT WINDOW HEAT WIRES ARCED DURING FLIGHT. REMOVED AND REPLACED WINDOW PER MM.SDR SWAA097598Lens · missingFWD GALLEY OVERHEAD EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA097580Wedge · delaminatedDURING SCHEDULED 8Y CHECK, FOUND LT WING NR 2 SLAT T/E WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA097565Wedge · delaminatedDURING SCHEDULED 18Y CHECK, FOUND LT WING NR 2 L/E SLAT T/E WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA097564Door Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND R1 DOOR LOWER WEB FRAME CRACKED. REMOVED AND REPLACED DOOR PER MM.SDR SWAA097496Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 662, RBL 24.5. REPAIRED WEB PER ER.SDR SWAA097481Flap · delaminatedDURING SCHEDULED MV1 CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA097533Stiffener · crackedDURING SCHEDULED MV2 CHECK, FOUND LT MAIN WHEEL WELL BULKHEAD SUPPORT STIFFENER CRACKED AT BS 633, LBL 6. REPAIRED STIFFENER PER EA.SDR SWAA097495Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA097417Battery Pack · dischargedLT FWD GALLEY EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA097347Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA097346Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787+12, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA097345Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 400, STR 1. REPAIRED SKIN PER SRM.SDR SWAA097344Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 807, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA097343Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA097279Skin · corrodedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 947 TO BS 952, STR 24L. REPAIRED SKIN PER EA.SDR SWAA097277Light · inoperativeDURING SCHEDULED MV3 CHECK, FOUND LT AFT EXTERNAL EMERGENCY LIGHT INOP. RELAMPED PER MM.SDR SWAA097252Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA097251Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 482B+15, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA097242Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747+12, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA097250Slide · out of adjustDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA097249Slide · out of adjustDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA097248Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND AFT ENTRY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA097231Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA097230Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 765 TO BS 785, STR 24L. REPAIRED SKIN PER SRM AND EA.SDR SWAA097229Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 933, STR 23R. REPAIRED SKIN PER SRM AND EA.SDR SWAA097228Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 765, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA097173Slide · low pressureDURING SCHEDULED MV1 CHECK, FOUND L2 DOOR EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA097118Slide · low pressureR2 DOOR EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MT.SDR SWAA097117Bulkhead · corrodedDURING SCHEDULED 20Y CHECK, FOUND BULKHEAD CHORD CORRODED AT BS 227, RBL 1 TO RBL 6. REPAIRED CHORD PER EA.SDR SWAA097020Crease Beam · crackedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM OUTER CHORD CRACKED BETWEEN BS 431 TO BS 435. REMOVED AND REPLACED BEAM PER AAR EA.SDR SWAA097019Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 662, LBL 24.5. REMOVED AND REPLACED BEAM PER AAR EA.SDR SWAA096966Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND SKIN CRACKED AT BS 947.5, STR 23L. REPAIRED SKIN PER AAR EA.SDR SWAA096965Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND SKIN CRACKED AT BS 927, STR 23L. REPAIRED SKIN PER AAR EA.SDR SWAA096964Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND LT AFT FUSELAGE SKIN CRACKED AT BS 753, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA096963Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 666.5, LBL 24.8. REPAIRED BEAM PER AAR EA.SDR SWAA096962Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 660, BBL .07. REPAIRED BEAM PER SI.SDR SWAA096961Skin · corrodedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CORRODED BETWEEN BS 948 TO BS 950, BETWEEN STR 25L TO STR 26L. REPAIRED SKIN PER EA.SDR SWAA096955Light · inoperativeDURING SCHEDULED 20Y CHECK, FOUND LOWER LT EXTERIOR EMERGENCY EXIT LIGHTS INOP. RELAMPED PER MM.SDR SWAA096954Light · inoperativeDURING SCHEDULED 20Y CHECK, FOUND EXTERIOR EMERGENCY EXIT LIGHTS INOP AT R2 DOOR. RELAMPED PER MM.SDR SWAA096953Light · inoperativeDURING SCHEDULED 20Y CHECK, FOUND FWD EEPLS INOP AT ROW 1. RELAMPED PER MM.SDR SWAA096930Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947, STR 27R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096929Skin · corrodedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO COMPARTMENT SKIN CORRODED AT BS 498B, LBL 11. REPAIRED SKIN PER AAR EA.SDR SWAA096928Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 43. REPAIRED BEAM PER AAR EA.SDR SWAA096927Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SI.SDR SWAA096926Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND SKIN CRACKED AT BS 527, RBL 5. REPAIRED SKIN PER AAR EA.SDR SWAA096925Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND SKIN CRACKED AT BS 527, LBL 5. REPAIRED SKIN PER AAR EA.
Back to Boeing 737-5H4