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 ORJA97181Floorboard · corrodedLEVEL 2 CORROSION AND TEARING AT NR 2 FLOORBOARD IN MID CARGO COMPARTMENT. REMOVED AND FABRICATED FLOORBOARD IAW DC-9 SRM 51-10-2. MATERIAL ID S007A PO NR L73534. (M)SDR 97ZZZX4208Floor Panel · damagedREAR BAGGAGE FLOOR DAMAGED FROM ABUSE LOADING FREIGHT.SDR 98ZZZM10Floor · corrodedFLOOR FRAME 43 TO 44 RIGHG SIDE INBOARD SEAT TRACK CORRODED, REF 53-51-01-03. REMOVED AND REPLACED AFT VEST INBOARD SEAT TRACK RAIL BETWEEN FRAME 43 TO 44 RIGHT SIDE. (M)SDR 97ZZZX4650Floorboard · delaminatedTHE BAGGAGE COMPARTMENT FLOOR IS CONSTRUCTED OF BONDED, HONEYCOMB MATERIAL. IT HAS TWO SECTIONS, FORWARD AND AFT, THAT ARE SPLICED TOGETHER. DURING AN A2 PHASE INSPECTION, A DELAMINATION WAS DISCOVERED INVOLVING THE UPPER SKIN OF THE FORWARD FLOORBOARD. IT SDR AALA971647Floor Panel · corrodedTUL - FLOOR PANEL CORRODED 10 INCH BY 2 INCH AREA AT STATION 427 SEAT TRACK NR 6 AND INBOARD. INSTALLED NEW FLOOR PANEL PER AARD 51-10-00-1. (M)SDR ABXA9701399Floor Panel · crackedDURING C-CHECK, FOUND LEFT COCKPIT FLOOR PANEL CRACKED. REPAIRED COCKPIT FLOOR PANEL IAW DC-9 SRM 53-01.SDR ABXA9701398Floor Panel · crackedDURING C-CHECK, FOUND CENTER COCKPIT FLOOR PANEL CORRODED BEYOND LIMITS AND CRACKED. FABRICATED P/N 9957827-3 FLOOR PANEL IAW DOUGLAS DRAWING 9957827.SDR QXEA9700722Floor · puncturedPDX- COCKPIT FLOOR HAS A PUNCTURE ON THE RIGHT HAND SIDE OUTBOARD OF THE COPILOTS SEAT TRACK. REPAIRED COCKPIT FLOOR IAW FOKKER SRM.SDR AALA971442Floor · corrodedTUL - FOUND CORROSION ON UNDER FLOOR MEMBRANE, JUST RIGHT OF CENTER AT STATION 200 (MARKED). REMOVED CORROSION AND INSTALLED DOUBLR PER SRM 53-01 FIG 4. (M)SDR RAIA970825Floor Plate · corrodedSTL - DURING MAINTENANCE CHECK, FOUND CORROSION AT FLOOR TRANSITION PLATE AFT OF SERVICE DOOR FRAME 39 TO 41. MAINTENANCE REPLACED TRANSITION PLATE PER ATR SRM. (M)SDR RAIA970823Floor Plate · corrodedSTL - DURING MAINTENANCE CHECK, FOUND CORROSION ON TRANSITION PLATE BETWEEN FRAME 39 AND 38. MAINTENANCE REPLACED TRANSITION PLATE PER ATR SRM. (M)SDR ABX9701265Floor Panel · crackedDURING C-CHECK, FOUND THE FLOOR PANEL AT STA 218 BETWEEN SEAT TRACK BL 0.0 AND RBL 9.0 CRACKED. REPAIRED IAW DC9 SRM 53-21-0.SDR AALA971491Floor · corrodedAFW - FOUND CORROSION ON FLOOR WEB AT STATION 1130-1160. REMOVED AND BLENDED CORROSION, ADD DOUBLER AND SPLICE PER SRM 51-40-3. (M)SDR ABXA9701247Floor Panel · corrodedDURING C-CHECK, FOUND RT OUTBOARD COCKPIT FLOOR PANEL CORRODED AT STA 120 TO 160. REPLACED FLOOR PANEL.SDR CKSA97374Floor Panel · spongyDURING ACCOMPLISHMENT AIRCRAFT RECONFIGURATION AS REQUIRED, FOUND FLOOR PANEL (CENTER) AT STA 449 SPONGY. REMOVED AND REPLACED FLOOR PANEL CENTER STA 449 IAW L1011 SRM 51-40-01 AND EER NBR L-1 05308. NON ROUTINE TASK CARD NUMBER 106798.SDR ORJA97109Floor Board · corrodedAFT PIT STA 1125, FLOOR BOARD HAS LEVEL 3 CORROSION. REMOVED FLOOR PANEL, CORROSION DAMAGE BEYOND REPAIRABLE LIMITS. FABRICATED NEW FLOOR PANEL FROM 7075-T6 .050 INCH IAW DC-9 SRM 51-10-2. TREATED AND PRIMED IAW DC-9 SRM 51-10-3. INSTALLED PANEL IAW DC-9 SSDR CALA9701088Floor Panel · corrodedINSPECTION FOUND FLOOR PANELS 291AF, 291EF, 292BF, 292DF, 292EF, 293BF, 293CF, AND 293DF CORRODED. REPLACEMENT FLOOR PANELS WERE FABRICATED AND INSTALLED IAW SRM 51-30-00, 53-21-00, AND 53-60-00.SDR CALA9701087Floor Panel · corrodedINSPECTION FOUND FLOOR PANELS 241EF, 241FF, 242BF, 242FF, AND 261BF CORRODED. REPLACEMENT FLOOR PANELS WERE FABRICATED AND INSTALLED IAW SRM 51-30-00, 53-60-00, AND 53-21-00.SDR CALA9701085Floorboard · corrodedINSPECTION FOUND FLOORBOARD PANEL 227AF CORRODED. A NEW PANEL WAS FABRICATED AND INSTALLED IAW SRM 53-60-00.SDR WRLADRC0192Panel · corrodedAVIONICS COMPARTMENT FLOOR PANEL FORWARD OF ACCESS DOOR 115 AZ FOUND CORRODED AND DELAMINATED. FLOOR PANEL REPLACED BY FABRICATION PER MD-11 SRM VOL III 51-21-01 FIG 7 REV 20. (M)SDR WRLADRC0138Panel · delaminatedFORWARD CARGO COMPARTMENT FLOORBOARD PANEL FOUND DELAMINATED, CORRODED AND SCRATCHED MARK PANELS NR 127PG, 127NG, 127JG, 127DF, 127AF, 123UF, 127HF AND 127NF. PANELS NR 127PG AND 127HF REPLACED BY FABRICATION PER DWG ACA 7573. PANELS NR 127NG, 127JG, 127DF, SDR WRLADRC0131Panel · corrodedFORWARD CABIN BS 735 TO 979 FLOOR PANELS FOUND DETERIORATED FOR NR 241KF, NR 243AF, NR 245AF, NR 243BF, NR 245BF, NR 245CF, NR 242HF AND NR 224AF. FLOOR PANELS FABRICATED AS EPR DWG ADA 7179, 8382 AND 8384. (M)SDR WRLADRC0130Panel · deterioratedCENTER CABIN FLOOR PANELS BS 1239 TO BS 1361 FOUND DETERIORATED FOR NR 262BF, NR 272BF AND NR 272AF. FLOOR PANELS FABRICATED AS PER DWG AGA 0182, 181 AND 180 AND INSTALLED AS PER MD 11 MM 53-21-04 REV 27. (M)SDR WRLADRC0129Panel · deterioratedAFT CABIN FLOOR PANELS BS 1561 TO 1681 FOUND DETERIORATED FOR NR 282BF AND NR 282AF. FLOOR PANEL FABRICATED AS PER DWG 3212 AND INSTALLED AS PER MD-11 53-21-04 REV 27. (M)SDR CALA9701070Floor · crackedINSPECTION FOUND AN 8 INCH CRACK AT LIGHTENING HOLE OF FLOOR UNDER FLIGHT ENGINEER'S SEAT. THE CRACK WAS STOP DRILLED AND A DOUBLER WAS FABRICATED AND INSTALLED IAW SRM 53-11-01 AND 51-31-01.SDR WRLADRC099Panel · corrodedCENTER CARGO COMPARTMENT FLOORBOARD PANEL FOUND DAMAGED, CORROSION, STUD DAMAGED, FASTENER HOLE DAMAGED AT FLOORBOARD NR 183BF, 183VB, 183KB, 183AB, 183MB, 183NB, 183PB, 183EF, 183EF, 183LB, 183JB, 183GB AND 183HF. PANELS NR 183CB, 183DB, 183XB, 183TB, 183AB,SDR WRLADRC0120Panel · deterioratedAFT CABIN FLOOR PANELS BS 1821-2007 FOUND DETERIORATED AS FOLLOWS, NR 291AF, 291CF, 291DF, 293FF, 292DF, 292CF, 292AF AND 293NF. PANELS FABRICATED AS PER DWG AGA 7072, 7075,7102, 8070 AND 8008 AND INSTALLED AS PER MD11 MM 53-21-04 REV 27. (M)SDR WRLADRC0105Panel · delaminatedFORWARD CARGO COMPARTMENT FLOORBOARD PANEL FOUND DAMAGE, CORRODED AND DELAMINATED, PANEL NR 127DG, 123HF, 127GB, 127PF AND 127RF. PANEL NR 127DG REPLACED BY FABRICATION PER DWG ACA 7573. PANELS NR 127GB, 123HF, 127PF AND 127RF REPAIRED PER MD-11 SRM VOL 1 53SDR WRLADRC0104Panel · corrodedAFT CARGO COMPARTMENT FLOORBOARD PANEL FOUND WITH CORROSION AT FLOORBOARD NR 187GF, 187HF, 187EF, 187AF. CORROSION REMOVED AND REPROTECTED AS PER MD-11 SRM VOL 1 51-21-01 REV 20. (M)SDR CALA9701086Floor Panel · corrodedINSPECTION FOUND CABIN FLOOR PANELS 231CF, 232AF, 232CF, 233AF, AND 233CF CORRODED. REPLACEMENT FLOOR PANELS WERE FABRICATED AND INSTALLED IAW SRM 51-30-00, 53-60-00, AND 53-21-00.SDR WRLADRC089Panel · delaminatedMAIN DECK 'C' ZONE, FLOORBOARD PANELS FOUND WITH CORROSION, DELAMINATION AROUND THE FASTENER HOLES. PANELS NR 283JF, 283HF, 283GF, 293QF, 293RF, 293SF, 293TF, 293LF, 293BF, 293KF, 293AF, 293PF, 293CF, 293JF, 293HF, 293MF AND 291MF. FLOOR PANELS FABRICATED PESDR CALA9701018Floor Panel · corrodedINSPECTION FOUND FLOOR PANEL CORRODED AT STA 840-899, RBL 72. THE PANEL WAS REMOVED AND REPLACED IAW SRM 53-00-01.SDR P5CA9700840Floor Panel · spongyU/D BS 520 TO 600 MOST LT O/B FLOOR PNL FOUND SPONGY. REPLACED/REINSTALLED SVC TAG NR 2042412.SDR P5CA9700838Floor Panel · spongyU/D FLOOR PNL FOUND SPONGY BET BS 520 TO 580 LBL 40 TO 65 IPC 53-21-17-01. REPLACED/REINSTALLED SVC TAG NT 2042488.SDR P5CA9700841Floor Panel · damagedU/D BS 520 TO 540 MID FLOOR PNL DAMAGE. REPLACED/REINSTALLED PER SV TAG NR 2042488.SDR P5CA9700859Floor Panel · damagedM/D-BS 460 TO 480 LBL 33 O/B FLOOR PNL DAMAGED. REPLACED/REINSTALLED PER BOEING SRM 51-10-01, SVC TAG NR 2042691.SDR P5CA9700824Floor Panel · brokenM/D BS 380 TO 440 CTR FLOOR PNL CORNER BROKEN. REPLACED/INSTALLED PER MM 53-21-02.SDR P5CA9700816Floor Panel · delaminatedM/D BS 460 TO 480 RBL 33TO O/B FLOOR PNL CORNER AREA. REPLACED/REINSTALLED SVC NR 2042301.SDR P5CA9700795Floor Panel · spongyM/D FLOOR PANEL FOUND SPONGY AT STA 2240 TO 2280 LBL 33 TO 90. REPLACED/REINSTALLED PER MM 53-21-02, SVC TAG NR 2042203.SDR P5CA9701011Panel · corrodedLEVEL 2 U/D BS 440 TO 460 CTR FLOOR PANEL SURFACE FOUND CORRODED. REPLACED PER MM 3-21-02, SVC TAG NR 2042498.SDR P5CA9701010Panel · corrodedLEVEL 2 U/D BS 460 TO 480 CTR FLOOR PANEL SURFACE FOUND CORRODED. REPLACED PER MM 53-21-02, SVC TAG NR 2042499.SDR P5CA9701009Panel · corrodedLEVEL 2 U/D BS 480 TO 520 CTR FLOOR PANEL SURFACE FOUND CORRODED. CORROSION REPLACED/INSTALLED PER MM 53-21-02, SVC TAG NR 2042496.SDR P5CA9700762Floor Panel · crackedM/D BS 1370 RBL 5 FLR PNL FOUND PUNCH HOLE. REPLACED AND REINSTALLED PER SV TAG NR 2042207.SDR P5CA9700761Floor Panel · crackedM/D BS 1640 RBL 5 FLOOR PNL FOUND PUNCH HOLE. REPAIRED FILLER PER BOEING SRM 51-40-07.SDR P5CA9700759Floor Panel · puncturedM/D BS 680 LBL 5 FLOOR PNL FOUND PUNCH HOLE. REPAIRED FILLER PER BOEING SRM 51-40-07.SDR DHL9780530CFloorboard · crackedAT C-CHECK, UPPER CARGO COMPT AT FS 240 TO 260 FLOORBOARD BETWEEN NR 6 AND NR 7 TRACK HAS CRACK AND WORKING RIVETS. CUT OUT DAMAGED AREA , FABRICATED AND INSTALLED REPAIR DOUBLER PER SRM 53-2-3. FASTENERS INSTALLED PER SRM 51-1-21.SDR DHL9780527CFloor Panel · crackedAT C- CHECK, FWD CARGO COMPT AT STA 240L FLOOR PANEL BOTTOM PLATING 12 FROM OUTBD IS CRACKED. FABRICATED REPAIR, STOP DRILLED CRACK AND INSTALLED REPAIR PER SRM 53-2-3.SDR HAIHEEA9782Floor Panel · holedFLOOR PANEL HAS HOLES IN UNDERSIDE. REMOVED FROM AIRCRAFT NYV-O-CVG-11.SDR HAIHEEA9754Floor Panel · defectiveFLOOR PANEL CORE ON BOTTOM SIDE HAS SHIFTED TOO CLOSE TO EDGE FOR INSTALLATION. TIME SINCE REPAIR 0:00.SDR DHL9780149CFloor · corrodedAT C-CHECK, MAIN CARGO COMPT SUBFLOOR HAS CRACK BETWEEN FS 220 AND 240 AT NR 1 SEAT TRACK. CUT OUT DAMAGED AREA, FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53-2-0.
Back to JASC 5321