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 ASAA0590104Floor Panel · dentedPAE - DURING C-CHECK, FOUND FORWARD CARGO BAY NR 3 FLOOR PANEL DAMAGED/DENTED. FABRICATED REPLACEMENT PANEL IAW SRM 51-10-02. (M)SDR UPS05144389Floor Panel · delaminatedFLOOR PANEL IN A/B SECTION HAS DELAM OF FACE PLATE AFT SECTION AS REPORTED BY LOAD CREW. TRIMMED DAMAGE AND COMPLIED WITH EO A300-5320-22110-A. BULK PIT TO BY EMPTY UNTIL PERMANENT REPAIR COMPLETED. REF D301479.SDR USAA050635Floor Panel · delaminatedFOUND FLOOR PANEL DELAMINATED GREATER THAN 10 PERCENT, MAIN CABIN FLOOR PANEL 271PF. FABRICATED AND INSTALLED NEW FLOOR PANEL PER SRM 53-02-00. (M)SDR ASAA0590102Floor Panel · damagedPAE - DURING C-CHECK, FOUND FORWARD CARGO BAY NR 4 FLOOR PANEL DAMAGED. REPAIRED IAW SRM 53-30-53. (M)SDR ASAA0590099Floor Panel · corrodedPAE - DURING C-CHECK, FOUND FORWARD CARGO BAY NR 1 FLOOR PANEL EDGE CORROSION AT BS 400. REPAIRED IAW SRM 51-20-01. (M)SDR ASAA0590091Floor Panel · dentedPAE - DURING C-CHECK, FOUND AFT BAY NR 1 FLOOR PANEL HAS DENTS. REPAIRED IAW SRM 53-60-53. (M)SDR ASAA0590090Floor Panel · dentedPAE - DURING C-CHECK, FOUND AFT BAY NR 2 FLOOR PANEL HAS DENTS. REPAIRED IAW SRM 51-20-01. (M)SDR ASAA0590087Floor Panel · dentedPAE - DURING C-CHECK, FOUND FORWARD CARGO BAY NR 5 FLOOR PANEL IS DENTED. REPAIRED IAW SRM 51-40-02. (M)SDR 05FDEA01097Floor Panel · crackedFLOOR PANEL 231NH HAS 3 EA CRACKS AND 7 EA MISSING/BROKEN INSERTS. FABBED REPLACEMENT PANEL 231NH IAW FED EX DWG NR SRZ-25-005 REV E.SDR ASAA0580212Cusp Web · corrodedDURING C-CHECK, FOUND CABIN FLOOR PANEL CUSP WEB CORRODED. REMOVED DAMAGED SECTION. INSTALLED REPAIR FILLER AND DOUBLER. (M)SDR 2005UALA00376Pressure Panel · crackedLEFT WHEEL WELL CEILING HAS CRACK AT FWD EDGE APPROXIMATELY SIX INCHES OUTBOARD OF AILERON TOWER SHAFT. *S/D* MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR UPS05844376Floorboard · corrodedMAIN CABIN , CORROSION ON FLOORBOARD STA 1560,1600 AND 1660, LBL35. REMOVED CORROSION FOUND OUT OF LIMITS, INSTALLED REPAIR DOUBLERS IAW 51-1-8, 53-02-00, 53-02-03 FIG 10 AND 51-1-21.SDR UPS05844310Floorboard · corrodedINSPECTION TYPE:C1 REMOVED CORROSION ON FLOORBOARD F86 AND FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED REPAIR DOUBLER IAW SRM 53-2-0, 53-2-3 FIG 10, AND 51-1-8.SDR UPS05844285Floorboard · corrodedINSPECTION TYPE: C1, LOWER SURFACE OF CABIN FLOORBOARD CORRODED FROM STA 1555 TO 1563 & BL 0 TO RBL 9. BLENDED OUT OF LIMITS AND REPAIRED IAW SRM 53-02-03, 51-1-8, 51-1-21, 51-3-0 AND 51-1-15.SDR ASAA0580191Floor Panel · delaminatedOKC - FOUND DURING C-CHECK, CABIN FLOOR PANEL IS DELAMINATED AND CRACKED. REPLACED PANEL. (M)SDR ASAA0580190Floor Panel · delaminatedOKC - FOUND DURING C-CHECK, CABIN FLOOR PANEL IS DELAMINATED. REPLACED PANEL. (M)SDR ASAA0580187Floor Panel · corrodedOKC - FOUND DURING C-CHECK, CABIN FLOOR PANEL CORRODED, DISBONDED, AND CRACKED. REPLACED DAMAGED SECTION. REBONDED, STOP DRILLED CRACK, AND INSTALLED A REPAIR DOUBLER. (M)SDR ASAA0580185Floor Panel · delaminatedOKC - FOUND DURING C-CHECK, CABIN FLOOR PANEL HAS SEVERAL DELAMINATED EDGES. REPLACED PANEL. (M)SDR ASAA0580184Floor Panel · crackedOKC - FOUND C-CHECK, CABIN FLOOR PANEL IS PUNCTURED AND CRACKED. REPLACED PANEL. (M)SDR ASAA0580183Floor Panel · delaminatedOKC - FOUND DURING C-CHECK, CABIN FLOOR PANEL IS DELAMINATED. REPLACED PANEL. (M)SDR ASAA0580182Floor Panel · damagedOKC - FOUND DURING C-CHECK, CABIN FLOOR PANEL HAS DAMAGED INSERTS AND EDGE POTTING DAMAGE. REPLACED PANEL. (M)SDR ASAA0580181Floor Panel · crackedOKC - FOUND DURING C-CHECK, CABIN FLOOR PANEL HAS PULLED RIVETS AND CRACKED SKIN. REMOVED DAMAGED SECTION. INSTALLED REPAIR DOUBLER AND FILLER. (M)SDR ASAA0580180Floor Panel · delaminatedOKC - FOUND DURING C-CHECK, CABIN FLOOR PANEL DELAMINATED. REPLACED PANEL. (M)SDR ASAA0580179Floor Panel · delaminatedOKC - FOUND DURING C-CHECK, CABIN FLOOR PANEL DELAMINATED. REPLACED PANEL. (M)SDR ASAA0580178Floor Panel · puncturedOKC - FOUND DURING C-CHECK, CABIN FLOOR PANEL PUNCTURED. REPLACED PANEL. (M)SDR ASAA0580177Floor Panel · puncturedOKC - FOUND DURING C-CHECK, CABIN FLOOR PANEL PUNCTURED. REPLACED PANEL. (M)SDR ASAA0580176Floor Panel · delaminatedOKC - FOUND DURING C-CHECK, FLOOR PANEL DELAMINATED. REPLACED PANEL. (M)SDR ASAA0580175Floor Panel · delaminatedOKC - FOUND DURING C-CHECK, CABIN FLOOR PANEL DELAMINATED. REPLACED PANEL. (M)SDR ASAA0580174Floor Panel · brokenOKC - FOUND DURING C-CHECK, CABIN FLOOR PANEL BROKEN. REPLACED PANEL. (M)SDR UPS05844368Floorboard · corrodedINSPECTION TYPE:C1 MAIN CABIN FLOORBOARD CORRODED AT STA 70 TO 140 RBL 55. REMOVED CORROSION AND INSTALLED DOUBLER IAW SRM 51-1-8 AND 51-1-21.SDR AWXA200500522Floor Panel · corrodedSAL - MAJOR REPAIR - DURING C-08 CHECK, GALVANIC CORROSION WAS FOUND ON FORWARD CARGO COMPARTMENT FLOOR PANEL 132FF. MAINTENANCE REMOVED FORWARD CARGO COMPARTMENT FLOOR PANEL 132FF; FABRICATED A NEW REPLACEMENT FLOOR PANEL AND DOUBLER; INSTALLED REPAIRED PARTSDR AWXA200500521Floor Panel · corrodedSAL - MAJOR REPAIR - DURING C-08 CHECK, GALVANIC CORROSION WAS FOUND ON FORWARD CARGO COMPARTMENT FLOOR PANEL 131JF. MAINTENANCE REMOVED FORWARD CARGO COMPARTMENT FLOOR PANEL 131JF; FABRICATED A NEW REPLACEMENT FLOOR PANEL AND DOUBLER; INSTALLED REPAIRED PARTSDR AWXA200500520Floor Panel · corrodedSAL - MAJOR REPAIR - DURING C-08 CHECK, CORROSION WAS FOUND ON FORWARD CARGO COMPARTMENT FLOOR PANEL 132JF. MAINTENANCE REMOVED FORWARD CARGO COMPARTMENT FLOOR PANEL 132JF; FABRICATED A NEW REPLACEMENT FLOOR PANEL AND DOUBLER; INSTALLED REPAIRED PARTS IAW AWASDR 2005UALA00276Pressure Panel · crackedLEFT STA 664 PRESSURE DECK WEB IS CRACKED AT APPROXIMATELY LBL 30 JUST FWD OF OUTBOARD AILERON TOWER SHAFT. MAJOR REPAIR ACCOMPLISHED. CUT OUT CRACK, FABRICATED AND INSTALLED A DOUBLER REPAIR.SDR USAA050446Floor Panel · corrodedBFM - FOUND FLOOR PANEL CORRODED GREATER THAN 10 PERCENT, HEAT FLOOR PANEL AT L2. FABRICATED NEW FLOOR PANEL PER TYPICAL REPAIR 53-002-01. (M)SDR VTZA200500021Floor Panel · crackedCARGO LANDING PLATE IS CRACKED AT RIVETS ATTACHING IT TO THE INTERCOSTALS.SDR SIMA200509108Doubler · corrodedDURING MBV INSPECTION FOUND FORWARD CABIN FLOOR DOUBLER AT FRAME 22 CORRODED AROUND NUTPLATE. INSTALLED NEW DOUBLER AT FRAME 22 IAW SRM. AC RETURNED TO SERVICE. (SW21200504818) (K)SDR SIMA200509107Doubler · corrodedDURING MBV INSPECTION, FOUND FWD CABIN FLOOR DOUBLER AT FRAME 20 CORRODED AROUND AFT NUTPLATE. INSTALLED NEW DOUBLER AT FRAME 20 IAW SRM 51-40-02. AC RETURNED TO SERVICE. (SW21200504818) (K)SDR USAA050434Floor Panel · corrodedBFM - FOUND FLOOR PANEL DELAMINATED AND CORRODED GREATER THAN 10 PERCENT, MAIN CABIN HEATED FLOOR PANEL 272 KF. FABRICATED NEW FLOOR PANEL. (M)SDR USAA050433Floor Panel · corrodedBFM - FOUND FLOOR PANEL DELAMINATED AND CORRODED, MAIN CABIN HEATED FLOOR PANEL 271JF. FABRICATED NEW FLOOR PANEL PER TYPICAL REPAIR 53-02-01. (M)SDR USAA050441Floor Panel · corrodedBFM - FOUND FLOOR PANEL DELAMINATED AND CORRODED MORE THAN 10 PERCENT, MAIN CABIN HEATED FLOOR PANEL 271KF. FABRICATED NEW FLOOR PANEL PER TYPICAL REPAIR 53-02-01. (M)SDR USAA050435Floor Panel · delaminatedBFM - FOUND FLOOR PANEL DELAMINATED AND CORRODED GREATER THAN 10 PERCENT, MAIN CABIN HEAT FLOOR PANEL 272JF. FABRICATED NEW FLOOR PANEL PER TYPICAL REPAIR 53-02-01. (M)SDR ASAA0580169Floorboard · corrodedHV-CHECK - PAX CABIN FLOOR PANEL IS WATER DAMAGED AND HAS CORRODED FASTENERS. REPLACED FLOOR PANEL. (K)SDR ASAA0580165Floorboard · delaminatedHV - CHECK - PAX CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (K)SDR ASAA0580164Floor Panel · delaminatedHV - CHECK - PAX CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (K)SDR ASAA0580166Floorboard · delaminatedHV - CHECK - PAX CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (K)SDR ASAA0580168Floorboard · delaminatedHV - CHECK - PAX CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (K)SDR ASAA0580167Floorboard · delaminatedHV- CHECK - PAX CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (K)SDR ASAA0580163Floorboard · delaminatedHV - CHECK - PAX CABIN FLOOR PANEL IS DELAMINATED AND CRACKED. REPLACED FLOOR PANEL. (K)SDR ASAA0580146Floorboard · crackedC-CHECK - CABIN FLOOR PANEL HAT SECTION IS CRACKED. REPLACED HAT SECTION. (K)
Back to JASC 5321