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 HALA0700463Seat Track · corrodedLEVEL 2 CORROSION ON SEAT TRACK RBL 88.5 STATION 650 TO 654+44. REPLACED SEAT TRACK PER SRM 51-40-02.SDR USAA920071067Seat Track · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED VERTICAL LEG OF SEAT TRACK, BS 673, LBL 24. REPAIRED CRACKED VERTICAL LEG OF SEAT TRACK, BS 673, LBL 24 IAW USAIRWAYS EA 98938.SDR HALA0700480Seat Track · corrodedSEAT TRACKS CORRODED IN SECTION 46 RBL 88.5, STA 1102 THRU 1439. REPLACED SEAT TRACK FROM STA 1102 TO STA 1439 RBL 88.5 AND RBL 11, STA 1197+37.SDR QXEA200701699Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION IN CHANNEL AND ON TOP OF RAIL AT STATION X479. REPAIRED IAW RD8/4-53-884.SDR QXEA200701698Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION IN CHANNEL AT STATION X558. REPAIRED IAW RD8/4-53-884.SDR QXEA200101697Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION IN CHANNEL AND ON TOP OF RAIL BETWEEN STATION X433 AND X435. REPAIRED IAW RD8/4-53-884.SDR QXEA200701696Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION IN CHANNEL BETWEEN STATION X417 AND X420. REPAIRED IAW RD8/4-53-884.SDR QXEA200701695Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION IN CHANNEL AND ON TOP OF RAIL BETWEEN STATION X403 AND X405. REPAIRED IAW RD8/4-53-884.SDR QXEA200701694Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION WITH PITS IN CHANNEL AND LIGHT CORROSION ON TOP OF RAIL BETWEEN STATION X385 AND X389. REPAIRED IAW RD8/4-53-884.SDR QXEA200701693Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION IN CHANNEL BETWEEN STATION X372 AND X374. REPAIRED IAW RD8/4-53-884.SDR QXEA200701692Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION IN CHANNEL AND ON RAIL BETWEEN STATION X350 AND X359. REPAIRED IAW RD8/4-53-884.SDR QXEA200701691Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION IN CHANNEL AND ON TOP OF RAILS AT STATION X342. REPAIRED IAW RD8/4-53-884.SDR QXEA200701690Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION IN BOTTOM OF CHANNEL BETWEEN STATION X323 AND X327. REPAIRED IAW RD8/4-53-884.SDR QXEA200701688Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION IN BOTTOM OF CHANNEL BETWEEN STATION X292 AND X296. REPAIRED IAW RD8/4-53-884.SDR QXEA200701687Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION IN BOTTOM OF CHANNEL AND ON TOP OF RAILS AT STATION X290. REPAIRED IAW RD8/4-53-884.SDR QXEA200701689Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION IN BOTTOM OF CHANNEL AND ON TOP OF RAILS AT STATION X321. REPAIRED IAW RD8/4-53-884.SDR QXEA200701684Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION IN BOTTOM OF CHANNEL AT STATION X127. REPAIRED IAW RD8/4-53-884.SDR QXEA200701686Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION IN CHANNEL AND ON TOP OF RAILS BETWEEN X230 AND X235. REPAIRED IAW RD8/4-83-884.SDR QXEA200701685Seat Track · corrodedC2 PDX - RIGHT OUTBOARD SEAT TRACK HAS LIGHT CORROSION IN BOTTOM OF CHANNEL BETWEEN STATION X137 AND X141. REPAIRED IAW RD8/4-53-884.SDR QXEA200701681Seat Track · corrodedC2 PDX - RIGHT INBOARD SEAT TRACK NR 11 HAS CORROSION AT STATION +32.400. REPAIRED IAW SRM 51-42-05, 51-40-20.SDR QXEA200701665Seat Track · corrodedC2 PDX - RIGHT INBOARD SEAT TRACK NR 11 HAS CORROSION AT STATION 47.975. REPAIRED IAW RD8/4-53-884.SDR QXEA200701664Seat Track · corrodedC2 PDX - RIGHT INBOARD SEAT TRACK NR 10 HAS CORROSION AT STATION 1.00. REPAIRED IAW RD8/4-53-884 AND SRM 51-42-05.SDR DLM90071428Seat Track · corrodedCABIN SEAT TRACK CORRODED OUT OF LIMITS FS 237 RBL 24. REPAIRED CABIN SEAT TRACK IAW MD-90 SRM 53-40-01 FIG B VOL I ON N/R 2700-0207 AT HMV-2 IN OKC.SDR DLM90071426Seat Track · corrodedCABIN SEAT TRACK CORRODED OUT OF LIMITS FS 455-530 LBL 24. REPAIR SEAT TRACK IAW MD-90 SRM 53-40-01 FIG 6 VOL II ON N/R 2700-0209 AT HMV-2 IN OKC.SDR HALA0700461Seat Track · corrodedLEVEL 2 CORROSION SEAT TRACK AT LBL88.5 STATION 955-958 CORROSION BLEND OUT BEYOND SRM LIMITS. REMOVED DAMAGED SEAT TRACK IAW SRM 53-00-52 FIG 201 REPAIR 3 FROM STATION 922-989.SDR UPS07M51258Seat Track · corrodedINSPECTION TYPE:C CABIN - CORROSION ON SEAT TRACK CROWN & CHANNEL AT STA 999-1079. CORROSION REMOVED PER SRM 51-21-01 VII R35. ORG THK: 0.100", MATL REMN: 0.047" (CHANNEL). FOUND EXCEED LIMIT. DAMAGED SEAT TRACK SECTIONAL CUT OUT BETWEEN STA 969 - STA 1089SDR TRAX200701629Seat Track · corrodedETNRC-200-120 SEAT TRACK LT I/B BTW FR 29 AND 39 CORRODED, (RESOLVED ON W/O: 74559 TASKCARD: N/R-0018). REMOVED CORROSION ON SEAT TRACK LT I/B BTW FR 29 AND FR 39 AS PER SRM 53-00-00. FABRICATION COVERED ON W/C 2000-203 SEAT TRACK. REPLACED IAW SRM 51-25-04SDR HALA0700482Seat Track · corrodedCORROSION AROUND SEAT TRACK LBL 11, STATION 656+21 TO STATION 656+32. REPLACE SEAT TRACK AT LBL 11, STATION 656+21 TO STATION 656+32.SDR HALA070071Seat Track · corrodedLEVEL 1 CORROSION ON SEAT TRACK AT RBL 11 STAT 654+13 TO 654+18. REMOVED CORROSION IAW 767 SRM 51-10-02 WITHIN LIMITS OF SRM 53-00-52/101.SDR TRAX200701628Seat Track · corrodedSEAT TRACK LEFT O/B BETWEEN FR 29 & 39 CORRODED. REMOVED CORROSION ON SEAT TRACK LT O/B BTW FR 29+39 AS PER SRM 51-21-42 AND IS WITHIN LIMITS AS PER SRM 53-00-00 MATERIAL THICKNESS: 0.083 MATERIAL REMOVED: 0.013 WITHIN LIMITS AS PER SRM: 53-00-00 FIG 304.SDR TRAX200701626Seat Track · corrodedSEAT TRACK RIGHT O/B BETWEEN FR 29 & 39 CORRODED. CORROSION REMOVED IAW SRM 51-21-42 AND IT IS WITHIN LIMIT AS PER SRM 53-00-00 FIG 304 MATERIAL THICKNESS: 0.053 MATERIAL REMOVED: 0.008 WITHIN LIMITS AS PER SRM: 53-00-00 FIG 304.SDR TRAX200701624Seat Track · corrodedRIGHT SEAT TRACK BETWEEN FR 39 & 40 CORRODED. RT SEAT TRACK BTW FR 39-40 CORROSION REMOVED IAW SRM 51-21-42 BUT IT IS OUT OF LIMIT AS PER SRM 53-00-00 FIG 304 NEW SEAT TRACK FABRICATED COVER ON W/C 2000-171 INSTALLED ON RT BTW FR 39 AND 40 IAW SRM 51-25-04 MASDR TRAX200701623Seat Track · corrodedLEFT SEAT TRACK BETWEEN FR 36 & 37 CORRODED.SDR TRAX200701622Seat Track · corrodedRIGHT SEAT TRACK BETWEEN FR 41 & 44 CORRODED. RT SEAT TRACK BTW FR 41-44 CORROSION REMOVED IAW SRM 51-21-42 AND IT IS WITHIN LIMIT AS PER SRM 3-00-00 FIG 304 MATERIAL THICKNESS: 0.083 MATERIAL REMOVED: 0.007 WITHIN LIMITS AS PER SRM: 53-00-00 FIG 304.SDR DLM90071395Seat Track · corrodedCABIN SEAT TRACK CORRODED OUT OF LIMITS FS 705 LBL 24. REMOVED AND REPLACED SEAT TRACK FS 705 LBL 24 PER SRM 53-40-01 VOL II ON N/R 2700-0210 AT HMV-2 IN OKC.SDR TRAX200701627Seat Track · corrodedSEAT TRACK RIGHT I/B BETWEEN FR 29 & 39 CORRODED. REMOVED CORROSION AS PER SRM 51-21-42 AND IS OUT OF LIMITS AS PER SRM 53-00-00 PART FABRICATED ON W/C 2000-210 SEAT TRACK REPAIRED IAW SRM 53-00-00 FIG 434 MATERIAL THICKNESS: 0.083 MATERIAL REMOVED: 0.062 OSDR MWEA070265Seat Track · corrodedCABIN FLOOR SEAT TRACK NR 4 FROM LEFT STATION 237-260 UNDER FLOOR PANEL SEAT TRACK HAS CORROSION. REMOVED DAMAGE SEAT TRACK AND INSTALLED NEW SEAT TRACK.SDR DLM90071505Seat Track · corrodedLT SEAT TRACK CORRODED 1255-1364 LBL 24. REPAIRED SEAT TRACK IAW MD-90 SRM 53-40-01 VOL I ON N/R 2000-0238 AT HMV-2 IN OKC.SDR WRLA2007117Cargo Track · damagedMAIN DECK CARGO SEAT TRACK DAMAGED STA Y=635 X=47.50. REPLACED SEAT TRACK REF SRM 53-70-00 FIG 1 REV 40.SDR WRLA2007116Seat Track · damagedMAIN DECK CARGO SEAT TRACK DAMAGED STA Y=635 X=27.50. REPLACED SEAT TRACK REF SRM 53-70-00 FIG1 REV 40.SDR UPS07M51223Seat Track · corrodedINSPECTION TYPE:C CABIN, CORROSION ON SEAT TRACK CROWN AND CHANNEL AT STA 902 X=27. CORROSION ON SEAT TRACK SECTIONAL TRIM OUT BTWN STA830 - 909, X=27 AND REMOVED PER SRM 51-31-01 VIIR 35. HFEC INSP C/O PER DAC NDTSPM R13 06-10-01.001 ON TRIM OUT AREA AND FSDR UPS07M51204Seat Track · corrodedINSPECTION TYPE:C CABIN, CORROSION ON SEAT TRACK FLANGE FROM STA 806-840 X=-75. REMOVED PER SRM 51-21-01VIIR35. ORG THK:0.100", MATL REMN: 0.040", EXCEED LMT PER SRM 53-70-00VI FIG 3 R35. CORROSION SEAT TRACK REMOVED PER SRM 51-31-01VIIR35. NEW SEAT TRACK RSDR QXEA200701603Seat Track · corrodedC4 PDX - CENTER SEAT TRACK NR 15 HAS CORROSION IN CENTER AND EDGES OF TRACK AT STATION FS 485, 493, 509, 525, AND 541. REPAIRED IAW AMM 53-00-49-000-0801-A01.SDR 07FDEA04690Seat Track · corrodedAFT CARGO COMPT SEVERE EXFOLIATION CORROSION ON SEAT TRACK. REPAIRED SEAT TRACK SECTION IAW SRM 53-70-00 VOL I FIG 1.SDR FDEA200710254685Seat Track · corrodedMAIN CABIN ENTRY WAY SEVERE CORROSION ON SEAT TRACK. REPAIRED SEAT TRACK IAW SRM 53-70-00 FIG 1 VOL I.SDR HALA0700483Seat Track · corrodedCORROSION FOUND AT 3S 654+120 LBL 22. SEAT TRACK SECTION REPLACED IAW SRM 51-40-02.SDR HALA0700481Seat Track · corrodedCORROSION AROUND SEAT TRACK ATTACH FLANGE AT STA 654 + 88 TO 118. REPLACED SEAT TRACK.SDR 2007UALA04399Seat Track · wornRIGHT INBOARD SEAT TRACK BETWEEN FRAME 36 & 41 IS WORN OUT OF LIMITS. REPLACED SEAT TRACK.SDR 07FDEA04685Seat Track · corrodedMAIN CABIN ENTRY WAY SEVERE CORROSION ON SEAT TRACK.SDR 07FDEA04684Seat Track · wornMAIN CABIN ON SEAT TRACK FOUND DEEP WEAR. REPAIRED SEAT TRACK IAW SRM 53-70-00 FIG 1 VOL I.
Back to JASC 5347