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 TRAX200700432Skin · crackedCRACK FOUND ON PAX DOOR INNER SKIN AT FS 329.50 NEAR HANDLE PIVOT SHAFT.SDR 07FDEA01148Shroud · crackedLT AFT SERVICE DOOR FWD UPPER END SHROUD HAS CRACKS 2 PLACES APPROX 8 IN AND 6 IN FROM FWD UPPER CORNER. CONTAINED CRACK IN SHROUD BY STOP DRILLING IAW SRM 51-10-1 PARA 10. TREATED AND PRIMED AREA IAW SRM 51-10-1. RESEALED AREA IAW DWG 65-56992 AND MM 51-3SDR 2007UALA00902Door · openRTFL DUE TO DOOR 1R PRESSURE INDICATION. [SUP 4-24-07] ON ARRIVAL FOUND DOOR OPEN APPROX 6 IN & EXTERIOR HANDLE FULLY DEPLOYED. ACCOMPLISHED DOOR OP CHECK. ARMED AND DISARMED PER 52-11-00-0601. ALL OPERATIONS NORMAL. SUSPECT DOOR WAS NOT CLOSED AND ARMED SDR COMA0760290Flapper Valve · obstructedFLIGHT 5244 - RECEIVED PAX DOOR CAUTION AND CABIN PRESSURE INCREASE ON CLIMBOUT. PERFORMED QRH. RETURNED TO PIT AND LANDED WITHOUT INCIDENT. CLEARED FOD FROM PAX DOOR FLAPPER VALVE. INSPECTED DOOR. NO FURTHER DEFECTS.SDR SWIA200718425Rib · crackedPAX DOOR TORQUE TUBE FORWARD ATTACH RIB IS CRACKED, DISCOVERED AT C-CHECK. REPLACED CRACKED RIB PER SRM 51-40-02.SDR AALA20070552Bottle · low pressureMIA - EMERGENCY ASSIST BOTTLE AT RIGHT NUMBER TWO DOOR HAS LOW PRESSURE. SERVICED EMERGENCY ASSIST BOTTLE AT RIGHT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070550Bottle · low pressureMIA - EMERGENCY ASSIST BOTTLE AT LEFT NUMBER ONE DOOR HAS LOW PRESSURE. SERVICED EMERGENCY ASSIST BOTTLE AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070551Bottle · low pressureMIA - EMERGENCY ASSIST BOTTLE AT RIGHT NUMBER FOUR DOOR HAS LOW PRESSURE. SERVICED EMERGENCY ASSIST BOTTLE AT RIGHT NUMBER FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR FDKA200703133Handle · unknownFDM RON CAE. MAIN CABIN DOOR WILL NOT OPEN. MX REINSTALLED THE DOOR HANDLE AND OPS CHECKED.SDR QXEA200700453Door · unknownSMF FLIGHT NR 2430: FLIGHT ATTENDANT REPORTS THAT THE AFT PASSENGER DOOR IS DIFFICULT TO OPEN. MAINTENANCE CLEANED AND INSPECTED SEAL. NO DEFECTS NOTED. C/W Q400 AMM TASK 52-12-00-710-802. NO DEFECTS NOTED. NO PARTS REPLACED. AIRCRAFT RETURNED TO SERVICESDR DLM90070266Skin · bentFOUND L1 DOOR LOWER AFT CORNER SKIN IS BENT. REPAIR PER SRM 52-10-01 AT HMV2 REF N/R 8000-0003.SDR AALA20070547Bottle · low pressureMIA - EMERGENCY BOTTLE AT RIGHT NUMBER ONE DOOR HAS LOW PRESSURE. SERVICED EMERGENCY BOTTLE AT RIGHT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AMTA200700171Switch · shortedR-2 DOOR WILL NOT OPEN ELECTRICALLY. FOUND R2 CLOSE SWITCH SHORTED INTERNALLY. REPLACED SWITCH IAW CH 20 STANDARD PRACTICE OPS CHECK GOOD. (K)SDR SWIA200718452Frame · crackedPAX DOOR IS CRACKED AT FRAME NR 3 DISCOVERED AT C-CHECK. DOUBLER INSTALLED IAW SRM 120 52-10-02.SDR SWIA200718451Bracket · crackedPAX DOOR IS CRACKED AT AFT LOWER CORNER, DISCOVERED AT C-CHECK. REPLACED CRACKED BRACKET ON PAX DOOR AFT LOWER CORNER IAW EMB 120 SRM 51-10-02 AND 51-40-02.SDR SWIA200718450Frame · crackedPAX DOOR IS CRACKED AT FRAME 5 ON THE AFT SIDE, DISCOVERED AT C-CHECK. NEW FRAME INSTALLED IAW SRM 120 51-10-02 PG 3, SEC 3 A.SDR SWIA200718429Boss · crackedPAX DOOR HAS CRACKED LOCKING MECHANISM BOSS BETWEEN FRAMES 4 AND 5, DISCOVERED AT C-CHECK. REPLACED LOCKING MECHANISM BOSS IAW 52-11-03.SDR SWIA200718428Attach Fitting · corrodedPAX DOOR FORWARD AND AFT CAM LINK ATTACH HARDWARE IS CORRODED, DISCOVERED AT C-CHECK. REPLACED HARDWARE AT PAX DOOR CAM LINKS AND BUSHINGS IAW 52-11-03.SDR DU4R2007075Rod End · corrodedFOUND CORROSION ON R1 DOOR INTERNAL UPPER END CENTER CONTROL ROD WITH RUSTED ROD END. REPAIRED BY REMOVING AND REPLACING ROD END WITH P/N 10-60779-8A IAW BOEING CMM 52-11-05.SDR DU4R2007076Rod · corrodedFOUND CORROSION ON R-1 DOOR LOWER GATE GIRT BAR CRANK PUSH ROD. REPAIRED BY REMOVING CORRODED ROD, ADJUSTED AND INSTALLED NEW ROD P/N 140N2751-4 ON GIRT BAR MECHANISM IAW CMM 52-11-05. SDR 07FDEA01105Gusset · corrodedFUSELAGE NOSE SECTION-CORROSION ON FWD PAX DOOR FRAME AREA, RT LOWER CORNER, GUSSET A536-11517-205 REPAIR PERFORMED BY REPLACEMENT OF GUSSET AND REWORK IAW EA 6-5312-106395 AND RAS/AS/010/2007 ISS.BSDR SWIA200718178Mount · crackedCRACK AT PAX DOOR ASSIST MOTOR MOUNT STRUCTURE AFT RADIUS, DISCOVERED AT C-CHECK. INSTALLED NEW STIFFENER P/N 601R 317745-7 P/O 27867 PER CRJ200 SRM 51-42-06 PG 4 AND 18.SDR SWIA200718177Angle · crackedCRACK AT PAX DOOR STRUCTURE ANGLE INSIDE 832AR CUT OUT, DISCOVERED AT C-CHECK. INSTALLED NEW DOUBLER ANGLE P/N 601R-318094-2 AS PER CRJ200 SRM 51-42-06 PG 5-19 AND CRJ200 SRM 51-42-21 PG 15-19.SDR SWIA200718176Web · crackedPAX DOOR FWD WEB CRACKED AT STEPS 3 AND 4, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLES, SHIM AND DOUBLER PER CRJ200 REO 601R-52-11-702 REV A.SDR 2007UALA00868Chain · misroutedMED 1LH HARNESS LATCH CHAIN MISROUTED OVER HARNESS FITTING. [06-14-07] ACCOMP'D ROUTINE JC'S TO RESTORE DOOR AND SLIDE TO NORMAL SAFE CONDITION. REROUTED CHAIN TO CORRECT POSITION.SDR 07FDEA01102Door · leakingAPPEARED TO LOOSE PRESSURIZATION PASSING 12,000' LEVELED AT 14,000' CABIN AT 9500, DESCENDED TO 10,000 AND WAS UNABLE TO GET PRESSURE IN CABIN BELOW 8,000. HEARD LOUD AIR NOISE, CHECKED MAIN CABIN DOOR, FOUND AIR LEAKING AROUND DOOR. RETURNED TO MEM. ADJUSSDR 2007FA0000261Seal · mismanufacturedWHILE INSTALLING THIS FACTORY NEW SEAL IT WAS NOTED THAT THE SEAL WAS VERY TIGHT GOING AROUND THE DOOR. UPON CABIN PRESS TEST THE SEAL WILL NOT INFLATE DUE TO BEING TO TIGHT. (2) SEAL FROM STOCK WERE TRIED WITH THE SAME AFFECT. THE LAST SEAL WAS INSTALLED ANDSDR K11A2008112572404Web · crackedVERTICAL WEB FWD OF AIRSTAIRS HAS 6 INCH CRACK IN WEB.SDR EIA2007064Skin · crackedR1 DOOR OUTER SKIN CRACKED AT AFT LOWER CORNER. CUTOUT DAMAGED AREA, FABBED AND INSTALLED DOUBLER AND FILLER PER B747 SRM 52-00-03 FIG 4 PAGES 5-6C AND 51-30-02 PAGES 8-9.SDR SWAA071491Skin · crackedDURING SCHEDULED C2 CHECK, FOUND R1 DOOR SKIN CRACKED AT LOWER DOOR HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR MASA200700153Cam · out of adjustASH 2730 DSM - PAX DOOR WILL NOT OPEN. MX ADJUSTED FWD AND AFT SPIGOTS AND CLEARANCE CAMS.SDR TRAX200700416Handle · crackedASD INNER HANDLE CRACKED AT SHAFT CONNECTION (LOCATION MARKED). REMOVED AND REPLACED ASD INNER HANDLE IAW AMM 52-11-02.SDR TRAX200700415Handle · crackedASD DOOR HANDLE CRACKED.SDR QXEA200700404Seal · leakingBOI - ON FLIGHT 2343, IN LEVEL FLIGHT AT 220 NR 2 AFT CABIN DOOR SEAL STARTED LEAKING PER FA, VERY LOUD NOISE DOOR LOWER FORWARD PORTION AT THE DOOR. MAINTENANCE REMOVED AND REPLACED CARGO DOOR SEAL. PRESSURIZED AIRCRAFT, NO LEAKS OR SQUEALS NOTED. AIRCRAFTSDR 07FDEA01007Skin · corrodedFOUND CORROSION ON RT FWD PASSENGER DOOR ARM ASSEMBLY. REPAIR PERFORMED BY BLEND OUT WITH DOUBLER INSTALLATION AND REPLACEMENT OF CORRODED PARTS IAW EA 6-5211-101326 AND IS APPROVED BY RAS 045586/005/2006.SDR AWXA200700456Cover · wornSAL - R2 DOOR AFT UPPER AFT CORNER INTERNAL COVER PLATE WORN. REPLACED R2 DOOR AFT UPPER AFT CORNER INTERNAL COVER PLATE IAW A320 SRM 51-72-11.SDR AWXA200700455Cover · wornSAL - L2 DOOR FORWARD UPPER AFT CORNER INTERNAL COVER PLATE WORN. REPLACED L2 DOOR FORWARD UPPER AFT CORNER INTERNAL COVER PLATE IAW A320 SRM 51-72-11.SDR FDKA200703127Roller · lack of lubeFDM 6126 ATL-CAK (0904 PHX LCL). PAX DOOR WILL NOT SHUT. MX CHECKED ALIGNMENT OF DOOR AND LUBED DOOR ROLLERS, OPS CHECK GOOD.SDR 2007UALA00822Frame · inadequateDOOR 2R FWD FRAME IS INADEQUATE. MAJOR REPAIR ACCOMPLISHED: INSTALLED FWD FRAME STEEL DOUBLER.SDR TRAX200700409Door · inoperativePAX DOOR WOULD NOT OPEN.SDR TRAX200700382Handle · crackedPAX DOOR HANDLE IS CRACKED. PAX DOOR STEP NR 2 REMOVED IAW AMM 20-21-00. HANDLE REMOVED IAW AMM 52-11-03. HANDLE INSTALLED IAW AMM 52-11-03. PAX DOOR STEP NR 2 INSTALLED IAW AMM 20-21-00. PAX DOOR FUNCTIONAL TEST C/OUT IAW AMM 52-11-03. PAX DOOR OPS TEST SDR 2007UALA00830Door · obstructedFLT ATTENDANT REPORTED UNABLE TO ARM DOOR 4L. *S/D* REMOVED FOREIGN OBJECT OPERATES NORMAL. AIRCRAFT RETURNED TO SERVICE. SUSPECT FOREIGN OBJECT WAS PIECE OF CABIN SERVICE MATERIAL.SDR 07FDEA00930Shaft · chafedOLD CHAFING MARK ON PAX DOOR NR 1 RT AT LOCKING CONTROL SHAFT. REPAIR WAS PERFORMED BY BLEND OUT IAW LHT SDR.SDR SWIA200718215Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED NEAR DOOR ASSIST MOTOR CABLE PULLEY, DISCOVERED AT C-CHECK. REPLACED PARTS FOR PAX DOOR AFT DRAG ANGLE IAW REO 670-52-11-072.SDR SWIA200718214Web · crackedPAX DOOR AFT WEB CRACKED AT SECOND STEP, DISCOVERED AT C-CHECK. REPLACED REPAIR ANGLES AND INTERNAL REPAIR DOUBLER PER REO 670-52-11-104.SDR SWIA200718213Web · crackedPAX DOOR FORWARD WEB CRACKED AT SECOND STEP, DISCOVERED AT C-CHECK. REPLACED REPAIR ANGLES AND EXTERNAL DOUBLER PER REO 670-52-11-104.SDR A6WA200740158Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED AT PAX DOOR ASST PULLEY BRACKET. (K) [SUP 06-05-07] CUTOUT DAMAGED SECTION AND REPAIRED IAW BOMBARDIER REO 601R-52-11-513 REV A AND BSC EO 601R-52-11280. (M)SDR FDKA200703123Door · out of rigFDM 6017 MCO-BNA (2209 PHX LCL). MAIN CABIN DOOR HARD TO OPEN. MX RE-RIGGED DOOR.SDR ASAA0741532Plate · wrong partFLIGHT ATTENDANT REPORTED L1 DOOR HARD TO OPEN FOUND INCORRECT BEARING PLATE INSTALLED WHICH APPEARED TO BE CATCHING ON DOOR DURING LAST 1 INCH OF DOOR CLOSING. AFTER REPLACING PLATE FOUND THE UPPER TORQUE ROD CONTROL LEVER ROLLER NOT ENGAGING CAM AT DOOR HANSDR 07FDEA00910Door · unsecureAFTER TAKEOFF IN IAD CABIN ALTITUDE WENT ABOVE 10,00 0' RAN QRH PROCEDURES CABIN ALTITUDE WENT TO 11,500' WENT ON O2 RETURNED TO IAD. NOTICE FORWARD ENTRY DOOR WAS NOT SEATED PROPERLY OPEN AND SECURED DOOR SEVERAL TIMES, PERFORMED FORWARD ENTRY DOOR INSPECT
Back to JASC 5210