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 QXEA0000801Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK HAS LIGHT SURFACE CORROSION AND SEVERAL GOUGES ON TOP SURFACE AT STATION 6305. REPAIRED IAW FOKKER 53-40-1.SDR DHL200072418CSeat Track · corrodedAT C-CHECK, FOUND MAIN CABIN COMPT SEAT TRACK HAS CORROSION BS 720E - 720D RBL 24. REMOVED SEAT TRACK AT BS 720E - 720D RBL 24 AS PER SRM 53-10-5 & 51-3-2. INSTALLED NEW SEAT TRACK FROM STA 720D TO STA 740 RBL 24 AS PER SRM 53-10-5 FIG 7. ALODINED AND PRIMESDR QXEA0000800Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK HAS LIGHT SURFACE CORROSION INSIDE CHANNEL AT STATION 13353. REPAIRED IAW FOKKER 53-40-01, AND 51-10-4, PAGE 8, PARAGRAPH 3C, STEPS 1-4, AND FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B.SDR QXEA0000794Seat Track · corrodedPDX- LEFT HAND OUTBOARD SEAT TRACK HAS LIGHT SURFACE CORROSION INSIDE CHANNEL AT STATION 1160. REPAIRED IAW FOKKER SRM 53-40-01 AND FOKKER SRM 51-10-4, PAGE 8, PARAGRAPH 3C, STEPS 1-4.SDR 00FDEA00154Seat Track · corrodedCORROSION C53-224-01 ON SEAT TRACK BS 740-690, RBL 45, WL 208.SDR TWAA0004803Seat Track · corrodedDURING OP 16 MAINT CHECK, FOUND CORROSION ON NUMBER 3 CHAIR TRACK, RBL 22 IN AT STA 200 TO 237. REMOVED AND REPLACED CHAIR TRACK PER SRM 53-05, FROM STA 200 TO 267.SDR MWEA00152Seat Track · corrodedFLOOR SUPPORT BETWEEN CENTER LINE, AND NR 3 SEAT TRACK AT STATION 200 HAS MODERATE CORROSION. FABRICATED AND INSTALLED NEW FLOOR SUPPORT.SDR MWEA00140Seat Track · corrodedNR 4 SEAT TRACK AND UNDERSIDE OF UPPER LEG HAS MODERATE CORROSION ON IT FROM STATION 200 TO STATION 237. FABRICATED AND INSTALLED SEAT TRACK AND SPLICES.SDR MWEA00165Seat Track · corrodedNR 3 SEAT TRACK AND UNDERSIDE OF UPPER LEG HAS MODERATE CORROSION ON IT FROM STATION 200 TO STATION 237. FABRICATED AND INSTALLED SEAT TRACK.SDR TWAA0004301Cargo Track · corrodedDURING CHECK-C MAINT, THE AFT CARGO BIN CARGO TIE DOWN TRACK, LT SIDE STA 1081 TO 1318, HAD CORROSION IN NUMEROUS PLACES. REMOVED CORRODED TRACK FROM STA 1081 TO 1220 PER SPM 6-80-01 PAGE 1 PARA 2(A)(2). REPLACED TRACK FROM STA 1220 TO 1320 PER SPM 6-70-01. SDR AU000315Seat Track · corroded(AUS) ALL CABIN SEAT TRACKS SEVERELY CORRODED.SDR 20000414AP001Seat Track · corrodedABI - SEAT TRACK AT BL 0 STATION 297 TO 348.5 CORRODED BEYOND LIMITS. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW SAAB 340B SRM 53-70-60 AND SAAB REPAIR STATEMENT 72SDS0795. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA0731Seat Track · corrodedABI - SEAT TRACK AT BL 0 STATION 297 TO 348.5 CORRODED BEYOND LIMITS. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW SAAB 340B SRM 53-70-60 AND SAAB REPAIR STATEMENT 72SDS0795. AIRCRAFT RETURNED TO SERVICE. (M)SDR 20000413AP001Seat Track · corrodedABI - SEAT TRACK AT BL 18.3 STATION 297 TO 377.5 CORRODED BEYOND LIMITS. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK AT BL 18.3 STATION 297 TO 377.5. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA0732Seat Track · corrodedABI - SEAT TRACK AT BL 18.3 STATION 297 TO 377.5 CORRODED BEYOND LIMITS. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK AT BL 18.3 STATION 297 TO 377.5. AIRCRAFT RETURNED TO SERVICE. (M)SDR QXEA0000847Seat Track · corrodedPDX- RIGHT HAND OUTBOARD SEAT TRACK HAS LIGHT SURFACE CORROSION INSIDE CHANNEL AT STATION 15550. REPAIRED IAW FOKKER SRM 53-40-01 AND FOKKER 51-10-4, PAGE 8, PARAGRAPH 3C, STEPS 1-4 AND SRM 51-10-4, PAGE 9, PARAGRAPH 4B.SDR QXEA0000846Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK HAS LIGHT SURFACE CORROSION INSIDE CHANNEL AT STATION 17455. REPAIRED IAW FOKKER SRM 53-40-01 AND FOKKER SRM 51-10-4, PAGE 8, PARAGRAPH 3C, STEPS 1-4 AND FOKKER SRM 51-10-4, PAGE 9, PARAGRAPH 4B.SDR QXEA0000802Seat Track · corrodedPDX- RIGHT HAND SEAT TRACK HAS LIGHT SURFACE CORROSION INSIDE CHANNEL AT STATION 5805. REPAIRED IAW FOKKER 53-40-01, AND FOKKER 51-10-4, PAGE 8, PARAGRAPH 3C, STEPS 1-4, AND FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B.SDR QXEA0000799Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK HAS LIGHT SURFACE CORROSION INSIDE CHANNEL AND ON TOP SURFACE AT STATION 12950. REPAIRED IAW FOKKER 53-40-01, AND FOKKER SRM 51-10-4, PAGE 8, PARAGRAPH 3C, STEPS 1-4, AND FOKKER SRM 51-10-04, PAGE 9 PARAGRAPH 4B.SDR QXEA0000798Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK HAS LIGHT SURFACE CORROSION INSIDE CHANNEL AT STATION 7000. REPAIRED IAW FOKKER SRM 53-40-01, AND FOKKER 51-10-04, PAGE 8, PARAGRAPH 3C, STEPS 1-4, AND FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B.SDR QXEA0000796Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK HAS LIGHT SURFACE CORROSION INSIDE CHANNEL AND SEVERAL GOUGES ON TOP SURFACE AT STATION 6100. REPAIRED IAW FOKKER SRM 53-40-01, FOKKER SMR 51-10-4, PAGE 8 PARAGRAPH 3C, STEPS 1-4, AND FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4SDR QXEA0000795Seat Track · corrodedPDX- LEFT HAND OUTBOARD SEAT TRACK HAS LIGHT SURFACE CORROSION INSIDE CHANNEL AT STATION 13400. REPAIRED IAW FOKKER SRM 53-40-01 AND FOKKER SRM 51-10-4, PAGE 8, PARAGRAPH 3C, STEPS 1-4, AND FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B.SDR MWEA00123Seat Track · corrodedNR 3 SEAT TRACK HAS LIGHT CORROSION BETWEEN STATION 200 - 238 UPPER AND LOWER SURFACE. FABRICATED AND INSTALLED SEAT TRACK.SDR MWEA00113Seat Track · misdrilledNR 1 SEAT TRACK HAS A MISDRILLED HOLE AT STATION 200. FABRICATED AND INSTALLED NEW SEAT TRACK.SDR MWEA00112Seat Track · corrodedNR 4 SEAT TRACK HAS LIGHT CORROSION AT STATION 200. FABRICATED AND INSTALLED NEW SEAT TRACK AND SPLICE.SDR RRXA000610Seat Track · corrodedDURING A MAINTENANCE VISIT, FOUND CORROSION DAMAGE TO THE MAIN DECK SEAT TRACK AT STA 680 TO 820 AND RBL 60, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED IAW DC-8 SRM 53-2-3 FIG 8A. (COSDR UPS00832097Seat Track · wornINSPECTION TYPE: C 123 SEAT TRACK HAS SEVERAL BARE METAL AREAS, STA 680 TO 980. CLEAN BARE METAL, FOUND OUT OF LIMITS IAW DC8 SRM 53-2-3. REPLACED & INSTALLED SEAT TRACK & CHANNEL SPLICE IAW DC8 SRM 51-3-0.SDR CALA0000300Cargo Track · corrodedINSPECTION FOUND MID PIT RT CARGO TIE DOWN TRACK CORRODED FROM STA 427-636. THE TRACK WAS REMOVED AND NEW TRACK WAS INSTALLED IAW SRM 51-30-1 AND 51-30-2.SDR RXAA000588Seat Track · corrodedDURING A MAINTENANCE VISIT, FOUND CORROSION DAMAGE TO MAIN CABIN SEAT TRACK BETWEEN STA 1260 TO 1370 AND LONGERON BL-R 60, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED MAIN CABIN SEAT TRSDR CALA0000289Cargo Track · corrodedINSPECTION FOUND AFT CARGO TIE DOWN TRACK CORRODED FROM STA 1003 TO 1212. THE TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1 AND 51-30-2.SDR AWXA0000120Seat Track · corrodedC-CHECK, SEAT TRACK IN FWD CABIN, FS 294.5 RBL 24 CORRODED. REMOVED SEAT TRACK IAW 737 SRM 51-30-2, FABRICATED AND INSTALLED SEAT TRACK FROM (BAC 1520-792 7178T6 / 511 R 659935) IAW B737 SRM 51-30-2.SDR TWAA0004222Cargo Track · corrodedDURING CHECK-C MAINT, THE CARGO TIE DOWN TRACK HAD CORROSION IN NUMEROUS PLACES RT SIDE AFT TRACK FRONT STA 1212 TO 1318. REMOVED CORRODED TRACK AND REPLACED WITH NEW TRACK (P/N 179803) PER SPM 6-70-01.SDR TWAA0004221Cargo Track · corrodedDURING CHECK-C MAINT, THE AFT CARGO BIN FLOOR FITTING WAS CORRODED AT STA 1150, ABOVE STRINGER 29R. REMOVED CORRODED FLOOR FITTING AND INSTALLED NEW FLOOR FITTING (P/N 3957317-501) PER SPM 6-70-01 PAGE 3B (1)(2) AND DRAWING 3957317.SDR UIEA01017Seat Track · scratchedDURING ROUTINE INSPECTION, FOUND SEAT TRACK GOUGED/SCRATCHED AT LBL 75.92 BETWEEN STATION 1320 AND 1460. ALL AREAS BLENDED PER SRM 51-10-01. HFEC INSPECTION PERFORMED. ALL WITHIN LIMITS PER SRM 53-10-01. AT STATION 1450 SEAT TRACK LUGS AFTER BLENDING WERE SDR UIEA01016Seat Track · scratchedDURING ROUTINE INSPECTION, FOUND SEAT TRACK GOUGED/SCRATCHED AT LBL 98.58 BETWEEN STATION 1030 AND 1135. ALL AREAS BLENDED PER SRM 51-10-01. HFEC INSPECTION PERFORMED. ALL FOUND WITHIN LIMITS PER SRM 53-10-01. FOUND SEAT TRACK LBL 75.92 GOUGED/SCRATCHED ATSDR AALA2000520Seat Track · corrodedTUL - FOUND CORROSION ON NR 2 SEAT TRACK STATION 1309-1195. REMOVED AND REPLACED NR 2 SEAT TRACK STATION 1185-1309 PER SRM 53-05 FIG 4F. (M)SDR CALA0000283Cargo Track · corrodedINSPECTION FOUND AFT CARGO AFT RT TIE DOWN TRACK CORRODED AROUND FASTENER HOLES. THE TIE DOWN TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-2.SDR DHL200072454CCargo Track · corrodedAT C CHECK, FOUND MAIN CARGO BAY CARGO TRACK CORRODED AT BS 720F, LBL 24. REMOVED CARGO TRACK NR 3 FROM STA 700 TO STA 740, PER SRM 51-30-2. INSTALLED NEW CARGO TRACK NR 3, LBL 24 FROM STA 690 TO 740 PER SRM 53-10-5 FIG 4.SDR DHL200072483CSeat Track · wornAT C CHECK, FOUND SEAT TRACK NR 5 RBL 24 HAS WORN LOCK. REMOVED FLOOR PANELS PER SRM 51-30-2, CUT OUT DAMAGED SECTION OF SEAT TRACK PER SRM 53-10-5 FIG 7, INSTALLED NEW SEAT TRACK PER SRM 53-10-5 FIG7, ALODINED AND PRIMED PER SRM 51-10-2, INSTALLED FLOORSDR UPS00832092Seat Track · corrodedINSPECTION TYPE: C 123 SEAT TRACK AT STA 1575 HAS CORROSION AROUND SEAT TRACK PLUG, FOUND OUT OF LIMITS IAW DC8 SRM 53-2-3. CUT SEAT TRACK AT FS 1550 & AT PRODUCTION SPLICE AT 1590. FABBED FWD SPLICE PER DC8 SRM 53-2-3. LOCATED, DRILLED & INSTALLED NEW SDR UPS00832088Seat Track · corrodedINSPECTION TYPE: C 123 CORROSION GROUND NUT PLATES FROM STA 1580 TO 1620 BL 0 AFT ACCESSORY BAY CORRODED BEYOND LIMITS. REMOVED CORROSION, FOUND OUT OF LIMITS IAW DC8 SRM 53-2-3. REMOVED & REPLACED SEAT TRACK.SDR UPS00832087Seat Track · corrodedINSPECTION TYPE:C 123 CORROSION ON FLOORBEAM, UPPER FLOOR SKIN & SEAT TRACK NEAR CUSP RT FS 1580 AFT ACCES BAY. SEAT TRACK CORRODED OUT OF LIMITS IAW DC8 SRM 53-2-3. REMOVED CORROSION FROM FLOORBEAM & SKIN. FOUND TO BE IN LIMITS IAW DC8 SR M 53-2-0. REMOSDR TWAA0003927Seat Track · corrodedDURING OP 16 MAINT CHECK, NUMBER 4 SEAT TRACK HAD CORROSION AT STA 232, RBL 44. REPLACED SECTION OF TRACK FROM STA 200 TO 284, NUMBER 4 TRACK PER SRM 53-05 FIG 4F FOR SPLICE, AND IPC 53-40-00 FOR TRACK AND FASTENERS. TREATED PER 51-10-3.SDR AALA2000515Seat Track · corrodedTUL - FOUND CORROSION IN SEAT TRACK NR 1 STATION 1230 TO 1237. INSTALLED NEW NR 1 SEAT TRACK FROM STATION 1174-1308 PER SRM 51-10-4 AND 51-10-4A. (M)SDR AALA2000514Seat Track · corrodedTUL - FOUND CORROSION IN SEAT TRACK NR 1 STATION 1207-1211. INSTALLED NEW NR 1 SEAT TRACK FROM STATION 1174-1308 PER 51-10-4 AND 51-10-4A. (M)SDR AALA2000512Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 4. INSTALLED PLUG PER SRM 53-05 FIG 4. (M)SDR DHL200072458CCargo Track · corrodedDURING C CHECK FOUND MAIN CARGO BAY CARGO TRACK CORRODED AT BS 950F TO 1030 RBL 24.5. REMOVED AND REPLACED SECTION OF CARGO TRACK FROM BS 950 TO BS 1030 RBL 24.5 PER SRM 51-30-1. TREATED AND PRIMED PER SRM 51-10-2.SDR DHL200072457CSeat Track · corrodedMAIN CARGO BAY, CARGO TRACK HAS CORROSION PRESENT AT BS 950F TO BS 1030 RBL 45.5. REMOVED FLOOR PANEL FOR ACCESS. REMOVED DAMAGED SECTION OF CARGO TRACK, RBL45.5, STA 950 TO 1030 PER SRM 51-30-2. INSTALLED NEW CARGO TRACK PER SRM 53-10-5 FIG 7. ALODINED SDR QXEA0000774Seat Track · corrodedYYC- LEFT HAND INBOARD SEAT TRACK IS CORRODED BEYOND LIMITS. REMOVED AND REPLACED SEAT TRACK IAW DHC-8 SRM 51-40-11 PAGE 1 SECTION 1 AND 2.SDR QXEA0000772Seat Track · corrodedYYC- RIGHT HAND FORWARD SEAT TRACK CORRODED BEYOND LIMITS. REPAIRED IAW DHC-8 SRM 51-4-00 TABLE 1 AND 2 PAGE 2.
Back to JASC 5347