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 USAA2010030190474Floorbeam · corrodedSAL - C22 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT BS 328, LBL 24. REPAIRED FLOORBEAM AT BS 328, LBL 24 IAW B737 SRM 53-10-52 REPAIR 6.SDR USAA2010022690452Floorbeam · corrodedSAL - C22 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM UPPER CHORD AT BS 294.5, RBL 46. REPAIRED FLOORBEAM AT BS 294.5, RBL 46 IAW B737 SRM 53-10-51 REPAIR 5.SDR FDEA201002100436Floorbeam · corrodedCORROSION FLOORBEAM MAIN CABIN BS 1110, RBL12. CUTOUT DAMAGED FLOORBEAM DIM: 1.9" X 2" IAW SRM 53-10-8, FIG 3 FABRICATED FLOORBEAM REPAIR, SUPPORT ANGLE, AND STRAP IAW SRM 53-10-3 FIG 3. TREATED AND PRIMED REPAIR PARTS IAW SRM 51-10-2. INSTALLED REPAIR PARTSSDR ASOA201000199Floorbeam · crackedFS 460, LBL 9.0 OTBD SIDE OF FLOORBEAM FITTINGS IS CRACKED, APPROX 1.25" IN LENGTH. REMOVED FITTING IAW SRM 51-42-21. DISCONNECTED THE LARGE WIRE BUNDLE CLAMPS TO FACILITATE ACCESS PANEL REMOVAL IAW SRM 51-41-02. REMOVED ADEL CLAMPS FWD AND AFT FITTING TO FSDR DALA103243225Floorbeam · corrodedDURING "H" CHECK FOUND CORROSION ON FLOORBEAM AT Y465 FR68. REPAIRED IAW SRM 51-44-11, SRM 51-42-11.SDR ASOA201000292Floorbeam · corrodedUPON INSP, FOUND CORROSION AT FWD END OF FLOOR SUPPORT BEAM LBL 9 AT 280 ATTACH BRACKET UNDER FLOOR BEAM CAP. REMOVED RIVETS TO SEPARATE CAP FROM FLOORBEAM AT FS 280, LBL 9 BLENDED CORROSSION REMOVED DAMAGE REF. 51-42-06-001-001-A01 & 51-21-06-001-001-A01 SUBSDR USAA2010021990412Floorbeam · corrodedBFM - C4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT BS 1502, RBL 38. REPAIRED FLOORBEAM AT BS 1502, RBL 38 IAW B767 SRM 53-00-51, 51-40-02 & 51-20-01.SDR USAA2010021290353Floorbeam · corrodedBFM - C4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM UPPER CHORD AT BS 325, RBL 34. REPAIRED FLOORBEAM UPPER CHORD AT BS 325, RBL 34 IAW B767 SRM 53-00-51, 51-21-01, 51-40-02 & 51-20-10.SDR FDEA201002090368Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 720 LBL 62 HAS CORROSION AT SCREW HOLE. REMOVED CORROSION IAW 51-10-02. ORIG MAT .125" AFTER REWORK .080 OUT OF LIMITS IAW SRM 53-00-51, FIG 1, DET III, REPAIRED IAW SRM 53-00-51 FIG 201 R1, THIS IS CAT. "A" REPAIR. MAJOR REPAIR.SDR HALA2010020800068Floorbeam · corrodedLEVEL 2 CORROSION ON FWD CABIN FLOOR SUPPORT ANGLE AT STATION 200, RBL 19 TO RBL 31. REMOVED CORROSION AT FWD CABIN FLOOR SUPPORT ANGLE AT STA 200, RBL 19 - RBL 31 PER REF 717 SRM 51-10-04, ORIGINAL MAT THICKNESS .070 INCH, MAT. REMOVED .018 INCH, REMAINING SDR USAA2010021790390Floorbeam · corrodedMCN - MAJOR REPAIR - C4 CHECK - CORROSION ON FLOORBEAM AT BS 365.25, BL 0 - RBL 14, WL 208. REPAIRED FLOORBEAM AT BS 365.25, BL 0 - RBL 14, WL 208 IAW B757 SRM 53-00-51.SDR SWAA100720Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND T-CAP CORRODED AT BS 986, RBL 15. REPAIRED T-CAP PER SRM.SDR SWAA100717Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, LBL 5. REPAIRED BEAM PER AEM EO.SDR SWAA100710Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND AFT GALLEY FLOORBEAM O/B END CORRODED AT BS 986. REPAIRED BEAM PER SRM.SDR SWAA100709Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 707 TO BS 714, BBL 0. REPAIRED WEB PER SI.SDR SWAA100706Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, LBL 43. REPAIRED BEAM PER SRM.SDR USAA2010020990322Floorbeam · corrodedBFM - MAJOR REPAIR - C2 CHECK - CORROSION ON FLOORBEAM CHORD AT BS 779 - BS 897, RBL 74.81. REPAIRED FLOORBEAM CHORD AT BS 779 - BS 897, RBL 74.81 IAW B767 SRM 53-00-51.SDR A6WA201040100Floorbeam · crackedFITTING AT RBL 10, FS 461.0, ON FLOOR SUPPORT BEAM CRACKED (BATH TUB) PN 600-31068-19. R & R FITTING IAW SRM.SDR FDEA201002070350Floorbeam · crackedCROSSBEAM AT FR 31 FWD SIDE 1 IN BELOW FLOOR AND LBL 67 IN CRACKED .5 IN
LENGTH. ROUTED OUT CRACK ON CROSSBEAM AT FR 31 FWD 1 IN. BELOW FLOOR LBL 67 IN FABBED DOUBLER AND INSTALLED IAW SRM 53-10-15 FIG 212 SHEET 1.SDR F3LA2010021000329Floorbeam · corrodedDURING C4 S1 C CHECK INSP NOTED FRAME 58 AND FRAME 59 CTR FLOORBEAM IN AFT CARGO PIT HAS CORROSION ON FWD MOST SCREW NUTPLATE HOLE. MX REMOVED FLOOR SUPPORT BEAM, FABRICATED NEW AND INSTALLED IAW DWG D53476573 AND SRM 51-42-11.SDR SWIA201024021Fitting · crackedFS 280 FLOORBEAM CLIPS CRACKED. (C CHECK) REPLACED CLIPS PER SRM.SDR A6WA201040098Floorbeam · crackedFS 280 FLOOR SUPPORT CRACKED AT LBL 9 AT ALT RELEASE CABLE MOUNT BRACKET. PERMANENT REPAIR INCORPORATED IAW GENERIC REO 601R-53-11-171, REV D.SDR A6WA201040097Floorbeam · crackedFLOORBOARD SUPPORT (OTBD) ANGLE CRACKED ATTACHED TO FS 280 FRAME AT LBL 9. FABRICATED NEW CLIP AND INSTALLED IAW REO 601R-53-11-171, REV D.SDR USAA2010020890312Floorbeam · corrodedCLT - MAJOR REPAIR - Q1 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT BS 986, RBL 30. REPAIRED FLOORBEAM AT BS 986, RBL 30 IAW B737 SRM 53-60-51.SDR FDEA201002050337Floorbeam · damagedMC DECK FLOORBEAM BS. 860 LBL-24.5 HAS ENLOGATED HOLE IN TOP FLANGE. REMOVED FLOORBEAM CHORD, FOUND TO BE OUT OF LIMITS, IAW SRM 53-00-51, IAW SRM 51-40-02. FABRICATED NEW FLOORBEAM CHORD IAW SRM 53-00-51. INSTALLED FLOOR BEAM CHORD REPAIR PARTS ANGLES, STSDR DALA102899763Floorbeam · corrodedDURING "L" CHECK FOUND FLOORBEAM AT STA 208, AT RBL 22 TO 44, CORRODED. REPAIRED IAW SRM 53-12-1, SRM 51-10-1, SRM 51-10-2, SRM 51-10-3, SRM 51-10-4, AND SRM 51-30-5.SDR DALA102819763Floorbeam · corrodedDURING "L" CHECK FOUND FLOOR SUPPORT AT STA 200, AT LBL 22 TO 44 CORRODED. REPAIRED IAW SRM 51-10-4, AND SRM 51-30-5.SDR USAA2010020890306Floorbeam · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACKED FLOORBEAM UPPER CHORD AT BS 665 - BS 669, LBL 24. REPAIRED FLOORBEAM UPPER CHORD AT BS 665 - BS 669, LBL 24 IAW EA 101686.SDR SWAA100679Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 45.5. REPAIRED BEAM PER AEM EO.SDR FDEA201002040327Floorbeam · damagedFLOORBEAM AT STA 377 LBL-47 HAS DEEP SCRATCH ON UPPER FLANGE. R & R UPPER T-CHORD MEASURED OUT OF LIMITS IAW SRM 53-00-51, FIG 201 REPAIR 3 AND SRM 53-00-01 FIG 101 DETAIL III. FABRICATED REPAIRS ON MAE TRAVELER NR T10/819048, T10/819047. CLASSIFIED CATEGORSDR FOTR20006NR5718Floorbeam · crackedMAIN CABIN OVERWING FLOORBEAM T-CHORD CRACKED AT BS 760 RBL.45.5. REPAIRED ON FASI W/O NR 20006, N/R 05718. REMOVED AND REPLACED MAIN CABIN FLOORBEAM T-CHORD AT STA 760.9 IAW BOEING DWG 65-16279 REV A. MATERIAL USED: BAC1506-1108, DIM: 110.0 L.SDR FOTR20006NR 5760Floorbeam · damagedSTA 1070 FLOORBEAM DOUBLE DRILLED HOLE RBL.50. REPAIRED ON FASI W/O NR 20006, N/R 04858. REMOVED AND REPLACED UPPER SUPPORT FITTING AT RT LOWER TORQUE BOX WEB AT VENTRAL STAIRS STA 1263 WITH P/N 65C27137-1 IAW B727 SRM 53-10-2, REV 102.SDR ASAA1047339Floorbeam · chafedCABIN FLOORBEAM IS CHAFED ON UPPER CHORD STRAP. REMOVED AND REPLACED STRAP.SDR SWAA100631Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 669 TO BS 701, BL 0.07. REPAIRED BEAM PER SWA EA.SDR USAA2010020490272Floorbeam · corrodedSAL - MAJOR REPAIR - S5 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT FR 16 - FR 20, -Y1292. REPLACED FLOORBEAM AT FR 12 - FR 24, -Y1292 IAW A320 SRM 51-72-11.SDR R61A20100049Floorbeam · corrodedWHILE AC WAS IN HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT SEAT TRACK FLOORBEAM AT FR 86 TO FR 89. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM PER EMB SRM, AC STILL OUT OF SERVICE FOR HEAVY CHECK.SDR DALA102629763Floorbeam · corrodedDURING "L" CHECK FOUND CORROSION ON FLOOR SUPPORT AT BS 200 BETWEEN BL0 AND LBL 22. REPAIRED IAW SRM 51-10-4 AND 51-30-5.SDR A6WA201040221Floorbeam · crackedFLOOR SUPPORT AT FS 621 LT END CRACKED AT PREVIOUS REPAIR. (LBL 36) REPLACED FILLER IAW REO 601R-53-61-117.SDR SWAA100614Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND AFT CABIN FLOORBEAM T-CAP CORRODED AT BS 986, BETWEEN RBL 31 TO RBL 36. REMOVED AND REPLACED T-CAP PER SRM.SDR FDEA201002020303Floorbeam · corrodedMAIN CABIN FLOORBEAM UPPER CAP CORRODED AT STA 740 BETWEEN LBL 54.9 TO APPROX LBL 72 DUE TO DISCREPANCY EFFECTING THE PTF MOD A FLOORBEAM REPAIR WAS ACCOMPLISHED AT STA 740 LBL 36-65 ON MAE W/C NR 11835002B22R02 AND MAE EA NR 757-5335-16-F2407 REV- DATED 11/1SDR FDEA201002020300Floorbeam · failedEXISTING FLOORBEAM REPAIR AT STA. 1640 LBL 61- RBL61 WILL INTERFERE WITH THE INSTALLATION OF 4 EA MOD, SEAT TRACKS. REMOVED FLOORBEAM IAW SRM 51-40-02, LOCATED AND DRILLED IAW SRM 51-40- 05,TREATED AND PRIMED AND PAINTED IAW SRM 51-20-01 INSTALLED FLOORBEAMSDR SWIA201024051Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C CHECK) REPAIRED PER REO.SDR USAA2010020290262Floorbeam · corrodedMCN - C4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT BS 740, WL 208 BETWEEN RBL 50 TO RBL 58. REPAIRED FLOORBEAM AT BS 740, WL 208 BETWEEN RBL 50 TO RBL 58 IAW B757 SRM 53-00-51.SDR SWAA100587Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 707, BL 0. REPAIRED WEB PER SRM.SDR SWAA100586Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 709, BL 0. REPAIRED WEB PER SRM.SDR R61A201000047Floorbeam · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT FLOORBEAM BETWEEN FR 86 AND FR 87. MAINTENANCE REMOVED AND REPLACED FLOORBEAM PER EMB SRM. AC WAS RELEASED AFTER THE COMPLETION OF THE HEAVY CHECK.SDR SWAA100573Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, LBL 28.5. REPAIRED BEAM PER SRM.SDR SWAA100564Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BS 663, RBL 24.5. REPAIRED WEB PER ER.SDR SWAA100563Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 706 TO BS 716, LBL 24.5. REPAIRED WEB PER ER.SDR DL757100567Floorbeam · corrodedCORROSION ON MAIN CABIN FLOOR STRUCTURE BOX BEAM BETWEEN STA 758, LBL 18 AND LBL 40 / REPLACED FLOOR STRUCTURE BOX BEAM AT SAT SAA REF NON ROUTINE CARD 151033
Back to JASC 5315