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 AWXA200400182Floor Panel · delaminatedDURING C-04 CHECK RT OB CABIN FLOOR PANEL (252VF) WAS FOUND DELAMINATED BETWEEN FR 60 AND FR 64, RBL 46 TO RBL 65. MAINTENANCE REMOVED DELAMINATED FLOOR PANEL (252VF); FABRICATED A NEW REPLACEMENT FLOOR PANEL IAW DWG D53670041; INSTALLED NEW PANEL IAW A320 SRSDR GTIA040177Floor Panel · wornFTW - FOUND COCKPIT FLOOR PANEL 4411A BOTTOM DISBONDED NON-SKID WORN. FOUND BOTTOM SKIN CRACKED. REMVOED BOTTOM SKIN. FABRICATED NEW BOTTOM SKIN. INSTALLED BOTTOM SKIN. (M)SDR AMTA200400159Floor Panel · corrodedC-2 CARGO PANELS HAVE CORROSION APPROX STATION 727A TO 727E. FOUND CORROSION OUT OF LIMITS PER SRM 53-00-53-1. REMOVED FLOOR PANEL. FABRIATED AND INSTALLED NEW PANEL. (M)SDR AMTA200400160Floor Panel · corrodedFOUND C-2 CARGO PIT FLOOR PANEL HAS CORROSION STATION 727E TO 727J. CORROSION OUT OF LIMITS PER SRM 53-00-53-01. REMOVED FLOOR PANEL, FABRICATED AND INSTALLED NEW PANEL IAW AMM 51-40-02-0. (M)SDR ASAA0480069Floor Panel · puncturedOKC - HV1 CHECK, FOUND COCKPIT FLOOR PANEL UNDER CAPTAINS SEAT IS PUNCTURED. REMOVED DAMGAED SECTION AND INSTALLED DOUBLER PER SRM 53-01. (M)SDR ASAA0480068Floor Panel · crackedOKC - HV1 CHECK, FOUND CABIN FLOOR PANEL SUPPORT ANGLE IS CRACKED AT FS 929-1003. REMOVED DAMAGED SECTION AND REPAIRED WITH FILLER AND SPLICE PER SRM 51-10-4, 53-01, AND 51-30-8. (M)SDR ASAA0480067Insert · dentedOKC - HV1-CHECK, FOUND CABIN FLOOR PANEL INSERT DAMAGED AT FS 927-1003. REPLACED FLOOR PANEL INSERT PER SRM 53-05. (M)SDR AMTA200400122Panel · corrodedFOUND C2 CARGO PANEL NR 1 HAS CORROSION. CORROSION BEYOND LIMITS PER SRM. FABRICATED NEW PANEL AND INSTALLED PANEL.SDR AMTA200400127Floor Panel · corrodedFOUND C2 CARGO PIT, AREA UNDER CARGO LOADING SYSTEM, PARTICALLY BY DOOR HAS CORROSION ON FLOOR STATION 727J TO 787. REMOVED AND REPLCED C-2 PIT FLOOR PANEL REF 737 AMM 25-51-1 0-4. (M)SDR AMTA200400126Floorboard · corrodedFOUND FLOORBOARD INBOARD OF C2 DOOR HAS CORROSION AT FORWARD END, STATION 887 TO 740 LBL 20 TO RBL 20. REMOVED AND REPLACED C-2 PIT FLOOR PANEL REF 737 AMM 25-52-10-4. (M)SDR GKZR200482303Floor Panel · delaminatedMAIN CARGO FLOOR FORM PALLET POSITION 4 AFT HAS MULTIPULE AREAS OF DISBONDING. REMOVED ALL HARDWARE FROM MAIN CARGO COMPARTMENT FLOOR P4 AFT IAW DC-8 SRM 51-03-00. FABRICATED REPLACEMENT FLOOR BOARDS FROM GIL FAB BOARD 16 EA. FROM 5042B ATI PO 16802. TREATED SDR 373PA0040Floor Panel · corrodedFLOOR PANEL SPLICE STRAP, AFT OF FRAME 727D, HAS SEVERAL AREAS OF LITE CORROSION. FABRICATED NEW SPLICE STRAP PER DRAWING 65-46592 AND INSTALLED PER SRM 51-10-2.SDR ASAA0480065Floor Panel · crackedDURING HV1 CHECK, FOUND CABIN FLOOR PANEL IS CRACKED AT FS 200-256. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR MALA040177Floor Panel · corrodedDURING INSPECTION IN LCQ, RT STA 176.1 CO-PILOT COCKPIT FLOOR CORRODED HEAVILY. MAINTENANCE REMOVED CORRODED AREA AND INSTALLED DOUBLER REPAIR IAW MESABA EO S53197. A/C RELEASE DATE 2/5/2004.SDR ASAA0480047Floorboard · damagedOKC - DURING 15K CHECK, FOUND CABIN FLOOR PANEL HAS DAMAGED CORE AT FS 655. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480045Floorboard · delaminatedOKC - DURING 15K CHECK, FOUND CABIN FLOOR PANEL IS DELAMINATED AT FS 886-927. REPLACED FLOOR PANEL PER SRM 51-01. (M)SDR ASAA0480046Floorboard · puncturedOKC - DURING 15K CHECK, FOUND CABIN FLOOR PANEL IS PUNCTURED AT FS 1041. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR AMTA200400113Floor Panel · corrodedC2 PIT FLOOR PANEL HAS CORROSION FROM STATION 1330 TO 1200 RBL 20 TO LBL 20. CORROSION OUT OF LIMITS IAW SRM. FABRICATED AND INSTALLED NEW CARGO FLOOR PANEL IAW SRM 51-40-02-0 AND AMM 25-50-04-404-004.SDR GTIA040119Floor Panel · delaminatedFTW - FOUND LEFT FLOOR PANEL STATION 200-256 DELAMINATED AND TWO INSERTS MISSING. FABRICATED NEW PANEL. (M)SDR ASAA0480033Floor Panel · crackedOKC - DURING INSPECTION, FOUND CABIN FLOOR PANEL FOR STATION 693-769 BETWEEN RBL 44 AND RBL 54 HAT CHANNEL ON UNDERSIDE IS CRACKED. REPAIRED IAW MD80 SRM 51-70-5. (M)SDR ASAA0480037Floorboard · delaminatedDURING INSPECTION FOUND FLOORBOARD STATION 769 TO 826, LBL 22-44 HAS SEVERAL AREAS OF EDGE DAMAGE. REPAIRED BY FABRICATED REPLACEMENT FLOORBOARD IAW MD80 SRM 53-05. (M)SDR CALA0400062Floor Panel · corrodedINSPECTION FOUND FLOOR PANEL SPLICE BETWEEN 2ND AND 3RD FLOORBOARD CORRODED AT STA 727I. A NEW FLOOR PANEL SPLICE WAS INSTALLED IAW SRM 53-42-11.SDR ASAA0580036Floorboard · damagedOKC - DURING C-CHECK, FOUND CABIN FLOORBOARD PANEL HAS PULLED FIBERGLASS STRANDS. APPLIED FIBERGLASS OVERLAY. (M)SDR ASAA0580033Floor Panel · puncturedOKC - HV-CHECK, COCKPIT FLOOR PANEL PUNCTURED. REMOVED DAMAGED AREA. INSTALLED REPAIR DOUBLER. (M)SDR ASAA0580037Floorboard · damagedOKC - DURING C-CHECK, CABIN FLOORBOARD HAS PULLED FIBERGLASS STRANDS. APPLIED FIBERGLASS OVERLAY. (M)SDR ASAA0580038Floor Panel · damagedOKC - DURING C-CHECK, CABIN FLOORBOARD PANEL HAS PULLED FIBERGLASS STRANDS. APPLIED FIBERGLASS OVERLAY. (M)SDR AMTA200400089Floor Panel · corrodedFOUND C2 CARGO FLOOR PANEL UNDER LOADING SYSTEM CORRODED FROM DOOR FORWARD. REMOVED AND REPLACED CARGO FLOOR PANEL. REINSTALLED ON A/C IAW 737 AMM 25-52-10-4. SEALED FITTINGS IAW 737 AMM 20-30-1 1-2. COATED PANEL WITH ABRASION PROTECTIVE COATING. (M)SDR ASAA0580008Floorboard · delaminatedOKC - HV-CHK, CABIN FLOORBOARD PANEL WAS FOUND DELAMINATED WITH CORRODED INSERTS. REPLACED PANEL. (M)SDR ASAA0580007Floorboard · corrodedOKC - HV-CHECK, CABIN FLOORBOARD PANEL HAS INSERTED PULLED THROUGH. REPLACED PANEL. (M)SDR ASAA0580006Floorboard · corrodedOKC - HV-CHECK, CABIN FLOORBOARD PANEL HAS CORRODED INSERTS. REPLACED PANEL. (M)SDR ASAA0580005Floorboard · corrodedOKC - FOUND HV-CHECK, CABIN FLOORBOARD WAS FOUND TO BE DELAMINATED, WITH CRACKED 'W' CHANNEL. REPLACED PANEL. (M)SDR ASAA0580004Floorboard · corrodedOKC - HV-CHECK, TWO CABIN FLOORBOARDS WERE FOUND TO HAVE CORRODED AND INSERTS FROM FS 541-617 AND BUTTOCK LINES L22 TO R22. BOTH PANELS WERE REPLACED. (M)SDR GTIA040145Channel · damagedFTW - FOUND PASSENGER CABIN METALLIC PANEL LEFT SIDE STATION 1174 TO 1260 HAS TWO HATS SECTION DISBONDED AND DAMAGE FORWARD END SECTION HAT. REPAIRED PANEL. (M)SDR ASAA0580001Floorboard · delaminatedOKC - HV-CHECK, FOUND CABIN FLOORBOARDS WERE FOUND DELAMINATED AT 25 DIFFERENT LOCATIONS FROM FUSELAGE STATION 148 TO 1250 AND BUTTOCK LINES L45 TO R50. DAMAGED FLOORBOARDS WERE REMOVED AND REPLACED IN ALL CASES.SDR ASAA0480025Floor Panel · debondedOKC - DURING 15K CHECK, FOUND CABIN FLOOR PANEL JOINING STRIP HAS DISBONDED AT FS 1155-1250. REBONDED JOINING STRIP PER SRM 51-70-1. (M)SDR ASAA0480026Floor Panel · delaminatedOKC - DURING 15K CHECK, FOUND CABIN FLOOR PANEL IS DELAMINATED AT FS 1003-1041. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0480027Floor Panel · puncturedDURING 15K CHECK, FOUND CABIN FLOOR PANEL IS PUNCTURED AT FS 1079-1155. FILLED PUNCTURE WITH FIBER RESIN AND GLASS OVERLAY PER SRM 51-70-1. (M)SDR ASAA0480023Floor Panel · damagedOKC - DURING HV1 CHECK, FOUND CABIN FLOOR PANEL HAS EDGE DAMAGE, UNSPECIFIED AT FS 148-160. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480022Floor Panel · corrodedOKC - DURING HV1 CHECK, FOUND CABIN FLOOR PANEL HAS CORRODED INSERTS AT FS 175-196. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480021Floor Panel · delaminatedOKC - DURING HV1 CHECK, FOUND CABIN FLOOR PANEL IS DELAMINATED AROUND THREADED FASTENERS AT FS 160-200. REPLACED FLOOR PANEL PER SRM 53-05. (M0SDR ASAA0480020Floor Panel · puncturedOKC - DURING HV1 CHECK, FOUND CABIN FLOOR PANEL IS PUNCTURED AT FS 927-1003. INSTALLED FASTENER TO PLUG PUNCTURE PER SRM 53-01. (M)SDR ASAA0480019Floor Panel · damagedOKC - DURING HV1 CHECK, FOUND CABIN FLOOR PANEL IS SHREDDING AT FS 946-1003. REPLACED CHANNEL PER SRM 53-05. (M)SDR ASAA0480018Floor Panel · puncturedOKC - DURING HV1 CHECK, FOUND CABIN FLOOR PANEL IS PUNCTURED AT FS 826-864. REPLACED CHANNEL PER SRM 53-05. (M)SDR ASAA0480024Floor Panel · debondedOKC - DURING 15K CHECK, FOUND EXISTING CABIN FLOOR PANEL REPAIR DOUBLER HAS DISBONDED AT FS 1155-1250. REBONDED DOUBLER EPR SRM 51-70-1. (M)SDR SWAA040194Floor Panel · crackedDURING SCHEDULED D CHECK, FOUND FLOOR WEB CRACKED FROM BS 178 TO BS 188, LBL 27. REPAIRED FLOOR WEB PER SRM.SDR ASAA0480008Floor Panel · corrodedOKC - DURING HV-1 CHECK, FOUND CABIN FLOOR PANEL IS CORRODED AT FS 1003-1079. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0480007Floor Panel · puncturedOKC - DURING HV-1 CHECK, FOUND CABIN FLOOR PANEL PUNCTURED AT FS 807-826. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0480012Floor Panel · debondedOKC 0 DURING HV-1 CHECK, FOUND CABIN FLOOR PANEL SURFACE IS DISBONDED AT FS 864-886. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480011Floor Panel · damagedOKC - DURING HV-1 CHECK, FOUND CABIN FLOOR PANEL CORNER IS CRACKED AT FS 886-927. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480010Floor Panel · damagedOKC - DURING HV-1 CHECK, FOUND CABIN FLOOR PANEL SURFACE IS SHREDDING. REPLACED FLOOR PANEL PER SRM 53-05. (M)
Back to JASC 5321