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 QXEA200501691Seat Track · gougedYYC - DURING C3 CHECK, RIGHT OUTBOARD SEAT RAIL HAS SCRATCHES GOUGES AND NICKS AT STATION 490-569. REPAIRED IAW REO 670-53-00-013.SDR QXEA200501690Seat Track · gougedYYC - DURING C3 CHECK, RIGHT OUTBOARD SEAT RAIL HAS SCRATCHES GOUGES AND CHAFING AT STATION 381-662. REPAIRED IAW REO 670-53-00-013.SDR QXEA200501669Seat Track · corrodedYYC - DURING C3 CHECK, FUSELAGE INTERIOR RIGHT INBOARD SEAT RAIL AT STATION 349-485 CORRODED. MAINTENANCE REPAIRED SEAT RAIL IAW REO 670-53-00-013.SDR QXEA200501658Seat Track · gougedYYC - DURING C3 CHECK, RIGHT SIDE OF SEAT RAIL AT STATION 858 HAS A GOUGE. MAINTENANCE REPAIRED DAMAGE IAW REO 670-53-00-013.SDR QXEA200501666Seat Track · corrodedYYC - DURING C3 CHECK, LEFT SIDE SEAT RAIL AT STATION 856 HAS AREAS OF CORROSION. MAINTENANCE REMOVED CORROSION IAW CRJ-700 REO 670-53-00-013. RESTORED FINISH.SDR QXEA200501659Seat Track · corrodedYYC - DURING C3 CHECK, RIGHT SIDE SEAT RAIL AT STATION 785-797 HAS AREAS OF CORROSION. MAINTENANCE REMOVED CORROSION IAW CRJ-700 REO 670-53-00-013.SDR QXEA200501661Seat Track · corrodedYYC - DURING C3 CHECK, RIGHT SIDE SEAT RAIL AT STATION 677-712 HAS CORROSION ON INNER SEAT ATTACH LUG. MAINTENANCE REMOVED CORROSION IAW REO 670-53-00-013. RESTORED FINISH.SDR QXEA200501656Seat Track · gougedYYC- DURING C3 CHECK, RIGHT SIDE SEAL RAIL STATION 916 TO 920 HAS GOUGES ON RAIL. MAINTENANCE REPAIRED IAW REO 670-53-00-013. RESTORED FINISH.SDR QXEA200501662Seat Track · corrodedYYC - DURING C3 CHECK, LEFT SIDE SEAT RAIL AT STATION 677-712 HAS CORROSION. MAINTENANCE REPAIRED CORROSION IAW REO 670-53-00-013. RESTORED FINISH.SDR QXEA200501663Seat Track · corrodedYYC - DURING C3 CHECK, LEFT SIDE SEAT RAIL AT STATION 713-760 HAS AREAS OF CORROSION. MAINTENANCE REPAIRED AREAS IAW CRJ-700 REO 670-53-00-013. RESTORED FINISH.SDR QXEA200501665Seat Track · corrodedYYC - DURING C3 CHECK, LEFT SIDE SEAT RAIL AT STATION 809-830 HAS AREAS OF CORROSION. MAINTENANCE REPAIRED CORRODED AREAS IAW REO 670-53-00-013. RESTORED FINISH.SDR QXEA200501664Seat Track · corrodedYYC - DURING C3 CHECK, LEFT SIDE SEAT RAIL AT STATION 785-797 HAS AREAS OF CORROSION ON INNER SEAT ATTACH LUG. MAINTENANCE REPAIRED CORRODED AREAS IAW CRJ-700 REO 670-53-00-013. RESTORED FINISH.SDR QXEA200501660Seat Track · corrodedYYC - DURING C3 CHECK, RIGHT SIDE SEAT RAIL AT STATION 713-760 HAS AREAS OF CORROSION. MAINTENENCE REMOVED CORROSION IAW CRJ-700 REO 670-53-00-013. RESTORED FINISH.SDR USAA051263Seat Track · corrodedFOUND SEAT TRACK CORRODED, LBL 45 BS 500A + 12. BLENDED AREA, WITHIN LIMITS IAW SRM 53-00-52, DEFECT SIZE: 1" BY 2".SDR USAA051264Seat Track · corrodedFOUND SEAT TRACK CORRODED, LBL 45 BS 494. BLENDED WITHIN LIMITS IAW SRM 53-00-52, DEFECT SIZE: 1" BY 2".SDR QXEA200501551Seat Track · corrodedPDX: RT OUTBOARD SEAT TRACK IS CORRODED AT STA X137-X140, X154-X157, X169 AND X200. MAINTENANCE REPAIRED IAW RD 8/4-53-844 AND NDTM PART 6, 51-00-02-250-801.SDR QXEA200501550Seat Track · corrodedPDX: RT OUTBOARD SEAT TRACK HAS LIGHT CORROSION AT FWD 2 INCHES OF TRACK. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-02-250-801.SDR QXEA200501500Seat Track · corrodedPDX: LT INBD SEAT TRACK SHOWS SIGNS OF CORROSION ALONG PREVIOUS REPAIR FROM APPROX STA X609-X621. MAINTENANCE REPAIRED IAW Q400 RD 8/4-53-884 AND Q400 NDTM PART 6, 51-00-02.SDR QXEA200501499Seat Track · corrodedPDX: LT INBD SEAT TRACK SHOWS SIGNS OF CORROSION ALONG PREVIOUS REPAIR FROM APPROX STA X481-X490. MAINTENANCE REPAIRED IAW Q400 RD 8/4-53-884 AND NDTM PART 6, 51-00-02.SDR QXEA200501498Seat Track · corrodedPDX: LT INBD SEAT TRACK SHOWS SIGNS OF CORROSION ALONG PREVIOUS REPAIR FROM APPROX STA X416-X422. MAINTENANCE REPAIRED IAW Q400 RD 8/4-53-884 AND NDTM PART 6, 51-00-02.SDR QXEA200501497Seat Track · corrodedPDX: LT INBD SEAT TRACK SHOWS SIGNS OF CORROSION ALONG PREVIOUS REPAIR FROM APPROX STA X376-X382. MAINTENANCE REPAIRED IAW Q400 RD 8/4-53-884 AND Q400 NDTM PART 6, 51-00-02.SDR GTIA050269Seat Track · crackedRT OB SEAT TRACK SWOLLEN AND CRACKED IN 2 PLACES AT APPROX FS465. CLEANED 2 SPOTS AND REMOVED SUSPECTED CRACK IAW SRM. PERFORMED HFEC OF RT OB SEAT TRACK AT FS 465 NO OTHER DEFECTS NOTED. PERFORMED ULTRASONIC THICKNESS OF SEAT TRACK WITHIN LIMITS, TREATED ASDR ASAA0540586Seat Track · corrodedPAE - FOUND CORROSION ON SEAT TRACK. REMOVED AND REPLACED CORRODED SEAT TRACK PER B737-400 SRM 53-00-52. (M)SDR ASAA0540577Seat Track · corrodedPAE - FOUND CORROSION ON SEAT TRACK. REMOVED AND REPLACED SEAT TRACK PER B737-400 SRM 51-40-52. (M)SDR ASOA05926Cargo Track · corrodedDURING A C-CHECK IN MCN, THE CARGO COMPARTMENT SEAT TRACKS WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE WILL REMOVE AND REPLACE THE CARGO COMPARTMENT SEAT TRACKS. (M)SDR 05FDEA03580Seat Track · crackedMAIN CABIN AT STA 1029 LT SIDE AT X27.500 ON SEAT TRACK FOUND 1EA CRACK 10 INCHES LONG. CUT OUT CRACKED SECTION OF SEAT TRACK, REPLACED NEW SECTION IAW SRM 53-70-00, FIG 1 SHT1-2, VOL1. FAB PARTS IAW DETAIL PARTS TRAVELER F161689/N01689.SDR UPS05545679Seat Track · corrodedINSPECTION TYPE:C4 MAIN CARGO SEAT TRACK CORRODED AT STA 1318, LBL 24. REPAIRED PER ER 05-4597.SDR UPS05545677Seat Track · corrodedINSPECTION TYPE:C4 MAIN CARGO SEAT TRACK CORRODED STA 1542 RBL 47 REPAIRED PER ER 05-4597.SDR AWXA200501288Seat Track · corrodedSAL - DURING C1 CHECK DISCOVERED CORROSION ON LT INBOARD SEAT TRACK AT Y765 AND FS 36+16". MAINTENANCE REMOVED SEAT TRACK FROM FS 36 TO FS 41 IAW AIRBUS 320 SRM 53-31-15. INSTALLED NEW SEAT TRACK FROM FS 36 TO FS 41 AT Y765 IAW AIRBUS 320 SRM 53-31-15 AND 5SDR UPS05M45896Seat Track · corrodedINSPECTION TYPE:C CABIN AT STA 1381 RT RBL 107.25 SEAT TRACK CROWN FOUND WITH CORROSION. CORROSION REMOVED PER SRM 51-2101 REV 31 VOL II AT SEAT TRACK & MAT REMOVED 0.038 INCH ORIG THK 0.100 INCH & FOUND EXCEED LIMIT PER SRM 53-70-00 VOL I REV 37 FIG 3. NEW SDR AWXA200501310Seat Track · corrodedSAL - MAJOR REPAIR - DURING C1 CHECK DISCOVERED CORROSION ON LT OUTBOARD SET TRACK AT FR37 AND Y1292. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-31-15 FIG 101. REMOVED SEAT TRACK FROM FS 36 TO FS 41 AT Y1292 IAW AIRBUS SDR AWXA200501290Seat Track · corrodedSAL - DURING C1 CHECK DISCOVERED CORROSION ON RT INBOARD SEAT TRACK AT Y-765 AND FR 40+15". MAINTENANCE REMOVED SEAT TRACK FROM FS 36 TO FS 41 IAW AIRBUS 320 SRM 53-31-15. INSTALLED NEW SEAT TRACK FROM FS 36 TO FS 42 AT Y-765 IAW AIRBUS 320 SRM 51-42-11 AND SDR AWXA200501289Seat Track · corrodedSAL - DURING C1 CHECK DISCOVERED CORROSION ON RT INBOARD SEAT TRACK AT Y-765 AND FS 42+18". MAINTENANCE REMOVED SEAT TRACK FROM FS 41 TO FS 47 IAW AIRBUS 320 SRM 51-42-11. INSTALLED NEW SEAT TRACK FROM FS 41 TO FS 47 AT Y-765 IAW AIRBUS 320 SRM 51-42-11 ANDSDR ASOA05884Seat Track · corrodedDURING A C-CHECK IN MCN, THE LEFT SEAT TRACK, AT S 785 TO FS 797, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE WILL REMOVE AND REPLACED THE LEFT SEAT TRACK, AT FS 785 TO 797. (M)SDR UPS05M45897Seat Track · corrodedINSPECTION TYPE:C CABIN AT STA 1321 LBL 27.5 SEAT TRACK CROWN FOUND CORRODED. CABIN STA 1321 LBL 27.5 SEAT TRACK CROWN CORROSION REMOVED PER SRM 53-70-00 FIG 3 VOL I REV 37 MAT ORIG THK 0.145: & MAT REMOVED 0.035 FOUND EXCEED LIMIT PER SRM 53-70-00 FIG 3 VOL SDR AWXA200501314Seat Track · corrodedMCN - DURING C18 CHECK DISCOVERED CORROSION ON SEAT TRACK AT BS 899 AND BL 45R. CORROSION WAS REMOVED AND WAS FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-00-52-1A 1 FIG 101. REMOVED SECTION OF SEAT TRACK FROM BS 887 TO BS 947 IAW BOEING 737-300 SRM 5SDR AWXA200501313Seat Track · corrodedMCN - DURING C18 CHECK DISCOVERED CORROSION ON SEAT TRACK AT BS 899 AND BL 45L. CORROSION WAS REMOVED AND WAS FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-00-52-1A 1 FIG 101. REMOVED SECTION OF SEAT TRACK FROM BS 887 TO BS 947 IAW BOEING 737-300 SRM 5SDR AWXA200501312Seat Track · corrodedMCN - DURING C18 CHECK DISCOVERED CORROSION ON SEAT TRACK AT BS 899 AND BL 25R. CORROSION WAS REMOVED AND WAS FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-00-52-1A 1 FIG 101. REMOVED SECTION OF SEAT TRACK FROM BS 887 TO BS 947 IAW BOEING 737-300 SRM 5SDR 2005UALA01158Seat Track · crackedCABIN SEAT TRACK AT GALLEY 4A FWD ATTACH POINT IS CRACKED, OUTBOARD SEAT TRACK.SDR UPS05545686Seat Track · corrodedINSPECTION TYPE:C4 MAIN CARGO SEAT TRACK CORRODED AT STA 1173, LBL 44.5. REMOVED AND REPLACED SEAT TRACK BS 1070 TO BS 1180 IAW SRM 53-00-52 AND SRM 51-40-02.SDR UPS05545744Seat Track · corrodedFOUND UPPER LOBE SEAT TRACK I/B FLANGE CORROSION AT NUT PLATE HOLE STA 1144 RBL 23. REPAIRED PER SRM 53-00-52-2R FIG 201 AND GOODRICH ER NR 05-4696.SDR UPS05545743Seat Track · corrodedFOUND UPPER LOBE SEAT TRACK IB FLANGE CORROSION, AT NUT PLATE HOLES STA 1084 TO STA 1153 LBL44. REMOVED AND REPLACED SEAT TRACK WITH NEW PER SRM 51-40-02.SDR UPS05545740Seat Track · corrodedFOUND BS 1321, WL 208, LBL 26, SEAT TRACK OUTBOARD FLANGE HAS AREA OF CORROSION. REPAIRED PER 53-00-52-2R AND GOODRICH ER NR 05-4696.SDR UPS05545739Seat Track · corrodedFOUND BS 1318, WL 208, RBL 45, SEAT TRACK UPPER SURFACE ON INBOARD FLANGE HAS 1EA AREA OF CORROSION. REPAIRED PER SRM 53-00-52-2R AND GOODRICH ER#05-4696.SDR UPS05545738Seat Track · corrodedFOUND MAIN DECK CARGO TRACK RT FLANGE HAS CORROSION. REPAIRED PER SRM 53-00-52-2R AND GOODRICH ER NR 05-4696.SDR UPS05545737Seat Track · corrodedFOUND MAIN DECK CARGO FLOOR SEAT TRACK HAS CORROSION BS 585, LBL24 WL208. REPAIRED PER SRM 53-00-52-2R.SDR UPS05545736Seat Track · corrodedFOUND MAIN DECK CARGO SEAT TRACK O/B FLANGE HAS CORROSION BS 440, LBL26, WL208. REPAIRED PER SRM 53-00-52-2R AND GOODRICH ER NR 05-4696.SDR QXEA200501410Seat Track · corrodedYYC - FUSELAGE INT, LEFT O/B SEAT RAIL AT FS 585 HAS PITTING CORROSION ON I/B FACING SURFACE. MAINTENANCE REPAIRED IAW REO 670-53-00-013 REV A.SDR QXEA200501409Seat Track · corrodedYYC - FUSELAGE INT, LEFT O/B SEAT RAIL AT FS 616 HAS PITTING CORROSION ON I/B FACING SURFACE. MAINTENANCE REPAIRED IAW REO 670-53-00-013 REV A.SDR QXEA200501406Seat Track · corrodedYYC - FUSELAGE INT, LEFT O/B SEAT RAIL AT FS 785 HAS PITTING CORROSION AND A TOOL MARK ON I/B FACING SURFACE. MAINTENANCE REPAIRED IAW REO 670-53-00-013 REV A.
Back to JASC 5347