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 SWAA102705Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 987, BETWEEN RBL 0 TO RBL 46. REMOVED AND REPLACED BEAM PER SRM.SDR A6WA201040483Floorbeam · crackedFS 280, FLOOR SUPPORT UPPER ANGLE CRACKED AT LBL 11.0. REPAIRED CRACKED FS 280, FLOOR SUPPORT ANGLE IAW REO REPAIR 601R-53-11-138, REV NC.SDR CALA2010051000193Floorbeam · corrodedSUPPORT TASK CABIN - AFTER E/E COMPT REMOVAL, RT STA 303 RBL 40-60 FLOORBEAM UPPER SURFACE FOUND CORROSION. CABIN FLOORBEAM UPPER TEE AT STA 303 LBL 40 - LBL 60 REPAIRED AS PER SRM 53-00-51 FIG 201 REPAIR 1 FORM 44.0008 ITEMS 1 TO 25 ACCOMPLISHED.SDR USAA2010052491023Floorbeam · corrodedPIT - MAJOR REPAIR - S2 CHECK - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR 20 - FR 21, -Y765. REPLACED FLOOR BEAM AT FR 20 - FR 21, -Y765 IAW A319 SRM 51-72-11.SDR USAA2010051990992Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - LEVEL 2 CORROSION ON UPPER SURFACE OF FLOORBEAM BETWEEN FR18 TO FR20, -Y1292. REPLACED FLOORBEAM BETWEEN FR18 TO FR20, -Y1292 IAW A319 SRM 51-41-11.SDR USAA2010051990990Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - LEVEL 2 CORROSION ON UPPER SURFACE OF FLOORBEAM AT FR21, Y254. REPLACED FLOORBEAM AT FR21, Y254 IAW A319 SRM 51-72-11.SDR USAA2010051990989Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON UPPER SURFACE OF FLOORBEAM BETWEEN FR16 TO FR20, Y1292. REPLACED FLOORBEAM BETWEEN FR16 TO FR20, Y1292 IAW A319 SRM 51-42-11 & 51-76-11.SDR FDEA201005091501Floorbeam · corrodedCABIN: TOP OF FLOORBEAM HAS CORROSION AT STA 365.25, BL 0 TO RBL 45". FLOORBEAM REPAIRED IAW STA ENGINEERING EA NR 757-5315-08-E0691 REV A AND PART 1 OF EA N F-5310-135849 COMPLIED WITH, THIS REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR CALA2010051000192Floorbeam · corrodedCORROSION ON FLOORBEAM AT STA 344 BETWEEN LBL 10 AND RBL 10 SEE WORK CARD MASTER PANEL CLOSE ZONE 107C SEQ 1007 FOR FLOOR PANELS INSTALLATION. REPAIRED CABIN FLOORBEAM STA 344 UPPER CORD BETWEEN BLL 10 AND RBL 10 PER ECRA 5310-01490.SDR F3LA2010052200425Floorbeam · corrodedREF HEAVY MX NON ROUTINE N0281. FLOORBEAM AT FRAME 68 BEAM +4765 CORRODED. CUT OUT DAMAGED AREA.FABRICATED REPAIR SECTION AND INSTALLED IAW SRM 53-00-14 FIG 204.SDR F3LA2010052200421Floorbeam · corrodedHEAVY MX NON-ROUTINE N0283. REAR FUSELAGE FLOORBEAM AT FRAME 66 HAS CORROSION AROUND FASTENER HOLE. REPAIRED AREA IAW SRM 53-41-14, PAGE 201, FIGURE 201 PRINCIPLE NR 6.SDR GTIA1000014Floorbeam · corrodedCORROSION ON FLOORBEAMS BETWEEN FRAME 67 AND 69.SDR USAA2010050790928Floorbeam · corrodedBFM - C4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM UPPER CHORD AT BS 287 ABOVE S20R, WL 200 BETWEEN RBL 5 TO RBL 88. REPAIRED FLOORBEAM UPPER CHORD AT BS 287 ABOVE S20R, WL 200 BETWEEN RBL 5 TO RBL 88 IAW B767 SRM 53-00-51.SDR USAA2010060191048Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - CORROSION AROUND ATTACH HOLE ON FLOORBEAM AT FR66, -Y465. REPLACED FLOORBEAM AT FR66, -Y465 IAW A319 SRM 51-72-11.SDR FDEA201005051464Floorbeam · corrodedMAIN DECK FLOORBEAM STA 1681.8, LBL39 UPPER CHORD HAS CORROSION AROUND NUT PLATE. REMOVED CORROSION FROM F/B STA 1681 IAW SRM 51-10-02. BLENDED AREA L=4.0" W=1.0, D=.019, ORIG MAT 156 REMAINING 137 OUT OF LIMITS IAW SRM 53-99-51, FIG 101, DET III. REPAIRESDR FDEA201005051463Floorbeam · corrodedCORROSION BOTTOM FLANGE FLOORBEAM BS 720 RBL 38 MAIN CABIN. CUT OUT DAMAGED AREA AT FLOORBEAM, BS 720, RBL 38, DIM: 3" X 2" IAW SRM 53-10-8, FIG 2, FABRICATED 2 NEW ANGLES 7075T6 .063 DIM: 17" X 2.75", FILLER BAC 1505-100797 7075T6 DIM: 3" X 2", STRAP 707SDR SWAA102590Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 987, BETWEEN RBL 0 TO RBL 10. REPAIRED BEAM PER SRM.SDR SIMA201012502Floorbeam · crackedDURING MAINTENANCE BASE VISIT FOUND FRAME 280 FLOORBEAM LEFT SIDE TO BE CRACKED. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE LEFT FLOORBEAM FRAME 280 IAW EO CR-53MR-134R1. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR USAA2010050690913Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68, -Y1160. REPLACED FLOORBEAM BETWEEN FR66 TO FR68, -Y1160 IAW A319 SRM 51-72-11.SDR USAA2010050690912Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR68, -Y1160. REPLACED FLOORBEAM AT FR68, -Y1160 IAW A319 SRM 51-72-11.SDR USAA2010050690910Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR70, -Y765. REPLACED FLOORBEAM AT FR70, -Y765 IAW A319 SRM 51-72-11.SDR USAA2010050690909Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM SEGMENT BETWEEN FR64.5 TO FR66, -Y765. REPLACED FLOORBEAM SEGMENT BETWEEN FR64.5 TO FR66, -Y765 IAW A319 SRM 51-72-11.SDR SWAA102567Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM NUT PLATE HOLES CORRODED AT BS 986.5, BETWEEN LBL 45 TO RBL 45. REPAIRED BEAM PER SRM.SDR SWAA102566Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328 BETWEEN RBL 11 TO RBL 22. REPAIRED BEAM PER SRM.SDR SWAA102565Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM T-CHORD CORRODED AT BS 294.5 BETWEEN RBL 42 TO RBL 43. REPAIRED T-CHORD PER SRM.SDR SWAA102499Fitting · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM FITTING CRACKED AT BS 727, RBL 45.5. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA102481Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 665, BBL 0.07. REPAIRED BEAM PER ER.SDR SWAA102480Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 24. REPAIRED BEAM PER ER.SDR ASAA1047911Floorbeam · corrodedAFT CABIN FLOORBEAM STA 967 HAS AREA OF CORROSION. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED FLOORBEAM REPAIR.SDR DALA109113351Floor Support · corrodedDURING H-CHECK FOUND CORROSION ON FLOOR STRUCTURE AT Y1456 FR17. REPAIRED IAW ERA 481359-14, REV O.SDR USAA2010050690908Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FORWARD SECTION OF THE Z-FLOORBEAM BETWEEN FR66 TO FR68, Y1160. REPLACED FORWARD SECTION OF THE Z-FLOORBEAM BETWEEN FR66 TO FR68, Y1160 IAW A319 SRM 51-42-11.SDR USAA2010050690907Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON MIDDLE SECTION OF Z-FLOORBEAM BETWEEN FR68 TO FR69, Y1160. REPLACED MIDDLE SECTION OF Z-FLOORBEAM BETWEEN FR68 TO FR69, Y1160 IAW A319 SRM 51-42-11.SDR USAA2010050690906Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON AFT SECTION OF THE Z-FLOORBEAM BETWEEN FR64 TO FR66, Y1160. REPLACED AFT SECTION OF THE Z-FLOORBEAM BETWEEN FR64 TO FR66, Y1160 IAW A319 SRM 51-42-11.SDR FDEA201004301404Floorbeam · corrodedMAIN DECK FLOORBEAM CORRODED AT STA 365 FROM BL0 TO RBL 60. REMOVED CORROSION REMOVED .057" FROM .125" ORIGINAL MATERIAL OUT OF LIMITS IAW SRM 53-00-51 FIG 101 DETAIL II, REMOVED PREVIOUS REPAIR FROM STA 365 RBL 58 -RBL 15. EXTENDED CUT LINE TO LBL 14 AT SDR ASAA1047945Floorbeam · corrodedCABIN FLOORBEAM CORRODED AROUND FASTENER HOLES AT PREVIOUS REPAIR. REMOVED EXISTING UPPER T-CHORD REPAIR, INSTALLED NEW CHORD AND REPAIR PARTS.SDR ASAA1077773Floorbeam · crackedLOWER FLANGE ON FLOORBEAM CRACKED IN RADIUS. REMOVED AND REPLACED THE BS 269 FLOORBEAM UPPER CHORD.SDR SWAA102438Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 729B, LBL 2. REMOVED AND REPLACED BEAM SECTION PER SRM.SDR SWAA102371Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CRACKED AT BS 666, RBL 24.5. REPAIRED BEAM PER AEM.SDR SWAA102355Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CRACKED AT BS 727B, LBL 45.5. REPAIRED BEAM PER AEM.SDR SWAA102353Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CRACKED AT BS 727B, RBL 45.5. REPAIRED BEAM PER AEM.SDR AALA20100428TUL04Floorbeam · crackedFLOORBEAM STATION 700 LEFT BUTTLINE 24 CRACKED. REPAIRED FLOORBEAM WITH SPLICED T-CAP AND DOUBLER PER TASK CARD 53-98-01 AND SRM 53-00-51-2R REPAIR NUMBER 3.SDR DALA1011280179Floorbeam · corrodedM/D STA 325 LBL20" FLOORBEAM FOUND CORRODED AND SUBJECT FLOORBEAM REPAIRED IAW ERA 480438-14.SDR DALA1011260179Floorbeam · corrodedM/D STA 1518 FLOORBEAM LBL 32INCH FOUND CORRODED AND SUBJECT FLOORBEAM REPAIRED IAW ERA 480438-14.SDR USAA2010050690911Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR70, -Y160. REPLACED CORROSION ON FLOORBEAM AT FR70, -Y160 IAW A319 SRM 51-72-11.SDR USAA2010042990863Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR65 TO FR66, -Y1732. REPLACED FLOORBEAM BETWEEN FR65 TO FR66, -Y1732 IAW A319 SRM 51-42-11.SDR ASAA1047952Floorbeam · corrodedAFT CABIN FLOORBEAMS HAS CORROSION IN SEVERAL PLACES. REMOVED DAMAGED AREA INSTALLED REPAIR.SDR A6WA201040297Floorbeam · crackedFS 280 UPPER CAP CRACKED AT RBL 10.0 AND LBL 10.0. R & R CLIP IAW SRM PROCEDURES AND REO 601R-53-11-926, REV B DABE 5/10/2006.SDR FDEA201004271367Floorbeam · corrodedCORROSION FLOORBEAM TOP MAIN CABIN BS 950 RBL 45 TO RBL 62. CORROSION OUT OF LIMITS, R & R FLOORBEAM TOP BS 950 RBL 62.5 TO 62.5 FROM BAC 1505-100405 7075T6 DIM: 129.5" LONG IAW B. DWG NR 65-16338, SRN 53-10-1, FIG 8.SDR DALA1011270179Floorbeam · corrodedM/D STA 287 RBL60" FLOORBEAM FOUND CORRODED AND SUBJECT FLOORBEAM REPAIRED IAW ERA 480438-14.SDR USAA2010042990864Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOORBEAM BETWEEN FR20 TO FR21, -Y189. REPLACED FLOORBEAM BETWEEN FR20 TO FR21, -Y189 IAW A319 SRM 51-72-11.
Back to JASC 5315