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 SWIA200617368Support · crackedPAX DOOR STEPS FORWARD SUPPORT FRAME CRACKED AT LOWER END, DISCOVERED DURING C-CHECK INSPECTION. NEW SUPPORT FRAME INSTALLED IAW SRM 120 51-10-02 ALSO IAW RII 52-800-1000.SDR SWIA200617366Boss · corrodedPAX DOOR INTERCONNECT MID TORQUE TUBE AFT BOSS CORRODED, DISCOVERED DURING C-CHECK INSPECTION. REPLACED PAX DOOR INTERCONNECT MID TORQUE TUBE ASSY IAW 32-13-00.SDR SWIA200617543Handle · crackedPAX DOOR HANDLE CRACKED SEVERAL PLACES, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED PAX DOOR OUTER HANDLE PER CRJ200 AMM 52-11-03-400-802.SDR SWIA200617542Step · crackedPAX DOOR STAIR CRACKED FWD NR 3 STEP, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PER REO 601R 52-11-702.SDR SWIA200617541Step · crackedPAX DOOR STAIR CRACKED AT AFT NR 3 STEP, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PER REO 601R 52-11-702.SDR SWIA200617536Step · crackedPAX DOOR AFT SIDE STEP 2ND FROM TOP WHEN DOOR IS OPEN CRACKED IN CORNER, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED DOUBLER AND ANGLES ON AFT SIDE OF PAX DOOR PER REO 601R-52-11-702.SDR SWIA200617535Intercostal · crackedPAX DOOR INTERCOSTAL AFT SIDE INSIDE ACCESS PANEL OPENING 832BR IS CRACKED AT RADIUS, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW INTERCOSTAL P/N 601R31902-318A (PO 176240) IN THE AFT SIDE LOWER CORNER OF PAX DOOR IAW CRJ200 SRM 52-00-00 AND SRM 51-40SDR SWIA200617528Panel · crackedPAX DOOR AFT SIDE PANEL CRACKED BEHIND HAND RAIL SUPPORT, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS OT AFT SIDE PAX DOOR BEHIND HAND RAIL SUPPORT AS PER REO 601R-52-11-702.SDR SWIA200617527Structure · crackedCRACK AT AFT DOOR EDGE MEMBER LOWER PART OF DOOR UNDER FOLDING STEP, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS PER CRJ200 REO 601R-52-11-279 NC REO AND RII52-900-1001.SDR SWIA200617526Angle · crackedCRACK AT LOWER EDGE OF OTBD (DOOR OPEN) DOOR ASSIST Z ANGLE, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW OTBD Z ANGLE PN 601R31-7745-7 PO 71461 PER CRJ200 SRM 51-42-06 PG 1-8.SDR TRAX200600893Anchor Fitting · crackedPAX DOOR CABLE FWD ANCHOR FITTING CRACKED (MARKED).SDR SWIA200617522Web · crackedPAX DOOR AFT SIDE EXTRUSION INSIDE DOOR WEB THAT HOLDS DOOR ASSIST MOTOR IS CRACKED AT LOWER RADIUS, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED STIFFENER PER DWG 601R 317745 AND CRJ200 SRM 51-42-06.SDR SWIA200617521Doubler · crackedPAX DOOR AFT SIDE (INSIDE ACCESS PNL 832AR) DOUBLER AT PULL IN CAM FRAME IS CRACKED AT CORNER RADIUS, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW DOUBLER P/N 601R318094-2 ON PAX DOOR IAW CRJ200 SRM 51-42-06 PAGE 10-18, 51-42-13 PAGE 4, 51-42-21 PAGE 1SDR SWIA200617520Web · crackedPAX DOOR AFT WEB CRACKED IN RADIUS UNDER HANDRAIL SUPPORT BRACKET, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED DOUBLER AND REPAIR ANGLES PER REO 601R 52-11-702.SDR SWIA200617519Web · crackedPAX DOOR FWD WEB CRACKED IN RADIUS UNDER HANDRAIL SUPPORT BRACKET, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED DOUBLER AND REPAIR ANGLES PER REO 601R 52-11-702.SDR SWIA200617518Drag Angle · crackedPASSENGER DOOR, DRAG ANGLE IS ON AFT SIDE OF DOOR IS CRACKED JUST ABOVE DOOR PULLEY, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED DRAG ANGLE SECTION P/N 601F5211513-1 AND SPLICE ANGLES IAW REO 601R-52-11-513.SDR EIA2006261Skin · crackedL-1 DOOR SKIN CRACKED IN LOWER AFT CORNER APPROX 12 INCHES FWD OF AFT EDGE EXTENDING FROM FASTENER HOLES. CUT OUT DAMAGE, FABBED AND INSTALLED REPAIR PER B747 SRM 52-10-02, FIG 9.SDR SWIA200617514Step · crackedPAX DOOR STAIR CRACKED AT FWD NR 3 STEP, HANDRAIL SUPPORT AREA, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW REPAIR PARTS PER REO 601R-52-11-702 REPAIR TO PAX DOOR STAIRS FWD AND AFT SIDE PANEL.SDR SWIA200617513Support · crackedPAX DOOR STAIR SUPPORT CRACKED ON AFT DRAG ANGLE, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW REPAIR PARTS PER REO 601R-52-11-513 REPAIR TO PAX DOOR STAIR AFT DRAG ANGLE.SDR KCSA061380Web · crackedR1 DOOR INNER WEB CRACKED AT LOWER CENTER LIGHTENING HOLE.SDR KCSA061379Web · crackedR1 DOOR INNER WEB CRACKED AT UPPER CENTER LIGHTENING HOLE.SDR SWIA200617288Handle · crackedPAX DOOR EXTERNAL HANDLE CRACKED AT LOCK RADIUS, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW PAX DOOR OUTER HANDLE ASSY PER CRJ 700 AMM 52-11-03-400-801-A01. OPERATIONAL CHECKS GOOD.SDR AWXA200601705Skin · crackedMCN - L1 DOOR INNER SKIN CRACKED AFT SIDE AT NR 6 FROM TOP STOP PIN CUTOUT. REPAIRED L1 DOOR INNER SKIN, AFT SIDE AT NR 6 FROM STOP PIN CUTOUT, IAW B737-300 SRM 51-70-13-0G, FIG 1.SDR TRAX200600808Door · malfunctionedCABIN DOOR WILL NOT LOCK.SDR QXEA200602691Panel · corrodedDOOR SHELL PANEL HAS CORROSION UNDER AL NUT AT FORWARD LOWER CORNER. REPAIRED IAW RD8-52-647 AND SRM 51-40-11.SDR EIA2006265Skin · crackedA 6.5 INCH VERTICAL CRACK ON R3 CABIN DOOR EXTERNAL L/E SKIN, 18 INCHES BELOW WINDOW. FABRICATED AND INSTALLED FILLERS AND DOUBLERS, DAMAGE REMOVED PER B747 SRM 51-10-02 PG 8-11.SDR RAIA00609044Handle · lack of lubeFLT NR 7978 - ORD - MAIN CABIN DOOR STUCK CLOSED. MAINTENANCE RELEASED THE PASSENGER DOOR HANDLE AND LUBRICATED BOTH THE HANDLES AND ROLLERS. OPS CHECKED NORMAL.SDR AWXA200601669Door Frame · crackedMCN - R1 DOOR AFT FRAME CRACKED AT THE 3RD AND 4TH STOP PIN CUT OUT FROM THE TOP, BS 328, S11R - S13R. REPAIRED R1 DOOR AFT FRAME AT THE 3RD AND 4TH STOP PIN CUT OUT FROM THE TOP, BS 328, S11R - S13R IAW ER 03-5200-06271-HF1.SDR SWAA063696Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR AFT FRAME CRACKED AT NR 3 DOOR STOP. REPAIRED DOOR FRAME SECTION PER SRM.SDR UPS06448207Vertical Beam · crackedINSPECTION TYPE-C NR 1R MED FWD LOWER CORNER VERTICAL BEAM FOUND CRACK APPROX 1.5 INCH LONG. NR 1R MED FWD LOWER CORNER VERTICAL BEAM REPAIRED IAW SRM 52-10-02 FIG 10.SDR UPS06448206Vertical Beam · crackedINSPECTION TYPE-C NR 2L MED FWD LOWER CORNER VERTICAL BEAM FOUND CRACK APPROX .7500 INCH LONG. NR 2L MED FWD LOWER CORNER VERTICAL BEAM REPAIRED IAW SRM 52-10-02 FIG 10.SDR TRAX200600790Door · stiffPAX DOOR VERY DIFFICULT TO CLOSE.SDR DL764060780Girt Bar · missing4R GIRT BAR MISSING INSTALLED MPN 141T6102-10 OPS CHECKS GOOD MCO AND PLAC REMO ETOPS CATEGORY (E): PROBLEMS WITH SYSTEMS CRITICAL TO ETOPS.SDR TRAX200600785Door · stiffPAX DOOR DIFFICULT TO CLOSE.SDR SWIA200617198Swivel · crackedAFT PAX DOOR LEVER SWIVEL CRACKED ANCHOR FITTING, DISCOVERED DURING MAINTENANCE INSPECTION. REMOVED AND REPLACED LEVER SWIVEL ON AFT ANCHOR FITTING AT PAX DOOR IAW 52-11-17. OPERATIONAL CHECKS GOOD, P/N 601R319741-1.SDR UPS06448209Vertical Beam · crackedINSPECTION TYPE-C M/D RT NR 5 DOOR INTERIOR FWD LWR CORNER VERTICAL BEAM FOUND CRACK, CRACK LENGTH 4.7500 INCH APPROX. M/D RT NR 5 DOOR INTERIOR FWD LOWER CORNER VERTICAL BEAM REPAIRED IAW SRM 51-10-02 FIG 10.SDR KCSA061351Fitting · corrodedR3 DOOR NR 6 FITTING CORRODED AND CRACKED AT STA 1270, WL 250.SDR QXEA200602612Torque Shaft · corrodedC3 PDX -THE INBOARD BEARINGS ON THE LATCH TORQUE SHAFT ARE RUSTY/CORRODED ON THE PASSENGER DOOR. REPAIRED IAW SRM 51-42-05, 51-42-15.SDR QXEA200602607Torque Shaft · corrodedC3 PDX - THE INBOARD BEARINGS ON THE LATCH TORQUE SHAFT ARE RUSTY/CORRODED ON THE REAR PASSENGER DOOR. REPAIRED IAW Q400 MM 52-00-00-830-803.SDR F3LA200600124Gust Lock · inoperativeFOUND GUST LOCK 1L INOP. ADJUSTED BUFFER PER AMM 52-11-12-820. RII INSPECTION ACCOMPLISHED. AIRCRAFT RELEASED FOR SERVICE.SDR MASA200602316Seal · dirtyASH GJT. MAIN CABIN DOOR SEAL WAS LEAKING. MX CLEANED DOOR SEAL.SDR AALA20060712Pin · installedMCO - LEFT NR 2 DOOR ASSIST BOTTLE FOUND BY FLIGHT ATTENDANT TO BE PINNED. CHECKED BOTTLE INSTALLATION AND INSURED IT WAS PROPERLY ARMED. REMOVED PIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR ASAA0680966Handle · stiffFOUND AFT CABIN DOOR HANDLE VERY HARD TO MOVE. LUBED DOOR HANDLE LOCKPINS. OP CHECKS NORMAL.SDR SWIA200617326Handle · crackedPAX DOOR EXTERIOR HANDLE IS CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW PAX DOOR OUTER HANDLE ASSEMBLY PER CRJ200 AMM 52-11-03-400-802. OPERATIONAL CHECKS GOOD.SDR SWIA200617325Intercostal · crackedINTERCOSTAL CRACKED IN UPPER RADIUS AT ACCESS HOLE 832BR ON PAX DOOR, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW INTERCOSTAL PER SRM 51-23-00 PG 4 AND SRM 51-42-06 PG 1-18 AND SRM 51-42-21.SDR SWIA200617324Intercostal · crackedINTERCOSTAL IN ACCESS HOLE 832AR UPPER CORNER CRACKED ON PAX DOOR, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW INTERCOSTAL PER CRJ200 SRM 51-42-13 PG 1 AND 2 AND SRM 51-42-20 PG 23.SDR SWIA200617323Drag Angle · crackedPAX DOOR DOOR STEP AFT DRAG ANGLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED FABRICATED REPAIR ITEMS, -1 ANGLE SECTION, 2 SPLICE ANGLES IAW CRJ 200 REO 601R-52-11-513A NOTES 8, 9, 10.SDR SWIA200617322Panel · crackedPAX DOOR FWD SIDE PANEL CRACKED AT BASE OF 2ND STEP, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED DOUBLER AND ANGLES AS PER CRJ 200 REO 601R-52-11-702 RII 52-900-1001 AND REO 601R-52-11-702.SDR DHL2006783003Door · damagedL1 ENTRY DOOR WEDGED IN STEPS. INSPECTED ENTRY DOOR , NO DEFECTS NOTED IAW M/M52-11-01.SDR 2007FA0000140Support · crackedAT FWD CABIN STA 328+6, DOOR 2R AFT STOP FTG INTERCOSTAL TEE SUPPORT, CRACKED. (K)
Back to JASC 5210