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 AWXA200400744Floor Panel · delaminatedDURING B-04 CHECK FOUND FLOOR PANEL 262BG MISSING AN INSERT WITH DELAMINATION TO BOTTOM OF LAMINATE. MAINTENANCE REPLACED INSERT AND PERFORMED BOND REPAIR TO BOTTOM LAMINATE OF FLOOR PANEL 262BG IAW SRM 53-02-00, FIG. 201.SDR AWXA200400746Floor Panel · crackedMAJOR REPAIR, DURING B-04 CHECK FOUND 2 EACH 1INCH CRACKS IN FLOOR PANEL 221EF. MAINTENANCE CUTOUT DAMAGE IN FLOOR PANEL 221EF, AND PERFORMED BOND REPAIR IAW A319 SRM 53-02-00, FIG. 202.SDR AWXA200400745Floor Panel · corrodedDURING B-04 CHECK FOUND CORROSION ON AFT SIDE CORNER OF FLOOR PANEL 261FF FROM FR 66 TO FR 68, AND Y1292 LT TO 1732 LT. MAINTENANCE REMOVED AND REPLACED FLOOR PANEL 261FF IAW AWA T/C C1D25310.SDR GTIA040652Floorboard · damagedFTW - FOUND MAIN CABIN STATION 1117 TO 1174 CENTER FLOOR PANEL HAVE SOFT/MUSHEY AND DAMAGE ON EDGE. FABRICATED CABIN FLOORBOARD. (M)SDR GTIA040653Floor Panel · crackedFTW - FOUND MAIN CABIN STATION 806 TO STATION 826, FLOOR PANEL ONE INSERT DAMAGE/CRACKS ON EDGES. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040651Floor Panel · crackedFTW - FOUND MAIN CABIN RIGHT INBOARD FLOOR PANEL STATION 1250-1309 HAVE CRACKS, DAMAGE ON EDGES/SEVERAL INSERTS HAVE PULLED THROUGH. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040655Floorboard · brokenFOUND FLOORBOARD BROKEN STATION 200-260 LBL 24-31. FABRICATED FLOORBOARD. (M)SDR GTIA040654Floorboard · brokenFTW - FOUND FLOORBOARD FASTENER INSERTS MISSING, TWO EACH STATION 200-260 LBL 24-25. UPON FURTHER INVESTIGATION FLOORBOARD PANEL FOUND TO BE BROKEN. FABRICATED FLOORBOARD. (M)SDR 04FDEA01773Floor Support · corrodedMAIN CARGO DECK RT STA 1821 BETWEEN SEAT TRACK REF X=102.5 AND X=75.25 FLOOR SUPPORT HAS EVIDENCE OF CORROSION. REMOVED AND REPLACED AS PER SRM 51-35-01 VOL II.SDR GTIA040605Floor Panel · corrodedFTW - FOUND CENTER CABIN FLOOR PANEL STATION 1309-1338 RUSTED INSERTS. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040604Floor Panel · brokenFTW - FOUND LEFT CABIN FLOOR PANEL STATION 200-257 BROKEN INSERTS. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040607Floor Panel · corrodedFTW - FOUND CENTER CABIN FLOOR PANEL STATION 1174-1287 CORRODED INSERTS. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040606Floor Panel · brokenFTW - FOUND CENTER CABIN FLOOR PANEL STATION 1287-1309 BROKEN EDGES. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040615Floor Panel · brokenFTW - FOUND LEFT CABIN FLOOR PANEL STATION 1174-1287 MISSING INSERTS BROKEN EDGES. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040603Floor Panel · damagedFTW - FOUND CENTER CABIN FLOOR PANEL STATION 693-769 MISSING INSERTS. FABRICATED NEW FLOOR BOARD PANEL. (M)SDR GTIA040602Floor Panel · damagedFTW - FOUND CENTER CABIN FLOOR PANEL STATION 617-693 MISSING INSERTS. FABRICATED NEW CENTER CABIN FLOOR PANEL. (M)SDR SWAA041680Floor Panel · crackedDURING SCHEDULED D-CHECK, FOUND FLOOR WEB AT RIGHT BS 188 TO RIGHT BS 196, WL 208, CRACKED. REMOVED AND REPLACED FLOOR WEB SECTION PER SRM.SDR IXXA060332SFloor Panel · crackedDURING ROUTINE C CHECK, FOUND FORWARD CARGO COMPARTMENT FLOOR PANEL CRACKED FROM STATION Y480 TO Y500. REPAIRED PER ALL APPLICABLE DATA.SDR GTIA050616Floor Panel · damagedFTW - FOUND COCKPIT FLOOR PANEL CENTER FS 120-148 IS DAMAGED SEVERAL PLACES. FABRICATED NEW FLOOR PANEL. (M)SDR IXXA060255SFloor Panel · corrodedDURING ROUTINE C CHECK FOUND FLOOR PANEL CORRODED BETWEEN STATIONS Y1542 AND Y1580 AT -X40 AND +X40. REPLACED FLOOR PANEL PER ALL APPLICABLE DATA.SDR IXXA060254SFloor Panel · corrodedDURING ROUTINE C CHECK FOUND FLOOR PANEL CORRODED AND LOOSE FASTENERS BETWEEN STATION Y1520 AND Y1542 AND BETWEEN -X40 AND +X40. REPLACED FLOOR PANEL PER ALL APPLICABLE DATA.SDR IXXA060253SFloor Panel · corrodedDURING ROUTINE C CHECK FOUND FLOOR PANEL CORRODED, WITH LOOSE RIVETS AND A DOUBLE HOLE. REPLACED FLOOR PANEL PER ALL APPLICABLE DATA.SDR GTIA040619Floor Panel · brokenFOUND CENTER CABIN FLOOR PANEL STATION 552-560 BROKEN EDGES. FABRICATED NEW PANEL. (M)SDR GTIA040594Floor Panel · debondedFOUND CABIN FLOOR PANEL STATOIN 256-313 HAT CHANNEL DISBONDED. REPAIRED DISBONDING HAT CHANNELS. (M)SDR GTIA040593Floor Panel · delaminatedFTW - FOUND LEFT CABIN FLOOR PANEL STATION 200-256 MISSING INSERTS AND DELAMINATED. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040614Floor Panel · delaminatedFTW - FOUND CABIN FLOOR PANEL STATION 168-200 MISSING INSERT AND DELAMINATED. FABRICATED FLOOR PANEL. (M)SDR USA2004F00090Floor Panel · corrodedFOUND CORROSION THROUGH MAIN FLOOR DECK PANEL, 2 INCH X 2 INCH X .040 INCH. REPLACED PANEL.SDR USAA040311Floor Panel · delaminatedFLOOR PANEL, EXCEEDS 10 PERCENT OF TOTAL AREA, DELAMINATION, MAIN DECK PANEL 221 PF. FABRICATED NEW FLOOR PANEL IAW SRM.SDR USAA040310Floor Panel · delaminatedFLOOR PANEL, 10 PERCENT OF TOTAL AREA, MAIN DECK FLOOR PANEL 262HG, DELAMINATION. FABRICATED NEW PANEL IAW SRM.SDR USAA040309Floor Panel · delaminatedFLOOR PANEL, 10 PERCENT OF TOTAL AREA, DELAMINATION, MAIN DECK, PANEL 262EF. FABRICATED NEW FLOOR PANEL 262 EF.SDR USAA040308Floor Panel · delaminatedFLOOR PANEL, 10 PERCENT OF TOTAL AREA, DELAMINATION, MAIN DECK, FLOOR PANEL 261DF. FABRICATED NEW FLOOR PANEL IAW SRM.SDR USAA040284Floor Panel · delaminatedFLOOR PANEL, GREATER THAN 10 PERCENT OF AREA, DELAMINATION, MAIN DELAMINATION, MAIN DECK FLOOR PANEL, 221PF. FABRICATED NEW PANEL IAW SRM.SDR 2004UALA00561Floor Panel · crackedFLOOR WEB APPROX 1 INCH AFT OF BS 199.9 AND HALF INCH INBOARD FROM FUSELAGE SKIN ON RIGHT SIDE CRACKS EMANATING FROM FASTENER BUCK TAIL. FABRICATED & INSTALLED WEB REPAIR.SDR USAA040283Floor Panel · delaminatedBFM - FOUND FLOOR PANEL DELAMINATED MORE THAN 10 PERCENT MAIN DECK FLOOR PANEL, 231 CF. FABRICATED NEW PANEL PER SRM 53-02-00, FIG 209. (M)SDR AWXA200400625Floor Panel · delaminatedMCN - MAJOR REPAIR - DURING C-04 CHECK FOUND THE AFT GALLEY FLOOR PANEL 261EF DELAMINATED. MAINTENANCE REMOVED DELAMINATED FLOOR PANEL 261EF FROM FR 66 TO FR 68, Y1292 LT TO Y1732 LT. FABRICATED AND INSTALLED NEW REPLACEMENT FLOOR PANEL IAW DWG 10D53670049.SDR AALA20040682Roller Tray · corrodedTUL - CORROSION ON LEFT FLOORBOARD FLANGE OF NUMBER 4 ROLLER TRAY BETWEEN FRAME 60 AND 61. AREA OF CORROSION IS 1 INCH BY 2 INCHES WITH A DEPTH OF .050. BLENDED OUT CORROSION PER SRM 51-74-0 AND INSTALLED REPAIR STRAP PER 53-30-00-1.SDR UPS04142589Floorboard · crackedINSPECTION TYPE: C2, AFT PIT FLOOR PNL 151CF CRACKED IN 3 PLACES. FABRICATE NEW FLOORBOARD IAW EO A300-5320-16407-A.SDR GTIA040586Floorboard · crackedFTW - FOUND FLIGHT COMPARTMENT CENTER FLOOR PANEL STATION 148 TO STATION 160 HAS SEVERAL CRACKS ON EDGES AND CORRODED AT INSERTS. FABRICATED NEW FLOORBOARD. (M)SDR ASAA0480459Floorboard · delaminatedOKC - DURING C-CHECK, FOUND FLOOR PANEL DELAMINATED AT CLASS DIVIDERS. REBONDED PANELS PER MM 25-00-00. (M)SDR ASAA0480458Floor Panel · delaminatedOKC - DURING C-CHECK, FOUND FLOOR PANEL DELAMINATED AT ROWS 20 AND 21. REBONDED PANELS PER MM 25-00-00. (M)SDR ASAA0480457Floor Panel · delaminatedOKC - DURING C-CHECK, FOUND FLOOR PANEL DELAMINATED AT G-3 AND G-4 GALLEYS. REBONDED PANELS PER MM 25-00-00. (M)SDR ASAA0480456Floor Panel · delaminatedOKC - FOUND DURING C-CHECK, FLOOR PANEL DELAMINATED AT CABIN ROW 11. REBONDED PANEL PER MM 25-00-00. (M)SDR GTIA040588Floorboard · damagedFTW - FOUND CENTER CABIN FLOORBOARD STATION FS 200-256 INSERTS PULLED THROUGH. FABRICATED FLOORBOARD. (M)SDR GTIA040587Floor Panel · crackedFTW - FOUND FLOOR PANEL LEFT OUTBOARD STATION 1097-1155 CRACKED. REPAIRED FLOOR PANEL. (M)SDR GTIA040528Floor Panel · delaminatedFLOOR PANEL LT IB STA 200-260 DELAMINATED EDGE. FAB NEW FLOOR PANEL.SDR GTIA040527Floorboard · delaminatedPAX CABIN FLOOR PANEL STA 1155-1250 DELAMINATED. FAB NEW CABIN.SDR GTIA040548Floor Panel · crackedLT FLOORBOARD STA 927-1003 CORNERS CRACKED. FABED NEW FLOOR PANEL.SDR ASAA0480414Floor Panel · corrodedOKC - DURING HV CHECK, FOUND FORWARD CABIN FLOOR MEMBER AT STATION 200, RBL 8 - LBL 8 IS CORRODED. REMOVED DAMAGE AND INSTALLED REPAIR SPLICE IAW 51-10-4. (M)SDR ASAA0480416Floor Panel · puncturedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL BELOW FIRST OFFICERS SEAT IS PUNCTURED. REMOVED DAMAGED SKIN AND INSTALLED REPAIR DOUBLER IAW 53-01. (M)SDR ASAA0480418Floor Panel · corrodedOKC - DURING HV-CHECK, FOUND FLOOR WEB AT STATION 200, RBL 22 IS CORRODED. REMOVED DAMAGE AND INSTALLED REPAIR DOUBLER IAW 51-70-4. (M)
Back to JASC 5321