Boeing 737-823
Service difficulty reports · 31,890
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = '737823' 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 aircraft_model_key = '737823' 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 AALA202212144401Lug · corrodedCORROSION ON LEFT HAND HORIZONTAL STABILIZER REAR SPAR LOWER LUG AFT FACE LOCATED AT STABILIZER STA 44.38. REPAIRED LUG PER EA 340494.SDR AALA202212126228Unknown · odorAIRCRAFT WAS GROUNDED: ON INITIAL TAXI WITH POWER UP GOT DIRTY SOCK SMELL IN COCKPIT. FLIGHT ATTENDANTS DID NOT SMELL. DISSIPATED ON TAKEOFF ROLL SMELL BEGAN AGAIN AND STRONGER. FROM GASPER VENTS. FLIGHT ATTENDANTS DETECTED SMELL DIRTY SOCKS FOR 5 MINUTES, THESDR AALA202212092695Guide Arm · unserviceableAIRCRAFT WAS GROUNDED: L1 DOOR ENTRY LIGHT ILLUMINATED ON TOUCH DOWN. EXTINGUISHED ON OWN DURING TAXI. NO INPUTS. REPLACED L1 DOOR GUIDE ARM PER AMM 52-11-21. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202212075543Door Latch · stickingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LATCH STICKS. LUBED AFT LEFT LAVATORY "D" DOOR LATCH.SDR AALA202212076857Module · faultedAIRCRAFT WAS GROUNDED: DURING CLIMB OUT CIRCUIT BREAKER A-19 ON P6-2 PANEL FOR OVERHEAT WHEEL WELL AND WING TO BODY POPPED. FLIGHT DIVERTED TO IND LANDING SAFELY. REPLACED OVERHEAT DETECTION CONTROL MODULE M00237 PER AMM 26-18-01. ACCOMPLISHED SATISFACTORY OPESDR AALA202301107537Slide · failedAIRCRAFT WAS GROUNDED: SLIDE AT DOOR R2 STARTED TO INFLATE NORMALLY UNTIL PROTECTIVE TARP WAS SUCKED INTO ASPIRATOR, INFLATION STOPPED AT THIS POINT. REMOVED AND REPLACED SLIDE AT R2 DOOR.SDR AALA202212228190Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER S23L AT BS 336. REPLACED STRINGER PER AARD 50-00-05-1.SDR AALA202212225377Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER S23L AT BS 313. REPAIRED STRINGER PER EA 340894.SDR AALA202212204089Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT CREASE ANGLE AT STA 967 HAS CORROSION AT R4 THRESHOLD AREA. INSTALLED NEW CREASE ANGLE PER AARD 51-00-05-1.SDR AALA202212200431Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON FLOORBOARD SUPPORT AT STA 960 AFT ENTRY DOOR BY FORWARD DRAIN AND LEFT BUTT LINE 50. REMOVED AND REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202212204851Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON FLOOR BEAM AT STA 986.5 AND RIGHT BUTT LINE 44. INSTALLED REINFORCING MODIFICATION PER SRM 53-70-51-2R-6.SDR AALA202212204954Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT ENTRY FLOORBOARD SUPPORT LOCATED AT BS 986.5 AND LBL 43. REPAIRED SUPPORT PER SRM 53-70-51-2R-6 ALTERNATE 4.SDR AALA202212076336Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR (02 DEC) VERY DIFFICULT TO CLOSE CHECK WITH LOCKING DEVICE ENGAGED. LUBED AND INSPECTED FLIGHT DECK DOOR CHECKS GOOD AS PER AMM 52-51-01.SDR AALA202212076792Pin · damagedAIRCRAFT WAS GROUNDED: L1 DOOR GUST LOCK BROKEN, DOOR WILL NOT LOCK IN OPEN POSITION. REPLACED DAMAGED PIN ON L1 DOOR GUIDE ARM AND LOCK ASSEMBLY PER AMM 52-11-21.SDR AALA202212070102Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR TAKES REPEATED EFFORTS TO CLOSE SECURELY. CHECKED AND LUBED STRIKER AND LATCH OPERATIONS CHECKS NORMAL.SDR AALA202212078907Module · faultedAIRCRAFT WAS GROUNDED: ON TAKE OFF ROLL FIRE WARNING ENGINE #1 & #2, APU, AND WHEEL WELL ILLUMINATED. REJECTED TAKEOFF AT APPROXIMATELY 70 KNOTS. REPLACED ENGINE / APU FIRE CONTROL MODULE P8 PER AMM 26-00-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECKS.SDR AALA202212060096Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR IS DIFFICULT TO CLOSE. LUBRICATED FLIGHT DECK DOOR LATCH. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 52-51-00.SDR AALA202301187253Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 241RF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301183214Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 242PF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301188082Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 242MF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301181736Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 242GF HAS DAMAGE TO TOP SKIN OF PANEL. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301183694Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 242FF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301180952Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 241VF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301186191Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 241SF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301186986Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 241QF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301181426Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 232SF HAS DAMAGE ON TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301188590Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 231ZF HAS DAMAGE ON TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301108024Door · out of adjustAIRCRAFT WAS GROUNDED: AT APPROXIMATELY 80-85 KNOTS L1 DOOR LIGHT ILLUMINATED. REJECTED TAKEOFF ACCOMPLISHED. PERFORMED ADJUSTMENT IAW AMM 52-71-11-820-801.SDR AALA202212093392Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND MAIN LANDING GEAR WHEEL WELL, WING CENTEER BOX VAPOR BARRIER CRACKED AT RBL 50 AND WL 160. MAINTENANCE REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R-2.SDR AALA202212092794Window · unlockedAIRCRAFT IN BASE MAINTENANCE: CAPTAIN'S L2 WINDOW HARD TO CLOSE AND LOCK. REMOVED AND REINSTALLED L2 WINDOW PER AMM 56-12-11-820-801 AND AMM 56-12-400-801. ACCOMPLISHED SATISFACTORY CHECK.SDR AALA202212078024Warning Light · illuminatedAIRCRAFT WAS GROUNDED: AT APPROXIMATELY 80-85 KNOTS L1 DOOR LIGHT ILLUMINATED. REJECTED TAKEOFF ACCOMPLISHED. (OPEN)SDR AALA202212074222Lamp · dimAIRCRAFT IN BASE MAINTENANCE: FORWARD LEFT OVERWING EMERGENCY LIGHT IS DIM. RE-LAMPED THE FORWARD LEFT OVERWING EMERGENCY LIGHT.SDR AALA202212065010Light · inoperativeAIRCRAFT WAS NOT GROUNDED: R2 EMERGENCY EXIT LIGHT FLASHING. REMOVED AND REPLACED OVERWING EXIT LIGHT ASSEMBLY PER AMM 33-21-00.SDR AALA202212067786Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO CLOSE. LUBRICATED FLIGHT DECK DOOR.SDR AALA202212061188Hinge · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR HARD TO OPEN AT AFT RIGHT LAVATORY. ADJUSTED AFT RIGHT LAVATORY DOOR HINGE PER AMM 52-50-00.SDR AALA202212065495Pump · leakingAIRCRAFT WAS GROUNDED: PRIOR TO DESCENT MASTER CAUTION HYDRAULIC A ENGINE 1 LOW PRESSURE LIGHT ILLUMINATED. HYDRAULIC A PRESSURE AT 20% PERFORMED QUICK REFERENCE HANDBOOK LOSS OF SYSTEM A CHECKLIST. EMERGENCY WAS DECLARED INTO DFW. TROUBLESHOOTING FOUND HYDRAUSDR AALA202212053268Light · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT HAND AFT DOOR EXTERIOR SLIDE LIGHT INOPERATIVE. REPLACED LIGHT PER AMM 33-51-04.SDR AALA202212138575Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT LEFT HAND FLOOR STRUCTURE BAFFLE ASSEMBLY LOCATED FROM BS 500E TO BS 500D AT LBL 16. REPLACED BAFFLE ASSEMBLY PER SRM 51-40-02.SDR AALA202212063661Door Latch · lack of lubeAIRCRAFT WAS GROUNDED: COCKPIT DOOR DIFFICULT TO CLOSE IN THE AIR AND ON GROUND. LUBRICATED COCKPIT DOOR LATCH AND ACCOMPLISHED OPERATIONS CHECK OK PER AMM 52-51-02.SDR AALA202212062137Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND R1 DOOR SLIDE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED R1 DOOR SLIDE EMERGENCY LIGHT LAMP PER AMM 33-51-04.SDR AALA202212061912Door Latch · stickingAIRCRAFT WAS GROUNDED: FORWARD LAVATORY DOOR GETS STUCK, DIFFICULT TO OPEN. LUBRICATED LAVATORY DOOR LATCH AND ACCOMPLISHED OPERATIONS CHECKS PER CMM 25-40-61.SDR AALA202212051367Power Supply · inoperativeAIRCRAFT WAS GROUNDED: L1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED L1 DOOR LEFT HAND EMERGENCY LIGHT POWER SUPPLY PER AMM 33-51-06.SDR AALA202212058400Oil Filter · cloggedAIRCRAFT WAS GROUNDED: DURING DESCENT #1 OIL FILTER BYPASS LIGHT ILLUMINATED. CREW SHUTDOWN #1 ENGINE. EMERGENCY DECLARED. FLIGHT LANDED SAFELY AT DFW. MAINTENANCE REPLACED #1 ENGINE SCAVENGE OIL FILTER PER AMM 79-21-00 AND ELECTRONIC ENGINE CONTROLLER PER JOBSDR AALA202212052414Eec · failedAIRCRAFT WAS GROUNDED: DURING DESCENT #1 OIL FILTER BYPASS LIGHT ILLUMINATED. CREW SHUTDOWN #1 ENGINE. EMERGENCY DECLARED. FLIGHT LANDED SAFELY AT DFW. MAINTENANCE REPLACED #1 ENGINE SCAVENGE OIL FILTER PER AMM 79-21-00 AND ELECTRONIC ENGINE CONTROLLER PER JOBSDR AALA202212206141Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: 2 INCH BY 1.7 INCH AREA OF CORROSION FOUND ON TRANSITION PANEL LOCATED AT STA 500E AND STR 26L AND LEFT BUTT LINE 25. REMOVED AND REPLACED CORRODED TRANSITIONAL PANEL PER SRM 53-00-53-2R-5.SDR AALA202212207799Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT TRANSITION PANEL HAS CORROSION LOCATED BETWEEN 500C+12 TO 500I AND STR 25R. REMOVED AND REPLACED RIGHT TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202212206531Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727 TO BS 815 AT S25L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R REPAIR 5.SDR AALA202212202742Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL SHIELD LOCATED FROM BS 787 TO BS 807 AT RBL 24. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202212205396Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 727 TO BS 767 AT S25R. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R REPAIR 5.SDR AALA202212204146Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR LOWER THRESHOLD WEB LOCATED FROM BS 807 TO BS 847 AT S25R. REPLACED WEB PER AARD 51-00-05-1 AND DWG 146A8123.
Back to Boeing 737-823