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 KCSA071183Seat Track · corrodedMAIN DECK SEAT TRACK IS CORRODED AT O/B FLANGE RBL 83 FROM STA 390 TO 402.SDR KCSA071182Seat Track · corrodedMAIN DECK SEAT TRACK IS CORRODED AT LBL 11 FROM STA 1770 TO 1815.SDR 2007UALA01773Seat Track · wornRT IB SEAT TRACK BETWEEN FRAME 42 -47 HAS WORN AREAS BEYOND LIMITS. MAJOR REPAIR ACCOMPLISHED: REPLACED FLOORBEAM.SDR KCSA071176Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED AT BS 1152, LBL 74.SDR SIMA200719201Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 53 AND 55. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719203Seat Track · corrodedRIGHT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 21 AND 24. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719204Seat Track · corrodedLEFT FORWARD INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 20 AND 21. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719202Seat Track · corrodedLEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 21 AND 24. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719118Seat 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 SIMA200719119Seat 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 TRAX200700783Seat Track · corrodedFOUND CORROSION ON SEAT TRACK IN CARGO FROM FS 540 TO FS 616, SEE ADDITIONAL WORK SHEET.SDR DHL2007783504Seat Track · corrodedCABIN SEAT TRACK CORRODED BETWEEN BS 760 TO BS 825, RBL 24. REMOVED SEAT TRACK SECTION BS 757.45 TO BS 852.45, RBL 45 IAW B727 SRM 51-30-2. LOCATED AND DRILLED NEW SEAT TRACK P/N BAC1520-841 IAW B727 SRM 51-30-5 AND 53-10-2, FIG 7. PART AND AREA TREATED, PRSDR DHL2007783503Seat Track · corrodedCABIN SEAT TRACK CORRODED BETWEEN BS 760 TO BS 825, RBL 45. REMOVED SEAT TRACK SECTION BS 757.45 TO BS 852.45, RBL 45 IAW B727 SRM 51-30-2. LOCATED AND DRILLED NEW SEAT TRACK P/N BAC1520-841 IAW B727 SRM 51-30-5 AND 53-10-2, FIG 7. PART AND AREA TREATED, PSDR 07FDEA02050Track · damagedMAIN CABIN, ADAPTER TRACK, FRAME 30, BL Y60, DAMAGED. REMOVED AND RELPACED ADAPTER TRACK IAW A300-600 SRM 51-40-20, PARAGRAPH 7.SDR DLM88070685Seat Track · corrodedCORROSION ON SEAT TRACK X=44 BETWEEN STA Y=220 TO 226. SEAT TRACK SECTION BETWEEN STA 200 TO 303 REPLACED WITH REPAIR SPLICE AT STA 303 IAW SRM 53-05 FIG 4F VIEW A.SDR 07FDEA02041Seat Track · corrodedCABIN FLOOR SEAT TRACK HAS CORR, FS 460-620, RBL-24". REMOVED CORRODED SEAT TRACK AT RBL 24 , STA 480 TO 620 IAW B727 SRM 53-10-5. FAB NEW SECTION OF SEAT TRACK PO 1142187. TREATED AND PRIMED IAW B727 SRM 51-10-2. INSTALLED SEAT TRACK IAW B727 SRM 53-10-SDR 07FDEA02042Cargo Track · wornMAIN CARGO COMPT AT FR 62, 27" TO 36" RIGHT OF BL, TIEDOWN TRACK WORN. REMOVED AND REPLACED ADAPTER TRACK IAW A300-600 SRM 51-40-21, PARAGRAPH 7.SDR ASAA0791812Cargo Track · corrodedAFT CARGO PIT FLOOR RAIL SPLICE CORRODED. REPAIRED IAW SRM 51-40-05 AND 51-40-02.SDR ASAA0791811Cargo Track · corrodedAFT CARGO PIT RAIL SPLICE IS CORRODED. REPAIRED IAW 51-40-02 AND 51-40-03.SDR ASAA0791810Cargo Track · corrodedAFT CARGO PIT RAIL SPLICE CORRODED. REPAIRED IAW SRM 51-40-02 AND 51-40-03.SDR ASAA0791807Cargo Track · corrodedAFT CARGO PIT TIE DOWN TRACK SPLICE CORRODED. REPAIRED IAW 51-40-02 AND 51-40-05.SDR ASAA0791806Cargo Track · corrodedAFT CARGO PIT TIE DOWN SPLICE CORRODED. REPAIRED IAW SRM 51-40-02 AND 51-40-05.SDR ASAA0791800Cargo Track · corrodedAFT CARGO RT CARGO TIE DOWN TRACK CORRODED. SPLICED IN NEW SECTION.SDR ASAA0791770Cargo Track · corrodedAFT CARGO PIT PH CARGO TIE DOWN CORRODED. REPAIRED IAW SRM 53-00-53.SDR ASAA0791769Cargo Track · corrodedCARGO PIT TIE DOWN TRACK CORRODED. REPAIRED IAW SRM 53-00-53.SDR ASAA0791750Cargo Track · gougedFWD CARGO PIT LEFT TIE DOWN TRACK GOUGED. REPAIRED IAW SRM 53-00-53.SDR 07FDEA02035Seat Track · corrodedUPPER CARGO COMPARTMENT, SEAT TRACK RBL 75 CORRODED AT STA 1301 TO STA 1361. [06-18-07] REPAIR CARRIED OUT AT UPPER CARGO COMPARTMENT, SEAT TRACK RBL 75, STA 1267 TO STA 1391 AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER SDR 07FDEA02031Track · corrodedMAIN DECK ADAPTER TRACK CORRODED AT APPROX FR 35, STA 2241, -Y890 REMOVED AND REPLACED ADAPTOR IAW A300-600 SRM 51-40-21 PARAG 7.SDR DHL2007803516Cargo Track · wornUPPER CARGO COMPT NR 6 TRACK LUGS WORN (STA 135.000 - 270.000). CUT OUT DAMAGED SEGMENT OF TRACK NR 6 AND FABRICATED SPLICES (AL7075T6 0.100"/ 0.125"/ 0.160") IAW SRM 53-2-3 PG 49-50. CLEANED, TREATED AND PRIMED AREA AND SPLICES IAW SRM 51-1-8B. INSTALLED NSDR KCSA071168Seat Track · corrodedSEAT TRACK O/B FLANGE HAS CORROSION FROM STA 390 TO 402 RBL 83.SDR ABXA070193Seat Track · corrodedSEAT TRACK AT STA 237 - 313, LEFT BUTT LINE 22 UNDER FLOOR PANEL 2B WAS CORRODED. REMOVED AND REPLACED SEAT TRACK IAW DC9 SRM 51-30-1.SDR 07FDEA01995Seat Track · wornMAIN CABIN DEEP WEAR ON SEAT TRACK. REPAIRED SECTION OF SEAT TRACK IAW SRM 53-70-00 PAGE 4 VOL 1.SDR DLM88070638Seat Track · corrodedFOUND CORROSION ON SEAT TRACK X = -54 AT STATIONS Y=271, 307, 326, 344, 364, 381, 416, 430, 448, 465, 470, 481, 498, 515, 531, 547, AND 564. DAMAGE AT STATIONS ABOVE WAS REMOVED IAW SRM 53-05D FIG 4A.SDR QXEA200700886Cargo Track · corrodedC4 PDX - AT X781 Z100 Y9L, THE TRACK HOLD DOWN CLEAT IS CORRODED. REPAIRED IAW RD8/4-53-884, AND SRM 51-40-07, 51-42-05.SDR 07FDEA01979Seat Track · corrodedCABIN FLOOR SEAT TRACK HAS CORROSION FS 640 LBL 1". REMOVED CORROSION IAW 727 SRM 51--10-2 FOUND TO BE OUT OF LIMITS AFTER CORROSION REMOVAL IAW SR 53-10-1. FABBED NEW SEAT TRACK IAW SRM 51-30-2 ,TREATED AND PRIMED IAW SRM 51-10-1. REMOVED AND INSTALLED SEASDR AWXA200700661Seat Track · corrodedSAL - CORROSION ON CABIN SEAT RAIL, +Y1292, FR 66. REPLACED CABIN SEAT RAIL,+Y1292, FR 64 - FR 66 IAW A320 SRM 51-72-11.SDR AWXA200700660Seat Track · corrodedSAL - CORROSION ON CABIN SEAT RAIL, -Y765, FR 66 + 4". REPLACED CABIN SEAT RAIL, -Y765, FR 64 - FR 66 IAW A320 SRM 51-72-11.SDR 07FDEA01973Seat Track · corrodedMAIN CABIN ON SEAT TRACK FOUND 1 SEVERE CORROSION WITH EXFOLIATION AND 6 ELONGATED HOLES, DISCREPANCY FOUND DURING ACF MODIFICATION. REPAIRED IAW SRM 53-70-00 FIG 1 VOL 1.SDR AMTA200700218Cargo Track · corrodedAFT PIT B/S 787 RBL 17 CORROSION EXISTS ADJACENT TO CARGO NET TIE DOWN FITTING ON LONGERON. REMOVED CORROSION SRM 51-10-02. ORIG .080 MECHANICAL MEASURE CALIPER NR 07-01 CAL DUE 07-03-07. LOSS .001-.003, DEPTH GAUGE NR 07-802 CAL DUE 08-12-07 IS WITHIN LIMISDR QXEA200700892Seat Track · corrodedC4 PDX - CORROSION ON LOWER SURFACEOF CARGO BAY FLOOR WEB BELOW NR 9 SEAT TRACK OUTBOARD FLANGE BETWEEN X728.102 AND X747.602. REPAIRED IAW SRM 51-21-00, 51-14-36, AND 51-25-45.SDR QXEA200700887Cargo Track · corrodedC4 PDX - AT X781 Z100 Y9R, THE TRACK HOLD DOWN CLEAT IS CORRODED. REPAIRED IAW RD8/4-53-884, SRM 51-40-15 AND 51-42-05.SDR QXEA200700890Seat Track · corrodedC4 PDX - THERE IS CORROSION ON THE RIGHT INBOARD SEAT TRACK FROM X13.5 TO X49 TRACK 11. REPAIRED IAW RD8/4-53-884, AND SRM 51-42-05.SDR QXEA200700889Seat Track · corrodedC4 PDX - THERE IS CORROSION ON THE RIGHT INBOARD SEAT TRACK INSIDE THE FLANGE AND ON THE FLANGE FROM X2 TO X6.5. REPAIRED IAW RD8/4-53-884 AND SRM 51-40-10.SDR AWXA200700667Seat Track · corrodedSAL - CORROSION ON CABIN SEAT RAIL, -Y1292, FR 66. REPLACED CABIN SEAT RAIL, -Y1292, FR 64 - FR 66 IAW A320 SRM 51-72-11.SDR 2007UALA01634Cargo Track · crackedAFT CARGO PIT STA 1850 2ND CARGO TRACK FROM ENTRANCE HAS 10 INCH CRACK AT PALLET LOCKDOWN AREA. [SUP 05-29-07] MAJOR REPAIR ACCOMPLISHED: INSTALLED NEW TRACK SECTION FROM AFT END TO EXISTING SPLICE SECTION IN AFT PIT.SDR 07FDEA01955Seat Track · crackedAFTER CEILING REMOVAL, 1 CRACK FOUND ON SEAT TRACK LOWER SURFACE AT STA 750 LBL 44. [SUP 06-08-07] REPAIR CARRIED OUT AS PER 53- 70-00 VOLUME I, FIGURE 1. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 07FDEA01954Seat Track · corrodedMDCC SEAT TRACK R3 FRAME 33- FR 45 7EA AREAS CORROSION 10 SQ IN. REMOVED CORROSION (7EACH AREAS) IAW A310-200 SRM 51-74-10. FAB`D 1 SEATTRACK FROM FRAME 36- 38.2; FAB`D 2 REPAIR ANGLES IAW A310-200 SRM 53-10-16; ALODINED, PRIMED, TOP COATED PER A310-200 SRSDR ASAA0741697Cargo Track · gougedCARGO TIE DOWN IS GOUGED. REMOVED DAMAGED SECTION OF TRACK, FABRICATED AND INSTALLED REPLACEMENT TRACK IAW ASA EA 5310 02722.SDR 07FDEA01953Seat Track · corrodedFS 1184 RBL 107.50 NR 10 SEAT TRACK CORRODED AROUND FASTENER HOLES (LOWER SIDE). REMOVED, FABRICATED AND INSTALLED SEAT TRACK SPLICE IAW DC10 SRM VOLUME I 53-70-00 FIG 1.SDR SIMA200719112Seat Track · corrodedRIGHT INBOARD SEAT TRACK BETWEEN FRAME 36 AND 47 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.
Back to JASC 5347