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 SWAA001674Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND BS 312 FLOORBEAM CORRODED, BL 0. REPAIRED FLOORBEAM PER SRM.SDR LR7A00175Floorbeam · corrodedDURING SCHEDULED C1 INSPECTION DRC 3012 ACCOMPLISHMENT FOUND FS 228 FLOORBEAM CAP CORRODED AT ESS DC TR UNIT NR 1 GROUND STUD HOLE, WL 146, LBL 28. REPAIRED IAW SMP 583-53-30-20, DRC 2058.SDR EIA2000246Floorbeam · crackedC1-CHECK, FOUND BULK CARGO COMPARTMENT, FLOORBEAM SUPPORT CRACKED AT BS 1940 RBL 2 TO RBL 23. FLOORBEAM REPAIRED PER SRM 51-40-04 AND HAECO LOMC018 AND LOMC010. (M)SDR 00FDEA00617Floorbeam · crackedFRAME 37 AT AXIS LHS Y + 1800, .5 INCH BELOW UPPER FLANGE, FOUND CRACK .5 INCH LONG. *S/D* REMOVED AND REPLACED PER FEDEX EA 6-5100-52045 & A310 SRM SUPL MANUAL 53-10-15, FIG 201.SDR EISA20000177Floorbeam · gougedFLOORBEAM AT STA 990 LBL 70, UPPER CHORD, AFT FLANGE GOUGED. REMOVED, FABRICATED REPAIR DOUBLER AND FILLER, ALODINED, PRIMED AND INSTALLED REPAIR DOUBLER AND FILLER IAW B727-200 SRM 51-10-2, 51-30-2 AND 53-10-8.SDR USAA001412Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED, STATION 986, BL 0. CORROSION LEVEL 1. REPAIR T-CAP AND SPLICE PER SRM 53-10-9. (M)SDR AWXA0000612Floorbeam · corrodedC-CHECK CORROSION, AFT CABIN FLOOR PANEL FLOORBEAM 66 STR Y 1292 RT CORRODED. FABRICATED NEW FLOORBEAM IAW DWG D53472090 AND INSTALLED IAW A320 SRM 51-72-11 PAGE 1.SDR USAA001408Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED .375 INCH, BS 328, RBL 24.50 TO SERVICE DOOR. INSTALLED ANGLES PER SRM 53-00-51. (M)SDR USAA001407Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 5 INCHES BY .25 INCH, BS 328M 11.5 INCHES IN FROM FORWARD SERVICE DOOR. INSTALLED REPAIR ANGLES, T-CAP PER SRM 53-00-51 FOG 201. (M)SDR USAA001409Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY 3 INCHES, STATION 344, 14 INCHES LBL. CORROSION LEVEL 1 C53-107-01. INSTALLED T-CAP FLOORBEAM REPAIR PER SRM 53-10-51. (M)SDR UPS00833722Floorbeam · misdrilledINSPECTION TYPE:C123, STA 1620 FLOORBEAM HAS MISDRILLED HOLES AT RBL 20. REPAIRED FLOORBEAM IAW 8110-3 APPROVED DH SK 729-533.SDR SWAA001632Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 967 FLOORBEAM CORRODED. REPAIRED FLOORBEAM PER SRM.SDR USAA001381Floorbeam · corrodedCLT - C-4, FLOORBEAM CORRODED, 1 INCH BY 2 INCHES, 2 EACH CRACKS, CORROSION LEVEL 1 C53-221-03, AT STA 395, RBL 12. INSTALLED REPLACEMENT PART PER SRM 53-00-51 FIG 203. (X)SDR USAA001382Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED .250 INCH BY 10 INCH, STATION 986 LEFT TO RIGHT. CORROSION LEVEL 1 C53-107-02. INSTALLED NEW T-CAP PER TR 53-10-05A. (M)SDR 00FDEA00610Floorbeam · crackedAT FRAME 35 FOUND FLOORBEAM CRACKED AT RHS Y - 700, .5 INCH BELOW TOP FLANGE WITH CROSS BEAM CHORD. *S/D* REMOVED AND REPLACED PER FEDEX EA 6-5100-52043 & A310 SUPL MANUAL 53-10-15, FIG 201.SDR SWAA001638Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 328 FLOORBEAM CORRODED AROUND NUT PLATE, RBL 42. REPAIRED BEAM PER TI-553-048.SDR EISA20000169Floorbeam · corrodedFLOORBEAM SUPPORT STRAP AT BS 1030 TO BS 1070 BL 72R CORRODED. REMOVED, FABRICATED STRAP SPLICE, ALODINED, PRIMED AND INSTALLED STRAP SPLICE IAW B727-200 SRM 51-10-2 AND 53-10-3.SDR 00FDEA00613Floorbeam · crackedAT FRAME 34 FOUND FLOORBEAM CRACKED AT RHS Y - 700, .5 INCH BELOW TOP FLANGE WITH CROSS BEAM CHORD. *S/D* REMOVED AND REPLACED PER FEDEX EA 6-5100-52043 & A310 SRM SUPL MANUAL 53-10-15, FIG 201.SDR 00FDEA00612Floorbeam · crackedAT FRAME 36 FOUND FLOORBEAM CRACKED AT LHS Y +700, .5 INCH BELOW TOP FLANGE WITH CROSS BEAM CHORD. *S/D* REMOVED AND REPLACED PER FEDEX EA 6-5100-52043 & A310 SRM SUPL MANUAL 53-10-15, FIG 201.SDR 00FDEA00611Floorbeam · crackedAT FRAME 36 FOUND FLOORBEAM CRACKED AT RHS Y -900, .0625 INCH BELOW TOP FLANGE WITH CROSS BEAM CHORD. *S/D* REMOVED AND REPLACED PER EA 6-5100-52043 & A310 SRM SUPL MANUAL 53-10-15, FIG 201.SDR 00FDEA00609Floorbeam · crackedAT FRAME 36 FOUND FLOORBEAM CRACKED AT RHS Y-700, .5 INCHES BELOW TOP FLANGE WITH CHORD. *S/D* REMOVED AND REPLACED PER FEDEX REF EA 6-5100-52043 & A310 SRM SUPL MANUAL 53-10-15, FIG 201.SDR AT0000430Floorbeam · corrodedFOUND CORROSION ON EPC PANEL FRAME AT FLOOR SUPPORT. REMOVED FRAME AND FLOOR SUPPORT, FABRICATED NEW REPAIR AND INSTALLED IAW DC9 SRM 51-10-2, 51-30-1, 52-61-0.SDR SWAA001616Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND BS 986 FLOORBEAM CORRODED ON UPPER FLANGE, RBL 25 TO RBL 40. REPAIRED FLOORBEAM PER SRM AND TRM.SDR USAA001352Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY 7 INCHES, BS 947, LBL 11, LBL 4, RBL 4, RBL 12. INSTALLED DOUBLER PER TR 53-60-02A. (M)SDR L1GA200000284Floorbeam · crackedA 1 INCH CRACK IN FLOORBEAM AT STATION 658. REMOVED AND REPLACED CRACKED FRAME.SDR L1GA200000281Floorbeam · damagedHOLE IN RADIUS OF FLOORBEAM AT STATION 297 BL 0. FAB AND INSTALLED NEW FLOOR SUPPORT.SDR CALA0001313Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED UNDER TWO NUT PLATES AT STA 200, RBL 44.5. THE CORROSION WAS REMOVED IAW SRM 51-10-03 AND THE FLOORBEAM WAS REPAIRED IAW EA 9-5310-2-A0755 AND ECRA 5310-04040.SDR RRXA002876Web · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE ON SUB-FLOOR WEB BELOW RELAY CONTROL PANEL AT STA 8 0 TO -12 FROM CL TO RBL 68", DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. ---------------------CX----------------------SDR GAIA00557Floorbeam · crackedDISCREPANCY: DURING HEAVY CHECK FOUND: BS740 FLOORBEAM UPPER CHORD VERTICAL FLANGE CRACKED AT RBL 24 CORRECTIVE ACTION: INSTALLED NEW FLOOR BEAM UPPER CAP IAW 727 SRM51-30-2SDR USAA001436Floorbeam · corrodedPIT - FOUND FLOORBEAM AND SUPPORTS CORRODED .5 INCH BY 4 INCHES, STATION 947-967, LEFT TO RIGHT CUSP. CORROSION LEVEL 1, TASK NR C53-107-02. REPLACED FLOORBEAMS PER SRM 51-40-02. (M)SDR SWAA001594Beam · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 787 FLOORBEAM CRACKED AT RADIUS, RBL 14. REPAIRED BEAM PER SRM.SDR RRXA002883Floorbeam · crackedDURING A MAINTENANCE VISIT FOUND A 1 1/4 INCH CRACK TO THE TOP FLOORBEAM AT STA -10 IN COCKPIT AND LBL -10, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 53-2-0.SDR USAA001518Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED .25 INCH, AFT LEFT LAV, FORWARD MOUNT HOLES. CORROSION LEVEL 1, TASK NR C53-107-02. DEFECTIVE PART REPLACED WITH IDENTICAL PAR NR PER SRM 51-40-00. (M)SDR USAA001519Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED .25 INCH, CENTER LAV MOUNTS AFT OF STATION 1016. DEFECTIVE PART REPLACED WITH IDENTICAL PART NR PER SRM 51-40-00. (M)SDR SWAA001585Floorbeam · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CABIN FLOORBEAM CORRODED, BS 985, RBL 43 - 46. REPAIRED BEAM PER SRM.SDR RRXA003083Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO THE L ANGLE TO FLOORBEAM IN THE AFT CARGO COMPT AT STA 1220 X AXIS -49 TO 58, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAWSDR USAA001304Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 1 INCH IN 4 PLACES, FLOORBEAM WEB AT RBL 24.75 FROM FS 706 TO FS 711. CUTOUT DAMAGED AND INSTALLED DOUBLER PER EA 67780. (M)SDR USAA001305Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 1 INCH IN FOUR PLACES, FLOORBEAM WEB AT LBL 24.75 FROM FS 706 TO FS 711. REMOVED AND REPLACED SECTION OF WEB AND INSTALLED DOUBLER PER EA 67780. (M)SDR USAA001308Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH, BS 927, BL 0. REMOVED CORROSION FABRICATED REPAIR AND INSTALLED PER SRM 53-00-51 FIG 202. (M)SDR AWXA0000578Floorbeam · corrodedC-CHECK CORROSION LEVEL 1, CORROSION ON TOP OF FLOORBEAM AT FS 986.5 RBL 28 TO LBL 18. REMOVED DAMAGED AREA, FAB''D AND INSTALLED T-CAP IAW 737 SRM 53-10-51 AND 51-40-02.SDR USAA001454Floorbeam · corrodedPIT - FOUND BEAM WEB CORRODED 1 INCH TO 3 INCH AREA SCATTERED ON TOP SURF, STATION 597-615, RT SIDE. CORROSION LEVEL 1, TASK NR C53-107-01. REMOVED AND REPLACED 3 RIVETS AFTER BLENDING OF MINOR SURF CORROSION PER SRM 53-60-13. (M)SDR USAA001452Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED .25 INCH IN DIAMETER, STATION 967 TOP SURF BEAM INBOARD RBBL 45.50. CORROSION LEVEL 1, TASK NR C53-107-02. REMOVED CORROSION, TREATED, PRIMED PER SRM 51-20-01, 51-10-02. (M)SDR USAA001451Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1 INCH IN DIAMETER, STATION 186 FLOORBEAM BB10 LOWER LEG TOP SURF NUTPLATE. REMOVED NUTPLATE AND CORROSION. TREATED, PRIMED AND INSTALLED NUTPLATE PER SRM 51-10-02, 51-20-01. (M)SDR USAA001447Floorbeam · corrodedPIT - FOUND BEAM CORRODED 1 INCH DIAMETER AT 27 NUTPLATE HOLES, STATION 986 DOOR TO DOOR. CORROSION LEVEL 1, TASK NR C53-107-02. REMOVED CORROSION OVERSIZED HOLES, TREATED AND PRIMED PER SRM 51-10-02 AND 53-60-51, 53-60-31, 53-15-01. (M)SDR USAA001348Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED .5 INCH IN DIAMETER, FLOORBEAM 967 OUTBOARD OF RBBL 24.75 NUTPLATE HOLE. CORROSION LEVEL 1, TASK NR C53-107-02. REMOVED CORROSION, TREATED AND PRIMED PER SRM 51-20-01. (M)SDR USAA001339Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1 INCH BY .2 INCH, STATION 344 FROM CENTER LINE OUTBOARD 42 INCHES. CORROSION LEVEL 1, TASK NR C53-107-01. REMOVED AND REPLACED FLOORBEAM CAP PER SRM 51-40-02. (M)SDR ALA0001292Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT NUT PLATE MOUNT AREA, STA 1338 BELOW LT AFT LAV. A SPLICE SECTION WAS INSTALLED IAW SRM 51-30-0 AND 51-10-3.SDR CALA0001284Floorbeam · corrodedINSPECTION FOUND O/B FLOORBEAM CORRODED AT GALLEY 2. THE FLOORBEAM WAS REPLACED IAW SRM 53-00-00 AND GMM 10-900-01.SDR F3LA00211Floorbeam · corrodedDEN - DURING C-3 CHECK, INSPECTION REPORTED FLOORBEAM UPPER CHORD CORRODED FROM RBL 20 TO LBL 49. MAINTENANCE FABRICATED REPAIR PARTS PER SRM 53-10-02 AND INSTALLED PER SRM 51-30-0. (M)SDR F3LA00210Floorbeam · corrodedDEN - FOUND DURING C-2 CHECK, CORROSION ON TOP OF FLOORBEAM CENTER AT STATION 292.5, LBL 5. MAINTENANCE REPLACED FLOORBEAM UPPER CHORD PER SRM''S 51-10-02, 51-30-02, 53-10-01 AND 53-10-09. (M)
Back to JASC 5315