JASC 5210
Service difficulty reports · 45,724
Reports filed under 5210 · Passenger/Crew Doors, 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 = '5210' 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 = '5210' 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 SWIA200616967Angle · crackedPAX DOOR FORWARD TOP ANGLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS IAW REO 601R-52-11-279 NOTES 5-10 AND SKYWEST RII 52-401.SDR SWIA200616966Anchor Fitting · crackedPAX DOOR AFT ANCHOR FITTING CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW ANCHOR FITTING P/N 601R38074-5 PER CRJ 200 SB 601R-52-116 ITEM 2B STEPS 1-10.SDR SWIA200616965Anchor Fitting · crackedPAX DOOR FORWARD ANCHOR FITTING CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW ANCHOR FITTING P/N 601R-38074-6 PER CRJ 200 SB601R-52-116 ITEM 2-B STEPS 1-10.SDR SWIA200616964Attach Angle · crackedPAX DOOR AFT ATTACH ANGLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS ON AFT SIDE DRAG ANGLE PER REO NR 601R52-11-513, AND PER SKYWEST RII 53-401.SDR QXEA200602224Skin · nickedPDX: FWD AIRSTAIR DOOR EXTERIOR SKIN HAS NICK AFT MID SECTION. MAINTENANCE REPAIRED IAW RD 8/4-53-666, NDTM PART 6, 51-00-04, Q400 SRM 51-21-10-380-801, SRM 51-25-10-370-801 AND SRM 51-25-15-370-801.SDR TRAX200600213Step · brokenAIRSTAIR DOOR STEP BROKEN.SDR A6WA200640182Door · damagedMAIN PAX DOOR DROPS 1 FOOT PRIOR TO GROUND. SOME STRUCTURAL DAMAGE INCURRED ON PAX DOOR AS A RESULT OF COMPONENT FAILURE. MAINTENANCE REPAIRED PAX DOOR IAW AMM 52-11-17-400-802, BOMBARDIER REO 601R-52-11-702, BSC EO 601R-52-9149, BSC EO 601R-52-91-46A, SRM 5SDR TRAX200600206Step · crackedASD 3RD STEP FROM TOP FWD AND AFT SIDE SKIN CRACKED.SDR A6WA200640183Skin · crackedAFT PAX DOOR SKIN AT RADIUS OF STEP 2 AND 3 CRACKED IN 2 PLACES. MAINTENANCE PAX DOOR SKIN IAW BOMBARDIER REO 601R-52-11-702. (M)SDR A6WA200640181Drag Angle · buckledPASSENGER DOOR AFT DRAG ANGLE IS BUCKLED IN AREA OF ASSIST MOTOR CABLE PULLEY. MAINTENANCE REPAIRED AFT DRAG ANGLE IAW BOMBARDIER REO 601R-52-11-513. (M)SDR UPS06446973Reveal · crackedINSPECTION TYPE:C M/D R1 DOOR CUTOUT FWD UPPER CORNER REVEAL FOUND CRACK. CRACK LENGTH .75 INCH. CORNER REVEAL REPLACED AS PER SRM 51-10-01 PG 9 AND INSTALLED AS PER SRM 51-30-02.SDR SWIA200616984Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED ANGLE SECTION AND THE SPLICE ANGLES FOR PAX DOOR AFT DRAG ANGLE REPAIR PER CRJ200 REO 601R 52-11-513 STEPS 6-10.SDR SWIA200616983Handle · crackedPAX DOOR OUTER HANDLE CRACKED AROUND RADIUS, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED PAX DOOR OUTER HANDLE PER TASK 52-11-03-400-802 SUBTASK 52-11-03-420-003 PG 410-411. OPERATIONAL CHECKS GOOD.SDR UPS06446944Fitting · crackedINSPECTION TYPE:C M/D LT NR 3 DOOR FWD LOWER CORNER REVEAL FITTING FOUND CRACKED AS MARKED CRACK LENGTH 1/2". REVEAL FTG REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR 06FDEA1775Door Frame · corrodedMAIN CABIN STATION 1901 R4 DOOR AFT JAMB STOP FITTING ATTACHMENT BOLTS LONG 17-27 CORRODED. BOLTS REMOVED BURNISHED REF SRM 51-00-01. BOLTS REINSTALLED, SEALED AND LPS APPLIED TO AREA REF SRM 51-21-01.SDR 06FDEA1774Door Frame · corrodedSTATION 1259-1301 R3 DOOR JAMBS FWD AND AFT STOP FITTING ATTACHMENT BOLTS CORRODED LONG 17-27. CORROSION CLEANED UP IAW SRM 51-21-01 VOL II. PAINTED AND LPS TREATED.SDR 06FDEA1776Stop Fitting · corrodedMAIN CABIN STATION 795-849 R2 DOOR JAMBS STOP FITTING ATTACHMENT BOLTS LONG 17-27 CORRODED. FASTENER RUST REMOVED AND TREATED WITH LPS 3, REF SRM 51-21-01.SDR USAA060672Skin · crackedFWD ENTRY DOOR CRACKED. REPAIR DOUBLER INSTALLED IAW SRM 52-10-16, DEFECT SIZE: .5 INCH.SDR USAA060675Web · gougedAFT ENTRY DOOR, LOWER HINGE COURT GOUGED. REMOVED DAMAGED WEB AND INSTALLED NEW WEB IAW SRM 51-10-02 EA 76929, DEFECT SIZE: .50 INCH.SDR FDKA200605088Mechanism · lack of lubeTHE CREW REPORTED THAT THE MAIN PASSENGER DOOR WAS HARD TO CLOSE. MAINTENANCE CLEANED AND LUBED DOOR.SDR F3LA200600043Hook · wornDURING C-4 CHECK, INSPECTION REPORTED L2 DOOR GEARBOX ASSY HOOK WORN. REPLACED GEARBOX HOOK PER AMM 52-13-21-400-001, STEP 3C(17)(C) THRU (E).SDR 0600921226Bottle · dischargedDURING LINE CHECK FOUND DOOR 2L DOOR ASSIST BOTTLE DISCHARGED. PEK LINE MAINTENANCE DEFERRED PER MEL 52-10, DDG PERFORMED, LIDS ENTRY MADE AND DOOR PLACARD. NRT LINE MAINTENANCE REINFLATED AND PRESSURIZED DOOR 2R RESERVOIR AS PER AMM 52-10-01. REQUIRED INSPSDR UPS06446931Door Frame · crackedR3 DOOR AFT FRAME UPPER CORNER CRACKED, CRACK LENGTH 1 INCH. R3 DOOR AFT FRAME UPPER CORNER REPAIRED AS PER SRM 52-10-02 FIG 10.SDR TRAX200600199Sill · corrodedASD LOWER SILL UPPER SURFACE FOUND CORRODED.SDR A6WA200640193Handle · unlatchedON CLIMB OUT (OUTER PAX DOOR HANDLE UNSTOWED MESSAGE) FOLLOWED BY DEPRESURIZATION. UPON RETURN TO GATE FOUND L1 DOOR HANDLE IN UNLATCHED POSITION. INSPECTED DOOR IAW AMM, NO DEFECTS NOTED. REF 152478/3 FOR PRESSURIZATION CHECK. REF 152478/3- PERFORMED PRESSDR TRAX200600163Drag Angle · crackedFOUND PAX DOOR AFT DRAG ANGLE CRACKED. REMOVED CRACKED SECTION OF PAX DOOR AFT DRAG ANGLE. NDT PERFORMED ON W/C295. FABRICATED REPAIR DETAILS FROM 601R31907-301S IAW REO 601R-52-11-513. OK TO INSTALL. INSTALLED REPAIR DETAILS IAW REO 601R-52-11-513. (CLOSED)SDR AWXA200600860Skin · crackedMCN - DURING C19 CHECK DISCOVERED THE L1 DOOR STRUCTURE INNER PANEL HAD A CRACK, .25 INCHES, AT THE OUTER EDGE, MID AREA. MAINTENANCE CUT OUT AND REMOVED DAMAGED PORTION OF INNER PANEL ON THE L1 DOOR IAW BOEING 737-300 SRM 51-70-13-0G FIG 1. FAB`D PLATE IAW SDR TRAX200600192Step · brokenBOTTOM ASD STEP BROKEN.SDR TRAX200600191Step · brokenBOTTOM ASD STEP IS BROKEN.SDR AWXA200600861Door Frame · crackedMCN - DURING C19 CHECK DISCOVERED L1 DOOR FRAME CRACKED AT THE 5TH AFT STOP. MAINTENANCE CUT OUT AND REMOVED DAMAGED SECTION OF FRAME ON THE L1 DOOR AT THE AFT 5TH STOP IAW BOEING 737-300 SRM 51-70-11-0G. FABRICATED REPAIR ANGLE IAW BOEING 737-300 SRM 51-70-SDR A6WA200640177Anchor · crackedPAX DOOR AFT CABLE ANCHOR ASSY, P/N 601R380741-3 IS CRACKED, APPROX 1.5 INCH IN LENGTH. REMOVED AND REPLACED AFT COUNTERBALANCE ASSY ANCHOR FITTING WITH NEW P/N 601R31976-1, IAW CRJ-200 AMM 52-11-17 AND SB 601R-52-116 REV C. (M)SDR TRAX200600178Step · crackedASD FIRST STEP WHEN OPEN CRACKED, RESOLVED ON W/O: 20097 TASKCARD: N/R-00083. REMOVED AND REPLACED ASD FIRST STEP IAW AMM 52-11.SDR USAA060647Skin · dentedFOUND DENT FORWARD ENTRY DOOR 4.0" AFT OF FWD EDGE. INSTALLED SKIN DOUBLER IAW SRM 51-70-13, DEFECT SIZE: .5".SDR SWIA200617007Handle · crackedPAX DOOR OUTER HANDLE CRACKED AT RADIUS, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED PAX DOOR OUTER HANDLE ASSY PER AMM 52-11-03-420-003. OPERATIONAL CHECKS GOOD.SDR QXEA200601299Fitting · wornYYC - C4 FUSELAGE INTERIOR LEFT HAND STATION X 252, STRINGER 11 DOOR SURROUND STOP UPPER FITTING WORN. REPAIRED IAW RD8-53-3933.SDR FDKA200604078Structure · damagedDURING ROUTINE OVERNIGHT MAINTENANCE SCRATCHES/DAMAGE WERE NOTED ON THE MAIN CABIN DOOR. MAINTENANCE COMPLIED WITH RO.SDR TRAX200600145Anchor Fitting · corrodedCORROSION FOUND ON ASD AFT SWIVEL ANCHOR SERRATED PLATE BASE (BASE PLATE).SDR AALA20090612TUL04Pan · gougedDOOR HANDLE PAN GOUGED. REPLACED DOOR HANDLE PAN PER ESO 60657.SDR SWAA061425Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR CUTOUT FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR MASA200601197Door · lack of lubeMAIN ENTRANCE DOOR HARD TO CLOSE. MX LUBED DOOR AND OPS CHECKED.SDR 2006UALA00812Frame · damagedFOUND FWD ENTRY DOOR SN 497 AFT SIDE FRAME HAS DEEP WEAR SPOT AT OB OF TOP STOP FITTING PIN.SDR CALA0600140Angle · corrodedR2 DOOR Z-ANGLE CORRODED. REPLACED Z-ANGLE PER SRM 51-40-02.SDR YENA200638Flap · openUPON CLIMBOUT NOTICED LOUD VIBRATION NOISE OF F/O'S RIGHT SIDE. NOTICED A/C HAD NOT PRESSURIZED ONLY SHOWING A CAB ALT OF 100 FEET AT 13000 MSL. EICAS INDICATION SHOWED CABIN ALT -300 CABIN RATE -750, A PRESS OF 2.6 PSI AND A LFE OF 0. A/C NEVER PRESSURIZEDSDR 06FDEA1595Bracket · dentedDENT AFT BRACKET AT DOOR 2R LOWER SIDE. REPLACED BRACKET AS PER DRAWING ADA3760 AND SRM 51-35-01 VOL2 (MAJOR REPAIR).SDR 06FDEA1594Bracket · crackedCRACK FWD BRACKET AT DOOR 4R LOWER SIDE. REPLACED BRACKET AS PER DRAWING ADA3760 AND SRM 51-35-01 VOL2 (MAJOR REPAIR).SDR SWIA200616963Handle · crackedPAX DOOR OUTER DOOR HANDLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. REPLACED PAX DOOR OUTER HANDLE IN ACCORDANCE WITH CRJ200 AMM 52-11-03-400-801-A01.SDR SWIA200616874Angle · crackedMAIN DOOR HAS CRACK IN ANGLE ON AFT SIDE 1' FROM DOOR MOTOR PULLEY, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED 601R 52-11-513-1 ANGLE SECTION AND 601R 52-11-513-2 AND -3 SPLICE ANGLE ON PAX DOOR.SDR SWIA200616867Structure · crackedMAIN DOOR CRACK ON TOP LEFT SIDE C 4' FROM DOOR HINGE, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED 601R 52-11-279-1 REPAIR ANGLE PER CRJ200 REO 601R 52-11-279. RII 52-101 COMPLETE.SDR SWIA200616866Structure · crackedMAIN DOOR CRACKED ON TOP RIGHT SIDE 4' FROM DOOR HINGE, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED 601R 52-11-279-1 REPAIR ANGLE PER CRJ200 REO 601R 52-11-279. RII 52-401 COMPLETE.SDR SWIA200616989Handle · crackedPAX DOOR OUTER HANDLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW OUTER PAX DOOR HANDLE PN 601R31763-1PER CRJ 200 AMM 52-11-03-400-802. OPERATIONAL CHECKS GOOD.
Back to JASC 5210