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 9JLA201103033369Solenoid · defectiveCREW REPORTED CABIN DOOR ANNUNCIATOR REMAINED ILLUMINATED AFTER THE CABIN DOOR WAS CLOSED. TROUBLESHOOTING IDENTIFIED THE DOOR VENT SOLENOID AS DEFECTIVE. THE SOLENOID WAS REPLACED, FUNCTIONAL CHECKS WERE SATISFACTORY.SDR CHQA201100080Casting · corrodedDURING INSPECTION CORROSION WAS FOUND ON THE MAIN PASSENGER DOOR STRUCTURE OPEN HANDLE BACK CASTING. THE MAIN PASSENGER DOOR OPEN HANDLE BACK CASTING WAS REPLACED.SDR CHQA201100079Channel · corrodedDURING INSPECTION CORROSION WAS FOUND ON THE MAIN PASSENGER DOOR STRUCTURE FORWARD CHANNEL SPLICE. THE MAIN PASSENGER DOOR STRUCTURE FORWARD CHANNEL SPLICE WAS REPLACED.SDR CHQA201100089Fitting · corrodedDURING INSPECTION CORROSION WAS FOUND ON THE MAIN PASSENGER DOOR STRUCTURE AFT FITTING ON BOTTOM RIB. THE MAIN PASSENGER DOOR STRUCTURE AFT FITTING ON BOTTOM RIB WAS REPLACED.SDR CHQA201100088Angle · corrodedDURING INSPECTION CORROSION WAS FOUND ON THE MAIN PASSENGER DOOR STRUCTURE ANGLE BETWEEN FRAME 2 AND BOTTOM RIB. THE MAIN PASSENGER DOOR STRUCTURE ANGLE BETWEEN FRAME 2 AND BOTTOM RIB WERE REPLACED.SDR CHQA201100087Support · corrodedDURING INSPECTION CORROSION WAS FOUND ON THE MAIN PASSENGER DOOR STRUCTURE AFT SUPPORT ASSEMBLY ON BOTTOM RIB. THE MAIN PASSENGER DOOR STRUCTURE AFT SUPPORT ASSEMBLY ON BOTTOM RIB WAS REPLACED.SDR CHQA201100086Door Frame · corrodedDURING INSPECTION CORROSION WAS FOUND ON THE MAIN PASSENGER DOOR STRUCTURE BOTTOM FRAME 2. THE MAIN PASSENGER DOOR STRUCTURE BOTTOM FRAME 2 WAS REPLACED.SDR CHQA201100085Door Frame · corrodedDURING INSPECTION CORROSION WAS FOUND ON THE MAIN PASSENGER DOOR STRUCTURE BOTTOM FRAME 1. THE MAIN PASSENGER DOOR STRUCTURE BOTTOM FRAME 1 WAS REPLACED.SDR CHQA201100084Rib · corrodedDURING INSPECTION CORROSION WAS FOUND ON THE MAIN PASSENGER DOOR STRUCTURE BOTTOM RIB. THE MAIN PASSENGER DOOR BOTTOM RIB WAS REPLACED.SDR CHQA201100083Angle · corrodedDURING INSPECTION CORROSION WAS FOUND ON THE MAIN PASSENGER DOOR STRUCTURE FORWARD ANGLE ON AFT SIDE OF BOTTOM RIB. THE MAIN PASSENGER DOOR STRUCTURE FORWARD ANGLE ON AFT SIDE OF BOTTOM RIB WAS REPLACED.SDR CHQA201100082Rib · corrodedDURING INSPECTION CORROSION WAS FOUND ON THE MAIN PASSENGER DOOR STRUCTURE FORWARD SUPPORT ASSEMBLY BOTTOM RIB. THE MAIN PASSENGER DOOR STRUCTURE FORWARD SUPPORT ASSEMBLY BOTTOM RIB WAS REPLACED.SDR CHQA201100081Channel · corrodedDURING INSPECTION CORROSION WAS FOUND ON THE MAIN PASSENGER DOOR STRUCTURE FORWARD BOTTOM CORNER CHANNEL. THE MAIN PASSENGER DOOR STRUCTURE FORWARD BOTTOM CORNER CHANNEL WAS REPLACED.SDR CHQA201100078Profile · corrodedDURING INSPECTION CORROSION WAS FOUND ON THE MAIN PASSENGER DOOR STRUCTURE FORWARD U PROFILE. THE MAIN PASSENGER DOOR STRUCTURE FORWARD SIDE "U" PROFILE WAS REPLACED.SDR CHQA201100077Fitting · corrodedDURING INSPECTION CORROSION WAS FOUND ON THE MAIN PASSENGER DOOR STRUCTURE FORWARD STEP FITTING ASSEMBLY. THE MAIN PASSENGER DOOR STRUCTURE FORWARD STEP FITTING ASSEMBLY WAS REPLACED.SDR CHQA201100076Fitting · corrodedDURING INSPECTION CORROSION WAS FOUND ON THE MAIN PASSENGER DOOR STRUCTURE AFT STEP FITTING ASSEMBLY. THE MAIN PASSENGER DOOR STRUCTURE AFT STEP FITTING WAS REPLACED.SDR CHQA201100075Doubler · crackedDURING INSPECTION A CRACK WAS FOUND ON THE INTERNAL DOUBLER ON THE AFT BOTTOM CORNER OF THE MAIN PASSENGER DOOR. THE INTERNAL DOUBLER ON THE AFT BOTTOM CORNER OF THE MAIN PASSENGER DOOR WAS REPAIRED IAW ETD 2011-145/02468.SDR MASA2011030502072Cable · brokenMAIN PAX DOOR CABLE BROKEN. MX R2 POWER ASSIST MOTOR.SDR USAA2011030490959Bottle · low pressureFLT 614 - ATL - EES - L-2 DOOR ASSIST BOTTLE LOW PRESSURE (600 PSI). MAINTENANCE SERVICED L-2 DOOR ASSIST BOTTLE AS REQUIRED.SDR GTIA1100006Door Seal · leakingLOUD WHISTLING NOISE FROM L1 DOOR IAW TSM 52-11-00-810-826 SECTION 4A.(2) AND TSM TASK 52-11-00-810-811, PERFORMED T/S PROCEDURE OF THE L1 DOOR SEAL IAW AMM TASK 52-10-00-220-006 VISUAL INSP OF DOOR SEAL. L1 DOOR SEAL FOUND IN SERVICEABLE CONDITION. PRESSURISDR A6WA201140253Handle · crackedPAX DOOR OUTER HANDLE IS CRACKED. REMOVED CRACKED OUTER HANDLE ON PAX DOOR THEN INSTALLED NEW SERVICEABLE OUTER HANDLE ONTO DOOR IAW AMM 52-11-03.SDR A6WA201140252Structure · crackedPAX DOOR STAIR STRUCTURE CRACKED NEXT TO AFT HANDRAIL BRACKET, 3RD STEP FROM TOP OF DOOR CUT OUT DAMAGED SECTION AND FABRICATED NEW SECTION AND INSTALLED IAW B/A 601R-52-11-702, REV C, ZONE 2.SDR A6WA201140251Bracket · crackedPAX DOOR STAIR STRUCTURE IS CRACKED NEXT TO FWD HANDRAIL BRACKET 3RD STEP FROM TOP STEP. CUT OUT DAMAGE SECTION THRU FABRICATED NEW PARTS NEW PARTS AND INSTALLED IAW B/A REO 601R-52-11-702, REV C, ZONE 2.SDR GUUA95252030211ASkin · crackedDURING SCHEDULED ROUTINE MX DISCOVERED SMALL CRACK ON AIRSTAIR DOOR OUTER SKIN AROUND DOOR HANDLE. DURING FURTHER INSPECTION DISCOVERED CORROSION ON OUTER AIRSTAIR DOOR SKIN REMOVED CORRODED OUTER SKIN AND CRACK AND INSTALLED FILLER AND DOUBLER REPAIR.SDR MASA2011030502070Pin · brokenPAX DOOR HAND RAIL PIN CABLE BROKEN. MX REPLACED PIN.SDR MASA2011030502068Bonding Strap · brokenFWD ENTRY DOOR TO STEP BONDING WIRE BROKEN. MX INSTALLED BONDING WIRE AT FWD ENTRY DOOR, NO OTHER DEFECTS NOTED.SDR DALA1114759878Stop Fitting · crackedSTA 1187 LT LOWER STOP FITTING CRACKED. REMOVED LT LOWER STOP FITTING IAW SRM 51-30-5. RECEIVED CUST FURNISHED PART. LOCATED, DRILLED, DEBURRED AND INSTALLED IAW SRM 51-10-4 AND 51-30-5, PN 3917624-517.SDR A6WA201140254Panel · crackedAFT DRAG ANGLE ON PAX DOOR STAIRS SIDE PANEL CRACKED AT PULLEY MOUNT. REMOVED CRACKED SECTION OF DRAG ANGLE AND SPLICED IN NEW SECTION IAW B/A REO 601R-52-11-513, REV A.SDR SWIA201125778Mechanism · lack of lubePAX DOOR HARD TO OPEN. (SERVICE) LUBED PAX DOOR HANDLE MECHANISM.SDR MASA2011030402063Cable · misroutedPAX DOOR POWER ASSIST STOPS EARLY. MX PROPERLY ROUTED ASSIST CABLE, OPS GOOD.SDR MASA2011030402061Cam · lack of lubePAX DOOR HARD TO LATCH. MX LUBED CAMS.SDR MASA2011030402059Riser · crackedPAX DOOR TOP STEP RISER CRACKED. MX REPLACED RISER.SDR MASA2011030402058Paint · missingPAX DOOR TOP STEP RISER MISSING PAINT. MX RE-PAINTED TOP STEP RISER.SDR R61A20110054Unknown · malfunctionedCREW REPORTED L2 DOOR DIFFICULT TO ARM. MX INSPECTED DOOR IAW EMB AMM NO DEFECTS NOTED AC OK FOR SERVICE.SDR AALA20110301TUL02Pan · gougedLEFT NUMBER 4 DOOR HAS A HANDLE PAN WITH A DEEP GOUGE. REPLACED HANDLE PAN PER ESO 90108.SDR R61A20110053Door · out of adjustCREW REPORTED L-1 DOOR WAS HARD TO OPEN, MAINTENANCE ADJUSTED L-1 DOOR PER EMB AMM AND PERFORMED OPS CHECKS. A/C WAS THEN RETURNED TO SERVICE.SDR JR2R2011030100056Flap · crackedPAX DOOR EXTERNAL HANDLE FLAP IS CRACKED AT UPPER FWD CORNER AND UPPER AFT CORNER. REMOVED AND REPLACED PAX DOOR EXTERNAL HANDLE FLAP IAW CRJ 700 SRM 51-42-06.SDR R61A20110051Liner · looseCREW REPORTED L-1 DOOR WAS HANGING WHEN OPENING FROM THE OUTSIDE. MAINTENANCE INSPECTED L-1 DOOR RIGGING, AND TIGHTENED DOOR LINING PER EMB AMM, ALL OPS CHECK GOOD.SDR UALA2011022800989Skin · damagedDOOR 1L SKIN DAMAGED FWD FRAME ADJACENT STOP FTNG 2ND FROM TOP. SUPPLEMENTAL DATA UPDATE SKIN DAMAGE APROX 3.000 IN X 0,535, SEAL MATING FLNG DENTED. NOTE DEFECT HAS 1EA FASTENER DOES NOT MEET MINIMUM E.D. REQUIREMENTS. RMVD DAMAGED SKIN. ACCOMPLISHED HFEC NOSDR UALA2011022800983Pan · gouged#1 LEFT MAIN ENTRY DOOR HANDLE PAN GOUGED AT THE 11 TO 12 POSITION. THE DEPTH OF THE GAUGE IS .025" PER DRAWINGS THE SKIN IN THE AREA COULD BE STRETCHED AS THIN AS .045" DURING FORMING. FERRIED TO SFO FOR REPAIR. MAIN ENTRY DOOR 1 LEFT CAM BASKET BEARING WORSDR QXEA2011030400200Door · bindingF/A REPORTS THAT THE MAIN CABIN DOOR IS DIFFICULT TO OPEN. CYCLED THE MAIN CABIN DOOR SEVERAL TIMES, DOOR OPERATES NORMALLY. DOOR HAD A LARGE AMOUNT OF WATER ALL OVER. SUSPECT ICE BUILD UP FROM THE PREVIOUS FLIGHT. NO OTHER DEFECTS NOTED. RETURNED TO SERVSDR RAIA201102280002Bracket · brokenDURING POST FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE PASSENGER DOOR STEPS DID NOT DEPLOY. MAINTENANCE INSPECTED AND REMOVED AND REPLACED THE PASSENGER DOOR AIRSTAIR BRACKET. DOOR OPS CHECKED GOOD.SDR ASOA201100405Door · lack of lubeUNABLE TO OPEN PAX DOOR FROM OUTSIDE UPON ARRIVAL AT AIRCRAFT. LUBED PAX DOOR AND PERFORMED OPS CHECKED , NO DEFECTS NOTED AT THIS TIME. ACFT OK FOR SERVICE PER AMM 52-11-00.SDR MASA2011030202050Support · crackedMED TOP STEP SUPPORT CRACKED. ORIGINAL DISCREPANCY WAS DEFFERED AND A NEW DISCREPANCY (ITEM 0210556) WAS OPENED ON 3/1/2011 TO ACCOMPLISH THE REPAIR. PAX DOOR TOP STEP RISER CRACKED. CORRECTIVE ACTION (ON 3/1/11) WAS, REPLACED RISER.SDR MASA2011030202049Spring · defectiveMED GROUND SUPPORT WHEEL NOT LATCHING OPEN. MX REPLACED TORSION SPRING ON ASSIST WHEEL LATCH ASSY.SDR MALA110042Mount · crackedNOTED CRACK THRU TOP RIVET ON AFT DOOR MOTOR MOUNT. REPAIRED DAMAGE IN ZONE 4 ON PAX AFT STAIR SIDE PANEL USING REO 670-52-11-104 AS REF. ACCOMPLISHED EDDY CURRENT INSPECTION OF REPAIRED AREA AND CUTOUT EDGES PER NDTM 51-20-006 CRACK FREE AT THIS TIME.SDR MALA20110041Drag Angle · crackedNOTED 1,5 INCH CRACK IN RADIUS OF AFT DRAG ANGLE NEAR THE SUPPORT WHEEL PULLEY BRACKET AREA ON FWD PAX DOOR. REPAIRED AFT DRAG ANGLE USING SRM 52-11-04 & REO 690-52-11-026 AS REF.SDR FDEA201102270788Skin · corrodedCABIN L1 DOOR WITH SURFACE CORROSION AT SURFACE INNER SKIN ADJACENT TO LOWER RT OF DOOR HANDLE MECHANISM. CORRODED STRAP REPLACED AS PER E.A. F-5210-146430. REPAIR IS CLASSIFIED AS MAJOR.SDR MASA2011030102045Unknown · malfunctionedPAX DOOR SLAMMING TO THE GROUND. MX OPS CHECK GOOD.SDR MASA2011030102041Motor · inoperativePAX DOOR ACTUATOR INOP. MX REMOVED AND REPLACED PAX DOOR MOTOR.SDR USAA20110301SB036Hinge · lack of lubeLAS - CREW REPORTED THE L1 FORWARD ENTRY DOOR WAS DIFFICULT TO OPEN. FLIGHT ATTENDANT STATED SHE COULD NOT OPEN THE DOOR WITHOUT ASSISTANCE FROM PERSON ON OUTSIDE. RUBBER ON BOTTOM OF DOOR CATCHES ON FRAME OF DOOR. MAINTENANCE LUBRICATED DOOR HINGES. DOOR
Back to JASC 5210