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 QXEA200603431Seat Track · corrodedPDX C3 - CORROSION INSIDE SEAT TRACK NR 7 AT APPROXIMATELY STATION X471.00 AND X473.00. REPAIRED IAW RD 8/4-53-884 AND DHC-8-400 SRM 51-21-10.SDR QXEA200603429Cargo Track · corrodedPDX C3 - AFT BAG COMPARTMENT LEFT INBOARD TRACK CORROSION OUTBOARD FLANGE APPROXIMATELY X774 TO X778 AND YL10. REPAIRED IAW DHC-8-400 SRM 51-42-05.SDR QXEA200602752Seat Track · damagedC3 PDX - LEFT OUTBOARD SEAT TRACK NR 1 HAS MINOR SCRATCHES FROM STATION X100, X156, X200 REPAIRED IAW SRM 51-21-10 AND RD8/4-53-884.SDR QXEA200602751Seat Track · corrodedC3 PDX - RIGHT INBOARD SEAT TRACK HAS PITTING CORROSION FROM STATION X68-X85. REPAIRED IAW SRM 51-40-07 AND RD8/4-53-884.SDR QXEA200602750Seat Track · corrodedC3 PDX - RIGHT INBOARD SEAT TRACK HAS PITTING CORROSION FROM STATION X90-X95. REPAIRED IAW SRM 51-40-07 AND RD8/4-53-884.SDR QXEA200602749Seat Track · chafedC3 PDX - CHAFE DAMAGE INSIDE SEAT TRACK NR 6 AT STATION X199.00. REPAIRED IAW SRM 51-21-10 AND RD8/4-53-884.SDR QXEA200602748Seat Track · chafedC3 PDX - CHAFE DAMAGE INSIDE SEAT TRACK NR 7 AT STATION X549.00 TO X559.00. REPAIRED IAW SRM 51-21-10 AND RD8/4-53-884.SDR QXEA200602747Seat Track · gougedC3 PDX - GOUGE INSIDE SEAT TRACK NR 7 AT STATION X529.00. REPAIRED IAW SRM 51-21-10 AND RD8/4-53-884.SDR QXEA200602746Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 7 AT STATION X500.00. REPAIRED IAW SRM 51-21-10 AND RD8/4-53-884.SDR QXEA200602745Seat Track · corrodedC3 PDX - CORROSION INSIDE SEAT TRACK NR 7 AT STATION X471.00 AND X473.00. REPAIRED IAW SRM 51-21-10 AND RD8/4-53-884.SDR QXEA200602744Seat Track · gougedC3 PDX - GOUGE INSIDE SEAT TRACK NR 7 AT STATION X430.00. REPAIRED IAW SRM 51-21-10 AND RD8/4-53-884.SDR QXEA200602734Seat Track · damagedC3 PDX - LEFT OUTBOARD SEAT TRACK NR 2 MINOR SCRATCHES, MINOR CHAFES AT STATION X232, X305, X340, X355, X388, AND X428. REPAIRED IAW SRM 51-71-10, AND RD8/4-53-884.SDR QXEA200602642Seat Track · corrodedC3 PDX-RT IB SEAT TRACK HAS PITTING CORROSION FROM X68-X85. REPAIRED IAW RD8/4-53-884, SRM 51-40-15SRM 51-40-04, SRM 51-42-05.SDR QXEA200602643Seat Track · damagedC3 PDX-LT OB SEAT TRACK NR 2 MINOR SCRATCHES, MINOR CHAFES AT STATION X232, X305-X428. REPAIRED IAW RD8/4-53-884, AND SRM 51-21-10.SDR QXEA200602641Seat Track · corrodedC3 PDX-RT IB SEAT TRACK HAS PITTING CORROSION GROM X90-X95. REPAIRED IAW RD8/4-53-884 AND SRM 51-40-07, 51-40-15, AND SRM 51-42-05.SDR AWXA200601710Seat Track · corrodedMAJOR REPAIR-BC2 CHECK-NR 5960193, CORROSION ON SEAT TRACK LOCATED FR 41+12 INCHES -Y765 RT PAX CABIN. SEAT TRACK LOCATED ON FR 41 TO FR 47 -Y765, RT PAX CABIN. REPLACED IAW SRM A320 51-72-11.SDR QXEA200603435Seat Track · corrodedPDX C3 - CORROSION ON SEAT TRACK NR 5 AT APPROXIMATELY STATION X16.700. REPAIRED IAW RD 8/4-53-884, DHC-8-400 SRM 51-40-15 AND SRM 51-42-05.SDR QXEA200602743Seat Track · corrodedC3 PDX - CORROSION ON SEAT TRACK NR 5 AT STATION X16.700. REPAIRED IAW SRM 51-40-15 AND 51-42-05.SDR QXEA200602648Seat Track · corrodedC3 PDX-RT SEAT TRACK CORROSION AT X6.0 TOP OF RAIL. REPAIRED IAW RD8/4-53-884 AND SRM 51-40-15, 51-40-00, AND SRM 51-40-07.SDR QXEA200602644Seat Track · damagedC3 PDX-LT OB NR 4 SEAT TRACK HAS MINOR SCRATCHES AND MINOR CHAFING AT STATION X590-X664. REPAIRED IAW RD8/4-53-884, AND SRM 51-42-05, SRM 51-40-07.SDR USAA061208Seat Track · corrodedFOUND CORROSION 55" FROM RT OUTBD FWD END SEAT TRACK. INSTALLED 2 SPLICES IN SEAT TRACK PER SRM 53-00-15; CORROSION TASK JA-220-53500; LEVEL 1, DEFECT SIZE: 1" BY 3" AND 1" BY 1".SDR F3LA200600134Fastener · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORRODED HARDWARE ON ALL 3 CARGO NET TIE DOWNS INBOARD OF DOOR THRESHOLD IN FWD CARGO COMPARTMENT. REPLACED CORRODED HARDWARE AS REQUIRED ON TIE DOWNS.SDR F3LA200600132Dummy Rail · corrodedDURING C-4 CHECK, INSPECTION REPORTED FWD LAV AREA DUMMY RAIL Y503.2, BETWEEN FRAMES C12 AND C16, CORRODED ALONG ENTIRE LENGTH OF BEAM. CORRODED AREAS FOUND TO BE OUT OF LIMITS PER SRM 53-11-14. REPLACED DUMMY RAIL PER SRM'S 51-44-11 AND 51-42-11.SDR DU4R2006633Seat Track · corrodedCORROSION CABIN FS 200 - 769 LT O/B SEAT TRACK OP, CENTER OF TRACK AROUND CLIP NUT HOLES. REMOVED CORRODED SEAT TRACK, FABRICATED AND INSTALLED SEAT TRACK 585" FROM P/N 53-0997-002, 6 STRAPS 13.0" BY 3.0" AND 6 EA. 2.0" BY 3.0" FROM 7075-T6 .063", 6 EA. STRAPSDR MALA060573Seat Track · corrodedCABIN SEAT TRACK AT BL 0 STA 630-640, IS CORRODED OUT OF LIMITS. INSTALLED REPAIR DOUBLER IAW MESABA EOS53079.SDR WRLA2006098Seat Track · corrodedITEM: DURING (C) CHECK IN RME FOUND RT OB TRACK HAS EXFOLIATING CORROSION JUST AFT OF R1 DOOR LAV AREA FUSELAGE STA 466.500. REMOVED RT OB TRACK ON MAIN DECK AND REPLACED AS REQUIRED IAW SRM 53-70-00.SDR ASAA0681042Seat Track · corrodedFOUND SEAT TRACK CORRODED. REMOVED DAMAGED SECTION OF TRACK. INSTALLED REPAIR CHANNEL AND PLUG PER SRM 53 05.SDR 06FDEA03582Seat Track · corrodedMAIN DECK CARGO, FOUND SEAT TRACK FLANGE AT STA 1400 LBL 8 CORRODED. TRIMMED OUT AND REPAIR CARRIED OUT AS PER SRM 53- 70-00 FIG.1, VOL.I FROM STA 1360 TO STA 1440, LBL 8. REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100.SDR 06FDEA03581Seat Track · corrodedMAIN DECK CARGO, FOUND SEAT TRACK FLANGE AT STA 1310 RBL 78 CORRODED. REPAIRED SEAT TRACK FABRICATED AND INSTALLED AS PER SRM 53-70-00, FIG.1, VOL.I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR KCSA061393Seat Track · corrodedFOUND SEAT TRACK HAS AREA OF CORROSION AT RBL 66 FROM STA 490 TO 560.SDR KCSA061392Seat Track · damagedFOUND FWD BILGE SEAT TRACK IS DAMAGED AT RBL 45, STA 554.SDR KCSA061389Seat Track · corrodedFOUND CORROSION ON RBL 41 SEAT TRACK AT BS 880.SDR 06FDEA03563Seat Track · damagedINTERNAL FUSELAGE MAIN CABIN FROM STA 515 TO STA 535 X= -47 RT SIDE SEAT TRACK REPAIR. REMOVED AND REINSTALLED NEW SEAT TRACK IAW DWG SP10580218.SDR 06FDEA03553Seat Track · corrodedMAIN DECK CARGO, FOUND SEAT TRACK FLANGE CORRODED AT BS 1230 AND 1240 RBL 78. CARRIED OUT REPAIR AS PER SRM 53-70-00 FIG. 1 VOL. I. REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100.SDR QXEA200602736Floorbeam · corrodedC3 PDX - AFT BAGGAGE COMPARTMENT TOP OF FLOORBEAM AT STATION FS783.102 CORROSION ON CLIP YR8.5 AROUND RIVET. REPAIRED IAW SRM 51-21-00.SDR DU4R2006632Seat Track · corrodedCORROSION CABIN RT OB SEAT TRACK FS 200 - 769 TOP, CENTER OF TRACK AND AROUND CLIP NUT HOLES. REMOVED CORRODED SEAT TRACK AND INSTALLED SEAT TRACK P/N 53-0997-002 AND SPLICE REPAIRS TWO 3" BY 13" AND 3" BY 7" FROM 7075-T6 .063", 5 EA. 7" BY .70" AND 5 EA. 13"SDR RAIA00610002Seat Track · corrodedMX - INSP - LEFT I/B FWD PART OF SEAT TRACK AT FRAME 18 SHOWS CORROSION. MAINTENANCE REPLACED THE LEFT I/B SEAT TRACK.SDR 06FDEA03523Seat Track · corrodedFOUND CORROSION, CABIN SEAT TRACK X = -8.5 AROUND STA 1135-1198. SEAT TRACK REPLACED AS PER SRM 51-31-01 AND 51-33-01 VOL2 (MAJOR REPAIR).SDR 06FDEA03522Seat Track · corrodedFOUND CORROSION,CABIN SEAT TRACK X = -27.5 AROUND STA 1039 TO 1049. SEAT TRACK REPLACED AS PER SRM 51-31-01 AND 51-33-01 VOL2 (MAJOR REPAIR).SDR 06FDEA03521Seat Track · corrodedFOUND CORROSION, CABIN SEAT TRACK FLANGE, CROWN AND CHANNEL X = 8 AT STA 819 TO 869. SEAT TRACK REPLACED AS PER SRM 51-31-01 AND 51-33-01 VOL2 (MAJOR REPAIR).SDR DHL2006363548Cargo Track · corrodedMAIN CARGO COMPARTMENT FLOOR SUPPORT FS 20-22 LBL 60 AND LBL 80 SURFACE CORROSION UNDER CLIP NUT. REPLACED SECTION OF TRACK AS REQUIRED FROM TMS 60-24257 7075T6, REF A300 SRM 51-10-40, TREATED AND PRIMED AND PAINTED IAW A300 SRM. INSTALLED SEAT TRACK AT FS SDR 06FDEA03508Seat Track · corrodedFOUND CORROSION, CABIN SEAT TRACK FLANGE, CROWN AND CHANNEL X = -8 AT STA 819 TO 909. SEAT TRACK REPLACED AS PER SRM 51-31-01 & 51-33-01 VOL2 (MAJOR REPAIR).SDR 06FDEA03507Seat Track · corrodedFOUND CORROSION, CABIN SEAT TRACK FLANGE, CROWN AND CHANNEL X = -27 AT STA 830 TO 869. SEAT TRACK REPLACED AS PER SRM 51-31-01 & 51-33-01 VOL2 (MAJOR REPAIR).SDR 06FDEA03506Seat Track · corrodedFOUND CORROSION, CABIN SEAT TRACK X=27.5 AROUND STA 1129-1165. SEAT TRACK REPLACED AS PER SRM 51-31-01 AND 51-33-01 VOL2 (MAJOR REPAIR).SDR 06FDEA03505Seat Track · corrodedFOUND CORROSION, CABIN SEAT TRACK X=27.5 AROUND STA 1129/6-10 AND STA 1129/6-75. SEAT TRACK REPLACED AS PER SRM 51-31-01 AND 51-33-01 VOL2 (MAJOR REPAIR).SDR 06FDEA03504Seat Track · corrodedFOUND CORROSION, CABIN SEAT TRACK X=8.5 AROUND STA 909-959. SEAT TRACK REPLACED AS PER SRM 51-31-01 AND 51-33-01 VOL2 (MAJOR REPAIR).SDR 06FDEA03503Seat Track · corrodedFOUND CORROSION, CABIN SEAT TRACK X=8.5 AT STA 1129/6-8. SEAT TRACK REPLACED AS PER SRM 51-31-01 AND 51-33-01 VOL2 (MAJOR REPAIR).SDR 06FDEA03502Seat Track · corrodedFOUND CORROSION, CABIN SEAT TRACK X=8.5 AT STA 1129/6-8 TO 1129/6-45. SEAT TRACK REPLACED AS PER SRM 51-31-01 AND 51-33-01 VOL2 (MAJOR REPAIR).SDR 06FDEA03501Seat Track · corrodedFOUND CORROSION, CABIN SEAT TRACK X=8.5 AT STA 909 TO 969. SEAT TRACK REPLACED AS PER SRM 51-31-01 AND 51-33-01 VOL2 (MAJOR REPAIR).SDR 06FDEA03500Seat Track · corrodedFOUND CORROSION, CABIN SEAT TRACK X=8.5 AT STA 969 TO 1129. SEAT TRACK REPLACED AS PER SRM 51-31-01 AND 51-33-01 VOL2 (MAJOR REPAIR).
Back to JASC 5347