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 USAA2010082491765Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR66, Y765. REPLACED FLOORBEAM AT FR66, Y765 IAW A320 SRM 51-42-11.SDR USAA2010081091637Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR66, Y765. REPLACED FLOORBEAM AT FR66, Y765 IAW A320 SRM 51-72-11.SDR SWAA104592Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 967, RBL 28. REPAIRED BEAM PER SRM.SDR SWAA104569Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, RBL 8. REPAIRED BEAM PER EA.SDR SWAA104568Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, RBL 3. REPAIRED BEAM PER EA.SDR SWAA104567Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, LBL 3. REPAIRED BEAM PER EA.SDR SWAA104566Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, LBL 8. REPAIRED BEAM PER EA.SDR SWAA104565Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, LBL 17. REPAIRED BEAM PER EA.SDR SWAA104564Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, LBL 12. REPAIRED BEAM PER EA.SDR VGQY2010080500058Floorbeam · damagedHFEC OPEN HOLE INSP FOUND DOUBLE HOLE ON BS 640 RBL 50 UPPER DECK FLOORBEAM UPPER CHORD AFT HORIZONTAL FLANGE AS MARKED. NEW WEB FABRICATED PER DWG 65B14743 DAMAGED UPPER CHORD AND WEB REMOVED AND REPLACED PER SRM 51-30-02 REV 117.SDR A6WA201040738Floorbeam · crackedCLIP AT RBL9 AND FS 280 IS CRACKED. LOCATED ON OTBD SIDE OF RBL9.0. R & R CLIP AT FS280 OTBD SIDE OF RBL9.0 IAW SRM 51-42-21.SDR A6WA201040737Floorbeam · crackedFLOOR ANGLE AT FS 280 IS CRCKED JUST OTBD OF LBL 9.0. REPAIRED FS280 AFT FLOOR SUPPORT ANGLE IAW REO 601R-53-11-138.SDR IPXA10562156Floorbeam · corrodedINSPECTION TYPE:C2, FLOORBEAM HAS CORROSION BS 879, LBL 30 AND 40 UPPER CHORD FWD FLANGE. REPAIR IAW ATS ER 10-3863.SDR VGQY2010080400055Floorbeam · crackedHFEC OPEN HOLE INSP FOUND CRACK ON BS 340 LBL 32 UPPER DECK FLOORBEAM UPPER CHORD AFT HORIZONTAL FLANGE. REPAIR STRAP AND FILLER FABRICATED AND INSTALLED PER SERVICE BULLETIN B747-53A2431 FIGURE 9 REVISION 2.SDR IPXA10562341Floorbeam · corrodedINSPECTION TYPE:C3, THE UPPER CHORD OF THE BS 1540 FLOORBEAM IS CORRODED RBL 40, WL 208. REPAIRED IAW ATS ER 10-3857.SDR IPXA10562292Floorbeam · corrodedINSPECTION TYPE:C3, THE BS 1200 FLOORBEAM UPPER CHORD IS CORRODED LBL 55 TO RBL 55, WL208. REPAIRED IAW EO B757-5310-39439-A.SDR IPXA10562249Floorbeam · corrodedINSPECTION TYPE:C3, THE UPPER TEE OF THE BS 1320 FLOORBEAM IS CORRODED RBL 28-55, WL 208. REPAIRED CORRODED FLOORBEAM IAW ER10-3871, SRM 53-60-51-0I 1, SRM 53-00-51-1A, SRM 51-10-02-0G DWG 146N5023.SDR U2RA227DHN014Floor Support · corrodedMAIN CABIN STA 1656, BL 0, FLOOR SUPPORT HAS CORROSION.SDR DALA1018223270Support · crackedDURING M-CHECK FOUND CRACK IN FLOORBEAM SUPPORT WEB BETWEEN FR8 TO FR11. REPAIRED PER SRM 51-42-11.SDR SWAA104537Floorbeam · crackedDURING SCHEDULED HC1 CHECK, FOUND LEFT O/B FLOORBEAM CRACKED AT BS 316. REPAIRED BEAM PER SRM.SDR DALA1018073270Support · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM SUPPORT AT Y1292 BETWEEN FR67 AND FR 68. REPAIRED PER SRM 51-42-11, SRM 51-44-11.SDR DALA1018063270Support · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM SUPPORT AT +Y765 BETWEEN FR66 & FR70. REPAIRED PER SRM 51-42-11, SRM 51-44-11.SDR DALA1018053270Support · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM SUPPORT AT Y1292 BETWEEN FR68 & FR69. REPAIRED PER SRM 51-42-11, SRM 51-44-11.SDR DALA1018043270Support · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM SUPPORT AT Y765 BETWEEN FR66 & FR70. REPAIRED PER SRM 51-42-11, 51-44-11.SDR DALA1018033270Support · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM SUPPORT AT Y765 BETWEEN FR64 & FR66. REPAIRED PER SRM 51-42-11, SRM 51-44-11.SDR FDEA201008022774Floorbeam · corrodedFLOORBEAM STA 324, RBL 24 TO RBL60, CORROSION. REMOVED CORROSION IAW SRM 51-10-02, ORIG MATL..120", LOSS: .030", REMAINING: .090", FOUND OUT OF LIMITS IAW SRM 53-10-08, FIG 101, P 107. R & R FLOORBEAM UPPER TEE IAW SRM 51-40-02 AND SRM 51-20-05. MAJOR RESDR DALA1017983270Support · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM SUPPORT AT +Y1292 BETWEEN FR68 & FR69. REPAIRED PER SRM 51-44-11, SRM 51-42-11.SDR DALA1017973270Support · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM SUPPORT AT +Y1292 BETWEEN FR64 & FR66. REPAIRED PER SRM 51-44-11, SRM 51-42-11.SDR DALA1017963270Support · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM SUPPORT AT +Y1292 BETWEEN FR66 & FR68. REPAIRED PER SRM 51-44-11, SRM 51-42-11.SDR FDEA201007312744Floorbeam · damagedREMOVED FLOORBEAM STA 1640 IAW SRM 51-40-02, FABRICATED NEW FLOORBEAM STA 1640, FROM MAT TYPE PN BAC 1518-338/18A, BATCH 1783535 IAW DWG NR 146N5089, SH 3, REV B. INSTALLED FLOORBEAM IAW SRM 51-40-02. MAJOR REPAIR.SDR CALA2010080300362Floorbeam · corrodedCABIN - STA 1661 RBL 0 - RBL 16 FLOORBEAM FOUND CORRODED (CTN CP53-251-01I). CABIN FLOORBEAM UPPER SURFACE CORROSION REMOVED OUT OF SRM 53-00-51 ALLOWABLE DAMAGE 1 FIG 101 LIMIT AND CORRODED FLOORBEAM REPAIRED AS PER SRM 53-00-51 REPAIR 3 FIG 201 AT STA 1661 SDR DALA1017953270Support · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM SUPPORT AT Y254 BETWEEN FR66 & FR68. REPAIRED PER SRM 51-44-11, SRM 51-42-11.SDR IPXA10562168Floorbeam · corrodedINSPECTION TYPE:C2, FLOORBEAM IS CORRODED, BS 879, WL 208, LBL 4. REPAIRED IAW ER NR10-3741, DATED 23AUG10 AND EO NR B757-5310-39352-A, DATED 8/25/10.SDR USAA2010082491777Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR66, Y1732. REPLACED FLOORBEAM AT FR66, Y1732 IAW A320 SRM 51-72-11.SDR USAA2010082491776Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM ASSEMBLY BETWEEN FR64 TO FR70, Y1292. REPLACED FLOORBEAM ASSEMBLY BETWEEN FR64 TO FR70, Y1292 IAW A320 SRM 51-72-11.SDR USAA2010082491775Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM ASSEMBLY BETWEEN FR64 TO FR70, Y1292. REPLACED FLOORBEAM ASSEMBLY BETWEEN FR64 TO FR70, Y1292 IAW A320 SRM 51-72-11.SDR USAA2010082491774Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM ASSEMBLY BETWEEN FR64 TO FR70, Y1292. REPLACED FLOORBEAM ASSEMBLY BETWEEN FR64 TO FR70, Y1292 IAW A320 SRM 51-72-11.SDR USAA2010082491773Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 WIDESPREAD GALVANIC CORROSION ON FLOORBEAM ASSEMBLY BETWEEN FR66 TO FR68, Y765. REPLACED FLOORBEAM ASSEMBLY BETWEEN FR66 TO FR68, Y765 IAW A320 SRM 51-72-11.SDR USAA2010082491772Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 WIDESPREAD GALVANIC CORROSION ON FLOORBEAM ASSEMBLY BETWEEN FR66 TO FR68, Y765. REPLACED FLOORBEAM ASSEMBLY BETWEEN FR66 TO FR68, Y765 IAW A320 SRM 51-72-11.SDR USAA2010082491771Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 WIDESPREAD EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68, -Y1292. REPLACED FLOORBEAM BETWEEN FR66 TO FR68, -Y1292 IAW A320 SRM 51-72-11 & 51-42-11.SDR USAA2010082491770Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 WIDESPREAD EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68, -Y1292. REPLACED FLOORBEAM BETWEEN FR66 TO FR68, -Y1292 IAW A320 SRM 51-72-11 & 51-42-11.SDR USAA2010082491769Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 WIDESPREAD EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68, -Y1292. REPLACED FLOORBEAM BETWEEN FR66 TO FR68, -Y1292 IAW A320 SRM 51-72-11 & 51-42-11.SDR IPXA10561888Floorbeam · corrodedINSPECTION TYPE:C2, FLOORBEAM UPPER FLANGE IS CORRODED AT NUTPLATE LOCATIONS, BS 620, BETWEEN LBL 25 AND LBL 45, WL 208. REPAIRED IAW ER 10-3743.SDR FDEA201007302742Floorbeam · corrodedCORROSION ON LOWER FLANGE OF MAIN CABIN FLOORBEAM AT BS 720, BL0 TO LBL 35. CUT OUT 2 EACH DAMAGED AREAS DIMS 1.75" X .9" EACH, FABRICATED TWO ANGLES USING 7075-O .071 DIMS 34.25" X 2.75" AND 29 5/8" X 2.5", HEAT TREATED ANGLES FROM 7075-O TO T6 CONDITIONSDR USAA2010081291652Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR67 TO FR69, -Y464. REPLACED FLOORBEAM BETWEEN FR67 TO FR69, -Y464 IAW A320 SRM 53-00-14.SDR AALA20100730TUL04Floorbeam · corrodedCORROSION AT FLOORBOARD FASTENER HOLE FORWARD FLOORBEAM STATION 987 LEFT BUTTLINE 43 INCHES. INSTALLED REPAIR DOUBLER PER EA B737-53-012136.SDR USAA2010081091636Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR16, Y254. REPLACED FLOORBEAM AT FR16, Y254 IAW A320 SRM 51-42-11.SDR USAA2010081091635Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR16, Y1292. REPLACED FLOORBEAM AT FR16, Y1292 IAW A320 SRM 51-72-11.SDR USAA2010081091634Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR66 TO FR69, -Y765. REPLACED FLOORBEAM BETWEEN FR66 TO FR69, -Y765 IAW TYPICAL REPAIR 51-40-01A.SDR USAA2010081091633Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR66 TO FR69, -Y765. REPLACED FLOORBEAM BETWEEN FR66 TO FR69, -Y765 IAW TYPICAL REPAIR 51-40-01A.
Back to JASC 5315