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 COMA0110055Beam · crackedDURING 2C CHECK TASK 811-02Z, THE PAX DOOR AFT LATERAL BEAM WAS FOUND CRACKED. THE PART WAS REPAIRED IN ACCORDANCE WITH EMB-120 SRM 52-10-02, FIGURE 201.SDR COMA0110046Channel · crackedDURING 2C CHECK TASK 811-02Z, THE PAX DOOR 3RD U-CHANNEL WAS FOUND CRACKED. THE PART WAS REPLACED IN ACCORDANCE WITH EMB-120 SRM STANDARD PRACTICES.SDR COMA0110045Channel · crackedDURING 2C CHECK TASK 811-02Z, THE PAX DOOR AFT U-CHANNEL WAS FOUND CRACKED. THE PART WAS REPLACED IN ACCORDANCE WITH EMB-120 SRM STANDARD PRACTICES.SDR COMA0110044Channel · crackedDURING 2C CHECK TASK 811-02Z, THE PAX DOOR 1ST U-CHANNEL WAS FOUND CRACKED. THE PART WAS REPLACED IN ACCORDANCE WITH EMB-120 SRM STANDARD PRACTICES.SDR ABXA010090Door · crackedLOWER FORWARD ENTRY DOOR WAS CRACKED BEHIND THE LOWER HINGE. MAINTENANCE INSPECTED AND REPLACED THE FORWARD ENTRY DOOR.SDR GLBA2001059Seal · out of positionRETURN TO BLOCK - PAX DOOR LEAKING AIR, INSPECTED FOUND DOOR SEAL OUT OF POSTION. RESECURED DOOR SEAL, PERFORMED TEST FLIGHT AND OPS CHECKED GOOD.SDR AC2A072821Latch · out of adjCABIN DOOR WAS EXTREMELY HARD TO OPEN AND WOULD NOT CLOSE PROPERLY. AJUSTED DOOR LATCHES.SDR UPS01435395Structure · crackedINSPECTION TYPE:C6 M/D - R2 DOOR FWD LWR CORNER FOUND CRACKED. DOOR FWD LWR CORNER REPAIRED AS PER SRM 52-10-02 FIG 10.SDR ASAA0110119Door · lack of lubeANC - DURING MAINTENANCE CHECK, FOUND L1 DOOR DIFFICULT TO OPEN. CLEANED AND LUBED L1 DOOR AND DOOR OPENED NORMALLY. (M)SDR TI1R001420Rod · dischargedGAS ROD, LOST GAS CHARGE. REMOVED AND REPLACED.SDR UPS01435390Fitting · crackedINSPECTION TYPE:C6 MAIN DECK - R3 DOOR FWD CUTOUT NR 5 DOOR STOP SUPPORT FITTING FOUND CRACKED. REFER NRC 6124 FOR FITTING REPLACEMENT DETAIL.SDR UPS01435387Fitting · crackedINSPECTION TYPE:C6 MAIN DECK - R3 DOOR FWD CUTOUT NR 5 STOP SUPPORT FITTING FOUND CRACKED. R3 DOOR FWD NO.5 STOP FITTING REPLACED AS PER SRM 51-10-01.SDR AUS20010664Roller · seized(AUS) PASSENGER DOOR R1 SEQUENCING CAM ROLLER SEIZED AND DISINTEGRATEDPREVENTING CORRECT OPERATION OF DOOR.SDR UPS01435424Doubler · crackedINSPECTION TYPE:C6 CABIN - L1 DOOR LOWER HINGE DOUBLER FOUND CRACKED. DOUBLER REPLACED AS PER BOEING SB B747-52-2144.SDR UPS01435413Stop Fitting · crackedINSPECTION TYPE:C6 CABIN - L1 DOOR FWD LOWER STOP FITTING CRACKED. STOP FITTING REPLACED AS PER SRM 51-10-01 P.8.SDR UPS01435355Fitting · crackedINSPECTION TYPE:C6 CABIN - R1 DOOR FWD LOWER STOP FITTING FOUND CRACKED. STOP FITTING REPLACED AS PER SRM 51-10-01 P.8.SDR PCAA0103015Strut · brokenROC FLIGHT 3512. CREW REPORTED, UNABLE TO OPEN THE AIRSTAIR DOOR. AIRCRAFT FERRIED TO MDT. MDT MAINTENANCE REPLACED FORWARD UPPER DOOR STRUT. OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR 20010507CW016Door Frame · crackedDURING INSPECTION A CRACK WAS FOUND IN THE AIR-STAIR DOOR FRAME LOWER AFT AREA. CRACK ORIGINATED AT THE HING PIN RETAINER SCREWHOLE AND EXTENDED FORWARD APPROX. 10 INCHES THRU THE HINGE UPPER RIVET ROW. AFTER REMOVING THE HINGE, THE SKIN WAS FOUND CRACKED ALSDR CA010313020Strut · jammed(CAN) WHEN DOOR WAS OPENED TO DEPLANE PASSENGERS, SHOCK STRUT JAMMED AND POPPED RIVETS ON BRACKET (P/N 552.10.12.176) WHEN BRACKET FAILED DOOR FREE FELL UNTIL CHECK CABLES ATTEMPTED TO STOP TRAVEL, BUT THE MOMENTUM SNAPPED THE CABLE ATTACH BRACKETS (P/N 552.10SDR USAASB01074Door · not closedIAH - FLT 744 - ON CLIMB-OUT FROM IAH, CAPTAIN REPORTED THEY COULD NOT GET THE CABIN TO PRESSURIZE. AT 8,000 FEET, FLIGHT ATTENDANT ADVISED CAPTAIN THAT THE AFT SERVICE DOOR WAS NOT CLOSED. NO DOOR INDICATION WAS NOTED IN COCKPIT. FLIGHT RETURNED TO FIELD ASDR TWAA0104404Door · dentedENGINEERING REQUESTED A PERMANENT REPAIR TO A DENT JUST FWD AND BELOW THE LEFT SIDE NUMBER 4 CABIN DOOR, STA 1610 AND STRINGER 18L. INSTALLED AN EXTERNAL DOUBLER 8 IN BY 10 INCHES USING BLIND FASTENERS PER SRM 53-00-01. CHECK-C 9-27-99 LAX.SDR UPS01235220Strap · unserviceableINSPECTION TYPE:IN FWD ENTRY DOOR HANDLE STRAP IS NOT LONG ENOUGH TO ENGAGE VELCRO PAD WHEN LOOPED AROUND THE DOOR HANDLE. REMOVED FWD ENTRY DOOR HANDLE STRAP AS PER EO B727-2560-12064. OK FOR SERVICE.SDR MWEA010259Pan · crackedFORWARD PAX DOOR PAN IS CRACKED AT BN FASTENER AT FORWARD LOWER CORNER AB2. LOCATED, DRILLED AND INSTALLED NEW DOOR PAN SEGMENT.SDR MWEA010249Attach Angle · damagedLOWER FORWARD PAN ATTACH ANGLE ON PAX DOOR HAS AREAS OF DAMAGE. REMOVED, FABRICATED AND INSTALLED ANGLE.SDR MWEA010248Beam · damagedPAX DOOR BEAM NR 7 HAS NON-REPAIRABLE DAMAGE. REMOVED, LOCATED, DRILLED AND INSTALLED NR 7 BEAM.SDR MWEA010237Intercostal · crackedFORWARD PAX DOOR INTERCOSTAL IS CRACKED ABOVE BAYONET AB9. REMOVED, LOCATED, DRILLED AND INSTALLED NEW INTERCOSTAL.SDR MWEA010226Intercostal · crackedFORWARD PAX DOOR HAS A CRACKED INTERCOSTAL OVER RECESS HANDLE PAN. (INTERCOSTAL AND REPAIR DOUBLER ARE CRACKED) REMOVED, FABRICATED AND INSTALLED INTERCOSTAL.SDR AWXA0001477Skin · dentedL2 DOOR FWD LWR CORNER EDGE SKIN HAS 2 DENTS. CUT OUT DAMAGED SKIN; NDT - NO CRACKS. FABBED DOUBLER AND FILLER IAW SRM 52-10-01; INSTALLED REPAIR PARTS IAW SRM 51-40-02.SDR DHL2001806610Skin · deformedC-CHECK - ENTRY DOOR FWD UPPER CORNER DEFORMED FS 60.000. REMOVED FASTENERS IAW SRM 51-1-20D PAGE 21. CUT OUT DEFORMED SKIN IAW EO DHL 010325, ED 2388, EO 2001047. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. FABRICATED FILLER AND DOUBLER (ALCLAD 7075SDR UPS01435550Web · crackedINSPECTION TYPE:N/A CRACKS ON NR 3 ENTRY DOOR LIGHTING HOLES. *S/D* ACCOMPLISHED REPAIR IAW EO 747-53-15-88270.SDR SWAA010637Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR FRAME CRACKED AT UPPER FWD LATCH ATTACHMENT POINT. REMOVED AND REPLACED FWD ENTRY DOOR PER MM.SDR AWXA0001463Tab · crackedFWD ENTRY DOOR TORQUE TUBE COVER TAB IS CRACKED AT EACH END AT BS 328. INSTALLED REPAIR DOUBLERS IAW SRM 51-30-01 & 51-40-02.SDR 01FDEA00171Door · damagedFWD ENTRY DOOR LIGHT ILLUM AT 18,000. LOUD BANG AT 3000 ON DEP I FRONT AREA OF A/C. *S/D* REMOVED AND REPLACED FWD ENTRY DOOR PER 727-200 MM 52-11-00-4. PERF RIG ADJUSTMENT TEST PER B727-200 MM 52-11-001-5. INSTALL DOOR LINER PER MM 52-11-001-5. REINSTALSDR DL72W010349Skin · crackedDURING MAINTENANCE VISIT, THE FWD ENTRY DOOR WAS FOUND CRACKED AROUND THE UPPER LATCH CUTOUT. REPAIR PER ER/A 401383-14.SDR AWXA0001425Skin · crackedFWD ENTRY DOOR INNER SKIN CRACKED AT UPPER FWD ACCESS OPENING. FABED REPAIR DOUBLER AND INSTALLED IAW B737-200 SRM 51-40-02.SDR USAA010188Web · crackedCLT - FOUND DOOR WEB CRACKED .5 INCH, AFT SERVICE DOOR TORQUE BOX WEB BS 947 BELOW STRINGER 11R. INSTALLED DOUBLER PER TR 53-30-07A. (M)SDR 20010425AP037Pan · corrodedDURING CPCP-2 INSPECTION MAINTENANCE REPORTED THE PAX DOOR INNER SKIN CRACKED NEXT TO THE PRESSURE RELIEF DOOR AND THE UPPER PAN CORRODED. MAINTENANCE REPAIRED THE INNER SKIN IAW SRM 52-11-00 AND 51-25-02, AND REPAIRED THE UPPER PAN IAW SRM 52-11-00 FIGURE 91SDR AALA20010349Skin · damagedTUL - FOUND BLEND OUT OF AREA WITH NO EDGE DISTANCE TO FASTENERS. REMOVED DAMAGED SECTION OF SKIN EDGE AND INSTALLED REPAIR DOUBLER PER SRM 52-00-3 FIG 4. (M)SDR USAA010176Sill · corrodedCLT - FOUND DOOR SILL OUTER CHORD CORRODED 38 INCHES, DOOR SILL FROM BS 560-612. INSTALLED REPAIR FILLERS AND SUPPORT ANGLE PER EA 69073. (M)SDR SIMA07815Pan · corrodedSAW - DURING CPCP-8 INSPECTION, MAINTENANCE REPORTED THE PAX DOOR LOWER PAN CORRODED AND DENTED IN TWO PLACES. MAINTENANCE REMOVED AND REPLACED THE LOWER PAN IAW SRM 52-11-00. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR ASAA0180084Door · inoperativeSEA - DURING PRE-FLIGHT CHECK, L1 DOOR (FWD LT CREW/PAX DOOR) WAS FOUND TO BE DIFFICULT TO OPEN AND CLOSE. REMOVED AND REPLACED L1 DOOR. DOOR THEN OPERATED NORMALLY. (M)SDR ASAA0110108Hinge · lack of lubeSEA - DURING MAINTENANCE CHECK, FOUND L1 DOOR HARD TO CLOSE. LUBED HINGES, DOOR OPERATED NORMALLY. (M)SDR MWEA010170Beam · crackedVENTRAL STAIR DOOR, LOWER LEFT HAND SIDE BEAM IS CRACKED IN 2 AREAS. REMOVED, FABRICATED AND INSTALLED BEAM.SDR P2EA01004Seal · failedMCI - FLT 350 - WHILE IN CLIMB-OUT OF MCI, AIRCRAFT WOULD NOT PRESSURIZE, RETURN TO MCI. INSPECTION FOUND AIRCRAFT L1 DOOR SEAL NOT PROPERLY SEATED. RESECURED DOOR AND OPERATIONAL CHECK NORMAL. (M)SDR ASAA0180081Door · out of adjSEA - DURING PRE-FLIGHT CHECK, L1 DOOR INTERNAL HANDLE WAS FOUND TO BE RUBBING AGAINST THE FORWARD LAVATORY WALL. READJUSTED DOOR PER MM 52-11-0. (M)SDR DLM11010307Handle · mislocatedL1 DOOR OPEN CONTROL HANDLE FOUND WITH INSUFFUCIENT CLEARANCE TO CREW REST MODULE. MODIFIED STRUCTURE PER ERA 388450-14.SDR DLM11010305Handle · mislocatedL1 DOOR OPEN HANDLE FOUND TO HAVE INSUFFICIENT CLEARANCE TO CREW REST MODULE. MODIFIED MODULE PER ERA 388450/14.SDR DLM11010304Handle · mislocatedL1 DOOR OPEN HANDLE FOUND TO HAVE INSUFFICIENT CLEARANCE TO CREW REST MODULE. MODIFIED MODULE PER ERA.SDR C2XA01CL031Roller · lack of lubeEWR FLIGHT 4258 THE CREW REPORTED THE FORWARD DOOR IS VERY DIFFICULT TO OPEN. MAINTENANCE INSPECTED AND LUBED THE DOOR ROLLERS. OPERATIONAL CHECKS WERE GOOD. THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR ASAA0180074Door · out of adjSEA - DURING LINE CHECK, FORWARD ENTRY L1 DOOR WAS DETERMINED TO BE HARD TO CLOSE WITH EXTERIOR HANDLE. REMOVED CENTER LINER. ADJUSTED DOOR PER MM 52-11-00. REINSTALLED LINER. DOOR LEAKED CHECKED OK. (M)
Back to JASC 5210