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 SWAA032286Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAMS CORRODED (3 EA) BETWEEN BS 859 AND BS 861, RBL 8, LBL 3 AND LBL 8. REPAIRED FLOORBEAMS PER SWA EA.SDR 2003UALA00784Floorbeam · dentedFWD PIT STA 720 FLOORBEAM T-CHORD AT RBL 10 APPROX IS DENTED ON THE HORIZONTAL FLANGE & EXTENDS INTO THE RADIUS OF THE FLANGE. MAJOR REPAIR ACCOMPLISHED. THE FLANGE WAS TRIMMED OUT AS MUCH AS POSSIBLE. ACP HFEC NDT INSP OF AREA FOR CRACKS, NONE FOUND. THISSDR SWAA032283Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 771, RBL 8. REPAIRED FLOORBEAM PER EA.SDR 03FDEA01765Floorbeam · damagedSTA 950F, WL 208, LBL 30 & 36 FLOORBEAM HAS TOOL MARKS. BLENDED TOOL MARKS FROM 950F FLOORBEAM WL 208, LBL 30-36, REMOVED 1 X1 X.150 & 1 X2 X.045 FROM ORIGINAL OF .225 . OUT OF LIMIT PER SRM 51-10-1. CUT OFF DAMAGE SECTION OF FLOOR BEAM, AFT UPPER SDR UPS03841604Floorbeam · corrodedINSPECTION TYPE: C3, AIR CONDITIONING ACCY COMPARTMENT AT STA 46 RBL 44. FLOORBEAM MISSING TWO FASTENERS. UPON INSP OF MISSING FAST FOUND FLOORBEAM TO BE CORRODED, REMOVED CORRODED IAW DC8 SRM 51-1-8 OUT OF LIMITS IAW DC8 SRM 53-2-0, REMOVED FLOORBOARD AN SDR C2XA03TY179Floorbeam · corrodedDURING A SCHEDULED 2C INSPECTION THE RT FLOORBEAM TOP PLATES AT FR 20 AND FR 22 WERE CORRODED AT THE NUT PLATE HOLES. MAINT INSTALLED THE RT FLOORBEAM TOP PLATES AT FR.20 - 22. IAW EMB 135/145 SRM 51-40-02. ALL WORK WAS ACCOMPLISHED AND WILL BE REL. AT COMPLSDR SIMA200329303Floorbeam · corrodedDURING AN MBV INSPECTION, THE LEFT FLOORBEAM AT FRAME 20 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. BLENDED THE CORRODED AREA AND PERFORMED AN NDT INSPECTION. FABRICATED AN EXTERNAL ANGLE, FILLER, SHIMS AND PLATE. REPAIR DONE IAW EMB 145 SRM, SRM 145/1142 RSDR 03FDEA01743Floorbeam · damagedSTA 1163 FLOORBEAM REPAIR NOT IAW STANDARD REWORK DRAWING. REWORKED FLOORBEAM REPAIR STA 1163 IAW EA 7-5310-55026SDR AWXA200301405Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND ON AFT CARGO COMPARTMENT FLOORBEAM AT NUT PLATES BETWEEN BS 1500 TO BS 1510, LBL 14. MAINTENANCE REMOVED CORRODED FLOORBEAM CAP BETWEEN BS 1500 TO BS 1510, LBL 14; FABRICATED A NEW REPLACESDR AWXA200301401Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND AT NUT PLATES ON AFT CARGO COMPARTMENT FLOORBEAM FROM BS 1503 TO BS 1513, RBL 9. MAINTENANCE REMOVED CORRODED SECTION OF FLOORBEAM FROM BS 1503 TO BS 1513, RBL 9; FABRICATED 2 EACH FILLERSSDR AWXA200301359Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK INTERGRANULAR CORROSION WAS FOUND AT NUT PLATES ON AFT CARGO COMPARTMENT FLOORBEAM BS 1502-1517, RBL 2. MAINTENANCE REMOVED DAMAGED SECTION OF CARGO FLOORBEAM FROM BS 1502 TO BS 1517, RBL 2; FABRICATED A REPAIR ANGLE & FSDR AWXA200301357Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK INTERGRANULAR CORROSION WAS FOUND AT NUT PLATES ON AFT CARGO COMPARTMENT FLOORBEAM BS 1503-1540, LBL 2. MAINTENANCE REMOVED DAMAGED SECTION OF CARGO FLOORBEAM FROM BS 1503 TO BS 1540, LBL 2; FABRICATED A REPLACEMENT FLOOSDR AWXA200301356Floorbeam · crackedLCQ - MAJOR REPAIR - DURING C-09 CHECK A .5625 INCH CRACK WAS FOUND ON AFT CARGO COMPARTMENT FLOORBEAM BS 1600, LBL 2. MAINTENANCE REMOVED DAMAGED SECTION OF CARGO FLOORBEAM FROM BS 1545 TO BS 1640, LBL 2; FABRICATED A REPAIR CHANNEL; INSTALLED REPAIR PART IASDR AWXA200301355Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK INTERGRANULAR CORROSION WAS FOUND AT NUT PLATES ON LOWER SIDE OF AFT CARGO COMPARTMENT FLOORBEAM BS 1500 TO BS 1540, LBL 9. MAINTENANCE REMOVED DAMAGED SECTION OF CARGO FLOORBEAM FROM BS 1500 TO BS 1540, LBL 9; FABRICATESDR AWXA200301354Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND AROUND NUT PLATES HOLES OF AFT CARGO COMPARTMENT FLOORBEAM BS 1624 TO BS 1638, RBL 14. MAINTENANCE REMOVED CORRODED SECTION OF FLOORBEAM UPPER CAP AT BS 1624 TO BS 1638, RBL 14; FABRICATEDSDR C2XA03SH386Floorbeam · corrodedSHV- DURING C-CHECK THE LEFT HAND OMEGA BEAM BETWEEN FRAMES 19 AND 20 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 135 SRM 53-21-10 FIGURE 201 SHEET 1. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AWXA200301402Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND ON LOWER SURFACE OF AFT CARGO COMPARTMENT FLOORBEAM BS 1474, RBL 9. MAINTENANCE REMOVED CORRODED SECTION OF FLOORBEAM FROM BS 1474, RBL 9; FABRICATED REPAIR ANGLES; INSTALLED REPAIR PARTS SDR AWXA200301361Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND AT NUT PLATES ON AFT CARGO COMPARTMENT FLOORBEAM BS 1320, LBL 2. MAINTENANCE REMOVED DAMAGED SECTION OF CARGO FLOORBEAM FROM BS 1215 TO BS 1320, LBL 2; FABRICATED A REPLACEMENT FLOORBEAM ASDR AWXA200301360Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK INTERGRANULAR CORROSION WAS FOUND ON AFT CARGO COMPARTMENT FLOORBEAM BS 1460-1480, RBL 18. MAINTENANCE REMOVED DAMAGED T-ANGLE AND ATTACH BRACKETS FROM BS 1460-1480, RBL 18; FABRICATED A NEW REPLACEMENT ANGLE AND ATTACH SDR AWXA200301358Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND AT NUT PLATES ON AFT CARGO COMPARTMENT FLOORBEAM BS 1470, LBL 2. MAINTENANCE REMOVED DAMAGED SECTION OF CARGO FLOORBEAM BS 1470, LBL 2; FABRICATED A REPAIR ANGLE & FILLER; INSTALLED REPAIRSDR AWXA200301351Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND ON NUT PLATES LOWER SIDE OF AFT CARGO COMPARTMENT FLOORBEAM BS 1304 TO BS 1312, LBL 2. MAINTENANCE REMOVED DAMAGED FLOORBEAM FROM BS 1215 TO BS 1320, LBL 2; FABRICATED A NEW REPLACEMENT FLSDR AWXA200301349Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND ON NUT PLATES LOWER SIDE OF AFT CARGO COMPARTMENT FLOORBEAM BS 1470, RBL 20. MAINTENANCE REMOVED DAMAGED FLOORBEAM FROM BS 1440 TO BS 1500, RBL 20; FABRICATED A NEW REPLACEMENT FLOORBEAM; SDR AWXA200301295Floorbeam · corrodedDURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND ON AFT CARGO COMPARTMENT FLOORBEAM AT BS 1470, RBL 2. MAINTENANCE REMOVED DAMAGED AREA OF FLOORBEAM BETWEEN BS 1450 AND BS 1480, RBL 2; FABRICATED 4 EACH REPAIR ANGLES AND 2 EACH CHANNELS; INSTALLED REPAIR PARSDR AWXA200301294Floorbeam · corrodedDURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND ON AFT CARGO COMPARTMENT FLOORBEAM AT BS 1320 AND BS 1330, RBL 2. MAINTENANCE REMOVED DAMAGED AREA OF FLOORBEAM BETWEEN BS 1235 AND BS 1340, RBL 2; FABRICATED A NEW REPLACEMENT SECTION OF FLOORBEAM AND REPAIR SDR AWXA200301293Floorbeam · corrodedDURING C-09 CHECK INTERGRANULAR CORROSION WAS FOUND ON AFT CARGO COMPARTMENT FLOORBEAM AT BS 1330, RBL 14. MAINTENANCE REMOVED DAMAGED AREA OF FLOORBEAM AT BS 1330, RBL 14; FABRICATED REPAIR ANGLES AND A FILLER; INSTALLED REPAIR PARTS IAW B757-200 SRM 51-70-1SDR AWXA200301292Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK INTERGRANULAR CORROSION WAS FOUND ON AFT CARGO COMPARTMENT FLOORBEAM AT BS 1362, RBL 14. MAINTENANCE REMOVED DAMAGED AREA OF FLOORBEAM BETWEEN BS 1343 AND BS 1365, RBL 14; FABRICATED 4 EACH REPAIR ANGLES & 2 EACH CHANNELSDR C2XA03SH383Floorbeam · corrodedDURING C-CHECK THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED AT FR 20. MAINTENANCE REMOVED AFFECTED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB SRM 53-21-20. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AWXA200301279Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-17 CHECK CORROSION WAS FOUND ON FLOORBEAM AT BS 993, LBL 15 TO LBL 20.70. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED DAMAGED SECTION OF FLOORBEAM AT BS 993, LBL 15 TO LBL 20.70; FABRICATESDR LR7A03081Floorbeam · corrodedDURING SCHEDULED B1 INSPECTION 02/GEN/16 ACCOMPLISHMENT FOUND FS 737, BL 0, WL 146 'D' RING PULLED. FURTHER ACCESS REVEALED FLOORBEAM UPPER CAP CORRODED. REPLACED CAP IAW SRM SMP 583 53-40-06. NR 0012.SDR SIM2004F00000Floorbeam · corrodedDURING INSPECTION THE LT FLOORBEAM WAS FOUND TO BE CORRODED BELOW SRM LIMIT BETWEEN FRAMES 24 AND 25. COMPLETELY REMOVED THE CORROSION BY CREATING A CUT OUT IN THE DAMAGED FLANGE AND WEB OF THE LT FLOORBEAM. FABRICATED A REPAIR ANGLE, FILLER AND SHIMS FOR RESDR SIMA200328804Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE RIGHT FLOORBEAM WAS FOUND TO BE CORRODED BELOW SRM LIMITS BETWEEN FRAMES 24 AND 25. COMPLETELY REMOVED THE CORROSION BY CREATING A CUT OUT IN THE DAMAGED FLANGE AND WEB OF THE RIGHT FLOORBEAM. FABRICATED A REPAIR ANGLE, FSDR SIMA200328806Floorbeam · corrodedDURING AN IMBV INSPECTION, THE CENTER SECTION OF THE FORWARD DIGITAL WAS FOUND TO BE CORRODED BEYOND SRM LIMITS. REMOVED DAMAGED SECTION OF THE FORWARD DIGITAL BY CUTOUT. FABRICATED A REPLACEMENT FORWARD DIGITAL CENTER SECTION, FABRICATED TWO DOUBLERS, SHIMSSDR SIMA200328805Floorbeam · corrodedDURING AN IMBV INSPECTION, THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED BELOW SRM LIMITS BETWEEN FRAMES 24 AND 25. COMPLETELY REMOVED THE CORROSIN BY CREATING A CUT OUT IN THE DAMAGED FLANGE AND WEB OF THE LEFT OMEGA BEAM. FABRICATED A REPAIR ANGLE, FILLER ANSDR C2XA03TY195Floorbeam · corrodedTYS DURING A SCHEDULED 3C INSPECTION THE LT OMEGA BEAM WAS FOUND CORRODED. MAINT REMOVED CORRODED AREA, FABRICATED A NEW DOUBLER AND INSTALLED FILLER, SHIMS, PLATE AND DOUBLER. ALODINED, PRIMED AND REPAINTED WORK AREA. REINSTALLED RAMP ANGLE. ALL WORK WASSDR C2XA03TY194Floorbeam · corrodedTYS DURING A SCHEDULED 3C INSPECTION THE CENTER OMEGA BEAM AT FR 20 WAS CORRODED. MAINT INSTALLED A NEW OMEGA BEAM IAW EMB 135/145 SRM 51-40-02. ALL WORK WAS ACCOMPLISHED AND WILL BE RELEASED UPON COMPLETION OF ALL WORK.SDR AWXA200301317Floorbeam · corrodedDURING C-15 CHECK INTERGRANULAR CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF AFT CARGO COMPARTMENT FLOORBEAM AT NUT PLATE HOLES BS 773, RBL 8. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUTOUT CORRODED AREA OF FLOORBEAM BSSDR AWXA200301283Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK FOUND AFT CARGO COMPARTMENT FLOORBEAM EXFOLIATED AND SPLIT AT BS 773, RBL 13. MAINTENANCE CUTOUT DAMAGED SECTION OF FLOORBEAM AT BS 773, RBL 13; FABRICATED A REPAIR PLATE, EXTRUSION, ANGLE, AND CHANNEL FILLER; INSTALLED RSDR 03FDEA01713Floorbeam · corrodedCORROSION BS 320-340, RBL 40, WL 208 ON TOP OF FLOORBEAM AND INTERCOSTAL REMOVED AND REPLACED FLOORBEAM.SDR AWXA200301266Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK INTERGRANULAR CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF AFT CARGO COMPARTMENT FLOORBEAM BS 773, LBL 3. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUT OUT DAMAGED SECTION OF FLOORBESDR AWXA200301318Floorbeam · corrodedDURING C-15 CHECK INTERGRANULAR CORROSION WAS FOUND ON AFT CARGO COMPARTMENT FLOORBEAM AT NUT PLATE HOLES BS 727D, RBL 8. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUTOUT CORRODED AREA OF FLOORBEAM BS 727D, RBL 8; FABRICATED 2SDR AWXA200301267Floorbeam · corrodedDURING C-15 CHECK INTERGRANULAR CORROSION WAS FOUND ON UPPER OF AFT CARGO COMPARTMENT FLOORBEAM AROUND NUT PLATES AT BS 727+5, LBL 3. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUTOUT DAMAGED SECTION OF FLOORBEAM BS 727+5, LBL 3SDR AWXA200301265Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK INTERGRANULAR CORROSION WAS FOUND ON LOWER SURFACE OF AFT CARGO COMPARTMENT FLOORBEAM AROUND NUT PLATES AT BS 727D+5, RBL 3. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUT OUT DAMAGED SECTSDR AWXA200301264Floorbeam · corrodedDURING C-15 CHECK INTERGRANULAR CORROSION WAS FOUND ON UPPER SURFACE OF AFT CARGO COMPARTMENT FLOORBEAM AND NUT PLATES AT BS 727D+5, LBL 8. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUT OUT DAMAGED SECTION OF FLOORBEAM BS 727DSDR 03FDEA01706Floorbeam · corrodedCORROSION (C53-111-01(3)) ON BS 1148 FLOORBEAM LOWER CHORD BL 0, WL 200. *S/D* CORROSION ON FLOORBEAM AT BS 1148 LOWER CHORD BL 0 WL 200 WAS FOUND TO BE OUT OF LIMITS. REPAIRED FLOORBEAM PER FED EX EA 7-5310-55019.SDR 2003UALA00747Floorbeam · crackedAFT PIT STA 1439 LT SIDE AT LBL 23, FLOORBEAM IS CRACKED. MAJOR REPAIR ACCOMPLISHED. INSTALLED ANGLE AND FILLER REPAIR.SDR SIMA200327911Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE GALLEY HAT BEAM AT FRAME 22 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. BLENDED THE CORRODED AREA AND PERFORMED AN NDT INSPECTION. CLEANED, TREATED AND APPLIED EPOXY PRIMER TO BLENDED AREA. FABRICATED A DOUBLER REPAIR DONSDR C2XA03TY176Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE GALLEY FLOOR SUPPORT CENTER OMEGA BEAM. MAINTENANCE REMOVED AND REPLACED THE OMEGA BEAM IAW EMB SRM 51-40-02, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTISDR C2XA03TY174Floorbeam · corrodedDURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE GALLEY FLOOR SUPPORT CENTER OMEGA TOP CAP. MAINTENANCE REMOVED AND REPLACED THE TOP CAP IAW EMB SRM 41-40-02, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR C2XA03TY173Floorbeam · corrodedDURING A SCHEDULED INSPECTION THE FORWARD FLOORBEAM AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE ACCOMPLISHED A DOUBLER REPAIR IAW EMB SRM 53-21-10 AND CPM 51-21-04/05/06, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSSDR USAA030206Floorbeam · corrodedFOUND FLOORBEAM CORRODED 24 INCHES, BS 700, LBL 50, CABIN FLOOR LEVEL. REPAIRED PER TYPICAL REPAIR 53-15-01. (M)
Back to JASC 5315