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 SWAA082589Fitting · looseDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING LOOSE. SECURED FITTING PER SRM.SDR SWAA082588Fitting · looseDURING SCHEDULED BRDG CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FITTING PER SRM.SDR SWAA082573Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082574Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082575Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082576Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082571Flap Track · looseDURING SCHEDULED BRDG CHECK, FOUND RIGHT WING NR 8 FLAP TRACK "A" FRAME LOOSE AT CARRIAGE. REMOVED AND REPLACED FLAP TRACK PER MM.SDR SWAA082572Hook · looseDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR HOOK LOOSE. SECURED GIRT BAR HOOK PER SRM.SDR SWAA082546Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 413, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA082550Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 489, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA082549Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR CUTOUT FWD LOWER CORNER. REPAIRED SKIN PER SWA EA.SDR SWAA082547Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 779, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA082548Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA082521Strap · brokenDURING SCHEDULED 16Y CHECK, FOUND L2 DOOR EVACUATION SLIDE CONTAINER RETAINING STRAPS BROKEN. REMOVED AND REPLACED RETAINING STRAPS PER SRM.SDR SWAA082480Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 6 ABC. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA082422Slat · wornDURING SCHEDULED 16Y CHECK, FOUND LEFT WING NR 3 L/E SLAT WORN AT OUTBOARD END. REMOVED AND REPLACED SLAT PER MM.SDR SWAA082421Stringer Splice · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 7L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA082420Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082419Slat · crackedDURING SCHEDULED 16Y CHECK, FOUND LT WING NR 1 L/E SLAT CRACKED AT OUTBOARD END. REPAIRED SLAT PER SRM.SDR SWAA082418Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA082383Torque Tube · failedDURING SCHEDULED 16Y CHECK, RIGHT ELEVATOR FAILS FREE PLAY CHECK. REMOVED AND REPLACED ELEVATOR OUTPUT TORQUE TUBE PER MM.SDR SWAA082382Torque Tube · failedDURING SCHEDULED 16Y CHECK, LEFT ELEVATOR FAILS FREE PLAY CHECK. REMOVED AND REPLACED ELEVATOR OUTPUT TORQUE TUBE PER MM.SDR SWAA082381Sign · looseLEFT OVERWING EMERGENCY EXIT LIGHT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA082361Light · inoperativeDURING SCHEDULED 16Y CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 23 ABC. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA082362Light · inoperativeDURING SCHEDULED 16Y CHECK, FOUND LEFT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA082358Shear Tie · corrodedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482B, RBL 2 TO RBL 10, WL 148. REPAIRED SHEAR TIE PER ER.SDR SWAA082359Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 963, STR 21L. REPAIRED SKIN PER ER.SDR SWAA082360Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA082356Actuator · brokenDURING SCHEDULED 16Y CHECK, FOUND LEFT WING NR 4 SPOILER INBOARD ACTUATOR AFT ATTACH POINT BROKEN. REMOVED AND REPLACED ACTUATOR PER MM.SDR SWAA082357Hinge · brokenDURING SCHEDULED 16Y CHECK, FOUND LEFT WING NR 4 SPOILER OUTBOARD ACTUATOR HINGE BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA082321Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 559, STR 17L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA082281Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 4L CRACKED AT BS 1010. REPAIRED STRINGER PER EA.SDR SWAA082280Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 5L CRACKED AT BS 1010. REPAIRED STRINGER PER EA.SDR SWAA082279Angle · corrodedDURING SCHEDULED 16Y CHECK, FOUND ZEE CHORD CORRODED AT BS 270, LBL 11 TO RBL 11, WL 208. REMOVED AND REPLACED ZEE CHORD PER SRM.SDR SWAA082258Sign · inoperativeDURING SCHEDULED 16Y CHECK, FOUND FWD CABIN EMERGENCY EXIT SIGN INOP. REMOVED AND REPLACED EXIT SIGN PER MM.SDR SWAA082235Resistor · disconnectedDURING SCHEDULED 16Y CHECK, FOUND FLIGHT DECK EMERGENCY EXIT LIGHT INOP. FOUND RESISTOR M1219 DISCONNECTED. RECONNECTED RESISTOR PER MM.SDR SWAA082230Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 482B, LBL 9, WL 148. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA082229Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 947, STR 11L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA082207Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 701, BL 0. REPAIRED FLOORBEAM PER ER AND BOEING SB.SDR SWAA082206Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, BL 0. REPAIRED FLOORBEAM PER ER AND BOEING SB.SDR SWAA082208Light · inoperativeDURING SCHEDULED 16Y CHECK, FOUND RIGHT OVERWING EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA082209Light · inoperativeDURING SCHEDULED 16Y CHECK, FOUND LEFT OVERWING EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA082210Light · inoperativeDURING SCHEDULED 16Y CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA082211Wire · brokenDURING SCHEDULED 16Y CHECK, FOUND FLIGHT DECK EMERGENCY EXIT LIGHT INOP. FOUND BROKEN WIRE AT D2992. REPAIRED WIRE PER WDM.SDR SWAA082205Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BETWEEN BS 387 AND BS 454, RBL 1 AND LBL 3. REPAIRED SKIN PER ER.SDR SWAA082162Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082183Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT EQUIPMENT COOLING EXHAUST DUCT. REPAIRED SKIN PER BOEING SB AND EA.SDR SWAA082199Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 986, RBL 43. REPAIRED FRAME PER SRM.SDR SWAA082198Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM WEB CORRODED BETWEEN BS 1016 AND BS 1040, BL 0 AND RBL 38. REMOVED AND REPLACED WEB PER SRM.SDR SWAA082197Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM WEB CORRODED BETWEEN BS 1006 AND BS 1016, LBL 38 AND LBL 39. REMOVED AND REPLACED WEB PER SRM.
Back to Boeing 737-5H4