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 SWIA200718769Web · crackedPAX DOOR FORWARD WEB UPPER CORNER IS CRACKED, FOUND AT C-CHECK. INSTALLED REPAIR PARTS ON PAX DOOR PER REO NO 601R-52-11-1299.
SDR SWIA200718681Skin · crackedPAX DOOR HAS A CRACK ON EXTERNAL SKIN ON AFT END, FOUND AT C-CHECK. INSTALLED REPAIR DOUBLER ON EXTERNAL SKIN OF PAX DOOR ON THE AFT SIDE IAW REO:601R-52-11-104.SDR SWIA200718572Door · bindingMAIN CABIN DOOR IS DIFFICULT TO OPEN, FLIGHT NR 5553. CLEANED AND LUBED MAIN CABIN DOOR. OPS CHECK GOOD.SDR SWIA200718552Structure · crackedAFT PORTION OF PAX DOOR IS CRACKED UNDERNEATH TOP STEP. REPAIRED CRACK IAW REO 601R-52-11-279.SDR SWIA200718551Structure · crackedFORWARD PORTION OF PAX DOOR IS CRACKED UNDERNEATH TOP STEP. REPAIRED CRACK IAW AMM REO 601R-52-11-279.SDR CALA0700441Door Frame · crackedINSPECTION FOUND A CRACK EMANATING FROM THE DOORSTOP CUTOUT IN THE AFT EDGE BEAM OF THE L-1 DOOR. THE EDGE BEAM WAS REPAIRED IAW ECRA 5210-01944.SDR 2007UALA02921Gate · corrodedL-1 DOOR UPPER GATE CORRODED. REPLACED UPPER GATE FOR DOOR 1L.SDR 2007UALA02920Reservoir · low pressureDOOR 1L EMERGENCY POWER RESERVOIR PSI LOW. REPLACED EMERGENCY POWER RESERVOIR FOR DOOR 1R AND ACCOMPLISHED BOTTLE INSPECTION.SDR 2007UALA02886Bottle · reads lowDOOR 2L DOOR BOTTLE PRESSURE LOW. SERVICED DOOR 2L ASSIST BOTTLE- NO REPEATS SINCE ORIGINAL.SDR 2007UALA02884Bottle · reads lowDOOR 1R DOOR ASSIST BOTTLE LOW. LOW CYLINDER PRESSURE (UNKNOWN) SERVICED CYLINDER TO PROPER PRESSURE, NO REPEATS.SDR 07FDEA02661Panel · misalignedFL 390 LEFT MAIN CABIN DOOR ALARM AND LIGHT FLASHING, ADV BY JUMPSEAT, RT INDICATOR BETWEEN LOCK AND UNLOCK. DOOR ALARM OFF IN DESCENT BELOW FL 200/PRESSURE DIF.6.7 CABIN AT 3300' NO ECAM INDICATIONS FOR THE LEFT CABIN UNLOCKED. FOUND COVER PANEL OF DOOR (ISDR CA070729003Strut · damaged(CAN) ON ARRIVAL IT WAS DISCOVERED THAT THE PAX AIRSTAIR HAD BEEN DAMAGED WHEN CLOSED. MAINTENANCE FOUND A SMALL PUNCTURE IN THE MAIN CABIN DOOR INNER SKIN BESIDE UPPER STEP. MAINTENANCE DISCOVERED THE GAS STRUT ON THE MCD FAILED CAUSING THE SKIN PUCTURE BY SDR 2007UALA02876Skin · damagedL-2 DOOR IS DAMAGED AT UPPER HINGE CUTOUT. FABRICATED AND INSTALLED A FORMED ANGLE DOUBLER.SDR A6WA200740430Skin · crackedSKIN UNDER PAX DOOR AFT DRAG ANGLE IS CRACKED AT 3RD FASTENER DOWN APPROX .5 INCH LONG. (K) MAINTENANCE REPAIRED AFT DRAG ANGLE IAW EO 601R-52-12354. (M)SDR A6WA200740429Drag Angle · crackedAFT PAX DOOR DRAG ANGLE (PN 601R31772-5) IS CRACKED AT PREVIOUS REPAIR APPROX .5 INCH LONG. (K) MAINTENANCE REMOVED AND REPLACED DRAG ANGLE ON AFT PAX DOOR IAW REO 601R-52-11-513. (M)SDR 2007UALA02908Handle · sticksFLT ATTENDANT STATED DOOR 4R DISARM HANDLE STICKS. FOUND DIRT AND GARBAGE IN GIRT BAR RETAINER. CLEANED AND LUBRICATE.SDR SWIA200718683Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED, FOUND AT C-CHECK. INSTALLED REPAIR PARTS PER REO 670-52-11-072.SDR AWXA200700964Cover · wornSAL - MAJOR REPAIR - C-06 CHECK - NR 5979695, L2 DOOR UPPER PANEL/PLATE COVER WORN, BS 3158/FR 66 TO BS 3257/FR 68. REPLACED L2 DOOR UPPER PANEL/PLATE COVER, BS 3158/FR 66 TO BS 3257/FR 68 IAW A320 SRM 51-72-11.SDR AWXA200700963Cover · wornSAL - MAJOR REPAIR - C-06 CHECK - NR 5979694, R2 DOOR UPPER PANEL/PLATE COVER WORN, BS 3158/FR 66 TO BS 3257/FR 68. REPLACED R2 DOOR UPPER PANEL/PLATE COVER, BS 3158/FR 66 TO BS 3257/FR 68 IAW A320 SRM 51-72-11.SDR AWXA200700962Stop Fitting · wornSAL - MAJOR REPAIR - C-06 CHECK - NR 5990364, R2 DOOR LOWER STOP FITTING WORN, BS 709/FR 16. REPLACED R2 DOOR LOWER DOOR STOP FITTING, BS 709/FR 16 IAW A320 SRM 51-72-11.SDR AWXA200700961Stop Fitting · wornSAL - MAJOR REPAIR - C-06 CHECK - NR 5990363, R2 DOOR UPPER DOOR STOP FITTING WORN, BS 709/ FR 16. REPLACED R2 DOOR UPPER DOOR STOP FITTING, BS 709/FR 16 IAW A320 SRM 51-72-11.SDR UPS07M50385Retainer · damagedINSPECTION TYPE:C CABIN - TOOL MARKS ON R1 DOOR LWR LINING FWD VIEWER RETAINING BRACKET. TOOL MARKS ON RETAINING BRACKET REMOVED PER SRM 51-21-01VII R38. BRACKET ORIGINAL THK 0.063", REMOVED 0.023" REMN 0.040" FOUND EXCEEDED LIMIT PER SRM 52-00-01 FIG 1AVIR3SDR ASAA0781910Skin · dentedFORWARD ENTRY DOOR IS DENTED. RECONTOURED DOOR SKIN AND INSTALLED INTERNAL DOUBLER PER SRM 53-04.SDR TRAX200701109Drag Angle · crackedAFT DRAG ANGLE ON PAX DOOR IS CRACKED.SDR 2007UALA02830Bottle · dischargedDOOR 1R ASSIST BOTTLE HAS ZERO PRESSURE. PRESSURE DISK FAILURE ON DOOR ASSIST BOTTLE. REPLACED THE R1 DOOR BOTTLE PRESSURE DIAPHRAGM AND SERVICED BOTTLE.SDR 2007UALA02829Angle · gougedFWD ENTRY DOOR SN 229 WEB ANGLES AT BOTH UPPER AND LOWER TORQUE TUBE BUSHINGS ARE GOUGED FROM TORQUE TUBE CONTACT. MAJOR REPAIR ACCOMPLISHED: INSTALLED NEW INTERCOSTALS ADJACENT TO HINGE ARM CASTINGS.SDR 2007UALA02828Skin · crackedFWD ENTRY DOOR SN 229 INNER SKIN AND AFT FRAME CRACKED AT AFT SIDE NR 7 STOP FITTING CUTOUT. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED DOUBLER REPAIR.SDR FDKA200707346Seal · looseFDM 6104 MCO - SQUEALING FROM TOP OF MAIN CABIN DOOR DURING PRESSURIZATION. MX RE-INSTALLED SEAL ON FRAME, OPS CK AND LEAD CK GOOD.SDR SWAA073624Beam · crackedDURING SCHEDULED C2 CHECK, FOUND R1 DOOR CRACKED AT LOWER BEAM WEB. REMOVED AND REPLACED R1 DOOR ASSY PER MM.SDR MASA200700445Door · lack of lubeASH 7447 CLT - MAIN CABIN DOOR DIFFICULT TO CLOSE. MX CLEANED AND LUBED PAX DOOR.SDR RAIA00707039Door · lack of lubeFLT 3521 - PIT - PASSENGER DOOR WOULD NOT OPEN FROM INSIDE THE CABIN. MAINTENANCE LUBRICATED THE DOOR AND OPS CHECKED IT GOOD.SDR QXEA200701200Seal · dirtyPDX FLIGHT NR 2454: AFT PASSENGER DOOR HARD TO OPEN. MAINTENANCE CLEANED THE DOOR SEAL. OPS CHECK WAS GOOD. NO PARTS REPLACED. AIRCRAFT RETURNED TO SERVICE.SDR MASA200700443Door · stiffASH 2775 PHX. PAX DOOR DIFFICULT TO OPEN AND CLOSE. FERRIED A/C TO TUS FOR TROUBLESHOOTING.SDR TRAX200701038Handle · bindsPAX DOOR HANDLE HARD TO OPEN/CLOSE PAX DOOR. FLT 4407 DEL 147 MINS.SDR SWIA200718721Intercostal · crackedINTERCOSTAL IS CRACKED AT INSIDE RADIUS ON PAX DOOR AFT SIDE, FOUND AT C-CHECK. REPLACED INTERCOSTAL IAW CRJ200 SRM 51-42-06 PG 1-20 51-42-21 PG 1-18 51-42-13 PG 1-7.SDR SWIA200718720Support Angle · crackedPAX DOOR AFT SIDE OF DOOR SUPPORT STRUCTURE ANGLE IS CRACKED IN THE CORNER, FOUND AT C-CHECK. INSTALLED REPAIR PARTS ON AFT SIDE OF PAX DOOR PER REO:601R-52-11-513 REV A.SDR SIMA200721204Support Bracket · crackedMAIN DOOR HANDLE BRACKET CRACKED. REPAIRED DOOR BRACKET IAW EMB IC2007-145/05000 DATED JULY 24, 2007.SDR SWIA200718501Strut · bindingFLT 3865 - MAIN CABIN DOOR DOES NOT OPEN FREELY. REPLACED AFT PAX DOOR STRUT IAW AMM 52-11-17, PN: 601R31911-9.SDR SWAA073563Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR USAA070557Skin · crackedNR 4 STOP PIN ACCESS HOLE IS CRACKED AT EDGE OF DOOR INTERIOR SKIN. REPAIRED PER EA 98739, DEFECT SIZE: 1 INCH.SDR MASA200700437Fastener · looseASH 2765 PHX. MAIN CABIN DOOR DIFFICULT TO OPEN. MX SECURED PASSENGER DOOR PRESSURE VALVE ACTUATING ROD HARDWARE. NO FURTHER DEFECTS NOTED.SDR SWIA200718678Lever · crackedPAX DOOR OPEN AND CLOSE INTERNAL LEVER IS CRACKED AT LOWER BOTTOM AREA, FOUND AT C-CHECK. INSTALLED LEVER HANDLE PER CRJ7/9 AMM 52-11-02-400-803-A02.SDR SWIA200718601Rib · crackedPAX DOOR, AFT MID INTERNAL RIB IS CRACKED, FOUND AT C-CHECK. NEW RIB INSTALLED IAW SRM 120 51-10-02 PG 3 SEC 3A.SDR 2007UALA02744Spring · brokenCABIN DOOR 1R ARM-DISARM LEVER COVER SPRINGS BROKEN. 09-07-07 AFTER DIAGNOSING THE PROBLEM, DISARMED LEVER AT DOOR. REPLACED COVER FOR ARM.SDR MASA200700435Spring · defectiveASH 2985 PHX. MAIN CABIN DOOR HARD TO OPEN. REPLACED COUNTER BAL SPRINGS AND CAM FITTNGS AND RIGGED DOOR.SDR MASA200700436Unknown · malfunctionedASH 2932 LAS. CAPT REPORTS THE MAIN CABIN DOOR WILL NOT OPEN. CREW MOVED THE AIRCRAFT APPROX 10 FEET FORWARD PRIOR TO MAINT ARRIVING. MX OPENED THE MAIN CABIN DOOR FROM INSIDE AND OUTSIDE WITHOUT PROBLEM.SDR AMTA200700350Pushrod · out of adjustL-1 DOOR DIFFICULT TO CLOSE FROM OUTSIDE AIRCRAFT. REMOVED AND REPLACED 4 EA LATCH CAM ROLLERS. ADJUSTED COCKING PUSHROD IAW 52-11-13-2. DOOR OPS CHECK NORMAL. (K)SDR QXEA200701162Unknown · unknownFCA - ON FLIGHT 2285 ABORTED TAKEOFF, ON START OF TAKEOFF ROLL, RECEIVED A MASTER WARNING WITH FUSELAGE DOOR, AFT PASSENGER DOOR. MAINTENANCE PERFORMED OPS TEST OF THE AFT PAX DOOR IAW AMM TASK 52-12-00-710-802, PG 504-506 PAR 1-4. OPS CHECK GOOD. INTERROGATESDR 2007UALA02702Strap · looseR2 DOOR WILL NOT ARM. [08-17-07] REMOVED BUSTLE, TIGHTENED STRAPS AND OPS CHECKED OKAY. REINSTALLED BUSTLE.SDR IXXA070034ODoor · unlockedDURING TAKEOFF FROM WSAP AT SIXTY KNOTS, THE DOOR WARNING LIGHT (MASTER WARNING) ILLUMINATED. THE CREW ABORTED TAKEOFF WITHOUT INCIDENT AND RETURNED TO BLOCKS. MAINTENANCE INSPECTED THE AIRCRAFT AND FOUND R-2 DOOR UNLOCKED. MAINTENANCE RESECURED THE DOOR AN
Back to JASC 5210