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 USAA2009021690348Seat Track · corrodedSAL - C8 - MAJOR REPAIR - NR 6171206 - CORROSION ON SEAT TRACK BETWEEN FR24 TO FR35, Y1292. REPLACED SEAT TRACK BETWEEN FR24 TO FR35, Y1292 IAW A320 SRM 51-72-11.SDR WRLA2009025Seat Track · corrodedDURING C-CHECK INSPECTION, FOUND SEAT TRACK CORROSION AT STA 824 + 859 X= -74.5. REPAIR THE DAMAGE SEAT TRACK PER SRM VOL I 53-70-00 PAGE 2 REV 40. REF EGAT N/R U05053.SDR WRLA2009024Seat Track · corrodedDURING C-CHECK INSPECTION IN TPE - FOUND SEAT TRACK CORROSION AT STA 824-859 X= -44. REPAIRED DAMAGED SEAT TRACK PER SRM 53-70-00 VOL I PAGE 2 REV 40. REF EGAT N/R U03017.SDR WRLA2009023Seat Track · corrodedDURING C-CHECK INSPECTION, FOUND SEAT TRACK CORROSION AT STA 824-859 X= 8.5. REPAIR THE DAMAGE SEAT TRACK PER SRM 53-70-00 VOL I PAGE 2 REV 40. REF EGAT N/R U05054.SDR WRLA2009022Seat Track · corrodedDURING C-CHECK INSPECTION, FOUND SEAT TRACK CORROSION AT STA 824-859 X=27.5. REPAIR THE DAMAGE SEAT TRACK PER SRM 53-70-00 VOL I PAGE 2 REV 40. REF EGAT N/R U03018.SDR WRLA2009021Seat Track · corrodedDURING C-CHECK INSPECTION IN TPE - FOUND SEAT TRACK CORROSION AT STA 824-859 X=107.5. REPAIRED SEAT TRACK IAW VOL I SRM 53-70-00 FIG 01 REV 40.SDR USAA2009022390421Seat Track · corrodedSAL - C8 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR47 TO FR64, Y1292. REPLACED SEAT TRACK BETWEEN FR47 TO FR64, Y1292 IAW A320 SRM 51-72-11.SDR HNAA2009061900196Seat Track · corrodedLT FWD INBD SEAT RAIL CORRODED AT STA X197. REMOVED AND REPLACE SEAT RAIL IAW RD8-53-27-97.SDR HNAA2009061900195Seat Track · corrodedLT AND RT SEAT RAIL BETWEEN STA X423 TO X588 CORRODED. REMOVED AND REPLACE SEAT RAIL IAW RD8-53-833.SDR SWIA200921322Seat Track · corrodedC-CHECKM, SIDEWALL SEAT TRACK CORRODED. REPLACED TRACK SECTIONS PER SRM.SDR AALA2009020900024Seat Track · wornCAPTAINS INBOARD AFT SEAT TRACK HAS EXCESSIVE WEAR. REPLACED CAPTAINS INBOARD AFT SEAT TRACK.SDR AALA2009020900023Seat Track · wornFIRST OFFICER AFT SEAT TRACK HAS EXCESSIVE WEAR. REPLACED FIRST OFFICER AFT INBOARD SEAT TRACK.SDR AALA2009021600130Cargo Track · corrodedLEFT TIE DOWN TRACK INBOARD SIDE CORRODED AT STATION 1214 OF AFT CARGO. INSTALLED NEW SPLICE PER SRM 51-10-03.SDR AALA2009021100091Cargo Track · corrodedCORROSION ON LEFT TIE DOWN TRACK CENTER MOUNT LUG AT STATION 670 TO 731. REPLACED LEFT TIE DOWN TRACK FROM STATION 522 TO 731 PER AARD 51-00-00-12.SDR AALA2009021100090Cargo Track · corrodedCORROSION ON LEFT TIE DOWN TRACK OUTBOARD AT STATION 674 TO 676. REPLACED SHEAR TIE DOWN TRACK FROM STATION 522 TO 731 PER AARD 51-00-00-012.SDR UALA2009013000326Seat Track · damagedMAIN CABIN STA 965 AT LBL 88.5 SEAT TRACK HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF SEAT TRACK, STA 944 TO 1032. INSTALLED NEW SECTION.SDR HNAA2009061900194Seat Track · corrodedLT INBD SEAT TRACK CORRODED AT MANY LOCATIONS BETWEEN STA X109.0 TO X662. REMOVED AND REPLACE SEAT TRACK IAW RD8-53-833.SDR AALA2009021600124Cargo Track · corrodedAFT CARGO LEFT TIE DOWN TRACK CORRODED AT STATION 1117 TO 1212. INSTALLED NEW TIE DOWN TRACK PER SRM 51-30.SDR ASOA200900183Seat Track · corrodedCARGO BAY SEAT TRACK SEGMENTS CORRODED LBL 9 F.S. 559+112 AND LBL 9 F.S. 615.50 TOTAL OF (2).SDR ASOA200900182Seat Track · corrodedCARGO SEAT TRACK SEGMENTS CORRODED RBL AND LBL 9.0, F.S. 559+90.SDR ASOA200900181Seat Track · corrodedCARGO SEAT TRACK SEGMENTS CORRODED RBL AND LBL 27 F.S. 559+80.SDR FDEA200901280351Seat Track · corrodedUPON REMOVAL OF MAIN DECK FLOOR PANEL AT ZONE 230 FOUND SEAT TRACK CORROSION AT STATION 760 TO 765 X = -8.5. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM EXISTING SPLICE AT STATION 745 TO STATION 785, X = -8.5 AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAISDR AALA2009021600122Seat Track · corrodedNUMBER 5 SEAT TRACK BLENDED OUT OF LIMITS. INSTALLED NEW SEAT TRACK AND SPLICE PER SRM 53-05-00.SDR AALA2009021100081Cargo Track · corrodedTIE DOWN TRACK CORRODED STATION 1212 TO 1322 RIGHT. INSTALLED NEW TIE DOWN TRACK PER SRM 51-32-02SDR FDEA200901270329Seat Track · corrodedCABIN, MAIN DECK SEAT TRACK BASE STATION 730 TO STATION 740, X = -8.5 FOUND CORROSION. CABIN, CORRODED SEAT TRACK AT STATION 730 TO STATION 740, X = -8.5 REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STATION 605 TO STATION 745, X = -8.5 AS PER SRM 53-70SDR AALA2009021600117Seat Track · corrodedCORROSION ON NUMBER 2 SEAT TRACK. REPLACED SEAT TRACK PER SRM 51-01-00.SDR AALA2009021600113Cargo Track · corrodedRIGHT TIE DOWN TRACK CORRODED AT SCREW HEADS AT STATION 1022 TO 1146 AT AFT CARGO. INSTALLED NEW TIE DOWN TRACK PER AARD 51-00-00-012.SDR AALA2009021100094Cargo Track · corrodedRIGHT TIE DOWN TRACK CORRODED AT SCREW HOLES STATION 1022 TO 1146. INSTALLED NEW TIE DOWN TRACK PER AARD 51-00-00-012.SDR IXXA09SMN022SSeat Track · corrodedDURING ROUTINE C CHECK INSPECTION, FOUND IN PASSENGER CABIN NUMBER FOUR TRACK CORRODED AT STATION 1420.000-1564.000. REMOVED CORROSION. FOUND OUT OF LIMITS. REMOVED CORRODED TRACK SEGMENT. FABRICATED SPLICES. CLEANED, TREATED, AND PRIMED AREA AND REPAIR PSDR IXXA09SMN021SSeat Track · corrodedDURING ROUTINE C CHECK INSPECTION, FOUND IN PASSENGER CABIN AUX TRACK CORRODED AT STATION 1500.000-1564.000 LEFT BOTTOM LINE-11. REMOVED CORROSION. FOUND OUT OF LIMITS. REMOVED CORRODED TRACK SEGMENT. FABRICATED SPLICES. CLEANED, TREATED, AND PRIMED AREA SDR IXXA09SMN020SCargo Track · corrodedDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT NUMBER 4 TRACK CORRODED AT STATION 970.000 - 1020.000. REMOVED EXISTING SPLICES. REMOVED CORROSION. FOUND OUT OF LIMITS. REMOVED CORRODED TRACK SEGMENT. FABRICATED SPLICES. CLEANED, TREATED,SDR USAA2009021990386Seat Track · corrodedSAL - C8 - MAJOR REPAIR - CORROSION ON SEAT TRACK RAIL BETWEEN FR46 +17 INCHES TO FR64, -Y765. REPLACED SEAT TRACK RAIL BETWEEN FR46 +17 INCHES TO FR64, -Y765 IAW A320 SRM 51-72-11.SDR USAA2009021990380Seat Track · corrodedSAL - C21 - MAJOR REPAIR - GALVANIC CORROSION ON SEAT TRACK AT BS 907, RBL 44. REPAIRED SEAT TRACK BETWEEN BS 907 TO BS 947.5, RBL 44 IAW B737 SRM 53-00-52.SDR USAA2009021790358Seat Track · corrodedSAL - C8 - MAJOR REPAIR - CORROSION ON SEAT TRACK AT FR36 TO FR41, Y1292. REPLACED SEAT TRACK AT FR36 TO FR41, Y1292 IAW A320 SRM 51-72-11.SDR USAA2009021690353Seat Track · corrodedSAL - C21 - MAJOR REPAIR - NR 6200186 - GALVANIC CORROSION ON SEAT TRACK AT BS932, LBL26. REPAIRED SEAT TRACK AT BS932, LBL26 IAW B737 SRM 53-00-52. UPON FURTHER REVIEW, EXPANDED PARAMETERS OF REPAIR STATION LOCATIONS WITHIN THE DISCREPANCY & WITHIN THE STRUSDR USAA2009021690352Seat Track · corrodedSAL - C21 - MAJOR REPAIR - NR 6209075 - GALVANIC CORROSION ON SEAT TRACK AT BS919, LBL44. REPAIRED SEAT TRACK AT BS919, LBL44 IAW B737 SRM 53-00-52.SDR USAA2009021190319Seat Track · corrodedSAL - C8 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR41 TO FR46, Y1292. REPLACED SEAT TRACK BETWEEN FR41 TO FR46, Y1292 IAW A320 SRM 51-72-11.SDR USAA2009020990310Seat Track · corrodedSAL - C8 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR12 TO FR24, -Y765. REPLACED SEAT TRACK BETWEEN FR12 TO FR24, -Y765 IAW A320 SRM 51-72-11.SDR WRLA2009015Seat Track · corrodedDURING C CHECK IN TPE - CORROSION - FOUND CORROSION WITH CRACK ON SEAT TRACK AT STA 799 - STA 919 X = 91.25. REPAIRED SEAT TRACK AT STA 799 - STA 919 X= 91.25 IAW VOL I 53-70-00 FIG 1, REV 40 AND CONDITION CHECK NORMAL & JOB COMPLETED.SDR DL75E090109Seat Track · gougedMAIN CABIN SEAT TRACK CROWN AT STA 820 RBL 25 FOUND GOUGE MARK, C/W AT SAA - SAT ON N/R 122467 SAA JOB 82000010001.SDR FDEA200901260326Seat Track · corrodedCABIN MAIN DECK SEAT TRACK AT STA 1480 TO STA 1500 X = 47.50 FOUND WITH SURFACE CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STATION 1471 TO STATION 1531, X = 47.50 AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6SDR FDEA200901260325Seat Track · corrodedCABIN MAIN DECK SEAT TRACK AT STA 1210 X = 75.25 FOUND WITH SURFACE CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STATION 1169 TO STATION 1269, X = 75.25 AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR FDEA200901260324Seat Track · corrodedCABIN MAIN DECK SEAT TRACK AT STA 1531 TO STA 5-63 X = 75.25 FOUND CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STATION 5-0 TO STATION 5-123, X = 75.25 AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR DU4R2009347Seat Track · corrodedS/O NR 312003, NR 25601, DURING SCHEDULED INSP, FOUND CORROSION ON SEAT TRACK AT BS 328 TO BS 344 RBL 44.SDR USAA2009021290324Seat Track · corrodedSAL - C21 MAJOR REPAIR - GALVANIC CORROSION ON SEAT TRACK AT BS 993.5, BL 19.5. REPAIRED SEAT TRACK AT BS 993.5, BL19.5 IAW B737 SRM 51-70-12.SDR ASOA200900125Seat Track · corrodedFLOOR SEAT TRACK IN FRONT OF LAV AT RBL-9 IS CORRODED.SDR ASOA200900123Cargo Track · corrodedALL CARGO FLOOR TRACKS ARE CORRODED AROUND SCREW HOLES.SDR USAA2009012790191Seat Track · corrodedBFM - C2 - MAJOR REPAIR - CORROSION ON SEAT TRACK AT FR42, -Y2462. REPLACED SEAT TRACK AT FR42, -Y2462 IAW A330 SRM 53-37-15 & 51-44-11.SDR USAA2009012790190Seat Track · corrodedBFM - C2 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR59 TO FR62, Y2462. REPLACED SEAT TRACK BETWEEN FR59 TO FR62, Y2462 IAW A330 SRM 53-00-15 & 51-42-1.SDR USAA2009012790189Seat Track · corrodedBFM - C2 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR38 TO FR39.2, Y450. REPLACED SEAT TRACK BETWEEN FR38 TO FR39.2, Y450 IAW A330 SRM 51-42-11 & 51-44-11.
Back to JASC 5347