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 AWXA200400258Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-20 CHECK INTERGRANULAR CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM AT BS 1016, RBL 33, WL 208. MAINTENANCE BLENDED OUT CORROSION ON UPPER SURFACE OF FLOORBEAM AT BS 1016, RBL 33, WL 208; FABRICATED A REPAIR STRAP; INSTALLEDSDR 04FDEA00520Floorbeam · corrodedCORROSION (C53-224-01,1) ON FLOORBEAM BS 340 RBL 12 WL 208 AT FASTENER HOLE. CORROSION ON FLOORBEAM BS 340, RBL 12, WL 208 AT FASTENER HOLE FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REMOVED & REPLACED FLOORBEAM BS 340 FROM BL 0 - RBL 65 PER SR DWG SR 27-53-SDR SWAA040577Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 259, LBL 11 AND RBL 11, WL 208. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR 2004UALA00165Floorbeam · corrodedSTA 947 RBL 45.5 FLOORBEAM UPPER CAP HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. INSTALLED FILLER AND REPAIR ANGLE.SDR MALA040260Floorbeam · crackedDURING INSPECTION IN LCQ, FRAME 18 FLOORBEAM CRACKED AT RCL 42 STA 216.65. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR DOUBLER AND ANGLES IAW MESABA EO A53155. A/C RELEASE DATE 3/10/04.SDR COMA0460161Floorbeam · crackedCARGO FLOOR ANGLE AT FS 621 RT SIDE CRACKED. REMOVED DAMAGED AREA OF RIGHT HAND CARGO FLOOR ANGLE. INSTALLED RIGHT HAND REPAIR ANGLE. ALL REPAIR AND FABRICATION WAS IN ACCORDANCE WITH BOMBARDIER REO 601R-53-61-004, CRJ SRM 51-23-00, CRJ SRM 51-25-06 AND CRJSDR AWXA200400240Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-20 CHECK .3125 INCH CRACK WAS FOUND IN LT CENTER CABIN FLOOR PANEL SUPPORT CHANNEL AT BS 540, BL -0-, WL 208. MAINTENANCE REMOVED CRACKED FLOOR CHANNEL AT BS 540, FROM BL -0- TO LBL 25, WL 208; FABRICATED A NEW REPLACEMENT CHANNESDR AWXA200400239Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-20 CHECK .25 INCH CRACK WAS FOUND IN CABIN FLOOR PANEL SUPPORT CHANNEL AT BS 540, RBL 45, WL 208. MAINTENANCE REMOVED CRACKED FLOOR CHANNEL AT BS 540, FROM RBL 25 TO RBL 45, WL 208; FABRICATED A NEW REPLACEMENT CHANNEL; INSTALLEDSDR AWXA200400237Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-20 CHECK .25 INCH CRACK WAS FOUND IN CABIN FLOOR PANEL SUPPORT CHANNEL AT BS 540, LBL 45, WL 208. MAINTENANCE REMOVED CRACKED FLOOR CHANNEL AT BS 540, FROM LBL 25 TO LBL 45, WL 208; FABRICATED A NEW REPLACEMENT CHANNEL; INSTALLEDSDR SWIA200413038Floorbeam · crackedDISCOVERED DURING C-CHECK INSPECTION, CARGO PIT FLOORBEAM ANGLE CRACKED AT FS 621.00 RBL 42.0. REPAIRED DAMAGE IAW CRJ REO 601R-53-61-117 REV ''A'' & RII 53-401.SDR SWIA200413034Floorbeam · crackedDISCOVERED DURING C-CHECK INSPECTION, MAIN FUSELAGE LBL 9.0 HAS INBOARD AND OUTBOARD FLOORBEAM ANGLES CRACKED AT FS 280.00. REPLACED IAW CRJ SRM.SDR SWIA200413033Floorbeam · crackedDISCOVERED DURING C-CHECK INSPECTION, MAIN FUSELAGE RBL 9.0 HAS INBOARD AND OUTBOARD FLOORBEAM ANGLES CRACKED AT FS 280.00. ANGLES REPLACED AT FS 280.0, RBL 9.0 IAW CRJ SRM.SDR C2XA04SH086Floorbeam · corrodedSHV- DURING C-CHECK THE LEFT OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND INSTALLED A SHIM FILLER REPAIR IAW EMB 1SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH085Floorbeam · corrodedSHV- DURING C-CHECK THE CENTER OMEGA BEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE CENTER OMEGA BEAM IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH072Floorbeam · corrodedDURING C CHECK THE LT OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A FILLER SHIM REPAIR IAW EMB 135 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04TY038Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE CENTER FLOORBEAM AT FRAME 20. MAINTENANCE REMOVED AND REPLACED THE CENTER OMEGA BEAM IAW EMB145 SRM 51-40-02, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTISDR C2XA04TY037Floorbeam · corrodedDURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE GALLEY FLOORBEAM RAMP ANGLE. MAINTENANCE REMOVED AND REPLACED THE RAMP ANGLE IAW EMB145 SRM 51-40-02, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR SWAA040491Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 986, RBL 24. REPAIRED PER SRM.SDR C2XA04SH068Doubler · corrodedSHV- DURING C-CHECK THE RT FLOORBEAM DOUBLER CAP AT FRAME 22 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED DOUBLER CAP IAW EMB135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH067Doubler · corrodedSHV- DURING C-CHECK THE RIGHT HAND FLOORBEAM DOUBLER CAP AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED CAP IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH070Buttstrap · corrodedSHV- DURING C-CHECK THE CENTER FLOORBEAM BUTTSTRAP WAS FOUND TO BE CORRODED IN THE LAVATORY BETWEEN FRAMES 55 AND 61. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 2004UALA00123Floorbeam · corrodedCORROSION WAS DISCOVERED ON THE UNDERSIDE OF THE FLOORBEAM LOCATED AT STA 1100 FROM LBL 17 TO LBL 30. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR STRAP.SDR SWAA040475Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND FLOORBEAMS CRACKED AT BS 727B, RBL 25, WL 208 AND BS 727B, LBL 45, WL 208. REPAIRED BEAMS PER ER.SDR CALA0400122Floorbeam · corrodedINSPECTION FOUND AFT CARGO FLOORBEAM STRAP CORRODED AT STA 727D + 6. THE FLOORBEAM STRAP WAS REMOVED AND REPLACED IAW SRM 53-60-53.SDR CALA0400111Floorbeam · corrodedINSPECTION FOUND AFT CARGO FLOORBEAMS UNDER CROSS STRAP CORRODED AT STA 767 + 6, RBL 8, RBL 3, AND LBL 3. REPAIRS WERE INSTALLED IAW ECRA 5320-01603.SDR SWIA200412961Floorbeam · crackedFS 280 RIGHT FLOORBEAM RBL 9.0 INBOARD AND OUTBOARD ATTACH ANGLES CRACKED. DISCOVERED DURING C-CHECK INSPECTION. REPLACED ANGLES IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-23-00, RII 53-401. P/N: 601R31113-58.SDR C2XA04SH063Floorbeam · corrodedSHV-DURING C-CHECK THE CENTER FLOORBEAM AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOORBEAM IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AWXA200400216Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON FLOORBEAM Y1732 LT, FORWARD OF FR 68. UPON FURTHER EVALUATION CORROSION WAS FOUND ON 2 EACH REPAIR FILLERS. MAINTENANCE REMOVED CORRODED FILLERS ON FLOORBEAM Y1732 LT, FORWARD OF FR 68; FSDR AWXA200400222Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y1292 RT BETWEEN FR 66 AND FR 68. MAINTENANCE REMOVED CORRODED FLOORBEAM Y1292 RT FROM FR 66 TO FR 68; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SSDR AWXA200400221Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON FLOORBEAM Y1292 RT BETWEEN FR 68 AND FR 69. MAINTENANCE REMOVED CORRODED FLOORBEAM Y1292 RT FROM FR 68 TO FR 69; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM SDR AWXA200400218Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON FLOORBEAM Y1292 RT AT FR 66. MAINTENANCE REMOVED CORRODED FLOORBEAM Y1292 RT FROM FR 64 TO FR 66; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-49-00, PG 5 SDR AWXA200400217Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON FLOORBEAM Y512 LT, AT FR 66. MAINTENANCE REMOVED AND REPLACED CORRODED FLOORBEAM Y512 LT, AT FR 66 IAW A320 SRM 51-49-00 PG 5 & 6, TABLE 1.SDR AWXA200400214Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y765 RT, BETWEEN FR 66 AND FR 68. MAINTENANCE REMOVED CORRODED FLOORBEAM Y765 FROM FR 66 TO FR 68; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 5SDR AWXA200400209Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON FLOORBEAM Y1292 LT BETWEEN FR 68 AND FR 69. MAINTENANCE REMOVED CORRODED FLOORBEAM Y1292 LT FROM FR 68 TO FR 69; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM SDR AWXA200400208Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK INTERGRANULAR CORROSION WAS FOUND ON FLOORBEAM Y1292 LT BETWEEN FR 66 AND FR 68. MAINTENANCE REMOVED CORRODED FLOORBEAM Y1292 LT BETWEEN FR 66 AND FR 68; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A320 SDR 2004UALA00117Floorbeam · crackedUPPER DECK FLOORBEAM WEB IS DENTED AND CRACKED STA 380 RBL 14. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED WEB, TAPER SHIM & STIFFENER REPAIRS.SDR 2004UALA00114Floorbeam · damagedAFT CARGO COMPARTMENT FLOORBEAM AT STA 1820 BL0 DAMAGED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CHORD REPAIR.SDR C2XA04TY036Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE LEFT HAND OMEGA BEAM AT FRAME 19. MAINTENANCE ACCOMPLISHED A DOUBLER REPAIR IAW EMB SRM 53-21-10, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR AWXA200400196Floorbeam · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK INTERGRANULAR CORROSION WAS FOUND ON FLOORBEAM AT FR 70, Y765 RT. MAINTENANCE REMOVED DAMAGED FLOORBEAM BETWEEN FR 68 AND FR 70, Y765 RT; FABRICATED A NEW REPLACEMENT FLOORBEAM PER DWG D53472209; INSTALLED REPAIR PART IASDR AWXA200400195Floorbeam · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK GALVANIC CORROSION WAS FOUND ON FLOORBEAM AT FR 66, Y512 RT. MAINTENANCE REMOVED DAMAGED FLOORBEAM BETWEEN FR 64 AND FR 67, Y512 RT; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-42-11 FIGSDR AWXA200400194Floorbeam · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK GALVANIC CORROSION WAS FOUND ON FLOORBEAM AT FR 66, Y765 RT. MAINTENANCE REMOVED DAMAGED FLOORBEAM AT FR 66, Y765 RT; FABRICATED A NEW REPLACEMENT FLOORBEAM PER DWG D53472209; INSTALLED REPAIR PART IAW A320 SRM 51-42-11,SDR AWXA200400191Floorbeam · corrodedDURING B-04 CHECK GALVANIC CORROSION WAS FOUND ON FLOORBEAM AT FR 68, Y1292 RT. MAINTENANCE REMOVED DAMAGED FLOORBEAM AT FR 68, Y1292 RT; FABRICATED A NEW REPLACEMENT FLOORBEAM IAW DWG D53472189; INSTALLED REPAIR PART IAW A320 SRM 51-42-11, FIG. 9-14, 16 SDR AWXA200400190Floorbeam · corrodedDURING B-04 CHECK CORROSION WAS FOUND ON FLOORBEAM BETWEEN FR 66 AND FR 68, Y1292 RT. MAINTENANCE REMOVED DAMAGED FLOORBEAM BETWEEN FR 66 AND FR 68, Y1292 RT; FABRICATED A NEW REPLACEMENT FLOORBEAM IAW DWG D53472172; INSTALLED REPAIR PART IAW A320 SRM 51-4SDR C2XA04TY035Floorbeam · corrodedTYS - DURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE CENTER OMEGA BEAM TOP CAP AT FRAME 15. MAINTENANCE REMOVED AND REPLACED THE TOP CAP IAW EMB SRM 51-40-02, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR C2XA04TY034Floorbeam · corrodedTYS - DURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE CENTER FLOORBEAM AT FRAME 20. MAINTENANCE ACCOMPLISHED A DOUBLER REPAIR IAW EMB SRM 53-21-10, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR 04FDEA00331Floorbeam · corrodedCORROSION ON FLOORBEAM AT FLOOR PANEL FASTENER HOLES BS 400 LBL 10 - RBL 10. REMOVED CORROSION IN A 1.0 X2.0 X .038 AREA. ORIG THICKNESS IS .125, TOP CHORD IS OUT OF LIMITS PER SRM 53-10-1. CUT-OUT DAMAGED UPPER CHORD PER SRM 53-10-8. FABRICATED CHORDSDR 04FDEA00330Floorbeam · corrodedCORROSION ON FLOORBEAM BS 360 LBL 17 - RBL 7 WL 208. FOUND CORROSION ON FLOORBEAM BS 360, LBL 17 TO RBL 17 WL 208 TO BE OUT OF LIMITS PER SRM 53-10-1. REPAIRED FLOORBEAM IAW SRM 53-10-8 FIG 8.SDR C2XA04TY031Floorbeam · corrodedDURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE FORWARD DIGITAL AT FRAME 23. MAINTENANCE REMOVED AND REPLACED THE DIGITAL IAW EMB SRM 51-40-02 AND CPM 51-21-04, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTIONSDR DHL2004806589Floorbeam · crackedFWD CARGO COMPT FLOORBEAM WITH 0.250 CRACK IN IT, STA 200.000 LBL 32 (MAJOR REPAIR). PERFORMED MAJOR REPAIR. REMOVED FASTENERS. CUT OUT FLOORBEAM DAMAGED AREA. INSPECTED FOR CRACKS IAW DC8 NDT SPM PART 6-10-01-001. FABRICATED 2EA ANGLE DOUBLER FWD/AFT (70SDR DHL2004806587Floorbeam · crackedMAIN CARGO COMPT FLOORBEAM CRACKED 0.250 AT STA 180.000 LBL 32. PERFORMED MAJOR REPAIR. REMOVED FASTENERS. TRIMMED OUT DAMAGED AREA ON FLOORBEAM. INSPECTED FOR CRACKS. NO CRACK FOUND. CLEANED, TREATED AND PRIMED AREA. FABRICATED ANGLE DOUBLERS 2EA (7075-
Back to JASC 5315