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 2002UALA00425Floorbeam · corrodedCABIN FLOOR UPPER T-CAP UPPER SURFACE CORRODED STATION 365 RBL 10 STRINGER 17R. MAJOR REPAIR ACCOMPLISHED. INSTALLED STRAP AND L-ANGLE REPAIR.SDR 2002UALA00419Floorbeam · corrodedSTATION 986.5 FLOORBEAM RBL 18 TO RBL 39 CORRODED. MAJOR REPAIR ACCOMPLISHED. ACCOMPLISHED ANGLE REPAIR.SDR SWAA020537Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 947.5, LBL 5. REPAIRED FLOORBEAM PER SRM.SDR 2002UALA00411Floorbeam · damagedCABIN FLOORBEAM MATERIAL REMOVED EXCEEDS LIMITS STATION 345 RBL 61. MAJOR REPAIR ACCOMPLISHED. TOP T-CAP SPLICED.SDR 2002UALA00408Floorbeam · corrodedFORWARD CABIN FLOORBEAM STATION 310 LBL 18 HAS EXCESIVE MAT LOSS AFTER DAMAGE CLEAN UP. MAJOR REPAIR ACCOMPLISHED. INSTALLED ANGLE AND STRAP REPAIR.SDR 2002UALA00397Floorbeam · damagedAFT CABIN STATION 947 LBL 5 AND LBL 15 HAS EXCESSIVE MATERIAL LOSS. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM UPPER CAP WITH SINGLE FLANGE BLEND OUT REPAIR. INSTALLED SINGLE REPAIR ANGLE.SDR SWAA020524Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 807, LBL 8. REPAIRED FLOORBEAM PER SWA RA.SDR AALA20020358Floorbeam · damagedTUL - FOUND FLOORBEAM LOWER FLANGE AT 389 RBL 15 DAMAGED FROM CARGO DOOR. CUT OUT DAMAGE AND INSTALLED L-ANGLE DOUBLER PER AARD 53-20-00-21. (M)SDR SIMA200207008Floorbeam · corrodedABI - DURING AN IMBV INSPECTION OF AIRCRAFT, FOUND CORROSION ON THE GALLEY AREA FORWARD DIGITAL. PERFORMED AN NDT INSPECTION OF THE AREA WITH NO REJECTABLE INDICATIONS. FABRICATED A REPLACEMENT STRAP, TWO DOUBLERS AND A SHIM. WORK DONE IAW EMB 145 SRM 145/1SDR RIVA020308EFloorbeam · corrodedMQY - FOUND FLOORBEAM CORRODED AT STATION 1110 FROM LBL 45 INCHES TO RBL 20 INCHES HAS BEEN BLENDED TO LIMITS IAW B727 SRM 53-10-1, FIG 4. CORROSION STILL EXISTS IN AREA. REMOVED AND REPLACED UPPER T-CHORD AT STATION 1110 LBL 69 TO RBL 34.5 IAW B727 SRM 53-1SDR RIVA020308FFloorbeam · corrodedMQY - FOUND STATION 344 FLOORBEAM CORROSION REMOVED TO MAX LIMITS PER SRM. CORROSION STILL EXISTS RBL 25 INCHES - LBL 25 INCHES. REMOVED DAMAGED SECTION AND REPLACED WITH NEW T-CAP AND SPLICES IAW B727 SRM 53-10-8, 51-30-2 AND 51-10-2. NEW REPLACEMENTS PARTSDR RIVA020308GFloorbeam · corrodedFOUND STATION 380 FLOORBEAM CORROSION. REMOVED TO MAX LIMITS PER SRM. CORROSION STILL EXISTS RBL 13 INCHES - 33 INCHES RBL. REMOVED EXISTING REPAIR T-CAP. FABRICATED NEW SECTION AND INSTALLED IAW B727 SRM 53-10-8, FIG 3 AND 51-10-2, 51-30-2. NEW REPLACEMESDR RIVA020308HFloorbeam · corrodedMQY - FOUND STATION 400 FLOORBEAM CORROSION REMOVED TO MAX LIMITS PER SRM. CORROSION STILL EXISTS LBL 18 INCH - RBL 15 INCH. REMOVED AND INSTALLED REPAIR SECTION T-EXTRUSION IAW B727 SRM 53-10-8, FIG 3 AND 51-10-2. NEW REPLACEMENT PARTS USED. NO CHANGE IN WSDR RIVA020308JFloorbeam · corrodedMQY - FOUND FLOORBEAM STATION 420 RBL 3 INCH CORROSION BLEND TO LIMITS IAW B727 SRM 53-10-1, FIG 4 CORROSION STILL EXISTS. CUT OUT CORRODED AREA PER B727 SRM 53-10-8, FIG 8. TREATED AND PRIMED PER SRM 51-10-2. INSTALLED FILLER AND REPAIR ANGLES PER SRM 53-1SDR RIVA020308KFloorbeam · corrodedMQY - FOUND FLOORBEAM STATION 328 UPPER FLANGE CORRODED BEYOND LIMITS LBL 30 INCHES AND RBL 13 INCHES UPPER AND LOWER SURFACES. REMOVED DAMAGED SECTION IAW B727 SRM 53-10-8. FABRICATED REPAIR SECTION AND SPLICES IAW B727 SRM 53-10-8. TREATED, PRIMED AND INSSDR 2002UALA00410Floorbeam · gougedCABIN FLOORBEAM GOUGED, STATION 680 LBL 22, UPPER CAP OF CABIN FLOOR. MAJOR REPAIR ACCOMPLISHED. T-CAP REPAIR INSTALLED.SDR COOSDR02012Floorbeam · crackedMAIN CARGO COMPARTMENT. Y STA 1580, Z0, +49.0 AND +X56.0, FLOORBEAM UPPER CHORD WITH CRACK.SDR 2002UALA00375Crease Beam · corrodedCABIN FLOOR CREASE BEAM WEB UPPER SURFACE CORRODED AT OUTBOARD EDGE AROUND ATTACH FASTENERS AT THREE PLACES BETWEEN BODY STATION 960 AND BODY STATION 984, RBL 68.50 AND WL208. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM.SDR LR7A02021Cap · crackedDURING SCHEDULED C3 INSPECTION PER JOB CARD HC05297 FOUND FS 577 LOWER BEAM CAP CRACKED AT RBL 58, WL 138.REPAIRED IAW LAC MEA 382-53-02-011. NR 2134.SDR LR7A02018Fitting · crackedDURING SCHEDULED C3 INSPECTION PER JOB CARD HSP53121 FOUND RH FS 577 BULKHEAD END FITTING CRACKED AT RBL 60, WL 142.REPLACED FITTING IAW SRM SMP 583 51-10 PG 4. NR 2089.SDR LR7A02015Fitting · crackedDURING SCHEDULED C3 INSPECTION PER JOB CARD HSP53121 FOUND LH FS 577 BULKHEAD END FITTING CRACKED AT LBL 60, WL 142.REPLACED FITTING IAW SRM SMP 583 51-10 PG 4. NR 2077.SDR 2002UALA00355Floorbeam · gougedSTATION 1600, FLOORBEAM CAP RBL 5 TO LBL 18 HAS GOUGES IN AREA OF AFT CABIN. MAJOR REPAIR ACCOMPLISHED. FLOORBEAM DOUBLER INSTALLED.SDR C2XA02IA047Beam · corrodedIAH, During C-check inspection the floor beam top plate at frame 14 was found to be corroded beyond limits. Maintenance repaired the affected portion of floor beam utilizing a splice repair in accordance with EMB 145 SRM 53-21-10SDR 02FDEA00177Floorbeam · damagedHOLES IN FLOORBEAM BS 1150, BL0, WL 208.1. R&R FLOORBEAM PER SRM 53-10-8 FIG 3.SDR 2002UALA00343Floorbeam · corrodedCABIN FLOORBEAM STATION 986 RBL 43 UPPER CAP IS CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED FLOORBEAM UPPER CAP REPAIR ANGLE AND STRAP.SDR 2002UALA00337Floorbeam · corrodedFLOORBEAM T-CAP HAS CORROSION BODY STATION 1197, LBL 1 UNDER NUT PLATE. MAJOR REPAIR ACCOMPLISHED. REPAIRED T-CAP.SDR SWAA020480Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 770, LBL 7 AND LBL 17. REPAIRED FLOORBEAM PER SWA RA.SDR C2XA02IA050Floorbeam · corrodedIAH - MAINTENANCE FOUND CORROSION OUT OF LIMITS ON THE FLOORBEAM AT FRAME 20. A SPLICE REPAIR WAS ACCOMPLISHED ON THE AFFECTED AREA OF FLOORBEAM IN ACCORDANCE WITH THE EMB SRM 53-21-00, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 2002F00511Floorbeam · corrodedAT CHECK, FOUND AFT CARGO FLOORBEAM EXFOLIATED AT STATION 1030 STRINGER 30. (M)SDR 2002F00510Floorbeam · corrodedAT C-CHECK, FOUND AFT CARGO PIT FLOORBEAM CORRODED AT STATION 1030 STRINGER 28R. (M)SDR COOSDR02044Floorbeam · crackedMAIN CARGO CABIN - STA Y=1600-FLOOR BEAM UPPER CHORD CRACKED.SDR UPS02437829Floorbeam · crackedINSPECTION TYPE:C AFT CARGO COMPT - BS 1880, LBL 30 FLOORBEAM CORROSION CRACKED. REPAIR FLOORBEAM PER SRM 51-40-04.SDR COOSDR020001Floorbeam · crackedFRAME TO FLOORBEARM STRUT, CRACKED.SDR COOSDR02011Floorbeam · corrodedMAIN CARGO COMPARTMENT Y STA 1680, Z0, -X10, FLOOR BEAM WITH CORROSION.SDR CALA0200121Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 340, RBL 12 TO LBL 12. THE CORRODED AREA OF FLOORBEAM WAS REMOVED AND A NEW SECTION WAS INSTALLED IAW SRM 53-10-51, FIGURE 205.SDR MWEA020146Floorbeam · chafedSTATION 617 FLOORBEAM IS LOOSE JUST INBOARD OF THE NR 2 SEAT TRACK, SHOWS SIGNS OF CHAFING. REMOVED AND REPLACED FLOORBEAM.SDR UPS02437804Floorbeam · chafedINSPECTION TYPE:C AFT CARGO COMPT - BS 1600 LBL 2 TO RBL 2 FLOORBEAM UPPER CHORD CHAFED. FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG 2.SDR UPS02437863Floorbeam · corrodedINSPECTION TYPE:C AFT CARGO COMPT - BS 1880 S48L FLOORBEAM UPPER CHORD SUPPORT PAD CORRODED. FLOORBEAM UPPER CHORD SUPPORT PAD REPLACED AS PER SRM 51-10-01.SDR UPS02437862Floorbeam · crackedINSPECTION TYPE:C AFT CARGO - BS 1820 LBL 47 FLOORBEAM FOUND CORR CRACK AS MARK. FLOORBEAM REPAIR AT BS 1820 LBL 47 MOST O/B AS PER SRM 51-40-04.SDR 02FDEA00156Floorbeam · corrodedCORROSION C53-111-01(3) LWR SURFACE OF UPPER CHORD OF FLOORBEAM BS 1166, RBL 3, WL 208. REMOVED AND REPLACED FLOORBEAM PER SRM 53-10-8 FIG 8.SDR SIMA200207810Floorbeam · corrodedTHIS IS A LEVEL 2 FINDING. LEFT FLOORBEAM CORRODED AT FRAME 26. REMOVED CORROSION, NDT AND RETREATED IAW EMB 145 GST-0714/02. (M)SDR C2XA02TY046Floorbeam · corrodedTYS DURING A SCHEDULED 1-C INSPECTION CORROSION WAS FOUND UNDER FLOOR SUPPORT CROSS MEMBER AT FR 20 ON THE LEFT OMEGA BEAM. MAINTENANCE CUT OUT DAMAGE AREA, FAB DOUBLER, SHIM AND EXTERNAL ANGLE. INSTALL THE REPAIR PIECES AND PROFILE ANGLE IAW 135/145 SRM 53SDR TSAA0251067Floorbeam · corrodedFOUND CORROSION ON THE EXISTING UPPER FLANGE FLOORBEAM REPAIR AT STATION 1016, WL 208 BBI 0 TO LBL 15. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-10-9 FIGURE 1. AIRCRAFT RETURNED TO SERVICE. (M)SDR 2002F00442Floorbeam · corrodedAT C-CHECK, FOUND FORWARD CARGO COMPARTMENT FLOORBEAM CORRODED AT STATION 536 LBL 13. (M)SDR 2002F00427Floorbeam · corrodedAT C-CHECK, FOUND FLOORBEAM CORRODED IN FORWARD CARGO COMPARTMENT AT STATION 536 RBL 13. (M)SDR AALA20020200Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM MID SPAN. REPAIRED FLOORBEAM PER BOEING 757 SRM 53-00-51-2 AND 51-70-00. (M)SDR UPS02437843Floorbeam · crackedINSPECTION TYPE:C M/D - BS 980 RBL 65 FLOORBEAM FOUND CRACK. FLOORBEAM REPAIRED AS PER SRM 53-10-07 FIG 12.SDR SWAA020440Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAMS CORRODED AT BS 847 AND LBL 8, BS 812 AND RBL 3, BS 847 AND LBL 3. REPAIRED FLOORBEAM PER SWA RA.SDR SIMA200208301Floorbeam · corrodedTHIS IS A LEVEL 2 FINDING. CORROSION GALLEY FORWARD DIGITAL. RESTORED PROTECTIVE COATING, DAMAGE ACCEPTED AS IS IAW EMB GST-0634/02. (M)SDR CALA0200099Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED ABOVE AND BELOW NUT CLIP HOLES AT STA 986, RBL 46 TO LBL 46. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-03851.
Back to JASC 5315