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 WRLA20091101291Seat Track · crackedCRACK - SEAT TRACK STA 755 X=47.5 M/D CARGO FLOOR. REPAIRED THE SEAT TRACK IAW MD11 SRM 53-00-52 REV 41. APPLY PROTECTION COATING IAW MD11 SRM 51-21-01 REV 41.SDR USAA2009110292971Seat Track · corrodedSAL - MAJOR REPAIR - BC7 CHECK - CORROSION ON SEAT TRACK AT FR 47 - FR 52, +Y765. REPAIRED SEAT TRACK AT FR 47 - FR 52, +Y765 IAW A320 SRM 53-41-15.SDR USAA2009110292969Seat Track · corrodedSAL - BC4 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR41 TO FR47, - Y765. REPLACED SEAT TRACK BETWEEN FR41 TO FR47, -Y765 IAW A320 SRM 51-72-11 AND DRAWING D53370500.SDR USAA2009110292968Seat Track · corrodedSAL - BC 4 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR46 TO FR64, Y+765. REPLACED SEAT TRACK BETWEEN FR46 TO FR64, Y+765 IAW A320 SRM 51-72-11.SDR CALA2009110300660Cargo Track · crackedB737-53-3-0714. A/B/B RT TIE DOWN RAIL CRACKED STA 727I. REMOVED AND REPLACED SECTION OF TIE DOWN RAIL FROM STA 727F TO 887 REF SRM 51-40-02.SDR UHLA2009103100146Seat Track · corrodedFWD CABIN RT SEAT TRACK AT FR 14 HAS LEVEL 2 CORROSION. REPAIRED FWD CABIN RT SEAT TRACK AT FR 14-15 IAW ETD2009-170/08886.SDR UHLA2009103100136Seat Track · corrodedFWD CABIN FLOOR RT SEAT TRACK BEAM AT FR 17 HAS LEVEL 2 CORROSION ON TOP. REPAIRED FLOORBEAM AT FR 17 IAW ETD2009-170/08886.SDR ASOA200901220Seat Track · corrodedSEAT TRACK CORRODED JUST FWD OF FS 621 AT LBL 9. REMOVED AND REPLACED SECTION OF SEAT TRACK JUST FWD OF FS 621 AT LBL 9 IAW SRM 51-40-00.SDR FDEA200910313750Seat Track · corrodedMAIN CABIN SEAT TRACK STA 680-780 LBL 45 HAS CORROSION AND GOUGES. REMOVED SEAT TRACK, FABRICATED NEW SEAT TRACK P/N 60-6549/24 IAW SRM 53-30-52. INSTALLED NEW SEAT TRACK STA 680-780, LBL 45, IAW SRM 53-30-52, 51-40-02. MAJOR REPAIR.SDR ASOA200901221Seat Track · corrodedSEAT TRACK CORRODED AT FS 559+95 AT LBL9.SDR NOCA05909Seat Track · corrodedCORROSION IN FWD END OF TIEDOWN TRACK STA 350 RBL 54. REPLACED CHAIR TRACK PER SRM 53-30-52.SDR FDEA200910313751Seat Track · corrodedMAIN CABIN FLOOR STR STA 1620 TO 1640 LBL 24 SEAT TRACK WEB CORRODED. REMOVED CORROSION IAW SRM 51-10-02. AREA FOUND OUT OF LIMITS IAW SRM 53-00-04, FIGURE 101, DETAIL II. REMOVED ANGLE AND WEB IAW SRM 51-40-02. RECEIVED NEW ANGLE AND WEB FROM FAB SHOP TSDR UHLA2009103000134Seat Track · corrodedFWD CABIN FLOOR LT SEAT TRACK BEAM AT FR 19 HAS LEVEL 2 CORROSION ON TOP. CUT OUT DAMAGE AND REPAIRED IAW EMB ETD 2009-170/08886.SDR UHLA2009103000133Seat Track · corrodedFWD CABIN FLOOR SEAT TRACK BEAM LT SIDE AT FR 16 HAS LEVEL 2 CORROSION ON TOP. REPAIRED LT SEAT TRACK BEAM IAW ETD2009-170/08886.SDR ASOA200901213Seat Track · corrodedLT AND RT FWD FLOOR SHORT SEAT TRACKS ARE CORRODED. REMOVED AND INSTALLED NEW LT AND RT FLOOR SHORT SEAT TRACKS AT FS 339.50 AMM 53-01-11.SDR FDEA200910303741Seat Track · gougedSTA 418-440, RBL 24 SEAT TRACK GOUGED REMOVED SEAT TRACK IAW SRM 51-40-00-02, FIG 101, DETAIL VII. RECEIVED NEW SEAT TRACK PN 60-6549/24. INSTALLED NEW SEAT TRACK STA 418 TO 440, RBL 24, IAW SRM 51-40-02. CATEGORY "A", MAJOR REPAIR.SDR ASOA200901202Cargo Track · corrodedCARGO BAY SEAT TRACK SEGMENT RBL 27.0 FS 559+80 TO FS 559+96 CORRODED. REMOVED CORRODED SEAT TRACK IAW SRM 51-41-02. LOCATED, DRILLED, AND COUNTERSUNK NEW SEAT TRACK IAW SRM 51-40-11. INSTALLED NEW SERVICEABLE SEAT TRACK IAW SRM 51-41-02.SDR ASOA200901201Seat Track · damagedREMOVED SEAT TRACK FS 559+80 TO FS 559+96 LBL 27 SRM 51-41-02. LOCATED, DRILLED, AND COUNTERSUNK NEW TRACK SEGMENT IAW SRM 51-40-11. INSTALLED NEW TRACK SEGMENTS FS 559+80 TO FS 559+96 LBL 27 IAW SRM 51-41-02.SDR ASOA200901200Seat Track · corrodedCARGO BAY SEAT TRACK SEGMENT LBL 9.0 FS 559+95 TO FS 567.0 CORRODED. REMOVED CORRODED TRACK IAW SRM 51-41-02. LOCATED, DRILLED, AND COUNTERSUNK HOLES IN NEW SEAT TRACK IAW SRM 51-40-11. INSTALLED NEW SERVICEABLE SEAT TRACK IAW SRM 51-41-02.SDR ASOA200901199Seat Track · corrodedCARGO BAY SEAT TRACK SEGMENT RBL 9.0, FS 559+95 TO FS 567.0 IS CORRODED. REMOVED CARGO BAY SEAT TRACK IAW SRM 51-41-02. LOCATED, DRILLED, AND COUNTERSUNK NEW TRACK SEGMENT IAW SRM 51-40-11. INSTALLED NEW TRACK SEGMENT RBL 9 FS 559+96 TO FS 567.0 IAW SRM 51-4SDR ASOA200901197Seat Track · corrodedCARGO BAY SEAT TRACK SEGMENT LBL 9.0 FS 559+84 TO 559+96 IS CORRODED. REMOVED IAW SRM 51-41-02. LOCATED, DRILLED, AND COUNTERSUNK NEW TRACK SEGMENT IAW SRM 51-40-11. INSTALLED NEW TRACK SEGMENTS LBL 9 FS 559+84 TO FS 559+96 IAW SRM 51-41-02.SDR ASOA200901198Seat Track · corrodedCARGO BAY SEAT TRACK SEGMENT RBL 9.0, FS 559+84 TO 559+46 IS CORRODED. REMOVED CORRODED SEAT TRACK IAW SRM 51-41-02. LOCATED AND DRILLED AND COUNTERSUNK NEW SEAT TRACK IAW SRM 51-40-11. INSTALLED NEW SERVICEABLE SEAT TRACK IAW SRM 51-41-02.SDR ASOA200901205Cargo Track · corrodedCARGO SEAT TRACK SEGMENT LBL 9.0, FS 618.0 TO FS 621.0 IS CORRODED. REMOVED CARGO BAY SEAT TRACK SEGMENT LBL 9 FS 618.0 TO FS 621.0 IAW SRM 51-41-02. LOCATED, DRILLED, AND COUNTERSUNK NEW TRACK SEGMENT IAW SRM 51-40-11. INSTALLED NEW CARGO SEAT TRACK SEGMESDR ASOA200901204Seat Track · corrodedCABIN SEAT TRACK FS 559 TO 559+84 RBL 9.0 BADLY CORRODED. REMOVE CABIN SEAT TRACK AND LOCATED AND COUNTERSUNK NEW SERVICEABLE CABIN SEAT TRACK IAW AMM 53-01-11-000-802 AND SRM 51-41-02. INSTALLED NEW SERVICABLE SEAT RAIL IAW AMM 53-01-11-400-802.SDR USAA2009110292986Seat Track · corrodedSAL - BC4 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR35 TO FR36, -Y1292. REPLACED SEAT TRACK BETWEEN FR35 TO FR36, -Y1292 IAW A320 SRM 51-72-11 AND DRAWING D53371034.SDR FDEA200910303737Seat Track · gougedSTA 418-440 RBL 45 SEAT TRACK GOUGED. REMOVED DAMAGED SEAT TRACK IAW SRM 51-40-02. OLD SEAT TRACK WAS FOUND OUT OF LIMITS DUE TO GOUGE BEING MORE THAN 20% OF MATERIAL THICKNESS. LOCATED AND DRILLED NEW SEAT TRACK IAW SRM 51-40-02. TREATED AND PRIMED NEW SESTSDR DL757100304Seat Track · corrodedMAIN CABIN SEAT TRACK LBL-45 HAS CORROSION BETWEEN STA 1320 AND 1540. REMOVED AND INSTALLED NEW SEAT TRACK AT SAA SAT REF NON ROUTINE CARD 144337.SDR FDEA200910293722Seat Track · corrodedMAIN DECK CARGO COMPARTMENT LT SEAT TRACK APPROX STA 1481, X = 75.25 FOUND CORRODED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 1451 TO STA 1531, X = 75.25 AS PER SRM 53- 00-52 FIGURE 201 REPAIR 1 REVISION 41. REPAIR CALSSIFIED AS MAJOR PER GMSDR USAA2009110292982Seat Track · corrodedSAL - MAJOR REPAIR - BC7 CHECK - CORROSION ON SEAT TRACK AT FR 24 - FR 35, -Y1292. REPLACED SEAT TRACK AT FR 24 - FR 35, -Y129 IAW A320 SRM 51-72-11.SDR QXEA2009110200892Seat Track · damagedUPON REMOVAL OF SIDE SEAT TRACK, RAIL CHANNEL DAMAGED AND A GOUGE INTO THE SEAT RAIL MOUNTING EXTRUSION SUPPORT STRUCTURE AT FS 708.00 LT. INFORMED ENGINEERING. BLENDED OUT DAMAGE AND COMPLETED REPAIR IAW REO 670-53-41-088. INSTALLED SEAT TRACK IAW AMM 53-00SDR FDEA200910283717Seat Track · corrodedSEAT TRACK UPPER AND LWR SURFACE CORRODED LBL 24 BS 1570-1640. REMOVED SEAT TRACK PER SRM 51-40-02 ,FABED NEW TRACK, P/N. BAC1520-792 BATCH 1544829 PER SRM 53-60-52 LOCATED END DRILLED AND INSTALLED IAW SRM 51-40-02 AND 51-20-05, THIS IS A MAJOR "A" REAPAIR NSDR ASAA0996882Cargo Track · crackedFOUND CRACK IN CARGO TRACK RADIUS. REMOVED AND REPLACED TRACK SECTION.SDR ASAA0996880Cargo Track · crackedAFT CARGO BAY CARGO TRACK CRACKED IN TWO PLACES. REMOVED AND REPLACED TRACK SECTION.SDR FDEA200910283718Seat Track · corrodedCORROSION SEAT TRACK FLANGE BS360 - BS420, LBL 24. REMOVED DAMAGED SEAT TRACK SECTION FROM BS 344-480 LBL 24, FABRICATED NEW SEAT TRACK SECTION FROM BAC 1520-792 PO NR 9006020 APPROX LENGTH 136" AND INSTALLED NEW SEAT TRACK SECTION USING PREVIOUS GOOD CONDITSDR QXEA2009102900886Seat Track · corrodedDURING INSPECTION FOUND CORROSION ON LT FLOOR SEAT TRACK AT FS 847 TO FS 879.00. REMOVED DAMAGED SECTION OF SEAT TRACK AND INSTALLED NEW TRACK SECTION IAW AMM 53-00-49-000-801-A01, REO 670-53-00-074, AND AMM 53-00-49-400-801-A01.SDR WX0A070456Seat Track · corrodedDURING BOW 1C/2C/S1/S2/S4, SEAT TRACK NR 2 HAS CORROSION STA 1150-1200, NEW SEAT TRACK INSTALLED PER SRM 53-05. ADDRESSED AS REQUIRED.SDR WX0A070454Seat Track · corrodedDURING BOW 1C/2C/S1/S2/S4, NR 2 SEAT TRACK HAS AREAS OF CORROSION. ADDRESSED AS REQUIRED.SDR QXEA2009102900885Seat Track · corrodedDURING INSPECTION FOUND CORROSION ON LT FLOOR SEAT TRACK AT FS 364.00. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01, FOUND OUT OF LIMITS IAW REO 670-53-00-013. REPLACED SECTION OF SEAT TRACK IAW REO 670-53-00-074.SDR QXEA2009102800881Seat Track · corrodedAT 604.5 ON THE RT OUTBOARD SEAT TRACK THERE IS A SMALL AREA OF CORROSION. BLENDED OUT CORROSION, MAX MATERIAL REMOVED .015", BLEND IS WITHIN LIMITS PER RD 8/4-53-884. HFEC IAW NDTM PART 6 51-00-01, NO CRACKS NOTED. ALODINED BLENDED AREA REF RD 8/4-53-884.SDR IPXA09557809Seat Track · damagedINSPECTION TYPE:N/A SEAT TRACK DAMAGED STA 1661 RBL 24.75. REPAIRED SEAT TRACK PER EO B757-5310-35370-A.SDR IPXA09557807Seat Track · damagedINSPECTION TYPE:N/A SEAT TRACK DAMAGE AT STA 1585 RBL 45.5. REPAIRED PER SRM 51-40-02 DWG 146N5220 AND 146N5217.SDR WX0A070450Cargo Track · corrodedDURING BOW 1C/2C/S1/S2/S4, TIEDOWN TRACK IN AFT CARGO FOUND CORRODED BEYOND MM LIMITS, RT SIDE FROM STA 1212 - 1307. ADDRESSED AS REQUIRED.SDR WX0A070449Cargo Track · corrodedDURING BOW 1C/2C/S1/S2/S4, LT AFT TIEDOWN TRACK CORRODED SEVERAL PLACES IN REAR CARGO. ADDRESSED AS REQUIRED.SDR QXEA2009102800883Seat Track · corrodedCORROSION RT AND LT SIDE WALL SEAT TRACKS BEYOND LIMITS (LT AT FS 329 TO FS 573 RT AT FS 379 TO FS 661). REMOVED AND REPLACED TRACKS IAW AMM 53-00-49, AND 53-00-49-400-801-A01.SDR QXEA2009102700880Seat Track · corrodedLT & RT SIDE SEAT TRACKS HAVE MULTIPLE SPOTS OF CORROSION (LT FS 861 TO FS 985 AND RT FS 675 TO FS 713 AND FS 861 TO FS 985) CORROSION IS BEYOND LIMITS. REMOVED AND INSTALLED NEW SEAT TRACKS IAW SRM 51-41-00, 51-42-02 AND AMM 53-00-49-400-801.SDR C77A195606Seat Track · corrodedDURING BASIC CHECK INSP, MX VISIT, CORROSION WAS FOUND ON LT FLOOR TRACK AT FFR 19, PN 170-03264-001. PERMANENT REPAIR WAS ACCOMPLISHED IAW ETD2009-170/08407A AND COMPASS EO E175-53MR-013 REV IR.SDR IPXA09557791Seat Track · corrodedM/D SEAT TRACK AT LBL 45.5 BETWEEN STA 1681.5 AND 1661 HAS CORROSION. REPAIR IAW 757 SRM 53-0052-2R.SDR USAA2009110493025Seat Track · crackedSAL - MAJOR REPAIR - BC4 CHECK - CRACKED SEAT TRACK AT FR 48 - FR 49, +Y1292. REPAIRED SEAT TRACK AT FR 48 - FR 49, +Y1292 IAW A320 SRM 53-41-15.SDR UHLA2009102400108Seat Track · corrodedFWD CABIN LT SEAT TRACK BEAM AT FRAME 16 HAS CORROSION ON TOP. REMOVED AND REPLACED FLOORBEAM FROM FRAME 12 FOR FRAME 20 LT SIDE IAW SRM 51-43-03 AND 51-41-02 AND 51-41-01.SDR UHLA2009102400107Seat Track · corrodedFWD CABIN RT SEAT TRACK BEAM AT FRAME 14 HAS CORROSION ON TOP. REPAIRED IAW EMB ETD2009-170/08613.
Back to JASC 5347