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 FDEA200909013220Seat Track · corrodedCABIN - RT STA 6-90 X= -75.25 SEAT TRACK FOUND CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM ST 6-0 TO STA 6-123 X= -75.25 IAW SRM 53-00-52, FIG 201/ REPAIR 1 REV 41. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REV 107.SDR FDEA200909013219Seat Track · corrodedCABIN - RT STA 1371 TO STA 1391 X= -75.25 SEAT TRACK FOUND CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 1371 TO STA 1411 X= -75.25 IAW SRM 53-00-52, FIG 201. REPAIR 1, REV. 41. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 107.SDR FDEA200909013218Seat Track · corrodedRIGHT STA 1411 X= -8 SEAT TRACK FOUND CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 1391 TO STA 1431 X= -8 IAW SRM 53-00-52 FIG 201, REPAIR 1, REV 41. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REV 107.SDR FDEA200909013217Seat Track · corrodedLT STA 1525 X= 8 SEAT TRACK FOUND CORRODED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 1491 TO STA 1531 X= 8 IAW SRM 53-00-52, FIG 201, REPAIR 1, REV. 41. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REV 107.SDR FDEA200909013203Seat Track · wornMAIN CABIN SEAT TRACK SCALLOP IS WORN AT BS 3710 - BS 3715; LBL Y45 - LBL Y45. BLENDED DAMAGED AREA. MINIMUM ALLOWABLE MATERIAL .26. REMAINING MATERIAL .245 AND BEYOND ALLOWABLE LIMITS IAW SRM 53-10-16, FIG 102. REMOVED FLOOR PANELS 251 LG;PG; BF;GF;NH ANDSDR IPXA09557394Seat Track · corrodedINSPECTION TYPE:C CORROSION ON NUT PLATE ATTACH FASTENERS ON MCB SEAT TRACK BS 1184, RBL 60, WL 208. REPAIRED MCB SEAT TRACK IAW ER NO 09-4388.SDR AALA20090902TUL12Seat Track · corrodedCORROSION ON SEAT TRACK NUMBER 6 STATION 792 BEYOND LIMITS. INSTALLED SPLICE UNDER SRM 51-30-01.SDR FDEA200908313189Seat Track · damagedMAIN CABIN SEAT TRACK SCALLOP IS BROKEN AT BS 4140 - BS 4120; LBL Y 440 - LBL Y 440. CHECKED DAMAGED SCALLOP 0.170 REMAINING. SCALLOP WORN BEYOND MINIMUM ALLOWABLE LIMITS OF 0.260 IAW SRM 53-10-16, PG 105. REMOVED SEAT TRACK SECTION IAW SRM 53-10-156, PG 2SDR FDEA200908313188Seat Track · gougedMAIN CABIN SEAT TRACK IS GOUGED AT BS 4360 - BS 4360; LBL Y 1400 - LBL Y 1410. CHECKED GOUGED AREA, SCALLOP WORN BEYOND MINIMUM ALLOWABLE LIMIT OF .26. .21 REMAINING OUT OF LIMITS IAW SRM 53-10-16; PG 105. REMOVED FLOOR PANELS (251AH; BH;YG AND XG) FOR ACSDR FDEA200908313171Seat Track · damagedMAIN CABIN SEAT TRACK SCALLOP IS BROKEN BETWEEN FR 63 AND FR 64; RT BUTTLINE 37 INCHES FROM CTR. REMOVED DAMAGED AREA REF SRM 71-73-10, PARA F. MATERIAL LOSS ALLOWED 0.016. MATERIAL REMOVED 0.155; FOUND TO BE OUT OF LIMITS IAW SRM 53-10-16; PG 105. INSTSDR SWIA200922763Seat Track · corrodedFLOOR SEAT TRACKS CORRODED. (C CHECK) REPLACED TRACKS PER AMM.SDR ZZDA2009247Seat Track · corrodedFLOOR SEAT TRACK WITH GALLEY SUPPORT ABOVE AT STA 239 RBL 44 CORRODED. CUT OUT DAMAGED SECTION OF FLOOR TRACK RBL 44 FROM STA 200 TO STA 245, INSTALLED NEW TRACK SECTION AND SPLICE REPAIR REF DC9 SRM 53-05 4F AND EA 17-53-01776IR.SDR ASOA200900949Seat Track · corrodedFLOOR SEAT TRACK CORRODED AT RBL 9 AFT OF FS 559. REMOVED FLOOR SEAT TRACK AT RBL 9, AFT OF FS 559 AND LOCATED HOLES ONTO NEW SEAT TRACK. DRILLED AND COUNTERSUNK HOLES IAW AMM 53-01-11-000-802 AND SRM 51-40-11. . INSTALLED FLOOR SEAT TRACK IAW AMM 53-01-11-40SDR FDEA200908283116Seat Track · gougedGOUGED FLOATING SEAT TRACK BS 740-BS 760 LBL 24.5. REMOVED DAMAGED SEATTRACK AT BS 740 TO BS 760 LBL 24.5 IAW SRM 51-30-2. FABRICATED NEW SEAT TRACK FROM BAC 15201431 PO NR 6360180 APPROX DIM: 18 INCH IN LENGTH IAW SRM 53-10-2 FIG 7 AND SRM 51-30-5, TREATED SDR ASOA200900939Seat Track · corrodedSEAT TRACK CORRODED AT NR 2 GALLEY INBD MOUNT AREA - FS349.0. REMOVED SEAT TRACK PER SRM 51-41-023-001-001-A01. 08-28-09. (32) 2. INSTALLED NEW SEAT TRACK PER SRM 51-41-02-001-001-A01.SDR ASAA0956460Seat Track · gougedCAPTAINS I/B AFT SEAT TRACK IS GROOVED ON UPPER SURFACE AND AFT HOLES ARE ELONGATED. REPLACED I/B AFT SEAT TRACK.SDR ASAA0956459Seat Track · gougedCAPTAINS O/B AFT SEAT TRACK IS GOUGED. REMOVED AND REPLACED CAPTAINS AFT O/B SEAT TRACK.SDR ASAA0956458Seat Track · damagedF/O OUTBOARD AFT SEAT TRACK HOLE IS ELONGATED. REMOVED AND REPLACED F/O AFT SEAT TRACK.SDR ASAA0956457Seat Track · damagedF/O INBOARD AFT SEAT TRACK I/B RAIL AFT HOLE IS ELONGATED AND TRACK IS GOUGED. REMOVED AND REPLACED F/O OUTBOARD AFT SEAT TRACK I/B RAIL.SDR FDEA200908273113Seat Track · corrodedMAIN DECK AT STA 765, RBL 45 SEAT TRACK CORRODED. REMOVED SEAT TRACK FROM RBL 45 STA 640 TO 780 IAW SRM 51-40-2. FURTHER INVESTIGATION WEB FROM 700-720 IS CRACKED, REMOVED WEB AT RBL 45, STA 700- 720. FABRICATED AND INSTALLED NEW WEB ON NR N00602; FABRICATESDR ASOA200900937Seat Track · corrodedCABIN SEAT TRACKS CORRODED IN SEVERAL LOCATIONS. REMOVED AND REPLACED SEAT TRACKS P/N 601R31032-15 AT RBL/LBL 9 FS 364 THRU 399 PER AMM 51-01-11-420-001 PART B. TRACK ON LBL 9 BLENDED FOUND TO BE WITH IN LIMITS. LBL 9 TRACK FINISH (A044) PER CRJ 200 SRM 53SDR QXEA2009082700633Seat Track · corrodedRFD - 8 YR TASK - CORROSION ON RT FLOOR SEAT TRACK AT FS L153.00. STARTED BLENDING CORROSION ON SEAT TRACK ON INNER AND TOP SURFACE. TOP SURFACE HAS BEEN BLENDED .005, TOP SURFACE IS WITHIN LIMITS ALLOWED .035. INNER SURFACE STILL HAS PITS, IT HAS BEEN BLENDSDR QXEA2009082700632Seat Track · corrodedROCKFORD - 8 YR TASK - CORROSION ON RT FLOOR SEAT TRACK AT FS 629.00. STARTED BLENDING CORROSION ON SEAT TRACK TOP SURFACE, HAS BEEN BLENDED .004, IS WITHIN LIMITS ALLOWED .025 TO BE REMOVED. STARTED BLENDING INNER SURFACE THERE ARE STILL SOME PITS, REMOVED SDR QXEA2009082700631Seat Track · corrodedROCKFORD - 8 YR TASK - CORROSION ON LT FLOOR SEAT TRACK. BLENDED CORROSION ON SEAT TRACK TOP SURFACE, BLENDED .006 WITHIN LIMITS ALLOWED .025. BLENDED INNER SURFACE .027 REMOVED IS STILL WITHIN LIMITS ALLOWED .035 IAW CRJ 700 53-31-49. ON INNER SURFACE MAX SDR FDEA200908243080Cargo Track · crackedCRACKED LOWER FLANGE OF FLOOR TRACK AT LT STA 755, X=27.5 IN MAIN DECK CARGO. REPAIRED AS PER SRM53-00-52 FIG201 REPAIR1 REV41 (MAJOR REPAIR).SDR AALA20090825TUL38Seat Track · corrodedSEAT TRACK NUMBER 2 STATION 1198-1201 OUT OF LIMITS DUE TO CORROSION. REPLACED SEAT TRACK UNDER SRM 53-05 FIG 4F.SDR SWIA200922761Galley Track · corrodedFUSELAGE CABIN GALLEY TRACK CORRODED. (C CHECK) REPLACED TRACK PER SRM.SDR IPXA09557148Seat Track · corrodedINSPECTION TYPE:C2 FOUND CORROSION ON SURFACE OF SEAT TRACK AT STA 1169 TO STA 1186 RBL 60. REMOVED AND REPLACED SEAT TRACK FROM STA 1080 TO STA 1186 IAW SRM 51-40-02-0G.SDR FDEA200908223069Seat Track · damagedMDCC SEAT TRACK 2R 2 IN. FWD OF FR 54.3 HAS 1 EA DAMAGED SCALLOP. REMOVED DAMAGED SEAT TRACK AT 2R FWD OF FR 54.3. INSTALLED REPAIR SECTION SEAT TRACK AND 2 EA REPAIR SPLICES IAW SRM 53-10-16.SDR ASAA0976423Seat Track · corrodedAFT CARGO COMPARTMENT BS 789 TO 813 RBL 14 CORROSION AROUND FASTENER HOLES ON FLOOR TRACK. REMOVED AND REPLACED FLOOR TRACK.SDR UALA2009082102567Seat Track · corrodedMAIN SEAT TRACK STA 325 LBL 11 CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW SECTION OF SEAT TRACK STA 325 TO 425, LBL 11.SDR UALA2009082102566Seat Track · corrodedMAIN CABIN SEAT TRACK STA 325 RBL 11 CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED SEAT TRACK SECTION STA 325 TO 425, RBL 11.SDR FDEA200908203058Seat Track · gougedMAIN DECK AT STA 865, LBL24 SEAT TRACK WORN/GOUGED. FABRICATED NEW SEAT TRACK PN 60-6549/24 BATCH NR 1511787. LOCATED AND DRILLED IAW SRM 51-40-05. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-40-02 AND SRM 51-20-05.SDR A6WA200940564Seat Track · corrodedFLOOR SEAT TRACK BTWN FS 364.00 AND FS 390.00, LBL 9.00 CORRODED. FLOOR SEAT TRACK CORROSION BTWN FS 364..00 AND FS 390.00, LBL 9.00. REMOVED IAW SRM 51-21-06 AND FOUND WITHIN LIMITS IAW SRM 53-21-49. (K)SDR A6WA200940563Seat Track · corrodedFLOOR SEAT TRACK BTW FS 364.00 AND FS 390.00, RBL 9.00 CORRODED. CORROSION ON FLOOR SEAT TRACK. (K)SDR AALA20090825TUL25Seat Track · damagedSEAT TRACK GOUGED AT STATION 1100 ON SEAT TRACK NUMBER 4. INSTALLED SEAT TRACK PLUG AT STATION 1100 ON SEAT TRACK NUMBER 4 UNDER AARD 53-20-00-10.SDR ASOA200900912Seat Track · corrodedCARGO BAY SEAT TRACK FS 559+95 TO FS 567.0 RBL 9.0 IS CORRODED. REMOVED SEAT TRACK FS 559.95-FS 567.0 RBL 9.0 IAW CRJ 200 SRM 51-41-02. INSTALLED NEW TRACK IAW SRM 51-41-02.SDR ASOA200900911Seat Track · corrodedCARGO BAY SEAT TRACK FS 559+95 TO FS 567 LBL 9.0 IS CORRODED. REMOVED DAMAGED SEAT TRACK FS 559+95 TO FS 567 LBL 9-0 IAW SRM 51-41-02. INSTALLED NEW SEAT TRACK IAW SMR 51-41-02.SDR ASOA200900910Seat Track · corrodedCARGO SEAT TRACK FS 559+85 TO FS 559+96 LBL 9.0 IS CORRODED. REMOVED CARGO SEAT TRACK FS 559+85 TO FS 559+96 LBL 9.0 IAW SRM 51-41-02. SEAT TRACK NEEDS INSTALLED. INSTALLED CARGO SEAT TRACK IAW CRJ 200 SRM 51-41-02.SDR ASOA200900909Seat Track · corrodedCARGO SEAT TRACK FS 559+85 TO FS 559+96 RBL 9.0 IS CORRODED. REMOVED CORRODED SEAT TRACK FROM FS 615.00, LBL 9.00 AND INSTALLED SERVICEABLE SEAT TRACK IAW SRM 51-41-04.SDR ASOA200900908Seat Track · corrodedCARGO SEAT TRACK LBL 9.0 FS 615 IS CORRODED. REMOVED CORRODED SEAT TRACK FROM FS 615.00, LBL 9.00 AND INSTALLED SERVICEABLE SEAT TRACK IAW SRM 51-41-04.SDR ASOA200900907Seat Track · corrodedCARGO BAY SEAT TRACK RBL 27.0 FS 559+84 TO 559+96 IS CORRODED. REMOVED & REPLACED CARGO BAY SEAT TRACK RBL 27.0 FS 559.+84 TO FS 559.+96 IAW SRM 51-41-02.SDR ASOA200900906Seat Track · corrodedCARGO BAY SEAT TRACK LBL 27.0 FS 559+84 TO 559+96 IS CORRODED. REMOVED & REPLACED CARGO BAY SEAT TRACK LBL 27.0 FS 559+84 TO FS 559.+96 IAW SRM 51-41-02.SDR ASOA200900905Seat Track · corrodedSEAT TRACK RBL 9.0, 409+128 TO 559.0 HAS AN AREA OF CORROSION. REMOVED SEAT TRACK AND TRANSFERRED HOLE LOCATIONS ONTO NEW SEAT TRACK IAW MM 53-01-11-000-802, SRM 51-40-11. INSTALLED SEAT TRACK IAW SRM 51-41-02 PGS 1 AND 2 AND AMM 53-01-11-400-802.SDR KCSA091091Seat Track · crackedMAIN DECK STA 1840 LBL-76 SEAT TRACK IS CRACKED .500 INCH.SDR KCSA091090Seat Track · corrodedMAIN DECK STA 1900 LBL-76 SEAT TRACK HAS CORROSION.SDR KCSA091089Seat Track · crackedMAIN DECK STA 1940 LBL-33 SEAT TRACK IS CRACKED .750 INCH.SDR FDEA200908193047Seat Track · corrodedCABIN - LT SEAT TRACK CROWN AREA AT STA 6-10 TO STA 6-30, X = -8.5 FOUND SURFACE CORROSION. REMOVED AND FOUND EXCEEDED LIMIT IAW SRM 53-00-52, FIG 201, REVISION 41. SEAT TRACK SPLICE REPAIR CARRIED OUT FROM STA 6-0 TO STA 6-25, X = -8.5 IAW SRM 53-00-52, SDR WX0A070388Track · corrodedCORROSION ON RT TIE DOWN TRACK BETWEEN STA 1212 - 1322.SDR WX0A070387Track · corrodedCORROSION IN LT TIE DOWN TRACK BETWEEN STA 1220-1322.
Back to JASC 5347