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 AWXA200300302Floor Panel · debondedDURING C-03 CHECK THE UPPER SURFACE OF CABIN FLOOR PANEL WAS FOUND DISBONDED FROM BS 2723, FR 58, TO BS 2936, FR 62. MAINTENANCE PERFORMED BOND REPAIR ON UPPER SURFACE OF CABIN FLOOR PANEL BS 2723, FR 58, TO BS 2936, FR 62 IAW A320 SRM 53-02-00, PG. 203-207, FSDR GTIA030230Floorboard · deterioratedFTW - FOUND PASSENGER CABIN CENTER FLOOR PANEL STATION 541-579 HAS SOFT/DETERIORATED. FABRICATED NEW FLOORBOARD. (M)SDR GTIA030229Floorboard · deterioratedFTW - FOUND PASSENGER CABIN STATION 1003 TO STATION 1079 CENTER FLOOR PANEL HAS SOFT/MUSHEY, DETERIORATED. FABRICATED NEW FLOORBOARD. (M)SDR GTIA030228Floorboard · crackedFTW - FOUND PASSENGER CABIN RIGHT SIDE STAITON 541 TO STATION 617 FLOOR PANEL CRACKED/DAMAGED AT CORNER/INSERTS BROKEN OUT. REPAIRED FLOOBOARD. (M)SDR GTIA030142Floor Panel · crackedAFT PIT CRACKED FLOOR WEB AT FS1289-1309 LONG 18R. FAB DOUBLER. INSTALLED DOUBLER.SDR GTIA030141Floor Panel · damagedCABIN FLOOR PANEL STA 826-864 DELAMINATED, BENT, PUNCTURED. FABRICATED NEW FLOOR.SDR GTIA030140Floorboard · deterioratedMAIN CABIN STA 807 TO STA 826 CENTER FLOORBOARD HAS SOFT/ MUSHY AND DETERIORATED. FABRICATED NEW FLOORBOARD.SDR GTIA030152Floorboard · deterioratedFORWARD CABIN STA 200 TO STA 160 LBL 8 INCHES TO 44 INCHES (40X36) HAS SOFT/MUSHEY DETERIORATED AND INSERTS CORR. FABBED NEW CABIN FLOORBOARD STA 200-160 LBL 8 LBL 44.SDR GTIA030150Floorboard · deterioratedFORWARD CABIN STA 200 TO STA 256 (7X56) LBL 15 INCHES FLOOR PANEL SOFT/MUSHEY DETERIORATED CORR INSERTS. FABRICATED NEW FLOOR BOARD.SDR GTIA030172Floorboard · damagedFLOORBOARD DAMAGED STA 1079-1146 LT. DRILL AND LOCATE.SDR 2003UALA00255Floor Panel · damagedCABIN PRESSURE DECK FLOOR HAS EXCESS MATERIAL LOSS AT STA 1681, RBL 43 AND RBL 52. MAJOR REPAIR ACCOMPLISHED. DOUBLER APPLIED.SDR ASAA0380226Floorboard · corrodedOKC - DURING 30K CHECK, FOUND MID CARGO FLOORBOARD PUNCTURED AND CORRODED AT FASTENER HOLES. REPLACED FLOOR PANEL PER SRM. (M)SDR GTIA030176Floor Panel · crackedPAX CABIN CENTER FLOOR PANEL STA 946 TO STA 1003 CRACKED/ DAMAGED SEVERAL INSERTS BROKEN OUT. DRILL AND LOCATE.SDR GTIA030175Floorboard · crackedPAX CABIN LT SIDE INBOARD STA 927 TO STA 1003 FILLER PNL CRACKED & DAMAGED. FLOORBOARD FAB.SDR GTIA030171Floor Panel · crackedPAX CABIN LT SIDE INBOARD STA 886 TO STA 926, FLOOR PANEL CRACKED. FABRICATED FLOORBOARD.SDR MWEA030126Floorboard · dentedFLOORBOARED BETWEEN SEAT TRACKS #3 AND #4 AT STATION 1147 IS DENTED. -- REPAIRED DENT.SDR MWEA03127Floor Panel · cutLARGE CABIN CENTER FLOOR PANEL LOCATED FROM FRAME STATION 200 TO 229 BETWEEN #2 AND #3 SEAT TRACK HAS A CUT IN TOP SURFACE AT FORWARD END. -- REPAIRED PANEL.SDR ASAA0380212Floor Panel · crushedOKC - DURING 30K CHECK, FOUND FLOOR PANEL HAS CRUSHED AREA AT FS 259-313. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0380206Floor Panel · brokenOKC - FOUND DURING 30K CHECK, FLOOR PANEL HAS BROKEN END AT FS 924-1004. BONDED DAMAGED AREA WITH FIBERGLASS CLOTH AND EPON 828 RESIN PER SRM 51-70-3. (M)SDR ASAA0380203Floor Panel · corrodedOKC - DURING 30K CHECK, FLOOR PANEL IS CORRODED AT FS 148-200. REPLACED PANEL PER SRM 53-01. (M)SDR ASAA0380213Floor Panel · damagedOKC - DURING 30K CHECK, FOUND FLOOR PANEL HAS SEVERAL LOOSE OR MISSING INSERTS AT FS 1155-1250. REPLACED PANEL PER SRM 53-05. (M)SDR GTIA030182Floor Panel · damagedFLOOR PANEL BETWEEN AFT LAVS HAS HOLE PUNCTURE. ALSO HAS DAMAGED INSERTS AND MISSING CORE. FABRICATED NEW PANEL.SDR ASAA0380185Floor Panel · crackedOKC - DURING 30K CHECK, FOUND MID CARGO BAY CENTER FLOOR PANEL ATTACH ANGLE IS CRACKED. REPLACED ATTACH ANGLE PER SRM 51-10-2 AND 30-2. (M)SDR CALA0300082Pressure Panel · crackedINSPECTION FOUND A .5 INCH CRACK IN PRESSURE DECK WEB AT STA 664, RBL 30. REPAIRED PRESSURE WEB IAW SRM 53-60-51.SDR ASAA0380171Floor Panel · brokenOKC - DURING 30K CHECK, FOUND FLOOR PANEL HAS BROKEN INSERTS AT FS 200-256. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0380183Skin · crackedOKC - DURING 30K CHECK, FOUND RIGHT FLOOR PANEL UPPER SKIN IS CRACKED AT AFT FASTENER HOLE. INSTALLED DOUBLER PER SRM 53-05. (M)SDR ASAA0380182Floor Panel · wornOKC - DURING 30K CHECK, FOUND RIGHT FLOOR PANEL UPPER SURFACE IS WORN TO METAL. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0380181Floor Panel · corrodedOKC - DURING 30K CHECK, FOUND AFT CARGO BAY FLOOR PANEL IS DELAMINATED, PUNCTURED, AND CORRODED ON TOP AND BOTTOM SIDES. REPLACED PANEL PER SRM 51-10-2, 10-3, AND 10-4. (M)SDR ASAA0380177Floor Panel · debondedOKC - DURING 30K CHECK, FOUND CABIN FLOOR PANEL IS MISSING SEVERAL INSERTS REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0380175Floor Panel · gougedOKC - DURING 30K CHECK, FOUND MID CARGO BAY FLOOR PANEL IS GOUGED IN SEVERAL PLACES ALONG EDGE. REPLACED PANEL PER SRM 51-10-2 AND 10-4. (M)SDR ASAA0380174Floor Panel · crackedOKC - DURING 30K CHECK, FLOOR PANEL IS CRACKED AT FS 731-786.5. REPLACED PANEL PER SRM 51-10-2, 10-3, AND 10-4. (M)SDR ASAA0380173Floor Panel · corrodedOKC - FOUND DURING 30K CHECK, FLOOR PANEL IS CORRODED ON UPPER SURFACE AT FS 1022. REMOVED CORROSION AND INSTALLED DOUBLER AND HAT CHANNEL PER SRM 51-30-2 AND 53-05. (M)SDR ASAA0380172Floor Panel · corrodedOKC - DURING 30K CHECK, FOUND FLOOR PANEL HAS CORRODED INSERTS AT FS 1079-1117. REPLACED PANEL PER SRM 53-05. (M)SDR ASAA0310056Floorboard · crackedOKC - DURING D-CHECK, FOUND FLOORBOARD AT BS 255-270, BUTTOCK LINE 0 CRACKED AND CORRODED. REMOVED AND REPLACED FLOORBOARD PER SRM. (M)SDR ASAA0310058Floor Panel · corrodedOKC - DURING D-CHECK, FOUND CARGO PIT FLOOR PANEL ATTACH ANGLE AT BS 947, STRINGER 23L CORRODED. REMOVED AND REPLACED ATTACH ANGLE PER SRM. (M)SDR CALA0300080Pressure Panel · crackedINSPECTION FOUND A 2 INCH CRACK IN PRESSURE DECK AT BS 664, LBL 30. REPAIRED IAW ECRA 5360-01078.SDR ASAA0380167Floor Panel · corrodedOKC - DURING 30K CHECK, FOUND CABIN PANEL HAS CORRODED/MISSING INSERTS AT FS 160-200. REPLACED FLOOR PANEL PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0380166Floor Panel · puncturedOKC - DURING 30K CHECK, FOUND LEFT FLOOR PANEL SURFACE IS PUNCTURED AT FS 408. REPLACED FLOOR PANEL PER SRM 53-20-1, AND 53-05. (M)SDR ASAA0380164Floor Panel · corrodedOKC - DURING 30K CHECK, FOUND CABIN FLOOR PANEL SUPPORT HAT CHANNEL IS CORRODED AT FS 1098-1211. REPLACED SUPPORT PER SRM 51-10-2, 10-3, 10-4 AND 30-1. (M)SDR GTIA030256Floor Panel · corrodedCABIN INTERIOR STA 788-965 LBL 54 FLOOR WEB`S CORRODED IN SEVERAL AREAS. REMOVED DAMAGED AREA. FABBED WEB REPAIR. INSTALLED REPAIR WEB.SDR MWEA030118Floorboard · dentedFLOORBOARD BETWEEN SEAT TRACKS #3 AND #4 AT STATION 750 IS DENTED. -- REPAIRED DENT.SDR MWEA030117Floorboard · dentedFLOORBOARD BETWEEN SEAT TRACK NR 1 AND 2 AT STATION 316 IS DENTED. REPAIRED DENT.SDR MWEA030116Floorboard · dentedFLOORBOARD BETWEEN SEAT TRACKS #1 AND #2 AT STATION 369 IS DENTED. -- REMOVED DAMAGED AREA AND INSTALLED REPAIR.SDR MWEA030115Floorboard · dentedFLOORBOARD BETWEEN SEAT TRACKS #1 AND #2 AT STATION 522 IS DENTED. -- FABRICATED AND INSTALLED DOUBLER AND FILLER.SDR ASAA0380157Floor Panel · brokenOKC - DURING 30K CHECK, FOUND CABIN FLOOR PANEL HAS BROKEN INSERTS. REPLACED DAMAGED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0380155Floor Panel · corrodedOKC - DURING 30K CHECK, FOUND CABIN FLOOR PANEL CORRODED AT INSERTS. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0380154Floor Panel · corrodedOKC - DURING 30K CHECK, CABIN FLOOR PANEL CORRODED AT INSERTS. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR GTIA030187Floor Support · corrodedFORWARD CABIN STA 160 RBL 12 INCHES TO RBL 44 INCHES SUPPORT FLOOR CORRODED. REMOVED FLOOR SUPPORT. FABBED AND INSTALLED NEW FLOOR SUPPORT.SDR GTIA030127Floorboard · damagedFTW - FOUND FORWARD CABIN STATION 160-148 LBL 8 INCHES FLOOR PANEL, BELOW OBSERVER, SOFT/DAMAGE (15 BY 11). FABRICATED NEW CABIN FLOORBOARD. (M)SDR GTIA030126Floorboard · corrodedFTW - FOUND FORWARD CABIN STATION 160 TO STATION 148 RBL 8 INCHES TO 17 INCHES FLOOR PANEL SOFT/MUSHY INSERTS CORRODED/BROKEN OUT. FABRICATED NEW CABIN FLOORBOARD. (M)
Back to JASC 5321