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 2004UALA01189Floorbeam · dentedAFT PIT FLOOR SUPPORT STRUCTURE AT STA 1800 HAS DENT AT RBL 22.0. CARGO OPERATIONS PERIODICALLY CAUSES STRUCTURAL DAMAGE IN THE SUPPORT FRAMES. STANDARD REPAIR.SDR SWAA043557Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LT CREASE BEAM BETWEEN BS 400 AND BS 420, CORRODED. REMOVED AND REPLACED CREASE BEAM SECTION PER EA.SDR SWAA043548Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 312, LBL 2, CORRODED. REMOVED AND REPLACED FLOORBEAM CHORD PER SRM.SDR ASA0440247Floorbeam · corrodedFOUND CORROSION FUSELAGE UPPER LOBE, FLOORBEAM UPPER FLANGE IS CORRODED. REPLACED FLOORBEAM. (M)SDR ASA0440248Floorbeam · corrodedFOUND CORROSION FUSELAGE UPPER LOBE, FLOORBEAM UPPER FLANGE IS CORRODED. REPLACED FLOORBEAM. (M)SDR ASA0440246Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM UPPER FLANGE. REPAIRED PER SRM. (M)SDR SWIA200414528Floorbeam · crackedRIGHT SIDE FS 621.00 CRACKED. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED -2 ANGLE, -6 ANGLE, -6 STRAP AND -302 ANGLE PER CRJ 200 REO 601R35-61-117.SDR SWIA200414527Floorbeam · crackedFLOORBEAM AT STA 280 RBL 9.1 CRACKED ON INBOARD AND OUTBOARD SIDES OF FLOORBEAM WEB, AND AT LEFT OUTBOARD. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED NEW SUPPORT ANGLES IAW CRJ 200 SRM 51-42-06 FIG 8, 51-42-21 FIG 10.SDR SWIA200414526Floorbeam · crackedLEFT INBOARD FS 280 BRACKET IS CRACKED. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED NEW ANGLE PER CRJ 200 SRM 51-42-06 AND 51-42-20.SDR A6WA200440199Floorbeam · crackedTHE LT AND RT SIDE UNDER FLOORBEAM STRUCTURE IS CRACKED AT FSL73, LBL40 AND RBL40. REMOVED CRACKED AREA AND INSTALLED REPAIR PARTS IAW REO.SDR 04FDEA03333Floorbeam · corrodedBULK CARGO FLOOR STRUCT RT SIDE FS 64 TO 67 FLOOR STRUCTURE W/MULTIPLE CORRODED FROM TOP TO UNDERNEATH SURFACE. REMOVED AND REPLACED TEE PROFILE AT FS 63 TO FS 67 RBL 37 RT IAW A310 SRM 51-40-21.SDR SWIA200414599Floor Support · corrodedFRAME 34-38, STR 15R, RIGHT FLOOR SUPPORT CORRODED. ITEM FOUND AT C-CHECK INSPECTION. FLOOR SUPPORT REPLACED IAW EMB 120 SRM 51-40-02.SDR SWIA200414585Floorbeam · damagedFUSELAGE FR38 BETWEEN CENTER AND T-PROFLIE IS DAMAGED. ITEM FOUND AT C-CHECK INSPECTION. REPLACED T-PROFILE IAW EMB SRM 51-22-00, 51-40-02.SDR SWIA200414584Floorbeam · corrodedLEFT FLOOR SUPPORT IS CORRODED AT FRAME 16, STR 15. ITEM FOUND AT C-CHECK INSPECTION. REPLACED FLOOR SUPPORT IAW SRM 51-25-00, 51-40-06, AND 51-40-02.SDR SWIA200414583Floorbeam · chafedLEFT FLOORBEAM BUTTSTRAP HAS CHAFING MARKS AT FRAME 16. ITEM FOUND AT C-CHECK INSPECTION. REPLACED BUTTSTRAP IAW EMB 120 SRM 51-40-02, 51-25-00, 51-22-00.SDR SIMA200434212Gusset · corrodedDURING CPCP INSPECTION, FOUND GUSSET ON FLOORBEAM AT FRAME 20, ABOVE STRINGER 18L, HAS CORROSION. REPLACED GUSSET AT FR 20 IAW SRM. AIRCRAFT WAS RETURNED TO SERVICE.(K)SDR C1HA200493024Floorbeam · corrodedAFT PIT LOWER SIDE OF CABIN FLOORBEAM STA 1090 FROM LBL 60 TO RBL 60 CORRODED NUMEROUS PLACES WHERE RUBITEX TAPE WAS REMOVED. INSTALLED FRAME REPAIR, EA-05-53, MINOR.SDR C1HA200493025Floorbeam · corrodedAFT PIT LOWER SIDE OF CABIN FLOORBEAM STA 1070 FROM LBL 60 TO RBL 60 CORRODED NUMEROUS PLACES WHERE RUBITEX TAPE WAS REMOVED. INSTALLED REPAIR STRAP PER EA 10700, MAJOR.SDR C1HA200493023Floorbeam · corrodedAFT PIT LOWER SIDE OF CABIN FLOORBEAM STA 1148 FROM LBL 60 TO RBL 60 CORRODED NUMEROUS PLACES WHERE RUBITEX WAS REMOVED. INSTALLED REPAIR STRAP, EA-10720, MAJOR.SDR C1HA200493022Floorbeam · corrodedAFT PIT LOWER SIDE OF CABIN FLOORBEAM STA 1130 FROM LBL 60 TO RBL 60 CORRODED NUMEROUS PLACES WHERE RUBITEX TAPE WAS REMOVED. INSTALLED REPAIR STRAP, EA-10703, MAJOR.SDR C1HA200493020Floorbeam · corrodedAFT PIT LOWER SIDE OF CABIN FLOORBEAM STA 1110 FROM LBL 60 TO RBL 60 CORRODED NUMEROUS PLACES WHERE RUBITEX TAPE WAS REMOVED, EA-10705, MAJOR.SDR SWAA043492Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 967, RBL 28, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR 0402095529Floor Support · corrodedDURING H-CHECK FOUND CORROSION ON FLOOR SUPPORT AT BS 365 RBL 45.5. REPAIRED PER EA 55-201141.SDR SIMA200434204Floorbeam · corrodedDURING AN IMBV INSPECTION FOUND THE GALLEY FORWARD DIGITAL WAS FOUND TO BE CORRODED. REMOVED A SECTION OF GALLEY AREA FORWARD DIGITAL. FABRICATED 2 REPAIR DOUBLERS AND SHIMS. REPAIR DONE IAW SRM. (K)SDR USAA040986Floorbeam · corrodedCLT - C-4 - FLOORBEAM, 9 INCH AREA, CORROSION AT STA 324, RBL 43-49. REPLACED T-CAP SECTION IAW EA.SDR C1HA200493019Floorbeam · corrodedCABIN FLOORBEAM STA 1160 LBL 20 TO RBL 20 CORRODED TOP SIDE EA-10698, MAJOR.SDR SWAA043477Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 1016, LBL 6, CORRODED. REMOVED AND REPLACED FLOORBEAM CHORD SECTION PER SRM.SDR 2004UALA01165Floorbeam · corrodedFLOORBEAM AT STA 365 BL0 TO RBL15 CORRODED. REMOVED CORROSION AND INSTALLED FLOOR BEAM REPAIR.SDR SWAA043461Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EACH CRACKS ON FLOORBEAM WEB AND FLOORBEAM UPPER CAP AT CENTER FLOORBEAM, BS 663.75. REPAIRED FLOORBEAM CHORD AND UPPER CAP PER ER.SDR 04FDEA03249Floorbeam · crackedDURING AIRPLANE'S CONVERSION FROM P-F/ACF FOUND CRACK ON FLOORBEAM DIM 3 INCH AT STA 1293 X= -107. REPLACE FLOORBEAM IAW DWG AEA 0361.SDR DHL2004873561Floorbeam · crackedAFT CARGO COMPT FLOORBEAM CRACKED 0.500, STA 1160.000 L-26R TO L-27R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG 1. REMOVED CRACKED FLOORBEAM IAW SRM 51-1-20D PG 21, SRM 51-1-21 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLEDSDR USAA041018Floorbeam · corrodedBFM - S1 CK - FLOORBEAM, 3 INCH X 2 INCH X .040 INCH DEEP; CORROSION; LEVEL 2; TASK NR JA-260-53500 FR 66, Y765 CABIN FLOOR STRUCTURE. REMOVED AND REPLACED BEAM IAW SRM 53-00-14, 51-42-11.SDR 2004UALA01163Stiffener · crackedSTATION 246 FLOORBEAM AT APPROX LBL 11, STIFFENER IS CRACKED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. REPLACED STIFFENER.SDR 2004UALA01162Stiffener · crackedSTATION 246 FLOORBEAM AT APPROX LBL 2, STIFFENER IS CRACKED. REPLACED STIFFENER.SDR SWAA043455Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FRAME AT BS 616, FLOORBEAM LT ATTACH POINT CRACKED. REPAIRED FRAME SECTION PER SRM.SDR USAA041074Floorbeam · corrodedPIT - Q5 - BEAM, 10 INCH L X 1 INCH WIDE, CORROSION; LEVEL 1; TASK NR C53-107-01, FLOORBEAM SCREW HOLES, STA 312, LBBL 13 TO RBBL13. 22 INCH REPAIR ANGLE WITH 10 INCH X 1 INCH W FILLER IAW SRM. (K)SDR MALA040838Floorbeam · corrodedDURING C-CHECK INSPECTION IN YYC, FWD CABIN FLOORBEAM AT FRAME 18 AND SEAT TRACK 3 (RT IB) UPPER FLANGE EDGE AND GUSSET PLATE CORRODED. MAINTENANCE REPAIRED IAW EO A53224. AIRCRAFT RETURNED TO SERVICE 11/23/04.SDR MALA040840Floorbeam · crackedDURING C-CHECK INSPECTION IN YYC, FWD CABIN FLOORBEAM AT FRAME 18 CRACKED AT RBL 20 & RBL 40. REFER TO 409, 226105 FOR ADDITIONAL DETAIL. AIRCRAFT RETURNED TO SERVICE 11/23/04.SDR MALA040837Floorbeam · corrodedDURING C-CHECK INSPECTION IN YYC, FWD CABIN FLOORBEAM AT FRAME 18 AND SEAT TRACK 4 (RT O/B) UPPER FLANGE EDGE AND GUSSET PLATE CORRODED. MAINTENANCE REPAIRED IAW EO A53224. AIRCRAFT RETURNED TO SERVICE 11/23/04.SDR DHL2004873522Floorbeam · corrodedAFT CARGO COMPT FLOORBEAM FLANGE CORRODED AT STA FS 1360.000 LBL 47 TO LBL 50 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 1G TR 53-124. REMOVED CORROSION IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS IAW SRM 53-2-0 PG 2P. FABRICATED REPAIR ANSDR ASAA0410597Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM AT FASTENER HOLE UPPER AND LOWER SURFACE OF UPPER FLANGE. REPLACED STUB BEAM. (M)SDR ASAA0410575Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM UPPER FLANGE. REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0410571Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM ON TOP OF LWR FLANGE LWR SURFACE. REPAIRED IAW EA.SDR ASAA0410570Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM ON TOP OF LWR FLANGE AROUND NUTPLATE. REMOVED CORROSION AND REPAIRED FLOORBEAM.SDR ASAA0410604Floorbeam · corrodedPAE - FOUND CORROSION LOWER FLOORBEAM. REPAIRED TRANSVERSE BEAM PER EA. (M)SDR C1HA200493003Floorbeam · corrodedFS 1090 FLOORBEAM IS CORRODED FROM LBL 35 TO LBL 63. SRM REPAIR MAJOR.SDR F3LA200400115Floorbeam · damagedDURING C-6 CHECK, INSPECTION REPORTED FLOORBEAM WEB AT STA 294 DAMAGED FROM ELEVATOR CABLE. INSTALLED REPAIR PER EA B3-53R-10584 ON WEB OF FLOORBEAM AT STA 294.SDR C1HA200493002Floorbeam · corrodedCORROSION ON MAIN CABIN FLOORBEAM T-CAP AT STA 1030, LBL 12 TO RBL 12. SRM REPAIR MAJOR.SDR CALA0400723Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 328, LBL 29 TO RBL 58. THE FLOORBEAM UPPER CHORD WAS REPLACED IAW SRM 53-10-51.SDR SWIA200414352Floorbeam · crackedCRACKED SUPPORT ANGLE AT FS 625 NEAR STR 14L. ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLE BRACKET PER CRJ 200 SRM 51-42-06 PG 11 & 51-77-00 PG 1.
Back to JASC 5315