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 DLM88090248Seat Track · corrodedFOUND BS 1174-1309 SEAT TRACK CORRODED. REPLACEMENTON NR 00928.SDR DLM88090240Seat Track · corrodedSEAT TRACK CORRODED AT STATION 788 TO STATION 1030 AT RIGHT OUTBOARD TRACK. REPLACED ON ATS 00924.SDR KCSA091014Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED AT BS 1027, LBL-11.SDR USAA2009030990546Seat Track · corrodedMCN - C24 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN BS 270 TO BS 294.5, WL 208, RBL 41.8. REPLACED SEAT TRACK BETWEEN BS 270 TO BS 294.5, WL 208, RBL 41.8 IAW B737 SRM 51-40-02.SDR IPXA09554946Seat Track · corrodedINSPECTION TYPE:C3 SEAT TRACK CORRODED ON O/B FLANGE, REMOVED, FABRICATED, AND INSTALLED SEAT TRACK, PER SRM 51-40-02-0GSDR DLM88090223Seat Track · corrodedLT INBD SEAT TRACK HAS SEVERAL AREAS OF GOUGING AND CORROSION FROM FACTORY SPLICE STA 788 TO FACTORY SPLICE 1030. REMOVED AND REPLACED SEAT TRACK SECTION PER SRM 51-30-01.SDR FDEA200902150527Seat Track · corrodedMAIN DECK CARGO COMPARTMENT, SEAT TRACK AT STA 1341, X = 8.5 FOUND CORRODED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1, VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR FDEA200902150526Seat Track · corrodedMAIN DECK CARGO COMPARTMENT, SEAT TRACK AT STA 1079, X = -8.5 FOUND CORRODED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1, VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR FDEA200902150525Seat Track · corrodedMAIN DECK CARGO COMPARTMENT, SEAT TRACK AT STA 5-65, X = -27.5 FOUND CORRODED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR FDEA200902150524Seat Track · corrodedMAIN DECK CARGO COMPARTMENT, SEAT TRACK AT STA 5-65, X = 27.5 FOUND CORRODED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1, VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR FDEA200902150523Seat Track · crackedMAIN DECK CARGO COMPARTMENT, SEAT TRACK AT STA 1661, X = -47.5 FOUND CRACKED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1, VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR AALA20090226TUL25Seat Track · brokenNR 3 SEAT TRACK LUG EAR AT STATION 579 IS BROKEN OFF, INSTALLED REPAIR PLUG PER SRM 53-05 FIGURE 4A.SDR ASAA0944807Seat Track · damagedNUMEROUS AREAS OF CORROSION AND OR MECHANICAL DAMAGE TO SEAT TRACK SEGMENT BS 727B 907 RBL 24. REMOVED AND REPLACED SEAT TRACK.SDR AALA2009021200205Cargo Track · corrodedLEFT TIE DOWN TRACK HAS CORROSION. AREA OF DISCREPANCY IS 17.75 INCH BY 4 INCH. REPLACED TIE DOWN TRACK PER SRM 51-02-00.SDR AALA2009021200204Splice · corrodedAFT CARGO, LEFT FORWARD TRACK SPLICE CORRODED, REMOVED OLD TRACK SPLICE AND REPLACED WITH NEW SPLICE PER SRM 51-30-5.SDR AALA2009021200202Cargo Track · corrodedRIGHT TIE DOWN TRACK CORRODED FROM STATION 1007 TO 1155. REMOVED AND REPLACED TIE DOWN TRACK PER SRM 51-02-00.SDR DU4R2009314Seat Track · corrodedDURING SCHEDULED INSP, FOUND SEAT TRACK SEC BS 344 TO 362 LBL 24 CORRODED TOP AND BOTTOM SURFACE.SDR USAA2009022390418Seat Track · corrodedSAL - C8 - MAJOR REPAIR - GALVANIC CORROSION ON SEAT BEAM RAIL BETWEEN FR64 TO FR66, Y1292. REPLACED SEAT BEAM RAIL BETWEEN FR64 TO FR66, Y1292 IAW A320 SRM 51-72-11.SDR FDEA200902110504Seat Track · corrodedMAIN DECK FLOOR PANELS AND SEAT TRACKS SEVERE CORROSION ON SEAT TRACK AND SPLICES. REPAIRED SEAT TRACK IAW SRM 53-70-00, FIG 1, VOL I.SDR AALA2009021000212Seat Track · corrodedNUMBER 5 SEAT TRACK HAS CORROSION, INSTALLED NEW SEAT TRACK AND SPLICE PER SRM 53-05.SDR AALA2009021000211Seat Track · corrodedCORROSION ON NUMBER 5 SEAT TRACK OUTBOARD FLANGE, INSTALLED NEW SEAT TRACK AND SPLICE PER SRM 53-05.SDR IPXA09554955Seat Track · corrodedINSPECTION TYPE:C3 MAIN CARGO BAY SEAT TRACK O/B FLANGE IS CORRODED BS 617 RBL 26 WL 208 R & R SEAT TRACK PER ATS ER 09-1682 DATED 04MAR09SDR IPXA09554954Seat Track · corrodedINSPECTION TYPE:C3 MAIN CARGO BAY SEAT TRACK O/B FLANGE IS CORRODED BS 441 RBL 26 WL 208 REMOVED CORROSION FOUND TO BE OUT OF LIMITS, IAW SRM 53-00-52-1AI SEAT TRACK TO BE REPLACED ON NRC 794585SDR IPXA09554953Seat Track · corrodedINSPECTION TYPE:C3 MAIN CARGO BAY- SEAT TRACK I/B IS CORRODED BS 575 AND 585 RBL 24, WL 208. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS, IAW SRM 53-00-52-1AI SEAT TRACK TO BE REPLACED ON NRC 794585.SDR IPXA09554952Seat Track · corrodedINSPECTION TYPE:C3 MAIN CARGO BAY SEAT TRACK O/B FLANGE IS CORRODED BS 514-620 LBL 26 WL 208. R&R SEAT TRACK PER ATS ER 09-1683 DATED 04MAR09SDR IPXA09555014Seat Track · corrodedINSPECTION TYPE:C3 SEAT TRACK RBL 59.5 JUST AFT OF STA 1180 UPPER SURFACE IS CORRODED 3 INCHES AFT. REMOVED CORROSION, PLUGGED FASTENER HOLE, RELOCATED FASTENER HOLE, FABBED NEW PANEL IAW ER 09-1558.SDR IPXA09555013Seat Track · corrodedINSPECTION TYPE:C3 SEAT TRACK AT RBL 59.5 JUST FWD OF STA 1200 UPPER SURFACE IS CORRODED. BLENDED CORROSION, PLUGGED HOLE, RELOCATED HOLE, FABBED NEW FLOOR PNL IAW ER 09-1557.SDR IPXA09554950Seat Track · corrodedINSPECTION TYPE:C3 SEAT TRACK CORRODED. REMOVED, FABRICATED, INSTALLED SEAT TRACK PER SRM 51-40-02-0GSDR IPXA09554949Seat Track · corrodedINSPECTION TYPE:C3 SEAT TRACK AT RBL 45.5 JUST AFT OF BS 1540 CORROSION AT FASTENER HOLE. SEAT TRACK BEING REPLACED ON CUST. CARD 794487SDR IPXA09554948Seat Track · corrodedINSPECTION TYPE:C3 SEAT TRACK AR RBL 45.5 JUST FOWARD OF STA 1180 TWO CORRODED NUT PLATES. REMOVED AND REPLACED SEAT TRACK SECTION BS 1080-1180 RBL 45.5 IAW SRM 51-40-02SDR IPXA09554947Seat Track · corrodedINSPECTION TYPE:C3 SEAT TRACK AT LBL 45.5 JUST FWD OF STA 1200 HAS 3 CORRODED NUTPLATES R & R SEAT TRACK PER ATS ER 09-1681 DATED 04MAR09SDR SWIA200921832Seat Track · corrodedC-CHECK, SEAT TRACKS CORRODED. REPLACED PER SRM.SDR AALA20090226TUL06Seat Track · corrodedCORROSION SEAT TRACK NUMBER 6, INSTALLED NEW SECTION SEAT TRACK SECTION PER SRM 53-40-01-2.SDR FDEA200902070482Seat Track · corrodedMCD SEAT TRACK FLANGE HAS CORROSION AT LBL24 APPROX FROM STA 370 TO 460. REMOVED AND REPLACED SEAT TRACK IAW SRM 53-10-5. FABRICATED TRACK AND SPLICES ON MAE TRAVELER T9/779235 AND T9/779236. MAJOR REPAIR, RII, RDR AND SDR.SDR USAA2009022490428Seat Track · corrodedBFM - C4 - MAJOR REPAIR - CORROSION ON SEAT TRACK AT BS 808, RBL 54.75. REPLACED SEAT TRACK AT BS 808, RBL 54.75 IAW B767 SRM 53-00-52.SDR DL75E090164Seat Track · corrodedCABIN STA 1635, RBL45 SEAT TRACK HAS CORROSION.SDR DL75E090157Seat Track · corrodedCABIN STA 1635 RBL 24 SEAT TRACK HAS CORROSION.SDR DL75E090154Seat Track · corrodedMAIN CABIN SEAT TRACK AT STA 640 RBL 45.5 FOUND CORROSION.SDR K11A2009020672001Seat Track · corrodedSEAT TRACK CORROSION.SDR HNAA2009022300069Seat Track · corrodedRIGHT INBOARD SEAT RAIL IS CORRODED AT GALLEY BUFFET MOUNTING HOLES. REMOVED AND REPLACED SEAT RAILS IN ACCORDANCE WITH RD8-53-3074.SDR HNAA2009022300068Seat Track · corrodedLEFT OUTBOARD FORWARD SEAT RAIL HAS SPOTS OF CORROSION AND MISSING SURFACE PROTECTIVE COATING WHERE SEAT LEGS ATTACHED. REMOVED AND REPLACED SEAT TRACK IN ACCORDANCE WITH DEHAVILLAND.SDR FDEA200902040448Seat Track · corrodedMAIN DECK FLOOR PANELS AND SEAT TRACKS FOUND CORROSION WITH EXFOLIATION ON TRACK. REPAIRED AREA IAW SRM 53-70-00, FIG 1, SHT 1 AND 2, VOL I.SDR CALA2009020400082Seat Track · crackedFORWARD CARGO COMPARTMENT BODY STATION 412 LBL 20 TRACK FOUND CRACKED. REPLACED FORWARD CARGO COMPARTMENT TRACK AT BODY STATION 412 LBL 20 PER SRM 51-10-02.SDR FDEA200902030435Seat Track · crackedCABIN, SEAT TRACK AT STA 635 X = 47.5 FOUND CRACKED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR FDEA200902030434Seat Track · crackedCABIN, SEAT TRACK AT STA 635 X = 27.5 FOUND CRACKED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 625 TO STA 665, X = 27.5 AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR CNMA20090119Seat Track · corrodedBS 1887-1941, LBL 27, CORROSION ON SEAT TRACK. DAMAGED SEAT-TRACK PORTION REMOVED, REINFORCED AREA WITH NEW PORTION OF SEAT-TRACK AND SPLICE. IAW SRM VOL 1, 53-70-00, FIG 1. INSTALLED FASTENERS IAW SRM VOL 2, 51-31-01.SDR ASOA200900171Seat Track · corrodedCABIN SEAT RAIL P/N 601R-38312-298 HAS CORROSION AND DAMAGE. FS 409R - 409+112R.SDR ASAA0944350Seat Track · wornRT LATERAL SEAT TRACK AT BS 480 WORN OB AND IB ENDS. REMOVED AND REPLACED SEAT TRACK SEGMENT.SDR USAA2009020690294Seat Track · corrodedSAL - C8 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR41 TO FR46 +17 INCHES, -Y1292. REPLACED SEAT TRACK BETWEEN FR41 TO FR46 +17 INCHES, -Y1292 IAW A320 SRM 51-72-11.SDR USAA20090204EM008Seat Track · dirtyCLT - CAPTAIN'S SEAT WILL NOT LOCK LATERALLY. MAINTENANCE REMOVED DEBRIS THAT WAS LODGED IN STOP ADJUSTMENT.
Back to JASC 5347