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 05FDEA00350Floorbeam · corrodedCORROSION ON LOWER SIDE OF FLOORBEAM AT BS 1070, LBL 1 TO LBL 45, WL 200. WORK TO BE ACCOMPLISHED ON CUSTOMER CARD N01219SDR CALA0600166Floorbeam · corrodedINSPECTION FOUND LEFT O/B EDGE OF FLOORBEAM UPPER CHORD CORRODED AT BS 294.5, LBL 20. THE CORRODED SECTION OF UPPER CHORD WAS REMOVED AND A NEW CHORD WAS SPLICED IN IAW ECRA 5310-04463.SDR 72300144Floorbeam · corrodedA 1 X 35 INCH AREA OF CORROSION ON FLOORBEAM FLANGE.SDR SWIA200514690Floorbeam · crackedCARGO PIT FLOOR SUPPORT ANGLE CRACKED AT FS 621 LBL 41. ITEM FOUND AT C-CHECK INSPECTION. FLOOR SUPPORT ANGLE REPAIRED IAW CRJ REO 601R-53-61-117 REV B.SDR 2005UALA00205Floorbeam · corrodedFLOORBEAM STA 1640, RBL 44- 48 CORRODED. DAMAGED FLOOR BEAM WAS REMOVED AND A REPAIR USING SPLICE STRAPS AND ANGLES WAS INSTALLED.SDR 2005UALA00203Floorbeam · corrodedCABIN FLOORBEAM HAS CORROSION ON UPPER TEE CAP STA 324, RBL 46 - 59. TRIMMED TEE CAP AND INSTALLED ANGLE AND STRAP REPAIR FOR TEE CAP SPLICE.SDR 05FDEA00338Floorbeam · corrodedBS 720D, RBL 4, WL 208 CORROSION ON FLOORBEAM. REPAIRED PER SRM 53-10-8SDR MALA050246Floorbeam · corrodedDURING C2 CHECK IN YYC FOUND FR 43 FLOORBEAM 20 INCHES LBL GUSSET CORRODED. MAT'L .100 INCH THICK 2024T3 AL SHEET.SDR MALA050245Floorbeam · corrodedDURING C2 CHECK IN YYC FOUND FRAME 43, 5 INCHES LBL GUSSET CORRODED ON FLOORBEAM. MAT'L .100 INCH THICK 2024T3 AC SACLT.SDR 2005UALA00197Floorbeam · dentedAFT PIT FLOOR TEE CHORD FLANGE DENTED AT STA 1780 AND RBL 48. DENT MEASURES 0.5 LONG BY 0.5 WIDE BY 0.06 5 INCH DEEP.SDR ASAA0580144Intercostal · crackedHV - CHECK - FLOORBEAM INTERCOSTAL IS CRACKED. REPLACED INTERCOSTAL. (K)SDR 0500429755Floorbeam · corrodedDURING H-CHECK FOUND CORROSION ON FLOORBEAM AT BS 794 RBL 57 TO RBL 60. REPAIRED PER EA 97-202515.SDR AALA20050218Floorbeam · corrodedAFW - FLOORBEAM AT STATION 325 (GENERAL LOCATION SECTION 41) HAS CORROSION REMOVAL ON UPPER SURFACE. MATERIAL REMAINING IS BEYOND SRM LIMITS. AREA IS 1.0 INCH BY 1.0 INCH WITH A DEPTH OF .026 INCHES. COMPLETELY REMOVED CORROSION AND ENSURED BLEND AREA WAS CSDR 2005UALA00190Floorbeam · corrodedFLOORBEAM AT STA 324 RBL 40 CORRODED. DAMAGED AREA OF FLOORBEAM WAS REMOVED AND REPAIR PARTS FABRICATED AND INSTALLED.SDR CALA0500067Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312, RBL 21, RBL 36, AND RBL 49. THE FLOORBEAM UPPER CHORD WAS REMOVED AND REPLACED IAW SRM 53-00-51.SDR CALA0500062Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED IN E&E COMPARTMENT ON RT SIDE ABOVE AIRFONE CONTROL BOX AT STA 312, RBL 21. THE FLOORBEAM UPPER CHORD WAS REMOVED AND REPLACED IAW SRM 53-00-51.SDR CALA0500061Floorbeam · crackedINSPECTION FOUND A 1.625 INCH CRACK IN FORWARD GALLEY FLOORBEAM WEB AT STA 312, RBL 18. THE WEB WAS REPAIRED IAW ECRA 5310-04462.SDR CALA0500060Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT AFT FLANGE OF UPPER CHORD, STA 986, LBL 14 TO LBL 18. THE CORRODED AREA WAS CUT OUT AND ANGLES WERE INSTALLED IAW SRM 53-60-51.SDR SIMA200506603Gusset · corrodedSAW - DURING CPCP INSPECTION MAINTENANCE, FOUND THE GUSSET OVER LEFT OUTBOARD FLOORBEAM BETWEEN FRAMES 16-17 HAS CORROSION. INSTALLED NEW GUSSET IAW SRM 51-40-02. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR 0500499870Floorbeam · crackedDURING H-CHECK FOUND CRACK IN FLOORBEAM AT BS 674 LBL 5. REPAIRED PER EA 98-202520.SDR ASAA0540149Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM AT FASTENER HOLE STA B344, LBL 25, WL 208. REPAIRED IAW SRM 53-00-51, FIG 203. (K)SDR SWIA200514689Floorbeam · crackedCARGO PIT FLOOR SUPPORT ANGLE CRACKED AT FS 621.00 RBL 42.0. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED DAMAGE TO FLOOR SUPPORT ANGLE, FS 621,IAW CRJ REO 601R-53-61-117 REV B.SDR SWIA200514683Floorbeam · crackedMAIN FUSELAGE FS 280 RBL 9.0 LOWER FLANGE CRACKED ON TRANSVERSE BEAM. ITEM FOUND AT C-CHECK INSPECTION. CRACKED FLANGE REPAIRED IAW CRJ REO 601R-53-11-171 REV A.SDR SWIA200514682Floorbeam · crackedMAIN FUSELAGE FS 280 LBL 9.0 LOWER FLANGE CRACKED ON TRANSVERSE BEAM. ITEM FOUND AT C-CHECK INSPECTION. CRACKED FLANGE REPAIRED IAW CRJ REO 601R-53-11-171 REV A.SDR SWIA200514681Attach Fitting · crackedFS 280 LEFT FLOORBEAM LBL 9.0 INBOARD ATTACH CLIP CRACKED. ITEM FOUND AT C-CHECK INSPECTION. CLIP TO BE REPAIRED ON 2192818 IAW CRJ REO 601R-53-11-171 REV A.SDR 72300185Floorbeam · corrodedA 1 X 1 INCH AREA OF CORROSION ON FLOORBEAM UPPER CHORD.SDR 2005FA0000486Floorbeam · crackedRIGHT DIVAN FLOOR ATTACH ANGLE P/N 2411395-26-526 CRACKED IN RADIOUS OF BEND 14 INCHES LONG. DISCOVERED WHILE PERFORMING CABIN PRESURE LEAK TEST.SDR SWIA200515058Floorbeam · crackedFS 621 LT FLOORBEAM ANGLE AT LBL 41 IS CRACKED, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED FLOOR SUPPORT ANGLE IAW CRJ REO 601R-53-61-117 REV B.SDR SWIA200515057Floorbeam · crackedMAIN FUSELAGE; FLOORBEAM AT RBL 9.0 HAS OB ATTACH ANGLE CRACKED AT FS 280.00, 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.SDR USAA050304Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 101 INCH BY 2 INCH, STATION 312 ENTIRE T-CAP. INSTALLED NEW SECTION OF FLOORBEAM IAW SRM 53-10-51. (M)SDR USAA050335Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 8 INCHES, STATION 312. CORROSION LEVEL 1, TASK C53-107-01. REMOVED AND REPLACED PER SRM AND IPC 53-4200 FIG 2. (M)SDR USAA050302Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY 101 INCHES, STATION 344 ENTIRE T-CAP. INSTALLED NEW SECTION OF FLOORBEAM PER SRM 53-10-51. (M)SDR USAA050303Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 10.9 INCHES BY 2 INCHES, STATION 328 ENTIRE T-CAP. INSTALLED T-CAP REPAIR PER SRM 53-10-51. (M)SDR USAA050301Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCH BY 78 INCH AREA OF CORROSION, STATION 294 ENTIRE T-CAP. INSTALLED NEW SECTION OF FLOORBEAM PER SRM 53-10-51. (M)SDR 2005UALA00183Floorbeam · corrodedCORROSION ON FWD LT CABIN FLOORBEAM AT STA 294.5 LBL 37-53. ACCOMPLISHED. BLENDED OUT DAMAGE AND INSTALLED ANGLE/STRAP REPAIR.SDR EIA2005023Floorbeam · crackedBS 420 LBL 43 UPPER DECK FLOORBEAM WEB HAS CRACK AT UPPER T-CHORD AREA. REMOVED DAMAGED SECTION OF WEB AND REPAIRED PER B747 SRM 53-10-07 PG 47-50 FIG II. BONDED WEB AND DOUBLER FOR STA 420 LBL 34-54 PER BAC 5514-5101 BOEING DRAWING 65B10931 SHEET 75 AND B74SDR EIA2005028Floorbeam · crackedBS 420 UPPER FLOORBEAM TOP CHORD AT RBL 57 AND OUTBOARD HAS NUMEROUS (5) FASTENER HOLES WITH CRACK INDICATIONS (RBL 57.75, 58.25, 63, 67.5, AND 89.5). REMOVED AND REPLACED STA 420 FLOORBEAM UPPER CHORD DUE TO NUMEROUS CRACK INDICATIONS PER SERVICE BULLETIN 74SDR SIMA200505602Floorbeam · corrodedTHE GALLEY AREA FORWARD DIGITAL WAS FOUND CORRODED. BLENDED THE AREA TO REMOVED CORROSION AND PERFORMED NDT INSPECTION. FABRICATED A REPAIR DOUBLER. REPAIR DONE IAW EMB 145 REPAIR STATEMENT IC2005-145/0923 DATED FEB 21, 2005. (M)SDR CALA0500050Floorbeam · corrodedINSPECTION FOUND AFT ENTRY FLOORBEAM CORRODED AT FASTENER HOLES, STA 986.5, LBL 54 TO RBL 54. REPAIRED IAW ECRA 5310-04461.SDR 375PA0040Floorbeam · crackedAFT CARGO FLOOR PANEL SUPPORT ANGLE CRACKED AT NUT PLATE AT BS 727D +7 AT LBL 7. REPAIRED PER SRM 53-00-53.SDR 375PA0029Floorbeam · corrodedCORROSION ON FLOORBEAM T-CAP AT BS 312 AT LBL 19. REPAIRED PER SRM 53-10-51.SDR 375PA0028Floorbeam · corrodedCORROSION ON FLOORBEAM T-CAP AT BS 344 FROM LBL 19 TO LBL 30. REPAIRED PER SRM 53-10-51.SDR 2005UALA00169Floorbeam · corrodedCABIN FLOORBEAM CORRODED AT BS 1640, RBL 42-57. DAMAGE CAUSED BY TYPICAL FLOORBEAM CORROSION. FLOORBEAM CAP REPAIRED WITH ANGLE AND FILLERS.SDR 2005UALA00166Floorbeam · corrodedCABIN STA 324 FLOORBEAM CORRODED BETWEEN RBL 38 AND RBL 44. TYPICAL FLOORBEAM CORROSION DAMAGE IN THE WET AREAS. FLOOR BEAM T-CAP WAS CUT AND REPAIRED USING ANGLES, FILLERS, AND A STRAP.SDR USAA050324Floorbeam · corrodedPIT - FOUND BEAM WITH CORROSION 48 INCH LONG SEVERAL AREAS, FS 312, UPPER CAP FLOORBEAM. CORROSION LEVEL 1, TASK C53-107-01. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 53-10-51, FIG 205. (M)SDR 2005UALA00168Floorbeam · corrodedCABIN LT FLOORBEAM CORRODED FROM STA 680-740 LBL 60-LBL64.SDR AWXA200500284Floorbeam · corrodedSAL - MAJOR REPAIR - DURING BC-4 CHECK FOUND EXFOLIATION CORROSION ON FLOORBEAM Y1292 AT FR 66+3 INCHES. MAINTENANCE REMOVED CORRODED SECTION OF FLOORBEAM Y1292 FROM FR 66+3 INCHES TO FR 64; FABRICATED A NEW REPLACEMENT SECTION OF FLOORBEAM; INSTALLED REPAIR SDR AWXA200500281Floorbeam · corrodedSAL - MAJOR REPAIR - DURING BC-4 CHECK, EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y1190 AT FS 68. MAINTENANCE REMOVED CORRODED FLOORBEAM Y1190 FROM FS 67 -5" TO FS 68 +3". FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11SDR AWXA200500280Floorbeam · corrodedSAL - MAJOR REPAIR - DURING BC-4 CHECK, EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y1292 AT FR 68 -3". MAINTENANCE REMOVED CORRODED FLOORBEAM Y1292 FROM FS 68 -3" TO FS 69. FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11SDR AWXA200500279Floorbeam · corrodedSAL - MAJOR REPAIR - DURING BC-4 CHECK, EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM -Y1292 AT FS 66+3". MAINTENANCE REMOVED CORRODED FLOORBEAM -Y1292 FROM FS 64" TO FS 66+5", FABRICATED A NEW REPLACEMENT FLOORBEAM, INSTALLED REPAIR PART IAW A320 SRM 51-72-11
Back to JASC 5315