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 SWAA042728Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM FWD FLANGE UNDERSIDE AT BS 986 LT AFT GIRT BAR MOUNT, CORRODED. REPAIRED FLOORBEAM FLANGE PER SRM.SDR 371PA0078Strap · corrodedSTRAP ON PREVIOUS BLEND OUT ON FLOORBEAM AT BS 328 AT LBL 12 HAS CORROSION. REMOVED STRAP AND REPAIRED FLOORBEAM PER SRM 53-10-51.SDR 371PA0054Floorbeam · corrodedFLOORBEAM AT BS 344 HAS CORROSION FROM LBL 40 TO RBL 20. REPAIRED IAW SRM 53-10-51.SDR CALA0400642Floorbeam · corrodedINSPECTION FOUND UPPER FLANGES OF FLOORBEAM CORRODED AT BS 720. THE FLOORBEAM WAS REPAIRED IAW SRM 51-40-05.SDR 371PA0083Floorbeam · corrodedFLOORBEAM AT BS 967 CORRODED AT LBL 18. REPAIRED IAW SRM 53-00-51.SDR USAA040602Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 130 INCHES, FS 365.25 ENTIRE FLOORBEAM. REPLACED TEE CAP PER TR 53-15-01. (M)SDR USAA040605Floorbeam · corrodedCLT - FOUND FLOORBEAM ANGLE CORRODED 2 INCHES, STATON 397 RBL 26-28. REPLACED ANGLE IAW SRM 51-10-02. (M)SDR USAA040606Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH, STATION 345 LBL 02. REPAIRED T-CAP PER SRM 53-00-51. (M)SDR 2004UALA00877Floorbeam · corrodedCABIN FLOORBEAM CAP IS CORRODED AT BS 365 FROM RBL 28 TO RBL 42. TYPICAL CORROSION FOUND ON EXISTING STRAP REPAIR. STRAP REPAIR WAS REMOVED, CORROSION CLEANED, AND STRAP REPAIR REPLACED.SDR 04FDEA02713Floorbeam · corrodedAFT PIT STA 1902 FLOOR SUPPORT FRAME T-CAP CORRODED UPPER SURFACE. REMOVED FRAME T-CAP IAW DC10 SRM 51-35-01 VOL 2. CORROSION OUT OF LIMITS IAW FEDEX DC10 SRM 53-00-01 VOL I, PG 8. MATERIAL FOR T-CAP ANGLE IS 7075-T6 .063 P/O 353160.4 IAW DC 10 SRM 53-16-01SDR 04FDEA02712Floorbeam · corrodedAFT PIT STA 1902, 20 LBL TO 20 RBL FLOOR SUPPORT FRAME CORRODED TOP SIDE OF T-CAP. REMOVED FRAME T-CAP IAW DC10 SRM 51-35-01 VOL 3, FOUND TO BE OUT OF LIMITS IAW DC10 SRM 53-00-01 VOL I. REMOVED DAMAGE IAW DC10 SRM 53-00-01 VOL I. FAB FILLER DOUBLER IAW DC1SDR COMA0460522Floorbeam · crackedCARGO FLOOR CAP CRACKED. IAW SRM 51-42-06, 51-42-13, 51-42-21 AND 51-42-26.SDR 04FDEA02698Floorbeam · crackedFWD CARGO FLOORBEAM STRUCTURE FR33 NOTED INDICATION OF CRACK. REMOVED DAMAGED AREA IAW A310 SRM 53-10-15, AND REPAIRED BY INSTALLING A DOUBLER IAW A310 SRM 53-10-15.SDR 04FDEA02693Floorbeam · crackedBULK CARGO COMPT FLOOR STRUCTURE ON FR67 AT RT SIDE CORNER UNDERNEATH NOTED CRACK. REMOVED AND REPLACED BEAM IAW A310 SRM 51-40-21.SDR 04FDEA02689Floorbeam · corrodedAFT CARGO COMPARTMENT, BETWEEN FR 54 AND 54.2, FLOOR STRUCTURE RT SIDE, 3 AREAS OF CORROSION ON CLIP NUTS HOLE TOP AND UNDERNEATH SURFACE. REMOVED CORROSION IAW A310 SRM 51-74-10, AND FOUND TO BE WITHIN LIMITS IAW A310 SRM 53-10-15, TREATED PRIMED AND TOP COASDR F3LA200400097Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED FLOORBEAM BETWEEN STA 294.5 AND 312, 10.5 INCHES FROM CENTER LT, CORRODED AT STA 312 END. REMOVED UPPER T-CHORD ON FLOOR SUPPORT AT LBL 10.5, STA 294.5 THRU 312, AND INSTALLED NEW UPPER T-CHORD IAW SRM 51-40-02.SDR F3LA200400096Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED FLOORBEAM AT STA 328 CRACKED 20 INCHES IN FROM FUSELAGE OUTER SKIN. VERTICAL ANGLE CRACKED ON LOWER END LT. REPLACED SHEAR TIE AT LBL 45 ON FWD SIDE OF STA 328 FLOORBEAM PER SRM 51-40-02, 51-40-05 AND SOPM 20-41-02.SDR F3LA200400095Floorbeam · corrodedDURING C-4 CHECK, INSPECTED REPORTED FLOORBEAM AT STA 967, LBL 42, CORRODED AT FLOOR PANEL SCREW NUT PLATE. FOUND FLOORBEAM TO BE CORRODED BEYOND LIMITS PER SRM 53-60-51. REMOVED DAMAGED AREA, FABRICATED REPAIR SECTION AND REPAIR PARTS AND INSTALLED PER SRM SDR F3LA200400094Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED FLOORBEAM AT STA 967, RBL 27.16, CORRODED AT FLOOR PANEL SCREW NUT PLATE. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53-00-51, FIG 202.SDR USAA040683Floorbeam · corrodedPIT - FOUND FLOORBEAM T-CAP CORRODED, STATION 344, LBL 12 TO RBL 12, 10 PERCENT OF .080 INCH REMOVED, THREE AREAS .020 INCH DEEP. CORROSION LEVEL 1, TASK NR C53-107-01. INSTALLED NEW T-CAP PER SRM 53-10-51. (M)SDR 371PA0082Floorbeam · corrodedFLOORBEAM AT BS 967 CORRODED ON THE AFT SIDE AT RBL 18. REPAIRED FLOORBEAM IAW SRM 53-00-51.SDR 371PA0075Floorbeam · corrodedFLOORBEAM AT BS 312 FROM RBL 9 TO LBL 34 HAS CORROSION. REPAIRED IAW SRM 51-10-51 AND SRM 53-10-51.SDR 371PA0052Floorbeam · corrodedFLOORBEAM AT BS 986 HAS CORROSION AT CLIP NUT HOLES FROM LBL 36 TO RBL 36. REPAIRED PER SRM 53-00-51.SDR SWAA042682Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CHORD AT BS 947, LBL 54, CORRODED. REMOVED AND REPLACED CHORD SECTION PER ER.SDR 371PA0068Floorbeam · corrodedFLOORBEAM AT BS 946 HAS CORROSION AT CLIP NUT HOLES FROM LBL 18 TO RBL 18. REPAIRED PER SRM 53-00-51 AND SRM 53-60-51.SDR P5CA0401195Floorbeam · crackedBULK CARGO COMPT FLOORBEAM CRACKED. REMOVED & REPLACED DAMAGED AREA.SDR SWAA042664Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 663, RBL 25, CRACKED. REPAIRED FLOORBEAM PER EA.SDR SWAA042662Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 668, LBL 25, CRACKED. REPAIRED FLOORBEAM PER EA.SDR SWAA042657Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAM AT BS 727B, LBL 24, CRACKED. REPAIRED FLOORBEAM PER ER.SDR F3LA200400093Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED TOP OF FLOORBEAM AT STA 294.5 CORRODED IN SEVERAL SPOTS FROM 10 INCHES LEFT OF CENTER TO 40 INCHES RT OF CENTER. ALL SCREW HOLES IN THIS AREA CORRODED. SCRATCH ON TOP OF BEAM RT SIDE, 12 INCHES FROM CENTER TO WALL. REPASDR C1HA200497011Floorbeam · corrodedFLOORBEAM STA 1230 LBL 15 - RBL 24 IS CORRODED AROUND FASTENER HOLES. REPAIRED FLOORBEAM LBL 15 TO RBL 24.SDR C1HA200497007Floorbeam · corrodedFLOORBEAM STA 1230 LBL 15 - RBL 24 IS CORRODED AROUND FASTENER HOLES. REPAIRED FLOORBEAM LBL 15 TO RBL 24.SDR SWAA042653Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CHORD AT BS 294.5, LBL 12, CORRODED. REMOVED AND REPLACED FLOORBEAM CHORD SECTION PER SRM.SDR SWAA042652Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CHORD AT 328, LBL 12, CORRODED. REMOVED AND REPLACED FLOORBEAM CHORD SECTION PER SRM.SDR 2004UALA00886Floorbeam · corrodedMAIN CABIN STA 1641 AND RBL 26 TO CENTER LINE, PREVIOUS FLOORBEAM REPAIR CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED ANGLES, STRAP AND BEAM SECTION.SDR ASAA0410394Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBAM UPPER CHORD. REPAIRED FLOORBEAM UPPER CHORD AFT FLANGE. (M)SDR SWAA042641Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CHORD AT BS 312, RBL 20 TO LBL 20, CORRODED. REMOVED AND REPLACED FLOORBEAM CHORD SECTION PER SRM.SDR CALA0400633Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER FLANGE CORRODED AT STA 986.5, LBL 45 TO RBL 45. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND A NEW SECTION OF FLOORBEAM WAS INSTALLED IAW SRM 53-00-51, FIGURE 202 AND ECRA 5310-03851.SDR GAIA04163Floorbeam · damagedDURING C-CHECK INSPECTION FOUND MAIN CABIN FLOOR SUPPORT AT BS 760, BL0 TO LBL20 DAMAGED. REF FASI NR 87006, REPLACED FLOOR SUPPORT PN 65-25589-5 IAW SRM 51-30-2.SDR GAIA04153Floorbeam · mismanufacturedDURING C-CHECK INSPECTION FOUND CABIN FLOORBEAM IS NOT IAW DWG NR 2902. REF FASI NR 86793 REMOVED AND REPLACED FLOORBEAM IAW DWG NR 2902 AND SRM 53-10-2, FIG 7.SDR SWIA200414085Floorbeam · crackedCRACKED ANGLES AT FS 280, LBL 9 AND EIE RBL 9.00. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED ANGLE AT FS 280 LBL 9 UNDER FLOOR IAW SRM 51-42-06.SDR SWIA200414084Angle · crackedLEFT AND RIGHT ANGLES ON 625 BULKHEAD STRINGER 13L & 13R CRACKED. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED ANGLES PER CRJ 200 SRM 51-40-11 PG 1, 53-61-17 PG 2.SDR ASOA04762Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAMS AT FS 39, STRINGERS 14L AND 14R AND AT FRAME 40, STRINGERS 14L AND 14R WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAMS AT FRAME 39, STRINGERS 14L AND 14R AND AT FRAME 40, STRINGESDR ASOA04761Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM AT FRAME 36 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FRAME 36 IAW SRM 51-25-01. (M)SDR ASAA0410391Floorbeam · corrodedPAE - FOUND CORROSION BOTTOM LOWER LOBE OF FLOORBEAM. REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED. (M)SDR AWXA200401056Floorbeam · corrodedDURING BC-4 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y765 RT AT FR 68. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y765 RT FROM FR 66 TO FR 70; FABRICATED A NEW REPLACEMENT SECTION OF BEAM; INSTALLED REPAIR PART IAW SRM 51-42-11, FIG. 9-18.SDR AWXA200401054Floorbeam · corrodedDURING BC-4 CHECK, EXFOLIATION CORROSION WAS FOUND ON BEAM Y1732 RT AFT OF FS 65. MAINTENANCE REMOVED CORRODED BEAM Y1732 RT AT FS 65; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-42-11, FIG 2-3, 8, 10-11, AND 18.SDR AWXA200401053Floorbeam · corrodedDURING BC-4 CHECK, EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 RT AT FS 68. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y1292 RT FROM FS 68 TO FS 69; FABRICATED A NEW REPLACEMENT SECTION OF BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR AWXA200401052Seat Track · corrodedDURING BC-4 CHECK, EXFOLIATION CORROSION WAS FOUND ON RAIL Y1292 RT AT FS 66. MAINTENANCE REMOVED CORRODED SECTION OF RAIL Y1292 RT AT FS 66; FABRICATED A NEW REPLACEMENT SECTION OF RAIL; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR AWXA200401050Floorbeam · corrodedDURING BC-4 CHECK, EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 RT ON FORWARD SIDE OF FS 67. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y1292 RT ON FORWARD SIDE OF FS 67; FABRICATED A NEW REPLACEMENT SECTION OF BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-7
Back to JASC 5315