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 ASAA2014031407203Guide Arm · failedL1 DOOR HARD TO OPEN. ACFT GROUNDED. REPLACED L1 DOOR GUIDE ARM IAW AMM 52-11-21-400-802 AND ADJUSTED IAW AMM 52-11-00-820-801. REPLACED L1 DOOR SNUBBER IAW AMM 52-11-51-400-8010. SNUBBER INSTALLATION TESTED GOOD. PERFORMED FORWARD ENTRY DOOR SYS TEST IAWSDR A6WA201441256Panel · crackedPASSENGER DOOR STAIR SUPPORT FWD PANEL CRACKED AT LOWER CORNER OF UPPER STEP. REPAIRED IAW REO 601R-52-11-702 REV C DATED 2010-03-09 ZONE 2.SDR SIMA20140314006Roller · lack of lubeMAIN CABIN DOOR EXTREMELY DIFFICULT TO OPEN ON TWO OCCASIONS. LUBE ALL DOOR ROLLERS, DOOR OPERATION CHECK IS GOOD IAW 140 52-10-00 AMM.SDR SWAA2014040726839Web · crackedL2 DOOR FWD WEB CRACKED. R & R WEB IAW SRM & DWG.SDR DALA14017119250Structure · dentedSMALL DENT ON LOWER FORWARD EDGE ON L1 DOOR. STRAIGHTENED DENT IAW SRM 52-01.SDR A6WA201441278Handle · crackedPASSENGER DOOR INNER HANDLE IS CRACKED AT THE ROLL PIN HOLE. REMOVED UNSERVICEABLE INNER DOOR HANDLE IAW CRJ 200 SRM 51-41-02. INSTALLED SERVICEABLE INNER DOOR HANDLE IAW CRJ 200 SRM 51-41-02.SDR ASAA2014031307202Control Rod · out of adjustF/A REPORTED L1 DOOR VERY HARD TO OPEN. ACFT GROUNDED. ADJUSTED HORIZONTAL CONTROL ROD ON L1 DOOR REF AMM 52-11-00-820-801.SDR N6WA20140313004Wheel · abnormalPASSENGER DOOR SUPPORT WHEEL COLLAPSED. LUBED MAIN CABIN DOOR SUPPORT WHEEL, PERFORMED OPERATIONS CHECK IAW CRJ700 AMM 52-11-13, OPERATIONS CHECKED GOOD.SDR CALA2014031490606Cable · frayedMAIN CABIN, L1 DOOR CABLE FRAYED. R & R L1 DOOR PRIMARY CABLE IAW AMM 52-11-16-401 STEP 4 5. PERFORMED DOOR COUNTER BALANCE TEST IAW AMM 52-11-16-501 STEP 3. SYS TESTED GOOD.SDR USAA2014031400007Attach Fitting · lack of lubeDOOR L2 SLIDE ARMING LEVER DIFFICULT TO OPERATE. LUBED SLIDE ATTACH POINTS AT DOOR L2, OPERATION CHECKED OK.SDR USAA2014031400001Bottle · low pressureACFT RT DOOR 4R DOOR PRESS IN RED CIDS PANEL, INDICATES CHECK DOOR PRESS. SERVICED AS REQUIRED.SDR MASA2014031330999Lock · fodPASSENGER MAIN CABIN DOOR WILL NOT OPEN. CLEANED DEBRIS FROM LOCK MECHANISM.SDR SIMA20140312006Door · dentedCOMPLIED WITH ERS-EM-52MR-043 PT B, RECURRING INSPECTION, ONLY PASS AFT UPPER EDGE DENT. REF TDMI 918T526 LG PG 3383675 4. PERFORMED PERMANENT REPAIR TO PAX DOOR DENT AT UPPER AFT EDGE IAW ERS-EM-52MR-043 PT C, TDMI RESTORED. SEE NRTC E457289 FOR DETAILS.SDR SIMA20140312017Bracket · crackedPAX DOOR BRACKET FOR INNER HANDLE TORQUE BOX HAS A 3/8 INCH CRACK ON AFT UPPER CORNER. REPAIRED PAX DOOR BRACKET FOR INNER HANDLE TORQUE BOX IAW EO-EM-52MR-250.SDR ASOA2014040410281Drag Angle · crackedASD AFT DRAG ANGLE CRACKED. REMOVED AFT TOP ANGLE, PN 600-31907-159 IAW SRM 51-42-13. INSTALLED DRAG ANGLE IAW SRM 51-42-13-00 AND DWG 600-31907.SDR SWIA201436822Step · corrodedMAIN CABIN DOOR INTERIOR SKIN UNDER LOWER FOLDING STEP CORRODED. C-CHECK, BLENDED AREA ON MAIN CABIN DOOR INTERIOR SKIN UNDER LOWER STEP IAW EA.SDR SWIA201436821Lever · chafedMAIN CABIN DOOR FWD PULL-IN LEVER CHAFED. C-CHECK, REPAIRED PULL IN LEVER IAW REO.SDR SWIA201436820Arm · chafedMAIN CABIN DOOR SUPPORT WHEEL ARM CHAFED. C-CHECK, BLENDED AREA ON MAIN CABIN DOOR WHEEL ARM PN CC670-38624-3 IAW STS EA.SDR SWIA201436819Hand Rail · chafedPAX DOOR AFT HAND RAIL CHAFED BY CABLE SUPPORT WHEEL. C-CHECK, BLENDED HAND RAIL IAW EA.SDR A6WA201441273Step · damagedCOMPLIED WITH AWAC CARD 4DMI16423 REPAIR PAX DOOR LOWER AFT CORNER 601R-52-11-2144A. REPAIRED PAX DOOR AFT CORNER OF UPPER STEP IAW REO 601R-52-11-279 REV NC DATED 2001-10-18.SDR SWAA2014031726085Mount · crackedL2 DOOR EMERGENCY EVAC SLIDE FWD ATTACH BRACKET MOUNT CRACKED. R & R MOUNT IAW SRM.SDR A6WA201441260Panel · crackedPASSENGER DOOR STAIR SUPPORT AFT SIDE PANEL CRACKED AT LIGHTNING HOLE UNDER GAS SHOCK SUPPORT. REPAIRED IAW REO 601R-52-11-702 REV C DATED 2010-03-09.SDR USAA2014031300006Cylinder · low pressureL2 DOOR EMERGENCY ASSIST CYLINDER PRESS IS LOW. SERVICED L2 DOOR EMERGENCY ASSIST CYLINDER IAW JOB CARD 26L00005005.SDR N6WA20140312002Cable · failedPASSENGER DOOR SUPPORT WHEEL COLLAPSED. R & R SUPPORT WHEEL CABLE IAW AMM 52-11-13, OPERATIONS CHECKED DOOR, GOOD AT THIS TIME.SDR A6WA201441282Web · crackedMAIN ENTRY DOOR FWD WEB IS CRACKED IN LOWER CORNER OF RISER. REMOVED CRACK IAW SRM 51-12-00.SDR N6WA20140311001Unknown · unknownLOUD NOISE COMING FROM PAX DOOR IN FLIGHT. VERIFIED PAX DOOR INDICATES CLOSED & LOCKED VIA GREEN WITNESS MARKS ON THE LOCK PINS.SDR SIMA20140311002Trim Panel · brokenPAX DOOR DIFFICULT TO OPEN. FOUND DOOR TRIM ON LOWER LT CORNER BROKEN & CATCHING ON FUSELAGE. DEFERRED DOOR TRIM IAW NEF 52 10B AUTH 030515M-N.SDR USAA2014031100002Bottle · low pressureTHE 2R DOOR ASSIST BOTTLE PRESS LOW. SERVICED 2R DOOR ASSIST BOTTLE TO PROPER PRESS IAW AMM 52-10-00, LEAK CHECKED OK.SDR ASOA2014041410342Skin · buckledASD TOP AFT SIDE STRUCTURE IS BUCKLED. COMPLIED WITH PERMANENT REPAIR OF ASD TOP AFT SIDE STRUCTURE IAW EC/TC REO 670-52-11-072. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. REMOVED AFT ASD SKIN IAW SRM 51-42-06-001-001-A01. DRILLED NEW AFT SKSDR USAA2014031100008Attach Bolt · looseSCREW STICKING OUT OF ARMING HANDLE ON DOOR 3L. TIGHTENED DOOR HANDLE ATTACH BOLT.SDR SIMA20140310005Hand Rail · out of adjustMAIN DOOR HAND RAIL PIN WILL NOT RELEASE WHEN FLIGHT ATTENDANT TRIED TO OPEN MAIN DOOR. ADJUSTED MAIN DOOR HANDRAIL IAW AMM 52-11-05, OPERATIONS CHECKED GOOD.SDR USAA2014031000013Arming Lever · looseCREW REPORTED THE L3 DOOR ARMING LEVER HANDLE LOOSE. SECURED L3 DOOR ARMING LEVER, OPERATION CHECKED NORMAL.SDR SIMA20140309009Bracket · crackedPAX DOOR AFT SIDE SKIN L BRACKET HAS APPROX 1 1/4 INCH CRACK. R & R PAX DOOR AFT SIDE SKIN L BRACKET IAW SRM 52-11-04.SDR R61A201403090393Dampener · corrodedDURING HEAVY CHECK, L2 DOOR DAMPENER HAS SURFACE CORROSION. MAINTENANCE R & R L2 DOOR DAMPENER IAW AMM 52-12-27.SDR GTIA201403091207Door Seal · leakingL2 DOOR SEAL LEAKING THROUGHOUT FLIGHT. PERFORM A.G.V.I. OF L2 DOOR IAW SL-10-W. NO DAMAGE NOTED CHECK SEALS.SDR USAA2014031000022Lever · looseARMING LEVERS AT DOORS L3 & R3 ARE LOOSE. SECURED LOOSE HARDWARE FOR ARMING LEVERS AT DOORS L3 & R3.SDR USAA2014031000020Cylinder · leakingDOOR L2 CHECK DOOR PRESS LIGHT ILLUMINATED. FOUND L2 DOOR DAMPNER EMERGENCY OPERATION CYLINDER LEAKING PRESS. REPLACED DOOR L2 DAMPNER CYLINDER IAW AMM 52-22-14-400-001-A.SDR USAA2014031000016Attach Fitting · damagedUPON SLIDE REMOVAL FOUND L2 DOOR AFT UPPER SIDE ATTACH FITTING DAMAGED. BOLT WILL NOT THREAD IN. R & R UPPER AFT ATTACH FITTING IAW A320 AMM 52-13-22.SDR RAIA201403090001Cable · inoperativePASSENGER DOOR WILL NOT CLOSE. MAINTENANCE REPLACED ALL DOOR CABLES, OPS CHECKED GOOD.SDR SWIA201436765Roller · lack of lubeMAIN CABIN DOOR IS HARD TO OPEN. LUBED MAIN CABIN DOOR ROLLERS AS REQUIRED. SECURED MAIN CABIN DOOR STACKS AS REQUIRED.SDR SWIA201436680Valve · failedACFT DID NOT PRESSURIZE DURING CLIMB, CABIN CLIMBED AT SAME RATE AS VERTICAL SPEED. REPLACED PAX DOOR PRESSURE VALVE IAW MM.SDR GTIA201403081204Rub Strip · looseL1 DOOR HAS NOTICEABLE VIBRATION NOISE AND TO THE TOUCH. NOISE STOPS & STARTS EVERY FEW SECONDS. FOUND RUB STRIP LOOSE ON TOP RIGHT CORNER COVER PLATE ON L1 DOOR. RE-APPLIED NEW SEALANT IAW AMM 52-11-118-300-002-A. PERFORMED GEN VISUAL INSPECTION IAW 52-11-SDR USAA2014031000031Diaphragm · faultyMAINTENANCE REPORTED THE L1 DOOR ASSIST BOTTLE BLOWN. ACCOMPLISHED L1 DOOR ASSIST DAMPER DIAPHRAGM REPLACEMENT IAW AMM 52-22-00-002-A, SERVICED BOTTLE.SDR SWIA201436811Angle · corrodedMAIN CABIN DOOR SILL KICK PLATE ANGLE CORRODED. C-CHECK, REPLACED KICKPLATE ANGLE IAW SRM.SDR SWIA201436810Cam · corrodedPAX DOOR LOWER FWD LATCH CAM HAS CORROSION. C-CHECK, REPAIRED IAW EA.SDR CALA2014031000300Bracket · looseA/C WOULD NOT PRESSURIZE AFTER TAKEOFF, FOUND FWD ENTRY DOOR L1 PARTIALLY GAPPED. FOUND GUIDE ARM BRACKET LOOSE, TIGHTENED & CHECKED RIG OF DOOR IAW AMM 52-11-00- 820-801.SDR USAA2014031000021Schrader Valve · leakingTSI ISSUED, DUE TO PILOT REPORTS OF SEVERAL CHECK DOOR 2L PRESS MESSAGES. FOUND SCHRADER VLV ON DOOR 2L DAMPENER TO BE LEAKING. REPLACED SCHRADER VLV, OPERATIONS & LEAK CHECKED GOOD. BITE TEST GOOD IAW AMM 23-73-00-740-005.SDR RAIA201403070001Handle · malfunctionedDURING POST FLIGHT INSPECTION, THE PASSENGER DOOR WILL NOT OPEN FROM OUTSIDE. MAINTENANCE REPLACED THE EXTERIOR DOOR HANDLE, OPS CHECKED GOOD.SDR REXA2014030800260Striker · damagedAFTER TAKEOFF, HEARD A LOUD HISSING NOISE FROM MCD. CABIN RATE OF CLIMB WAS ZERO, DIFFERENTIAL PRESSURE WAS 5.2, CABIN ALT WAS 1600, LDG ELEVATION 1600 DURING CLIMB, LEVELED OFF AT 14,000' & RETURNED TO MSP FA REPORTED ALL MARKINGS GREEN & LOCKED. FOUND DAMASDR USAA2014031000001Mechanism · out of adjustL1 DOOR EMERGENCY OPENING SYS FAILED WHEN PERFORMING FUNCTIONAL CHECK. MX ACCOMPLISHED ADJUSTMENT TEST OF THE CONTROL MECHANISM, CHECKED NORMAL.
Back to JASC 5210