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 SWAA020103Web · crackedDURING SCHEDULED D CHECK, FOUND WEB CRACKED AT BS 294.5, STR 16L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA020077Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED (2 EA) AT BS 616, STR 1R AND 2R. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA020064Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICES CRACKED (2 EA) AT BS 907, STR 4L AND 4R. REMOVED AND REPLACED STR SPLICES PER SRM.SDR SWAA020065Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 6L. REPAIRED FRAME PER SRM.SDR SWAA020057Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED (2 EA) AT BS 685, STR 1L AND 2L. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA013425Lens · looseLT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA013290Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (4 EA) BETWEEN STRS 8L AND 9L, BS 520, 747, 787 AND 827. REPAIRED FRAMESPER BFG ER.SDR SWAA013289Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (3 EA) BETWEEN STRS 8R AND 9R, BS 380, 747 AND 787. REPAIRED FRAMES PER BFG ER.SDR SWAA013278Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED UPON ARRIVAL. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA013266Flashlight · inoperativeEMERGENCY FLASHLIGHT INOP AT FWD CABIN UPPER POSITION. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA013245Lens · looseEEPLS LENS LOOSE AT ROW 8. REMOVED AND REPLACED EEPLS LIGHT ASSY PER MM.SDR SWAA013222Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT OUT OF ADJUST. REPOSITIONED SLIDE PER MM.SDR SWAA013214Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND WEB CRACKED AT BS 178, WL 234 AND LBL 10. REPAIRED WEB PER SRM.SDR SWAA013216Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, WL 226 AND RBL 17.1. REMOVED AND REPLACED WEB PER SRM.SDR SWAA013215Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND HORIZONTAL WEBS CRACKED (2 EA) AT BS 179, WL 207, LBL 27.0 AND RBL 27.0. REMOVED AND REPLACED WEBS PER SRM.SDR SWAA013202Actuator · failedNR 7 SPOILER WOULD NOT DEPLOY. FOUND NR 7 SPOILER CABLE LOOSE OUTSIDE THE SPOILER HOUSING AND NR 7 SPOILER ACTUATOR INOP. REMOVED AND REPLACED SPOILER CONTROL CABLES AND SPOILER ACTUATOR PER MM.SDR SWAA013193Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND 2 EA SHEAR TIES CRACKED, BS 344 AND BS 360, BETWEEN STRINGERS 14R-15R. REPAIRED SHEAR TIES PER SRM.SDR SWAA013160Battery · dischargedDURING SCHEDULED RON, FOUND FWD SVC DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA013221Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 22R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA013135Slat · crackedDURING SCHEDULED C1 CHECK, FOUND NR 1 L/E SLAT CRACKED 20 INCHES INBD OF ACTUATOR. REPAIRED NR 1 L/E SLAT PER SWA RA..SDR SWAA013130Lens · looseDURING SCHEDULED C1 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA013110Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED (6 EA) AT BS 178, BETWEEN LBL 10 & RBL 11. REPAIRED WEB PER SRM.SDR SWAA013080Flap · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT OTBD AFT FLAP DELAMINATED AT LOWER SURFACE INBD END. R&R FLAP PER MM.SDR SWAA013031Flap · delaminatedDURING SCHEDULED C2 CHECK, FOUND LH OTBD AFT FLAP T/E CORNER DELAMINATED. REPAIRED FLAP PER SRM.SDR SWAA012942Slide · out of adjFWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA012932Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED AT BS 727D, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA012931Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012928Fastener · looseDURING SCHEDULED C2 CHECK, FOUND LOOSE FASTENER AT FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINING HOOK. SECURED GIRT BAR HOOK PER MM.SDR SWAA012927Slide · dirtyDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND WINDOW DIFFICULT TO SEE THROUGH. CLEANED WINDOW PER MM.SDR SWAA012926Fastener · looseDURING SCHEDULED C2 CHECK, FOUND LOOSE FASTENER AT FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINING HOOK. SECURED GIRT BAR HOOK PER MM.SDR SWAA012916Lens · looseDURING SCHEDULED C1 CHECK, FOUND OVERHEAD BIN BULL NOSE EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 2DEF. R&R LENS PER MM.SDR SWAA012877Light · inoperativeEEPLS INOP FWD CABIN. REMOVED AND REPLACED LIGHT BASE AND INSTALLED END CAP SPACER PER MM.SDR SWAA012873Slide · looseAFT ENTRY DOOR EMERGENCY EVAC SLIDE FASTENER LOOSE ON SLIDE CONTAINER. SECURED CONTAINER PER MM.SDR SWAA012857Line · looseENGINE SHUT DOWN, DECLARED EMERGENCY. DURING FLIGHT SHUT DOWN NR 2 ENGINE 0 OIL QUANTITY, LOW OIL PRESS. FOUND NR 5 BEARING SUMP EXTERNAL OIL LINE LOOSE. TIGHTENED AND SAFETIED, SERVICED AND RAN ENG. NO LEAKS NOTED AND OPS CK GOOD PER MM.SDR SWAA012849Cover · brokenEEPLS COVER BROKEN AT ROW 15. R&R COVER PER MM.SDR SWAA012869Skin · crackedDURING SCHEDULED A1 CHECK, FOUND CAPT'S FWD WINDOW POST SKIN CRACKED .5 INCHES. REPAIRED WINDOW POST SKIN PER SRM.SDR SWAA012831Slide · looseAFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR LANYARD LOOSE. SECURED LANYARD PER MM.SDR SWAA012852Slide · looseAFT ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA012828Warning Light · erraticDURING FLIGHT FIRE WARNING LIGHT CAME ON FOR 2 SECONDS AT FLIGHT LEVEL 310 AND WENT OUT, NO OTHER INDICATIONS NOTED. INSPECTED CARGO COMP & ENGINE FOR DEFECTS, NONE NOTED. FIRE TEST OF CARGO COMP & ENGINES NORMAL.SDR SWAA012827Light · looseEEPLS LOOSE IN CABIN. SECURED EEPLS PER MM.SDR SWAA012814Window · missingAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND VIEWING WINDOW MISSING. INSTALLED VIEWING WINDOW PER MM.SDR SWAA012804Light · inoperativeDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA012802Wire · brokenDURING SCHEDULED D-CHECK, FOUND FWD SVC DOOR EMERGENCY EXIT LIGHT INOP. REPAIRED BROKEN WIRE PER MM.SDR SWAA012813Flap · delaminatedDURING WALK AROUND INSPECTION, FOUND # 1 T/E FLAP DELAMINATED 1 1/2 INCHES FROM AFT T/E. REPAIRED FLAP PER SRM..SDR SWAA012794Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA012776Battery · erraticDURING SCHEDULED PM CHECK, FOUND AFT CABIN EMERGENCY LIGHTS ON WHEN SWITCH IS OFF. R&R BATTERY PER MM.SDR SWAA012761Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA012738Cover · crackedDURING SCHEDULED C2 CHECK, FOUND EEPLS COVER CRACKED AT ROW 1. R&R COVER PER MM.SDR SWAA012736Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA012685Frame · crackedDURING SCHEDULED D CHECK AT DALFORT, FOUND Z FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SRM.
Back to Boeing 737-5H4