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 GTIA021364Floorboard · brokenFTW - FOUND CABIN FLOORBOARD STATION 927-1003 NR 5 CORNER BROKEN CORRODED. FABRICATED NEW CABIN FLOORBOARD. (M)SDR GTIA021345Floorboard · brokenFTW - FOUND CABIN FLOORBOARD RIGHT STATION 826-844 BROKEN OUT INSERTS, CORROSION. FABRICATED NEW PANEL. (M)SDR GTIA021344Floorboard · brokenFTW - FOUND CABIN FLOORBOARD RIGHT STATOIN 869-886 CORNER BROKEN, CORROSION. FABRICATED PANEL. (M)SDR GTIA021343Floorboard · corrodedFTW - FOUND CABIN FLOORBOARD LEFT INBOARD STATION 864-886 INSERTS PULLED THROUGH, CORROSION. LOCATED AND DRILLED FLOORBOARD. (M0SDR GTIA021369Floor Panel · brokenFTW - FOUND FLOOR PANEL MAIN CABIN STATION 198-250 NR 5 FIBERGLASS SUPPORT BROKEN AT ENDS. REPAIRED FLOOR PANEL. (M)SDR GTIA021368Floorboard · deterioratedFTW - FOUND MAIN CABIN FLOORBOARD 199-250 NR 2 DETERIORATING AND BLUE WATER STAINS. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA021360Floor Panel · damagedFTW - FOUND FLOOR PANEL MAIN CABIN STATION 198-250 NR 6 BROKEN FIBERGLASS SUPPORTS BLUE WATER STAINS, DETERIORATED. REPAIRED FLOOR PANEL. (M)SDR GTIA021342Floorboard · damagedFTW - FOUND MAIN CABIN FLOORBOARD STATION 198-250 NR 4 MISSING INSERTS, DETERIORATED. FABRICATED NEW FLOORBOARD. (M)SDR GTIA021341Floorboard · damagedFTW - FOUND MAIN CABIN FLOORBOARD STATION 140-199 NR 5 DETERIORATED, LOCATED AND DRILLED. (M)SDR GTIA021340Floorboard · damagedFTW - FOUND MAIN CABIN FLOORBOARD STATION 120-140 NR 4 DETERIORATED, LOCATED AND DRILLED. (M)SDR GTIA021339Floorboard · damagedFTW - MAIN CABIN FLOORBOARD STATION 120-140 NR 3 DETERIORATED BLUE WATER STAINS. DRILLED AND LOCATED. (M)SDR GTIA021338Floorboard · damagedFTW - FOUND MAIN CABIN FLOORBOARD STATIN 140-199 NR 3 DETERIORATED. FABRICATED NEW FLOORBOARD. (M)SDR GTIA021337Floorboard · damagedFTW - FOUND MAIN CABIN FLOORBOARD STATION 140-199 NR 5 MISSING INSERTS, DETERIORATING. FABRICATED NEW FLOORBOARD. (M)SDR GTIA021329Floorboard · deterioratedFTW - FOUND MAIN CABIN FLOORBOARD STATION 120-140 NR 2 DETERIORATED. DRILLED AND LOCATED PANEL. (M)SDR GTIA021328Floorboard · deterioratedFTW - FOUND MAIN CABIN FLOORBOARD STATION 120-140, NR 1 DETERIORATED. DRILLED AND LOCATED PANEL. (M)SDR GTIA021326Floorboard · deterioratedFTW - FOUND MAIN CABIN FLOORBOARD STATION 198-250 NR 5 HAS CORRODED INSETS AND DETERIORATING BOARD. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA021327Floorboard · deterioratedFTW - FOUND LEFT COCKPIT FLOORBOARD STATION 120-183 DETERIORATED. FABRICATED NEW LEFT COCKPIT FLOORBOARD FS 120-183. (M)SDR SWIA200211716Floor Panel · crackedELECTRICAL BAY FLOOR FS 193.0 LEFT AND RIGHT SIDES CRACKED. FOUND DURING C-CHECK INSPECTION. HFEC INSPECTION COMPLIED WITH ON CUTOUT EDGE AND AREA AS REQUESTED IAW RJ NDTM 51-20-06. NO CRACKS FOUND. DAMAGED AREA REPAIRED IAW CRJ REO 601R-53-11-081 REV 'NC'SDR GTIA021304Floorboard · corrodedPAX CABIN STA 200 TO 160 FLOORBOARD CORRODED AT INSERTS/ DELAMINATED. FABRICATED NEW FLOORBOARD.SDR ASAA0280647Floorboard · corrodedOKC - FOUND DURING 30K CHECK, FLOORBOARD CORRODED AT 4 FASTENER HOLES AT FS 886-927. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASA0280650Floorboard · damagedOKC - FOUND DURING 30K CHECK, FLOORBOARD IS DISBONDED AT ONE END AND CREASED/CRACKED ACROSS ENTIRE WIDTH OF BOARD AT FS 927-1003. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280637Floorboard · dentedOKC - FOUND DURING 30K CHECK, FLOORBOARD HAS TWO DENTS AT FS 927-1003. REPLACED FLOORBOARD SECTION PER SRM 53-05. (M)SDR ASAA0280638Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOORBOARD HAS CORRODED INSERTS AT FS 160-200 NEAR L1 ENTRY DOOR. REPLACED FLOORBOARD SECTION PER SRM 53-05. (M)SDR ASAA0280639Insert · corrodedOKC - FOUND 30K CHECK, FOUND FLOORBOARD NR 3 HAS 16 CORRODED INSERTS AT FS 160-200. REPLACED FLOORBOARD NR 3 PER SRM 53-05. (M)SDR ASAA0280640Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOORBOARD NR 5 HAS 6 CORRODED INSERTS AT FS 160-200. REPLACED FLOORBOARD NR 5 PER SRM 53-05. (M)SDR ASAA0280641Insert · corrodedOKC - FOUND 30K CHECK, FLOORBOARD NR 8 HAS 8 CORRODED INSERTS AT FS 200-256. REPLACED FLOORBOARD NR 8 PER SRM 53-05. (M)SDR ASAA0280642Floorboard · damagedOKC - FOUND DURING 30K CHECK, FLOORBOARD HONEYCOMB DAMAGED AT FS 408-446. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR AMTA200300176Floor Panel · corrodedAFT CARGO COMPARTMENT FLOOR PANELS 140BF AND 140CF CORRODED. REPLACED FLOOR PANELS IAW AMM 25-25-10-400-801. (M)SDR AMTA200300175Floor Panel · corrodedAFT CARGO COMPARTMENT FLOOR PANEL 140AF CORRODED. REPLACED FLOOR PANEL IAW AMM 25-25-10-400-801. (M)SDR GTIA021272Floor Panel · crackedFTW - FOUND PASSENGER CABIN LEFT INBOARD FLOOR PANEL STATION 465 TO 541 HAS CRACKED METAL, CORE DAMAGE AND FASTENER BROKEN OFF IN PANEL. FABRICATED NEW PANEL. (M)SDR 730PA0001Skin PanelFloor panels damaged for aft cargo bin. Removed aft cargo floor panels and fabricated new per EA 53-319 authorizing the use of 2024-T3 .071 alclad sheet per the -60 installation.SDR GTIA021288Floor Panel · damagedFTW - FOUND CAPTAIN FLOOR PANEL NEXT TO CONTROL COLUMN HAS DELAMINATED AND BROKEN WOOD FILLER AS MARKED. LOCATED AND DRILLED NEW PANEL. (M)SDR GTIA021235Floorboard · damagedFTW - FLOORBOARD PANEL FS 1118-1184 BL0-BL23 HAS CORRODED INSERTS AND PUNCHER WITH DELAMINATION. FABRICATED NEW FLOORBOARD FS 1118-1184. (M)SDR ASAA0280566Floorboard · corrodedOKC - FOUND 30K CHECK, FLOORBOARD HAS NUMEROUS CORRODED INSERTS AND FASTENERS AT FS 207, LBL 22 TO RBL 22. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280567Floorboard · corrodedOKC - FOUND 30K CHECK, FLOORBOARD HAS NUMEROUS CORRODED INSERTS AND FASTENERS AT FS 160-207, BL 0 TO LBL 60. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280568Floorboard · corrodedOKC - FOUND FLOORBOARD HAS NUMEROUS CORRODED INSERTS AND FASTENERS AT FS 207, LBL 22-44. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280569Floorboard · damagedOKC - FOUND 30K-CHECK, FLOORBOARD HAS SOFT SPOT AT FS 218 TO 229, BL 0. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280570Floorboard · puncturedOKC - FOUND DURING 30K-CHECK, FLOORBOARD IS PUNCTURED AT FS 256-275, LBL 36. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280571Floorboard · puncturedOKC - FOUND 30K CHECK, FLOORBOARD IS PUNCTURED AT FS 1117-1174, LBL 22-LBL 44. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280572Floorboard · delaminatedOKC - FOUND 30K-CHECK, FOUND FLOORBOARD IS DELAMINATED FORWARD OF FS 617, RBL 36. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR UPS02239931Floor Panel · corrodedINSPECTION TYPE:C MAIN ENTRY DOOR FLOOR PANEL CORRODED BETWEEN FS 312 AND 344. REMOVED AND REPLACED FLOOR PANEL.SDR ASAA0280565Floorboard · damagedOKC - FOUND 30K-CHECK, FLOORBOARD HAS SOFT SPOT AT FS 1003 TO 1022 AT LBL 22 TO RBL 22. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR F3LA200200381Floor Panel · corrodedDURING C 6 CHECK, CORROSION WAS FOUND IN THE AFT CARGO PIT, RIGHT HAND, TRANSITION PANEL FROM STA 767 TO 727 AT RBL 21. INSPECTION FOUND THE PANEL TO BE OUT OF LIMITS IN ACCORDANCE WITH THE REQUIREMENTS OF SRM 63-60-53. A NEW PANEL WAS FABRICATED AND INSTALLSDR F3LA200200382Floor Panel · corrodedDURING C 6 CHECK, THE AFT CARGO PIT FLOOR TRANSITION PANEL, LEFT HAND, WAS FOUND CORRODED BETWEEN STA 727 TO STA 787, LBL 28. REMOVED DAMAGED PANEL AND FABRICATED REPLACEMENT. REPLACEMENT WAS PRIMED, PAINTED AND INSTALLED IN ACCORDANCE WITH THE REQUIREMENTS SDR F3LA200200380Floor Panel · corrodedDURING C 6 CHECK, CORROSION WAS FOUND IN THE AFT CARGO PIT FLOOR TRANSITION PANEL FROM STA 750 TO 754 AT RBL 20. REMOVED PANEL AND FABRICATED NEW PART IN ACCORDANCE WITH BOEING DRAWING 69-43477. PAINTED AND INSTALLED IN ACCORDANCE WITH SOPM 20-4602.SDR ASAA0280481Floorboard · debondedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 389-465, LBL 22-44. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR GTIA021298Floorboard · brokenFORWARD LAV AREA FLOORBOARD BROKEN AND DELAMINATED. REPAIRED DAMAGED AND DELAMINATED AREAS.SDR GTIA021199Floorboard · brokenFTW - FOUND CABIN FLOORBOARD STATION 1174-1117, BROKEN, DELAMINATED AND SOFT. FABRICATED A NEW FLOORBOARD. (M)SDR ASAA0280482Floorboard · delaminatedOKC - FOUND DURING 30K CHECK, FLOORBOARD DELAMINATED AT FS 1079-1156, LBL 22-44. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280483Stiffener · crackedOKC - FOUND DURING 30K CHECK, FLOORBOARD STIFFENER CRACKED AT FS 207-256, LBL 44-54. REPAIRED STIFFENER WITH FIBERGLASS OVERLAY PER MM 25-00-00, PARA 3E, PG 801. (M)
Back to JASC 5321