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 ABXA020027Floorbeam · corrodedCORROSION ON AFT FACE OF TRANSVERSE FLOOR BEAM AT WEB STATION 996, BL 0, LBL 36.SDR 2002F00535Floorbeam · corrodedDURING SCHEDULED INSPECTION THE CABIN FLOORBEAM, T-CAP AT FS 901, LBL 30 TO RBL 30 HAD SEVERAL AREAS OF LEVEL 2 CORROSION. MAINTENANCE REPAIRED DAMAGED T-CAP SECTION IN ACCORDANCE WITH SRM 53-23-00 AND 51-40-01.SDR 02FDEA00359Floorbeam · corrodedCORROSION ON LOWER SURFACE OF FLOORBEAM FWD FLANGE AT BS 360, LBL 3.1, WL 208. REMOVED AND REPLACED FLOORBEAM PER SRM 53-10-8 FIG 3.SDR 2002UALA00904Floorbeam · corrodedSTATION 987 RBL 19 CABIN FLOORBEAM UPPER SURFACE IS CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED ANGLE REPAIR.SDR CALA0200300Channel · crackedCABIN FLOOR BEAM CHANNEL CRACKED AT MAIN FRAM ATTACH POINT AT STATION 927 RIGHT. INSTALLED NEW FLOOR BEAM CHANNEL PER SRM 51-30-00.SDR ASAA0210130Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 1006, LEFT BUTTOCK LINE 10 CORRODED. REPAIRED FLOORBEAM PER SRM. (M)SDR C1HA200292013Floorbeam · corrodedFLOORBEAM AT STA 1070 TOP IS CORRODED LBL 24-45SDR C1HA200292012Floorbeam · corrodedFLOORBEAM STA 1110 LBL 24- RBL 28 TOP FLANGE AND REPAIR HAVE CORROSION. LBL 22 HAS FLOORBOARD ATTACH HOLE WITH NO PITCH.SDR 2002F00558Floorbeam · corrodedAT C-CHECK, FOUND CORROSION ON FORWARD SIDE OF WEB AT PASSENGER COMPARTMENT FLOORBEAM, AT STATION 555 LEFT, AT LBL 67. (M)SDR SWAA021101Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 3, LBL 8 AND RBL 3. REPAIRED FLOORBEAM PER SWA RA.SDR AALA20020812Floorbeam · crackedTUL - FLOORBEAM CRACKED, STATION 927, LBL 56. REMOVED AND INSTALLED NEW FLOORBEAM PER SRM 51-01. (M)SDR C1HA200292011Floorbeam · corrodedSTA 420 FLOORBEAM IS CORRODED BETWEEN TRACK 24 RT AND FLOOR WEBSDR SIMA200214112Floorbeam · corrodedSAW - DURING CPCP4 INSPECTION, FOUND FLOORBEAM AT FRAME 39 HAS NUMEROUS SPOTS OF CORROSION AROUND NUTPLATE HOLES. RAID FLOORBEAM IAW SRM 51-25-02. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200214111Floorbeam · corrodedSAW - DURING CPCP4 INSPECTION, FOUND LOWER FLOORBEAM AT FRAME 41 HAS NUMEROUS SPOTS OF CORROSION AROUND NUTPLATE HOLES. REMOVED AND REPLACED FLOORBEAM 41 IAW SRM 51-25-01. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200214104Floorbeam · corrodedSAW - DURING CPCP 2 INSPECTION, FLOORBEAM AT FRAME 36 HAS NUMEROUS SPOTS OF CORROSION. AROUND SCREW HOLES TOP AND BOTTOM. INSTALLED NEW FLOORBEAM 36 IAW ATR42 SRM 51-25-02. AIRCRAFT RETURNED TO SERVICE. (M)SDR 2002F00561Floorbeam · corrodedAT C-CHECK, FOUND CORROSION AT AFT GALLEY FLOOR SUPPORTS AND FLOORBEAM, IN NUMEROUS PLACES, AT STATION 1887 FROM LBL 87 TO RBL 87. (M)SDR 2002F00559Floorbeam · corrodedAT C-CHECK, FOUND EXFOLIATED CORROSION AT PASSENGER COMPARTMENT FLOORBEAM, LOWER CAP, AT PRESSURE PANEL FORWARD SIDE, AT STATION 555 LEFT, LBL 67. (M)SDR 2002F00557Floorbeam · crackedAT C-CHECK, X-RAY INSPECTION INDICATES A CRACK IN LEFT FLOORBEAM LOWER CAP, AT FLOOR STRUT INTERSECTION LOWER OUTBOARD FASTENER, AT STATION 879 LEFT. (M)SDR 2002F00551Floorbeam · corrodedAT C-CHECK, FOUND CORROSION IN AFT GALLEY AREA FLOOR SUPPORTS, AT CLIP NUTS AT FLOORBEAM STATION 1921, FROM LBL 50 THROUGH RBL 50. (M)SDR CALA0200297Angle · crackedCRACK ON FLOOR SUPPORT AT STATION 1231 ABOVE STRINGER 26LT ABB. STOP DRILLED CRACK AND INSTALLED REPAIR PER EC/RA 5320-01263.SDR ABXA020026Fitting · crackedFS 775 RIGHT, CABIN FLOOR SUPPORT LOWER FITTING WAS CRACKED. REPLACED THE SUPPORT FITTING IAW DC-9 SRM 51-10-4 AND 51-30-5.SDR ABXA020025Fitting · crackedFS 775 LEFT, CABIN FLOOR SUPPORT STRUT LOWER FITTING WAS CRACKED. REPLACED THE LOWER FITTING IAW DC-9 SRM 51-30-1 AND 51-30-5.SDR ABXA020024Fitting · crackedFS 832 RIGHT, CABIN FLOOR SUPPORT STRUT LOWER FITTING WAS CRACKED. REPLACED THE SUPPORT FITTING IAW DC-9 SRM 51-10-4 AND 51-30-5.SDR ABXA020023Fitting · crackedFS 945 LEFT, CABIN FLOOR STRUT LINE FITTING WAS CRACKED. REPLACED THE STRUT LINE FITTING IAW DC-9 SRM 51-30-5.SDR ABXA020022Floorbeam · corrodedFS 937, RBL 22, HAD LEVEL I CORROSION ON THE CABIN FLOORBEAM HORIZONTAL FLANGE. REPAIRED THE FLOORBEAM IAW DC-9 SRM 53-05.SDR UPS02838543Floorbeam · crackedINSPECTION TYPE:C1 PROBLEM WITH FLOORBEAM CRACK UNDER FLANGE FS 1746 BL 2L. FABBED REPAIR PARTS IAW DC8 SRM 53-2-0. INSTALLED REPAIR PARTS IAW DC8 SRM 536-2-0 AND 51-2-20D.SDR SWAA021090Beam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL BEAM CRACKED AT BS 667, WL 206.5 AND LBL 25. REPAIRED BEAM PER BFG ER.SDR USAA020232Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED, TOP BEAM CAP STATION 967 AT LBBL 18 AT SCREW HOLE. REMOVED AND REPLACED BEAM CAP PER SRM 53-00-51. (M)SDR ABXA020018Fitting · corrodedCABIN FLOOR SUPPORT STRUT LOWER FITTING CRACKED AT FS 237, LONGERON 23 RIGHT. REPLACED FITTING IAW DC-9 SRM 51-30-5 AND 51-30-2.SDR UPS02838588Floorbeam · corrodedINSPECTION TYPE:C1 MAIN CABIN TOP MLG PRESSURE WEB AREA FLOORBEAM IS CRACKED AND CORRODED ON FWD & AFT LEG AT STA 900 LBL 44. REMOVED MVD CORROSION FROM FLOORBEAM, OUT OF LIMITS. FABBED REPAIR PARTS IAW R EO G08638 MPI OF REPAIR PARTS IAW ASTM E1444. NO CRASDR SIMA200213811Floorbeam · corrodedDURING AN MBV MAINTENANCE FOUND CORROSION ON LEFT HAND OMEGA BEAM AT FRAME 20 REMOVED CORROSION BY CUT OUT. FABRICATED A DOUBLER ANGLE, FILLERS AND SHIMS. REPAIR DONE, IAW MFG SRM.SDR SIMA200213810Floorbeam · corrodedDURING AN IMBV MAINTENANCE FOUND CORROSION ON GALLEY UNDER FLOOR CENTER BEAM. REMOVED CORRODED GALLEY CENTER BEAM. INSTALLED NEW CENTER BEAM IAW SRM.SDR SIMA200213809Floorbeam · corrodedDURING AN IMBV MAINTENANCE FOUND CORROSION ON FORWARD DIGITAL. REMOVED CORROSION BY CUT OUT. FABRICATED A REPLACEMENT STRAP, TWO DOUBLERS AND SHIMS. REPAIR DONE IAW SRM.SDR UPS02838565Floorbeam · corrodedINSPECTION TYPE:C1 AFT PIT FLOORBEAM CORRODED AT STA 1440 UPPER FWD FLANGE AT RBL 60. REMOVED CORROSION IAW DC8 SRM 51-1-8. OUT OF LIMITS IAW DC8 SRM 53-2-0. FOUND AFT FLANGE CORRODED REMOVED AFT FLANGE OF FLOORBEAM IAW TRSM 95T0345001 STD 6310-001. FABBEDSDR UPS02838531Floorbeam · crackedINSPECTION TYPE:C1 AFT PIT - STA 1060 CABIN FLOORBEAM UPPER AFT FLANGE IS CRACKED HORIZONTALLY ACROSS AFT EDGE AT RBL 60. CUTOUT CRACKED AREA IAW REO G08643. FABRICATED REPAIR ANGLE IAW REO G08643. INSTALLED REPAIR ANGLE AND FLOOR PANEL IAW DC8 SRM 51-1-20DSDR 2002UALA00876Floorbeam · corrodedCABIN FLOORBEAM AT BODY STATION 294 HAS EXCESSIVE MATERIAL LOSS AT RBL 44 DUE TO CORROSION REMOVAL. MAJOR REPAIR ACCOMPLISHED. REPLACED CHORD AND SPLICES.SDR AWXA200200437Angle · crackedYVR - MAJOR REPAIR - DURING INSPECTION A CRACK WAS FOUND ON SUPPORT ANGLE BELOW FLOOR WEB, R/H WHEEL WELL, RBL 40. MAINTENANCE REMOVED AND REPLACED CRACKED ANGLE AT R/H W/W , RBL 40 IAW B737-200 SRM 51-30-2, PG. 8.SDR AWXA200200436Floorbeam · crackedYVR - MAJOR REPAIR - DURING INSPECTION A .375 INCH CRACK WAS FOUND ON LONGITUDINAL FLOORBEAM BS 675, LBL 24.75 AT THE AILERON QUADRANT CUTOUT. MAINTENANCE REMOVED ANGLE AND PREVIOUS REPAIR PARTS, TRIMMED TAB ON CHORD AT BS 675, LBL 24.75, FABRICATED A NEW CHASDR 0201875507Floorbeam · corrodedDURING "H" CHECK FOUND CORROSION ON FLOORBEAM AT BS 377 LBL 56-59. REPAIRED PER EA 55-106085.SDR SIMA200213801Floorbeam · corrodedABI - DURING AN IMBV MAINTENANCE, FOUND CORROSION ON FORWARD DIGITAL. REMOVED CORROSION BY CUT OUT. FABRICATED A REPLACEMENT STRAP, TWO DOUBLERS AND SHIMS. REPAIRED IAW EMB 145 (SRM 145/1142 CHAPTER 53, REV 18) 53-21-10, AND STANDARD SRM PRACTICES. (M)SDR USAA020230Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED, STATION 986.5 TOP T-CAP ON FLOORBEAM, CORROSION REMOVED PER SRM 53-60-51. (M)SDR 2002F00646Floorbeam · corrodedAT C-CHECK, FOUND CORROSION IN AFT CARGO BAY FLOORBEAM, AT STATION 1841 ON CENTER SEGMENT OF ANGLE, ALSO CORRODED ON LOWER SURFACE. (M)SDR 02FDEA00346Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER FLANGE BS 312, LBL 27, WL 208. REMOVED AND REPLACED FLOORBEAM PER SRM 51-10-1.SDR SIMA200213802Floorbeam · corrodedABI - DURING AN IMBV MAINTENANCE, FOUND CORROSION ON GALLEY CENTER BEAM. REMOVED CORRODED GALLEY CENTER BEAM. INSTALLED NEW BEAM IAW EMB 145 (SRM 145/1142, CHAP 51 REV 18) 51-40-02, GST 1128/02, AND STANDARD SRM PRACTICES. (M)SDR 2002F00612Floorbeam · corrodedAT C-CHECK, FOUND CORROSION IN AFT CARGO BAY FLOORBEAM, ON UPPER AND LOWER SURFACE OF BEAM CAP AND ATTACH ANGLE, AT STATION 1902. (M)SDR 02FDEA00345Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER SURFACE BS 348, LBL 25-50, WL 208. REMOVED AND REPLACED FLOORBEAM PER SRM 53-10-8.SDR SWAA021053Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAMS CORRODED AT BS 770, BETWEEN LBL 12 TO RBL 8. REPAIRED FLOORBEAMS PER SWA RA.SDR SWAA021060Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 754, RBL 3. REPAIRED FLOORBEAM PER SWA RA.SDR SWAA021059Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CRACKED AT BS 747, RBL 14. REPAIRED FLOORBEAM PER SWA RA.SDR SIMA200213804Floorbeam · corrodedABI - DURING AN IMV MAINTENANCE, FOUND CORROSION ON LEFT OMEGA BEAM, PREVIOUS REPAIR, AT FRAME 20. REMOVED PREVIOUS REPAIR (CORROSION LIMITED TO PREVIOUS REPAIR). FABRICATED A DOUBLER ANGLE AND SHIMS AND FILLERS. REPAIR DONE IAW EMB145 (SRM 145/1142, CHAPTE
Back to JASC 5315