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 SWAA116161Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 727E+18, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA116159Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 16R. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA116158Keelbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND RT KEEL BEAM LOWER SURFACE CORRODED AT BS 663.75+25. REPAIRED BEAM IAW SRM.SDR SWAA116157Keelbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND RT KEEL BEAM LOWER SURFACE CORRODED AT BS 663.75+51. REPAIRED BEAM IAW SRM.SDR SWAA116156Keelbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND RT KEEL BEAM LOWER SURFACE CORRODED BETWEEN BS 663.75+10 TO BS 727. REPAIRED BEAM IAW SRM.SDR SWAA116095Lens · missingFWD ENTRY EMERGENCY EXIT LIGHT LENS MISSING. RE-INSTALLED LENS PER MM.SDR SWAA116033Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 794.3, BETWEEN STR 23R TO STR 25R. REMOVED AND REPLACED FRAME PER SRM AND DWG.SDR SWAA116032Support Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND SUPPORT ANGLE CRACKED BETWEEN BS 294.5 TO BS 303.9, STR 10L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA116031Pressure Panel · crackedDURING SCHEDULED 22Y CHECK, FOUND PRESSURE DECK WEB CRACKED BETWEEN BS 665 TO BS 675, BETWEEN RBL 35 TO RBL 45. REMOVED AND REPLACED WEB PER SRM.SDR SWAA116008Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BULB IAW MM.SDR SWAA116007Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 929 TO BS 932, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA116009Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTANTLY FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MM.SDR SWAA116010Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 24L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA116012Support · damagedDURING SCHEDULED HEAVY CHECK, FOUND AILERON LATER CONTROL POWER CONTROL SUPPORT BEARING BORE DAMAGED. REPAIRED PER EA.SDR SWAA115914Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 16L. REPAIRED CLIP IAW SRM.SDR SWAA115913Shear Tie · crackedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CRACKED AT BS 277, BETWEEN STR 8L TO STR 9L. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA115866Stringer · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CRACKED AT BS 400, STR 15R. REMOVED AND REPLACED STRINGER SECTION IAW SRM.SDR SWAA115865Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOOR BEAM CORRODED AT BS 967, LBL 5. REPAIRED BEAM IAW SRM.SDR SWAA115864Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 16R. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA115863Shear Tie · crackedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CRACKED AT BS 520, BETWEEN STR 21L TO STR 22L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA115862Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM INNER CHORD CORRODED BETWEEN BS 954 TO BS 986, RBL 50. REMOVED AND REPLACED CHORD PER SRM AND DWG.SDR SWAA115861Attach Angle · crackedDURING SCHEDULED 22Y CHECK, FOUND HORIZONTAL STABILIZER CENTER SECTION BEAM ATTACH ANGLE CRACKED AT BS 1119. REMOVED AND REPLACED ANGLE IAW SRM.SDR SWAA115794Channel · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 727B+4, LBL 3. REMOVED AND REPLACED CHANNEL IAW EA AND SRM.SDR SWAA115793Channel · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 727B+4, RBL 3. REMOVED AND REPLACED CHANNEL IAW EA AND SRM.SDR SWAA115792Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 5R. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA115789Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 7R. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA115823Flap · delaminatedDURING SCHEDULED MV1 CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA115787Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA115760Door · out of adjustAFTER TAKEOFF RT MAIN LANDING GEAR STAYED DOWN. CYCLED GEAR DOWN AND UP AND GEAR CAME UP. REMOVED AND REPLACED RT MLG INNER DOOR PER MM.SDR SWAA115715Indicator · faultyAIR TURNBACK - INTERMITTENT RADAR PAINTS WEATHER EVERY OTHER SWEEP AND ERASES WEATHER EVERY OTHER SWEEP. REMOVED AND REPLACED WEATHER RADAR INDICATOR.SDR SWAA115702Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CHORD CRACKED BETWEEN BS 661 TO BS 674, RBL 24.5. REPAIRED CHORD PER EA.SDR SWAA115701Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CHORD CRACKED BETWEEN BS 639 TO BS 680, LBL 24.5. REPAIRED CHORD PER EA.SDR SWAA115704Light · looseLT EEPLS LOOSE BETWEEN ROW 6 TO ROW 7. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA115703Battery Pack · inoperativeDURING SCHEDULED MV1 CHECK, FOUND LT AFT GALLEY EMERGENCY EXIT LIGHT BATTERY PACK INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA115616Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 6R. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA115594Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663.75, STR 10L. REMOVED AND REPLACED CLIP IAW MM.SDR SWAA115593Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND LT CREASE BEAM BETWEEN BS 867 TO BS 887 WEB UPPER FACE CORRODED. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA115592Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 6R. REPAIRED WEB IAW SRM.SDR SWAA115542Fitting · crackedDURING SCHEDULED 22Y CHECK, FOUND VERTICAL FITTING CRACKED AT BS 727, RBL 45.5. REMOVED AND REPLACED FITTING IAW SRM AND DWG.SDR SWAA115541Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER AFT CORNER BEAR STRAP. REPAIRED SKIN IAW SRM.SDR SWAA115540Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 22R. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA115539Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 19L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA115543Battery Pack · dischargedDURING SCHEDULED MV3 CHECK, FOUND L1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA115544Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA115523APump · faultyDECLARED EMERGENCY - ON DESCENT FROM FL 350, WITH THROTTLES AT IDLE AND N1 APPROX 60 PERCENT, NOTICED A LOUD POP AND VIBRATION COMING FROM NR 2 ENGINE, ON LEVEL OFF BOTH THROTTLES SLOWLY ADVANCED AND OPERATED NORMAL, AGAIN ON DESCENT RETARDED APPROX 60 PERCENTSDR SWAA115475Fitting · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT I/B VERTICAL STIFFENER FITTING AT KEEL BEAM CRACKED AT BS 727, LBL 6. REMOVED AND REPLACED FITTING IAW SRM AND DWG.SDR SWAA115474Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 924, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA115449Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 20L. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA115448Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA115447Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 21L. REMOVED AND REPLACED CLIP PER SRM AND DWG.
Back to Boeing 737-5H4