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 CALA0000010Seat Track · corrodedINSPECTION FOUND RT I/B SEAT TRACK CORRODED AT STA 927. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52.SDR CALA0000009Seat Track · corrodedINSPECTION FOUND LT I/B SEAT TRACK CORRODED AT STA1098-1140. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-0.SDR SIMA0031Seat Track · corrodedDURING CPCP-4 INSPECTION, MAINTENANCE FOUND THE LEFT FORWARD INBOARD, LEFT FORWARD OUTBOARD, LEFT MIDDLE INBOARD, LEFT AFT CARGO, RIGHT AFT INBOARD, RIGHT AFT OUTBOARD, RIGHT FLIGHT ATTENDANT, RIGHT MIDDLE OUTBOARD, RIGHT MIDDLE INBOARD, RIGHT FORWARD INBOARD,SDR AALA2000114Seat Track · gougedTUL - FOUND NR 4 SEAT TRACK DEEP GOUGE STATION 1155. ROUTED OUT DAMAGED AREA AND INSTALLED SEAT TRACK PLUG PER SRM 53-05-08 FIG 4A. (M)SDR AALA2000113Galley Track · corrodedTUL - GALLEY TIE DOWN FLOOR FITTING CORRODED BELOW SUBFLOOR. REMOVED AND REPLACED GALLEY TIE DOWN FITTING PER SRM 51-01. (M)SDR SCNA99654Seat Track · crackedDURING A HEAVY MAINTENANCE CHECK, THE SEAT TRACK AT STATION 857 RBL 28 WAS FOUND GOUGED BEYOND LIMITS. REMOVED SEAT TRACK SECTION IAW DC10 SRM 513101 VOL 2. FABRICATED SEAT TRACK HAT SPLICE AND SPLICE PLATE IAW DC10 SRM 537000 VOL 1. ALODINED AND PRIMED IAWSDR SCNA99647Seat Track · gougedDURING A HEAVY MAINTENANCE CHECK, THE SEAT TRACK AT STATION 495 LBL 8 WAS FOUND TO HAVE GOUGES AND SCRATCHES. REMOVED SEAT TRACK SECTION IAW DC10 SRM 513301 VOL 2. FABRICATED TRACK SPLICE HAT AND SPLICE PLATE IAW DC10 SRM 537000 VOL 1. ALODINED AND PRIMED ISDR SCNA99646Seat Track · gougedDURING A HEAVY MAINTENANCE CHECK, THE SEAT TRACK AT STATION 495 RBL 28 WAS FOUND GOUGED ON THE OUTBOARD FLANGE. REMOVED TRACK SECTION IAW DC10 SRM 537000 VOL 1. FABRICATED TRACK SPLICE HAT AND PLATE IAW DC10 SRM 517000 VOL 1. ALODINED AND PRIMED IAW DC10 SRSDR SCNA99645Seat Track · crackedDURING A HEAVY MAINTENANCE CHECK, THE SEAT TRACK FLANGE AT STATION 450 LBL 7 WAS FOUND CRACKED. FABRICATED FILLER AND TWO STRAPS IAW DC10 SRM 537000 VOL 1. ALODINED AND PRIMED IAW DC10 SRM 512101 VOL 2.. INSTALLED FILLER AND STRAPS IAW DC10 SRM 513301 VOL 2SDR SCNA99640Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK, THE SEAT TRACK AT STATION 438 TO 450 LBL 27 WAS FOUND CORRODED. REMOVED SEAT TRACK FABRICATED SPLICE HAT AND PLATE IAW DC10 SRM 537000 VOL 1. ALODINED AND PRIMED IAW DC10 SRM 512101 VOL 2. INSTALLED SEAT TRACK IAW DC10 SRM SDR SCNA99635Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK, EQUIPMENT TIE DOWN TRACK AT STATION 1303 RBL 25 WAS FOUND CORRODED ON THE INSIDE OF THE TRACK.. TRACK WAS FOUND TO BE OUT OF LIMITS IAW DC10 SRM 537000 VOL 1. SEAT TRACK SPLICE REPAIR WAS ACCOMPLISHED.SDR SCNA99632Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK, THE SEAT TRACK AT STATION 460 LBL 58 WAS FOUND TO BE CORRODED. REMOVED SEAT TRACK IAW DC10 SRM 537000 VOL 1. MATERIAL ID AND INSTALLED SEAT TRACK IAW DC10 SRM 513301 VOL 2 AND 513101 VOL 2.SDR SCNA99631Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK, THE SEAT TRACK AT STATION 457 TO 465 RBL 57 WAS FOUND TO BE CORRODED. REMOVED SEAT TRACK IAW DC10 SRM 513301 VOL 2. INSTALLED NEW SEAT TRACK IAW DC10 SRM 513501 VOL 2 AND 513101 VOL 2.SDR SCNA99630Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK, THE SEAT TRACK AT STATION 454 LBL 56 AT FLANGE SCREW HOLE UPPER AND LOWER SURFACES WAS FOUND TO BE CORRODED. REMOVED SEAT TRACK IAW DC10 SRM 537000 VOL 1. INSTALLED SEAT TRACK IAW DC10 SRM 513301 AND DC10 SRM 513101 VOL 2.SDR SCNA99618Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK, THE SEAT TRACK AT STATION 421 TO 459 RBL 84 WAS FOUND TO HAVE CORROSION. REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW DC10 SRM 530001 VOL 1. INSTALLED NEW SEAT TRACK IAW DC10 SRM 513101 VOL 2 AND DC10 SRM 513301 VOL 2 ANDSDR SCNA99615Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK, THE SEAT TRACK FROM STATION 1861 TO 1887 RBL 58 WAS FOUND TO HAVE CORROSION. MATERIAL ID IAW DC10 SRM 537000 VOL 1. FABRICATE IAW DC10 SRM 537000 VOL 1. ALODINED AND PRIMED IAW DC10 SRM 512101 VOL 2. INSTALLED IAW DC10 SRMSDR SCNA99612Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK, THE SEAT TRACK AT STATION 1910 LT VERY OUTBOARD AT LAVATORY ATTACH POINT WAS FOUND TO HAVE CORROSION. REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW DC10 SRM 530001. MATERIAL ID FOR NEW TRACK IAW IPC 534215. LOCATED DRILLSDR SCNA99606Galley Track · corrodedDURING A HEAVY MAINTENANCE CHECK, THE FORWARD PIT STATION 879 OUTBOARD RT GALLEY TRACK WAS FOUND CORRODED. REMOVED CORRODED SECTION OF THE TRACK AND FABRICATED REPAIR SPLICE FOR THE NEW TRACK SECTION IAW DC10 SRM 537000 VOL 1. ALODINED AND PRIMED SPLICE OF NSDR QXEA0000110Seat Track · corrodedPDX - OUTBOARD FLANGE OF RIGHT-HAND INBOARD SEAT TRACK CORRODED IN AND UNDER NUTPLATE RECEPTICAL, 2 FORWARD OF FRAME 461D. REPAIRED IAW FOKKER SRM 51-31-01 AND HORIZON AIR EA 4-53-957.SDR QXEA0000089Seat Track · damagedPDX - TOOL DAMAGE ON RIGHT-HAND INBOARD SEAT TRACK. DAMAGE IS AT LOBE FOR FLOORBOARD FASTENER RECEPTICLE AND IS .145 WIDE X .182 LONG, LOCATED BETWEEN 5805 AND 6305. REPAIRED IAW HORIZON AIR EA 4-53-955.SDR RRXA000287Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FE'S FORWARD SEAT TRACK. DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC-8 SRM 51-3-0.SDR QXEA9902729Seat Track · crackedPDX - CRACK IN VERTICAL SUPPORT INBOARD SIDE FOR LEFT INBOARD SEAT TRACK AT FRAME 9305B. REPAIRED IAW FOKKER SRM 51-31-01.SDR CALA9901748Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT FS 1110-1130, RBL 22. THE SEAT TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-10-2, 51-30-2, AND MM 51-20-0.SDR 20000411AP001Seat Track · corrodedSAW - DURING CPCP INSPECTION, FOUND LEFT MIDDLE OUTBOARD AND LEFT MIDDLE INBOARD SEAT TRACKS CORRODED BEYOND LIMITS. REMOVED AND REPLACED LEFT MIDDLE OUTBOARD AND INBOARD SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA3642Seat Track · corrodedSAW - DURING CPCP INSPECTION, FOUND LEFT MIDDLE OUTBOARD AND LEFT MIDDLE INBOARD SEAT TRACKS CORRODED BEYOND LIMITS. REMOVED AND REPLACED LEFT MIDDLE OUTBOARD AND INBOARD SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 99FDEA00516Seat Track · crackedSNRM 403,0404, 467 - MAIN DECK CARGO COMP BS 635, LBL 47 CRACK IN LWR -403, MAIN DECK CARGO COMP BS 635, RBL 8.5 CRACK IN LWR -404, MAIN DECK CARGO COMP BS 635, LBL 27 CRACK IN LWR - 467. SEAT TRACKS REPAIRED PER SRM 53-70-00 FIG VOL 1.SDR TWAA0000704Seat Track · corrodedDURING OP 16 MAINT CHECK, FOUND CORROSION ON TRACK FROM STA 200 TO 218, RBL 44. REPLACED FLOOR TRACK PER SRM 53-05, PAGE 10G AND H, FIG 4F. 46 INCHES OF TRACK REPLACED.SDR QXEA0000104Seat Track · corrodedPDX - CORROSION ON LEFT-HAND INBOARD SEAT TRACK AT FRAME 4850. REPAIRED IAW FOKKER SRM 51-31-01 AND SRM 51-10-04.SDR SIMA36413Seat Track · corrodedABI - SEAT TRACK CORRODED BEYOND LIMITS AT FS 619 TO 686.88 18.3L. REMOVED AND REPLACED SEAT TRACK 18.3L FROM FS 619 TO FS 686.88. (M)SDR 20000417AP007Seat Track · corrodedSEAT TRACK CORRODED BEYOND LIMITS AT BL 0.0. REMOVED AND REPLACED 12 INCH OF SEAT TRACK AT BL 0.0. (M)SDR SIMA36410Seat Track · corrodedSEAT TRACK CORRODED BEYOND LIMITS AT BL 0.0. REMOVED AND REPLACED 12 INCH OF SEAT TRACK AT BL 0.0. (M)SDR 20000417AP006Seat Track · corrodedABI - FOUND CORROSION BEYOND SRM LIMITS ON SEAT TRACK 18.3L AT FS 300. REMOVED AND REPLACED 12 INCH SECTION OF SEAT TRACK. (M)SDR SIMA3649Seat Track · corrodedABI - FOUND CORROSION SRM LIMITS ON SEAT TRACK 18.3L AT FS 300.00. REMOVED AND REPLACED 12 INCH SECTION OF TRACK. (M)SDR QXEA0000088Seat Track · crackedPDX - CRACK IN RIGHT-HAND INBOARD SEAT TRACK APPROXIMATELY .200 LONG, LOCATED AT FRAME 6805. REPAIRED IAW HORIZON AIR EA 4-53-952.SDR AALA991996Lavatory Track · corrodedTUL - CORROSION ON LAVATORY SUPPORT IKNBOARD FLANGE BRACKET TRACK B ANC C LEFT SIDE BETWEEN FRAMES 30 AND 31. INSTALLED NEW LAVATORY SUPPORT TRACK PER SRM 51-72-10-0. TST: 32,241.11 HOURS. CYCLES: 12,979. (X)SDR L1GA200000305Cargo Track · corrodedAFT CARGO COMPARTMENT RT FLOOR TRACK CORRODED 1 X 24 INCHES.SDR QXEA9902732Seat Track · corrodedPDX - NUT PLATE CORRODED ON OUTBOARD FLANGE OF RIGHT INBOARD SEAT TRACK, AFT OF FRAME 4610. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA9902730Seat Track · corrodedPDX - NUMEROUS CORRODED SPOTS ON INBOARD FLANGE OF LEFT INBOARD SEAT TRACK BETWEEN FRAMES 10746 THROUGH 14755. REPAIRED IAW HORIZON AIR EA 4-53-946.SDR QXEA9902726Seat Track · corrodedPDX - FRETTING CORROSION ON INBOARD FLANGE OF LEFT SEAT TRACK BETWEEN FRAMES 8805 AND 9305. REPAIRED IAW FOKKER SRM 51-10-4 AND HORIZON AIR EA 4-53-946.SDR QXEA0000106Seat Track · corrodedPDX - CORROSION ON FLANGES OF LEFT-HAND INBOARD SEAT TRACK BETWEEN FRAMES 6805 AND 7305. REPAIRED IAW HORIZON AIR EA 4-55-946.SDR QXEA0000052Seat Track · gougedPDX - RIGHT INBOARD SEAT TRACK GOUGED ON SEVERAL TRACK LOBES BETWEEN FUSELAGE FRAMES 12405 AND 12875. REPAIRED IAW HORIZON AIR EA 4-53-948.SDR 2000ZZZX449Seat Track · corrodedTAT: 17,939.02 HOURS. TLDG: 20,490. LGPG: 1,121,465. STA: SAW CRIC: 9,861. RIGHT AFT OUTBOARD SEAT TRACK CORRODED. BLENDED, FOUND OUT OF LIMITS. ATR-42 IAW SRM 53-00-00 FIG 304. INSTALLED NEW SEAT TRACK IAW EO NR E9-5300-013 R4.SDR 2000ZZZX441Seat Track · corrodedTAT: 17,939.02 HOURS. TLDG: 20,490. LGPG: 1,121,465. STA: SAW CRIC: 9,859. LEFT AFT INBOARD SEAT TRACK CORRODED. BLENDED, FOUND OUT OF LIMITS. ATR-42 IAW SRM 53-00-00 FIG 304. REMOVED AND REPLACED LEFT AFT INBOARD SEAT TRACK IAW EO NR E9-5300-013 RSDR 2000ZZZX440Seat Track · corrodedTAT: 17,939.02 HOURS. TLDG: 20,490. LGPG: 1,121,465. STA: SAW CRIC: 9860. RIGHT AFT INBOARD SEAT TRACK CORRODED. BLENDED, FOUND OUT OF LIMITS. ATR-42 IAW SRM 53-00-00 FIG 304. REMOVED AND REPLACED RT AFT INBOARD SEAT TRACK IAW EO NR E9-5300-013 R4.SDR 20000424AP016Seat Track · corrodedABI - SEAT TRACK CORRODED BEYOND LIMITS AT FS 294. REMOVED AND REPLACED SEAT TRACK AT FS 294, 11 INCH SECTION FROM FS 294 TO 305. (M)SDR SIMA36412Seat Track · corrodedABI - SEAT TRACK CORRODED BEYOND LIMITS AT FS 294.0. REMOVED AND REPLACED SEAT TRACK AT FS 294.0 11 INCH SECTION FROM FS 294 TO 305. (M)SDR 20000417AP001Seat Track · corrodedABI - SEAT TRACK CORRODED BEYOND LIMITS AT FS 594.8 TO FS 686.8 TRACK 18L. REMOVED AND REPLACED SEAT TRACK AT 18.3L, 92 INCH SECTION. (M)SDR SIMA36411Seat Track · corrodedSEAT TRACK CORRODED BEYOND LIMITS AT FS 594.8 TO FS 686.8 TRACK 18.3L. REMOVED AND REPLACED SEAT TRACK AT 18.3L, 92 INCH SECTION. (M)SDR QXEA0000103Seat Track · corrodedPDX - CORROSION AT RIGHT-HAND INBOARD SEAT TRACK WHERE IT ABUTS FLOORBEAM. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 3, PARAGRAPH 4.SDR 2000ZZZX444Seat Track · corrodedTAT: 17,939.0 HOURS. TAC: 20,490. LGPG: 1,121,465. STA: SAW CRIC: 9,865. LEFT F/A'S SEAT TRACK CORRODED. BLENDED OUT CORROSION AND FOUND OUT OF LIMITS IAW ATR 42 SRM 53-00-00 FIG 304. INSTALLED NEW SEAT TRACK AT LEFT F/A POSITION IAW ATR 42 SRM 51-25-
Back to JASC 5347