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 ASOA05496Floorbeam · corrodedDURING A C-CHECK, THE FORWARD AND AFT FLOOR SUPPORT ANGLES 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 FS 280 BETWEEN LBL 9 AND RBL 9 IAW EO. (K)SDR SWIA200515160Floorbeam · crackedFS 280 FLOORBEAM LBL 9.0 OUTBOARD ATTACH ANGLE CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-00, 51-42-13, 51-23-00.SDR PIDA20050023Floorbeam · corrodedCORROSION ON BS 1641 FLOORBEAM AT RBL 59. REPAIRED PER SRM 53-00-51.SDR PIDA20050025Floorbeam · corrodedCORROSION ON BS 1320 FLOORBEAM FROM LBL 16 TO LBL 58. REPAIRED PER SRM 53-00-51.SDR PIDA20050024Floorbeam · corrodedCORROSION AROUND NUT PLATE HOLES ON BS 1661 FLOORBEAM FROM RBL 15 TO RBL 8. REPAIRED PER SRM 53-00-51.SDR CALA0500184Floorbeam · corrodedINSPECTION FOUND CORROSION AROUND NUT PLATE HOLE ON FLOORBEAM AT STA 947.5, RBL 6 AND RBL 18. REPAIRED IAW SRM 53-00-51, FIGURE 203.SDR 20052400AFloorbeam · corrodedCABIN FLOOR SUPPORT STRUCTURE FS 256.0 LBL 44 TO RBL 44 HAS CORROSION.SDR SWAA051642Floorbeam · corrodedDURING SCHEDULED 5Y CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 772, BETWEEN LBL 8 TO LBL 12. REPAIRED FLOORBEAM PER SWA EA.SDR DHL2005741607Floorbeam · corrodedFLOORBEAM AT BS 1110, BL-0, LWR CHORD IS EXFOLIATED. REMOVED WEB FOR ACCESS FROM STA 1110 BL 0 TO STA 1130 BL 0 IAW B727 SRM 51-30-2. CUT OUT DAMAGED AREA FLOORBEAM LOWER CHORD STA 1110 BL 0 SIZE 4.5 X 2 INCH IAW B727 SRM 53-10-8. FABRICATED REPAIR ANGLES FSDR SWAA051622Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CRACKED AT BS 727A + 17.5, RBL 44 & RBL 46, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR MALA050458Floorbeam · crackedDURING C1 & C2 CHECKS IN YYC FOUND FRAME 20 FLOORBEAM CRACKED AND CORRODED THROUGH THE TOP FLANGE AT RBL 22.SDR A6WA200540189Floorbeam · crackedTHE LT AND RT SIDE UNDERFLOOR SUPPORT ANGLE IS CRACKED 1.0 INCH AT FS 621, LBL 40 AND RBL 40, WL 73. REPAIRED INTERCOSTALS IAW REO. (K)SDR SWAA051594Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND COCKPIT FLOORBEAM UPPER CHORD CORRODED AT BS 260, LBL 9 TO RBL 9, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR SWIA200515165Floorbeam · crackedFS 280 AT RBL 9.0 INBOARD AND OUTBOARD FLOORBEAM ATTACH ANGLES CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REMOVED AND REPLACED ANGLES IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-21-11, 51-25-16, 51-23-00 .SDR SWIA200515164Floorbeam · crackedFS 280 AT LBL 9.0 OUTBOARD FLOORBEAM ATTACH ANGLE CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-21-11, 51-25-16, 51-23-00.SDR 72300213Floorbeam · corrodedA 1 X 8 INCH AREA OF CORROSION ON FLOORBEAM.SDR USAA050688Floorbeam · corrodedFOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH, RBL 24 STATION 965. REPLACED TEE CAP IAW SRM 53-00-51. (M)SDR USAA050689Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH, LBL 36 STATION 967. (M)SDR USAA050690Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCH BY 3 INCH, LBL 5 STATION 967 FLOORBEAM. INSTALLED NEW T-CAP IAW SRM 53-00-51. (M)SDR RYAN200500019Floorbeam · corrodedFLOORBEAM HAS CORROSION AT UPPER CAP BS 1640 RBL48.SDR 05FDEA01460Floorbeam · misdrilledUPPER LOBE INTERIOR, STA 520, RBL 43, TOP OF FLOORBEAM HAS DOUBLE DRILLED HOLES. REPAIRED BS 520 UPPER CHORD PER FED-EX EA 7-5310-86321.SDR USAA050733Floorbeam · corrodedBFM - C4 - FLOORBEAM, 2.5 IN L X 2 IN W X .027 IN D, 2 IN L X 2 IN W X .016 IN D; CORROSION; LEVEL 1; TASK C53-252-03, STA1640, BL 0-LBL 60. REPAIRED AS OUTLINED. (K)SDR CALA0500165Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 43 TO RBL 29. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01222.SDR UPS05144675Floorbeam · crackedMAIN CABIN RT FLOORBOARD SUPPORT BRACE CRACKED STA 51 RBL 24. REMOVED AND REPLACED FLOORBOARD SUPPORT BRACE (CROSSBEAM) IAW A300 SRM 51-40-00, AIRBUS STANDARDS MANUAL ANSA 2814 AND DWG 15-A53813309.SDR 05FDEA01445Floorbeam · corrodedAFT CARGO, STA 1130 FLOORBEAM LWR CHORD CORRODED AT NUT CLIP LOCATIONS LBL 60 TO RBL 60 (C53-113-01, 2). *S/D* REPAIRED FLOORBEAM PER SRM 53-10-8.SDR 05FDEA01414Floorbeam · deformedFWD CARGO COMPARTMENT, AT STA 6-10 FOUND FLOORBEAM DEFORM AS MARKED. REMOVED AS PER SRM 51-35-01 VOL II. NEW FLOORBEAM INSTALLED AS PER DWG AFA 0039 AND AS PER SRM 51-35-01 VOL II. MAJOR REPAIR AS PER GMM 6-2-100.SDR 05FDEA01413Floorbeam · deformedFWD CARGO COMPARTMENT, AT STA 1099 FLOORBEAM FOUND DEFORM AS MARKED. REMOVED AS PER SRM 51-31-01 VOL II. NEW FLOORBEAM INSTALLED AS PER DWG AFA 0039 AND AS PER SRM 51-31-01 VOL II. MAJOR REPAIR AS PER GMM 6-2-100.SDR UPS05844813Floorbeam · corrodedINSPECTION TYPE:C3, MAIN CABIN FLOORBEAM, EXISTING REPAIR UNDER AREA HAS HEAVY CORROSION AT STA 940 RBL 65. REMOVED EXISTING 2 FLOORBEAM REPAIRS, 1 FILLER AND FLOORBEAM. FABRICATED AND INSTALLED FLOORBEAM AND 4 REPAIR ANGLES IAW EO DC8-53-20466 AND SAA SK840SDR USAA050672Floorbeam · crackedCLT - FOUND FLOORBEAM STRAP CRACKED .5 INCH, BS 312, RBL 48 WL 200, BELOW CABIN FLOORBEAM. REMOVED DAMAGED PART, DRILLED AND INSTALLED NEW STRAP IAW SRM 51-10-02. (M)SDR USAA050693Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 20 INCH BY 3 INCH WIDESPREAD AT Y48 FRAME 66. REPLACED FLOORBEAM PER AIRBUS DWG D53472780 AND SRM 51-72-11. (M)SDR SWAA051503Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND NR 1 & NR 4 LONGITUDINAL FLOORBEAMS CRACKED AT BS 639. REPAIRED BEAMS PER SRM.SDR 05FDEA01410Floorbeam · deformedFWD CARGO COMPARTMENT, AT STA 1079 FLOORBEAM FOUND DEFORMED AS MARKED. FLOORBEAM REMOVED AS PER SRM 51-35-01 VOL II. NEW FLOOR BEAM INSTALLED AS PER DRAWING AFA 0039 AND SRM 51-35-01 VOL II. MINOR REPAIR AS PER GMM 6-2-100.SDR 05FDEA01409Floorbeam · deformedFWD CARGO COMPARTMENT, AT STA 6-30 FLOORBEAM FOUND DEFORMED AS MARKED. FLOORBEAM REMOVED AS PER SRM 51-35-01 VOL II. NEW FLOOR BEAM INSTALLED AS PER DRAWING AFA 0039 AND SRM 51-35-01 VOL II. MINOR REPAIR AS PER GMM 6-2-100.SDR CALA0500163Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 328, RBL 45 TO RBL 49. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01227.SDR USAA050683Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1 INCH DIAMETER, AT FRAME 66 Y1500 LEFT. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-45-00, 51-72-11, DWG D534-74350.SDR USAA05686Floorbeam · corrodedBFM - C4 - FLOORBEAM UPPER CHORD, 1.5 L X 2.0 W X .020, 1.5: X 2 W X .029, 2L, CORROSION (3 AREAS); LEVEL 1; TASK C53-251-03, STA 1640 FROM BL0 - RBL 60. REPLACED UPPER CHORD SECTION IAW TYP REP. (K)SDR CALA0500158Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 344, LBL 48 TO RBL 48. THE FLOORBEAM SECTION WAS REMOVED AND REPLACED IAW SRM 53-10-51.SDR CALA0500157Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 344, LBL 10. A REPAIR WAS INSTALLED IAW ECRA 5321-01223.SDR CALA0500156Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312, LBL 12. A CAP WAS INSTALLED ON FLOORBEAM IAW ECRA 5321-01224.SDR USAA050720Floorbeam · corrodedPIT - FOUND FLOORBEAM ANGLE BRACKET CORRODED 2 INCHES BY 1 INCH, FRAME 17 - Y 31 INCH. CORROSION LEVEL 2, TASK JA-220-53500. FABRICATED ANGLE BRACKET PER SRM 53-11-15. (M)SDR CALA0500160Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 720, RBL 20.5 TO RBL 50.5. REPAIRED IAW SRM 53-00-51.SDR USAA050669Floorbeam · corrodedCLT - FOUND FLOORBEAM CAP CORRODED .250 INCH BY .250 INCH, STATION 312 FLOORBEAM AROUND SCREW HOLE RBL 38. FABRICATING NEW SECTION OF FLOORBEAM P/N BAC 1505-100246 FLOOR IAW SRM 53-10-51. (M)SDR USAA050724Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH AREA, FRAME 17 BLL 18 INCHES. CORROSION LEVEL 2, TASK JA-220-53500. REPLACED FLOORBEAM PER SRM 53-11-14, DWG B2D53112826. (M)SDR SWIA200515115Floorbeam · crackedFS 621 AT RBL 41 FLOORBEAM ANGLE IS CRACKED, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED FLOOR SUPPORT ANGLE IAW CRJ REO 601R-53-61-117 REV "B".SDR SWIA200515114Floorbeam · crackedFS 621 AT LBL 41 FLOORBEAM ANGLE IS CRACKED, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED FLOOR SUPPORT ANGLE AS PER IAW REO 6014-53-61-117 REV "B" .SDR SWIA200515113Floorbeam · crackedFS 280 AT RBL 9.0 OUTBOARD FLOORBEAM ATTACH ANGLE IS CRACKED, ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-21, 51-23-00, 51-21-11, 51-42-06.SDR UPS05444526Floorbeam · damagedINSPECTION TYPE:C CABIN- U/D BS 380 FWD FLANGE OF FLOORBEAM FLOOR PANEL ATT. HOLES SHORT EDGE MARGIN FOUND AT RBL 20 INCHES AND 24.5 INCHES. CABIN - U/D BS 380 FLOORBEAM FWD FLANGE RBL 20 INCHES AND 24.5 INCHES AREA REPAIRED IAW EO B747-5320-12407-D PLAN C.SDR UPS05444524Floorbeam · misdrilledINSPECTION TYPE:C CABIN - U/D FLR BEAM BS 340 FWD FLANGE RBL 40 INCHES SHORT EDGE MARGIN FOUND AT CLIP NUT HOLES AREA. CABIN - U/D BS 340 FLR BEAM FWD FLANGE RBL 40 INCH AREA REPAIRED IAW EO B747-5320-12407-D PLAN C.SDR UPS05444523Floorbeam · misdrilledINSPECTION TYPE:C CABIN - U/D BS 380 FWD FLANGE OF FLOORBEAM FLOOR PANEL ATT HOLES SHORT EDGE MARGIN FOUND AT RBL 39, 40 & 41 AREA. CABIN - U/D BS 380 FWD FLANGE OF FLOORBEAM RBL 39, 40 & 41 AREA REPAIRED AS PER UPS EO B747-5320-12407 APPENDIX D PLAN C.SDR UPS05444522Floorbeam · misdrilledINSPECTION TYPE:C CABIN - U/D BS 380 FWD FLANGE OF FLOORBEAM FLOOR PANEL ATT HOLES SHORT EDGE MARGIN FOUND AT RBL 55 & 65 AREA. CABIN - U/D BS 380 FLOORBEAM FWD FLANGE RBL 55 & 65 REPAIRED AS PER UPS EO B747-5320-12407 APPENDIX D PLAN -C-.
Back to JASC 5315