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 ASAA0480014Floor Panel · crackedOKC - DURING HV-1 CHECK, FOUND CABIN FLOOR PANEL HAT CHANNEL CRACKED AT FS 617-693. REPLACED CHANNEL PER SRM 51-10-4 AND 51-10-3. (M)SDR ASAA0480013Floor Panel · crackedOKC - DURING HV-1 CHECK, FOUND CABIN FLOOR PANEL CRACKED IN HAT CHANNELS AT FS 796-826. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480005Floor Panel · delaminatedOKC - DURING HV-1 CHECK, FOUND CABIN FLOOR PANEL DELAMINATED AT FS 826-864. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480017Floor Panel · crackedDURING HV-1 CHECK, FOUND CABIN FLOOR PANEL IS CRACKED ON UNDERSIDE AT FS 674-693. REPLACED CHANNEL PER SRM 53-05. (M)SDR ASAA0480016Floor Panel · crackedDURING HV-1 CHECK, FOUND CABIN FLOOR PANEL HAS CRACKED INSERT AT FS 196-256. REPLACED CHANNEL PER SRM 53-05. (M)SDR ASAA0480015Floor Panel · debondedOKC - DURING HV-1 CHECK, FOUND CABIN FLOOR PANEL IS DISBONDING AND HAS CORRODED FASTENERS AT FS 196-256. REPLACED CHANNEL PER SRM 53-05. (M)SDR GTIA040069Floorboard · crackedFTW - FOUND CORROSION ON FLOORBOARD STATION 826 TO 1003 RBL 44 TO 54. UPON FURTHER INVESTIGATION CRACK FOUND AROUND SCREW HOLE. FABRICATED DOUBLER AND REMOVED CRACK. INSTALLED DOUBLER AND FILLER. (M)SDR GTIA040122Floor Panel · debondedFTW - FOUND COCKPIT FLOOR PANEL FOR CONSOLE SKIN IS DEBONDED AND MISSING. REBONDED SKIN. (M)SDR GTIA040236Floor Panel · delaminatedFTW - FOUND LEFT FLOOR PANEL STATION 200-256 DELAMINATED AND TWO EACH INSERTS MISSING. FABRICATED NEW PANEL. (M)SDR GTIA040083Floorboard · delaminatedFTW - FOUND CABIN FLOORBOARD STATION 1200, RBL 24-44 PEELING FIBERGLASS 349. REQUIRES EDGE FILLER. FABRICATED NEW CABIN FLOORBOARD. (M)SDR GTIA040077Floor Panel · damagedFTW - FOUND FLOOR PANEL STATION 320-370 EDGES SPLIT-CRUSHED. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040126Floor Panel · delaminatedFTW - FOUND CENTER FLOOR PANEL STATION 927 DELAMINATED AND DAMAGED EDGE FILLER. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040109Floor Panel · crackedFOUND CENTER FLOOR PANEL STATION 800 BOTTOM LEFT AND RIGHT SUPPORT STIFFENERS CRACKED IN SEVERAL AREAS. REMVOED AND REPLACED SUPPORT STIFFENERS. (M)SDR GTIA040108Floor Panel · damagedFTW - FOUND LEFT CAPTAIN FLOOR PANEL BRACKET MISSING AND BOTTOM STIFFENERS DETACHED. REATTACHED BOTTOM STIFFENERS. INSTALLED NEW BRACKET. (M)SDR GTIA040104Floorboard · peelingFTW - FOUND CABIN FLOORBOARD RIGHT AFT STATION 1307 PEELING FIBERGLASS. REQUIRES EDGE FILLER. FABRICATED NEW CABIN FLOORBOARD. (M)SDR GTIA040111Floor Panel · crackedFTW - FOUND CENTER FLOOR PANEL STATION 860 UPPER DOUBLER CRACKED AND BOTTOM LEFT AND RIGHT STIFFENERS CRACKED IN SEVERAL AREAS. REPLACED UPPER DOUBLER BOTTOM LEFT AND RIGHT STIFFENERS. (M)SDR GTIA040121Floor Panel · delaminatedFTW - FOUND RIGHT OUTBOARD FLOOR PANEL STATION 120 DELAMINATED AND THREE DAMAGED INSERTS. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040164Floor Panel · deterioratedFTW - FOUND FLOOR PANEL STATION 1079-1155 DETERIORATING. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040099Floor Panel · delaminatedFTW - FOUND FLOOR PANEL STATION 1150-1250 LEFT, MISSING BROKEN INSERTS NO EDGE SEAL. UPON FURTHER EVALUATION FOUND PANEL AT STATION 1150-1250 TO BE DELAMINATED. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040085Floor Panel · damagedFTW - FOUND FLOOR PANEL METAL EDGES BENT, CRACKED, WORN THROUGH. NO EDGE SEAL. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040079Floor Panel · crackedFTW - FOUND FLOOR PANEL HAS CORROSION AT EDGES AND FAST HOLES, END OF STIFFENER CRACKED. STOP DRILLED CRACK. FABRICATED REPAIR. INSTALLED REPAIR. (M)SDR GTIA040068Floor Panel · deterioratedFTW - FOUND FLOOR PANEL STATION 1225 LEFT DETERIORATING NO EDGE SEAL. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040057Floorboard · delaminatedFTW - FOUND BROKEN INSERT AND DELAMINATION, CABIN FLOORBOARD FS 1140. FABRICATED NEW FLOORBOARD. (M)SDR GTIA040103Floor Panel · corrodedFTW - FOUND FLOOR PANEL FS 1174 RBL 24-44 CORRODED AND TOP PRIMER REQ'D. FABRICATED FLOOR PANEL. (M)SDR GTIA040075Support · crackedFTW - FOUND CABIN FLOOR PANEL STATION 1174-1250 HAS CRACKED FLOOR SUPPORT. REPAIRED CRACKED FLOOR SUPPORT ON FLOOR PANEL. (M)SDR GTIA040054Floorboard · damagedFTW - FOUND CABIN CENTER FLOORBOARD FS 598 TO 636, INSERT BROKEN AND MATERIAL PEELING. FABRICATED NEW FLOORBOARD. (M)SDR GTIA040123Doubler · missingFTW - FOUND FLOOR PANEL OUTBOARD STATION 927 DOUBLER MISSING ON PANEL EDGE. FABRICATED NEW DOUBLER. INSTALLED DOUBLER. (M)SDR GTIA040107Floor Panel · damagedFTW - FOUND FLOOR PANEL RIGHT OUTBOARD STATION 927 STIFFENER DETACHED AND CENTER STIFFENER 3 AREAS OF INCORRECT REPAIRS. REMOVED DAMAGED STIFFENER. FABRICATED NEW STIFFENER. INSTALLED NEW STIFFENER. (M)SDR GTIA040112Floor Panel · damagedFTW - FOUND FLOOR PANEL OUTBOARD STATION 800 STIFFENER DEATTACHED IN 2 AREAS. REBONDED STIFFENER. (M)SDR GTIA040097Floorboard · delaminatedFTW - FOUND LEFT FLOORBOARD STATION 1136-1193 DELAMINATED AND INSERTS CORRODED. FABRICATED NEW LEFT FLOORBOARD. (M)SDR GTIA040084Floorboard · crackedFTW - FOUND SCREW HEAD PULLED THROUGH FLOORBOARD STATION 250 LBL 44, AND PANEL CRACKED AT HOLE. STOP DRILLED CRACK. FABRICATED REPAIR DOUBLER. INSTALLED REPAIR DOUBLER. (M)SDR GTIA040090Floorboard · delaminatedFTW - FOUND CABIN FLOORBOARD LEFT AFT FS 1257 SURFACE DELAMINATED MISSING INSERT. FABRICATED NEW CABIN FLOORBOARD. (M)SDR GTIA040086Floorboard · damagedFTW - FOUND RIVETS PULLED THROUGH FLOORBOARD STATION 826 LBL 44 TO 54. UPON FURTHER INVESTIGATION FLOORBOARD STATION 826 LBL 44 TO 54 FOUND TO HAVE NUMEROUS BLOWN OUT HOLES, CRACKS, AND DELAMINATION. FABRICATED NEW FLOORBOARD. (M)SDR GTIA040058Floorboard · delaminatedFTW - FOUND COCKPIT CENTER FLOORBOARD, BROKEN INSERTS AND SIDE DELAMINATIONS. FABRICATED NEW COCKPIT CENTER FLOORBOARD. (M)SDR GTIA040100Floor Panel · corrodedFTW - FLOOR PANEL UNDER F/O SEAT CORROSION AND GOUGE IN UPPER SURFACE. BROKEN TRIM SUPPORT. DISBONDED INNER SIDE STRIPS. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA040073Floorboard · crackedFTW - FOUND CABIN FLOORBOARD FORWARD LAVATORY STATION 200-256 CRACKED IN SEVERAL AREAS. COMPOSITE SUPPORT CRACKED ON AFT END. REPAIRED CABIN FLOORBOARD. (M)SDR GTIA040024Floorboard · damagedFTW - FOUND CABIN FLOORBOARD, RIGHT STATION 767-787 HAS MISSING EDGE FILLER, DAMAGED INSERTS, PEELING FIBERGLASS. FABRICATED NEW CABIN FLOORBOARD. (M)SDR GTIA040019Floorboard · damagedFTW - FOUND CABIN CENTER FLOORBOARD STATION 200-256, MISSING INSERTS, EDGE FILLER MISSING, PEELING FIBERGLASS. FABRICATED NEW CABIN CENTER FLOORBOARD. (M)SDR GTIA040018Floorboard · crackedFTW - FOUND FLT COMP, FLOORBOARD DIRECTLY BEHIND CAPTAINS SEAT IS CRACKED. CUT OUT DAMAGE. FABRICATED DOUBLER AND FILLER. INSTALLED DOUBLER AND FILLER. UPON FURTHER INVESTIGATION FOUND FIBERGLASS DOUBLERS SEPERATE. RECEMENTED FIBERGLASS DOUBLERS. (M)SDR GTIA040096Floorboard · delaminatedFTW - FOUND CABIN FLOORBOARD, RIGHT, OUTBOARD STATION 160-200 MISSING EDGE FILLER, PEELING FIBERGLASS. FABRICATED NEW CABIN FLOORBOARD. (M)SDR GTIA040089Floorboard · delaminatedFTW FOUND CABIN FLOORBOARD, RIGHT INBOARD STATION 180-200 SEVERAL INSERTS MISSING. PEELING FIBERGLASS REQUIRES EDGE FILLER. FABRICATED NEW CABIN FLOORBOARD. (M)SDR GTIA040059Floorboard · damagedFTW - FOUND CABIN FLOORBOARD, RIGHT STATION 197-229, DAMAGED INSERTS, MISSING EDGE FILLER, PEELING FIBERGLASS. FABRICATED NEW FLOORBOARD. (M)SDR GTIA040102Floorboard · damagedFTW - FOUND RIGHT CABIN FLOORBOARD STATION 200-256 MISSING FASTENERS NEEDS EDGE FILLER PEELING FIBERGLASS. FABRICATED NEW RIGHT CABIN FLOORBOARD. (M)SDR GTIA040020Floorboard · peelingFTW - FOUND CABIN FLOORBOARD LEFT OUTBOARD STATION 160-200 MISSING EDGE FILLER, PEELING FIBERGLASS. FABRICATED NEW CENTER CABIN FLOORBOARD. (M)SDR GTIA040022Floorboard · peelingFTW - FOUND CABIN FLOORBOARD ENTRY WAY STATION 160-200 EXPOSED HONEYCOMB ON UPPER FACE, PEELING FIBERGLASS. FABRICATED NEW CABIN FLOORBOARD. (M)SDR GTIA040101Floor Panel · corrodedGTIA - FOUND COCKPIT FLOOR PANEL 4411C CORRODED, CRACKED. BONDED CRACKED AREA. (M)SDR CALA0300727Floor Panel · crackedREMOVED AFT LAV WEBS TO FACILITATE REPAIR OF APB. REMOVED AND REPLACED WEBS PER SRM 51-10-02. CRACKED 2 X 5 INCH.SDR 03FDEA02335Floor Panel · corrodedMAIN DECK FLOOR PANEL 233VF FOUND TOP SURFACE WITH CORROSION. FLOOR PANEL 233VF REMOVED AND REPLACED AS PER MM 53-21-04-4.SDR 03FDEA02334Floor Panel · corrodedFLOOR PANEL 232PF FOUND TOP SURFACE CORROSION. DAMAGED FLOOR PANEL NR 232PF REMOVED AND REPLACED AS PER MM 53-21-04-4.SDR 03FDEA02333Floor Panel · corrodedFLOOR PANEL 231PF FOUND TOP SURFACE WITH CORROSION. DAMAGED FLOOR PANEL NR 231PF REMOVED AND REPLACED AS PER MM 53-21-04-4.
Back to JASC 5321