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 AT0200077Floorboard · corrodedCPCP, METALLIC FLOORBOARDS AND HONEYCOMB STRUCTURE INSPECTION. LEVEL 2 CORROSION FINDINGS.SDR SIMA200222108Floorboard · corrodedTHIS IS A LEVEL TWO FINDING ON CRIC NR 23858. GALLEY AREA FLOORBOARD EXTENSIONS HAVE CORROSION. GALLEY AREA FLOORBOARD EXTENSIONS HAVE CORROSION. REMOVED AND INSTALLED EXTENSION IAW SRM.SDR AAL2002F00003Floor Panel · corrodedFLOOR MEMBRANE, 2 INCH X 4 INCH ON FLOOR MEMBRANE BELOW BRACKET AT RBL 11 STA 160 IS CORRODED AND CRACKED AT FASTENERS HOLES. INSTALLED DOUBLER PER AARD. (2002-1114/ AMC4)SDR UPS02839142Floor Panel · delaminatedINSPECTION TYPE:C1 FLOOR PANEL STA 759-879 PANEL A DELAMINATED. FABBED NEW PANEL IAW UPS EO DC8 5320-9691C.SDR MWEA020460Floor Panel · deterioratedCABIN FLOOR IN FRONT OF FWD LAV SEEMS SOFT. FABRICATED AND INSTALLED FLOOR PANEL.SDR MALA020415Floor Panel · corrodedDURING 4K-CHECK IN CWA, LT FLIGHT DECK FLOOR HAS CORROSION ON THE FLOOR AND RIVET HEADS. MAINTENANCE PERFORMED REPAIRS AND REMOVED CORROSION IAW SRM 51-70-40 AND 53-60-50-2. REMOVED CORRODED RIVETS IAW 51-40-21. REFER TO 409# 109814. RELEASE DATE 7/17/02.SDR GTIA020840Floorboard · corrodedFTW - AFT CARGO FLOORBOARD STATION 1212-1234 SURFACE CORROSION, GOUGES, DRILL STARTS AND ELONGATED HOLES. REMOVED CORROSION GOUGES, MATERIAL OUT OF LIMITS. FORMED NEW FLOORBOARD. (M)SDR MALA020413Floor Panel · corrodedDURING 4K-CHECK IN CWA, RT FLIGHT DECK FLOOR HAS CORROSION. MAINTENANCE REPAIRED CORROSION AROUND FLOOR "SNAP" FASTENERS IAW SAAB SRM 53-60-50 AND SAAB STATEMENT 340SDS004125. REFER TO 409 109815SDR MALA020379Floor Panel · corrodedPITTING CORROSION LOCATED ON THE FLOOR, LT SIDE OF CAPTAINS CONTROL COLUMN STA 177 TO STA 185. REMOVED AND REPAIRED DECK FLOOR IAW 177-185 EO S53124.SDR MALA020378Floor Panel · corrodedFLIGHT DECK FLOOR HAS LIGHT CORROSION. REMOVED AND TREATED IAW SRM 51-70-40.SDR GTIA020838Floorboard · corrodedFTW - FOUND COCKPIT FLOORBOARD STATION 120-160 CENTER CORRODED AND MISSING INSERTS. FABRICATED NEW PANEL. (M)SDR AALA20021030Floorboard · corrodedTUL - FOUND AFT EDGE OF FLOORBOARD CORRODED UNDER F/O'S SEAT. REPLACED FLOORBOARD TOP SKIN SHEET AND INSTALLED FLOORBOARD PER SRM 51-01. (M)SDR CA020624003Floorboard · cracked(CAN) THE ENTRANCE FLOOR PANEL WAS FOUND CRACKED AT STATION 278.5. PANEL REPLACED AND NO FURTHER DAMAGE REPORTEDSDR 02FDEA00412Floor Panel · corrodedN 540, 542, 544, 547, 551 CORROSION ON MAIN CABIN FLOOR PANELS. REMOVED AND REPLACED PANELS.SDR GTIA020697Floorboard · damagedFTW - FOUND CABIN FLOORBOARD STATION 200-256 LEFT FOUR BROKEN INSERTS AND CORE BROKEN. FABRICATED A NEW FLOORBOARD STATION 200-256, LEFT. (M)SDR GTIA020602Floor Panel · crackedFTW - FOUND AFT FUSELAGE BESIDE RIGHT AIRSTAIR ACTUATOR, FLOOR PANEL CRACKED. REMOVED CRACKED FLOOR PANEL RIGHT SIDE AIRSTAIR. FABRICATED REPAIR. INSTALLED FABRICATED PARTS ON THE REMOVED PANEL. (M)SDR GTIA020533Floorboard · corrodedFTW - FLOORBOARD STATION 200-236 LEFT HAS CORROSION ON INSERTS. FABRICATED NEW FLOOR PANEL STATION 200-236. (M)SDR CA020529002Pressure Panel · cracked(CAN) DURING THE FLEET LEADER STRUCTURAL INSPECTION, THE INSPECTION REVEALED FOUR CRACKS TO THE PRESSURE FLOOR AT FS 460.00, RBL 9.00 TO CENTER LINE AND LBL 9.00 TO CENTER LINE. AIRCARFT IS REPAIR PER REO 601R-53-41-090SDR C1HA200292026Floor Panel · corrodedCENTER FLOOR WEB STA 1148 - 1176 HAS CORROSION TOP AND BOTTOMSDR MWEA020373Floorboard · puncturedFLOORBOARD BETWEEN TRACKS 1 AND 2 JUST AFT OF LEFT FORWARD COAT CLOSET. FABRICATED AND INSTALLED REPAIR DOUBLER AND CORE PLUG.SDR MWEA020364Floorboard · delaminatedFLOORBOARD FROM STATION 148 TO STATION 160 RIGHT BUTT LINE 30 TO RIGHT BUTT LINE 45 REMOVED DUE TO DELAMINATION. -- FABRICATED AND INSTALLED FLOORBOARD.SDR MWEA020363Floor Panel · delaminatedFLOOR PANEL FROM STATION 160 TO STATION 200, LEFT BUTT LINE 6 TO RIGHT BUTT LINE 6, IS DELAMINATED ALONG ITS FORWARD EDGE. -- FABRICATED AND INSTALLED FLOOR PANEL.SDR MWEA020361Floorboard · delaminatedFORWARD GALLEY FLOOR BAORD DELAMINATED, STATION 180-200. -- FABRICATED AND INSTALLED FLOOR BOARD.SDR MWEA020359Floor Panel · crackedFLOOR PANEL CRACKED, STATION 916, NEXT TO #1 SEAT TRACK. -- FABRICATED AND INSTALLED DOUBLER.SDR MWEA020356Floor Panel · puncturedFLOOR PANEL PUNCTURED, STATION 701, NEXT TO #1 SEAT TRACK. -- FABRICATED AND INSTALLED FILLER AND DOUBLER.SDR MWEA020355Floor Panel · crackedFLOOR PANEL CRACKED, STATION 708, NEXT TO #SEAT TRACK. -- FABRICATED AND INSTALLED FILLER AND DOUBLER.SDR MWEA020354Floor Panel · crackedFLOOR PANEL CRACKED, STATION 870, NEXT TO #1 SEAT TRACK. -- FABRICATED AND INSTALLED FILLER AND DOUBLER.SDR MWEA020353Floor Panel · puncturedCABIN FLOOR PANEL PUNCTURED, STATION 864, BETWEEN #3 AND #4 SEAT TRACKS. -- FABRICATED AND INSTALLED FLOOR BOARD.SDR MWEA020352Floor Panel · corrodedCABIN FLOOR PANEL HEAVILY CORRODED, STATION 256, OUTBOARD OF #4 SEAT TRACK. -- FABRICATED AND INSTALLED DOUBLER AND FILLER.SDR MWEA020350Floor Panel · crackedFLIGHT DECK FLOOR PANEL HAS A SMALL CRACK LOCATED BETWEEN PILOT'S AFT SEAT TRACKS AND 3 INCHES FORWARD OF EPC PANEL. REMOVED DAMAGED AREA. LOCATED AND DRILLED DOUBLER AND FAIRING PLATE. INSTALLED DOUBLER AND FAIRING PLATE.SDR MWEA020349Floorboard · puncturedRIGHT OUTBOARD AT STATION 315 HAS A PUNCTURE IN MIDDLE OF FLOORBOARD. REPAIRED MIDDLE OF FLOORBOARD IAW SRM 53-05 FIGURE 3, TINNERMAN SPEED NUT WASHER ASSEMBLY INSTALLATION.SDR MWEA020348Floorboard · puncturedLEFT MID FLOORBOARD AT STATION 430 HAS A PUNCTURE AT INBOARD SIDE AND DELAMINATION ON FORWARD END. FABRICATED AND INSTALLED FLOORBOARD.SDR MWEA020347Floorboard · puncturedRIGHT INBOARD FLOORBOARD AT STATION 320 HAS PUNCTURE AT FORWARD INBOARD SIDE. -- FABRICATED AND INSTALLED CORE PLUG AND DOUBLER REPAIR.SDR MWEA020346Floorboard · puncturedRIGHT OUTBOARD FLOORBOARD AT STATION 315 HAS PUNCTURE ON INBOARD FORWARD END. FABRICATED AND INSTALLED DOUBLER AND FILLER.SDR MWEA020345Floor Panel · crackedLEFT OUTBOARD FLOOR PANEL CRACKED ON INBOARD EDGE AT STATION 804. -- FABRICATED AND INSTALLED FILLER AND DOUBLER.SDR MWEA020344Floorboard · delaminatedRIGHT FLOORBOARD PANEL DELAMINATED, STATION 200-256, OUTBOARD OF #3 SEAT TRACK. -- FABRICATED AND INSTALLED NEW FLOORBOARD.SDR MWEA020343Floorboard · delaminatedFORWARD GALLEY DOOR FLOORBOARD DELAMINATED, STATION 161-200. -- FABRICATED AND INSTALLED FLOORBOARD.SDR MWEA020335Floor Panel · damagedFLOOR PANEL, FORWARD OUTBOARD CORNER DAMAGED, STATION 927, NEXT TO #1 SEAT TRACK. -- FABRICATED AND INSTALLED FLOORBOARD.SDR MWEA020334Floorboard · damagedCENTER AISLE FLOORBAORD AT APPROXIMATELY STATION 700 IS DAMAGED AT THE FORWARD LEFT. -- FABRICATED AND INSTALLED FLOORBOARD.SDR MWEA020333Floorboard · corrodedFLOOR BOARD HEAVILY CORRODED, AS SEEN FROM FORWARD CARGO BAY STATION 256 JUST AFT OF CABIN FLOOR BEAM, RIGHT TUNNEL. -- FABRICATED AND INSTALLED FLOORBOARD.SDR GTIA020542Floorboard · crackedFTW - FOUND FLOOR PANEL STATION 1308 TO STATION 1278 HAS MUSHY SOFT/CRACKED AROUND THE EDGE. FORMED NEW PANEL. (M)SDR GTIA020541Floorboard · damagedFTW - FOUND FLOORBOARD STATION 1750 TO STATION 1270 LEFT SIDE HAS SOFT/DAMAGE ALL CORNERS. FABRICATED FLOORBOARD. (M)SDR GTIA020540Floorboard · damagedFTW - FOUND FLOORBOARD STATION 1174 TO STATION 1250 HAS MUSHY SOFT. FABRICATED NEW FLOORBOARD. (M)SDR GTIA020539Floorboard · delaminatedFTW - FOUND FLOORBOARD STATION 1003 TO 1079 HAS DELAMINATED DAMAGE AT CORNER. FABRICATED NEW PAX CABIN FLOORBOARD STATION 1003-1079. (M)SDR GTIA020538Floorboard · damagedFTW - FOUND FLOORBOARD STATION 1174 TO 1117 IS MUSHEY/SOFT. FABRICATED FLOOR PANEL. (M)SDR GTIA020534Floorboard · debondedFTW - FOUND FLOORBOARD STATION 200-250 FORWARD LAV CHANNELS DEBONDED. REPAIRED FLOORBOARD OF FORWARD LAVATORY AT STATION 200-250. (M)SDR GTIA020669Floor Panel · corrodedFTW - FOUND FLOOR PANEL NR 15 RIGHT SIDE STATION 120 TO STATION 160 HAS CORROSION ATTACHING PANEL PAD. MATERIAL LOSS FOUND TO BE OUT OF LIMITS. REMOVED DAMAGED PADS. INSTALLED PAD IAW MD80 SRM 51-20-00. (M)SDR GTIA020537Floorboard · damagedFTW - FOUND COCKPIT FLOORBOARD STATION 150-160 LEFT HAS CORROSION ON INSERT, EDGES BROKEN OUT AND TORN. FABRICATED NEW PANEL. (M)SDR GTIA020536Floorboard · corrodedFTW - FOUND FLOORBOARD STATION 150-160 HAS CORROSION ON INSERTS. FABRICATED NEW PANEL. (M)SDR GTIA020535Floorboard · corrodedFTW - FOUND FLOORBOARD STATION 180-200 INSERTS MISSING AND HAS CORROSION. FABRICATED FLOORBOARD. (M)
Back to JASC 5321