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 TRAX200600338Anchor Fitting · crackedASD FWD COUNTERBALANCE ANCHOR MOUNT CRACKED.SDR TRAX200600335Step · crackedBOTTOM STEP OF AIRSTAIR HAS BROKE CRACK... FLT 4273 DEL 25 MINS.SDR SWIA200617038Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS TO AFT DRAG ANGLE ON PAX DOOR PER CRJ700 SRM 51-42-11 PG 4; 51-42-06 PG 7 AND RII52-401.SDR QXEA200601465Latch · lack of lubeDEN - MAIN CABIN DOOR DIFFICULT TO LATCH CLOSED AND OPEN. MAINTENANCE INSPECTED THE DOOR MECHANISM, NO DEFECTS NOTED. APPLIED GREASE TO THE LATCH CAMS AS REQUIRED. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR TRAX200600316Plate · corrodedPAX DOOR AFT CABLE ANCHOR FITTING BASE PLATE CORRODED (MARKED). REMOVED AND REPLACED AFT ASD ANCHOR FITTING BASE PLATE IAW M/M 53. (CLOSED)SDR 2006FA0000681Handle · defectiveDOOR HANDLE WAS SPINNING INDEPENDENTLY OF THE MECHANISM FOR THE DOOR LATCH. THE PORTION OF THE HANDLE WITH THE SPLINE IS PRESSED INTO THE HANDLE. THE PRESS FIT WAS DEFECTIVE ALLOWING THE HANDLE TO SPIN FREELY. (K)SDR QXEA200601466Handle · lack of lubePDX - MAIN CABIN DOOR DIFFICULT TO OPEN. MAINTENANCE FOUND THE INNER HANDLE STICKING A LITTLE ON THE OPEN CYCLE. LUBED INNER HANDLE AND ADJUSTED THE INNER HANDLE DETENT ASSEMBLY IAW CRJ-700 AMM TASK 52-11-02-400-831-A01. OPERATIONAL CHECKS GOOD. HANDLE NO SDR AWXA200600927Plate · corrodedSAL - EES - DURING C6 CHECK DISCOVERED HONEYCOMB BROKEN ON PLATE OF GIRT BAR FITTING IN THE L2 DOOR FORWARD POSITION. MAINTENANCE REMOVED AND REPLACED PLATE OF GIRT BAR FITTING IN THE L2 DOOR FORWARD POSITION IAW AIRBUS 320 AMM 52-13-31.SDR COMA0660364Handle · out of rigFLIGHT 5588 - EN ROUTE JAN-CVG RECEIVED A CABIN DOOR OUTER HANDLE CAUTION MESSAGE. FLIGHT RETURNED TO THE FIELD. PERFORMED RE-RIGGING OF THE CABIN DOOR OUTER HANDLE ASSEMBLY.SDR MASA200601442Mechanism · lack of lubeASH 7275 IAD - PAX DOOR HARD TO OPEN. MX LUBED DOOR.SDR TRAX200600293Skin · crackedEVIDENCE OF POSSIBLE SKIN CRACK UNDER TOP ASD STEP FWD SECTION.SDR TRAX200600291Step · crackedLWR PAX DOOR STEP IS CRACKED. FLT 4680 DEL 22 MINS.SDR MASA200601433Handle · lack of lubeASH 7339 IAD - UNABLE TO OPEN MAIN CABIN DOOR FROM INSIDE. MX LUBED HANDLE.SDR TRAX200600285Handle · crackedASD HANDLE CRACKED.SDR UPS06247004Skin · crackedINSPECTION TYPE:C SUSPECT SKIN CRACK IN AFT AIRSTAIRS SKIN AT THE NR 8 STEP FROM THE BOTTOM POSITION. CARRY OUT NDI AND RECTIFY AS NECESSARY. HFEC CARRIED OUT ON SUSPECT CRACK IAW B727 NDTM 51-00-00 PT 6 FIG 4. CRACK CONFIRMED, ENDS MARKED. REPAIR CARRIED SDR TRAX200600289Step · brokenTOP ASD STEP BROKEN.SDR TRAX200600273Step · brokenFOUND LOWER ASD STEP BROKEN, FLT 4186 DEL 215 MINS.SDR 2006UALA01021Frame · crackedFWD ENTRY DOOR INNER SKIN AND FRAME HAS A CRACK RADIATING OUT OF DOOR STOP CUTOUTS 5TH FROM BOTTOM AFT SIDE, 4TH FROM TOP AFT SIDE AND 4TH FROM BOTTOM ON THE AFT SIDE.SDR TRAX200600334Anchor Fitting · crackedASD FWD ANCHOR MOUNT CRACKED (MTC).SDR TRAX200600260Door · malfunctionedDIFFICULTY CLOSING MAIN CABIN DOOR, FLT 4610 DEL 60 MINS.SDR UPS06847009Hinge Fitting · crackedINSPECTION TYPE:C1 DURING REMOVAL OF L-1 DOOR UPPER DOOR HINGE FITTING ASSY CRACKED. REMOVED AND REPLACED L-1 DOOR UPPER HINGE FITTING ASSY IAW SRM 51-1-2 0D, AND 51-3-0.SDR AWXA200600871Fitting · corrodedSAL - DURING C6 CHECK DISCOVERED CORROSION ON THE L2 SLIDE SUPPORT STRUCTURE FITTING BETWEEN BEAM 2 AND 3 AT FS 68 AND Y1292. MAINTENANCE REMOVED AND REPLACED THE L2 SLIDE SUPPORT STRUCTURE FITTING BETWEEN BEAM 2 AND BEAM 3 AT FS 68 AND Y1292 IAW AIRBUS 320 SSDR AWXA200600870Fitting · corrodedSAL - DURING C6 CHECK DISCOVERED CORROSION ON THE R1 SLIDE SUPPORT STRUCTURE FITTING BETWEEN BEAM 2 AND 3 AT FS 16 AND Y-1292. MAINTENANCE REMOVED AND REPLACED THE R1 SLIDE SUPPORT STRUCTURE FITTING BETWEEN BEAM 2 AND BEAM 3 AT FS 16 AND Y-1292 IAW AIRBUS 320SDR TRAX200600258Door · malfunctionedPAX DOOR WILL NOT OPEN, CABLE OFF PULLY.SDR TRAX200600252Door · malfunctionedPAX DOOR W/N OPEN FROM INSIDE OR OUTSIDE.SDR YENA200649Damper · leakingDURING C-1 CHECK PER ROUTINE CARD 10100-J1-1/8 DISCOVERED R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER HAS BEEN DISCHARGED INDICATING 0 PRESSURE IN THE GAUGE. REPLACED R1 DOOR DAMPER AS PER AMM 52-11-14-04.SDR TRAX200600251Step · brokenBOTTOM STEP BROKEN, FLT 4620 DEL 371 MINS.SDR TRAX200600250Anchor Fitting · crackedASD AFT ANCHOR FITTING CRACKED.SDR AWXA200600851Fitting · corrodedSAL - DURING C6 CHECK DISCOVERED CORROSION ON STRUCTURE FITTING OF L1 SLIDE SUPPORT. MAINTENANCE REMOVED AND REPLACED THE L1 SLIDE SUPPORT FITTING IAW AIRBUS 320 SRM 51-72-11.SDR 05242006ADoor Seal · blownCLIMBING THROUGH 16K TO FL 200 HAD VERY LOUD POP SOUND FOLLOWED BY CONSTANT HISSING COMING FROM FRONT OVERHEAD OF AIRCRAFT. FOUND MAIN ENTRANCE DOOR SEAL TO HAVE BEEN BLOWN. REMOVED AND REPLACED MAIN ENTRANCE DOOR SEAL.SDR 52106N116CS1Grommet · failedAIRCRAFT WAS EN ROUTE FROM MDW TO FTW, AT FL380 CABIN LOST PRESSURIZATION AFTER A NOISE WAS HEARD FROM MAIN CABIN DOOR. THE CABIN DOOR ANNUNCIATED AND CABIN CLIMBED TO 18,000 FEET, O2 MASK DEPLOYED. CREW DECLARED EMERGENCY AND BEGAN EMERGENCY DESCENT. AT 8,SDR TRAX200600245Anchor Fitting · crackedASD AFT ANCHOR FITTING CRACKED.SDR ASMF200605012Door · ground damageDURING TRANSIT CHECK, AIRCRAFT WAS STRUCK ON THE MAIN PASSENGERS DOOR BY MOBIL STAIRS. AIRCRAFT WAS INSPECTED IAW SRM 51-02 AND DAMAGE WAS WITHIN LIMITS. DURING OVERNIGHT CHECK AT MEX, FINAL REPAIR WAS PERFORMED IAW SRM 51-02, FIG 1, ALL CORRECT.SDR IXXA06SMN153SSkin · crackedDURING ROUTINE C CHECK INSPECTION, FORWARD PASSENGER DOOR SKIN WITH 03 CRACKS APPROXIMATELY ¾ INCH LONG. PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 NUMBER 06282 DATE 06-06-06, SEMAN DRAWING NUMBER ED 4238 DATED 06-03-06. REMOVED FASTENERS AS NEEDED TO REMOVE SDR TRAX200600242Skin · crackedPOSSIBLE SKIN CRACK UNDER TOP ASD STEP AFT SECTION.SDR SWIA200617013Handle · crackedPAX DOOR OUTER HANDLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED PAX DOOR OUTSIDE HANDLE (SERVICEABLE) PER CRJ 200 AMM SUBTASK 52-11-03-420-003 THROUGH ITEM 21.SDR QXEA200601338Mount Bracket · crackedPDX: C3. CRACKED MOUNT BRACKET AT AFT PAX DOOR SETP SLIDER ASSY AT THE OB STA X715. MAINTENANCE REPAIRED IAW HORIZON EA 6-53-714, Q400 SRM 51-42-05 AND SRM 51-40-10.SDR TRAX200600237Anchor Fitting · crackedPAX DOOR FWD AND AFT ANCHOR FITTINGS CRACKED. REMOVED AND REPLACED AFT FITTING, 601R380741-3, AFT LEVER 601R319741-1 AND BEARING M81934/2-10A016 IAW CRJ AMM 52-11-17. REMOVED AND REPLACED FWD FITTING 601R380742-3 IAW CRJ AMM 52-11-17. INSTALLED FWD LEVER 601SDR QXEA200601333Nut Plate · corrodedPDX: C3. AFT ENTRY DOOR AFT STOP FITTING (2ND FROM TOP) HAS CORRODED NUT PLATE AT LOWER OB BOLT POSITION. MAINTENANCE REPAIRED IAW EA 6-52-461 AND Q400 SRM 51-42-45.SDR TRAX200600236Structure · corrodedRANRC 256. PAX DOOR AFT CLEAT HAS CORROSION.SDR SWAA061702Door Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND R1 DOOR AFT FRAME CRACKED AT STOP PIN CUTOUT BELOW GUIDE ROLLER. REPAIRED DOOR FRAME PER SRM.SDR MASA200601353Door · malfunctionedASH 6459 LAS - PAX DOOR DIFFICULT TO OPEN. MX PERFORMED OP'S CHECK WITH NO DEFECTS NOTED.SDR MASA200601343Door · malfunctionedASH 7274 DSM - PAX DOOR WILL NOT OPEN FROM INSIDE OR OUTSIDE. MAINTENANCE PERFORMED AN OPERATIONAL CHECK WITH NO FAULT FOUND.SDR AWXA200600936Support Fitting · corrodedSAL - MAJOR REPAIR - DURING C6 CHECK DISCOVERED CORROSION ON THE R2 SLIDE SUPPORT STRUCTURE FITTING BETWEEN BEAM 2 AND 3 AT FR 68 AND Y-1292. MAINTENANCE REMOVED AND REPLACED THE R2 SLIDE SUPPORT STRUCTURE FITTING BETWEEN BEAM 2 AND BEAM 3 AT FR 68 AND Y-1292SDR TRAX200600218Hinge · damagedRANRC 173. HINGE CORRODED BEYOND LIMITS ON PAX DOOR STEP 832ET. REMOVED UNSERVICEABLE HINGE AND INSTALLED NEW HINGE IAW CRJ AMM 52-11-04. (CLOSED)SDR A6WA200640201Drag Angle · crackedFOUND DOOR AFT DRAG ANGLE CRACKED APPROX 1.4 INCH LONG IN AREA OF PULLEY BRACKET. MAINTENANCE REPAIRED PAX DOOR AFT DRAG ANGLE IAW BOMBARDIER REO 601R-52-11-513 REV A. (M)SDR QXEA20060198Fitting · chafedYYC - C4 AIR STAIR DOOR SHELL FORWARD UPPER AND LOWER STEP BOLT FITTINGS CHAFED, AFT LOWER FITTING CHAFED. REPAIRED IAW RD8-52-828 AND EA 2-52-224.SDR TRAX200600222Bracket · crackedA/S/D AFT. CABLE COUNTER BALANCE ANCHOR BRACKET CRACKEDSDR SIMA200613704Door · lightning strikeDEFERRED MAINTENANCE ITEM. LIGHTNING STRIKE DAMAGE ON PASSENGER DOOR. INSTALLATION OF DOUBLER IAW SRM 52-10-01. AIRCRAFT RETURNED TO SERVICE. (M)SDR SWIA200616968Angle · crackedPAX DOOR AFT TOP ANGLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. REPAIR PARTS INSTALLED AT AFT LOCATION IAW REO 601R-52-11-279 NOTES 5-10 AND SKYWEST RII 52-401.
Back to JASC 5210