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 AALA980675Floorbeam · corrodedTUL - FOUND CARGO CEILING FLOORBEAM CORRODED LBL 24 TO LBL 48 AT STATION 1070. INSTALLED LOWER CHORD REPAIR ANGLE AND STRAPS, TWO LOCATIONS LBL 24 PER SRM 53-10-8 AND STRAP LBL 45 PER ESO. (M)SDR AALA980671Floorbeam · corrodedTUL - FOUND CORROSION ON TOP OF FLOORBEAM STATION 380 RBL 29-RBL 42 AND CORROSION ON TOP OF AND ON BOTTOM OF TOP FLANGE STATION 380 RBL 45 TO RBL 63. REPAIRED PER SRM 53-10-08 PAGES 9A AND 9B. (M)SDR 99ZZZM525Floorbeam · corrodedDV INSPECTION FLOORBEAMS AND SUPPORT STRUCT FRAME 41-44. ACCESS UNDER FLOOR THROUGH 181HL/181HR EVIDENCE OF LEAKAGE APPARENT UNDER TOILET/GALLEY, INSPECTION THROUGH 25 1AF/DF/EF/FF, 252AF/BF/CF/DF. SII REPORT FINDS FORM M046 (SII 53-30-154). PERFORMED DV INSDR SIMA980903Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THAT THE FLOORBEAM 38 WAS CORRODED OUT OF LIMITS. MAINTENANCE REPAIRED FLOORBEAM 38 IAW SRM 53-00-00 PAGE 498. A/C WAS RETURNED TO SERVICE. (M)SDR P2EA98095Floorbeam · corrodedQ-CHECK ITEM, FLOORBEAM CORRODED BEYOND LIMITS BETWEEN BS 967.5 AND 986.6, RBL 20 WL 208.1. REPAIRED FLOORBEAM BETWEEN BS 967.5 AND BS 986.6 RBL 20 PER BOEING FAX COO-SJO-98-0178RR DATED ON 3-1398. DOCUMENTED ON FAA FOR 8110-3. APPROVED AND SUBMITTED BY FAASDR AALA984060Floorbeam · corrodedAFW - WHILE IN FOR MBV MAINTENANCE FOUND TWO AREA OF CORROSION ON THE UPPER SURFACE OF THE UPPER FLANGE OF THE FLOORBEAM AT STATION 933 LBL 11. AFTER BLENDING, THE AREAS WERE DYE CHECKED SHOT/ROTO PEENED PER SRM 51-20-06. REFINISHED PER SRM AND FILLED WITH BSDR SWAA980435Floorbeam · crackedDURING SCHEDULED C2 CHECK, FOUND FLOORBEAM AT BS 520 CRACKED. REPAIRED PER BOEING SRM.SDR C2XA98IA092Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE FLOORBEAM AT FRAME 39 WAS FOUND TO BE CORRODED. MAINTENANCE REPAIRED THE FLOORBEAM USING A DOUBLER REPAIR IAW CONTINENTAL EXPRESS ENGINEERING CHANGE/REPAIR AUTHORIZATION EC5310-01032. THE AIRCRAFT WAS THEN APPROVED FOR RESDR C2XA98IA090Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, FRAME 38 FLOORBEAM WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOORBEAM IAW THE EMB SRM 53-61-40, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR CALA9800600Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 480, RBL 48. THE CORRODED AREA WAS REMOVED, A FLOORBEAM REPAIR WAS FABRICATED AND INSTALLED IAW SRM 53-10-8, FIGURE 1.SDR TWAA9807315Floorbeam · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND CORROSION BEYOND LIMIT ON FLOORBEAM CAP FROM STATION 196 TO 218 OBL. FABRICATED AND INSTALLED NEW BEAM CAP PER SRM 51-01 PAGE 1. (M)SDR SWAA980414Floorbeam · corrodedDURING SCHEDULED 1/4 D-CHECK, FOUND CORROSION UNDERNEATH FLOORBEAM NUT PLATE AT BS 429 RBL 8.5. REPAIRED PER BOEING SRM.SDR DL757980684Floorbeam · corrodedTHE UPPER CAP OF THE STA 1681.8 FLOORBEAM WAS FOUND CORRODED ALONG ITS ENTIRE LENGTH LBL 61.95 TO RBL 61.95. THE UPPER CAP WAS TRIMMED OFF AND AN EXTRUDED CAP INSTALLED IN ITS PLACE PER ER/A 364222-14, REV B.SDR 9808852284Floorbeam · corrodedDURING M-CHECK, FOUND CORROSION ON FLOORBEAM AT FS 1130, LBL 30, WL 208. REPAIRED PER EA 22-156532.SDR 9808842284Floorbeam · corrodedDURING M-CHECK, FOUND CORROSION ON FLOORBEAM AT FS 1130, LBL 24, WL 208. REPAIRED PER EA 22-156532.SDR SWAA980401Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 967, RBL 28, WL 208 ON UPPER AND LOWER SURFACE. REPAIRED PER BOEING SRM.SDR SWAA980399Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND SUPPORT BEAM AT BS 1010 LBL 34 WL 208, BS 959 RBL 18 WL 208, BS 995 LBL 18 TO BS 1004 LBL 7 WL 208 AND BS 957 RBL 25 WL 208 CORRODED AT FASTENER HOLE. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980398Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT 328, RBL 30, WL 208 CORRODED AT FASTENER HOLE LOWER SURFACE. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980397Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 986.5, LBL 45 TO RBL 50, WL 208 CORRODED ON UPPER AND LOWER SURFACES. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980396Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 947.5, WL 208, LBL 53 CRACKED AT FASTENER HOLE. REPAIRED PER BOEING SRM.SDR SWAA980392Floorbeam · corrodedDURING SCHEDULED 1/4 D-CHECK, FOUND CORROSION ON FLOORBEAM AT BS 947, RBL 48.5. REPAIRED PER BOEING SRM.SDR DL72S980700Floorbeam · corrosionON UPPER SURFACE OF FLOORBEAM STA 344 FROM LT O/B SEAT TRACK TO DOOR SILL FOUND CORROSION. INSTALLED NEW FLOORBEAM PER SRM 53-10-8 FIG 11.SDR AALA980614Floorbeam · corrodedTUL - PREVIOUS REPAIR CORRODING ON TOP OF FLOORBEAM AT STATION 400 RBL 10 TO 14 INCH. REMOVED DAMAGED AREA AND REPAIRED PER SRM 53-10-8. (M)SDR AALA980607Floorbeam · corrodedTUL - FOUND CORROSION ON TOP FLANGE OF FLOORBEAM STATION 420 RBL 55 TO RBL 60. REMOVED DAMAGE AND REPAIRED PER SRM 53-10-8. (M)SDR TWAA9807309Floorbeam · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND SURFACE CORROSION ON FLOORBEAM CAP AT FS 160 FROM OL-288. REPLACED FLOORBEAM CAP PER SRM 51-01, PAGE 1 ITEM 1C. SEALED PER SRM 91-20-0. (M)SDR EIAA980162Floorbeam · corrodedMZJ - DURING 'C4' CHECK INSPECTION, FLOORBEAM UPPER CHORD IS CORRODED AND CRACKED AT STATION 480 RBL 55-65. REPAIRED T-CHORD IAW SRM 51-40-04. (M)SDR CALA9800583Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT FS 1166 RBL 45. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED, A REPAIR WAS FABRICATED AND INSTALLED IAW SRM 53-10-8 AND 51-30-2.SDR CALA9800582Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT FS 1090, RBL 24. THE CORRODED AREA WAS CUT OUT, TWO ANGLES WERE FABRICATED AND INSTALLED IAW SRM 53-10-8, FIGURE 8.SDR SWAA980356Beam Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON CREASE BEAM WEB AT BS 440 TO 460, WL 208, RBL 69. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980351Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AROUND FLOORBOARD FASTENER HOLE AT BS 967, RBL 48, WL 208. REPAIRED PER BOEING SRM.SDR SWAA980348Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORRODED FASTENER HOLE AT BS 344, LBL 7. REPAIRED PER BOEING SRM.SDR P5CA9800725Floorbeam · corrosionLEVEL 1 CORROSION ON FLOORBEAM UPPER CHORD AT FUSELAGE BS 980 L2 TO R2. CORROSION REMOVED AND REPROTECTED PER SRM 51-10-01 AND 51-10-02.SDR AALA980574Floorbeam · corrodedTUL - FLOORBEAM IN AFT CARGO AT FRAME 56 HAS CORROSION BELOW ROLLER TRAY NR 6. REMOVED CORROSION PER SRM 51-74-10-2. REPAIRED PER ESO 30595 STEP A DATED 3-19-98. (M)SDR AALA980571Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM IN AFT CARGO AT FRAME 58 BELOW NR 6 ROLLER TRAY. REPAIRED PER ESO 30595 DATED 3-18-98, AFTER CORROSION REMOVED PER SRM 51-74-10-2. (M)SDR AALA980570Floorbeam · corrodedTUL - FOUND FLOORBEAM IN BULK CARGO HAS CORROSION AT FRAME 64 RT SIDE WALL TO NR 5 ROLLER TRAY. REPAIRED PER ESO 30595, DATED 3-18-98, AFTER CORROSION REMOVED PER SRM 51-74-10-2. (M)SDR USAA980128Floorbeam · corrosionCLT - DURING Q-6 VISUAL INSPECTION, FOUND CORROSION AT SCREW HOLES STATION 1016 BEAM IN LEFT LAV AREA. INSTALLED REPAIR STRAP REPAIR DOCUMENT SRM 53-00-51 FIG 203. (M)SDR USAA980127Floorbeam · corrosionCLT - DURING Q-6 VISUAL INSPECTION, FOUND CORROSION AT SCREW HOLES THE ENTIRE LENGTH STATION 986 FLOORBEAM. REPLACED T-CAP PER TYPICAL REPAIR NR 53-10-05. (M)SDR USAA980126Floorbeam · corrosionCLT - DURING Q-6 VISUAL INSPECTION, FOUND CORROSION ON THE UPPER SURFACE OF FLOORBEAM AT STATION 312 LBBL 11.0. CORROSION TASK NR C53-107-02. INSTALLED DOUBLER PER SRM 53-10-51. (M)SDR UPS98826466Floorbeam · corrodedINSPECTION TYPE-D, FS 1520 FLOORBEAM FWD SIDE HAS HEAVY CORROSION ON TANG LBL 59. REPAIRED IAW DHC SK-803-070.SDR SWAA980341Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CRACKED AROUND FASTENER HOLE AT BS 344, RBL 0 AND AT BS 344, RBL 1. REPAIRED PER BOEING SRM.SDR SWAA980340Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CRACKED AROUND FASTENER HOLE AT BS 344, LBL 9 AND AT BS 344, LBL 7. REPAIRED PER BOEING SRM.SDR CALA9800575Floorbeam · corrodedINSPECTION FOUND TOP FLANGE OF FLOORBEAM CORRODED AT FS 1110, RBL 10 TO RBL 63. THE CORRODED AREA WAS CUT OUT AND A REPAIR WAS FABRICATED AND INSTALLED IAW SRM 53-10-8.SDR CALA9800569Floorbeam · corrodedINSPECTION FOUND TOP FLANGE UPPER AND LOWER SURFACE OF FLOORBEAM CORRODED AT FS 360, RBL 10 TO LBL 18. THE CORRODED AREA WAS CUT OUT, A FLOORBEAM REPAIR WAS FABRICATED AND INSTALLED IAW SRM 53-10-8 AND 51-10-2.SDR CALA9800552Floorbeam · corrodedINSPECTION FOUND FLOORBEAM TOP FLANGE UPPER AND LOWER SURFACE CORRODED AT FS 360, RBL 10 TO LBL 10. THE CORRODED AREA WAS CUT OUT, A FLOORBEAM REPAIR WAS FABRICATED AND INSTALLED IAW SRM 53-10-8 AND 51-10-2.SDR C2XA98IA079Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, FOUND CAPTAINS SIDE FLOOR CORRODED AT SEAT ATTACHMENT AREA. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM IAW ATR-42 SRM 53-17-70/51-25-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR AALA980561Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM AT FRAME 67 BETWEEN TRAYS NR 1 AND NR 2. REMOVED AND REPLACED FLOORBEAM AT FRAME 67 BULK CARGO FLOOR BETWEEN TRAYS 1 AND 2 PER SRM 53-10-15. (M)SDR AALA980560Floorbeam · corrodedTUL - LARGE AREAS OF CORROSION BETWEEN FRAME 66 AND FRAME 69 LEFT SIDE OF BULK CARGO FLOORBEAM. REMOVED AND REPLACED BULK CARGO FLOORBEAM BETWEEN FRAME 66 AND 69 LEFT SIDE PER SRM 53-10-15. (M)SDR SWAA980336Floorbeam · damagedDURING SCHEDULED D-CHECK, FOUND FLOORBOARD FASTENER HOLE DRILLED BESIDE REPAIR FASTENER IN FLOORBEAM SPLICE AT BS 312, RBL 20.5, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR P2EA98062Floorbeam · corrodedSJO - Q-CHECK, AFT CARGO CMPT FLOORBEAM CORRODED BEYOND LIMITS, BS 787, BETWEEN BL 0 AND RIGHT BL 68.5. REPAIRED FLOORBEAM PER BOEING FAX COO-SJO-98-0191RR, DATED MARCH 16, 1998, AND SRM 53-10-9 FIG 2. FAA FORM 8110-3 APPROVED AND SUBMITTED BY FAA DER DESIGNSDR CALA9800493Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1110, RBL 12-36. THE CORRODED AREA WAS CUT OUT. A REPAIR WAS FABRICATED AND INSTALLED IAW SRM 53-10-08.
Back to JASC 5315