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 AALA20021774Seat Track · corrodedTUL - FOUND NR 1 SEAT TRACK CORRODED STATION 1235-1239. CORROSION REMOVED PER SRM 51-10-3, CORROSION REMOVED BEYOND LIMITS. A NEW SEAT TRACK WAS INSTALLED STATION 1174-1309 FREEZE PLUG INSTALLED AND GALLEY MOUNT PER AMM 53-40-01. (M)SDR AALA20021703Galley Track · corrodedFOUND CORROSION ON SEAT TRACK NR 1 AT GALLEY TIE DOWN. REMOVED CORROSION CUTOUT AREA BEYOND LIMITS AND INSTALLED PLUG PER AARD 53-20-00-10. (M)SDR AALA20021744Seat Track · corrodedTUL - FOUND CORROSION ON BOTTOM SIDE OF CLIP NUT TABS, BEYOND MANUAL LIMITS. SPLICE IN NEW SECTION OF NR 2 SEAT TRACK PER SRM 53-05. (M)SDR SIMA200234508Seat Track · corrodedA LEVEL 2 CORROSION FOUND DURING A IMBV INSPECTION. LT HAND FORWARD LOWER SEAT TRACK CORRODED BETWEEN FRAMES 19 AND 24. REMOVED AND INSTALLED SERVICEABLE SEAT TRACK IAW MM.SDR MALA020658Seat Track · corrodedDURING 6Y/4Y INSPECTION IN CWA, NOTED LT FWD SEAT TRACK LBL 18.3 HAS HEAVY CORROSION. MAINTENANCE COMPLETED REPAIR BETWEEN STA 297-329 IAW EO S53060. A/C RELEASE DATE 11/20/02SDR AALA20021773Seat Track · corrodedTUL - FOUND CORROSION BEYOND MANUAL LIMITS. SPLICE NEW SECTION OF SEAT TRACK NR 6 SRM PER SRM 53-05. (M)SDR MALA020659Seat Track · corrodedDURING 6Y/4Y INSPECTION IN CWA, SEAT TRACK CORROSION IN CARGO AREA. MAINTENANCE COMPLETED SEAT TRACK SPLICE REPAIR IAW EO S53060 AT BL 0 STA 619.138 - 686.888. A/C RELEASE DATE 11/20/02.SDR AALA20021757Seat Track · corrodedTUL - FOUND CORROSION IN NR 2 SEAT TRACK AT APPROX STATION 1304. REMOVED CORRODED AREA AND INSTALLED SEAT TRACK PLUG REPAIR PER 53-20-00-10. (M)SDR AALA20021759Seat Track · corrodedTUL - FOUND CORROSION IN NR 3 SEAT TRACK AT APPROX STATION 1304. REMOVED CORRODED AREA AND INSTALLED SEAT TRACK PLUG. REPAIR PER 53-20-00-10. (M)SDR ASAA0240211Cargo Track · corrodedDURING C-CHECK, FOUND CORROSION ON CARGO FLOOR TRACK IN AFT CARGO BAY FROM BS 787-847 AND RBL 14. REPAIRED IAW SRM. (M)SDR MALA020677Seat Track · corrodedDURING C-CHECK IN CVG, NR 3 SEAT TRACK SECTION FROM FRAME 18 TO FRAME 20 IS CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED SEAT TRACK IAW SRM 53-00-32 201 AND EO A53026.SDR MALA020676Seat Track · corrodedDURING C-CHECK IN CVG, NR 4 SEAT TRACK SECTION FROM FRAME 18 TO FRAME 20 IS CORRODED BEYOND LIMITS. MAITENANCE REPAIRED SEAT TRACK IAW SRM 53-00-32-201 AND EO A53026.SDR GTIA021258Seat Track · damagedFTW - FOUND PASSENGER SEAT TRACK LEFT, OUTBOARD WORN AT FS 998-1010, GOUGE 1019, CORROSION 1037-1041, WORN 1059-1067, 1087-1098, CORROSION 1240. LEFT, OUTBOARD SEAT TRACK FOUND TO BE OUT OF LIMITS AT FS 1240. REMOVED LEFT OUTBOARD SEAT TRACK FS 1222-1309. LSDR AALA20021679Seat Track · corrodedFOUND CORROSION ON SEAT TRACK BETWEEN STATION 1207 AND 1299. INSTALLED NEW SEAT TRACK PER SRM 51-01. (M)SDR AALA20021690Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 2 FROM STATION 1203 TO 1300. INSTALLED NEW SEAT TRACK NR 2, STATION 1184-1307 AND INSTALLED NEW SPLICE PER SRM 53-05 PART 1. (M)SDR GTIA021234Seat Track · wornFTW - PASSENGER SEAT TRACK LEFT INBOARD, WORN AT FS 1005-1809, 1118-1129, 1222, 1241, 1274, 1280. OUT OF LIMITS AT STATION'S 1118 TO 1129, 1241, 1274 AND 1280. CUT AND REMOVED DAMAGED SECTION OF SEAT TRACK. DRILLED NEW SEAT TRACK SECTION OF LEFT INBOARD FS SDR SWIA200211653Seat Track · corrodedFORWARD AND AFT, RIGHT AND LEFT SIDES, FLOOR SEAT TRACKS ARE CORRODED. FOUND DURING C-CHECK INSPECTION. INSTALLED NEW SEAT TRACKS IAW MM 53-01-05.SDR GTIA021208Seat Track · corrodedFTW - FOUND PASSENGER SEAT TRACK RIGHT OUTBOARD, GOUGE AT FS 248, 291, CORROSION AT FS 256, 277, 301, 340, 400-418, 424-447, 458-478, 492-496, 523-536, 551-566, 582-598. REMOVED SEAT TRACK STATION 256-291. LOCATED AND DRILLED NEW SEAT TRACK. LOCATED AND DRISDR MALA020656Seat Track · corrodedDURING 6Y/4Y INSPECTION, SEAT TRACK BL 0, STA 297-348 HAS CORROSION. MAINTENANCE COMPLETED SEAT TRACK REPAIR SPLICE IAW EO 53060. A/C RELEASE DATE 11/20/02.SDR 2002UALA01722Track · damagedRH IB SEAT TRACK FLANGE DOME NUT MISSING AND HOLE ELONGATED. STA 1050, RBL 24. MAJOR REPAIR ACCOMPLISHED.INSTALLED REPAIR ANGLE ON SEAT TRACK FLANGE.SDR LR7A02117Track · wornDURING SCHEDULED B1 INSPECTION PER HB0509 FOUND FLIGHT ENGINEERS SEAT TRACKS WORN. FS159, BL0, WL200.REPLACED TRACKS IAW SRM SMP 583-51-60-00, DWGS 371094, AND 371095. NR0047.SDR ASAA0280560Seat Track · corrodedOKC - FOUND 30K CHECK, LEFT INBOARD SEAT TRACK IS CORRODED AT FS 574-598, LBL 22. REMOVED DAMAGED SECTION AND INSTALLED REPAIR PARTS PER SRM 53-05. (M)SDR ASAA0280562Seat Track · gougedOKC - FOUND DURING 30K-CHECK, LEFT INBOARD SEAT TRACK GOUGED AT FS 693, LBL 22. REMOVED DAMAGED SECTION AND INSTALLED REPAIR PART PER SRM 53-05. (M)SDR MWEA020680Web · damagedCUSP WEB STATION 218-237 OF SEAT TRACK NUMBER 4 REQUIRED REPLACEMENT. -- REMOVED AND REPLACED WEB.SDR SIMA200233824Seat Track · corrodedABI - THIS LEVEL 2 FINDING WAS FOUND DURING AN IMBV INSPECTION REFERENCE CRIC NR 29953, LEFT OMEGA BEAM FORWARD SEAT TRACK CORRODED. REMOVED AND REPLACED SEAT TRACK ON OMEGA BEAM IAW EMB 145 AMM 53-01-06. (M)SDR QXEA0201901Seat Track · damagedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 12 HAS PAINT MISSING WHERE SEAT ATTACHES AND SEAT LOCKING POINTS ARE MARRED BY SEAT AT STATION 514 AND STATION 529. REPAIRED IAW RD 8-53-3644 AND RD 8-51-102.SDR QXEA0201902Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 11 AT STATION 435 HAS LIGHT PITTING CORROSION AND MARRED EDGES AT LOCKING POINTS. REPAIRED IAW DHC-8 SRM 51-40-11 AND RD 8-51-102.SDR ASAA0280537Seat Track · corrodedOKC - FOUND 30K CHECK, SEAT TRACK FOUND CORRODED AT FS 562, RBL 44. REMOVED CORRODED SECTION. SPLICED IN REPLACEMENT SECTION PER SRM 53-05, FIG 4F. (M)SDR ASAA0280538Seat Track · corrodedOKC - FOUND 30K CHECK, FOUND SEAT TRACK CORRODED AT FS 235-237, RBL 44. REMOVED CORRODED SECTION. SPLICED IN REPLACEMENT PER SRM 53-05, FIG 4F. (M)SDR ASAA0280539Seat Track · gougedOKC - FOUND DURING 30K-CHECK, SEAT TRACK GOUGED AT FS 257-259, LBL 44. REMOVED GOUGED SECTION. SPLICED IN REPLACEMENT SECTION PER SRM 53-05, FIG 4F. (M)SDR AUS20021299Seat Track · worn(AUS) RH INBOARD AND LH OUTBOARD SEAT TRACKS WORN BEYOND LIMITS. FOUNDDURING INSPECTION IAW AD/C172/53 AMDT2.SDR QXEA0201905Seat Track · corrodedPDX - SEAT TRACK NR 7 HAS CORROSION ON TOP EDGES AT LOCATIONS X187.5, X207, X213.5 AND X222. REPAIRED IAW DHC-8 SRM 51-40-11.SDR CALA0200537Seat Track · corrodedINSPECTION FOUND R/H I/B SEAT TRACK CORRODED AT STA 218-265. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-05-4F AND 53-05-4B1.SDR 0203843220Seat Track · corrodedDuring "M"check found corrosion on seat track at BS 1292 on frame 54 plus 20" and frame 52 plus 14". Repaired per EA32-192349.SDR MALA020645Structure · corrodedDURING A11 INSPECTION IN CWA, MAINTENANCE FOUND RT SEAT TRACK WRAP AROUND HAS CORROSION. MAINTENANCE REMOVED AND REPLACED RT SEAT TRACK WRAP AROUND IAW SRM CHAP 51. A/C RELEASE DATE 11/12/02SDR CALA0200534Seat Track · corrodedINSPECTION FOUND L/H I/B SEAT TRACK CORRODED AROUND HOLES AT STA 1193-1309. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-5.SDR ASAA0280521Seat Track · corrodedOKC - FOUND DURING 30K CHECK, SEAT TRACK IS CORRODED AT FS 237. REPLACED SEAT TRACK PER SRM 53-05, FIG 4F. (M)SDR ASAA0280528Cargo Track · corrodedOAK - FOUND C-CHECK, AFT CARGO BAY LEFT TIEDOWN TRACK IS CORRODED FROM FS 1212 TO 1338 AT LONGERON 27L. REPLACED TIEDOWN TRACK PER SRM 51-10-4 AND 51-30-0. (M)SDR ASAA0280527Cargo Track · corrodedOAK - FOUND C-CHECK, AFT CARGO BAY LEFT TIEDOWN TRACK IS CORRODED FROM FS 1212 TO 1338. REPLACED TIEDOWN TRACK PER SRM 51-10-4 AND 51-30-0. (M)SDR QXEA0201836Seat Track · damagedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 3 HAS MARRED EDGES AND MISSING PAINT AT STATION X529 AND X514. REPAIRED IAW RD 8-53-1342 AND DHC 8 SRM 51-20-36.SDR QXEA0201842Seat Track · corrodedPDX - SEAT TRACK NR 9 HAS CORROSION NEAR RIVETS BETWEEN STATIONS X200 AND X220. REPAIRED IAW RD 8-53-4473, RD 8-53-1102 AND DHC-8 SRM 51-40-11.SDR QXEA0201839Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 1 HAS LIGHT PITTING CORROSION AT STATION X418. REPAIRED IAW DHC-8 SRM 51-40-00 AND SRM 51-40-11.SDR CALA0200530Seat Track · corrodedINSPECTION FOUND R/H O/B SEAT TRACK CORRODED FROM STA 907-927. REPLACED SEAT TRACK IAW SRM 53-00-52.SDR CALA0200528Seat Track · corrodedINSPECTION FOUND CABIN L/H I/B SEAT TRACK CORRODED FROM STA 380-420. THE SEAT TRACK WAS REPLACED IAW SRM 53-30-52.SDR SWIA200211530Screw · corrodedFLOOR SEAT TRACKS HAVE CORROSION ON 90 PERCENT OF SCREW HEADS. FOUND DURING C CHECK INSPECTION. REPLACED RT AND LT FLOOR SEAT TRACKS AND ATTACHING HARDWARE IAW EMB MM 53-01-05.SDR ASAA0210279Seat Track · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SEAT TRACK AT BS 864, LEFT BUTTOCK LINE 25 CORRODED. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0210278Seat Track · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SEAT TRACK AT BS 863, LEFT BUTTOCK LINE 25 CORRODED. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASA0240174Seat Track · damagedPAE - DURING CHECKED, FOUND SEAT TRACKS IS DAMAGED AT BS 540 LEFT AND RIGHT BL 25, LEFT AND RIGHT BL 45 AND WL 208. REPAIRED IAW SRM. (M)SDR QXEA0201913Seat Track · corrodedPDX - SEAT TRACK NR 5 HAS SURFACE CORROSION BETWEEN LOCATIONS X465 AND X473. REPAIRED IAW RD 8-53-1339 AND DHC-8 SRM 51-20-36.SDR QXEA0201910Seat Track · corrodedPDX - SEAT TRACK NR 5 HAS SURFACE CORROSION BETWEEN STATIONS X515 AND X519. REPAIRED IAW RD 8-53-1339 AND SRM 51-20-36.
Back to JASC 5347