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 SWAA100150Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 707 TO BS 708, LBL 24.6. REPAIRED BEAM PER ER.SDR R61A2010003Floorbeam · corrodedLEVEL TWO CORROSION FOUND DURING HEAVY CHECK. LT FLOORBEAM HAS CORROSION, LEVEL TWO, AROUND RIVET HOLE AT FRAME 87. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM IAW EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK.SDR DALA100229876Floorbeam · corrodedDURING "H" CHECK FOUND CORROSION ON FLOORBEAM AT BS 200 BL0-L20L. REPAIRED IAW SRM 51-10-03.SDR DALA100219871Floorbeam · corrodedDURING "H" CHECK FOUND CORROSION ON FLOORBEAM AT BS 237 L22L-L44L. REPAIRED IAW SRM 53-10-03.SDR SIMA201001101Floorbeam · crackedDURING MAINTENANCE BASE CHECK FOUND FRAME 280 FLOORBEAM CRACKED AT BUTT LINE 9 RIGHT W1 72.50. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED THE RIGHT FRAME 280 FLOORBEAM IAW EO CR-53MR-134RL. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR USAA2010010890055Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR20 TO FR21, Y254. REPLACED FLOORBEAM BETWEEN FR20 TO FR21, Y254 IAW A319 SRM 51-42-11.SDR SWIA201023739Floorbeam · crackedLBL12 FLOORBEAM FORWARD OF FS 280 CRACKED AT ANGLE BRACKET TIE IN. (C CHECK) REPAIRED PER REO.SDR USAA2010020290264Floorbeam · corrodedSAL - C22 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM CHORD UPPER FACE AT BS 294.5, RBL 34. REPAIRED FLOORBEAM CHORD UPPER FACE AT BS 294.5, RBL 34 IAW B737 SRM 53-10-51 REPAIR 5.SDR SWIA201023483Floorbeam · chafedC-CHECK, LANDING GEAR ALTERNATE RELEASE CABLE PULLEY CHAFING ON FS 280 BEAM. REPAIRED PER REO.SDR SWAA100098Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, RBL 3. REPAIRED BEAM PER EA.SDR SWAA100097Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, RBL 7. REPAIRED BEAM PER EA.SDR SWAA100096Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, LBL 8. REPAIRED BEAM PER EA.SDR SWAA100095Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, LBL 12. REPAIRED BEAM PER EA.SDR SWAA100094Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, LBL 17. REPAIRED BEAM PER EA.SDR AALA20100108TUL14Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM STATION 294.5, RIGHT BUTTLINE 28 TO 34. REPLACED UPPER "T" CAP PER ENGINEERING AUTHORIZATION B737-53-008449 AND B737-53-008405.SDR AALA20100108TUL09Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM STATION 294.5 RIGHT BUTTLINE 13 TO RIGHT BUTTLINE 21. REPLACED UPPER "T" CAP PER ENGINEERING AUTHORIZATION B737-53-008449 AND B737-53-008405.SDR AALA20100107TUL05Floorbeam · corrodedCORROSION ON FLOORBEAM. REMOVED CORROSION AND REPAIRED PER SRM 53-00-51.SDR FDEA201001050029Floorbeam · crackedCRACK INDICATION FLOORBEAM MAIN CABIN BS 400 LBL 8. CUTOUT DAMAGED AREA IAW DWG SR 27-53-034 REV "F". FABRICATED 2 ANGLE REPAIRS. 2 STRAPS, & 1 TEE IAW DWG SR 27-53-034 REV "F". TREATED AND PRIMED IAW SRM 51-10-2. INSTALLED ALL PARTS IAW SRM 51-30-2 & DSDR SWIA201023463Floorbeam · corrodedC-CHECK, FS 280 BEAM CORRODED AT TOP AND CRACKED AT LBL11.5. REPLACED BEAM PER REO.SDR SWIA201023452Floorbeam · crackedDURING C-CHECK, FS 280 BEAM CRACKED. REPAIRED PER REO.SDR IPXA10558136Floorbeam · damagedINSPECTION TYPE: C2, FOUND MECHANICAL DAMAGE ON FLOORBEAM AT STA 1020 BL 0 TO RBL 24. REPAIRED DAMAGED FLOORBEAM IAW SRM 53-00-51-1A, SRM 51-40-2 AMM 51-21-04-7.SDR SWAA100044Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND FLOORBEAM CRACKED AT BS 670, RBL 24. REPAIRED BEAM PER EA.SDR USAA2010011990135Floorbeam · corrodedLEVEL 2 CORROSION ON FLOORBEAM AT FR 16, Y505, S23L. REPLACED FLOORBEAM AT FR16, Y505, S23L IAW A319 SRM 51-72-11.SDR SWAA100027Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND CENTER WING BOX LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 713.5, BBL 0.07. REPAIRED WEB PER SRM.SDR SWAA100021Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CHORD CRACKED AT BS 294, LBL 54. REPAIRED CHORD PER SRM.SDR UALA2010010400057Floorbeam · misrepairedDURING REPAIR OF MAIN DECK FLOORBEAMS AT BS 1265 LT AND RT FOUND REPAIR ANGLES WITH SHORT EDGE MARGIN. MAJOR REPAIR ACCOMPLISHED: FABRICATED AND INSTALLED NEW REPAIR ANGLES AT BS 1265 LT AND RT.SDR UIEA201000106Floorbeam · crackedM/DECK WEB CRACKED STA 380, RBL 80. M/D STA 380 RBL 80 FLOORBEAM CRACKED WEB TRIMMED OFF FROM RBL 77 TO RBL 88. HFEC INSPECTED, NO CRACK AFT TRIMMED OFF. FLOORBEAM WAS REPAIRED IAW SRM 53-00-51-2R-1 FIG 201 REPAIR 1. CATEGORY B. REF NON ROUTINE NR 50999.SDR USAA2009123193461Floorbeam · crackedBFM - MAJOR REPAIR - C4 CHECK - CRACKED FLOORBEAM AT BS 347, LBL 9 - RBL 45. REPAIRED FLOORBEAM AT BS 347, LBL 9 - RBL 45 IAW EA 134181.SDR IPXA10558155Floorbeam · corrodedINSPECTION TYPE:C2, CORROSION ON UPPER SURFACE OF BS 1100 FLOORBEAM WL 208 LBL36 TO RBL 55 (MARKED). REPAIRED FLOORBEAM IAW ATS ER NR 09-6023 DATED 1-13-10.SDR IPXA10558148Floorbeam · corrodedINSPECTION TYPE: C2, CORROSION FOUND ON LWR SURFACE OF THE UPPER CHORD AT LBL 4.7" BS 1200 OUT OF LIMITS. REPAIRED FLOORBEAM AT BS 1200, IAW REV ATS ER NR 10-1000, AND EO NR B757-5310-36265-A.SDR UHLA2009122900153Floorbeam · corrodedLEVEL 2 CORROSION ON FLOOR GUSSETS AFT SIDE OF GALLEY. REMOVED DAMAGED GUSSETS AND FABRICATED NEW GUSSETS, INSTALLED IAW EMB IC 2009-170/00325.SDR IPXA10558124Floorbeam · corrodedINSPECTION TYPE: C2 LONGITUDINAL FLOORBEAM UPPER CHORD CORRODED, BS1055 RBL44 WL208. FLOORBEAM EAS REPLACED IAW SRM 51-40-02.SDR IPXA10558123Floorbeam · corrodedINSPECTION TYPE:C2 LONGITUDINAL FLOORBEAM UPPER CHORD CORRODED BS1055 RBL26 WL208. FLOORBEAM WAS REPLACED IAW SRM 51-40-02.SDR IPXA10558100Floorbeam · corrodedINSPECTION TYPE:C2 FLOORBEAM IS CORRODED BS 1016 BETWEEN LBL25 AND LBL45 WL208. FLOOR SUPPORT WAS REPLACED IAW SRM 53-00-51 AND SRM 51-40-02.SDR SWAA098143Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 715, BBL 0. REPAIRED BEAM PER AAR EA.SDR SWAA098100Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND CENTER BOX WING LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 727B, RBL 24.8. REPAIRED BEAM PER AAR EA.SDR SWAA098099Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND CENTER BOX WING LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 727B, LBL 24.8. REPAIRED BEAM PER AAR EA.SDR SWAA098098Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND CENTER BOX WING LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 707, LBL 24.8. REPAIRED WEB PER AAR EA.SDR SWAA098014Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947.5, LBL 5. REPAIRED BEAM PER EA.SDR USAA2010011990132Floorbeam · corrodedLEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR 66 TO FR 67 + 10 INCHES, Y1230. REPLACED FLOORBEAM BETWEEN FR 66 TO FR 67 + 10 INCHES, Y1230 IAW SRM 51-72-11.SDR USAA2010011990131Floorbeam · corrodedMAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON HARD POINT AREA OF FLOORBEAM BETWEEN FR 65 + 29 INCHES TO FR66 + 5 INCHES, Y920. REPLACED FLOOR AND DRAWING NR D53472040.SDR USAA2010011990130Floorbeam · corrodedLEVEL 2 INTERGRANULAR CORROSION ON HARD POINT AREA OF FLOORBEAM AT FR 66 + 5 INCHES, Y320. REPLACED FLOORBEAM AT FR 66 + 5 INCHES, Y320 IAW A320 SRM 51-72-11.SDR FDEA200912284519Floorbeam · misrepairedFWD CARGO COMPARTMENT BILGE AREA, FLOORBEAM UPPER CHORD FOUND WITH STRUCTURE REPAIR AT STA 1059, LBL 20 TO RBL 20. FWD CARGO COMPARTMENT BILGE AREA, FLOORBEAM UPPER CHORD EXISTING REPAIR AT STA 1059, LBL 20 TO RBL 20 EVALUATED AND FOUND NOT IAW ANY SRM REPAISDR F3LA2010010500278Floorbeam · corrodedDURING C3 C-CHECK INSP, NOTED FLOORBEAM CORRODED AFT CABIN AT FRAME 67 Y1295. MX REMOVED AND REPLACED FLOORBEAM IAW SRM 51-74-00, SRM 53-00-14, SRM 51-42-11, SRM 51-44-11 AND SRM 51-75-12.SDR F3LA2010010200277Floorbeam · corrodedDURING C3 C-CHECK INSP NOTED FLOORBEAM CORRODED AFT CABIN AT FRAME 67 Y1295. MX REMOVED AND REPLACED FLOORBEAM IAW SRM 51-74-00, SRM 53-00-14, SRM 51-42-11, SRM 51-44-11 AND SRM 51-75-12.SDR CALA2009122800764Floorbeam · corrodedCABIN FLOORBEAM UPPER FRONT FLANGE UNDER SIDE HAS HEAVY CORROSION AT STA 1681, LBL 48. REPAIRED DAMAGED FLOORBEAM STA 1681 LBL 48 REF ECRA 5310-05066.SDR CALA2009122800763Floorbeam · corrodedCABIN FLOORBEAM AT STA 1681, LBL 5 HAS CORROSION ON FWD EDGE LOWER SURFACE, SEEN FROM BELOW. REPAIRED DAMAGED FLOORBEAM STA 1681, LBL 5 REF ECRA 5310-05066.SDR USAA2010010590032Floorbeam · corrodedMCN - S2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR68, -Y765. REPLACED FLOORBEAM AT FR68, -Y765 IAW A320 SRM 51-42-11.SDR SWAA097997Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 45.5. REPAIRED BEAM PER AAR EA.SDR SWAA097938Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 987, BETWEEN RBL 46 TO LBL 46. REPAIRED BEAM PER SRM.
Back to JASC 5315