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 ASAA0380715Floorboard · puncturedOKC - DURING 15K CHECK, FOUND PASSENGER CABIN FLOORBOARD IS PUNCTURED AT FS 1034-1060. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0380713Floorboard · crackedOKC - DURING 15K CHECK, FOUND PASSENGER CABIN FLOORBOARD IS CRACKED AT FS 820-920. REPLACED FLOOR PANEL PER SRM 51-10-4. (M)SDR ASAA0380712Floorboard · corrodedOKC - DURING 15K CHECK, FOUND PASSENGER FLOORBOARD IS CORRODED AT FS 256. REPLACED FLOOR PANEL PER SRM 53-05 AND 51-10-4. (M)SDR ASAA0380714Floorboard · delaminatedOKC - DURING 15K CHECK, FOUND PASSENGER CABIN FLOORBOARD IS DELAMINATED AT FS 887-947. REPLACED FLOOR PANEL PER SRM 53-24. (M)SDR ASAA0380711Floorboard · corrodedOKC - DURING 15K CHECK, FOUND FLIGHT DECK FLOOR PANEL FASTENERS AND WASHERS ARE CORRODED AT FS 155. REPLACED DAMAGED FLOOR PANEL PER SRM 53-05. (M)SDR GTIA030931Floor Panel · crackedFOUND CABIN STATION 389 RIGHT OUTBOARD FLOOR PANEL CRACKED. FABRICATED NEW RIGHT OUTBOARD FLOOR PANEL. (M)SDR MALA030500Floor Panel · corrodedDURING 4K INSPECTION IN LCQ, FIRST OFFICERS FLOOR PANEL CORRODED AT STA 179 RBL 25. VENDOR CUT OUT CORRODED AREA, FABRICATED AND INSTALLED REPAIR DOUBLER IAW MESABA EO S53186 DATED 03 NOV 03.SDR GTIA030924Floor Panel · damagedFOUND CABIN FLOOR PANEL STATION 927-1003, CORNERS SEPARATING, BENT, EDGE GOUGED. FABRICATED NEW CABIN FLOOR PANEL. (M)SDR GTIA030915Floor Panel · crackedFOUND FLOOR PANEL RIGHT OUTBOARD STATION 769-826 HAT CHANNEL END CRACKED THROUGH. CUT OUT DAMAGED PORTION OF HAT CHANNEL. FABRICATED NEW HAT CHANNEL. FABRICATED SPLICE. INSTALLED HAT CHANNEL AND SPLICE. (M)SDR GTIA030925Floor Panel · crackedFOUND FLOOR PANEL, LEFT OUTBOARD STATION 541-617 HAT CHANNEL CRACKED IN HALF. REMOVED DAMAGED H-SECTION FORMED FILLER AND SPLICES. INSTALLED FILLER AND SPLICES. (M)SDR GTIA030916Floor Panel · brokenFOUND FLOOR PANEL STATION 1003-1041 CENTER, INSERT BROKEN OUT. UPON FURTHER EVALUATION FLOORBOARD IS OUT OF LIMITS. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA030920Floor Panel · delaminatedFOUND COCKPIT FLOOR PANEL NR 4411A DELAMINATED. REPAIRED COCKPIT FLOOR PANEL. (M)SDR ASAA0370018Strap · corrodedOAK - DURING C-CHECK, FOUND FLOOR PANEL SUPPORT STRAP IS CORRODED AT FS 887. REPLACED STRAP PER MM 51-40-02. (M)SDR UPS03841609Finger Doubler · corrodedINSPECTION TYPE: C3, CORROSION AND SHEARED RIVETS ON WEB FINGER DOUBLER COCKPIT SHEAR WEB UNDER F/E STA RT CUSP FS -12.000 TO -32.000. REMOVED CORRODED FINGER DOUBLER IAW DC8 SRM 51-1-21, CUT OUT DAMAGE IN WEB IAW DWG SRO8530026, REMOVED CORROSION ON CUSPSDR MWEA030427Floorboard · deterioratedFLOORBOARD IN AFT BAG-PIT AT STATION 1155 HAS AREA WORN AND DETERIORATED AT FORWARD EGDE OF LOWER CENTER PANEL, JUST INSIDE BAG-PIT DOOR. FABRICATED AND INSTALLED NEW FLOORBOARD.SDR MWEA030426Floorboard · deterioratedMID CARGO COMPARTMENT CENTER FLOORBOARD STATION 598-636 IS DETERIORATED ALONG AFT EDGE. FABRICATED AND INSTALLED FLOORBOARD.SDR GTIA030884Floor Panel · corrodedFTW - FOUND CABIN FLOOR WEB CORRODED UNDER GALLEY DRAIN PAN STATION 158 RBL - 44 INCHES. (M)SDR ASAA0380658Floorboard · delaminatedOKC - DURING 30K CHECK, FOUND FLOORBOARD DELAMINATED. REPLACED FLOORBOARD. (M)SDR ASAA0380671Floorboard · corrodedOKC - DURING 30K CHECK, FOUND FLOORBOARD HAS CORRODED INSERTS. REPLACED FLOORBOARD. (M)SDR ASAA0380662Floor Panel · crackedOKC - DURING 30K CHECK, FOUND RIGHT FLOOR PANEL AT STATION 920-1000 EDGE AND STIFFENER CRACKED AND DISBONDED. REPAIRED IAW SRM. FABRICATED AND BONDED REPAIR PLATE. (M)SDR ASAA0380670Floorboard · corrodedOKC - DURING 30K CHECK, FOUND FLOORBOARD HAS CORRODED INSERTS. REPLACED FLOORBOARD. (M)SDR ASAA0380676Floorboard · corrodedOKC - DURING 30K CHECK, FOUND CABIN FLOORBOARD HAS CORRODED INSERTS AT FS 1155-1250. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380677Floorboard · corrodedOKC - DURING 30K CHECK, FOUND CABIN FLOORBOARD HAS 15 CORRODED INSERTS AT FS 1113-1174. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380646Floorboard · corrodedOKC - DURING 30K CHECK, FOUND FLOORBOARD IS CORRODED AND HAS DEFECTIVE INSERTS AT FS 1174-1250. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380645Floorboard · puncturedOKC - FOUND DURING 30K CHECK, FLOORBOARD PUNCTURED AT FS 1079-1117. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380651Floorboard · corrodedOKC - DURING 30K CHECK, FOUND FLOORBOARD HAS CORRODED INSERTS AT FS 1117-1174. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380648Floorboard · corrodedOKC DURING 30K CHECK, FLOORBOARD IS CORRODED AT FS 1113-1174, AND HAS 15 INSERTS EITHER CRACKED, MISSING, OR CORRODED. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380647Floorboard · delaminatedOKC - DURING 30K CHECK FLOORBOARD IS DELAMINATED AT FS 826-886. REPLACED FLOORBOARD PER SRM 53-04. (M)SDR ASAA0380683Floor Panel · corrodedOAK 15K CHECK, FOUND FLOOR PANEL, MEMBRANE, IS CORRODED AT FS 522. REMOVED DAMAGED AREA AND INSTALLED DOUBLER PER SRM 51-10-3. (M)SDR ASAA0380639Floorboard · crackedOKC - DURING 15K CHECK, FOUND PASSENGER CABIN FLOORBOARD CRACKED AT FS 889-927. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380680Floor Panel · corrodedOAK - DURING 15K CHECK, FLOOR PANEL IS CORRODED AT FS 1155-1174. REMOVED DAMAGED SECTION AND INSTALLED DOUBLER PER SRM 51-70-3. (M)SDR MWEA030418Floorboard · gougedCABIN FLOORBOARD LEFT SIDE BETWEEN STATION 1250-1309 HAS A GOUGE IN THE CENTER AREA. REPAIRED FLOORBOARD.SDR MWEA030417Floor Panel · damagedELEVEN SMALL HOLES IN CENTER FLOOR PANEL STATION 258. REPAIRED FLOOR PANEL.SDR MWEA030414Floorboard · crackedRIGHT CABIN FLOOR BOARD BETWEEN SEAT TRACK 3 AND 4 IS CRACKED APPROXIMATELY 18 INCHES FROM FORWARD END. -- REPAIRED.SDR GTIA030860Floorboard · delaminatedFTW - FOUND PAX CABIN FLOORBOARD DELAMINATED AT FORWARD F/A SEAT AREA. FABRICATED NEW FLOORBOARD. (M)SDR ASAA0380631Floorboard · gougedDURING 15K C-CHECK, FOUND CABIN FLOOR PANEL HAS SEVERAL GOUGES BETWEEN FS 1117 AND 1174. REPLACED DAMAGED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0380626Floorboard · corrodedFOUND DURING 15K CHECK, CABIN FLOORBOARD HAS SEVERAL CORRODED INSERTS AND LARGE TORN AREA FROM FS 1155 TO 1250. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380625Floorboard · debondedFOUND DURING 15K CHECK, CABIN FLOORBOARD HAS LARGE SOFT, DEBONDED, AREA FROM FS 1117 TO 1174. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR GTIA030805Floor Panel · crackedFTW - FOUND FORWARD CABIN STA 200 TO 256 LBL 14 TO 21 FLOOR PANEL HAS CRACKED/DAMAGED AT CORNERS. FABRICATED NEW FLOOR PANEL. (M)SDR ASAA0380606Floorboard · tornFOUND FLOORBOARD FIBERGLASS CLOTH TORN FROM UPPER SURFACE AT FS 1079-1117. REPLACED FLOORBOARD PER SRM 53-03. (M)SDR ASAA0380617Floorboard · corrodedFOUND DURING 15K CHECK, CABIN FLOORBOARD JUST INSIDE L1 ENTRY IS CORRODED AROUND INSERTS AT FS 148-196. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380616Floorboard · corrodedFOUND DURING 15K CHECK, CABIN FLOOR PANEL IS CORRODED AROUND INSERTS AT FS 160-190. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380615Floorboard · debondedFOUND DURING 15K CHECK, CABIN FLOOR PANEL IS DISBONDING AROUND INSERTS AT FS 190-256. REPLACED FLOORBOARD [ER SRM 53-05. (M)SDR ASAA0380614Floorboard · corrodedFOUND DURING 15K CHECK, FLIGHT DECK HAS CORRODED FLOORBOARD INSERTS AT FS 150-160. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380613Floorboard · corrodedFOUND DURING 15K CHECK, FLOORBOARD HAS CORRODED AND SOME MISSING INSERTS AT FS 160-200. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380612Floorboard · corrodedFOUND DURING 15K CHECK, CABIN FLOORBOARD HAS CORRODED AND SOME MISSING INSERTS AT FS 160-200. REPLACED FLOORBOARD PER SRM 53-05. (M0SDR ASAA0380610Floor Panel · debondedFOUND DURING 15K CHECK, FLOOR PANEL DISBONDED AT EDGE AT FS 769-826. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0380607Floorboard · corrodedFOUND DURING 15K CHECK, FLIGHT DECK FLOORBOARD DELAMINATED AND CORRODED AT FS 125-160. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380621Floorboard · delaminatedOKC - FOUND DURING 15K CHECK, CABIN FLOOR PANEL IS DELAMINATED AT TWO LOCATIONS BETWEEN FS 541 AND 617. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380620Floorboard · debondedDURING 15K CHECK FOUND CABIN FLOOR PANEL IS DISBODED AT CORNER AND CREASED THROUGH MIDDLE AT FS 465-522. REPLACED FLOORBOARD PER SRM 53-05. (M)
Back to JASC 5321