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 AALA202301276806Fitting · wornAIRCRAFT IN BASE MAINTENANCE: 80VU RACK RIGHT HAND LOWER LATERAL FITTING MAKING CONTACT WITH AIRCRAFT STRUCTURE DUE TO BUSHING MIGRATION. MAINTENANCE REPLACED LOWER LATERAL FITTING PER EA 341160.SDR SWAA2022113066500Support Angle · crackedCRACKED SUPPORT ANGLE BS 695,BL 0. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02, SRM 51-10-02, STEP 9, AND DWG 273A9110, SHEET 6, REV A.SDR SWAA2022111766440Support · corrodedFWD CARGO BILGE SIDEPLATE SUPPORT Z STA 500B+15 TO STA 500I RBL 21 S-26R WL 156 HAS CORROSION AS MARKED. 124-003 / [01] REMOVED CORROSION ON Z CHANNEL FROM STA 500B TO STA 500I RBL 21 S-26R WL 156. MATERIAL REMOVED 0.010'; MATERIAL REMAINING 0.030'; ORIGINAL MSDR AALA202211160573Baffle · damagedAIRCRAFT IN BASE MAINTENANCE: LEFT BAFFLE HAS OVERSIZED FASTENER HOLES LOCATED BETWEEN STA 500D AND 500E AND LEFT BUTT LINE 24. INSTALLED NEW BAFFLE PER AARD 53-00-01-6.SDR AALA202211166443Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND BAFFLE CRACKED AT FASTENER HOLE LOCATED AT STA 500C AND 500D AND LEFT BUTT LINE 24.SDR AALA202211168183Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND BAFFLE CRACKED AT FORWARD FASTENER HOLE LOCATED AT STA 500 TO 500A. REMOVED AND REPLACED BAFFLE PER AARD 53-00-01-6.SDR SWAA2022111666357Floor Support · crackedPASS CABIN FLOOR SUPPORT CRACKED AT STA 540; LBL1 (MARKED) / [01] STA. 540 LBL 1 FLOORBOARD PANEL HOLES LOCATED PER SRM 51-40-02.SDR SWAA2022111666358Floor Support · crackedPASS CABIN FLOOR SUPPORT CRACKED AT STA 540; RBL1 (MARKED) / [01] STA. 540 LBL 1 FLOORBOARD PANEL HOLES LOCATED PER SRM 51-40-02.SDR REXA2022111502541Gusset · corrodedFWD INTERCOSTAL GUSSET AT STGR 20R @ FS 349.00 HAS CORROSION. REPLACED FWD INTERCOSTAL GUSSET IAW SRM 51-23-00-001-001-A01 AND SRM 51-42-21-001-001-A01.
"SDR ASAA2022103140735Intercostal · corrodedAFTER REMOVAL OF AFT PIT R/H TRANSITION FOUND INTERCOSTAL STA 747 TO 767 TO BE CORRODED. GROUNDED - YES. FOUND TO HAVE 100% MAT. LOSS REMOVED AND REPLACED INTERCOSTAL IAW B737-700 SRM 51-40-02-0G-0W=1 O=.040 R=0 L=2 D=100%.SDR REXA2022110302395Frame · corrodedFRAME AT FS 661.00 BETWEEN STGR 17L AND 18L IS CORRODED. REPAIRED IAW REO NO 690-53-31-680 AND CRJ900 SRM 53-00-06-201-001-A03, FIG. 53-00-06-991-883.SDR FDEA202210312701Fitting · corrodedMAIN CABIN - STA 324-345 RBL2 INTERCOSTAL IS CORRODED AT FLOOR PANEL HOLES REMOVED, FABRICATED AND INSTALLED NEW INTERCOSTAL IAW B757 DWG 141N5160 REV CD AND 141N5161 REV -SDR DALA2022110207099Web · crackedCRACKS (2 PLACES) ON UPPER WEB OF AFT CABIN BULKHEAD DOOR. SUMMARY OF NRC 00063: UPPER WEB OF AFT CABIN BULKHEAD DOOR WAS REPLACED PER B717 SRM 51-41-05-0G PAR. 8 AND SRM 51-40-02-0G. (LP #2477471)SDR DALA2022110107079Strap · corrodedDURING INSPECTION FOUND CORROSION STRAP LOCATED ON BS 887 BTW STR 25R TO STR 26L AT AFT CARGO COMPARTMENT. REPLACED STRAP LOCATED ON BS 887 BTW STR 25R TO STR 25R TO STR 26L AT AFT CARGO COMPARTMENT AS PER B737-900 SRM 51-40-02 AND SRM 51-10-02, ITEM 9 AND DWGSDR YENA2022110101058Floor Support · corrodedDURING HEAVY MAINTENANCE: INITIAL INSPECTION "CPCP FINDING": CORROSION IN LATERAL FLOOR SUPPORT LOCATED FROM Y= -1100 TO Y= -1270.0 AND FROM FR12 TO FR 16 IN PASSENGER CABIN FLOOR STRUCTURE W1; LATERAL FLOOR SUPPORT LOCATED FROM Y=-1100.0 TO Y=-1270 AND FR 12-SDR DALA2022110107061Angle · crackedCRACK ON CLIP ANGLE NEAR TO UPPER BELLCRANK OF AFT CABIN BULKHEAD DOOR. SUMMARY OF NRC 00065: CLIP ANGLE (FITTING ASSY) NEAR TO UPPER BELLCRANK OF AFT CABIN BULKHEAD DOOR WAS FABRICATED AND REPLACED PER DWG 3917863 REV B AND B717-200 SRM 51-41-05-0G. (LP #2477SDR F3LA2022112900155Shear Plate · crackedREFERENCE PEMCO N/R# 13031.0334 AFT WET AREA RH SHEAR PLATE CRACKED. REMOVED AND REPLACED AFT WET AREA RH SHEAR PLATE IAW SRM 51-72-11-911-001SDR AALA202211152685Support · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO AFT BULKHEAD LOWER BULKHEAD TO FLOOR SUPPORT LOCATED AT STA 500I LEFT BUTT LINE 21 TO RIGHT BUTT LINE 21 HAS CORROSION. REMOVED AND REPLACED FLOOR SUPPORT PER SRM 51-40-02-0G.SDR REXA2022111102535Seat Track · corrodedCORROSION FOUND ON SEAT TRACK RBL 9 BETWEEN F.S. 661+32-F.S. 693.00 INSTALLED NEW SEAT TRACK ON RBL 9 BETWEEN F.S. 661+32-F.S. 693.00 IAW CRJ900 AMM 53-00-49-400-801 (CONFIG A07).SDR REXA2022110302403None · corrodedRBL 9 ATTACHING CLIP TO "J" ANGLE CORRODED AT FS 280 FABRICATED AND INSTALLED J ANGLE ATTACHMENT CLIP ON RBL 9 TO 'J' ANGLE IAW CRJ900 SRM 51-42-06-001-001-A01 AND 51-42-13-001-001-A01SDR REXA2022110302402Seat Track · corrodedCORROSION FOUND ON SEAT TRACK RBL 9 BETWEEN F.S. 661+32-F.S. 693.00 INSTALLED NEW SEAT TRACK ON RBL 9 BETWEEN F.S. 661+32-F.S. 693.00 IAW CRJ900 AMM 53-00-49-400-801 (CONFIG A07).SDR REXA2022110302401Post · corrodedLBL 9 POST AT FS 280.00 IS CORRODED BETWEEN LH AFT WEB. REPAIRED LBL 9 POST FS 280.00 CORROSION ON LH AFT WEB PN CC670-34094JP1 AND JP2 IAW CRJ 900 SRM 53-11-10-201-004-A01SDR REXA2022110302400None · corrodedLH FLOOR SILL BETWEEN FS 913.00 AND 969.00 IS CORRODED IN MULTIPLE LOCATIONS. REMOVED AND REPLACED LH FLOOR SILL IAW CRJ900 SRM 51-42-06-001-001-A01 AND REO 690-53-51-350 REV-- DATED 2022-10-26SDR REXA2022110302399Stringer · corrodedCORROSION FOUND ON STGR 21R BETWEEN FS 409.00-485.00. INSTALLED STR21R PN SH670-31385-1S AND FS447.40 SPLICE PN SH670-33252-1 IAW CRJ900 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01SDR REXA2022110302398Cleat · corrodedCORROSION FOUND ON SUPPORT ANGLE AT FS 394.00 AT STGR 19L. REMOVED FABRICATED AND INSTALLED NEW STRINGER CLEAT @ FS. 394.00 STGR 19R IAW CRJ900 SRM 51-42-06-001-001-A01SDR REXA2022110302397Stringer · corrodedCORROSION FOUND ON STGR 20R BETWEEN FS 364.00-379.00. REMOVED AND REPLACED NEW STRINGER P/N SH670-31405-2S AT FS 364 IAW CRJ 900 SRM 51-42-06-001-001-A01SDR REXA2022110302396Stringer · corrodedCORROSION FOUND ON STGR 19R BETWEEN FS295-310. REMOVED AND REPLACED STRINGER 19R FROM F.S 280-F.S 319 IAW CRJ 900 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01.SDR REXA2022110302394Frame · crackedL/H COCKPIT FRAME F.S.235 IS CRACKED. REPAIRED L/H COCKPIT FRAME FS 235 CRACK IAW MHIRJ REO 690-53-11-1474SDR REXA2022110302392None · corrodedLBL 9 ATTACHING CLIP TO "J" ANGLE CORRODED AT FS 280 FABRICATED AND INSTALLED J ANGLE ATTACHMENT CLIP ON RBL 9 TO 'J' ANGLE IAW CRJ900 SRM 51-42-06-001-001-A01 AND 51-42-13-001-001-A01SDR REXA2022110302390Frame · corrodedFRAME AT FS 927.00 IS CORRODED BETWEEN STGR 25R AND 26R. COMPLIED WITH SPLICE REPAIR OF FS 927.00 BETWEEN STGR 25R AND 26R IAW CRJ 900 SRM 53-00-06-201-001-A03.SDR REXA2022110302389Stringer · corrodedSTRINGER 20R BETWEEN FS 597.00 AND 613.00 IS CORRODED. COMPLIED WITH STRINGER SPLICE REPAIR ON STRINGER 20R BETWEEN FS 597.00 AND FS 613.00 IAW CRJ-900 SRM 53-00-03-201-001-A02 REPAIR S6295 TYPE Z8 REPAIR.SDR REXA2022110302388Frame · crackedFRAME AT FS 645.00 BETWEEN STGR 17L AND 18L IS CORRODED. REMOVED AND INSTALLED NEW SECTION FRAME AND SPLICE REPAIR ON FS645 BETWEEN STR16LH-STR18LH IAW REO NO 690-53-31-680 DATE 2022-10-14, AND SRM 53-00-06-201-001-A03, FIGURE 53-00-06-991-879, 51-42-06-001-00SDR ASAA2022103040543Profile · corrodedFORWARD CARGO R/H OUTBOARD FLOOR SUPPORT FRAME UPPER SURFACE HAS CORROSION FR31 TO FR34. GROUNDED - YES. REMOVED AND REPLACED NEW PROFILE PLATE AT FR31 TO FR34 AND Y765 IAW A320 SRM REV 142 53-21-14-03-A ITEM 15 AND SRM 51-72-11-911-001.SDR DALA2022110107077Baffle · corroded(LOG 2475268) DURING INSPECTION FOUND CORROSION ON AFT CARGO COMPARTMENT FLOOR BAFFLE STA 747-767, RBL 21, WL 156. REPLACED FLOOR BAFFLE IN AFT CARGO @ STA 747-767, RBL 21, WL 156 IAW BOEING DWG 146A7500 AND B737-900 SRM 51-40-02-0G.SDR UIEA2022103101181None · noneCORROSION-SKIN, FWD CGO COMPARTMENT BILGE SURFACE STA 740~760. S-46R~S-47R(<P>1) BLEND OUT THE DAMAGE AREA I.A.W SRM 51-10-02. REV=52 2) PFM NOT INSP REFER TO JOB CARD ATTACHING SHEET NO=0271928 3) MEASURED REWORK AREA DEPTH=0.005", LENGTH=2", WIDTH=2" IT WAS SDR UIEA2022103101180None · noneCORROSION-SKIN, FWD CGO COMPARTMENT BILGE SURFACE STA 760~780, S-45L-S-47L.(<P>1) BLENDED OUT THE DAMAGE AREA I.A.W. SRM 51-10-02 REV. 52. 2) PFM NOT INSP REFER TO JOB CARD ATTACHING SHEET NO 0271927. 3) MEASURED REWORK AREA DEPTH= 0.01" LENGTH= 3.2" WIDTH=1.5SDR JR2R20221030996Gusset · corrodedFLOOR GUSSET AT FR90 RBL24 CORRODEDSDR JR2R20221030973Gusset · corrodedFR89 BL0 GUSSET CORRODEDSDR JR2R20221030997Channel · corrodedRH MOP SILL FROM FR88 TO FR90 CORRODEDSDR JR2R20221030971Shear Panel · corrodedFR87-FR88 RBL 9 - RBL24 SHEAR PANEL CORRODEDSDR JR2R20221030969Gusset · corrodedFR90 RBL9 GUSSET CORRODEDSDR JR2R20221030975Doubler · corrodedFR87 RBL9 REPAIR DOUBLER CORRODEDSDR JR2R20221030970Gusset · corrodedFR88 RBL36 GUSSET CORRODEDSDR JR2R20221030972Gusset · corrodedFR89 RBL9 GUSSET CORRODEDSDR JR2R20221030974Shear Panel · corrodedFR87-FR88 LBL9-RBL9 SHEAR PANEL CORRODEDSDR JR2R20221030919Support · corrodedCORROSION FOUND IN AFT CARGO AT FR74 AND STR29LSDR JR2R20221030976Gusset · corrodedFR85 - FR84 RBL9 GUSSET ON INTERCOSTAL CORRODEDSDR AALA202212165870Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. MAINTENANCE REPALCED SHEAR PLATE PER SRM 51-72-11.SDR AALA202211309596Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND AFT PASSENGER / CREW DOOR CUT OUT LOWER SILL AT FR 67 AND S23R. MAINTENANCE REPLACED THE LOWER SILL PER SRM 53-41-14-300-001.SDR ASAA2022102940957Shear Plate · corrodedMAIN CABIN LH AFT FLOOR SHEAR PLATE UPPER SURFACE CORRODED AT FR70 GROUNDED - YES. REMOVED AND REPLACED MAIN CABIN FLOOR LH AFT SHEAR PLATE UPPER SURFACE AT FR70 STGR 22L
Back to JASC 5320