JASC 5320
Service difficulty reports · 216,207
Reports filed under 5320 · Fuselage Miscellaneous Structure, 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 = '5320' 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 = '5320' 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 IPXA2022070783928Floor Panel · wornINSPECTION TYPE:A300MDC FLOORPANEL 242EF HAS PUNCTURESREPAIRED MDC FLOOR PANEL 242EF AS NEEDED IAW EO NO A300-5320-42722-FSDR IPXA2022070783926Floor Panel · wornINSPECTION TYPE:A300MDC FLOOR PANEL PANEL 231KH HAS PUNCTURESREPAIRED MDC FLOOR PANEL 231KH AS NEEDED IAW EO NO A300-5320-42722SDR IPXA2022070783925Floor Panel · wornINSPECTION TYPE:A300MDC FLOOR PANEL 232HG HAS PUNCTURESREPAIRED MDC FLOOR PANEL 232HG AS NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070783917Floor Panel · wornINSPECTION TYPE:A300MDC FLOOR PANEL 232LH HAS PUNCTUREREPAIRED MDC FLOOR PANEL 232LH NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070783916Floor Panel · wornINSPECTION TYPE:A300MDC FLOOR PANEL 231QH HAS PUNCTURESREPAIRED MDC FLOOR PANEL 231QH AS NEEDED IAW EO NO A300-5320-42722-FSDR IPXA2022070783914Floor Panel · wornINSPECTION TYPE:A300MDC FLOOR PANEL 231LG HAS PUNCTURESREPAIRED MDC FLOOR PANEL 231LG AS NEEDED IAW EO A300-5320-4277-FSDR IPXA2022070883954Floor Panel · wornINSPECTION TYPE:A300MDC FLOOR PANEL 231KG HAS PUNCTURESREPAIRED MDC FLOOR PANEL 231KG AS NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070883950Floor Panel · wornINSPECTION TYPE:A300MDC FLOOR PANEL 231VG HAS PUNCTURESREPAIRED MDC FLOOR PANEL 231VG AS NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070883949Floor Panel · wornINSPECTION TYPE:A300MDC FLOOR PANEL 231HQ HAS PUNCTURESREPAIRED MDC FLOOR PANEL 231QG AS NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070883947Floor Panel · wornINSPECTION TYPE:A300MDC FLOOR PANEL 242GF HAS PUNCTURESREPAIRED MDC FLOOR PANEL 242GF AS NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070883944Floor Panel · wornINSPECTION TYPE:A300MDC FLOOR PANEL 231NJ HAS PUNCTURESREPAIRED MDC FLOOR PANEL 231NJ AS NEEDED IAW EO NO A300-5320-42722-FSDR IPXA2022070783923Floor Panel · wornINSPECTION TYPE:A300MDC FLOOR PANEL 222CG HAS PUNCTURESREPAIRED MDC FLOOR PANEL 222CG AS NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070783922Floor Panel · wornINSPECTION TYPE:A300MDC FLOOR PANEL 232BH HAS PUNCTURESREPAIRED MDC FLOOR PANEL 232BH AS NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070783921Floor Panel · wornINSPECTION TYPE:A300MDC FLOOR PANEL 232RH HAS PUNCTURESREPAIRED MDC FLOOR PANEL 232RH AS NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070783920Floor Panel · wornINSPECTION TYPE:A300MDC FLOOR PANEL 232KH HAS PUNCTUREREPAIRED MDC FLOOR PANEL 232KH NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070683880Floor Panel · damagedINSPECTION TYPE:A300PNL 221EG BROKENFABBED IAW SREO A300-5320-40552-BSDR IPXA2022070683876Floor Panel · damagedINSPECTION TYPE:A300PNL 231XG BROKENFABBED IAW SREO A300-5320-40552-BSDR AALA202207058733Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR REXA2022070101445Stringer · corrodedSTGR 24R BETWEEN FS 333 TO FS409 FOUND 4 LOCATIONS AROUND FASTENERS CORRODED. REPAIRED STRINGER IAW ENDEAVOR EA CRJ953-13887 REV IR DATED 6/27/2022.SDR SWAA2022062718132Attach Angle · crackedFOUND CRACK IN A/C BAY ON LOWER ATTACH ANGLE WL 172 AT STA 663 LBL 8 / [01] APPLIED EWIS PROTECTION TO REPAIR AREA IAW AMM 20-60-07;[02] REMOVED ALL FASTENERS AND TRIMMED OUT DAMAGED SECTION OF ANGLE IAW SRM 57-10-10-2R-5;[03] PERFORMED DETAILED VISUAL INSPECTSDR REXA2022062701357Seat Track · corrodedPASSENGER SEAT TRACK AT LBL 9 FS 977 - FS 1000 IS CORRODED. REMOVED, FABRICATED & REPLACED SEAT TRACK IAW CRJ 900 SRM 51-40-11-001-001-A01, 53-00-49-201-002-A01 & AMM 53-00-49-000/400-801-A07.SDR REXA2022062301332None · corrodedLH SIDE SEAT RAIL F.S. 673.- 720 HAS MULTIPLE SPOTS OF CORROSION REMOVED, FABRICATED AND REPLACED SIDE SEAT RAIL IAW CRJ SRM 53-00-49-201-002-A01 & AMM 53-00-49-000/400-801-A07SDR REXA2022062201323Frame · corrodedFRAME CORRODED @ FS 942 BETWEEN STGR 27 AND STGR 25R. SPLICE REPAIRED FRAME USING FRAME SECTOR PART NUMBER SH690-37073-5 IN LIEU OF P/N SH690-37095-3 IAW ENDEAVOR AIR EA CRJ953-13822.SDR SWAA2022061718116Floor Support · crackedCRACKED FLOOR SUPPORT STA 540; BL0-LBL 25; WL 208. / [01] REMOVED FLOOR SUPPORT AT STA 540 BL0 LBL25 WL 208 IAW SRM 51-40-02-0G-0.;[02] LOCATED AND DRILLED NEW FLOOR SUPPORT AT STA 540 BL0-LBL25 WL 208 IAW SRM 51-40 -05-0G-0 . OK TO INSTALL.;[03] UPDATED MEASUSDR YENA2022061400611Beam · corrodedDURING HEAVY MAINTENANCE, CORROSION ON LONGITUDINAL BEAM BTW FR 84-85 AND Y= -300; REF. TOMX W/O: N306JB/1931 NR-00286- LONGITUDINAL BEAM BTW FR 84-85 AND Y=-300 WAS REPAIRED PER EMB -190 SRM 53-23-10 REPAIR 54.SDR YENA2022061400610Stringer · corrodedDURING HEAVY MAINTENANCE, CORROSION ON STGR 27R BTW FR 87-88; REF. TOMX W/O: N306JB/1931 - NR-00280 - STGR 27R AND BTW FR 87-88 WERE REPAIRED PER EMB-190 SRM 53-23-03, REP 51.SDR SWAA2022071417706Angle · corrodedCORROSION ON FLOOR TO SIDEWALL ANGLE LBL 24.75; WL 156.5; BS 440+10.5; 14.5; 18.5; BS 460+10.5; 14.5; 18.5; BS 480+6; BS 500+5; 10.5; 14.5; BS 500A+2; 6.5; 10.5; 14.5; BS 500B+10.5 & 500C+6.5 10.5 14.5 / [01] VERIFIED APPLICABILITY SRM 53-30-53-0I-2 IDENTIFICASDR SWAA2022071417708Angle · corrodedCORROSION ON FLOOR TO SIDEWALL ANGLE RBL 24.75; WL 156.5; BS 500A+2.5; 6.5; 10.5; 14.5; 18.5; BS 500B+2.5; 6.5; 14.5; 18.5; BS 500C+6.5; 10.5; 14.8 / [01] VERIFIED APPLICABILITY OF SRM 53-00-53-1A-2 FOR ALLOWABLE LIMITS.;[02] REMOVED CORROSION ON FLOOR TO SIDESDR SWAA2022071417707Shield · corrodedCORROSION ON AFT DOOR CUTOUT SHIELD RBL 24.75; WL 156.5; BS 500+2.5; 6.5; 10.5; 14.5; 18.5 / [01] CORROSION ON AFT DOOR CUTOUT SHIELD BS 500 TO BS 500A; FOUND TO BE OUT OF LIMITS DUE TO NO ALLOWABLE DAMAGE ON SRM PARTS WILL BE REPAIRED BY REPLACEMENT; IAW SRM SDR IPXA2022070783927Floor Panel · puncturedINSPECTION TYPE:A300MDC FLOOR PANEL 242RM HAS DAMAGESREPAIRED MDC FLOOR PANEL 242RM AS NEEDED IAW EO NO A300-5320-42722-FSDR IPXA2022070783918Floor Panel · puncturedINSPECTION TYPE:A300MDC FLOOR PANEL 242FK HAS PUNCTUREREPAIRED MDC FLOOR PANEL 242FK NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070783913Floor Panel · damagedINSPECTION TYPE:A300MDC FLOOR PANEL 242TM HAS DAMAGESREPAIRED MDC FLOOR PANEL 242TM AS NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070883955Floor Panel · wornINSPECTION TYPE:A300MDC FLOOR PANEL 241YG HAS ONE FASTENER EMBEDDEDREPAIRED MDC FLOOR PANEL 241YG AS NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070883952Floor Panel · puncturedINSPECTION TYPE:A300MDC FLOOR PANEL 242SN HAS PUNCTUREREPAIRED MDC FLOOR PANEL 242SN NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070883951Floor Panel · puncturedINSPECTION TYPE:A300MDC FLOOR PANEL 242ZG HAS PUNCTURESREPAIRED MDC FLOOR PANEL 242ZG AS NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070883948Floor Panel · puncturedINSPECTION TYPE:A300MDC FLOOR PANEL 242GN HAS PUNCTUREREPAIRED MDC FLOOR PANEL 242GN NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070883946Floor Panel · puncturedINSPECTION TYPE:A300MDC FLOOR PANEL 242ZJ HAS PUNCTURESREPAIRED MDC FLOOR PANEL 232ZJ AS NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070883945Floor Panel · delaminatedINSPECTION TYPE:A300MDC FLOOR PANEL 242YK HAS DELAMINATEDREPAIRED MDC FLOOR PANEL 242YK AS NEEDED IAW EO A300-5320-42722-FSDR IPXA2022070783924Floor Panel · puncturedINSPECTION TYPE:A300MDC FLOOR PANEL 242TH HAS PUNCTURESREPAIRED MDC FLOOR PANEL 242TH AS NEEDED IAW EO A300-5320-42722-FSDR REXA2022062701365Stringer · corrodedSTGR 21R IS CORRODED BETWEEN FS 333.00-349.00. REMOVED & REPLACED STRINGER IAW CRJ 900 SRM 51-40-11-001-001-A01 & 51-42-06-001-001-A01.SDR REXA2022062701363Stringer · corrodedSTRINGER/SH670-31636-1/CORRODED/STRINGER/SH670-31636-1 STRINGER/SH670-31636-1/CORRODEDSDR REXA2022062701361Splice · corrodedSTGR SPLICE (JOINT PIECE) 21R IS CORRODED AT FS 333.00. REMOVED & REPLACED SPLICE IAW CRJ 900 SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01 & 51-42-21-001-001-A01.SDR REXA2022062701347Frame · corrodedF.S.847+16 FRAME IS CORRODED FROM STGR 26L TO 26R. SPLICE REPAIRED FRAME IAW CRJ 900 SRM 53-00-06-201-001-A03.SDR REXA2022062301331Striker · corrodedLOWER SERVICE DOOR SURROUND HAS MULTIPLE SPOTS OF CORROSION. REMOVED & REPLACED SEAL STRIKER FITTING IAW CRJ 900 SRM 51-40-11-001-001-A01, 51-42-21-001-001-A01 & 51-42-06-001-001-A01.SDR REXA2022062201324Beam · corrodedFRAME STA 1031, LBL9, FLOOR BEAM CORRODED TO FS 1051. SPLICE REPAIRED BEAM IAW CRJ 900 SRM 53-00-41-201-001-A03.SDR REXA2022062201322Frame · corrodedFRAME CORRODED @ FS 927 BETWEEN STGR 27 AND STGR 25R. SPLICE REPAIRED FRAME IAW CRJ 900 SRM 53-00-06-201-001-A03SDR CALA2022061301490Beam · corroded(SUPPORT TASK) CORROSION ON CREASE BEAM INNER CHORD AT LBL64 APP ROX STA 1630, TRANSCRIBED FROM HAECO GSO NRC 9280931SDR CALA2022061301489Pressure Plate · corroded(SUPPORT TASK) LIGHT SURFACE CORROSION ON AFT DECK PRESSURE PLATE UPPER UPPER SURFACE LOCATED AT STA 1681 APPROX. RBL 60, TRANSCRIBED FROM HAECO GSO NR 9280939SDR IXXA2022061201Support Web · corrodedALC PDU MOUNT STA 1346 LBL33 CORRODEDSDR REXA2022072001625Seat Track · corrodedRIGHT SIDE SEAT TRACK (RAIL) SEGMENT BETWEEN FS485 TO FS572.5 IS CORRODED. REMOVED & REPLACED SEAT RAIL IAW CRJ 900 AMM 53-00-49-000/400-801-A07
Back to JASC 5320