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 VJ9800328Floor · corrodedF/O'S FLOOR PANEL NR 14 CORRODED BEYOND LIMITS IAW SRM 53-01 FIG 1 PG 8. MATERIAL LOSS 100 PERCENT. FORMED NEW FLOOR PANEL FROM 7075 T6 .040 CLAD IAW DC-9 SRM 51-10-2, 51-10-4, TREATED AND PRIMED PANEL IAW SRM 51-10-3.SDR VJ9800076Floor · corrodedFLOOR PANEL, FS 130, CORRODED BEYOND LIMITS DC9 SRM 53-01, FIG 1. REMOVED CORROSION IAW DC9 SRM 51-10-3. INSTALLED NEW FLOOR PANEL IAW DC9 SRM 51-10-2 AND 51-30-1.SDR VJ9800074Floor · corrodedFLOOR PANEL 4410A CORRODED BEYOND LIMITS ON BOTTOM SIDE IAW DC9 SRM 51-10-3 AND SRM 53-01, FIG 1. REMOVED CORROSION AND FABRICATED PANEL IAW DC9 SRM 51-10-2. BONDED NEW PART IAW DC9 SRM 51-70-3.SDR VJ9800130Floor · corrodedFLOOR PANEL, FS 130 CORRODED BEYOND LIMIT IAW DC9 SRM 53-01. REMOVED AND INSTALLED NEW SKIN IAW DC9 SRM 51-10-2 AND 51-30-1.SDR EIA990017Floor · crackedDURING C-CHECK, MAIN CABIN THIRD FLOORBOARD FROM L1 DOOR HAS CRACKS AROUND CARGO NET FITTING, NRC NR 0574. REPAIRED IAW SRM 53-05 FIG 1. (M)SDR EIA990016Floor · corrodedDURING C-CHECK, MAIN CABIN BS 120-160 FLOOR PAN FROM BL 0 - LBL 60 HAS CORROSION AND CHAFING, NRC NR 0400. REPAIRED IAW SRM 53-10-01. (M)SDR VJ9800129Floor · corrodedBOTTOM FLOOR PANEL 4410 CORRODED BEYOND LIMIT IAW DC9 SRM 53-01, FIG 1. FABRICATED AND BONDED NEW PART IAW DC9 SRM 51-10-2 AND 51-70-3.SDR SIMA980421Floor · corrodedSAW - DURING HMBV-1 INSPECTION, MAINTENANCE REPORTED THE COCKPIT COPILOT FLOOR PANEL BETWEEN FRAMES 7 AND 9 CORRODED. MAINTENANCE REPAIRED THE FLOOR PANEL IAW ATR DRAWING S531R0161 ISSUE A. AIR ISSUED A SRAS. AIRCRAFT RETURNED TO SERVICE. (X)SDR P5CA9800235Floor Panels · damagedMAIN CABIN FLOOR PANELS UNDER UPPER DECK ACCESS LADDER INBD LEG DAMAGED DUE TO LADDER RESTING ON THE PANEL. FABRICATED AND INSTALLED NEW FLOOR PANEL PER SRM 51-30-02 AND 51-0-01.SDR VJ9800068Floor · corrodedCENTER FLOOR PANEL AT FS 351 TO FS 446 CORRODED BEYOND LIMITS AT TOP SIDE AND BOTTOM EDGES OF SCREW HOLES. FABRICATED NEW FLOOR PANEL IAW DC9 SRM 51-10-4 AND 53-05, FIG 1.SDR HEEA0013018Floor Cover · mis mfgFORWARD EDGE OF PANEL DOES NOT HAVE REINFORCEMENT STRIP BONDED ON FOR INSTALLATION OF PANEL TO MAIN FLOOR PANEL.SDR DHL9872413CFloor Panels · delaminatedAT C-CHECK, FLOORBOARD NR 105 CRACKED AND DELAMINATING BS 1030 TO 1070 LBL 24 TO 45. REMOVED CABIN FLOOR PANELS AND REPLACED PER SRM 51-10-1, 8 X 32 AND 10 X 32. N/R 3680.SDR VJ9800066Floor · corrodedPILOTS FLOOR BOARD AND ATTACHED PARTS CORRODED BEYOND LIMITS. REMOVED CORROSION AND INSTALLED NEW STIFFENERS AND SKIN IAW DC9 SRM 53-01, FIG 1 AND DC9 SRM 51-30-2.SDR VJ9800065Floor · corrodedTOP SIDE, BOTTOM EDGE AND BOTTOM SUPPORT RIBS AFT GALLEY CENTER FLOOR PANEL CORRODED BEYOND LIMITS. FABRICATED AND INSTALLED NEW SKIN IAW DC9 SRM 51-10-2. SEALED AND ASSEMBLED PANEL IAW DC9 SRM 51-30-2.SDR HEEA0012869Floor · corrodedCORRODED. SCRAPPED AT PHI.SDR HEEA0012801Panel · mis mfgPANEL HOLES FOR DRAIN LINES MISPLACED.SDR VJ9800119Floor · corrodedNUT PLATE ATTACH PLATE CORRODED BOTTOM SIDE CABIN FLOOR FS 218, BL 35. REMOVED AND REPLACED NUT PLATE IAW DC9 SRM 51-30-2. FABRICATED DOUBLER IAW DC9 SRM 51-10-2.SDR ABXA9800056Floor · crackedDURING C-CHECK, FOUND SUB-FLOOR CRACKED, STA 207 AT RBL 22, STA 200 AT RBL 4, AND STA 218 AT LBL 3 AND 9. REPAIRED CRACKED SUB-FLOOR IAW DC9 SRM 53-01.SDR 98FDEA00445Floor · crackedN1326 STA-VCE: UPPER FUSELAGE INTERNAL RT SIDE, AT STA 1149 FOUND 2 EA CRACKS 2 LONG ON FLOOR WEB L27. REMOVED CRACKED FLOOR WEB AND REPLACED WITH A NEW ONE IAW SRM 51-41-01 AND 51-35-01. (11 JUNE 1998).SDR AALA980149Floorboard · corrodedTUL - CORROSION ON BOTTOM OF TOP FLANGE OF FLOORBOARD STA 1110, LBL 27 TO LBL 30. REMOVED CORROSION ON BOTTOM SIDE OF FLOORBOARD STA 1110 LBL 27 TO LBL 30 PER SRM 51-10-6. CUT AND REMOVED SECTION OF FLOORBOARD HAT WAS BEYOND LIMITS, ALODINED AND PRIMED AREA.SDR MZZA98060Floor Panel · corrodedTNN - DURING 'S' CHECK INSPECTION ON AIRCRAFT AT AIR ASIA, SEVERE CORROSION WAS FOUND ON RT AFT LAVATORY FLOOR PANEL AT BS 1136, RBL 26. THE CORRODED FLOOR PANEL 3 INCH BY 4 INCH IN SIZE WAS CUTOUT AND INBOARD PARTITION LOWER SUPPORT CHANNEL WERE REPAIRED PERSDR DHL9871738CFloor Panel · delaminatedAT C CHECK, RT SIDE STA 720 NR 6 FLOOR PANEL IS DELAMINATED. REPLACED PANEL PER SRM 51-30-2, 27 BY 16.5, N/R 5131.SDR DHL9871785CFloor Panel · crackedAT C CHECK, CAPT FLOOR PANELS EDGES WORN THIN AND CRACKED, PIECES AROUND CONTROL COLUMN BROKEN. CUT OUT DAMAGED AREAS, FABRICATED AND INSTALLED PANELS PER SRM 53-20-2, 2 BY 4, N/R 5043.SDR DHL9871746CFloor Panel · crackedAT C CHECK, F/O FLOOR PANELS WORN, AND BROKEN. REMOVED PANELS, FABRICATED REPAIRS AND REINSTALLED PER SRM 51-10-2, 2 BY 4, N/R 5066.SDR DHL9871739CFloor Panel · delaminatedAT C CHECK, RT STATION 740 NR 6 FLOOR PANEL DELAMINATED. REPLACED PANEL PER SRM 51-30-2, 16.5 BY 16.75, N/R 5130.SDR DHL9871761CFloor Panel · delaminatedAT C CHECK, RT STA 950 FLOOR NR 6, DELAMINATED. REMOVED AND REPLACED FLOOR PANEL NR 6 PER SRM 51-30-2, 81 BY 16, N/R 5114.SDR DHL9871760CFloor Panel · delaminatedAT C CHECK, R/S STA 950 NR 5 FLOOR PANEL DELAMINATED. REMOVED AND REPLACED FLOOR PANEL PER SRM 51-30-2, 27 BY 19.75, N/R 5113.SDR DHL9871759CFloor Panel · delaminatedAT C CHECK, LEFT SIDE STA 840 FLOOR PANEL NR 2 DELAMINATED. REMOVED AND REPLACED PANEL PER SRM 51-30-2, N/R 5112.SDR DHL9871758CFloor Panel · delaminatedAT C CHECK, LT STA 848 FLOOR PANEL NR 4 DELAMINATED. REMOVED AND REPLACED FLOOR PANEL PER SRM 51-30-2, 22 BY 17, N/R 5111.SDR DHL9871757CFloor Panel · delaminatedAT C CHECK, LT STA 848 FLOOR PANEL DELAMINATED. REMOVED AND REPLACED FLOOR PANEL PER SRM 51-30-2, N/R 5110.SDR DHL9871745CFloor Panel · delaminatedAT C CHECK, LT SIDE FWD OF STA 600 FLOOR PANEL NR 2 DELAMINATED. REMOVED AND REPLACED FLOOR PANELS PER SRM 51-30-2, 20 BY 80, N/R 5105.SDR DHL9871744CFloor Panel · delaminatedAT C CHECK, STA 580 CABIN NR 3 CENTER FLOOR PANEL DELAMINATED. REMOVED AND REPLACED PANEL PER SRM 51-30-2, 5 FT BY 4 FT, N/R 5106.SDR DHL9871743CFloor Panel · delaminatedAT C CHECK, LT SIDE STATION 520 NR 1 FLOOR PANEL DELAMINATED. REMOVED AND REPLACED FLOOR PANEL PER SRM 51-30-2, 24 BY 7 FT, N/R 5107.SDR DHL9871740CFloor Panel · delaminatedAT C CHECK, STA 520 LEFT NR 2 FLOOR PANEL DELAMINATED. REMOVED AND REPLACED PANEL PER SRM 51-30-2, 29.87 BY 19.25, N/R 5108.SDR QXEA9800154Floor Panel · bentAFT CARGO BAY PANEL BETWEEN FLOORBEAMS FRAMES 1666 AND 16060, IS BENT. DIRECTLY ABOVE AFT CARGO DOOR BOTTOM DOOR SILL. REPAIRED PANEL IAW HORIZON EA 4-53-335 AND REINSTALLED TO FLOORBEAM PER FOKKER SRM 51-31-01.SDR TWAA9715101Sequence Valve · failedFLT MCI - FLT 297 - AFTER TAKEOFF, THE RIGHT MLG DOOR LIGHT REMAINED ON. REPLACED THE DOOR SAFETY VALVE MFG NR 1372-579788 AND THE GEAR OPERATED SEQ VALVE MFG NR 10-60580-2. (M)SDR M8XA328MXC2Floorboards · damagedCOS - DURING THE COURSE OF THE C-CHECK INSPECTION, MAINTENANCE DISCOVERED SEVERAL FLOORBOARD PANELS DAMAGED IN THE AFT CARGO COMPARTMENT. MAINTENANCE REPLACED THE DAMAGED PANELS IAW AMM 53-52-00, P/N'S FOR THE DAMAGED FLOORBOARDS 001A539A570000, 01A539A571000SDR CALA9701656Floor Panel · corrodedINSPECTION FOUND FLOOR PANEL AND HAT CHANNEL CORRODED UNDER PILOT'S SEAT. A NEW PANEL AND HAT CHANNEL WERE FABRICATED AND INSTALLED IAW SRM 51-30-2 AND 51-20-0.SDR DHL9780235CFloor Panel · corrodedAT C-CHECK, FWD CARGO COMPT LT INBD AREA BETWEEN STA 140 AND 180 FOUND CORROSION ON FLOOR PANEL. FABRICATED REPAIR PART PER SRM 53-2-0 AND INSTALLED, AREA 6 X 12.SDR USAA970327Floor · corrodedCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND A 15 BY 3 INCH CORRODED AREA AT STATION 957-984 (AFT SERVICE DOOR THRESHOLD) FLOORING WEB, CORROSION TASK NR C53-107-02. FABRICATED WEB PER SRM 53-60-15 PER REPAIR DOCUMENT NR SRM 51-10-02. (M)SDR 98ZZZX1216Floor · buckledREF FAX LM/115-97, LM/116-97, JM/RJ0096-97, AND DJR/RJ0098-97. MLG PRESS FLOOR BETWEEN FRAMES 29 AND 32 OTBD SEAT RAILS 19 INCHES, 20 INCHES OTBD CENTERLINE HV BUCKLE APPROX .125 INCH DEEP. DV DUE EA 500 CYC. REPORT FINDINGS AI (R) REMOVE FLOOR STS. CUR 230SDR HEEA0011792Panel · separatedFLOOR PANEL SEPARATED BEYOND REPAIR.SDR DHL9780236CFloor Panel · corrodedAT C-CHECK, FWD CARGO COMPT FWD LT SIDE UPPER AREA AT STA 120 , FLOOR PANEL HAS CORROSION. FABRICATED REPAIR DOUBLER PER SRM 53-2-3 AND INSTALLED PER SRM 53-2-0, AREA 18.5 X 6.SDR EISA97211Floor Pan · corrodedMAIN CABIN, FLOOR PAN HAS CORROSION APPROX FS 1160. CUT OUT DAMAGED AREA, FABRICATED REPAIR PER 51-40-02. INSTALLED FILLER AND DOUBLER PER SRM 51-40-02. (M)SDR MZZA97266Floor Panel · corrodedHKG - ON WALK AROUND DISCOVER CORROSION AT STATION 440 BETWEEN STRINGER STRINGER 28R AND STRINGER 27R. OPENED FORWARD CARGO FLOOR PANEL AND INSEPCTED DAMAGED AREA. THERE IS NO DAMAGE TO THE STRINGER AND FRAME WEB ASSEMBLY. CUTOUT DAMAGED AREA 2.4 INBY BY 2.SDR DHL9780237CFloor Panel · crackedAT C-CHECK, FWD LOWER CARGO COMPT LT I/B UPPER AREA BETWEEN STA 200 AND 220, FOUND CRACKED PANEL UNDER FLOOR. CUT OUT DAMAGED AREA AND FABRICATED REPAIR PER SRM 51-1-8.SDR HEEA0011617Panel · corrodedCOCKPIT PANEL HAS EXTENSIVE CORROSION AT FORWARD BELLY LATCH BRACKETS. REPLACED WITH SERVICEABLE PART.SDR P5CA9701782Floor · tornTHREE TEARS IN FWD LWR CARGO COMP AT STA 678. REPAIRED PER SRM 51-30-02.SDR HEEA0011446Floor · separationBAGGAGE FLOOR CORROSION AND SEPARATION.SDR UPS97825257Floor Web · corrodedINSPECTION TYPE:C/CK, FLOOR WEB CORRODED AT FS 70 AFT OF FWD ACCY COMPT AFT BULKHEAD AT FLOOR LINE TOP OF RIGHT FWD LOWER CARGO COMPT STRUT. REMOVED CORROSION IAW DC8 SRM 51-1-8 FABRICATED REPAIR DOUBLER AND FILLER IAW REO 03853 IR INSTALLED IAW REO 03853 I
Back to JASC 5321