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 05FDEA01911Floorbeam · corrodedAT STA 1821 ALONG LBL 10 TO LBL 25.5 FLOORBEAM STRUCTURE FOUND CORRODED. DISCREPANT FLOOR SUPPORT REMOVED, NEW FLOOR SUPPORT REWORKED FROM S2929169X7075T6511 AS PER DRAWING AGA 3814 AND INSTALLED AS PER SRM 51-31-01 VOL II. CLASSIFIED MINOR AS PER GMM 6SDR 05FDEA01910Floorbeam · corrodedAT STA 1821 ALONG LBL 38.5 TO LBL 65 FLOORBEAM STRUCTURE FOUND CORRODED. REMOVED AND REPLACED. NEW FLOOR SUPPORT REWORKED IAW DWG AGA 7028. NEW SUPPORT PAINTED, PART MARKED AND INSTALLED IAW SRM 51-35-01 VOL.II. CLASSIFIED MINOR REPAIR AS PER GMM 6-2-100.SDR EIA2005139Floorbeam · damagedFLOORBEAM WEB REPAIR BUCKLED AT STA 280 RBL 45. REPAIRED FLOORBEAM WEB STA 280 RBL 45 PER ECRA 487-53-010-2.SDR AWXA200500902Floorbeam · corrodedSAL - DURING C4 CHECK DISCOVERED CORROSION ON FLOORBEAM LOCATED AT +Y1180 AND BETWEEN FR 66+4" AND FR 68-5". MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-00-14 FIG 102. MAINTENANCE REMOVED FLOORBEAM AT +Y1180 AND BETWEEN SDR AWXA200500879Floorbeam · corrodedDURING C4 CHECK, DISCOVERED CORROSION ON FLOORBEAM Y-254, FROM FS 16 TO FS 19. MAINTENANCE REMOVED CORRODED SECTION OF FLOORBEAM AT Y -254, FROM FS 16 TO FS 19 IAW AIRBUS SRM 53-11-14 FIG 202. PREPARED NEW FLOORBEAM FOR INSTALLATION IAW AIRBUS SRM 53-11-14 ASDR CALA0500218Floorbeam · corrodedAFT GALLEY FLOORBEAM CORRODED AT SEVERAL AREAS UNDER NUT PLATE AREA AT STA 986.5, LBL 54 TO RBL 54. REPAIRED FLOORBEAM IAW ECRA 5321-01246.SDR UPS05844985Floorbeam · corrodedINSPECTION TYPE: C1, CORROSION ON FLOORBEAM AT STA 60 RBL 45. REMOVED DAMAGE ON UPPER TEE CAP OF FLOORBEAM, FABRICATED AND INSTALLED REPAIR IAW SAA SK 851-857217.SDR CALA0500215Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT STA 967, RBL 38 TO LBL 0. REPLACED FLOORBEAM UPPER CHORD IAW ECRA 5311-01231.SDR UPS05845117Floorbeam · corrodedINSPECTION TYPE:C1 FLOORBEAM CORRODED AT STA 55 BL 0, FWD SIDE, SEEN FROM A/C COMPARTMENT. REMOVED CORROSION IAW SRM 51-2-1 FIG 1 SHEET 7. FABRICATED REPAIR ANGLE DOUBLER AND FILLER IAW SRM 53-07-03 FIG 006A, AND 51-02-00-0 FIG 050. INSTALLED FILLER AND ANGSDR SWIA200515384Floorbeam · crackedFS 280 CABIN FLOOR TRANVERSE BEAM LOWER FLANGE CRACKED, ITEM FOUND AT C-CHECK. REPAIRED BEAM IAW CRJ REO 601R-53-11-171 REV "B".SDR PIDA20050078Floorbeam · corrodedBS 986 FLOORBEAM HAS CORROSION AT LBL 20 TEE CHORD. REPAIRED FLOORBEAM T-CAP AT LBL 20 PER SRM 53-10-9.SDR PIDA20050079Floorbeam · corrodedBS 1016 FLOORBEAM HAS CORROSION FROM LBL 3 TO LBL 10. REPAIRED FLOORBEAM UPPER CHORD FROM LBL 3 TO LBL 10 PER EA 53-172.SDR USAA050854Floorbeam · corrodedPIT - FOUND BEAM CORRODED .5 INCH BY 3 INCH AREA, FLOORBEAM Y254 BETWEEN CROSSBEAMS C-16 AND C-20. REMOVED AND REPLACED WITH NEW PART PER SRM 53-11-14 FIG 202. CORROSION LEVEL 1, TASK JA-222-53500. (M)SDR USAA050855Floorbeam · corrodedFOUND FLOORBEAM CORRODED 21 HOLES WITH 1 INCH OF CORROSION, FRAME 66-68 FLOORBEAM Y1292. REMOVED AND REPLACED PER SRM 53-00-15 FIG 201. (M)SDR USAA050859Floorbeam · corrodedPIT - FOUND FLOORBEAMS CORRODED .5 INCH DIAMETER AROUND 12 NUTPLATES, STATION Y1292 FRAME 66-68. REPLACED FLOORBEAM SECTIONS FROM FRAME 64-70 PER SRM 51-72-11. (M)SDR USAA050861Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1 INCH BY .75 INCH, FRAME 68 Y 254. REMOVED OLD FLOORBEAM AND INSTALLED NEW PER AIRBUS DWG 18D53472780. (M)SDR SWAA051986Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 712, LBL 25, WL 203. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA052002Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 35 TO RBL 39, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR SIMA200519315Floorbeam · corrodedTHE GALLEY AREA FORWARD DIGITAL PREVIOUS REPAIR WAS FOUND CORRODED. REMOVED THE EXISTING REPAIR, BLENDED THE DAMAGE AREA OF THE FORWARD DIGITAL TO REMOVE THE CORROSION FABRICATED A REPAIR DOUBLER. REPAIR DONE IAW SRM. (K)SDR ASOA05586Floorbeam · corrodedDURING A C-CHECK IN MCN, THE FS 280 FLOOR SUPPORT ANGLE BETWEEN LBL 9 AND RBL 9 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE FS 280 FLOOR SUPPORT ANGLE BETWEEN LBL 9 AND RBL 9. (M)SDR USAA050841Floorbeam · corrodedCLT - FOUND FLOORBEAM TEE CAP CORRODED 1 INCH, AT BS 986.5, LBL 31. REMOVED AND REPLACED UPPER T-CAP OF FLOORBEAM IAW TYPICAL REPAIR 53-10-05, SRM 53-00-51. (M)SDR SWAA051982Floorbeam · corrodedDURING SCHEDULED 5Y CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 767, BETWEEN LBL 12.0 TO RBL 7.5. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA051943Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, BETWEEN LBL 45 & RBL 45. REPAIRED FLOORBEAM PER BFG ER.SDR SIMA200519312Floorbeam · corrodedTHE FORWARD DIGITAL WAS FOUND TO BE CORRODED. REMOVED THE CORRODED FORWARD DIGITAL. INSTALLED NEW DIGITAL IAW SRM. (K)SDR SWAA051942Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, LBL 15 TO LBL 35, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA051941Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 986, LBL 17 TO RBL 50, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR COMA0570079Floorbeam · corrodedTRANSVERSE BEAM AT FS 280 FROM LBL 36 TO RBL 36. CORRODED ALONG UPPER AND LOWER EDGES. REPLACED TRANSVERSE BEAM AT FS 280 IAW BOMBARDIER REO 670-53-11-047 REV C.SDR SWAA051921Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND CABIN LONGITUDINAL FLOORBEAM CRACKED AT BS 663, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR USAA050824Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1.5 INCH BY 1.5 INCH, STATION 312 RBL 10. NEW TEE CAP INSTALLED IAW SRM 53-10-01, AND SRM 53-00-51. (M)SDR AWXA200500823Floorbeam · corrodedDURING C16 CHECK DISCOVERED CORROSION ON THE TOP OF FLOORBEAM, UPPER CHORD AT BS 294, BL 16.7, AND WL 208, WAS PREVIOUS BLEND OUT. AFTER REMOVAL OF CORROSION, MAINTENANCE FOUND CORROSION TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-10-51-1 FIG 101. REMOVED SDR SWIA200515829Floorbeam · crackedCARGO COMPARTMENT FS 621 LHS FLOOR SUPPORT ANGLE CRACKED, ITEM FOUND AT C CHECK INSPECTION. REPAIRED ANGLE IAW CRJ REO 601R53-61-117 REV "C".SDR SWIA200515827Floorbeam · crackedFOUND FS 280 RT FLOORBEAM INBD AND OB ANGLES RBL 9.0 CRACKED, ITEM FOUND AT C CHECK INSPECTION. REPLACED ANGLES IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-23-00, 51-21-11.SDR SWIA200515826Floorbeam · crackedFOUND FS 280 LT FLOORBEAM OB ATTACH ANGLE LBL 9.0 CRACKED, ITEM FOUND AT C CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-23-00.SDR ASAA0540330Floorbeam · corrodedYXX - AFT CARGO PIT FLOOR SUPPORT BEAM TIE DOWN TRACK HAS CORROSION FORWARD OF BS 947 LBL 18. REPAIRED IAW 737-400 SRM 53-00-53 FIG 209. (M)SDR UPS05844893Fitting · crackedFLOORBEAM VERT ATTACH FITTING CRACKED STA 64 RBL 48. REMOVED CRACKED FITTING AND REPLACED IAW DC-8 SRM 51-1-21D.SDR PIDA20050075Floorbeam · corrodedBS 294 FLOORBEAM HAS CORROSION FROM LBL 28 TO RBL 45 AT FASTENER HOLES. REPAIRED FLOORBEAM PER SRM 53-10-9.SDR ASOA05553Floorbeam · corrodedDURING A C-CHECK, THE FORWARD AND AFT FLOOR SUPPORT ANGLES AT FS 280 BETWEEN LBL 9 AND RBL 9 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE FORWARD AND AFT FLOOR SUPPORT ANGLES AT FS 280 BETWEEN LBL 9 AND RBL 9 IAW EO. (K)SDR USAA050799Floorbeam · corrodedFOUND FLOORBEAM CORRODED 48 INCHES LONG BY 2 INCHES WIDE BY .035 INCH DEEP, 2.5 INCHES LONG BY 2 INCHES WIDE BY .033, FLOORBEAM, BS 328, RBL 12 INCHES-50 INCHES AND LBL 50 INCHES. FABRICATED PARTS, INSTALLED NEW T-CHORD AND REPAIR ANGLE PER SRM 53-00-51, FIG SDR USAA050797Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 2 INCHES BY 36 INCHES, Y765 PLUS FRAME 66-70. REPLACED FLOORBEAM PER SRM 51-72-11 TYPICAL 51-40-01. CORROSION LEVEL 1, TASK JA-260-53500. (M)SDR USAA050792Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED .5 INCH BY .75 INCH, Y1292 FRAME 64-67. DEFECTIVE PART REPLACED WITH IDENT PART. (M)SDR USAA050787Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1.5 INCH BY 4 INCHES, CABIN FLOORBEAM Y1292 AT FRAME 18. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-42-00, 51-43-00, 51-72-11. CORROSION LEVEL 1, TASK JA-220-53500. (M)SDR SIMA200518606Floorbeam · corrodedFLOORBEAM AT STA 225.0 WAS FOUND CORRODED. PERFORMED A CUT OUT TO REMOVE THE CORROSION. FABRICATED A FILLER, DOUBLER AND 2 SHIMS. REPAIR DONE IAW SRM. (K)SDR SIMA200518605Floorbeam · corrodedTHE GALLEY FLOOR FRAME AT STA 272 WAS FOUND CORRODED. BLENDED THE DAMAGED AREA TO REMOVE THE CORROSION. FABRICATED A REPAIR DOUBLER. REPAIR DONE IAW SRM. (K)SDR 05FDEA01664Floorbeam · corrodedCORROSION ON FLOORBEAM LBL 10, BS 560. REPAIRED PER SRM 53-10-8.SDR PIDA20050104Floorbeam · corrodedFLOORBEAM IN AFT CARGO BIN AT RBL 5 HAS CORROSION AROUND NUT PLATE HOLE AT BS 787. REPAIRED DAMAGED AREA OF UPPER LEG PER SRM 51-40-3.SDR UPS05444809Floorbeam · deformedINSPECTION TYPE:C . AFT CARGO - STA 1580 BL 0 FRAME UPPER CHORD DEFORMED. AFT CARGO BAY, BS 1580 LBL 16 TO RBL 16 FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG 2 REF NRC NR 6699.SDR CALA0500205Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED ON UNDERSIDE OF UNDER ANCHOR NUT ATTACH PLATE AT BS 1681, LBL 52. REPAIRED IAW ECRA 5320-01781.SDR SIMA200518607Floorbeam · damagedTHE CARGO FLOOR FRAME AT STA 710.0 WAS FOUND BENT IN 2 AREAS. RECONTOURED BOTH DENTS. FABRICATED AND INSTALLED 2 DOUBLERS AND 2 ANGLES. REPAIR DONE IAW SRM. (K)SDR UPS05444822Floorbeam · corrodedINSPECTION TYPE:C. U/D BS 400 RBL 11-14 FLOORBEAM UPPER CHORD FOUND SLIGHT CORROSION. CORROSION BLEND OUT 0.038 BY 0.5 BY 2 IN. EXCEED SRM 53-10-01 FIG 1 LIMITS, U/D FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG 1 AT BS 400 RBL 7 - 18"AREA.SDR UPS05444818Floorbeam · corrodedINSPECTION TYPE:C. U/D, BS 400, RBL 0-6 FLOORBEAM UPPER CHORD FOUND SLIGHTLY CORRODED. CORROSION BLEND OUT 0.040 BY 0.875 BY 1.5 IN. EXCEED SRM 53-10-01 FIG 1 LIMITS, FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG 1.
Back to JASC 5315