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 AWXA200401136Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-10 CHECK, INTERGRANULAR CORROSION WAS FOUND ON CABIN FLOORBEAM AT BS 365.25, BETWEEN RBL 28 AND RBL 43. MAINTENANCE REMOVED CORRODED FLOORBEAM UPPER CAP AT BS 365.25 FROM RBL 28 TO RBL 43; FABRICATED A NEW REPLACEMENT SECTION OF SDR AWXA200401117Floorbeam · corrodedDURING C-10 CHECK, INTERGRANULAR CORROSION WAS FOUND ON CABIN TRANSVERSE FLOORBEAM AT BS 334, BETWEEN RBL 2 AND RBL 39. MAINTENANCE REMOVED FLOORBEAM AT BS 334, FROM RBL 2 TO RBL 39; FABRICATED AND INSTALLED A NEW REPLACEMENT FLOORBEAMS PER DWG 141N5160.SDR AWXA200401116Floorbeam · corrodedDURING C-10 CHECK, INTERGRANULAR CORROSION WAS FOUND ON CABIN TRANSVERSE FLOORBEAM AT BS 334, BETWEEN RBL 2 AND RBL 39. MAINTENANCE REMOVED FLOORBEAM AT BS 334, FROM RBL 2 TO RBL 39; FABRICATED AND INSTALLED A NEW REPLACEMENT FLOORBEAM PER DWG 141N5160.SDR QXEA200400698Floorbeam · crackedCABIN FLOORBEAM LOCATED AT FS 280.00 HAS CRACK AT WL 69.95, EXTENDING FROM RBL 8.2 TO RBL 10.1. REPAIRED IAW EA R-53-209.SDR QXEA200400697Floorbeam · crackedPDX - CABIN FLOORBEAM LOCATED AT FS 280.00 HAS CRACK AT WL 69.95, EXTENDING FROM LBL 8.9 TO LBL 10.7. REPAIRED IAW HORIZON AIR EA R-53-209.SDR QXEA200400695Floorbeam · crackedPDX - CABIN FLOORBEAM LOCATED AT FS 280.00 HAS TWO CRACKS IN UPPER FLANGE, LOCATED AT LBL 13.00. CRACKS RUN FROM RIVET HOLE TO AFT EDGE OF FLANGE. REPAIRED IAW HORIZON AIR EA R-53-209.SDR QXEA200400701Floorbeam · corrodedPDX - CABIN FLOORBEAM, AFT SIDE OF FS 280 BULKHEAD UPPER FLANGE, LOWER SURFACE IS CORRODED AT LBL 1.0, LBL 3.5 AND LBL 13.5 TO LBL 17. REPAIRED IAW HORIZON AIR EA R-53-209 AND CRJ SRM 51-21-06, PARAGRAPH 3A, B, D, PAGE 2 AND 4.SDR QXEA200400699Floorbeam · crackedPDX - CABIN FLOORBEAM LOCATED AT FS 280.00 HAS A SERIES OF CRACKS EXTENDING FROM RIVET HOLE AT WL 72.00 BETWEEN RBL 10.5 AND RBL 12.0. REPAIRED IAW HORIZON AIR EA R-53-209.SDR QXEA200400700Floorbeam · corrodedCABIN FLOORBEAM, AFT SIDE OF FS 280 BULKHEAD, UPPER SURFACE IS CORRODED IN MULTIPLE LOCATIONS BETWEEN LBL 36 AND RBL 16. REPAIRED IAW HORIZON AIR EA R-53-209 AND CRJ SRM 51-21-06, PARAGRAPH 3A, B, D, PAGE 2 AND 4.SDR QXEA200400708Floorbeam · crackedPDX - DRIP TRAY ON RIGHT HAND SIDE CONNECTED TO COCKPIT AFT FLOORBEAM IS CRACKED IN SEVERAL PLACES. REPAIRED IAW HORIZON AIR EA R-53-208.SDR CALA0400648Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER T-CAP CORRODED AT STA 328, RBL 12 TO RBL 58. A NEW SECTION OF FLOORBEAM WAS INSTALLED IAW SRM 53-10-51.SDR 2004UALA00874Floorbeam · corrodedCABIN FLOORBEAM AT STA 325 BETWEEN RBL 44 AND RBL 58 CORRODED ON TOP CAP OF BEAM. FABRICATED & INSTALLED DOUBLER REPAIR. FABRICATED & INSTALLED ANGLE REPAIR DOUBLER.SDR 2004UALA00871Floorbeam · corrodedMAIN CABIN FLOORBEAM AT STA 1640 RBL 58 TOP RAIL CORRODED. FABRICATED & INSTALLED NESTED ANGLE REPAIR.SDR SWAA042814Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM WEB AT BS 1016, LBL 1 TO RBL 37, CORRODED. REMOVED AND REPLACED FLOORBEAM WEB SECTION PER SRM.SDR SWAA042813Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM AT BS 344, RBL 1 TO RBL 8, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR F3LA200400104Floorbeam · corrodedDURING C-4 CHECK, FLOORBEAM GOUGED AND CORRODED AT STA 947.5 - 967, RBL 16. REPLACED DAMAGED INTERCOSTAL PER SRM 51-40-02 AND 53-60-51.SDR F3LA200400102Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED FLOORBEAM SUPPORT AT STA 947.5 - 967, LBL 14, CORRODED. REPLACED INTERCOSTAL AT STA 947.5 - 967, LBL 14, PER SRM 51-40-02, 51-30-01 AND DRAWING 65C33375.SDR 04FDEA02840Floorbeam · corrodedBFM CLOSER C/W WITH EA7-5321-82044 FUSELAGE, FLOORBEAM UPPER CORD REPAIR STA 950 AT BL 21.0 ENT BY: 497236 RPT BY: 497236 FACT 28SEP04 23:10. BFM U COMPLIED WITH EA 7-5321-82044. REMOVED CORROSION, TREATED AREA AND INSTALLED REPAIR ANGLE ENT BY: 497236 RPT SDR COMA0460554Floorbeam · corrodedCARGO FLOORBEAM CAP IS CORRODED. REPAIRED IAW CRJ SRM 51-42-21.SDR COMA0460553Floorbeam · corrodedCARGO FLOOR CAP IS CORRODED. REPAIRED IAW CRJ SRM 51-42-06, 61-42-21 AND 51-42-24 AND 51-40-11.SDR COMA0460546Floorbeam · crackedLEFT HAND CARGO FLOOR ANGLE FS 621.00 CRACKED. REPAIRED IAW REO 601R-53-61-117.SDR COMA0460545Floorbeam · crackedCARGO FLOORBEAM CAP CRACKED. REPAIRED IAW CRJ SRM 51-42-13.SDR SWAA042805Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS BS 1016, LBL 9 TO LBL 17, CORRODED. REPAIRED FLOORBEAM PER ER.SDR USAA040667Floorbeam · corrodedFLOORBEAM BS 1480, LBL36, 5.5 INCHES X 3 INCHES, CORROSION. REMOVED AND REPLACED FLOORBEAM IAW SRM 53-00-51.SDR SWIA200413910Floorbeam · crackedCARGO COMPARTMENT FLOOR ATTACH ANGLE IS CRACKED; FS 621.00 LBL 38.0. ITEM FOUND AT C-CHECK INSPECTION. CRACKED ATTACH ANGLE REPAIRED IAW CRJ REO #601R-53-61-117. REV "B".SDR CALA0400655Floorbeam · corrodedINSPECTION FOUND UPPER SURFACE OF CABIN FLOORBEAM CORRODED AT STA 740, LBL 14 TO RBL 8. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, FIGURE 203.SDR SWAA042807Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 259.5, LBL 11 TO RBL 11, CORRODED. REMOVED AND REPLACED FLOORBEAM CHORD SECTION PER SRM.SDR SWAA042802Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM AT BS 860, LBL 8 TO RBL 8, CORRODED. REPAIRED FLOORBEAM PER EA.SDR F3LA200400100Floor Support · crackedDURING C-4 CHECK, INSPECTION REPORTED FLOOR SUPPORT CRACKED AT STA 927 - 947.5, RBL 16. REMOVED FLOOR SUPPORT TO REPLACE CRACKED FLANGE. REPAIRED CRACKED FLANGE AND REINSTALLED FLOOR SUPPORT PER BOEING DRAWING 65-36656, 737-300 SRM 51-40-02 AND 51-10-02, ANDSDR F3LA200400099Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED FLOORBEAM AT STA 947.5 CORRODED AT FLOOR PANEL NUT PLATES. REPAIRED FLOORBEAM UPPER CHORD PER SRM 53-00-51, 51-40-02, 51-20-01 AND MM 51-21-01.SDR F3LA200400098Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED FLOORBEAM AT STA 986.5 CORRODED AT FLOOR PANEL NUT PLATES. REPLACED FLOORBEAM UPPER CHORD AT STA 986.5 PER SRM 53-60-51, 53-00-51, FIG 202, AND MM 51-20-01.SDR UPS04443341Floorbeam · corrodedINSPECTION TYPE: C, FWD CARGO STA 960 RBL 45 FLOOR SUPPORT CORROSION FOUND. CORROSION REMOVED IAW SRM 51-10-01. CORROSION BLEND OUT 0.050 X 2 X 2 INCH EXCEED SRM 53-10-01 FIG 01 LIMITS. FLOORBEAM FLANGE REPAIRED PER SRM 54-40-04 FIG 1. CIC APPLIED IAW EO MSDR UPS04443340Floorbeam · corrodedINSPECTION TYPE: C, FWD CARGO STA 840 RBL 30 FLOOR SUPPORT CORRODED. CORROSION REMOVED IAW SRM 51-10-01. CORROSION BLEND OUT 0.050 X 1 X 2 INCH EXCEED SRM 53-10-01 FIG 1 LIMITS, FLOOR SUPPORT REPAIRED PER SRM 51-40-04 FIG 2. CIC APPLIED IAW EO M-5100-2780-ESDR AWXA200401090Floorbeam · corrodedDURING BC-4 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 RT AT FR 68. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y1292 RT FROM FR 67 TO FR 68; FABRICATED A NEW REPLACEMENT SECTION OF BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-42-11.SDR AWXA200401084Floorbeam · corrodedDURING BC-4 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 LT, AT FR 68. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y1292 LT FROM FR 67 TO FR 68; FABRICATED A NEW REPLACEMENT SECTION OF BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR AWXA200401130Floorbeam · corrodedDURING BC-4 CHECK GALVANIC CORROSION WAS FOUND ON LONGITUDINAL FLOORBEAM Y1292, UNDER LT AFT LAVATORY AT FR 66. MAINTENANCE REMOVED FLOORBEAM Y1292 LT AT FR 66; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-71-11.SDR IXXA0500039SFloorbeam · damagedDURING A ROUTINE C CHECK INSPECTION, FOUND LT FUSELAGE AFT CENTER SECTION FLOORBEAM INTERIM REPAIR STA 1560.000, LBL 45 INCH. REPAIR ACCOMPLISHED, REMOVED INTERIM REPAIR. PERFORMED BLEND OUT ON DAMAGE AREA, FOUND OUT OF LIMITS. FABRICATED FILLER AND REPAIR SDR IXXA0500038SFloorbeam · corrodedDURING A ROUTINE C CHECK INSPECTION, FOUND TH FUSELAGE FORWARD CENTER SECTION FLOORBEAM CAP UPPER CORROSION DAMAGE STA 857.000, LBL 32 INCH. REPAIR ACCOMPLISHED. REMOVED CORROSION AND FOUND OUT OF LIMITS. REMOVED THE CORRODED AREA AND FABRICATED FILLER AND SDR SWIA200414272Floorbeam · crackedFLOORBOARD FRAME CRACKED AT STA 621 LEFT SIDE. ITEM FOUND AT C-CHECK INSPECTION. INSTALL REPAIR ANGLES IAW REO 601R-53-61-117.SDR EIA2004106Floorbeam · damagedBS 420 FLOORBEAM UPPER DECK, UPPER CHORD FWD FLANGE. HOLE AT RBL 52.0 WAS REAMED TO MAX 0.34 DIAM, WITH CRACK INDICATIONS REMAINING. MUST BE REPAIRED PER SB. REPAIR HOLE BS 420, RBL 52.0 FWD HORIZ FLANGE PER SB 747-53-2439, FIG 9, SHT 1-6SDR AWXA200401074Floorbeam · corrodedDURING BC-4 CHECK, EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 RT FORWARD AND AFT OF FS 67. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y1292 RT FROM FS 67 TO FS 68; FABRICATED A NEW REPLACEMENT SECTION OF BEAM PER DWG 18D53472172; INSTALLED REPAIR PART IASDR AWXA200401072Floorbeam · corrodedDURING BC-4 CHECK, EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 LT AT FS 68. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y1292 LT FROM FS 68 TO FS 69; FABRICATED A NEW REPLACEMENT SECTION OF BEAM; INSTALLED REPAIR PART IAW A319 SRM 51-72-11.SDR SWAA042755Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM WEB AT BS 1010, LBL 39, CORRODED. REMOVED AND REPLACED FLOORBEAM WEB PER SRM.SDR SWAA042749Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM WEB AT BS 328, RBL 45, CORRODED. REPAIRED FLOORBEAM WEB PER ER.SDR 04FDEA02797Floorbeam · corrodedBULK CARGO COMPT FLOOR STRUCTURE FS 65 ON LT SIDE, MID AND RT SIDE AREA NOTED CORROSION ON TOP AND UNDERNEATH SURFACES. REMOVED AND REPLACED BEAM IAW A310 SRM 53-10-15.SDR 04FDEA02795Floorbeam · corrodedAFT CARGO COMPT FS 63 FLOOR STRUCTURE, ON LEFT SIDE 3EA AREAS OF CORROSION ON TOP SURFACE AND UNDERNEATH FLOOR STRUCTURE. REMOVED AND REPLACED FLOOR STRUCTURE BEAM IAW A310 SRM 51-40-21.SDR ASAA0410400Floorbeam · corrodedCORROSION ON FLOORBEAM AT FLANGE AROUND NUT PLATE. REMOVED CORROSION, AND REPAIRED FLOORBEAM.SDR 371PA0071Floorbeam · corrodedFWD CABIN FLOORBEAM AT BS 294.5 HAS CORROSION FROM LBL 12 TO RBL 45. REPAIRED PER SRM 53-10-51.SDR SWIA200413872Floorbeam · crackedFS 280.00 RT FLOORBEAM RBL 9.0 OB ATTACH ANGLE CRACKED. (ITEM FOUND AT C-CHECK INSPECTION.) ANGLE REPLACED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-20 AND 51-23-00.SDR 04FDEA02783Floorbeam · crackedMDIS 421 53-10 0009108 21SEP04 SIN CLOSE U- QA PICKUP FLOORBEAM AT FWD FACE OF FR 33, BETWEEN -Y450 AND -Y953 WITH HAIR LINE CRACK. ENT BY: 275296 RPT BY: 275296 FACT 21SEP04 02:26 SIN U FLOORBEAM REPAIR C/O IAW SRM 53-10-15 FIG 201 SH 4A. RII B
Back to JASC 5315