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 SWIA200719188Floorbeam · crackedFS 280 AT LBL9 FLOORBEAM IS CRACKED, FOUND AT C-CHECK. INSTALLED REPAIR PARTS PER REO 601R-53-11-171 AND CRJ200 SRM 51-42-06.SDR SWIA200719187Floorbeam · crackedFS 280 AT RBL9 AND LBL9 UPPER FLOORBEAM IS CRACKED, FOUND AT C-CHECK. COMPLIED WITH REPAIRS PER REO 601R-53-11-136 REV A AND REO 601R-53-11-1271 REV A.
SDR MWEA070267Floorbeam · corrodedAT STATION 1311 FLOOR LEVEL CENTER AREA BETWEEN AFT LAVATORY HAS CORROSION AT FLOOR BEAM. REMOVED AND REPLACED FLOORBEAM.SDR CALA0700641Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 344, BL 0 TO LBL 13. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01504.SDR CALA0700640Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 328, RBL 16. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01507.SDR CALA0700639Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 328, RBL 41. THE UPPER CHORD OF FLOORBEAM WAS REPLACED IAW ECRA 5321-01508.SDR CALA0700637Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312, LBL 11. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, REPAIR 1.SDR CALA0700633Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 360, LBL 9. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01505.SDR TRAX200701679Floorbeam · corrodedFOUND FS 280 FWD ATTACH ANGLE HAS CORROSION DAMAGE.SDR TRAX200701678Floorbeam · corrodedFOUND FS 280 CROSSBEAM HAS CORROSION DAMAGE.SDR 07FDEA04706Floorbeam · corrodedBULK PIT BELOW FLOOR, CORROSION ON FLOOR FRAME 67 UNDER NUTPLATE AT RBL 38. REMOVED CORROSION IAW A310 SRM 51-22-00 PG 11, CHECKED LIMITS, ORIG MAT 0.130, MAT. REMOVED .040, MAT REMAINING .090. FOUND OUT OF LIMITS IAW A310 SRM 53-10-15 PG 101 UTG NR 8225-B.SDR TRAX200701641Floorbeam · corrodedFOUND FLOORBEAM 39 CORRODED, RESOLVED ON W/O: 74559 TASKCARD: N/R-00277. FLOORBEAM 39 CORROSION REMOVED IAW SRM 51-21-42 BUT IT IS OUT OF LIMIT AS PER SRM 53-61-00 FIG 301. FLOORBEAM 39 REPAIRED IAW SRM 53-00-00 FIG 450. FABRICATION OF PARTS COVER ON W/C 20SDR KCSA071504Floorbeam · corrodedFORWARD PIT FLOORBEAM UPPER CHORD CORRODED AT BS 960, RBL 44.SDR SWIA200719183Floorbeam · crackedCRACK IN UPPER FLANGE OF FS 280 FLOORBEAM AT RBL12 AND RBL9, FOUND AT C-CHECK. REPLACED FS 280 FLOORBEAM PER REO 670-53-11-047 REV D.
SDR TRAX200701620Floorbeam · corrodedFLOORBEAM 40 CORRODED. FLOORBEAM 40 CORROSION REMOVED IAW SRM 51-21-42 AND IT ISW WITHIN LIMIT AS PER SRM 53-61-00 FIG 301. MATERIAL THICKNESS: 0.063 MATERIAL REMOVED: 0.002 WITHIN LIMITS AS PER SRM: SRM 53-61-00 FIG 301.SDR TRAX200701618Floorbeam · corrodedFLOORBEAM 38 CORRODED. FLOORBEAM 38 CORROSION REMOVED IAW SRM 51-21-42 AND IT IS WITHIN AS PER SRM 53-61-00 FIG 301. MATERIAL THICKNESS: 0.063 MATERIAL REMOVED: 0.003 WITHIN LIMITS AS PER SRM: 53-61-00 FIG 301.SDR TRAX200701625Floorbeam · corrodedLOWER FLOORBEAM AT FR 41, STR 17 RIGHT CORRODED.SDR TRAX200701619Floorbeam · corrodedFLOORBEAM 36 CORRODED. CORROSION REMOVED AS PER SRM 51-21-42 AND IT IS OUT OF LIMITS AS PER SRM 53-61-00. NEW BEAM SPLICED INSTALLED IAW SRM 51-25-01 AND 51-25-04 FABRICATION COVERED ON W/C 2000-199. MATERIAL THICKNESS: 0.063 MATERIAL REMOVED: 0.047 OUT OFSDR 2007UALA04464Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED AT OUTBOARD END BS 287 AT FWD LOWER CORNER OF R-1 DOOR CUTOUT. SUSPECT MOISTURE CONTAMINATION. REMOVED DAMAGED SECTION OF CAP AND FABRICATED CAP SECTION, ANGLES AND STRAPS AND INSTALLED PER SRM 53-00-51. ACFT OK FOR SERVICE.SDR C2XA07SH089Floorbeam · corrodedSHV - DURING C-CHECK CENTER OMEGA BEAM CORROED BEYOND ALLOWABLE LIMITS ON FR 20. MAINTENANCE REMOVED AND REPLACED CENTER OMEGA BEAM FROM 18 TO 23 IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN FOR SERVICE.SDR SWAA075391Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, LBL 5 TO RBL 40. REPAIRED FLOORBEAM PER SRM.SDR SWAA075392Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 26. REPAIRED FLOORBEAM PER SRM.SDR SWIA200719160Floorbeam · crackedFS 280 FORWARD FLOOR SUPPORT IS CRACKED AT RBL9, FOUND AT C-CHECK. REPLACED CRACKED SUPPORT ANGLE.
SDR SWIA200719159Floorbeam · crackedFS 280 AND LBL 9 LOWER FLOOR SUPPORT IS CRACKED, FOUND AT C-CHECK. INSTALLED REPAIR PARTS PER REO 601R-53-11-171.
SDR SWIA200719158Floorbeam · crackedRBL 9 AT FS 280 FLOORBEAM IS CRACKED, FOUND AT C-CHECK. COMPLIED WITH REPAIR PER CRJ200 REO 601R 53-11-171.
SDR SWIA200719157Floorbeam · crackedLBL 9 AND RBL 9 AT FS 280 IS CRACKED NEAR UPPER FLOORBEAM, FOUND AT C-CHECK. COMPLIED WITH REPAIR PER REO 601R-53-11-136.SDR DLM88071531Floorbeam · crackedCRACK ON FLOOR SUPPORT STA Y=650 BTWN LONGERON 25 RT AND 26 RT REPAIRED PER ERA 413029-14MA.SDR 2007UALA04441Angle · corrodedMAIN CABIN AT STA 287 APPROX RBL 80, FLOORBEAM ANGLE P/N 141T5111-45 IS CORRODED. MAJOR REPAIR ACCOMPLISHED: REPLACED ANGLE P/N 141T5111-45.SDR CA071026009Floorbeam · corroded(CAN) AFT CABIN BS 986.5 BEAM UPPER CAP CORRODED AT LBL24, LBL18, RBL10, RBL, RBL32, RBL28, RBL22, RBL17 REPAIRED IAW CUSTOMER EA. (TC NR 20071026009)SDR CALA0700621Floorbeam · corrodedINSPECTION FOUND MAIN CABIN FLOORBEAM CORRODED AT STA 328, RBL 11. THE FLOORBEAM SECTION WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR USAA920070992Floorbeam · corrodedMCN - MAJOR REPAIR - C4 CHECK - LEVEL 2 CORROSION ON CABIN FLOORBEAM UPPER CHORD, BS 324, LBL 10 - RBL 42, WL 208. REPAIRED CABIN FLOORBEAM UPPER CHORD, BS 324, LBL 10 - RBL 42, WL 208 IAW B757 SRM 51-70-12.SDR USAA920070991Floorbeam · corrodedMCN - MAJOR REPAIR - C4 CHECK - LEVEL 2 CORROSION ON CABIN FLOOR SUPPORT, BS 297, RBL 5 - RBL 16, WL 208. REPLACED CABIN FLOOR SUPPORT, BS 297, RBL 5 - RBL 16, WL 208 IAW B757 SRM 51-40-02.SDR SWAA075321Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 706, LBL 49. REPAIRED FLOORBEAM PER SRM.SDR SWAA075357Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, LBL 45 TO RBL 40. REPAIRED FLOORBEAM PER SWA EA.SDR QXEA200701616Floorbeam · corrodedC4 PDX-280 FLOORBEAM HAS CORROSION ON TOP SURFACE OF BEAM LEFT SIDE AT 6-8, 13-18, 19-25, AND 29-46 MEASURED FROM LEFT SIDE FUSELAGE SKIN TO CENTERLINE. REPAIRED IAW REO670-53-11-047 AND SRM 51-42-10.SDR ABXA070361Strap · crackedFS 775, LEFT BUTT LINE 12, FLOORBEAM ATTACH STRAP CRACKED. REMOVED AND REPLACED ATTACH STRAP FS 775, LEFT BUTT LINE 12 IAW DC9 SRM.SDR 07FDEA04663Floorbeam · corrodedMAIN CABIN FLOORBEAM STRUCTURE BENEATH LT FWD LAV BETWEEN FR 14 AND 14B HAS INTERGRANULAR CORROSION. REMOVED CORROSION IAW A310 SRM 51-74-10. ORIGINAL THICKNESS .079. REMOVED .045. REMAINING MATERIAL NOT WITHIN ALLOWABLE LIMITS IAW A310 SRM 53-10-00. UT GASDR KCSA071493Floorbeam · damagedFORWARD BILGE, FLOORBEAM UPPER CHORD IS DAMAGED AT STA 820, LBL 28 TO LBL 29.SDR KCSA071492Floorbeam · damagedFORWARD BILGE, FLOORBEAM UPPER CHORD IS DAMAGED AT STA 640, LBL 22.SDR KCSA071490Floorbeam · damagedFORWARD BILGE, FLOORBEAM UPPER CHORD IS DAMAGED AT STA 800 LBL 48 TO LBL 52.SDR TRAX200701564Floorbeam · noneFLOORBEAM 36 TOP SURFACE CORRODED. CORROSION REMOVED, FOUND WITHIN LIMITS.SDR CALA0700599Floorbeam · corrodedINSPECTION FOUND SURFACE CORROSION ON FLOORBEAM AT STA 986, RBL 4. A REPAIR STRAP WAS INSTALLED IAW SRM 53-60-51.SDR CALA0700598Floorbeam · corrodedINSPECTION FOUND SURFACE CORROSION ON FLOORBEAM AT STA 986, RBL 40. A REPAIR STRAP WAS INSTALLED IAW SRM 53-60-51.SDR QXEA200701601Floorbeam · corrodedC4 PDX - 280 FLOORBEAM RIGHT SIDE BULKHEAD HAS CORROSION ON AFT SIDE OF BULKHEAD NEXT TO 18-24, 26-35, AS MEASURED FROM RIGHT SIDE WALL FUSELAGE SKIN LOCATION. REPAIRED IAW REO670-53-052.SDR QXEA200701600Floorbeam · corrodedC4 PDX - 280 FLOORBEAM HAS CORROSION AREAS ON TOP SURFACE OF BEAM RIGHT SIDE AT 13-18, 19-33, 34-46 CENTERLINE AS MEASURED FROM RIGHT SIDEWALL FUSELAGE SKIN TO CENTERLINE LOCATION. REPAIRED IAW REO670-53-11-047, REO670-53-11-052.SDR SWAA075202Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 328, LBL 28. REPAIRED BEAM PER SRM.SDR CALA0700597Floorbeam · corrodedINSPECTION FOUND MAIN CABIN FLOORBEAM CORRODED ON UPPER AND LOWER SURFACES AT STA 360, BL 0. REPAIRED IAW SRM 53-30-51.SDR KCSA071478Floorbeam · damagedFWD PIT FLOORBEAM UPPER CHORD DAMAGED AT BS 760, LBL 10.SDR ABXA070411Floorbeam · corrodedFLOORBEAM AT STATION 1011 LOWER FORWARD FLANGE CORRODED AT APPROXIMATELY RIGHT BUTT LINE 15 UNDER NUT PLATES. REPAIRED FLOORBEAM IN ACCORDANCE WITH DC9 SSRM K07411.SDR SWIA200719163Floorbeam · crackedLBL9 AT FS 280 IS CRACKED AT LOWER RADIUS, FOUND AT C-CHECK. COMPLIED WITH FLOORBEAM REPAIR IAW CRJ200 REO 601R-53-11-171 REV C.
Back to JASC 5315