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 ASAA0580410Floor Panel · corrodedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL HAS CORRODED INSERTS. REPLACED FLOOR PANEL. (M)SDR 05FDEA02027Floor Panel · crackedMAIN DECK FLOOR PANEL 261AH CRACKED. FABBED FLOOR PANEL 261AH ON MAE TRAVELER T5/532924 REF SRZ-25-005 MAJOR REPAIR.SDR 05FDEA02026Floor Panel · crackedMAIN CABIN FLOOR PANEL 241MF CRACKED. FABBED FLOOR PANEL 241MF ON MAE TRAVELER T5/532595 REF SRZ-25-005 MAJOR REPAIR.SDR 05FDEA02025Floor Panel · crackedMAIN CABIN FLOOR PANEL 242MF CRACKED. FABBED FLOOR PANEL 242MF ON MAE TRAVELER T5/532594 REF SRZ-25-005 MAJOR REPAIR.SDR MALA050591Floor Panel · corrodedDURING 4Y/2Y CHECK IN BNA FOUND FLOOR FLANGE AT FS272 IS CORRODED AND HAS BEEN REPAIRED IAW MESABA EO#S53102. REF: EAMS WORK ORDER 212613 TASK 2517SDR ASAA0580404Floor Panel · chafedOKC - DURING C-CHECK, FOUND CABIN FLOOR PANEL HAS CHAFE MARKS ON LOWER SURFACE BONDED STIFFENER. REPLACED STIFFENER. (M)SDR ASAA0570043Floor Panel · gougedPAE - DURING C-CHECK, FOUND AFT CARGO BAY NR 2 FLOOR PANEL GOUGED AND DENTED. REPAIRED IAW SRM 51-40-05. (M)SDR ASAA0570042Floor Panel · dentedPAE - DURING C-CHECK, FOUND AFT CARGO BAY NR 1 FLOOR PANEL GOUGED AND DENTED. REPAIRED IAW SRM 51-40-5. (M)SDR ASAA0570035Floor Panel · puncturedPAE - DURING C-CHECK, FOUND FORWARD CARGO BAY NR 2 FLOOR PANEL IS PUNCTURED. REPAIRED IAW SRM 53-00-00. (M)SDR GTIA050221Floor Panel · corrodedRIGHT CABIN FLOOR WEB RBL 44 TO RBL 45 HAS CORROSION AT STATION 522 THROUGH 617, STATION 636 THROUGH 646, STATION 674 THROUGH 680, STATION 1068 THROUGH 1076, STATION 1105 THRU 1110 AND STATION 1178 THRU 1135. FLOOR WEB AT STATION RIGHT 560-579 AND FLOOR WEB SSDR ASAA0580362Floor Panel · tornOKC - DURING HV CHECK FOUND CABIN FLOOR PANEL TORN AT CORNER. REPLACED FLOOR PANEL. (M)SDR ASAA0580384Floor Panel · delaminatedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580383Floor Panel · corrodedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL HAS CORRODED INSERTS. REPLACED FLOOR PANEL. (M)SDR ASAA0580382Floor Panel · corrodedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL HAS MISSING AND CORRODED INSERTS. REPLACED FLOOR PANEL. (M)SDR ASAA0580381Floor Panel · corrodedOKC - DURING HV CHECK, FOUND FLOOR PANEL HAS MISSING AND CORRODED INSERTS. REPLACED FLOOR PANEL. (M)SDR ASAA0580380Floor Panel · delaminatedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580379Floor Panel · delaminatedOKC - FOUND DURING HV CHECK, CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580378Floor Panel · delaminatedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580377Floor Panel · puncturedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL PUNCTURED. REPLACED FLOOR PANEL. (M)SDR ASAA0580376Floor Panel · delaminatedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580375Floor Panel · puncturedOKC - FOUND DURING HV CHECK, CABIN FLOOR PANEL PUNCTURED. REPLACED FLOOR PANEL. (M)SDR ASAA0580374Floor Panel · crackedOKC - FOUND DURING HV CHECK, CABIN FLOOR PANEL DELAMINATED AND CRACKED. REPLACED FLOOR PANEL. (M)SDR ASAA0580373Floor Panel · delaminatedOKC - FOUND DURING HV-CHECK, CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580372Floor Panel · delaminatedOKC - DURING HV-CHECK, FOUND CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580371Floor Panel · delaminatedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580370Floor Panel · delaminatedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580369Floor Panel · delaminatedOKC - DURING HV-CHECK, FOUND CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580368Floor Panel · puncturedOKC - DURING HV-CHECK, FOUND CABIN FLOOR PANEL PUNCTURED. REPLACED FLOOR PANEL. (M)SDR ASAA0580367Floor Panel · delaminatedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580366Floor Panel · delaminatedOKC - FOUND DURING HV CHECK, CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580365Floor Panel · delaminatedOKC - FOUND DURING HV-CHECK, CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580364Floor Panel · delaminatedOKC - DURING HV CHECK, FOUND FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580363Floor Panel · bentOKC - DURING HV CHECK FOUND CABIN FLOOR PANEL BENT AT CORNER. INSTALLED REPAIR FILLER AND DOUBLER. (M)SDR ASAA0580361Floor Panel · delaminatedOKC - FOUND DURING HV CHECK, CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580360Floor Panel · delaminatedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL DELAMINATED. REBONDED FIBERGLASS. (M)SDR SWAA052017Web · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE FLOOR WEB CRACKS BETWEEN BS 188 TO BS 196, LT & RT SIDE, WL 208. REPAIRED FLOOR WEB PER SRM.SDR USAA050850Splice · corrodedCLT - FOUND SPLICE STRAP CORRODED .5 INCH, AFT CARGO FLOOR PANEL SPLICE STRAP. FABRICATED NEW STRAP AND INSTALLED IAW SRM 51-10-02. (M)SDR ASAA0570029Floor Panel · corrodedPAE - DURING CHECK, FOUND CORROSION ON RIGHT AND LEFT SIDES OF NR 2 FLOOR PANEL IN AFT CARGO BAY. REPAIRED IAW SRM 51-40-02. (M)SDR ASAA0570030Floor Panel · corrodedPAE - DURING CHECK, FOUND CORROSION ON RIGHT AND LEFT SIDES OF NR 1 FLOOR PANEL IN AFT CARGO BAY. REPAIRED IAW SRM 51-40-02. (M)SDR AWXA200500784Web · crackedDURING C-16 CHECK, DISCOVERED FLOOR WEB CRACKED FROM FRAME CUT OUT AT BS 197, WL 207, BL 28R. MAINTENANCE REMOVED THE CRACKED WEB AT BS 197, WL 207, BL 28R IAW MFG 737-300 SRM 51-40-02-0 FIG 8. FABRICATED REPLACEMENT SHEAR TIE WEB IAW MFG DWG 65-45833, SRM 5SDR SWAA051905Floor Skin · crackedDURING SCHEDULED D-CHECK, FOUND COCKPIT FLOOR SKIN CRACKED AT BS 244, RBL 15. REPAIRED FLOOR SKIN PER SRM.SDR ASAA0570026Repair · temporaryPAE - DURING C-CHECK, FOUND FORWARD CARGO BAY NR 2 FLOOR PANEL HAS A TEMP REPAIR ON AFT END OF PANEL. FABRICATED REPLACEMENT PANEL IAW SRM 51-40-02. (M)SDR USAA050795Floorboard · crackedPIT - FOUND FLOORBOARD CRACKED AND DELAMINATED, FLOOR PANEL 262 HG FRAME 64-66/6 INCH FORWARD OF FRAME 66. DOUBLER REPAIR BONDED COMPOSITE PER SRM 53-02-00. (M)SDR ASOA05548Pressure Panel · corrodedDURING A C-CHECK, THE PRESSURE FLOOR AT LBL 36, RBL 36 FROM FS 409+128 TO FS 559 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE PRESSURE FLOOR AT LBL 36, RBL 36 FROM FS 409+128 TO FS 559 IAW EO. (K)SDR SWAA051832Floor Panel · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE FLOOR WEB CRACKS BETWEEN BS 188 TO BS 197, LT & RT SIDE, WL 208. REPAIRED FLOOR WEB PER SRM.SDR ASAA0590112Floor Panel · dentedPAE - DURING C-CHECK, FOUND AFT CARGO BAY NR 2 FLOOR PANEL HAS NUMEROUS DENTS. REPAIRED IAW SRM 53-60-53. (M)SDR ASAA0590113Floor Panel · dentedPAE - DURING C-CHECK, FOUND AFT CARGO BAY NR 3 FLOOR PANEL HAS NUMEROUS DENTS. REPAIRED IAW SRM 53-60-53. (M)SDR ASAA0580313Floor Panel · brokenOKC - DURING HV-CHECK, FOUND CABIN FLOOR PANEL BROKEN. REPLACED FLOOR PANEL. (M)SDR ASAA0580312Floor Panel · delaminatedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580311Floor Panel · delaminatedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL. (M)
Back to JASC 5321