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 DHL2005749026Seat Track · corrodedFOUND CORROSION ON SEAT TRACK AT RBL24 BS 770-800. CLEANED CORROSION IAW B727 SRM 51-0-6 AND FOUND TO BE OUT OF LIMITS IAW B727 SRM 53-10-1 FIG 3. REMOVED SEAT TRACK SECTION AT RBL 24 BS 757-852 IAW B727 SRM 51-30-2 TREAT AT PRIMED AREA IAW B727 SRM 51-10-2.SDR DHL2005749025Seat Track · corrodedFOUND CORROSION ON SEAT TRACK AT RBL 45 BS 770-850. REMOVED SEAT TRACK BS 757-852 RBL 45 AND FABBED NEW FROM BAC 1520-841 PO 9002277 DIM 95" IN LENGTH IAW B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 2 LWR SURFACED TREATED AND PRIMED IAW B727 SRM 51-10-2. INSTALLESDR 05FDEA03686Repair · unknownMAIN CABIN STA 635 X27 FOUND STANDARD SEAT TRACK REPAIR. PERFORMED A GVI OF EXISTING REPAIR IAW EO8-5100-7-5001 CRITERIA FOUND REPAIR IN COMPLIANCE WITH SRM 53-70-00 FIG 2 SHT 1-2 VOL 1.SDR 05FDEA03685Plug · unknownSEAT TRACK PLUG REPAIR AT STA 969 X47. PERFORMED A GVI OF EXISTING REPAIR IAW EO8-5100-7-5001 CRITERIA FOUND REPAIR IN COMPLIANCE WITH SRM 53-70-00 PAGE 11 FIG 62A VOL 1.SDR 05FDEA03684Plug · unknownSEAT TRACK PLUG REPAIR LOCATED AT STATION 1511 X75. PERFORMED A GVI OF EXISTING REPAIR IAW EO8-5100-7-5001 CRITERIA FOUND REPAIR IN COMPLIANCE WITH SRM 53-70-00 PAGE 11 FIG 62A VOL 1.SDR AWXA200501399Seat Track · corrodedSAL - DURING BC4 CHECK DISCOVERED CORROSION ON SEAT TRACK AT LT INBOARD FRAME 41 + 7 AND Y765. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW AIRBUS 319 SRM 53-31-15 FIG 101. MAINTENANCE REMOVED SEAT TRACK AND INSTALLED NEW SEAT TRACK FROM FSDR AWXA200501398Seat Track · corrodedSAL - DURING BC4 CHECK DISCOVERED CORROSION ON SEAT TRACK AT LT INBOARD FRAME 37+3 AND Y765. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW AIRBUS 319 SRM 53-31-15 FIG 101. MAINTENANCE REMOVED SEAT TRACK AND INSTALLED NEW SEAT TRACK FROM FRASDR AWXA200501382Seat Track · corrodedDURING C CHECK INSPECTION FOUND CORROSION ON SEAT TRACK AT FR 45 + 16" AND BL -Y1292. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW AIRBUS 319 SRM 53-31-15 FIG 101. REMOVED SEAT TRACK AND INSTALLED NEW SEAT TRACK FROM FS 41 TO FS 47 AND BL SDR AWXA200501378Seat Track · corrodedDURING C CHECK INSPECTION, DISCOVERED CORROSION ON SEAT TRACK AT FR 45+5" AND BL -Y765. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW AIRBUS 319 SRM 53-31-15 FIG 101. SEAT TRACK WAS REMOVED FROM FS 41 TO FS 47 AND -Y765 IAW AIRBUS 319 SRM 5SDR 05FDEA03647Seat Track · damagedFOUND MAIN DECK COMPARTMENT, SEAT TRACK FOUND EDGE DAMAGED AT STA 5/23, X= -47.5. REPAIR CARRIED OUT AS PER SRM 53-70-00 VOL. I FIG. 1 AND SRM 51-33-01 VOL. II. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 05FDEA03646Seat Track · corrodedFOUND MAIN DECK COMPARTMENT, SEAT TRACK FOUND CORROSION AT STA 1521, X=8.5. REPAIR CARRIED OUT IAW SRM 53-70-00 FIG. 3 VOL. I AND SRM 51-33-01 VOL. II. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 05FDEA03645Seat Track · corrodedFOUND MAIN DECK COMPARTMENT, SEAT TRACK FOUND CORROSION AT STA 5/0 - 5/73, X=8.5. REPAIR CARRIED OUT IAW SRM 53-70-00 VOL. I FIG. 1 AND SRM 51-33-01 VOL. II. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR ASOA05954Seat Track · corrodedDURING A C-CHECK IN MCN, THE FLOOR SEAT TRACKS, AT LBL 9 AND RBL 9, FS 379 TO FS 969, WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE WILL REMOVE AND REPLACE THE FLOOR SEAT TRACKS, FROM FS 379 TO FS 969, LBL 9 AND RBL 9. (M)SDR ASOA05955Seat Track · corrodedDURING A C-CHECK IN MCN, THE LEFT AND RIGHT SIDEWALL SEAT TRACKS, AT FS 379 TO FS 969, WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE WILL REPAIR THE LEFT AND RIGHT SEAT TRACKS, AT FS 379 TO FS 969, IAW BOMBARDIERSDR SWIA200516008Seat Track · corrodedLT SIDE CABIN FLOOR SEAT TRACK FWD END HAS CORROSION, ITEM FOUND AT C-CHECK INSPECTION. REPLACED FORWARD END OF LT SIDE CABIN FLOOR SEAT TRACK IAW EMB120 MM 53-01-05.SDR SWIA200516007Seat Track · corrodedLT SIDE FWD SHORT SEAT TRACK CORRODED, ITEM FOUND AT C-CHECK INSPECTION. REPLACED LT SIDE FWD SHORT SEAT TRACK IAW EMB120 MM 53-01-05.SDR 05FDEA03639Seat Track · corrodedMAIN CABIN BETWEEN FS 17 AND FS 19 SEAT TRACK 1R RIGHT SIDE HAS 2 SQ INCHES OF CORROSION REF N00665. REMOVED AND REPLACED SEAT TRACK 1R IAW SRM 51-72-10.SDR 05FDEA03638Seat Track · corrodedNR 3 SEAT TRACK HAS 3 AREAS OF CORROSION BETWEEN FS 47 AND FS 51, REF N00618. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-72-10.SDR 05FDEA03636Seat Track · corrodedMAIN CABIN SEAT TRACK 3L AT FS 74 TO FS 79 HAS 4 EA AREAS OF CORROSION REF N00522. REPAIRED SEAT TRACK IAW SRM 53-10-16.SDR 05FDEA03635Seat Track · corrodedFOUND MAIN CABIN SEAT TRACK 1 BETWEEN FR 74 TO 79 HAS 6 EA AREAS OF CORR REF N00520. REPAIRED SEAT TRACK IAW SRM 53-10-16.SDR 05FDEA03634Seat Track · corrodedFOUND MAIN CABIN SEAT TRACK 4R AT FS 76 TO 77 HAS MILD CORR IN 2 AREAS REF N00518. REPAIRED SEAT TRACK IAW SRM 53-10-16.SDR 05FDEA03633Seat Track · corrodedFOUND MAIN DECK FS 45 TO 50 SEAT TRACK 4 LEFT HAS 4 EA AREAS OF EXFOIATION REF N00610. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-72-10.SDR 05FDEA03618Seat Track · corrodedMAIN DECK COMPARTMENT, SEAT TRACK FOUND CORROSION AT STATION 5/0- 5/73, X=8.5. REPAIR CARRIED OUT IAW SRM 53-70-00 VOL. I FIG. 1 AND SRM 51-33-01 VOL. II. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 05FDEA03616Seat Track · wornMAIN DECK COMPARTMENT, SEAT TRACK EDGE FOUND WORN AT STATION 755, X=-8.5. CARRIED OUT REPAIR IAW SRM 53-70-00 FIG. 1 VOL. I AND SRM 51-33-01 VOL.II. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 05FDEA03606Seat Track · corrodedMAIN DECK CARGO NR 2 L SEAT TRACK AT FRAME 64 HAS MILD CORROSION REF N00440. REMOVED CORROSION CHECK LIMITS IAW SRM 51-74-10 AND 53-10-16 FIG 101. FOUND TO BE WITHIN LIMITS RESTORED FINISH IAW SRM 51-75-10.SDR SIMA200531510Seat Track · corrodedSAW - FOUND LEFT FORWARD OUTBOARD SEAT TRACK CORRODED. REPLACED SEAT TRACK IAW EMB 140 AMM 53-01-06. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA200531508Seat Track · corrodedFOUND LEFT OUTBOARD SECOND AFT SEAT TRACK FROM FRONT CORRODED. REPLACED SEAT TRACK IAW EMB 140 AMM 53-01-06. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR ERA2005F00000Seat Track · corrodedFOUND WHILE AIRCRAFT WAS UNDERGOING C1 CHECK, AWC 19412, FOUND LT FWD SEAT RAIL CORROSION BEYOND MFG LIMITS. REPAIRED IAW RO. (K)SDR SIMA200531504Seat Track · corrodedFOUND LEFT SECOND FROM FORWARD INBOARD SEAT TRACK CORRODED. REPLACED SEAT TRACK IAW EMB 140 AMM 53-01-00. AIRCRAFT WAS RETURNED O SERVICE. (M)SDR SIMA200531503Seat Track · corrodedFOUND LEFT FORWARD INBOARD SEAT TRACK CORRODED. REPLACED SEAT TRACK IAW EMB 140 AMM 53-01-06. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR QXEA200501685Seat Track · corrodedYYC - DURING C3 CHECK, LEFT OUTBOARD SEAT RAIL HAS CORROSION AT STATION 581-615. REPAIRED IAW REO 670-53-00-013.SDR QXEA200501684Seat Track · scratchedYYC - DURING C3 CHECK, LEFT OUTBOARD SEAT RAIL AT STATION 581-661 HAS SURFACE SCRATCHES. REPAIRED IAW REO 670-53-00-013.SDR QXEA200501683Seat Track · damagedYYC - DURING C3 CHECK, LEFT OUTBOARD SEAT RAIL AT STATION 662-665 HAS SURFACE SCRATCHES. REPAIRED IAW REO 670-53-00-013.SDR QXEA200501677Seat Track · corrodedYYC - DURING C3 CHECK, RIGHT INBOARD SEAT RAIL AT STATION 581-683 HAS CORROSION ON TOP SURFACE. REMOVED CORROSION IAW REO 670-53-00-013.SDR QXEA200501676Seat Track · corrodedYYC - DURING C3 CHECK, LEFT INBOARD SEAT RAIL AT STATION 581-683 HAS CORROSION ON TOP SURFACE. REPAIRED IAW REO 670-53-00-013.SDR QXEA200501682Seat Track · corrodedYYC - DURING C3 CHECK, LEFT INBOARD SEAT RAIL AT STATION 850-953 HAS CORROSION AND GOUGES. REPAIRED IAW REO 670-53-00-013.SDR QXEA200501681Seat Track · gougedYYC - DURING C3 CHECK, RIGHT INBOARD SEAT RAIL HAS GOUGES ON TOP SURFACE AT STATION 850-923. REPAIRED IAW REO 670-53-00-013.SDR QXEA200501680Seat Track · gougedYYC - DURING C3 CHECK, LEFT INBOARD SEAT RAIL AT STATION 724-830 HAS GOUGES ON TOP SURFACE. REPAIRED IAW REO 670-53-00-013.SDR QXEA200501679Seat Track · gougedYYC - DURING C3 CHECK, RIGHT INBOARD SEAT RAIL HAS CORROSION AND GOUGES ON TOP SURFACE. REPAIRED IAW REO 670-53-00-013.SDR QXEA200501693Seat Track · gougedYYC - DURING C3 CHECK, RIGHT OUTBOARD SEAT RAIL HAS SCRATCHES NICKS AND GOUGES AT STATION 396-448. REPAIRED IAW REO 670-53-00-013.SDR QXEA200501687Seat Track · damagedYYC - DURING C3 CHECK, LEFT OUTBOARD SEAT RAIL HAS SCRATCHES AND NICKS AT STATION 504-568. REPAIRED IAW REO 670-53-00-013.SDR QXEA200501686Seat Track · corrodedYYC - DURING C3 CHECK, LEFT OUTBOARD SEAT RAIL AT STATION 501-570 HAS SURFACE CORROSION. REPAIRED SEAT RAIL IAW REO 670-53-00-013.SDR QXEA200501672Seat Track · corrodedYYC - DURING C3 CHECK, RIGHT INBOARD SEAT RAIL AT STATION 485-581 HAS CORROSION AND GOUGES. MAINTENANCE REPAIRED IAW CRJ-700 REO 670-53-00-013.SDR QXEA200501670Seat Track · corrodedYYC - DURING C3 CHECK, LEFT ONBOARD SEAT RAIL AT STATION 394-485 HAS CORROSION AND GOUGES. MAINTENANCE BLENDED OUT DAMAGE AND CORROSION IAW REO 670-53-00-013.SDR QXEA200501667Seat Track · corrodedYYC - DURING C3 CHECK, LEFT SIDE SEAT RAIL AT STATION 933-953 CORRODED. MAINTENANCE REPAIRED IAW REO 670-53-00-013.SDR QXEA200501671Seat Track · corrodedYYC - DURING C3 CHECK, LEFT INBOARD SEAT RAIL AT STATION 485-581 HAS CORROSION. MAINTENANCE REMOVED AND REPAIRED DAMAGE IAW CRJ-700 REO 670-53-00-013.SDR QXEA200501689Seat Track · chafedYYC - DURING C3 CHECK, LEFT OUTBOARD SEAT RAIL HAS SCRATCHES NICKS AND CHAFING AT STATION 397-453. REPAIRED IAW REO 670-53-00-013.SDR QXEA200501688Seat Track · corrodedYYC - DURING C3 CHECK, LEFT OUTBOARD SEAT RAIL AT STATION 457-475 HAS SCRATCHES AND CORROSION. REPAIRED IAW 670-53-00-013.SDR QXEA200501678Seat Track · gougedYYC - DURING C3 CHECK, RIGHT SEAT RAIL HAS GOUGES ON TOP SURFACE AT STATION 696. REMOVED DAMAGE IAW REO 670-53-00-013.SDR QXEA200501692Seat Track · gougedYYC - DURING C3 CHECK, RIGHT OUTBOARD SEAT RAIL HAS SCRATCHES CHAFING AND GOUGES AT STATION 458-481. REPAIRED IAW REO 670-53-00-013.
Back to JASC 5347