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 QXEA200601871Seat Track · corrodedPDX C3 - LEFT INBOARD SEAT TRACK HAS PITTING CORROSION BETWEEN X505 AND X508. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601863Seat Track · corrodedPDX C3 - LEFT INBOARD SEAT TRACK HAS CORROSION AND CHAFFING INSIDE TRACK CHANNEL BETWEEN STATIONS X144.0 - X159.0 WITH CHAFE DAMAGE ON TOP OF TRACK AT STATION X156.0. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601874Seat Track · chafedPDX C3 - LEFT INBOARD SEAT TRACK HAS CHAFE DAMAGE ON INSIDE OF TRACK, BETWEEN X608 AND X624. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601873Seat Track · corrodedPDX C3 - LEFT INBOARD SEAT TRACK HAS PITTING CORROSION BETWEEN X602 AND X606. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601872Seat Track · damagedPDX C3 - LEFT SEAT TRACK HAS CHAFE DAMAGE BETWEEN X510 AND X529, X545 AND X565, X574 AND X589. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601869Seat Track · corrodedPDX C3 - RIGHT INBOARD SEAT TRACK HAS PITTING CORROSION BETWEEN X703 AND X711. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601867Seat Track · chafedPDX C3 - RIGHT INBOARD SEAT TRACK HAS CHAFE DAMAGE ON INSIDE OF TRACK BETWEEN X607 AND X623. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601866Seat Track · corrodedPDX C3 - RIGHT INBOARD SEAT TRACK HAS PITTING CORROSION BETWEEN X604 AND X607. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601876Seat Track · corrodedPDX C3 - LEFT INBOARD SEAT TRACK HAS PITTING CORROSION BETWEEN X721 AND X744. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601868Seat Track · corrodedPDX C3 - RIGHT INBOARD SEAT TRACK HAS PITTING CORROSION BETWEEN X634 AND X637. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601865Seat Track · damagedPDX C3 - FOUND LEFT INBOARD SEAT TRACK HAS CHAFE DAMAGE ON TOP OF TRACK CUTOUT AT APPROXIMATELY STATION X249.4. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601864Seat Track · corrodedPDX C3 - LEFT INBOARD SEAT TRACK HAS CORROSION AND CHAFFING INSIDE CHANNEL BETWEEN STATIONS X206.0 - X226.0. ALSO, STATION X218.0 HAS LIGHT CORROSION ON TOP OF TRACK. REPAIRED IAW RD 8-/-53-884.SDR QXEA200601870Seat Track · chafedPDX C3 - LEFT INBOARD SEAT TRACK HAS CHAFE DAMAGE ON INSIDE OF TRACK BETWEEN X438 AND X456 AND X476 AND X499. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601726Seat Track · gougedPDX: C3 CHECK, GOUGE INSIDE CHANNEL OF RT INBOARD SEAT TRACK APPROX 373.00. MAINTENANCE REPAIRED IAW RD 8/4-53-884, Q400 SRM 51-20-16 AND NDTM PART 6, 51-00-01-250-801.SDR QXEA200601725Seat Track · gougedPDX: C3 CHECK, GOUGE ON TOP OF RT INBOARD SEAT TRACK AT APPROX X375.00. MAINTENANCE REPAIRED IAW RD 8/4-53-884, Q400 SRM 51-20-16 AND NDTM PART 6, 51-00-01-250-801.SDR QXEA200601723Seat Track · corrodedPDX: C3 CHECK, LT INBOARD SEAT TRACK HAS CORROSION AND CHAFING INSIDE CHANNEL BETWEEN STA X84.0 - X94.8. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-00-250-801.SDR QXEA200601722Seat Track · corrodedPDX: C3 CHECK, LT INBOARD SEAT TRACK HAS CORROSION AND CHAFING INSIDE CHANNEL BETWEEN STA X282.5 - X292.0. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01-250-801.SDR QXEA200601721Seat Track · corrodedPDX: C3 CHECK, LT INBOARD SEAT TRACK HAS CORROSION AND CHAFING INSIDE CHANNEL BETWEEN STA X413.0 - X4128.5. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01-250-801.SDR QXEA200601720Seat Track · corrodedPDX: C3 CHECK, LT INBOARD SEAT TRACK HAS CORROSION AND CHAFING INSIDE CHANNEL BETWEEN STA X376.0 - X391.0. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01-250-801.SDR QXEA200601719Seat Track · corrodedPDX: C3 CHECK, LT INBOARD SEAT TRACK HAS CORROSION AND CHAFING INSIDE CHANNEL BETWEEN STA X346.0 - X359.0. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01-250-801.SDR QXEA200601718Seat Track · corrodedPDX: C3 CHECK, LT INBOARD SEAT TRACK HAS CORROSION AND CHAFING INSIDE CHANNEL BETWEEN STA X241.0 - X259.5. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01-250-801.SDR QXEA200601717Seat Track · corrodedPDX: C3 CHECK, LT INBOARD SEAT TRACK HAS CORROSION AND CHAFING INSIDE CHANNEL BETWEEN STA X176.0 - X194.0. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01-250-801.SDR QXEA200601716Seat Track · corrodedPDX: C3 CHECK, LT INBOARD SEAT TRACK HAS CORROSION AND CHAFING INSIDE CHANNEL BETWEEN STA X113.0 - X127.0. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01-250-801.SDR QXEA200601715Seat Track · chafedPDX: C3 CHECK, LT INBOARD SEAT TRACK HAS CHAFE DAMAGE INSIDE CHANNEL AT APPROX STA X94.8. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01-250-801.SDR QXEA200601712Seat Track · damagedPDX: C3 CHECK, RT INBOARD SEAT TRACK HAS CHAFE DAMAGE ON INSIDE OF TRACK AT APPROX X509-528, X547-563 AND X571-590. MAINTENANCE REPAIRED IAW Q400 RD 8/4-53-884 AND NDTM PART 6, 51-00-01.SDR QXEA200601711Seat Track · chafedPDX: C3 CHECK, RT INBOARD SEAT TRACK HAS CHAFE DAMAGE ON INSIDE OF TRACK AT APPROX X428-439, X446-469 AND X479-501. MAINTENANCE REPAIRED IAW RD 8/4-53-884 ADN NDTM PART 6, 51-00-01.SDR 06FDEA2289Seat Track · corrodedRIGHT CABIN SEAT TRACK AT APPROX STA Y= 1521, X= -8.5 SEAT TRACK SLOT CHANNEL BASE AREA FOUND CORRODED. RIGHT CABIN SEAT TRACK AT APPROX STA Y= 1521, X= -8.5 CARRIED OUT. REPAIR AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR IS CLASSIFIED MAJOR PER GMM 6-2-1SDR 06FDEA2287Seat Track · corrodedRIGHT CABIN SEAT TRACK AT APPROX STA Y= 1561, X= -75.25 SUPPORT FLANGE FOUND CORRODED. RIGHT CABIN SEAT TRACK AT APPROX STA Y= 1561, X= -75.25 CARRIED OUT. REPAIR AS PER SRM 53-70-00 VOLUME I FIGURE 3. REFER TO SNRM N00759 FOR WORK DETAILS. REPAIR CLASSIFISDR QXEA200602173Seat Track · corrodedPDX: FUSELAGE INTERIOR INBOARD SEAT RAIL STA X721.0 - X783.0 HAS AREAS OF CORROSION RT SIDE. MAINTENANCE REPAIRED IAW RD 8/4-53-884, RD 8/4-53-1541, HORIZON EA 6-53-728 AND NDTM PART 6, 51-00-01.SDR QXEA200602172Seat Track · corrodedPDX: FUSELAGE INTERIOR CENTER SEAT RAIL STA X721.0 HAS AREAS OF CORROSION. MAINTENANCE REPAIRED IAW RD 8/4-53-1548, HORIZON EA 6-53-733 AND NDTM PART 6, 51-00-01.SDR MALA060429Seat Track · corrodedDURING 2 YEAR CHECK IN BNA FOUND SEAT TRACK AT BLO BETWEEN FS294 AND 319, IS CORRODED OUT OF LIMITS AND HAS BEEN REPAIRED IAW MESABA EO S53342. REF: EAMS WORK ORDER 214013 TASK 1504SDR MALA060428Seat Track · corrodedDURING 2 YEAR CHECK IN BNA FOUND SEAT TRACK AT LBL 18.3, BETWEEN FS294 AND 319, IS CORRODED OUT OF LIMITS AND HAS BEEN REPAIRED IAW MESABA EO S53342. REF: EAMS WORK ORDER 214013 TASK 1503.SDR SIMA200616718Seat Track · corrodedDURING IMBV FOUND LEFT INBOARD SEAT TRACK BETWEEN FRAMES 18-24 IS CORRODED. RAI`D SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA200616717Seat Track · corrodedDURING IMBV, FOUND LEFT INBOARD SEAT TRACK BETWEEN FRAMES 24-30 IS CORRODED. RAI`D SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA200616716Seat Track · corrodedDURING IMBV, FOUND LEFT INBOARD SEAT TRACK BETWEEN FRAMES 30-36 IS CORRODED. RAI`D SEAT TRACK IAW EMB AMM 53-01-06 AND I/C 2006-145/4615. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR UPS06847163Seat Track · corrodedINSPECTION TYPE:C2 MAIN CABIN SEAT TRACK AT STA 465 LBL 60 HAS EXFOLIATION CORROSION. CUT OUT DAMAGED SEAT TRACK AT STA 460-600 LBL 60 IAW SRM 53-2-0 FIG 12. LOCATED, DRILLED UP AND INSTALLED REPLACEMENT SEAT TRACK AT STA 460-600 LBL 60 IAW SRM 51-1-21 AND SSDR UPS06847162Seat Track · gougedINSPECTION TYPE:C2 CABIN SEAT TRACK AT STA 240 RBL 44 IS GOUGED AND SCALLOPS ARE DAMAGED. CUT OUT DAMAGED SEAT TRACK IAW EO DC8-5340-7779 AT STA 240 RBL 44 INSTALLED SEAT TRACK PLUG AT STA 240 RBL 44 IAW SRM 51-3-0, AND EO DC8-5340-7779.SDR SIMA200616517Seat Track · corrodedSAW - DURING IMBV INSPECTION, FOUND LEFT INBOARD SEAT TRACK BETWEEN FRAMES 22-28 IS CORRODED. REMOVED AND INSTALLED TRACK IAW AMM 53-01-06. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA200616516Seat Track · corrodedDURING IMBV INSPECTION, FOUND AFT RIGHT UPPER SEAT TRACK CORRODED BETWEEN FRAMES 47-53. REMOVED AND INSTALLED SEAT TRACK IAW EMB SRM 53-01-06. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA200616513Seat Track · corrodedDURING IMBV INSPECTION, FOUND RIGHT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 28 AND 36. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200616512Seat Track · corrodedDURING IMBV INSPECTION, FOUND RIGHT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 28 AND 36. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200616511Seat Track · corrodedSAW - DURING IMBV INSPECTION, FOUND AFT RIGHT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 47 AND 53. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200616505Seat Track · corrodedDURING IMBV INSPECTION, FOUND LEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 28 AND 36. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200616503Seat Track · corrodedDURING IMBV INSPECTION, FOUND RIGHT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 20 AND 28. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200616502Seat Track · corrodedDURING IMBV INSPECTION, FOUND RIGHT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 36 AND 47. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06-400-801A. AIRCRAFT RETURNED TO SERVICE. (M)SDR UPS06247383Seat Track · corrodedINSPECTION TYPE-C CORROSION ON SEAT TRACK, TOP CHORD BS 481 RBL 45.5 CORROSION FOUND OUTSIDE LIMITS IAW SRM 53-10-1. SEAT TRACK AND CONNECT OR REPLACED IAW SRM 53-10-05 AND SRM 51-30-02.SDR KCSA061174Seat Track · damagedFWD PIT SEAT TRACK DAMAGED AT BS 650, RBL 45.SDR QXEA200602248Seat Track · gougedYYC: FUSELAGE INTERIOR RT INBOARD SEAT RAIL STA X103.0 - X229.0 HAS AREAS OF CORROSION AND GOUGES. MAINTENANCE REPAIRED IAW RD 8/4-53-884, Q400 SRM TASK 51-40-00-800-801, SRM 51-42-05, SRM TASK 51-42-05-330-801, SRM 51-40-15-330-801, SRM 51-41-05-800-801 AND SDR QXEA200602246Seat Track · corrodedYYC: FUSELAGE INTERIOR RT INBOARD SEAT RAIL STA X11.0 - X103.0 HAS AREAS OF CORROSION. MAINTENANCE REPAIRED IAW Q400 SRM 51-41-00-800-801 AND 51-42-05-330-801, SRM TASK 51-40-07320-801, SRM 51-42-05-330-801, SRM 51-40-15-330-801 AND SRM 51-41-05-800-801.SDR SIMA200616715Seat Track · corrodedDURING IMBV FOUND LEFT OUTBOARD UPPER SEAT TRACK CORRODED BETWEEN FRAMES 47-52. RAI`D SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT WAS RETURNED TO SERVICE. (M)
Back to JASC 5347