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 AWXA200500103Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-17 CHECK, CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF FLOORBEAM UPPER CHORD AT BS 1016, BETWEEN LBL 4 AND LBL 34, WL 208. MAINTENANCE CUTOUT DAMAGE IN FLOORBEAM UPPER CHORD AT BS 1016, FROM LBL 4 TO LBL 34; FABRICATED A NEWSDR AWXA200500109Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-17 CHECK CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF FLOORBEAM UPPER CHORD AT BS 986, BETWEEN LBL 45 AND RBL 45, WL 208. MAINTENANCE REMOVED DAMAGED SECTION OF FLOORBEAM UPPER CHORD AT BS 986, FROM LBL 45 TO RBL 45; FABRICATSDR AWXA200500107Floorbeam · corrodedDURING C-17 CHECK, CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF FLOORBEAM UPPER CHORD AT BS 967, BETWEEN LBL 50 AND RBL 38, WL 208. MAINTENANCE CUTOUT DAMAGE IN FLOORBEAM UPPER CHORD AT BS 967, FROM LBL 50 TO RBL 38; FABRICATED A NEW REPLACEMENT SECTION SDR AWXA200500104Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-17 CHECK, EXFOLIATION CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF FLOOR SUPPORT AT BS 956, BETWEEN RBL 26 AND RBL 40, WL 208. MAINTENANCE REMOVED CORRODED FLOOR SUPPORT AT BS 956, FROM RBL 26 TO RBL 40; FABRICATED A NEW REPSDR 2004UALA01247Floorbeam · dentedUPPER T-CHORD FWD FLANGE OF AFT CARGO COMPARTMENT FLOORBEAM AT STA 1760, LBL 51 WAS FOUND DENTED. REPAIR ACCOMPLISHED.SDR SWAA043707Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO COMPT FLOORBEAM CORRODED AT BS 767, LBL 3. REPAIRED BEAM PER SRM & SWA EA.SDR 249TR0078Floorbeam · corrodedFORWARD SIDE OF LOWER TEE AT LEFT SIDE OF BS 1006 FLOORBEAM OUTBOARD ATTACH ANGLE HAS CORROSION. REPLACED ATTACH ANGLE PER SRM 51-10-1 AND 51-10-2 AND 51-30-0.SDR 249TR0050Floorbeam · corrodedBS 1016 FLOORBEAM HAS CORROSION AT FLOORBOARD HOLES BL 0 TO LBL 20. REPAIRED PER EA 53-346.SDR 249TR0049Floorbeam · corrodedBS 947 FLOORBEAM UPPER SURFACE AND FLOORBOARD ATTACH HOLES HAVE CORROSION. REPAIRED PER EA 53-340.SDR 249TR0046Floorbeam · corrodedBS 1016 FLOORBEAM LOWER -T- HAS CORROSION AT LBL 13. REPAIRED PER EA 53-342.SDR 249TR0044Floorbeam · corrodedCORROSION ON BS 312 FLOORBEAM. REPAIRED PER SRM 53-10-9.SDR 249TR0043Floorbeam · corrodedCORROSION ON BS 344 FLOORBEAM. REPAIRED PER SRM 53-10-9.SDR 249TR0040Floorbeam · corrodedBS 270 FLOORBEAM HAS CORROSION BETWEEN RBL 10 AND LBL 10. REPAIRED PER EA 53-345.SDR 249TR0039Floorbeam · corrodedBS 986 FLOORBEAM HAS CORROSION AT SEVERAL FLOORBOARD ATTACH HOLES ON UPPER AND LOWER SURFACE OF FLANGE. REPAIRED PER EA 53-343.SDR USAA041095Floorbeam · corrodedBFM - S1-CHECK - SUPPORT BEAM - 1.5 X 1.2 X 0.035 INCH AND 1.5 X 1.5 X 0.040 INCH, CORROSION; LEVEL 2; TASK NR JA-260-53500, MAIN CABIN Y1292, FR 66. REMOVED AND REPLACED WITH NEW PART IAW SRM. (K)SDR USAA041085Floorbeam · corrodedBFM - S1 CHECK- BEAM, 3.1 INCH X 1.5 INCH X 0.043 INCH AREA, CORROSION; LEVEL 2; TASK NR JA-260-53500-005, FLOOR SUPPORT BEAM AT Y765, FR 66. REMOVED AND REPLACED BEAM ASSY IAW SRM. (K)SDR SWAA043697Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LOGITUDINAL FLOORBEAM UPPER CHORD AT BS 663, BL 0, CRACKED. REPAIRED CHORD PER ER.SDR SWAA043696Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND 5 EACH CRACKS ON LONGITUDINAL FLOORBEAM AT BS 727B, FROM LBL 43 TO RBL 47. REPAIRED FLOORBEAM PER ER.SDR USAA041080Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 12 INCHES, STATION 347 FROM FROM 32 TO 44 RBL . REPLACED TEE CAP SECTION PER SRM 53-00-51. (M)SDR SIMA200435816Floorbeam · corrodedDURING AN MBV INSPECTION, THE FORWARD DIGITAL WAS FOUND TO BE CORRODED. BLENDED DIGITAL TO REMOVED CORROSION. FABRICATED A DOUBLER FOR REPAIR. REPAIR DONE IAW SRM. (SW21200501984) (K)SDR SWIA200414381Attach Angle · crackedFS 280 RIGHT FLOORBEAM RBL 9.0 OUTBOARD ATTACH ANGLE CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-13, 51-23-00, 51-21-11 & 51-42-21.SDR SIMA200435804Floorbeam · corrodedDURING CPCP INSPECTION, FOUND THE FLOOR DIGITAL CORRODED IN SEVERAL AREAS REMOVED AND REPLACED FLOOR DIGITAL IAW SRM. AIRCRAFT WAS RETURNED TO SERVICE. (SW21200501985) (K)SDR SWAA043689Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 986, BETWEEN LBL 47 AND RBL 47, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER EA.SDR SWAA043672Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 772, FROM LBL 12 TO RBL 14, CORRODED. REPAIRED FLOORBEAM PER EA.SDR DHL2005743506Floorbeam · corrodedMAIN PASSENGER CABIN STA 380 RBL 20 FLOORBEAM HAS CORROSION. REMOVED CORROSION IAW B727 SRM 51-10-6 FOUND OUT OF LIMITS. REMOVED FLOORBOARD TO GAIN ACCESS. REMOVED UPPER CHORD FROM STA 380 BL 0 TO RBL 33. MAT ID FOR UPPER CHORD BAC 1505-10061 PO 33-41778 ISDR USAA041125Floorbeam · corrodedBFM - FOUND FLOORBEAM CORRODED .6 INCH BY .6 INCH BY .045 INCH DEEP, MAIN CABIN FLOORBEAM 74, -Y 1202 CM. CORROSION LEVEL 2, TASK NR J7-270-53500. REMOVED AND REPLACED BEAM PER SRM 53-00-15. (M)SDR ASA440344Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM. REPLACED PER EA. (M)SDR AALA20050058Floorbeam · corrodedFLOORBEAM AT RIGHT BUTTLINE 49 AT STATION 325 HAS CORROSION 1.0 INCH BY 1.0 INCH WITH DEPTH OF .069. MATERIAL REMAINING IS BEYOND SRM LIMITS. FABRICATE REPAIR STRAP OUT OF 301 AND ONE HALF HARD STAINLESS STEEL 0.050 THICK. ALODINE ALL BARE ALUMINUM SURFACESSDR SIMA200429802Floorbeam · crackedDURING AN MBV INSPECTION A CRACK WAS DISCOVERED ON THE FORWARD DIGITAL AT FRAME 13. PERFORMED EDDY CURRENT INSPECTION TO DETERMINED THE LENGTH OF THE CRACK AND STOP DRILLED THE CARCK. FABRICATED A REPAIR DOUBLER. REPAIR DONE IAW STATEMENT IC2004/145-4832. SDR USAA041097Floorbeam · corrodedBFM - S1-CHECK - FLOOR BEAM, 16 INCHES L X 2 INCHES X .027 INCH D, CORROSION; LEVEL 2; TASK JA-220-53500-001, BEAM Y1292, FR 16-20. REMOVED AND REPLACED WITH NEW BEAM IAW SRM. (K)SDR SWIA200414500Floorbeam · crackedFS 280 BL 9 LEFT INBOARD AND OUTBOARD ANGLE BRACKETS BROKEN. ITEM FOUND AT C-CHECK INSPECTION. INSTALL NEW ANGLES PER REO 601R-53-11-137 AND CRJ 200, SRM 51-42-00, PG 1.SDR USAA041088Floorbeam · corrodedBFM - S1-CHECK - BEAM, 2.0 INCH X .75 INCH X 0.052 INCH AREA, CORROSION; LEVEL 2; TASK NR JA-260-53500, MAIN CABIN FLOOR BETWEEN FR 68-69, BL Y1292. REMOVED AND REPLACED BEAM ASSY IAW SRM. (K)SDR 2004UALA01207Floorbeam · corrodedMAIN CABIN AT BS 1661 FLOORBEAM CORRODED BETWEEN BL 0 AND LBL 1. FABRICATED & INSTALLED STRAP REPAIR TO UPPER CHORD.SDR SWAA043608Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 767, LBL 3, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA043604Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 270 FROM LBL 7 TO RBL 7, CORRODED. REMOVED AND REPLACED FLOORBEAM CHORD SECTION PER SRM.SDR IXXA0500099SFloor Panel · corrodedDURING A ROUTINE C-CHECK INSPECTION FOUND FLOORBEAM CORROSION DAMAGE IN CARGO COMPARTMENT AT STA FS 759.000 LBL 10. REPAIR ACCOMPLISHED BY REMOVING THE CORROSION. FOUND OUT OF LIMITS IAW SRM 53-32-0 PG 2P. FABRICATED REAPRI ANGLE IAW DC8 SRM 53-2-0 FIG 1 SHEETSDR IXXA0500098SFloorbeam · corrodedDURING A ROUTINE C-CHECK INSPECTION, FOUND FLOORBEAMS IN FUSELAGE CARGO COMPARTMENT WITH CORROSION DAMAGE AT STA FS 640.000 RBL 38. REPAIR ACCOMPLISHED BY REMOVING CORROSION. FOUND OUT OF LIMITS. REMOVED DAMAGE AREA, FABRICATED ANGLE REPAIR AND FILLER. CLSDR ASA044031Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM. REPAIRED FLOORBEAM UPPER CHORD PER SRM. (M)SDR ASA0440292Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM UPPER FLANGE. CORROSION FOUND OUT OF LIMITS, REPAIRED FLOORBEAM. (M)SDR ASA0440310Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM. REPAIRED PER SRM. (M)SDR SWIA200414464Floorbeam · crackedANGLE 621 AT CARGO FLOOR LEVEL, RIGHT SIDE CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED IAW CRJ REO 601R-53-61-117.SDR ASA0440259Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM UPPER FLANGE. REPAIRED FLOORBEAM PER SRM. (M)SDR USAA041083Floorbeam · corrodedBFM - S1 CHECK, FLOORBEAM, 2.4 INCH L X 1.81 INCH X .066 INCH D, CORROSION; LEVEL 2; TASK NR JA260-53500-007, FR 66,Y765, Z240. REMOVED AND REPLACED WITH NEW FLOORBEAM IAW SRM. (K)SDR SWAA043589Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM SHEAR WEB FROM BS 947 TO BS 1006, RBL 45, CORRODED. REMOVED AND REPLACED WEB PER SRM.SDR ASA0440273Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM UPPER FLANGE. REPAIRED FLOORBEAM UPPER FLANGE. (M)SDR AWXA200401459Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK CORROSION WAS FOUND AT FASTENER HOLES ON FLOORBEAM AT BS 986 BETWEEN RBL 25 AND RBL 60. MAINTENANCE REMOVED CORRODED FLOORBEAM AT BS 986 FROM RBL 25 TO RBL 60; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PARSDR ASOA04985Floorbeam · corrodedDURING A C-CHECK IN MCN, THE FLOORBEAM AT FS 574-621 WERE FOUND TO BE CORRODED BEYOND LIMIT. MAINTENANCE IS SUBMITTING A REPAIR REQUEST TO BOMBARDIER FOR AN REO TO REPAIR THE FLOORBEAMS AT FS 574-621. (M)SDR AWXA200500010Floorbeam · corrodedSAL - MAJOR REPAIR - DURING C-10 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM UPPER CHORD AT BS 324, RBL 50. MAINTENANCE CUT OUT CORRODED SECTION OF FLOORBEAM UPPER CHORD AT BS 324, RBL 50; FABRICATED A NEW REPLACEMENT SECTION OF FLOORBEAM UPPER CHORD, SDR SWAA043574Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM AT BS 665, BL 0, CRACKED. REPAIRED FLOORBEAM PER EA.SDR AALA20050057Floorbeam · corrodedAFW - FLOORBEAM SECTION 41 AT STATION 347 HAS CORROSION. MATERIAL REMAINING IS BEYOND SRM LIMITS. FABRICATE REPAIR STRAP OUT OF 301 AND ONE HALF HARD STAINLESS STEEL 0.050 THICK. ALODINE ALL BARE ALUMINUM SURFACES. FINISH BLENDS WITH 2 COATS BMS10 11 PRIME
Back to JASC 5315