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 CALA0500310Floorbeam · corrodedINSPECTION FOUND FORWARD FLANGE OF FLOORBEAM CORRODED ON NUT PLATE HOLES AT STA 986.6, LBL 23, LBL 26, RBL 4, RBL 12, AND RBL 20. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01292.SDR CALA0500309Floorbeam · corrodedINSPECTION FOUND LITE CORROSION UNDER SCREW HOLES ON FLOORBEAM AT STA 967, LBL 30 TO RBL 30. REPAIRED FLOORBEAM IAW ECRA 5321-01291.SDR ASAA0510296Floorbeam · corrodedYXX - FOUND BEYOND LIMITS CORROSION ON BS 807 FLOORBEAM UPPER CAP AT LBL 24-LBL 45. REPAIRED IAW ERO 4554 AND EA 5310-02425 BY REINFORCEMENT OF CAP WITH STRAP. (M)SDR ASAA0540453Floorbeam · corrodedOKC - FOUND CORROSION ON FLOORBEAM AT BS 360. REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR PARTS IAW B737-400 SRM 53-00-51 FIG 201. (M)SDR ASAA0540448Floorbeam · corrodedOKC - FOUND UPPER CHORD OF FLOORBEAM AT BS 294.5 IS CORRODED. REMOVED CORRODED SECTION OF CHORD. FABRICATED REPLACEMENT CHORD AND INSTALLED IAW B737-200 SRM 53-10-51 FIG 201. (M)SDR ASAA050447Floorbeam · corrodedOKC - FOUND HAT CHANNEL ON FLOORBEAM AT BS 294.5 IS CORRODED. REMOVED CHANNEL, FABRICATED AND INSTALLED REPLACEMENT CHANNEL IAW B737-200 SRM 51-40-02 AND AMM 51-21-21. (M)SDR UPS05845622Floorbeam · crackedPOSSIBLE CRACK AT FLOORBEAM LOWER AREA STA 902 RBL 50-55. NDT VERIFIED TWO CRACKS. CUT OUT DAMAGED SECTION OF FLOORBEAM, FABRICATED REPLACEMENT SECTION OF FLOORBEAM AND REPAIR PARTS IAW SAA SK 801-805214.SDR GTIA050251Floorbeam · corrodedFOUND FLOORBEAM JUST INSIDE R-1 DOOR CORRODED, INSIDE CHANNEL. REMOVED AND REPLACED FLOORBEAM INSIDE R-1 DOOR. (M)SDR SWIA200515599Floorbeam · crackedMAIN FUSELAGE, FS 280.00, LBL 9.0, UPPER FLANGE CRACKED ON FLOORBEAM, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED MAIN FUSELAGE FS 280.00, LBL 9.0 UPPER ANGLE ON TRANSVERSE BEAM IAW CRJ REO 601R-53-11-138 REV "NC".SDR MAC90501Floorbeam · crackedTHE LONGITUDINAL FLOORBEAM BL 0 AT FRAME 15 CRACKED NEAR ATTACH POINT TO THE LATERAL FLOORBEAM. CRACK WAS DISCOVERED DURING TROUBLESHOOTING ANOTHER UNRELATED PROBLEM. REPAIR WAS ACCOMPLISHED PER EO 4225001-42-53-32. THIS PART WAS INSTALLED BY STC ST01189W1.SDR UPS05245510Floorbeam · corrodedCORROSION ON FLOORBEAM TOP ANGLE AT BS 340 RBL 24. REPAIR CARRIED OUT IAW SRM 51-30-2, 53-10-8 AND 53-10-1.SDR AWXA200501164Floorbeam · corrodedMCN - DURING C15 CHECK DISCOVERED CORROSION ON UPPER CAP OF FLOORBEAM, PREVIOUS BLEND OUT, AT BS 986 AND FROM BL 17R TO BL 44R. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-60-51-1A FIG 101. MAINTENANCE REMOVED FLOORBEAM UPPER CAP IAW BOSDR DHL2005748751Floorbeam · corrodedFLOORBEAM AT BS 1166 RBL 36 HAS HEAVY EXFOLIATION ON UPPER FLANGE. CUT OUT DAMAGED AREA OF TOP AFT FLANGE OF FLOORBEAM 4.6 BY 1.0 AT STA 1166 RBL 36 IAW B727 SRM 53-10-8 FIG 8. FAB REPAIR SUPPORT ANGLES FROM 7075T6 PO NR 9001487 22.0 BY 6.0 AND 15.2 BY 6.0 ISDR ASAA0540454Floorbeam · corrodedCORROSION ON FLOORBEAM AFT FLANGE. REMOVED CORROSION ON FLOORBEAM, FABRICATED AND INSTALLED REPAIR PARTS IAW SRM. (K)SDR ASAA0510289Floorbeam · corrodedBSTA 927.0 RT WL 155 AND RBL 8.0, FLOOR SUPPORT RAIL EXFOLIATION CORROSION UNDER ANCHOR NUT. REPAIRED FLOOR SUPPORT RAIL AT BSTA 927.0 AT WL155 AND RBL 8.0 IAW SRM. (K)SDR USAA051073Floorbeam · corrodedCORROSION FLOORBEAM -Y1292 AT FRAME 66. REMOVED & REPLACED BEAM PER SRM 53-41-14, DEFECT SIZE: 2 X 3 INCH.SDR USAA051072Floorbeam · corrodedCORROSION FLOORBEAM FR 66 -Y1500. INSTALLED DOUBLER PER SRM 53-41-14 REPAIR 6. DEFECT SIZE: 1.5 X .75 INCH.SDR USAA051077Floorbeam · crackedFLOORBEAM Y503.4 LEFT BETWEEN FRAME 14 DEFECTIVE. DEFECTIVE PART REPLACED WITH IDENTICAL PART PR SRM 51-72-11. DEFECT SIZE: .5 X 8 X .040 INCH DEEP.SDR VTZA200500176Floorbeam · corrodedRBL 27 FLOORBEAM HAS CORROSION AT FS 337.SDR VTZA200500174Floorbeam · crackedLT FS 621 FLOOR SUPPORT IS CRACKED AT 1" IN ANGLE.SDR PIDA20050123Floorbeam · corrodedFLOORBEAM AT BS 312 HAS CORROSION ON UPPER SURFACE FROM BL 0 TO RBL 8. REPLACED TEE CAP FROM RBL 23 TO LBL 18 PER SRM 53-10-9.SDR SWAA052739Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND CABIN FLOORBEAM UPPER CHORD CRACKED AT BS 294.5, LBL 53. REPAIRED FLOORBEAM UPPER CHORD PER SRM.SDR SWAA052716Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CABIN FLOORBEAM CORRODED AT BS 328, RBL 24. REPAIRED FLOORBEAM PER SRM.SDR SWAA052714Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CABIN FLOORBEAM UPPER CHORD CORRODED AT BS 986.5, BETWEEN RBL 35 TO RBL 45, WL 208. REPAIRED FLOORBEAM PER SRM.SDR SWAA052713Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CABIN FLOORBEAM UPPER CHORD CORRODED AT BS 947, BETWEEN BL 0 TO LBL 45, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR AWXA200501070Floorbeam · corrodedDURING C4 CHECK DISCOVERED, GALVANIC CORROSION LOCATED ON FLOORBEAM FROM FR 65 TO FR 67, Y912. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-00-14. REMOVED FLOORBEAM FROM FR 65 TO FR 67, Y912 IAW AIRBUS 320 SRM 51-72-11. SDR AWXA200501069Floorbeam · corrodedDURING C4 CHECK, DISCOVERED EXFOLIATION CORROSION LOCATED ON FLOORBEAM FROM FR 64 TO FR 70, Y512. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-00-14. REMOVED FLOORBEAM FROM FR 64 TO FR 70, Y512 IAW AIRBUS 320 SRM 51-72-11SDR AWXA200501068Floorbeam · corrodedDURING C4 CHECK, DISCOVERED GALVANIC CORROSION LOCATED ON FLOORBEAM FROM FR 64 TO FR 66, Y-1292. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-00-14. REMOVED FLOORBEAM FROM FR 64 TO FR 66, Y-1292 IAW AIRBUS 320 SRM 51-72-1SDR AWXA200501067Floorbeam · corrodedDURING C4 CHECK DISCOVERED GALVANIC CORROSION LOCATED ON FLOORBEAM FROM FR 66+8 TO FR 68, Y-1292. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-00-14. REMOVED FLOORBEAM FROM FR 66+8 TO FR 68, Y-1292 IAW AIRBUS 320 SRM 51-7SDR AWXA200501066Floorbeam · corrodedDURING C4 CHECK, DISCOVERED GALVANIC CORROSION LOCATED ON FLOORBEAM FROM FR 66+8 TO FR 68, Y-765. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-00-14. REMOVED FLOORBEAM FROM FR 66+8 TO FR 70, Y-765 IAW AIRBUS 320 SRM 51-72SDR AWXA200501065Floorbeam · corrodedDURING C4 CHECK, DISCOVERED EXFOLIATION CORROSION LOCATED ON FLOORBEAM FROM FR 66 TO FR 68, Y1292. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-00-14. REMOVED FLOORBEAM FROM FR 66 TO FR 68, Y1292 IAW AIRBUS 320 SRM 51-72-SDR AWXA200501063Floorbeam · corrodedDURING C4 CHECK, DISCOVERED EXFOLIATION CORROSION LOCATED ON FLOORBEAM AT FR 68, Y1292. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-00-14. REMOVED FLOORBEAM AT FR68, Y1292 IAW AIRBUS 320 SRM 51-72-11. INSTALLED NEW FLOOSDR SWAA052704Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CRACKED AT BS 668, LBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA052703Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 668, RBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR AWXA200501125Floorbeam · crackedMCN - DURING C18 CHECK DISCOVERED .9 INCH LONG CRACK ON FLOORBEAM AT BS 328, RBL 19, AND WL 208. MAINTENANCE CUT OUT DAMAGED AREA OF FLOORBEAM IAW BOEING 737-300 SRM 53-10-51-2R. FABRICATED REPAIR FILLER AND REPAIR ANGLES IAW BOEING 737-300 SRM 53-10-51-2R SDR 2005UALA00932Floorbeam · corrodedCABIN FLOOR BS 312 LBL 1 AND LBL 6 SMALL AREA OF CORROSION ON UPPER SURFACE OF FLOORBEAM.SDR MALA050685Gusset · corrodedWHILE ACCOMPLISHING C1 INSPECTION, FOUND GUSSET PLATE AT FRAME 18 FLOORBEAM LBL 12 CORRODED.SDR MALA050688Floorbeam · corrodedWHILE ACCOMPLISHING C1 INSPECTION, FOUND FLOORBEAM (UNDERSIDE) AT FRAME 18 RBL 30 CORRODED.SDR CALA0500299Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND FLOORBOARD HOLES AT STA 967 FROM RBL 30 TO RBL 49. THE CORROSION WAS REMOVED AND THE AREA WAS REWORKED AND REPAIRED IAW ECRA 5321-01282.SDR CALA0500298Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 64 TO RBL 64. REPAIRED FLOORBEAM PER ECRA 5321-01283 AND SRM 51-40-02.SDR SWAA052692Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 664, LBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA052675Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 845, LBL 8. REPAIRED FLOORBEAM PER SWA EA.SDR AWXA200501064Floorbeam · corrodedDURING C4 CHECK DISCOVERED, GALVANIC CORROSION LOCATED ON FLOORBEAM AT FR 68, Y-1292. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-00-14. REMOVED FLOORBEAM AT FR68, Y-1292 IAW AIRBUS 320 SRM 51-72-11. INSTALLED NEW FLOORSDR 05FDEA02732Floorbeam · crackedFWD CARGO COMPT, BETWEEN LBL 3 AND LBL 22, ALONG STA 6-70, FLOORBEAM CRACKED AND CORRODED. CORRECTIVE ACTION: SNRM N1070: FWD CARGO STA 6-70 FLOOR PANEL BEAM CRACK AND CORROSION SUPPORT REMOVED AND NEW SUPPORT INSTALLED AS PER DRAWING ADA 7667, SRM 51-33SDR CALA0500287Floorbeam · corrodedINSPECTION FOUND PITTING CORROSION ON FLOORBEAM AT STA 328, RBL 58 IN THE GALLEY AREA. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01281.SDR EIA2005246Floorbeam · crackedFWD CARGO COMPARTMENT STA 600 CARGO FLOORBEAM CRACKED. STA 600 FLOORBEAM UPPER CHORD RT OB SECTION REPLACED PER SRM 51-10-01.SDR EIA2005244Floorbeam · crackedFOUND BS 420 UPPER DECK FLOORBEAM UPPER CHORD FASTENER HOLE CRACKED AT RBL 86 AND RBL 90. FLOORBEAM UPPER CHORD REPAIRED PER EA-53-0993.SDR ASOA05827Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAMS AT FRAME 36, FRAME 38, FRAME 39, FRAME 40 AND FRAME 41 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAMS AT FRAME 36, FRAME 38, FRAME 39, FRAME 40 AND FRAME 41 IAW ASA EO 72-53-016SDR 2005UALA00920Floorbeam · corrodedMAIN CABIN FLOORBEAM AT BS 1640, UPPER T-CAP HAS CORROSION IN SEVERAL PLACES AROUND FASTENER HOLES, UPPER AND LOWER SURFACES, LBL 9 TO RBL 60. REMOVED EXISTING SPLICES AND DAMAGED T-CAP SECTION, FABRICATED NEW T-CAP AND SPLICE ANGLES AND STRAPS PER MM 53-0SDR AALA20050591Floorbeam · corrodedAFW - FLOORBEAM AT STATION 325 HAS CORROSION REMOVED ON UPPER AND LOWER SURFACE BEYOND SRM LIMITS. AREA IS 1.0 INCH BY .021 INCH AT RT BUTTLINE 16, 1.1 BY .040 AT RT BUTTLINE 19.5, 1.2 BY .045 INCH AT RT BUTTLINE 25.5 AND 2.0 BY .021 INCH AT RIGHT BL 54 WITH A
Back to JASC 5315