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 ASAA0580145Floorboard · crackedC-CHECK, CABIN FLOOR PANEL HAT SECTION IS CRACKED. REPLACED HAT SECTION. (K)SDR ASAA0580123Floor Panel · delaminatedOKC HV - CHECK - CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (K)SDR ASAA0580122Floor Panel · delaminatedOKC HV-CHECK - CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (K)SDR ASAA0580121Floor Panel · damagedOKC HV-CHECK - CABIN FLOOR PANEL IS FEREL DAMAGED. REPLACED FLOOR PANEL. (K)SDR ASAA0580126Floorboard · delaminatedOKC - HV-CHECK, FOUND CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580124Floorboard · delaminatedOKC - HV-CHK, CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580127Floorboard · delaminatedOKC - HV-CHECK, FOUND CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580125Floorboard · delaminatedOKC - HV-CHECK, CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580131Floorboard · delaminatedOKC - HV-CHECK, CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580130Floorboard · delaminatedOKC - HV-CHECK, CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580129Floorboard · delaminatedOKC- HV-CHECK, FOUND CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580132Floorboard · corrodedHV-CHECK, CABIN FLOOR PANEL HAS CORRODED FASTENERS. REPLACED FLOOR PANEL. (M)SDR ASAA0580128Floorboard · delaminatedOKC - HV-CHECK, CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580115Floorboard · delaminatedOKC - HV-CHECK, FOUND CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580116Floorboard · corrodedOKC - HV-CHECK, FOUND CABIN FLOOR PANEL IS WATER DAMAGED AND HAS CORRODED FASTENERS. REPLACED FLOOR PANEL. (M)SDR ASAA0580120Floor Panel · delaminatedOKC HV-CHECK - CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (NM02200500849) (K)SDR ASAA0580119Floor Panel · delaminatedOKC HV-CHECK - CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (NM02200500849) (K)SDR ASAA0580118Floor Panel · delaminatedOKC HV - CHECK - CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (NM02200500849) (K)SDR ASAA0580117Floor Panel · damagedOKC HV- CHECK - CABIN FLOOR PANEL IS WATER DAMAGED AND HAS CORRODED FASTENERS. REPLACED FLOOR PANEL. (NM02200500849) (K)SDR ASAA0580114Floor Panel · corrodedOKC HV-CHECK - CABIN FLOOR PANEL HAS CORRODED AND CRACKED FASTENERS. REPLACED FLOOR PANEL. (NM02200500849) (K)SDR ASAA0580113Floor Panel · corrodedOKC HV- CHECK FLOOR PANEL HAS CORRODED FASTENERS. REPLACED FLOOR PANEL. (NM02200500849) (K)SDR ASAA0580112Channel · debondedOKC HV - CHECK - CABIN FLOOR PANEL HAT CHANNEL DISBONDED. BOND REPAIRED. (K)SDR ASAA0580111Channel · dentedOKC HV-CHECK - CABIN FLOOR PANEL HAT CHANNEL DENTED. REPLACED CHANNEL. (K)SDR AWXA200500308Floor Panel · corrodedSAL - MAJOR REPAIR - DURING BC-4 CHECK INTERGRANULAR CORROSION WAS FOUND ON FLOOR PANEL AT L-2 DOOR ENTRANCE. MAINTENANCE REMOVED AND REPLACED FLOOR PANEL AT L-2 DOOR ENTRY WAY IAW T/C R1C25306.SDR AWXA200500319Floor Panel · delaminatedSAL - MAJOR REPAIR - DURING BC-4 CHECK FOUND FLOOR PANEL 251RF DELAMINATED. MAINTENANCE REMOVED AND REPLACED FLOOR PANEL 251RF IAW A319 SRM 53-02-00 FIG 209.SDR AWXA200500276Floor Panel · delaminatedMCN - MAJOR REPAIR - DURING 8-DAY CHEC, FOUND AFT GALLEY FLOOR PANEL 261QF DELAMINATED. MAINTENANCE REMOVED DELAMINATED AFT GALLEY FLOOR PANEL 261QF, FABRICATED AND INSTALLED NEW REPLACEMENT FLOOR PANEL IAW DWG D53671754.SDR ASAA0580101Floor Panel · damagedOKC - DURING C-CHECK, FOUND PAX CABIN FLOOR PANEL PEELED. FIBERGLASS BOND REPAIRED. (M)SDR ASAA0580100Floor Panel · delaminatedOKC - DURING C-CHECK, FOUND PAX CABIN FLOOR PANEL DELAMINATED. FIBERGLASS BOND REPAIRED. (M)SDR ASAA0580106Floor Panel · peelingOKC C-CHECK - PAX CABIN FLOOR PANEL PEELED. FIBERGLASS BOND REPAIRED. (K)SDR ASAA0580105Floor Panel · delaminatedOCK C-CHECK - PAX CABIN FLOOR PANEL PEELED. FIBERGLASS BOND REPAIRED. (NM02200500846) (K)SDR ASAA0580104Floor Panel · damagedOKC C-CHECK- PAX CABIN FLOOR PANEL PEELED. FIBERGLASS BOND REPAIRED. (K)SDR ASAA0580103Floor Panel · delaminatedOKC C-CHECK- PAX CABIN FLOOR PANEL DELAMINATED. FIBERGLASS BOND REPAIRED. (NM02200500846) (K)SDR ASAA0580102Floor Panel · delaminatedOKC C-CHECK, PAX CABIN FLOOR PANEL PEELED AND DELAMINATED. FIBERGLASS BOND REPAIRED. (NM02200500846) (K)SDR QXEA200500245Floor Panel · corrodedYYC - FUSELAGE INTERIOR, FLOOR CORROSION AT STATION 280 ALONG TOP FLANGE. REPAIRED IAW CRJ700 REO 670-53-11-047 AND SRM 51-41-00-001-001-A01.SDR QXEA200500248Floorboard · corrodedYYC - FUSELAGE INTERIOR, COCKPIT FLOORBOARD SUPPORT ANGLE AT STATION 280 IS CORRODED. REPAIRED IAW CRJ700 SRM 51-42-06-001-001-A01.SDR USAA050276Floorboard · crackedBFM - FOUND FLOORBOARDS CRACKED WITH 1 INCH CRACKS ON ALL 3 PANELS, FRAME 53.6 BETWEEN L3 AND R3 DOORS, MAIN CABIN FLOOR. FABRICATED 3 NEW FLOORBOARDS PER SRM 53-02-00. (M)SDR USAA050277Floor Panel · crackedBFM - FOUND FLOOR PANEL CRACKED 1 INCH, MAIN CABIN FLOOR PANEL 231BF, UNREPAIRABLE DAMAGE ON UPPER SURFACE. FABRICATED NEW FLOORBOARD PER SRM 53-02-00. (M)SDR ASAA0580084Floor Panel · damagedOKC - DURING C-CHECK, FOUND CABIN FLOORBOARD PANEL IS FRAYING. FIBERGLASS OVERLAY REPAIRED. (M)SDR ASAA0580085Floor Panel · frayedOKC - DURING C-CHECK, FOUND CABIN FLOORBOARD PANEL IS FRAYING. FIBERGLASS OVERLAY REPAIRED. (M)SDR ASAA0580083Floor Panel · frayedOKC - DURING C-CHECK, FOUND CABIN FLOORBOARD PANEL IS FRAYING. FIBERGLASS OVERLAY REPAIRED. (M)SDR ASAA0580052Floor Panel · damagedOKC - DURING C-CHECK, PAX CABIN FLOOR PANEL HAS PULLED STRANDS OF FIBERGLASS. FIBERGLASS BOND REPAIRED. (M)SDR ASAA0580055Floor Panel · brokenOKC - DURING C-CHECK, PAX CABIN FLOOR PANEL HAS BROKEN INSERTS. REPLACED FLOOR PANEL. (M)SDR ASAA0580054Floor Panel · crackedOKC - DURING PAX CABIN FLOOR PANEL HAS TWO CRACKED RIBS. INSTALLED REPAIR HAT CHANNEL AND SPLICE. (M)SDR ASAA0580053Floor Panel · damagedOKC - DURING C-CHECK, PAX CABIN FLOOR PANEL HAS ELONGATED HOLE. INSTALLED REPAIR FILLER AND DOUBLER HAT SECTION AND SPLICE. (M)SDR ASAA0580046Floor Panel · damagedOKC - DURING C-CHECK, PAX CABIN FLOOR PANEL HAS PULLED STRANDS OF FIBERGLASS. REPLACED FLOOR PANEL. (M)SDR ASAA0580048Floor Panel · damagedOKC - DURING C-CHECK, FOUND PAX CABIN FLOOR PANEL HAS PULLED STRANDS OF FIBERGLASS. REPLACED FLOOR PANEL. (M)SDR ASAA0580045Floor Panel · damagedOKC - C-CHECK, PAX CABIN FLOOR PANEL HAS PULLED STRANDS OF FIBERGLASS. REPLACED FLOOR PANEL. (M)SDR ASAA0580057Floor Panel · puncturedOKC - DURING C-CHECK, PAX CABIN FLOOR PANEL PUNCTURED. REPLACED FLOOR PANEL. (M)SDR ASAA0580051Floor Panel · brokenOKC - DURING C-CHECK, PAX CABIN FLOOR PANEL HAS CORRODED AND BROKEN INSERTS. REPLACED FLOOR PANEL. (M)SDR ASAA0580058Floor Panel · delaminatedOKC - DURING C-CHECK, PAX CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (M)
Back to JASC 5321