JASC 5321
Service difficulty reports · 49,402
Reports filed under 5321 · Fuselage Floor Panel, 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 = '5321' 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 = '5321' 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 SWIA200413027Floor Panel · crackedDISCOVERED DURING C-CHECK INSPECTION, FS 193 LEFT SIDE ELECTRICAL BAY FLOOR CRACKED. DISCOVERED DURING C-CHECK INSPECTION. REPAIRED FLOOR IAW CRJ REO 601R-53-11-081 REV. NC AND RII 53-401SDR ASAA0480171Floor Panel · delaminatedOKC - DURING HV12 CHECK, FOUND CABIN FLOOR PANEL HAS SEVERAL DELAMINATED AREAS AT FS 200-256. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480169Floor Panel · corrodedOKC - DURING HV12 CHECK, FOUND CABIN FLOOR PANEL HAS MISSING AND CORRODED INSERTS AT FS 148-200. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480164Floor Panel · delaminatedOKC - DURING HV12 CHECK, FOUND CABIN FLOOR PANEL HAS DELAMINATED AREAS AT FS 864-886. REPLACED PANEL PER SRM 53-05. (M)SDR SWIA200413158Floor Panel · crackedDISCOVERED DURING C-CHECK INSPECTION, WING BOX PRESSURE FLOOR SKIN CRACKED AT FS460, LBL2 - LBL8 AND RBL2 - RBL8, 4 CRACKS TOTAL. PRESSURE FLOOR REPAIRED IAW CRJ REO 601R-53-41-102 REV. NC, RII 53-401.SDR SWIA200413157Floor Panel · crackedDISCOVERED DURING C-CHECK INSPECTION, FORWARD EQUIPMENT COMPARTMENT FS 193.00 RIGHT SIDE FLOOR WEB CRACKED BY FRAME. REPAIRED IAW CRJ REO 601R-53-11-245 REV. NC.SDR SWIA200413156Floor Panel · crackedDISCOVERED DURING C-CHECK INSPECTION, FORWARD EQUIPMENT COMP FS 193.0 LT SIDE FLOOR WEB CRACKED BY FRAME. REPAIRED IAW CRJ REO 601R-53-11-081 REV. NC, RII 53-401.SDR GTIA040196Floor Panel · delaminatedFTW - FOUND FLOOR PANEL BETWEEN AFT LAVS, STAINED, CORNER DELAMINATED. REPAIRED CORNER DELAMINATION. (M)SDR GTIA040195Floor Panel · crackedFTW - FOUND COCKPIT FLOOR PANEL LEFT, PUNCTURED, FASTENER HOLES BROKEN OUT, CHAFED STRIP MISSING PLASTIC SHIELD BROKEN, EDGE CRACKED. COCKPIT FLOOR PANEL HAS PUNCTURE AND NUMEROUS CRACKS. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040194Floor Panel · brokenFTW - FOUND COCKPIT CENTER FLOOR PANEL, CORNERS BROKEN OUT DRAIN PLATE CORRODED, DETERIORATING. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040191Floor Panel · delaminatedFTW - FOUND FLOOR PANEL STATION 160-200 LEFT OUTBOARD DELAMINATED, INSERTS MISSING, CRACKED, EDGE SEAL. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040192Floor Panel · puncturedFTB - FOUND LEFT OUTBOARD FLOOR PANEL STATION 258-313 HAS PUNCTURE. FOUND ADDITIONAL CRACK. REMOVED DAMAGED AREA. FABRICATED DOUBLER AND HAT CHANNEL. INSTALLED HAT CHANNEL AND DOUBLER. (M)SDR GTIA040190Floor Panel · corrodedFTW - FOUND FLOOR PANEL FIRST OFFICERS SIDE, CORRODED, DISBONDED, STIFFENER BENT. REBONDED FLOOR PANEL. (M)SDR GTIA040189Floor Panel · deterioratedFTW - FOUND FLOOR PANEL 200-237 STAINED, DETERIORATED. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040188Floor Panel · delaminatedFTW - FLOOR PANEL STATION 160-200 DELAMINATED, NO EDGE SEAL. FABRICATED NEW FLOOR PANEL. (M)SDR ASAA0480158Floorboard · gougedOKC - FOUND CABIN FLOORBOARD X=22 STATION 1117-1174 HAS GOUGES AND DELAMINATED EDGES. FABRICATED REPLACEMENT FLOORBOARD IAW MD80 SRM 53-05. (M)SDR ASAA0480157Floorboard · corrodedOKC - FOUND CABIN FLOORBOARD STATION 200-256 X=14-X=22 HAS SEVERAL CORRODED INSERTS. FABRICATED REPLACEMENT FLOORBOARD IAW MD80 SRM 53-05. (M)SDR ASAA0480150Insert · corrodedOKC - DURING CABIN FLOORBOARD STATION 160-200 HAS SEVERAL CORRODED INSERTS. FABRICATED REPLACEMENT FLOORBOARD IAW MD80 SRM 53-05. (M)SDR ASAA0480148Floorboard · delaminatedOKC - FOUND CABIN FLOORBOARD STATION 946-1003 CENTER HAS DELAMINATION AROUND EDGES. FABRICATED REPLACEMENT FLOORBOARD IAW MD80 SRM 53-05. (M)SDR ASAA0480155Insert · corrodedOKC - FOUND CABIN FLOORBOARD STATION 160-200 HAS SEVERAL INSERTS CORRODED AND BENT. FABRICATED REPLACEMENT FLOORBOARD IAW MD80 SRM 53-05. (M0SDR ASAA0480154Floorboard · crackedOKC - FOUND CABIN FLOORBOARD STATION 927-1003 HAS CRACK IN SKIN AND DELAMINATION AROUND EDGES. FABRICATED REPLACEMENT FLOORBOARD IAW MD80 SRM 53-05. (M)SDR ASAA0480151Floorboard · gougedOKC - FOUND CABIN FLOORBOARD X=-44 STATION 1079-1155 HAS GOUGES AROUND EDGES AND IN SKIN. FABRICATED REPLACEMENT FLOORBOARDS IAW MD80 SRM 53-05. (M)SDR ASAA0480115Insert · corrodedOKC - DURING HV6-CHECK, FOUND CABIN FLOOR PANEL HAS CORRODED INSERTS AT FS 200-256. REPLACED DAMAGED PANEL PER SRM 53-05. (M)SDR ASAA0480118Floor Panel · corrodedOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL IS CORRODED OUTBOARD OF OUTBOARD TRACK AT FS 256-313. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0480117Floor Panel · corrodedOKC - DURING HV6-CHECK, FOUND CABIN FLOOR PANEL HAS CORRODED AND BENT INSERTS AT FS 200-256. REPLACED PANEL PER SRM 53-05. (M)SDR USAA040042Floor Panel · crackedBFM - FOUND FLOOR PANEL 222EF CRACKED 1 INCH, FRAME 16-20 EDGE OF TOP SURFACE. FABRICATED NEW FLOOR PANEL PER SAMPLE PER SRM 53-002-00. (M)SDR USAA040041Floor Panel · delaminatedBFM - FOUND FLOOR PANEL DELAMINATED 1.5 SQUARE INCH, TOP SURFACE FLOOR PANEL 241EF, FRAME 36-42. FABRICATED NEW FLOOR PANEL PER SRM 53-02-00. (M)SDR AMTA200400205Floor Panel · corrodedC-2 FLOOR HAS SEVERAL AREAS OF CORROSION FROM STATION 1465-1180. REPLACED FLOOR PANELS FROM STATION 1465-1330 AND 1330-1180 PER A MM 25-50-04-4 AND SRM 53-00-53-1. (M)SDR CALA0400177Splice · corrodedINSPECTION FOUND AFT CARGO PIT FLOOR PANEL SPLICE CORRODED AT STA 727D. THE FLOOR PANEL SPLICE WAS REPLACED IAW IPC 53-42-11-26.SDR ASAA0480098Floor Panel · damagedOKC - DURING HV6-CHECK, FOUND CABIN FLOOR PANEL HAS MISSING EDGE SEAL AT FS 886-905. RESEALED PANEL PER DPS 1.901 AND DWG 9936584. (M)SDR ASAA0480106Floor Panel · damagedOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL EDGE SEAL MISSING FS 1007-1079. RESEALED PER DPS 1.901 AND DWG 9936584. (M)SDR ASAA0480105Floor Panel · damagedOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL EDGE SEAL MISSING FS 1009-1041. RESEALED PER DPS 1.901 AND DWG 9936584. (M)SDR ASAA0480102Floor Panel · delaminatedOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL CORNER IS DELAMINATED AT FS 160-180. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0480101Floor Panel · delaminatedOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL EDGE DELAMINATED AT FS 160-200. REPLACED PANEL PER SRM 53-05. (M)SDR GTIA040203Floorboard · delaminatedFTW - FOUND MAIN CABIN F/B FS 256-312 CENTER IS DAMAGED AND DELAMINATED AT INSERTS. FABRICATED NEW FLOORBOARD. (M)SDR 2004F00325Floor Panel · delaminatedDURING INSPECTION, FOUND FLOOR WAS DELAMINATING. THE PROBLEM IS A RESULT OF THE TOILET LEAKING AND CAUSING CORROSION, A REQUEST WAS GRANTED FROM LEARJET TO OPERATE A/C UNTIL 2/18/2004. AT WHICH TIME FLOOR WILL BE REPLACED. (M)SDR ASAA0480094Floor Panel · damagedOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL HAS BROKEN INSERTS AND MISSING MATERIAL AT FS 465-541. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0480093Insert · missingOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL HAS NUMEROUS MISSING, BROKEN AND CORRODED INSERTS AT FS 200-256. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0480092Insert · corrodedOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL HAS CORRODED INSERTS AT FS 180-200. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0480091Floor Panel · tornOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL HAS TORN EDGE AT FS 160-200. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0480090Floor Panel · crushedOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL CORNER IS CRUSHED AT FS 905-977. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0480095Floor Panel · damagedOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL HAS EDGE SEALANT MISSING AT FS 864-886. RESEALED EFFECTED AREAS. (M)SDR ASAA0480097Floor Panel · corrodedOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL HAS CORRODED INSERTS AT FS 160-200. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0480096Floor Panel · damagedOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL HAS EDGE SEALANT MISSING AT FS 826-864. RESEALED EFFECTED AREAS. (M)SDR GTIA040172Floorboard · damagedFTW - FOUND MAIN CABIN FLOORBOARD FS 200-256 LEFT INBOARD CENTER HAS MISSING AND DAMAGED INSERTS AND DAMAGED ON END. FABRICATED NEW CABIN FLOORBOARD STATION 200-256. (M)SDR ASAA0480087Floor Panel · gougedOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL IS GOUGED ALONG EDGE AT FS 905-977. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480086Floor Panel · corrodedOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL HAS CORRODED INSERTS AT FS 200-256. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480085Floor Panel · gougedOKC - DURING HV6 CHECK, FOUND CABIN FLOOR PANEL IS GOUGED AT EDGE AT FS 808-826. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR GTIA040205Floorboard · delaminatedFTW - FOUND MAIN CABIN F/B FS 1078-1155 LBL 30 IS DELAMINATED AND DAMAGED. FABRICATED NEW FLOORBOARD. (M)SDR UPS04541960Floor Panel · corrodedINSPECTION TYPE: C, CORROSION ON MAIN DECK FLOOR WEB SURFACE BS 368-375 RBL 22 WL 208. REPAIRED PER SRM 51-70-13.
Back to JASC 5321