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 L1GA200000037Floorboard · tornCABIN FLOOR AT STATION 313 BETWEEN CENTER LINE AND X24R TORN AT INBOARD EDGE.SDR L1GA200000036Floorboard · crackedCRACK ON CABIN FLOOR PANEL NUMBER 18A THAT RAN THROUGH 6 FASTENER HOLES.SDR L1GA200000035Floorboard · corrodedHEAVY CORROSION ON AND UNDER FLOORBOARD NR 23B.SDR L1GA200000034Floorboard · tornFOWARD EDGE OF FLOOR PANEL TORN AT FS 812 BETWEEN CENTERLINE TO X24.SDR CALA0000449Floorboard · crackedINSPECTION FOUND A 1 INCH CRACK IN CABIN LT FLOOR SKIN AT FS 218, LBL 54. THE CRACK WAS STOP DRILLED AND A DOUBLER WAS INSTALLED IAW SRM 53-01, FIGURE 2, 51-10-3, 51-10-4, 51-30-2, AND 51-30-5.SDR COMA0060322Floorboard · corrodedFLOOR PLATE AT FS 295 RBL 3 TO RBL 9 CORRODED WITH ELONGATED HOLES. INSTALLED FABBED PLATE IAW WVAC EO 601R-53-1116.SDR MWEA00277Floorboard · chafedCABIN FLOOR PANEL E-13 HAS AREAS OF BARE METAL AND MISSING CHAFE STRIPS. FABRICATED AND INSTALLED FLOORBOARD.SDR MWEA00276Floorboard · flakingCABIN FLOOR PANEL, FOR STATION 160 TO 200, IN FRONT OF PAX DOOR HAS LAMINATE FLAKING AND A HOLE WITH INSUFFICIENT EDGE DISTANCE. REPAIRED DAMAGED AREAS IAW SRM 51-70.SDR MWEA00275Floorboard · flakingCABIN FLOORBOARD FOR STATION 160 TO 200 RIGHT OF CENTER BEAM 45 TO 55 INCHES HAS LAMINATE FLAKING UP. MAINTENANCE REPAIRED DAMAGED AREA IAW SRM 51-70.SDR MWEA00272Floorboard · corrodedFLOOR PANEL BETWEEN AFT LAVATORYS HAS NUMEROUS AREAS OF LIGHT CORROSION, CHAFES, AND MISSING PAINT. FABRICATED AND INSTALLED REPAIR DOUBLER.SDR RRXA001747Floorboard · crackedDURING A MAINTENANCE VISIT, FOUND A CRACK AT THE DRAIN PLUG HOLE ON THE MAIN CABIN FLOOR PANEL, AT BS 1200 AND RBL 10, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW DC-8 SSDR RRXA001732Floorboard · corrodedDURING A MAINTENANCE VISIT, FOUND CORROSION DAMAGE TO THE MAIN CABIN FLOORBOARD, FS 987 TO 990 AND LBL 16 TO 19, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED REPAIR AND INSTALLED IAW DC-8 SRM 53-SDR RRXA001731Web · corrodedDURING A MAINTENANCE VISIT, FOUND CORROSION DAMAGE TO THE MAIN CABIN COURIER AREA FLOOR WEB AT FS 25 TO 45 AND LBL 48 TO 75, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW FLOOR WEBSDR MWEA00270Floorboard · crackedCABIN FLOOR PANEL E13 HAS NUMEROUS CHAFE MARKS AROUND BOLT HOLES BOTTOM SIDE, AND A DENT WITH A CRACK ON TOP CENTER. FABRICATED AND INSTALLED NEW FLOORBOARD.SDR MWEA00246Floorboard · puncturedCAPTAIN FLOORBOARD AROUND YOLK IS PUNCTURED AT INBOARD AFT CORNER. FABRICATED AND INSTALLED NEW DOUBLER.SDR MWEA00245Floorboard · dentedCOCKPIT FLOORBOARD BEHIND CENTER PEDESTAL IS DENTED. FABRICATED AND INSTALLED NEW DOUBLER.SDR MWEA00248Floorboard · gougedGOUGES AROUND FLOORBOARD FASTENER HOLES TOP OF NR 2 SEAT TRACK FROM STATION 718 TO 786. FABRICATED AND INSTALLED REPAIRED TRACK.SDR DHL200080448CFloorboard · crackedMAIN CARGO NR 60 FLOOR CRACKED. STOP DRILLED PER SRM 53-2-3. FABRICATED DOUBLER PER SRM 53-2-3. CLEANED, TREATED AND PRIMED PER SRM 53-2-3. INSTALLED DOUBLER PER SRM 53-2-3.SDR DHL200080446CFloorboard · crackedMAIN CARGO NR 2D FLOOR CRACKED. STOP DRILLED PER SRM 53-2-3. FABRICATED DOUBLER PER SRM 53-2-3. CLEANED, TREATED AND PRIMED PER SRM 51-1-8. INSTALLED DOUBLER PER SRM 53-2-3.SDR DHL200080445CFloorboard · crackedMAIN CARGO COMPT 2C FLOOR CRACKED. STOP DRILLED PER SRM 53-2-0. FABRICATED DOUBLER PER SRM 53-2-0. CLEANED, TREATED AND PRIMED PER SRM 51-1-8. INSTALLED DOUBLER ON CARGO FLOOR PER SRM 53-2-0.SDR DHL200080444CFloorboard · corrodedMAIN CARGO COMPT 6A FLOOR SKIN LOWER PART SHOWS CORROSION. REMOVED CORRODED FLOOR SKIN PER SRM 51-1-21. FABRICATED NEW SKIN PER SRM 53-2-0. CLEANED, TREATED AND PRIMED PER SRM 51-1-8. INSTALLED SKIN PER SRM 53-2-0.SDR DHL200080443CFloorboard · crackedMAIN CARGO COMPT 3D FLOOR CRACKED 1 INCH AT STA 724.00. STOP DRILLED PER SRM 51-1-21. FABRICATED DOUBLER PER SRM 53-2-3. CLEANED,TREATED AND PRIMED PER SRM 51-1-8. INSTALLED DOUBLER PER SRM 53-2-3.SDR DHL200080442CFloorboard · crackedMAIN CARGO COMPT FLOOR CRACKED .5 INCH. STOP DRILLED PER SRM 53-2-3. FABRICATED DOUBLER PER SRM 53-2-3. INSTALLED DOUBLER PER SRM 53-2-3.SDR DHL200080441CFloorboard · crackedMAIN CARGO COMPT 3-D FLOOR CRACKED .5 INCH AT STA 596.00. STOP DRILLED PER SRM 53-2-3. FABRICATED DOUBLER PER SRM 53-2-3. CLEANED, TREATED AND PRIMED PER SRM 51-1-8. INSTALLED DOUBLER PER SRM 53-2-3.SDR MWEA00229Floorboard · dentedCABIN FLOORPANEL B-6 HAS A DENT AND NUMEROUS CRACKS ON SKIN AND SUPPORT CHANNELS. FABRICATED AND INSTALLED NEW PANEL.SDR MWEA00228Floorboard · puncturedCABIN FLOOR PANEL E-8 IS PUNCTURED AND HAS SEVERAL CRACKS. FABRICATED AND INSTALLED NEW FLOORBOARD PANEL.SDR MWEA00227Floorboard · chafedCABIN FLOOR PANEL E-8 HAS CHAFED AREA AND IS MISSING CHAFE. FABRICATED AND INSTALLED NEW FLOOR PANEL.SDR MWEA00226Floorboard · crackedCABIN FLOOR PANEL A-5 HAS CRACKS AND DAMAGED FIBERGLASS SUPPORT CHANNEL. FABRICATED AND INSTALLED DOUBLER.SDR MWEA00225Floorboard · damagedCABIN FLOOR PANEL F-7 HAS DAMAGED FIBERGLASS SUPPORT CHANNELS AND SUPPORT CHANNEL ATTACH RIVETS HAVE INSUFFICIENT EDGE DISTANCE. FABRICATED AND INSTALLED FIBERGLASS SUPPORT CHANNELS.SDR MWEA00224Floorboard · corrodedCABIN FLOORPANEL F-1 HAS AREAS OF BAREMETAL, WIDESPREAD LIGHT TO MODERATE CORROSION, AND DAMAGED FIBERGLASS SUPPORT CHANNEL. FABRICATED AND INSTALLED FLOORBOARD.SDR MWEA00223Floorboard · misdrilledCABIN FLOOR PANEL B-9 HAS AREAS OF BAREMETAL, HOLES WITH INSUFFICIENT EDGE DISTANCE, AND MISSING CHAFE STRIP. FABRICATED AND INSTALLED REPAIR DOUBLER.SDR MWEA00222Floorboard · crackedCABIN FLOOR PANEL B-2 HAS AREAS OF BAREMETAL, AND A SECTION CRACKED OUT FROM ATTACHMENT HOLE. FABRICATED AND INSTALLED DOUBLER.SDR MWEA00221Floorboard · chafedCABIN FLOOR PANEL A-3 HAS AREAS OF BAREMETAL AND A CHAFED AREA. FABRICATED AND INSTALLED DOUBLER.SDR MWEA00220Floorboard · chafedCABIN FLOOR PANEL A-2 HAS CHAFED AREAS AND CRACKS. FABRICATED AND INSTALLED DOUBLER.SDR MWEA00219Floorboard · crackedCABIN FLOOR PANEL F-5 HAS CRACKS, PUNCTURES, AND DAMAGED FIBERGLASS SUPPORT CHANNELS. FABRICATED AND INSTALLED DOUBLERS.SDR MWEA00218Floorboard · chafedCABIN FLOOR PANEL D-1 HAS A CHAFED AREA AND HAS BEEN PARTIALLY DRILLED INTO. REPAIRED DAMAGED AREA IAW SRM 51-70-1.SDR MWEA00217Floorboard · misdrilledCABIN FLOOR PANEL C-6 HAS BEEN PARTIALLY DRILLED INTO. REPAIRED HOLE IN PANEL C-6 IAW SRM 51-70-1.SDR MWEA00216Floorboard · damagedCABIN FLOOR PANEL D-6 IS SPLITTING ON OVERLAPPING TONGUE. REPAIRED DAMAGED AREA IAW SRM 51-70-1.SDR MWEA00215Floorboard · damagedCABIN FLOORPANEL C-5 HAS A HOLE WITH INSUFFICIENT EDGE DISTANCE. REPAIRED DAMAGED AREA IAW SRM 51-70-1.SDR MWEA00214Floorboard · misdrilledCABIN FLOORPANEL B-7 HAS AREAS OF METAL, CHAFES, AND DOUBLE DRILLED HOLES. FABRICATED AND INSTALLED NEW FLOORBOARD.SDR MWEA00213Floorboard · crackedCABIN FLOOR PANEL E-1 IS CRACKED, PUNCTURED, AND HAS CORNERS CRACKED OUT. FABRICATED AND INSTALLED NEW FLOORBOARD.SDR MWEA00212Floorboard · puncturedCABIN FLOOR PANEL B-3 HAS AREAS OF BAREMETAL AND IS PUNCTURED. FABRICATED AND INSTALLED REPAIR DOUBLER.SDR MWEA00211Floorboard · damagedCABIN FLOOR PANEL C-4 HAS FIBERGLASS SPLITTING WHERE RIVETS ATTACH EXPANSION JOINT. REPAIRED DAMAGED AREA''S IAW SRM 51-70-1 PARAGRAPH 7.SDR MWEA00210Floorboard · damagedCABIN FLOOR PANEL C-3 HAS FIBERGLASS DAMAGE ON OVERLAPPED TONGUE. REPAIRED PANEL C-3 IAW SRM 51-70.SDR MWEA00209Floorboard · crackedCABIN FLOOR PANEL E-5 HAS AREAS OF BAREMETAL, A CRACK, AND A CHAFE. FABRICATED AND INSTALLED NEW DOUBLER.SDR MWEA00208Floorboard · misdrilledCABIN FLOOR PANEL E-9 HAS DOUBLE DRILLED HOLES AND OPEN FASTENER HOLES. FABRICATED AND INSTALLED NEW REPAIR DOUBLERS.SDR MWEA00207Floorboard · crackedCABIN FLOOR PANEL B-1 AND F-4 HAS A CRACK AND MISSING CHAFE. FABRICATED AND INSTALLED NEW CHAFE STRIP AND DOUBLER.SDR MWEA00206Floorboard · crackedCABIN FLOOR PANEL A-1 HAS CRACKS, CHAFES AND A PUNCTURE. FABRICATED AND INSTALLED REPLACEMENT FILLER AND DOUBLER PLATES.SDR MWEA00204Floorboard · crackedCRACK ON OUTBOARD EDGE OF FLOOR PANEL A-5. FABRICATED AND INSTALLED DOUBLER.SDR MWEA00203Floorboard · crackedCOCKPIT CENTER FLOOR PANEL ASSY CRACKED IN SEVERAL PLACES. REPAIRED COCKPIT CENTER FLOORPANEL IAW DC-9 SRM 51-70-1.
Back to JASC 5321