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 SIMA200719111Seat Track · corrodedLEFT OUTBOARD SEAT TRACK BETWEEN FRAME 17 AND 23 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719110Seat Track · corrodedRIGHT INBOARD SEAT TRACK BETWEEN FRAME 47 AND 53 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719109Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK BETWEEN FRAME 24 AND 36 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719102Seat Track · corrodedLEFT INBOARD SEAT TRACK BETWEEN FRAME 53 AND 55 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06 AND AMERICAN EAGLE ENGINEERING TECHNICAL NOTICE EM-53-110R2. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719115Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK BETWEEN FRAME 36 AND 47 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICESDR SIMA200719107Seat Track · corrodedLEFT INBOARD SEAT TRACK BETWEEN FRAME 36 AND 47 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06 AND AMERICAN EAGLE ENGINEERING TECHNICAL NOTICE EM-53-110R2. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719106Seat Track · corrodedLEFT OUTBOARD SEAT TRACK BETWEEN FRAME 47 AND 53 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06 AND AMERICAN EAGLE ENGINEERING TECHNICAL NOTICE EM-53-110R2. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719104Seat Track · corrodedLEFT OUTBOARD SEAT TRACK BETWEEN FRAME 36 AND 47 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719103Seat Track · corrodedLEFT OUTBOARD SEAT TRACK BETWEEN FRAME 53 AND 55 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICESDR SIMA200719116Seat Track · corrodedRIGHT INBOARD SEAT TRACK BETWEEN FRAME 24 AND 36 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719114Seat Track · corrodedLEFT INBOARD SEAT TRACK BETWEEN FRAME 47 AND 53 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719113Seat Track · corrodedLEFT OUTBOARD SEAT TRACK BETWEEN FRAME 24 AND 36 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719108Seat Track · corrodedLEFT INBOARD SEAT TRACK BETWEEN FRAME 24 AND 36 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06 AND AMERICAN EAGLE ENGINEERING TECHNICAL NOTICE EM-53-110R2. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719105Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK BETWEEN FRAME 47 AND 53 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06 AND AMERICAN EAGLE ENGINEERING TECHNICAL NOTICE EM-53-110R2. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719101Seat Track · corrodedRIGHT AFT INBOARD SEAT TRACK BETWEEN FRAME 53 AND 57 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06 AND AMERICAN EAGLE ENGINEERING TECHNICAL NOTICE EM-53-110R2. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719117Seat Track · corrodedLEFT INBOARD SEAT TRACK BETWEEN FRAME 17 AND 23 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR ABXA070190Seat Track · corrodedSEAT TRACK CORRODED AT SPLICE FS 590, RIGHT BUTT LINE 44.5. REMOVED AND REPLACED TRACK IAW DC9 SRM 51-30-1.SDR ABXA070192Seat Track · corrodedCENTER SEAT TRACK CORRODED AT FS 590. REMOVED AND REPLACED SEAT TRACK IAW DC9 SRM 51-30-1.SDR ABXA070191Seat Track · corrodedSEAT TRACK CORRODED AT FS 590, LEFT BUTT LINE 22.5 AT SPLICE. REMOVED AND REPLACED SEAT TRACK LEFT BUTT LINE 22.5, FS 590 - 661 IAW DC9 SRM 51-30-1 AND 51-10-4.SDR QXEA200700888Seat Track · corrodedC4 PDX - SEAT TRACK WEB IS CORRODED AROUND SCREW HOLE AT STATION X 1.03 OUTBOARD OF LEFT INBOARD SEAT TRACKS. REPAIRED IAW SRM 51-21-00.SDR 200714308Seat Track · corrodedFOUND LEFT INBOARD SEAT TRACK BETWEEN FRAMES 17 AND 23 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM. RETURNED AIRCRAFT TO SERVICE.SDR 200714317Seat Track · corrodedRIGHT AFT INBOARD SEAT TRACK BETWEEN FRAMES 53 AND 57 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM AND ETN EM-53-110R2. RETURNED AIRCRAFT TO SERVICE.SDR 200714309Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAME 47 AND 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM AND ETN EM 53-110R2. RETURNED AIRCRAFT TO SERVICE.SDR 200714325Seat Track · corrodedLEFT INBOARD SEAT TRACK BETWEEN FRAMES 47 AND 53 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM. RETURNED AIRCRAFT TO SERVICE.SDR 200714318Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK BETWEEN FRAMES 24 AND 36 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM. RETURNED AIRCRAFT TO SERVICE.SDR 200714316Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK BETWEEN FRAMES 36 AND 47 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM. RETURNED AIRCRAFT TO SERVICE.SDR 200714310Seat Track · corrodedFOUND LEFT OUTBOARD SEAT TRACK BETWEEN FRAMES 36 AND 47 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM. RETURNED AIRCRAFT TO SERVICE.SDR 200714324Seat Track · corrodedRIGHT INBOARD SEAT TRACK BETWEEN FRAMES 36 AND 47 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM. RETURNED AIRCRAFT TO SERVICE.SDR 200714323Seat Track · corrodedLEFT OUTBOARD SEAT TRACK BETWEEN FRAMES 53 AND 55 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM. RETURNED AIRCRAFT TO SERVICE.SDR 200714320Seat Track · corrodedLEFT INBOARD SEAT TRACK BETWEEN FRAMES 53 AND 55 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM AND ETN EM-53-110R2. RETURNED AIRCRAFT TO SERVICE.SDR 200714321Seat Track · corrodedRIGHT INBOARD SEAT TRACK BETWEEN FRAMES 47 AND 53 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM. RETURNED AIRCRAFT TO SERVICE.SDR 200714314Seat Track · corrodedLEFT OUTBOARD SEAT TRACK BETWEEN FRAMES 17 AND 23 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM. RETURNED AIRCRAFT TO SERVICE.SDR 200714313Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAME 47 AND 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM AND ETN EM 53-110R2. RETURNED AIRCRAFT TO SERVICE.SDR 200714312Seat Track · corrodedRIGHT INBOARD SEAT TRACK BETWEEN FRAMES 24 AND 36 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM. RETURNED AIRCRAFT TO SERVICE.SDR 200714319Seat Track · corrodedLEFT INBOARD SEAT TRACK BETWEEN FRAMES 36 AND 47 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM AND ETN 53-110R2. RETURNED AIRCRAFT TO SERVICE.SDR 200714315Seat Track · corrodedLEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 24 AND 36. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM AND ETN 53-110R2.SDR 200714311Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 24 AND 36. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM. RETURNED AIRCRAFT TO SERVICE.SDR 07FDEA01928Seat Track · damagedMAIN DECK CARGO COMPARTMENT, SEAT TRACK STA 765 X= 8.5 FOUND BROKEN. [SUP 06-08-07] REPAIR CARRIED OUT AS PER SRM 53-70-00 VOLUME I, FIGURE 1. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 07FDEA01927Seat Track · corrodedA 2.0 SQ INCH AREA OF CORROSION EXIST AT MDCC SEAT TRACK L-6 FRAME 34, 1 SEAT TRACK AND 4 REPAIR ANGLES IAW A310 SRM 53-10-16. ALODINED PRIMED AND TOP COATED IAW SRM 51-75-10. INSTALLED SEAT TRACK AND 4 REPAIR ANGLES IAW A310 SRM 53-10-16.SDR ABXA070189Seat Track · crackedCRACK FROM UPPER OUTBOARD BOLT HOLE TO EDGE OF FITTING - BELOW SEAT TRACK AT RIGHT BUTT LINE 44, FS 680. REMOVED AND REPLACED FITTING IAW DC9 SRM 51-30-5.SDR 07FDEA01924Seat Track · corrodedA 1.5 SQ INCH AREA OF CORROSION EXIST AT MDCC SEAT TRACK L-5 FRAME 34 FAVED 1 SEAT TRACK AND 4 REPAIR ANGLES PER SRM 53-10-16, ALODINED PRIMED TOP COATED PER SRM 51-75-10. INSTALLED SEAT TRACK AND 4 REPAIR ANGLES IAW SRM 53-10-16.SDR USAA070389Seat Track · corrodedFRAME 23, RIGHT OUTBOARD SEAT TRACK -Y760 HAS CORROSION. SPLICED IN NEW SECTION IAW SRM 53-00-15 FIG 201, DEFECT SIZE: 1 INCH DIA.SDR TRAX200700692Seat Track · corrodedLT SIDE PASSENGER SEAT SIDE RAILS CORRODED AND GOUGED AS MARKED FWD OF FS 409+128. BLENDED SIDEWALL SEAT RAIL PN 601R38312-31 AT FS 385 TO DEMINSIONS OF 1"X1"X.007 DEEP. BLENDED SIDEWALL SEAT RAIL PN 601R38312-29 AT STA 409+22 TO DEMINSIONS OF 1"X1"X .007 DSDR TRAX200700695Seat Track · corrodedRIGHT SIDE PASSENGER SEAT SIDE RAILS CORRODED AND GOUGED AS MARKED AFT OF FS 409+128. BLENDED SIDEWALL SEAT RAIL P/N 601R38312-115 AT STA 449.85 TO DIMENSIONS OF 1" X 1" X .007 DEEP AND AT STA 495.98 TO DIMENSIONS OF 1" X 1" X .008 DEEP. BLENDED SIDEWALL SEASDR TRAX200700694Seat Track · corrodedRIGHT SIDE PASSENGER SEAT SIDE RAILS CORRODED AND GOUGED AS MARKED FWD OF FS 409+128. BLENDED SIDE WALL SEAT TRACK P/N 601R38312-29 AT FS 409+86 TO DIMENSION OF 1" X 1" X .004 DEEP AS PER CRJ200 SRM 51-12-00. RECEIVED DAMAGE LIMITS FROM BOMBARDIER, LIMITS OFSDR TRAX200700693Seat Track · corrodedLEFT SIDE PASSENGER SEAT SIDE RAILS CORRODED AND GOUGED AS MARKED AFT OF FS 409+128. BLENDED SIDE WALL SEAT RAIL P/N 601R38312-21 AT FS 409+130 TO DIMENSIONS OF 1" X 3" X .017 DEEP AND AT FS 409+147 TO DIMENSIONS OF 1" X 1" X .007 DEEP. BLENDED SIDEWALL SEATSDR F3LA200700116Seat Track · corrodedDURING C-3 CHECK, INSPECTION REPORTED SURFACE CORROSION ON CABIN FLOOR FR20 AT -Y765 (RT I/B SEAT TRACK). REPLACED SEAT TRACK IAW SRM 51-42-11 AND 51-72-11.SDR UPS07M50459Seat Track · corrodedINSPECTION TYPE:C CABIN - SEAT TRACK AT STA 1965 LBL 107 FOUND CORRODED. CORRODED EXISTING TRACK TRIMMED OFF FR STA 1831-2007 PER SRM 53-70-00 V1 FIG 7R.38. HFEC INSP C/OUT PRT DAC NDTSPM R.13 06-10-01.001 FOUND NO CRACK EVIDENT. SEAT TRACK SPLICE HAT, SPLISDR UPS07M50094Seat Track · corrodedINSPECTION TYPE:C CABIN-SEAT TRACK BETWEEN STA889-919 RBL=107 FOUND CORRODED. REMOVAL C/OUT ON SEAT TRACK AREA TO EXECUTE REPAIR AS NECESSARY. REPAIRED S/TRACK SPLICE HAT AND SPLICE PLATE FAB PER SRM 53-70-00.V2.R 38. PICKED UP HOLES FOR FAB PARTS PER SRM 5SDR MALA070065Seat Track · corrodedSEAT TRACK AT LBL 18.3 AND STA 298 IS CORRODED OUT OF ALLOWABLE LIMITS. INSTALLED REPAIR DOUBLER IAW MESABA EO S53342. REFERENCE EAMS WORK ORDER 216422 TASK 1509.
Back to JASC 5347