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 GTIA020340Floorboard · damagedFTW - FOUND FORWARD ENTRY AREA FLOORBOARD FROM STATION 160-200 X48-X55 HAS INSERTS MISSING, BROKEN AND EDGES DAMAGED. FABRICATED NEW FLOORBOARD. (M)SDR GTIA020339Floorboard · damagedFTW - FOUND FORWARD ENTRY AREA, FLOORBOARD FROM STATION 200-260 -X22 TO -X43 HAS INSERTS MISSING, CORNER CRACKED AND EDGES DAMAGED. FABRICATED NEW FLOORBOARD. (M)SDR GTIA020337Floorboard · damagedFTW - FOUND FORWARD ENTRY AREA, FLOORBOARD FROM STATION 180-200 -X7 TO -X43 HAS INSERTS MISSING AND DELAMINATION. FORM NEW FLOOR PANEL. (M)SDR GTIA020336Floorboard · damagedFTW - FORWARD ENTRY AREA, FLOORBOARD FROM STATION 160-200 X6-X6 HAS INSERTS MISSING, BROKEN AND DELAMINATION. FORM NEW PANEL. (M)SDR GTIA020335Floorboard · damagedFTW - FOUND FORWARD ENTRY AREA, FLOORBOARD FROM STATION 160-200 X11 TO X46 HAS MISSING INSERTS, BROKEN INSERTS, EDGES DELAMINATED. FORM NEW PANEL. (M)SDR GTIA020334Floorboard · damagedFTW - FORWARD ENTRY AREA, FLOORBOARD FROM STATION 200-260 X23 TO X44 HAS MISSING INSERTS, BROKEN INSERTS, PUNCTURES AND CORNERS CRACKED. FABRICATED NEW FLOORBOARD. (M)SDR ASAA0280077Floor Panel · corrodedPAE - DURING 30K CHECK, FOUND CORROSION ON FLOOR WEB IN PAX CABIN. INSTALLED NEW WEB PER SRM 53-01 AND 51-30-2. (M)SDR ASAA0280078Floor Panel · corrodedPAE - DURING 30K-CHECK, FOUND CORROSION ON FLOOR WEB AT FS 235-313. INSTALLED NEW WEB PER SRM 51-30-2 AND SRM 52-30-1. (M)SDR ASAA0280079Floor Panel · corrodedPAE - DURING 30K-CHECK, FOUND CORROSION ON FLOOR WEB AT FS 1250-1271. TRIMMED CORRODED AREA AND INSTALLED REPAIR DOUBLER PER SRM 51-70-4 AND SRM 51-30-2. (M)SDR 2002F00450Web · corrodedAT C-CHECK, FOUND AFT PIT SHEAR FLOOR WEB CORRODED AT STATION 1183 RBL 18. (M)SDR DLM88020322Floor Panel · damagedDURING HMV THE 9952521-12, -71, AND -84 FLOOR PANELS WERE FOUND DAMAGED. REPAIR PER ER/A 411064-14.SDR F3LA200200114Floor Panel · corrodedDURING C-2 CHECK, INSPECTION REPORTED AFT CARGO COMPARTMENT FLOOR PANEL NR 3 CORRODED. FABRICATED AND INSTALLED REPLACEMENT FLOOR PANEL PER SRM 51-20-01.SDR F3LA200200113Floor Panel · corrodedDURING C-2 CHECK, INSPECTION REPORTED JOINT BETWEEN PANELS 3 AND 4 IN AFT CARGO COMPARTMENT CORRODED. FABRICATED AND INSTALLED REPAIR PER SRM 53-60-53.SDR F3LA200200104Floor Panel · crackedDURING C-5 CHECK, INSPECTION REPORTED CRACK IN FWD CARGO COMPARTMENT FLOOR PANEL AT STA 490, STR 26R.SDR HEEA078160Floor Panel · separatedFLOOR PANEL SEPARATED BEYOND LIMITS.SDR MWEA020150Floorboard · puncturedFLOORBOARD AT FUSELAGE STATION 288 BETWEEN NR 1 AND 2 SEAT TRACK HAS A SMALL PUNCTURE. FABRICATED AND INSTALLED FLOORBOARD REPAIR.SDR MWEA020145Floorboard · corrodedCORROSION ON CABIN FLOOR BOARD 31 AT STATION 237. FABRICATED AND INSTALLED SLICE REPAIR.SDR MWEA020282Floorboard · damagedCABIN FLOORBOARD B-8 HAS DAMAGE TO THE FORWARD EDGE. FABRICATED AND INSTALLED SKIN AND HAT CHANNELS.SDR F3LA200200074Floor Panel · corrodedDURING C-3 CHECK, INSPECTION REPORTED CORROSION AROUND EDGES OF AFT FLOOR PANEL IN FWD CARGO COMPARTMENT. REMOVED CORROSION AROUND EDGES OF AFT FLOOR PANEL PER SRM 51-10-06. FABRICATED AND INSTALLED REPLACEMENT RETAINER STRAP PER SRM 51-10-01, 51-10-02 AND SSDR DLM88020345Floor Panel · crackedFUSELAGE CABIN FLOOR PANEL WAS FOUND DELAMINATED AND CRACKED. REPAIR PER ER/A 411006-14.SDR MWEA020134Floorboard · crackedFLOORBOARD FUSELAGE STATION 237 TO 313 BETWEEN SEAT TRACK NR 1 AND NR 2 CRACK AT FORWARD END AND CORROSION ON FORWARD EDGE AROUND HOLES. FABRICATED AND INSTALLED FLOORBOARD REPAIR.SDR MWEA020078Floorboard · chafedFLOORBOARD IS CHAFING ON SUBFLOOR AT STATION 218 BETWEEN NR 3 AND 4 SEAT TRACKS. FABRICATED AND INSTALLED REPAIR DOUBLER.SDR MWEA020077Floorboard · chafedFLOORBOARD IS CHAFING ON SUBFLOOR BETWEEN AIRCRAFT CENTER LINE AND NR 2 SEAT TRACK STATION 200 TO 218. FABRICATED AND INSTALLED DOUBLER.SDR P5CA0200645Floorboard · puncturedMAIN DECK L/S FLOOR BOARD PUNCTURE BS 1720 LT SIDE. REPAIRED PER SRM 53-00-50.SDR P5CA0200641Floor Panel · puncturedMAIN DECK, STA 1920/2040 LEFT SIDE FLOOR PANEL DAMAGED (PUNCTURES). REMOVED AND REPLACED PER MM 53-00-50.SDR 2002UALA00204Intercostal · corrodedCABIN FLOOR INTERCOSTAL AT STATION 332 RBL 25" TO 39" STRINGER 1 7R CORRODED ON UPPER SURFACE. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW INTERCOSTAL U-CHANNEL.SDR 2002UALA00203Intercostal · corrodedCABIN FLOOR INTERCOSTAL AT STATION 332 RBL 4" TO 22" CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW U-CHANNEL.SDR RAIA00201042Support BracketMX-STL- DURING BLOCK CHECK FOUND MODERATE CORROSION AT FORWARD CENTER FLOOR BOARD ANGLE SUPPORT. REMOVED AND REPLACED ANGLE SUPPORT CENTER FLOOR BEAM IAW SRM 51-40-02.SDR 2002UALA00140Pressure Panel · corrodedSTATION 1680 PRESSURE DECK UPPER SURFACE AT FORWARD EDGE HAS CORROSION BEYOND LIMIT 0 TO 24 LBL AT STRINGER 17 LT. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE. INSTALLED DOUBLER.SDR RAIA00201044SillMX-STL- DURING BLOCK CHECK FOUND MODERATE CORROSION ON FLOOR SUPPORTS AFT OF PAX DOOR. REMOVED AND REPLACED LEFT SILL AFT OF PAX DOOR, IAW SRM 51-40-02.SDR GTIA020192Floorboard · delaminatedFTW - PAX CABIN FLOORBOARDS TWO DELAMINATED AT AFT GALLEY SERVICE DOOR THRESHOLD. REMOVED DELAMINATED FLOORBOARDS. REPAIRED PAX CABIN FLOORBOARDS. INSTALLED FLOORBOARDS AT AFT GALLEY SERVICE DOOR THRESHOLD. (M)SDR F3LA200100148Floor Panel · crackedDURING C-7 CHECK, INSPECTION REPORTED FLOORBEAM PANEL CRACKED AND CORRODED ABOVE STRINGER 25-R AT STA 787. FABRICATED AND INSTALLED REPLACEMENT PANEL PER BOEING DRAWING 69-43477 AND SRM 51-10-2 AND 51-30-2.SDR C2XA01TY210DoublerTYS DURING A SCHEDULED 1-C INSPECTION CORROSION WAS FOUND ON DOUBLER AT FRM. 20 ON THE RIGHT SIDE.MAINTENANCE REMOVED THE CORROSION IAW 135/145 CPM 51-14-02 APPLIED ALLODINE ,PRIME AND PAINTED IAW EMB. 135/145 CPM 51-21-04,05,06. THE WORK WAS ACCOMPLISHED AND SDR GTIA020205Floorboard · brokenFTW - FOUND COCKPIT CENTER FLOORBOARD BROKEN OUT AND CRUSHED AND TORN AT EDGES. FORMED NEW FLOORBOARDS IAW MD80 MM 20-10-19. (M)SDR GTIA020202Floorboard · chafedFTW - FOUND FLOORBOARD PANEL NR A-10 HAT CHANNEL CHAFED, DENTS IN SKIN AND NEEDS CLEANING. FABRICATED DOUBLER. GOUGE IS OUT OF LIMITS ON HAT CHANNEL NR 2. FABRICATED NR 2 HAT CHANNEL DOUBLER. INSTALLED REPAIR DOUBLER. INSTALLED HAT NR 2 REPAIR DOUBLER IAWSDR GTIA020201Floor Panel · puncturedFTW - FOUND COCKPIT FLOOR PANEL HAS HOLE PUNCHED IN SKIN. HOLE AND CRACK IN FLOORBOARD OUT OF LIMITS. FABRICATED REPAIR DOUBLER. INSTALL DOUBLER IAW DC9 MD80 SRM 51-30-1. (M)SDR GTIA020180Floorboard · damagedFTW - FOUND CENTER FLOORBOARD IN CABIN FROM STATION 250-313 IS SPONGY. REMOVED FLOOR PANEL. FABRICATED FLOOR PANEL. INSTALLED PASSENGER CENTER FLOOR BOARD PANEL ROM STATION 250-313 IAW MD80 MM 53-20-1. (M)SDR GTIA020179Floorboard · damagedFTW - FOUND CABIN CENTER FLOORBOARD FROM STATION 200-250 IS SPONGY. REMOVED FLOOR PANEL STATION 200-250. FORMED NEW FLOOR PANEL. INSTALLED PAX CENTER FLOOR PANEL FROM STATION 200-250 IAW MD80 M 53-20-01. (M)SDR GTIA020148Floorboard · damagedFTW - FORWARD ENTRY WAY FLOORBOARDS FS 160 TO FS 195 PLUS X8 INCH TO PLUS 57 INCHES, AND FLOORBOARDS FS 195 TO FS 235 -X22 INCH TO PLUS X57 INCHES HAS BLUE WATER STAINS AND ARE SPONGY. REMOVED 2 FLOORBOARD FS 195-256 LEFT 22-56. FABRICATED TWO FLOORBOARDS FSSDR 2001UALA02415Floor Panel · corrodedAFT CABIN FLOOR DECK HAS 5 LOCATIONS OF EXCESSIVE MATERIAL REMOVED RBL 5, RBL 12, RBL 45, RBL 48, RBL 52, AT STATION 1682. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIRS.SDR GTIA020160Insert · corrodedFTW - FOUND PAX CABIN ENTRY WAY, UNDER LEFT FORWARD LAVATORY, FLOORBOARD HAS 4 CORRODED INSERTS. REMOVED FLOOR PANEL. FORMED FLOOR PANEL. (M)SDR ASOA01282Floorboard · corrodedDURING C-CHECK INSPECTION IN BNA, THE FLOORBOARD SCREW HOLES AT FRAMES 9 AND 10 SHOWED SIGNS OF CORROSION AND SEVERAL ELONGATED HOLES WERE FOUND. MAINTENANCE REMOVED CORROSION AND REPAIRED ELONGATED HOLES WERE FOUND. MAINTENANCE REMOVED CORROSION AND REPAIRESDR ASOA01281Floorboard · corrodedDURING C-CHECK INSPECTION IN BNA, THE TOP AND BOTTOM SURFACES OF THE FLOORBOARDS TOP FLANGE WERE FOUND TO BE CORRODED AT FRAMES 36, 38, 39, AND 40. MAINTENANCE REPAIRED CORROSION IAW WITH ASA EO72-53-0123. THIS EO REFERENCE FAA FORM 8110-3, REPORT NR 01-295,SDR DL73K011915Web · crackedCRACKS WERE FOUND IN THE WEBS OF THE RBL AND LBL 24 FLOOR BEAMS AT F.S. 680. THE CRACKS WERE CUT OUT AND A DOUBLER INSTALLED PER ERA 398177-14AD. THE DAMAGE WAS FOUND AT HMV.SDR GTIA012122Channel · crackedFTW - FOUND FORWARD ENTRY FLOOR PANEL HAT CHANNEL HAS CRACKED. REMOVED CRACKED CHANNEL. FABRICATED CHANNEL. INSTALLED CHANNEL IAW DC9 SRM 51-30-2. (M)SDR GTIA012187Floorboard · damagedFTW - CO-PILOT FLOORBOARD DAMAGED AT UPPER FACE. PUNCTURE AT STATION Y=150. REMOVED DAMAGED AREA. FABRICATED DOUBLER. INSTALLED REPAIR DOUBLER PER DC9 SRM 51-30-2. (M)SDR GTIA012174Floorboard · damagedFTW - FOUND FLOORBOARD WEB HAS HOLE Y211-X27. REMOVED DAMAGE. FABRICATED REPAIR PARTS FILLER AND DOUBLER. INSTALLED PER DC9 SRM 53-01. (M)SDR GTIA012198Floorboard · damagedFTW - FOUND RIGHT INBOARD FLOORBOARD STATION 237-313 GOUGED, HOLES ELONGATED, SURFACE CORROSION. FABRICATED DOUBLER. INSTALLED DOUBLER IAW DC9 SRM 51-30-2. (M)SDR GTIA012260Floorboard · damagedFTW - FOUND RIGHT INBOARD FLOORBOARD STATION 756-832 HAS SURFACE CORROSION, HOLES OVERSIZED AND COUNTERSINKS BROKEN OUT. FORMED PATH SHAPE FOR BROKEN OUT OVERSIZED HOLES PER DC9 SRM 55-01. (M)SDR GTIA012256Floorboard · damagedFTW - FOUND LEFT, OUTBOARD FLOORBOARD STATION 465-579 COUNTERSINKS BROKEN OUT AND SURFACE CORROSION. STOPPED DRILL CRACKED. FORMED DOUBLER REPAIR. INSTALLED DOUBLER. REMOVED SURFACE CORROSION IAW DC9 SRM 53-01. (M)
Back to JASC 5321