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 2007UALA02991Seat Track · damagedRIGHT INBOARD & OUTBOARD SEAT TRACKS FROM FR 41 TO FR 51 HAVE SCRATCHES AND GOUGES BEYOND LIMITS. MAJOR REPAIR ACCOMPLISHED: REPLACED SEAT TRACK.SDR SWIA200718714Seat Track · corrodedFOUND C-CHECK, LEFT SIDEWALL SEAT TRACK HAS CORROSION ON FORWARD SECTION. REPLACED THE LEFT FORWARD SIDEWALL SEAT TRACK SECTION IAW EMB120 AMM 53-01-05.SDR AWXA200700992Seat Track · corrodedSAL - MAJOR REPAIR - C-07 CHECK - NR 5963570, CORROSION FOUND ON CABIN SEAT TRACK, BS 605/FR 12 - BS 950/FR 24, -Y1292. REPLACED CABIN SEAT TRACK, BS 605/FR 12 - BS 950/FR 24, -Y1292, IAW A320 SRM 51-72-11, PAGE 1-2.SDR KCSA071274Seat Track · corrodedSTA 2280 TO 2290 LBL 36 SEAT TRACK HAS CORROSION WL 200.SDR 07FDEA02706Seat Track · corrodedAFTER CENTER CARGO CEILING PANEL REMOVED, FOUND MAIN DECK CARGO SEAT TRACK AT STA 1815, X = -27.5 CORRODED. [08-15-07] REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE 6 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 07FDEA02705Seat Track · corrodedAFTER CEILING PANEL REMOVED, FOUND MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STA 1756, X = -8.5 CORRODED. [08-15-07] REPAIRED BY REPLACEMENT AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 07FDEA02683Seat Track · crackedARTICULATING SEAT TRACK AT Y1456 BETWEEN FR 38.2 AND FR 40 IS CRACKED ON UPPER FLANGE FWD EDGE REMOVED AND REPLACED ARTICULATING SEAT TRACK PER A310-200 SRM 51-40-44, 51-40-21, ALODINED AND PRIMED PER A310-200 SRM 51-21-10.SDR 07FDEA02679Seat Track · wornFORWARD CABIN , FOUND CARGO SEAT TRACK AT STA 500 RBL 62" WORN.SDR 07FDEA02672Seat Track · wornMAIN CABIN SEAT TRACK DEEP WEAR ON UPPER SIDE. REPAIRED IAW SRM 53-70-000 FIG 1 VOL 1.SDR KCSA071268Seat Track · damagedSTA-1250 LBL-99 SEAT TRACK HAS DAMAGE TO CARGO SYSTEM LOCKING HOLES.SDR TRAX200701071Seat Track · corroded2 SEAT TRACKS IN CARGO BAY CORRODED, 1 MARKED, 1 REMOVED. 10-18-07 INSTALLED SEAT RAIL, FOR RIGHT 9G WALL, PN 601R38779-9 IAW CRJ 200 53-01-11 MM13267 7-28-07. UPON INSTALLION OF SEAT TRACK FOR CENTER 9G WALL FOUND INCORRECT PART HAD BEEN OREDERED. REMOVSDR DHL2007741518Seat Track · corrodedMAIN CABIN RT SEAT TRACKS, RBL 25.0, CORRODED BETWEEN BS 480 AND BS 690. CORROSION ON SEAT TRACK BEYOND LIMITS PER B727 SRM 53-10-1. REMOVED SEAT TRACK SECTION FROM BS 480 TO BS 720, FABRICATED NEW SEAT TRACK SECTION FROM BAC 1520-792 EXTRUSION, 210" LONG, PSDR KCSA071257Seat Track · damagedAFT PIT SEAT TRACK WEB AT LBL-25 HAS AN OPEN HOLE AT STA-1902.SDR 07FDEA02631Seat Track · corrodedCOURIER AREA FR 16A- FR 18 SEAT TRACK 3L 20 SQ IN CORROSION REF A300-600 AMM 53-12-00-6 ZONE 230. REMOVED CORROSION ON L3 SEAT TRACK. WENT OUT OF LIMITS IAW A300-600 SRM 53-10-16. REPAIR SEAT TRACK IAW A300-600 SRM 53-12-16. PRIMED AND TREATED PARTS IAW A3SDR 07FDEA02630Seat Track · gougedFUSELAGE MAIN DECK SEAT TRACK 2L GOUGED ON I/B FLANGE, AROUND 6 FASTENER HOLES BETWEEN FRAMES 47-51 (ZONE 240) REF A300-600 SRM 51-10-00 TOTAL AREA GOUGED 6 INCHES APPROX. BY .010 DEEP. BLENDED DAMAGE PER A300-600 SRM 51-73-10 AND FOUND TO BE OUT OF LIMITS PSDR 07FDEA02629Seat Track · corrodedMDCC SEAT TRACK L5 FR 19-FR 24 18 SQ IN CORROSION INBOARD FLANGE IN AND AROUND FASTENER HOLES REF A300-600 AMM 53-13-11-6 ZONE 230. CLEAN CORROSION IAW A300-600 SRM 51-74-10. CHECK LIMITS PER A300-600 SRM 53-10-16 OUT OF LIMITS. FAB REPAIR PART PER A300-600SDR 07FDEA02615Seat Track · corrodedMAIN CABIN FLOOR SEAT TRACK IS CORRODED AT STA 1090 RBL 45 REMOVED CORROSION, FOUND TO BE OUT OF LIMITS, .090" REMOVED. VERIFIED MATERIAL BAC1520-792 7178T6511, FABRICATED NEW SEAT TRACK, TREATED AND PRIMED NEW SEAT TRACK. INSTALLED NEW SEAT TRACK REF 27 SDR 07FDEA02735Seat Track · crackedNR 4 RT SEAT TRACK BETWEEN FR 38.2 AND FR 40 AT Y-1456 FOUND CRACKED. THE PART WAS REPLACED IN ACCORDANCE WITH SRM SUPP 53-15-15.SDR 07FDEA02734Seat Track · crackedNR 2 RT SEAT TRACK BETWEEN FR 38.2 AND FR 40 AT Y-450 FOUND CRACKED. THE PART WAS REPLACED IN ACCORDANCE WITH SRM SUPP 53-15-15.SDR 07FDEA02733Seat Track · crackedNR 2 LT SEAT-TRACK BETWEEN FR 38.2 AND FR40 AT Y450 FOUND CRACKED. IT WAS REPLACED IN ACCORDANCE WITH SRM SUPP 53-15-15.SDR 07FDEA02731Seat Track · crackedNR 3 LT SEAT-TRACK, BETWEEN FR 38.2 AND FR 40 AT Y953, FOUND CRACKED. IT WAS REPAIRED IN ACCORDANCE WITH SRM SUPP 53-15-15.SDR TRAX200701050Seat Track · corrodedCORROSION ON SEAT RAILS AT VARIOUS ATTACH SCREWS AT FS 559 RBL 9.00.SDR UIEA200700288Seat Track · corrodedCORROSION ON SEAT TRACK UPPER DECK GALLEY STA 480 TO 520 LBL 60. REMOVED UPPER DECK GALLEY SEAT TRACK STA 480-590 LBL 60. FABRICATED NEW SECTION OF SEAT TRACK FROM BAC1520-1567 7178-T6511 PO NR 1114517 IAW SRM 53-10-05. INSTALLED NEW SECTION OF SEAT TRACK FSDR UIEA200700287Seat Track · corrodedCORROSION ON SEAT TRACK UPPER DECK GALLEY STA 480 TO 520 LBL 40. REMOVED UPPER DECK GALLEY SEAT TRACK STA 480-530 LBL 40. FABRICATED NEW SECTION OF SEAT TRACK FROM BAC1520-1567 7178-T6511 PO NR 1114517 IAW SRM 53-10-05. INSTALLED NEW SECTION OF SEAT TRACK FSDR 07FDEA02604Seat Track · corrodedUPPER MAIN DECK SEAT TRACK HAS CORROSION AT BL- 0, STA 930 LT SEAT TRACK FLANGE. REMOVED OLD SEAT TRACK, FABRICATED NEW TRACK. INSTALLED NEW TRACK AT BS 930 BL 0, REF SRM 51-30-02.SDR 07FDEA02602Seat Track · corrodedMDCC SEAT TRACK 3RH FR 45 - FR 54 20 SQ INCH CORROSION REF A300-600 AMM 53-10-16-6-02 ZONE 200. REMOVED CORROSION IAW A300-600 SRM 51-74-10. CHECKED LIMIT FOUND TO BE OUT OF LIMIT IAW A300-600 SRM 53-10-16 FIG 101. FAB`D SEAT TRACK IAW A300-600 DWG NR A5327SDR 07FDEA02600Seat Track · corrodedMDCC SEAT TRACK 2RT FR45-FR54 8 SQ INCH CORROSION REF A300-600 AMM 53-10-16-6. REMOVED OLD SEAT PER A300-600 SRM 51-40-21. FABRICATED NEW SEAT TRACK PER AIRBUS DRAWING 532-74005. REPROTECTED SURFACE USING ALODINE, PRIMER, TOPCOAT PER A300-600 SRM 51-75-10. SDR KCSA071248Seat Track · corrodedUPPER DECK SEAT TRACK CORRODED AT LBL-65, BS 519.SDR KCSA071247Seat Track · corrodedUPPER DECK SEAT TRACK CORRODED AT LBL-65 BETWEEN BS 580 AND 700.SDR 07FDEA02574Seat Track · corrodedTHREE 4.5 SQ INCH AREAS OF CORROSION EXIST AT MDCC SEAT TRACK R-3 BETWEEN FRAMES 40 THRU 45 REF 53-10-16-06 ZONE 200 IAW A300-600 AMM. BLENDED CORROSION IAW A300-600 SRM 51-74-10. CHECKED LIMIT IAW A300-600 SRM 53-10-16, FOUND TO BE OUT OF LIMIT. FAB`D SEATSDR 07FDEA02573Seat Track · corrodedA 5 SQ INCH AREA OF CORROSION EXIST AT MDCC SEAT TRACK L-2 FRAME 42 REF. 53-10-16-06 IAW A300-600 AMM. REMOVED CORROSION IAW A300-600 SRM 51-74-10. MAT LOSS IS FOUND TO BE OUT LIMITS. REMOVED SEAT TRACK L-2 FR 40 THRU FR 45 IAW A300-600 SRM 51-40-21. FABRISDR 07FDEA02572Seat Track · corrodedMDCC SEAT TRACK 3L FR15 HAS 1 SQ IN AREA OF CORROSION EXTENDING ON AND UNDER SCALLOPS ZONE 220 REF A300-600 AMM 53-10-16. REMOVED CORROSION AT 3L FR15 SEAT TRACK. FOUND TO BE OUT OF LIMITS IAW A300-600 SRM 53-10-16. REMOVED AND REPLACED SEAT TRACK IAW A300-SDR DHL2007784535Seat Track · corrodedFUSELAGE INTERIOR SEAT TRACK FROM BS 760 TO BS 850, LBL 45.50, WL 208.5 IS CORRODED. REMOVED SEAT TRACK OUT OF LIMITS STA 760 TO 850 IAW B727 SRM 51-30-2. FABRICATED NEW SEAT TRACK FROM P/N BAC1520-841-7178T6, DIM 94.875 IAW B727 SRM 53-10-5, FIG 2. TREATEDSDR CALA0700371Seat Track · corrodedINSPECTION FOUND THE FORWARD ENTRY RIGHT O/B SEAT TRACK CORRODED BETWEEN STA 328 AND 360, RBL 36. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52.SDR CALA0700369Seat Track · corrodedINSPECTION FOUND FORWARD ENTRY RIGHT I/B SEAT TRACK CORRODED BETWEEN STA 328 AND 360, RBL 20. A REPAIR WAS INSTALLED IAW SRM 53-00-52.SDR DLM90071098Seat Track · corrodedFOUND SEAT TRACK LBL 54 FS 1212 TO 1304 EXFOLIATED CORROSION. REMOVED DAMAGED SEAT TRACK AND REPLACED WITH NEW IAW MD-90 SRM 51-30-05, 51-30-1, 51-10-05, 53-40-01 AND 51-10-03.SDR DLM90071076Seat Track · corrodedFOUND CABIN SEAT TRACK LBL-54 OUT OF LIMITS STA 1148-1180. REPLACED SEAT TRACK AT LBL-54 STA 1088-1193 IAW MD-90 SRM 51-30-1.SDR KCSA071246Seat Track · corrodedUPPER DECK SEAT TRACK AT LBL 46 IS CORRODED AT STA 690 TO 720.SDR 07FDEA02551Seat Track · corrodedRBL 24 SEAT TRACK BETWEEN STA 804 TO 848 HAS LIGHT CORROSION AROUND NUT PLATE HOLES ON UPPER AND LWR FLANGE SURFACES (DOT 15) REPLACED T-CAP IAW SRM 51-30-2.SDR 07FDEA02547Seat Track · corrodedCABIN BL 0 SEAT TRACK LEFT FLANGE UPPER SURFACE HAS CORROSION BETWEEN BS 500 AND 580. REMOVED SEAT TRACK AND FABRICATED NEW TRACK FROM BAC1520-792. TREATED PRIMED AND INSTALLED SEAT TRACK REF SRM 51-30-02 P1.SDR 07FDEA02533Seat Track · corrodedMAIN DECK CARGO ALONG CENTER STA 1521 TO 5-93 SEAT TRACK AROUND FASTENER HOLE AREA FOUND WITH CORROSION. [08-02-07] CARRIED OUT REPAIR AS PER SRM 53-70-00 FIGURE 6 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 07FDEA02529Seat Track · corrodedMAIN DECK CARGO ALONG CENTER STA 1501 TO 1521 SEAT TRACK AROUND FASTENER HOLE AREA FOUND WITH CORROSION. [07-30-07] CARRIED OUT REPAIR AS PER SRM 53-70-00 FIGURE 6 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 07FDEA02522Seat Track · corrodedCORRODED SEAT TRACK AT LBL 54 AFT BULK PIT AT STA 1801 TO1840. REMOVED, FABRICATED AND INSTALLED SEAT TRACK IAW MD/DC10 SRM 51-31-01 VOLII AND 51-21-01 VOLII AND DWG AGA3855.SDR 07FDEA02521Seat Track · corrodedRIGHT AFT MAIN DECK CARGO COMPARTMENT SEAT TRACK UPPER SURFACE HAS CORROSION BETWEEN C72-C73 BL 00 REMOVED FLOOR PANEL 252/251WH TO GAIN ACCESS TO DAMAGED SEAT TRACK GOT MATERIAL FOR SEAT TRACK AND U SECTION. LOCATED AND DRILLED SEAT TRACK AND U SECTION. INSSDR 07FDEA02520Seat Track · damagedMAIN DECK CARGO CENTER STA 635 BETWEEN FLOOR PANELS NR 232FF AND NR 233GF, FOUND SEAT TRACK CROWN AREA CHIPPED OFF. CARRIED OUT REPAIR ON DAMAGED SEAT TRACK AT STA 625 TO STA 645 AS PER SRM 53-70-00 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR SIMA200720610Seat Track · corrodedRIGHT NUMBER 4 UPPER SEAT TRACK SUPPORT CORRODED. CUTOUT CORROSION, FABRICATED AND INSTALLED REPAIR PARTS IAW EMB IC2007-145/04757A, DATED JULY 13, 2007. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200720609Seat Track · corrodedRIGHT NUMBER 5 SEAT TRACK SUPPORT CORRODED. CUTOUT CORROSION, FABRICATED AND INSTALLED REPAIR PARTS IAW EMB IC2007-145/04757A, DATED JULY 13, 2007. AIRCRAFT RETURNED TO SERVICE.SDR KCSA071231Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED BETWEEN BS 1910 AND 2030, LBL 98, WL 199.SDR KCSA071230Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED BETWEEN BS 2030 AND 2150, LBL 98.SDR SIMA200720605Seat Track · corrodedSEAT TRACK AT BL36L FOUND CORRODED. REMOOVED AND REPLACED SEAT TRACK IAW SAAB SRM 51-40-21 AND 51-40-22. AIRCRAFT RETURNED TO SERVICE.
Back to JASC 5347