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 SWAA2012101908669Crease Beam · damagedCREASE BEAM CHORD MISSING AT BS 727A, STR 17R. REPAIRED CHORD IAW SRM & DWG.SDR SWAA2012110509032Frame · crackedFRAME CRACKED AT BS 482, STR 21L. REPAIRED FRAME IAW EA.SDR SWAA2012110509031Skin · crackedL1 DOOR FUSELAGE SKIN CRACKED AT FWD UPPER CORNER, BS 312, STR 6L. REPAIRED SKIN IAW EA.SDR SWAA2012112609779Structure · corrodedAFTER REMOVAL OF LEVELING COMPOUND AT STATION 243 THROUGH STATION 251 LEFT BODY LINE 16 THROUGH LEFT BODY LINE 18 LOWER CHORD WAS FOUND TO BE CORRODED. FOUND CHORD TO BE OUT OF LIMITS. ORIG "T" 0.125" REMAINING 0.100" REMOVED 0.025" IAW SRMSDR SWAA2012111509504Strip · crackedFORWARD ENTRY DOOR CUTOUT NUT PLATE STRIP OUTBOARD OF FRAME AT STATION 348.2 IS CRACKED NEAR CABIN FLOOR LEVEL BELOW STRINGER 16 LEFT. REMOVED AND REPLACED STRIP IAW DWG AND SRM.SDR SWAA2012111509423Shear Tie · crackedFORWARD ENTRY DOOR CUTOUT SHEAR TIE AT STATION 294.5 STRINGER 14L CRACKED AT RADIUS. REMOVED AND REPLACED ANGLE IAW BOEING DWG AND IAW SRM.SDR SWAA2012110509096Door Frame · crackedL1 DOOR FRAME WEB CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME IAW SRM & DWG.SDR SWAA2012102408806Stringer · crackedL1 DOOR CUTOUT STRINGER CRACKED AT BS 360, STR 7L. REMOVED AND REPLACED STRINGER IAW DWG AND SRM.SDR SWAA2012112609778Crease Beam · corrodedLEFT CABIN CREASE BEAM WEB IS CORRODED ON UPPER SURFACE NEAR STATION 887 THROUGH 907. REMOVED AND REPLACED CREASE BEAM WEB AT BS 887 - BS 907 LEFT IAW SRM 51-40-02 AND BOEING DWG 65-47976 REMOVED CORROSION ORIG "T" .036" REMOVED .005" REMAININGSDR SWAA2012112609747Skin · corrodedCORROSION BETWEEN STRINGER AND SKIN AND UNDER END OF KEEL BEAM. REPAIRED SKIN IAW EA AND IR.SDR SWAA2012111509503Crease Beam · corrodedRIGHT CABIN CREASE BEAM WEB IS CORRODED ON UPPER SURFACE NEAR STATION 727B+4. REMOVED AND REPLACED WEB IAW SRM AND BOEING DWG.SDR SWAA2012111209259Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 867+6 TO BS 867+12. REPAIRED WEB IAW SRM.SDR SWAA2012111209258Frame · crackedFRAME CRACKED AT BS 986.5, STR 3L. REPAIRED FRAME IAW SRM & DWG.SDR SWAA2012102508843Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED AT STA 727B+16. REPAIRED WEB IAW SRM.SDR SWAA2012102508842Keelbeam · corrodedLEFT KEEL BEAM LOWER CHORD CORRODED AT BS 520 +3, STR 28L. REPAIRED CHORD IAW SRM & DWG.SDR SWAA2012101908679Skin · crackedSKIN CRACKED AT BS 390, STR 16R. REPAIRED SKIN PER EA.SDR SWAA2012101608566Battery Pack · dischargedRIGHT EMERGENCY EXIT LIGHT INOP BETWTEEN ROW 8 TO ROW 9. CHARGED BATTERY PACK IAW MM.SDR SWAA2012112609777Support Bracket · crackedAFT PIT LEFT 727 KEEL BEAM SUPPORT BRACKET CRACKED, MARKED. REMOVED LOCATED DRILLED AND INSTALLED NEW STA 727 LEFT KEEL BEAM SUPPORT BRACKET IN AFT PIT IAW 737-500 SRM 51-40-02, 51-40-05 AND BOEING DWG 69-41460.SDR SWAA2012111909615Floorbeam · corrodedAFT CABIN FLOORBEAM UPPER FLANGE CORRODED BS 986.5 FLOORBEAM LBL 0 TO LBL 8. ACCOMPLISHED FLOORBEAM REPAIR AT BS 986.5 LBL 50- RBL 50 IAW EA 121203 REV IR & EA NO 1-553-21035 REV ON NRC V812466.SDR SWAA2012111609552Skin · crackedSKIN ATTACH FASTENER HOLE CRACKED AT BS 452, 2 FASTENERS ABOVE STR 26R. REPAIRED SKIN IAW EA.SDR SWAA2012111509502Fastener · crackedCRACK INDICATIONS AROUND FORWARD CARGO DOOR OPENING FORWARD AND AFT FRAMES TO SKIN ATTACH FASTENERS, REMOVE FASTENERS FOR NDT CRACK VERIFICATION, ALL FASTENERS MARKED IN BLACK. REMOVED TOTAL OF 11EA. FASTENERS AT FWD CARGO DOOR CUTOUT FRAMES IAW SRM. 8EA FASSDR SWAA2012111209257Floorbeam · corrodedFLOORBEAM CORRODED AT BS 328, BETWEEN RBL 27 AND RBL 34. REPAIRED FLOORBEAM IAW EA.SDR SWAA2012110509095Channel · crackedL1 DOOR THRESHOLD Z-CHANNEL UPPER SURFACE CRACKED AT BS 318. REMOVED AND REPLACED Z-CHANNEL IAW SRM.SDR SWAA2012101508520Skin · crackedSKIN CRACKED AT BS 452, STR 25R. REPAIRED SKIN IAW SRM.SDR SWAA2012101508519Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 380, STR 22L. REPAIRED CLIP IAW DWG AND SRM.SDR SWAA2012101108430Light · inoperativeLEFT EMERGENCY EXIT LIGHT INOP AT BS 727. RELAMPED LIGHT PER M/M.SDR SWAA2012101108429Stringer · crackedSTRINGER CRACKED AT BS 390, STR 13R. REPAIRED STRINGER PER EA.SDR SWAA2012112809967Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE IAW MT #G325-61-06.SDR SWAA2012112809966Seal · tornFORWARD ENTRY DOOR, LOWER FORWARD CORNER OF PRESSURE SEAL IS TORN FORWARD ENTRY DOOR LOWER FORWARD CORNER OF PRESSURE SEAL TORN. REMOVED SEAL IAW AMM 52-09-11. INSTALLED NEW SEAL IAW AMM 52-09-13 REMOVED AND INSTALLED SLIDE IAW MT#325-61-06.SDR SWAA2012111909614Door Frame · corrodedR2 DOOR STA 986.5, FRAME CORRODED AT INTERSECTION OF WL 208 - WL 211 AND CREASE BEAM INNER CHORD. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2012111909613Crease Beam · corrodedR2 DOOR STA 955 - STA 988.5, CREASE BEAM INNER CHORD CORRODED. REMOVED AND REPLACED CREASE BEAM IAW SRM.SDR SWAA2012111909612Fitting · crackedFWD ENTRY DOOR, STA 360, STR 11L, INTERCOSTAL CLIP IS CRACKED. CLIP FWD ENTRY DOOR INTERCOSTAL CLIP AT BS 360 STR 11L. DRILLED NEW IAW SRM 51-40-02 AND INSTALLED ON NRC V812387 FOR HORIZONTAL FLANGE FASTENERS AND SRM.SDR SWAA2012102608877Wedge · delaminatedLEFT WING NR 3 SLAT UPPER AFT INBOARD CORNER DELAMINATED. REPAIRED WEDGE IAW SRM & IAW AMM.SDR SWAA2012102408805Stringer Clip · crackedR1 DOOR STRINGER CLIP CRACKED AT BS 277, STR 15R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012101508521Skin · crackedSKIN CRACKED AT BS 405, STR 16R. REPAIRED SKIN PER EA.SDR SWAA2012112809965Web · crackedLEFT NOSE WHEEL WELL STATION 259, 12" TO 16" FROM TOP OF WHEEL WELL, 3 EACH CRACKED. REPAIR WEB IAW EA.SDR SWAA2012112609746Support Angle · corrodedFWD CARGO COMPARTMENT AFT BULKHEAD LOWER SUPPORT ANGLE CORRODED STA 482B LBL 24-RBL 24. REMOVED AFT BULKHEAD LOWER SUPPORT ANGLE IAW B737 SRM 51-40-02 AND REPLACED WITH NEW ANGLE IAW B737 SRM 51-40-02 AND DRAWING 65C33865.SDR SWAA2012111509396Floor Support · corrodedFWD CARGO COMPARTMENT FLOOR SUPPORT RAIL CORRODED STA 482A+17 LBL 18. REMOVED AND REPLACED TRACK IAW SRM.SDR SWAA2012111509388Door Frame · crackedPASSENGER CABIN, FWD ENTRY DOOR CUTOUT, FWD LOWER LATCH RAMP SURROUND STRUCTURE, CRACKED AT INBD EDGE. REMOVED AND REPLACED CUTOUT IAW SRM.SDR SWAA2012111409335Retainer · crackedPASSENGER CABIN, FWD ENTRY DOOR CUTOUT, FWD LOWER SEAL RETAINER CRACKED (MARKED). REPLACED CRACKED SEAL RETAINER AT FORWARD ENTRY DOOR CUTOUT, FOWARD LOWER SEAL RETAINER IAW SRM 51-40-02 AND IPC 25-21-31-01.SDR SWAA2012110909184Shear Tie · corrodedSHEAR TIE CORRODED AT BS 482, BETWEEN LBL 6 TO RBL 6. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA2012102608876Wedge · delaminatedLEFT WING LEADING EDGE NR 2 SLAT INBOARD UPPER AFT CORNER DELAMINATED. REPAIRED WEDGE IAW SRM.SDR SWAA2012101908683Support Fitting · crackedMLG W/W BULKHEAD SUPPORT CLIP CRACKED AT BS 727, RBL 15. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012102308764Skin · crackedSKIN CRACKED AT BS 927, STR 25R. REPAIRED SKIN IAW SRM.SDR SWAA2012102308763Skin · crackedFUSELAGE SKIN CRACKED AT BS 927+7, STR 25R. REPAIRED SKIN IAW SRM.SDR SWAA2012102308762Skin · crackedFUSELAGE SKIN CRACKED AT BS 927+7, STR 24L. REPAIRED SKIN IAW EA.SDR SWAA2012102308761Skin · crackedFUSELAGE SKIN CRACKED AT BS 927+6, STR 21R. REPAIRED SKIN IAW EA.SDR SWAA2012101908680Skin · crackedSKIN CRACKED AT BS 927+5, STR 21L. REPAIRED SKIN IAW SRM.SDR SWAA2012101908665Skin · crackedSKIN CRACKED AT BS 787+8, STR 18L. REPAIRED SKIN IAW SRM.SDR SWAA2012101808645Skin · crackedSKIN CRACKED AT BS 482B+14, STR 16L. REPAIRED SKIN IAW EA.
Back to Boeing 737-5H4