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 07FDEA01625Channel · dentedAFT PAX DOOR LOWER DOOR CHANNEL DAMAGED (DEFORMATION) REPAIR PERFORMED BY REPLACEMENT OF PARTS (LOWER CHANNEL P/N A521-75271-202, SEGMENT P/N A521-75325-332).SDR ABXA070157Strap · crackedMAIN ENTRY DOOR INTERIOR FRAME STRAP CRACKED JUST AFT OF DOOR UPPER HINGE POINT AT APPROXIMATELY STA 170. REMOVED AND REPLACED FRAME STRAP IAW DC9 SRM 51-30-2, 51-30-5, AND 51-30-1.SDR ABXA070156Pan · crackedMAIN ENTRY DOOR FRAME CRACKED AT FORWARD LOWER CORNER JUST FORWARD OF LOWER HINGE POINT. REMOVED AND REPLACED DOOR PAN SEGMENT IAW DC9 SRM.SDR FDKA200704162Cam · lack of lubeFDM 6053 PHF-ATL (0615 PHX LCL). MAIN PASSENGER DOOR IS HARD TO OPEN AND CLOSE. MX LUBED CAM, DOOR SEAL.SDR A6WA200740217Handle · lack of lubeAT ROTATION GOT PAX DOOR CAUTION MESSAGE ILLUMINATED COMPLIED WITH QRH GREEN WITNESS MARKS NOT ALIGNED AT GATE DOOR STILL WOULD NOT CLOSE PROPERLY. INSPECTED DOOR AND FOUND EXTERNAL HANDLE WOULD NOT STOW WITHOUT USE OF EXCESSIVE FORCE FROM INTERNAL STOW HANDLSDR YENA2007027Seal · dirtyFLT 1242, TPA TO BOS, RETURNED TO TPA AFTER HEARING LOUD WIND NOISE FROM 1R DOOR AND VIBRATION. PRESSURIZATION NOTES: CABIN ALT 7300 FT, RATE OF CLIMB 700-800 FPM, AP 4 PSI, AT FL190. CLEANED DOOR SEAL & PERFORMED PRESSURIZATION CHECK IAW AMM 21-31-00-720-8SDR 07FDEA01587Handle · wornR1 DOOR EMERGENCY HANDLE BACKLOCK DOES NOT HOLD HANDLE ONCE HANDLE IS MOVED TO EMERGENCY POSITION. FOUND OVERRIDE LEVER BINDING WITH BACKLOCK. REPLACED BUSHING, SEAL AND LEVER IAW MD10-10 MM 52-11-14-2 AXIAL PLAY CK GOOD. PERFORMED PNEUMATIC TEST TO CK BASDR TRAX200700561Handle · brokenFWD PAX DOOR OUTER HANDLE BROKEN.SDR MASA200700221Spring · bindingASH 7155 ROC - RETURNED TO THE FIELD DUE TO PASSENGER DOOR WARNING MESSAGE IN FLIGHT. MX INSPECTED, FOUND DOOR LOCK HANDLE DETENT CAM SPRING BINDING. CLEANED AND LUBED, OPS CHECKED GOODSDR SWIA200718305Web · crackedPAX DOOR FORWARD WEB IS CRACKED AT HANDRAIL SUPPORT, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS PER CRJ 700 REO 67-0-52-11-104 REV B, REPAIR SCHEME 2 SHEET 6.SDR SWIA200718304Web · crackedPAX DOOR AFT WEB IS CRACKED AT HANDRAIL SUPPORT, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS IN ACCORDANCE WITH CRJ 700 REO 601R-52-11-104 REV B.SDR HNAA0700078Bolt · missingUNABLE TO OPEN THE PAX DOOR FROM THE INSIDE. FERRYING AIRCRAFT TO CLT FOR REPAIRS. REPLACED MISSING BOLT AND WASHER THAT SUPPORTS OUTER SKIN RIGHT SIDE AT BOTTOM STEP, OPS CHECK GOOD.SDR DXTA200702132Control Valve · inoperativeAFTER FLIGHT, CABIN DOOR WOULD NOT OPEN FROM INSIDE, APPLIED EXCESSIVE FORCE MULTIPLE TIMES OVER 15 MINUTE PERIOD. HAD TO OPEN DOOR FROM OUTSIDE. TOOK A WHILE AND WAS VERY HARD FROM OUTSIDE ALSO. AIR PRESSURE WAS NOT RELEASING. REMOVED AND REPLACED MAIN CABINSDR MASA200700222Rod · damagedASH 7379 IAD - AIRCRAFT RETURNED TO FIELD FOR PAX DOOR OUTER HANDLE CAUTION MESSAGE. MX REPLACED PAX DOOR PRESSURIZATION FLAPPER DOOR ROD.SDR SWIA200718368Web · crackedPAX DOOR AFT WEB IS CRACKED AT HANDRAIL SUPPORT BRACKET, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS PER CRJ200 REO 601R 52-11-702 REV 'A'.SDR SWIA200718367Web · crackedPAX DOOR FORWARD WEB IS CRACKED, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS PER REO 601R-52-11-702 REV A.SDR SWIA200718365Structure · crackedPAX DOOR HAS CRACK AT LOWER AFT CORNER, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS AT LOWER AFT AND LOWER FORWARD PAX DOOR UNDER TOP STEP PER CRJ200 REO 601R 52-11-279 REV NC.SDR EIA2007112Stop Fitting · crackedDOOR STOP NR 9 ON LT MAIN ENTRY DOOR CRACK NOTED DURING ACCOMPLISHMENT OF EO, LOCATED AT BS 488 FRAME WEB TOOLING HOLE. REPAIRED MAIN ENTRY DOOR FRAME STA 488 PER SRM B747 53-10-04 FIG 121.SDR IXXA07SMN144SHook · crackedDURING ROUTINE C CHECK INSPECTION, FOUND EXTERIOR FUSELAGE AT NOSE SECTION FORWARD PAX DOOR HOLD OPEN HOOK, WAS CRACKED AT STATION 15.000 LONGERON 16 LEFT. REMOVED FASTENERS AS NEEDED TO PERFORM THE REPAIR. REMOVED DAMAGED AREA. PERFORMED INSPECTION NDT INSDR QXEA200700650Gate · unsecureLAX FLIGHT NR 2424: FUSELAGE DOORS MASTER WARNING LIGHT ILLUMINATED IN FLIGHT WITH A FWD BAGGAGE DOOR OPEN INDICATION ON MFD. PRESSURIZATION REMAINED STEADY. AIRCRAFT DIVERTED TO FAT. MAINTENANCE, UPON INITIAL INSPECTION, FOUND PRESSURIZATION FLAPPER DOOR NSDR TRAX200700550Door · stiffFWD PAX DOOR IS VERY DIFFICULT TO UNLATCH AND OPEN FROM THE OUTSIDE.SDR AWXA200700699Door Frame · crackedMCN - MAJOR REPAIR - R1 DOOR AFT FRAME CRACKED AT THE 3RD AND 4TH STOP. REPAIRED R1 DOOR AFT FRAME AT THE 3RD AND 4TH STOP IAW AWA ER 03-5200-07142-SS3.SDR 2007UALA01229Gate · damagedL-4 DOOR UPPER GATE CORRODED AND CRACKED. [SUP 05-04-07] REPLACED UPPER GATE.SDR AWXA200700745Skin · crackedMCN - MAJOR REPAIR - CRACKED R1 DOOR SKIN, BS 296, S14R, AT THE LOWER HINGE CUT OUT. REPAIRED R1 DOOR SKIN, BS 296, S14R, AT THE LOWER HINGE CUT OUT IAW AWA ER 03-5210-07159-ES1.SDR CPCP20070022Support · corrodedLT AFT PASSENGER DOOR THREAD SUPPORT 1(BOTTOM) IS CORRODED. NEW THREAD SUPPORT 1 (BOTTOM), INSTALLED IAW SRM 51-25-01.SDR CPCP20070023Support · corrodedLT AFT PASSENGER DOOR THREAD SUPPORT 5 IS CORRODED. NEW THREAD SUPPORT 5 INSTALLED IAW SRM 51-25-01.SDR TRAX200700577Step · crackedPAX DOOR TOP STEP AFT BASE RADIUS CRACKED (MARKED).SDR RAIA00704053Unknown · unknownPRE FLT NR 5488 - IAD- PAX DOOR WILL NOT OPEN AND APPEARS SLIGHTLY OPEN AND JAMMED. MAINTENANCE CYCLED DOOR HANDLE OPEN AND CLOSED MAIN DOOR FROM THE INSIDE AND OUTSIDE. INSPECTED DOOR ACTUATING AND LOCKING MECHANISM. NO FAULTS DETECTED.SDR TRAX200700540Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED. [5-1-07] CUTOUT DAMAGED SECTION OF PAX DOOR AFT DRAG ANGLE AS REQUIRED. FABRICATED SPLICE ANGLE, AND SPLICE DOUBLERS. COMPLIED WITH LPI OF PAX DOOR AFT GRAG ANGLE CUTLINES IAW REO 670-52-11-072. NO DEFECTS NOTED.SDR TRAX200700539Door · stiffCREW REPORTS PAX DOOR HARD TO OPEN.SDR 2007UALA01221Door Frame · crackedR-1 DOOR FWD FRAME AT LOWER HINGE CUTOUT IS CRACKED. [06-14-07] MAJOR REPAIR ACCOMPLISHED. REMOVED CRACK FROM LOWER HINGE BY CUTTING -238 FRAME TO MAKE A -131 AND -237 SECTIONS PER BOEING AND UA ENGINEERING SPECIFICATIONS. ALODINED AND PRIMED AND RSDR SWAA071905Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR LOWER FRAME CRACKED AT LOWER FWD CORNER. REMOVED AND REPLACED L1 DOOR PER MM.SDR COMA0760326Skin · corrodedDURING HMV7 INSP FOUND CORROSION ON LOWER SIDE OF INNER CABIN DOOR SKIN AT ACCESS 832EL. REPLACED INNER SKIN PER SRM 51-42-06, 51-42-20, 51-45-00, 52-10-31.SDR AWXA200700705Door Frame · crackedMCN - MAJOR REPAIR - CRACKED L1 DOOR AFT FRAME, BS 347, S9L - S12L AT THE 4TH, 5TH, 6TH AND 7TH STOP PIN CUT OUTS. REPAIRED L1 DOOR AFT FRAME, BS 347, S9L - S12L AT THE 4TH, 5TH, 6TH AND 7TH STOP PIN CUT OUTS IAW AWA ER 03-5210-07151-DH1.SDR SWIA200718288Bracket · crackedPAX DOOR HAS CRACKED BRACKET INSIDE ACCESS HOLE (832BR) ON AFT SIDE OF DOOR, DISCOVERED AT C-CHECK. INSTALLED NEW INTERCOSTAL P/N 601R-31902-3185 IAW CRJ200 SRM 51-42-06 PG 11.SDR SWIA200718287Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS ON AFT SIDE OF PAX DOOR PER REO 601R-52-11-513 REV A.SDR SWIA200718286Bracket · crackedPAX DOOR ASSIST MOTOR BRACKET IS CRACKED, DISCOVERED AT C-CHECK. INSTALLED PAX DOOR ASSIST MOTOR BRACKET PER SRM 51-42-06.SDR SWIA200718285Web · crackedPAX DOOR AFT WEB IS CRACKED IN THE RADIUS BETWEEN THE 3RD AND 4TH FIXED STEPS, DISCOVERD AT C-CHECK. INSTALLED ALL REPAIR PARTS ON AFT SIDE OF PAX DOOR PER REO 601R 52-11-702 REV 'A'.SDR SWIA200718284Web · crackedPAX DOOR - THE PAX DOOR FORWARD WEB IS CRACKED IN THE RADIUS BETWEEN THE 3RD AND 4TH FIXED STEPS, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS ON FORWARD WEB OF PAX DOOR PER REO 601R-52-11-1235.SDR AWXA200700514Fitting · wornSAL - R1 DOOR SUPPORT ARM UPPER FITTING BEARING ATTACHMENT HOLE WORN AND BEARING IS MIGRATING. REPLACED R1 DOOR SUPPORT ARM UPPER FITTING IAW A320 AMM 52-11-12.SDR RAIA00704051Door · lack of lubePOST FLT NR 5524-STL-PAX DOOR DIFFICULT TO OPEN. MAINTENANCE LUBED DOOR FRAME AND INSPECTED MAIN PAX DOOR .SDR 2007UALA01215Strap · looseDOOR 1R WILL NOT ARM. [06-14-07] FOUND "D" RING STRAP LOOSE, RESECURED. DOOR ARMING OPERATION PUT BACK TO NORMAL.SDR CA070427001Door · separated(CAN) AFTER TAKING OFF FROM AN OFFSHORE RIG AT 300 FT, 70 KNOTS, CREW HEARD A STRONG NOISE AND ONE OF THE PASSENGERS ADVISED THAT DOOR WAS MISSING. P/C NOTICED NO CAUTION LIGHTS. AC RETURNED TO THE RIG AND LANDED WITHOUT FURTHER INCIDENT. AC SUBSEQUENTLY RETURSDR SWIA200718423Rib · crackedPAX DOOR MID SECTION FORWARD INTERNAL RIB IS CRACKED. REPLACED PAX DOOR INTERNAL RIB IAW SRM 120 51-10-02 PG 3 SEC 3A.SDR SWIA200718422Rib · crackedPAX DOOR MID SECTION AFT INTERNAL RIB IS CRACKED, DISCOVERED AT C-CHECK. REPLACED PAX DOOR INTERNAL RIB IAW SRM 120 51-100-02 PG 3 SEC 3A.SDR SWIA200718420Torque Tube · corrodedPAX DOOR TORQUE TUBE AFT BEARING BOSS HAS CORROSION, DISCOVERED AT C-CHECK. REPLACED PAX DOOR TORQUE TUBE AFT BEARING BOSS IAW EMB 120 MM 52-11-05.SDR AWXA200700704Skin · crackedMCN - FOUND CRACKED L1 DOOR INNER SKIN, BS 347. REPAIRED L1 DOOR INNER SKIN, BS 347 IAW AWA ER 03-5210-07151-DH1.SDR SWIA200718293Roller · corrodedPASSENGER DOOR LATCH MECHANISM ROLLER IS CORRODED, DISCOVERED AT C-CHECK. REMOVED AND REPLACED ROLLER PER BOMBARDIER CMM 52-12-01.SDR SWIA200718292Web · crackedPAX DOOR FORWARD WEB IS CRACKED AT LOWER ATTACH POINT OF MIDDLE STEP, DISCOVERED AT C-CHECK. REPAIRED AREA IAW REO 670-52-11-104.SDR SWIA200718291Web · crackedPAX DOOR AFT WEB CRACKED AT MID-STEP, DISCOVERED AT C-CHECK. INSTALLED FABRICATED REPLACEMENT PARTS PER REO 670-52-11-258.
Back to JASC 5210