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 SIMA20150111003Nut Plate · brokenTRANSFERRED FROM AML PAGE 3665100 ITEM 3. MAIN CABIN DOOR HARD TO CLOSE & OPEN. PERFORMED MAIN DOOR INTERNAL ACTUATING TEST IAW AMM 52-18-00. OPERATIONS CHECKED GOOD. REF NRWC 653-DFW-01923 ADJUSTED BOTH UPPER DOOR ROLLERS IAW AMM 52-18-00. PERFORMED MAINSDR IPXA2015011285264Skin · damagedL1 ENTRY DOOR OUTER SKIN DAMAGE.SDR USAA2015011200001Bottle · low pressureCIDS PANEL SHOWS DOOR SLIDE 4R PRESS CHECK. SERVICED 4R DOOR ASSIST BOTTLE PRESS.SDR DALA2015011200294Skin · bentL1 DOOR LOWER FLANGE BENT ON FORWARD LOWER CORNER SKIN. STRAIGHTENED LOWER EDGE IAW SRM 52-01-01. NO ADDITIONAL REPAIR REQUIRED. OK FOR SERVICE.SDR N6WA2015011002Hinge · dirtyPOPPING NOISE HEARD COMING FROM PAX DOOR ASSIST MOTOR WHEN CLOSING. PERFORMED INSPECTION, FOUND DEBRIS IN HINGE. REMOVED IAW AMM 52-11-00. OPERATIONS CHECKED GOOD AT THIS TIME.SDR ASAA2015011010211Arm · out of adjustL1 DOOR IS DIFFICULT TO LATCH CLOSE. ACFT GROUNDED. ADJUSTED L1 DOOR GUIDE ARM IAW MM 52-11-00-705-007 PG 2, STEPS 3H (1 AND 2).SDR SWAA2015011935880Fitting · crackedL1 DOOR ANGLE BRACKET CLIP CRACKED AT BS 294.5, STRINGER 10L. R & R CLIP IAW SRM & DWG.SDR REXA2015010900013Seal · frozenF/A REPORTS THAT PASSENGER DOOR MAKES LOUD SQUEELING NOISE IN FLIGHT. REMOVED ICE AND DEBRIS FROM LOWER DOOR SEAL AREA. CLEANED DOOR SEAL PRESSURIZED AIRCRAFT, REF AMM 21-32-00, NO LEAKS NOTED.SDR USAA2015011200005Bottle · low pressureL4 DOOR ASSIST BOTTLE PRESS LOW. SERVICED DOOR L4 ASSIST BOTTLE IAW AMM 52-10-00-614-001A.SDR DALA2015012200539Frame · crackedDOOR FRAME CRACKED INSIDE L-1 DOOR AT UPPER AFT CORNER. REMOVED L-1 DOOR IAW AMM 52-11-00-401, STEP 1A-2A5. INSTALLED SERVICEABLE L1 DOOR IAW AMM 52-11-00-501. PERFORMED SATISFACTORY RIG & LEAK/PRESSURE CHECK IAW AMM 52-11-00.SDR FDEA201501080087Pan · chafedCABIN L4 DOOR EXTERNAL HANDLE PAN FOUND CHAFED. HANDLE PAN REMOVED AS PER SRM 51-10-02 REV 113 AND FOUND MATERIAL LOSS OF MORE THAN 50%. L4 DOOR EXTERNAL HANDLE PAN REMOVED AS PER SRM 51-40-02 REV 113. NEW L4 DOOR HANDLE PAN INSTALLED IAW DWG 146N6100 SHT 7 SDR GTIA2015010801478Bottle · low pressureL1 AND L2 DOOR ASSIST BOTTLES HAVE LOW PRESSURE. L1 & L2 DOOR ASSIST BOTTLES SERVICED IAW AMM 52-10-00.SDR REXA2015010800010Motor · failedMAIN CABIN DOOR ASSIST DOESN`T BRING DOOR UP ALL THE WAY. R & R PASSENGER DOOR POWER ASSIST MOTOR IAW AMM 52-11-08. OPS CHECKED GOOD.SDR RAIA201501080001Cable · lack of lubePASSENGER DOOR HARD TO OPEN AND CLOSE DURING POST FLIGHT. MAINTENANCE INSPECTED AND LUBED CABLES AND SEALS, OPS CHECKED GOOD.SDR N6WA2015010801Wheel · malfunctionedPASSENGER DOOR SUPPORT WHEEL DID NOT DEPLOY. CYCLED PAX DOOR & INSPECTED SUPPORT ASSEMBLY. OPERATIONS CHECKED NORMAL OF PAX DOOR WHEEL SUPPORT IAW AMM 52-13-00.SDR AALA20150109005Actuator · low pressureR1 DOOR EMER DAMPER & ACTUATOR PRESS LOW. SERVICED R1 DOOR EMER DAMPER & ACTUATOR IAW AMM 52-10-00.SDR SWAA2015010935595Skin · crackedL1 DOOR INNER SKIN CRACKED BELOW THE TORQUE BOX. REPAIRED SKIN IAW EA.SDR ASOA2015020412143Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED AT POWER DOOR ASSIST PULLEY. REMOVED 2 EA SPLICE ANGLES FROM PAX DOOR DRAG ANGLE IAW SRM 51-42-06. INSTALLED 2 NEW FABBED SPLICE ANGLES IAW REO 601R-52-11-513. REMOVED 1 EA PAX DOOR PULLEY BRACKET IAW SRM 51-42-10. INSTASDR ASAA2015010710473Web · puncturedL2 DOOR INNER WEB PUNCTURED NEAR UPPER HINGE PRESSURE PANEL. ACFT GROUNDED. REPAIRED L2 DOOR INNER WEB IAW EA: COMPT-52EA-14216, REV-NEW DATED 28JAN2015 AND REO-G18700, REV A DATED 21JAN2015. TITLE "AFT ENTRY, L2 DOOR, INTERNAL UPPER SKIN PUNCTURE REPAIR.", SDR REXA2015010700031Structure · crackedPAX DOOR CRACKED ON AFT WALL AT BOTTOM OF UPPER STEP SUPPORT BY HAND RAIL RETAINER CUP. REPAIRED IAW EO R52022.SDR REXA2015010700030Structure · crackedPAX DOOR CRACKED ON FWD WALL AT BOTTOM OF UPPER STEP SUPPORT BY HAND RAIL RETAINER CUP. REPAIRED IAW EO R52022.SDR RAIA201501070001Handle · looseMAIN CABIN DOOR HARD TO OPEN DURING PREFLIGHT. MAINTENANCE INSPECTED AND SECURED LOOSE INNER MAIN CABIN DOOR HANDLE, OPS CHECKED GOOD.SDR QXEA2015010901139Rib · corrodedAFT PAX DOOR SURROUND RIB FOUND CORRODED. REMOVED AND REPLACED IAW SRM 51-42-05, IAW SRM 51-42-05, AND DWG 85339511.SDR USAA2015010800011Pneumatic System · depletedL2 DOOR BOTTLE READING ZERO PRESS. REPLACED PNEUMATIC ASSEMBLY DIAPHRAGM & SEALS IAW AMM 52-12-52-000 400-801A & 52-12-51-614-801-A.SDR USAA2015010800002Bottle · low pressureFLIGHT ATTENDANTS ADVISE DOOR 1R IS ANNUNCIATING, CHECK DOOR PRESS. SERVICED FWD RT SERVICE DOOR ASSIST BOTTLE IAW AMM 52-10-00-6-14-001-A. OPERATIONS CHECKED NORMAL.SDR USAA2015010800006Bottle · low pressureR2 DOOR PRESS READS LOW. SERVICED R2 DOOR ASSIST BOTTLE IAW AMM 52-11-14.SDR UHLA2015010600006Deflector · tornDURING DESCENT, THE CREW REPORTED HEARING A POPPING SOUND AND HAVING THE COCKPIT FLOOR VIBRATE. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. FOUND L1 DOOR DEFLECTOR IS TORN. R & R L1 DOOR DEFLECTOR REF AMM 52-11-28.SDR SWAA2015010835551Bearing · faultyL1 DOOR WILL NOT OPEN FULLY. R & R BEARING IAW MM.SDR V0XD20150108004Panel · crackedPASSENGER DOOR AFT SIDE STAIR SKIN HAS CRACK AT THIRD STEP. REPAIRED AFT SIDE PANEL IAW REO 670-52-11-104 REV F DATED 21 OCT 2010.SDR USAA2015010700005Door · obstructedFLIGHT ATTENDANT REPORTS 1R DOOR DIFFICULT TO ARM. CLEANED DEBRIS FROM FLOOR. OPERATION NORMAL.SDR SWIA201540609Vent · dentedPASSENGER DOOR VENT FLAP DENTED ABOVE UPPER RIB, VISIBLE FROM EXTERIOR, MARKED, C-CHECK. EVALUATED DENT ON PAX DOOR VENT FLAP DOOR CAUSED BY BREAKER CABLE RUBBING INNER SURFACE. A DENT IS ACCEPTABLE IN THIS AREA. THE DENT HAS NO SHARP CREASES AND IS WITHIN LSDR SWIA201540608Rib · chafedPASSENGER DOOR VENT FLAP CHAFED FROM CABLE ON UPPER RIB. HAND BLENDED CHAFE ON PAX DOOR VENT FLAP DOOR INNER RIB AND FOUND TO BE WITH-IN LIMITS IAW REO. ORIGINAL THICKNESS OF RIB STIFFENER IS .625? REMAINING AFTER BLEND IS .534?, LOSS OF .080?.SDR SWIA201540607Lever · chafedPASSENGER DOOR FWD PULL-IN LEVER CHAFED. HAND SANDED OUT SMALL CHAFE MARK ON PAX DOOR FWD PULL-IN LEVER AND REPAIR IS WITHIN LIMITS IAW REO. ORIGINAL THICKNESS AT THE CROSS SECTION OF THE PAX DOOR FWD PULL-IN LEVER IS 1.080", REMAINING THICKNESS AFTER BLEND OSDR UHLA2015010500003Door · detachedL1 DOOR CAME OFF TRACK WHILE TRYING TO CLOSE IT. SEQUENCED L1 DOOR IAW AMM 52-11-20. ADJUSTMENT AND TEST OPS CHECKED GOOD.SDR USAA2015010600003Bottle · low pressureL1 DOOR ASSIST BOTTLE LOW. SERVICED L1 DOOR ASSIST BOTTLE TO IAW AMM 52-00-614.SDR A6WA201542305Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED.SDR DALA2015010500055Cable · out of adjustL4 DOOR FAILS EMERGENCY POWER ACTUATION CABLE CHECK SHOULD BE .950+ OR -.050 IS 1.100. ADJUSTED L4 DOOR EMERGENCY POWER ACTUATION CABLE IAW AMM 52-11-32-404-010, OPS CHECKED GOOD.SDR USAA2015010500010Actuator · low pressureSID CAUTION LIGHT ON, RETURNED TO GATE. DOOR R2 ACTUATOR LOW PRESS. SERVICED DOOR R2 ACTUATOR IAW AMM 52-22-00.SDR A6WA201542287Cleat · corrodedPAX DOOR HANDRAIL STOW CLEATS ARE CORRODED.SDR USAA2015010500013Arming Lever · looseDOOR 3R ARMING LEVER LOOSE. SECURED DOOR 3R ARMING LEVER.SDR USAA2015010500012Arming Lever · looseDOOR 3L SLIDE ARMING HANDLE IS LOOSE. SECURED DOOR 3L SLIDE ARMING HANDLE.SDR USAA2015010500009Bottle · low pressureCIDSS CAUTION LIGHTS ON FWD. FLIGHT ATTENDANT PANEL ILLUMINATED. DOOR L2 ASSIST BOTTLE LOW, SERVICED DOOR L2 ASSIST BOTTLE IAW AMM 5200-614-050-A.SDR QXEA2015012800030Intercostal · corrodedPAX DOOR MACHINED INTERCOSTAL CORRODED. PAX DOOR MACHINED INTERCOSTAL, PN 85329342-105. REMOVED REF SRM 51-40-15/51-41-00. PAX DOOR MACHINED INTERCOSTAL PN 85329342-105 INSTALLED ON TASK CARD 6-53-1160-FWD PAX DOOR ITEM 25. C/W AIR CPCP FORM M-184. LOCATESDR ASAA2015010210140Door · bindingL1 DOOR DIFFICULT TO CLOSE FROM THE INSIDE, NOT CLOSING PROPERLY.SDR DALA2015010200066Skin · crackedDURING INSPECTION, FOUND A CRACK ON THE EXTERNAL SKIN OF AFT PASSENGER DOOR. REPAIRED IAW SRM 52-10-00 PARA 5C, FIG 203.SDR SWAA2015010535447Skin · crackedL1 DOOR INNER SKIN CRACKED BELOW THE TORQUE BOX AT LOWER HINGE AREA. REPAIRED SKIN IAW EA.SDR USAA2015010500015Bottle · low pressureDOOR L1 PRESS SHOWS CAUTION ON CIDS PANEL INFLIGHT. SERVICED DOOR L1 ASSIST BOTTLE IAW AMM 52-11-14.SDR SIMA20150102002Door Seal · dirtyMAIN CABIN DOOR DIFFICULT TO OPEN. REPEAT WRITE-UP SEE PG 3665077 ITEM 2. REPOSITION CABIN ENTRY CURTAIN & CLEANED DOOR & FRAME SEAL IAW AMM 52-18-00.SDR AALA20150101005Skin · dentedR2 DOOR SKIN HAS TWO DENTS. REPAIRED R2 DOOR SKIN IAW SRM52-10-01-2R REPAIR 5.SDR IPXA2015010585206Bottle · low pressureL1 DOOR NITROGEN BOTTLE PRESSURE IS LOW. SERVICED THE BOTTLE IAW MM 12-25-04-600-801.
Back to JASC 5210