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 MWEA00714Floor Panel · damagedMKE - FOUND RIVET PULLED THROUGH CABIN FLOOR PANEL BOARD A-3 AT STATION 389. FABRICATED AND INSTALLED REPAIR FLUSH PATCH. (M)SDR MWEA00713Floor Panel · crackedMKE - FOUND CABIN FLOOR PANEL F-7 TOP FORWARD SIDE CRACK AROUND RIVET HEAD. FABRICATED AND INSTALLED REPAIR DOUBLERS. (M)SDR MWEA00712Floor Panel · corrodedMKE - FOUND CABIN FLOOR PANEL F-6, TOP SIDE AREAS OF LIGHT CORROSION AND BARE METAL. FABRICATED AND INSTALLED FLOOR PANEL REPAIR. (M)SDR MWEA00711Floor Panel · crackedMKE - FOUND CABIN FLOOR PANEL B-8, FORWARD TOP END, CRACK AROUND RIVET HEAD, AND CRACK AT FORWARD EDGE OF PANEL. FABRICATED AND INSTALLED REPAIR DOUBLER. (M)SDR MWEA00710Floor Panel · crackedMKE - CABIN FLOOR PANEL E-10, TOP FORWARD END CRACKS AROUND 2 EACH RIVETS. FABRICATED AND INSTALLED REPAIR DOUBLER. (M)SDR MWEA00709Floorboard · corrodedMKE - FOUND CORROSION ON SKIN AND CRACKED HAT CHANNEL ON FLOORBOARD FORWARD STATION 160 FIRST OFFICERS SIDE. REMOVED AND REPLACED SKIN AND HAT CHANNEL. (M)SDR F3LA00188Floor Panel · crackedDEN - PRIOR TO DEPARTURE, MAINTENANCE REPORTED HOLE IN AFT CARGO COMPARTMENT FLOOR PANEL NR 2 AND FLOORBEAM AT STATION 747, RBL 19, CRACKED AT TIE DOWN. MAINTENANCE REMOVED DAMAGED FLOOR PANEL AND DAMAGED SECTION OF FLOORBEAM. FABRICATED REPLACEMENT FLOOR PASDR MWEA00674Floorboard · chafedMKE - FOUND FLOORBOARD E-11 TOP SURFACE END LIP HAS CHAFE AND TEAR DAMAGE. FABRICATED AND INSTALLED REPAIR DOUBLER. (M)SDR MWEA00673Floor Panel · dentedMKE - FOUND DENTED AREA ON FLOOR PANEL A9. FABRICATED AND INSTALLED REPAIR PARTS. (M)SDR MWEA00672Floorboard · chafedMKE - FLOORBOARD E-11 HAS 6 EACH END LIP SCREW HOLES WITH CHAF DAMAGE. FABRICATED AND INSTALLED REPAIR DOUBLER. (M)SDR MWEA00671Floorboard · corrodedMKE - FOUND FLOORBOARD NR F6 HAS MANY AREAS OF LIGHT CORROSION AND BARE METAL, CHAFED AREAS, RIPPED OUT SCREW HOLES, BENT AND RIPPED U-CHANNELS, AND MISSING 2 CHAFED STRIPS. REMOVED AND REPLACED FLOORBOARD. (M)SDR MWEA00693Floor Panel · damagedMKE - FOUND HOLE ON UPPER SURFACE OF CABIN FLOOR PANEL NR A-5 AT STATION 660. FABRICATED AND INSTALLED REPAIR PARTS. (M)SDR MWEA00694Floor Panel · crackedMKE - FOUND CABIN FLOORBOARD A-7 CHAFED STRIPS IS DEBONDING AND UPPER SURFACE IS ALSO CRACKED, AT STATION 758. FABRICATED AND INSTALLED REPAIR PARTS. (M)SDR MWEA00696Floor Panel · debondedMKE - FOUND ON CABIN FLOORBOARD B-11 HAS TWO HOLES AND ALSO CHAFED STRIP IS DEBONDING. FABRICATED AND INSTALLED REPAIR DOUBLER. (M)SDR MWEA00697Floor Panel · crackedMKE - FOUND CABIN FLOOR E-15, TWO CRACKS ON TOP EDGE OF PANEL. FABRICATED AND INSTALLED REPAIR DOUBLER. (M)SDR MWEA00698Floor Panel · damagedMKE - FOUND CABIN FLOOR PANEL E-11 TOP SIDE FORWARD END, SCREW HOLE ELONGATED. FABRICATED AND INSTALLED REPAIR DOUBLER. (M)SDR MWEA00699Floor Panel · crackedMKE - FOUND CABIN FLOOR PANEL E-10 TOP AFT CORNER SMALL CRACK IN JOGGLE. FABRICATED AND INSTALLED REPAIR DOUBLER. (M)SDR MWEA00677Floorboard · chafedMKE - CABIN FLOORBOARD B-10 HAS CHAF DAMAGE ATTACH HOLES. FABRICATED AND INSTALLED REPAIR DOUBLER. (M)SDR MWEA00676Floorboard · chafedMKE - FOUND CABIN FLOORBOARD E-6 ATTACH HOLES HAVE CHAF DAMAGE. FABRICATED AND INSTALLED REPAIR DOUBLER. (M)SDR MWEA00675Floorboard · oversizedMKE - FLOORBOARD E-15 HAS OVERSIZED SCREWHOLE. FABRICATED AND INSTALLED FLOORBOARD REPAIR. (M)SDR MWEA00662Floorboard · chafedMKE - FOUND CABIN FLOORBOARD E-12 HAS CHAFED DAMAGED AT ATTACH HOLES. FABRICATED AND INSTALLED REPAIR DOUBLER. (M)SDR MWEA00682Floorboard · chafedMKE - CABIN FLOORBOARD E-7 HAS CHAF DAMAGE ON UPPER AND LOWER SURFACES AT ATTACH HOLES. FABRICATED AND INSTALLED FLOORBOARD REPAIR. (M)SDR MWEA00681Floorboard · crackedMKE - CABIN FLOORBOARD E-3 HAS SMALL CRACKED AT EDGE OF SKIN. FABRICATED AND INSTALLED REPAIR DOUBLER. (M)SDR MWEA00679Floorboard · corrodedMKE - CABIN FLOORBOARD B-1 UPPER SURFACE HAS LIGHT CORROSION AND CHAFED AREAS AROUND FASTENER HOLES. FABRICATED AND INSTALLED WEB AND DOUBLER REPAIR. (M)SDR MWEA00678Floorboard · chafedMKE - CABIN FLOORBOARD B-4 ATTACH HOLES HAVE CHAFED DAMAGE. FABRICATED AND INSTALLED FLOOR SKIN AND SPLICE DOUBLER. (M)SDR MWEA00691Floor Panel · damagedMKE - HOLE ON UPPER SURFACE OF CABIN FLOOR PANEL A-1 AT STATION 230. FABRICATED AND INSTALLED FLOOR PANEL REPAIR. (M)SDR MWEA00692Floor Panel · crackedMKE - CABIN FLOOR PANEL F-2 IS CRACKED ON TOP SIDE NEXT TO SCREW HOLE. FABRICATED AND INSTALLED FLOOR PANEL REPAIR. (M)SDR TWAA0013515Floor Panel · corrodedDURING OP 15 MAINT CHECK, FLOOR PANEL NUMBER 11 AT FWD ENTRY DOOR HAD AREAS AROUND SCREW HOLES BLENDED BEYOND LIMIT. PANEL MADE NEW IN SHOP PER SSRM 53-00-104.SDR TWAA0013514Floor Panel · corrodedDURING OP 15 MAINT CHECK, FOUND CORROSION ON FLOOR PANELS 12 AND 22. MADE NEW PANELS IN SHOP PER SSRM 53-00-104.SDR UPS00833618Floor Panel · corrodedINSPECTION TYPE:C2, AFT CABIN FLOOR PNL F214 LWR SIDE SEVERAL AREAS OF CORROSION MARKED (RACK 23 SHELF 4) DOT A356. REMOVED CORROSION ON FLOOR PANEL, REPLACED HAT CHANNEL, ALODINED AND PRIMED IAW DC8 SRM 53-2-0, 51-1-21 & 51-1-8.SDR CALA0001235Floor Panel · corrodedINSPECTION FOUND FORWARD ENTRY FLOOR WEB CORRODED AT AFT LT CORNER, STA 196 LBL 2 - LBL 7. A REPAIR DOUBLER WAS INSTALLED IAW SRM 53-14-1, 53-01, FIGURE 2, 51-30-2, 51-10-3, AND 51-20-0.SDR CALA0001233Floor Panel · corrodedINSPECTION FOUND RIGHT O/B FLOOR WEB CORRODED AT STA 636 - 712. THE WEB WAS REMOVED AND REPLACED IAW SRM 51-30-2 AND 51-30-1.SDR CALA0001218Floor Panel · corrodedINSPECTION FOUND AFT PIT FLOOR PANEL CORRODED AT FS 1212 - 1230. THE FLOOR PANEL WAS REMOVED AND A NEW FLOOR PANEL WAS INSTALLED IAW SRM 53-20, FIGURE 11, 51-10-3, 51-10-4, AND ECRA 5320-01265.SDR F3LA00181Floor Panel · corrodedDEN - DURING C-2 CHECK INSPECTION, REPORTED CORROSION ON TOP OF LONGITUDINAL FLOOR PANEL INTERCOSTAL FROM STATION 292.5 TO STATION 312, LBL 10. MAINTENANCE FABRICATED NEW FLOOR SUPPORT AND COVER CAP PER 51-30-02 AND INSTALLED PER SRM 51-10-02 AND 51-30-02. (SDR CALA0001201Floor Panel · crackedINSPECTION FOUND THAT CABIN FLOOR PANEL AT FS 674 - 693, RBL 24 - 44 HAD CRACKED INSERTS AND LOOSE FASTENERS. THE FLOOR PANEL WAS REMOVED, BUILT UP, AND INSTALLED IAW ECRA 5320-01265 AND MM 53-20-01.SDR MWEA00606Floorboard · corrodedMKE - FOUND FLOORBOARD AFT OF FIRST OFFICERS SEAT HAS HEAVY CORROSION AT STATION 150. REMOVED AND REPLACED FLOORBOARD. (M)SDR MWEA00605Stiffener · chafedMKE - FLOORBOARD C-7 HAS CHAFED DAMAGE TO STIFFENER AT STATION 579 TO 680. FABRICATED AND INSTALLED REPAIR STIFFENER. (M)SDR MWEA00604Stiffener · chafedMKE - FLOORBOARD C-7 HAS CHAFED DAMAGE TO STIFFENER AT STATION 579-620. REMOVED AND REPLACED STIFFENER. (M)SDR MWEA00602Insulation · missingMKE - FOUND FLOORBOARD E-9 MISSING AN INSULATION BLANKET AT STATION 639-680. FABRICATED AND INSTALLED NEW FLOOR PANEL AND REPLACED INSULATION BLANKET. (M)SDR MWEA00601Floorboard · damagedMKE - FOUND FLOORBOARD B-2 HAS PUNCTURE/IMPACT DAMAGE TO TOP SURFACE AT STATION 313. FABRICATED AND INSTALLED REPAIR PANEL AND SPLICE PANEL. (M)SDR USAA001125Pressure Panel · crackedCLT - FOUND PRESSURE DECK WITH TWO CRACKS .5 INCH AND 1 INCH, PRESS DECK MLG WHEEL WELL STRINGER 663, LBL 30. REMOVED DAMAGE INSTALLED REPAIR DOUBLER AND FILLER PER TR 53-60-04. (M)SDR L1GA200000242Floor Panel · crackedTWO CRACKS 1 INCH LONG ON FLOOR PANEL. INSTALLED REPAIR DOUBLER.SDR L1GA200000241Floor Panel · crackedTWO CRACKS APPROX 1 INCH LONG ON FLOOR PANEL. INSTALLED REPAIR DOUBLER.SDR L1GA200000240Floorboard · crackedA 1 INCH CRACK UPPER SURFACE OF FLOORBOARD FS 832. INSTALLED REPAIR DOUBLER UPPER SURFACE.SDR L1GA200000229Floor Panel · crackedA 1 INCH CRACK AT FS 293 BL 44L FLOOR PANEL. INSTALLED REPAIR DOUBLERS.SDR L1GA200000225Floorboard · corrodedSERVRAL AREAS OF CORROSION AT STATION 965 30 RT ON FLOOR PANEL. REPLACED FLOOR PANEL.SDR L1GA200000208Floor Panel · crackedA 20 INCH CRACK FS 237 BL 0 TO BL 22 LT FLOOR PANEL. REMOVED AND FABRICATED NEW FLOOR PANEL.SDR L1GA200000191Floorboard · crackedA 1 INCH CRACK FLOOR PANEL FS 579 - 680 BL 0-24 LT. INSTALLED REPAIR DOUBLER.SDR L1GA200000190Floorboard · crackedA 1 INCH CRACK FS 579 - 680 BL 0-24 LEFT. INSTALLED REPAIR DOUBLER.SDR L1GA200000189Floorboard · crackedPANEL EDGE CRACKED 1 INCH CRACK AT FS 579 - 680 BL 44 - 48 LT. INSTALLED REPAIR DOUBLER.
Back to JASC 5321