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 07FDEA02634Floorbeam · corrodedFLOORBEAM UPPER TEE CORRODED ON LOWER SIDE AT FRAME 36 RBL 60. [08-08-07] REMOVED CORROSION FOUND OUT OF LIMITS IAW A310-200 SRM 53-10-00, REMOVED CORRODED SECTION AND REPLACED WITH NEW UPPER TEE IAW A310-200 SRM 53-10-15 PG241/242SDR 07FDEA02633Floorbeam · corrodedFWD PIT FLOORBEAM UPPER TEE CORRODED FR 34 AT RBL 60. [08-14-07] REMOVED AND REPLACED UPPER TEE AND SPLICE PER A310-200 SRM 53-10-15 PG 241/242SDR 07FDEA02628Floorbeam · crackedFWD CARGO COMPT CEILING, CABIN FLOORBEAM C-27 HAS A CRACK ON FWD FACE VERTICAL FORMED SECTION, BETWEEN RT SEAT TRACK 2-3 WITH APPROX 0.25 IN LONG REF A300-600 SRM 51-10-10. CLEAN OUT CRACK IN FLOORBEAM IAW A300-600 SRM 53-10-15. FAB`D REPAIR ANGLE AND FILLERSDR 07FDEA02622Floorbeam · corrodedFWD CARGO AREA, STA 643 AT STR 28R ABOUT RBL 12, FLOOR SUPPORT CORRODED UNDER NUT PLATE. REMOVED CORROSION BY CUTTING OUT DAMAGED AREA, SRM 51-40 -4 PG 1. FABRICATED REPAIR PARTS SRM 51-40-4 PG 1-5. DRILLED FASTENER HOLES SRM 51-40-4 AND 51-30-2 PG 1- 12. SDR 07FDEA02620Floorbeam · corrodedSTA 848 FLOORBOARD SUPPORT BET BL 0 AND LBL 24, HAS LIGHT CORROSION AT NUTPLATE HOLES, UPPER AND LOWER FLANGES SURFACES REMOVED FLOOR SUPPORT AND INSTALLED NEW FLOORBOARD SUPPORT BL 0 TO LBL 24 NAD INSTALLED INBD AND OTBD SEAT TRACK FLANGE, STA 780 - 850 FER SSDR SIMA200721807Floorbeam · corrodedPREVIOUS REPAIR ON GALLEY FLOOR SUPPORT AT STATION 258 FOUND CORRODED. REMOVED PREVIOUS REPAIR AND INSTALLED NEW FILLER IAW SAAB SRM 53-70-30. RETURNED AIRCRAFT TO SERVICE.SDR UIEA200700296Floorbeam · crackedCRACK ON FORWARD FACE OF FLOORBEAM WEB (UPPER DECK) STA 330 LEFT SIDE AT FRAME TO FLOORBEAM ATTACHMENT. REPAIRED CRACKED FLOORBEAM WEB AT STA 330 LEFT PER SB 747-53-2272 DRAWING NR 65B28068 SRM 51-30-02 AND SRM 51-10-01. AREA CHECKED FOR FOD.SDR 07FDEA02612Floorbeam · corrodedCABIN FLOORBEAM AT STA 950 HAS CORROSION ON UPPER SURFACE BET RBL 24 RBL 45 REMOVED CORROSION FROM FLOORBEAM AT STA 950 RBL 24 TO RBL 45 IAW B727 SRM 51-10-1, ORIGINAL .125", REMAINING .120", HFEC. NO DEFECTS NOTED, ROTO PEENED, TREATED AND PRIMED IAW EA NR 7SDR KCSA071254Floorbeam · damagedMAIN DECK FLOORBEAM WEB DAMAGED AT BS 460, LBL-99.SDR UPS07850371Floorbeam · corrodedINSPECTION TYPE:C2 FLOORBEAM STA 1300 RBL 24 CRACKED AND CORRODED. CUT OUT DAMAGE, FABRICATED AND INSTALLED FILLER & DOUBLER IAW SRM 5 3-2-0, 51-02-00 FIG 1, 51-1-8, 51-1-20D, AND DWG 2759472.SDR F3LA200700181Floorbeam · corrodedDURING C-3 CHECK, INSPECTION REPORTED AFT GALLEY RT FLOORBEAM -Y1292, FR 68 TO FR69 CORRODED AT NUT PLATE FASTENER LOCATIONS.SDR F3LA200700180Floorbeam · corrodedDURING C-3 CHECK, INSPECTION REPORTED FLOORBEAM INBD OF R2 DOOR GIRT BAR CUTOUTS HAD LIGHT TO MODERATE CORROSION AT ALL NUT PLATE ATTACH POINTS. REPLACED FLOORBEAM IAW A318 SRM 51-42-11, STEP 7B.SDR F3LA200700179Floorbeam · corrodedDURING C-3 CHECK, INSPECTION REPORTED FLOORBEAM INBD OF L2 DOOR GIRT BAR CUTOUTS HAD LIGHT TO MODERATE CORROSION AT ALL NUT PLATE ATTACH POINTS. REPLACED FLOORBEAM IAW A318 SRM 51-42-11, PARA 5-7.SDR CALA0700373Floorbeam · corrodedINSPECTION FOUND MAIN CABIN FLOORBEAM CORRODED AROUND FASTENER HOLE AT STA 360, BL 0. THE CORRODED AREA WAS CUT OUT AND REPAIR ANGLES WERE INSTALLED IAW SRM 53-30-51, FIGURE 201, REPAIR 2.SDR USAA070576Floorbeam · corrodedDOOR R4 SILL BEAM FWD END ABOVE FRAME 66; CORRODED TASK JA-260-53500. CUT OUT AREA, FAB'D & INSTALLED FILLER & SPLICE ANGLES PER SRM 53-41-14, DEFECT SIZE: .5 X .5 INCH.SDR USAA070579Floorbeam · corrodedFLOORBEAM Y254 AT FRAME 16 HAS CORROSION. FABRICATED FILLER AND REPAIR ANGLES, INSTALLED WITH LOCK FASTENERS; CORR TASK JA-220-53500; LEVEL 1, DEFECT SIZE: 1 X 1 INCH.SDR UPS07449033Floorbeam · corrodedDURING C-3 CHECK, INSPECTION REPORTED AFT GALLEY RT FLOORBEAM -Y1292, FR 68 TO FR69 CORRODED AT NUT PLATE FASTENER LOCATIONS.SDR UPS07850394Floorbeam · gougedINSPECTION TYPE:C2 A-PIT STA 120 LBL 26 FLOORBEAM GOUGED AND FASTENER SHEARED. CUT OUT DAMAGED AREA ON FLOORBEAM AT STA 120 LBL 26 IAW SRM 51-02-00, FABRICATED AND INSTALLED REPAIR ANGLES AT STA 120 LBL 26 IAW SRM 51-02-00 FIG 1, AND SRM 53-02-00 FIG 1F.SDR TIPR200736001Floorbeam · corrodedAFT PIT FLOORBEAM UPPER T-CAP AT UPPER AND LOWER SURFACES HAS CORROSION AT BS1197 BETWEEN RBL 22 TO RBL 44. REMOVED CORROSION IAW MM 51-00-53. FOUND TO BE BEYOND LIMITS IAW SRM 53-00-07. MATERIAL ID IS BAC1506-3123 IAW DRAWING 146T1206. FABRICATED NEW T-CAP SDR A6WA200740467Floorbeam · crackedFOUND FS 280 RBL 9 INBOARD CLIP, P/N 601R31113-58 IS CRACKED. MAINTENANCE REMOVED AND REPLACED ANGLE IAW CRJ 200 SRM 51-42-13 ABD BSC SR 601R-53-0057A. (M)SDR A6WA200740407Floorbeam · crackedLT FS 484 FLOOR SUPPORT INTERCOSTAL ANGLE AT LBL 27 CRACKED APPROX .2 INCH LONG. (K) MAINTENANCE REPAIRED FS 484, LBL 27 ANGLE IAW BOMBARDIER STANDARD REPAIR 601R-53-0029B. (M)SDR A6WA200740406Floorbeam · crackedLT FS 484 FLOOR SUPPORT INTERCOSTAL AT LBL 36 CRACKED APPROX .2 INCH LONG. MAINTENANCE REMOVED FLANGE FABRICATED AND INSTALLED ANGLE IAW BSC SR 601R-53-0030A AND BOMBARDIER REO 601R-53-41-059 REV A. (M)SDR A6WA200740405Floorbeam · crackedRT FS 484 FLOOR SUPPORT INTERCOSTAL ANGLE AT RBL 27 CRACKED APPROX .2 INCH LONG. (K) MAINTENANCE REMOVED AND REPLACED ANGLE IAW CRJ 200 SRM 51-42-06 AND 51-42-21. (M)SDR A6WA200740404Floorbeam · crackedRT FS 484 FLOOR SUPPORT INTERCOSTAL AT RBL 36 CRACKED APPROX .2 INCH LONG. MAINTENANCE REPAIRED IAW REO 601R-53-41-059 AND EO 601R-53-003A. (M)SDR A6WA200740403Floorbeam · crackedRT FS 460 FLOOR SUPPORT FITTING (PN 600-31068) AT OB SIDE OF RBL 9 CRACKED APPROX 1.5 INCHES LONG. (K) MAINTENANCE REMOVED AND REPLACED FITTING P/N 600-31068-19 IAW CRJ 200 SRM 51-42-13, 51-42-21, AND 51-23-00. (M)SDR SWIA200718719Floorbeam · crackedSTA 621 FLOOR SUPPORT STRUCTURE IS CRACKED ON RIGHT SIDE, FOUND AT C-CHECK. INSTALLED REPAIR PARTS TO FS 621 RIGHT FLOOR SUPPORT PER CRJ200 SRM 51-42-06 PAGE 11 AND 51-42-21 PAGE 17.SDR SWIA200718718Floorbeam · crackedCARGO COMPARTMENT CRACKS AT STA 621 ON FLOOR SUPPORT STRUCTURE, FOUND AT C-CHECK. INSTALLED REPAIR PARTS PER CRJ200 SRM 51-42-06 PAGE 11 AND 51-42-21 PAGE 17.SDR SWAA073600Floorbeam · corrodedDURING SCHEDULED RON, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 986.5, RBL 44. REPAIRED FLOORBEAM PER ER.SDR 07FDEA02553Floorbeam · damagedCABIN MAIN DECK FLOORBEAM AT BS 720 RBL 48" HAS A DOUBLE DRILLED HOLE IN FWD FLANGE OF THE UPPER CHORD. REMOVED DAMAGE AREA'S. FAB 2EA REPAIR ANGLES FAB 3EA SHIMS, FAB CHORD, FAB WEB, FAB T-CHORD PN 65-80690 IAW B727 SRM 51-30-2 FIG NR 8. INSTALLED FAB PASDR 07FDEA02546Floorbeam · unknownFOUND REPAIR LOCATED AT BS 1050 FLOORBEAM UPPER CHORD FROM LBL 18" TO 22". REPAIR REQUIRES EVALUATION FOR MAJOR/MINOR DETERMINATION AND IF THE REPAIR WAS ACCOMPLISHED USING FAA APPROVED DATA. REMOVED OLD REPAIR. REPLACED REPAIR WITH NEW REPAIR. REF FEDEX DSDR 07FDEA02538Floorbeam · corrodedCABIN BS 560 FLOORBEAM UPPER CHORD HAS CORROSION ON UPPER SURFACE BETWEEN LBL 12 AND LBL 20. REMOVED DAMAGE IAW SRM 51-10-1 MAT WAS .125. REMOVED .005 -.120 REMAINS FOUND TO BE WITHIN LIMITS. PERFORMED NDT FOR CRACKS, NEGATIVE RESULTS. ROTO- PEENED IAW SOPSDR 07FDEA02537Floorbeam · corrodedCABIN BS 560 FLOORBEAM UPPER CHORD HAS CORROSION ON UPPER SURFACE BETWEEN LBL12 AND LBL 20. REMOVED DAMAGE IAW SRM 51-10-1 MAT WAS .125 REMOVED .005 -.120 REMAINS FOUND TO BE WITHIN LIMITS PERFORMED NDT FOR CRACKS, NEGATIVE RESULTS. ROTO- PEENED IAW SOPM 20-SDR SIMA200720714Floorbeam · corrodedCROSSBEAM AT FRAME 280 CORRODED. REMOVED CORROSION AND INSTALLED NEW SECTION IAW CRJ REPAIR STATEMENT REO 670-53-11-045. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200720712Floorbeam · corrodedCROSS BEAM AT FRAME 280 CORRODED. REMOVED AND REPLACED CROSS BEAM IAW CRJ REPAIR STATEMENT REO670-53-11-47. AIRCRAFT RETURNED TO SERVICE.SDR 2007UALA02745Stiffener · crackedCABIN FLOORBEAM STA 246 VERTICAL STIFFENER AT FWD FACE, RBL 11, CRACKED AT BEND RADIUS. [08-14-07] REMOVED AND REPLACED VERTICAL STIFFENER PER SRM 53-10-51, PARAGRAPH 3. AIRPLANE READY FOR SERVICE. SUSPECT FATIGUE EXACERBATED BY ASSEMBLY PRE-LOAD.SDR SWAA073566Floorbeam · crackedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CRACKED AT BS 312. BL 0. REPAIRED FLOORBEAM PER SRM.SDR SWAA073575Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 903, RBL 8. REPAIRED FLOORBEAM PER SRM.SDR CALA0700367Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED THE ENTIRE LENGTH, AT STA 328, LBL 45 TO RBL 45. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51.SDR CALA0700366Floorbeam · corrodedINSPECTION FOUND UPPER SURFACE OF FLOORBEAM CORRODED AT STA 344, LBL 17 TO RBL 12. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51.SDR KCSA071243Floorbeam · corrodedUPPER TEE CHORD CORRODED UPPER DECK FLOORBEAM STA 460 RBL 45 WL 308.SDR SWIA200718679Floorbeam · crackedFS 280 FLOORBEAM IS CRACKED AT RBL AND LBL 11, FOUND AT C-CHECK. INSTALLED FS 280 BEAM PER CRJ7/9 SRM 51-42-23/REO 670-53-11-047.SDR 2007UALA02721Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 365 RBL 20 TO RBL 50 HAS SURFACE CORROSION. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED T-CAP, RBL 20 TO CUSP. FABRICATED T-CAP. INSTALLED ANGLE DOUBLER & STRAP.SDR KCSA071234Floorbeam · crackedSTA 1220 RBL 113 AFT SIDE OF LOWER FLOORBEAM WEB CRACKED 1 INCH.SDR EIA2007142Floorbeam · damagedLT STA 1345 BL 117 O/B FLOORBOARD SUPPORT HAS ELONGATED HOLE (UNDER FLOOR BOARD). REPAIRED LT STA 1345 BL 117 O/B FLOORBOARD SUPPORT PER ECRA 488-53-024-2A.SDR EIA2007141Floorbeam · damagedRT STA 1345 BL 117 O/B FLOORBOARD SUPPORT HAS ELONGATED HOLE (UNDER FLOOR BOARD). REPAIRED RT STA 1345 BL 117 O/B FLOORBOARD SUPPORT PER ECRA 488-53-024-2A.SDR EIA2007144Floorbeam · loose2 FASTENERS MISSING AND 2 NOT TIGHTENED ON UPPER TEE OF FLOORBEAM STA 1460 BELOW CARGO TIE DOWN FITTING RBL 57 (BELOW FLOOR PANEL). REPAIRED STA 1460 FLOORBEAM AT RBL 57 PER ECRA 488-53-025-2.SDR NWAA072695503Floorbeam · corrodedDURING "M" CHECK, FOUND CORROSION ON AFT DECK PLATE SUB FLOOR STRUCTURE AT BS 1717 LBL 60 TO RBL 60. REPAIRED PER EA 55-194183.SDR USAA070548Floorbeam · crackedFOUND STA 294.5 31" LBL0, FLOORBEAM. REMOVED DAMAGED PART AND INSTALLED REPAIR PART PER SRM 51-20-00, DEFECT SIZE: 1.5.SDR USAA070549Floorbeam · crackedSTA 328 RBL 47 FLOORBEAM CRACKED. DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 51-10-02, DEFECT SIZE: 1 INCH.SDR USAA070550Floorbeam · crackedFLOOR SUPPORT, STA 540, LBL 0 TO LBL 25 HAS CRACK. REPLACED FLOOR SUPPORT PER SRM 51-10-02, DEFECT SIZE: .5 INCH.
Back to JASC 5315