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 GTIA030603Floorboard · delaminatedFTW - FOUND RIGHT COCKPIT FLOOR PANELS TWO NO FILL AND DELAMINATED. FABRICATED TWO NEW FLOORBOARD. (M)SDR 03FDEA01153Floor Panel · corrodedFORWARD PIT FLOOR PANEL DELEMINATED WITH CORROSION. RECEIVED PANEL AND FAB ON TRAVELER T2/351475 IAW DWG SRZ 25-005.SDR GTIA030632Floor Panel · crackedFOUND CABIN FLOOR PANEL STATION 1003-1072 IS CRACKED AND DISBONDED. STOP DRILLED CRACK. FABRICATED DOUBLER. INSTALLED DOUBLER. (M)SDR GTIA030593Floorboard · crackedFTW - LEFT FLOOR PANEL, FS 886, SKIN CRACKED WITH MATERIAL MISSING AND EDGE FILLER DAMAGED AROUND PERIPHERY. FABRICATED NEW FLOORBOARD. (M)SDR GTIA030594Channel · debondedFTW - FOUND CABIN FLOORBOARD AT FS 1250-1309 LEFT OUTBOARD BOTH 'HAT' CHANNELS DISBONDED. RE-BONDED 2 EACH HAT CHANNELS ON FLOORBOARD. (M)SDR 2003UALA00577Floor Panel · crackedMAIN CABIN FLOOR PANEL AT APB CRACKED BS 1016+12 RBL 2. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED PANEL.SDR GTIA030597Floorboard · corrodedFTIA - FOUND CABIN FLOORBOARD AT FS 1271-1338 CTR CORRODED AND BROKEN INSERTS AND BROKEN CORNER/EDGES. FABRICATED NEW FLOORBOARD. (M)SDR GTIA030596Floorboard · corrodedFTW - FOUND CABIN FLOORBOARD CORRODED, BROKEN INSERTS, EDGES BROKEN, FS 1271-1338. FABRICATED NEW FLOORBOARD. (M)SDR GTIA030584Floor Panel · crackedFTW - MAIN CABIN LEFT SIDE STATION 1174 TO 1250 SUB-FLOOR PANEL (PHENOLIC) HAS DISBONDED AT LOWER HATS SECTION AND CRACKS AT FORWARD EDGE. REPAIRED LOWER HAT SECTIONS AND CRACKS ON SUB FLOOR PANEL STATION 1174 TO 1250. (M)SDR GTIA030589Angle · corrodedFTW - FOUND COCKPIT FLOORBOARD FS 120-160 LEFT ATTACHED SYN ANGLE CRACKED, CORRODED AND DIRTY. REMOVED CRACKED ANGLE. FORMED NEW ANGLE. FABRICATED NEW FLOORBOARD. INSTALLED NEW ANGLE. (M)SDR GTIA030583Angle · brokenFTW - FOUND RIGHT COCKPIT FLOORBOARD ATTACHED SYNTHETIC ANGLE BROKEN, HEAVY FOOD/DIRTY DEPOSITS. REMOVED SYNETHETIC ANGLE. FORMED NEW ANGLE. INSTALLED NEW ANGLE. (M)SDR GTIA030579Floorboard · corrodedFTW - FOUND MAIN CABIN STATION 256 TO STATION 313 RBL 22 TO RBL 45 FLOORBOARD HAS CORROSION AND PUNCTURE HOLES AT BACKSIDE R5. FABRICATED NEW FLOORBOARD. (M)SDR GTIA030573Floorboard · delaminatedFOUND CABIN FLOOR BOARD FORWARD R1 DOOR CORRODED INSERTS, BOARD DELAMINATED, EDGE FILL INCOMPLETE. FABRICATED NEW PANEL. (M)SDR AMTA200300864Floor Panel · crackedFOUND C1 CARGO PIT CRACK IN FLOOR PANEL AT FS 679 DAMAGE IS 7 INCHES RT OF CENTER LINE 1.5 INCHES LONG. PERFORMED INTERIM REPAIR PER ERA L10-53T-2549 REV B.SDR SWIA200312149Floor Panel · crackedFS 193 ELECTRICAL BAY RT FLOOR CRACKED. DISCOVERED DURING C-CHECK. REPAIRED DAMAGED FLOOR IAW CRJ REO 601R-53-11-245, REV NC.SDR SWIA200312148Floor Panel · crackedFS 193 ELECTRICAL BAY LT FLOOR CRACKED. DISCOVERED DURING C-CHECK. REPAIRED DAMAGE IAW CRJ REO 601R-53-11-081 REV NC.SDR GTIA030492Floorboard · delaminatedFOUND CABIN FLOORBOARD STATION 617-674 STIFFENER DELAMINATED FROM BOTTOM. RESEALED DISBONDED STRIPS. (M)SDR GTIA030490Floor Panel · delaminatedCABIN FLOORBOARD DELAMINATED AND NUMEROUS INSERTS CORRODED. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA030513Floorboard · delaminatedFTW - FOUND RIGHT AFT LAVATORY FLOORBOARD DELAMINATED. FABRICATED NEW FLOORBOARD. (M)SDR GTIA030532Floor Panel · delaminatedFTW - FOUND FORWARD LAV INBOARD SECTION FLOOR PANEL DELAMINATED AND CORRODED AROUND EDGES. REPAIRED DELAMINATION. (M)SDR GTIA030524Floorboard · corrodedFTW - FOUND CABIN FLOORBOARD FS 160-200 LBL 24 INCHES DELAMINATED AND CORRODED INSERTS AND FASTENERS. REMOVED FLOORBOARD. FABRICATED NEW PANEL INSTALLED NEW FLOORBOARD. (M)SDR GTIA030482Floor Panel · corrodedAFT PIT STATION 1117-1155 STRINGER 18L FLOOR WEB CORRODED. FABRICATED REPAIR DOUBLER. INSTALLED REPAIR DOUBLER. (M)SDR GTIA030512Floorboard · crackedFTW - FOUND AFT PIT CEILING STATION 1338 LBL 49 LAV FLOOR CRACKED. FOUND FLOORBOARD FRAME CORRODED AND OUT OF LIMITS. FABRICATED LEFT AFT LAV FLOORBOARD FRAME. FABRICATED LEFT AFT LAV FLOORBOARD. INSTALLED LEFT AFT LAV FLOORBOARD. (M)SDR GTIA030495Floor Panel · crackedFTW - AFT PIT STATION 1287-1309 STRINGER 18R FLOOR PANEL CRACKED. TRIMMED OUT DAMAGED AREA. LOCATED AND DRILLED DOUBLER/FILLERS. INSTALLED DOUBLER/FILLERS. (M)SDR 2003UALA00474Floor Panel · crackedFWD PIT STA 720 FLOOR WEB CRACKED AT RBL 12 INCHES. CRACK LOCATED APPROX 8 INCHES BELOW T-CHORD OF FRAME & IS APPROXIMATELY 1 INCH LONG. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED FILLER AND DOUBLER.SDR DLM88030513Floor Panel · puncturedON ARRIVAL IAD FOUND HOLE IN FLOOR OF NR 5 BAG BIN. REPAIRED PER DRD 5305D.SDR GTIA030445Floor Panel · delaminatedFOUND PASSENGER CABIN UNDER G-4 GALLEY FLOOR PANEL DELAMINATED, INSERTS BAD. FABRICATED NEW PANEL. INSTALLED FLOOR PANEL. (M)SDR CALA0300317Pressure Panel · crackedINSPECTION FOUND CRACKS IN PRESSURE DECK WEB AT STA 665 TO 675, RBL 35 TO 45. A WEB STIFFENER WAS INSTALLED IAW ECRA 5312-01022.SDR DHL2003604581Floor Panel · corrodedMAIN CARGO COMPT, CORROSION ON FLOOR PANEL SKIN STA 1160.000 TRACK NR 6. REMOVED CORROSION IAW SRM 51-1-8 PG 17,18 FOUND OUT OF LIMITS IAW SRM 53-2-0 PG 2P. FABRICATED DOUBLER IAW SRM 53-2-3 FIG 10. CLEANED, TREATED AND PRIMED AREA AND DOUBLER IAW SRM 51-1-8B.SDR GTIA030443Floorboard · debondedFOUND FLOORBOARD STATION 1156-1254 LBL 44 STIFFENERS CRACKED AND DEBONDED. REPAIRED FLOORBOARD. (M)SDR GTIA030442Floor Panel · debondedFOUND FLOOR PANEL OUTBOARD G-2 STIFFENERS CHAFING AND DEBONDED. REPAIRED FLOOR PANEL. (M)SDR UIEA200300026Floor Panel · delaminatedDURING C-CEHCK AT SIN, FOUND FLOOR PANEL DELAMINATED AT FS 2040 TO STATION 2140, RIGHT SIDE RBL 33.00-75.00. REPAIR BOND A 2024-T3 REPAIR DOUBLER TO THE UNDERSIDE OF THE FLOOR PANEL, PER REF'A'. REPAIR PER REF 'A' IS TIME LIMITED. DER APPROVAL OF REF 'A' ENSDR GTIA030474Floor Panel · crackedFOUND RIGHT CO-PILOT CONTROL COLUMN FLOOR PANEL CRACKED. REMOVED DAMAGED FLOOR PANEL. LOCATED AND DRILLED NEW FLOOR PANEL. INSTALLED NEW FLOOR PANEL SKIN. (M)SDR GTIA030389Floor Panel · brokenFOUND FLIGHT COMP, F/O'S RIGHT FORWARD FLOOR PANEL BROKEN. REMOVED FLOORBOARD. FABRICATED NEW FLOORBOARD. INSTALLED F/B RIGHT. (M)SDR GTIA030371Floor Panel · damagedFTW - HIDDEN DAMAGE COCKPIT FLIGHT OFFICERS FLOOR PANEL DIRECTLY UNDER SEAT CORRODED. FABRICATED NEW PANEL. (M)SDR AWXA200300601Floor Panel · delaminatedDURING C-01 CHECK CENTER WING FLOOR PANEL 241EF WAS FOUND DELAMINATED. MAINTENANCE REMOVED DAMAGED FLOOR PANEL 241EF; FABRICATED A NEW REPLACEMENT PANEL PER DWG 10D536-70057; INSTALLED REPAIR PART IAW AWA T/C R1C25306.SDR AWXA200300600Floor Panel · delaminatedMCN - MAJOR REPAIR - DURING C-01 CHECK CABIN FLOOR PANEL 241FF WAS FOUND DELAMINATED. MAINTENANCE REMOVED DAMAGED FLOOR PANEL 241FF; FABRICATED A NEW REPLACEMENT PANEL PER DWG 10D536-70057; INSTALLED REPAIR PART IAW AWA T/C R1C25306.SDR AWXA200300599Floor Panel · delaminatedMCN - MAJOR REPAIR - DURING C-01 CHECK CENTER WING FLOOR PANEL 242FF WAS FOUND DELAMINATED. MAINTENANCE REMOVED DAMAGED FLOOR PANEL 242FF; FABRICATED A NEW REPLACEMENT PANEL PER DWG 10D536-70055; INSTALLED REPAIR PART IAW AWA T/C R1C25306.SDR AWXA200300571Floor Panel · delaminatedMCN - MAJOR REPAIR - DURING C-01 CHECK CABIN FLOOR PANEL 242GF WAS FOUND DELAMINATED. MAINTENANCE REMOVED CABIN FLOOR PANEL 242GF; FABRICATED A NEW REPLACEMENT FLOOR PANEL PER DWG D536-70055; INSTALLED NEW PANEL IAW AWA T/C R1C25306, AND A320 SRM 53-02-00, PGSDR GTIA030397Floor Panel · brokenFOUND PASSENGER CABIN FLOOR PANEL AT FS 1250-1303 CENTER, PANEL HONEY COMB EDGE BROKEN. FABRICATED FLOOR PANEL. (M)SDR AWXA200300640Floor Panel · delaminatedMCN - MAJOR REPAIR - DURING C-03 CHECK PASSENGER CABIN FLOOR PANEL 251LF WAS FOUND DELAMINATED. MAINTENANCE REMOVED DAMAGED FLOOR PANEL 251LF; FABRICATED A NEW REPLACEMENT PANEL PER DWG 10D53670022; INSTALLED REPAIR PART IAW T/C R1C25306 AND SRM 53-02-00 PG 2SDR AWXA200300639Floor Panel · delaminatedMCN - MAJOR REPAIR - DURING C-03 CHECK PASSENGER CABIN FLOOR PANEL 251RF WAS FOUND DELAMINATED. MAINTENANCE REMOVED DAMAGED FLOOR PANEL 251RF; FABRICATED A NEW REPLACEMENT PANEL PER DWG 10D53670022; INSTALLED REPAIR PART IAW T/C R1C25306 AND SRM 53-02-00 PG 2SDR GTIA030441Floorboard · debondedFOUND FLOORBOARD, OUTBOARD LEFT AFT, STATION 1250 TO 1361, STIFFENER DISBONDED. INSULATION MISSING AND TORN. REPAIRED FLOORBOARD. (M)SDR GTIA030476Floor Panel · gougedPILOT FLOOR PANEL GOUGE AND BARE METAL. UPON FURTHER INVESTIGATION GOUGE IS A CRACK. FABRICATED PLATE AND DOUBLER. INSTALLED PLATE AND DOUBLER. (M)SDR GTIA030438Floor Panel · delaminatedFOUND FLIGHT COMPARTMENT CENTER FLOOR PANEL AND SUPPORT DAMAGED DELAMINATED. FABRICATED FLOOR PANEL. (M)SDR GTIA030437Floor Panel · delaminatedFOUND FLIGHT COMPARTMENT OBSERVER SEAT FLOOR PANEL DELAMINATED. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA030439Floorboard · delaminatedFOUND CABIN FLOOR PANEL AFT OF R-1 DOOR IS DELAMINATED. FABRICATED NEW CABIN FLOORBOARD. (M)SDR GTIA030348Floorboard · crackedFTW - FLOORBOARD STATION 1174-1294 LBL 44-54 CRACKED AND DELAMINATED IN SEVERAL AREA. REPAIRED FLOORBOARD. (M)SDR GTIA030349Floorboard · crackedFTW - FLOORBOARD STATION 1056-1136 LBL 44-54 CRACKED AND DELAMINATED IN SEVERAL AREAS. REPAIRED FLOORBOARD. (M)SDR GTIA030460Floor Panel · crackedFLIGHT COMPARTMENT, RIGHT FLOOR PANEL CRACKED, BACKSIDE HAS SURFACE CORROSION AND BARE METAL. CUT OUT CRACK IN PANEL, FABRICATED NEW PLATE AND DOUBLER. INSTALLED PLATE AND DOUBLER. (M)
Back to JASC 5321