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 UPS06M47904Seat Track · corrodedINSPECTION TYPE-C MAIN DECK:ALONG X=-8 (RT SIDE), BETWEEN STA 865 AND STA 869, SEAT TRACK CROWN AREAS CORRODED STA 849-919 X=-8 CORROSION SEAT TRACK REMOVED IAW SRM 51-31-01 V.2 R.38, CORROSION OUT OF LIMIT TO REPAIR. REPAIR SEAT TRACK FAB IAW SRM 53-70-0 0 FSDR UPS06M47901Seat Track · corrodedINSPECTION TYPE-C MAIN DECK:X=8 (LT SIDE), BETWEEN STA 865 AND STA 869, SEAT TRACK CROWN AREAS CORRODED STA 849-919 X=8 CORROSION SEAT TRACK REMOVED IAW SRM 51-31-01 V.2 R.38, CORROSION OUT OF LIMIT TO REPAIR. REPAIR SEAT TRACK FAB IAW SRM 53-70-00 FIG 1 V.1 SDR AWXA200601550Seat Track · corrodedSAL - CORROSION ON SEAT TRACK LOCATED AT FS 47/51 + 6", FS 52 + 15", FS 57 + 4", +Y765, LT INBD PASSENGER CABIN (3 POINTS). PERFORMED PERMANENT REPAIR ON SEAT TRACK LOCATED AT FS 47/51 + 6", +Y765, LT INBD PASSENGER CABIN IAW A319 SRM 53-00-15, PAGE 207 TO PASDR CALA0600301Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 270-294.5, RBL 42. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0600300Seat Track · corrodedINSPECTION FOUND RIGHT O/B SEAT TRACK CORRODED AT STA 328. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR DU4R2006600Seat Track · corrodedS/O 291020 N/R 32059 RT OB SEAT TRACK AT FS 418-800 RBL 54 CORRODED. REMOVED CORRODED SEAT TRACK, CUT AND INSTALLED 48 FOOT SECTION OF TRACK P/N 5930547U70 IAW SRM 51-10-4 AND 53-05D.SDR COMA0670175Seat Track · corrodedRIGHT FLOOR SEAT TRACK AT FS 490-496 HAS MINOR CORROSION. BLENDED OUT MINOR SURFACE CORROSION IAW CRJ700 SRM 53-21-49, RE-APPLIED PROTECTIVE TREATMENT AS REQUIRED.SDR COMA0670174Seat Track · corrodedRIGHT SIDEWALL SEAT TRACK AT FS 377-383 HAS MINOR SURFACE CORROSION. BLENDED OUT MINOR SURFACE CORROSION IAW CRJ700 SRM 53-21-49. RE-APPLIED PROTECTIVE TREATMENT AS REQUIRED.SDR KCSA061264Seat Track · crackedFIRST OFFICER`S RT FWD SEAT TRACK CRACKED.SDR KCSA061263Seat Track · crackedCAPT`S FWD I/B SEAT TRACK CRACKED.SDR KCSA061262Seat Track · crackedFIRST OFFICER`S FWD I/B SEAT TRACK CRACKED.SDR KCSA061261Seat Track · crackedCAPT`S O/B AFT SEAT TRACK CRACKED.SDR UPS06648162Seat Track · corrodedINSPECTION TYPE:C2 MAIN CARGO FLOOR SUPPORT STRUCTURE HAS CORROSION AROUND THE UPPER AND LOWER SURFACE OF NUMEROUS FASTENER HOLES FROM BS 1461 TO BS 1518, RBL 89. REMOVED CORROSION BY MECHANICAL MEANS-AREAS "IN LIMITS" WERE ALODINED, PRIMED, AND PAINTED AREASSDR UPS06447922Fitting · corrodedBS 842 LBL27-30 TIE DOWN FTG FLANGE CORROSION. CORROSION BLEND OUT 0.016" BY 1/2" BY 3" EXCEED SRM LIMIT. FTG REPLACED AS PER MM 20-51-01.SDR UPS06447921Fitting · corrodedM/D BS860 LBL55 TIE DOWN FTG FLANGE CORROSION. CORROSION BLEND OUT 0.026" BY 1/2" BY 3" EXCEED SRM LIMIT. FTG REPLACED AS PER MM 20-51-01.SDR UPS06447920Fitting · corrodedM/D BS 978 RBL28 TIE DOWN FTG FLANGE CORROSION. CORROSION BLEND OUT 0.027" BY 0.5" BY 2" EXCEED SRM LIMIT. FTG REPLACED AS PER MM 20-51-01.SDR UPS06447919Fitting · corrodedM/D BS980 RBL83 TIE DOWN FTG FLANGE CORROSION. CORROSION BLEND OUT 0.021" BY 1" BY 2" EXCEED SRM LIMIT. FTG REPLACED AS PER MM 20-51-01.SDR UPS06447916Fitting · corrodedM/D BS 802 LBL27 TIE DOWN FTG FLANGE CORROSION. CORROSION BLEND OUT 0.043" BY 1" BY 3" EXCEED SRM LIMIT. FTG REPLACED AS PER MM 20-51-01.SDR UPS06447915Fitting · corrodedM/D BS 900 LBL55 TIE DOWN FTG FLANGE CORROSION. CORROSION BLEND OUT 0.039" BY 1/2" BY 2" EXCEED SRM LIMIT. FTG REPLACED AS PER MM 20-51-01.SDR UPS06447913Seat Track · corrodedM/D BS 759 LBL75 SEAT TRACK LT FLANGE CORROSION. CORROSION BLEND OUT 0.021" BY 1/2" BY 1" EXCEED SRM LIMIT. M/D BS 750 TO BS 830 LBL 75 TRACK REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS06447902Seat Track · corrodedINSPECTION TYPE-C M/D BS 896 LBL 33 SEAT TRACK RT FLANGE CORROSION. CORROSION BLEND OUT 0.022 INCH X .5 INCH X 2 INCH EXCEED SRM LIMIT. M/D BS890 TO BS1000 LBL33 TRACK REPAIRED IAW SRM 53-10-05 FIG 1A.SDR AMTA200600514Anchor · damagedAFT PIT CARGO SYSTEM FWD FLOOR ANCHOR HAS GOUGES, PITTING AND SURFACE CORRODED AROUND 3 ATTACH POINTS AND NUT PLATES HAVE CORROSION. REMOVED CORROSION AND GOUGES IAW CPM ORIGINAL MATERIAL THICKNESS IS .063 AND .040 MATL LOSS AT AREA OF .063 IS .005 WITHIN LIMSDR MALA060519Seat Track · corrodedDURING 4K CHECK, FOUND SEAT TRACK AT LBL 18.3 BETWEEN FS 658.5 AND FS 686.888 IS CORRODED OUT OF LIMITS IN THE COIN SLOT AREA. THE DAMAGED SEAT TRACK HAS BEEN REMOVED AND REPLACED IAW MESABA EO NR S53060. REF: EAMS WORK ORDER 214264 TASK 1539.SDR TRAX200600634Seat Track · corrodedCORROSION FOUND ON CROWN OF RIGHT SEAT TRACK BETWEEN FR 39 AND FR 40. ON CROWN OF RT SEAT TRACK BTWN FR 39-40 CORROSION IS REMOVED AS PER SRM 51-21-42. MATERIAL THICKNESS 0.146 MATERIAL REMOVED .003 WITHIN LIMITS AS PER SRM 53-00-00 FIG 304. REPAIR DETERMISDR TRAX200600633Seat Track · corrodedCORROSION FOUND ON CROWN OF LT SEAT TRACK BETWEEN FR 36 AND 39. REPAIRED IAW ALL SRMS.SDR TRAX200600630Seat Track · corrodedRIGHT SEAT TRACK FR 36 OUTBOARD CORROSION. RT SEAT TRACK FR 36 O/B CORROSION REMOVED AS PER SRM 51-21-42. MATERIAL THICKNESS 0.146 MATERIAL REMOVED .005 WITHIN LIMITS AS PER SRM 53-00-00 FIG 304. REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IAW SP663 AND FAR 4SDR UPS06M48337Seat Track · corrodedINSPECTION TYPE:C MAIN DECK:ALONG X=-75, STA 1331 TO STA 1381, SEAT TRACK CROWN AND FLANGE AREAS FOUND CORRODED. STA 1256.25 TO 1381 X=-75 OUT OF LIMIT CORROSION. TRACK ATTACH PARTS AND FASTENERS REMOVED PER SRM 51-31-01 V.II R.38 STA 1265 & 1391 X=-75 SEAT SDR 06FDEA02993Seat Track · corrodedCORROSION FOUND ON SEAT TRACK FLANGE AND CROWN AT STA 859 TO STA 824 RBL 27.5. REMOVED CORROSION AND FOUND EXCEED LIMIT AS PER SRM 53-70-00 FIG 3 VOL I AND CARRIED OUT. REPAIR BY FABRICATING NEW SEAT TRACK AND SPLICE AS PER SRM 53-70-00 FIG VOL.I. CLASSIFISDR DHL2006745527Seat Track · corrodedMAIN CARGO DECK AT BS 680-720F 45L SEAT TRACK HAS CORROSION AND MISDRILLED HOLE AT BS 690. REMOVED SEAT TRACK FROM BS 660-740 LBL45 IAW B727 SRM 51-30-2, FAB NEW SEAT TRACK P/N BAC1520-792 PO NR 9003607 APPROX DIM 17'3" IAW B727 SRM 53-10-05 FIG 1 AND SRM 53-SDR QXEA200602129Seat Track · corrodedPDX C4 - CORROSION ON NR 7 SEAT TRACK AT APPROXIMATELY STATION X240.5. REPAIRED IAW DHC-8-200 SRM 51-40-00 AND SRM 51-40-11.SDR UPS06447917Fitting · corrodedM/D BS 682 LBL15 TIE DOWN FTG FLANGE CORROSION. CORROSION BLEND OUT 0.017" BY 1.5" BY 3" EXCEED SRM LIMIT. FTG REPLACED AS PER MM 20-51-01.SDR UPS06447884Seat Track · corrodedINSPECTION TYPE-C M/D BS990-1000 LBL33 SEAT TRACK IB FLANGE FOUND COR. CORROSION BLEND OUT 0.020 INCH X .5 INCH X 1 INCH EXCEED SRM LIMIT. M/D BS890-1000 LBL33 TRACK REPAIRED IAW SRM 53-10-05 FIG 1A REFER NRC 6587 FOR WORKING DETAIL.SDR UPS06447883Seat Track · corrodedINSPECTION TYPE-C M/D BS980-1000 LBL33 SEAT TRACK OB FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.033 INCH X .8750 INCH X 2 INCH EXCEED SRM LIMIT. M/D BS890 TO 1000 LBL33 TRACK REPAIRED IAW SRM 53-10-05 FIG 1A REFER NRC 6587 FOR WORKING DETAIL.SDR QXEA200602124Seat Track · corrodedPDX C4 - MULTIPLE CORROSION ON SEAT TRACKS NR 4 FROM STATION X112.00. REPAIRED IAW RD 8-53-1339, RD 8-53-4473, DHC-8-200 SRM 51-40-00 AND SRM 51-40-11.SDR WRLA2006071Seat Track · corrodedDURING C-CHECK IN GSO FOUND MAIN CABIN BETWEEN STA 824 TO 899 SEAT TRACK AT APPROX RBL 106 CORRODED. REMOVED AND REPLACED SEAT TRACK SECTION FROM STA 765 TO 910 WITH A NEW SEAT TRACK IAW DC10-30 SRM 53-70-00 VOL I.SDR 06FDEA2993Seat Track · corrodedCORROSION FOUND ON SEAT TRACK FLANGE AND CROWN AT STA 859 TO STA 824 RBL 27.5.SDR UPS06M48253Seat Track · corrodedINSPECTION TYPE:C MAIN DECK FROM STA 1911 TO STA 2007, LT MOST O/B SEAT TRACK FLANGE AREAS AND SEAT TRACK CROWN AREAS FOUND CORRODED SEAT TRACK AT STA 1831 - 2007 LBL107.25 ATTACH PARTS AND TRACK REMOVED PER SRM 51-31-01 V.II R.38. NEW SEAT TRACK FASTENER HOLSDR UPS06M48244Seat Track · corrodedINSPECTION TYPE-C MAIN DECK: FROM STA 1911 TO STA 2007, RT MOST OB SEAT TRACK FLANGE AREAS AND SEAT TRACK CROWN AREAS FOUND CORRODED. CORRODED SEAT TRACK AT STA 1831 TO 2007 RBL 107.25 ATTACH PARTS AND TRACK REMOVED IAW SRM51-31-01 V.II R.38. NEW SEAT TRASDR UPS06448084Seat Track · crackedBS 520 RBL8 SEAT TRACK CRACK, CRACK LENGTH 4" AND 0.75" RESP. BS 520 RBL98 SEAT TRACK REPAIRED AS PER RS R53-25-35572 AND UPS ENGINEERING FILE NUMBER 747-53-20330.SDR UPS06447880Seat Track · crackedBS 641 RBL 75 SEAT TRACK CRACK, CRACK LENGTH 3/8". BS 640 TO BS 670 RBL75 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS06447879Seat Track · crackedBS 520 RBL90 SEAT TRACK CRACK, CRACK LENGTH 1/2". BS 480 TO BS 530 RBL90 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS06447878Seat Track · crackedBS 636-640 RBL75 SEAT TRACK CRACK, CRACK LENGTH 7/16". BS 610 TO BS 640 RBL75 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS06447927Fitting · corrodedBS 521 RBL14-20 TIE DOWN FTG FLANGE CORROSION. CORROSION BLEND OUT 0.022" BY 1/2" BY 3" EXCEED SRM LIMIT. TIE DOWN FTG ATTACH PLATE REPLACED AS PER SRM 51-10-01 PG 9.SDR UPS06447918Fitting · corrodedM/D BS 681 RBL15 TIE DOWN FTG FLANGE CORROSION. CORROSION BLEND OUT 0.042" BY 1.5" BY 2" EXCEED SRM LIMIT. FTG REPLACED AS PER MM 20-51-01.SDR UPS06447889Seat Track · corrodedINSPECTION TYPE-C M/D BS 532 RBL11 SEAT TRACK RT FLANGE CORROSION. CORROSION BLEND OUT 0.025 INCH X .5 INCH X 2 INCH EXCEED SRM LIMIT. M/D BS510-630 RBL11 TRACK REPLACED AND INSTALLED IAW SRM 51-10-01 P PG9 AND 51-30-02 REFER NRC 6163 FOR DETAIL.SDR UPS06447887Seat Track · corrodedINSPECTION TYPE-C M/D BS556-560 RBL11 SEAT TRACK LT FLANGE CORROSION. CORROSION BLEND OUT 0.028 INCH X .5 INCH X 5 INCH EXCEED SRM LIMIT. M/D BS510-630 RBL11 TRACK REPLACED AND INSTALLED IAW SRM 51-10-01 PG 9 AND 51-30-02 REFER NRC 613 FOR DETAIL.SDR UPS06447886Seat Track · corrodedINSPECTION TYPE-C M/D BS583-620 RBL11 SEAT TRACK RT FLANGE CORROSION. CORROSION BLEND OUT 0.021 INCH X .5 INCH X 10 INCH EXCEED SRM LIMIT. M/D BS510-630 RBL11 TRACK REPLACED AND INSTALLED IAW SRM 51-10-01 PG 9 AND 51-30-02 REFER NRC 6163 FOR WORKING DETAIL.SDR UPS06447885Seat Track · corrodedINSPECTION TYPE-C M/D BS520-528 RBL11 SEAT TRACK RT FLANGE CORROSION. CORROSION BLEND OUT 0.022 INCH X .5 INCH X 3 INCH EXCEED SRM LIMT. M/D BS510-630 RBL11 TRACK REPLACED AND INSTALLED INCH SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS06447882Seat Track · corrodedINSPECTION TYPE-C M/D BS678 RBL11 SEAT TRACK LT FLANGE CORROSION. CORROSION BLEND OUT 0.017 INCH X .5 INCH X 3 INCH EXCEED SRM LIMIT. M/D BS630-690 RBL11 TRACK REPLACED AND INSTALLED IAW SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS06447881Seat Track · corrodedINSPECTION TYPE-C M/D BS636-639 RBL11 SEAT TRACK CROWN CORROSION. CORROSION BLEND OUT 0.035 INCH X .7500 INCH X 3 INCH EXCEED SRM LIMIT. M/D BS630-690 RBL11 TRACK REPLACED AND INSTALLED IAW SRM 51-10-01 PG 9 AND 51-30-02.
Back to JASC 5347