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 2005UALA00387Floorbeam · corrodedAFT CABIN FLOORBEAM UPPER CAP IS CORRODED AT STA 1661 RBL 60. CORROSION WAS REMOVED AND A STRAP REPAIR WAS INSTALLED.SDR SWIA200514953Floorbeam · crackedFUSELAGE FS 280.00 RBL 9.0 LOWER FLANGE CRACKED ON TRANSVERSE BEAM. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED FS 280, FBL 9, LOWER FLANGE ON TRANSVERSE BEAM IAW CRJ REO 601R-53-11-171 REV B.SDR DHL2005741522Floorbeam · corrodedBS 324 T CAP UPPER CORROSIONS. FOUND CORROSION TO BE OUT OF LIMITS AT STA 324 "T" CAP UPPER AT BLR 48 AND BLR 20 AND BLL 32 IAW B727 SRM 53-10-1 FIG 5. REMOVE STA 324 "T" CAP IAW B727 SRM 51-30-2. FABRICATED OF NEW "T" CAP DIM 128" FROM BAC1505-100242 PO NRSDR C1HA200596005Floorbeam · corrodedMAIN PASSENGER CABIN STA 1030 LBL 24 TO RBL 24 TOP OF FLOORBEAM CORRODED.SDR C1HA200596004Floorbeam · corrodedMAIN PASSENGER CABIN STA 1130 LBL 26 TO 46 TOP OF FLOORBEAM CORRODED.SDR USAA050629Floorbeam · corrodedBFM - FOUND FLOORBEAM CORRODED 5 INCHES LONG BY 1 INCH WIDE BY .020 INCH DEEP, FRAME 73, Y-794.3 -Z240. REMOVED AND REPLACED WITH NEW PART PER SRM 53-00-15, 51-42-11. (M)SDR DHL2005741563Floorbeam · defectiveFOUND REPLACE TEE ANGLE AT BS RBL 60-LBL 60 FOR 9-G BARRIER INSTALLATION. REMOVED TEE ANGLE BS 344 FROM LBL 60 -LBL 60. LOCATED AND DRILLED HOLES IN REPLACEMENT PART IAW B727 SRM 51-30-2 FIG 1. TREATED AND PRIMED PART IAW B727 SRM 51-10-2. INSTALLED REPLACSDR UPS05844460Floorbeam · corrodedINSPECTION TYPE:C1 MAIN CABIN FLOORBEAM HEAVY CORRODED AT STA 1700 RBL 34. REMOVED CORROSION AND FOUND OUT OF LIMITS IAW DC-8 SRM 53-2-0 FIG 1F. FABRICATED AND INSTALLED FLOORBEAM REPAIR IAW DC-8 SRM 53-2-0 FIG 1G, 51-1-20D, AND 51-3-0.SDR USAA050516Floorbeam · corrodedCLT - FOUND FLOORBEAM UP CHORD 1 INCH BY 1 INCH, STATION 986 RBL 8 TO RBL 38. REPLACED UPPER CHORD IAW TR 53-60-01. (M)SDR USAA050511Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED .250 INCH BY .250 INCH, BL 0 STATION 344. REMOVED CORROSION AND REPAIRED IAW SRM 53-10-51. REPAIR COMPONENTS FABRICATED. (M)SDR SIMA200511704Floorbeam · corrodedTHE GALLEY FORWARD DIGITAL WAS FOUND TO BE CORRODED. BLENDED THE CORRODED AREA. FABRICATED A DOUBLER AND INSTALLED. REPAIR DONE IAW SRM. (SW21200505716) (K)SDR MALA050377Floorbeam · corrodedDURING C2 INSPECTION, FOUND FLOORBEAM AT FRAME 20 AND RBL 20 HAS CORROSION ON TOP OF UPPER FLANGE.SDR PIDA200500003Floorbeam · corrodedCORROSION AT CLIP NUT HOLE AT LBL 27 ON FLOORBEAM AT BS 312. REPAIRED PER SRM 53-10-51.SDR 05FDEA01043Floorbeam · crackedFLOORBEAM CRACKED FRAME 58 / -Y953. REMOVED ALL NECESSARY CARGO LOADING SYSTEM AND FLOOR PANELS TO FOM. REMOVED DAMAGED ADAPTER.SDR SWAA051150Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM T-CHORD CRACKED AT BS 660.5, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR 2005UALA00359Floorbeam · corrodedCABIN FLOORBEAM CAP CORRODED AT BS 324, RBL 60-64 UPPER SURFACE. FLOORBEAM WAS REPAIRED USING REPAIR ANGLES AND STRAP.SDR USAA050520Floorbeam · corrodedPIT - FOUND BEAM CORRODED .25 INCH DIAMETER, RT OUTER SILL BEAM, FRAME 66. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-43-00 DWG IED 53474180. (M)SDR CALA0500104Floorbeam · corrodedCABIN FLOORBEAM AT STA 986.5, LBL 43 IS CORRODED. REPAIRED BEAM PER ECRA 5310-04470.SDR CALA0500102Floorbeam · corrodedCABIN FLOOR CORROSION AT STA 986.5, APPROXIMATELY 48 INCHES. REPLACED BEAM PER SRM 53-00-51 FIG 203.SDR CALA0500116Floorbeam · corrodedFLOORBEAM CORROSION AT BS 680, RBL 53 ON FLOORBOARD FASTENER HOLE. REPAIRED CHORD PER SRM 53-00-51, FIG 201.SDR USAA050499Floorbeam · corrodedPIT - FOUND FLOORBEAM ASSEMBLY .25 INCH BY .5 INCH CORROSION, FRAME 69L Y1440. DEFECTIVE PART REPLACED WITH IDENT PART. (M)SDR MALA050352Gusset · corrodedDURING C2 INSPECTION FOUND GUSSET CORRODED AT FRAME 18 RBL 37.SDR SWAA051095Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 715, BL 0, WL 204. REPAIRED BEAM PER SRM & EO.SDR USAA050497Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1 INCH IN DIAMETER, LT INBOARD SEAT TRACK BEAM AT FRAME 66. DEFECTIVE PART REPLACED WITH IDENT PART. CORROSION LEVEL 1, TASK JA 260-53500. (M)SDR QXEA200500792Floorbeam · corrodedYYC - FUSELAGE INTERIOR, FUSELAGE STATION 280 FLOOR SUPPORT CROSSBEAM IS CORRODED ON TOP FLANGE FROM LBL30 TO RBL30. REPAIRED IAW REO 670-53-11-047.SDR SWIA200514919Floorbeam · crackedFS 280 RIGHT FLOORBEAM RBL 9.0 INBOARD AND OUTBOARD ATTACH ANGLES CRACKED, ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLES IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21 & 51-23-00SDR SWIA200514918Floorbeam · crackedFS 280 LEFT FLOORBEAM LBL 9.0 OUTBOARD ATTACH ANGLE CRACKED, ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-71, 51-42-06, 51-42-21 & 51-23-00.SDR 72300167Floorbeam · corroded3 INCH BY .75 INCH AREA OF CORROSION ON FLOORBEAM UPPER CHORD.SDR ASOA05345Floorbeam · corrodedDURING C-CHECK, THE FLOOR MEMBER WEBBING AT FS 280 BETWEEN LBL9 AND RBL 9 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE FLOOR MEMBER WEBBING AT FS 280 BETWEEN LBL 9 AND RBL 9 IAW EO. (K)SDR ASOA05343Floorbeam · crackedDURING C-CHECK, THE TRANSVERSE BEAM AT FS 280 BETWEEN LBL9 AND LBL 27 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE TRANVERSE BEAM AT FS 280 BETWEEN LBL 9 AND LBL 27 IAW EO. (K)SDR USAA050542Floorbeam · corrodedBFM - FOUND FLOORBEAM CORRODED 3 INCHES LONG BY 1 INCH WIDE BY .055 INCH DEEP AND 3 INCHES LONG BY 1 INCH WIDE BY .043 INCH DEEP, AFT CARGO FLOOR LBL 12.5 AND RBL 3. FABRICATED REPAIR ANGLES AND INSTALLED PER TYP REPAIR 53-10-06B. CORROSION LEVEL 1, TASK C53SDR USAA050541Floorbeam · corrodedBFM - FOUND FLOOR SUPPORT/ANGLE CORRODED 1 INCH LONG BY 1 INCH WIDE BY .028 INCH DEEP, AFT CARGO FLOOR SUPPORT BS 867 LBL 8.10 INCH. INSTALLED REPAIR ANGLE PER TYPICAL REPAIR 53-10-06B AND SRM 53-60-53. (M)SDR SWAA051055Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 662, RBL 25, WL 207. REPAIRED BEAM PER SB & PAE ER.SDR SWIA200514916Floorbeam · crackedFS 621 RIGHT SIDE FLOOR SUPPORT ANGLE RBL 42 CRACKED, ITEM FOUND AT C-CHECK INSPECTION. CRACKED ANGLE REPAIRED IAW CRJ REO 601R-53-61-117 REV "B" .SDR SWIA200514913Floorbeam · crackedFS 460 RIGHT OUTBOARD FLOOR FITTING RBL 9.0 CRACKED, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED IAW CRJ SRM 51-42-06, 51-42-21, 51-23-00, 51-25-16 & 51-21-11.SDR CALA0500100Floorbeam · corrodedINSPECTION FOUND MAIN CABIN FLOORBEAM BEAM CORRODED AROUND SCREW HOLES AT STA 947.5, LBL 17 TO RBL 17. A REPAIR WAS INSTALLED IAW ECRA 5310-04049.SDR USAA050477Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 2.5 INCHES DIAMETER AREAS, FLOORBEAM GALLEY MOUNTING HOLES OUTBOARD FLOORBEAM, BETWEEN RT SIDE C68-69. DEFECTIVE PART REPLACED WITH IDENT PART NR. (M)SDR USAA050496Floorbeam · corrodedFOUND FLOORBEAM CORRODED 1 SQUARE INCH, AROUND NUT PLATE HOLES, FLOORBEAM C66-C69 LEFT OUTBOARD. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-72-11. CORROSION LEVEL 1, TASK JA 260-53500. (M)SDR USAA050479Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 2 INCHES BY 2 INCHES BY .060 INCH DEEP AREA, FLOOR SUPPORT AT Y750 ABOVE C68. CORROSION LEVEL 1, TASK JA-260-53500. DEFECTIVE PART REPLACED WITH IDENT PART NR PER SRM 51-72-11. (M)SDR USAA050478Floorbeam · corrodedFLOORBEAM CORRODED .5 INCH DIAMETER AREA, FLOORBEAM AT FRAME 20, 9 INCH RIGHT OF CENTER. REMOVED CORROSION, INSTALLED DOUBLER PER SRM 53-11-14. CORROSION LEVEL 1, TASK JA-220-53300. REMOVED CORROSION, INSTALLED DOUBLER PER SRM 53-11-14. (M)SDR 0500879871Floorbeam · crackedDURING H-CHECK FOUND CRACK IN FLOORBEAM AT BS 237 LBL 5. REPAIRED PER EA 98-203186.SDR 05FDEA00896Floorbeam · damagedCOMPLY WITH EA 7-5321-55461 FUSELAGE - FLOORBEAM LOWER CHORD REPAIR, STA 720 AT RBL 13.0. COMPLIED WITH EA 7-5321-55461.SDR ASOA05355Floorbeam · corrodedDURING HANGAR MAINTENANCE, THE FS 280 TRANSVERSE BEAM WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED THE FS 280 TRANSVERSE BEAM IAW EO. (K)SDR USAA050537Floorbeam · corrodedBFM - FOUND SUPPORT, T-ANGLE, WEB CORRODED AND CRACKED 4 INCHES LONG, 1 INCH WIDE AND 1 INCH, BS 994 WL 208 AFT CABIN FLOOR. BLENDED SUPPORT, REMOVED AND REPLACED T-ANGLE AND WEB WITH NEW FABRICATED PARTS PER SRM 51-40-02, 53-60-51. (M)SDR UPS05444424Floorbeam · crackedRT BS 340 U/D FLOORBEAM FOUND 2EA FASTENER HOLES CRACKED AT STR 12 RT REFER TO ATTACH SKETCH FOR DETAILS, CRACK LENGTH FS WEB 1/4", 1/8" AND THROUGH THICKNESS FLOORBEAM CHORD 0.060". BS 340 RT U/D FLOORBEAM CHORD REPAIRED AT RBL 48" TO RT MOST O/B END AS PER SDR UPS05444423Floorbeam · crackedLH BS 340 U/D FLOORBEAM FOUND 2EA FASTENER HOLES CRACKED AT STR 12L REFER TO ATTACH SKETCH FOR DETAILS. CRACK LENGTH CHORD 0.060", FRAME WEB 1/8" AND THROUGH THICKNESS FLOORBEAM WEB CRK THROUGH THICKNESS. BS 340 LT U/D FLOORBEAM CHORD REPAIRED AT LBL 36 TO LSDR USAA050485Floorbeam · corrodedBFM - FOUND CORROSION 1.6 INCH LONG BY 1.3 INCHES WIDE BY .035 INCH DEEP, BS 870 AND 860 AT RBL 74.8 AT MAIN CABIN FLOOR PANELS. ACCOMPLISHED FLOORBEAM SPLICE REPAIR PER SRM 53-00-51 FIG 203. (M)SDR USAA050468Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 7 INCHES, FS 271 LBL 8 TO RBL 8. SPLICED A NEW Z ANGLE. (M)SDR SWIA200514894Floorbeam · crackedFS 621 LBL 41 FLOORBEAM ANGLE IS CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED FLOOR SUPPORT ANGLE AS PER IAW CRJ REO 601R-53-61-117 REV B.SDR SWIA200514892Floorbeam · crackedMAIN FUSELAGE FLOORBEAM AT RBL 9.0 O/B ATTACH ANGLE AT FS 280 IS CRACKED, ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-21-11, 51-25-16, 51-23-00.
Back to JASC 5315