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 USAA2011112500010Spring · weakC1 CHECK, L1 DOOR EMERGENCY ESCAPE DEPLOYMENT GAS SPRINGS ARE WEAK. REPLACED L1 DOOR EMERGENCY ESCAPE DEPLOYMENT GAS SPRINGS ARE WEAK IAW B767 AMM 25-66-03-004-053 AND 25-66-03-404-067.SDR ASAA11410694Snubber · defectiveF/A REPORTS AFT LEFT DOOR L2 WILL NOT FULLY OPEN. REPLACED L2 DOOR SNUBBER PER AMM 52 41 71. OPS CHECK OF L2 DOOR NORMAL PER AMM 52 41 00.SDR USAA2011112200016Setscrew · out of adjust2S CHECK - OUT OF ADJUSTMENT RIGGING POINT OF REDUCER SHAFT BELLCRANK (UP POSITION) AT DOOR 831. PERFORMED ADJUSTMENT OF RIGGING POINT OF REDUCER SHAFT BELLCRANK (UP POSITION) AT DOOR 831, ADJUSTMENT IS OK IAW A320 AMM 52-11-21-400-001 PROCEDURE 8(G) STEP 20 SDR USAA2011112200017Bushing · worn2S CHECK - EXCESSIVE PLAY IN UPPER CONNECTION LINK AT DOOR 832. REPLACED BUSHINGS IN UPPER CONNECTION LINK AT DOOR 832 IAW A320 AMM 52-10-00-915-001 PAR 4 STEP A, B. ADJUSTMENT CHECK IAW AMM 52-13-21-400-001 STEP J, ADJUSTMENT IS OK.SDR MASA2011112164077Handle · dirtyMAIN DOOR HANDLE STIFF. CLEANED AND LUBED HANDLE.SDR MASA2011112164076Pin · damagedPAX DOOR INNER STOW HANDLE BROKEN. R2 PIN IN DOOR ACTUATOR.SDR GTIA20111120293Cylinder · low pressureFWD RT PAX / CREW DOOR OPERATION CYLINDER REQUIRES SERVICE. CHARGED THE FORWARD RT PASS/CREW DOOR EMER OPERATION CYLINDER TO THE PROPER PRESSURE IAW AMM 52-10-00-614-001. NO LEAKS NOTED.SDR GTIA20111120292Cylinder · low pressureR2 DOOR REQUIRES SERVICE. FOUND THE AFT RT PASS/CREW DOOR EMER OPERATION CYLINDER CHARGED TO THE PROPER PRESSUERE IAW AMM 52-11-14-200-001.SDR AALA20111119TUL01Structure · crackedLEFT NUMBER 2 DOOR UPPER HINGE CUTOUT CRACKED. ACCOMPLISHED DOUBLER REPAIR PER SRM 52-10-02, REPAIR 1 AND EA 52-020365.SDR USAA2011112100005Damper · damaged2S CHECK - DURING OPERATIONAL TEST DAMPING FUNCTION BUFFER IMPACT HARD ON AIRCRAFT STRUCTURE AT DOOR 842. REPLACED DOOR DAMPER AND EMERGENCY-OPERATION CYLINDER AT DOOR 842 IAW A320 AMM 52-13-14. CHECKED THE ADJUSTMENTS & FOUND GOOD.SDR ASOA201111190002Structure · corrodedSERVICE DOOR LOWER STRUCTURE CORRODED (LEVEL 1) AROUND NUT PLATES. BLENDED-OUT MINOR CORROSION IAW EC5210-01154. ACFT STILL IN C-CHECK.SDR ASOA201111190001Structure · corrodedPAX DOOR LOWER STRUCTURE HAS CORROSION AROUND NUT PLATE HOLES. FABRICATED AND INSTALLED DOUBLER AFTER BLEND-OUT OF NUT PLATES ON AFT HALF OF MAIN DOOR. BLENDED OUT MINOR CORROSION ON FORWARD HALF OF DOOR IAW EC5210-01154. ACFT STILL IN C-CHECK.SDR SWIA201131120Skin · crackedPASSENGER DOOR INNER SKIN CRACKED AT FS 340 LOWER PORTION. (C-CHECK) REPAIRED PER CRJ700 SRM.SDR ASOA2011111802292Anchor Fitting · crackedPAX DOOR AFT ANCHOR FITTING CRACKED. R & R PAX DOOR AFT ANCHOR FITTING IAW AMM TASK 52-11-17-000-804 & 52-11-17-400-804.SDR ASOA2011111802291Anchor Fitting · crackedPAX DOOR FWD ANCHOR FITTING CRACKED. R & R WITH NEW ANCHOR FITTING IAW SRM 51-42-21.SDR SIMA201132503Seal · damagedON FLIGHT 3612 THE CREW REPORTED THAT AFTER TAKEOFF THE NUMBER 1 FLIGHT ATTENDANT REPORTED A LOUD NOISE FROM THE MAIN CABIN DOOR. F/A ALSO REPORTED THE OUTSIDE WAS VISIBLE THROUGH THE CRACK IN THE UPPER LEFT CORNER OF THE DOOR SEAL AT LEAST 1 INCH. THE NUMBESDR QXEA2011112201243Seal · lack of lubeRAMP AGENTS REPORT AFT PAX DOOR DIFFICULT TO OPEN. LUBRICATED SEAL, OPS CHECKED DOOR IAW AMM TASK 52-12-00-710-801, OPS CHECK GOOD. RETURNED TO SERVICE.SDR QXEA2011112201242Door · bindingA F/A REPORTS MAIN CABIN DOOR LEVER VERY HARD TO OPERATE TO OPEN DOOR. GVI FWD PASSENGER DOOR MECHANISM IAW AMM TASK 52-11-00-210-801, NO OBIOUS DEFECT NOTED, OPS CHECK FWD PASSENGER DOOR IAW 52-11-00-710-802 FEW TIMES, NO DEFECT NOTED. COULD NOT DUPLICATE. RESDR MASA2011112164060Cable · out of positionPAX DOOR FREE FALLS. REROUTED COUNTER BALANCE CABLE AND ADJUSTED.SDR USAA2011112100004Strap · brokenLGA - COCKPIT DOOR LOWER EMERGENCY STRAP BROKE. MAINTENANCE REPLACED COCKPIT LOWER STRAP, CHECKED OK.SDR SIMA2011325002Door Seal · defectiveON FLIGHT 4379 THE CREW REPORTED THAT AT CLIMBING THROUGH 32,000 FEET THE PASSENGER DOOR STARTED MAKING A LOUD SQUEAL. CABIN ALT 6700' CAB P 7.6ASI. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE PASSENGER DOOR SEAL IAW EMB - 140 AMM 53-21-SDR GTIA20111118296Cylinder · low pressureR1 DOOR EMER BOTTLE READS 1400 PSI. SERVICED TO PROPER RANGE IAW AMM 52-10-00-614-001.SDR GTIA20111118295Cylinder · low pressureL1 DOOR EMER BOTTLE READS 1500 PSI. SERVICED TO PROPER RANGE IAW AMM 52-10-00-614-001.SDR GTIA20111118294Cylinder · low pressureR2 DOOR EMER BOTTLE READS 1500 PSI. SERVICED TO PROPER RANGE IAW AMM 52-10-00-614-001.SDR GTIA20111118291Accumulator · low pressureL1 DOOR EMERGENCY ACCUMULATOR LOW. SERVICED L1 DOOR ACCUMULATOR IAW 52-10-00-614-001.SDR ASOA201102250Attach Fitting · corrodedWHILE REMOVING FOAM FROM UPPER PART OF AIRSTAIR DOOR, FOUND 3 EA ATTACH FITTINGS CORRODED. R & R 3 EA CORRODED FITTINGS IAW 51-40-11, 51-42-06, & 51-23-00.SDR DALA1164375641Skin · dentedPAX DOOR - L4 DOOR INT SKIN FOUND PUNCH MARK AT UPPER HINGE ARM. L4 DOOR INTERIOR SKIN AT UPPER HINGE ARM AREA PATCH. REPAIRED IAW ER/A 497647-14 REV O.SDR UHLA2011111700392Indicator · out of adjustL2 DOOR DOES NOT DISPLAY "ARMED" WHEN ARMED. LETTERS NOW SHOWING UP IN CLEAR VIEW WINDOW. ADJUSTED ARMED INDICATOR ON L2 DOOR IAW EMB 170 MM 52-12-40. OPS CHECK GOOD.SDR AALA20111117TUL07Structure · crackedLEFT NUMBER 2 DOOR UPPER HINGE CUTOUT CRACKED. INSTALLED REPAIR DOUBLER PER SRM 52-10-02 IAW EA COMP-52-020365.SDR USAA2011111800001Striker · out of adjust2S CHECK - OUT ADJUSTMENT AT DIMENSION 'B' BETWEEN FINGER & STRIKER LEVER AT DOOR 841. PERFORMED ADJUSTMENT DIMENSION "B" (J1) BETWEEN FINGER & STRIKER LEVER OF THE DOOR DAMPER & EMERGENCY OPERATION CYLINDER AT DOOR 841, ADJUSTMENT IS OK IAW AMM 52-11-14-820-SDR FDEA201111174952Gate · corrodedL2 DOOR LWR GATE CORRODED. REMOVED L2 LOWER GATE IAW AMM 52-11-38. DETERMINTED CORROSION EXCEEDING LIMIT IAW SRM 52-10-02. REMOVED HINGE FROM LOWER GATE IAW SRM 51-40-02. INSTALLED HINGE ON NEW LOWER GATE IAW SRM 51-40-02. INSTALLED GATE ON L2 DOOR BOTTOMSDR CALA2011111700747Pan · gougedL-1 DOOR PAN GOUGED. REMOVED AND REPLACED L-1 DOOR PAN P/N 141N6302-3 REF B757/200 S RM51-40-02 AND IPC 52-11-0.SDR JR2R2011111700597Support Angle · crackedPAX DOOR STAIRS AFT MOTOR SUPPORT ANGLE CRACKED IN RADIUS. REMOVED AND REPLACED PAX DOOR STAIRS AFT MOTOR SUPPORT ANGLE IAW CRJ 700 SRM 51-42-06 AS ON AAR WO 1007491-8000-0037 AND MESA WO 711011825.SDR SWIA201131108Drag Angle · crackedPASSENGER DOOR STAIR STRUCTURE AFT DRAG ANGLE HAS CRACK. (C-CHECK) REPAIRED PER REO.SDR R61A20110382Liner · unsecureCREW REPORTED L1 DOOR NOT LATCHING IN OPEN POSITION. ON CALL MAINTENANCE FOUND DOOR LINER COVER RESTRICTING THE STAY OPEN LATCH FROM LATCHING. MAINTENANCE RE-SECURED DOOR LINER PER EMB AMM, ALL CHECKS GOOD.SDR ASOA201102204Drag Angle · crackedPAX DOOR DRAG ANGLE CRACKED AT RADIUS JUST ABOVE DOOR ASSIT MOTOR PULLEY BRACKET. . R & R DRAG ANGLE IAW REO 601R-52-11-513.SDR USAA2011111800015Bottle · low pressureL1 DOOR ASSIST BOTTLE LOW PRESSURE. REPLACED DOOR ASSIST BOTTLE.SDR QXEA2011111701227Handle · corrodedAFT PAX DOOR INTERNAL HANDLE MECHANISM IS RUSTING. REMOVED EXTERNAL DOOR HANDLE MECHANISM IAW AMM 52-12-01-000-802. REMOVED INTERNAL HANDLE MECHANISM AND REPLACED BEARINGS ON HANDLE SHAFT IAW AMM 52-12-01-000-801. INSTALLED DOOR HANDLE MECHANISM FOR AFT ENTSDR SIMA2011321001Door · lack of lubeON FLIGHT 2913 THE CREW REPORTED THE MAIN DOOR WAS EXTREMELY HARD TO OPEN UP. THE AIRCRAFT WAS REMOVED FROM SERVICE. LUBRICATED DOOR PER ERJ 145 AMM 52-18-00 AND PERFORMED OPERATIONAL CHECK IAW EMB 145 AMM 52-00-00. FOUND TO BE SATISFACTORY. THE AIRCRAFT WSDR QXEA2011112101237Strut · malfunctionedINITIAL LEVER THROW ON MAIN CABIN DOOR VERY STIFF & DIFFICULT. ADJUSTED LIFT AND LATCH MECHANISM AND R & R GAS STRUTS. DOOR FUNCTIONAL CHECKED GOOD IAW AMM 52-11-00-720-802. RETURNED TO SERVICE.SDR ASOA201102196Latch · malfunctionedDESCENDING THROUGH FL180, WE HAD A PASSENGER DOOR WARNING MESSAGE. RAN QRH WE UNPRESSURIZED THE ACFT. DOOR HANDEL POPPED UP, WE DID NOT ATTEMPT TO RESTOW. GREEN INDICATORS WENT RED (EMERGENCY DECLARED AS A PRECAUTION) REPAIRED INNER DOOR LATCH MECHANISMSDR UALA2011111506249Door Frame · crackedNR 4 LT MED: UPPER DOOR FORMED FRAME AT GATE HINGE ATTACH HOLE CRACKED. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE, HFEC, MFG AND INSTALL REPAIR IAW AMECO EN-52-0050. PER EN PAGE 4 AND MM 51-00-80 PG 204 NOTE 5.B.2 AND NOTE D.2.B, 'UNSURVEYED RSCS MAY ONLY BSDR UHLA2011111400387Door · obstructedCOULD NOT DISARM L1 DOOR. REMOVED DEBRIS FROM LOWER DOOR FRAME, PERFORMED ARMED/DISARMED CHECK. OPS CHECK GOOD IAW EMB 170 MM 52-11-00.SDR UALA2011111406202Gauge · looseNR 3 RT PAX ENTRY DOOR EPAS RESERVOIR GAUGE LOOSE. REMOVED AND REPLACED RESERVOIR.SDR RAIA201111130004Structure · corrodedDURING HEAVY CHECK INSPECTION MAINTENANCE FOUND THE MAIN PASSENGER DOOR HAS CORROSION ON INTERNAL STRUCTURE. MAINTENANCE REMOVED AND REPLACED THE MAIN PASSENGER DOOR.SDR SIMA2011319006Nut · looseON FLIGHT 3231 THE FLIGHT ATTENDANT REPORTED THE MAIN CABIN DOOR WAS DIFFICULT TO OPEN. THE AIRCRAFT WAS REMOVED FROM SERVICE. FOUND NUT LOOSE ON DOOR OPEN ROD LINKAGE, RE-SECURE NUT. THE DOOR OPERATIONAL CHECK WAS GOOD IAW EMB 135 52-10-00 AMM. THE AIRCRASDR SIMA2011319005Roller · lack of lubeON FLIGHT 3335 THE FLIGHT ATTENDANT REPORTED THE MAIN CABIN DOOR WAS DIFFICULT TO OPEN AND CLOSE. THE AIRCRAFT WAS REMOVED FROM SERVICE. LUBED MAIN DOOR ROLLERS IAW EMB 145 AMM 53-21-02. THE OPERATIONAL CHECK WAS GOOD IAW AMM 52-00-00. THE AIRCRAFT WAS RETSDR GLBA20111114JCable · inoperativeDOOR WAS EXTREMELY HARD TO OPEN. MX INSTALLED NEW UPPER AND LOWER DOOR CABLES IAW BMM 52-10-02, OPS CHECKED GOOD.SDR GLBA20111114GDoor · leakingF/A REPORTED A HISSING SOUND FROM THE AIRSTAIR DOOR. MX INSPECTED SEAL, FOUND IN SERVICABLE CONDITION, OPS CHECKED GOOD.SDR ASOA201102167Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED. INSTALLED NEW DRAG ANGLE SECTION IAW SRM TEMP, REV 52-0008 AND SRM 51-42-06, 51-42-13, AND 51-42-22.
Back to JASC 5210