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 SWIA201230497Roller · lack of lubeTHE MAIN CABIN DOOR RELEASE HANDLE BECAME STUCK ABOUT 1/2 WAY THOUGH ITS TRAVEL. (FLT 6272) LUBED MAIN CABIN DOOR ROLLERS AND DOOR HANDLE.SDR GTIA20120421404Cylinder · low pressurePAX DOOR ASSIST BOTTLES REQUIRE SERVICING. DOOR ASSIST BOTTLES SERVICED IAW AMM 52-10-00-614-001.SDR SWIA201230484Door · lack of lubeMAIN CABIN DOOR DIFFICULT TO OPEN. (FLT 5232) LUBRICATED MAIN CABIN DOOR IN REF TO AMM.SDR USAA2012042300006Door · out of adjust2S CHECK - OUT OF ADJUSTMENT DIMENSION B BETWEEN STRIKER LEVER AND FINGER AT PASSENGER L2 DOOR 832. ADJUSTED CLEARANCE J1 BETWEEN STRIKER LEVER AND FINGER AT PASSENGER L2 DOOR 832 IAW A319 AMM 52-13-14-820-002-A ITEM 4A.SDR GTIA20120420403Cylinder · low pressureR1 DOOR EMERGENCY ACCUMULATOR LOW. SERVICED IAW AMM 52-10-00-614-001-A.SDR V0XR20120422J0022Angle · corrodedPASSENGER DOOR LOWER THRESHOLD KICK ANGLE CORRODED BEYOND SERVICEABLE LIMITS. REMOVED AND CLEANED CORROSION FROM KICK ANGLE,.004" MATERIAL REMOVED, PART WITHIN LIMITS, TREATED, PRIMED,AND PAINTED WITH TOPCOAT LAW SRM 53-21-23, 51-21-06,51-25-06, 51-25-16, 51SDR SIMA20120419003Roller · lack of lubeON FLIGHT 4257 THE CREW REPORTED THE MAIN CABIN DOOR WAS HARD TO OPEN. THE AIRCRAFT WAS REMOVED FROM SERVICE. LUBRICATED MAIN DOOR ROLLERS IAW EMB 53-21-02. NO PARTS REMOVED OR REPLACED. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SIMA20120419002Roller · out of adjustON FLIGHT 4160 THE FLIGHT ATTENDANT REPORTED THE MAIN CABIN DOOR WAS DIFFICULT TO OPEN. THE AIRCRAFT WAS REMOVED FROM SERVICE. FOUND UPPER ROLLERS HITTING TRACKS. ADJUSTED ROLLERS IAW EMB-145 AMM 52-18-00. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SIMA20120419001Door · lack of lubeON FLIGHT 2717 THE CREW REPORTED THE MAIN CABIN DOOR WAS HARD TO OPEN. THE AIRCRAFT WAS REMOVED FROM SERVICE. CLEANED AND LUBED MAIN CABIN DOOR. NO PARTS REMOVED OR REPLACED. THE OPERATIONAL CHECK WAS GOOD PER AMM 52-18-00. NO DEFECTS NOTED. THE AIRCRAFTSDR DALA1225366306Skin · crackedDURING INSPECTION, MAINTENANCE FOUND NR 5R MAIN ENTRY DOOR AFT UPPER CORNER CUTOUT CRACKED. CRACK REPAIRED PER ERA 505022-14.SDR A6WA201240489Anchor Fitting · crackedPAX DOOR CUT OUT FWD AND AFT ANCHOR FITTING CRACKED. REMOVED UNSERVICEABLE FWD AND AFT PAX DOOR ANCHOR FITTINGS AND INSTALLED SERVICEABLE FWD AND AFT PAX DOOR ANCHOR FITTINGS.SDR A6WA201240473Anchor Fitting · crackedPAX DOOR CUT OUT FWD AND AFT ANCHOR FITTING CRACKED. REMOVED UNSERVICEABLE FWD AND AFT PAX DOOR ANCHOR FITTINGS AND INSTALLED SERVICEABLE FWD AND AFT PAX DOOR ANCHOR FITTINGS.SDR UHLA2012041800131Indicator · out of adjustL1 DISARM INDICATOR NOT FULL IN WINDOW. ADJUSTED ARM/DISARM INDICATOR, OPS CHECK GOOD IAW EMB 170 MM 52-11-00.SDR R61A201204180244O-Ring · missingCREW REPORTED L1 DOOR WAS DIFFICULT TO OPERATE. MAINTENANCE REPLACED O-RING FOR L-1 DOOR ASSIST BOTTLE PER EMB AMM, OPS CHECK GOOD.SDR GLBA2012041901Door · out of rigCABIN DOOR HARD TO OPEN FROM INSIDE. RIGGED MAIN DOOR AND REPLACED BUSHINGS, OPS CHECKED GOOD.SDR HNAA2012041800739Shaft · corrodedSHAFT ON FORK ASSY THAT ATTACHED TO THE BOTTOM OF LOWER DOOR STRUT ASSY AFT END IS CORRODED. REMOVED SHAFT AND FORK ASSY FROM PAX DOOR STEPS. INSTALLED NEW SHAFT ON FORK ASSY.SDR HNAA2012041800738Post · corrodedLOWER END OF FORWARD POST IS CORRODED. REMOVED LOWER FORWARD POST. REMOVED LIGHT CORROSION ON LOWER END OF FORWARD POST AND INSTALLED ON PAX DOOR SHAFT ASSY.SDR HNAA2012041800736Shaft · corrodedSHAFT ON FORK ASSY THAT ATTACHES TO THE BOTTOM OF LOWER PAX DOOR STRUT ASSY IS CORRODED. REMOVED SHAFT AND FORK ASSY FROM PASSENGER DOOR STEP. INSTALLED NEW SHAFT TO FORK ASSY AND INSTALLED FORK ASSY TO LOWER STRUT ASSY.SDR UALA2012041902333Gate · gougedL2 DOOR LWR GATE HAS A GOUGE NEAR THE CENTER BOTTOM. REMOVED AND REPLACED LWR DOOR GATE ON LP 9964609.SDR REXA2012041700524Wheel · out of adjustMAIN CABIN DOOR HYPER EXTENDED, DOOR IS RESING ON RAMP, WHEEL OUT TO THE SIDE. ADJUSTED & INSPECTED PAX DOOR SUPPORT WHEEL PER CRJ200 AMM 52-11-13. OPS CHECK GOOD. OK FOR SVC.SDR SWAA2012050703718Door Frame · crackedL1 DOOR INTERNAL FRAME CRACKED AT BS 312 FWD LOWER CORNER. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWIA201230449Handle · dirtyMAIN CABIN DOOR DIFFICULT TO OPERATE. (FLT 5511) CLEANED AND LUBED MAIN CABIN DOOR OUTER AND INNER HANDLES, AND LUBED BOTH FWD AND AFT HINGE ARMS.SDR UHLA2012041600128Window · out of positionL1 DOOR CLOSED GREEN INDICATOR WINDOW IS NOT POSITIONED CORRECTLY ON AFT POSITION OF SURROUND. REMOVED AFT PORTION OF L1 DOOR SURROUND FOM. REPAIRED L1 SURROUND VIEWING WINDOW LOCATION IAW EMB 170 MM 25-00-19, RE-INSTALLED REPAIRED L1 DOOR SURROUND AFT PORTISDR UALA2012041702323Lanyard · misroutedDOOR 3 LEFT LANYARD IS ON WRONG SIDE. ROUTED LANYARD CORRECTLY.SDR V0XD201204190014Cable Guide · unsafetiedPASSENGER DOOR SUPPORT WHEEL BRACKET PULLEY CABLE GUIDES NOT SAFETIED. SAFETIED PASSENGER DOOR SUPPORT WHEEL BRACKET PULLEY CABLE GUIDES IAW AMM 52-11-13-400-802.SDR V0XD201404190014Cable Guide · unsafetiedPASSENGER DOOR SUPPORT WHEEL BRACKET PULLEY CABLE GUIDES NOT PROPERLY SAFTIED. SAFTIED PASSENGER DOOR SUPPORT WHEEL BRACKET PULLEY CABLE GUIDES AS REQUIRED IAW AMM 52-11-13-400-802.SDR V0XD201204180003Channel · corrodedPASSENGER DOOR CORRODED BEYOND SERVICEABLE LIMITS FROM FS 311.75 TO FS 347.25, END CAPS. CLEANED AND TREATED PASSENGER DOOR FROM FS 311.75 TO FS 347.25, LOWER SECTION, FORWARD BOTTOM CORNER IAW SRM 51-21-06, 51-26-00.SDR V0XD201204180002Channel · corrodedPASSENGER DOOR CORRODED BEYOND SERVICEABLE LIMITS FROM FS 311.75 TO FS 347.25, END CAPS. CLEANED AND TREATED PASSENGER DOOR FROM FS 311.75 TO FS 347.25, LOWER SECTION, FORWARD BOTTOM CORNER IAW IAW SRM 51-21-06, 51-26-00.SDR V0XD201204180001Channel · corrodedPASSENGER DOOR CORRODED BEYOND SERVICEABLE LIMITS FROM FS 311.75 TO FS 347.25, END CAPS. CLEANED AND TREATED PASSENGER DOOR FROM FS 311.75 TO FS 347.25, LOWER SECTION, FORWARD BOTTOM CORNER IAW SRM 51-21-06, 51-26-00.SDR USAA2012041700007Cylinder · low pressure2S CHECK - DISCHARGED L2 CABIN DOOR EMERGENCY POWER ASSIST CYLINDER. RE-CHARGED L2 CABIN DOOR EMERGENCY POWER ASSIST CYLINDER PER A320 AMM 52-10-00.SDR USAA2012041700006Cylinder · low pressure2S CHECK - DISCHARGED L1 CABIN DOOR EMERGENCY POWER ASSIST CYLINDER. RE-CHARGED L1 CABIN DOOR EMERGENCY POWER ASSIST CYLINDER PER A320 AMM 52-10-00.SDR CA120417011Seal · loose(CAN) DOOR SEAL BLEW OUT ON ROUTE,THROUGH FL 310. PRESSURIZATION WAS NOT AFFECTED, BUT THE NOISE CAUSED PROBLEMS WITH ATC COMMUNICATION. THE NOISE WAS CONSIDERABLE UNTIL PRESSURIZATION DIFFERENTIAL WENT DOWN. MAINTENANCED ADDRESED PROBLEM BY, REPAIRING DOOSDR QXEA2012041500314Stop Fitting · corrodedFWD PAX DOOR FUSELAGE UPPER STOP FITTINGS HAVE PITTING CORROSION. REMOVED CORROSION IAW SRM 51-21-00-00-02. FOUND OUT OF LIMITS. REPLACED FWD PAX DOOR FUSELAGE UPR STOP FITTINGS FWD AND AFT IAW SRM 51-41-00-00-01.SDR R61A201204170235Door · obstructedCREW REPORTED THE L-1 DOOR WOULDN'T OPEN. MAINTENANCE REMOVED VALVE CAP FROM GIRT BAR LOCATION AND PERFORMED, OPS CHECK OF L-1 DOOR PER EMB AMM. OPS CHECK GOOD.SDR GTIA20120415402Cylinder · low pressureL1 DOOR ASSIST PRESSURE REQUIRE SERVICE. SERVICED L1 DOOR ASSIST PRESSURE IAW AMM 52-10-00-614-001.SDR REXA2012041400073Hinge · wornAD102314CR2, PAX DOOR HINGE WORN (DOOR HINGE). REMOVED & REPLACED WORN HINGE IAW CRJ200 SRM 52-10-31. 601R318073-5, B18040, HST11HG-5-6, B88173, HST11HG5-7, B18159, HST11AG5-8, B18158, HST11AG5-9, B19143, B0203016-08, B19498 AAR SM-28.SDR ASOA20120425065Skin · dentedPAX DOOR HAS PETRUDING DENT BELOW HANDLE. CUT OUT DAMAGE, FABRICATED, ALODINED, PRIMED AND PAINTED DOUBLER AND FILLERS. INSTALLED DOUBLER AND FILLER.SDR FDEA201204141426Pulley · wornL1 UPPER AFT DOOR FRAME DRIVE CABLE PULLEY WORN REMOVED AND REPLACED PULLEY ASSY IAW SRM 51-31-01. NO RIG DISTURBED. OPS CHECKED GOOD IAW AMM 52-11-00-5. MINOR REPAIR.SDR FDEA201204141425Pulley · wornL1 UPPER FWD DOOR FRAME DRIVE CABLE PULLEY IS WORN. R & R PULLEY ASSY IAW SRM 51-31-01. NO RIG DISTURBED. OPS CHECKED GOOD IAW AMM 52-11-00-5. MINOR REPAIR.SDR FDEA201204141402Gust Lock · brokenL1 DOOR GUST LOCK COLLAR BROKEN. R & R L-1 DOOR HOLD OPEN LOCK IAW MM REF 52-11-08-8. OPS CHECKED GOOD. OK FOR SERVICE.SDR R61A201204130233Damper · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE L1 DOOR DAMPER. MAINTENANCE REMOVED & REPLACED THE L1 DOOR DAMPER IAW EMB 190 AMM 52-11-27. AIRCRAFT IS CURRENTLY STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR UHLA2012041300125Door · lack of lubeL1 DOOR HARD TO OPEN HANDLE FROM INSIDE OF A/C. LUBED L1 DOOR, REMOVED DEBRIS, PERFORMED OPS CHECK IAW EMB 170 MM 52-11-00. OPS CHECK GOOD.SDR UHLA2012041300124Indicator · misalignedWINDOW THAT INDICATES GREEN ON MAIN CABIN DOOR HAS INDICATOR MISALIGNED SO THE GREEN INDICATION IS NOT SHOWING CORRECTLY. MAINTENANCE DEFERRED. ON 4/16/12 MAINTENANCE REPAIRED THE L1 DOOR SURROUND VIEW WINDOW.SDR ASOA201201269Relay · unserviceableF/A REPORTED, OPENING PASSENGER DOOR, DOOR AUTOMATICALLY CLOSED ON ITS OWN. RESISTANCE IS FELT. DOOR KEPT CLOSING ON ITS OWN WHILE PASSENGER WERE EXITING AIRPLANE. PULLED CIRCUIT BREAKER 1F1 TO STOP DOOR FROM CLOSING. CIRCUIT BREAKER LEFT OPEN. R & R JB-SDR R61A201204130230Damper · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND L2 DOOR DAMPER IS CORRODED. MX REMOVED AND REPLACED THE L2 DOOR DAMPER IAW EMB 190 AMM 52-11-27 PN SP-21619A. A/C REMAINS IN CMH FOR HEAVY CHECK COMPLETION.SDR USAA2012041600022Cylinder · low pressureL-1 DOOR BOTTLE NEEDS SERVICE. MAINTENANCE SERVICED L1 DOOR BOTTLE IAW AIRBUS MAINTENANCE MANUAL 52-10-00.SDR AALA20120413041Doubler · damagedFORWARD ENTRY DOOR, DOUBLER AT HOLD OPEN HOOK CUTOUT DAMAGED FROM HOOK CONTACT. INSTALLED DOUBLER PER SRM 52-05-00 FIGURE 20A.SDR GTIA20120413401Cylinder · low pressureR2 DOOR ASSIST BOTTLE REQUIRES SERVICE. SERVICED R2 DOOR ASSIST BOTTLE IAW AMM 52-10-00-614-001. NO OTHER DEFECTS NOTED AT THIS TIME.SDR CALA2012041300261Reservoir · low pressureDOOR ASST BOTTLE, DOOR 1L ZERO PRESSURE. R & R L1 EMERGENCY ASST BOTTLE PER AMM 52-11-30-404-013.SDR SIMA20120413001Rod · out of adjustON FLIGHT 3407 THE CREW REPORTED THE MAIN CABIN DOOR WAS HARD TO OPEN/CLOSE. THE AIRCRAFT WAS REMOVED FROM SERVICE. ADJUSTED PASSENGER MAIN CABIN DOOR. ADJUSTED INTERCONNECTION ROD V IAW AMM 52-18-00 DOOR OPEN/CLOSES NORMALLY AT THIS TIME NO DEFECTS NOTED.
Back to JASC 5210