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 P2EA00124Floorbeam · corrodedSJO - DURING C-CHECK, CORROSION ON TOP OF FLOORBEAM AT BS 312 BETWEEN LBL 1 AND RBL 8. REPAIRED FLOORBEAM UPPER CHORD AT BS 312 FROM LBL 26 TO RBL 45 IAW SRM 53-10-9, FIG 5. SEE COOPESA W/O N10316-2-224, VAM100 NR 642 AND 912SDA111. (X)SDR SWAA000719Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOOR BEAM UPPER SURFACE CORRODED, BS 294, LBL 11. REPAIRED BEAM PER RA NR T1-253-006.SDR SWAA000717Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 947 FLOORBEAM CRACKED ON UPPER SURFACE, LBL 54. REPAIRED BEAM PER SWA RA NR 1-353-1834.SDR USAA000561Floorbeam · corrodedFOUND FLOORBEAM CORRODED .500 INCH, STATION 360 RBL 52 - RBL 72. INSTALLED T-CAP PER SRM 53-00-51 AND 51-70-11. CORROSION LEVEL 2 NR C53-107-01. (M)SDR USAA000562Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 3 INCHES BY 1 INCH, STATION 328, RBL 51 TOP SURFACE. INSTALLED T-CAP PER SRM 53-10-51. CORROSION LEVEL 2 NR C53-107-01. (M)SDR USAA000556Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 1 INCH, UPPER RADIUS FLOORBEAM STATION 520 AT RBL 24.75. REPAIRED PER SB 737531120 AND EA 66956A. (M)SDR USAA000563Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED, .5 INCH BY .5 INCH, STATION 986.5, LBL 15 TO RBL 56. CORROSION LEVEL 2 NR C53-107-02. REPAIRED PER TR 53-60-0. (M)SDR TWAA0007402Floorbeam · corrodedFLOORBEAM AT STA 1250 HAS CORROSION LT SIDE TOP. INSTALLED NEW FLOORBEAM STA 1250 PER MD80 SRM 5301 PG 10. 04/14/00 CK C28C JFK.SDR CALA0000494Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312, LBL 18. AN UPPER CHORD REPAIR WAS INSTALLED IAW SRM 53-10-51, FIGURE 205.SDR CALA0000467Floorbeam · corrodedINSPECTION FOUND R-1 DOOR FLOORBEAM CORRODED AT FS 160 - 200, RBL 48. THE FLOORBEAM WAS REMOVED AND A NEW FLOORBEAM WAS INSTALLED IAW SRM 51-30-2, 51-10-3 AND 51-30-1.SDR TWAA0006111Floorbeam · crackedDURING C CHECK, FOUND CRACK IN MEMBRANE AT STA 1280, AND 1296 TO 1309, LONGER 18 LT. STOP DRILLED CRACKS. INSTALLED REPAIR DOUBLER OVER CRACKED MEMBRANE AND INSTALLED FASTENERS PER SRM 53-05, PAGE 349 AND 359. ---CLOSED---SDR RRXA002465Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM AT STA 540 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED PART IAW DC-8 SRM 51-1-21 AND EOSDR RRXA002400Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES IN THE FLOORBEAM AT FS 680, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW DC-8 SRM 51-1-20D AND EO NR 00-04SDR RRXA002260Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES IN THE FLOORBEAM 1400 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES IAW EO NR 00-047 WITH APPROVED 8110-3 SDR RRXA002259Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES IN THE FLOORBEAM 1380 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLERS IAW DC-8 SRM 51-1-21, 51-1-4 SDR RRXA002237Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM 1300 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW DC-8 SRM 51-1-21 AND EO NRSDR RRXA002232Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM 1100 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED PLUGS/STRAPS IAW DC-8 SRM 51-1-20D ANDSDR RRXA002231Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM 1080 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED PLUGS/STRAPS IAW EO NR 00-047 WITH APPSDR RRXA002229Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM 1260 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED STRAPS/FILLERS IAW DC-8 SRM 51-1-21, 5SDR RRXA002209Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES TO THE FLOORBEAM IN THE UPPER CARGO COMPT AT FS 650, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED STRAPS/FILLERS AND INSTALLED IAW SDR USAA000551Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 1.7 INCH, STATION 520, LBL 45.5 FLOORBEAM RADIUS. REPAIRED FILLER, DOUBLER PER EA 66956A. (M)SDR USAA000552Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED .4 INCH, STATION 520, RBL 45.5 FLOORBEAM RADIUS. REPAIRED FILLER, DOUBLER PER EA 66956A. (M)SDR USAA000553Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED .4 INCH AND .7 INCH, STATION 520, LBL 24.75. REPAIRED FILLER, DOUBLER PER EA 66956A. (M)SDR 20000620AP002Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND FLOORBEAM 36 AND 38 CORRODED BEYOND LIMITS. REMOVED AND REPLACED FLOORBEAM 36 AND 38 IAW SRM 51-25-01. AIRCRAFT RETURNED TO SERVICE. REFERENCE SIMA1047. (M)SDR SIMA1047Floorbeam · corrodedDURING CPCP-2 INSPECTION, FOUND FLOORBEAM 36 AND 38 CORRODED BEYOND LIMITS. REMOVED AND REPLACED FLOORBEAM 36 AND 38 IAW SRM 51-25-01. AIRCRAFT RETURNED TO SERVICE. (M)SDR AALA20000673Floorbeam · corrodedTUL- FLOORBEAM CORRODED STA 1166 FROM RBL46 TO RBL 49. REMOVED DAMAGED SECTION OF FLOORBEAM AND INSTALLED FLOORBEAM REPAIR PER ESO 11697, DATED 4-10-00. (X)SDR AALA20000675Floorbeam · corrodedTUL - RIGHT AFT FLOOR ANGLE CORRODED 1174 TO 1176 RBL 34 TO RBL 35. REMOVED OLD ANGLE. INSTALLED NEW FLOOR ANGLE 51-10-1. (X)SDR 0001632290Floorbeam · corrodedDURING H CHECK, FOUND CORROSION ON FLOORBEAM UPPER CHORD. REPAIRED PER EA 22-175154.SDR 0001622290Floorbeam · corrodedDURING H CHECK, FOUND CORROSION ON FLOORBEAM UPPER CHORD, BODYLINE 0. REPAIRED PER EA 22-175152.SDR SWAA000706Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAMS UPPER SURFACE CORRODED, BS 947, LBL 5 TO RBL 55, AND BS 887, RBL 21 TO LBL 62. REPAIRED FLOORBEAMS PER SRM.SDR CALA0000463Floorbeam · corrodedINSPECTION FOUND FLOORBEAMS CORRODED AT STA 1887, BETWEEN RBL 25 - 30, RBL 35 -55, AND RBL 65 - 100. THE FLOORBEAMS WERE REMOVED AND NEW FLOORBEAMS WERE INSTALLED IAW SRM 51-31-01.SDR RRXA002466Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM AT STA 560 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED PART IAW DC-8 SRM 51-1-21 AND EOSDR RRXA002462Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM AT STA 460 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED PART IAW EO NR 00-047 WITH APPROSDR RRXA002461Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES TO THE FLOORBEAM AT FS 940, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW EO NR 00-047 WITH APPROVED 8110-3SDR RRXA002350Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES IN THE FLOORBEAM AT FS 980, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES IAW DC-8 SRM 51-1-21 AND EO NR 00-047 WITH ASDR RRXA002348Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES IN THE FLOORBEAM AT FS 940, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW DC-8 SRM 51-1-21 AND EO NR 00-04SDR RRXA002347Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES IN THE FLOORBEAM AT FS 900, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES IAW DC-8 SRM 51-1-21 AND EO NR 00-047 WITH ASDR RRXA002346Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES IN THE FLOORBEAM AT FS 878, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES IAW DC-8 SRM 51-1-21 AND EO NR 00-047 WITH ASDR RRXA002345Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES IN THE FLOORBEAM AT FS 857, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES IAW DC-8 SRM 51-1-21 AND EO NR 00-047 WITH ASDR RRXA002265Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES IN THE FLOORBEAM AT STA 1440 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW DC-8 SRM 51-1-21 ANSDR RRXA002257Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES IN THE FLOORBEAM 1340 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES IAW DC-8 SRM 51-1-21 AND EO NR 00-047 SDR RRXA002236Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM 1320 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES IAW EO NR 00-047 WITH APPROVED 8110-3 SDR RRXA002223Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES IN THE FLOORBEAM 1140 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES IAW EO NR 00-047 WITH APPROVED 8110-3 SDR RRXA002204Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES TO THE FLOORBEAM IN THE UPPER CARGO COMPT FS 1520, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES IN FLOORBEAM IAW EO NSDR 00FDEA00241Seat Track · corrodedCORROSION (C53-224-04) ON SEAT TRACK FLANGE BS 1070, RBL 45, WL 208. *S/D* REMOVED AND REPLACED, ALODINED, PRIMED PER FEDEX SRM 53-10-1 FIG 3, 51-30-5 FIG 1 & 2, 51-10-2.SDR 00FDEA00242Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER FLANGE AND NUT PLATE HOLE BS 312, LBL 19, WL 208.SDR 00FDEA00233Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER FLANGE BS 620, LBL 45 TO RBL 25, WL 208.SDR RRXA002472Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM AT STA 360 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED PART IAW DC-8 SRM 51-1-21 AND EOSDR RRXA002340Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES IN THE FLOORBEAM AT FS 798, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW DC-8 SRM 51-1-20D AND EO NR 00-0SDR RRXA002224Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM 1160 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLERS IAW DC-8 SRM 51-1-21, 51-1-20
Back to JASC 5315