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 FDEA200902230660Floorbeam · crackedMAIN CABIN FLOOR STRUCTURE, FWD SIDE OF FRAME 27 IS CRACKED 1 INCH BELOW FLOOR LEVEL AT RBL 27. BLENDED CRACKED FLOORBEAM IAW SRM 53-10-15 FIG 212. CRACK STILL PRESENT AFTER ACCOMPLISHING HFEC OF AREA IAW NTM 51-10-08. CUT OUT DAMAGE IAW SRM 53-10-15 FIG 21SDR FDEA200902230659Floorbeam · crackedMAIN CABIN FLOOR STRUCTURE, FWD SIDE OF FRAME 28 IS CRACKED 1 INCH BELOW FLOOR LEVEL AT RBL 27. BLENDED CRACKED FLOORBEAM IAW SRM 53-10-15 FIG 212. CRACK STILL PRESENT AFTER ACCOMPLISHING HFEC OF AREA IAW NTM 51-10-08. CUT OUT DAMAGE IAW SRM 53-10-15 FIG 21SDR CALA2009022300109Floorbeam · corrodedFLOORBEAM UPPER SURFACE AREA HAS CORROSION (PITTED) STATION 986.5 AND RBL 23. CUT OUT DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED REPAIR PER SRM 53-00-51, FIGURE 203, REPAIR 1.SDR SWAA091344Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24. REPAIRED BEAM PER ER.SDR DLM88090280Floorbeam · corrodedFLOOR SUPPORT CORRODED AT STATION 946, X=+19 Z=0. REPAIRED BY REPLACEMENT ON ATS NR 01151.SDR DLM88090275Floorbeam · corrodedCORROSION ON FLOOR SUPPORT STATION 1155 +13 -5X -44Z IN AFT CARGO. REPAIRED BY REPLACEMENT ON ATS 00426.SDR USAA2009040390795Floorbeam · corrodedMCN - C1 - MAJOR REPAIR - CORROSION ON UPPER SURFACE OF FLOORBEAM AT BS 740, WL 208, LBL 55. REPAIRED FLOORBEAM AT BS 740, WL 208, LBL 55 IAW US AIRWAYS EA 130213.SDR LR7A2009030900008Floorbeam · corrodedDURING SCHEDULED C-8 CHECK PER JOB CARD HC5301, FOUND UNDER DECK FLOORBEAM UPPER CAP TIE DOWN POINT EXFOLIATION CORROSION AT FS 242, WL 146, LBL 56. REPLACED IAW DRAWING 389183.SDR LR7A2009030900005Floorbeam · corrodedDURING SCHEDULED C-8 CHECK PER JOB CARD HC5313, FOUND COCKPIT FLOORBEAM UPPER CAP EXFOLIATION CORROSION AT FS 180, WL195, RBL12. FABRICATED AND INSTALLED UPPER CAP IAW SMP583 FIG 53-30-05 AND CHAP 51-70.SDR GTIA0900018Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM AT FR69 Y254. REMOVED AND REPLACED FLOORBEAM.SDR USAA2009040390796Floorbeam · corrodedMCN - C1 - MAJOR REPAIR - CORROSION ON UPPER SURFACE OF FLOORBEAM AT BS 700, WL 208 BETWEEN LBL 45 & LBL 65. REPAIRED FLOORBEAM AT BS 700, WL 208 BETWEEN LBL 45 & LBL 65 IAW US AIRWAYS EA 130213.SDR A6WA200940082Floorbeam · crackedAFT FLOORBEAM ANGLE AT LBL 9.00, FS 280.00 FOUND CRACKED AFT FLOOR ANGLE AT LBL 9.0, FS 280. REPAIRED IAW REO 601R-53-11-136 REV A. (K)SDR A6WA200940080Floorbeam · crackedOTBD CLIP CRACKED AT FS 280.00, LBL 9.0, OTBD CLIP AT FS 280.00 AND LBL 9.00. REPLACED IAW SRM 51-52-21. (K)SDR USAA2009050191053Floorbeam · crackedMCN - C24 - MAJOR REPAIR - CRACK ON FLOORBEAM SUPPORT T-CHORD AT BS 663.75, RBL 25. REPAIRED FLOORBEAM AT BS 663.75, RBL 25 IAW US AIRWAYS EA 130231.SDR USAA2009042290951Floorbeam · corrodedMCN - C24 - MAJOR REPAIR - EXFOLIATION CORROSION ON FLOORBEAM AT BS 986 BETWEEN LBL 14 TO RBL 43, WL 208. REPLACED FLOORBEAM T-CAP AT BS 986 BETWEEN LBL 50 TO RBL 50, WL 208 IAW US AIRWAYS EA 130209.SDR GTIA0900017Floorbeam · corrodedEVIDENCE OF CORROSION AT FR 68 AND Y765 BELOW AFT GALLEY. REMOVED AND REPLACED FLOORBEAM.SDR SWIA200921334Floorbeam · crackedDURING C-CHECK, FS 280 FLOORBEAM CRACKED. REPAIRED PER REO.SDR USAA2009040190765Floorbeam · corrodedMCN - C24 - MAJOR REPAIR - EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 947.5, WL 208 BETWEEN RBL 1 TO LBL 5. REPAIRED FLOORBEAM T-CAP AT BS 947.5, WL 208 BETWEEN RBL 1 TO LBL 5 IAW B737 SRM 53-60-51.SDR DU4R2009315Floorbeam · corrodedDURING SCHEDULED INSP, FOUND AFT CABIN FOORBEAM T-CAP UPPER AREAS HAVE CORROSION IN NUMEROUS AREAS RBL 10 TO LBL 10, BS 947.5SDR A6WA200940078Floorbeam · crackedPREVIOUS REPAIR, ANGLE AND CLIP CRACKED AT FS 480.00, LBL 27.00 AND LBL 36.00. AND ANGLE AND CLIP ARE REPLACED IAW SRM 51-42-21. (K)SDR FDEA200902190590Floorbeam · crackedAFT CARGO COMPARTMENT MAIN FLOOR ATTACH ANGLE AT FRAME 60 - FRAME 60, RBL 60 - 80. REMOVED ATTACH ANGLE IAW A300-600 SRM 51-40-21. RECEIVED NEW ANGLE P/N A5327541120300, PO NR 648839.1. LOCATED AND DRILLED IAW A300-600 SRM 51-40-44, PARA 2. INSTALLED IAW ASDR SWAA091186Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, BETWEEN LBL 12 TO RBL 3. REPAIRED BEAM PER SWA EA.SDR DU4R2009302Floorbeam · corrodedDURING SCHEDULED INSP, FOUND FWD CABIN FLOORBEAM HAS CORROSION AT BS 349 LBL 34 BELOW T-CAP.SDR USAA2009031890624Floorbeam · corrodedMCN - C24 - MAJOR REPAIR - EXFOLIATION CORROSION ON FLOORBEAM T-CHORD AT BS 345 BETWEEN LBL 2 TO LBL 12. REPAIRED FLOORBEAM T-CHORD AT BS 345 BETWEEN LBL 2 TO LBL 12 IAW B737 SRM 53-10-51.SDR A6WA200940077Floorbeam · crackedPREVIOUSLY REPAIRED ANGLE AND CLIP CRACKED AT F/S 484, RBL 27 AND RBL 36.0 (REF REO 53-41-059 REV A) FABRICATED ANGLE AND CLIP AND INSTALLED. (K)SDR SWIA200921856Floorbeam · corrodedC-CHECK, FS 280 BEAM CRACKED AND CORRODED. REPAIRED PER REO.SDR AALA20090624TUL14Floorbeam · corrodedAFW - FLOORBEAM AT STATION 325 HAS CORROSION AT RIGHT BUTTLINES 21, 25, 49, AND 57 THAT EXCEEDS SRM LIMITS. INSTALLED REPAIR STRAP IN ACCORDANCE WITH MRB 767-3385.SDR F3LA2009022300029Floorbeam · corrodedREFERENCE NON ROUTINE C057992. DURING C3 C-CHECK, INSPECTION NOTED CORROSION ON VARIOUS NUT CLIP FASTENER HOLES ON FLOORBEAM Y1292 BETWEEN FRAME 66 AND FRAME 68. MAINTENANCE REMOVED AND REPLACED FLOORBEAM WITH NEW PER SRM 51-42-11.SDR USAA2009022090396Floorbeam · corrodedBFM - C4 - MAJOR REPAIR - FLOORBEAM CORRODED AT BS 325, LBL 54. REPAIRED FLOORBEAM AT BS 325, LBL 54 IAW B767 SRM 53-00-51.SDR DLM88090238Floorbeam · corrodedCORROSION ON FLOORBEAM AT BS 427, LONGERON 27L TO 27 R. REPAIRED BY REPLACEMENT ON ATS 01078.SDR DL757090211Floorbeam · damagedMAIN CABIN FLOOR SUPPORT SHIM AT STA 1055 LBL 44-62.5 WATER LINE 208.1 DAMAGED. REPLACED PART ON ATS NR 00872. DAMAGE TO PART OUT OF LIMITS PER 53-10.SDR USAA2009031790619Floorbeam · corrodedSAL - C17 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT BS 986.5, BETWEEN LBL 45.5 TO RBL 45.5. REPAIRED FLOORBEAM AT BS 986.5, BETWEEN LBL 45.5 TO RBL 45.5 IAW US AIRWAYS EA 132284 & B737 SRM 53-00-51.SDR USAA2009031690602Floorbeam · corrodedSAL - C17 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT BS 986.5, RBL 4. REPAIRED FLOORBEAM AT BS 986.5, RBL 4 IAW US AIRWAYS EA 132284.SDR USAA2009030390492Stiffener · crackedMCN - C24 - MAJOR REPAIR - CRACK ON FLOORBEAM STIFFENER AT BS 328, WL 200, RBL 32. REPAIRED FLOORBEAM STIFFENER AT BS 328, WL 200, RBL 32 IAW B737 SRM 51-40-02.SDR DLM88090228Floorbeam · corrodedCORROSION FWD CABIN FLOOR STRUCTURE STA 256. REMOVED DAMAGED FLOOR STRUCTURE, FABRICATED AND INSTALLED NEW FLOOR SUPPORT STRUCTURE IAW SRM 51-30-05.SDR FDEA200902160554Floorbeam · corrodedCORRODED FLOOR SUPPORT AT RBL 3, 11, AND 16 LOCATED AFT CARGO AT BS 1200 TO BS 1380. EVALUATE AND REPAIR, AT BS 1200 TO BS 1380 FLOOR SUPPORTS AT RBL 3 AND RBL 6 CORROSION BLENDED OUT AND FOUND WITHIN ALLOWABLE LIMIT IN ACCORDANCE WITH B757-200 SRM 53-00-53, SDR A6WA200940083Floorbeam · crackedAFT FLOOR ANGLE AT RBL 9.0, FS 280.00. FOUND CRACKED AFT FLOOR ANGLE AT RBL 9.0, FS 280.0. REPAIRED IAW REO 601R 53-11-136, REV A. (K)
SDR A6WA200940081Floorbeam · crackedINBD CLIP FOUND CRACKED, FS 280, RBL 9.0. INBD CLIP REPLACED AT FS 280.0, RBL 9.0 IAW SRM 51-42. (K)SDR ASAA0944601Floorbeam · corrodedFLOORBEAM STA 344 LBL 50 CORRODED. REMOVED CORROSION, FABRICATED, DRILLED AND INSTALLED REPAIR STRAP IAW ASA EA 400 53EA 00780.SDR SWAA091131Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 270, BL 0. REPAIRED BEAM PER SRM.SDR DHLA7812009513Floorbeam · corrodedLOWER FUSELAGE AFT CARGO COMPT BS 1090 LBL 19.5 FLOORBEAM LOWER CHORD WITH CORROSION. REPAIRED FUSELAGE FLOORBEAM FWD FLANGE SECTION AT BS 1090 IAW SRM 53-10-8 FIG 8.SDR FDEA200902140517Floorbeam · corrodedSTA 345 FLOORBEAM HAS CORROSION BL 0-24L, ON EXISTING REPAIR. REMOVED AND REPLACED TCAP REPAIR IAW SRM 53-00- 51. FABRICATED ANGLES AND STRAPS IAW SRM 53-00-51.SDR CALA2009021500097Floorbeam · corrodedFLOORBEAM STATION 986 RBL 29 AND RBL 23 HAS CORROSION IN FASTENER HOLES. REPAIRED FASTENER HOLES ON FLOORBEAM AT STATION 986 RBL 29 AND RBL 23 PER CAL EC/RA 5321-01429, REPAIR B.SDR SWIA200921859Floorbeam · crackedC-CHECK, BEAM RBL 12 AT FS 274 CRACKED. REPAIRED PER REO.SDR SWIA200921858Floorbeam · corrodedC-CHECK, FS 280 LEFT BEAM CORRODED. REPAIRED PER REO.SDR AALA20090624TUL15Floorbeam · crackedAFW - FLOORBEAM AT STATION 347 TOP SURFACE CRACKED AT RIGHT BUTTLINE 84. INSTALLED FLOORBEAM REPAIR, REPAIR ANGLES AND STRAP IN ACCORDANCE WITH MRB 767-3387 AND SRM 53 00 51 2R.SDR DHLA7812009506Floorbeam · corrodedLOWER FUSELAGE AFT CARGO COMPARTMENT BS 950E LBL 43 FLOORBEAM LOWER CHORD WITH CORROSION. REPAIRED AFT CARGO COMPARTMENT FLOORBEAM LOWER CHORD BS 950E BETWEEN LBL 35.5 AND LBL 50.5 IAW SRM 53-10-8 FIG.8.SDR IPXA09554859Floorbeam · corrodedINSPECTION TYPE:C4 CORROSION MAIN CABIN FLOORBEAM BS 1200 LBL 48.55 WL 208. REPAIRED PER ATS ER 09-1641 DATED 26FEB09 UPS EO B757-5310-32484A.SDR IPXA09554858Floorbeam · corrodedINSPECTION TYPE:C4 CORROSION MAIN CABIN FLOORBEAM BS 1200 LBL 48-55 WL 208. REPAIRED PER ATS ER 09-1641 DATED 26FEB09 UPS EO B757-5310-32484A.SDR IPXA09554855Floorbeam · corrodedINSPECTION TYPE:C4 CORROSION MAIN CABIN FLOORBEAM BS 1200 LBL 5 WL 209. REPAIRED PER ATS ER 09-1641 DATED 26FEB09 AND UPS EO B757-5310-32484A.
Back to JASC 5315