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 QXEA200400374Seat Track · corrodedPDX - SEAT TRACK 4 HAS CORROSION ON OB FLANGE FROM STATION X202 TO X210 AROUND RIVET HEADS. REPLACED NR 4 SEAT TRACK.SDR USAA040250Seat Track · corrodedSEAT TRACK, 5.45 INCH X 0.813 INCH X .047 INCH D, CORROSION, FR17 AT Y 1270, Z240. REMOVED AND REPLACED SEAT TRACK IAW SRM.SDR N150AW0004Seat Track · crackedSTATION 727B SEAT TRACK AT RBBL 24.82 OUTBOARD FLANGE AND SEAT TRACK AT RBBL 45.57 INBOARD AND OUTBOARD FLANGES HAVE A CRACK ON THE UPPER CHORD ON THE HORIZONTAL FREE FLANGE AT THE TRANSVERSE BEAM CONNECTION POINT. REPAIRED AREAS PER EA NR 53-085.SDR MALA040425Seat Track · corrodedDURING 4Y/2Y INSPECTION IN LCQ, FS 300 RT I/B SEAT TRACK CORRODED. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK AT FS 300 I/B IAW MESABA EO S53060. A/C RELEASE DATE 6/4/05.SDR MALA040424Seat Track · corrodedDURING 4Y/2Y INSPECTION IN LCQ, FS 300 LEFT I/B SEAT TRACK CORRODED. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK AT FS 300 I/B IAW MESABA EO S53060. A/C RELEASE DATE 6/4/05.SDR MALA040426Cargo Track · corrodedDURING 4Y/2Y INSPECTION IN LCQ, FS 630.112 CARGO COMPARTMENT CENTER SEAT TRACK CORRODED. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK AT FS 300 I/B IAW MESABA EO S53060. A/C RELEASE DATE 6/4/05.SDR QXEA200400384Seat Track · gougedPDX - RIGHT HAND OUTBOARD NUMBER 12 SEAT TRACK TOP FLANGE IS GOUGED AND PITTED AT STATION X518.0. REPAIRED IAW DHC-8 SRM 51-40-00 AND 51-40-11.SDR QXEA200400383Seat Track · damagedPDX - RIGHT HAND OUTBOARD NUMBER 11 SEAT TRACK AT STATION X438.0, TOP FLANGE IS SCRATCHED AND GOUGED. CHANNEL IS SCRATCHED. REPAIRED IAW DHC-8 SRM 51-40-00 AND 51-40-11.SDR 04FDEA01448Seat Track · corrodedUPPER FUSELAGE STA 1870 FR 28 I/B SIDE OF TRACK 5R UNDER FLOOR PANEL 232VH LEVEL 1 CORROSION 1.2 L X 1.0 INCH W. DEPTH UNDERMINE WITHOUT BLENDOUT, ALSO FR 29 LIGHT SURFACE CORROSION 1 EA AREA, BETWEEN FR 30 & 31, 1 EA AREA LIGHT SURFACE CORROSION, FR 38 AND FSDR 04FDEA01441Seat Track · corrodedSEAT TRACK 3R SECTION (10 INCHES FWD OF FR 74 TO JUST AFT OF FR 80/82) HAS 6 EA AREAS OF CORROSION INCLUDING ON AND UNDER SCALLOPS. 6 INCHES FWD OF FR 74, BETWEEN FR 74 AND FR 75, BETWEEN FR 75 AND 76, 1 INCH FWD OF FR 76, 1 INCH AFT OF FR 76, AND 7 INCHES AFSDR 04FDEA01440Seat Track · corrodedSEAT TRACK 3R (FROM 14 INCHES FWD OF FR 59 TO FR 69) HAS 5 EA AREAS OF CORROSION, INCLUDING ON AND UNDER SCALLOPS. 8 INCHES AFT OF FR 64, 10 INCHES FWD OF FR 65, 8 INCHES AFT OF FR 65, 6 INCHES FWD OF FR 65, AND 8 INCHES AFT OF FR 67. REMOVED SEAT TRACK FROMSDR QXEA200400382Seat Track · corrodedPDX - NR 4 SEAT TRACK HAS CORROSION ON OUTBOARD EDGE OF TRACK FLANGE AT STATION X226. REPAIRED IAW RD 8-53-1139, 8-53-1102, 8-53-4473 AND SRM 51-30-26 AND 51-40-11.SDR QXEA200400381Seat Track · corrodedPDX - NUMBER 8 SEAT TRACK HAS CORROSION ON INBOARD FLANGE FROM STATION X490 TO X496. REPAIRED IAW RD 8-53-1339, 8-53-4473 AND SRM 51-40-11.SDR 04FDEA01438Seat Track · corrodedMDCC ON L4 SEAT TRACK BETWEEN FR 40 TO 44, 4 EA SPOT OF CORROSION ON TOP INNER CHANNEL AND SIDE OF SEAT TRACK. REMOVED CORRODED SEAT TRACK, SPLICED IN NEW SECTION BETWEEN FRAMES 40 TO 44.5 IAW A300-600 SRM 53-10-16.SDR 04FDEA01437Seat Track · corrodedMDC AT FRAME 14B SEAT TRACK L2 HAS CORROSION. REMOVED FLOOR DRAIN PANS, REMOVED SEAT TRACK, DRILLED NEW SEAT TRACK, INSTALLED NEW SEAT TRACK AND REINSTALLED FLOOR DRAIN PANS IAW A300-600 SRM 51-72-10 AND 51-40-21.SDR 04FDEA01436Seat Track · corrodedMAIN DECK CARGO COMP, ONE EACH SPOT OF CORROSION BETWEEN FR 54 AND 54.1 ON SEAT TRACK L5. REMOVED AND REPLACED DUMMY SEAT TRACK IAW A300-600 SRM 51-72-10.SDR 04FDEA01431Seat Track · damagedCOMPLY WITH EA 8-5310-77410 FUSELAGE MAIN FRAME - MINOR DEVIATION TO SRM SEAT TRACK SPLICE. COMPLIED WITH EA 8-5310-77410.SDR 04FDEA01420Seat Track · corrodedSEAT TRACK 3R HAS FIVE AREAS OF CORROSION INCLUDING ON AND UNDER SCALLOPS. 2 INCHES FWD OF FR 74, BETWEEN FR 74 AND 75, 0.5 INCH AFT OF FR 75, BETWEEN FR 76 AND 77, AND 1 INCH AFT OF FR 77. BLENDED CORROSION AND FOUND TO BE OUT OF LIMITS AT ALL LOCATIONS. RSDR 04FDEA01419Seat Track · corrodedSEAT TRACK LBL 8.5 CORRODED AT STA 1119 TO STA 6-50. REMOVED AND REPAIR CARRIED OUT IAW SRM 53-70-00 FIG 1 VOL I.SDR 04FDEA01414Seat Track · crackedMAIN CARGO COMP SEAT TRACK HAS AREAS OF ELONGATED SCALLOPS FROM FS 1129-1530 LBL 8 AND IS CRACKED AT FS 1179 APPROX 4 INCHES LONG. NDT AT LBL 8 FS 1179 NO CRACK NOTED IAW NTSPM 06-10-01. BLENDED OUT DAMAGED AREAS AT LBL 8 FS 1129-1530 IAW SRM 53-70-00. STA SDR 04FDEA01409Seat Track · crackedMAIN CARGO AREA FS 925 SEAT TRACK RBL 47 EDGE IS CRACKED. REMOVED CRACKED SEAT TRACK SECTION, FABRICATED REPAIR PARTS, AND SLICE PLATES IAW DC10 SRM 53-70-00 VOL 1 AND INSTALLED IAW DC10 SRM 51-21-01 VOL 2 AND DC10 SRM 51-31-01 VOL 2.SDR 04FDEA01405Seat Track · crackedMAIN CARGO APPROX STATION 910 SEAT TRACK AT RBL 27 IS CRACKED. REMOVED CRACKED SEAT TRACK SECTION, LOCATED AND DRILLED REPAIR SECTION AND INSTALLED SEAT TRACK REPAIR IAW DC10-10 SRM 53-70-00 VOL 1 AND DC10-10 SRM 51-31-01 VOL 2.SDR 04FDEA01401Seat Track · incorrectSEAT TRACK ON WL 27R BETWEEN 615-670 MAIN UPPER CARGO HAS A BIG GAP TWO PLACES. REMOVED SEAT TRACK SECTION AND INSTALLED NEW TRACK SECTION IAW DC10 SRM 51-31-01 VOL 2 AND DC10 SRM 51-21-01 VOL 2.SDR 04FDEA01399Seat Track · crackedMAIN CARGO AREA STATION 925 SEAT TRACK AT LBL 47 EDGE IS CRACKED. CUT OUT DAMAGE SECTION OF TRACK, FABRICATED SEAT TRACK, SPLICE PLATE AND INSTALLED REPAIR PARTS IAW DC10 SRM 53-70-00 VOL 1 AND DC10 SRM 51-31-01 VOL 2.SDR 04FDEA01394Seat Track · corrodedMAIN DECK R1 DOOR WAY SEAT TRACK FOUND CORROSION AT STA 440 RT 86 INCHES. REMOVED IAW SRM 51-33-01 VOL II. NEW SEAT TRACK HOLES TRANSFERRED IAW SRM 51-31-01 VOL II, PROTECTED IAW SRM 51-21-01 VOL II AND INSTALLED IAW SRM 51-33-01 VOL II.SDR 04FDEA01393Seat Track · crackedMAIN DECK - SEAT TRACK FOUND CRACKED AT STA 902-914 RT 28 INCHES. REMOVED AT STA 459 TO STA 535 RBL 27.5 IAW SRM 51-33-01 VOL II, REPAIR TRACK FABRICATED AND INSTALLED IAW SRM 53-70-00 FIGURE 1 VOL I.SDR 04FDEA01390Seat Track · crackedSEAT TRACK FOUND CRACKED AT STA 902-914 RIGHT 28 INCHES. SEAT TRACK CUT AND REMOVED AT STA 869 TO STA 969 RBL 27.5 AND REPAIR CARRIED OUT IAW SRM 53-70-00 FIG 1 VOL I.SDR 04FDEA01386Seat Track · corrodedMAIN CABIN SEAT TRACK NR 3 RIGHT, BETWEEN FR 50-52, MULTIPLE SPOTS OF CORROSION ALONG SEAT TRACK HOLES AND BOTH SIDES OF FLANGE TOP TO BOTTOM AS MARKED. REMOVED SEAT TRACK, FABBED NEW SEAT TRACK, DRILLED AND REAMED HOLES, TREATED PRIMED AND TOP COATED, AND INSDR GTIA040529Seat Track · corrodedCABIN RT IB SEAT TRACK LT CORRODED AND WORN STA 200-1309. MATERIAL FOUND OUT OF LIMITS FROM STA 200 TO 267. REMOVED RT, IB SEAT TRACK. FABRICATED NEW SECTION SEAT TRACK. INSTALLED SEAT TRACK.SDR QXEA200400353Seat Track · corrodedPDX - SEAT TRACK 15 NEEDS REPLACED FOR CORROSION PITS. REPLACED IAW HORIZON AIR EA 6-53-356.SDR QXEA200400335Seat Track · corrodedPDX - SEAT TRACK NR 9 AT STATION X778.5 HAS SURFACE CORROSION IN CHANNEL. REPAIRED IAW HORIZON AIR EA 6-53-356.SDR QXEA200400333Seat Track · corrodedPDX - SEAT TRACK NR 9 AT STATION X778.5 HAS SURFACE CORROSION IN CHANNEL. REPAIRED IAW HORIZON AIR EA 6-53-356.SDR C1HA200492002Seat Track · corrodedSEAT TRACK CORROSION.SDR C1HA200492003Seat Track · corrodedSEAT TRACK CORROSION.SDR ASAA0480427Seat Track · corrodedOKC - DURING HV CHECK - FOUND SEAT TRACK AT STATION 200-237, RBL 22 IS CORRODED. REMOVED DAMAGE AND INSTALLED REPLACEMENT SECTION IAW 51-10-4. (M)SDR UPS04542532Seat Track · corrodedINSPECTION TYPE: C3, CORROSION SEAT TRACK BS 880-895 LBL 46 HAS MECHANICAL DAMAGE AND CORROSION. REMOVED CORRODED AND DAMAGED SEAT TRACK, AND REPLACED WITH FABRICATED SEAT TRACK.SDR ASAA0480417Seat Track · corrodedOKC - DURING HV CHECK, FOUND CABIN SEAT TRACK AT STATION 200-237, RBL 44 IS CORRODED. REMOVED DAMAGED SECTION AND INSTALLED REPAIR SECTION IAW 53-05. (M)SDR AWXA200400568Seat Track · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK EXFOLIATION CORROSION WAS FOUND ON FORWARD END OF SEAT TRACK Y1292 AT FR 20. MAINTENANCE REMOVED CORRODED SEAT TRACK Y1292 FROM FR 12 TO FR 24; INSTALLED NEW REPLACEMENT SEAT TRACK IAW A319 SRM 51-72-11 PG 1 & 2.SDR 0400775515Seat Track · corrodedDURING AN H-CHECK FOUND CORROSION ON SEAT TRACK SUPPORT BEAM AT BS 377 RBL 46. REPAIRED IAW EA 198879.SDR UPS04842541Seat Track · corrodedINSPECTION TYPE:C-2, MAIN CABIN FS AT 995 SEAT TRACK -E- HAS CORROSION BETWEEN LUGS. REMOVED CORROSON FOUND TO BE OUT OF LIMITS. REMOVED FLOORBOARD 1000 TO 1060. CUT SEAT TRACK FROM STA 830 TO 1100 IAW EO DC8 5320517C DWG DC8 53B 003. MAT ID SEAT TRACK 277SDR UPS04842449Seat Track · corrodedINSPECTION TYPE:C-2 MAIN CABIN FS AT 995 SEAT TRACK "E" HAS CORROSION BETWEEN LUGS. REMOVED CORROSION FOUND TO BE OUT OF LIMITS. CUT SEAT TRACK EO DC8-5320-5167C DWG DC8-53B-003. LOCATED, DRILL AND DEBURRED SEAT TRACK PLUS 2 SPLICE FITTING SEAT TRACK. ALODINESDR 04FDEA01265Seat Track · crackedMAIN CABIN SEAT TRACK LBL 27 FS 1119 IS CRACKED. REPLACED SEAT TRACK IAW SRM 53-70-00 AT MAE.SDR 04FDEA01256Seat Track · gougedMAIN CARGO DECK SEAT TRACK GOUGED AT LBL 47.25 FS 1740. REMOVED AND REPLACED DAMAGED TRACK AT FS 1740 LBL 47.25 IAW SRM 53-70-00 FIG 1 & 51-31-01 AT MAE.SDR CALA0400490Seat Track · corrodedINSPECTION FOUND LEFT I/B SEAT TRACK CORRODED AT GALLEY MOUNTS, STA 1174 AND 1212. REMOVED AND REPLACED SEAT TRACK SECTION IAW SRM 53-05.SDR GTIA040519Seat Track · corrodedCABIN RT OB SEAT TRACK LT CORRODED AND WORN. RT OB SEAT TRACK FROM STA 200 TO 300 OUT OF LIMITS. REMOVED SEAT TRACK. LOCATED AND DRILLED HOLES FOR SEAT TRACK FROM STA 200 TO 300 RT OB. INSTALLED NEW SEAT TRACK SECTION.SDR GTIA040530Seat Track · corrodedLT OB CABIN SEAT TRACK LT CORRODED AND WORN STA 200-1309. OUT OF LIMITS FROM STA 200-300 AND 1030-1206. REMOVED LT OB SEAT TRACK STA 1030 TO 1206. INSTALLED LT OB SEAT TRACK STA 200 TO 300. FABRICATED SEAT TRACK LT OB STA 1030-1206. REMOVED LT OB SEAT TRASDR 04FDEA01236Seat Track · dentedMAIN CARGO DECK STA 810 LEFT HAND SEAT TRACK REF X=27.5 SEAT TRACK DENTED. DENTED SEAT TRACK AT MAIN CARGO DECK STA 810 LEFT HAND SIDE X=27.5 REPAIRED AS PER SRM 53-70-00 FIG 1 VOL I.SDR GTIA040544Seat Track · wornCABIN RT MIDDLE SEAT TRACK WORN AND CORRODED STA 200-1307. MATERIAL LOSS ON RT MIDDLE SEAT TRACK STA 937-1033 OUT OF LIMITS. REMOVED RT MIDDLE SEAT TRACK. LOCATED AND DRILLED RT MIDDLE REPLACEMENT SEAT TRACK STA 937-1033 AND SPLICE. INSTALLED RTMIDDLE SEATSDR GTIA040542Seat Track · wornCABIN LT IB SEAT TRACK WORN AND CORRODED STA 200-1307. STA 935 TO 1117 AND STA 1200 OUT OF LIMITS. REMOVED SEAT TRACK AND SPLICES STA 915-1090 AND 1184-1221. INSTALLED SEAT TRACK AND SPLICES STA 1184-1221. INSTALLED SEAT TRACK AND SPLICES STA 915-1090.SDR UPS04242433Seat Track · corrodedINSPECTION TYPE:C CORROSION ON SEAT TRACK FLANGE AT BS 495, RBL 62.5. REPAIRED IAW SRM 53-10-5, FIG 1.
Back to JASC 5347