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 CALA0100793Floor Panel · delaminatedINSPECTION FOUND CABIN R/H FLOOR PANEL DELAMINATED AT FS 245-313 AND A CREASE IN FLOOR PANEL AT FS 313-390. NEW FLOOR PANELS WERE INSTALLED IAW ECRA 5320-01265.SDR CALA0100792Floor Panel · delaminatedINSPECTION FOUND CABIN CENTER FLOOR PANEL DELAMINATED AT FS 1003-1079. A NEW FLOOR PANEL WAS INSTALLED IAW ECRA 5320-01265.SDR CALA0100791Floor Panel · delaminatedINSPECTION FOUND CABIN CENTER AND L/H FLOOR PANELS DELAMINATED AT FS 769-807 AND FS 769-826. A R/H FLOOR PANEL AT FS 769-807 WAS FOUND TORN AT EDGES. NEW FLOOR PANELS WERE INSTALLED IAW ECRA 5320-01265.SDR CALA0100790Floor Panel · damagedINSPECTION FOUND RT CABIN FLOOR PANEL CREASED AT FS 466-542. A NEW FLOOR PANEL WAS INSTALLED IAW ECRA 5320-01265.SDR CALA0100789Floor Panel · delaminatedINSPECTION FOUND CABIN R/H FLOOR PANELS DELAMINATED AT FS 1193-1250 AND FS 1250-1309. NEW FLOOR PANELS WERE INSTALLED IAW ECRA 5320-01265.SDR CALA0100788Floor Panel · delaminatedINSPECTION FOUND R/H CABIN FLOOR PANEL DELAMINATED AT FS 826-864 AND R/H CABIN FLOOR PANEL CRACKED AT FS 889-927. NEW FLOOR PANELS WERE INSTALLED IAW ECRA 5320-01265.SDR CALA0100787Floor Panel · delaminatedINSPECTION FOUND CABIN CENTER AND R/H FLOOR PANELS DELAMINATED AT FS 1079-1117 AND R/H FLOOR PANEL DELAMINATED AT FS 1117-1174. NEW FLOOR PANELS WERE INSTALLED IAW ECRA 5320-01265.SDR CALA0100783Floor Panel · puncturedINSPECTION FOUND CABIN L/H AND R/H FLOOR PANELS PUNCTURED AT FS 1003-1079. NEW FLOOR PANELS WERE INSTALLED IAW ECRA 5320-01265.SDR CALA0100782Floor Panel · delaminatedINSPECTION FOUND CABIN R/H FLOOR PANEL DELAMINATED AT FS 693-765. A NEW FLOOR PANEL WAS INSTALLED IAW ECRA 5320-01265.SDR CALA0100781Floor Panel · puncturedINSPECTION FOUND CABIN L/H FLOOR PANEL PUNCTURED AT FS 927-1003. A NEW FLOOR PANEL WAS INSTALLED IAW ECRA 5320-01265.SDR CALA0100779Floor Panel · tornINSPECTION FOUND CABIN CENTER FLOOR PANEL TORN BY INSERT HOLE AT FS 945-1003. A NEW FLOOR PANEL WAS INSTALLED IAW ECRA 5320-01265.SDR CALA0100778Floor Panel · delaminatedINSPECTION FOUND CABIN L/H FLOOR PANEL DELAMINATED AT FS 1250-1309. A NEW FLOOR PANEL WAS INSTALLED IAW ECRA 5320-01265.SDR CALA0100777Floor Panel · delaminatedINSPECTION FOUND CABIN CENTER FLOOR PANEL DELAMINATED AT FS 254-313. A NEW FLOOR PANEL WAS INSTALLED IAW ECRA 5320-01265.SDR CALA0100776Floor Panel · delaminatedINSPECTION FOUND COCKPIT CENTER FLOOR PANEL DELAMINATED AT FS 120-160. A NEW FLOOR PANEL WAS INSTALLED IAW ECRA 5320-01265.SDR CALA0100775Floor Panel · delaminatedINSPECTION FOUND CABIN CENTER FLOOR PANELS DELAMINATED AT FS 1250-1309 AND FS 1309-1347. NEW FLOOR PANELS WERE INSTALLED IAW ECRA 5320-01265.SDR CALA0100774Floor Panel · delaminatedINSPECTION FOUND CABIN FORWARD ENTRY FLOOR PANEL C & J DELAMINATED. NEW FLOOR PANELS WERE INSTALLED IAW ECRA 5320-01265.SDR CALA0100773Floor Panel · corrodedINSPECTION FOUND FORWARD ENTRY FLOOR PANEL CORRODED AT FS 160-200, LBL 8-44. A NEW FLOOR PANEL WAS INSTALLED IAW ECRA 5320-01265.SDR CALA0100772Floor Panel · delaminatedINSPECTION FOUND CABIN CENTER FLOOR PANEL DELAMINATED AT FS 826-886. A NEW FLOOR PANEL WAS INSTALLED IAW ECRA 5320-01265.SDR CALA0100771Floor Panel · delaminatedINSPECTION FOUND CENTER CABIN FLOOR PANELS AT FS 1117-1174 AND FS 1174-1250 DELAMINATED. LEFT HAND CABIN FLOOR PANELS WERE FOUND DELAMINATED AT FS 1079-1155 AND FS 1155-1250. NEW FLOOR PANELS WERE INSTALLED IAW ECRA 5320-01265.SDR CALA0100770Floor Panel · delaminatedINSPECTION FOUND COCKPIT FLOOR PANEL DELAMINATED AT FS 150-160, LBL 8-12. A NEW FLOOR PANEL WAS INSTALLED IAW ECRA 5320-01265.SDR CALA0100769Floor Panel · delaminatedINSPECTION FOUND CABIN L/H FLOOR PANEL DELAMINATED AROUND INSERT HOLES AT FS 673-763. A NEW FLOOR PANEL WAS INSTALLED IAW ECRA 5320-01265.SDR CALA0100764Floor Panel · delaminatedINSPECTION FOUND MAIN CABIN CENTER FLOOR PANEL DELAMINATED AT FS 1117-1174. A NEW FLOOR PANEL WAS INSTALLED IAW ECRA 5320-01265.SDR 2002F00696Floor Panel · corrodedFOUND CORROSION ON COCKPIT FLOOR SUPPORT PANEL FROM BS 259.5 TO BS 282.5 AT LBL 8. (M)SDR 2002F00695Floor Panel · corrodedFOUND CORROSION ON COCKPIT FLOOR SUPPORT PANEL BS 259.5 FROM RBL 0 TO 12 AND FROM LBL 0 TO LBL 32. (M)SDR 2002F00694Floor Panel · corrodedFOUND CORROSION ON UNDERSIDE OF COCKPIT FLOOR PANEL NR 2301. (M)SDR 2002F00693Floor Panel · corrodedFOUND CORROSION ON COCKPIT FLOOR PANEL 2303, UNDER FACE. (M)SDR 2002F00692Floor Panel · corrodedFOUND CORROSION ON UNDERSIDE OF COCKPIT FLOOR PANEL NR 2306. (M)SDR DHL2001727515Floor Panel · damagedMAIN CABIN BS 380 LBL 52 FLOOR PANEL PREVIOUS REPAIR METAL ROLLED BACK. REMOVED FLOOR PANELS PER SRM 51-30-2. FABRICATED NEW FLOOR PANEL PER SRM 53-20-1. ALODINED AND PRIMED AREA PER SRM 51-10-2. INSTALLED NEW FLOOR PANELS PER SRM 51-30-2.SDR CALA0100761Floor Panel · puncturedINSPECTION FOUND CABIN FLOOR PANEL PUNCTURED AT FS 256-313. THE FLOOR PANEL WAS REMOVED AND A NEW PANEL WAS INSTALLED IAW SRM 51-30-1 AND ECRA 5320-01265.SDR GTIA011063Floor Panel · corrodedCOCKPIT FLOOR PANEL BENEATH PILOT SEAT IS CORRODED. FOUND TO BE OUT OF LIMITS. FORMED NEW PANEL IAW MD80 SRM 53-21-0. (M)SDR GTIA011062Floor Panel · corrodedFTW - COCKPIT FLOOR PANEL BENEATH CO-PILOTS SEAT IS CORRODED. REMOVED FLOOR PANEL, CORRODED OUT OF LIMITS. FORM NEW PANEL PER MD80 SRM 51-10-2. (M)SDR GTIA011041Floorboard · crackedFTW - CENTER FLOORBOARD FS 826-886 CRACKED AFT EDGE. AFTER FURTHER EVALUATION P/N 993639-15 (TWO PIECES) AND P/N 9936639-13 (TWO PIECES) WERE FOUND TO BE OUT OF LIMITS IAW MD80 SRM 51-01. FABRICATED 2 NEW PIECES OF EDGE TRIM IAW MD80 SRM 53-05. INSTALLED SUPSDR GTIA011040Floor Panel · crackedFTW - FLOOR PANEL CRACKED AFT EDGE FS 927.2R, OUTBOARD PANEL. STOP DRILLED CRACK IAW MD80 SRM 53-05-0. FABRICATED DOUBLER IAW MD80 SRM 53-05-0. INSTALLED DOUBLER IAW MD80 SRM 51-30-2. (M)SDR LR7A01067Floor Panel · warpedDURING SCHEDULED C2 INSPECTION PER JOB CARD HC05297 FOUND FS 245 - 345E RH FLOOR PANEL WARPED AND CORRODED AT LBL 16 - 42, WL 146.REPLACED FLOOR PANEL IAW SRM SMP 583-53-40-05. NR 2143.SDR LR7A01064Floor Panel · warpedDURING SCHEDULED C2 INSPECTION PER JOB CARD HC05297 FOUND FS 737E - 817E CENTER FLOOR PANEL WARPED AND CORRODED AT BL 0, WL 146.REPLACED FLOOR PANEL IAW SRM SMP 583-53-40-05. NR 2121.SDR LR7A01063Floor Panel · warpedDURING SCHEDULED C2 INSPECTION PER JOB CARD HC05297 FOUND FS 245 - 345E RH FLOOR PANEL WARPED AND CORRODED AT RBL 16 - 52, WL 146.REPLACED FLOOR PANEL IAW SRM SMP 583-53-40-05. NR 2119.SDR RRXA010062Floor Panel · damagedUPPER DECK CARGO FLOOR AT STA 781, 30 AND TO THE RT HAS A HOLE. REPAIRED GOUGE IN FLOOR PANEL IAW DC-8 SRM 53-2-3 FIG 6.SDR 2002F00701Floor Panel · corrodedFOUND CORROSION ON COCKPIT FLOOR SUPPORT PANEL BETWEEN BS 289.5 AND BS 312 AT RBL 12. (M)SDR 2002F00700Floor Panel · corrodedFOUND CORROSION ON COCKPIT FLOOR SUPPORT PANELS FROM BS 257.5 TO BS 312, AT LBL 13. (M)SDR CALA0100712Floor Panel · corrodedINSPECTION FOUND FORWARD ENTRY FLOOR PANEL AT R-1 DOOR JAMB CORRODED, FS 160-200, RBL 48. THE FLOOR PANEL AND SUPPORT WERE REMOVED AND A NEW FLOOR PANEL AND SUPPORT WERE INSTALLED IAW SRM 51-10-4, 53-30-1, AND 51-30-1.SDR CALA0100711Floor Panel · brokenINSPECTION FOUND CABIN L/H O/B FLOOR PANELS BROKEN OFF AT FASTENER HOLES AT FS 1079-1155 AND FS 1155-1250. THE PANELS WERE REPAIRED IAW SRM 51-70-1.SDR CALA0100709Floor Panel · puncturedINSPECTION FOUND CABIN R/H I/B FLOOR PANEL PUNCTURED AT FS 389-408. A NEW PANEL WAS INSTALLED IAW ECRA 5320-01265 AND SRM 51-30-1.SDR CALA0100708Floor Panel · delaminatedINSPECTION FOUND COPILOT'S I/B FLOOR PANEL DELAMINATED. THE FLOOR PANEL WAS REMOVED AND A NEW FLOOR PANEL WAS INSTALLED IAW SRM 53-30-01, 53-21-0, SHEET 23, 51-30-1, AND 51-30-2.SDR CALA0100693Floor Panel · delaminatedINSPECTION FOUND MAIN CABIN R/H I/B FLOOR PANEL DELAMINATED AT FS 1003-1079. A NEW FLOOR PANEL WAS INSTALLED IAW ECRA 5320-01265.SDR CALA0100690Floor Panel · delaminatedINSPECTION FOUND CABIN FLOOR PANELS M-P DELAMINATED. NEW FLOOR PANELS WERE INSTALLED IAW ECRA 5320-01265.SDR CALA0100689Floor Panel · delaminatedINSPECTION FOUND CABIN FLOOR PANELS B-K DELAMINATED. NEW FLOOR PANELS WERE INSTALLED IAW ECRA 5320-01265.SDR CALA0100688Floor Panel · delaminatedINSPECTION FOUND CABIN L/H I/B FLOOR PANEL DELAMINATED AT FS 1079-1155 AND R/H I/B FLOOR PANEL WAS DELAMINATED AT FS 927-1003. NEW FLOOR PANELS WERE INSTALLED IAW ECRA 5320-01265.SDR CALA0100687Floor Panel · delaminatedINSPECTION FOUND MAIN CABIN CENTER FLOOR PANELS DELAMINATED AT FS 1174-1250 AND FS 1309-1361. A R/H I/B FLOOR PANEL WAS DELAMINATED AT FS 1250-1309. A NEW FLOOR PANELS WERE INSTALLED IAW ECRA 5320-01265.SDR CALA0100686Floor Panel · delaminatedINSPECTION FOUND CABIN R/H I/B AND CENTER FLOOR PANELS AT FS 1117-1174 DELAMINATED AND CENTER PANEL AT FS 1079-1117 DELAMINATED. NEW FLOOR PANELS WERE INSTALLED IAW ECRA 5320-01265.SDR CALA0100685Floor Panel · delaminatedINSPECTION FOUND CABIN CENTER FLOOR PANELS DELAMINATED AT FS 826-886 AND AT FS 945-1003. NEW FLOOR PANELS WERE INSTALLED IAW ECRA 5320-01265.
Back to JASC 5321