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 DHL2001803523Seat Track · wornMAIN CARGO COMPT - LUGS WORN ON L/H # 1 TRACK AT STA 1570-1710.CUR OUT DAMAGED TRACK AT MAIN CARGO COMPT, STA 1530.000 - 1710.000 PER SRM 53-2-3 PG 1&2.CLEANED , TREATED AND PRIMED AREA PER SRN 51-1-8B.INSTALLED NEW TRACK PER SRM 53-2-3 PG 1 & 2SDR 2001UALA01249Seat Track · corrodedBS 355 RT SEAT TRACK CORRODED. *S/D* FABRICATED AND INSTALLED SEAT TRACK IN ACCORDANCE WITH BAC DWG 141T5121 N-R. MAJOR REPAIR.SDR 2001UALA01225Seat Track · corrodedBS 1197-1351 LBL 88 A SEAT TRACK CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 146T5214 AAND SRM 53-00-52 N-R. MAJOR REPAIR.SDR MALA010553Seat Track · corrodedFOUND DURING 4K-CHECK IN CWA, FOUND CORROSION IN CARGO SEAT TRACK BL 0 BETWEEN STA 640 - 687. MAINTENANCE REMOVED AND REPLACED SEAT TRACK SECTION IAW EO S53060, BETWEEN STA 619 - 687.SDR CALA0100595Seat Track · corrodedINSPECTION FOUND MAIN CABIN SEAT TRACK CORRODED AT FS 1070-1203, LBL 25. THE CORRODED SECTION OF SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 53-05, FIGURE 4, 51-10-4, AND 51-10-3.SDR DHL2001727526Seat Track · wornCABIN FLOOR SEAT TRACK HAS WORN AREAS BETWEEN BS 504 TO 51B LBL 46. REMOVED SEAT TRACK AT CABIN FLOOR BETWEEN BS 480-560 LBL 46 PER SRM 51-30-2. FABRICATED NEW SEAT TRACK PER SRM 53-10-5. INSTALLED NEW SEAT TRACK PER SRM 53-10-5 FIG 7.SDR CALA0100589Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT FS 1097-1215, LBL 45. THE SEAT TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-30-2, 51-10-4, AND 51-10-3.SDR 0102466306Seat Track · corrodedIn H check, found corrosion on seat track. Repaired per EA63-184052.SDR 2001UALA01157Seat Track · corrodedBS 1249 LBL 11 SEAT TRACK CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH SRM 53-00-52 AND 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01143Seat Track · corrodedBS 933 RBL 88 SEAT TRACK CORRODED.SDR QXEA0101097Seat Track · corrodedPDX - NR 7 SEAT TRACK REQUIRES REPLACEMENT FOR NUMEROUS DISPCREPANCIES. REPLACED NR 7 SEAT TRACK IAW DHC-8 SRM 51-40-11.SDR 2001UALA01104Seat Track · corrodedBS 1285 - 1307 SEAT TRACK CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH SRM 53-00-52 AND 51-40-02 N-R. MAJOR REPAIR.SDR QXEA0101098Seat Track · damagedPDX - NR 4 SEAT TRACK REQUIRES REPLACEMENT FOR NUMEROUS DISCREPANCIES. REPLACED NR 4 SEAT TRACK IAW DHC-8 SRM 51-40-11.SDR 0102456306Seat Track · corrodedIn H check, found corrosion on seat track. Repaired per EA63-182725.SDR QXEA0101095Seat Track · corrodedPDX - RIGHT-HAND INBOARD SEAT TRACK AT STATION 597.500 HAS PITTING CORROSION AROUND SCREW HOLES. REPAIRED IAW DHC-8 PSM 1-GEN-5, CHAPTER 5 AND HORIZON AIR EA 2-53-287.SDR QXEA0101094Seat Track · corrodedPDX - RIGHT-HAND INBOARD SEAT TRACK AT STATION 597.500 HAS SEVERAL SCRATCHES. REPAIRED IAW DHC-8 PSM 1-GEN-5, CHAPTER 5 AND HORIZON AIR EA 2-53-287.SDR QXEA0101093Seat Track · corrodedPDX - RIGHT-HAND INBOARD SEAT TRACK AT STATION 580.500 HAS SURFACE CORROSION AROUND SCREW HOLES. REPAIRED IAW DHC-8 PSM 1-GEN-5, CHAPTER 5 AND RD 8-53-784.SDR QXEA0101053Seat Track · corrodedPDX - RIGHT-HAND OUTBOARD SEAT TRACK AT APPROXIMATELY X505.000 CHAFE DAMAGE. REPAIRED IAW DHC-8 CPM CHAPTER 5, PAGE 5-4 AND 5-5, AND HORIZON AIR EA 2-53-286.SDR QXEA0101052Seat Track · corrodedPDX - RIGHT-HAND OUTBOARD SEAT TRACK AT X488.500 HAS SURFACE CORROSION. REPAIRED IAW DHC-8 CPM CHAPTER 5, PAGES 5-4 AND 5-5, AND HORIZON AIR EA 2-53-286.SDR QXEA0101049Seat Track · corrodedPDX - RIGHT-HAND OUTBOARD SEAT TRACK AT X436.500 HAS PITTING CORROSION. REPAIRED IAW DHC-8 CPM CHAPTER 5, PAGES 5-4 AND 5-5 AND HORIZON AIR EA 2-53-286.SDR QXEA0101048Seat Track · corrodedPDX - LEFT-HAND OUTBOARD SEAT TRACK AT X260.000 HAS PITTING CORROSION. REPAIRED IAW DHC-8 CPM CHAPTER 5, PAGES 5-4 AND 5-5 AND HORIZON AIR EA 2-53-285.SDR QXEA0101116Seat Track · corrodedPDX - RIGHT-HAND INBOARD SEAT TRACK AT X234.500 NUT PLATE FLANGE HAS PITTING CORROSION. BLENDED CORROSION WITHOUT EXCEEDING LIMITS.SDR QXEA0101115Seat Track · corrodedPDX - REPLACED NR 10 SEAT TRACK DUE TO CORROSION OUT OF LIMITS. REPLACED SEAT TRACK IAW DHC-8 SRM 51-40-11 AND RD 8-51-102.SDR QXEA0101114Seat Track · corrodedPDX - LEFT-HAND OUTBOARD SEAT TRACK AT X366.050 HAS PITTING CORROSION. REPAIRED IAW HORIZON AIR EA 2-53-285 AND DHC-8 CPM CHAPTER 5, PAGES 4-5 AND 5-5.SDR QXEA0101113Seat Track · gougedPDX - LEFT HAND OUTBOARD SEAT TRACK AT X521.050 HAS GOUGE. REPAIRED IAW DHC-8 CPM CHAPTER 5, PAGES 5-4 AND 5-5.SDR QXEA0101112Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK AT X531.000 HAS SURFACE CORROSION. REPAIRED IAW RD 8-53-3644 AND DHC-8 CPM, CHAPTER 5, PAGES 5-4 AND 5-5.SDR QXEA0101092Seat Track · corrodedPDX - RIGHT-HAND INBOARD SEAT TRACK AT STATION 570.000 HAS PITTING AT CREW HOLES. REPAIRED IAW DHC-8 SRM 51-20-16 AND RD 8-53-784.SDR QXEA0101051Seat Track · corrodedPDX - RIGHT-HAND OUTBOARD SEAT TRACK AT 456.500 HAS SURFACE CORROSION. REPAIRED IAW DHC-8 CPM CHAPTER 5, PAGES 5-4 AND 5-5, AND HORIZON AIR EA 2-53-286.SDR QXEA0101050Seat Track · corrodedPDX - RIGHT-HAND OUTBOARD SEAT TRACK AT X445.500 HAS A GOUGE. REPAIRED IAW DHC-8 CPM CHAPTER 5, PAGES 5-4 AND 5-5, AND HORIZON AIR EA 2-53-286.SDR QXEA0101047Seat Track · corrodedPDX - LEFT-HAND OUTBOARD SEAT TRACK AT X290.000 HAS PITTING CORROSION. REPAIRED IAW DHC-8 CPM CHAPTER 5, PAGES 5-4 AND 5.5, AND HORIZON AIR EA 2-53-285.SDR QXEA0101046Seat Track · corrodedPDX - LEFT-HAND OUTBOARD SEAT TRACK AT X312.350 HAS PITTING CORROSION. REPAIRED IAW DHC-8 CPM CHAPTER 5, PAGES 5-4 AND 55, HORIZON AIR EA 2-53-285.SDR QXEA0101045Seat Track · corrodedPDX - LEFT-HAND OUTBOARD SEAT TRACK AT X333.300 HAS PITTING CORROSION. REPAIRED IAW DHC-8 CPM CHAPTER 5, PAGES 5-4 AND 5-5 AND HORIZON AIR EA 2-53-285.SDR UPS01436143Cargo Track · crackedINSPECTION TYPE:C, FWD CARGO COMPT TIE DOWN TRACK FOUND CRACKED AT LBL 25 BS 560 - 570 AREA AS MARKED. TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 5.SDR QXEA0101096Seat Track · corrodedPDX - RIGHT-HAND INBOARD SEAT TRACK HAS TWO GOUGES AT STATION 215. REPAIRED IAW RD 8-53-1339.SDR QXEA0101091Seat Track · corrodedPDX - RIGHT-HAND INBOARD SEAT TRACK AT STATION 270.500 HAS PITTING CORROSION. REPAIRED IAW RD 8-53-1339.SDR QXEA0101090Seat Track · corrodedPDX - RIGHT-HAND INBOARD SEAT TRACK AT STATION 252.700 HAS PITTING CORROSION. REPAIRED IAW RD 8-53-1339.SDR QXEA0101089Seat Track · chafedPDX - RIGHT-HAND INBOARD SEAT TRACK AT X252.700 HAS CHAFE DAMAGE. REPAIRED IAW RD 8-53-1339.SDR QXEA0101088Seat Track · corrodedPDX - RIGHT-HAND INBOARD SEAT TRACK AT X234.400 HAD PITTING CORROSION. REPAIRED IAW RD 8-53-1339.SDR 2001F00122Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE LEFT OUTBOARD, LEFT F/A, AND RIGHT F/A SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EO E9-5300-013. AIRCRAFT WAS RETURNED TO SERVICE. REF SIMA2001171. (M)SDR 2001F00121Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE LEFT OUTBOARD, LEFT F/A, AND RIGHT F/A SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EO E9-5300-013. AIRCRAFT WAS RETURNED TO SERVICE. REF SIMA2001171. (M)SDR 01FDEA00437Seat Track · corrodedAFT CARGO COMP LBL 20, BS 1790 TO 1964 HAS CORROSION TOP, BOTTOM AND AROUND SCREW HOLES OF TIE DOWN TRACK. REMOVED AND REPLACED SEAT TRACK PER IAW SRM 51-31-01.SDR CALA0100541Seat Track · corrodedINSPECTION FOUND LEFT I/B SEAT TRACK CORRODED AT FS 1041-1322. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-05 AND 51-30-01.SDR MWEA010931Seat Track · corrodedNR 4 SEAT TRACK CORRODED FROM STATION 200-237. REMOVED CORROSION, FABRICATED NEW SEAT TRACK SECTION, INSTALLED SEAT TRACK AND SPLICES.SDR MWEA010899Seat Track · corrodedNR 3 SEAT TRACK HAS AREAS OF MODERATE CORROSION STATION 228-265. REMOVED SEAT TRACK SECTION, FABRICATED DRILLED AND INSTALLED NEW SEAT TRACK SECTION.SDR MWEA010898Seat Track · corrodedFORWARD ENTRY NR 2 SEAT TRACK HAS LIGHT CORROSION FROM STATION 202-205. BLENDED CORROSION, REMOVED SECTION OF SEAT TRACK, DRILLED SEAT TRACK.SDR UPS01536155Seat Track · corrodedINSPECTION TYPE:C, CORROSION (CP53-131-01.00-01) ON SEAT TRACK AROUND NUT PLATE HOLES FROM BS 1040 - 1050, LBL 1 TO RBL 1, WL 208 IN MAIN CARGO COMPARTMENT. FOUND LONGITUDINAL BEAM OUT OF LIMITS AT 1045, LBL 1. REPLACED LONGITUDINAL BEAM FROM BS 900 - 1060 WSDR CA010622021Channel · cracked(CAN) BROUGHT THE A/C IN TO ADJUST THE LOW FUEL PRESS ON THE AUX FUEL PUMP. TO D0SO YOU MUST REMOVE THE PILOT SEAT & ADJUST A RESISTOR UNDER THE PILOT SEAT SUPPORT ASSY. THAT IS WHEN NOTICED THE CRACKIN THE LOWER R/H SEAT SUPPORT ASSY BOTTOM CHANNELSDR 01FDEA00481Seat Track · wornBS 1050 LT SIDE OF CENTERLINE SEAT TRACK WORN APPROX 6 INCHES. *S/D* REMOVED AND REPLACED SEAT TRACK PER IAW SRM 53-70-00.SDR 01FDEA00479Seat Track · damagedBS 119 RT SIDE OF CENTERLINE OF UPPER CARGO TRACK NR 3 SEAT TRACK IS DAMAGED APPROX 4 INCHES. *S/D* REMOVED AND REPLACED SEAT TRACK PER IAW SRM 53-70-00 & 53-42-01.SDR 01FDEA00480Seat Track · damagedBS 949 RT SIDE OF CENTERLINE TRACK NR 3 UPPER CARGO COMP SEAT TRACK IS DAMAGED APPROX 8 INCHES. *S/D* REMOVED AND REPLACED SEAT TRACK PER IAW SRM 53-70-00, 53-42-01.
Back to JASC 5347