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 HALA0700364Seat Track · corrodedSECTION 43 SEAT TRACK CORROSION RBL 88.50 STN 592 CORROSION BEYOND SRM LIMITS, REPAIRED BE SEAT TRACK REPLACEMENT. REPLACEMENT P/N 143T5217-11.SDR 07FDEA03307Seat Track · gougedMAIN CARGO COMPT SEAT TRACK HAS GOUGED AREA AT F/S 1039-1059 LBL 107. REMOVED DAMAGED SEAT TRACK AND FABRICATED AND INSTALL NEW SEAT TRACK AND HAT SPLICES.SDR 07FDEA03306Seat Track · gougedMAIN CARGO COMPT SEAT TRACK HAS GOUGED AREA AT F/S 1380-1530 LBL8. REMOVED DAMAGED SEAT TRACK. FABRICATED AND INSTALLED NEW SEAT TRACK AND HAT SPLICES.SDR 07FDEA03300Seat Track · corrodedSEAT TRACK FROM STA 560 - 572, LBL 24 - 25 CORRODED REMOVED CORRODED SEAT TRACK, MANUFACTURED NEW SEAT TRACK AND INSTALLED REF SRM 51-30-02 FOR REMOVAL, AND SRM 5-30-02 FOR INSTALL. SEAT TRACK WAS REPLACED FROM STA 480 TO 689, LBL 24. THIS IS CLASSIFIED AS ASDR TRAX200701279Nut · brokenON RIGHT SEAT TRACK BETWEEN FR 36 AND FR 39 ANCHOR NUT FOUND BROKEN.SDR TRAX200701277Seat Track · corrodedRIGHT SEAT TRACK BETWEEN FR 36-39 CORROSION FOUND. REPAIR ACCOMPLISHED IN ACCORDANCE WITH 51-21-42.SDR TRAX200701276Seat Track · corrodedLEFT SEAT TRACK BETWEEN FR 36-39 CORROSION FOUND. REPAIR ACCOMPLISHED IN ACCORDANCE WITH SRM 51-21-42.SDR TRAX200701275Seat Track · corrodedRIGHT SEAT TRACK BETWEEN FR 39-40 CORROSION FOUND. REPAIR ACCOMPLISHED IN ACCORDANCE WITH SRM 51-21-42.SDR TRAX200701265Seat Track · corrodedCORROSION FOUND ON TOP OF SEAT RAIL BETWEEN FS 364 AND 15.409 + 128 AT RBL 9 AND LBL 9. REMOVED CORROSION ON TOP OF SEAT RAIL BTW FS 364 & 409 + 128 AT RBL 9 & CBL 9 AS PER SRM 51-21-06 ALODINE APPLIED AS PER 51-21-11SDR CALA0700480Seat Track · corrodedINSPECTION FOUND LT I/B SEAT TRACK CORRODED FROM STA 767-907, LBL 25. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52.SDR CALA0700475Seat Track · corrodedINSPECTION FOUND LT O/B SEAT TRACK CORRODED FROM STA 767-907, LBL 45. THE SEAT TRACK WAS REPAIRED IAW SRM 53-00-52, PAGE 201.SDR 07FDEA03241Seat Track · damagedUPPER MAIN DECK FLOOR STRUCTURE, UPPER BEAM CAP HAS MULTIPLE DRILL HOLES UNDER REMOVED SEAT TRACK STA 1166, RBL 25. INSTALLED TWO FREEZE PLUGS IN 1166 FLOORBEAM. PLUG TWO HOLES IN 1166 FLOORBEAM. DRILLED TWO HOLES IN 1166 FLOORBEAM. DRILLED TWO TO BLUE SDR AWXA200701049Seat Track · corrodedSAL - MAJOR REPAIR - C-07 CHECK - NR 5980131, CORROSION ON CABIN PASSENGER SEAT RAIL BEAM, BS 3043/FR 64 - BS 3158+5" / FR 66+3", -Y1292. REPLACED CABIN PASSENGER SEAT RAIL BEAM, BS 3043 / FR 64 - BS 3158+5" / FR 66+3", -Y1292 IAW A320 SRM 51-72-11.SDR 07FDEA03234Seat Track · corrodedMAIN CABIN SEAT TRACK HAS CORROSION AT STA.720 AT LBL 107. REMOVED, FABRICATED AND INSTALLED SPLICED PLATE, SPLICE HAT AND SEAT TRACK IAW MD/DC10 SRM 53-70-00 VOL I PGE 3-4,51-31-01 VOL II PGE 1-10,53-70-00 PG E51 VOL I AND PART MARKED IAW FED EX GMM 7-0-1000SDR 07FDEA03233Seat Track · corrodedMDCC SEAT TRACK 3 RT FR15B-FR19 5 SQ IN CORROSION REF A300-600 AMM 53-10-16-6-02 ZONE 220. REMOVED CORROSION ON SEAT TRACK IAW A300 SRM 51-74-10. FOUND TO BE OUT OF LIMITS IAW A300 SRM 53-10-16 FIG 102. REMOVED AND REPLACED SEAT TRACK IAW A300 SRM 53-40-21.SDR ABXA070288Seat Track · corrodedLITE CORROSION ON UPPER CARGO CENTER SEAT TRACK STA 256 - 294. REPLACED SECTION OF TRACK IAW DC9 51-30-1.SDR USAA070680Seat Track · crackedSTA 727B RBL 24.75 HAS CRACK. INSTALLED FABRICATED REPAIR PARTS PER EA 98824, DEFECT SIZE: 3 INCH.SDR CALA0700460Seat Track · corrodedINSPECTION FOUND MAIN CABIN SEAT TRACK CORRODED AT STA 480-540, RBL 25. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-40-00.SDR 07FDEA03947Seat Track · crackedDUMMY TRACK NR 5 RT AT Y-1959 BETWEEN FR 54 AND FR 54.2 CRACKED AT LOCKS. THE DUMMY TRACK WAS REPLACED IAW SRM 51-72-10.SDR 07FDEA03946Seat Track · crackedDUMMY TRACK NR 1 AT Y0 BETWEEN FR 54 AND FR 54.2 WITH CRACK AT LOCKS. THE PART WAS REPLACED PER SRM 51-72-10.SDR 07FDEA03944Seat Track · crackedCABIN, DUMMY TRACK NR 3 RT (Y-953) CRACKED BETWEEN FR 54 AND FR 54.2. THE PART WAS REPLACED IAW SRM 51-72-10.SDR 07FDEA03943Seat Track · wornCABIN DUMMY TRACK NR 5 LT AT Y1959 BETWEEN FR 54 AND FR 54.2 WITH WEAR OF 1.7MM AT AFT HOLE ATTACHMENT AND WITH CRACKS AT LOCKS. THE AFFECTED PART WAS REPLACED IAW SRM 51-72-10.SDR 07FDEA03141Seat Track · crackedFORWARD CARGO COMPARTMENT, MAIN DECK CARGO SEAT TRACK LBL 47.5 FOUND CRACK. 09-04-07 MAIN DECK CARGO SEAT TRACK FROM STA 625 TO STA 665 LBL 47.5 REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG. 1 VOL.I. REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100.SDR CALA0700458Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1504-1545, RBL 74. THE SEAT TRACK WAS REPLACED IAW SRM 53-00-52, FIGURE 202, REPAIR 3.SDR 07FDEA03131Seat Track · shearedMAIN CABIN RIGHT SEAT TRACK Y-1959 AT FRAME 47 LUGS ARE BROKE OUT.SDR CALA0700457Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1508-1540, LBL 74. THE SEAT TRACK SECTION WAS REPLACED IAW SRM 53-00-52, FIGURE 202, REPAIR 3.SDR AWXA200701038Seat Track · corrodedSAL - MAJOR REPAIR - C-07 CHECK - NR 5980105, CORROSION ON CABIN SEAT TRACK, BS 605/FR 12 - BS 950/FR 24, +Y765. REPLACED CABIN SEAT TRACK, BS 605/FR 12 - BS 950/FR 24, +Y765 IAW A320 SRM 51-72-11.SDR 07FDEA03119Seat Track · corrodedSEAT TRACK CORRODED FROM STA 363-372, LBL 24-25 AREA AT STA 363-372, LBL 24-25 BLENDED AND MAPPED, REF SRM 53-10-1. NDT, FOUND NO DEFECTS. AREA ROTO - PEENED REF REF SOPM 20-10-03. TREATED AND PRIMED REF SRM 51-10-2. REF EA NR 7-5310-113091, CORROSION IS SDR 07FDEA03118Seat Track · corrodedSEAT TRACK CORRODED, STA 386-390, LBL 44-45 AREA AT STA 386-390, LBL 44-45, BLENDED AND MAPPED, REF SRM 53-10-1. NDT, FOUND NO DEFECTS. AREA ROTO PEENED REF SOPM 20-10-03, TREATED AND PRIMED REF SRM 51-10-2 REF EA NR 7-5310-113091, LEVEL 1 CORROSION. THIS ISDR COEA0758821Seat Track · corrodedFOUND DURING HEAVY CHECK. LEVEL 2 CORROSION: CORROSION ON SEVERAL CABIN FLOOR SEAT TRACKS FROM FR 29 TO 44. REMOVED AND REPLACED THE FOLLOWING FLOOR SEAT TRACK SECTIONS. FR 29 TO 36, LT/OB, PN S53678001224. FRAME 39 TO 41 LT AND RT, L PN S53678001214, R PNSDR CPCP20070098Seat Track · corrodedRT SEAT TRACK BETWEEN FRAME 36-39 IS CORRODED. RT SEAT TRACK BETWEEN FRAME 36-39 IS REPLACED BY NEW ONE IAW SRM 51-25-04.SDR CPCP20070097Seat Track · corrodedLT SEAT TRACK BETWEEN FRAME 36 TO 39 IS CORRODED. LT SEAT TRACK BETWEEN FRAME 36-TO 39 IS REPLACED BY NEW ONE IAW SRM 51-25-04.SDR 07FDEA03716Seat Track · corrodedAFT SEAT TRACK AT Y 1390 WITH CORROSION OUT OF SRM ALLOWABLE VALUES NEXT TO FR68. SEAT TRACK REPAIRED IAW SRM 53-16-10, FIG 202.SDR 07FDEA03714Dummy Rail · wornDUMMY TRACK NR 6 RT BETWEEN FR 54 AND 54.2 WITH WEAR OF 1.1MM AT AFT ATTACHMENT HOLES. DUMMY TRACK REPAIRED IAW SRM 53-15-16, FIG 203.SDR AWXA200701067Seat Track · crackedMCN - MAJOR REPAIR - C-11 CHECK - NR 5988776, CRACKED CABIN SEAT TRACK, BS 1600, RBL 45.50, WL 208. REPLACED CABIN SEAT TRACK, BS 1600, RBL 45.50, WL 208 IAW B757-200 SRM 51-40-02.SDR 07FDEA03467Seat Track · corrodedAFT MDCC - SEAT TRACK Y0 WITH CORROSION OUT OF VALUES BETWEEN FR74 AND FR75. SEAT TRACK REPAIRED IN ACCORDANCE WITH SRM SUPP 53-10-16 FIG 202 BETWEEN FR 72 AND FR 73.SDR 07FDEA03093Seat Track · corrodedMAIN CABIN FLOOR SEAT TRACK IS CORRODED AT STA 1090, RBL 24 BLENDED CORROSION. ORIGINAL "T" .090", REMOVED .025" OUT OF LIMITS REF SRM 51-10-1 PG 15. FABRICATED REPLACEMENT SEAT TRACK, FABRICATED SPLICE REPAIR PARTS, TREATED AND PRIMED SEAT TRACK AND REPAIR SDR 07FDEA03092Seat Track · corrodedUPPER MAIN CARGO DECK FLOOR STRUCTURE, SEAT TRACK BETWEEN STA 1130 TO 1166 PLUS 8", RBL 25", HAS CORROSION ON LOWER FAYING SURFACE AT AFT END. FABRICATED NEW SEAT TRACK, REF DWG 53FX 976, SEAT TRACK INSTALLED ON N/R N00816. THIS IS CLASSIFIED AS A MAJOR REPASDR USAA070650Seat Track · corrodedSEAT TRACK AT FR 24 - Y1292 CORRODED. CUT OUT CORRODED PORTION & SPLICED IN NEW PER SRM 53-00-15 FIG 202; CORR TASK JA-900-0900-137, LEVEL 1, DEFECT SIZE: 2 INCH SQ.SDR AWXA200701065Seat Track · corrodedSAL - MAJOR REPAIR - C-07 CHECK - NR 5986012, CORROSION ON CABIN SEAT TRACK, BS 1590/FR 36 - BS 1810/FR 41, -Y765. REPLACED CABIN SEAT TRACK, BS 1590/FR 36 - BS 1810/FR 41, -Y765 IAW A320 SRM 51-72-11.SDR AWXA200701064Seat Track · corrodedSAL - MAJOR REPAIR - C-07 CHECK - NR 5986011, CORROSION ON CABIN SEAT TRACK, BS 1725/FR 39 - BS 1810/FR 41, -Y1292. REPLACED CABIN SEAT TRACK, BS 1590/FR 36 - BS 1810/FR 41, -Y1292 IAW A320 SRM 51-72-11.SDR DHL2007746501Seat Track · corrodedSURFACE CORROSION OVER LENGTH OF SEAT TRACK BS 680-740 RBL24. REMOVED DAMAGED SEAT TRACK SECTION IAW B727 SRM 51-30-2 AT RBL 24.75 FROM STA 680-740 IAW B727 SRM 51-30-2. FABRICATED AND INSTALLED NEW SEAT TRACK SECTION IAW B727 SRM 53-10-5 FIG1 AND 53-10-2 FISDR 07FDEA03053Seat Track · damagedMAIN CABIN RT SEAT TRACK NR Y-1456 AT FRAME C63 LUGS BROKEN OUT. 09-11-07 REMOVED DAMAGED SECTION OF SEAT TRACK IAW A310 SRM 53-10-16. INSTALLED NEW SECTION OF SEAT TRACK AND SPLICE IAW A310 SRM 53-10-16SDR UPS07850590Seat Track · damagedINSPECTION TYPE:C2 COCKPIT 1ST OBSERVERS SEAT TRACK HOLES ARE ELONGATED AT STA -32. REMOVED AND REPLACED 1ST OBSERVERS SEAT TRACK AT STA -32 IAW SRM 51-03-00, AND SRM 51-01-24.SDR KCSA071323Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED AT LBL 12 BETWEEN BS 1680 AND 1720.SDR KCSA071318Seat Track · crackedAFT PIT SEAT TRACK LOWER FLANGE CRACKED AT BS 1490, RBL 46.SDR 07FDEA02982Seat Track · crackedCABIN SEAT TRACK FLANGE IS CRACKED AT STA 449 LBL 28.5 REMOVED SEAT TRACK AT STA 449 LBL 28.5 IAW DC-10 SRM 51-31-01 VOL 2 PG 1-10. FABRICATED IAW DC-10 SRM 53-70-00 PG 51 VOL 1. INSTALLED SEAT TRACK AT STA 449LBL 28.5 IAW DC 10 SRM 51-51-01 VOL 2 PG 1-2 .SDR 07FDEA02980Seat Track · gougedGOUGED CABIN SEAT TRACK SCALLOPS AT STA 879 TO 899 LBL 85 REMOVED AND REPLACED SEAT TRACK IAW DC-10 SRM 53-70-00 VOL 1 PG 51. FABRICATED SPLICE PLATES AND SPLICE HATS IAW DC-10 SRM 53-70-00 PG 4 VOL 1. INSTALLED SEAT TRACK SPLICE PLATE AND SPLICE HAT IAW DC1SDR UPS07M50678Seat Track · scratchedINSPECTION TYPE:C CTR CABIN - SEAT TRACK FROM STA 1273 - STA 1381 -X27.5 SEVERAL SCRATCH MARKS FOUND ON CROWN & CHANNEL SURFACE AS MARKED. CTR CABIN SEAT TRACK FROM STA 1273-1381 X=-27.5 RT SCRATCH MARKS ON CROWN & CHANNEL REMOVED FOUND EXCEEDS LIMIT. SCRATCSDR UPS07M50677Seat Track · scratchedINSPECTION TYPE:C CTR CABIN - SEAT TRACK FROM STA 1273 - STA 1381, +X27.5 SEVERAL SCRATCH MARKS FOUND ON CROWN & CHANNEL SURFACE AS MARKED. CABIN SEAT TRACK STA 1273 - 1381 X=27.5 SCRATCH MARK AT CROWN & CHANNEL SURFACE REMOVED FOUND EXCEEDS LIMIT. SEAT TRAC
Back to JASC 5347