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 01FDEA00840Shear Tie · corrodedCORRODED SHEAR TIE BS 1110, RBL 10 - 14. REMOVED AND REPLACED SHEAR TIE PER SRM 51-20-1, 51-10-2 & 51-30-2.SDR SWAA012586Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, WL 209 & RBL 55. REPAIRED FRAME PER BFG ER 01-0838.SDR SWAA012571Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, BETWEEN STR 8R & 9R. REPAIRED FRAME PER BFG ER 01-0788SDR SWAA012570Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED ( 2 EA ) AT BS 767 & BS 807, BETWEEN STR 8L & 9L. REPAIRED FRAMES PER BFG ER 01-0788.SDR SWAA012569Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 27L. R&R STR CLIP PER SRM.SDR SWAA012566Web · crackedDURING SCHEDULED D CHECK, FOUND VERTICAL BEAM WEBS CRACKED ( 2 EA ) AT BS 178, WL 175 & WL 177, RBL 17.1. R&R WEBS PER BFG ER 01-0781.SDR 01FDEA00837Frame · dentedN 450 AFT CARGO FRAME DENT AT BS 970, LBL 33. ** S/D ** COMINGSDR SWAA012554Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL WEBS CRACKED ( 4 EA ) AT BS 178, RBL 17.1 & LBL 17.1, WL 176 TO WL 230. REPAIRED WEBS PER SRM.SDR MWEA011272Web · chafedFOUND MINOR CHAFE ON WEB IN NOSE WELL. -- BLENDED CHAFE AND REPAIRED WITH DOUBLER REPAIR.SDR MWEA011263Longeron · crackedE&E COMPARTMENT, LONGERON 23 LEFT IS CRACKED AT FRAME STATION 200. -- REMOVED AND REPLACED LONGERON AND SPLICE.SDR MWEA011262Longeron · crackedE&E COMPARTMENT, LONGERON 24 LEFT IS CRACKED AT FRAME STATION 200. -- REMOVED AND REPLACED LONGERON AND SPLICE.SDR MWEA011258Door Frame · gougedLEFT AFT EMERGENCY EXIT DOOR JAMB AT THE UPPER LATCH IS GOUGED. REMOVED AND REPLACED REPAIR DOUBLER.SDR 0104199868Fitting · crackedDuring Mck in Atl., A crack was found in the forward airstair aft support fitting. The crack was 5/8 long. Material 7075-t7651 aluminum plate . Repaired per EA 98-185142.SDR MALA010720Seat Track · corrodedDuring 4K-check in CWA, found LH Center Aisle seat LBL 18.3 corroded. Mx Performed Repair from Sta 297 to 349 IAW EO S53060. Seat Track PN 7253799-383, Slice joint PN 7253799-379.SDR MALA010719Angle · corrodedDuring 4K-Inspcection found frome Top Flange and Angle corroded on bottom Frame at Sta 258. Maintenance replaced corroded Angle PN 7253722-001 and performed repair to Top Flange IAW EO S53102.SDR ZW0A0108805Door Frame · crackedDURING CHECK-C MAINT FOUND APPROX 2 INCH CRACK IN FWD LEFT CABIN OUTER DOOR FRAME, LOWER FWD CORNER BELOW THE DOOR HINGE ASSEMBLY. REPLACED LOWER FWD CORNER OF PAN ASSY PER SRM 51-00 P27 ITEM B.SDR SWAA012555Beam · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM CRACKED AT BS 178, LBL 17.1 & WL 220. REPAIRED BEAM PER SRM.SDR SWAA012544Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL WEB CRACKED AT BS 179, WL 227 & LBL 17.1. R&R WEB PER SRM.SDR SWAA012542Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL WEBS CRACKED ( 2 EA ) AT BS 183, WL 233, LBL 17.1 & RBL 17.1. R&R WEBS PER SRM.SDR USAA011302Shear Tie · crackedCLT - FOUND SHEAR TIE CRACKED .5 INCH, AT STRINGER 25R TO FRAME AT STATION 947.5. REPLACE TIE CLIP. (M)SDR SWAA012543Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND HORIZONTAL WEBS CRACKED ( 2 EA ) AT BS 180, WL 207, LBL 26.5 & RBL 26.5. R&R WEBS PER SRM.SDR SWAA012535Fitting · crackedDURING SCHEDULED D-CHECK, FOUND Lt W/W SUPPORT FITTING CRACKED AT BS 716, LBL 68 & WL 192. REPAIRED FITTING PER SRM.SDR GTIA011089Door Frame · corrodedFTW - AFT LOWER CARGO COMPARTMENT FORWARD SIDE OF LOWER DOOR CORRODED FROM STATION 1155 TO 1212 AS MARKED. CORRODED OUT OF LIMITS AT LOWER CARGO DOOR JAMB. REMOVED CARGO DOOR JAMB BEAM. LOCATED AND DRILLED HOLES CARGO DOOR JAMB BEAM. INSTALLED LOWER CARGO SDR 01FDEA00955Door Frame · wornN 33 FS 960, LONG 40R TO 41R, FWD CARGO DOOR FRAME, AFT FRAME SKIN WORN. R&R FRAME PER SRM & EA.SDR 01FDEA00827Door Frame · wornF/S 960 LONG 40R TO 41R FWD CARGO DOOR AFT FRAME WORN. R&R PER IAW & SRM.SDR 01FDEA00825Door Frame · damagedF/S 963 LONG 39R TO 40R AFT FRAME FWD CARGO DOOR FRAME WORN THRU BOTH LAYERS OF SKIN. R&R FRAME PER SRM & EA.SDR AWXA200100508Web · crackedMCN - C17 CK - "C" - 5 EA CRACKS (TOTAL OF 3") ON VERTICAL WEB BS 706 TO 718, WL 200, LBL24, BELOW FLOOR PANELS. MAINTENANCE REMOVED DAMAGED SECTION OF VERTICAL WEB, FABRICATED REPAIR PARTS AND INSTALLED IAW AWA ER 03-5700-01270-JS3.SDR UPS01436945Shear Tie · crackedINSPECTION TYPE:C FWD CARGO COMPARTMENT STA 980 RT STR 45 - 46 FRAME SHEAR TIE CORROSION AND CRACK FOUND AS MARKED. THE CORRODED SHEAR TIE WAS TRIMMED OFF, AND WAS REPAIRED AS PER SRM 53-10-04 FIG 3 HFEC INSP CONFIRMED CRACK FREE AS PER NTM PT6, 51-00-00 FIG 4SDR 2001UALA02025Shear Tie · corrodedAFT PIT STATION 1395 SHEAR TIE BETWEEN STRINGER 38L AND 39R IS CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR USAA011297Web · crackedCLT - FOUND WEB CRACKED .5 INCH, BS 178 WL 213 RBL 6 AND WL 207 LBL 1. INSTALLED REPAIR DOUBLER PER EO 5300V153. (M)SDR USAA011225Web · crackedCLT - FOUND WEB CRACKED .75 INCH, BS 178, RBL 10, WL 234. INSTALLED REPAIR DOUBLER PER EA 85403. (M)SDR UPS01436885Door Frame · crackedINSPECTION TYPE:C M/D, MED NR 1L CUTOUT FWD FRAME BS 434 1EA HOLE CRACK AT FRAME WEB. REPAIRED FRAME WEB AT LT BS 434 S-21L TO S-26L AS PER SRM 53-10-04 FIG 99.SDR SWAA012522Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, LBL 17.1 & WL 230. R&R WEB PER SRM.SDR SWAA012533Web · corrodedDURING SCHEDULED D-CHECK, FOUND WEB CORRODED AT BS 810-823, RBL 66 & WL 199.v Removed and replaced WEB PER SRM.SDR 0104189866Door Frame · crackedDURING LINE CHECK IN CMH, A CRACK WAS NOTED IN THE APB VENTRAL DOOR JAMB PAN. THE CRACK WAS LOCATED 24 INCHES UP FROM THE FLOOR LINE ON THE LHS SIDE BY THE ROLLER ASSEMBLY. THE .375 INCH CRACK IS IN THE RADIUS OF THE DOOR JAMB. REPAIRED PER EA 98-164476.SDR 2001F00428Door Frame · crackedMAIN CARGO DOOR CUTOUT, FORWARD FRAME SKIN HAS A CRACK APPROXIMATELY AT BS 502 ABOVE STRINGER 14L. (M)SDR P2EA01176Door Frame · crackedSJO - DURING C-CHECK, LOWER FUSELAGE AFT CARGO COMPARTMENT DOOR WAY SECTION BS 794, BETWEEN STRINGER 25 AND 24 RT WEB WITH CRACK. REPAIRED AFT CARGO COMPARTMENT DOORWAY AT BS 794 BETWEEN STRINGERS 21 AND 25 RT, DUE TO CRACKS IAW COOPESA EO COO-3-53-503-01. (SDR UPS01436958Fitting · crackedINSPECTION TYPE: C, RT BATH TUB FITTING FOUND 1EA BOLT HOLE CRACK AT VERT CHORD ATTACH SURFACE AT 9 O'CLOCK POSITION ( LOOKING FWD ) APPROX 3/16 INCH IN LENGTH. RT BS 1000 S38R AREA BATH STUB FITTING REPLACED AS PER SRM 51-10-01 PAGE 8.SDR UPS01836882Door Frame · crackedINSPECTION TYPE:C2 R1 DOOR UPPER FWD CORNER HAS A CRACK INDICATION APPROX .500 IN LENGTH. PERFORMED HFEC IAW DC8 SRM 06-10-001. REMOVED DAMAGE IAW DC8 SRM 53-2-0. FABBED DOUBLER, TRIPLER & FLR IAW DC8 SRM 53-2-0. INSTALLED IAW DC8 SRM 53-2-0 & 51-1-20D.SDR AWXA0002261Shear Tie · damagedD: Shear tie at F.S. 324 between STR 1 & STR 2 left side damaged.C: Removed shear tie, fabricated shear tie filler & shim IAW DWG # 141N1315 & SRM 51-40-02. Installed shear tie, filler & shim IAW DRG 141N1315 & SRM 51-40-02SDR SWAA012498Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, RBL 17.1 & WL 230. R&R WEB PER SRM.SDR MWEA011251Skin · crackedFUSELAGE SKIN WAS CRACKED AT STATION 718 BELOW LONGERON 10 RIGHT. -- REMOVED DAMAGE, INSTALLED DOUBLERS.SDR 0104319750Door Frame · crackedDURING RON IN CMH A CRACK WAS NOTED IN THE APB VENTRAL DOOR JAMB PAN. THE CRACK WAS LOCATED 52.25 INCHES FROM THE FLOOR LINE ON THE LT BY THE ROLLER ASSEMBLY. REPAIRED PER 97-185133.SDR 2001UALA02019Shear Tie · corrodedBODY STATION 1263 STRINGER 38R-39R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA02007Shear Tie · corrodedBODY STATION 1351 STRINGER 33L-34L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA02006Shear Tie · corrodedBODY STATION 1263 STRINGER 27L-28L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR SWIA200110247Shear Tie · crackedFORMER CRACKED JUST AFT OF PILOT'S DIRECT VISION WINDOW AFT CENTER. REMOVED AND REPLACED CRACKED BRACKET WITH NEW SERVICEABLE BRACKET OF SAME P/N FOR THIS LOCATION. ALL WORK PERFORMED IN ACCORDANCE WITH THE SRM 51-70-00. ALL CHECKS GOOD. P/N: 120-12545-00SDR 2001UALA01988Door Frame · crackedCABIN 1L DOOR CUT UPPER AUXILIARY SILL WEB IS CRACKED AT BODY STATION 306 STRINGER 4L. MAJOR REPAIR ACCOMPLISHED. REPLACED WEB.SDR QXEA0101505Structure · corrodedPDX- CORROSION 4.5 INCHES BEHIND FRAME 445.500 INBOARD OF STRINGER 31 RT. REPAIRED IAW DHC-8 SRM 53-00-16 PAGE 13, 53-10-11 PAGES 3 AND 5, 51-20-16 PAGE 4 AND 51-20-36 PAGE 7.SDR SWAA012511Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 17L. REPAIRED FRAME PER SRM.
Back to JASC 5310