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 MWEA001300Floor Panel · gougedGOUGE ON CABIN FLOOR PANEL B-9 ALSO A CRACK AROUND FASTENER HOLE AND BARE METAL. -- FABRICATED AND INSTALLED REPAIR SKIN, DOUBLER, AND FASTENERS.SDR MWEA001299Floor Panel · crackedCRACKS AROUND FASTENER HOLE ON CABIN FLOOR PANEL A-4 ALSO MISSING HALF OF CHAFF STRIP AND BARE METAL. -- FABRICATED AND INSTALLED SKIN REPAIR AND FASTENERS.SDR MWEA001298Floor Panel · damagedSEVERAL FIGURE EIGHT FASTENER HOLES ON CABIN FLOOR PANEL A-2 ALSO AREAS OF CORROSION AND BARE METAL. -- FABRICATED AND INSTALLED REPAIR SKIN AND SPLICE DOUBLER.SDR MWEA001297Floor Panel · crackedCABIN FLOOR PANEL E-13 IS CRACKED AND DENTED. -- FABRICATED AND INSTALLED REPAIR DOUBLER.SDR MWEA001276Floor Panel · corrodedCRACKED FLOOR PANEL ALSO CORROSION AND BARE METAL F-4. -- FABRICATED AND INSTALLED FLOOR BOARD SKIN.SDR RAIA0012079Floor Panel · corrodedMX-STL-DURING MAINTENANCE CHECK FOUND COCKPIT RIGHT HAND FLOOR PANEL 212FF HAS CORROSION. MAINTENANCE REMOVED AND REPLACED FLOOR PANEL IAW ATR42 MAINTENANCE MANUAL.SDR RAIA0012078Floor Panel · corrodedMX-SYL-DURING MAINTENANCE CHECK FOUND COCKPIT FLOOR PANEL 211FF WAS CORRODED. MAINTENANCE REPAIRED FLOOR PANEL IAW ATR42 SRM.SDR AWXA0001126Web · crackedFLOOR WEB CRACKED FS 180 WL 207 LBL 26 (1.0L). REMOVED DAMAGED WEB; FABED NEW WEB; INSTALLED WEB IAW SRM 51-40-02 DWG 65-45833SDR AWXA0001122Web · crackedFLOOR WEB CRACKED FS 180 WL 207 RBL 26 (1.0L). REMOVED DMGD WEB IAW SRM 51-40-02; FABED REPLACEMENT WEB IAW DWG 65-45833; INSTALLED IAW 51-40-02SDR CALA0001928Floor Panel · bentINSPECTION FOUND CABIN RT O/B FLOOR PANEL BENT AT FS 465-541 AND AT FS 541-617. REPAIR DOUBLERS WERE INSTALLED AT EACH LOCATION IAW SRM 53-24-0, 53-01, 51-30-2, 51-30-3, AND 51-30-4.SDR DHL200080229CFloor Panel · crackedAT C CHECK; NR 9 TRANSFERENCE FLOOR LWR SKIN CRACKED AND UPPER SKIN BROKEN. PERFROMED STOP DRILL IAW SRM 53-2-3, FIG 5, CLEANED,TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, FABRICATED AND INSTALLED DOUBLERS IAW SRM 53-2-3 FIG 5. REF: N/R 0854.SDR RRXA003509Floor Panel · damagedDURING A MAINTENANCE VISIT FOUND TORN OUT SCREW HOLES ON THE COCKPIT FLOOR PANEL BETWEEN PILOT & CO-PILOTS SEAT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM.SDR RRXA003517Floor Panel · crackedDURING A MAINTENANCE VISIT FOUND A CRACK AND TORN OUT SCREW HOLES ON THE COCKPIT FLOOR PANEL PILOTS SEAT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM.SDR RRXA003516Floor Panel · crackedDURING A MAINTENANCE VISIT FOUND A CRACK TO THE FLOOR PANEL 678, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM.SDR MALA000807Splice · corrodedFOUND DURING C-CHECK, FLOOR PANEL SPLICE FOR PANEL 122DZ HAS CORROSION. REFER TO CELSIUS W/O 19120, TASK 1516. MAINTENANCE REMOVED CORROSION ON SPLICE PANEL. REMAINING MATERIAL WITHIN LIMITS. ALODINED, PRIMED AND TOPCOATED SPLICE PLATE.SDR MALA000806Splice · corrodedFOUND DURING C-CHECK, FLOOR PANEL SPLICE FOR PANEL 122 EZ HAS CORROSION. REFER TO CELSIUS W/O 19120, TASK 1515. MAINTENANCE REMOVED CORROSION, REMAINING MATERIAL IS WITHIN LIMITS SRM 51-10-10. ALODINED, PRIMED, AND TOPCOATED SPLICE PLATE IAW SRM 51-20-42/43SDR MALA000805Floorboard · corrodedFOUND DURING C-CHECK, FLOORBOARD FLANGE AT FS 258 IS CORRODED. REFER TO CELSIUS W/O 19120, TASK 1514. MAINTENANCE REMOVED CORROSION IAW SRM 51-70-40. REMAINING MATERIAL IS OUT OF LIMIT REF SRM 51-10-10. OUT OF LIMITS FLANGE REMOVED, NEW FLANGE FABRICATED, SDR RRXA003807Floor Panel · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO LAV FLOOR PANEL AT STA 35-55 AND X=40 TO X=50, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SDR EF2R2000296Floor Panel · crackedDURING ROUTINE INSPECTION, THE FLOOR PANEL BENEATH THE CAPTAINS RUDDER PEDALS WAS FOUND TO BE CRACKED. REMOVED DAMAGED PANEL. INSTALLED REPLACEMENT PANEL.SDR MWEA001207Floorboard · weakCABIN FLOOR BOARD IS WEAK, ROW (D), BETWEEN STATION 258 AND STATION 313. -- FABRICATED AND INSTALLED FLOOR PANEL AND FASTNERS.SDR MWEA001206Floorboard · weakCABIN FLOOR BOARD IS WEAK, ROW (B) BETWEEN STATION 258 AND 313. -- FABRICATED AND INSTALLED FLOOR PANEL AND FASTNERS.SDR MWEA001205Floorboard · weakCABIN FLOOR BOARD IS WEAK, ROW (D) BETWEEN STATION 1175 AND 1193. -- FABRICATED AND INSTALLED FLOOR PANEL.SDR MWEA001204Floorboard · weakCABIN FLOORBOARD IS WEAK. ROW (B), BETWEEN STATION 465 AND STATION 541. -- FABRICATED AND INSTALLED PANEL.SDR DHL200080216CFloor Panel · crackedAT C CHECK; MAIN CARGO COMPARTMENT SUB FLOOR SKIN CRACKED 16 INCHES BETWEEN FS 20 AND FS 40. CUT AFFECTED AREA IAW SRM 53-2-3, FIG 5, CLEANED,TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, FABRICATED AND INSTALLED FILLER AND DOUBLER IAW SRM 53-2-3 FIG 5. REFSDR DHL200180247CFloor Panel · crackedDURING C CHK FOUND MAIN CARGO COMPT NR 8 FLOOR PANEL CRACKED 1/2 INCH BETWEEN STA 1680 AND 1701. REMOVED CRACKED FLOOR SKIN PER SRM 51-1-21. FABRICATED SKIN PER SRM 53-2-3. TREATED AND PRIMED PERS RSM 51-1-8B. INSTALLED NEW FLOOR SKIN PER SRM 51-1-21.SDR DHL200180238CFloor Panel · brokenMAIN CARGO COMPT-CTR FLOORING PANEL 1A UPPER SKIN BROKEN.CUT OUT DAMAGED AREA PER SRM 53-2-3,FABRICATED FILLER AND DOUBLER PER SRM 53-2-3.CLEANED ,TREATED AND PRIMED PER SRM 51-1-8B,INSTALLED FILLER AND DOUBLER PER SRM 53-2-3.SDR AT0100022Floor Panel · corrodedFOUND COCKPIT FLOORPANEL 4416 CORRODED BEYOND LIMITS. REPLACED SKIN ON FLOOR PANEL 4416 IAW DC9 SRM 53-01, 53-21, AND 51-10-03.SDR AWXA0000919Web · crackedFLOOR WEB CRACKED FS 180 WL 207 LBL 26. REMOVED PART IAW SRM 51-40-02. FABBED REPLACEMENT IAW DWG 65-45833. INSTALLED IAW 51-40-02.SDR AT0100030Floorboard · gougedFOUND FLOORBOARD 96C HAS GOUGE OUT OF LIMITS. REPLACED FLOORBOARD SKIN IAW DC9 SRM 53-01 FIG 1, 53-21, 51-10-04, 51-10-03, 51-30, AND 51-30-02.SDR MWEA001181Floorboard · corrodedFLOORBOARD BETWEEN NR 3 AND 4 SEAT TRACK HAS CORROSION AT FORWARD ENGINE STATION 237. FABRICATED AND INSTALLED NEW SKIN.SDR MWEA001174Floorboard · crackedFLOORBOARD B6 HAS TWO CRACKED HAT CHANNELS. REMOVED AND REPLACED HAT CHANNEL.SDR MWEA001172Floorboard · gougedFLOORBOARD B9 FORWARD END HAS 3 FASTENER HOLES GOUGED FROM WASHERS. FABRICATED AND INSTALLED REPAIR DOUBLER.SDR MWEA001171Floorboard · damagedFLOORBOARD B3 HAS A HOLE IN THE OUTBOARD AFT CORNER. FABRICATED AND INSTALLED REPAIR DOUBLER.SDR MWEA001170Floorboard · chafedFLOORBOARD F5 SKIN IS TORN AND NUMEROUS FASTENER HOLES ARE CHAFED. FABRICATED AND INSTALLED NEW FLOORBOARD.SDR MWEA001169Floorboard · gougedFLOORBOARD A5 HAS GOUGES AROUND 3 FASTENER HOLES. FABRICATED AND INSTALLED SKIN DOUBLER.SDR MWEA001168Floorboard · damagedFLOORBOARD B5 HAS ONE END WITH NUMEROUS FASTENER HOLES DAMAGED BY THE LARGE AREA BEAUTY WASHERS. FABRICATED AND INSTALLED FLOOR PANEL.SDR MWEA001167Floorboard · crackedFLOORBOARD E8 HAS TWO HAT CHANNELS WITH CRACKED ENDS. FABRICATED AND INSTALLED NEW HAT CHANNELS.SDR MWEA001166Floorboard · mismanufacturedFLOORBOARD E9 HAS ONE END WITH TOO LITTLE OR NO EDGE DISTANCE FOR THE FASTENER HOLES. FABRICATED AND INSTALLED NEW PANELS.SDR AT0100037Floorboard · corrodedFOUND SURFACE CORROSION ON SERVICE DOOR ENTRY FLOORBOARD. INSTALLED NEW SKIN IAW DC9 SRM 51-10-04, 51-10-02, AND 51-10-03.SDR AWXA0000874Floorboard · corrodedCORROSION AROUND AND BENEATH FASTENERS IN CREASE BEAM STA 727D STR 17R. REMOVED FLOORBOARD AND WEB, FABRICATED WEB AND INSTALLED IAW SRM 51-40-02 & 53-60-13 FIG 1.SDR MALA000724Floor Panel · corrodedFOUND DURING C-CHECK, FLOOR PANEL 122DZ, 122EZ, 121EZ UPPER FLOOR PANEL PLATES ARE CORRODED. REFER TO CELSIUS W/0 19036, TASK CARD 1525. MAINTENANCE REMOVED LIGHT SURFACTE FROM SHORT SPLICE PLATE IAW SRM 51-10-10. NEGL IGABLE MAT . LOSS TREATED AND PRIMED ISDR L1GA200000323Floor Panel · crackedTWO CRACKS 1 INCH AT FLOOR PANEL 12 FS 137 TO 157 LBL 24 TO LBL 40. INSTALLED REPAIR DOUBLERS.SDR L1GA200000431Floor Panel · corrodedFLOORBOARD SKIN CORRODED AFT OF CO-PILOTS SEAT. FABBED NEW PANEL.SDR L1GA200000430Floor Panel · corrodedFLOOR PANEL CORRODED. FABBED NEW FLOOR PANEL.SDR L1GA200000429Floor Panel · corrodedCORROSION AND CRACKS ON FLOOR PANEL. FABBED NEW SKIN.SDR L1GA200000395Floor Panel · corrodedA 60 BY 10 INCH AREA OF CORROSION AND ELONGATED HOLES ON FLOOR PNL 37. FABBED FLOOR PANEL SKIN.SDR L1GA200000392Floor Panel · corrodedAREAS OF CORROSION ON FLOOR PANEL NR 62. FABBED AND INSTALLED SKIN AND CHANNEL SPLICES.SDR L1GA200000391Floor Panel · corrodedCORROSION ON FLOOR PANEL AT FS 570. FABBED AND REPLACED FLOOR PANEL WEB.SDR L1GA200000378Floor Panel · corrodedLOCALIZED CORROSION LEFT O/B FLOOR PANEL. REMOVED AND REPLACED PANEL.SDR L1GA200000377Floor Panel · crackedLOCALIZED CRACK PANEL 49. INSTALLED FILLER AND DOUBLER.
Back to JASC 5321