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 UPS06246833Floorbeam · corrodedINSPECTION TYPE:C CORROSION AROUND ANCHOR NUT ON FLOORBEAM AFT CARGO STA 1148. CORROSION FOUND OUT OF LIMITS AT ABOVE AREA IAW SRM 51-10-01. CUTOUT MADE IAW SRM 53-10-08. HFEC CARRIED OUT IAW B727-NDTM PT6 51-00-00 FIG 4. REPAIR COMPLETED IAW SRM 53-10-08.SDR SWAA061273Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND COCKPIT FLOORBEAM UPPER CHORD CORRODED AT BS 259.5, BETWEEN LBL 11 TO RBL 11, WL 208. REPAIRED FLOORBEAM PER SRM.SDR TRAX200600057Floorbeam · crackedFOUND STA 280 AFT FLOORBEAM ANGLE IS CRACKED OB OF LBL 9 TWO PLACES. REPAIRED IAW REO 601R-53-11-1002.SDR CALA0600133Floorbeam · corrodedCORROSION ON FLOORBEAM 967 LBL 5. INSTALLED REPAIR STRAP PER SRM 53-00-51, FIG 201.SDR UPS06846857Floorbeam · crackedFOUND MAIN CABIN APPROX STA 880 L22R RBL 57 FLOORBEAM CRACKED APPROX 4" FROM LIGHTNING HOLE TO FASTENER. CUT FLOORBEAM AT STA 879 RBL 49.03, FABRICATED AND INSTALLED -1,-2 -3,-4 REPAIR ANGLES, AND FLOORBEAM EXTRUSION IAW UPS RAA DC8-53- 20546, SAA EA# 008-532SDR QXEA200601180Floorbeam · damagedPDX: AFT CARGO FLOOR PANEL SUPPORT T-CLIP AT STA X726.0, Y32.0R Z100.0 HAS 3 SHEARED RIVETS AT SUPPORT FRAME. MAINTENANCE REPAIRED IAW Q400 SRM 51-42-05.SDR QXEA200601174Floorbeam · corrodedPDX: WARDROBE FLOORBEAM, INBOARD AND OUTBOARD, HAVE CORROSION FORMING AT FLOOR ATTACH POINTS. MAINTENANCE REPAIRED IAW Q400 TASK 51-21-00-350-801, DRAWING 85300727, TASK 51-42-05-330-001, SUBTASK 51-21-10-380-01, SRM 51-14-00, SRM 51-42-05, NDTM PART 1, 51-00SDR 2006UALA00675Floorbeam · corrodedFLOORBEAM AT BS 986 CORRODED ON UPPER T-CAP & GOUGED AT RBL 24-48. REMOVED DAMAGED TEE CAP FROM RBL 24 TO OUTBD END. FABRICATED REPLACEMENT CAP AND INSTALLED NESTED ANGLE CHORD SPLICES ON FWD & AFT SIDE OF BEAM REF MM53-10 -95 REPAIR X1X.SDR 2006UALA00674Floorbeam · gougedCABIN FLOORBEAM UPPER CAP HAS A DEEP GOUGE COMING OUT OF FWD HOLE AT STA 520 RBL 24.75. NESTED ANGLE REPAIR INSTALLED PER MM 53-10-95 RPR NR 6.SDR ASAA0610445Floorbeam · corrodedFOUND FLOORBEAM CORRODED. REPLACED FLOORBEAM PER EA 5310 02602 AND ERO 5606.SDR ASAA0610435Floorbeam · corrodedFOUND FLOORBEAM CORRODED. REPAIRED PER SRM 53 10 1 FIG 1 AND 51 30 7 REF NRC 4926376.SDR ASAA0610428Floorbeam · corrodedFOUND FLOORBEAM CORRODED. REPAIRED FLOORBEAM PER SRM 51 30 02 AND ASA EA 5310 02601SDR ASAA0610420Floorbeam · corrodedFOUND FLOORBEAM IS CORRODED. REPLACED UPPER FLOORBEAM PER EA 5310 02602.SDR ASAA0610441Floorbeam · crackedFOUND FLOORBEAM CORRODED. REPLACED FLOORBEAM IAW EA 5310 02602 AND ERO 5606.SDR C2XA06SH045Floorbeam · corrodedSHV - DURING C-CHECK THE CENTER OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAMES 24 AND 29. MAINTENANCE REMOVED THE DAMAGED AREA AND INSTALLED A DOUBLER REPAIR IAW EMB 145 SRM 53-00-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 06FDEA1363Keelbeam · corrodedSTA 1030 - 1050 STR 29R HAS CORROSION ON STR FLANGE.SDR C2XA06TY018Floorbeam · corrodedTYS DURING A 2C INSPECTION THE FLOOR CENTER AISLE BEAM IN THE GALLEY WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE CENTER OMEGA BEAM, TOP CAP AND RAMP ANGLE IN THE GALLEY IAW EMB 145XR 51-40-02. ALL WORK WAS ACCOMPLISHED AND A/C WAS RELEASED TO SESDR SWAA061218Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 967, RBL 27.5. REPAIRED FLOORBEAM PER SRM.SDR SWAA061214Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 947, RBL 1. REPAIRED FLOORBEAM PER SRM.SDR SWAA061177Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 947, LBL 4. REPAIRED FLOORBEAM PER SRM.SDR SWAA061176Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 328, RBL 36. REPAIRED FLOORBEAM PER SRM.SDR SWAA061174Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER FLANGE CORRODED AT BS 772, LBL 7. REPAIRED FLOORBEAM PER SWA EA.SDR CALA0600110Strap · corrodedINSPECTION FOUND CABIN FLOORBEAM STRAP ON TOP TEE CORRODED. THE CORRODED AREA WAS REMOVED AND A NEW STRAP WAS INSTALLED IAW SRM 51-40-02.SDR QXEA200601178Floorbeam · corrodedPDX: AFT CARGO COMPARTMENT FWD FLOOR - AFT FLOOR SUPPORT ANGLE CORROSION APPROX X788 AND YL7-YL14. MAINTENANCE REPAIRED IAW Q400 SRM 51-21-00, SRM 51-14-00, SRM 51-21-10 AND SRM 51-25-10.SDR SWAA061196Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FLOORBEAM UPPER CHORD CORRODED AT BS 328, BETWEEN LBL 36 TO RBL 60. REPAIRED UPPER CHORD PER SRM.SDR CA060406007Floorbeam · corroded(CAN) CORROSION FOUND ON FWD FLANGE OF FLOORBEAM AT BS 807 RBL 56 AND REPAIRED IAW CUSTOMER EA. (TC NR 20060406007)SDR CA060406006Floorbeam · cracked(CAN) BS 1016 AND STR17L WEB TO FLOOR ATTACH ANGLE CRACKED AND REPAIRED IAW EA AND SRM. (TC NR 20060406006)SDR F3LA200600012Floorbeam · corrodedDURING C3 CHECK, INSPECTION REPORTED SURFACE CORROSION ON FLOORBEAM AFT OF FRAME 66 AND FORWARD OF FRAME 68 (10" INBD OF L2 DOOR CUTOUT) AT OR NEAR CLIPNUTS AT FS 66. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-42-11 AND EA A9-53R-11343.SDR F3LA20060012Floorbeam · corrodedDURING C3 CHECK, INSPECTION REPORTED SURFACE CORROSION ON FLOORBEAM AFT OF FRAME 66 AND FORWARD OF FRAME 68 (10" INBD OF L2 DOOR CUTOUT) AT OR NEAR CLIPNUTS AT FS 66. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-42-11 AND EA A9-53R-11343.SDR 2006UALA00650Floorbeam · corrodedFOUND FLOORBEAM AT STA 947 CORRODED FROM RBL 29 TO RBL 39. BLENDED CORRODED AREA. ACP NDT FOR CRACKS BLEND OUT OF LIMITS. FABRICATED & INSTALLED NESTED ANGLE REPAIR ON AFT SIDE OF FRAME REF. MM 53-10-95.SDR SWAA061161Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOOR BEAM CORRODED AT BS 663, BL 0. REPAIRED FLOOR BEAM PER SWA EA.SDR SWAA061160Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 772, LBL 12. REPAIRED FLOORBEAM PER SWA EA.SDR KCSA061107Floorbeam · corrodedFOUND MAIN DECK FLOORBEAM UPPER CHORD IS CORRODED AT STA 400, LBL 16 TO 53.SDR DHL2006801535Floorbeam · misdrilledUPPER CARGO COMPT FLOORBEAM UPPER FLANGE MISDRILLED HOLE STA 857.125 LBL 37.5. PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 03-28-06, EO# AST060304 DATED 03-16-06. REMOVED FASTENERS IAW SRM 51-1-21, SRM 51-1-20D. CUT OUT DAMAGED SECTION IAW EO# AST06030SDR USAA060572Floorbeam · corrodedFOUND FLOORBEAM CORRODED, STA 1016 RBL 8. REMOVED AND REPLACED PANS CHANNEL AND TWO STRAPS IAW SRM 53-00-01, DEFECT SIZE: .50".SDR USAA060575Floorbeam · corrodedFLOORBEAM STA 1010 RBL 12 CORRODED. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-10-02, DEFECT SIZE: 1 X 3 INCH.SDR 061099Floorbeam · crackedFOUND UPPER DECK FLOORBEAM UPPER CHORD CRACKED AT BS 480, RBL 62.SDR 061098Floorbeam · misdrilledFOUND UPPER DECK FLOORBEAM HAS DOUBLE DRILLED HOLE AT BS 640, LBL46.SDR AWXA200600713Floorbeam · corrodedMCN - DURING C11 CHECK DISCOVERED CORROSION ON THE CABIN FLOORBEAM AT BS 1640, FROM BL 11R TO BL 60R, WL 208. MAINTENANCE REMOVED CORROSION AT BS 1640, FROM BL 11R TO BL 60R, WL 208 IAW BOEING 757-200 SRM 53-00-51-1A1 FIG 101. CORROSION FOUND OUT OF SRM LIMISDR USAA060566Floorbeam · corrodedFLOORBEAM Y-254 AT FR 18 CORRODED. FABRICATED REPAIR PART PER SRM 53-00-14, FIG 201; CORRODED TASK JA-220-53500; LEVEL 1, DEFECT SIZE: 1 X 1 INCH.SDR KCSA061094Floorbeam · crackedMAIN DECK FUSELAGE FRAME TO FLOORBEAM ATTACH ANGLE CRACKED AT BS 2220, STR 26L.SDR SWAA061141Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE FLOOR BEAM UPPER T-CAP CORRODED AT BS 986, BETWEEN LBL 45 TO RBL 45. R&R UPPER T-CAP PER SWA EA.SDR SWAA061131Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 730B, LBL 3. REPAIRED FLOORBEAM PER SWA EA.SDR USAA060537Floorbeam · corrodedSTA 967 AND RBL 37 CORRODED. FABRICATED STRAP REPAIR AND INSTALLED PER SRM 53-00-51, DEFECT SIZE: .25 INCH.SDR CALA0600104Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 325, LBL 25 TO 55. REPAIRED IAW SRM 53-00-51, FIGURE 201, REPAIR 1.SDR 06FDEA1285Floorbeam · corrodedBULK CARGO FLOOR STRUCTURE BEAM AT FR. 66 CENTER TOP BEAM HAS EXFOLIATED CORROSION MEASURING 2 INCH BY 3 IN. REMOVED AND REPLACED FLOORBEAM IAW A310-200 SRM 51-72-10SDR 061086Floorbeam · corrodedFOUND UPPER DECK FLOORBEAM AT BS 600 UPPER CHORD CORRODED RBL 3 TO LBL 63.SDR KCSA061088Floorbeam · corrodedFOUND UPPER DECK FLOORBEAM AT BS 540 CORRODED BL 0.0 TO LBL41.SDR SIMA200609417Beam · bentFLOOR BEAM 65 BENT. REPLACED FLOOR BEAM 65 IAW SRM. AIRCRAFT WAS RETURNED TO SERVICE. (K)SDR SWAA061116Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE FLOOR BEAM CORRODED AT BS 1016, RBL 6. REPAIRED FLOOR BEAM PER SRM.
Back to JASC 5315