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 SWAA2022081628598Angle · corrodedCORROSION INNER CHORD ANGLE LOCATED BETWEEN BS312 TO BS344; LBL60 AND WL208.1 AT FWD GALLEY AREA 2022-381474 / [01] REPLACED INNER CHORD ANGLE LOCATED BETWEEN BS312 TO BS344; LBL60 AND WL208.1 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 ITEM 9; 51-40-02 AND DSDR SWAA2022081628589Floor Support · corrodedCORROSION FLOOR STRUCTURE INTERCOSTAL LOCATED BETWEEN BS312 TO BS328 ;LBL11 AND WL 208.1 AT FWD GALLEY AREA 2022-381458 / [01] REPLACED FLOOR STRUCTURE INTERCOSTAL LOCATED BETWEEN BS312 TO BS328 ;LBL11 AND WL 208.1 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02;SDR SWAA2022081628591Intercostal · corrodedCORROSION FLOOR STRUCTURE INTERCOSTAL LOCATED BTW BS 312 TO BS 328 RBL 12 AND WL 208.1 AT FWD GALLEY AREA 2022-381461 / [01] REPLACED FLOOR STRUCTURE INTERCOSTAL LOCATED BTW BS 312 TO BS 328 RBL 12 AND WL 208.1 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 ITEMSDR SWAA2022081628596Structure · corrodedCORROSION INNER CHORD LOCATED BTW STA 294.5 TO STA 360 LBL 58 AND WL 208.1 AT FWD GALLEY AREA 2022-381465 / [01] REPLACED INNER CHORD LOCATED BTW STA 294.5 TO STA 360 LBL 58 AND WL 208.1 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 ITEM 9 AND DWG 141A8310 SHEESDR IPXA2022081085096Floor Panel · damagedINSPECTION TYPE:CPN 131RG DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022081085102Floor Panel · damagedINSPECTION TYPE:CPN 131ZG DAMAGEDFABBED PER DREO A300-5320-16407-ESDR IPXA2022080484910Floor Panel · damagedINSPECTION TYPE:SEGPNL 151SF DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022080484909Floor Panel · damagedINSPECTION TYPE:SEGPNL 152UP DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022080484908Floor Panel · damagedINSPECTION TYPE:SEGPNL 131AH DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022080484907Floor Panel · damagedINSPECTION TYPE:SEGPNL 132SG DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022080484906Floor Panel · damagedINSPECTION TYPE:SEGPNL 151TF DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022080484905Floor Panel · damagedINSPECTION TYPE:SEGPNL 132PG DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022080484904Floor Panel · damagedINSPECTION TYPE:SEGPNL 152QF DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022080484903Floor Panel · damagedINSPECTION TYPE:SEGPNL 152VF DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022080484902Floor Panel · damagedINSPECTION TYPE:SEGPNL 132DG DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022080484901Floor Panel · damagedINSPECTION TYPE:SEGPNL 151VF DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022080484900Floor Panel · damagedINSPECTION TYPE:SEGPNL 131WG DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022080484898Floor Panel · damagedINSPECTION TYPE:SEGPNL 134SG DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022080484897Floor Panel · damagedINSPECTION TYPE:SEGPNL 152NG DAMAGEDFABBED PER SREO A300-5320-16407-ESDR SWAA2022072928469Bracket · crackedAFT CARGO BRACKET CRACKED AT STA 867; LBL 16. AFT CARGO BRACKET CRACKED AT WASTE TANK ENCLOSURE LOWER ANGLE STA 867 LBL 16. / [01] REMOVED BRACKET.;[02] REMOVED AND REPLACED BRACKET PER SRM 51-40-02;[03] REMOVED AND RE-INSTALLED CLOSE OUT PANEL LOWER L-ANGLE PSDR REXA2022072101637Seat Track · corrodedLH WALL SEAT RAIL BETWEEN FS897.00 AND FS985.00 REQUIRES REPLACEMENT. REMOVED AND REPLACED LH WALL SEAT RAIL P/N SH690-37542-1 BETWEEN FS897.00 AND FS985.00 IAW CRJ900 AMM 53-00-49-000-801-A19 AND 53-00-49-400-801-A19SDR REXA2022071801603Bracket · crackedSTGR3L BRACKET AT THE 280.00 BULKHEAD IS CRACKED. REPLACED PART PER SRM 51-42-06 AND 51-42-21.SDR CALA2022071501736Floor Support · corrodedSUPPORT TASK MAIN CABIN STA 720-724 RBL 65 GUTTER SUPPORT HAS CO RROSION ON UPPER SURFACE, TRANSCRIBED FROM HAECO GSO NR 9282390 REMOVED AND REPLACED GUTTER SUPPORT AT STA 720 TO 724 RBL-65 IAW B757-200 SRM 51-40-02, 51-40-05, DWG 143N5202. HAECO GSO MECH V 9SDR LR7A2022071303187Stiffener · crackedDURING SCHEDULED B-2 CHECK UNDER JOB CARD HB5302, FOUND AFT FUSELAGE SIDE STRUCTURE STIFFENER CRACKED AT FS862, LBL72, WL202. / REPAIR BY REPLACEMENT ACCOMPLISHED IAW LOCKHEED SMP583 SRM, CH. 51-60 & 51-70. NR#1000785364.SDR SWAA2022081828154Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BS847 TO BS867 AT LEVEL LBL30 AT AFT CARGO COMPARTMENT 2022-365483 / [01] REPLACED WEB - INTERCOSTAL LOC. BS847 TO BS867 AT LEVEL LBL30 AT AFT CARGO COMPARTMENT I.A.W B737-700 SRM 51-40-02 AND SRM 51-10-02 ITEM 9 AND DWG:149A810SDR SWAA2022081828156Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED ABOVE BS727B AT LEVEL LBL52 AT AFT CARGO COMPARTMENT 2022-365484 / [01] TOOL USED PN:NORTEC 600D;PN:200053402;DUE DATE:13-MAY-23;[02] TOOL USED PN:NORTEC 600D;PN:200053402;DUE DATE:13-MAY-23;[03] REPLACED ANGLE - SUPPORT LOCATED BSDR SWAA2022081828158Fitting · crackedCRACK ANGLE LOCATED BS947.5 AT LBL17 AFT CARGO COMPARTMENT 2022-365490 / [01] REPLACED NEW FITTING AND FASTENERS ON BS947 AT LBL17 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND DRAWING 149A8103 SHEET 6 REV-;[02] CORRECTIVE STEP 1<BR>REPLACED FITTING LOCASDR REXA2022081101842Cleat · corrodedSTR22R CLEAT AT FS310 CORRODED. 1.5" X .50" X .040" DEEP REMOVED AND REPLACED CLEATSDR REXA2022081101841Splice · corrodedSTR 23R SPLICE AT FS 333.00 HAS AREA OF CORROSION WITH 100% MATERIAL LOSS REMOVED AND REPLACED SPLICE.SDR SWAA2022080128209Support Angle · brokenBROKEN SUPPORT ANGLE BS 867 BTW STR 2R AND STR 3R AT PASSENGER CABIN 2022-384008 / [01] REPLACED SUPPORT ANGLE LOCATED BS 867 BTW STR 2R AND STR 3R AT PASSENGER CABIN IAW B737-700 SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 146A7901 SHEET: 22 REV: A.<BR>SEE INDISDR SWAA2022072928190Floor Support · crackedCENTER SECTION FLOOR SUPPORT LBL 0 TO LBL 24.75 CRACKED AT ATTACH POINT STA 540. / [01] REMOVED AND REPLACED PER SRM 51-40-02.;[02] VERIFIED REMOVED AND REPLACED PER SRM 51-40-02.SDR SWAA2022072928231Transition Panel · corrodedCORROSION ITEMS ONLY:::AFT CARGO; L ANGLE UNDER R/H SMALL TRANSITION ANGLE HAS HEAVY CORROSION FROM STA 767 THRU 787. / [01] PART REPLACED PER SRM 51-40-02SDR IPXA2022072584512Floor Panel · corrodedINSPECTION TYPE:3CMAIN CABIN FLOOR PANEL WSP0789-501 AT POS. 2 HAS CORROSION.REMOVED AND REPLACED FLOOR PANEL IAW SRM 51-31-01. (MINOR)SDR IPXA2022072084379Floor Panel · corrodedINSPECTION TYPE:3CMAIN CABIN FLOOR PANEL WSP0785-502 AT POS. 4 HAS CORROSION.REMOVED AND REPLACED FLOOR PANEL IAW SRM 51-31-01. (MINOR)SDR IPXA2022072084378Floor Panel · corrodedINSPECTION TYPE:3CMAIN CABIN FLOOR PANEL WSP0786-501 HAS CORROSION.REMOVED AMD REPLACED FLOOR PANEL IAW SRM 51-31-01. (MINOR)SDR IPXA2022072084377Floor Panel · corrodedINSPECTION TYPE:3CMAIN CABIN FLOOR PANEL WSP0788-501 HAS CORROSION.REMOVED AND REPLACED FLOOR PANEL IAW SRM 51-31-01. (MINOR)SDR IPXA2022072084375Floor Panel · corrodedINSPECTION TYPE:3CMAIN CABIN FLOOR PANEL WSP0785-501 HAS CORROSION.REMOVED AND REPLACED FLOOR PANEL IAW SRM 51-31-01. (MINOR)SDR IPXA2022072084374Floor Panel · corrodedINSPECTION TYPE:3CMAIN CABIN FLOOR PANEL WSP0790-501 HAS CORROSION.REMOVED AMD REPLACED FLOOR PANEL IAW SRM 51-31-01. (MINOR)SDR IPXA2022072084372Floor Panel · corrodedINSPECTION TYPE:3CCOURIER FLOOR PANEL WSP0785-502 HAS CORROSION.REMOVED AND REPLACED FLOOR PANEL IAW SRM 51-31-01. (MINOR)SDR REXA2022072101642Stringer · corrodedFS333-FS349, STR26L STRINGER CORRODED. REMOVED AND REPLACED CORRODED STRINGER STR26L,FS333-FS349 IAW CRJ700 SRM 51-42-06.SDR IPXA2022072084356Angle · crackedINSPECTION TYPE:CE/E FR 10 HAS A CRACKED ANGEL SUPPORT FITTING.REMOVED AND REPLACED IAW SRM 51-40-21.SDR IPXA2022071284115Floor Panel · damagedINSPECTION TYPE:CFWD CARGO FLOOR PANEL 132PG HAS MUTIPLE DAMAGES.FABBED PER SREO A300-5320-16407-ESDR IPXA2022071284107Floor Panel · damagedINSPECTION TYPE:CPNL 131RG IS DAMAGED.FABBER PER SREO A300-5320-16407-E.SDR IPXA2022071284102Floor Panel · wornINSPECTION TYPE:CMDC FLOOR PANEL 242GN HAS PUNCTURE.REPAIRED MDC FLOOR PANEL 242 GN NEEDED IAW EO:A300-5320-42722-F***SUPPLEMENTAL TO CORRECT SOURCE DOC#***SDR REXA2022121902712Intercostal · corrodedINTERCOSTALS CORRODED BEYOND LIMITS @ STRINGER 20R BETWEEN FS 310 AND FS 319 AND FS 319 AND FS 349 REMOVED AND REPLACED INTERCOSTALS @ STRINGER 20R BETWEEN FS 310 AND FS 319 AND FS 319 AND FS 349. SH670-32047-1 & -3SDR SWAA2022081727839Scuff Plate · crackedCRACK ON AFT CARGO CUT OUT CORNER SCUFF PLATE AFT POSITION AT AFT CARGO COMPARTMENT 2022-365459 / [01] TOOL USED: DIGITAL CALIPER: P/N: 500-196-30; S/N: B21141522; DUE DATE: 18-OCT-22.;[02] REPAIRED AFT CARGO CUT OUT CORNER SCUFF PLATE AFT POSITION AT AFT CARGSDR SWAA2022081627895Structure · corrodedCORROSION FLOOR STRUCTUREEXISTING REPAIR LOC. BS 986.5 AT RBL 39 AND WL 208.11 AFT GALLEY AREA 2022-381212 / [01] TOOL USED UT EQUIPMENT P/N: 45MG; S/N: 130066701; CAL DUE DATE: 08-APR-23;[02] TOOL USED PN:NORTEC 600D;PN:200053402;DUE DATE:13-MAY-23;[03] TOOL SDR REXA2022081101837Door Sill · corrodedAFT BAGGAGE DOOR SURROUND LOWER SILL CORRODED. 3.95" X 1.476" X .030" DEEP REMOVED AND REPLACED SILLSDR AALA202208023919None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON LEFT TRANSITION PANEL LOCATED AT STA 500F AND LEFT BUTT LINE 25. REMOVED AND REPLACED LEFT TRANSITION PANEL PER SRM 51-10-02.SDR AALA202208026049None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON LEFT TRANSITION PANEL LOCATED AT STA 500D AND LEFT BUTT LINE 25. REMOVED AND REPLACED LEFT TRANSITION PANEL PER SRM 51-10-02.
Back to JASC 5320