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 USAA970161Floor Beam · corrosionCLT - DURING 'C-4' CHECK VISUAL INSPECTION, FOUND CORROSION 100 INCHES BY 3 INCHES UPPER AND LOWER SURFACES ENTIRE LENGTH FLOOR BEAM, STA 1640. REMOVED AND REPLACED T-CAP AND INSTALLED DOUBLERS PER EA 59682. (X)SDR UPS97222930Floorbeam · corrodedINSPECTION TYPE-D, CORRISION ON SEVERAL AREAS OF FLOORBEAM STA 344 TOP CHORD. NEW TOP CHORD INSTALLED IAW SRM 51-30-2 AND INSTALLED DRAWING NR 6 5-16316.SDR RAAA97E8012Floorbeam · corrodedDURING ACCESS FOR SEAT TRACK REPAIR (RAAA97E8011) FOUND TRANSVERSE FLOORBEAM CORRODED AT FS 996 FROM RBL 45 TO RBL 63. REPLACED CORRODED SECTION AND REPAIRED TRANSVERSE FLOORBEAM PER SRM 51-3-7, FIG 1.SDR AWXA9700276Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON TOP CHORD OF FLOORBEAM BS 294.5 FROM RBL 16 TO RBL 46, WL 208. FABRICATED AND REMOVED AND REPLACED TOP CHORD OF FLOORBEAM BS 294.5, RBL 46 TO LBL 19 PER SRM 53-10-51, DETAIL 1.SDR USAA970156Floorbeam · corrodedINT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND .25 INCH BY .5 INCH CORRODED AREA WL 208.1 LBL 7 INCH BS 312 FLOORBEAM. INSTALLED REPAIR STRAPS, REPAIRED PER TR 5310-01A. CORROSION TASK NR C53-107-01, CORROSION LEVEL 1. (M)SDR USAA970155Floorbeam · crackedINT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND .25 INCH CRACK BS 709 WL 203.5 LONGITUDINAL FLOORBEAM WEB. CUTOUT DAMAGE, INSTALLED FILLER AND DOUBLER, REPAIRED PER SRM 51-40-2. (M)SDR USAA970154Floorbeam · crackedINT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND 1 INCH CRACK RBL 25, .5 INCH CRACK LBL 25, .5 INCH CRACK LBL 45, .5 INCH CRACK RBL 45 BS 520, WL 207.75 FLOORBEAM. STOP DRILLED, INSTALLED DOUBLER, REPAIRED PER EA 42309. (M)SDR USAA970150Floorbeam · crackedINT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND .5 INCH CRACK BS 668 LBL 24 INCH WL 205 FLOORBEAM WEB. INSTALLED DOUBLER, REPAIRED PER EA 42333. (M)SDR USAA970149Floorbeam · crackedINT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND 1 INCH CRACK LBL 24.5 STATION 676 FLOORBEAM. INSTALLED CHANNEL, REPAIRED PER EO 5791G632. (M)SDR USAA970144Floorbeam · corrodedINT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND CORROSION 14 INCHES STATION 328 LBL 51 TO LBL 27 FLOORBEAM UPPER CHORD. REPLACED T-CAP, REPAIRED PER TR 53-10-13. CORROSION TASK NR C53-107-01, CORROSION LEVEL 1. (M)SDR RRXA97160Floorbeam · corrosionDURING A MAINTENANCE VISIT, FOUND FLOORBEAM CORRODED PAST LIMITS IAW DC-8 SRM, AT Y=1440 AND X=-10.5. REMOVED AND TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW DER APPROVED ENGINEERING SKETCH C44-R13.SDR DHL9770159CFloorbeam · corrodedAT C-CHECK, CORROSION ON CABIN FLOORBEAM 804 LEFT O/B END ATTACH TO WING CENTER SECTION. REMOVED DAMAGED LOWER CHORD FROM FLOORBEAM, INSTALLED ANGLE AND STRAP REPAIR PER AVITAS EO DRAWING 97PMSI152D-5. REPAIR 6 BY 3 AND .75 BY 6 (STRAP).SDR ABXA9700926Floorbeam · corrodedDURING C-CHECK, FOUND THE FLOORBEAM AT F/STA 786 CORRODED AT LBL 27 ON TOP SIDE. REPAIRED IAW ABX REA D953-19248-MR.SDR AALA970784Floor Beam · crackedTUL - STA 294.5 FRAME (FLOOR BEAM) CRACKED 12 INCHES INBOARD FROM LEFT OUTBOARD SKIN TOP SIDE. REMOVED CRACKED SECTION OF EXTRUDED ANGLE AND SPLICED IN NEW SECTION PER SRM 51-40-4. 77,504 HOURS. CYCLES, 52,602. (X)SDR AALA970771Floor Beam · corrodedTUL - FLOOR BEAM CORRODED BL ZERO STA 1110. CUT OUT DAMAGED SECTION OF FLOOR BEAM AND INSTALLED REPAIR DOUBLER PER SRM 53-10-8. 77,504 HOURS. CYCLES, 52,602. (X)SDR RRXA97150Floorbeam · corrodedDURING A MAINTENANCE VISIT, FOUND CORROSION ON FLOORBEAM DAMAGE BEYOND LIMITS IAW DC-8 SRM, AT Y=920 AND X=+49.5. REMOVED CORROSION AND TREATED IAW DC-8 SRM. FABRICATED AND INSTALLED REPAIR IAW DER APPROVED ENGINEERING SKETCH C44-R19.SDR RRXA97151Floorbeam · buckledDURING A MAINTENANCE VISIT, FOUND FLOORBEAM BUCKLED, AT Y=1500 AND X=+4 TO X=+15. FABRICATED AND INSTALLED REPAIR IAW DER APPROVED ENGINEERING SKETCH C44-R20.SDR ABXA9700911Floorbeam · crackedDURING C-CHECK, FOUND FLOORBEAM AT FS 503 AND LBL 57 CRACKED. REPLACED FLOORBEAM IAW DC9 SRM.SDR 9712239615Floorbeam · corrodedDURING M-CHECK AND PRIOR TO ENTERING SERVICE, FOUND CORROSION ON FLOORBEAM UPPER CHORD FS 965, LBL 58 TO RBL 58. REPAIRED PER EA 99-100049.SDR UPS97823005Floorbeam · crackedINSPECTION TYPE:D, FLOORBEAM F/S 920 CRACKED ON LOWER FLANGE IN RADIUS AT LBL 68. REF UPS N/R 534617. REPAIRED IAW DHC SK-894-617 (REF UPS ENRG FILE NR DC8-53-1806).SDR AALA970809Floor Beam · corrodedAFW - FOUND AND BLENDED OUT CORROSION ON THE UPPER SURFACE OF THE CABIN FLOOR BEAMS. THE DAMAGE EXCEEDS SRM LIMITS. REMOVED FLOOR BEAM FROM STA 841 TO STA 876.8. SPLICED IN NEW SECTION OF FLOOR BEAM APPROVED BY ENGINEERING PER MRB 767-1393. TST: 44,482.55SDR 9716976642Floorbeam · corrodedDURING M-CHECK AND PRIOR TO SERVICE, FOUND CORROSION ON CONTROL CABIN FLOORBEAM FS 270, LBL 40. REPAIRED PER EA 66-150052.SDR AALA970803Floorbeam · corrodedAFW - FLOORBEAM AT STATION 310 RBL 42 HAD CORROSION BLENDED BEYOND SRM LIMITS, E58 NR 1692352. REPAIRED PER MRB, NR 7571136. (M)SDR AALA970801Floorbeam · corrodedAFW - FLOORBEAM AT STATION 324 RBL 44 AND RBL 60 HAD CORROSION BLENDED BEYOND SRM LIMITS E58 NR 1692354 AND 1692367. REPAIRED PER MRB NR 757-138. (M)SDR AALA970799Floorbeam · corrodedAFW - FLOORBEAM AT STATION 365 HAS CORROSION REMOVAL ON UPPER SURFACE. MATERIAL REMAINING IS BEYOND SRM LIMITS E58 NR 1692356 AND 1692544. REPAIRED PER MRB NR 757-1140. (M)SDR USAA970137Floor Beam · corrosionINT - DURING 'Q-5' CHECK VISUAL INSPECTION, FOUND 2 INCH BY 2 INCH CORROSION STA 312 RBL 10 FLOOR BEAM. INSTALLED T-CAP STA RBL 20 TO LBL 19. REPAIRED PER TYPICAL REPAIR MANUAL 53-10-03. CORROSION TASK NR: C53-107-02. CORROSION LEVEL: 2. (X)SDR AALA970804Floorbeam · corrodedAFW - FLOORBEAM AT 1640 HAS CORROSION REMOVAL ON UPPER SURFACE BEYOND SRM LIMITS E58 1692426 1692423 1692421. REPAIRED PER MRB NR 757-1135. (M)SDR 9716986642Floorbeam · crackedDURING M-CHECK AND PRIOR TO SERVICE, FOUND CRACK IN FLOORBEAM INTERCOSTAL AT FS 500 TO 510, RBL 6, WL 199. REPAIRED PER EA 66-123937.SDR CALA9700689Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1016. THE CORRODED AREA WAS REMOVED, A REPAIR WAS FABRICATED AND INSTALLED IAW SRM 51-30-2 AND 51-30-1.SDR AWXA9700251Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON UNDERSIDE OF TOP CHORD FLOORBEAM BS 967, RBL 5 TO 50. FABRICATED AND INSTALLED REPAIR PARTS IAW, ER 2-53-15-63, TCO-PAN-97-0655RR, 8110-3.SDR AWXA9700250Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON TOP AND UNDERSIDE OF TOP CHORD OF FLOORBEAM BS 987, LBL 12 TO RBL 50, WL 208. REPAIRED PER ER 2-53-15-63, TCO PAN 97-0655RR-8110-3.SDR 97ZZZM690Floorbeam · corrodedDURING C-CHECK INSPECTION, DISCOVERED CORROSION ON THE UPPER SURFACE OF THE UPPER FLOORBEAM CHORD BETWEEN BS 1450-1460, RBL 57.7. BLENDOUT OF CORROSION EXCEEDED SRM LIMITS AND REQUIRED TRIMMING TO REMOVE CORROSION. REINFORCEMENT REPAIR ANGLES AND FILLERS WERSDR CALA9700703Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 24 TO RBL 24. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-9.SDR 9712229615Floorbeam · corrodedDURING M-CHECK AND PRIOR TO ENTERING SERVICE, FOUND CORROSION ON FLOORBEAM AT FS 980, RBL 42. REPAIRED PER EA 99-100044.SDR AWXA9700257Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON TOP OF FLOORBEAM BS 1016, RBL 2 - LBL 37, WL 208. FABRICATED AND INSTALLED REPAIR PARTS PER ER 2-53-15-62, TCO-PAN-97-0652RR8110-3.SDR UPS97222543Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION ON FLOORBEAM STA 560 BL 0 WL 206 AND DADO CUT IN THE BEAM WEB AFT SIDE. REMOVED COMBINATION CORROSION AND GOUGE IAW SRM 51-10-6, CLEAN UP DEEMED OUT OF LIMITS IAW SRM 53-10-1, REPAIRED REWORK AREA IAW TRAMCO EWO 97-2129 UPS FILE SDR MWEA97267Floorbeam · corrodedDURING INSP, FLOORBEAM AT FS 237 LOWER FLANGE MODERATE CORROSION 6 IN FROM CUSP. REPAIRED IAW DAC TEL SVC-MSP-0134/ADJ 2/4/97.SDR MWEA97266Floorbeam · corrodedDURING INSP, FLOORBEAM AT FS 389 LOW FLANGE MODERATE CORR AROUND CONDUIT CLIP. REPAIRED IAW DAC TEL SVC-MSP-0134/AJC 2/4/97.SDR EIAA970117Floorbeam · crackedDURING C5/D INSPECTION, FOUND FLOORBEAM UPPER CHORD CRACKED, AFT CARGO BS 1820 RBL 46-RBL 50. FLOORBEAM UPPER CHORD REPLACED FROM RBL 40 TO RBL 60 PR SRM 51-10-01 PAGE 18. (M)SDR CALA9700640Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 312, LBL 11 TO RBL 12. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 53-10-51.SDR C2XA97IA140Floor Beam · crackedIAH - DURING C-CHECK INSPECTION, FLOOR BEAM AT FRAME 17 RIGHT WAS FOUND CRACKED. MAINTENANCE REPAIRED FLOOR BEAM IAW CONTINENTAL EXPRESS EC5310-01037, AND AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. ACFT TT 14,901.5 HOURS. CYCLES 17,366. (X)SDR CALA9700683Floorbeam · crackedINSPECTION FOUND A 1.5 INCH CRACK IN FLOORBEAM CHANNEL AT STA 807. THE CRACKED AREA WAS REMOVED, A NEW PART WAS FABRICATED AND INSTALLED IAW SRM 51-10-2, 53-10-2, AND 51-30-2.SDR CALA9700589Floorbeam · corrodedFLOOR SUPPORT BEAM UPPER CHORD HAS CORROSION BETWEEN BL 48 RT AND BL 58 RT AT STATION 380. CUT OUT DAMAGED AREA AND FABRICATED REPAIR IN ACCORDANCE WITH SRM 53-10-8.SDR AWXA9700244Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON FLOORBEAM UPPER CHORD AT BS 312, WL 208, LBL 11 TO RBL 11. REMOVED UPPER CHORD OF FLOORBEAM AT BS 312 FROM LBL 18 TO RBL 18 AND REPLACED CHORD PER SRM 53-10-9.SDR AWXA9700243Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON FLOORBEAM BS 328, RBL 11 TO 20, WL 208. REMOVED UPPER CHORD, FABRICATED REPAIR PARTS AND INSTALLED PER SRM 51-30-2, 51-30-5 AND 53-10-9, FIG 5.SDR 9708119101Floorbeam · crackedDURING L-CHECK, FOUND CRACK IN FLOORBEAM AT FS 503, RIGHT, PSE 53.09.016. REPAIRED PER EA 91-112350.SDR USAA970129Floorbeam · corrosionINT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND SEVERAL 1 INCH BY 2 INCH CORRODED NUT PLATE HOLES AT BS 986 FLOORBEAM BL 0 TO RBL 46. REMOVED CORRODED AREA, INSTALLED REPAIR PARTS AND COMPLETED REPAIR PER T/R 53-60-01. CORROSION TASK NR C53-107-02, CORROSIONSDR USAA970128Floorbeam · corrosionINT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND 1 INCH BY 2 CORRODED AREA BS 947 FLOORBEAM T-CAP LBL 12 INCHES. INSTALLED DOUBLER, REPAIRED PER TR 53-10-01A. CORROSION TASK NR C53-107-02, CORROSION LEVEL 2. (M)SDR USAA970127Floorbeam · corrosionINT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND 2 INCH BY 2 INCH CORRODED AREA BS 967 FLOORBEAM T-CAP NUTPLATE HOLES. FABRICATED NEW T-CAP, AND DOUBLERS, REPAIRED PER TR 53-60-02. CORROSION TASK NR C53-107-02, CORROSION LEVEL 2. (M)SDR USAA970126Floorbeam · corrosionINT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND .75 INCH DIAMETER CORROSION AT SCREW HOLES TOP OF FLOORBEAM BS 294 BL 0 TO RBL 52. CUT OFF UPPER CHORD AND INSTALLED T-CAP, REPAIRED PER SRM 53-10-51. CORROSION TASK NR C53-107-02, CORROSION LEVEL 2. (M)
Back to JASC 5315