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 SWAA101344Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101343Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101342Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101443Sensor · faultyDECLARED EMERGENCY. NR 1 ENGINE COMPRESSOR STALLED. REMOVED AND REPLACED NR 1 ENGINE MEC, FUEL PUMP AND CIT SENSOR PER MM.SDR SWAA101312Bulkhead · crackedDURING SCHEDULED 20Y CHECK, FOUND PRESSURE BULKHEAD CRACKED AT BS 178, LBL 17.0. REPAIRED BULKHEAD PER AEM EO.SDR SWAA101311Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 45.5. REPAIRED CHORD PER AEM EO.SDR SWAA101283Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101282Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101281Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 2R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101280Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482A, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101279Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101278Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101246Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA101286Lens · looseDURING SCHEDULED 2HC1 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA101285Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER AFT CORNER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA101284Structure · crackedDURING SCHEDULED 2HC1 CHECK, FOUND L1 DOOR CRACKED AT LOWER FWD CORNER, APPROX LENGTH OF CRACK, 2.5 INCHES. REMOVED AND REPLACED L1 DOOR PER MM.SDR SWAA101215Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 45.5. REPAIRED BEAM PER SRM.SDR SWAA101197Flap · delaminatedDURING SCHEDULED OTS CHECK, FOUND RT WING O/B FORE FLAP T/E DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA101130Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 21R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101129Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101128Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101127Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 19L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101126Sill · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR LOWER SILL WEB CRACKED AT BS 416. REPAIRED WEB PER SRM.SDR SWAA101125Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 27L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101124Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO COMPT FRAME CRACKED AT BS 482, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA101123Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO COMPT FRAME CRACKED AT BS 482A, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA101122Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 831, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA101101Lens · looseLEFT OVERHEAD BULLNOSE EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LENS PER MM.SDR SWAA101046Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482B, BETWEEN STR 20L TO STR 21L. REPAIRED SKIN PER ER.SDR SWAA101045Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 932, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA101044Stringer Splice · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA101208Beam · crackedDURING SCHEDULED HC2 CHECK, FOUND CABIN R1 DOOR AFT LOWER ACCESS BEAM CRACKED FROM EDGE FWD BELOW HI-LOKS. REMOVED AND REPLACED DOOR PER MM.SDR SWAA100974Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA100973Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA100891Wedge · delaminatedDURING SCHEDULED OTS CHECK, FOUND LT WING NR 2 SLAT T/E WEDGE DELAMINATED. REMOVED AND REPLACED NR 2 SLAT PER MM.SDR SWAA100876Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND EEPLS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA100875Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND EXTERIOR EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA100874Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BETWEEN BS 404 TO BS 408, STR 16R. REPAIRED SKIN PER EA.SDR SWAA100829Keelbeam · crackedDURING SCHEDULED OTS CHECK, FOUND WHEEL WELL KEEL BEAM WEB CRACKED AT BS 711. REMOVED AND REPLACED WEB PER SRM.SDR SWAA100830Angle · crackedDURING SCHEDULED OTS CHECK, FOUND LT KEEL BEAM Z-ANGLE CRACKED AT BS 711. REPAIRED Z-ANGLE PER SRM.SDR SWAA100800Lens · looseDURING SCHEDULED 2HC1 CHECK, FOUND RT EEPLS LENS LOOSE AT ROW 5. SECURED LENS PER MM.SDR SWAA100685Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CUTOUT CRACKED AT R1 DOOR LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA100684Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED BETWEEN BS 793 TO BS 795, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA100668Door Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND R1 DOOR AFT FRAME CRACKED 2ND STOP FITTING DOWN. REMOVED AND REPLACED R1 DOOR PER MM.SDR SWAA100667Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND AFT CARGO DOOR SKIN CRACKED AT AFT CORNER. REPAIRED SKIN PER EA.SDR SWAA100645Light · inoperativeEMERGENCY EXIT LIGHT INOP AT FWD LAV. SECURED LIGHT PER MM.SDR SWAA100583Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT EMERGENCY EXIT BULLNOSE LIGHT INOP AT ROW 11. RELAMPED PER MM.SDR SWAA100525Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND GROUND AIR CONDITION DOOR CUTOUT CRACKED AT FWD LT CORNER. REPAIRED SKIN PER ER.SDR SWAA100485Flap · delaminatedDURING SCHEDULED 18Y CHECK, FOUND LT WING O/B FORE FLAP T/E DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA100452Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM LOWER CHORD WEB CRACKED AT BS 664, LBL 24.8. REPAIRED BEAM PER ER.
Back to Boeing 737-5H4