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 07FDEA00547Seat Track · corrodedMAIN DECK CARGO, FLOOR SEAT TRACK FOUND CORROSION AT STA 5-0 TO 5-53, X=-75.25. SEAT TRACK REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG. 1 VOL. I. REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100.SDR 07FDEA00546Seat Track · corrodedMAIN DECK CARGO, FLOOR SEAT TRACK FOUND CORROSION AT STA 1521-1528, X=8.5. SEAT TRACK REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG. 1 VOL. I. REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100.SDR QXEA200700344Seat Track · gougedC4 PDX - FOUND LEFT INBOARD SEAT TRACK IS GOUGED AT STATION X543. REPAIRED IAW RD8-53-4936 AND SRM 51-20-36.SDR QXEA200700343Seat Track · gougedC4 PDX - FOUND LEFT OUTBOARD SEAT TRACK NR 1 IS GOUGED AT STATION X411. REPAIRED IAW SRM 51-20-36 AND RD8-53-1342.SDR QXEA200700328Cargo Track · corrodedC4 PDX - ON SEAT TRACK NR 6 IN FORWARD CARGO BAY THERE IS PITTING IN INBOARD FLOOR BOARD SUPPORT FROM STATION X550 TO X597. REPAIRED IAW RD8-53-784 AND SRM 51-20-36.SDR QXEA200700308Seat Track · corrodedC4 PDX - FOUND LEFT INBOARD SEAT TRACK IS GOUGED AT STATION X543. REPAIRED IAW RD8-53-4936 AND SRM 51-20-16 AND 51-20-36.SDR QXEA200700307Seat Track · gougedC4 PDX - FOUND LEFT OUTBOARD SEAT TRACK NR 1 IS GOUGED AT STATION X411. REPAIRED IAW SRM 51-20-36 AND RD8-53-1342.SDR QXEA200700311Cargo Track · corrodedC4 PDX - ON SEAT TRACK SIX IN FORWARD CARGO BAY THERE IS PITTING ON INBOARD FLOORBOARD SUPPORT FROM STATION X550 TO X597. REPAIRED IAW RD8-53-784 AND SRM 51-20-16, 51-20-36.SDR ABXA070065Seat Track · corrodedSEAT TRACK AT RIGHT BUTT LINE 44, APPROXIMATELY STA 330 - CORRODED. REMOVED AND REPLACED TRACK RIGHT BUTT LINE 44, STA 200 - 285 IAW DC9 SRM 51-30-1.SDR TRAX200700283Seat Track · corrodedRIGHT FWD SEAT TRACK IN PAX COMPARTMENT CORRODED.SDR TRAX200700282Seat Track · corrodedLEFT FWD SEAT TRACK IN PAX COMPARTMENT CORRODED.SDR UPS07849342Seat Track · corrodedINSPECTION TYPE:C1 SEAT TRACK HEAVILY CORRODED STA 1510 RBL 45. REMOVED SEAT TRACK FROM STA 1490-1550 RBL 45. FABRICATED AND INSTALLED REPLACEMENT SEAT TRACK IAW SRM 51-3-0, 53-07-03 FIG 7-3 FIG 003.SDR 07FDEA00536Seat Track · corrodedMAIN DECK CARGO, FLOOR SEAT TRACK FOUND CORROSION AT STA 1328, X=75.25. SEAT TRACK REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG. 1 VOL. I. REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100.SDR 07FDEA00535Seat Track · corrodedMAIN DECK CARGO, FLOOR SEAT TRACK FOUND CORROSION AT STA 1505, X= 75.25. SEAT TRACK REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG. 1 VOL. I. REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100.SDR 07FDEA00534Seat Track · corrodedMAIN DECK CARGO, FLOOR SEAT TRACK FOUND CORROSION AT STA 1521, X=8.5. SEAT TRACK REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG. 1 VOL. I. REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100.SDR 07FDEA00533Seat Track · corrodedMAIN DECK CARGO, FLOOR SEAT TRACK FOUND CORROSION AT STA 1495 - 1510, X=-75.25. SEAT TRACK REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG. 1 VOL. I. REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100.SDR AWXA200700319Seat Track · corrodedSAL - FOUND CORROSION ON MAIN CABIN SEAT TRACK, FR 41 - FR 47, -Y1292. REPLACED MAIN CABIN SEAT TRACK, FR 41 - FR 47, -Y1292 IAW A319 SRM 51-72-11.SDR TRAX200700265Seat Track · corrodedFOUND LT CABIN SIDEWALL SEAT TRACKS HAVE MINOR CORROSION IN SEVERAL LOCATIONS AS MARKED.SDR TRAX200700264Seat Track · corrodedFOUND RT CABIN SIDEWALL SEAT TRACKS HAVE MINOR CORROSION IN SEVERAL LOCATIONS AS MARKED.SDR TRAX200700263Seat Track · corrodedFOUND LT AND RT CABIN FLOOR SEAT TRACKS CORRODED AT FS 559+80.SDR TRAX200700262Seat Track · corrodedFOUND LT AND RT CABIN FLOOR SEAT TRACKS CORRODED AT FS 559+112.SDR TRAX200700261Seat Track · corrodedFOUND RT CABIN FLOOR SEAT TRACK CORRODED AT FS 544.SDR TRAX200700260Seat Track · corrodedFOUND RT CABIN FLOOR SEAT TRACK CORRODED AT FS 439.SDR TRAX200700259Seat Track · corrodedFOUND RT CABIN FLOOR SEAT TRACK CORRODED AT FS 409+64.SDR TRAX200700258Seat Track · corrodedFOUND LT CABIN FLOOR SEAT TRACK CORRODED AT FS 364.SDR TRAX200700257Seat Track · corrodedFOUND RT CABIN FLOOR SEAT RAIL CORRODED FROM FS 364 TO FS 394.SDR 07FDEA00516Seat Track · gougedGOUGE FOUND ON SEAT TRACK NR 5 ZONE 231 LT SIDE BETWEEN FRAME 18 AND 20. REPAIRED SEAT TRACK PER A310 SRM 53-10-16.SDR 07FDEA00515Seat Track · corrodedFOUND SEAT TRACK AT R-5 2EA SPOTS OF CORROSION BETWEEN FR 38.2 AND 40/41. REMOVED AND REPLACED SEAT TRACK IAW A310 SRM 51-40-21 AND 53-10-16.SDR 07FDEA00514Seat Track · gougedMDCC SEAT TRACK HAS 1 AREA GOUGED, 1 PREVIOUS REPAIR AND 6 SPOTS OF CORROSION BETWEEN FR 58-72. REMOVED SEAT TRACK IAW A310 SRM 51-72-10. FABBED REPLACEMENT SEAT TRACK IAW A310 SRM 53-10-16 AND AIRBUS DWG A53278820. INSTALLED REPLACEMENT SEAT TRACK IAW A310SDR HALA0800263Seat Track · corrodedLEVEL 1 CORROSION ON SEAT TRACK CROWN/BASE AT LBL 88.5, STA 1400, AREA HAS BEEN REWORKED BEFORE. SEAT TRACK REPLACE PER SRM.SDR QXEA200700284Seat Track · corrodedC4 PDX - FOUND RIGHT OUTBOARD SEAT TRACK NR 10 HAS CORROSION ON TOP EDGE AND IN CENTER OF TRACK AT STATION X280. REPAIRED IAW RD8-53-3644, AND RD8-53-1342.SDR QXEA200700287Seat Track · corrodedC4 PDX - FOUND CORROSION ON LEFT CENTER SEAT TRACK NR 4 AROUND RIVETS ON OUTBOARD FLANGE FROM STATION 201 TO 262. REPAIRED IAW RD8-53-4698, SRM 51-40-11, RD8-53-1102, AND RD8-53-4473.SDR QXEA200700274Seat Track · corrodedC4 PDX - NR 7 SEAT TRACK HAS CORROSION ON INBOARD FLANGE AT STATION X202.750, NEXT TO CAMLOCK FASTENER HOLE. REPAIRED IAW RD8-53-4698, RD8-53-1102, RD8-53-4473, SRM 51-40-00 AND 51-40-11.SDR QXEA200700282Seat Track · corrodedC4 PDX - FOUND RIGHT OUTBOARD SEAT TRACK NR 11 HAS CORROSION IN CENTER OF TRACK AND ON EDGE OF CLAWS AT STATION X495. REPAIRED IAW RD8-53-1342.SDR 07FDEA00478Seat Track · misrepairedPREVIOUS REPAIR LOCATED ON MAIN CABIN SEAT TRACK 5R BETWEEN FRAMES 35 TO 37 HAS A REPAIR WITH 4 EACH REPAIR ANGLES MEASURING 8.8" LONG EACH AND THE SEAT TRACK REPAIR SECTION IS 20" LONG. PREVIOUSLY INSTALLED REPAIR LOCATED AT MAIN CABIN SEAT TRACK 5R BETWEEN SDR SIMA200707413Seat Track · corrodedCORROSION ON LEFT OUTBOARD SEAT TRACK BETWEEN FRAME 30 TO 36. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICE.SDR UPS07449330Seat Track · corrodedINSPECTION TYPE:C M/D STA 1520-1530 RBL 96 SEAT TRACK I/B FLANGE CORRODED. CORROSION BLEND OUT 0.035" X .5" X 1" EXCEED SRM 53-10-09 FIG 1, LIMITS. M/D BS 1480-1570 RBL 96 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS07449305Seat Track · corrodedINSPECTION TYPE:C M/D BS 2130-2140 LBL 85 SEAT TRACK O/B FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.029" X .5" X 20" EXCEED SRM 53-10-01 FIG 1 LIMITS. M/D BS 2110-2150 LBL 85" SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS07449287Seat Track · corrodedINSPECTION TYPE:C M/D BS 908-910 LBL 11 SEAT TRACK BOTH SIDE FLANGE FOUND CORROSION. CORROSION BLEND OUT 0.022" X .75" X 3" IS EXCEED SRM 53-10-01 FIG 1 LIMITS. M/D BS 890-930 LBL 11" SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 14.SDR QXEA200700285Seat Track · corrodedC4 PDX - FOUND RIGHT OUTBOARD SEAT TRACK NR 10 HAS CORROSION ON EDGE OF CLAWS AT STATION X262 TO X264. REPAIRED IAW RD8-53-1342.SDR QXEA200700283Seat Track · corrodedC4 PDX - FOUND RIGHT OUTBOARD SEAT TRACK NR 11 HAS CORROSION ON EDGES OF CLAWS AT STATION X455. REPAIRED IAW RD8-53-1342.SDR QXEA200700277Seat Track · corrodedC4 PDX - FOUND LEFT CARGO COMPARTMENT SEAT TRACK NR 6 HAS CORROSION IN AND AROUND THE FOOT LATCH SECTION AT STATION X596. REPAIRED IAW RD8-53-4936, SRM 51-20-16 AND 51-20-36.SDR QXEA200700276Seat Track · corrodedC4 PDX - FOUND RIGHT CARGO COMPARTMENT SEAT TRACK NR 9 HAS CORROSION ON THE TOP SURFACE OF THE FOOT LATCH SECTION AT STATION X596. REPAIRED IAW RD8-53-4936, RD8-53-4472, AND SRM 51-40-00, 51-20-36.SDR XEA200700188Seat Track · corrodedC4 PDX - RIGHT OUTBOARD SEAT TRACK NR 12 HAS CORROSION ON TOP OF TRACK AT STATION X510. REPAIRED IAW RD8-53-3644.SDR QXEA200700183Seat Track · damagedC4 PDX - LEFT CENTER SEAT TRACK NR 5 HAS SCRATCHES, NICKS AT STATION 425, 439 TO 450, 473 TO 489. REPAIRED IAW RD8-53-1339.SDR QXEA200700187Seat Track · corrodedC4 PDX - RIGHT OUTBOARD SEAT TRACK NR 12 HAS CORROSION ON EDGE OF CLAW AT STATION X541. REPAIRED IAW RD8-53-3644.SDR QXEA200700185Seat Track · corrodedC4 PDX - RIGHT INBOARD SEAT TRACK NR 8 HAS GOUGE IN CENTER OF TRACK AT STATION X440 TO X452. REPAIRED IAW RD8-53-1339.SDR QXEA200700186Seat Track · corrodedC4 PDX - RIGHT INBOARD SEAT TRACK NR 8 HAS CORROSION ON THE INBOARD FLANGE AT STATION X437. REPAIRED IAW RD8-53-1339.SDR QXEA200700184Seat Track · corrodedC4 PDX - RIGHT INBOARD SEAT TRACK NR 8 HAS CORROSION IN CENTER OF TRACK AND ON EDGES OF CLAWS AT STATION X487. REPAIRED IAW RD8-53-1339.SDR 07FDEA00473Seat Track · corrodedMDC FOUND SEAT TRACK NR 2 LT BTN FR72.5 TO FR 73.5 HAS CORROSION. REMOVED CORROSION IAW A310 SRM 51-74-10 AND CHECKED LIMITS PER SRM 53-10-16 AND FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK NR 3L FR71.5 - FR73.5 IAW A310-200 SRM 51-40-21.
Back to JASC 5347