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 WRLA2009069Seat Track · corrodedDURING C3 CHECK IN TPE INSPECTION FOUND CABIN SEAT TRACK HAD CORROSION AT STA 846 X=43. REPAIRED THIS CORRODED SEAT TRACK IAW SRM 53-70-00 VOL 1 FIG 1 REV 40, JOB COMPLETED AND CONDITION CHECK NORMAL.SDR FDEA200903210989Seat Track · corrodedCABIN, LT STA 1331 X= 75 SEAT TRACK FOUND CORRODED. SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIG. I VOL. I REV. 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REV. 107.SDR FDEA200903210988Seat Track · corrodedCABIN, LT STA 1325 TO STA 1381, X= 8.5 SEAT TRACK FOUND CORRODED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIG. I VOL. I REV. 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REV. 107SDR FDEA200903210987Seat Track · corrodedCABIN, RT STA 1305 X= -8.5 SEAT TRACK FOUND CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIG. I VOL. I REV. 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REV. 107.SDR FDEA200903210986Seat Track · corrodedCABIN, RT STA 1279 TO STA 1299, X= -8.5 SEAT TRACK FOUND CORRODED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIG. I VOL. I REV. 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REV. 107.SDR FDEA200903210985Seat Track · corrodedCABIN, LT STA 1299 TO STA 1309, X= 75 SEAT TRACK FOUND CORRODED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIG. I VOL. I REV. 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REV. 107.SDR FDEA200903210983Seat Track · corrodedCABIN, RT STA 1401 TO STA 1426, X= -8 SEAT TRACK FOUND CORRODED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIG. I VOL I REV. 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REV. 107.SDR FDEA200903210982Seat Track · corrodedCABIN, LT STA 1401 TO STA 1461, X= 8 SEAT TRACK FOUND CORRODED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIG. I VOL. I REV. 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REV. 107.SDR ASAA0975013Strap · corrodedAFT PIT FLOOR PANEL TIE DOWN STRAP STA 770 LBL 24 RBL 24 CORRODED. REMOVED CORRODED TIE DOWN STRAP, RECEIVED NEW PART, LOCATED, TREATED, PRIMED AND INSTALLED IAW B737 700 SRM 53 60 53 51 40 05.SDR IPXA09555311Seat Track · corrodedINSPECTION TYPE:C3 CORROSION ON SEAT TRACK O/B FLANGE UPPER AND LOWER SURFACES BS 1602 - BS 1610 LBL 46 WL 208. SEAT TRACK SECTION WAS REPLACED IAW SRM 51-40-02.SDR IPXA09555310Seat Track · corrodedINSPECTION TYPE:C3 CORROSION ON SEAT TRACK I/B FLANGE BS 1167 - BS 1198 LBL 45 WL 208. CORROSION REMOVAL BLENDED OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-40-02-0G, 51-40-08-0G, DWG 146N5218-1.SDR IPXA09555309Seat Track · corrodedINSPECTION TYPE:C3 CORROSION ON SEAT TRACK O/B FLANGE BS 1182 LBL 26 WL 208. FOUND 100 PERCENT MATERIAL LOSS. REMOVED AND REPLACED SEAT TRACK BS 1180-1320 IAW SRM 51-40-02-0G, DWG 146N5218-1, SRM 51-40-08-0G.SDR USAA2009040190760Seat Track · corrodedSAL - C7 - MAJOR REPAIR - GALVANIC CORROSION ON SEAT TRACK BETWEEN FR12 TO FR20, -Y1292. REPLACED SEAT TRACK BETWEEN FR12 TO FR20, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2009040190759Seat Track · corrodedSAL - C7 - MAJOR REPAIR - GALVANIC CORROSION ON SEAT BEAM RAIL BETWEEN FR64 TO FR66 + 5 INCHES, -Y765. REPLACED SEAT BEAM RAIL BETWEEN FR64 TO FR66 + 5 INCHES, -Y765 IAW A319 SRM 51-72-11.SDR USAA2009040190751Seat Track · corrodedSAL - C7 - MAJOR REPAIR - GALVANIC CORROSION ON SEAT TRACK BETWEEN FR12 TO FR24, -Y765. REPLACED SEAT TRACK BETWEEN FR12 TO FR24, -Y765 IAW A319 SRM 51-72-11.SDR ASOA200900318Seat Track · corrodedCABIN FLOOR SEAT RAILS BETWEEN FS 559.00 AND FS 559.00+80 AT RBL 9 AND LBL 9 HAVE CORROSION. REMOVED CABIN SEAT TRACKS. FABRICATED SEAT TRACK, DRILLED AND COUNTERSUNK HOLES IAW SRM 51-40-11.SDR ASOA200900317Cargo Track · corrodedCARGO FLOOR SEAT RAILS BETWEEN FS 559.00+80 AND FS 559.00+120 AT LBL 27 HAVE CORROSION AROUND SCREW HOLES. REMOVED DAMAGED CARGO TRACK. FABRICATED NEW SECTION OF CARGO TRACK, LOCATED, DRILLED, AND COUNTERSUNK HOLES IAW CRJ 200 SRM 51-40-11.SDR ASOA200900316Cargo Track · corrodedCARGO BAY CARGO TRACK BETWEEN FS 559.00+110 AND FS 621.00 AT LBL 9 HAVE CORROSION AROUND SCREW HOLES. REMOVED DAMAGED CARGO TRACK, FABRICATED NEW SECTIONS OF CARGO TRACK. LOCATED, DRILLED, AND COUNTERSUNK 2 OF 5 SECTIONS. ALL WORK PERFORMED IAW SRM 51-40-11.SDR ASOA200900315Cargo Track · corrodedCARGO BAY FLOOR SEAT RAILS BETWEEN FS 559.00+80 AND FS 574.00 AT RBL 9 HAVE CORROSION AROUND SCREW HOLES. REMOVED SEAT TRACK IAW SRM 51-41-02. INSTALLED SEAT TRACK IAW AMM 53-01-11-400-802.SDR ASOA200900314Cargo Track · corrodedCARGO BAY FLOOR SEAT RAIL BETWEEN FS 559.00+80 AND FS 559.00+96 HAS CORROSION AROUND SCREW HOLES AT RBL 27.0. INSTALLED NEW SEAT TRACK IAW SRM 51-41-02.SDR AALA20090406TUL15Seat Track · wornNR 6 SEAT TRACK WORN BEYOND LIMITS. INSTALLED SEAT TRACK PLUG PER SRM 53-05-00.SDR USAA2009040190758Seat Track · corrodedSAL - C7 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR36 TO FR41, -Y765. REPLACED SEAT TRACK BETWEEN FR36 TO FR41, -Y765 IAW A319 SRM 51-72-11.SDR FDEA200903190968Seat Track · crackedCABIN, LT STA 695 TO STA 735, X= 8.5 SEAT TRACK FOUND CRACKED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 665 TO STA 745 X= 8.5 AS PER SRM 53-70-00 FIG. I VOL. I REV 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REV. 107.SDR FDEA200903190967Seat Track · corrodedCABIN,LT STA 415 TO STA 475. X= 107 SEAT TRACK FOUND CORROSION. REMOVED AND REPLACED AS PER SRM 51-31-01 VOL.II REV 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REV. 107.SDR FDEA200903190966Seat Track · corrodedCABIN, LT STA 1521 TO STA 1531 X=8 SEAT TRACK FOUND CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 1411 TO STA 1531 X= 8 AS PER SRM 53-70-00 FIG. I VOL. I REV 40. REPAIR CLASSIFIED AS MAJOR AS PER REV. 107.SDR AALA20090406TUL06Cargo Track · corrodedCORROSION ON LEFT HAND TIE DOWN TRACK IN AFT CARGO STATION 1022-1212. REMOVED AND REPLACED TIE DOWN TRACK PER AARD 51-00-00-012.SDR AALA20090331TUL42Seat Track · corrodedSEAT TRACK NR 5 CORRODED BEYOND LIMITS FROM STATION 200-206. INSTALLED NEW TRACK SECTION PER SRM 53-05-00 FIGURE 4.SDR USAA2009032390658Seat Track · corrodedBFM - C4 - MAJOR REPAIR - LEVEL 2 CORROSION ON SEAT TRACK BETWEEN BS 785.9 TO BS 808, RBL 88.5. REPLACED SEAT TRACK BETWEEN BS 785.9 TO BS 808, RBL 88.5 IAW B767 SRM 53-00-52.SDR DL75E090455Seat Track · corrodedMAIN CABIN SEAT TRACK STA 695 TO 780 RBL 24-25 HAS CORROSION ON MULTIPLE AREAS BOTTOM SURFACE AND CROWN. C/W AR SAA - SAT ON N/R 119046 SAA JOB 82301770001.SDR FDEA200903180958Seat Track · gougedBS 418-440 RBL 45 SEAT TRACK GOUGED. REMOVED SEAT TRACK & FOUND TO BE DAMAGED AND SEVERAL DOUBLE HOLES IAW SRM 51-40-2. FABRICATED NEW SEAT TRACK IAW SRM 53-00-52 FIG 201. INSTALLED NEW SEAT TRACK IAW SRM 51-40-2 AND SRM 53-00-52 FIG 201. CATEGORY "A" MAJOSDR AALA20090331TUL38Seat Track · corrodedSEAT TRACK NR 2 CORRODED FROM STATION 216-220. INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10.SDR FDEA200903161574Roller Track · misrepairedPREVIOUS REPAIR FOUND ON ROLLER TRACK LOCATED BTW FR 22-23 AT Y-100. REPAIR REQUIRES EVALUATION FOR MAJOR/MINOR DETERMINATION AND IF REPAIR WAS ACCOMPLISHED USING FAA APPROVED DATA. REPAIR EVALUATED AND FOUND NOT TO CONFORM TO AN SRM REPAIR. NEW REPAIR WASDR ASAA0944773Seat Track · corrodedNUMEROUS AREAS OF CORROSION/MECH DAMAGE TO SEAT TRACK. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944742Seat Track · damagedNUMEROUS AREAS OF CORROSION AND OR MECHANICAL DAMAGE TO SEAT TRACK SEGMENT BS 727B-907 RBL 24. REMOVED AND REPLACED SEAT TRACK.SDR AALA20090318TUL05Cargo Track · corrodedCORROSION ON AFT CARGO LEFT TIE DOWN TRACK FROM STATION 1212-1231. REMOVED AND REPLACED TIE DOWN TRACK PER 25-52-00-03L.SDR AALA20090318TUL04Splice · corrodedCORROSION ON LEFT TIE DOWN TRACK SPLICE FROM STATION 1212-1231. REMOVED AND REPLACED TIE DOWN TRACK SPLICE PER IPC 25-52-00-03L.SDR AALA20090313TUL05Fitting · corrodedLEFT CARGO TIE DOWN TRACK FITTING CORRODED AT STATION 1271. INSTALLED NEW TIE DOWN FITTING PER SRM 51-30-05.SDR AALA20090313TUL04Fitting · corrodedRIGHT TIE DOWN TRACK FITTING CORRODED AT STATION 271. INSTALLED NEW CARGO TIE DOWN TRACK FITTING PER SRM 51-30-05.SDR AALA20090402TUL01Cargo Track · corrodedCORROSION ON LEFT TIE DOWN TRACK FROM STATION 1085-1155. REMOVED AND REPLACED LEFT TIE DOWN TRACK PER 53-24-00.SDR FDEA200903110901Seat Track · corrodedSEAT TRACK LBL 25 CORRODED ON NUMEROUS LOCATIONS FROM STA 500-690. REMOVED SEAT TRACK IAW SRM 51-30-2, FABRICATED NEW SEAT TRACK FROM 60-6549/24 BATCH NR 1514987 LOCATED AND DRILLED IAW SRM 51-30-2. TREATED AND PRIMED IAW SRM 51-10-2. INSTALLED NEW SEAT TRSDR FDEA200903110900Seat Track · corrodedMAIN DECK, AT STATION 1006, X = 8.5 SEAT TRACK FOUND CORRODED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 989 TO STA 1029, X = 8.5, AS PER SRM 53-70-00 FIGURE 1 VOLUME I, REVISION 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REVISION 107.SDR AALA20090310TUL01Seat Track · damagedSEAT TRACK HAS WEAR DAMAGE AT LBL 33 FROM STA 1031 TO STA 1289. REPAIRED IAW EA B777-53-005664 AND SRM 51-00-01 +51-40-03 +51-40-05 + 51-20-02, INSTALLED STRAP DOUBLER.SDR ASAA0954694Cargo Track · corrodedCORROSION ON RT CARGO TRACK. REMOVED AND REPLACED RT CARGO TRACK.SDR ASAA0944673Cargo Track · corrodedAFT PIT FWD LT ANCHOR FITTING LOCKING LUGS DAMAGED ADDITION DAMAGE NOTED/CORROSION.SDR ASAA0954669Cargo Track · corrodedCORROSION ON CARGO TIE DOWN TRACK. REMOVED AND REPLACED DAMAGED CARGO TRACK.SDR FDEA200903090873Seat Track · wornBS 377-440, LBL 24, SEAT TRACK REQUIRES REPLACEMENT PER CUSTOMER REQUEST. REMOVED SEAT TRACK IAW SRM 51-40-02. FABRICATED NEW SEAT TRACK ASSY PER SRM 53-30- 52. LOCATED AND DRILLED IAW SRM 51-40-05. TREATED AND PRIMED PER SRM 51-20-01. INSTALLED NEW SEATSDR FDEA200903090872Seat Track · gougedBS 418-440, RBL 24, SEAR TRACK IS GOUGED. REMOVED DAMAGED AREA IAW SRM 53-00-53, FIG 101, DETAIL 1. GOUGE FOUND TO BE OUT OF LIMITS PER SRM 53-00-53, FIG 101, DETAIL 1. ORIGINAL MATL. .180 INCH; AFTER REWORK; .060 INCH. REMOVED SEAT TRACK, BS 418-440, RBL 2SDR FDEA200903090870Seat Track · corrodedMAIN DECK FLOOR PANELS AND SEAT TRACKS 1 EA 1 INCH LONG MODERATE CORROSION LOWER CHANNEL. REPAIRED AREA IAW SRM 53-70-00, FIG 13, SHT 1, VOL I.SDR SWIA200921485Seat Track · corrodedC-CHECK, SEAT TRACK CORRODED. REPLACED PER AMM.SDR FDEA200903080863Seat Track · corrodedSEAT TRACK LBL 45 CORRODED ON NUMEROUS LOCATIONS FROM STA 500 - 690. REMOVED AND REPLACED DAMAGED SEAT TRACK SECTION FROM STA 500 - 690 LBL 45 IAW SRM 51305, FABRICATED FROM PN 60-6549/24 BATCH NR 1514987.
Back to JASC 5347