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 GTIA011045Seat Track · corrodedFTW - FOUND SEAT TRACK CORRODED FROM STATION Y199 TO STATION Y230, X45 INCHES. REMOVED CORROSION ON SEAT TRACK FROM STATION 199-230 BY 45 INCHES CORROSION REMOVAL OUT OF LIMITS IAW MD80 SRM 53-05. REMOVED SEAT TRACK AT FS 199 FS 230 IAW MD80 SRM 51-30-2. INSSDR UPS01036708Seat Track · damagedINSPECTION TYPE:C2 CABIN SEAT TRACK G BETWEEN PALLET POSITION 7 & 8 SEVERAL SCALLOPS HAVE ELONGATED HOLES. SEAT TRACK OUT OF LIMITS IAW DC8 SRM 53-2-3 FIG 12. REMOVED DAMAGED SCALLOP SECTIONS IAW DC8 SRM 53-2-3 FIG 6D. INSTALLED PLUGS AND CHANNELS IAW DC8 SRMSDR QXEA0101366Seat Track · corrodedPDX-SEAT TRACK NR 1 CORRODED ON TOP INBOARD AT STATION 422. REPAIRED IAW DHC-8 RD8-53-1342, SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0101365Seat Track · corrodedPDX-SEAT TRACK NR 1 CORRODED ON INSIDE CENTER AT STATION 407. REPAIRED IAW DHC-8 RD8-53-1342, SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0101364Seat Track · corrodedPDX-SEAT TRACK NR 1 CORRODED ON TOP INBOARD AND OUTBOARD AT STATION 392. REPAIRED IAW DHC-8 RD8-53-1342, SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0101363Seat Track · corrodedPDX-SEAT TRACK NR 1 CORRODED ON TOP INBOARD AT STATION 361. REPAIRED IAW DHC-8 RD8-53-1342, SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0101362Seat Track · corrodedPDX-SEAT TRACK NR 1 CORRODED ON TOP INBOARD AT STATION 328. REPAIRED IAW DHC-8 RD8-53-1342, SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0101361Seat Track · corrodedPDX-SEAT TRACK NR 1 CORRODED ON TOP INBOARD AT STATION 282. REPAIRED IAW DHC-8 RD8-53-1342, SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0101360Seat Track · corrodedPDX-SEAT TRACK NR 1 CORRODED ON TOP INBOARD AND OUTBOARD AT STATION 275. REPAIRED IAW DHC-8 RD8-53-1342, SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0101398Seat Track · corrodedPDX - SEAT TRACK NR 8 CORRODED ON TOP INBOARD AND OUTBOARD AT STATION 518. REPAIRED IAW DHC8 RD 8-53-1339.SDR QXEA0101392Seat Track · chafedPDX - SEAT TRACK NR 3 CHAFED ON TOP CENTER AT STATION 542. REPAIRED IAW DHC8/202 SRM 51-20-16 AND SRM 51-20-41.SDR AWXA0002175Seat Track · corrodedFR 20 Y-754 RT SEAT TRACK CORRODED. REPLACED SEAT TRACK/FLOOR SUPPORT RAIL AS PER SRM 53-11-14 PG 37 AND DWG D53110858.SDR DHL2001804540Seat Track · wornMAIN CARGO COMPT 1-LT FLOOR TRACK LUG WORN STA 1580. TRIMMED OUT DAMAGED AREA OF FLOOR TRACK PER SRM 53-2-3 PG 17-19. FABRICATED TRACK PLUG (P/N 52772660) PER SRM 53-2-3 PG 17-19. INSTALLED TRACK PLUG PER SRM 53-2-3 PG 17-19.SDR AWXA0002163Seat Track · corrodedFR 20 Y -754 RT SEAT TRACK CORRODED. REPLACED SEAT TRACK/FLOOR SUPPORT RAIL AS PER SRM 53-11-14 PG 37 AND DWG D53110858.SDR P2EA01163Cargo Track · corrodedDURING Q-CHECK, FOUND FORWARD CARGO COMPARTMENT FROM BS 380 TO BS 520 LBL 18.5, CARGO TRACK WITH CORROSION. (M)SDR SIMA200123411Seat Track · corrodedSAW - DURING CPCP2 INSPECTION, FOUND CORROSION WAS FOUND ON SEAT TRACKS, LEFT AFT OUTBOARD, LEFT AFT INBOARD, LEFT F/A, RIGHT F/A. THE SEAT TRACKS WERE REMOVED AND REPLACED IAW ATR 72 SRM 51-25-04 AND AMERICAN EAGLE ENGINEERING ORDER E2-53MR-115. THE AIRCRAFSDR 2001F00398Seat Track · corrodedSBP - DURING MBV INSPECTION, MAINTENANCE FOUND THE RIGHT GALLEY TRACK IS CORRODED. REMOVED AND REPLACED GALLEY TRACK AND PROFILE IAW SAAB SRM 51-40-40, 51-40-21, AND 51-40-22. REF SIMA200123404. (M)SDR AWXA0002173Seat Track · corrodedFR 20 Y765 LT SEAT TRACK CORRODED. REPLACED SEAT TRACK NR 1 FROM FR 16 TO 20 AS PER SRM 53-11-15 PAGE 6.SDR AWXA0002110Seat Track · corrodedFR Y765 LT SEAT TRACK CORRODED. REPLACED SEAT TRACK NR 1 FROM FR 16 TO FR 20 AS PER SRM 53-11-15 PAGE 6.SDR GTIA011068Seat Track · damagedFTW - FOUND SEAT TRACK RIGHT INBOARD GOUGED AND PITTED. REMOVED AND SEAT TRACK. FABRICATED, DRILLED AND LOCATED SEAT TRACK. INSTALLED SEAT TRACK IAW MD80 SRM 53-04. (M)SDR AALA20011613Seat Track · corrodedTUL - FOUND RIGHT SEAT TRACK C (3RD FROM R-2 DOOR) HAS CORROSION TOP SIDE, FRAME 30 TO FRAME 33. REPLACED RIGHT SEAT TRACK C PER SRM 51-72-10-0. (M)SDR DHL2001804524Seat Track · wornMAIN CARGO COMPT CTR FLOOR TRACK LUG WORN AT STA 70.00. CUT OUT DAMAGED LUG AT MAIN CARGO COMPT CTR FLOOR TRACK STA 70.00 IAW SRM 53-2-3 PG 17-19. FABRICATED TRACK PLUG (P/N 52772660) IAW 57-2-3 PG 17-19. INSTALLED CTR FLOOR TRACK PLUG AT MAIN CARGO COMPT STSDR DHL2001804525Seat Track · wornMAIN CARGO COMPT 2 LT FLOOR TRACK LUG WORN AT STA 220.00. CUT OUT DAMAGED LUG AT MAIN CARGO COMPT NR 2 LT FLOOR TRACK STA 220.00 IAW SRM 53-2-3 PG 17-19. FABRICATED TRACK PLUG (P/N S2772660) IAW 57-2-3 PG 17-19. INSTALLED CTR FLOOR TRACK PLUG AT MAIN CARGOSDR UPS01836714Seat Track · corrodedINSPECTION TYPE:C2,3 STA 1030-1080 LBL 24 SEAT TRACK IS CORRODED BEYOND LIMITS. REPAIRED SEAT TRACK IAW SRM 53-2-3 FIG 8A.SDR UPS01836713Seat Track · corrodedINSPECTION TYPE:C2,3 STA 1030-1080 SEAT TRACK IS CORRODED BEYOND LIMITS. REPAIRED SEAT TRACK IAW SRM 53-2-3 FIG 8A.SDR SCNA01352Seat Track · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS ON THE SEAT TRACK AT STA 1020 TO 1028 LBL 56. REMOVED CORROSION IAW B727 SRM 511006. REMOVED DAMAGED AREA IAW B727 SRM 513002. FABRICATED NEW SEAT TRACK PER SAMPLE. INSTALLED IAW B727 SRSDR SCNA01349Seat Track · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS ON THE SEAT TRACK AT STA 1020 TO 1060 LBL 36. REMOVED CORROSION IAW B727 SRM 511006. REMOVED DAMAGED AREA IAW B727 SRM 513002. FABRICATED NEW SEAT TRACK PER SAMPLE. INSTALLED IAW B727 SRSDR DHL2001804527Seat Track · brokenCOCKPIT F/E FWD & AFT SEAT TRACKS BROKEN. REMOVED BROKEN SEAT TRACKS IAW SRM 51-8-0 PAR 1. INSTALLED NEW SEAT TRACKS IAW SRM 51-8-0.SDR MWEA011110Seat Track · corrodedNR 3 SEAT TRACK CORRODED STATION 200-206. REMOVED CORROSION, FABRICATED AND INSTALLED NEW SECTION OF SEAT TRACK.SDR MWEA011109Seat Track · corrodedNR 4 SEAT TRACK IS CORRODED AND HAS SOME TOOL MARKS STATION 218-237. REMOVED CORROSION, FABRICATED, LOCATED, DRILLED AND INSTALLED NEW SECTION OF SEAT TRACK.SDR 2001UALA01654Seat Track · corrodedBS 347 RBL 50 SEAT TRACK CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SEAT TRACK REPAIR.SDR 2001UALA01653Seat Track · corrodedBS 808 - 860 RBL 55 SEAT TRACK CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW SEAT TRACK.SDR 2001UALA01651Seat Track · corrodedBS 1307-1310 STR 37R SPLICE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW SEAT TRACK.SDR SCNA01347Seat Track · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS ON THE SEAT TRACK AT STA 4380 TO 480 RBL 24. REMOVED CORROSION IAW B727 SRM 511006. REMOVED DAMAGED AREA IAW B727 513002. FABRICATED NEW SEAT TRACK PER SAMPLE. INSTALLED IAW B727 SRM 513SDR SCNA01348Seat Track · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS ON THE SEAT TRACK AT STA 344 TO 480 RBL 42. REMOVED CORROSION IAW B727 SRM 511006. REMOVED DAMAGED AREA IAW B727 SRM 513002. FABRICATED NEW SEAT TRACK PER SAMPLE. INSTALLED IAW B727 SRM 5SDR SCNA01346Seat Track · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS ON THE SEAT TRACK AT STA 1070 THOUGH 1090 LBL 48. REMOVED CORROSION IAW B727 SRM 511006. REMOVED DAMAGED SECTION IAW B727 SRM 513002. FABRICATED NEW SEAT TRACK SECTION PER SAMPLE. INSTALLSDR SCNA01345Seat Track · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS ON THE SEAT TRACK AT STA 1070 THROUGH 1110 LBL 24. REMOVED CORROSION IAW B727 SRM 511006. REMOVED DAMAGED AREA IAW B727 SRM 513002. FABRICATED NEW SEAT TRACK PER SAMPLE. INSTALLED IAW BSDR SCNA01344Seat Track · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS ON THE SEAT TRACK AT STA 1090 THROUGH 1110 RBL 24. REMOVED CORROSION IAW B727 SRM 511006. REMOVED DAMAGED AREA IAW B727 SRM 513002. FABRICATED NEW SEAT TRACK PER SAMPLE. INSTALLED IAW B7SDR RRXA11455Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CABIN SEAT TRACK HAS CORROSION AT STA FS 610 AT RBL 48. REPAIRED SEAT TRACK IAW DC8 SRM 53-23 FIG 8A.SDR GAIA01280STFitting · crackedDURING AN LTC INSPECTION, IT WAS DISCOVERED CARGO TIE DOWN FITTING CRACKED BS 620, RBL 24, FORWARD CARGO PIT. ACCOMPLISHED CARGO TIE DOWN FITTING REPLACEMENT IAW B727 SRM 51-30-2. (M)SDR GAIA01288STSeat Track · corrodedDURING AN LTC INSPECTION, IT WAS DISCOVERED SEAT TRACK AT RBL 24.75 IS CORRODED FROM BS 480-520 AND CHAFFED UNDER PALLET LOCK LOCATION BS 610-625. ACCOMPLISHED SEAT TRACK REPAIR IAW B727 SRM 53-10-5 FIG 1. (M)SDR QXEA0101316Seat Track · nickedPDX - RIGHT HAND INBOARD SEAT TRACK TOP FLANGE HAS NICKS WITH RAISED METAL AT STATION 352 Y9.25 RIGHT. REPAIRED IAW DHC-8 SRM 51-40-11, RD 8-53-3403 AND HORIZON AIR EA 2-53-314.SDR QXEA0101372Seat Track · corrodedPDX-CORROSION IN AND AROUND NUTPLATES ON LEFT HAND INBOARD SEAT TRACK AT STATION X182.0-X190.9. REPAIRED IAW DHC-8 SRM 51-00-06.SDR QXEA0101320Seat Track · corrodedPDX - CORROSION IN AND AROUND NUT PLATES ON LEFT-HAND INBOARD SEAT TRACK AT STATION X182.0 TO X190.9. REPAIRED IAW DHC-8 CPM 5-2 THROUGH 5-7 AND CPM 5-47.SDR 2001UALA01600Seat Track · corrodedAFT CABIN RT FLOOR SECTION OF SEAT TRACK AT BS 986 - BS 1016, RBL 39 HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. REPLACED SEAT TRACK.SDR SWIA200110183Seat Track · corrodedRIGHT REAR SIDEWALL TRACK IS CORRODED.REMOVED AND REPLACED RIGHT REAR SIDEWALL SEAT TRACK WITH NEW PART IAW 53-01-05.P/N: 120-15996-005.SDR SWIA200110182Seat Track · corrodedRIGHT REAR FLOOR TRACK IS CORRODED.REMOVED AND REPLACED RIGHT REAR FLOOR SEAT TRACK WITH NEW PART IAW 53-01-05.P/N: 120-26865-005SDR SWIA200110181Seat Track · corrodedLEFT REAR FLOOR TRACK IS CORRODED.REMOVED AND REPLACED LEFT REAR FLOOR SEAT TRACK WITH NEW PART IAW 53-01-05.P/N: 120-26863-605SDR SWIA200110180Seat Track · corrodedLEFT REAR SIDEWALL SEAT TRACK IS CORRODED.REMOVED AND REPLACED LEFT REAR SIDEWALL SEAT TRACK WITH NEW PART IAW 53-01-05.P/N: 120-26865-005SDR 2002F00698Seat Track · damagedFOUND MAIN CABIN FLOOR SEAT TRACK DAMAGED AT BS 640, RBL 24. (M)
Back to JASC 5347