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 SWIA200923085Bushing · lack of lubeTHE MAIN CABIN DOOR HARD TO OPEN. (FLT 7769) LUBED SHAFT BUSHINGS.SDR AALA20091102TUL06Gate · crackedLEFT NUMBER FOUR DOOR UPPER GATE CRACKED. INSTALLED NEW UPPER GATE PER ESO 90108.SDR AALA20091102TUL05Torque Box · crackedRIGHT NUMBER TWO PASSENGER DOOR HANDLE TORQUE BOX IS CRACKED. REPLACED RIGHT NUMBER TWO PASSENGER DOOR HANDLE TORQUE BOX PER ESO 90282.SDR AALA20091102TUL02Gate · crackedLEFT NUMBER ONE DOOR UPPER GATE CRACKED AT ROD END BOLT HOLE. REMOVED CRACKED UPPER GATE AND INSTALLED NEW UPPER GATE PER ESO 90283.SDR QXEA2009110600911Handle · lack of lubeF/A ADVISES L2 DOOR HANDLE STIFF. LUBRICATED DOOR HANDLE MECHANISM AS REQ'D. OPERATED DOOR MULTIPLE TIMES, W/ NO DEFECTS NOTED. A/C OKAY FOR CONT. SERVICE. NO PARTS REPLACED.SDR SWAA097011Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND L1 DOOR SKIN CRACKED AT AFT UPPER CORNER. REPAIRED SKIN PER SRM.SDR FDEA200911023792Beam · crackedR3 DOOR FWD LOWEST BEAM FWD STOP FITTING CRACKED. R3 DOOR, CRACKED LOWEST BEAM REMOVED AND REPLACED IAW SRM 51-31-01 REV 41. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REV 108.SDR AALA20091101TUL03Gate · corrodedRIGHT NUMBER TWO PASSENGER DOOR LOWER GATE HAS HEAVY CORROSION ON LOWER END. REPLACED LOWER GATE PER ESO 90282.SDR QXEA2009110500910Door · lack of lubeF/A REPORTS AFT PASSENGER DOOR TOUGH TO OPEN & CLOSE. CLEANED AND LUBED PASSENER DOOR AS REQUIRED. OPERATIONAL CHECK GOOD. RETURNED TO SERVICE. NO PARTS REPLACED.SDR MYWA090055Seal · not seatedON CLIMBOUT L1 DOOR DID NOT SEAL, UNABLE TO PRESSURIZE.SDR AALA20091030TUL07Gate · corrodedLEFT NUMBER ONE PASSENGER ENTRY DOOR LOWER GATE ASSEMBLY CORRODED. REPLACED WITH NEW LOWER GATE ASSEMBLY PER ESO 90283.SDR AALA20091030TUL02Fitting · crackedVAULT DOOR HAS A CRACKED ANGLE JUST BELOW THE LOWER LATCH PIN LINK. REMOVED CRACKED FITTING AND INSTALLED NEW PER ESO 80186.SDR UALA2009110403401Snubber · faultyMAIN CABIN DOOR 4R DOOR SNUBBER INDICATION LOW. INSTALLED NEW DOOR SNUBBER AND COUNTER BALANCE, LWR AND UPR CAM PLATE BEARINGS AND INTERCOSTAL BEARINGS HOUSE BEARINGS. REINSTALLED DOOR. ADJUST AND OPS NORMAL.SDR SWIA200923003Door · lack of lubeMAIN CABIN DOOR WILL NOT OPEN FROM THE INSIDE. (FLT 6554) LUBED MAIN CABIN DOOR.SDR EIAA200900121Door Frame · corrodedL3 DOOR FWD FRAME HAS CORROSION LWR CORNER VERTICAL SIDE. CUT OUT DAMAGE, FABBED AND INSTALLED REPAIR PER ECRA 486-52-076-2.SDR AALA20091029TUL07Pan · crackedHANDLE PAN ON FORWARD ENTRY DOOR CRACKED. INSTALLED NEW HANDLE PAN PER ESO 80172.SDR ASOA200901191Handle · inoperativePAX DOOR HANDLE INOP FROM OUTSIDE.SDR ASOA200901190Anchor Fitting · crackedPAX DOOR, AFT ANCHOR FITTING CRACKED.SDR ASOA200901188Door · stuckF/A REPORTS THAT THE MAIN PASSENGER DOOR IS DIFFICULT TO OPEN.SDR EIAA200900118Skin · crackedL1 DOOR SKIN CRACK IN LOWER AFT CORNER COMMON TO DOOR FRAME. REMOVED DAMAGE, FABBED AND INSTALL REPAIR PER B747 SRM 52-10-02 PG 8-10A.SDR USAA2009102892907Bottle · low pressureBFM - C1 - EES - NEED TO SERVICE DOOR R-2 ASSIST BOTTLE. SERVICED R-2 DOOR ASSIST BOTTLE IAW A330 AMM 52-10-00.SDR USAA2009102892906Bottle · low pressureBFM - C1 - EES - NEED TO SERVICE DOOR R-1 ASSIST BOTTLE. SERVICED R-1 DOOR ASSIST BOTTLE IAW A330 AMM 52-10-00.SDR USAA2009102892905Bottle · low pressureBFM - C1 - EES - NEED TO SERVICE DOOR L-2 ASSIST BOTTLE. SERVICED L-2 DOOR ASSIST BOTTLE IAW A330 AMM 52-10-00.SDR UALA2009102803375Bearing · corrodedMAIN CABIN DOOR 4L LWR FWD GATE TORQUE TUBE CAM BEARING CORRODED. INSTALLED NEW BEARING.SDR MASA2009102700323Door · stuckASH FLT 7295 BHM - CREW UNABLE TO OPEN EITHER THE PASSENGER OR SERVICE DOOR FROM THE OUTSIDE. CONTRACT MAINTENANCE WAS ABLE TO OPEN BOTH PASS AND SVC DOOR FROM OUTSIDE, BOTH OPS NORMAL.SDR SIMA200930301Support Bracket · crackedDURING MAINTENANCE INSPECTION FOUND THE PASSENGER DOOR MOTOR UPPER SUPPORT BRACKET CRACKED. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND INSTALLED NEW SERVICEABLE PASSENGER DOOR MOTOR UPPER SUPPORT BRACKET IAW CRJ 700 SRM 51-42-06. THE AIRCRAFT WAS RETURNED TSDR QXEA2009103000890Hand Rail · looseGEG- FORWARD PASSENGER DOOR WILL NOT OPEN. SECURED LOOSE FASTENER ON THE AFT HANDRAIL ASSEMBLY. PERFORMED OPERATIONAL CHECK IAW AMM 52-11-00-710-802. CHECKS GOOD RETURNED TO SERVICE. NO PARTS REPLACED.SDR USAA2009102892904Bottle · low pressureBFM - C1 - EES - NEED TO SERVICE DOOR L-1 ASSIST BOTTLE. SERVICED L-1 DOOR ASSIST BOTTLE IAW A330 AMM 52-10-00.SDR SWIA200923163Door Frame · crackedPASSENGER DOOR FRAME CRACKED. (C-CHECK) REPLACED FRAME PER SRM.SDR QXEA2009102900887Valve · lack of lubeBOI- MAIN CABIN DOOR WILL NOT OPEN. FOUND DOOR SEAL SLOW TO DEFLATE. LUBED SEAL DEFLATION VALVE. DOOR OPERATES NORMALLY. RETURNED TO SERVICE. NO PARTS REPLACED.SDR ASOA200901178Door · stuckFA REPORTS MAIN CABIN DOOR VERY HARD TO OPEN (HANDLE WOULD NT MOVE).SDR USAA2009102692863Diaphragm · leakingFLT 1624 - CLT-ORD - EMERGENCY EQUIPMENT - R4 DOOR ASSIST BOTTLE AT 0 PSI. REPLACED DIAPHRAGM AND O-RINGS ON STRIKER IAW CMM 52-11-05. SERVICED DAMPNER TO 1650 PSI IAW AMM 52-10-00-614-001. NO FURTHER LEAKS NOTED.SDR RAIA2009111600003Door · stiffCREW REPORTED THAT THE PASSENGER DOOR WAS DIFFICULT TO OPEN. MAINTENANCE LUBED THE DOOR'S INTERNAL LINKAGES. SUBSEQUENT OPERATIONAL CHECK OF THE DOOR CHECKED GOOD.SDR RAIA2009111600002Door · stiffTHE CREW REPORTED THAT THE PASSENGER WAS DIFFICULT TO OPEN. MAINTENANCE LUBED THE DOOR ACTUATING MECHANISM AND PERFORMED A SUCCESSFUL OPERATIONAL CHECK OF THE DOOR.SDR SWIA200922968Bolt · out of adjustMAIN CABIN DOOR DIFFICULT TO CLOSE. (FLT 6574) ADJUSTED MAIN CABIN DOOR HINGE ECCENTRIC BOLTS.SDR ASOA200901177Door · stuckF/A UNABLE TO OPEN PAX DOOR WITHOUT ASSISTANCE FROM OUTSIDE.SDR DL757100280Gate · corrodedL-4 DOOR LOWER GATE BOTTOM EDGE AND LIP HAVE PITTING (2 AREAS) CP53-221-O1E. R & R LOWER GATE AND ADJUSTED AT SAA SAT REF NON ROUTINE CARD 137339.SDR CA091023004Attach Angle · corroded(CAN) DURING BLOCK CHECK ON A/C THE PASSENGER DOOR WAS REMOVED AND ROUTED TO YYC OVERHAUL SHOP FOR REPAIR IN JULY OF THIS YEAR.THIS DOOR WAS BEING DISSASSEMBLED FOR REPAIR WHEN THE SHEETMETAL TECH DISCOVERED THE MAJOR INTERNAL CORROSION.SDR MASA2009102200322Bolt · out of adjustASH FLT 7304 OKC-IAD. CREW REPORTED PASSENGER DOOR WAS HARD TO OPEN AFTER LANDING. MX ADJ CLOSE TOL BOLT.SDR SWIA200922948Cam · out of adjustMAIN CABIN DOOR WILL NOT CLOSE. (FLT 5935) ADJUSTED MAIN CABIN DOOR LOWER TORQUE TUBE LOCKING CAM.SDR RAIA2009111600001Actuator · lack of lubeCREW REPORTED THAT THE MAIN PASSENGER STICKS WHEN OPENING IT. MAINTENANCE LUBRICATED THE MAIN DOOR ACTUATING ASSEMBLY. SUBSEQUENT OPERATIONAL CHECK WAS GOOD.SDR FDKA2009102100190Handle · out of adjustFRL FLT 6107 CVG. MAIN CABIN DOOR HARD TO OPEN FROM THE INSIDE. MX RE-INDEXED DOOR HANDLE AND LUBED ROLLERS, OPS GOOD.SDR C2XA09SH385Structure · corrodedSHV - DURING C-CHECK MAIN DOOR MOST LOWER NUT PLATE HOLES HAVE SURFACE CORROSION (LEVEL 2 LOCAL). MAINTENANCE PERFORMED REPAIR OF MAIN DOOR MOST LWR NUT PLATE HOLES IAW EMB-145 EC 5210-01154. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR A6WA200940702Structure · crackedPASSENGER DOOR EDGE MEMBER FWD AREA CRACKED (1.250 LONG). REPAIR TO PASSENGER DOOR EDGE MEMBER FWD AREA IAW REO 601R-52-11-279, REV NC. (K)SDR A6WA200940754Drag Angle · crackedPASSENGER DOOR STAIR AFT DRAG ANGLE AT F/S 349.00 IS CRACKED. (1.00" LONG) PASSENGER DOOR STAIR AFT DRAG ANGLE AT FS 349.00 REPAIRED IAW REO 601R-52-11-513, REV A. (K)SDR FDKA2009102000189Roller · dirtyFRL FLT 6136 CVG-LIT. CABIN DOOR UNABLE TO OPEN FROM INSIDE. MX CLEANED AND LUBED ROLLERS PLUS DOOR SEALS, OPS CHECK GOOD.SDR SWIA200922912Lanyard · out of positionUNABLE TO OPEN MAIN DOOR FULLY. (FLT 7556) REPOSITION FWD PAX DOOR HANDRAIL PIP PIN LANYARD AND RE-SECURED.SDR QXEA2009102100831Step · corrodedCORROSION ON MCD STEP ASSY LOCATED AT THE TOP STEP AFT STIFFENER PLATE. REPLACED THE MCD STEP ASSY.SDR QXEA2009102100830Step · corrodedCORROSION ON MCD STEP ASSY LOCATED AT THE TOP STEP FWD STIFFENER PLATE. REPLACED THE MCD STEP ASSY.SDR USAA2009102192817Cylinder · low pressureFLT 115 - LAS - EMERGENCY EGRESS SYSTEM - L1 DOOR ASSIST BOTTLE LOW. MAINTENANCE SERVICED L1 DOOR ASSIST BOTTLE PER AIRBUS MAINTENANCE MANUAL 52-10-00-614-001.
Back to JASC 5210