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 ERKR200100133Shear Tie · crackedCRACKED SHEAR TIE AT LIGHTENING HOLES BETWEEN STA 340-STA 360, WL.199.80. THE CRACK WAS FOUND AT A LIGHTENING HOLE IN SHEAR TIE LOCATED BETWEEN STA 340 AND STA 360, WL 199.80. REMOVED AND REPLACED THE DAMAGED SHEAR TIE PER ECRA 478-53-125-2.SDR 01FDEA00466Door Frame · corrodedCORROSION (C53-111-02, 2) ON NR 3 CARGO DOORWAY AFT FRAME BS 1136 RBL 30 WL 157. *S/D* REMOVED AND REPLACED NR 3 CARGO DOORWAY AFT FRAME PER EA 7-5310-57293.SDR 01FDEA00465Shear Tie · corrodedCORROSION ON SHEAR TIE AT BS 950F LBL 9 WL 138.5. *S/D* REMOVED, REPLACED AND FAB PER IAW FEDEX SRM 53-10-1, 51-10-2, 53-10-4.SDR MWEA010999Skin · crackedFUSELAGE SKIN CRACKED IN LOWER AFT CORNER OF FORWARD AIRSTAIR DOOR JAMB. -- REMOVED DAMAGE AND INSTALLED DOUBLER AND FILLER.SDR 01FDEA00457Shear Tie · corrodedEXTERIOR SKIN BULGED BS 500 BETWEEN STR 25 & 26 RT. *S/D* REMOVED AND REPLACED CORRODED SHEAR TIE PER IAW FEDEX SRM 51-10-6, 51-30-2, FEDEX MM 51-20-191, 51-20-21.SDR AWXA0001876Stringer · crackedD: Stringer #1 LT. at BS 727A cracked C: Removed damaged section of Stringer #1 LT. BS 727A- Formed and Installed Stringer repair cables. Installed Stringer filler at Stringer 1 LT. BS 727A All IAW B737-300 SRM 53-00-03 Fig 203 PG214-216SDR 01FDEA00454Stringer · crackedNR 838 WHILE WORKING N0301 FND CRACK EMANATING FROM OPEN HOLE AT BS 460, STR 3 L/H. ** S/D ** R&R STRING PER FEDEX SRM 53-10-3, 51-20-151, 53-10-3.SDR HN6R0000243Crease Beam · corrodedAT BS 380 TO 390 RBL 65, WL 207, THERE IS CORROSION ON THE CREASE BEAM. CAUSE UNKNOWN. REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED.SDR MWEA010993Frame · damagedEXTERIOR FUSELAGE HAS LIGHTENING STRIKES AT WINDOW 9L. -- BLENDED OUT DAMAGED AREAS, LOCATED AND DRILLED DOUBLER, INSTALLED REPAIR AT WINDOW.SDR MWEA010992Seat Track · corroded#3 SEAT TRACK CORRODED AT FORWARD END APPROXIMATELY STATION 200. -- REMOVED CORROSION, REMOVED DAMAGED SECTION OF SEAT TRACK, LOCATED AND DRILLED AND INSTALLED NEW SEAT TRACK.SDR MWEA010991Frame · gougedWINDOW 9L INNER WINDOW FRAME HAS SEVERAL MODERATE GOUGES/TOOL MARKS IN RADIUS OF FRAME BOTH FORWARD AND AFT SIDES. -- BLENDED TOOL MARKS, LOCATED AND DRILLED NEW INNER WINDOW FRAME, INSTALLED WINDOW RETAINER.SDR MWEA010990Bracket · elongatedATTACH BRACKET HOLES ELONGATED FORWARD AND AFT, FORWARD CARGO DOOR HINGES ATTACH TO FUSELAGE. -- FABRICATED AND INSTALLED DOUBLERS.SDR MWEA010989Skin · crackedEXTERIOR SKIN ABOVE FORWARD PAX DOOR HOLD OPEN HOOK CUT OUT HAS TWO SMALL CRACKS. -- TRIMMED, LOCATED AND DRILLED PLATE AND DOUBLERS, INTSTALLED DOUBLERS, PAN, PIN.SDR RRXA11353Skin · gougedDURING A MAINTENANCE VISIT FOUND EMPINNAGE SKIN L/H SIDE OF #60 PANEL HAS A GOUGE WITH FILLER IN PORTIONS OF IT. FROM LONG 26L TO 36 STA 1781 TO 1793. *** CORRECTIVE ACTION *** REMOVED FILLER AND FASTENER PER SRM 51-1-21, CUT OUT DAMAGE PER SRM 53-2-0 FIG 1DSDR RRXA11305Frame · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FRAME AT STA.1100 AND L33R, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 51-1-20A&D, 51-1SDR EISA20010101Crease Beam · crackedLT FUSELAGE CREASE BEAM WEB IS CRACKED AT BS 1090 FLOOR LEVEL. CUT OUT CRACKED AREA. FABRICATED AND INSTALLED WEB AND FILLER ANGLE. REPAIRS IAW B727 SRM 51-30-2, 51-10-1, 51-40-2, 51-10-2 AND MM 51-22-11.SDR SWAA011744Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 400 TO BS 420, RBL 68 & WL 208. REPAIRED WEB PER SRM.SDR 01FDEA00489Seat Track · crackedSNRM N 201 MAIN DECK CARGO COMPT SEAT TRACK AT BS 635 RH X=8.5 FND CRACKED APPROX 4" LONG. ** S/D ** R&R SEAT TRACK PER SRM 53-70-00 VOL I.SDR 01FDEA00487Seat Track · crackedSNRM N 202 MAIN DECK CARGO COMPT SEAT TRACK AT BS 635, RH X=8.5 FND CRACKED APPROX 4" LONG. R&R SEAT TRACK PER SRM 53-70-00, VOL I.SDR RRXA11300Doubler · crackedDURING A MAINTENANCE VISIT FOUND CRACK DAMAGE TO INTERNAL DOUBLER AT STA.35-70 AND L34L-L34R, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 51-SDR USAA010804Frame · crackedPIT - FOUND FRAME CRACKED 2 INCHES, FS 663.75 AT ST-1C1-26-3R-2R AND 3L. REPAIRED PER EA 71500 AND SRM 53-00-07. (M)SDR RRXA11298Seat Track · wornDURING A MAINTENANCE VISIT FOUND WORN DAMAGE TO SEAT TRACK AT STA.1480 AND BL.0, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 53-2-3 FIG8A.SDR RRXA11296Frame · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FRAME AT STA.1000 AND L36, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED REPAIR AND INSTALLED IAW DC-8 SRM 51-1-20D, 51-1-SDR RRXA11295Seat Track · wornDURING A MAINTENANCE VISIT FOUND WORN DAMAGE TO SEAT TRACK AT STA.513 AND RBL25, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 53-2-3 FIG8A.SDR UPS01236178Fitting · crackedINSPECTION TYPE:C TIAL SKID BAY L/H UPPER TIE LINK AFT FITTING, EVIDENCE OF CRACK ON V ERTICAL FLANGE BETWEEN FASTENERS. FITTING REPLACED.SDR DL75A011001Bulkhead · gougedFUSELAGE / SKIN & BULKHEAD / FS 1700-1780 / STRG. 26L-26R : GROUND DAMAGE REPAIR THE FUSELAGE SKIN FWD AND AFT OF THE FS 1720 BULKHEAD WAS GOUGED AND PUNCTURED FROM A TAIL STRIKE DURING LANDING. THEBULKHEAD WEB WAS SLISDR DL73K010980Door Frame · crackedTHE UPPER SILL BEAM OF THE C2 DOOR CUTOUT SURROUND STRUCTURE WAS FOUND WITH A CRACK IN THE BEAM WEB AT FS 818.SDR AWXA0001869Tee Chord · crackedAFT SIDE OF BS 178 BULKHEAD BELOW FLOOR TEE CHORD CRACKED LBL 5.7, WL 185, I/B SIDE. REPAIRED TEE CHORD AFT SIDE OF BULKHEAD BS 178 LBL 5.7 WL 185 IAW B737-300 SRM PAGES 221-240.SDR MWEA010985Skin · gougedGOUGE AT STATION 813 BETWEEN LONGERONS 25 AND 26 RIGHT. -- BLENDED GOUGE, CUT OUT SKIN, REMOVED LOWER FLANGE OF SHEAR TIES, FABRICATED REPAIR, INSTALLED REPAIR DOUBLER AND SKIN REPAIR, FABRICATED SHEAR TIE REPAIR ANGLES, INSTALLED SHEAR TIES.SDR MWEA010984Floorboard · damagedREMOVED CABIN FLOORBOARD B10 TO FACILITATE OTHER MAINTENANCE. -- FABRICATED NEW SKIN AND HAT SECTIONS, INSTALLED INSULATION AND SHIM MATERIAL.SDR MWEA010983Frame · damagedUPPER FUSELAGE FRAME STATION 737 HAS THREE HOLES THAT DO NOT HAVE (2D) SPACING BETWEEN LONGERONS 5 AND 6 LEFT. -- PLUGGED HOLES, FABRICATED, LOCATED AND DRILLED REPAIR ANGLES, INSTALLED REPAIR.SDR MWEA010979Intercostal · damagedFORWARD ENTRY INTERCOSTAL HAS FIVE OPEN FASTENER HOLES AND INNER LEG HAS MATERIAL TRIMMED OUT STATION 228 ABOVE LONGERON 11 LEFT. -- FABRICATED AND INSTALLED REPAIR ANGLES.SDR MWEA010978Frame · damagedUPPER FUSELAGE FRAME STATION 889 HAS THREE HOLES THAT DO NOT HAVE (2D) SPACING BETWEEN LONGERON 5 AND 6 LEFT. -- FABRICATED, LOCATED AND DRILLED REPAIR ANGLE AND FILLER, INSTALLED REPAIR ANGLE DOUBLER.SDR MWEA010977Frame · damagedUPPER FUSELAGE FRAME 870 HAS TWO HOLES THAT DO NOT HAVE (2D) SPACING BETWEEN LONGERON 5 AND 6 RIGHT. -- PLUGGED HOLES, FABRICATED A REPAIR ANGLE, INSTALLED REPAIR ANGLE.SDR MWEA010976Frame · damagedUPPER FUSELAGE STATION 870 HAS TWO HOLES THAT DO NOT HAVE (2D) SPACING BETWEEN LONGERON 5 AND 6 LEFT. -- PLUGGED HOLES, FABRICATED A REPAIR ANGLE, INSTALLED REPAIR ANGLE.SDR MWEA010975Frame · damagedUPPER FUSELAGE FRAME 813 HAS THREE HOLES THAT DO NOT HAVE (2D) SPACING BETWEEN LONGERON 5 AND 6 LEFT. -- PLUGGED HOLES IN FRAME, FABRICATED REPAIR PARTS, INSTALLED REPAIR.SDR MWEA010974Frame · misdrilledFRAME STATION 503 IN BETWEEN LONGERON 5 AND 6 RIGHT SIDE HAS ONE MISDRILLED HOLE AND THREE OPEN DRILLED HOLES, CHECK EDGE DISTANCE. -- FABRICATED, LOCATED AND DRILLED NEW ANGLE, INSTALLED REPAIR.SDR MWEA010973Frame · damagedUPPER FUSELAGE FRAME STATION 832 HAS TWO HOLES THAT DO NOT HAVE 2D SPACING BETWEEN LONGERON 5 AND 6 RIGHT. -- PLUGGED HOLES, FABRICATED A REPAIR ANGLE, INSTALLED REPAIR.SDR MWEA010972Frame · damagedUPPER FUSELAGE FRAME STATION 794 HAS TWO HOLES THAT DO NOT HAVE (2 D) SPACING BETWEEN LONGERON 5 AND 6 LEFT. -- FABRICATED REPAIR DOUBLER AND SHIMS, INSTALLED REPAIR.SDR MWEA010971Frame · damagedUPPER FUSELAGE FRAME STATION 756 HAS TWO HOLES THAT DO NOT HAVE (2 D) SPACING BETWEEN LONGERON 5 AND 6 RIGHT. -- FABRICATED, LOCATED AND DRILLED REPAIR, INSTALLED REPAIR ANGLE.SDR MWEA010970Frame · damagedFRAME STATION 598 IN BETWEEN LONGERON 5 AND 6 LEFT SIDE HAS SEVERAL OPEN DRILL HOLES ONE IS IN THE RADIUS. -- PLUGGED HOLES AND FABRICATED REPAIR DOUBLER, INSTALLED ANGLE REPAIR.SDR MWEA010969Frame · damagedFRAME STATION 598 IN BETWEEN LONGERON 5 AND 6 RIGHT SIDE HAS SEVERAL OPEN DRILL HOLES ONE IS FIGURE EIGHT. -- PLUGGED HOLES, FABRICATED REPAIR DOUBLER, INSTALLED ANGLE REPAIR.SDR MWEA010968Frame · damagedFRAME STATION 579 IN BETWEEN LONGERON 5 AND 6 RIGHT SIDE HAS SEVERAL OPEN DRILL HOLES. -- FABRICATED REPAIR DOUBLER, INSTALLED REPAIR.SDR MWEA010967Frame · damagedFRAME STATION 579 IN BETWEEN LONGERON 4 AND 5 RIGHT SIDE TWO OPEN DRILL HOLES CHECK EDGE DISTANCE. -- FABRICATED REPAIR DOUBLER, INSTALLED REPAIR.SDR MWEA010966Frame · damagedUPPER FUSELAGE FRAME STATION 718 HAS TWO FASTENER HOLES THAT DO NOT HAVE (2 D) SPACING INBOARD OF LONGERON 6 RIGHT. -- PLUGGED HOLES, FABRICATED AND INSTALLED REPAIR ANGLE.SDR MWEA010965Frame · damagedUPPER FUSELAGE FRAME STATION 718 HAS TWO FASTENER HOLES THAT DO NOT HAVE (2 D) SPACING INBOARD OF LONGERON 5 AND 6 LEFT. -- PLUGGED HOLES, FABRICATED REPAIR ANGLE, INSTALLED REPAIR ANGLE.SDR MWEA010962Frame · damagedUPPER FUSELAGE FRAME STATION 658 HAS HOLES THAT DO NOT HAVE (2 D) SPACING LONGERON 5 TO 6 RIGHT. -- PLUGGED HOLES, FABRICATED REPAIR ANGLE, INSTALLED REPAIR.SDR MWEA010961Frame · damagedUPPER FUSELAGE FRAME STATION 658 HAS THREE HOLES THAT DO NOT HAVE (2 D) SPACING BETWEEN LONGERON 5 TO 6 LEFT. -- PLUGGED HOLES, FABRICATED, LOCATED AND DRILLED ANGLE DOUBLER, INSTALLED REPAIR.SDR MWEA010960Frame · damagedFUSELAGE FRAME STATION 446 HAS MISDRILLED/OPEN FASTENER HOLES AT LONGERON 6 LEFT. -- FABRICATED REPAIR DOUBLER, PLUGGED HOLES, INSTALLED REPAIR.SDR MWEA010959Frame · misdrilledFUSELAGE FRAME STATION 427 HAS MISDRILLED/OPEN FASTENER HOLES AT LONGERON 6 LEFT. -- FABRICATED REPAIR DOUBLER, INSTALLED REPAIR.
Back to JASC 5310