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 05FDEA00617Floorbeam · corrodedCORROSION SPOTS UNDER FLOORBEAM LOWER SURFACE AROUND NUT CLIP HOLES AT BS 1070 FROM LBL 42 TO RBL 21, WL 200 IN THE AFT CARGO BAY. BLENDED CORROSION ON LOWER SURFACE OF BS 1070 FLOORBEAM LOWER CHORD FROM RBL 21- LBL 42 WL 200, FOUND AREA RBL 21-LBL 4 TO BE WSDR 05FDEA00626Floorbeam · damagedFR 38 MDCC FLOORBEAM LT OF CTR AT 38 INCHES, AFTER REMOVAL OF CLS ADAPTER TO FACILITATE FRAME REPAIR, FASTENER HOLES FOUND TO BE OUT OF ROUND, FWD INBOARD HOLE ON CLS ADAPTOR AFT OUTBD, AND ALSO 2 DRILL STARTS. BLENDED OUT DRILL STARTS PER A310 SRM 51-73-10, SDR SWAA050871Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND COCKPIT FLOORBEAM UPPER CHORD CORRODED AT BS 260, BETWEEN RBL 2 TO LBL 9, WL 200. REPAIRED FLOORBEAM PER PAE ER & SRM.SDR CALA0500086Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT FLOORBOARD FASTENER HOLE, BS 720, RBL 26 AND RBL 43.5. REPAIRED IAW ECRA 5320-01769.SDR ASAA0540192Floorbeam · corrodedTOP OF FLOORBEAM CORRODED AT STA 312, LBL 12. REMOVED DAMAGED UPPER CHORD, FABRICATED AND INSTALLED A REPLACEMENT UPPER CHORD IAW SRM. (K)SDR QXEA200500510Floorbeam · corrodedPDX - FLOORBEAM FS280.0 CORRODED WL72.50 FROM BLL 22.0 - BLR25.0 AND CRACK AT FS280.0, WL 72.50, BLL 12.0. REPAIRED IAW CRJ 700 REO 670-53-11-045 AND CRJ 700 SRM 51-42-06SDR QXEA200500504Floorbeam · corrodedPDX - FLOORBEAM AT FUSELAGE STATION 280.00 CORRODED WL 72.50 FROM LBL 22.0 - RBL 25.0 AND CRACK AT FS 280.0 WL 72.50 BLL 12.0. REPAIRED IAW REO 670-53-11-045.SDR SWAA050856Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND 4 EA CRACKS ON LONGITUDINAL BEAMS AT BS 727A + 17, RBL 25, RBL 45, LBL 25, LBL 45. REPAIRED BEAMS PER PAE ER.SDR 05FDEA00586Floorbeam · crackedFWD PIT BAY CEILING AREA FR 38, 38 INCHES TO LT OF CTR FLOORBEAM IS CRACKED. REWORKED AREA TO INSTALL 2EA ANGLE REPAIRS PER A310-200 SRM 53-10-15. CLEAN, TREATED AND PRIMED AREA PER A310-200 SRM 51-21-10, INSTALLED 2EA REPAIR ANGLES PER A310-200 SRM 53-10-15SDR SWIA200515088Buttstrap · corrodedCENTER BUTT STRAP BELOW CABIN FLOOR AFT OF ROW 10 CORRODED, ITEM FOUND AT C-CHECK INSPECTION. NEW BUTT STRAP INSTALLED IAW SRM 120 51-10-02 PG 3 SEC 3.A.SDR SWIA200514798Floorbeam · crackedRT FLOORBEAM ANGLE AT FS 621.00 IS CRACKED. ITEM FOUND AT C-CHECK INSPECTION. CRACKED ANGLE REPAIRED IAW REO 601R-53-61-117 REV B.SDR SWIA200514797Floorbeam · crackedLT FLOORBEAM ANGLE AT FS 621.00 IS CRACKED. ITEM FOUND AT C-CHECK INSPECTION. CRACKED ANGLE REPAIRED IAW REO 601R-53-61-117 REV B.SDR A6WA200540109Floorbeam · crackedFLOORBEAM ANGLE AT FS 621 LT SIDE IS CRACKED 1 INCH. PERFORMED REPAIR TO RT FS 621 FLOORBEAM ANGLE IAW BOMBARDIER REO 601R-53-117 REV C. (M)SDR A6WA200540102Floorbeam · crackedRIGHT CARGO FLOOR SUPPORT ANGLE AT FS 621 CRACKED .5 INCH LONG. (M) REMOVED CRACKED SECTION OF FLOOR SUPPORT ANGLE AT FS 621 RT AND INSTALLED REPAIR ANGLE IAW MDG REO. (K)SDR SWAA050811Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 945, LBL 12. REPAIRED BEAM PER SRM.SDR SWAA050807Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND 3 EA CRACKS ON LONGITUDINAL BEAM WEB AT BS 710, RBL 25, WL 201. REPAIRED BEAM PER PAE ER.SDR USAA050443Floorbeam · corrodedBFM - FOUND FLOORBEAM CORRODED 2 INCHES LONG BY 1 INCH WIDE BY .016 INCH DEEP, FRAME 16A-Y1450 -Z240. REPLACED FLOORBEAM PER SRM 53-11-14 FIG 101, 51-42-11. (M)SDR UPS05444180Floorbeam · crackedINSPECTION TYPE: C M/D- BS 1500 RBL 83-89 FLOORBEAM UPPER CHORD LWR SURFACE CRACKED CRACK, LENGTH .375 INCH. FLOORBEAM REPAIRED AS PER SRM 51-40-04 FIG 1.SDR UPS05444181Floorbeam · corrodedINSPECTION TYPE:C M/D- BS 1580 RBL 83-96 FLOORBEAM UPPER CHORD CORROSION. CORROSION BLEND OUT 0.060 X 2 X 2 INCH EXCEED SRM 53-10-01 FIG 1 LIMIT. M/D BS 1580 RBL 83-96 FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG 1.SDR MALA050266Floorbeam · corrodedDURING 4Y/2Y CHECK IN BNA FOUND FLOOR FRAME AT STA 258.0 IS CORRODED. REPAIRED AFTER CORROSION REMOVAL REF SRM 53-70-30-2.SDR ASOA05288Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM AT FRME 40 LT/RT WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FRAME 40 LEFT/RIGHT IAW SRM 51-25-01. (M)SDR ASOA05286Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM AT FRAME 36, STRINGER 14 L/R WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FRAME 36, STRINGER 14 L/R, IAW SRM 51-25-01. (M)SDR ASOA05289Floorbeam · corrodedDURING A C-CHECK IN YUL, THE LOWER FLOORBEAM AT FRAME 41, STRINGER 18R WAS FOUND TO BE CORRODED BEYOND LIMITS ON TOP OF THE FLANGE AND UNDER THE ANCHOR NUT. MAINTENANCE REMOVED AND REPLACED THE LOWER FLOORBEAM AT FRAME 41, STRINGER 18R IAW SRM 51-25-01. (M)SDR AWXA200500404Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-05 CHECK CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF FLOORBEAM UPPER CHORD AT BS 986, BETWEEN LBL 3 AND LBL 40. MAINTENANCE REMOVED CORRODED SECTION OF FLOORBEAM UPPER CHORD AT BS 986, FROM LBL 3 TO LBL 40; FABRICATED A NEWSDR 05FDEA00497Floorbeam · damagedBS 950, BL 59, WL 200, MECHANICAL DAMAGE ON LWR FLOORBEAM ANGLE. REPAIRED PER SRM 51-30-5, 51-30-6, 51-20-1SDR USAA050379Floorbeam · corrodedBFM - FOUND FLOORBEAM CORRODED 4 INCH BY 1 INCH BY .080 INCH AREA, STATION 303, RBL 20-24. REPAIRED FLOORBEAM T-CHORD PER SRM 53-00-51. (M)SDR SWIA200514753Floorbeam · crackedLEFT FLOORBEAM ANGLE AT FS 621.00 IS CRACKED. ITEM FOUND AT C-CHECK INSPECTION. CRACKED FLOOR SUPPORT REPAIRED IAW CRJ REO 601R-53-61-117 REV B.SDR SWIA200514751Floorbeam · crackedFLOORBEAM RBL 9.0 ATTACH ANGLE IS CRACKED AT FS 280.0. ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-25-16, AND 51-23-00.SDR COMA0570029Floorbeam · corrodedTHE TRANSVERSE BEAM AT FS 280 IS CORRODED FROM LBL 36 TO RBL 36. THE CORRODED TRANSVERSE BEAM WAS REMOVED. A NEW TRANSVERSE BEAM WAS FABRICATED AND INSTALLED IAW BRAS EO 601R-53-6066 AND BOMBARDIER REO 670-53-11-047 REV A.SDR CALA0500080Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 720, RBL 3 TO LBL 3. REPAIRED IAW SRM 53-00-51, FIGURE 203.SDR CALA0500072Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT FASTENER HOLE OF FORWARD FLANGE OF UPPER CHORD, STA 986, LBL 43. A REPAIR WAS INSTALLED IAW ECRA 5321-01210.SDR 05FDEA00451Floorbeam · corrodedAFT PIT FLOOR FS 66 10 INCH TO RT OF CTR HAS A 5 INCH BY 2 INCH AREA OF CORROSION. REMOVED CORROSION PER A310-200 SRM 51-74-10. CORROSION OUT OF LIMITS PER SRM 51-10-00. REMOVED CORRODED FLOORBEAM AND INSTALLED NEW BEAM PER A310-200 SRM 51-72-10. REPROTECTSDR SWIA200514750Floorbeam · crackedFS 621 FLOORBEAM ANGLE RBL 42 CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED IAW CRJ REO 601R-53-61-117 REV B.SDR SWIA200514746Floorbeam · crackedMAIN FUSELAGE FS 280 LBL 9.0 LOWER FLANGE CRACKED ON TRANSVERSE BEAM. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED REPAIR IAW CRJ REO 601R-53-11-138 REV NC.SDR SWIA200514745Floorbeam · crackedMAIN FUSELAGE FS 280 RBL 9.0 LOWER FLANGE CRACKED ON TRANSVERSE BEAM. ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13 AND 51-23-00.SDR SWIA200514744Floorbeam · crackedFS 280 LT FLOORBEAM RBL 9.0 INBOARD ATTACH ANGLE CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13 AND 51-23-00.SDR SWIA200514743Floorbeam · crackedFS 280 RT FLOORBEAM RBL 9.0 INBOARD ATTACH ANGLE CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13 AND 51-23-00.SDR 2005UALA00214Floorbeam · corrodedBS 365 FLOORBEAM CORRODED BEYOND LIMITS BETWEEN RBL 59 TO BL 0. TEE CAP WAS TRIMMED AND REPAIR ANGLES AND STRAPS WERE USED TO SPLICE IN NEW SECTION OF TEE CAP.SDR 05FDEA00407Floorbeam · corrodedBULK PIT FLOOR T-CAP BETWEEN FR65 AND FR66 24 INCHES TO RT OF CTR HAS A 6 X 1 INCHES OF CORROSION. REMOVED CORRODED SECTION & INSTALLED NEW SECTION PER A310 SRM 51-72-10 & REPROTECTED FASTENERS PER A31-200 SRM 53-21-10. T-CAP WAS CORRODED BEYOND LIMITS AS GISDR CALA0500071Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM FORWARD FLANGE OF UPPER CHORD FASTENER HOLE CORRODED AT STA 986, RBL 43 TO RBL 44. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01209.SDR ASOA05228Floorbeam · corrodedDURING HANGAR MAINTENANCE IN CKB, THE FS 280 FLOOR TRANSVERSE BEAM WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FS 280 FLOOR TRANSVERSE BEAM IAW BOMBARDIER REO 670-53-11-047. (M)SDR GTIA050080Floorbeam · corrodedAFT CARGO COMPARTMENT, STA 1309. CABIN FLOORBEAM IS CORRODED (EXFOLIATION) AT RBL 20. FOUND LWR AFT ANGLE SUPPORT CRACKED. CORROSION FOUND TO BE ALL THE WAY THROUGH FLOORBEAM AND IS OUT OF LIMITS. DETENTIONED CABLE RUNS, DISCONNECTED 2 HYD LINES AND POT. SDR 05FDEA00359Floorbeam · corrodedBS 950 LBL 11, WL 208 CORROSION ON FLOORBEAM (OUT OF LIMITS). REPAIRED BS 950 FLOOR BEAM LBL 11 WL 208 FED EX EA 7-5310-86259.SDR CALA0600167Floorbeam · corrodedINSPECTION FOUND LEFT O/B EDGE OF FLOORBEAM UPPER CHORD CORRODED AT BS 277, LBL 19. THE CORRODED SECTION OF UPPER CHORD WAS REMOVED AND A NEW CHORD WAS SPLICED IN IAW ECRA 5310-04464.SDR SWIA200515657Floorbeam · crackedTRANSVERSE FLOORBEAM AT FS 280 IS CRACKED O/B OF RBL 9.0 AND LBL 9.0. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED IAW 51-42-06 PG 1-20 AND 51-42-21 PG 1-4 AND REO 601R-53-11-171.SDR SWIA200515656Floorbeam · crackedFLOORBEAM AT FS 280 IS CRACKED AT O/B OF RBL 9.0 AND LBL 9.0. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED REPAIR ANGLE IAW REO 601R 53-11-136.SDR SWIA200515655Floorbeam · crackedFLOORBEAM AT FS 280 IS CRACKED AT O/B OF RBL 9.0 AND LBL 9.0. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED REPAIR ANGLE IAW REO 601R 53-11-136.SDR 91500001Floorbeam · corrodedMAIN DECK FLOORBEAM CORRODED AT NUT PLATES.SDR 05FDEA00353Floorbeam · corrodedCORROSION SPOTS UNDER FLOORBEAM LOWER SURFACE AT BS 1130 LBL 43 TO RBL 52, WL 200 IN AFT CARGO BAY. FLOOR BEAM WILL BE REPLACED ON N01035, INTERIOR 5081 AT BS 1130, LBL 65 TO RBL 65 LOWER CHORD.SDR 05FDEA00351Floorbeam · corrodedCORROSION ON LOWER SIDE OF FLOORBEAM AT BS 1130, LBL 45 TO RBL 45, WL 200.
Back to JASC 5315