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 QXEA9901525Mechanism · lack of lubePDX - MAIN CABIN DOOR DIFFICULT TO OPEN. LUBRICATED MAIN CABIN DOOR MECHANISM. FLIGHT ATTENDANT OPERATED DOOR, NO EXCESSIVE EFFORT REQUIRED TO OPEN DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR CALA9900876Fitting · crackedINSPECTION FOUND A 1 CRACK IN L-1 DOOR LOWER HINGE FITTING. A NEW FITTING WAS INSTALLED IAW SRM 51-10-4.SDR VTZA990241Seal · out of adjustPVD/IAD - FLT 7531 - DURING TAKEOFF, AIRCRAFT MADE AN UNSCHEDULED LANDING DUE TO UNABLE TO PRESSURIZE AIRCRAFT. AIRCRAFT RETURNED TO GATE WITH NO FURTHER PROBLEMS. MAINTENANCE INSPECTED AND FOUND PASSENGER DOOR SEAL MIS-POSITIONED. MAINTENANCE RE-POSITIONEDSDR USAASB99182Hinge · failedBWI - FLT 2622 - DURING CLIMB-OUT FROM BWI, CREW REPORTED A LOUD UNBEARABLE SQUEAL COMING FROM THE MAIN ENTRY DOOR. FLIGHT RETURNED TO FIELD AT BWI AND LANDED WITHOUT FURTHER INCIDENT. NO EMERGENCY WAS DECLARED. MAINTENANCE REMOVED AND REPLACED THE MAIN ENTSDR MASA99134Cam Follower · jammedFLT 5772 - CLT-LIT - THE AIRCRAFT HAD A PASSENGER DOOR THAT WAS HARD TO OPEN. MAINTENANCE UNJAMMED A ROLLER ON THE PASSENGER DOOR. OPS CHECK GOOD. THE AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA992022Zee · corrodedSAW - DURING HMBV-1 INSPECTION, FOUND THE LEFT AFT PASSENGER DOOR ZEE MEMBER CORRODED BETWEEN FRAMES 39 AND 40. REMOVED AND REPLACED THE ZEE MEMBER IAW SRM 52-11-30. AIRCRAFT RETURNED TO SERVICE. (X)SDR DHL9970318CStructure · crackedAT C CHECK, FWD ENTRY DOOR INTERIOR FWD UPPER CORNER IS CRACKED. REMOVED INTERIOR FWD ENTRY DOOR PER SRM 51-30-2, FABRICATED NEW LINER SUPPORT FWD CORNER PER SRM 52-10-1 FIG 1 USED .050 2024-0 HEAT TREATED TO 2024T3 PER 99PMSI 247 PG-01. ALODINED AND PRIMED PSDR 99ZZZX2985Shield · damagedTHE RIGHT FORWARD CABIN DOOR POST SHIELD WAS FOUND BUCKLED. UPON REMOVAL, FOUND THE FRESH AIR HOSE RUNNING DOWN THE DOOR POST WAS NOT ALLOWING THE SHIELD TO SEAT FULLY IN ITS CORRECT POSITION. THE AIR VENT HOSE WAS FLATENED TO PROVIDE SUFFICIENT CLEARANCE FOSDR DL72S991636Strap · out of positionDOOR 2L SAFETY WAS REPORTED BY F/A TO BE FLAPPING AGAINST OUTSIDE OF A/C AFTER T/O. INSPECTED AREA, NO APPRECIABLE DAMAGE NOTED. INSPECTED INTAKE NR 1 ENG, A-OK. REPLACED DAMAGED STRAP.SDR DL75A991628Mechanism · out of adjustRIGHT FWD ENTRY DOOR HANDLE UNLOCKED AFTER T/O AND COULD NOT BE LOCKED. EICAS MSG R FWD ENT DOOR AND ENTRY DOOR LIGHT ON OVERHEAD PANEL CAME ON. ADJUSTED LOWER GATE AND STOP PINS PER MM.SDR ABXA9900578Pan · crackedDURING C-CHECK, FOUND LEFT FORWARD ENTRY DOOR PAN CRACKED. REPLACED DOOR PAN SEGMENT IAW DC9 SRM 51-30-2.SDR A6WA9900081Latch Mech · not latchedDEN - FLT 5558 - IN CLIMB EDI MSG. DOOR LATCH CAUTION. SHORTLY FOLLOWED BY EDI MSG DOOR LATCH WARNING. F/A CONFIRMED TOP TWO LATCHES NOT ALIGNED. PERFORMED OPS CHECK IAW MM, CHECKS GOOD. WILL PERFORM TEST FLIGHT. TEST FLIGHT SUCCESSFUL. (X)SDR COMA9960383Handle · out of adjustDOOR OUTER HANDLE WARNING AFTER TAKEOFF. ADJUSTED DOOR HANDLE SPRING TENSION.SDR COMA9960393Pin · shearedCREW REPORTED MAIN CABIN DOOR IS VERY HARD TO OPEN AND THAT DOOR HANDLE SEEMS TO GET STUCK WHEN PULLING UPWARD ON HANDLE. WHILE TROUBLESHOOTING THE DOOR HANDLE (P/N 600-31887-11 ITEM NR 5 PAGE 1 FIG 1 RJ IPC CH 52-11-02) FOUND THE PIN (HSP 115BO94-900 ITEM NRSDR MALA976516Handle · not latchedLEFT FORWARD CABIN DOOR KEPT DISARMING IN FLIGHT. AIRCRAFT RETURNED TO MSP. MAINTENANCE UPON ARRIVING TO AIRCRAFT FOUND OUTSIDE DOOR HANDLE NOT RECESSED COMPLETELY OUT OF AIRSTREAM. PUSHED HANDLE BACK INTO DOOR RECESS, OPS CHECK GOOD.SDR 99ZZZX3151Mechanism · out of adjustKMEM/KMIA - FAE FLT 114 - AFTER TAKEOFF, UNABLE TO PRESSURIZE CABIN. PURSER ADVISED EXTREMELY LOUD NOISE FROM FORWARD ENTRY DOOR. RETURNED TO KMEM, UNEVENTFUL LANDING. ON THE GROUND, REMOVED LINING. ADJUSTED FORWARD ENTRY DOOR UPPER CONTROL ROD ASSEMBLY RISDR COMA9960359Handle · not latchedDOOR UNLOCKED WARNING AFTER TAKEOFF. FOUND DOOR HANDLE UNLATCHED. INSPECTED LATCH MECHANISM AND FOUND NO DEFECTS.SDR SWIA971514Seal · failedAFTER DEPARTURE AIRCRAFT MAIN DOOR HAD LOUD SQUEAL AND AIRCRAFT WOULD NOT PRESSURIZE. RETURNED TO SLC. REMOVED AND REPLACED CABIN DOOR SEAL IAW SB 601R-52-067. PRESSURIZED AIRCRAFT AND ALL CHECKS GOOD.SDR MWEA99383Skin · crackedFORWARD ENTRANCE DOOR SKIN AROUND HOLD OPEN HOOK IS CRACKED AND HAS SCRATCHED SKIN WHERE HOOK ENGAGES. MTC FABRICATED AND INSTALLED DOUBLER REPAIR.SDR HEEA062740Panel · crackedDOOR CRACKED. REFERENCE: DMR NR 686169.SDR HEEA062739Panel · crackedDOOR CRACKED. REFERENCE: DMR NR 686168.SDR TWAA9910103Skin · bentTHE LT FWD PASSENGER ENTRY DOOR, FORWARD LOWER EDGE OF THE OUTER SKIN, WAS BENT IN 4 INCHES WIDE BY 1 INCH HIGH AND 0.25 IN DEEP. REPAIRED PER SRM 52-03, PAGE 1 ITEM 1 PARAGRAPH A.SDR TWAA9909706Gust Lock · damagedDURING CHECK-C MAINT, FOUND THE FWD LEFT CABIN DOOR GUST LOCK DAMAGED. TRIMMED OUT EDGE DAMAGE, CHECKED FASTENERS AND EDGE MARGINS, AND TREATED. REPAIRED PER SRM 53-04, FIG 24.SDR COMA9960347Door · not securedMAIN CABIN DOOR AIR LEAK IN AREA OF GROUND STRAP. SECURED THE DOOR ELECTRICAL BONDING STRAP. PRESSURIZED AIRCRAFT. NO LEAKS FOUND.SDR ASAA9980150Liner · loosePDX - FLT 601 - AFTER ARRIVAL, CREW REPORTED THE L1 DOOR WAS DIFFICULT TO OPEN. FOUND DOOR INTERIOR LINER LOOSE AND CATCHING ON FORWARD FLIGHT ATTENDANT JUMP SEAT. INSTALLED MISSING FASTENER IN DOOR LINER AND OPERATED NORMALLY. (X)SDR MASA99113Strut · misalignedRDU/BOS - FLT 5215 - THE CAPTAIN REPORTED DAMAGE TO CABIN DOOR INNER SKIN, DUE TO MISALIGNED STRUT. MAINTENANCE WAS ABLE TO SECURE DOOR CLOSED AND THE AIRCRAFT FERRIED TO BHM WHERE A PERMANENT REPAIR WAS PERFORMED. OPS CHECK GOOD. THE AIRCRAFT WAS RETURNED SDR MASA99112Mechanism · lack of lubePHL/MKE - FLT 5809 - THE CAPTAIN REPORTED A STICKY AIRSTAIR DOOR. MAINTENANCE WAS SENT TO INVESTIGATE AND REPORTED NO DISCREPANCIES, LUBED THE DOOR. FUNCTION CHECKS GOOD. THE AIRCRAFT WAS RETURNED TO SERVICE. (X)SDR A6WA9900079Latch · out of adjustDEN - FLT 5618 - PASSENGER DOOR LATCH CAS MESSAGE. PERFORMED PASSENGER DOOR FUNCTIONAL TEST. MOVED AFT UPPER LATCH DOWN ONE SERRATION. DOOR OPS CHECK GOOD. (X)SDR 99ZZZX2705Frame · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON R01 DOOR FRAME.SDR MWEA99371Fitting · crackedFORWARD PASSENGER DOOR LOWER HINGE FITTING IS CRACKED. MTC FABRICATED AND INSTALLED BRACKET AND REMOVED AND REPLACED FITTING.SDR HEED064573Door · mismarkedDOOR ASSY RETURNED. REASON, MISMARKED. DOOR IS A -102 RIGHT WITH -101A LEFT NUMBER STAMPED ON IT. ORDERED REPLACEMENT.SDR USAA069955Housing · crackedFORWARD ENTRY DOOR HANDLE MECHANISM HOUSING HAS BROKEN ACCESS HOLE EDGES WHERE PUSH ROD PASSES THROUGH CASTING TO TORQUE TUBE. ACCOMPLISHED FORWARD ENTRY DOOR MECHANISM HOUSING REPAIR IAW AVITAS ENGINEERING DRAWING 99AVHM.029D-1. (M)SDR CALA9900714Beam · crackedINSPECTION FOUND A .5 INCH CRACK IN AT AFT END OF MAIN CABIN DOOR NR 7 BEAM. REPAIRED IAW SRM 52-05, FIGURE 31, SHEET 12.SDR COMA9960304Striker · damagedPAX DOOR SEAL STRIKER DAMAGED AT FS 310.00, LOWER PART OF PAX DOOR OPENING. REPAIRED IN ACCORDANCE WITH REO CRJ601R-52-11-008 REPAIR A.SDR COMA9960301Striker · damaedPAX DOOR SEAL STRIKER DAMAGED AT FS 310, LOWER PART OF OPENING. REPAIRED PAX DOOR SEAL STRIKER IN ACCORDANCE WITH REO 601-52-11-008 REPAIR A.SDR MWEA99352Skin · gougedPASSENGER AIRSTAIR COMPARTMENT DOOR HAS A DEEP GOUGE AT UPPER AFT AREA. MAINTENANCE FABRICATED AND INSTLLED NEW SKIN.SDR F3LA99085Fitting · crackedDEN - DURING C-4 CHECK INSPECTION, REPORTED LEFT UPPER FORWARD STOP FITTING ON AFT AIRSTAIR DOOR CRACKED. MAINTENANCE INSTALLED REPLACEMENT FITTING PER SRM 51-30-2. (M)SDR CALA9900705Skin · crackedINSPECTION FOUND A .5 CRACK IN L-1 DOOR EXTERIOR SKIN AT FORWARD LOWER CORNER. A REPAIR WAS INSTALLED IAW SRM 52-03-00, FIGURE 37, 51-10-3, AND 51-30-2.SDR RAIA990621Lever · failedFLT 7364 - STL - PAX DOOR LIGHT ILLUMINATED. MAINTENANCE REPLACED PAX DOOR LOCK CAM LEVER. (M)SDR VTZA990163Door · not stowedIAD/CRW - FLT 7745 - DURING CRUISE, AIRCRAFT MADE AN UNSCHEDULED LANDING DUE TO PASSENGER DOOR WARNING LIGHT ILLUMINATED. AIRCRAFT WENT TO GATE WITH NO FURTHER PROBLEMS. MAINTENANCE INSPECTED AND RESTORED DOOR HANDLE. OPS CHECK OK. AIRCRAFT RELEASED AND APSDR DL72S991371Skin · crackedREF NRC 53 TPA LETTER CHECK C-1, .5 INCH CRACK IN R-1 DOOR SKIN AT LWR AFT CORNER. INSTALLED DOUBLER PER M/M 52-11-01, NR 8.SDR 9902659975Pax Door · crackedDURING PERIODIC CHECK, FOUND .375 INCH CRACK AT UPPER FORWARD CORNER OF PASSENGER DOOR JAMB, FS 160. REPAIRED PER EA 99-164408. (P/N 5911406-5).SDR CA990719017Torque Tube · out of rig(CAN) DOOR WARNING LIGHT ON IN-FLIGHT. TORQUE TUBE UPPER LATCH CAMS FOUND OUT OF RIG.SDR RRXA991693Doubler · corrodedDURING FOUND CORROSION DAMAGE TO L-1 DOOR WINDOW EXTERNAL DOUBLER AT Y=160 LT. DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGED DOUBLER, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW DOUBLER IAW DC-8 SRM 51-1-20.SDR COMA9960282Striker · damagedPASSENGER DOOR SEAL STRIKER AT FS 310 DAMAGED. REPAIRED IN ACCORDANCE CRJ REO 601R-52-11-008 ISSUE B REPAIR A.SDR COMA9960281Striker · damagedPASSENGER DOOR SEAL STRIKER AT FS 310.349 DAMAGED. REPAIRED IN ACCORDANCE WITH CRJ REV 601R-52-11-008 ISSUE B REPAIR A.SDR 99FDEA00212Mechanism · unlatched99-130 - RIGHT PASSENGER DOOR OPEN ECAM AND SHIME SOUNDED. CHECK DOOR PER AMM 52-10-20-5 ALL LATCHES OPER NORM. SUSPECT DOOR WAS NOT LATCHED ALL THE WAY. A/C OK FOR SERVICE.SDR C2XA99IA308Stair · crackedIAH - DURING C-CHECK INSPECTION, THE PASSENGER DOOR STAIR ASSEMBLY WAS FOUND TO BE CRACKED IN SEVERAL PLACES. MAINTENANCE STOP DRILLED THE CRACKS AND INSTALLED REPAIR DOUBLERS IAW ATR42-320 SRM 52-11-00, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (SDR C2XA99IA307Pan · crackedIAH - DURING C-CHECK INSPECTION, THE PASSENGER DOOR PAN WAS FOUND TO BE CRACKED. MAINTENANCE STOP DRILLED THE CRACK AND INSTALLED A REPAIR DOUBLER IAW ATR42-320 SRM 52-11-00, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR QXEA9901269Cable · out of adjPDX- MAIN CABIN DOOR WILL NOT WORK IN EMERGENCY MODE. CLEANED AND LUBED DOOR BACK-UP PINS AND EMERGENCY RELEASE CABLE. RERIGGED EMERGENCY CLUTCH RELEASE CABLE IAW MM 52-10-05. DOOR OPERATES NORMAL.
Back to JASC 5210