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 P5CA9900379Tie Down · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 420 TO 460 LBL 68 TIE DOWN TRACK OUTBOARD FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900377Tie Down · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 378 LBL 80 TIE DOWN TRACK OUTBOARD FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900376Tie Down · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 324 LBL 36 TIE DOWN TRACK. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900375Tie Down · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 290 LBL 70 TIE DOWN TRACK OUTBOARD FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900374Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 240 TO 260 LBL 36 SEAT TRACK CROWN SURFACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900373Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 220 TO 224 LBL 26 SEAT TRACK CROWN SURFACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900369Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 2180 RBL 76 SEAT TRACK FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900367Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 2105 TO 2108 RBL 87 SEAT TRACK OUTBOARD FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900366Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1967 RBL 33 SEAT TRACK FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900365Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1940 RBL 97 SEAT TRACK FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900364Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1950 TO 1970 RBL 11 SEAT TRACK FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900363Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1294 RBL 33 SEAT TRACK FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900361Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1900 RBL 75 SEAT TRACK FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900360Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1888 RBL 11 SEAT TRACK INBOARD FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900348Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1394 RBL 11 SEAT TRACK CROWN. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900344Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 940 TO 980 RBL 11 SEAT TRACK. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900341Tie Down · corrodedLEVEL 1 CORROSION FOUND AT BS 680 RBL 56 TIE DOWN PLATE SURFACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900336Tie Down · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 520 RBL 87 TIE DOWN PLATE SURFACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900335Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 480 TO 520 RBL 68 SEAT TRACK CROWN SURFACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900316Tie Down · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 710 TO 790 LBL 11 TIE DOWN TRACK OUTBOARD FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900306Tie Down · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 382 LBL 45 TIE DOWN TRACK INBOARD FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900302Tie Down · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1170 TO 1260 LBL 11 TO RBL 11 TIE DOWN TRACK FLANGE AROUND ANCHOR NUTS. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR CALA9900220Seat Track · corrodedINSPECTION FOUND LEFT CENTER SEAT TRACK CORRODED AROUND SCREW HOLES FROM GALLEY NR 3 TO GALLEY NR 4 AREA, STA 1117 TO 1174. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-05, FIGURE 4F.SDR AALA990304Seat Track · corrodedTUL - FOUND DEEP CORROSION IN NR 6 SEAT TRACK. REMOVED OLD SEAT TRACK AND INSTALLED NEW SECTION OF SEAT TRACK STATION 200-797.5. (M)SDR TWAA9903813Seat Track · wornDURING OP 16 FOUND CHAIR TRACK NR 3 BLENDED OUT OF LIMITS AT STA 266, APPROX 22 IN LBL. INSTALLED NEW TRACK SPLICED IN AT STA 266 TO STA 198. SPLICED PER SEAT TRACK SPLICE REPAIR SRM 53-05 PG 7 FIG 4, SHEET 1.SDR P5CA9900420Tie Down · corrodedLEVEL 1 CORROSION FOUND ON MD BS 2220 LBL 97 TIE DOWN TRACK. CORROSION REMOVED PER SRM 51-10-01.SDR P5CA9900415Seat Track · corrodedLEVEL 1 CORROSION FOUND ON SEAT TRACK FROM BS 1900 TO 1980 LBL75 TO 77. CORROSION REMOVED PER SRM 51-10-01.SDR P5CA9900402Seat Track · corrodedLEVEL 1 CORROSION ON SEAT TRACK BS 1540 TO 1560 LBL 75. REMOVED CORROSION PER SRM 51-10-01.SDR P5CA9900401Seat Track · corrodedLEVEL 1 CORROSION ON SEAT TRACK BS 1530 LBL 77. REMOVED CORROSION PER SRM 51-10-01.SDR P5CA9900400Seat Track · corrodedLEVEL 1 CORROSION FOUND ON M/D BS 1510 TO 1560 LBL 10 SEAT TRACK FLANGE. REMOVED CORROSION, BLENDED OUT AND TREATED PER SRM 51-10-01.SDR P5CA9900392Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 770 TO 790 LBL 10 SEAT TRACK FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900389Seat Track · corrodedLEVEL 1 CORROSION FOUND AT UPPER DECK BS 670 TO 690 LBL 22 SEAT TRACK SURFACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900383Seat Track · corrodedLEVEL 1 CORROSION FOUND AT UPPER DECK SEAT TRACK EDGE ATTACH HOLE LOWER AREA, BS 560 TO 590 LBL 40 AND 60. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900378Tie Down · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 380 TO 460 LBL 80 TIE DOWN TRACK FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900372Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 2234 TO 2236 RBL 64 SEAT TRACK OUTBOARD FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900371Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 2226 TO 2228 RBL 32 SEAT TRACK INBOARD FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900370Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 2198 TO 2200 RBL 34 SEAT TRACK OUTBOARD FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900368Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 2140 TO 2148 RBL 11 SEAT TRACK OUTBOARD FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900362Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1916 TO 1920 RBL 75 SEAT TRACK FLANGE AND CROWN. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900359Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1830 RBL 75 SEAT TRACK CROWN AND FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900358Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1810 TO 1812 RBL 11 SEAT TRACK OUTBOARD FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900353Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1775 TO 1780 RBL 75 SEAT TRACK FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900352Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1752 TO 1754 RBL 11 SEAT TRACK OUTBOARD FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900351Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1500 TO 1508 RBL 11 SEAT TRACK. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900350Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1500 RBL 11 SEAT TRACK FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900349Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1413 RBL 10 SEAT TRACK FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900346Tie Down · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1208 TO 1223 RBL 32 TIE DOWN TRACK CROWN OUTBOARD EDGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900345Tie Down · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1140 TO 1160 RBL 32 TIE DOWN TRACK LOWER FACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900343Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 770 RBL 10 SEAT TRACK FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900273Tie Down · corrodedLEVEL 1 CORROSION FOUND MAIN DECK TIE DOWN TRACK FLANGE, BS 460 TO 480 LBL 32 WL 200. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.
Back to JASC 5347