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 DL75E090686Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 1660, RB0, UPPER SURFACE CORRODED AROUND FASTNERS AR SAA - SAT ON N/R 129491 JOB 82598990001.SDR QXEA2009041600262Floorbeam · corrodedMULTIPLE AREAS OF CORROSION ON FS 280.0 FLOORBEAM. REMOVED 280 BEAM LT IAW T/C SB670BA-53-026. RELOCATED AND DRILLED NEW 280 BEAM AND ANGLES IAW T/C SB670BA-53-26/B. INSTALLED LT SIDE 280 BEAM IAW SB670BA-53-026. REMOVED INTERCOSTALS ON RIGHT SIDE OF 280 BSDR FDEA200904161310Floorbeam · crackedAFT CARGO COMPARTMENT FRAME 58 BETWEEN SEAT TRACKS NR 2RT AND NR 3RT CABIN FLOORBEAM HAS 1 INCH CRACK CUT OUT DAMAGED AREA AND INSTALLED CROSSBEAM REPAIR AT CRACKED STIFFENER AT FRAME 58 CROSSBEAM BETWEEN SEAT TRACKS NR 2 RT AND NR 3 RT IAW A300-600 FREIGHTERSDR ASAA0995449Floorbeam · corrodedFLOORBEAM STA 986 CORRODED. REMOVED DAMAGED SECTION OF FLOORBEAM, FABRICATED, TREATED, PRIMED, TOP COATED AND INSTALLED T-CHORD REPAIR IAW ASA EA 900 52EA 01237.SDR ASAA0995448Floorbeam · corrodedFLOORBEAM STA 947 LBL 6 CORRODED. REMOVED CORROSION, FABRICATED, TREATED, PRIMED, TOP COATED AND INSTALLED FLOORBEAM REPAIR STRAP IAW ASA EA 900 52EA 01225.SDR ASAA0995447Floorbeam · corrodedFLOORBEAM AT STA 947 RBL 12 IS CORRODED. REMOVED DAMAGED AREA, FABBED REPAIR PARTS AND INSTALLED REPAIR IAW ASA EA 900 52EA 01225.SDR CALA2009041600203Floorbeam · corrodedCABIN FLOORBEAM STA 355 RBL 10 HAS CORROSION. FABRICATED AND INSTALLED FLOORBEAM REPAIR REF SRM 53-00-51 REF REPAIR NR 3 AND SHIMMED G1B MOUNT SUPPORT REF ECRA 5321-01629.SDR 2009F00035Floorbeam · corrodedDURING AV11 CHECK B18601, CORROSION WAS FOUND ON FLOORBEAM AT STA 986.5 LBL 22.5 AND RBL 23 ABOUT 0.4 INCH X 0.4 INCH X 0.050 INCH. THIS IS A CPCP LEVEL 2 ITEM. REPAIRED THE CORRODED AREAS IAW SRM 53-00-51.SDR 2009FA0000428Floorbeam · corrodedDURING AV11 CHECK , CORROSION WAS FOUND ON FLOORBEAM AT STA 986.5 LBL 22.5, RBL 23 ABOUT 0.4" X 0.4" X 0.050". THIS IS A CPCP LEVEL 2 ITEM. REPAIRED THE CORRODED AREAS IAW SRM 53-00-51.SDR USAA2009052191251Floorbeam · corrodedMIA - C1 - MAJOR REPAIR - NR 6011136 - CORROSION ON FLOOR SUPPORT BEAM AT FR66 BETWEEN LBL30 TO LBL36. REPLACED FLOOR SUPPORT BEAM AT FR66 BETWEEN LBL30 TO LBL36 IAW A320 SRM 51-42-11.SDR IPXA09555722Floorbeam · corrodedINSPECTION TYPE:C4 MAIN CABIN 44 SECTION, FLOORBEAM AT STA 1200 BETWEEN LBL 0 AND 24.75, 4EA CORRODED NUT PLATES. FLOORBEAM WAS REPAIRED PER ATS ENGINEERING REPAIR 09-2385 DATED 30 APRIL 09.SDR ASOA200900447Floorbeam · corrodedFLT DECK FLOORBEAM SHOWS SIGNS OF CORROSION AT FS 280 BETWEEN RBL 9.0 AND LBL 9.0. REMOVED FLT DECK FLOORBEAM IAW SRM 51-42-06, 51-42-21. LOCATED, DEBURR, ALODINE, NEW SERVICEABLE FLOORBEAM IAW SRM 51-42-06, 51-42-21. INSTALLED NEW SERVICEABLE FLOORBEAM IAWSDR ASOA200900445Floorbeam · crackedFLOOR SUPPORT CRACKED AND CORRODED AT LBL 12.0 AND RBL 12.0. REMOVED LEFT AND RIGHT CROSSBEAMS IAW SRM 51-42-06 51-42-21. CUT NEW CROSSBEAM, LOCATED IAW REO 670-53-11-047.SDR ASOA200900429Support Angle · crackedFLOORBEAM SUPPORT ANGLE AT O/B SIDE OF RBL 9 AT FS 280 IS CRACKED. REMOVED FLOORBEAM ANGLE IAW SRM 51-42-21. FABRICATED ANGLE & INSTALLED IAW SRM 51-42-21.SDR ASOA200900425Floorbeam · crackedRT SIDE FS 484 ANGLE BETWEEN RBL 9 AND RBL 18 IS CRACKED AT INBD AND OTBD SIDE. REPAIRED ANGLE AT FS 484 IAW REO 601R-53-41-059 & ECTC 601R-53-41-059.SDR ASOA200900424Floorbeam · corrodedLT SIDE FS 621 FLOOR SUPPORT ANGLE HAS CORROSION AROUND SCREW HOLES UNDER PNLS 281LLF AND 281JLF.SDR SWAA092413Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, BL 0. REPAIRED BEAM PER SWA EA.SDR ASAA0995114Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER CHORD BS 986 RBL 17 WL 208. REMOVED AND INSTALLED FABRICATED FLOORBEAM UPPER CHORD PER SRM 53-70-51.SDR ASOA200900421Floorbeam · corrodedCARGO FLOORBEAM CAP LBL27 FS 559+112 TO FS 621 HAS CORROSION AT NUTPLATES. BLENDED DAMAGE AT FLOOR BEAM CAP, FOUND TO BE OUT OF LIMITS IAW SRM 53-00-00 FIG 101. REMOVED SEAT TRACK. IAW SRM 51-42-06, 51-42-21. CUT AND REMOVED FLOORBEAM CAP IAW SRM 53-00-43 FSDR SWAA092355Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CRACKED AT BS 685, LBL 24. REPAIRED BEAM PER SRM.SDR SWAA092336Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM T-CAP CRACKED AT BS 540, RBL 3. REMOVED AND REPLACED CHANNEL PER SRM.SDR SWAA092313Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 667 AT LOWER CHORD. REPAIRED BEAM PER SWA EA.SDR AALA20090414TUL06Floorbeam · corrodedCORROSION ON CABIN FLOORBEAM AT STATION 947 RIGHT BODY LINE 30. REPAIRED WITH L-ANGLE DOUBLER PER AARD 53-00-00-07.SDR AALA20090414TUL04Floorbeam · corrodedCORROSION ON FLOORBEAM SUPPORT BETWEEN STATION 954 AND 964 RIGHT BODY LINE 25. INSTALLED NEW SUPPORT PER SRM 51-10-2-OG.SDR MZZA2009041000048Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM BL0, STA 270. REPAIR CARRIED OUT IAW EC/RA 5311-01445, REV A.SDR ASAA0945319Floorbeam · corrodedLT AFT WEB OF STA 986 FLOORBEAM LBL 32 CORRODED. REMOVED CORRODED WEB, FABRICATED, TREATED, LOCATED, PRIMED, TOP COATED AND INSTALLED NEW WEB IAW B737 400 SRM 51 40 02.SDR ASAA0945318Floorbeam · corrodedLT AFT WEB OF STA 986 FLOORBEAM LBL 32 CORRODED. REMOVED CORRODED WEB, FABRICATED, TREATED, LOCATED, PRIMED, TOP COATED AND INSTALLED NEW WEB IAW B737 400 SRM 51 40 02.SDR IPXA09555592Floorbeam · corrodedINSPECTION TYPE:C2 CORROSION ON LONGITUDINAL BEAM BS 1012, LBL26 WL208 REPAIRED PER ER 09-2275.SDR IPXA09555591Floorbeam · corrodedINSPECTION TYPE:C2 CORROSION AROUND SCREW HOLE AT BS 1055 LBL10-15, WL208 ON PANEL SUPPORT. REPLACED PANEL SUPPORT TEE IAW SRM 53-00-51-1A, SRM51-40-05-0G.SDR IPXA09555590Floorbeam · corrodedINSPECTION TYPE:C2, CORROSION AROUND SCREW HOLE AT BS 1048, LBL45, WL208 ON LONGITUDINAL BEAM. BEAM SECTION WAS REPLACED PER SRM 51-40-02.SDR A6WA200940198Floorbeam · damagedTOOL DAMAGE ON FLOORBEAM AT FS 484, RBL 36.00, WL 72.00 AND INTERCOSTAL AT FS 484.00 BTW RBL 36 AND RBL 45, WL 72.00. FLOORBEAM AT FS 484.00, RBL 36.00, WL 72 AND INTERCOSTAL FS 484.00, RBL 36-45 WL 72 REPAIRED IAW REO 601R-53-41-916. (K)SDR COMA2009041350113Floorbeam · corrodedFLOORBEAM WEB AT FS 280 BETWEEN LBL 9 AND RBL 9 HAS CORROSION THAT IS OUT OF LIMITS. REMOVED DAMAGE AND INSTALLED A SERVICEABLE REPAIR TO FS 280 FLOORBEAM WEB PER COMAIR EA 10-5310-02557.SDR UHLA2009040700162Floorbeam · corrodedLT FLOORBEAM BETWEEN FR85-89 LEVEL 2 CORROSION. REMOVED AND REPLACED IAW SRM 51-41-01 AND 51-43-01.SDR SWIA200922030Floorbeam · crackedFS 280 CRACKED AND CORRODED. (C CHECK) REPAIRED PER SRM.SDR A6WA200940184Floorbeam · crackedLT PILOT - BULKHEAD FLOOR SUPPORT AT FS 280, LBL 9.0 FOUND CRACKED. REPAIR TO LT PILOT BULKHEAD FLOOR SUPPORT AT FS 280.00 LBL 9.0 CARRIED OUT IAW REO 601R-53-11-171. (K)SDR USAA2009051591182Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - NR 6191067 - GALVANIC CORROSION ON FLOORBEAM ASSEMBLY BETWEEN FR65 TO FR67, Y920. REPLACED FLOORBEAM ASSEMBLY BETWEEN FR65 TO FR67, Y920 IAW A320 SRM 51-72-11.SDR IPXA09M55670Floorbeam · dentedINSPECTION TYPE:1C TRANSFERRED FROM DMI-LOG D-385057: MAIN DECK FLOORBEAM LOWER FLANGE DENT FS 939. REMOVED DOUBLER, FABRICATED AND INSTALLED REPAIR FILLER, AND ANGLE IAW IPXA EO MD11-5310-33246-A.SDR SIMA200909804Floorbeam · corrodedDURING A MBV INSPECTION THE RIGHT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 23. REMOVED CORROSION BY BLENDING AND PERFORMED NDT INSP CLEANED, ALODINED AND PRIMED THE REWORKED AREA. FILLED IN BLENDED AREA. FABRICATED A DOUBLER. REPAIR DONE IAW SRM 53-21-1SDR SWAA092257Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM OVER CENTER WING BOX UPPER CHORD CRACKED AT BS 665, RBL 1, WL 208. REPAIRED BEAM PER SI.SDR SWAA092256Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM OVER CENTER WING BOX UPPER CHORD CRACKED AT BS 660, BBL 0, WL 208. REPAIRED BEAM PER SI.SDR A6WA200940189Floorbeam · crackedMWC 132400-69- UPPER ANGLE ALONG CROSSBEAM AT FS 280.00, LBL 10.00, WL 72 IS CRACKED. UPPER ANGLE ALONG CROSSBEAM AT FS 280.00 LBL 10.00, WL 72.00 REPAIRED IAW REO 601R-53-11-138. (K)SDR FDEA200904051183Floorbeam · corrodedFLOORBEAM HAS CORROSION AT BS 340 RBL 48 UNDER UPPER TEE. REMOVED CORROSION, FOUND OUT OF LIMITS IAW SRM 53-00-51 FIG 101. REMOVED DAMAGED AREA. REPAIRED IAW SRM 53-00-51 FIG 201 REPAIR NR 3. CLASSIFIED AS CATEGORY "A" MAJOR REPAIR.SDR MZZA2009040600041Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM STA BS 344, RBL5. REPAIR CARRIED OUT IAW EC/RA 5321-01624.SDR SWAA092184Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 616, LBL 45. REPAIRED BEAM PER ER.SDR SWAA092163Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 987, BETWEEN RBL 42 TO RBL 46. REPAIRED BEAM PER ER.SDR SWAA092158Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 670, RBL 24. REPAIRED BEAM PER ER.SDR SWAA092157Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 45. REPAIRED BEAM PER ER.SDR ASAA0945385Floorbeam · corrodedAFT CABIN FLOORBEAM CORRODED STA 986 RBL 42 44. CUT OUT DAMAGED SECTION, FABRICATED, LOCATED, DRILLED, TREATED, PRIMED AND INSTALLED FLOOR BEAM REPAIR IAW EA 400 53EA 01199.SDR ASAA0945384Floorbeam · corrodedAFT CABIN FLOORBEAM CORRODED STA 986 RBL 42 44. CUT OUT DAMAGED SECTION, FABRICATED, LOCATED, DRILLED, TREATED, PRIMED AND INSTALLED FRAME REPAIR IAW EA 400 53EA 01199.SDR AALA20090423TUL35Floorbeam · crackedFLOORBOARD SUPPORT CRACKED AT STATION 926. REMOVED AND REPLACED SUPPORT PER SRM 51-01.
Back to JASC 5315