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 01FDEA00727Frame · dentedN 852 DENT IN UPR FLANGE OF FRAME BS 970, WL 150, LBL 30. ** S/D ** COMINGSDR 01FDEA00712Shear Tie · corrodedN 1008 CORROSION ON SHEAR TIE AT BS 720C BL0, WL 148 R&R SHEAR TIE PER IAW SRM 51-20-1.SDR 01FDEA00707Shear Tie · crackedN 992 CRACKED SHEAR TIE BS 720, LBL 4, WL 148. ** S/D ** R&R SHEAR TIE.SDR 01FDEA00706Stringer Clip · crackedN 1017 FUSELAGE STR CLIP AT STR 232 IS CRACKED AT BS 580. R&R CLIP.SDR 01FDEA00703Frame · dentedN 852 DENT IN UPPER FLANGE OF FRAME AT BS 970, WL 150, LBL 30. ** S/D ** COMINGSDR 01FDEA00688Shear Tie · corrodedN 671 CORROSION EMANATING UNDER SHEAR TIE AT BS 1148 BETWEEN STR 27 AND 28L. ** S/D ** COMINGSDR SWAA012343Tie · crackedDURING SCHEDULED D CHECK AT DALFORT, FOUND SHEAR TIE CRACKED AT BS 967, STR 7L. REPAIRED SHEAR TIE PER SRM.SDR SWAA012340Frame · crackedDURING SCHEDULED D CHECK AT DALFORT, FOUND FUSELAGE FRAME CRACKED ( 2 EA ) AT BS 420, BETWEEN STR 15R & STR 17R. REPAIRED FRAME PER SRM.SDR SWAA012328Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT FWD CARGO DOOR LOWER CUT OUT AT BS 452, RBL 41. R&R FRAME SECTION PER SRM.SDR SWAA012290Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED AT BS 178, LWR RH ANTENNA MOUNT. REPAIRED WEB PER SRM.SDR SWAA012285Angle · crackedDURING SCHEDULED D CHECK AT DALFORT, FOUND 'Z' FRAME ANGLES CRACKED AT STR 8L, BS 400, BS 787 & BS 907. REPAIRED ANGLES PER SRM.SDR 01FDEA00699Frame · dentedN 885 DENTS IN FRAME FLANGE AT BS 600 BETWEEN STR 23L AND 25L. ** S/D ** COMINGSDR AWXA0002115Skin · dentedD: Lwr fuselage at STA 1510 STR 27L has dent 1" L x .5w x .095DC: removed intercostal cut out damage NDT no cracks noted INSTLD repair parts -fillers doublers IAW SRM 53-00-01 pg 206 and NDT SRM 51-00-19 and reinstalled intercostal SRM 51-40-02SDR SWAA012267Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIES CORRODED AT BS 827 BETWEEN STR 27R & STR 27L. REPAIRED SHEAR TIES PER SRM.SDR EIA2001243Doubler · crackedMZJ - FORWARD PASSENGER DOOR UPPER FORWARD CORNER HAS A CRACK IN INNER MOST DOUBLER. REPAIRED PER ECRA 915-53-058-2 BY REPLACEMENT OF DOUBLER AFTER TRIMMING OUT DAMAGE. (M)SDR UPS01236679Stringer · crackedINSPECTION TYPE:C ON FURTHER INSPECTION S6L AT BS 400 FOUND TO BE CRACKED. DAMAGED STRINGER REPAIRED IAW SRM 53-10-3SDR UPS01236678Stringer · crackedINSPECTION TYPE:C ON FURTHER INSPECTION S3R FOUND CRACKED AT BS 400 REPAIRED PER SRM.SDR UPS01236677Stringer · crackedINSPECTION TYPE:C ON FURTHER INSPECTION S9R FOUND CRACKED AT BS 400 STRINGER REPAIRED IAW SRM.SDR UPS01236676Stringer · crackedINSPECTION TYPE:C ON FURTHER INSP FOR ACCESS S15R AT BS 400 FOUND TO BE CRACKED REPAIRED IAW SRMSDR UPS01236675Stringer · crackedINSPECTION TYPE:C ON FURTHER INSPECTION FOR ACCESS S16R FOUND CRACKED AT BS 400 REPAIRED IAW SRM.SDR UPS01236661Stringer · crackedINSPECTION TYPE:C ON FURTHER INSPECTION FOR ACCESS S15L FOUND CRACKED AT BS 400 REPAIRED IAW SRMSDR UPS01236660Stringer · crackedINSPECTION TYPE:C ON FURTHER INSPECTION FOR ACCESS, S16L FOUND CRACKED AT BS 400 REPAIRED IAW SRMSDR UPS01236657Stringer · crackedINSPECTION TYPE:C ON FURTHER INSPECTION STRINGER S6R FOUND CRACKED AT BS 400 REPAIRED PER SRMSDR DHL2001804532Door Frame · crackedAFT PAX DOOR HAS 1 INCH CRACK AT AFT UPPER CORNER STA 1660. CUT DAMAGED AREA PER SRM 53-2-0 PG 127-128. FABRICATED FILLER AND DOUBLER PER SRM 53-2-0 PG 127/128. CLEANED AND TREATED, FABRICATED PARTS PER SRM 51-1-8B. INSTALLED FILLER AND DOUBLER AND TRIPLERSDR AWXA0002119Frame · crackedD: Frame bent on upper flange at end of previous repair FS 1400 LBL 40 Aft pit.C: Found to be cracked, removed damaged area of flange fabricated repair parts and installed per 757 SRM 51-40-02 Pgs 3-4SDR AWXA0002102Skin · crackedD: 1/4" crack at right aft service door lower hinge cut out BS 948C: removed damaged and installed repair doubler IAW B737 SRM 53-60-01 figure 207 sheet 1-8SDR UPS01236666Frame · crackedINSPECTION TYPE:C CRACK BS 930 R/H FLANGE I/B LOWER CORNER RADIUS REPAIRED PER SRM ADDENDUM B727-5310-2611BSDR 2001UALA01669Crease Beam · corrodedCABIN STA 616-639 S17R CREASE BEAM WEB CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW WEB.SDR SWAA012269Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM WEB CRACKED AT BS 180, RBL 17.1 & WL 227. R&R VERTICAL BEAM WEB PER SRM.SDR 01FDEA00734Stringer · corrodedN 549 STR 29L CORRODED FROM BS 950E-950F. R&R STRINGER PER SRM 51-40-4, 51-30-2.SDR 0103869612Frame · crackedDuring Hck in ATL the fuselage frame at sta 756 were inspected per EO 5311-01157, A 1.75 inch crack was found in the frame and a 2.0 crack was found in the right frame. The right frame was removed and replaced per EO 5311-01157 7075-t6 aluminum. the left frameSDR SWAA012253Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIES CORRODED BETWEEN STR 26L & 26R AT BS 767, BS 787 & BS 807. REPAIRED SHEAR TIES PER SRM.SDR SWAA012235Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND BEADED WEB CRACKED AT BS 663, LBL 32. REPAIRED WEB PER SWA T1-353-046.SDR 01FDEA00675Stringer · corrodedN 548 STR 29L CORRODED AT BS 960. R&R STR PER IAW FEDEX SRM 51-40-4 & 51-30-2.SDR AALA20011638Door Frame · corrodedTUL - FOUND MID CARGO DOOR CUTOUT LOWER BEAM CORRODED STATION 636-693. REMOVED CORROSION, INSTALLED 2 ANGLE DOUBLER PER AARD 53-10-00-3 FIG 2 PAGE 18. (M)SDR 2001UALA01649Shear Tie · corrodedBS 1307-1310 STR 37R SPLICE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR SWAA012236Frame · crackedDURING SCHEDULED D CHECK, FOUND FWD CARGO DOOR CUTOUT FRAME CRACKED AT BS 492, RBL 36 & WL 159. REPAIRED FRAME PER BFG ER.SDR 2001UALA01648Structure · corrodedBS 434 STR 37R-38R CORRODED.SDR USAA011038Tie Clip · gougedCLT - FOUND TIE CLIP GOUGED .5 INCH, BS 727A AT 518R. INSTALLED NEW TIE CLIP PER SRM 51-10-101. (M)SDR USAA011036Support Fitting · crackedCLT - FOUND SUPPORT FITTING CRACKED 5 INCHES, BS 727 BL 0 WL 203. REMOVED AND REPLACED SUPPORT FITTING PER EO 5394G176. (M)SDR USAA011035Frame · crackedCLT - FOUND FRAME CRACKED .5 INCH, BS 767 AT S13L. REMOVED DAMAGE, INSTALL CHANNEL AND FILLER PER SRM 53-10-4. (M)SDR USAA011025Tie Clip · crackedCLT - FOUND TIE CLIP CRACKED .250 INCH, BS 706 STRINGER 10L. REMOVED AND REPLACED TIE CLIP PER PCI JOB CARD J253-10-10R. (M)SDR RRXA11458Angle · corrodedDURING A MAINTENANCE VISIT FOUND A/C BAY R/H SIDE FRAME HAS EXFOLIATION BETWEEN L26 AND L25 STA 35. *** CORRECTIVE ACTION *** REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLE PER REF DHSK 873-216-15 AND SRM 51-1-20D.SDR RRXA11456Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CABIN SEAT TRACK IS CORRODED AT FS 760 RBL48. *** CORRECTIUVE ACTION *** SEAT TRACK FOUND OUT OF LIMITS PER DC8 SRM 53-2-3 FIG 12. REMOVED DAMAGED SECTION OF SEAT TRACK PER DC8 SRM 51-30-. FABRICATED SEAT TRACK AND SPLINE ANSDR DL72S011300Door Frame · crackedFUSELAGE C1 DOOR OPENING FWD FRAME AT FS 560 CRACKED. INSPECTION OF THE C1 DOOR CUTOUT SURROUND FRAME WEBS PER AD 99-23-13 REVEALED A TYPICAL CRACK IN THE FWD FRAME WEB BELOW THE LIGHT SWITCH WEB CUTOUT ALONG THE OUTER CHORD ATTACHMENT LOCATIONS.SDR 0104039858Fitting · corrodedDuring SUV corrosion was found on the left wing to the body fitting which required the part to be replaced. Material 7075-T651 Repaired per EA 98-186041.SDR USAA010977Frame · dentedCLT - FOUND FRAME DENTED APPROX .5 INCH WIDE BY .125 INCH DEEP, STATION 540 AT S24L. REPAIRED DOUBLER PER EA 85029. (M)SDR SWAA012358Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CRACKED AT BS 277, STR 10R. REPAIRED STR PER SRM.SDR RRXA11453Shear Tie · corrodedDURING A MAINTENANCE VISIT FOUND AFT PIT AT FS1140 BETWEEN LONGERON 35R AND 36 HAS SHEER TIE BLOWN OUT WITH CORROSION. *** CORRECTIVE ACTION *** CUT OUT DAMAGED SECTION OF SHEAR TIE IAW DC8 SRM 53-2-0 FIG 2A. FABRICATED REPLACEMENT SHEAR TIE AND SPLICE AND ISDR 01FDEA00660Shear Tie · corrodedCORROSION (C53-111-02, 2) FWD CARGO BAY BS 660, BL 0, WL 147 SHEAR TIE. *S/D* REMOVED AND REPLACED SHEAR TIE PER SRM 53-10-4 FIG 15.
Back to JASC 5310