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 SWAA100484Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND SKIN CRACKED AT BS 767, STR 24L. REPAIRED SKIN PER EA.SDR SWAA100483Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND SKIN CRACKED AT BS 777, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA100482Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND SKIN CRACKED AT BS 782, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA100404Lens · missingRT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA100372Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM LOWER CHORD CRACKED AT BS 707, BL 0. REPAIRED CHORD PER SI.SDR SWAA100371Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND SKIN CRACKED AT BS 842, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA100370Angle · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME TO FLOORBEAM ANGLE CRACKED AT BS 727B, RBL 45. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA100275Light · looseDURING SCHEDULED MV2 CHECK, FOUND RT EEPLS LOOSE AT ROW 20. SECURED EEPLS PER MM.SDR SWAA100194Light · inoperativeDURING SCHEDULED MV3 CHECK, FOUND LT OVERHEAD EMERGENCY EXIT LIGHT INOP AT ROW 3. RELAMPED PER MM.SDR SWAA100201Sign · looseL1 DOOR EMERGENCY EXIT SIGN LOOSE. REMOVED AND REPLACED SIGN PER MM.SDR SWAA100157Stringer Clip · corrodedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 947, STR 24L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100156Stringer · corrodedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CORRODED AT BS 967, STR 25L. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA100155Connector · looseDURING SCHEDULED 18Y CHECK, FOUND R1 DOOR LOWER EMERGENCY EXIT SIGN WIRES LOOSE. SECURED CONNECTORS PER SWPM.SDR SWAA100154Slide · out of positionDURING SCHEDULED 18Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA100152Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 716, BBL 0. REPAIRED BEAM PER ER.SDR SWAA100151Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 707 TO BS 708, RBL 24.8. REPAIRED BEAM PER ER.SDR SWAA100150Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 707 TO BS 708, LBL 24.6. REPAIRED BEAM PER ER.SDR SWAA100147Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482B, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA100176Bracket · brokenL2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR BRACKET SPRING BROKEN. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA100149Fitting · looseDURING SCHEDULED SPV CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA100148Tab · crackedDURING SCHEDULED SPV CHECK, FOUND LT WING AILERON TAB END CRACKED. REMOVED AND REPLACED TAB PER MM.SDR SWAA100144Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BETWEEN BS 787 TO BS 807, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA100143Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 761, STR 23L. REPAIRED SKIN PER EA.SDR SWAA100142Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 765, STR 23L. REPAIRED SKIN PER EA.SDR SWAA100140Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 764, STR 22L. REPAIRED SKIN PER EA.SDR SWAA100146Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 376, STR 15L. REPAIRED SKIN PER EA.SDR SWAA100145Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 392, STR 15L. REPAIRED SKIN PER EA.SDR SWAA100110Door Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO DOOR CUTOUT FRAME CRACKED AT BS 400, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA100089Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 482B LT WIRE PENETRATION HOLE. REPAIRED FRAME PER SRM.SDR SWAA100088Light · fadedDURING SCHEDULED 20Y CHECK, FOUND COCKPIT P5 PANEL EMERGENCY "NOT ARMED" EXIT LIGHT FADED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA100087Angle · corrodedDURING SCHEDULED 20Y CHECK, FOUND Z-ANGLE CORRODED BETWEEN BS 452 TO BS 482. REMOVED AND REPLACED Z-ANGLE PER BAC DWG.SDR SWAA100077Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA100076Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA100075Stringer Splice · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 361, STR 4L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA100074Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO BAY AFT FRAME DOOR CUTOUT CRACKED AT BS 452. REMOVED AND REPLACED PER ACO.SDR SWAA100053Fitting · looseDURING SCHEDULED 18Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA100052Fitting · looseDURING SCHEDULED 18Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA100050Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 482B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER AAR EA.SDR SWAA100049Mount Fitting · crackedDURING SCHEDULED 18Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD MOUNT FITTING CRACKED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA100030Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947.5, STR 24R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100029Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED BETWEEN BS 360 TO BS 399, BETWEEN STR 27L TO STR 27R. REPAIRED SKIN PER AAR EA.SDR SWAA100028Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 482, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA100027Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND CENTER WING BOX LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 713.5, BBL 0.07. REPAIRED WEB PER SRM.SDR SWAA100026Splice · damagedDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LIGHT INOP. REMOVED AND REPLACED SPLICE PER MM.SDR SWAA098126Strap · crackedDURING SCHEDULED 18Y CHECK, FOUND L1 DOOR CUTOUT STRINGER STRAP CRACKED AT BS 303, STR 13L. REMOVED AND REPLACED STRAP PER SRM.SDR SWAA098147Mount Bracket · brokenDURING SCHEDULED 18Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FLOOR MOUNT BRACKET BROKEN. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA098146Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND SKIN CRACKED AT BS 750, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA098145Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA098144Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 482B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA098143Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 715, BBL 0. REPAIRED BEAM PER AAR EA.
Back to Boeing 737-5H4