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 SWIA200819668Handle · crackedPAX DOOR EXTERNAL HANDLE IS CRACKED, FOUND AT C-CHECK. REPLACED PAX DOOR HANDLE IAW CRJ200 SRM 51-41-04, 51-42-06 AND 51-42-21.
SDR SWIA200819647Handle · crackedPAX DOOR HANDLE CRACKED ON AFT SIDE, FOUND AT C-CHECK. REPLACED PAX DOOR LATCH LOCK BOX ASSEMBLY AS PER CRJ200 AMM 52-11-25-400-801.
SDR SWIA200819382Rod · out of adjustFLT 3789 - PAX DOOR IS DIFFICULT TO CLOSE. ADJUSTED PAX DOOR LATCH ROD IAW 52-11-21. OPS CHECK GOOD.
SDR C2XA08IA085Panel · looseCOS - FLIGHT 2422, THE CREW REPORTED THAT THE MAIN CABIN DOOR WOULD NOT OPEN FULLY. CONTRACT MAINTENANCE RE-SECURED A LOOSE INTERIOR DOOR PANEL, OPERATIONALLY CHECKED THE DOOR WITH NO DEFECTS NOTED, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR A6WA200840212Drag Angle · crackedPAX DOOR AFT WEB DRAG ANGLE IS CRACKED. REPAIRED IAW REO 601R-52-11-513 REV A. (M)SDR 2008UALA01551Skin · damagedL2 DOOR HINGE ARM CUTOUT HAS DAMAGE. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER REPAIR.SDR 2008UALA01550Skin · out of toleranceR2 DOOR UPPER HINGE ARM CUTOUT HAS DAMAGE. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER REPAIR.SDR 2008UALA01549Structure · corrodedR4 DOOR HANDLE BOX CORRODED BEYOND LIMITS. REPLACED HANDLE BOX. REPLACED HANDLE BOX.SDR 2008UALA01544Skin · crackedFWD ENTRY DOOR, AFT SIDE INNER SKIN CRACKED AT MID STOP PIN LOCATION. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED SKIN DOUBLER REPAIR TO INNER DOOR SKIN.SDR 2008UALA01523Skin · crackedFORWARD ENTRY DOOR UPPER HINGE CUTOUT HAS 2 EA CRACKS IN FASTENER HOLES AT BS 310 AND STRINGER S-10L. MAJOR REPAIR ACCOMPLISHED BY REMOVING DAMAGE AND INSTALLING STRUCTURAL FILLER AND REPAIR DOUBLER.SDR SWIA200819642Handle · crackedINNER PAX DOOR HANDLE IS CRACKED AT LOWER ATTACH POINT, FOUND AT C-CHECK. INSTALLED NEW PAX DOOR INNER HANDLE ASSEMBLY PER CRJ700 AMM 52-11-02-400-809-A01.SDR MALA080043Skin · dentedPASSENGER ENTRANCE DOOR HAS 1 DENT THAT IS DISBONDED. REPAIRED IAW EO NR S5202.8.SDR 2008UALA01490Connector · bentTHE 4R DOOR EPAS RESERVOIR ELECTRIC PLUG PIN BENT.SDR MASA200800231Handle · lack of lubeASH FLT 7547 ORD-SPI, PASSENGER DOOR WILL NOT OPEN FROM THE OUTSIDE. LUBED OUTER HANDLE, OPS CHECK GOOD.SDR 2008UALA01464Seal · dislodgedF/A'S UNABLE TO ARM DOOR 1R. UPPER AFT SECTION OF DOOR SEAL WAS DISLODGED FROM RETAINER. RE-INSTALLED RETAINER, DOOR OPS OK.SDR A6WA200840221Step · crackedPAX DOOR AFT SIDE PANEL, QTY TWO CRACKS EXIST AT 4 AND 5 STEP. PAX DOOR AFT SIDE PANEL REPAIRED IAW 601R-52-11-702 REV A. (M)SDR A6WA200840214Step · puncturedTOP STAIR ASSY IS PUNCTURED IN THE TREAD AREA. TOP STAIR ASSY PUNCTURED AREA REPAIRED IAW REO 601R-52-11-1457. (M)SDR F3LA200800127Skin · damagedFOLLOWING CONTACT OF THE JET BRIDGE WITH THE L-1 DOOR, INSPECTION, DURING THE DAILY CHECK, REPORTED DAMAGE WAS FOUND TO THE LOWER, FORWARD CORNER OF THE DOOR SKIN. MAINTENANCE REPAIRED THE FORWARD LOWER CORNER OF THE L-1 DOOR IN ACCORDANCE WITH THE REQUIREMENSDR F3LA20080017Skin · damagedFOLLOWING CONTACT OF THE JET BRIDGE WITH THE L-1 DOOR, INSPECTION, DURING THE DAILY CHECK, REPORTED DAMAGE WAS FOUND TO THE LOWER, FORWARD CORNER OF THE DOOR SKIN. MAINTENANCE REPAIRED THE FORWARD LOWER CORNER OF THE L-1 DOOR IN ACCORDANCE WITH THE REQUIREMENSDR A6WA200840220Structure · crackedCRACKS ON FORWARD AND AFT ON PAX DOOR UNDER STEP PLATE. REPAIRED IAW REO 601R-52-11-279. (M)SDR A6WA200840204Hinge · corrodedPAX DOOR FOLDING STEP UPPER HINGE FOUND CORRODED. PAX DOOR FOLDING STEP UPPER HINGE REPLACED WITH SERVICEABLE ITEM IAW CRJ 200 SRM 51-40-11 AND 51-41-04. (M)SDR SWIA200819360Fork · defectiveFLT 5727 - MAIN CABIN DOOR WILL NOT OPEN. REPLACED FORK ASSEMBLY ON AFT OVER CENTER CAM LINKAGE FOR CABIN DOOR. OP CHECKS GOOD.SDR KCSA081170Fitting · crackedMAIN ENTRY DOOR 1R UPPER AFT CORNER FITTING CRACKED BS 485.SDR KCSA081169Door Frame · crackedMAIN ENTRY DOOR 2L FWD LOWER CORNER FRAME CRACKED BS 808.SDR KCSA081168Door Frame · crackedMAIN ENTRY DOOR 4R LOWER AFT CORNER FRAME CRACKED AT PREVIOUS STOP DRILL.SDR KCSA081167Door Frame · crackedMAIN ENTRY DOOR 4R TOP AFT CORNER FRAME CRACKED BS 1700.SDR UIEA200800083Frame · crackedMAIN DECK L4 DOOR AFT LOWER CORNER FRAME CRACKED. CRACKED AREA REPAIRED PER SRM 52-10-02.SDR TRAX200800408Structure · crackedPAX DOOR AFT EDGE MEMBER CRACKED UNDER STEP 832ET. REMOVED DAMAGED AREA OF PAX DOOR AFT EDGE MEMBER PER: REO 601R-52-11-279. C/W HFEC INSP OF PAX DOOR AFT MEMBER, IAW NDTM 51-20-06 AND REO 601R-52-11-279. NO DEFECTS NOTED. COMPLIED WITH REPAIR OF PAX DOOR AFSDR 2008UALA01335Structure · damagedDOOR 2L UPPER HINGE CUT-OUT REQUIRES DOUBLER TO BE INSTALLED. MAJOR REPAIR ACCOMPLISHED.SDR 2008UALA01334Structure · damagedDOOR 2R UPPER HINGE CUTOUT REQUIRES DOUBLER TO BE INSTALLED. MAJOR REPAIR ACCOMPLISHED.SDR 2008UALA01333Structure · gougedDOOR 1R INTERIOR STRUCTURE IS GOUGED AT UPPER HINGE ARM AREA. ACCOMPLISHED MAJOR REPAIR.SDR MASA200800215Cable · defectiveASH 2859 PHX-MRY - CAPTAIN REPORTED THE MAIN PAX DOOR IS DIFFICULT TO OPEN AND CLOSE, LOCK/UNLOCK. REMOVED AND REPLACED THRESHOLD RETRACT CABLE.SDR MASA200800213Seal · dirtyFLT 2741, PHX-PSP - MAIN CABIN DOOR MAKES A HISSING NOISE PASSING THROUGH FL 200 AND BELOW, PLANE DID NOT LOSE PRESSURE. MX FOUND DOOR SEAL DIRTY, CLEANED AND RELUBED SEAL.SDR USAA920080605Diaphragm · defectiveFLT 9225 - MBJ-CLT - R2 DOOR WOULD NOT MOVE WITH NORMAL PRESSURE. MAINTENANCE REPLACED THE DIAPHRAGM IN THE PERCUSSION MECHANISM OF THE RIGHT AFT DOOR DAMPER AND EMERGENCY OPERATION CYLINDER. DOOR OPERATION NORMAL.SDR TRAX200800395Handle · bindingPAX DOOR HANDLE VERY DIFFICULT TO OPEN.SDR 2008UALA01303Bottle · low pressureDOOR 2R EMERGENCY DOOR ASSIST BOTTLE PRESS LOW. SERVICED BOTTLE TO FULL, NO LEAKS NOTED AT TIME OF SERVICE.SDR 2008UALA01288Door Frame · crackedFORWARD ENTRY DOOR AFT FRAME CRACKED AT 6TH FROM BOTTOM STOP PIN FITTING. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED EXTERNAL DOUBLER REPAIR.SDR 2008UALA01287Skin · crackedFWD ENTRY DOOR INNER SKIN AFT EDGE HAS A CRACK BETWEEN THE 5TH AND 6TH STOP PIN FITTING FROM BOTTOM. MAJOR REPAIR ACCOMPLISHED: REMOVED CRACK FROM SKIN AT 5TH FROM BOTTOM STOP PIN. FABRICATED & INSTALLED DOUBLER REPAIR.SDR GUUA03080804Handle · crackedDURING SCHEDULED ROUTINE MAINT, DISCOVERED AIRSTAIR DOOR INTERIOR HANDLE CRACKED. REPLACED AIRSTAIR DOOR INTERIOR HANDLE.SDR QXEA200800281Rod · brokenALW - UPON TRYING TO OPEN THE MAIN CABIN DOOR, THE GROUND CREW REPORTED THAT THE WERE UNABLE TO DO SO. MAINTENANCE ENTERED AIRCRAFT THROUGH THE CARGO DOOR AND FOUND THAT THE SUPPORTING ROD WAS BROKEN AT THE BASE. AIRCRAFT FERRIED TO PDX FOR REPAIRS. IN PDX,SDR A6WA200840158Handle · stuckFLIGHT CREW REPORTS PAX DOOR OUTER HANDLE DOES NOT RELEASE WHEN THE TRIGGER IS PRESSED. (K)SDR QXEA200800265Shaft · damagedSEA - FLIGHT ATTENDANT REPORTS MAIN CABIN DOOR DIFFICULT TO CLOSE. SEA MAINTENANCE INSPECTED AND FOUND HOLE ON SHAFT OBLONG. REMOVED AND REPLACED SHAFT FOR HANDRAIL MECHANISM ASSEMBLY ON FORWARD SIDE OF MAIN CABIN DOOR. DOOR OPS CHECKS GOOD. AIRCRAFT RETURSDR 2008UALA01254Lifter · wornDOOR 4R IS HARD TO ARM. FOUND AFT LIFTER ASSY WORN. FOUND METAL BURRS ON SLIDER. FILED OFF BURRS AND CLEANED SLIDERS, DOOR ARMS AND DISARMS NORMALLY.SDR MASA200800196Web · crackedREPAIR TO PAX DOOR AFT WEB CRACKS.SDR MASA200800191Door · lack of lubeASH 2728 PHX-LGB - PAX DOOR WILL NOT CLOSE. MX LUBED THE PAX DOOR AND OPS CHECK NORMAL.SDR MASA200800190Switch · out of adjustASH FLT 7350 - ORD - PAX DOOR OUTER HANDLE HARD TO STOW. ADJUSTED OUTER HANDLE STOW SWITCH, OPS CHECKS GOOD.SDR 08FDEA00760Rub Strip · chafedR-1 DOOR UPPER AFT CORNER IS CHAFED. REMOVED CHAFED RUB STRIP REF SRM 51-40-21 PARA 6. ALODINED AND PRIMED AREA REF SRM 51-21-10. INSTALLED NEW RUB STRIP REF SRM 51-40-21 PARA 6. MINOR REPAIR.SDR 08FDEA00759Rub Strip · chafedR-1 UPPER FWD CORNER IS CHAFED. REMOVED CHAFED RUB STRIP IAW SRM 51-40-21; PARA 6. ALODINED AND PRIMED AREA SRM 51-21-10. INSTALLED NEW RUB STRIP REF A310-200 SRM 51-40-21 PARA 6. MINOR REPAIR.SDR A6WA200840195Web · crackedPAX DOOR STAIRS AFT WEB FOUND CRACKED IN FIRST AND SECOND STEP CORNERS AREA. REPAIRED IAW REO 601R-52-11-702 REV A. (M)SDR A6WA200840194Web · crackedPAX DOOR STAIRS FORWARD WEB FOUND CRACK IN FIRST STEP CORNER AREA. PAX DOOR STAIRS FORWARD WEB REPAIRED IAW REO 601R-52-11-702 REV A. (M)
Back to JASC 5210