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 M562004F00002Seat Track · corrodedMAIN CABIN STA 903-927, WL 208, LBL 44, SEAT TRACK HAS CORROSION TO SURFACE. REMOVED AND REPLACED SEAT TRACK. C1, C2, C3 INSP 8/4/04.SDR CALA0400563Seat Track · corrodedINSPECTION FOUND LEFT I/B SEAT TRACK CORRODED AT STA 907-927. THE CORRODED SECTION OF SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 53-00-52.SDR DHL2004745560Seat Track · wornDURING A C-CHECK, COCKPIT F/E AFT TRACK HAS WORN OUT INDICATION LOCK HOLES ARE SCRATCHED. REMOVED & REPLACED DAMAGED TRACK P/N 806019-401 PO 427462 IAW 727 SRM 51-30-2.SDR UPS04842880Seat Track · wornINSPECTION TYPE: C3 SEAT TRACK E HAS WORN SCALLOPS AND LUGS BETWEEN FS 1400 AND 1410. BLEND AREA IAW UPS SRM 51-1-8, FOUND TO BE OUT OF LIMITS IAW SRM 53-2-3, CUT OUT DAMAGE ON SEAT TRACK IAW EO 5340-7779B. ALODINED AND PRIMED CUT AREA, MAT ID PLUG SEAT TSDR UPS04842879Seat Track · wornINSPECTION TYPE: C3, SEAT TRACK (D) HAS WORN SCALLOPS AND LUGS BETWEEN FS 1560-1580 DOT NR D 973. BLENDED SEAT TRACK LUGS AND SCALLOPS, FOUND OUT OF LIMITS. OPEN FLOORBOARDS FROM FS 1495 TO 1690 LBL 16 TO LBL 32 IAW DC8 SRM 51-3-0 TO FOM, REMOVED SEAT TRACK SDR UPS04842878Seat Track · gougedINSPECTION TYPE: C3, STA 1580 RBL 18 SEAT TRACK LOBES GOUGED AND OBLONGED. BLENDED OUT DAMAGED LOBES AND FOUND OUT OF LIMITS. REMOVED 4 HOLES SEAT TRACK PLUG P/N DC8-53B-007-002 PO NR SP0906208 AND INSTALLED IAW EO NR 5340-7779-B. ALL IAW SRM 53-2-0, 53-2-3, ASDR UPS04842874Seat Track · wornINSPECTION TYPE: C3, STA 595-600 RBL 36 SEAT TRACK LOBES ELONGATED/OBLONGED. DAMAGE FOUND OUT OF LIMITS IAW SRM 53-2-3. REMOVED SEAT TRACK SECTION IAW SRM 51-3-0, DRILLED NEW SEAT TRACK SECTION TO FIT IAW SRM 51-1-24. INSTALLED IAW SRM 51-3-0 AND 51-3-1.SDR UPS04842866Seat Track · wornINSPECTION TYPE: C3, SEAT TRACK-C HAS WORN LUGS AND SCALLOPS BETWEEN FS 1300-1315 (DOT D976). BLENDED OUT OF LIMITS IAW DC8 SRM 53-2-3. DIMENSION AFTER BLEND OUT OUT OF LIMITS. REMOVED DAMAGE FROM SEAT TRACK MAT ID FOR PLUG 7452952 -3 MAT ID FOR SEAT TRACK SDR 04FDEA01914Seat Track · corrodedMAIN CABIN SEAT TRACK 4L HAS 2EA AREAS OF CORROSION INCLUDING ON AND UNDER SCALLOPS BETWEEN FR 75 & 76 AND BETWEEN FR 74 & 75. REMOVED CORRODED SECTION AND REPAIRED IAW A300-600 SRM 53-10-16, INSTALLED 1EA TRACK 4 FT 9 INCHES AND 2 EA SPLICES.SDR UPS04M42763Seat Track · corrodedINSPECTION TYPE:C STA Y 755 TO 859 X=-27.50 SEAT TRACK FOUND CORRODED. CORROSION AT SEAT TRACK STA Y755-859 AT X=-27.50 REMOVED FOUND EXCEED LIMIT. ORI THK=0.08 INCH & THK REMAIN=0.041 INCH. NEW SEAT TRACK & SPLICE FAB & INSTALLED PER SRM 53-70-00 F1, V1, RSDR UPS04M42762Seat Track · corrodedINSPECTION TYPE: C, STA Y 695 TO 755 SEAT TRACK FOUND CORRODED AT STA X=-27.50. CORROSION AT SEAT TRACK STA Y695-755 AT X=-27.50. CORROSION REMOVED FOUND EXCEEDED LIMIT. ORI,THK=0.100 INCH & REMAIN THK=0.050 INCH. NEW SEAT TRACK & SPLICE FAB AS PER SRM 53-SDR QXEA200400507Seat Track · corrodedPDX - NR 4 SEAT TRACK HAS PITTING CORROSION ON FLANGE AND OUTBOARD SIDE OF LUGS. REPAIRED IAW SRM 51-40-11 AND RD 8-53-1102.SDR CALA0400559Cargo Track · corrodedINSPECTION FOUND CARGO TRACK TIE DOWN RAIL IN AFT BAGGAGE BIN CORRODED AT STA 787-847, RBL 30, JUST ABOVE S27R. THE CARGO TRACK TIE DOWN RAIL WAS REMOVED AND REPLACED IAW SRM 53-00-53.SDR UPS04842691Seat Track · corrodedINSPECTION TYPE: C-3, FWD PIT FS 600 MIDDLE ROW OF FASTENERS IN SEAT TRACK SPLICE (AS SEEN FROM BELOW) LOCATED AT BC 60 R- CORROSION AROUND FASTENERS & SPACER. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS IAW DC8 SRM 53-2-3. MAT ID FOR SEAT TRACK SPLICES A &SDR 04FDEA01887Seat Track · damagedDURING P TO F MODIFICATION AND TRANSITION CHECK, FOUND DRILLED ADA3203-33 FLOOR PANEL STA 879-824 AT X /- 75.25 PROCURE DAMAGED HOLES .440 INCH Q/TA 5 HOLE ON EXISTING SEAT TRACK. PERFORM REPAIR IAW SRM 57-70-00 FIG 1A VOL I. INSTALL P/N WSP0414-7, ACA7414-SDR P5CA0401175Seat Track · crackedSEAT TRACK CORRODED & CRACKED B/W STA 580-560 LBL 62 UPPER DECK. REMOVED DAMAGE SECTION OF SEAT TRACK FROM STA 530-620 IAW SRM 51-30-08. NEW SECTION OF SEAT TRACK INSTALLED PER SRM 51-40-02, 51-11-25.SDR ASOA04465Seat Track · corrodedDURING A (C) CHECK, THE RT SEAT TRACK FORWARD OF THE LAVATORY AT FS559 + 32 TO FS 559 + 80 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE RT SEAT TRACK FORWARD OF THE LAVATORY AT FS 559 +80.SDR DHL2004804507Cargo Track · wornMAIN CARGO COMPT NR 4 TRACK LUG WORN, STA 1696.000. TRIMMED OUT DAMAGED AREA IAW SRM 53-2-3 PG 17 FIG 6D. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW CHANNEL AND TRACK PLUG IAW SRM 51-3-0 PG 1.SDR DHL2004804508Cargo Track · wornMAIN CARGO COMPT NR 2 TRACK PLUG LUG WORN, STA 1133.000. REMOVED WORN NR 2 TRACK PLUG, STA 1133.000 IAW DC8 SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW DC8 SRM 51-1-8B. INSTALLED NEW PLUG IAW SRM 51-3-0 PG 1.SDR AWXA200400751Seat Track · crackedMCN - MAJOR REPAIR - DURING C-15 CHECK A .75 INCH CRACK WAS FOUND ON INBOARD SIDE OF SEAT TRACK FLANGE AT BS 727B, RBL 45. MAINTENANCE CUT OUT DAMAGED AREA OF SEAT TRACK FLANGE AT BS 727B, RBL 45. FABRICATED A FILLER, SHIM AND 2 EACH REPAIR STRAPS; INSTALLEDSDR CALA0400553Seat Track · corrodedINSPECTION FOUND RIGHT I/B SEAT TRACK CORRODED AT STA 907-927. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52.SDR CALA0400548Seat Track · corrodedINSPECTION FOUND FORWARD ENTRY RIGHT I/B SEAT TRACK CORRODED BETWEEN STA 328 AND 344. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 53-00-52.SDR CALA0400546Seat Track · corrodedINSPECTION FOUND FORWARD ENRTY RIGHT O/B SEAT TRACK CORRODED BETWEEN STA 344 AND 360. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52.SDR CALA0400545Seat Track · corrodedINSPECTION FOUND FORWARD ENTRY LEFT I/B SEAT TRACK CORRODED AT STA 360-380. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52.SDR GTIA040621Seat Track · corrodedFTW - FOUND RIGHT INBOARD SEAT TRACKS STATION 798-1309 GOUGED AND CORRODED. FOUND TRACK OUT OF LIMITS FROM STATION 798 TO 817 AND 1260-1309. REMOVED TRACK SECTION FROM STATION 798 TO 817. FABRICATED SECTION OF TRACK. INSTALLED SECTION SEAT TRACK AND SPLICESDR DHL2004804502Cargo Track · wornMAIN CARGO COMPT NR 7 TRACK PLUG LUG WORN, STA 320.000. REMOVED WORN PLUG IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG IAW SRM 51-3-0 PG 1.SDR DHL2004804501Cargo Track · wornMAIN CARGO COMPT NR 2 TRACK PLUG LUG WORN, STA 1215.000. REMOVED DETERIORATED PLUG IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG IAW SRM 51-3-0 PG 1.SDR DHL2004804500Cargo Track · wornMAIN CARGO COMPT NR 3 TRACK PLUG LUG WORN, STA 689.000. REMOVED NR 3 TRACK PLUG, STA 689.000 IAW DC8 SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW DC8 SRM 51-1-8B. INSTALLED NEW PLUG IAW DC8 SRM 51-3-0 PG 1.SDR 0401065534Seat Track · corrodedDURING (H) CHECK FOUND CORROSION ON SEAT TRACK AT BS 1640 LBL 46. REPAIRED IAW EA 55-199278.SDR QXEA200400468Seat Track · corrodedPDX - LEFT HAND NR 5 SEAT TRACK INBOARD CENTER FLANGE HAS PITTING CORROSION. REPAIRED IAW RD 8-57-989.SDR QXEA200400467Seat Track · corrodedPDX - LEFT HAND NR 5 SEAT TRACK INBOARD UPPER FLANGE HAS PITTING CORROSION. REPAIRED IAW RD 8-57-989.SDR QXEA200400463Seat Track · corrodedPDX - NR 11 SEAT TRACK HAS SUSPECTED PITTING CORROSION AT STATION X484.5 TO 499.0. REPAIRED IAW DHC-82 SRM 51-40-11.SDR QXEA200400462Seat Track · corrodedPDX - SEAT TRACK NR 10 HAS SUSPECTED PITTING CORROSION AT STATION X277. REPAIRED IAW SRM 51-40-11.SDR 04FDEA01842Seat Track · crackedMAIN DECK SEAT TRACK FOUND CRACKED AT STA 635 RT 8 INCHES.SDR CALA0400543Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED BETWEEN STA 277 AND 294.5 UNDER RIGHT GALLEY. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR GTIA040650Seat Track · corrodedFTW - FOUND RIGHT OUTBOARD SEAT TRACK STATION 200-1309 IS CORRODED AND GOUGED ALONG ENTIRE LENGTH, FS 494 IS OUT OF LIMITS. REMOVED DAMAGED SECTION OF SEAT TRACK FROM STATION 494 TO 532. LOCATED AND DRILLED NEW SEAT TRACK SECTION AND TWO NEW SPLICES. INSTALSDR GTIA040663Seat Track · corrodedFOUND LEFT INBOARD SEAT TRACK STATION 200-1309 IS CORRODED AND GOUGED ALONG ENTIRE LENGTH. REMOVED CORROSION STATION 200-236 IS OUT OF LIMITS. MATERIAL LOSS AT STATION 948-1231 IS OUT OF LIMITS. REMOVED SEAT TRACKS FROM STATION 200-250. REMOVED LEFT INBOARSDR 04FDEA01791Seat Track · wornMAIN DECK SEAT TRACK FOUND WORN AT STA 699 LBL 47 INCHES.SDR AWXA200400706Seat Track · corrodedMAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON LT OB Y1292 SEAT TRACK FR 36-41. MAINTENANCE REMOVED AND REPLACED SEAT TRACK AT Y1292 FR 36-41 IAW A320 SRM 51-42-11 FIGURES 12,18.SDR AWXA200400702Seat Track · corrodedMAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON LT IB Y765 SEAT TRACK FR36-41. MAINTENANCE REMOVED AND REPLACED SEAT RACK SECTION ON LT SIDE IB OF Y765 IAW SRM 51-42-11 PAGES 6,7,39-41 FIGURES 12,18.SDR AWXA200400701Seat Track · corrodedMAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON RT IB Y-765 SEAT RACK FR36-41. MAINTENANCE REMOVED AND REPLACED SEAT TRACK AT FR 36-41 IAW A320 SRM 51-42-11 FIGURES 9,10,12,18.SDR AWXA200400700Seat Track · corrodedMAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON RT OB Y-1292 SEAT TRACK FR36-FR41. MAINTENANCE REMOVED AND REPLACED SEAT TRACK AT FR 36-4 IAW A320 SRM 51-42-11 PAGES 6,7,28 FIGURE 12.SDR 04FDEA01777Seat Track · crackedMAIN DECK SEAT TRACK FOUND CRACKED AT STA 905 RT 28. REMOVED AND REPAIRED IAW SRM 53-70-00 FIG 1 VOL I.SDR 04FDEA01771Seat Track · corrodedMAIN CARGO DECK RIGHT HAND STA 1741 TO STA 2007 SEAT TRACK REF X=102.5 SEAT TRACK HAS CORROSION. SEAT TRACK REMOVED AS PER SRM 51-21-01 VOL II, FOUND EXCEEDED LIMIT: ORIG. THICKNESS =0.080, MATERIAL REMAINED=0.043", MATERIAL REMOVED =0.037 AS PER SRM 53-70-SDR USAA040320Seat Track · corrodedSEAT TRACK, 27 INCHES X .85 INCH X .047 INCH AREA, CORROSION; LEVEL 2; MAIN DECK FLOOR SUPPORT, FRAME 14-16, Y+503. REMOVED AND REPLACED FLOOR SUPPORT IAW SRM.SDR 04FDEA01769Seat Track · wornMAIN DECK SEAT TRACK FOUND WORN AT STA 792 RIGHT 48 INCHES.SDR 04FDEA01759Seat Track · corrodedMAIN DECK SEAT TRACK AT R1 DOOR WAY FOUND CORRODED.SDR 04FDEA01758Seat Track · wornMAIN DECK - SEAT TRACK FOUND WORN AT STA 492 RT 63.SDR 04FDEA01757Seat Track · wornMAIN DECK SEAT TRACK FOUND WORN AT STA 492 RIGHT 63.SDR 04FDEA01735Seat Track · corrodedFOUND MAIN DECK SEAT TRACK CORROSION AT STA 460 LEFT HAND MOST OUTBOARD. MAIN DECK SEAT TRACK FOUND CORROSION AT STA 460 LEFT HAND MOST OUTBOARD REMOVED AS PER SRM 51-31-01 VOL 2 AND SRM 51-33-01 VOL 2. THE CORROSION REMOVED AS PER SRM 51-21-01 VOL 2 AND F
Back to JASC 5347