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 KCSA061376Seat Track · corrodedFOUND UPPER DECK SEAT TRACK HAS CORROSION BETWEEN STA 580 AND 600, RBL 29.SDR DU4R2006644Seat Track · corrodedCORROSION CABIN LT I/B SEAT TRACK FS 200 TO 769 TOP CENTER OF TRACK, AND FLANGES. CUT OUT CORRODED AREA OUT OF LIMITS FS 586 TO 684, FABRICATED AND INSTALLED NEW SEAT TRACK 7' LONG FROM P/N S00483 7050T76511, 2 PLUGS P/N 7452952-3 AND CHANNEL 7452952-7 IAW DCSDR KCSA061375Seat Track · crackedFOUND MAIN DECK OUTBOARD SEAT TRACK FLANGE NEAR FLOORBEAM IS CRACKED AT STA 1200, LBL 75.SDR KCSA061372Seat Track · corrodedFOUND MAIN DECK SEAT TRACK HAS CORROSION ON LOWER SIDE AT STA 1780, RBL 79.SDR 06FDEA03469Seat Track · corrodedFOUND MAIN DECK CARGO, SEAT TRACK FLANGE (STA 1521, RT=75.25) UNDER FLOOR PANEL CORRODED. REPAIR CARRIED OUT AT MAIN DECK CARGO SEAT TRACK FLANGE (STA 1521,RH=75.25) AS PER SRM 53-70-00 FIGURE 3 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 06FDEA03447Seat Track · corrodedM/D CARGO SEAT TRACK (STA 5/0-5/33, RH X=75.25) UNDER FLOOR PANEL FOUND CORRODED. REPAIR CARRIED OUT AT M/D CARGO SEAT TRACK (STA 5/0-5/33, RH X=75.25) AS PER SRM 53- 70-00 FIGURE 3 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR KCSA061368Seat Track · damagedSEAT TRACK DAMAGED AT STA 566 LBL 47.SDR 06FDEA03446Seat Track · damagedM/D CARGO SEAT TRACK BS 755, RT X=8.5 FOUND EDGE BROKEN. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR DU4R2006628Seat Track · nickedNICKS, GROOVE AND CHAFE MARKS TOP, CENTER OF TRACKS AND FLANGES CABIN LT I/B SEAT TRACK FS 1032 TO FS 1309. BLENDED NICKS, GROOVED AND CHAFED MARKS, OUT OF LIMITS FS 1136 TO FS 1153. REPLACED SEAT TRACK FS 1126 TO FS 1206 WITH 15" SOO483 7075-T76511, INSTALLSDR KCSA061359Seat Track · wornAFT BILGE SEAT TRACK AT RBL 48 IS WORN FROM STA 1800 TO 1840.SDR KCSA061358Seat Track · crackedLEG ON SEAT TRACK CRACKED AT BS 1720 RBL 52.SDR DU4R2006634Seat Track · corrodedCORROSION CABIN LT CENTER SEAT TRACK FS 1203 - 1309 TOP, CENTER OF TRACK AND FLANGES. CUT OUT SEAT TRACK FS 1257 AND 1397 IAW DC-9/MD-80 SRM 53-05D. INSTALLED SPLICES P/N 53-0997-006, P/N ACA7413-505, FABRICATED AND INSTALLED SPLICE 47" BY 3.50" FROM P/N 539SDR ASAA0670997Cargo Track · corrodedFOUND FWD CARGO TIE DOWN TRACK FWD OF 500D CORRODED REPAIRED IAW SRM 53 00 53, REPAIR 3 FIG 201.SDR C1HA200697006Seat Track · corrodedPASSENGER CABIN SEAT TRACK CORRODED 1110 - 1145 LBL 24. REMOVED AND REPLACED SEAT TRACK FROM BS 990 - 1145 LBL 45 IAW B727 SRM 53-10-5 FIG 7 AND 51-30-2 FIG 1 & 11.SDR C1HA200697016Seat Track · corrodedSURFACE CORROSION ON SEAT TRACK RBL 45 BS 990-1130. REMOVED AND REPLACED SECTION OF SEAT TRACK FOUND WITH CORROSION OUT OF LIMITS AT BS 970-1080 RBL 45 IAW B727 SRM 53-10-2 AND 53-10-5.SDR C1HA200697012Seat Track · corrodedFOUND CORROSION ON SEAT TRACK BS 340-480 RBL 24. REPLACED SEAT TRACK AT BS 340-480 RBL 24 AS PER B727 SRM 51-30-2, B727 SRM 53-10-2 FIG 7.SDR C1HA200697007Seat Track · corrodedFOUND PASSENGER CABIN SEAT TRACK CORRODED 1110-1145 LBL-55. REMOVED CORRODED SEAT TRACK FROM FS 1110-1145 LBL 55 IAW B727 SRM 51-30-2. FAB NEW SEAT TRACK (5'10") FROM BAC 1520-795 7178-T6511, IAW B727 SRM 53-10-5 FIG 7 SHEET 1. INSTALLED SEAT TRACK AT FS 11SDR C1HA200697019Seat Track · corrodedFOUND SEAT TRACK AT STA 950F RBL 45 HAS CORROSION. REPAIRED SEAT TRACK AS REQUIRED IAW B727 SRM 53-10-5 FIG 7.SDR TRAX200600786Seat Track · corrodedSEAT TRACK BETWEEN FR 39 TO 41 IS CORRODED. CORROSION REMOVED ON SEAT TRACK BETWEEN FRAME 39 TO 41 AS PER SRM 51-21-42. REPLACED DAMAGED SEAT TRACK P/N S53678001214 WITH NEW PART PER TC 72-53-0232. MATERIAL THICKNESS 0.071 MATERIAL REMOVED 0.032 WITHIN LIMITSDR DU4R2006643Seat Track · corrodedCORROSION CABIN RT I/B SEAT TRACK FS 1032 TO 1309 NICKS, GROOVE MARKS, CHAFE MARKS, TOP CENTER OF TRACK, FLANGES. CORROSION OUT OF LIMITS FS 1130 AND 1065. CUT OUT AREA, INSTALLED PLUGS P/N 7452952-3 AND CHANNEL 7452952-7 IAW DC-9/MD-80 SRM 53-05D, 51-30-1 ANSDR AWXA200601658Seat Track · corrodedSAL - MAJOR REPAIR - CORROSION ON MAIN CABIN SEAT TRACK, -Y1292, FS 41 TO FS 47 (5 POINTS). REPLACED MAIN CABIN SEAT TRACK, -Y1292, FS 41 TO FS 47 IAW A319 SRM 51-72-11.SDR AWXA200601657Seat Track · corrodedSAL - MAJOR REPAIR - CORROSION ON MAIN CABIN SEAT TRACK, -Y1292, FS 36 TO FS 41 (3 POINTS). REPLACED MAIN CABIN SEAT TRACK, -Y1292, FS 36 TO FS 41 IAW A319 SRM 51-72-11.SDR AWXA200601656Seat Track · corrodedSAL - MAJOR REPAIR - CORROSION ON MAIN CABIN SEAT TRACK, +Y765, FS 41 TO FS 47/51 (5 POINTS). REPLACED MAIN CABIN SEAT TRACK, +Y765, FS 41 TO FS 47/51 IAW A319 SRM 51-72-11.SDR AWXA200601646Seat Track · corrodedSAL - CORROSION ON MAIN CABIN SEAT TRACK, +Y765, FS 36 - FS 41. REPLACED MAIN CABIN SEAT TRACK, +Y765, FS 36 - FS 41 IAW A319 SRM 51-72-11.SDR AWXA200601643Seat Track · corrodedSAL - CORROSION ON MAIN CABIN SEAT TRACK, -Y765, FS 36 - FS 41. REPLACED MAIN CABIN SEAT TRACK, -Y765, FS 36 - FS 41 IAW A319 SRM 51-72-11.SDR ASAA0690982Cargo Track · corrodedFWD CARGO TIE DOWN FITTING AT BS 500L IS CORRODED. REPAIRED IAW SRM 53-00-53.SDR MALA060559Seat Track · corrodedSEAT TRACK AT BL0 AND LBL18.3 IS CORRODED OUT OF LIMITS ON THE CENTER AISLE FLOOR PANEL ATTACH FLANGE BETWEEN FS297 AND FS307. THE DAMAGE HAS BEEN REPAIRED IAW MESABA EO#S53342. REF: EAMS WORK ORDER 214459 TASK 1508.SDR SWIA200617350Mount · corrodedSEAT TRACK FOR FWD GALLEY MOUNT CORRODED, DISCOVERED DURING C-CHECK INSPECTION. REPLACED SEAT TRACK SECTION WITH NEW.SDR AWXA200601651Seat Track · corrodedSAL - MAJOR REPAIR, CORROSION ON MAIN CABIN SEAT TRACK, -Y765, FS 41 TO FS 47/51 (5 POINTS). REPLACED MAIN CABIN SEAT TRACK , -Y765, FS 41 TO FS 47/51 IAW A319 SRM SRM 51-72-11.SDR AWXA200601650Seat Track · corrodedSAL - MAJOR REPAIR, CORROSION ON MAIN CABIN SEAT TRACK, +Y1292, FS 41 TO FS 47/51 (7 POINTS). REPLACED MAIN CABIN SEAT TRACK , +Y1292, FS 41 TO FS 47/51 IAW A319 SRM SRM 51-72-11.SDR AWXA200601649Seat Track · corrodedSAL - MAJOR REPAIR, CORROSION ON MAIN CABIN DUMMY RAIL, FS 20, -Y189. REPLACED MAIN CABIN DUMMY RAIL, FS 20 - FS 24, -Y189 IAW SRM A319 51-72-11.SDR AWXA200601645Seat Track · corrodedSAL - CORROSION ON MAIN CABIN DUMMY RAIL, FS 14 - FS 16, +Y503.2. REPLACED MAIN CABIN DUMMY RAIL, FS 14 - FS 16, +Y503.2 IAW A319 SRM 51-72-11.SDR AWXA200601644Seat Track · corrodedSAL - FOUND CORROSION ON MAIN CABIN SEAT TRACK, +Y1292, FS 36 - FS 41. REPLACED MAIN CABIN SEAT TRACK, +Y1292, FS 36 - FS 41 IAW A319 SRM 51-72-11.SDR ASAA0690979Cargo Track · corrodedAFT CARGO CUPPOR CHANNEL CORRODED AT LBL 17.24 AND BS 827 REPAIRED IAW 53 00 53 REPAIR 3.SDR CALA0600352Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1522-1564, RBL 74. THE SEAT TRACK WAS REPAIRED IAW SRM 53-00-52, FIGURE 202, REPAIR 3.SDR USAA061185Seat Track · corrodedSEAT TRACK FLOORBEAM Y1292 BETWEEN FRAMES 66-69 CORROSION. REMOVED AND REPLACED 3 ATTACHED FLOORBEAMS PER SRM 51-72-11; CORR LEVEL 1; TASK JA-260-53500, DEFECT SIZE: 3 SQ INCHES.SDR CALA0600355Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1476-1517, LBL 90. THE SEAT TRACK WAS REPLACED IAW SRM 51-10-02, PAGE 8 AND SRM 51-40-02.SDR CALA0600354Seat Track · corrodedINSPECTION FOUND O/B SEAT TRACK CORRODED AT STA 1546.5-1567.5, LBL 110. THE SEAT TRACK WAS REPAIRED IAW SRM 53-00-52, FIGURE 202, REPAIR 4.SDR CALA0600353Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1543-1552, RBL 108. THE SEAT TRACK WAS REPAIRED PER SRM 53-00-52, FIGURE 202, REPAIR 4.SDR KCSA061347Seat Track · corrodedUPPER DECK SEAT TRACK HAS EVIDENCE OF CORROSION FROM STA. 660 TO 710, RBL 66.SDR DU4R2006639Seat Track · corrodedS/O 291022 NR 29736 CORROSION CABIN LT OB SEAT TRACK FS 769-1032, NICKS, GROOVE MARKS, CHAFE MARKS, TOP CENTER OF TRACK AND FLANGES. CUT OUT CORRODED SECTION OF SEAT TRACK, INSTALLED REPAIR CHANNELS P/N 7452952-7 AND PLUGS P/N 7452952-3 IAW MD-80 SRM 53-05D.SDR KCSA061341Seat Track · corrodedMAIN DECK SEAT TRACK HAS CORROSION ON LOWER SIDE NEXT TO FLOORBEAM AT STA. 1820 TO 1940, RBL 75.SDR 06FDEA03360Track · misrepairedFWD CARGO COMP LT ROLLER TRACK NR 2 BETWEEN FRAME 38.1 TO 38.2 HAS PREVIOUS REPAIR, A FLAT DOUBLER INSIDE ROLLER TRACK COVERING THE DRAIN PORT WITH APPROX MEASUREMENTS 8X4". THIS REPAIR AT FWD CARGO LT SIDE ROLLER TRACK NR 2 BETWEEN FS 38.1 TO 38.2 WAS FOUND SDR MALA060558Seat Track · corrodedDURING 2 YEAR CHECK IN BNA FOUND SEAT TRACK AT LBL 18.3 IS CORRODED BEYOND SERVICEABLE LIMITS AT STA 297 - STA 319. REPAIRED IAW EO NR S53342SDR CALA0600347Seat Track · corrodedINSPECTION FOUND MAIN CABIN SEAT TRACK CORRODED AT STA 328-343, RBL 43. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR KCSA061330Seat Track · crackedPILOTS FWD OUTBOARD SEAT TRACK CRACKED.SDR KCSA061329Seat Track · crackedF/O AFT OUTBOARD SEAT TRACK CRACKED.SDR CALA0600345Seat Track · corrodedINSPECTION FOUND MAIN CABIN SEAT TRACK CORRODED AT STA 277-291, RBL 42. A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-40-02 AND 51-20-01.SDR KCSA061327Seat Track · crackedCOCKPIT, CAPTAIN'S AFT OB SIDE SEAT TRACK IS CRACKED.SDR MALA060555Seat Track · corrodedSEAT TRACK AT BLO.O STA 297-319 HAS CORROSION THAT IS OUT OF LIMITS. REPAIRED DAMAGE IAW EO NR S53342.
Back to JASC 5347