JASC 5347
Service difficulty reports · 66,435
Reports filed under 5347 · Fuselage, Seat/Cargo Attach Fittings, 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 = '5347' 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 = '5347' 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 UPS05444645Seat Track · corrodedINSPECTION TYPE:C M/D- BS 1000-1100 LBL 11 SEAT TRACK SURFACE CORRODED AS MARKED. CORROSION BLEND OUT 0.036 X .875 X 2.25 INCH EXCEED SRM 53-10-01 FIG 1 LIMITS. M/D- BS 1000-1110 AND BS 1110-1150 LBL 11 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 34.SDR UPS05444610Seat Track · corrodedBS 910-940 RBL 11 SEAT TRACK FLANGE CORROSION. CORROSION BLEND OUT 0.022 BY 1.0 BY 4.0 IN. EXCEED SRM 53-10-01 FIG 1 LIMIT. M/D BS 890 - BS 1000 RBL 11 SEAT TRACK. REPAIRED AS PER SRM 53-10-05 FIG 14 WORK DETAIL REF NRC 6392.SDR UPS05444609Seat Track · corrodedBS 900-920 RBL 12 SEAT TRACK FLANGE CORROSION. CORROSION BLEND OUT 0.020 BY 1.0 BY 3.0 IN. EXCEED SRM 53-10-01 FIG 1 LIMIT, M/D BS 890- BS 1000 RBL 11 SEAT TRACK. REPAIRED AS PER SRM 53-10-05 FIG 14 WORK DETAIL REF NRC 6392.SDR UPS05444607Seat Track · corrodedBS 980-1000 RBL 11 INCH SEAT TRACK FLANGE CORROSION. CORROSION BLEND OUT 0.060 BY 0.875 BY 2.0 IN. EXCEED SRM 53-10-01 FIG 1 LIMITS, M/D BS 890 - BS 1000 RBL 11 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 14.SDR UPS05444601Seat Track · corrodedBS 1000-1060 RBL 10 SEAT TRACK FLANGE CORROSION. CORROSION BLEND OUT 0.028 BY 1.0 BY 1.0. EXCEED SRM 53-10-01 FIG 1 LIMIT, M/D BS 1000-1130 RBL 11 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 34.SDR UPS05444586Seat Track · corrodedINSP TYPE: C U/D BS 660-710 RBL 48, SEAT TRACK CROWN HI-LOCK AREA FOUND CORROSION. CORROSION BLENDED OUT 0.045 INCH BY 0.5 INCH BY 2 INCH EXCEED SRM 53-10-01 FIG 1 LIMIT. U/D BS 650 TO 720 RBL 48 INCH TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR ASAA0580269Seat Track · corrodedOKC - DURING C-CHECK, FOUND CABIN SEAT TRACK LBL 44 STATION 1174 IS EXFOLIATED. REMOVED AND REPLACED SEAT TRACK. (M)SDR ABXA050140Seat Track · brokenOUTBOARD SEAT TRACK AT FS 579 LEFT BLOWN AT SPLICE. REMOVED AND REPLACED LEFT OUTBOARD SEAT TRACK FS 579 - 560.SDR USAA050696Seat Track · corrodedPIT - FOUND DUMMY RAIL CORRODED, 3 INCHES BY 10 INCHES AT Y254 BETWEEN C-14 AND C-16. DEFECTIVE PART REPLACED WITH IDENT PART NR. (M)SDR UPS05444603Seat Track · corrodedBS 1140 - 1265 RBL 11 SEAT TRACK FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.052 BY 1.5 BY 1.5 IN. EXCEED SRM 53-10-01 FIG 1 LIMITS, M/D -BS 1130-1265 RBL 11 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 34.SDR UPS05444602Seat Track · corrodedM/D BS 1130-1140 RBL 11 SEAT TRACK FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.063 BY 1.5 BY 2.0 IN. EXCEED SRM 53-10-01 FIG 1 LIMITS. M/D BS 1130 TO 1265 RBL 11 TRACK REPAIRED AS PER SRM 53-10-05 FIG 34.SDR 05FDEA01297Seat Track · corrodedMAIN DECK STATION 839 AND STATION 859 X=-8 SEAT TRACK FOUND CORRODED. TRIMMED OUT AND REPAIRED AS PER SRM 53-70-00SDR ASAA0580258Seat Track · corrodedOKC - DURING C-CHECK, FOUND CABIN SEAT TRACK BL 44 STATION 218-237 IS CORRODED. REMOVED AND REPLACED DAMAGED SECTION OF TRACK. (M)SDR GTIA05152005Seat Track · corrodedFOUND CABIN SEAT TRACK CORRODED. REMOVED FLOOR PANELS. REMOVED DAMAGED SEAT TRACK AND FORWARD AND AFT GIRT MOUNTS. FABRICATED FORWARD AND AFT GIRT MOUNTS. LOCATED AND DRILLED NEW HOLES ON FABRICATED FORWARD AND AFT GIRT MOUNTS. LOCATED AND DRILLED NEW SEASDR 05FDEA01269Seat Track · crackedMAIN DECK, SEAT TRACK LBL 47 CRACKED AT STA 755. CARRIED OUT REPAIR AS PER SRM 53-70-00 VOLUME I FIGURE 1. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100.SDR EIA2005123Seat Track · brokenM/D BS 1883 RBL 11, SEAT TRACK FLANGE FOUND BROKEN. M/D BS 1870 TO BS 1950 RBL 11, SEAT TRACK REPAIRED PER SRM 53-10-05, FIG 14.SDR EIA2005121Seat Track · corrodedM/D BS 996 RBL 33, SEAT TRACK, RT FLANGE FOUND CORROSION. SEAT TRACK AT BS 990 TO BS 1000, RBL 33, SECTIONAL REPLACED PER SRM 53-10-05, FIG 1A.SDR EIA2005120Seat Track · corrodedM/D BS 1000, LBL 33, SEAT TRACK OUTBOARD FLANGE FOUND CORROSION. M/D BS 990 TO BS 1000, LBL 33, SEAT TRACK SECTIONAL REPLACED PER SRM 53-10-05 FIG 1A.SDR EIA2005119Seat Track · corrodedM/D BS 1535 TO BS 1545, LBL 33, SEAT TRACK CROWN FOUND CORROSION. M/D BS 1480 TO BS 1550, SEAT TRACK SECTIONAL REPLACED PER SRM 53-10-05, FIG 1A.SDR EIA2005118Seat Track · unknownM/D BS 610 TO BS 620 LBL 33, SEAT TRACK RT-05, FIG 1A.SDR EIA2005107Cargo Track · corrodedM/D BS 1680-1700 LBL 11 TIE DOWN TRACK FLANGE FOUND CORROSION AS MARKED. M/D BS 1680-1730 LBL 11 TIE DOWN TRACK REPAIRED PER SRM 53-10-05, FIG 14.SDR CALA0500148Seat Track · corrodedINSPECTION FOUND LEFT O/B SEAT TRACK CORRODED AT STA 1183-1227, LBL 35. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-05-00.SDR USAA050648Galley Track · corrodedBFM - C4 - PLATE ASSY, 1 INCH X .5 INCH X .050 INCH, CORROSION; NO LEVEL OR TASK, CABIN FLOOR AFT GALLEY, LT MOUNT PAD AND SUPPORT PLATE ASSY. REMOVED AND REPLACED MOUNT PAD AND SUPPORT PLATE ASSY WITH FAB PART IAW SRM. (K)SDR QXEA200500852Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK HAS PITTING CORROSION ON EXPOSED SURFACES AT X19-X27, X37-X41 AND X67-X71. REPAIRED IAW DHC-8-400 SRM 51-42-05, 51-40-11 AND SRM 51-42-45.SDR QXEA200500851Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK HAS LIGHT CORROSION ON TOP OF SEAT LUG RAILS AT X 0.0 TO X 1.0. REPAIRED IAW DHC-8 400 SRM 51-42-05, 51-40-10 AND SRM 42-42-45.SDR CALA0500146Seat Track · corrodedINSPECTION FOUND LEFT I/B SEAT TRACK CORRODED AT STA 1085, LBL 22. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-05 FIGURE 4F.SDR USAA050600Seat Track · crackedCLT - FOUND SEAT TRACK CRACKED 1 INCH, BS 747 AND STRINGER 26R. SDA COMPLETED REPAIRED PER 737-4 SRM 53-00-53 AND 53-60-53. (M)SDR CALA0500145Seat Track · corrodedINSPECTION FOUND RT O/B SEAT TRACK CORRODED AT STA 200-256, RBL 40. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-05.SDR 05FDEA01226Seat Track · damagedSEAT TRACK BL 0 STA 720F HAS AN EXISTING SPLICE REPAIR AND DOES NOT MEET REQUIREMENTS OF DWG 2902. REMOVED DAMAGED SECTION OF SEAT TRACK AND INSTALLED NEW SECTION OF TRACK WITH REPAIR ANGLES IAW SRM 51-10-5 FIG 1.SDR AWXA200500634Seat Track · corrodedSAL - MAJOR REPAIR - DURING C08 CHECK, GALVANIC CORROSION WAS FOUND ON FLOORBEAM DUMMY RAIL Y920 BETWEEN FS 65 AND FS 67. MAINTENANCE REMOVED DAMAGED DUMMY RAIL Y920 BETWEEN FS 65 AND FS 67; FABRICATED A NEW REPLACEMENT DUMMY RAIL PER DWG D53472040; INSTALLEDSDR AWXA200500620Seat Track · corrodedDURING C08 CHECK, GALVANIC CORROSION WAS FOUND ON SEAT TRACK BEAM Y1292 BETWEEN FS 64 TO FS 67. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK BEAM Y1292 BETWEEN FS 64 TO FS 67; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK BEAM; INSTALLED REPAIR PARSDR AWXA200500554Seat Track · corrodedSAL - MAJOR REPAIR - DURING C08 CHECK GALVANIC CORROSION WAS FOUND ON SEAT TRACK BEAM Y765 AT FR 66. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK BEAM Y765 AT FR 66; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK BEAM; INSTALLED REPAIR PART IAW A320SDR AWXA200500628Seat Track · corrodedDURING C08 CHECK, GALVANIC CORROSION WAS FOUND ON LT OUTBOARD SEAT TRACK BEAM Y1292 AT FS 41 TO FS 47. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK BEAM Y1292 AT FS 41 TO FS 47; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK BEAM; INSTALLED REPAIR PSDR AWXA200500627Seat Track · corrodedDURING C08 CHECK, GALVANIC CORROSION WAS FOUND ON LT OUTBOARD SEAT TRACK BEAM Y1292 AT FS 53. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK BEAM Y1292 AT FS 53; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK BEAM; INSTALLED REPAIR PART IAW A320 SRM 5SDR AWXA200500626Seat Track · corrodedSAL - MAJOR REPAIR - DURING C08 CHECK GALVANIC CORROSION WAS FOUND ON SEAT TRACK BEAM -Y765 AT FR24 TO FR35. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK BEAM -Y765 AT FR24 TO FR35; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK BEAM; INSTALLED REPAISDR AWXA200500625Seat Track · corrodedDURING C08 CHECK, GALVANIC CORROSION WAS FOUND ON LT INBOARD SEAT TRACK BEAM Y765 AT FS 45. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK BEAM Y765 AT FS45; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-42SDR ABXA050117Seat Track · corrodedHEAVILY CORRODED CENTER SEAT TRACK STA 214. CENTER SEAT TRACK REMOVED AND REPLACED ON JC 0281 IAW DC-9 SRM.SDR USAA050656Seat Track · corrodedPIT - FOUND OUTBOARD SEAT TRACK FLOORBEAM CORRODED 1 INCH DIAMETER IN 5 AREAS, OUTBOARD SEAT TRACK, FLOORBEAM AT Y1292L. CORROSION LEVEL 2; TASK JA-220-53500. FOUR AREAS BLENDED, 1 AREA HAD CORROSION CUT OUT AND REPAIR INSTALLED PER SRM 53-11-15. (M)SDR AWXA200500624Seat Track · corrodedSAL - MAJOR REPAIR - DURING C08 CHECK GALVANIC CORROSION WAS FOUND ON RT INBOARD SEAT TRACK BEAM -Y765 AT FS 12 TO FS 24. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK BEAM -Y765 AT FS 12 TO FS 24; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK BEAM;SDR AWXA200500623Seat Track · corrodedDURING C08 CHECK GALVANIC CORROSION WAS FOUND ON RT INBOARD SEAT TRACK BEAM -Y765 AT FS 41 TO FS 47. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK BEAM -Y765 AT FS 41 TO FS 47; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK BEAM; INSTALLED REPAIR PARSDR AWXA200500622Seat Track · corrodedDURING C08 CHECK, GALVANIC CORROSION WAS FOUND ON RT OUTBOARD SEAT TRACK BEAM -Y1292 AT FS 41 TO FS 47. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK BEAM -Y1292 AT FS 41 TO FS 47; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK BEAM; INSTALLED REPAIRSDR AWXA200500621Seat Track · corrodedDURING C08 CHECK, EXFOLIATION CORROSION WAS FOUND ON RT SEAT TRACK BEAM -Y1292 AT FS 12 TO FS 24. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK BEAM -Y1292 AT FS 12 TO FS 24; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK BEAM; INSTALLED REPAIR PART SDR AWXA200500619Seat Track · corrodedDURING C08 CHECK, GALVANIC CORROSION WAS FOUND ON SEAT TRACK BEAM -Y765 BETWEEN FS 36 TO FS 41. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK BEAM -Y765 BETWEEN FS 36 TO FS 41; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK BEAM; INSTALLED REPAIR PARSDR MALA050398Seat Track · corrodedDURING 4K INSPECTION IN BNA, FOUND SEAT TRACK AT BL 0 FROM FS297 TO FS319 IS CORRODED. DAMAGE HAS BEEN REPAIRED AS REQUIRED IAS SRM 53-70-60. REF EAMS WORK ORDER 212113 TASK 1507.SDR MALA050396Seat Track · corrodedSEAT TRACK AT LBL 18.3, FROM FS 297 TO FS 319 IS CORRODED. DAMAGE HAS BEEN REPAIRED AS REQUIRED IAW SRM 53-70-60. REF: EAMS WORK ORDER 212113 TASK 1505.SDR USAA050658Track · corrodedPIT - FOUND TRACK CORRODED .5 INCH AREA, AT FRAME 16 Y503. REPLACED WITH IDENT PART. (M)SDR USAA050646Seat Track · corrodedBFM - C4 - SEAT TRACK, 3 INCHES LONG X .750 INCH WIDE X .058 INCHES DEEP, CORROSION; LEVEL 2; TASK C53-221-02. CABIN SEAT TRACK STA 365.25 TO 440, LBL 45.50. REMOVED AND REPLACED SEAT TRACK IAW SRM. (K)SDR USAA050647Galley Track · corrodedBFM - C4 - GALLEY MOUNT PAD, 1.5 INCH L X .5 INCH W X .035 INCH D. CORROSION; NO LEVEL OR TASK, STA 330, LBL 21. REMOVED AND REPLACED IAW SRM. (K)SDR FFS2005F00003Seat Track · corrodedTHE LT FORWARD SEAT TRACK WAS CORRODED THROUGH THE SIDE OF THE TRACK AND THE TRACK AND THE FLANGE THAT SUPPORTS THE FLOORBOARD. CORROSION WAS PARTICULARLY EVIDENT AT FUSELAGE STA 158.5 - 170.5. THE LOCATION OF THE CORROSION, JUST INSIDE THE AIRSTAIR DOOR, SUSDR USAA050588Seat Track · crackedCLT - FOUND SEAT TRACK CRACKED IN LOWER RADIUS OF SEAT TRACK, STATION 727B, RBL 45.5. SPLICED IN NEW SECTION OF SEAT TRACK. (M)
Back to JASC 5347