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 QXEA0200489Seat Track · corrodedPDX - PITTING IN RT OUTBOARD SEAT TRACK FROM STATION 280.25 TO 282.0. REPAIRED IAW DHC-8 SRM 51-20-36, PAGE 6, PARAGRAPH F, STEPS 1 AND 2.SDR QXEA0200488Seat Track · scratchedPDX - SCRATCH IN RT OUTBOARD SEAT TRACK AT STATION 277.5. REPAIRED IAW DHC-8 SRM 51-20-36, PAGE 6, PARAGRAPH F, STEPS 1 AND 2.SDR QXEA0200483Seat Track · groovedPDX - GROVES WORN INTO LT INBOARD SEAT TRACK FROM STATION 502.0 TO 516.75. REPAIRED IAW DHC-8 SRM 51-20-36, PAGE 6, PARAGRAPH F, STEPS 1 AND 2.SDR QXEA0200482Seat Track · gougedPDX - GOUGE IN LT INBOARD SEAT TRACK AT STATION 541.0. REPAIRED IAW DHC-8 SRM 51-20-36, PAGE 6, PARAGRAPH F, STEPS 1 AND 2.SDR QXEA0200481Seat Track · wornPDX - WEAR IN RT INBOARD SEAT TRACK FROM STATION 515.75 TO 518.25. REPAIRED IAW DHC-8 SRM 51-20-36, PARAGRAPH F, STEPS 1 AND 2.SDR ZW0A0203103Seat Track · corrodedDURING CHECK-C MAINT FOUND PILOTS AFT INBD SEAT TRACK WAS CORRODED. REMOVED AND REPLACED TRACK PER SRM 51-01, PAGE 1, ITEM C.SDR AALA20020359Seat Track · corrodedTUL - FOUND CORROSION SEAT TRACK NR 1 FS 1208-1209. CUT OUT DAMAGED AREA AND INSTALLED PLUG PER AARD-53-70-00-10. (M)SDR ZW0A0203106Seat Track · corrodedDURING CHECK-C MAINT FOUND CORROSION ON NUMBER 6 RH O/B SEAT TRACK, FROM STA 256 TO 313. REPLACED SECTION OF SEAT TRACK USING SEAT TRACK SPLICE AT STA 421. TRACK CHANGED FROM STA 214 TO 421, PER SRM 53-05, PAGE 104.SDR AALA20020273Seat Track · corrodedTUL - FOUND CORROSION ON NR 1 SEAT TRACK STATION 1025. CORRODED SECTION OF NR 1 SEAT TRACK REMOVED. NEW SEAT TRACK INSTALLED STATION 936-1033 PER SRM 53-05. (M)SDR AALA20020272Seat Track · corrodedTUL - FOUND SEAT TRACK NR 2 CORRODED STATION 1199-1203. CORRODED SECTION OF NR 2 TRACK REMOVED NEW SECTION OF SEAT TRACK INSTALLED STATION 1033-1309 PER SRM 53-05. (M)SDR AWXA200200312Seat Track · corrodedYWG - MAJOR REPAIR - DURING C-08 CHECK CORROSION WAS FOUND AT RECESSED NUT HOLES ON SEAT RAIL Y1292 RT, FR 64 TO FR 66. MAINTENANCE REMOVED SEAT RAIL Y1292 RT BETWEEN FR 64 AND FR 66, FABRICATED A NEW SEAT RAIL AND INSTALLED REPAIR IAW SRM 51-72-11 PG 1 & 2, SDR AWXA200200311Seat Track · corrodedYWG - MAJOR REPAIR - DURING C-08 CHECK CORROSION WAS FOUND ON RECESSED NUT HOLE OF SEAT RAIL AT FR 64, Y765. MAINTENANCE REMOVED SEAT RAIL AT FR 64, Y765 RT, FABRICATED A NEW SEAT RAIL, AND INSTALLED REPAIR IAW SRM 51-72-11 PG 1 & 2 AND SRM 51-42-11 PG 1.SDR UPS02537928Seat Track · corrodedINSPECTION TYPE:MOD UPON REMOVAL OF BALLMAT, FOUND CORROSION IN SEAT TRACK AT BS 614, LBL 45, WL 208. REMOVED AND REPLACED SEAT TRACK FROM BS 440 TO 680, LBL 45 PER SRM 51-40-02 AND SRM 53-00-52.SDR UPS02437807Cargo Track · corrodedINSPECTION TYPE:C FWD CARGO COMPT - BS 960 RBL 25 TRACK FLANGE FOUND CORRODED AFTER END FITTING REMOVED. TIE DOWN TRACK REPAIRED AS PER SRM 53-10-21 FIG 5.SDR UPS02437805Seat Track · corrodedINSPECTION TYPE:C M/D - BS 895 RBL 33 SEAT TRACK HEAVY CORRODED. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR QXEA0200427Seat Track · chafedPDX - LT INBOARD SEAT TRACK AT STATION 443.024 ON FLANGE WHERE TRACKS BUTT UP THERE IS CHAFING. REPAIRED IAW FOKKER MM 53-40-01, PAGE 206, FIGURE 205 AND SRM 53-02-15, FIGURE 1.SDR QXEA0200426Seat Track · gougedPDX - LT INBOARD SEAT TRACK AT STATION 464.328 TOP LUGS HAVE GOUGES. REPAIRED IAW FOKKER SRM 53-02-15, FIGURE 1 AND SRM 51-31-01.SDR QXEA0200425Seat Track · gougedPDX - LT INBOARD SEAT TRACK AT STATION 481.800 THERE IS AN AREA ABOUT 5 INCHES LONG WITH MANY GOUGES ON THE LUGS. REPAIRED IAW FOKKER MM 53-40-01, PAGE 206, FIGURE 205 AND SRM 53-02-15, FIGURE 1.SDR QXEA0200424Seat Track · chafedPDX - LT INBOARD SEAT TRACK AT STATION 488.738 HOLE FOR FLOORBOARD RECEPTACLE HAS CHAFING ON FLANGE. REPAIRED IAW FOKKER MM 53-40-01, PAGE 206, FIGURE 306 AND SRM 53-02-15, FIGURE 1.SDR QXEA0200423Seat Track · gougedPDX - LT INBOARD SEAT TRACK AT STATION 488.740 THERE ARE GOUGES ON TOP LUGS AND FLANGE AT FRAME 10966. REPAIRED IAW FOKKER MM 53-40-01, PAGE 205, FIGURE 204 AND SRM 53-02-15, FIGURE 1.SDR UPS02437798Seat Track · corrodedINSPECTION TYPE:C M/D - BS 1935 LBL 98 SEAT TRACK CROWN FOUND CORROSION. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1.SDR AALA20020278Cargo Track · gougedTUL - FOUND MID CARGO TIE DOWN TRACK GOUGED, STATION 598. REMOVED AND REPLACED WITH NEW CARGO TIE DOWN TRACK SRM 51-01 FIG 2-4. (M)SDR UPS02437867Cargo Track · corrodedINSPECTION TYPE:C AFT CARGO COMPT - BS 1577 RBL 25 TIE DOWN TRACK VERTICAL ATTACHMENT CORRODED. TIE DOWN TRACK REPLACED AT BS 1500 - BS 1590 RBL 25 AS PER SRM 51-10-01 PG 8.SDR CALA0200114Cargo Track · corrodedINSPECTION FOUND FORWARD CARGO RT TIE DOWN RAIL CORRODED AT BS 500B-500D. A NEW SECTION OF TIE DOWN RAIL WAS SPLICED IN IAW SRM 53-00-53.SDR MWEA020144Seat Track · corrodedCORROSION ON NR 3 SEAT TRACK AT FROM 200 TO STATION 237. FABRICATED AND INSTALLED SEAT TRACK SECTION.SDR CALA0200111Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 270-294.5, RBL 35. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-40-02 AND DRAWING # 69-40352.SDR AALA20020276Seat Track · corrodedTUL - FOUND NR 6 SEAT TRACK CORRODED AT G2 TIE DOWN STATION 215. REPLACED SEAT TRACK FROM STATION 215 TO 303, APPROX SRM 53-05. (M)SDR UPS02437846Seat Track · corrodedINSPECTION TYPE:C M/D - BS 1980-2020 LBL 11 SEAT TRACK O/B FLANGE FOUND CORROSION. TRACK REPLACED AS PER SRM 53-10-05 FIG 14.SDR ZW0A0202502Seat Track · corrodedDURING CHECK-C MAINT CABIN SEAT TRACK HAD CORROSION IN LT FLANGE OF TRACK, LBL 44.5 INCHES, BETWEEN STA 1117 AND 1174. INSTALLED NEW SECTION OF TRACK FROM STA 1108 TO 1222 PER SPM 6-70-01, PAGE 3. SPLICED PER SRM 53-05, FIG 4F.SDR MWEA020140Seat Track · corrodedCORROSION ON TOP SIDE OF NR 4 SEAT TRACK AT STATION 200 AND CORROSION ON BOTTOM OF UPPER FLANGE AROUND THREE FASTENER HOLES AT STATION 221 TO 230 OF NR 4 SEAT TRACK. REMOVED SEAT TRACK AT STATION 221 TO 230 AND INSTALLED SEAT TRACK REPLACEMENT AND SPLICE.SDR AALA20020277Cargo Track · corrodedTUL - FOUND TIE DOWN STATION 160 RBL 12 INCHES CORRODED. REMOVED AND REPLACED WITH NEW TIE DOWN STATION 160 RBL 12 INCHES PER SRM 51-01. (M)SDR AALA20020271Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK. REPLACED SEAT TRACK NR 1 FROM STATION 1174 TO 1309 PER SRM 51-10-3. (M)SDR UPS02437788Seat Track · corrodedINSPECTION TYPE:C M/D - BS 1600-1620 RBL 11 SEAT TRACK I/B FLANGE FOUND CORRODED. SEAT TRACK REPAIRED PER SRM 53-10-05 FIG 4.SDR UPS02437785Seat Track · corrodedINSPECTION TYPE:C M/D - BS 770 RBL 75 SEAT TRACK O/B FLANGE CORROSION FOUND. SEAT TRACK REPAIRED PER SRM 53-10-05 FIG 1A.SDR UPS02437784Seat Track · crackedINSPECTION TYPE:C M/D - BS 770 LBL 33 SEAT TRACK FLANGE CORROSION CRACK. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1.SDR UPS02437781Seat Track · corrodedINSPECTION TYPE:C M/D- BS 850 RBL 11 SEAT TRACK O/B FLANGE LOWER FACE CORRODED.SDR UPS02437756Seat Track · wornINSPECTION TYPE:C M/D - BS 1660-1680 RBL 11 SEAT TRACK LIP FOUND WORN. SEAT TRACK REPAIRED AT M/D BS 1600-1680 RBL 11 AS PER SRM 53-10-05 FIG 14.SDR AALA20020275Seat Track · corrodedTUL - FOUND NR 3 SEAT TRACK STATION 1300-1307 HAS AREAS OF CORROSION. REMOVED SECTION OF SEAT TRACK AND INSTALLED NEW SECTION 1265 TO 1307. (M)SDR UPS02437812Seat Track · crackedINSPECTION TYPE:C M/D - BS 240 RBL 30 SEAT TRACK CROWN FOUND CRACKED DUE HANDLING. SEAT TRACK REPLACED SRM 51-10-01.SDR UPS02437786Seat Track · corrodedINSPECTION TYPE:C M/D - BS 960 LBL 97 SEAT TRACK CROWN CORRODED. SEAT TRACK REPAIRED AS PER SRM 53-10-05.SDR UPS02437782Track · crackedINSPECTION TYPE:C M/D - BS 760-780 RBL 10, TIE DOWN TRACK FLANGE FOUND CORROSION CRACK AS MARKED. TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 14.SDR 2002F00512Seat Track · corrodedAT C-CHECK, FOUND CABIN SEAT TRACK FLANGE CORRODED AT STATION 620 RBL 48. (M)SDR F3LA200200086Cargo Track · corrodedDURING C-2 CHECK, INSPECTION REPORTED AFT CARGO COMPARTMENT FLOOR TIE DOWN CORRODED AT STA 859 AND STA 772, LBL 17.2. REPLACED CORRODED AFT CARGO COMPARTMENT FLOOR TRACKS PER SRM 53-60-53.SDR F3LA200200080Cargo Track · corrodedDURING C-2 CHECK, INSPECTION REPORTED AFT CARGO BAY FLOOR TIE DOWN TRACK AT STA 859, RBL 13.8, CORRODED. SPLICED IN SECTION OF AFT CARGO BAY FLOOR TIE DOWN TRACK PER SRM 53-00-53.SDR AALA20020274Seat Track · corrodedTUL - FOUND NR 2 SEAT TRACK, STATION 1170, HAS CORROSION AT FASTENER HOLE. CUT OUT DAMAGE AREA AROUND HOLE, FABRICATED STRAP FROM 7075-T6, .090. INSTALLED STRAP PER AARD 53-20-00-13. (M)SDR 2002F00456Seat Track · wornAT C-CHECK, FOUND SEAT TRACK WORN OUT OF LIMITS AT STATION 700D TO STATION 720E LBL 44. (M)SDR AALA20020228Galley Track · corrodedTUL - FOUND G2 GALLEY MOUNT CORRODED. REMOVED AND REPLACED MOUNT PER AARD INTRODUCTION AND SRM 51-10-4. (M)SDR QXEA0200436Seat Track · corrodedPDX - CORROSION ON RT INBOARD SEAT TRACK FORWARD OF FRAME 4900 ABOUT 2 X 3 INCHES LONG ON OUTBOARD FLANGE. REPAIRED IAW FOKKER MM PAGE 206, FIGURE 205 AND SRM 53-01-01, PAGE 8, PARAGRAPH 4C.SDR QXEA0200435Seat Track · corrodedPDX - CORROSION ON RT OUTBOARD SEAT TRACK AFT OF FRAME 4610 ON INBOARD FLANGE. REPAIRED IAW FOKKER MM PAGE 206, FIGURE 205.SDR QXEA0200434Seat Track · corrodedPDX - CORROSION ON RT OUTBOARD SEAT TRACK FORWARD OF FRAME 5305 ABOUT 10 INCHES TO FRAME 4610 OUTBOARD FLANGE. REPAIRED IAW FOKKER SRM 51-31-01.
Back to JASC 5347