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 ASOA2014082711138Cap · dentedDENT DISCOVERED ON BOTH LOWER END CAPS OF PAX DOOR. REPAIRED IAW REO 670-52-11-159.SDR SIMA20140803001Roller · lack of lubePASSENGER MAIN ENTRY DOOR DIFFICULT TO OPEN & CLOSE. LUBRICATED MAIN DOOR ROLLERS. OPERATIONS CHECKED GOOD IAW AMM 52-10-01.SDR USAA2014080400002Damper · low pressureDOOR 1LT SHOWS CHECK PRESS ON FLIGHT ATTENDANT PANEL. ACCOMPLISHED TASK DISCHARGING & CHARGING OF THE DOOR DAMPER & EMER OPERATION CYLINDER.SDR 29GA2014080600001Door · lack of lubeMAIN DOOR HARD TO OPEN AND CLOSE. CLEANED AND LUBED MAIN DOOR, OPS CHECKED GOOD.SDR USAA2014080400016Bearing · lack of lubeTHE L1 DOOR UPPER BEARING CREAKING & DOOR IS HARD TO SWING. CLEANED & LUBRICATED L1 DOOR HINGE BEARINGS. NO DEFECTS NOTED AT THIS TIME. OK FOR SERVICE.SDR R61A201408020950Guide Stop · failedCREW REPORTED THAT THE MAIN CABIN DOOR WOULD NOT OPEN. MAINTENANCE TROUBLESHOT AND FOUND A BAD GUIDE STOP AND CAP. MAINTENANCE R & R GUIDE STOP AND CAP IAW AMM AND OPS CHECKED GOOD.SDR A6WA201441841Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED JUST ABOVE PULLEY.SDR SWIA201438947Door · lack of lubeF/A REPORTS MAIN CABIN DOOR DIFFICULT TO OPEN. CLEANED AND LUBED MAIN CABIN DOOR IAW AMM. OPS CHECK GOOD AT THIS TIME.SDR SIMA20140801006Actuator · dirtyMAIN CABIN DOOR DIFFICULT TO OPERATE. CLEAN & LUBE DOOR ACTUATOR ASSEMBLY ON MAIN DOOR. OPERATIONS CHECKED GOOD IAW AMM 52-18-00-600-801A.SDR GTIA2014080101394Bottle · low pressureL1 DOOR ASSIST BOTTLE HAS LOW PRESSURE. SERVICED L1 DOOR ASSIST BOTTLE IAW 52-10-00.SDR ASOA2014081511087Riser · crackedDISCOVERED FWD RISER CRACKED AT BOTTOM PAX DOOR STEP. REPAIRED IAW EA 32-2014-043.SDR QXEA2014073100648Strut · lack of lubeF/A REPORTS MAIN CABIN DOOR IS STICKING ABOUT .2500 TO .5 OF THE WAY DOWN, AFTER OPENING AND NEEDS ADDITIONAL FORCE TO OPEN. CLEANED & LUBED UPPER & LOWER STRUTS OPS CHECKED GOOD MCD OPERATES AS REQUIRED IAW AMM 52-11-00-710-802. RETURNED TO SERVICE.SDR USAA2014080100002Cylinder · low pressureTHE L2 PAX CREW DOOR CYLINDER BOTTLE NEEDS CHARGED. SERVICED L2 PAX CREW DOOR CYLINDER IAW AMM TASK 52-10-00-614-001.SDR SWIA201439093Skin · corrodedPAX DOOR CORRODED AROUND NUT PLATES ON DOOR SKIN FOR ACCESS PANEL 832BL. C-CHECK, REMOVED NUTPLATES AND BLENDED OUT CORROSION AND INSTALLED REPAIR DOUBLER TO DOOR SKIN IAW REO.SDR SWIA201439092Skin · corrodedPAX DOOR CORRODED AROUND NUT PLATES ON DOOR SKIN FOR ACCESS PANEL 832DL. C-CHECK, REMOVED NUTPLATES AND BLENDED CORROSION AND CUT OUT CRACKED AREA AND INSTALLED REPAIR DOUBLER TO DOOR SKIN IAW REO.SDR SWIA201439091Skin · dentedPAX DOOR INNER SKIN UPPER FWD CORNER HAS A DENT AND FASTENER HEAD IS WORN. C-CHECK, REPAIRED IAW REO.SDR SWIA201439090Skin · dentedPAX DOOR INNER SKIN UPPER AFT CORNER HAS A DENT AND FASTENER HEAD IS WORN. C-CHECK, REPLACED PASSENGER DOOR INNER SKIN UPPER AFT CORNER COVER IAW SRM AND REO.SDR SWIA201439089Skin · gougedPAX DOOR INNER VERTICAL SKIN FWD SIDE IS GOUGED JUST ABOVE FWD DOOR PULL IN LEVER. C-CHECK, BLENDED OUT GOUGE IAW EA.SDR QXEA2014073000646Roller · damagedAFT PASSENGER DOOR UNLOCK MECHANISM IS STIFF TO OPERATE. REPLACED AFT CAM ROLLER AND ROLLER TRACK. DOOR OPS CHECKED GOOD. RETURNED TO SERVICE.SDR DXTA2014073105840Bolt · brokenMAIN EXIT DOOR WILL NOT OPEN FROM INSIDE THE ACFT. RED HANDLE WILL ROTATE UP HALF WAY BEFORE IT BINDS. R & R BROKEN BOLT THAT CAME LOOSE & INSPECTED MAIN DOOR LOCKING & ACTUATING MECHANISM. OPS CHECKE GOOD. ALL WORK DONE IAW AMM 20-10-01.SDR N6WA20140730002Cover · unsecureEMERGENCY ESCAPE COVER, PAX DOOR, NEEDS TO BE SECURED. SECURED EMER ESCAPE COVER IAW AMM 51-22-61.SDR REXA2014072900795Drag Angle · crackedPASSENGER DOOR HAS A CRACK IN THE DRAG ANGLES AT PREVIOUS REPAIR. REMOVED REPAIR ANGLE IAW SRM 51-42-10-001-001-A01. INSTALLED NEW REPAIR ANGLE ON PAX DOOR AFT DRAG ANGLE IAW SRM 52-11-04-201-002-A01.SDR GTIA2014072901391Bottle · low pressureL1 DOOR ASSIST BOTTLE HAS LOW PRESSURE. SERVICED L1 DOOR ASSIST BOTTLE IAW AMM 52-10-00.SDR 29GA2014080100001Latch · out of adjustCABIN DOOR 208 WILL NOT LATCH CLOSED. CLEANED AND ADJUSTED LATCH, OPS CHECKED GOOD.SDR A6WA201441822Panel · crackedCOMPLIED WITH AWAC CARD 4DMI17146 REPAIR PAX DOOR AFT SIDE PNL 601R-52-11-2178.SDR USAA2014073000007Bottle · low pressureR1 DOOR ASSIST BOTTLE NEEDS SERVICING. SERVICED NITROGEN PRESS ON R1 DOOR ASSIST BOTTLE AS REQUIRED.SDR USAA2014073000006Bottle · low pressureDURING DAILY CHECK FOUND 3L ASSIST BOTTLE REQUIRING SERVICING. SERVICED 3L ASSIST BOTTLE.SDR USAA2014073000001Bottle · low pressureDURING DAILY CHECK FOUND FOLLOW DOOR 2L ASSIST BOTTLE REQUIRING SERVICING. NO FAP OR CIDS MSG. SERVICED 2L ASSIST BOTTLE.SDR MASA2014072902277Handle · bindingPAX DOOR INTERIOR HANDLE DIFFICULT TO OPERATE. TROUBLESHOOTING.SDR SWIA201439041Lever · chafedPAX DOOR FWD PULL-IN LEVER CHAFED ON RADIUS. PAX DOOR FWD PULL-IN LEVER CHAFE BLENDED WITHIN LIMITS IAW REO AND AMM.SDR SWIA201438895Cable · failedPASSENGER DOOR OUTER HANDLE CAUTION MESSAGE, THEN PASSENGER DOOR WARNING MESSAGE. R & R ICE BREAKER CABLE IAW AMM.SDR RAIA201407280001Door · lack of lubeDURING POST FLIGHT, THE MAIN PASSENGER DOOR IS HARD TO OPEN. MAINTENANCE LUBRICATED PASSENGER DOOR AND OPS CHECK GOOD.SDR USAA2014072900005Arming Lever · loose2R ARMING LEVER LOOSE. SECURED 2R ARMING LEVER.SDR SWAA2014082931432Liner · crackedL2 DOOR LINER CRACKED IN SEVERAL PLACES. REPAIRED LINER IAW EA.SDR UHLA2014072700520Door · obstructedMAIN CABIN DOOR WON'T LOCK IN THE OPEN POSITION. FOUND L1 DOOR TRIM COMPONENTS TO BE INTACT IAW AMM 25-23-04, AND L1 DOOR OPENS AND LOCKS IN PLACE AS NORMAL IAW AMM 52-11-00.SDR A6WA201441819Mount Bracket · crackedPAX DOOR ASSIST MOTOR MOUNT BRACKET CRACKED.SDR SWIA201438898Door · bindingUNABLE TO OPEN MAIN CABIN DOOR FROM INSIDE. OPENED DOOR AFTER CYCLING OUTER HANDLE SEVERAL TIMES. OPS NORMAL IAW AMM.SDR N6WA20140727001Door Seal · defectivePAX DOOR SQUEALS ON CLIMB. R & R PAX DOOR SEAL IAW AMM 52-11-07. LEAK CHECKED GOOD AT THIS TIME.SDR USAA2014072800020Mechanism · lack of lubeTHE GUST LOCK AT DOOR 1L BROKEN. IDENTIFIED GUST LOCK LINKAGE ON 1L DOOR, LUBED MECHANISM. OPERATIONS CHECKED GOOD.SDR SIMA20140727003Cable · detachedFLIGHT ATTENDANT REPORTS MAIN CABIN DOOR OPENED VERY ROUGH, NO SPRING ASSIST & HIT THE GND HARD. PERFORMED GVI OF OUTSIDE OF DOOR & FOUND NO DAMAGE. REATTACHED MOTOR ASSIST CABLE TO PULLEY IAW SMP. DOOR OPENS & CLOSES NORMALLY IAW MM 52-11-00.SDR SWIA201439141Skin · chafedPAX DOOR IS CHAFED ON OUTER SKIN NEAR HANDLE. REPAIRED PAX DOOR SKIN IAW EA.SDR N6WA20140726002Unknown · malfunctionedPAX DOOR SLAMS DOWN ON OPENING. INSPECTED DOOR & FOUND NO DAMAGE IAW 52-11-00. DEFERRED PAX DOOR ON DMI 33913184.SDR A6WA201441816Structure · crackedPAX DOOR STAIRS CRACKED AT UPPER PAX DOOR ASSIST MOTOR MOUNT BRACKET .SDR SIMA20140725004Door · obstructedFLIGHT ATTENDANT REPORTED THAT MAIN DOOR IS VERY HARD TO OPEN & CLOSE. FOUND COURTAIN STRAP GETTING BETWEEN PAX DOOR AND DOOR STOP. REPOSITIONED STRAP AND COMPLIED WITH EM -52-029. OPS CHECKED GOOD IAW AMM 52- 18-00.SDR USAA2014072800018Damper · damaged2S CHECK L1 DOOR DAMPER GAUGE IS MISSING PRESS SEAL. REPLACED L1 PAX CREW DOOR DAMPER IAW AMM 52-11-14.SDR N6WA20140725002Cable · brokenPAX DOOR ASSIST CABLE BROKEN. R & R PAX DOOR POWER ASSIST CABLE IAW 52-11-08. OPERATIONS CHECKED GOOD AT THIS TIME.SDR USAA2014072800022Bottle · low pressureCIDS PANEL WARNING CHECK DOOR PRESS L4. SERVICED L4 DOOR ASSIST BOTTLE IAW AMM 52-10-00-301.SDR VQI2014082200021Bushing · wornREPORT THAT THE GUST LOCK ON R1 DOOR NOT LOCKING. NYLON BUSHINGS WERE WORN, REPLACED THE BUSHINGS IAW AMM 52-11-12-00-802. ACFT RETURNED TO SERVICE.SDR VQI2014082200020Bushing · wornACFT ARRIVED, MAINTENANCE RECEIVED A VERBAL REPORT OF THE GUST LOCK ON R1 DOOR NOT LOCKING. MAINTENANCE IDENTIFIED NYLON BUSHINGS WERE WORN. REPLACED IAW AMM 52-11-12-00-802. ACFT RETURNED TO SERVICE.SDR SWAA2014072830394Skin · crackedL1 DOOR INNER SKIN CRACKED FWD SIDE OF LOWER HINGE CUT OUT VERTICAL FRAME. REPAIRED SKIN IAW EA.
Back to JASC 5210