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 WRLA2007064Seat Track · crackedDURING 4C+30/60M CHECK, EGAT MECHANIC FOUND MAIN DECK CARGO SEAT TRACK CRACK AT Y:755, X:48, Z:-18. [SUP 05-02-07] REPLACED MAIN DECK CARGO SEAT TRACK PER MD-11 SRM 53-70-00 VOL.1 REV 38 FIG.1.SDR 07FDEA01508Seat Track · damagedCABIN SEAT TRACK CROWN AREA FOUND CHIPPED OFF AT STA 899 X = -47. CABIN SEAT TRACK AT STA 899 X= -47 CARRIED OUT REPAIR AS PER SRM 53-70-00 VOL I FIG 1. REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100.SDR QXEA200700664Seat Track · corrodedC5 PDX - FOUND CABIN SEAT TRACK NR 7 HAS CORROSION AT STATION X221. REPAIRED IAW RD8-53-4698 AND SRM 51-40-11, 51-40-00.SDR QXEA200700661Seat Track · corrodedC5 PDX - FOUND CABIN SEAT TRACK NR 12 HAS CORROSION AT STATION X516. REPAIRED IAW RD8-53-1342.SDR SIMA200710711Seat Track · corrodedRIGHT INBOARD SEAT TRACK BETWEEN FRAME 47 AND 50 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB SRM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200710709Seat Track · corrodedLEFT INBOARD SEAT TRACK BETWEEN FRAMES 18L TO 23L CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200710720Seat Track · corrodedLEFT INBOARD SEAT TRACK BETWEEN FRAME 32 AND 46 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200710719Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAME 32 TO 46. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200710723Seat Track · corrodedLEFT OUTBOARD SEAT TRACK BETWEEN FRAME 47 AND 53 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200710722Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAME 23 TO 32. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200710717Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK BETWEEN FRAME 47 AND 53 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200710716Seat Track · corrodedLEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAME 23 TO 32. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200710714Seat Track · corrodedRIGHT INBOARD SEAT TRACK BETWEEN FRAME 22 AND 46 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200710724Seat Track · corrodedLEFT INBOARD SEAT TRACK BETWEEN FRAME 47 TO 53 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200710725Seat Track · corrodedRIGHT INBOARD SEAT TRACK BETWEEN FRAME 24 TO 32 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200710708Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK BETWEEN FRAME 32 AND FRAME 46. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200710710Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAME 24 TO 32. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR UPS07M49815Seat Track · corrodedINSPECTION TYPE:C CABIN - CORROSION ON SEAT TRACK CROWN AT STA 1351 X=-75.0. SEAT TRACK CORROSION REMOVED FOUND EXCEEDED LIMITS PER SRM 53-70-00 FIG 3 REV 38 VOL 1. SEAT TRACK ATTACHED PARTS STA 1264-1391 X=-75 REMOVED PER SRM 51-31-01 VOL 2 REV 38. CORRODESDR QXEA200700662Seat Track · corrodedC5 PDX - FOUND SEAT TRACK NR 6 HAS CORROSION BETWEEN STATION 543 AND 547. REPAIRED IAW RD8-53-4936 AND SRM 51-40-11.SDR QXEA200700659Seat Track · corrodedC5 PDX - CABIN SEAT TRACK NR 9 HAS CORROSION AT STATION X580 CENTER FLOORBOARD ATTACH NUTPLATE. REPAIRED IAW RD8-53-784 AND SRM 51-40-00, 51-40-11.SDR QXEA200700660Seat Track · damagedC5 PDX - CABIN SEAT TRACK NR 8 HAS MINOR SCRATCHES AT STATIONS X428, X436 - X456, X467 - X487, X501 - X525. REPAIRED IAW RD8-53-1339 AND SRM 51-40-00, 51-40-11.SDR QXEA200700635Seat Track · damagedC5 PDX - CABIN SEAT TRACK NR 1 HAS SCRATCHES AT STATION X434-X456, X379-X387. REPAIRED IAW RD8-53-1342 AND SRM 51-40-11, 51-40-00.SDR QXEA200700634Seat Track · corrodedC5 PDX- NR 10 SEAT TRACK HAS CORROSION AT STATION 310. REPAIRED IAW SRM 51-40-00, 51-40-11, AND RD8-53-1342.SDR WRLA2007062Seat Track · corrodedDURING 4C+30/60M CHECK, MAIN DECK CARGO SEAT TRACK CORROSION AT Y:735, X:-8, Z:-18. [SUP 05-02-07] REPLACED MAIN DECK CARGO SEAT TRACK PER MD-11 SRM 53-70-00 VOL.1 REV 38 FIG 1SDR WRLA2007061Seat Track · wornDURING 4C+30/60M CHECK, MAIN DECK CARGO SEAT TRACK WORN AT Y:630, X:-8, Z:-18. [SUP 05-02-07] REPLACED MAIN DECK CARGO SEAT TRACK PER MD-11 SRM 53-70-00 VOL.1 REV 38 FIG.1.SDR WRLA2007060Seat Track · corrodedDURING 4C+30/60M CHECK, MAIN DECK CARGO SEAT TRACK CORROSION AT Y:627, X:-28, Z:-18. [SUP 05-02-07] REPLACED MAIN DECK CARGO SEAT TRACK PER MD-11 SRM 53-70-00 VOL.1 REV 38 FIG 1.SDR 07FDEA01460Seat Track · corrodedCORROSION ON SEAT TRACK, C15A-C19, Y-953. REPAIR PERFORMED BY REPLACEMENT OF PART IAW. SRM 71-52-10.SDR USAA070270Seat Track · corrodedCORROSION AT 3 PLACES AT LEFT I/B SEAT TRACK FROM FRAME 47-47.2. CUT OFF DAMAGED SECTION, SPLICED IN NEW SECTION PER SRM 53-41-15 FIG 202; CORROSION TASK JA-220-25502, DEFECT SIZE: 1 INCH.SDR ABXA070148Seat Track · corrodedSEAT TRACK CORRODED LOWER FLANGE AND UNDERSIDE OF TRACK AT STA 560 TO 600 LEFT BUTT LINE 12. REMOVED AND REPLACED SEAT TRACK FS 49 L - 606 LEFT BUTT LINE 1L IAW DC9 SRM 53-05.SDR KCSA071138Seat Track · corrodedUPPER DECK SEAT TRACK HAS AREA OF CORROSION AT STA-630 RBL-28 WL-308.SDR 07FDEA01385Seat Track · corrodedUPPER MAIN CARGO COMPARTMENT FOUND SEAT TRACK WITH CORROSION AT STA 1179 X= 8. [SUP 4-20-07] 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 07FDEA01384Seat Track · corrodedCORROSION FOUND ON SEAT TRACK AT STA 1853 - 1887, X= 8.5, DISCOVERED AFTER REMOVAL OF FLOOR PANEL FOR ACCESS. [SUP 4-20-07] 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 07FDEA01383Seat Track · corrodedCORROSION FOUND ON SEAT TRACK AT STA 1871 X = -8.5, DISCOVERED AFTER REMOVAL OF FLOOR PANEL FOR ACCESS. [SUP 4-20-07] 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 UPS07M50156Seat Track · corrodedINSPECTION TYPE:C MID CABIN - CORROSION ON SEAT TRACK CROWN AT STA 909 X=-75.0. CABIN STA 909 X=-75 SEAT TRACK BASE CORROSION REMOVED & REPROTECTED PER SRM 53-70-00 FIG 3 V.I R.39 & SRM 51-21-01 V.II R.39. CABIN STA 909.6 X =-75 SEAT TRACK CROWN CORROSION RESDR UPS07M50154Seat Track · corrodedINSPECTION TYPE:C AFT CABIN - CORROSION ON SEAT TRACK CROWN & FLANGE AT STA 1966 X=107. CURVE SEAT TRACK ATTACHMENT & ATTACHED PARTS AT STA 1831-2007 X=107 LEFT REMOVED PER SRM 51-31-01 V.II R.39. CLEAN UP REWORKED AREA PER SRM 51-21- 01 V.II R.39. NEW SEATSDR UPS07M49814Seat Track · corrodedINSPECTION TYPE:C AFT CABIN CORROSION ON SEAT TRACK CROWN & FLANGE AT STA 1966 X=-107. RIGHT NR 4 PASSENGER DOOR SILL REMOVED. REMOVED SEAT TRACK & ATTACH PARTS STA 1831-2007 RBL 107 PER SRM 51-31-01 VOL 2 REV 38. CORRODED SEAT TRACK TRIMMED OFF. HFEC INSPSDR UPS07M49795Seat Track · corrodedINSPECTION TYPE:C MID CABIN - CORROSION ON SEAT TRACK CROWN & FLANGE AT STA 859 - 899 X= -8.0. SEAT TRACK PARTS REMOVED PER SRM 51-31-01 VOL 2 REV 38. CORRODED SEAT TRACK TRIMMED OFF PER SRM 53-70-00 FIG 1 VOL 1 REV 38. HFEC INSP CUTOUT & FOUND NO CRACK. CSDR UPS07M49794Seat Track · corrodedINSPECTION TYPE:C MID CABIN - CORROSION ON SEAT TRACK CROWN AT STA 859 & STA 891 X=8.0. REMOVED SEAT TRACK PER SRM 51-31-01 VOL 2 REV 28. CORRODED SEAT TRACK TRIMMED OFF PER SRM 53-70-00 FIG 1 VOL 1 REV 38. HFEC INSP CUTOUT & FOUND NO CRACK. CORRODED SEAT SDR 07FDEA01378Seat Track · corrodedUPPER MAIN CARGO COMPARTMENT FOUND SEAT TRACK CORROSION ON STA 1179 TO 1199, X= -8.5. [SUP 4-20-07] 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 WRLA2007063Seat Track · crackedDURING 4C+30/60M CHECK, EGAT MECHANIC FOUND MAIN DECK CARGO SEAT TRACK CRACK AT Y:755, X:28, Z:-18. [SUP 05-02-07] REPLACED MAIN DECK CARGO SEAT TRACK PER MD-11 SRM 53-70-00 VOL.1 REV 38 FIG.1.SDR UIEA200700155Seat Track · corrodedUPPER DECK STATION 685 RBL 27 SEAT TRACK CORRODED AS MARKED. REMOVED CORROSION PER SRM 53-10-05SDR QXEA200700605Seat Track · corrodedC5 PDX - CORROSION ON SEAT TRACK 34 AT STATION X345. REPAIRED IAW RD8-53-1339.SDR QXEA200700606Seat Track · gougedC5 PDX - FOUND SEAT TRACK NR 4 HAS 4 GOUGES AT STATION X377. REPAIRED IAW RD8-53-1339.SDR QXEA200700604Seat Track · corrodedC5 PDX - CORROSION ON SEAT TRACK NR 4 AT STATION X297-X299. REPAIRED IAW RD8-53-1339.SDR DHL2007806537Cargo Track · wornFOUND UPPER CARGO COMPT NR 2 TRACK LUG WORN (STA 280.000 - 300.000). REMOVED WORN SEGMENT OF TRACK NR 2 AND EXISTING SPLICES IAW SRM 53-2-3, SRM 51-3-0, SRM 51-1-21. CLEANED, TREATED AND PRIMED AREA AND EXISTING SPLICES IAW SRM 51-1-8B. INSTALLED NEW TRACK SDR ABXA070139Seat Track · corrodedSEAT TRACK SECTION BUTT LINE 0, STA 570 - 785 CORRODED AT STA 785 - 765, 737, 710 - 699, 680 - 670 AND 636 - 617. REMOVED AND REPLACED SEAT TRACK STA 160 - 784 IAW DC9 SRM 51-30-1 AND 51-10-4.SDR ABXA070138Seat Track · corrodedFOUND SEAT TRACK RIGHT BUTT LINE 44 CORRODED AT STA 718. REMOVED AND REPLACED SEAT TRACK STA 570 TO 748 IAW DC9 SRM 51-30-1. REINSTALLED FLOOR PANELS IAW DC9 SRM 51-30-1.SDR ABXA070137Seat Track · corrodedFOUND SEAT TRACK AT RIGHT BUTT LINE 11 CORRODED ON BOTH SIDES OF SPLICE AT STA 493. REMOVED AND REPLACED SEAT TRACK IAW DC9 SRM 53-05.SDR ABXA070135Seat Track · corrodedUPPER CARGO SEAT TRACK CORRODED AT RIGHT BUTT LINE 9, FS 160. REMOVED AND REPLACED SEAT TRACK IAW DC9 SRM 51-10-3 AND 51-30-1.SDR QXEA200700611Seat Track · corrodedC5 PDX - CABIN SEAT TRACK NR 7 HAS CORROSION AT STATION X218. REPAIRED IAW RD8-53-1339.
Back to JASC 5347