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 20000515AP022Seat Track · gougedFOUND CABIN SEAT TRACK STATION 870-960 LBL 24 HAS CORROSION, GOUGES AND GROOVES. REMOVED AND REPLACED SEAT TRACK FROM STATION 870-950 PLUS 10 LBL 24 IAW SRM 53-10-5 PAGE 3, 51-10-2 PAGE 14. (M)SDR 20000515AP021Seat Track · gougedFOUND CABIN SEAT TRACK STATION 870-970 LBL 45 HAS CORROSION, GOUGES AND GROOVES. REMOVED AND REPLACED SEAT TRACK FROM STATION 870-950D LBL 45 IAW SRM 53-10-5 PAGE 3, 51-10-2 PAGE 14. (M)SDR UPS99230511Seat Track · corrdedINSPECTION TYPE:SI, SEAT TRACK CORRODED AT BS 950F - 1010 LBL 45 AT NUT PLATE HOLES. CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-10-1 FIG 3. REMOVED AND REPLACED SEAT TRACK FROM BS 950E BS 1020 LBL 45 PER 53-10-5.SDR P2EA99263Seat Track · crackedSJO - SEAT TRACK WEB CRACKED AT BS 706 AND BS 727 BETWEEN WL 203.1 AND 208.1. REPAIRED IAW COOPESA EO COO-SJO-3-53-500-98. (M)SDR CALA9901081Galley Track · corrodedINSPECTION FOUND RT O/B GALLEY MOUNT TRACK CORRODED AT STA 328-360. THE MOUNT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-2 AND 51-10-2.SDR UPS99230960Seat Track · corrodedINSPECTION TYPE:SI, AREAS OF CORROSION ON SEAT TRACK BETWEEN BS 481 AND BS 580 LBL 25, WL 208. REMOVED CORRODED SEAT TRACK, FABRICATED NEW ONE, AND INSTALLED IAW 53-10-05.SDR UPS99230828Seat Track · corrodedINSPECTION TYPE:SI CORROSION ON SEAT TRACK BETWEEN BS 360-380, LBL 65, WL 208. CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REMOVED SEAT TRACK, INSTALLED NEW SEAT TRACK PER SRM 51-30-2, SRM 51-30-2, AND SRM 51-10-2.SDR UPS99230827Seat Track · corrodedINSPECTION TYPE:SI CORROSION ON SEAT TRACK AT BS 782 AND BS 798, RBL 45, WL 208. REMOVED CORRODED TRACK, FABRICATED AND INSTALLED SEAT TRACK PER SRM 51-30-2, 51-10-2, 51-30-5 AND 53-10-5.SDR TWAA9911906Seat Track · corrodedDURING OP 16 MAINT CHECK, CHAIR TRACK NUMBER 4 WAS CORRODED AT FLANGE, STA 857 THRU 965. NEW TRACK INSTALLED PER SPM 6-70-01. SPLICE PER SRM 53-05, FIG 4F SHEET 1.SDR QXEA9901910Seat Track · gougedPDX - RIGHT-HAND INBOARD SEAT TRACK IS GOUGED AT STATION 480. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901908Seat Track · gougedPDX - RIGHT-HAND INBOARD SEAT TRACK GOUGED AT STATION 498. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901907Seat Track · gougedPDX - RIGHT-HAND INBOARD SEAT TRACK GOUGED AT STATION 530. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901906Seat Track · gougedPDX - RIGHT-HAND INBOARD SEAT TRACK IS GOUGED AT STATION 567. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901905Seat Track · gougedPDX - RIGHT-HAND INBOARD SEAT TRACK IS GOUGED AT STATION 572. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901904Seat Track · gougedPDX - RIGHT-HAND INBOARD SEAT TRACK IS GOUGED AT STATION 588. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901903Seat Track · gougedPDX - RIGHT-HAND INBOARD SEAT TRACK IS GOUGED AT STATION 618. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901902Seat Track · gougedPDX - RIGHT-HAND INBOARD SEAT TRACK IS GOUGED AT STATION 639. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901901Seat Track · gougedPDX - RIGHT-HAND INBOARD SEAT TRACK IS GOUGED AT STATION 647. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901899Seat Track · gougedPDX - RIGHT HAND OUTBOARD SEAT TRACK GOUGED AT STATION 610. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901898Seat Track · gougedPDX - RIGHT-HAND OUTBOARD SEAT TRACK IS GOUGED AT STATION 639. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901897Seat Track · gougedPDX - RIGHT-HAND OUTBOARD SEAT TRACK IS GOUGED AT STATION 659. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901799Seat Track · gougedPDX - RIGHT-HAND OUTBOARD SEAT TRACK IS GOUGED AT STATION 580. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901798Seat Track · corrodedPDX - RIGHT-HAND OUTBOARD SEAT TRACK IS GOUGED AT STATION 588. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901797Seat Track · gougedPDX - RIGHT-HAND OUTBOARD SEAT TRACK GOUGED AT STATION 590. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901795Seat Track · gougedPDX - RIGHT-HAND OUTBOARD SEAT TRACK IS GOUGED AT STATION 601. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901794Seat Track · gougedPDX - RIGHT-HAND OUTBOARD SEAT TRACK IS GOUGED AT STATION 603. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR DHL9972746CSeat Track · corrodedAT C CHECK, CORROSION ON NR 5 SEAT TRACK THE LAST O/B TRACK ON THE RT SIDE OF CABIN, NEXT TO THE FWD RIGHT EMERGENCY ESCAPE DOOR (WING) STA 760-850. REMOVED SEAT TRACK CAP FROM STA 760 TO 850 AT NR 5 SEAT TRACK PER SRM 51-30-2. REMOVED NR 5 FLOATING SEAT TRACSDR CALA9901077Seat Track · corrodedINSPECTION FOUND RT I/B SEAT TRACK CORRODED FROM STA 328-344. REPAIRED IAW SRM 53-00-52, FIGURE 202, SHEET 1.SDR UPS99230530Seat Track · corrodedINSPECTION TYPE:SI, SEAT TRACK CORRODED AT BS 950B-950C LBL 25 WL 208. CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REMOVED AND REPLACED SEAT TACK FROM BS 950+10 TO BS 950F+10 LBL 25 PER SRM 53-10-5.SDR QXEA9901796Seat Track · gougedPDX - RIGHT-HAND OUTBOARD SEAT TRACK GOUGED AT STATION 593. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, C.SDR QXEA9901675Seat Track · corrodedPDX - LEFT-HAND INBOARD SEAT TRACK FROM STA 202.750 TO 222.700 HAS MINOR SURFACE CORROSION AND LIGHT PITTING. REPAIRED IAW SHC-8 SRM 51-40-11 AND SRM 51-40-00.SDR UPS99830465Seat Track · corrodedINSPECTION TYPE:SVC, AFT ACCY COMPARTMENT, SEAT TRACK CORRODED BEYOND LIMITS AT FS L3L10. REMOVED SEAT TRACK FROM FS 1500-1700 L3L10 AND SPLICED IN NEW SEAT TRACK SECTION, INSTALLED SPLICES AND REINSTALLED FLOORBOARDS AND CARGO SYSTEM IAW DC8 SRM 53-2-3, 51-SDR UPS99230513Seat Track · corrodedINSPECTION TYPE:SI, SEAT TRACK CORRODED BETWEEN BS 480 - 520 BL 0, WL 208. CORROSION CLEAN-UP BEYOND ACCEPTABLE LIMITS. FABRICATED AND INSTALLED REPLACEMENT TRACK PER SRM 51-10-8 AND 53-10-5.SDR QXEA9901896Seat Track · gougedPDX - LEFT-HAND OUTBOARD SEAT TRACK IS GOUGED AT STATION 548. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, PARAGRAPH 4B, C.SDR 20000515AP050Seat Track · corrodedFOUND CABIN SEAT TRACK STATION 380-480 RBL 45 HAS CORROSION. REMOVED AND REPLACED SEAT TRACK SEAT TRACK STATION 380-480 RBL 45 IAW SRM 53-10-5 PAGE 3, 53-30-2 PAGE 1. (M)SDR 20000515AP049Seat Track · gougedFOUND CABIN SEAT TRACK STATION 480-680 LBL 24 HAS CORROSION, GOUGES AND GROOVES. REMOVED AND REPLACED SEAT TRACK FROM STATION 460-520 RBL 45 IAW SRM 53-10-5 PAGE 2, 51-10-2 PAGE 14. (M)SDR DHL9972744CSeat Track · looseAT C CHECK, SEAT TRACKS LBL 48 MISSING ATTACH FASTENERS AT STA 940. REMOVED FASTENERS AT SEAT TRACK LBL 48 FROM STA 950A TO STA 890 PER SRM 51-30-2. FOUND HOLE TO BE IN WRONG LOCATION. INSTALLED NEW CABIN SEAT TRACK LBL 48 PER SRM 53-10-5 FIG 7. ALODINED ASDR 99FDEA00341Seat Track · crackedMAIN DECK UPPER FUSELAGE, SEAT TRACK FOUND CRACK AT BS 635 X = 8.5 RT. CRACK LENGTH APPROX 3.4 IN. *S/D* REPAIRED AND INSTALLED PARTS, FABRICATED PER SRM 53-70-00 FIG 1 VOL.SDR QXEA9901676Seat Track · corrodedPDX - RIGHT-HAND INBOARD SEAT TRACK HAS MINOR CORROSION WHERE CARGO TIE DOWN MOUNTS. REPAIRED IAW HORIZON AIR EA 2-53-73.SDR 20000515AP055Seat Track · corrodedFOUND CABIN SEAT TRACK STATION 680-740 LBL 45 HAS CORROSION, GOUGES AND GROOVES. REMOVED AND REPLACED SEAT TRACK FROM STATION 720C-720E LBL 45 IAW SRM 53-10-5 PAGE 3, 51-10-2 PAGE 14. (M)SDR MWEA99511Seat Track · damagedTOOL MARKS ON NR 1 SEAT TRACK AT STATION 717 AND NR 2 SEAT TRACK AT STATION 721. MTC FABRICATED AND INSTALLED REPAIR PLUG.SDR MWEA99509Seat Track · crackedNR 3 SEAT TRACK AT STATION 601 HAS CRACKED TABS. MTC FABRICATED AND INSTALLED NEW SEAT TRACK.SDR MWEA99508Seat Track · corrodedNR 4 SEAT TRACK AT STATION 227 TO 236 HAS HEABY CORROSION. MTC FABRICATED AND INSTALLED NEW SECTION OF SEAT TRACK.SDR K4HA99076Seat Track · corrodedDURING ROUTINE ACCOMPLISHMENT OF SCHEDULED C CHECK AND CPCP TASK CARDS, FOUND CORROSION. SEAT TRACK FLANGE CRACKED AND CORRODED APPROXIMATELY 8 INCHES. REMOVED DAMAGE IAW L1011 SRM 53-21-00 FIG 808. FABRICATE REPAIR DOUBLER IAW L1011 SRM 53-21-00. INSTALLESDR UPS99230600Seat Track · corrodedINSPECTION TYPE:SI SEAT TRACK CORRODED AT BS 680-740 LBL 45 WL 208. REMOVED AND REPLACED SEAT TRACK FROM BS 660-740 PER SRM 51-30-2 AND 53-10-5 FIG 1.SDR 20000515AP051Seat Track · damagedFOUND CABIN SEAT TRACK STATION 440 RBL 24 HAS DAMAGE. REMOVED AND REPLACED SEAT TRACK 440 RBL 24 IAW SRM 53-10-5 PAGE 2, 51-10-2 PAGE 14. (M)SDR AALA991186Seat Track · corrodedTUL - NR 6 TRACK CORRODED, STATION 1150 TO 1184. INSTALLED TWO PLUG REPAIRS AT STATION 1150 AND 1184 PER SRM 53-05 FIG 4. (M)SDR MWEA99487Seat Track · corrodedSEAT TRACK NR 4 FROM STATION 200 TO 218 HAS NUMEROUS AREAS OF LIGHT CORROSION AND TOOL MARKS. MTC FABRICATED AND INSTALLED NEW SEAT TRACK.SDR AT9900584Seat Track · corrodedDURING A ROUTINE INSPECTION AT TIMCO LAKE CITY FL, FOUND CABIN SEAT TRACK CORRODED AT BS 200 LBL 45. REMOVED SEAT TRACK, CUT, DRILLED, COUNTERSUNK NEW SECTION OF SEAT TRACK AND INSTALLED IAW DC9 SRM 53-05, 51-10-4, 51-10-3, 53-21-0 FIG 3.SDR 99FDEA00329Seat Track · crackedMAIN DOCK UPPER FUSELAGE SEAT TRACK FOUND CRACK AT BS 635 X=8.5 RT. - 3.2 IN, AT BS 635 X 27.5 RT. - 3.5. AT BS 635 X 47.5 RT -4.3 IN, AT BS 635 X = 47.5 LH-4.5. *S/D* FASTENERS REMOVED AND SEAT TRACK TRIMMED & REWORKED PER SRM 53-42-01.
Back to JASC 5347