JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, newest first.
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 jasc_code = '5310' 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 jasc_code = '5310' 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 AALA20004079Strap · corrodedAFW - FUSELAGE STRAP AT STATION 1825 JUST BELOW 53R HAD INTERGRANNULAR CORROSION AT 2 NUT PLATES. REMOVED CORROSION PER REF/01. FABRICATE REPAIR DOUBLER FROM .125 INCH 7075-T6. FABRICATE FILLER AND SHIM FROM 7075-T6 THICKNESS AS REQUIRED. FINISH DOUBLER FISDR AALA20004080Door Frame · corrodedAFW - FOUND LOWER MAIN SILL NR 2 CX DOOR CUTOUT INNER CHORD HAS CORROSION REMOVAL AS SHOWN ON SKETCH. MATERIAL REMAINING IS 002 INCH BEYOND SRM LIMITS. REQUEST ENG APPROVAL TO CONT IN SERVICE. REMOVED CORROSION PER REF/C/. VERIFY CORROSION COMPLETELY REMOVSDR COMA0010394Shear Tie · crackedUPON COMPLIANCE OF 2C INSPECTION 232-01Z THE FUSELAGE SKIN SUPPORT AT FRAME 13A, STRINGER 14R WAS FOUND TO BE CRACKED. THE DAMAGED PART WAS REPAIRED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND AERODESIGN REPORT NR 3653-IR, 11-7-00.SDR COMA0010389Shear Tie · crackedUPON COMPLIANCE OF 2C INSPECTION TASK 221-01Z THE LT FUSELAGE SKIN SUPPORT BRACKET WAS FOUND TO BE CRACKED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR RRXA003649Door Frame · crackedDURING A MAINTENANCE VISIT FOUND A CRACK TO THE LWR FWD CARGO AFT DOOR LWR JAMB AT FS 542, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED REPAIR AND INSTALLED IAW PD 08-53-091.SDR AALA20001932Frame · crackedTUL - FOUND UPPER AFT CORNER OF WINDOW FRAME CRACKED .2 INCH, AT APPROX STATION 1060, LEFT SIDE. STOP DRILLED CRACK, DYE CHECKED TO CONFIRM, VERIFIED MATERIAL AND INSTALLED REPAIR PER AARD 53-10-00-25.L (M)SDR AALA20001922Frame · crackedTUL - FOUND UPPER AFT CORNER OF WINDOW FRAME CRACKED .25 INCH AT APPROX STATION1041 LEFT SIDE. TRIMMED OUT CRACK, DYE CHECKED TO CONFIRM, VERIFIED MATERIAL AND INSTALLED DOUBLER PER AARD 53-10-00-25. (M)SDR USAA001897Beam · crackedCLT - FOUND BEAM CRACKED 3 INCHES, STATION 695 STUB BEAM WEB LBL 62, WL 206. FABRICATED STUB BEAM WEB AND INSTALLED PER SRM 51-10-1. (M)SDR MWEA001133Door Frame · misdrilledRIGHT OVERWING DOOR JAMB HAS 2 FASTENER HOLES ON AFT SIDE OF JAMB THAT ARE SHORT ON EDGE DISTANCE. FABRICATED AND INSTALLED DOOR JAMB REPAIR AND PARTS.SDR ASAA0010160Service difficultyDURING SCHEDULED C-CHECK FOUND STRINGER TIE AT BODY STATION 540, STRINGER 24R CORRODED. REPAIRED PER SRM 51-30-2. PAGE 8.SDR ASAA0010161Structure · corrodedDURING SCHEDULED C-CHECK FOUND BODY STATION 1006, WATERLINE 156, BUTTOCK LINE 0 TO LEFT BUTTOCK LINE 12 CORRODED. REPAIRED PER SRM 51-40-2.SDR UPS00434378Shear Tie · crackedINSPECTION TYPE:C, FWD CARGO SHEAR TIE BETWEEN UPPER MAIN DECK FLOOR STRUCTURE AT BS1000 BBL 33 IS CRACKED. SHEAR TIE REPLACED IAW Q/NOTE 56/2000 PER STANDARD SRM PROCEDURES.SDR UPS00434379Forging · crackedINSPECTION TYPE:C, WINDOW BELT AT BS 660 - 680 LHS WINDOW FORGING CRACKED AT TWO LOCATIONS. WINDOW FORGING REPLACED IAW SRM 31-30-02.SDR ASAA0010157Structure · damagedDURING SCHEDULED C-CHECK, FOUND TWO SHORT EDGE MARGIN HOLES AT STATION 480, STRINGER -4R. REPAIRED PER EA 5310-01878.SDR UPS00234487Door Frame · crackedINSPECTION TYPE:C, AFT CARGO DOOR FWD FRAME BENEATH NR 1 STOP FITTING CRACKED. REPLACED LWR FORWARD FRAME ON AFT CARGO DOOR IAW SRM 51-30-2 AND DRAWING 65-18625.SDR UPS00434347Door Frame · crackedINSPECTION TYPE:C, DOOR 2R AFT FRAME IS CRACKED APPROX 6 INCHES FROM BOTTOM. REPAIR ACCOMPLISHED IAW SRM 52-10-02.SDR UPS00434346Door Frame · crackedINSPECTION TYPE:C, DOOR 2L FWD FRAME BOTTOM LOWER CORNER IS CRACKED. REPAIRS CARRIED OUT IN SHOP IAW SRM 52-30-02.SDR SWAA002240Crease Beam · crackedDURING SCHEDULED SPECIAL VISIT, FOUND CREASE BEAM CRACKED, BS 178, WL 207. REPAIRED CREASE BEAM PER ER 00-1236.SDR UPS00434333Structure · corrodedINSPECTION TYPE:C, EXT FUS WING TO BODY FAIRING SUPPORT STRUCTURE. SUPPORT CLIPS ATTACHED TO BELLY PANEL AT BS 860 CORRODED. CORROSION REMOVED AND REPROTECTED IAW SRM 51-10-01 AND 51-10-02.SDR PCAA0011071Structure · crackedMDT- DURING A FLEET INSPECTION, THE REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME NR 4 STRINGER NR 4 PORT SIDE. CRACK WAS REPAIRED PER DEHAVILLAND REPAIR DRAWING RD8-55-199. AIRCRAFT WAS RETURNED TO SERVICE.SDR UPS00434295Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 540 - 560 LT. CORROSION REMOVED IAW SRM 53-10-01 FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434294Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 380 - 400. WINDOW FORGING REMOVED, CORROSION REMOVED FROM SKIN DOUBLER AND STR 20 AND 22 IAW SRM 51-10-01. CORROSION REMOVED FROM WINDOW FORGING. STRINGER 22 REPAIRED IAW QUERY NOTE 16/SDR UPS00434293Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 360 - 380 LT. WINDOW FORGING REMOVED, CORROSION REMOVED FROM SKIN DOUBLER AND STR 20 AND 22 IAW 51-10-01. CORROSION REMOVED FROM WINDOW FORGING IAW 56-20-01. STRINGER 22 REPAIRED IAW QUSDR UPS00434292Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 280 - 300 LT. WINDOW FORGING REMOVED, CORROSION REMOVED FROM SKIN DOUBLER IAW SRM 53-10-01. CORROSION REMOVED FROM WINDOW FORGING IAW SRM 53-10-01. FORGING INSTALLED.SDR UPS00434291Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER WINDOW FORGINGS AT BS 220 - 240 LT. WINDOW REMOVED, CORROSION REMOVED FROM DOUBLER IAW SRM 53-10-01. CORROSION REMOVED FROM WINDOW FORGING IAW 53-10-01. FORGING INSTALLED.SDR AALA20004076Door Frame · corrodedAFW - CX COMP DOOR CUT OUT LOWER MAIN AFT SILL OUTER CHORD HAS CORROSION. REMOVED CORROSION, VERIFY CORROSION COMPLETELY REMOVED, APPLY ALODINE AND 2 COATS PRIMER TO ALL BAKE SURFACES, APPLY CORROSION INHIBITING COMPOUND TO THE BLENDED AREA. (M)SDR AALA20001928Beam · corrodedTUL - FOUND CORROSION, 1 INCH BY 6 INCHES, ON AFT CARGO DOOR JAMB BEAM STATION 1155 TO STATION 1212. INSTALLED DOUBLER REPAIRS PER AARD 53-10-00 AND ESO 80559 11/7/2000. (M)SDR ASAA0010154Plate · crackedDURING SCHEDULED C-CHECK, AFT AND FWD CARGO DOOR SILL PLATE HAS CRACKS IN RADIUS. REPAIRED PER EA 5330-01470.SDR ASAA0010155Threshold · crackedDURING SCHEDULED C-CHECK, AFT CARGO DOOR CENTER THRESHOLD HAS NUMEROUS CRACKS AND FORWARD CARGO DOOR CENTER THRESHOLD SCUFF PLATES HAS NUMEROUS CRACKS ON RADIOUS AND ON THE EDGES.REPAIRED PER EA 5330-01470.SDR AWXA0000831Shear Tie · crackedC-CHECK, AFT CARGO BAY SHEAR TIE CRACKED AT STA 727A, STR 18L. REMOVED AND FABRICATED SHEAR TIE IAW 737 SRM 53-10-1, TREATED PARTS AND INSTALLED REPAIR PARTS IAW 737 SRM 51-30-2.SDR AWXA0000830Tee Chord · crackedC-CHECK, LOWER T CHORD CRACKED AT FS 727, BL 0. STOP DRILLED CRACK AND INSTALLED REPAIR IAW AWA ER 15-5715-00284-DL1.SDR AWXA0000829Skin · corrodedC-CHECK, CORROSION FOUND AFTER REMOVAL OF SEALER ON THE SKIN AT STA 990, L25L, AFT CARGO COMP. REMOVED DAMAGE IAW 737 SRM 53-30-3 FIG 1, FAB''D DOUBLER IAW 737 SRM 53-50-3 FIG 18, INSTALLED DOUBLER IAW 737 SRM 51-30-2.SDR AWXA0000827Skin · gougedC-CHECK, R-1 DOOR UPPER HINGE CUTOUT, LOWER CORNER HAS GOUGE OUT OF LIMITS. REPAIRED R-1 DOOR HINGE CUTOUT IAW AWA EO 52-00-02 AND EO 52-00-03.SDR AWXA0000818Doubler · crackedC-CHECK, EXT POWER RECEPTACLE DOOR FRAME DOUBLER CRACKED. REMOVED DAMAGED AREA IAW ER 15-5311-00274-JS2 SHEET 2, TREATED IAW 737 SRM 51-00-00 FIG 23, FAB''D AND INSTALLED REPAIR FILLER IAW ER 15-5311-00274-JS2.SDR AWXA0000816Shear Tie · crackedC-CHECK, AFT CARGO BAY SHEAR TIE CRACKED AT STA 787, BS 24R. REMOVED SHEAR TIE IAW 737 SRM 51-30-2, FAB''D NEW SHEAR TIE IAW 737 SRM 53-00-3, INSTALLED SHEAR TIE IAW 737 SRM 51-30-2.SDR QXEA0002997Fastener · misinstalledPDX- EXCESSIVE GAPS UNDER HI-LOCK COLLARS AT UPPER END OF NR 3 LEFT HAND WINDOW POST.REPAIRED IAW FOKKER SRM 51-30-02.SDR AWXA0000814Frame · crackedC-CHECK, CAPTIANS WINDSHIELD FRAME HAS .5 INCH CRACK IN UPPER OUTBOARD CORNER. ROUTED OUT CRACKED AREA IAW 737 SRM 56-20-02 FIG 101, FABBED AND INSTALLED CONICAL WASHERS AND DOUBLERS IAW 737 SRM 53-10-01.SDR SWAA002187Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 906, LBL 69, WL 230. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR DLM90002135Frame · mislocatedWHILE ACCOMPLISHING A MODIFICATION TO THE VENTRAL STAIRWAY SHROUD FRAME AT FS 1418 PER DAC S/B MD90-27-026 AS MANDATED PER AD 99-21-32, AN EXISTING BRACE WAS FOUND LOCATED IN THE MOD AREA WHICH WAS NOT SHOWN IN THE S/B OR DESIGN DRAWINGS. THE EXISTING BRACE WSDR SWAA002170Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD SVC DOOR STUB FRAME CRACKED AT STR 17, FWD SIDE, BS 294. REMOVED AND REPLACED STUB FRAME PER SRM.SDR QXEA0003004Structure · crackedPDX- LEFT HAND NOSE LANDING GEAR BAY WALL HAS APPROXIMATELY 3/8 INCH LONG CRACK THROUGH A RIVET HOLE AT THE TOP OF THE WALL. REPAIRED IAW HORIZON AIR EA 4-53-1391.SDR AT0000501Door Frame · crackedDURING A SCHEDULED INSPECTION, FOUND CRACK IN FORWARD CARGO COMPARTMENT DOOR JAMB. CUT OUT CRACKED SECTION AND INSTALLED REPAIR IAW EO 09-5310-29-E1482.SDR AT0000498Door Frame · crackedDURING A SCHEDULED INSPECTION, FOUND FORWARD CARGO COMPARTMENT DOOR JAMB CRACKED. CUT OUT CRACKED SECTION AND INSTALLED REPAIR IAW EO 09-5310-29-E1482.SDR P2EA00329Door Frame · crackedSJO - DURING Q-CHECK, FOUND THE FORWARD CARGO DOOR FRAME LOWER FORWARD CORNER WITH CRACK .75 INCH BY .002 INCH. IDENTIFIED AS REPORTABLE ON 11-07-00. REPAIRED THE FORWARD CARGO DOOR FRAME LOWER FORWARD CORNER WITH CRACK IAW BOEING SB 737-52-1090 REV 1 DATED SDR USAA001818Beam · crackedCLT - FOUND LONGITUDINAL BEAM 2 INCH CRACK, BS 663, OBL. INSTALLED DOUBLER, NEW WEB PER TR 57-10-04 AND EA 68369. (M)SDR SWAA002146Crease Beam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 360 - 380. REPLACED WEB PER SRM.SDR USAA002112Beam · corrodedPIT - FOUND BEAM CORRODED .008 INCH DEEP, BETWEEN BEAM 328-344 UNDER PANEL 8. CORROSION LEVEL 1, TASK NR C53-107-02. REMOVED AND REPLACED INTERCOSTAL PER BOEING DWG 65-45834. (M)SDR P2EA00333Door Frame · crackedSJO - DURING Q-CHECK, FO UND THE L-1 DOOR JAMB AFT LOWER CORNER SKIN WITH CRACK 2.5 INCH BY .002 INCH. IDENTIFIED AS REPORTABLE ON 11-07-2000. REPAIRED THE L-1 DOOR JAMB AFT LOWER CORNER SKIN IAW BOEING SB 737-53-1083 SECT III PART IV REV 3 DATED DECEMBER 7,SDR SWAA002138Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON CREASE BEAM WEB UPPER SURFACE AT BS 953, RBL 56, WL 208. REMOVED AND REPLACED DAMAGED WEB PER DWG 65-45855 AND SWA T1-A51-002.SDR CALA0001648Frame · corrodedINSPECTION FOUND CABIN WINDOW FRAME 41L CORRODED ON FORWARD AND AFT FLANGES AT STA 984 AND 1003. A REPAIR AND WINDOW DOUBLER WAS INSTALLED IAW EA 9-5330-2-A0794, ECRA 5330-02998, AND DOUGLAS DRAWING SRO9530053.
Back to JASC 5310