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 SWAA098132Slide · out of positionDURING SCHEDULED 18Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA098131Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482 BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA098130Light · brokenR1 DOOR LOWER EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA098108Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 23L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA098107Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA098106Shear Tie · crackedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CRACKED BETWEEN BS 286 TO BS 288, STR 13L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA098105Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 25L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA098104Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA098103Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 23L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA098102Attach Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND VERTICAL STABILIZER ATTACH FITTING RT LUG CORRODED. REPAIRED FITTING PER BAC DWG.SDR SWAA098101Attach Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND VERTICAL STABILIZER ATTACH FITTING LT LUG CORRODED. REPAIRED FITTING PER BAC DWG.SDR SWAA098100Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND CENTER BOX WING LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 727B, RBL 24.8. REPAIRED BEAM PER AAR EA.SDR SWAA098099Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND CENTER BOX WING LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 727B, LBL 24.8. REPAIRED BEAM PER AAR EA.SDR SWAA098098Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND CENTER BOX WING LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 707, LBL 24.8. REPAIRED WEB PER AAR EA.SDR SWAA098053Battery · dischargedDURING SCHEDULED MV2 CHECK, FOUND AFT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA098052Battery · dischargedDURING SCHEDULED MV2 CHECK, FOUND FWD LT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA098051Battery · dischargedDURING SCHEDULED MV2 CHECK, FOUND FWD RT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA098050Lens · looseDURING SCHEDULED CV CHECK, FOUND RT OVERWING EMERGENCY EXIT SIGN LIGHT LENS LOOSE. SECURED PER MM.SDR SWAA097998Shear Tie · crackedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CRACKED AT BS 482B, STR 19R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA097997Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 45.5. REPAIRED BEAM PER AAR EA.SDR SWAA097996Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA097943Web · crackedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR WEB CRACKED AT BS 294.5, STR 11L. REMOVED AND REPLACED WEB PER BAC DWG.SDR SWAA097942Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 348.2, STR 15L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097880Door Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND FWD GALLEY SERVICE DOOR BEAM FRAME CRACKED. REMOVED AND REPLACED R1 DOOR PER MM.SDR SWAA097879Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 932, STR 22R. REPAIRED SKIN PER SRM.SDR SWAA097878Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 947, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA097877Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 764, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA097876Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 750, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA097999Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA097833Bulkhead · crackedDURING SCHEDULED 20Y CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, LBL 5.7. REMOVED AND REPLACED WEB PER SRM.SDR SWAA097786Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR INNER SKIN LOWER AFT CORNER CRACKED. REPAIRED SKIN PER SRM.SDR SWAA2012091807721Skin · crackedSKIN CRACKED AT BS 947, STR 22L. REPAIRED SKIN PER EA.SDR SWAA097746Fitting · looseDURING SCHEDULED 18Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA097745Light · inoperativeDURING SCHEDULED 18Y CHECK, FOUND LT EXTERIOR EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED LAMP PER MM.SDR SWAA097744Hinge Fitting · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE HINGE BOX FITTING CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA097743Angle · corrodedDURING SCHEDULED 18Y CHECK, FOUND AFT CARGO COMPT, RT Z-ANGLE CORRODED AT BETWEEN BS 767 TO BS 794, STR 25R. REPAIRED Z-ANGLE PER BAC DWG.SDR SWAA097742Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 482, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA097741Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 482A, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA097747Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 955, STR 18L. REPAIRED SKIN PER EA.SDR SWAA097693Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO FRAME CRACKED AT BS 380, STR 21L. REPAIRED FRAME PER SRM.SDR SWAA097692Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO FRAME CRACKED AT BS 380, STR 22L. REPAIRED FRAME PER SRM.SDR SWAA097691Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA097690Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA097681Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097680Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 25R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097671Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097670Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097669Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097668Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097667Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM ANGLE CRACKED AT BS 727B, RBL 45.5. REMOVED AND REPLACED ANGLE PER SRM.
Back to Boeing 737-5H4