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 UIEA200800196Stop Fitting · brokenMAIN DECK L3 DOOR AFT SIDE NR 2 COUNTED FROM BOTTOM STOP FITTING BROKEN. REPLACED STOP FITTING PER SRM 51-10-01.SDR UIEA200800206Door Frame · crackedMAIN DECK L3 DOOR AFT UPPER CORNER EDGE FRAME FOUND CRACKED. CRACKED AREA REPAIRED PER SRM 52-10-02.
SDR FDKA200805198Seal · dirtyFDM 6177 PNS-TPA. MAIN CABIN DOOR HARD TO LOCK CLOSED. MX CLEANED AND LUBED DOOR SEAL, OPS GOOD.SDR A6WA200840414Step · crackedPAX DOOR MID STEP, AFT CORNER EDGE IS CRACKED. OPEN. (S)SDR RAIA00805012Handle · out of adjustFLT 8006 - IAD - PASSENGER DOOR DIFFICULT TO OPEN FROM INSIDE. MAINTENANCE RE-INDEXED THE MAIN DOOR INTERNAL HANDLE. DOOR OPERATION CHECKED GOOD.SDR 2008UALA02724Gate · damagedL-2 DOOR LOWER GATE HAS ELONGATED AND OVERSIZE HOLES FROM RUB STRIP MOUNTING. WELDED LOWER GATE AND INSTALLED RUB STRIP.SDR 2008UALA02723Structure · damagedDOOR 2L UPPER HINGE ARM CUTOUT REQUIRES DOUBLER REPAIR. MAJOR REPAIR ACCOMPLISHED, REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR.SDR 2008UALA02722Structure · crackedDOOR 2R UPPER HINGE ARM CUTOUT CRACKED. MAJOR REPAIR ACCOMPLISHED, REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR.SDR C2XA08SH073Roller · out of adjustFLT 4920 (FERRY FLIGHT) CABIN DOOR FAIL TO CLOSE. MX ADJUSTED STABILIZER ARMS AND ROLLERS ON CABIN DOOR OPS CHECK GOOD, FORCE APPLIED CHECK 40 LBS IAW AMM 52-18-00. THE AIRCRAFT WAS APPROVED TO RETURN FOR SERVICE.SDR F3LA200800247Fitting · corrodedDURING C3 S1 C CHECK INSPECTION NOTED L2 DOOR AFT LOWER CORNER CAST FITTING IS CORRODED. MAINTENANCE REMOVED AND REPLACED L2 DOOR AFT LOWER CORNER CAST FITTING IN ACCORDANCE WITH THE REQUIREMENTS OF SRM 51-72-11 AND AMM 53-45-15. UPON COMPLETION OF THE REPAISDR TRAX200800609Handle · bentTHE PAX DOOR EXTERIOR HANDLE IS CRACKED AND THE FLAP HANDLE IS BENT. REMOVED AND REPLACED CRACKED PAX DOOR OUTER HANDLE WITH A NEW SERVICEABLE OUTER HANDLE IAW BOMBARDIER SB 601R-52-119 REV. A. REMOVED AND REPLACED BENT/CRACKED PAX DOOR OUTER HANDLE FLAP WITHSDR TRAC200800612Anchor Fitting · crackedTHE AFT PAX DOOR ANCHOR FITTING IS CRACKED AND SWIVEL FITTING HOLE ELONGATED. REMOVED AND REPLACED PAX DOOR AFT ANCHOR FITTING ASSY WITH A NEW SERVICEABLE ANCHOR FITTING ASSY IAW CRJ 200 MM 52-11-17-400-804 STEP 2A-2B (3) CRJ 200 MM 52-11-17-400-804 CLOSEOUTSDR A6WA200840476Structure · crackedCRACK ON PAX DOOR EDGE MEMBER AT FS 316. CRACK ON PAX DOOR EDGE MEMBER AT FS 316 REPAIRED IAW REO 601R-52-11-279. (A)SDR A6WA200840472Guard · tornPAX DOOR WEATHER GUARD IS TORN AND RETAINER IS CRACKED. REPLACED PAX DOOR WEATHER GUARD RETAINER IAW SRM 51-42-13 AND SRM 51-41-02. (A)SDR REXA200800013Handle · crackedPASSENGER DOOR INTERNAL HANDLE CRACKED AT ROLL PIN, FOUND DURING MAINTENANCE. REMOVED CRACKED PAX DOOR INNER HANDLE AND INSTALLED NEW HANDLE IAW CRJ 200 SRM 51-43-00.SDR QXEA200800455Seal · damagedSEA - LEFT AFT PASSENGER DOOR IS HARD TO CLOSE. REPLACED THE DOOR SEAL. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR 2008UALA02674Spring · defectiveR2 DOOR FWD DEPLOYMENT CABLE RETRACTOR STICKS, CABLE DOES NOT RETRACT. REPLACED GAS SPRING. OP CHECKS GOOD.SDR UIEA200800202Skin · deformedMAIN DECK L4 DOOR FORWARD LOWER CORNER EXTERNAL SKIN FOUND DEFORMED. L4 DOOR EXTERNAL SKIN REPAIRED AS PER SRM 51-10-01.SDR GUUA05070801Cable · out of adjustPILOT REPORTED CABIN DOOR CAMS DO NOT ALIGN WITH BOLTS AND IS HARD TO CLOSE. ADJUSTED AIRSTAIR DOOR STRUT CABLE.SDR USAA920081013Intercostal · crackedPIT - MAJOR REPAIR - C2 CHECK - CRACKED L2 DOOR INTERCOSTAL WEB AT THE NR 4 DOOR STOP. REPLACED L2 DOOR INTERCOSTAL WEB AT THE NR 4 DOOR STOP IAW USAIRWAYS EO 5304R143.SDR MASA200800381Web · crackedREPAIRED PAX DOOR FWD AND AFT WEB CRACKS.SDR MASA200800375Seal · dirtyASH FLT 2925 PHX-ICT. LOUD NOISE FROM PAX DOOR DURING DESCENT. MX FOUND NO DAMAGE TO THE SEAL OR RETAINER BUT FOUND IT DIRTY. MX CLEANED THE SEAL AND OP AND PRESSURIZATION CHECKS WERE GOOD.SDR MASA200800374Rod End · out of adjustASH FLT 2748 PHX-SBP. MAIN PAX DOOR WILL NOT LOCK. ADJUSTED ROD END ON PRESS DOOR.SDR SWAA082469Skin · crackedDURING SCHEDULED SPV CHECK, FOUND R1 DOOR SKIN CRACKED AFT OF WINDOW. REMOVED AND REPLACED DOOR PER MM.SDR KCSA081234Door Frame · crackedR5 MAIN ENTRY DOOR FWD LOWER CORNER VERTICAL FRAME CRACKED IN RADIUS, BS 2241, WL-207.SDR KCSA081233Door Frame · crackedL1 MAIN ENTRY DOOR FWD LOWER CORNER VERTICAL FRAME CRACKED IN RADIUS ADJACENT TO DOOR STOP FITTING, BS 441, WL-209.SDR KCSA081232Door Frame · crackedL5 MAIN ENTRY DOOR FWD LOWER CORNER VERTICAL FRAME CRACKED IN RADIUS ADJACENT TO DOOR STOP, BS 2241, WL-207.SDR TRAX200800597Angle · crackedPAX DOOR VENT FLAP SUPPORT STRUCTURE HAS CRACKED ANGLE ON AFT SIDE AT THE LOWER RIVET. REMOVED AND REPLACED PAX DOOR VENT FLAP SUPPORT STRUCTURE ANGLE ON AFT SIDE AS NEEDED IAW CRJ 200 SRM 51-42-06. (B)SDR K5LA050908001Bellcrank · twistedDRUING A ROUTINE PHASE 3 INSPECTION, IT WAS FOUND THAT THE MAIN CABIN DOOR AFT UPLOCK BELLCRANK WAS TWISTED ABOUT 10 DEGREES FROM WHAT A NEW ONE IS.. ALSO THE BOLT PN NAS110321D THAT THE UPLOCK BRACKET PIVOTS ON WAS DEFORMED SLIGHTLY. THIS WAS PROBABLY CAUSED SDR UIEA200800175Door Frame · deformedMAIN DECK 5L DOOR FORWARD UPPER EDGE FRAME FOUND DEFORMED. PERFORMED DOOR EDGE RE-WORK AS PER SRM 51-10-01.SDR UIEA200800174Door Frame · deformedMAIN DECK 5L DOOR AFT UPPER EDGE FRAME FOUND DEFORMED. PERFORMED DOOR EDGE RE-WORK AS PER SRM 51-10-01.SDR UIEA200800173Skin · deformedMAIN DECK 4R DOOR AFT LOWER CORNER EXTERNAL SKIN FOUND DEFORMED. PERFORMED EXTERNAL SKIN RE-WORK AS PER SRM 51-10-01.SDR 2008UALA02639Skin · damagedR2 DOOR UPPER HINGE ARM CUT-OUT HAS DAMAGE. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED: RMV'D DAMAGE. FABRICATED & INSTALLED A REPAIR ANGLE & TAPERED FILLERS.SDR 2008UALA02638Arm · crackedL2 DOOR UPPER HINGE ARM CUTOUT HAS CRACKS. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. FABRICATED & INSTALLED A REPAIR ANGLE & TAPERED FILLERS.SDR DL738080676Door · out of adjustRETURNED TO JFK, FWD ENTRY DOOR NOT SEATED PROPERLY AND NO PRESSURIZATION. OVERWEIGHT LANDING 165 KTS. UPON ARRIVAL FOUND L1 DOOR NOT PROPERLY FAIRED. INSPECTED DOOR PER MM CHAP 52-11-00. FWD DOOR INSP, NO DEFECTS. OPENED AND CLOSED DOOR SEVERAL TIMES. ASDR 2008UALA02632Door · obstructedDOOR 1L DOES NOT DISARM. FOUND FOD UNDER DOOR. REMOVED SCREW FROM UNDER AFT GATE AREA, DISARMS NORMALLY.
SDR MASA200800370Hinge · damagedFOUND DAMAGE TO PAX DOOR HINGE. DAMAGE IS 3 SMALL GOUGES ON THE LUG OF THE PAX DOOR HINGE. REPAIRED DAMAGE.SDR DU4R2008194Structure · corrodedS/O 312001 OPS NR 24701, CORROSION OUT OF LIMITS ON L-1 DOOR LOWER INNER CHORD AT BS 328,
LBL 58 TO LBL 60.SDR 08FDEA01752Frame · corrodedCORROSION ON L2 DOOR AFT FRAME WEB SURFACE BELOW HANDLE. TO REMOVE CORROSION AS PER SRM. REPAIR ON L2 DOOR AFT FRAME WEB SURFACE BELOW HANDLE WAS CARRIED OUT AS PER FEDEX EA NR F-5210-117342. REPAIR CLASSIFIED AS MINOR PER GMM 6-2-100 CRITERIA.SDR FDKA200805188Unknown · unknownFDM FLT 6208 JFK-DCA. PASSENGER DOOR FREEFALLS TOO FAST WHEN OPENING. MX OPERATED DOOR SEVERAL TIMES AND DOOR OPS NORMAL.SDR TRAX200800596Door · obstructedMAIN PAX DOOR STILL STICKING IN CLOSED POSITION, REQUIRES EXCESSIVE FORCE TO OPEN. FOUND BOTTLE CAP IN DOOR FRAME. REMOVED CAP, OPS CHECK GOOD REF CRJ-200MM 52-11-0.SDR QXEA200800449Rod End · damagedSEA - FLIGHT 2231 - MAIN CABIN DOOR HARD TO CLOSE. MAINTENANCE REPLACED THE AFT AND FORWARD UPPER HANDRAIL STRUT ROD ENDS. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR 2008UALA02578Structure · damagedDOOR 1L AREA IS GASHED. THIS IS A MAJOR REPAIR. CUT OUT DAMAGE AND REPAIRED PER SRM 53-11-11 ON NR D0453A DURING H MV VISIT. PERMANENT REPAIR.SDR QXEA200800559Seal · scratchedRFD CR CHECK LOWER FWD STRIKER SEAL FOR PAX DOOR SCRATCHED. BLENDED DAMAGE IAW REO 670-53-21-348. PERFORMED EDDY CURRENT IAW REO 670-53-21-348. ALODINE PRIMED AND PAINTED IAW CRJ 700 SRM 51-21-11, 51-25-06 AND 51-25-01.SDR SWIA200819798Handle · crackedPAX DOOR OUTER HANDLE IS CRACKED. (FOUND AT C-CHECK) COMPLIED WITH REPLACEMENT OF PAX DOOR OUTER HANDLE IAW SB 670BA-52-030.
SDR SWAA082395Door Frame · crackedDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR FWD FRAME CRACKED AT LOWER STOP FITTING. REMOVED AND REPLACED L1 DOOR PER MM.SDR A6WA200840387Structure · crackedREPAIR CRACK ON AFT OF PAX DOOR. REPAIR ON AFT SIDE OF PAX DOOR IAW REO 601R-52-11-279. (A)SDR A6WA200840378Drag Angle · crackedPAX DOOR AFT DRAG ANGLE FOUND CRACKED. PAX DOOR DRAG ANGLE REPAIRED IAW REO 601R-52-11-513.SDR ABXA080152Pan · crackedMAIN ENTRY DOOR PAN CRACKED FORWARD SIDE (BOTTOM HINGE) SECOND STOP FROM BOTTOM. REMOVED AND REPAIRED DOOR IAW DC9 SRM.SDR F3LA200800250Bearing · seizedDURING C3 S1 C CHECK INSPECTION NOTED RIGHT HAND AFT ENTRY DOOR UPPER LATCH HOOK BEARING SEIZED. MAINTENANCE REMOVED AND REPLACED RIGHT AFT ENTRY DOOR UPPER LATCH HOOK BEARING IN ACCORDANCE WITH THE REQUIREMENTS OF AMM 52-13-00-820-001. UPON COMPLETION OF THE
Back to JASC 5210