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 ASAA0380071Floor Panel · corrodedOKC - FOUND DURING C-CHECK, FLOOR PANEL CORRODED IN AFT CARGO BAY. REPLACED PANEL PER SRM 51-10-2 AND 51-10-3. (M)SDR GTIA030010Floor Panel · deterioratedFTW - FOUND CABIN FLOOR PANEL AFT AUX TANK AFT CENTER HAS SOFT/MUSHY/DETERIORTATION. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA030009Floor Panel · deterioratedFTW - FOUND CABIN FLOOR PANEL, AFT AUX TANK, FORWARD CENTER HAS SOFT/DETERIORATED. FABRICATED NEW FLOOR PANEL. (M)SDR ASA0380065Floor Panel · puncturedFOUND DURING 30K CHECK, FORWARD CARGO BAY FLOOR PANEL IS PUNCTURED AND FS 330-370. REPLACED SECTION OF FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0380046Floor Panel · delaminatedOKC - FOUND DURING 30K CHECK, AFT CARGO BAY FLOOR PANEL UPPER SKIN IS DISBONDED. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0380045Floor Panel · damagedOKC - FOUND DURING 30K CHECK, MID CARGO BAY FLOOR PANEL HAS DAMAGED EDGE. REPLACED PANEL PER SRM 53-05 AND 51-10-4. (M)SDR ASAA0380044Floor Panel · damagedOKC - FOUND DURING 30K CHECK, MID CARGO BAY FLOOR PANEL HAS DAMAGED EDGE. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0380043Floor Panel · damagedOKC - FOUND DURING 30K CHECK, MID CARGO BAY FLOOR PANEL HAS DAMAGED EDGE. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0380042Floor Panel · puncturedOKC - FOUND DURING 30K CHECK, AFT CARGO BAY FLOOR PANEL IS PUNCTURED. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0380041Floor Panel · corrodedOKC - FOUND DURING 30K CHECK, AFT CARGO BAY FLOOR PANEL IS CORRODED. REPLACED PANEL IS SRM 51-10-4. (M)SDR ASAA0380039Floor Panel · puncturedOKC - FOUND DURING 30K CHECK, FORWARD CARGO BAY FLOOR PANEL PUNCTURED AT FS 427-465. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0380035Floor Panel · crackedOKC - FOUND DURING 30K CHECK, COCKPIT LEFT SIDE FORWARD FLOOR PANEL IS CRACKED. REPAIRED CRACK PER MM 25-00-00, 3E. (M)SDR ASAA0380019Floorboard · tornOKC - FOUND DURING 30K CHECK, FLOORBOARD TORN AT FOUR FASTENER HOLES AT FS 886-927. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380018Floor Panel · damagedOKC - FOUND DURING 30K CHECK, MID CARGO BAY FLOOR PANEL EDGE DAMAGED AT FS 636-693. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0380017Floor Panel · damagedOKC - FOUND DURING 30K CHECK, MID CARGO BAY FLOOR PANEL EDGE DAMAGED AT FS 693-730. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0380015Floor Panel · puncturedOKC - FOUND DURING 30K CHECK, AFT CARGO BAY FLOOR PANEL IN PUNCTURED AT FS 1117-1155. REPLACED PANEL PER SRM 53-05. (M)SDR GTIA021379Floorboard · corrodedFTW - FOUND CABIN FLOORBOARD STATION 693-769 LEFT HAS CORROSION AND LOOSE TORN INSULATION. REMOVED OLD SKIN. FABRICATED NEW SKIN. INSTALLED NEW SKIN. (M)SDR GTIA021378Floor Panel · corrodedFTW - FOUND CABIN FLOOR PANEL STATION 796-826 LEFT OUTBOARD HAS CORROSION. INSTALLED NEW SKIN PANEL. (M)SDR GTIA021351Floor Panel · deterioratedFTW - FOUND CABIN FLOOR PANEL STATION 769-826 LEFT DETERIORATING, MISSING INSERT. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA021350Floor Panel · corrodedFTW - FOUND CABIN FLOOR PANEL STATION 693-769 LEFT, DENTED AND CORRODED. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA021349Floor Panel · crackedFTW - FOUND FLOOR PANEL STATION 1079-1155 LEFT INBOARD HAS CRACK/SOFT CORROSION AT INSERTS AND ELONGATED HOLES. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA021381Floor Panel · crackedFTW - FOUND FLOOR PANEL STATION 1271-1309, RIGHT SIDE INBOARD HAS CRCKED/DAMAGED AT BOTTOM PANEL. FABRICATED NEW PANEL. (M)SDR GTIA021380Floor Panel · corrodedFTW - FOUND CENTER FLOOR PANEL STATION 1271 TO STATION 1309 HAS CRACKED, SOFT/MUSHEY, CORRODED AT INSERTS ELONGATED HOLES. DRILLED AND LOCATED NEW PANEL. (M)SDR ASAA0280698Floor Panel · delaminatedOKC - FOUND DURING 30K CHECK, FLOOR PANEL DELAMINATED AT FS 1146-1250. REPLACED FLOOR PANEL PER SRM 53-24-0 AND 53-05. (M)SDR ASAA0280697Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOOR PANEL HAS CORRODED INSERTS AT FS 1071-1155. REPLACED FLOOR PANEL WITH NEW INSERTS PER SRM 53-24-0 AND 53-05. (M)SDR ASAA0280694Rib · wornOKC - FOUND DURING 30K CHECK, FLOOR PANEL RIB WORN IN 6 PLACES AT FS 1003-1098. REPLACED DAMAGED SECTION PER SRM 51-70-5, 53-24-0, AND 51-60-0. (M)SDR ASAA0280693Rib · crackedOKC - FOUND 30K CHECK, FLOOR PANEL HAS A CRACKED RIB AT FS 465-541. CUT OUT AND REPLACED DAMAGED SECTION PER SRM 51-70-5, 53-24-0, AND 51-60-0. (M)SDR ASAA0280691Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOOR PANEL HAS CORRODED INSERTS AT FS 200-256. REPLACED PANEL WITH NEW INSERTS PER SRM 53-24-0 AND 53-05. (M)SDR ASAA0280689Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOOR PANEL INSERTS ARE CORRODED AT FS 200-256. REPLACED PANEL WITH NEW INSERTS PER SRM 53-24-0 AND 53-05. (M)SDR ASAA0280688Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOOR PANEL INSERTS ARE CORRODED AT FS 180-200. REPLACED PANEL WITH NEW INSERTS PER SRM 53-24-0 AND 53-05. (M)SDR ASAA0280687Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOOR PANEL INSERTS ARE CORRODED AT FS 160-180. REPLACED PANEL WITH NEW INSERTS PER SRM 53-24-0 AND 53-05. (M)SDR ASAA0280686Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOOR PANEL INSERTS ARE CORRODED AT FS 160-200. REPLACED PANEL WITH NEW INSERTS PER SRM 53-24-0 AND 53-05. (M)SDR ASAA0280685Insert · corrodedOKC - FOUND DURING 30K CHECK, AFT SERVICE L-2 DOOR EMERGENCY SLIDE GIRT BAR FITTING INSERTS ARE CORRODED. REPLACED FOUR INSERTS PER SRM 51-30-1. (M)SDR GTIA021358Floor Panel · crackedFTW - FOUND AT FS 795 LB2 44A CRACK IN FLOOR WEB 2 INCHES LONG FROM EOP TO LIGHTENING HOLE, AT FS 795 LBL 44 A PIECE OF FLOOR WEB 1 INCH BY .500 INCH MISSING, AT FS 800 LBL 44 A TOOL MARK OF .75 INCH BY .75 INCH WITH HOLE IN WEB. REMOVED DAMAGED AREAS. FABRISDR GTIA021348Floor Panel · deterioratedFTW - FOUND CENTER FLOOR PANEL STATION 1309 TO STATION 1338 HAS SOFT/MUSHEY DETERIORATED, LOCATED AND DRILLED. (M)SDR GTIA021347Floor Panel · dentedFTW - FOUND LEFT INBOARD FLOOR PANEL STATION 1271 TO STATION 1309 INBOARD FACE HAS DENTED/DAMAGES AND CRACKED SEVERAL AREAS. FABRICATED PANEL. (M)SDR GTIA021382Floor Panel · corrodedFTW - FOUND AFT PIT FLOOR PANEL STATION 1007-1155 DELAMINATED AND CORROSION. FABRICATED NEW FLOORBOARD. (M)SDR GTIA021357Floor Panel · corrodedFTW - FOUND FORWARD CABIN FLOOR WEB STATION 200-218 CORRODED. FABRICATED NEW WEB. (M)SDR GTIA021383Floorboard · corrodedFTW - FOUND CABIN FLOORBOARD STATION 927-1300 BENT, TORN, CORRODED. FABRICATED NEW FLOORBOARD. (M)SDR ASAA0280683Floorboard · damagedOKC - FOUND DURING 30K CHECK, FLOORBOARD HAS ONE PUNCTURE, ONE DENT, AND DISBONDING AT ENDS OF LOWER STIFFENER AT FS 826-927. INSTALLED DOUBLERS ON LOWER STIFFENER AND REBONDED ENDS PER SRM 51-70-2 AND 53-05. (M)SDR ASAA0280682Floorboard · damagedOKC - FOUND DURING 30K CHECK, FLOORBOARD HAS ONE PUNCTURE, 50 DENTS, AND DISBONDING AT BOTH ENDS OF LOWER STIFFENERS AT FS 825. INSTALLED DOUBLERS ON LOWER STIFFENER PER SRM 51-70-2 AND 53-05. (M)SDR ASAA0280676Floorboard · tornOKC - FOUND DURING 20K CHECK, FLOORBOARD HAS TORN METAL AT 'W' SANDWICH EXTRUSION AT FS 826-886. REPLACED SUPPORT SECTION PER SRM 51-30-8, 51-20-0, AND 51-10-4. (M)SDR ASAA0280675Floorboard · tornOKC - FOUND DURING 30K CHECK, FLOORBOARD HAS TORN METAL AT 'W' SANDWICH EXTRUSION AT FS 886-946. REPLACED SUPPORT SECTION PER SRM 51-30-8, 51-20-0, AND 51-10-4. (M)SDR ASAA0280673Floor Panel · crackedOKC - FOUND DURING 30K CHECK, FLOOR PANEL IS PUNCTURED AT FS 1003-1071. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0280672Floor Panel · crackedOKC - FOUND DURING 20K CHECK, FLOOR PANEL CRACKED AT OUTBOARD SIDE FS 465-541. REPLACED FLOOR PANEL PER SRM 51-70-5, 51-60-0 AND 53-24-0. (M)SDR GTIA021346Floor Panel · deterioratedFTW - FOUND CABIN FLOOR PANEL STATION 927-1003 DETERIORATED, DRILLED AND LOCATED. (M)SDR GTIA021385Floorboard · brokenFTW - FOUND CABIN FLOORBOARD STATION 886-946 CENTER, BROKEN OUT INSERTS, CORROSION ON METAL SUPPORTS. FABRICATED PANEL. (M)SDR GTIA021384Floorboard · corrodedFTW - FOUND CABIN FLOORBOARD STATION 826-886, DETERIORATED, METAL SUPPORTS HAVE GOUGES, CORROSION, TORN. FABRICATED NEW FLOORBOARD. (M)SDR GTIA021367Floorboard · corrodedFTW - FOUND CABIN LEFT OUTBOARD FLOORBOARD STATION 807-916, HAS CORROSION ELONGATED HOLES, TORN INSULATION, BENT CORNERS. REMOVED OLD SKIN. FABRICATED NEW SKIN. INSTALLED NEW SKIN. (M)SDR ASAA0280671Floorboard · crackedOKC - FOUND DURING 30K CHECK, FLOORBOARD SKIN CRACKED AT FS 212. REPLACED FLOORBOARD SECTION PER SRM 53-05. (M)
Back to JASC 5321