JASC 5315
Service difficulty reports · 44,223
Reports filed under 5315 · Fuselage Main, Floor Beam, 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 = '5315' 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 = '5315' 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 2002UALA01772Web · crackedCABIN FLOOR SUPPORT INTERCOSTAL WEB CRACKED IN RADIUS ON FORWARD END STATION 661 LBL 44" STRINGER 17L. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED.REMOVED AND INSTALLED NEW WEB.SDR 2002UALA01769Fastener · elongatedCABIN FLOOR SEAT TRACK FLANGE FASTENER HOLE FOR FLOOR BOARD ON INBD SIDE OF FLANGE ELONGATED LOCATED AT STA.572 LBL 44. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. L-ANGLE AND STRAP INSTALLED.SDR SWAA022787Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 328 FLOORBEAM CORRODED BETWEEN LBL 30 AND RBL 60. REPAIRED PER SWA EA.SDR SIMA200233802Floorbeam · corrodedABI - DURING AN MBV INSPECTION, THE CENTER SECTION OF THE FORWARD DIGITAL WAS FOUND TO BE CORRODED BEYOND SRM LIMITS. REMOVED DAMAGED 15.25 BY 21.25 SECTION OF THE FORWARD DIGITAL BY CUTOUT. FABRICATED A REPLACEMENT FORWARD DIGITAL CENTER SECTION. FABRICATESDR SWIA200211587Floorbeam · crackedFS 280 RBL 9.0 INBOARD FLOORBEAM ANGLE CRACKED. FOUND DURING C-CHECK INSPECTION. ANGLE REPLACED IAW CRJ SRM 51-40-11, 51-42-06 & 51-42-21 USING ORIGINAL HARDWARE.SDR 02FDEA00872Floorbeam · corrodedCORROSION ON LONGITUDINAL FLOORBEAM BS 790 - 850, RBL 25, WL 208.SDR AWXA200201214Floorbeam · corrodedMAJOR REPAIR - DURING C-09 CHECK INTERGRANULAR CORROSION WAS FOUND AROUND A HILOC ON CABIN FLOORBEAM AT BS 1661, LBL 57.5. MAINTENANCE REMOVED HILOC AND CORROSION ON CABIN FLOORBEAM AT BS 1661, LBL 57.5, AND FOUND MATERIAL LOSS OUT OF LIMITS. CUTOUT DAMAGED SESDR ABXA030014Floorbeam · corrodedCABIN RIGHT SIDE STA 287 FLOORBEAM, RBL 73, FOUND CORROSION ON UPPER FLANGE OF FLOORBEAM, WL 199.5. PERFORMED FLOORBEAM UPPER CHORD REPAIR IAW SRM 53-00-51, FIGURE 201, REF SRM 53-10-51 AND DWG NR 141T5111. INSTALLED IAW SRM 51-40-02.SDR AWXA200201213Floorbeam · corrodedDURING C-09 CHECK INTERGRANULAR CORROSION WAS FOUND ON CABIN FLOORBEAM UPPER FLANGE AT BS 1661, LBL 24. MAINTENANCE REMOVED CORROSION ON CABIN FLOORBEAM UPPER FLANGE AT BS 1661, LBL 24, AND FOUND MATERIAL LOSS OUT OF LIMITS. CUTOUT DAMAGED SECTION OF FLOORBEAMSDR 2002UALA01750Floorbeam · crackedFLOORBEAM SEAT TRACK SPLICE CRACKED AT STATION 786, LBL 10. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM WITH REPAIR SPLICES AND FILLERS.SDR AWXA200201209Floorbeam · corrodedMAJOR REPAIR - DURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND ON CABIN FLOORBEAM AT RIGHT INBOARD EDGE OF CUSP, BS 1681. MAINTENANCE REMOVED CUSP ATTACH ANGLE FROM RIGHT CUSP AREA BS 1640 TO BS 1720, THRESHOLD WEB AND SUPPORT STRUCTURE, INTERCOSTALS FROM SDR AWXA200201159Web · crackedMCN - MAJOR REPAIR - DURING C-02 CHECK A 1" CRACK WAS FOUND ON FORWARD END OF WEB FLOOR SUPPORT BRACKET JUST INSIDE AVIONICS DOOR 824 AT FS 6393 TO FS 6425. MAINTENANCE REMOVED DAMAGED WEB FLOOR SUPPORT BRACKET AT FS 6393 TO FR 6425; FABRICATED A NEW REPLACEMESDR USAA020462Floorbeam · corrodedTPA - FOUND FLOORBEAM WITH 1 INCH SQUARE CORRODED AREA, UPPER SURFACE FLOOR SUPPORT BEAM Y765 AT FRAME 66. REMOVED AND REPLACED FLOORBEAM PER SRM 53-41-04. (M)SDR USAA020461Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED 1 SQUARE INCH, UPPER SURFACE FLOORBEAM Y1292 AT FRAME 16. SPLICED IN NEW SECTION OF SEAT TRACK PER SRM 53-11-15. (M)SDR USAA020458Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED 1 SQUARE INCH, UPPER SURFACE FLOOR SUPPORT BEAM Y1732 FRAME 66. CLEANED CORRODED AREA, INSTALLED REPAIR ANGLES PER SRM 53-41-14 FIG 201. (M)SDR 2002UALA01735Floorbeam · crackedCABIN FLOOR STRUCTURE FRAME 12+2, LBL 9 TRANSVERSE FLOORBEAM CRACKED FWD FASTENER HOLE. MAJOR REPAIR ACCOMPLISHED. SPLICED IN NEW SECTION OF TRANSVERSE FLOORBEAM WITH 4EA NESTED ANGLES.SDR MALA020675Floorbeam · corrodedDURING C-CHECK IN CVG, FLOORBEAM 18 BETWEEN NR 3 AND 4 SEAT TRACK AND OUTBOARD 1.0 INCH FROM NR 4 SEAT TRACK HAS CORROSION ON UPPER SURFACE BEYOND LIMITS. MAINTENANCE REPAIRED FLOORBEAM 18 IAW EO A53013 AND BAE FAX BARA/AVR/6171/02-DC.SDR MWEA020696Floorbeam · damagedCENTER FLOOR BEAM ANGLE FLANGE AT STATION 1309 BLENDED BEYOND LIMITS. AREA IS ACCEPTABLE FOR STRENGTH AW MWX-MKE-02-00128H.SDR 02FDEA00859Floorbeam · corrodedCORROSION ON LOWER CHORD OF BS 970 FLOORBEAM AROUND NUTPLATE HOLE, RBL 11, WL 200. R&R FLOORBEAM PER SRM 53-10-1 & 53-10-8 FIG 8.SDR 02FDEA00858Floorbeam · corrodedCORROSION ON LWR CHORD OF BS 970 FLOORBEAM AROUND NUTPLATE HOLE, RBL 22, WL 200. R&R FLOORBEAM PER SRM 53-10-1 & 53-10-8 FIG 8.SDR UPS02239941Floorbeam · crackedINSPECTION TYPE:C BEAM TIE CRACKED ON FLOORBEAM LWR FLANGE BS 328 RBL 40. REPAIR PLATE FABRICATED AND FITTED AS PER ARM 53-10-8.SDR 2002UALA01734Floorbeam · corrodedMAIN CABIN FLOOR BEAM T-CAP CORRODED STATION 850-854, LBL 48 TO LBL 52. MAJOR REPAIR ACCOMPLISHED. REPAIR ANGLE SPLICES AND SHIMS.SDR 2002UALA01733Floorbeam · corrodedMAIN CABIN FLOOR BEAM T-CAP CORRODED STATION 850-854, RBL 48-RBL 52. MAJOR REPAIR ACCOMPLISHED. REPAIRED ANGLE-DOUBLER AND SHIMS.SDR ASAA0210319Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 500B, RIGHT BUTTOCK LINE 11, RIGHT BUTTOCK LINE 24 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0210308Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 500B, LEFT BUTTOCK LINE 6, LEFT BUTTOCK LINE 44 CORRODED. REMOVED CORROSION AND FABRICATED REPAIR PER EA. (M)SDR ASAA0210309Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BODY STATION 1016, LEFT BUTTOCK LINE 36, RIGHT BUTTOCK LINE 36 CORRODED. REMOVED CORROSION AND FABRICATED REPAIR PER EA. (M)SDR ASAA0210310Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 480, LEFT BUTTOCK LINE 42 CORRODED. REMOVED CORROSION AND FABRICATED REPAIR PER EA. (M)SDR ASAA0210311Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM FLANGE AT BS 787, LEFT BUTTOCK LINE 45, RIGHT BUTTOCK LINE 45 CORRODED. REMOVED CORROSION AND FABRICATED REPAIR PER EA. (M)SDR ASAA0210316Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 420, LEFT BUTTOCK LINE 12, LEFT BUTTOCK LINE 48 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0210317Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BODY STATION 480, LEFT BUTTOCK LINE 29, LEFT BUTTOCK LINE 43 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0210318Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 500, LEFT BUTTOCK LINE 44 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR 02FDEA00849Floorbeam · corrodedCORROSION ON BS 1090 FLOORBEAM LOWER CHORD AT NUTPLATE HOLES, RBL 21, WL 200. REMOVED AND REPLACED FLOORBEAM IAW SRM.SDR 02FDEA00848Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER FLANGE AROUND NUTPLATE HOLES AT BS 950C, RBL45-55, WL 208. REMOVED AND REPLACED FLOORBEAM IAW EA AND SRM.SDR 02FDEA00844Floorbeam · corrodedCORROSION ON LWR CHORD OF BS 1070 FLOORBEAM AROUND NUTPLATE HOLES, BL0 - RBL 31, WL 200. REMOVED AND REPLACED FLOORBEAM IAW EA AND SRM.SDR 02FDEA00841Floorbeam · corrodedCORROSION ON UPPER CHORD OF FLOORBEAM AROUND FLOORBOARD HOLES AT BS 680, RBL 4 TO RBL 21, WL 208. REMOVED AND REPLACED FLOORBEAM IAW EA AND ER.SDR 02FDEA00839Floorbeam · corrodedCORROSION AT BS 344, WL 208, LBL 65 UNDERSIDE OF FLOORBEAM UPPER CHORD, AROUND THE NUTCLIP. REMOVED CORROSION ON FLOORBEAM UPPER CHORD. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED CHORD AND SPLICE IAW SRM.SDR 02FDEA00843Floorbeam · corrodedCORROSION BS 680, LBL 2 TO LBL 24, WL 208 FLOOR SUPPORT TOP AND BOTTOM. BLENDED CORROSION ON FLOORBEAM. FOUND FLOORBEAM TO BE OUT OF LIMITS IAW.SDR 02FDEA00842Floorbeam · corrodedBS 680, LBL 28 TO LBL 41, WL 208 FASTENER HOLES HAS CORROSION AT LWR SIDE. BLENDED CORROSION ON FLOORBEAM. FOUND FLOORBEAM TO BE OUT OF LIMITS IAW SRM.SDR 02FDEA00840Floorbeam · corrodedCORROSION ON FLOORBEAM NUT PLATE HOLES BS 950F, LBL 10, WL 208. REMOVED CORROSION ON FLOORBEAM. FOUND TO BE OUT OF LIMITS, REMOVED DAMAGED AREA, FABRICATED, AND INSTALLED REPAIR PARTS IAW SRM.SDR CALA0200549Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT BS 967, RBL 46. OLD TOP CHORD REPAIR EXISTS FROM LBL 43 TO RBL 43. FLOORBEAM REPAIRED IAW ECRA 5311-01142. TOP CHORD REPLACED FROM LBL 43 TO R/H EXTREMITY AT FRAME.SDR SIMA200232302Floorbeam · corrodedABI - DURING A IMBV INSPECTION, THE GALLEY AREA CENTER BEAM WAS FOUND TO BE CORRODED BELOW SRM LIMITS. REMOVED EXISTING BEAM AND INSTALLED NEW BEAM IAW EMB 145 SRM (EMB 145/1142 REV 19) CHAPTERS 51-40-02, 51-20-03 AND 51-40-06. (M)SDR ASAA0210307Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 420, LEFT BUTTOCK LINE 49, LEFT BUTTOCK LINE 59 CORRODED. REMOVED CORROSION AND FABRICATED REPAIR PER EA. (M)SDR ABXA020338Floorbeam · corrodedFLOORBEAM AT STA 995 WAS CORRODED ON THE TOP FLANGE AT LEFT BUTT LINE 46. REPAIRED FLOOR BEAM IAW DC-9 SRM.SDR UPS02239932Floorbeam · corrodedINSPECTION TYPE:C MAIN ENTRY DOOR FLOORBEAM T ANGLE SUPPORT SHOWS EVIDENCE OF CORROSION BETWEEN FS 312 AND FS 344. REMOVED AND REPLACED T ANGLE SUPPORT.SDR 02FDEA00826Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER CHORD AT BS 1110, RBL 16, WL 200 AT NUTPLATE HOLES. FOUND CORROSION ON FLOORBEAM UPPER CHORD TO BE OUT OF LIMITS IAW SRM 53-10-1. CUT OUT DAMAGE AREA & REPAIRED IAW SRM 53-10-8 FIG 8.SDR 2002UALA01719Floorbeam · corrodedCABIN FLOORBEAM CORRODED, STA 365, RBL 6. MAJOR REPAIR ACCOMPLISHED. ACCOMPLISHED SPLICE, ANGLE AND STRAP REPAIR.SDR 2002UALA01717Floorbeam · corrodedCABIN FLOOR BEAM T CAP UPPER SURFACE STATION 291 RBL 10-50 HAS AREAS OF EXCESSIVE MATERIAL LOSS DUE TO CORROSION. MAJOR REPAIR ACCOMPLISHED. T CAP REPLACED.SDR SWIA200211591Floorbeam · crackedFS 280 RBL 9.0 FLOORBEAM INBOARD AND OUTBOARD ANGLES CRACKED. FOUND DURING C-CHECK INSPECTION. REPLACED INBOARD AND OUTBOARD ANGLES IAW CRJ SRM 51-40-11, 51-42-21, 51-42-13, 51-42-06 AND REO 601R-53-11-171 REV NC.SDR SWIA200211590Floorbeam · crackedFS 280 LBL 9.0 FLOORBEAM INBOARD AND OUTBOARD ANGLES ARE CRACKED. FOUND DURING C-CHECK INSPECTION. FIT AND INSTALLED NEW CLIPS (ANGLES) IAW CRJ REO 601R-53-11-171.SDR 02FDEA00833Floorbeam · corrodedCORROSION ON LOWER CHORD OF BS 950D AT NUTPLATE HOLE RBL 14-40, WL 200. REPAIRED LOWER CHORD OF FLOORBEAM AT BS 950 RBL 14-40. ALL WORK DONE IAW SRM.
Back to JASC 5315