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 MALA070064Seat Track · corrodedSEAT TRACK AT BL 0.0 AND STA 298 IS CORRODED OUT OF ALLOWABLE LIMITS. INSTALLED REPAIR DOUBLER IAW MESABA EO S53342. REFERENCE EAMS WORK ORDER 216422 TASK 1511.SDR TRAX200700684Seat Track · corrodedSEAT TRACK ON FLOOR UNDER OVERHEAD BIN 11CD SHOWS SIGNS OF CORROSION. [07-23-07] REPAIRED IAW; 53-21-49, 51-12-00, AND 51-21-06.SDR TRAX200700683Seat Track · corrodedSEAT TRACK ON FLOOR UNDER OVERHEAD BIN 1 AB SHOWS SIGNS OF CORROSION TO FWD SECTION OF TRACK. [SUP 05-24-07] REMOVED AND REPLACED SEAT TRACK P/N 601R-31032-15 IAW CRJ 200 AMM 53-01-11.SDR ASAA0791685Cargo Track · corrodedAFT CARGO PIT TIE DOWN TRACK CORRODED. REPAIRED IAW SRM 53-00-53.SDR ASAA0791682Cargo Track · corrodedFWD CARGO PIT CORROSION ON RIGHT CARGO TRACK. REPAIRED IAW SRM 53-00-53.SDR ASAA0791681Cargo Track · corrodedAFT CARGO PIT TIE DOWN TRACK CORRODED. REPAIRED IAW SRM 53-00-53.SDR ASAA0791680Cargo Track · corrodedAFT CARGO PIT TIE DOWN TRACK CORRODED. REPAIRED IAW SRM 53-00-53.SDR ASAA0791666Splice · corrodedAFT CARGO TIE DOWN SPLICE CORRODED. REPAIRED IAW SRM 51-40-05.SDR ASAA0791659Splice · corrodedAFT CARGO PIT TIE DOWN SPLICE CORRODED. REPAIRED IAW SRM 51-40-05.SDR 07FDEA01839Seat Track · corrodedIN THE AFT PIT, THE SEAT TRACKS AT ABOUT BS 1787 TO BS 1981, RBL 20R AND LBL 20L BS 1841 LBL 59L HAVE DEBRIS, LIGHT CORROSION AND MINOR SCRATCHES. REMOVED, FABRICATED, AND INSTALLED TRACKS IAW DC/MD10 SRM 53-70-00 VOL I FIG 1 SHT 1- 4, AND DAC DRAWING AGA 385SDR 07FDEA01806Seat Track · corroded6 AREAS OF CORROSION EXIST AT MDCC SEAT TRACK L-3 BETWEEN FRAMES 74 THRU 79 EACH DEFECTED AREA MEASURE 1.5 SQ INCHES CORROSION REMOVED IAW A310/200 SRM 51-74-10 ONE SPOT FOUND OUT OF LIMITS IAW A310/200 SRM 53-10-16 DAMAGED AREA TRIMMED OUT IAW SRM 53-10-16. SDR 07FDEA01799Seat Track · wornDUMMY TRACK IN FWD PIT FR 38.2 TO FR 40 TH NR 5 WORN .040 REMOVED AND REPLACED 2 FLOOR BOARDS IAW A310/200 AMM53-10-25-4. REMOVED AND REINSTALLED 1 DUMMY TRACK SECTION AND ATTACHING PARTS IAW A310 SRM 51-40-21. REPAIRED HOLE IN DUMMY SEAT TRACK IAW A310/200 SDR 07FDEA01798Seat Track · corroded3 AREAS OF CORROSION EXIST AT MDCC SEAT TRACK NR 1 DEFECTED AREA MEASURES 7.5 SQ IN FROM FRAMES 76 THRU 79. REMOVED CORROSION 3 AREAS A, B, C, IAW A310/200 SRM51-74-10 MEASURED MATERIAL LOSS .075 AT AREA A FR-76 MATERIAL LOSS .009 AT AREA B FR77-78 MATERIAL SDR 07FDEA01789Seat Track · corroded2 AREAS CORROSION EXIST AT MDCC SEAT TRACK L-4 BETWEEN FRAMES 2/32 AND FRAME 33, DEFECTED AREA MEASURE 1.5 SQ INCHES. REMOVED CORROSION IAW A310 SRM 51-74-10 MATERIAL LOSS IN LIMITS IAW A310 SRM 53-10-1. SEAT TRACK REMOVED AND REPLACED IAW A310 SRM 51-72-10.SDR 07FDEA01788Seat Track · corroded2 CORROSION EXIST AT MDCC SEAT TRACK L-4 BETWEEN FRAMES 2/32 AND FRAME 33 DEFECTED AREA MEASURE 1.5 SQ INCHES. REMOVED CORROSION IAW A310 SRM 51-74-10 MATERIAL LOSS IN LIMITS IAW A310 SRM 53-10-16, SEAT TRACK REMOVED AND REPLACED IAW A310 SRM 51-72-10.SDR 07FDEA01787Seat Track · corrodedMDCC HAS 2 AREAS OF CORROSION ON SEAT TRACK L-4 FRAME 34 AFFECTED AREA MEASURES 2 SQ INCHES. REMOVED CORROSION IAW A310 SRM 51-74-10 OUT OF LIMITS IAW A310 SRM53-10-16. REMOVED AND REPLACED SEAT TRACK L-4 IAW A310 SRM 51-72-10.SDR 07FDEA01785Seat Track · corroded2 AREAS OF CORROSION EXIST AT MDCC SEAT TRACK L-4 FRAME 37 DEFECTED AREA MEASURES 2 SQ INCHES. REMOVED CORROSION IAW A310 SRM51-74-10 OUT OF LIMITS IAW A310 SRM53-10-16. REPLACED SEAT TRACK IAW A310 SRM51-72-10.SDR HNAA0700109Seat Track · corrodedSTA 530 FROM I/B SEAT RAIL TO O/B SEAT RAIL WEB UNDER FLOOR SHOWS SIGNS OF CORROSION AND FASTENERS CORRODED. REMOVED CORRODED FASTENERS, REMOVED LIGHT CORROSION, ALODINE AND PRIMED IAW 51-20-11, SRM 51-20-16, REINSTALLED FASTENERS.SDR HNAA0700108Seat Track · corrodedLEFT HAND INBOARD SEAT RAIL AT STA 510-530 SHOWS SIGN OF CORROSION AROUND FASTENERS AND SPLICE PLATES. REMOVED FASTENERS, REMOVED LIGHT CORROSION, ALODINE AND PRIMED IAW SRM 51-20-11, SRM 51-20-16. REINSTALLED FASTENERS.SDR SIMA200714028Seat Track · corrodedLEFT SEAT TRACK CORRODED BETWEEN FRAMES 18 AND 23. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06 AND AMERICAN EAGLE ENGINEERING TECHNICAL NOTICE EM-53-110R2. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200714024Seat Track · corrodedLEFT SEAT TRACK CORRODED BETWEEN FRAMES 23 AND 36. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200714026Seat Track · corrodedRIGHT SEAT TRACK CORRODED BETWEEN FRAMES 47 AND 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06 AND AMERICAN EAGLE ENGINEERING TECHNICAL NOTICE EM-53-110R2. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200714025Seat Track · corrodedLEFT SEAT TRACK CORRODED BETWEEN FRAMES 36 AND 47. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200714027Seat Track · corrodedRIGHT SEAT TRACK CORRODED BETWEEN FRAMES 36 AND 47. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06 AND AMERICAN EAGLE ENGINEERING TECHNICAL NOTICE EM-53-110R2. RETURNED AIRCRAFT TO SERVICESDR UPS07649969Seat Track · corrodedINSPECTION TYPE:2C SEAT TRACK CORRODED. REPAIRED IAW SRM 53-00-52-2R REPAIR 9.SDR UPS07649916Seat Track · corrodedINSPECTION TYPE:2C SEAT TRACK CORRODED. REPAIRED IAW SRM 53-00-52-2R REPAIR 9.SDR UPS07649915Seat Track · corrodedINSPECTION TYPE:2C SEAT TRACK CORRODED. REPAIRED IAW SRM 53-00-52-2R REPAIR 9.SDR QXEA200700801Seat Track · corrodedC4 PDX - CORROSION IN CENTER CHANNEL OF CENTER SEAT TRACK NR 7 AT STATION 416.0. REPAIRED IAW RD8/4-53-884 AND RD8/4-53-1913.SDR CPCP20070046Seat Track · corrodedRT SEAT TRACK BETWEEN FRAME 39 AND FRAME 40 IS CORRODED. RT SEAT TRACK BETWEEN FRAME 39 AND FRAME 40 REPLACED AS PER SRM 51-25-04.SDR CPCP20070045Seat Track · corrodedRT SEAT TRACK BETWEEN FRAME 36 AND FRAME 39 IS CORRODED. RT SEAT TRACK BETWEEN FRAME 36 AND FRAME 39 REPLACED AS PER SRM 51-25-04.SDR CPCP20070044Seat Track · corrodedLT SEAT TRACK BETWEEN FRAME 39 AND FRAME 41 IS CORRODED. LT SEAT TRACK BETWEEN FRAME 39 AND FRAME 41 REPLACED AS PER SRM 51-25-04.SDR CPCP20070043Seat Track · corrodedLT SEAT TRACK BETWEEN FRAME 36 AND FRAME 39 IS CORRODED. LT SEAT TRACK BETWEEN FRAME 39 AND FRAME 39 REPLACED AS PER SRM 51-25-04SDR QXEA200700838Seat Track · corrodedC4 PDX - PITTING AT RIGHT CENTER SEAT TRACK NR 16 AT STATION 780. REPAIRED IAW RD8/4-53-884, AND SRM 51-40-07, 51-21-10.SDR QXEA200700802Seat Track · corrodedC4 PDX - PITTING AT LEFT CENTER SEAT TRACK NR 9 AT STATION 780.0. REPAIRED IAW SRM 51-42-05, 51-21-10, 51-42-05, AND 51-40-15.SDR QXEA200700834Seat Track · corrodedC4 PDX - SURFACE AND PITTING CORROSION ON FLANGES AND UPPER LIP AND INNER CHANNEL OF RIGHT CENTER SEAT TRACK NR 11 FROM STATION 12.0 TO 70.0. REPAIRED IAW SRM 51-40-07, 51-42-05, 51-40-10, AND RD8/4-53-884.SDR QXEA200700835Seat Track · corrodedC4 PDX - PITTING CORROSION ON LEFT CENTER SEAT TRACK UPPER FLANGE FROM STATION 30.0 TO 56.0. REPAIRED IAW RD8/4-53-884, AND SRM 51-42-05, 51-25-90, 51-42-00, 51-40-15.SDR 07FDEA01756Seat Track · wornMAIN DECK SEAT TRACK SCALLOP WORN STA 1621 RBL 47 REMOVED FLOOR BOARDS FROM STA 1561-1741. BROKEN SCALLOP FOUND TO BE OUT OF LIMITS IAW DC10 SRM 53-70-00 VOL I FIG 5. REMOVED SEAT TRACK FROM STA 1551-1671 RBL 47 IN REF WITH DC10 SRM 53-70-00, VOL I FIG 1. SDR 07FDEA01755Seat Track · corrodedCABIN SEAT TRACK HOLE AREAS AT LBL 76 FS 675-735 HAVE CORROSION REMOVED CORROSION IAW DC10-SRM VOL II 51-21-01 PG 28 ORIG THICKNESS .080 REMOVED .039 FOUND TO BE OUT OF LIMITS IAW DC10 SRM VOL I 53-70-00 FIG 5. REMOVED AND REPLACED SEAT TRACK IAW DC10 SRM 53-SDR 07FDEA01754Seat Track · gougedMAIN DECK LT SIDE SEAT TRACK HAS GOUGE AT STA 943 LBL 27 REMOVED CORROSION IN REF TO DC10/MD10 SRM 51-21-01 VOL II, FOUND TO BE OUT OF LIMITS IAW DC10/MD10 SRM 53-70-00 VOL 1 FIG 5. REMOVED SEAT TRACK AND SPLICE IAW DC10/ MD 10 SRM 51-31-01 VOL II PG 1 MAT SDR 07FDEA01753Seat Track · wornMAIN DECK SEAT TRACK SCALLOP WORN STA 1300 RBL 27 BLENDED AND FOUND TO BE OUT OF LIMITS PER MD10/DC10 SRM 53-70-00 VOL I PG 21. REMOVED SEAT TRACK SECTION RBL 27 STA 1248 TO STA 1351 PER MD10/DC10 SRM 53-70-00 VOL I PG 21. SEAT TRACK MATERIAL IS 4929150 PESDR 07FDEA01752Seat Track · crackedMAIN DECK LT SIDE SEAT TRACK IS CRACKED AT STA 1220 LBL 27 REMOVED SEAT TRACK FROM STA 1129 /1229 LBL 27 IAW DC10-SRM 51-31-01 VOL II MAT ID FOR SEAT TRACK 4929147 IAW DC10 SRM 53-42-01 VOL III PAGE 7 MATERIAL ID FOR SPLICE HAT AND SPLICE PLATE 4932154 AND 707SDR 07FDEA01751Seat Track · corrodedMAIN DECK LT SIDE SEAT TRACK HAS CORROSION AT STA 1204 LBL 27. BLENDED AREA AND FOUND OUT OF LIMITS IAW DC10 SRM 53-70-00 FIG 5 VOL I. REMOVED SEAT TRACK FROM STA 1049/1129 LBL 27 IAW DC10 SRM 53-70-00 FIG I VOL III, MAT ID FOR SEAT TRACK 4929147 IAW DC10 SRSDR 07FDEA01750Seat Track · corrodedMAIN DECK LT SIDE SEAT TRACK HAS CORROSION AT STA 935 LBL 27. WORK ACCOMPLISHED IN CONJUNCTION WITH NON ROUTINE. SEAT TRACK FOUND TO BE OUT OF LIMITS IAW DC10-MD10 SRM 53-70-00 VOL I FIG 5 FROM STA 905 TO STA 1005. CLASSIFIED AS MAJOR, REPLACED SEAT TRACK ASDR 07FDEA01749Seat Track · wornMAIN DECK LEFT SIDE SEAT TRACK SCALLOP WORN AT STA 1139 LBL8. REMOVED, FABRICATED AND INSTALLED SEAT TRACK SECTION IAW DC/MD10 SRM 53-70-00 VOL I FIG1 SHT 1, 53-70-00 VOL 1 FIG 5 SHT 1 AND 51-21-01 VOL II PAGE 21, 25.SDR 07FDEA01748Seat Track · wornFOUND MAIN DECK LEFT SIDE SEAT TRACK SCALLOP WORN AT STA 1265 LBL 8. REMOVED, FABRICATED, AND INSTALLED SEAT TRACK SECTION IAW DC/MD10 SRM 53-70-00 VOL I FIG 5 SHT 1 AND 53-42-01 VOL III PAGE 5.SDR 07FDEA01747Seat Track · wornFOUND MAIN DECK SEAT TRACK SCALLOP WORN STA 1777 RBL 27. REMOVED, FABRICATED, AND INSTALLED SEAT TRACK SECTION DC/MD10 SRM 53-42-01 VOL III FIG 5 AND 53-70-00 VOL I FIG 1 SHT 1 AND 51-21-01 VOL II PAGE 21, 25.SDR 07FDEA01746Seat Track · corrodedFOUND CORROSION ON SEAT TRACK FROM STA 695 TO 735 LBL28. REMOVED, FABRICATED, AND INSTALLED SEAT TRACK SECTION IAW DC/MD10 SRM 53-70-00 VOL I FIG 1 SHT 1 AND 53-70-00 VOL1 FIG 5 SHT 2 AND 51-21-01 VOL II.SDR 07FDEA01745Seat Track · corrodedFOUND CORROSION ON SEAT TRACK AT STA 605 LBL 28. REMOVED, FABRICATED AND INSTALLED SEAT TRACK SECTION IAW DC/MD10 SRM 53-70-00 VOL I FIG 1 SHT 1 AND 53-70-00 VOL I FIG 5, SHT 2 AND 51-21-01 VOL II PAGE 21.SDR 07FDEA01744Seat Track · wornMAIN DECK SEAT TRACK SCALLOP WORN STA 1356 RBL47 REMOVED, FABRICATED AND INSTALLED SEAT TRACK SPLICE PLATE AND HAT SECTION IAW DC/MD10 SRM 51-33-01 VOL II PAGE 1-30 AND 53-70-00 VOL I PAGE 3-6.SDR 07FDEA01738Seat Track · corroded6 AREAS OF CORROSION EXIST AT MDCC SEAT TRACK NR 1 BETWEEN FRAMES 61 THRU 71/72 EACH AREA MEASURES 1.25 SQ INCHES. REMOVED CORROSION ON SEAT TRACK IAW A310-200 SRM 51-74-10 3 AREAS FOUND TO BE OUT OF LIMITS IAW A310-200 SRM 53-10-16 PB 101. ALODINED, PRIMED,
Back to JASC 5347