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 ASAA0480403Floor Panel · tornDURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 200-256, LBL 15 - RBL 22 HAS TORN FIBERS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480404Floor Panel · corrodedDURING HV-CHECK, FOUND CABIN FLOOR PANEL AT STATION 200-256, RBL 22-44 HAS CORRODED INSERTS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480410Floor Panel · corrodedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 160-200, LBL 44-54 HAS CORRODED INSERTS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480411Floor Panel · delaminatedDURING HV-CHECK, FOUND CABIN FLOOR PANEL AT STATION 144-160, RBL 32-44 HAS DELAMINATED CORNERS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480412Floor Panel · tornOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 200-256, LBL 22-44 HAS TORN FIBERS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480413Floor Panel · debondedDURING HV-CHECK, FOUND OVERWING AREA FLOORBOARD IS DISBONDED ON CORNER. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480408Floor Panel · crackedDURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 160-200, RBL 44-54 IS CRACKED. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480409Floor Panel · corrodedDURNIG HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 180-200, RBL 8-44 HAS CORRODED AND BROKEN INSERTS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480406Floor Panel · tornDURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 160-200, LBL 8 - RBL 8 HAS TORN FIBERS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480407Floor Panel · corrodedDURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 144-160, RBL 8-16 HAS CORRODED INSERTS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480405Floor Panel · debondedOKC - DURING HV CHECK, CABIN FLOOR PANEL AT STATION 160-200, LBL 8-44 HAS DISBONDED CORNERS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480402Floor Panel · delaminatedOKC - DURING C-CHECK, FOUND LEFT EXIT ROW 22 FLOOR PANEL IS BROKEN AND DELAMINATED. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOORBOARD IAW 53-05. (M)SDR GTIA040522Floor Panel · crackedCOCKPIT STA 127 LBL 6 FLOOR WEB CRACKED. TRIMMED OUT CRACK. FABRICATED FILLER AND DOUBLER. INSTALLED DOUBLER AND FILLER.SDR GTIA040521Floorboard · damagedCOCKPIT RT FLOORBOARD, DELAMINADED AND EDGE DAMAGED. FAB RT COCKPIT FLOORBOARD.SDR USAA040217Floor Panel · crackedFLOOR PANEL, .9 INCH CRACK, MAIN CABIN, FLOOR PANEL 242 MF. FABRICATED FLOOR PANEL IAW SRM.SDR USAA040216Floor Panel · crackedFLOOR PANEL, 1.2 INCH CRACK, MAIN CABIN FLOOR PANEL 261 HG. FABRICATED FLOOR PANEL IAW SRM.SDR ASAA0480374Floor Panel · crackedOKC - DURING HV CHECK, FOUND OVERWING AREA FLOOR PANEL HAS CRACKED ATTACH STRIP. REPAIR IAW SRM. (M)SDR ASAA0480375Floor Panel · crackedDURING HV CHECK, FOUND OVERWING AREA FLOOR PANEL HAS 2 CRACKS ON ATTACH STRIP. REPAIR IAW MM. (M)SDR ASAA0480376Floor Panel · debondedDURING HV CHECK, FOUND CABIN FLOOR PANEL AT FS 826-927 TRIM SEPARATED. REPAIR IAW SRM. (M)SDR ASAA0480377Floor Panel · debondedDURING HV CHECK, FOUND CABIN FLOOR PANEL AT FS 200-256 STIFFENERS ARE DISBONDED. REPAIR IAW MM. (M)SDR ASAA0480387Floor Panel · crackedDURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 927-1003 CRACKED. REPAIR IAW SRM. (M)SDR ASAA0480388Floorboard · puncturedDURING HV CHECK, FOUND OVERWING AREA FLOORBOARD HAS A HOLE AT STATION 826. REPAIR IAW SRM. (M)SDR ASAA0480386Floor Panel · tornOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 160-180 AND RBL 8-44 DAMAGED. REPAIR IAW SRM. (M)SDR ASAA0480385Floor Panel · crackedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL STATION 200-256 AND LBL 15-22 CRACKED. REPAIR IAW SRM. (M)SDR DHL2004765003Floor Panel · corrodedAFT LOWER CARGO COMPARTMENT FLOOR COMPARTMENT B9 & B10 HAS LIQUID SPILL THAT IS CAUSING SURFACE CORROSION & MINOR PITTING ON FLOOR PANELS. REMOVED CORROSION AND TREATED WITH ARODINE IAW SRM 51-10-2 AND SRM 51-10-6. MATERIAL LOSS LESS THAN .001, WITHIN LIMITSSDR GTIA040501Floorboard · delaminatedG2 GALLEY FLOOR BOARD AT STA 148 TO STA 200 (H) DELAMINATED. REMOVED FLOORBOARD. FAB NEW FLOORBOARD. INSTALLED FLOORBOARD.SDR GTIA040495Floorboard · delaminatedRT OB FLOORBOARD PANEL STA 1079-1117 PANEL DELAMINATED. BONDED FLOORBOARD.SDR GTIA040494Floorboard · delaminatedG2 GALLEY FLOORBOARD AT STA 200 TO STA 256 (P) DELAMINATED. FAB FLOORBOARD.SDR GTIA040493Floorboard · delaminatedG2 GALLEY FLOORBOARD AT STA 200 TO STA 256 (N) DELAMINATED. FAB NEW FLOORBOARD.SDR GTIA040492Floorboard · delaminatedG4 GALLEY FLOORBOARD AT STA 1155 TO STA 1287 (D) DELAMINATED. REPAIRED DELAMINATED AREAS.SDR GTIA040491Floorboard · delaminatedG4 GALLEY FLOORBOARD AT STA 1117 TO STA 1287 (C) DELAMINATED. FABRICATED NEW FLOORBOARD.SDR GTIA040480Floorboard · delaminatedCABIN RT IB FLOORBOARD AT STA 1250-1309 DELAMINATED SEVERAL PLACES. FAB NEW CABIN FLOORBOARD.SDR GTIA040477Floor Panel · crackedCOCKPIT FLOOR PANEL CRACKED AND NON SKID MISSING. FABRICATED NEW PANEL.SDR GTIA040476Floorboard · delaminatedRT OB FLOORBOARD PANEL STA 1003-1079 RIVETS PULLED AND PANEL DELAMINATED, SPACER MISSING. FABRICATED REPLACEMENT FILLER. BONDED FILLER TO RT OB FLOOR PANEL.SDR ASAA0480365Floorboard · delaminatedOKC - DURING C-CHECK, FOUND FLOORBOARD IS DELAMINATED AT FS 693-750. REPAIR IAW SRM. (M)SDR GTIA040505Seal · brokenFLOOR PANEL STA 1003-1079 CORNER BROKEN NO EDGE SEAL. FABRICATED NEW FLOOR PANEL.SDR GTIA040498Floor Panel · delaminatedF/O STEERING COLUMN FLOOR PANEL DELAMINATED. REBONDED DELAMINATED AREA.SDR GTIA040497Floor Panel · crackedCOCKPIT F/O`S FLOOR PANEL CRACKED AND DRILLED OFF SCREW. CUT OUT CRACKED PART. FABRICATED DOUBLER. INSTALLED FABED PARTS.SDR GTIA040496Floor Panel · separatedFLOOR PANEL 1251-1309 SEPARATED. FAB NEW FLOOR PANEL.SDR GTIA040486Floorboard · damagedMAIN CABIN STA 470 CENTER FLOORBOARD IS SPONGY UNDER FOOT. FAB FLOORBOARD. INSTALLED NEW FLOORBOARD.SDR ASOA04359Floor Panel · corrodedDURING C-CHECK INSPECTION, THE FLOOR WEB AT THE FORWARD CARGO DOOR ENTRANCE AT FRAME 13 TO 17 WAS FOUND CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE CORRODED FLOOR WEB IAW SRM 533780 AND 512500. AIRCRAFT WAS RELEASED FROM C-CHECK ON MAY 14, 2SDR USAA040172Floor Panel · delaminatedFLOOR PANEL, 6 INCHES X .2500 INCH W, DELAMINATION, FLOOR PANEL NR 241 AF, FR 34 AND 35 AT Y24, Z240. FABRICATED NEW FLOOR PANEL IAW SRM 53-02-00, FIG 209. FABRICATED NEW FLOOR PANEL IAW SRM 53-02-00, FIG 209.SDR USAA040171Floor Panel · delaminatedFLOOR PANEL 4 INCH X 4 INCH AREA, DELAMINATION, 31.25 CM FWD OF FR 68, Y 756.25. FABRICATED NEW FLOOR PANEL IAW SRM 53-02-00, FIG 209.SDR USAA040170Floor Panel · delaminatedFLOOR PANEL, 4.5 INCH X 5.5 INCH OB AFT CORNER, DELAMINATION FR 66, Y1182, FLOOR PANEL 261 HG. NEW PANEL FABRICATED IAW SRM 53-02-00, FIG 309.SDR GTIA040388Floor Panel · crackedFTW - FOUND MAIN C/B STATION 389 TO STATION 465 LBL 24 INCHES TO 44 INCHES FLOOR PANEL HAS CRACKED ON EDGES/SEVERAL INSERTS DAMAGED. FABRICATED FLOOR PANEL. (M)SDR 0400745515Floor Panel · corrodedDURING H-CHECK FOUND CORROSION ON FLOOR WEB UPPER SURFACE FROM BS 1712 TO 1716 LBL 50 TO RBL 50. REPAIRED PER EA 55-199013.SDR USAA040157Floor Panel · corrodedBFM - FOUND FLOOR PANEL CORRODED 2 INCHES BY 38.5 INCHES BY 13 INCHES AND .5 INCH BY 10 INCH AREA, PANEL NR 222FF, FRAME 16-20, Y=-1732, Z=-240. DEFECTIVE PART REPLACED WITH IDENT PART NR PER SRM 53-02-00. CORROSION LEVEL 2, TASK NR JA-220-53300. (M)SDR USAA040158Floor Panel · corrodedBFM - FOUND FLOOR PANEL CORRODED 1 INCH BY 36 INCHES, 1 INCH BY 12 INCHES, 1 INCH BY 10 INCHES, PANEL NR 221FF, FRAME 16-20, Y=1732, Z=-240. REMOVED AND INSTALLED NEW PANEL. CORROSION LEVEL 2, TASK NR JA-220-53300-001. (M)SDR GTIA040318Floor Panel · crackedMAIN CB STA 446 TO 466 RT SIDE MID FLOOR PANEL HAS CRACKED/DAMAGE ON EDGE.SDR USAA040156Floorboard · corrodedBFM - FOUND FLOORBOARD CORRODED 1.3 INCHES BY 1.125 INCH BY .10 INCH DEEP, BETWEEN FRAME 66-68, -Y1732, -Z240. REMOVED AND REPLACED FLOORBOARD PER SRM 51-42-11, 51-74-00. (M)
Back to JASC 5321