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 DHL200374266Seat Track · damagedDURING C-CHECK, NR 5 SEAT TRACK AT BS 480 IS DAMAGED. REMOVED DAMAGED SEAT TRACK AND FABBED NEW FROM BAC1520-792 PO 902203 DIM 158.5 INCH AND TWO SPLICE ANGLES FROM BAC1503-100122 PO 900221 DIM 14 INCH X 2.5 INCH AND 1 EA SPLICE PLATE FROM 7075-T6 .250 PO 991SDR USAA030287Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED .125 SQUARE INCH AREA, FRAME 63 RBL 17.75. DAMAGED TRACK REMOVED AND REPLACED WITH NEW SECTION PER SRM 51-74-00 AND 51-72-11. (M)SDR USAA030294Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED .150 SQUARE INCH, FRAME 58 RBL 17.75. DAMAGED TRACK REMOVED AND REPLACED WITH NEW PER SRM 51-74-00 AND 51-72-11. (M)SDR USAA030295Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED .125 SQUARE INCH, FRAME 57.4 RBL 17.75. DAMAGED TRACK REMOVED AND REPLACED WITH NEW SECTION PER SRM 51-74-00 AND 51-72-11. (M)SDR USAA030296Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED .150 SQUARE INCH AREA, FRAME 57.3 RBL 17.75. DAMAGED TRACK REMVOED AND REPLACED WITH NEW SECTION PER SRM 51-74-00 AND 51-72-11. (M)SDR USAA030293Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED .125 SQUARE INCH, RBL 17.75 FRAME 59. DAMAGED TRACK REMOVED AND REPLACED WITH NEW PER SRM 51-74-00 AND 51-72-11. (M)SDR USAA030298Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED .125 SQUARE INCH AREA, FS 57 RBL 17.75. DAMAGED TRACK REMOVED AND REPLACED WITH NEW SECTION PER SRM 51-74-00 AND 51-72-11. (M)SDR ASAA0380760Seat Track · gougedDRUING 15K CHECK, FOUND SEAT TRACK GOUGED. REPLACED TRACK PER SRM. (M)SDR DHL2003742520Seat Track · corrodedDURING C-CHECK DISCREPANCY AS FOLLOWS, NR 59977 FWD CARGO COMPARTMENT, CABIN SEAT TRACK AND SPLICE PARTS ARE CORRODED BETWEEN STA 680-700 RBL 24. REMOVED SPLICE OF SEAT TRACK BETWEEN STA 680 TO 700 RBL 24 IAW B-727 SRM 51-30-2. REMOVED LITE CORROSION OF SEATSDR DHL2003742517Seat Track · corrodedDURING C-CHECK, FWD CARGO COMPT CABIN SEAT TRACK AND SPLICE PARTS ARE CORRODED BETWEEN STA 680-700 RBL 45. REMOVED SPLICE OF SEAT TRACK BETWEEN STA 680-700 RBL 45 AND FABRICATED NEW SPLICE FROM MAT 7075-T6 .250 PO 9911344 DIM 6.75 X 2 INCH IAW B-727 SRM 53-1SDR SIMA200332701Seat Track · lack of lubeRDU - FLT 4852 - PILOT REPORTED AN UNCOMMANDED SEAT MOVEMENT. MAINTENANCE CLEANED AND LUBRICATED THE SEAT TRACK AND RAILS. OPERATIONAL CHECK WAS GOOD AND AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR QXEA200301507Seat Track · corrodedNR 1 SEAT TRACK HAS LITE SURFACE CORROSION ON TOP OF RAILS 7 INCHES AFT OF X354. REPAIRED IAW DHC-8 SRM 51-00-06 AND RD 8-53-1342.SDR QXEA200301506Seat Track · damagedNR 1 SEAT TRACK HAS DAMAGED LUGS FROM 2 TO 5 INCHES AFT OF X387. REPAIRED IAW DHC-8 SRM 51-00-06 AND RD 8-53-1342.SDR QXEA200301505Seat Track · corrodedNR 2 SEAT TRACK HAS LITE SURFACE CORROISON ON TOP OF RAILS FROM X434 TO 4 INCHES AFT OF X434. REPAIRED IAW DHC-8 RD 8-53-1342.SDR QXEA200301504Seat Track · corrodedNR 2 SEAT TRACK HAS LITE SURFACE CORROSION ON TOP OF RAILS AND IN THE BOTTOM OF CHANNEL FROM 7 TO 10 INCHES AFT OF STATION X445. REPAIRED IAW DHC-8 RD 8-53-1342.SDR QXEA200301503Seat Track · corrodedNR 2 SEAT TRACK HAS LITE SURFACE CORROSION ON RAILS AND IN BOTTOM OF CHANNEL FROM X467 TO 4 INCHES AFT OF X467. REPAIRED IAW DHC-8 RD 8-53-1342.SDR QXEA200301502Seat Track · corrodedNR 2 SEAT TRACK HAS LITE SURFACE CORROSION ON TOP OF RAILS AND BOTTOM OF CHANNEL FROM 2 TO 6 INCHES FORWARD OF STATION X488. REPAIRED IAW DHC-8 RD 8-53-1342.SDR QXEA200301501Seat Track · corrodedNR 2 SEAT TRACK HAS LITE SURFACE CORROSION ON RIGHT HAND RAIL AND IN BOTTOM OF CHANNEL 8 TO 12 INCHES FORWARD OF STATION X510. REPAIRED IAW DHC-8 RD 8-53-1342.SDR QXEA200301500Seat Track · corrodedNR 3 SEAT TRACK HAS LIGHT SURFACE CORROSION ON TOP OF RAILS FROM 5 TO 8 INCHES AFT OF X510. REPAIRED IAW DHC-8 SRM 51-00-06 AND RD 8-53-3644.SDR QXEA200301499Seat Track · corrodedPDX- NR 3 SEAT TRACK HAS LIGHT SURFACE CORROSION ON TOP OF LT RAIL AT X531. REPAIRED IAW DHC-8 SRM 51-00-06 AND RD'S 8-53-3644 AND 8-53-1342.SDR QXEA200301498Seat Track · corrodedPDX- NR 5 SEAT TRACK HAS CORROSION IN BOTTOM OF CHANNEL 9 INCHES FORWARD OF X510. REPAIRED IAW DHC-8 SRM 51-20-16, 51-00-06 AND RD 8-53-1339.SDR QXEA200301497Seat Track · corrodedPDX- NR 5 SEAT TRACK HAS SURFACE CORROSION IN BOTTOM OF CHANNEL FROM 6 TO 9 INCHES AFT OF X510. REPAIRED IAW DHC-8 SRM 51-20-16, 51-00-06 AND RD 8-53-1339.SDR QXEA200301496Seat Track · corrodedNR 11 SEAT TRACK HAS CORROSION ON INSIDE AT STATION X486.45, 466.45 AND 454.45. REPAIRED IAW DHC-8 SRM 51-20-16, 51-00-06 AND RD 8-53-1342.SDR MALA030520Seat Track · gougedDURING E-CHECK INSPECTION. CABIN AFT LT AISLE SEAT TRACK AT STA 575 TO STA 686 HAS GOUGES. MAINTENANCE RECEIVED NEW SECTION OF SEAT TRACK, CUT, TRIMMED, ALODINED AND PRIMED, INSTALLED NEW SECTION OF SEAT TRACK IAW MESABA EO NR A53060 DATED 11/3/03. A/C RELEASDR MALA030517Seat Track · corrodedDURING E-CHECK INSPECTION PERFORMED BY TIMCO, LAKE CITY, FL. CABIN AFT CENTER SEAT TRACK CORRODED AT STA 649-686. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK AND INSTALLED NEW SECTION IAW MESABA EO A53060. A/C RELEASE DATE 12/2/03.SDR MWEA030446Seat Track · corrodedNR 4 SEAT TRACK HAS CORROSION IN SEVERAL PLACES FROM STATION 200 - 256. FABRICATED AND INSTALLED SEAT TRACK SECTION.SDR MWEA030444Seat Track · corrodedCORROSION ON NR 1 SEAT TRACK AT STATION 625. CUT OUT DAMAGE AND INSTALLED REPAIR.SDR ASAA0380798Seat Track · gougedOKC - DURING 15K CHECK, FOUND RT SEAT TRACK IS GOUGED AT FS 200-275. REPLACED TRACK IAW SRM 53.05. (M)SDR MALA030513Seat Track · corrodedDURING E-CHECK INSPECTION. STA 294 BL 0 SEAT TRACK CORRODED. MAINTENANCE REMOVE DAMAGED SEAT SECTION AND INSTALLED NEW SECTION, IAW MESABA EO A53060, DATED 11/3/03. A/C RELEASE DATE 12/2/03. REFER TO 409 NR 1206073 FOR FURTHER DETAIL.SDR SWIA200312673Seat Track · corrodedLEFT SIDE AFT SECTION OF SEAT TRACK NEEDS TO BE REPLACED DUE TO CORROSION ABOVE SCREW HOLES. DISCOVERED DURING C-CHECK INSPECTION. REMOVED AND REPLACED LT SIDE AFT SECTION OF SEAT TRACK AS REQUIRED.SDR C1HA200394045Seat Track · corrodedSEAT TRACK BS 959 - 1140 RBL 24 HAS BARE METAL AND CORROSION.SDR DHL2003802508Seat Track · wornUPPER CARGO COMPT NR 2 TRACK LUG WORN, STA 65.000. CUT OUT DAMAGED SECTION OF TRACK NR 2 IAW SRM 53-2-3 PG 17 FIG 6D. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG AND CHANNEL IAW SRM 51-3-0 PG 1.SDR MALA030493Seat Track · corrodedDURING A C2 INSPECTION, TIMCO FOUND NR 2 MAIN CABIN SEAT RAIL WAS EXFOLIATED. REPLACED SEAT RAIL AND INSTALLED REPAIR PER EO A53026.SDR DHL2003802510Cargo Track · wornUPPER CARGO COMPT TRACK PLUG WORN, STA 684.000. REMOVED NR 4 TRACK PLUG, STA 684.000 IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG IAW SRM 51-3-0 PG 1.SDR DHL2003802509Cargo Track · corrodedUPPER CARGO COMPT NR 4 TRACK FLANGE CORRODED, STA 952.000. REMOVED FASTENERS IAW SRM 51-3-0 PG 1. REMOVED CORROSION FROM NR 4 TRACK FLANGE, STA 952.000 IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS IAW SRM 53-2-3 FIG 12. CUT OUT NR 4 TRACK DAMAGED SECTION ISDR C1HA200394040Seat Track · corrodedSEAT TRACK BS 1010 - 1148 LBL 45.5 HAS HEAVY CORROSION.SDR C1HA200394039Seat Track · corrodedSEAT TRACK BS 344 - 480 LBL 45.5 HAS LIGHT CORROSION AND WORN AREAS.SDR C1HA200394038Seat Track · corrodedSEAT TRACK BS 868 - 950+9 LBL 24.75 HAS LIGHT CORROSION AND WORN AREAS.SDR C1HA200394037Seat Track · corrodedSEAT TRACK BS 344 - 480 LBL 24.75 HAS CORROSION AND WORN AREAS.SDR C1HA200394036Seat Track · corrodedSEAT TRACK BS 480 - 689.45 LBL 45.5 HAS CORROSION AND WORN AREAS.SDR C1HA200394035Seat Track · corrodedSEAT TRACK BS 480 - 689.45 LBL 24.75 HAS CORROSION AND WORN AREAS.SDR UPS03841605Seat Track · corrodedINSPECTION TYPE: C3, CORROSION ON SEAT TRACK FS 570, LBL46. REMOVED CORROSION IAW DC8 SRM 51-1-8. FOUND OUT OF LIMITS IAW SRM 5 3-2-3. INSTALLED NEW SEAT TRACK S4755395 AND 4 FITTING SEAT TRACK SUPPORT AND 2 SPLICES IAW UPS EO DC8-5320-8309-D AND DC8-5320-5SDR C1HA200394028Seat Track · corrodedSEAT TRACK BS 689 - 741, LBL 24.75 HAS AREAS OF CORROSION AND WORN AREAS.SDR C1HA200394025Seat Track · corrodedSEAT TRACK BS 480-690, RBL 24 HAS BARE METAL & CORROSION AS MARKED.SDR C1HA200394024Seat Track · corrodedSEAT TRACK BS 852 - 868, LBL-45.5 HAS LIGHT CORROSION AS MARKED.SDR C1HA200394034Seat Track · corrodedSEAT TRACK AT BS 689.5 - 741 LBL 24.75 HAS CORROSION AND WORN AREAS.SDR C1HA200394033Seat Track · corrodedSEAT TRACK BS 741 - 757 LBL 45.5 HAS BARE METAL, CORROSION AND WORN AREAS.SDR C1HA200394032Seat Track · corrodedSEAT TRACK AT BS 344 - 380 RBL 56 HAS BARE METAL AND CORROSION.SDR C1HA200394031Seat Track · corrodedSEAT TRACK AT BS 344 - 480 RBL 45 HAS BARE METAL AND CORROSION.SDR C1HA200394030Seat Track · corrodedSEAT TRACK AT BS 480 - 580 RBL 45 HAS BARE METAL AND CORROSION.
Back to JASC 5347