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 RAIA00805030Mechanism · lack of lubePOST FLT NR 5594 - STL - PASSENGER DOOR HARD TO OPEN. MAINTENANCE LUBED THE DOOR ROLLERS, LATCH MECHANISM AND PIVOTS. DOOR OPERATION CHECKED GOOD.SDR TRAX200800694Door · stiffPASSENGER DOOR HARD TO OPEN, HANDLE OPERATES OK. DOOR REQUIRES HARD PUSH TO OPEN. OPERATED PASSENGER DOOR. DIDN`T FIND ANY FAULTS. OPS CHECK GOOD IAW CRF-200 AMM 52-11-00. (S)SDR TRAX200800693Door · stiffPAX DOOR HARD TO OPEN. HANDLE OPERATES OK, DOOR REQUIRES HARD PUSH TO OPEN. PERFORMED OPS CHECK OF PAX DOOR PER AMM 52-10-00. NO DEFECT NOTED. (B)SDR 2008UALA03044Structure · chafedDOOR R4 DOUBLER AFT AND BELOW HANDLE BOX CHAFED. MAJOR REPAIR ACCOMPLISHED, REMOVED DAMAGE. FABRICATED AND INSTALLED DOUBLER REPAIR.SDR DHL2008764529Skin · bentWHILE AT C CHECK, L1 DOOR INNER SKIN BENT FWD LOWER CORNER. REPAIRED IAW B727 SRM 51-40-2 AND ASTAR EVA B52-00073 REV1.SDR C2XA08ON128Lock · out of adjustFLT 522 - RDU - FLIGHT CREW REPORTED PAX DOOR HARD TO OPEN. MX FERRY FLIGHT TO TYS. MX ADJUSTED HANDLE LOCKING MECHANISM OPERATIONALLY CHECK SATISFACTORY AIRCRAFT WAS RELEASE TO RETURN FOR SERVICE.SDR ASAA0842980Door · stuckFLIGHT ATTENDANT REPORTS L1 DOOR HARD TO CLOSE. OPENS EASILY NO SQUEALING DURING FLIGHT. LIGHT INDICATION NORMAL. INSPECTED L1 DOOR FOR PROPER OPERATION. FOUND OK REF 52 11 00, LUBED DOOR HINGES.SDR MWEA080080Hook · damagedFORWARD PASSENGER DOOR HAS DRILLED TOOLING MARK DAMAGE IN THE RADIUS ON THE AFT SIDE OF THE DOOR HOLD OPEN HOOK. FABRICATED AND INSTALLED DOUBLER.SDR GUU2008F00019Pin · brokenFLIGHT 9292, PILOT REPORTED CABIN DOOR HANDLE FELL OFF. HANDLE INNER PIN BROKEN. C/A REPLACED CABIN DOOR HANDLE. (A)SDR USAA920081150Skin · crackedCLT - MAJOR REPAIR - Q6 CHECK - NR O3C10552004/1, O3C10552004/2 AND O3C10552004/3, FORWARD ENTRY DOOR INNER SKIN CRACKED AT THE NR 5, NR 6 AND NR 7 DOOR STOP CUT OUT AREA. REPAIRED THE FORWARD ENTRY DOOR INNER SKIN CRACKED AT THE NR 5, NR 6 AND NR 7 DOOR STOPSDR FDKA200805209Roller · lack of lubeFDM FLT 5991 JFK-BWI, MAIN DOOR HARD TO CLOSE. MX LUBED DOOR ROLLERS, OPS CHECK GOOD.SDR QXEA200800514Seal · dirtySEA - FLIGHT 2215 - AFT CABIN DOOR DIFFICULT TO OPEN. MAINTENANCE CLEANED THE SEAL. OPERATIONAL CHECKS GOOD, AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR A6WA200840448Skin · dentedDENTS ON PASSENGER DOOR FWD AND AFT UPPER CORNER COVERS. ON FURTHER INVESTIGATION, CRACKS FOUND ON PARTS (CORNERS) ON PAX DOOR FWD AND AFT REMOVED AND REPLACED IAW SRM 51-42-06 AND SRM 51-42-13. (A)SDR TRAX200800717Handle · crackedTHE PAX DOOR EXTERIOR HANDLE AND FLAPPER ARE CRACKED. REMOVED HANDLE AND REPLACED IAW AMM 52-11-03-400-802 AND SB 601R-52-119. ACCOMPLISH CLOSEOUT SECTION C AND INSTALLED PROXIMITY SWITCH TARGET ON DOOR HANDLE. (B)SDR TRAX200800678Handle · no testEMERGENCY HANDLE OF THE PAX DOOR FAILS FORCE TEST. LUBED PAX DOOR IAW AMM 12-20-52-640-810. PERFORMED FUNCTIONAL TEST OF PAX DOOR INNER HANDLE TEST GOOD AT THIS TIME IAW AMM 52-11-00-720-802.SDR COMA0860251Door Frame · crackedPAX DOOR FRAME FS 338.9 IS CRACKED AT UPPER END. REPAIRED IAW REO 601R-52-11-402.SDR MASA200800412Handle · lack of lubeASH FLT 7236, ORD-MSN - PAX DOOR PRESSURE FLAP HARD TO CLOSE. LUBED HANDLE AND PERFORMED OP CHECKS WITH NO DEFECTS.SDR MWEA080075Structure · dentedFORWARD PASSENGER DOOR, AFT LOWER AREA HAS A DENT. CUT OUT DAMAGE, FABRICATED AND INSTALLED DOUBLER.SDR MWEA080074Structure · dentedFORWARD PASSENGER DOOR, FORWARD LOWER AREA HAS A DENT. CUT OUT DAMAGE, FABRICATED AND INSTALLED DOUBLER.SDR TRAX200800674Fitting · lack of lubePSG DOOR STUCK AND WOULD NOT OPEN UPON ARRIVAL INTO SHV. LUBED AND CLEANED SHOOT DOOR FITTINGS AND PERFORMED OPS CK ON ASD IAW CRJ200 AMM 12-20-52 AND CRJ200 AMM 52-11-00. OPS CK GOOD A/C OK FOR SERVICE. [SDR CLOSED]SDR QXEA200800512Door · malfunctionedSEA - FLIGHT 2340 - UNABLE TO CLOSE THE AFT PASSENGER DOOR. MAINTENANCE RECENTERED THE DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR QXEA200800511Door · lack of lubePDX - FLIGHT ATTENDANT REPORTS THAT THE AFT PASSENGER DOOR IS HARD TO MOVE. MAINTENANCE CLEANED AND LUBED THE DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR TRAX200800669Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED JUST ABOVE ASSIST MOTOR PULLEY. CUT AWAY DAMAGED PROTION OF DRAG ANGLE IAW REO 601R5211513 REV.A, STEP 1-2. COMPLIED WITH HFEC IAW REO 601R-52-11-513, STEP 3 AND NDTM PT 1 51-20-06. NO INDICATIONS NOTED AT THIS TIME. INSTSDR TRAX200800668Handle · crackedPAX DOOR OUTER HANDLE IS CRACKED. REMOVED CRACKED HANDLE INSTALLED NEW HANDLE KIT 601R52-119K1 IAW AMM 52-11-03-400-802. PAX DOOR HANDLE REQUIRES FUNCTIONAL TEST. PERFORMED FUNCTIONAL TEST OF THE PAX DOOR OUTER HANDLE IAW AMM -52-11-03-720-802. FUNCTIONAL TESDR TRAX200800672Mechanism · lack of lubePAX DOOR VERY DIFFICULT TO OPEN AND CLOSE. LUBRICATED PAX DOOR LATCH MECHANISM, OPS CHECK GOOD IAW CRJ-200 AMM 52-11-02. ---[SDR CLOSED](B)SDR 2008UALA02898Structure · damagedR-2 DOOR UPPER HINGE ARM CUTOUT REQUIRES DOUBLER. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER REPAIR.SDR TRAX200800660Step · crackedASD BOTTOM STEP CRACKED. REMOVED AND REPLACED ASD BOTTOM STEP IAW AMM 52-11-04. OPS CK GOOD. (B)SDR 2008UALA02870Light · no testDOOR 3R ARM LIGHT WILL NOT ILLUMINATE. SUPPLEMENTAL DATA UPDATE CAUSE, DEBRIS UNDER GIRT BAR. REMOVED DEBRIS AND CLEANED SWITCHES, OPS CHECKS OK, ARMS/DISARMS NORMALLY.SDR UIEA200800215Panel · crackedMAIN DECK L-2 DOOR FWD UPPER INNER REVEAL PANEL FOUND CRACKED. CRACKED AREA REPAIRED IAW EO NR 4753B148.SDR SWIA200819657Door · out of rigFLT 3912 - PASSENGER DOOR IS VERY HARD TO OPEN. RESHIMMED AND RIGGED THE FORWARD LATCH CAMS IAW CRJ MM 52-11-23. OPS CHECK GOOD.SDR KCSA081248Web · damagedL-4 MAIN ENTRY DOOR LOWER WEB ACCESS AREA DAMAGED AT BS 1700, STR 24L.SDR SWIA200819658Rod End · corrodedFLT 3569 - CABIN DOOR IS HARD TO OPEN FROM THE INSIDE. REPLACED CORRODED TORQUE TUBE ROD ENDS AND BEARINGS. OPS CHECK GOOD.SDR QXEA200800498Door · unknownSEA - FLIGHT 2257 - AFT PASSENGER DOOR HARD TO CLOSE. MAINTENANCE CLEANED DEBRIS FROM THE DOOR. DOOR OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR TRAX200800651Handle · crackedPAX DOOR EXTERNAL HANDLE IS CRACKED. SB 601R-51-119 REV A, DOORS, PASSENGER DOOR, REPLACEMENT OF THE OUTER HANDLE INCORPORATED. PAINTED PAX DOOR HANDLE IAW 51-25-01.SDR A6WA200840447Structure · crackedPAX DOOR EDGE MEMBER CRACKED AT FS 338. REPAIRED IAW REO 601R-52-11-279. (A)SDR MASA200800405Door · stiffASH 7076 IAD - PAX DOOR HARD TO OPEN. MX INSPECTED DOOR. NO DEFECTS NOTED. DOOR ASSY OPS GOOD.SDR 2008UALA02823Skin · dentedDOOR 2L HAS A SKIN DENT. ACCOMPLISHED MAJOR REPAIR AT GSO. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW SRM 52-10-01.SDR SWIA200819630Handle · bindingMAIN CABIN DOOR HANDLE IS DIFFICULT TO CLOSE AND OPEN, FLIGHT NR 3614. INSPECTED, CLEANED AND OPERATED CABIN DOOR FROM INSIDE AND OUTSIDE WITH NO DISCREPANCIES NOTED.SDR QXEA200800496Door · unknownGEG - FLIGHT 2395 - FA COULD NOT CLOSE THE LEFT REAR PASSENGER DOOR. MAINTENANCE RESET THE DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR QXEA200800495Door · undertorquedSEA - REAR PASSENGER DOOR IS HARD TO OPEN. MAINTENANCE LUBRICATED THE DOOR. OPERATIONAL CHECKS GOOD. NO PARTS REPLACED. AIRCRAFT RETURNED TO SERVICE.SDR MASA200800401Motor · malfunctionedASH FLT 2838, PHX-BUR - PAX DOOR POWER ASSIST MOTOR INOP. RESET C/B.SDR TRAX200800631Door · out of adjustASD HARD TO CLOSE, ADJUSTED PAX DOOR COUNTERBALANCE SYSTEM IAW MM 52-11-17. OK FOR SERVICE. (B)SDR TRAX200800630Motor · malfunctionedPAX DOOR WOULD NOT OPEN ALL THE WAY. T/S SYSTEM - FOUND DOOR ASSIST MOTOR HOLDING DOOR. CYCLED C/B FOR DOOR ASSIST. DOOR OP CHECKS OK IAW AMM 52-11-00. (B)SDR MASA200800400Seal · leakingFLT 2721, PHX-SBA - FRONT CABIN DOOR HAS AIR LEAK. REPLACED DOOR SEAL, OP AND PRESSURE CHECKS GOOD.SDR C2XA08SH075Support · crackedSHV - DURING C-CHECK PAX DOOR INTERNAL HANDLE SUPPORT CRACKED. MX REMOVED AND REPLACED PAX DOOR INTERNAL HANDLE SUPPORT IAW EMB SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN FOR SERVICE.SDR UIEA200800190Door Frame · crackedMAIN DECK R5 DOOR FORWARD LOWER CORNER EDGE FRAME FOUND CRACKED. CRACKED AREA REPAIRED PER SRM 52-10-02.SDR MASA200800396Door · lack of lubeASH FLT 7127 IAD-CLT - PASSENGER DOOR VERY HARD TO OPEN. LUBED DOOR.SDR A6WA200840418Step · crackedPAX DOOR TOP STEP AFT LOWER CORNER IS CRACKED. PAX DOOR TOP STEP AFT LOWER CORNER REPAIRED IAW REO 601R-52-11-702 REV A.SDR A6WA200840416Step · crackedPAX DOOR TOP STEP FWD LOWER CORNER IS CRACKED. PAX DOOR TOP STEP FWD LOWER CORNER REPAIRED IAW REO 601R-52-11-702 REV A.SDR A6WA200840415Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACK. PAX DOOR DRAG ANGLE REPAIRED IAW REO 601R-53-11-513 REV A.
Back to JASC 5210