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 AALA202506236618Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 277 TO BS 294. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202506171098Start Valve · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DISPLAYED SHOWING ENGINE 1 OIL QUANTITY 0 IN FLIGHT, OIL PRESSURE AND TEMPERATURE INDICATIONS WERE NORMAL BUT EVENTUALLY OIL PRESSURE DROPPED, PRECAUTIONARY ENGINE SHUTDOWN. AIRCRAFT DIVERTED TO AND LANDSDR AALA202506170325Starter · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DISPLAYED SHOWING ENGINE 1 OIL QUANTITY 0 IN FLIGHT, OIL PRESSURE AND TEMPERATURE INDICATIONS WERE NORMAL BUT EVENTUALLY OIL PRESSURE DROPPED, PRECAUTIONARY ENGINE SHUTDOWN. AIRCRAFT DIVERTED TO AND LANDSDR AALA202507096398Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND SIDE OF FUSELAGE SKIN IS CORRODED AT AFT LAVATORY OVERBOARD VENT AREA AT STA 907 BETWEEN STR 21L AND 22L. REPAIRED LEFT HAND SIDE OF FUSELAGE SKIN IS CORRODED AT AFT LAVATORY OVERBOARD VENT AREA. PER B737 SRM 53-70-01-2RSDR AALA202506246257Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540, LBL 10. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1SDR AALA202506247482Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500B PLUS 6 INCHES TO BS 500I AT LBL 25. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202506234442Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 323, RBL 31. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202506180363Guide Arm · stickingAIRCRAFT WAS GROUNDED: MAIN CABIN DOOR GUST LOCK STICKS AND IS DIFFICULT TO MOVE. REMOVE AND REPLACE L1 DOOR GUIDE ARM (AALA202506160363) AND ROLLER ASSEMBLY (AALA202506173297). PER AMM 52-11-21.SDR AALA202506174616Liner · damagedAIRCRAFT WAS NOT GROUNDED: SLEEVE ATTACHED TO GIRT BAR ON FORWARD ENTRY DOOR IS SAGGING AND LOOSE. ADJUSED SLEEVE ON FORWARD ENTRY DOOR SLIDE. PER AMM-25-66-00.SDR AALA202506173571Slide · out of positionAIRCRAFT WAS GROUNDED: WHILE OPEN FORWARD SERVICE DOOR EMERGENCY SLIDE RED BAR IS HANGING NOT DEPLOYED. REMOVE AND REPLACE R1 DOOR ESCAPE SLIDE. PER J/C 08L22125001.SDR AALA202506170363Guide Arm · stickingAIRCRAFT WAS GROUNDED: MAIN CABIN DOOR GUST LOCK STICKS AND IS DIFFICULT TO MOVE. REMOVE AND REPLACED L1 DOOR GUIDE ARM (AALA202506160363) AND ROLLER ASSEMBLY (AALA202506173297). PER AMM 52-11-21.SDR AALA202506173297Roller · stickingAIRCRAFT WAS GROUNDED: MAIN CABIN DOOR GUST LOCK STICKS AND IS DIFFICULT TO MOVE. REMOVE AND REPLACED L1 DOOR GUIDE ARM (AALA202506160363) AND ROLLER ASSEMBLY (AALA202506173297). PER AMM 52-11-21.SDR AALA202506179392Door · bindingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE BOTH ON THE GROUND AND IN FLIGHT. SECURED AFT LOWER DOOR TRIM BINDING ON DOOR. PER CMM 25-48-48.SDR AALA202506175422Autobrake Sys · faultedAIRCRAFT WAS GROUNDED: AUTO BRAKE DISARM LIGHT ILLUMINATED WITH AUTO BRAKES OFF AFTER LANDING. REMOVE AND REPLACED AUTO BRAKE CONTROL UNIT. PER AMM 32-42-81. GROUND OPERTIONAL CHECK GOOD AT THIS TIME.SDR AALA202506174249Connector · looseAIRCRAFT WAS NOT GROUNDED: DURING SERVICE CHECK FOUND CABIN EMERGENCY LIGHTS OUT AT ROWS 13, 14, 15. INSPECTED CABLES UNDER SEAT 13, 14, 15C FOUND RED P2 CABLES WITHA LOOSE CONECTION UNDER SEATS TIGHTENED RED P2 CABLES CONNECTION, OPERTIONAL TEST PASSED.SDR AALA202507146448Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947, LBL 25. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202507142052Mount · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND AFT LAVATORY OUTBOARD AFT MOUNT AT BS 947, LBL 48. REPLACED MOUNT PER AARD 51-00-05-1.SDR AALA202507145481Mount · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND AFT LAVATORY INBOARD AFT MOUNT AT BS 947, LBL 25. REPLACED MOUNT PER SRM 53-70-51-2R REPAIR 5.SDR AALA202507029867Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR STRUCTURE FLOORBOARD SUPPORT CRACKED AT STA 540 AND LBL2. COMPLETED INSTALLATION OF BREAK ASSEMBLY. PER AARD 51-00-05 AND I.P.C 53-31-00.SDR AALA202507021601Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO RIGHT HAND SIDE AT STA 727B AND RBL 22, BAFFLE CLIP IS CRACKED. REINSTALLED BAFFLE CLIP. PER SRM 51-40-02.SDR AALA202506259622Pressure Switch · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON CLIMB OUT, PASSING 5000FT AND MAINTAINING 250KTS ENGAGED AUTOPILOT-B. A BUMP WAS FELT, AND THE AIRCRAFT WAS THEN UNABLE TO MAINTAIN PITCH AND AIRSPEED. AUTOPILOT WAS DISCONNECTED AND THE AIRCRAFT WAS SDR AALA202506258071Actuator · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON CLIMB OUT, PASSING 5000FT AND MAINTAINING 250KTS ENGAGED AUTOPILOT-B. A BUMP WAS FELT, AND THE AIRCRAFT WAS THEN UNABLE TO MAINTAIN PITCH AND AIRSPEED. AUTOPILOT WAS DISCONNECTED AND THE AIRCRAFT WAS SDR AALA202506245379Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500B AND BS 500D AT LBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506249947Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500E AND BS 500F AT RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506240511Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500B AND BS 500C AT RBL 28. REPAIRED TRANSITION PANEL PER SRM 51-10-02.SDR AALA202506242325Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727H PLUS 12 INCHES TO BS 757 AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506243161Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM BS 767 TO BS 787 AT RBL 24. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202506244893Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN BS 294 AND BS 312 AT LBL 12. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202506244837Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED FORWARD GIRT BAR TIEDOWN AT BS 312, LBL 48. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202506247877Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED AFT GIRT BAR TIEDOWN AT BS 344, LBL 46. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202506240982Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD STA 947, FROM LBL 16 TO RBL 16. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202506231718Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER AT STA 663.75, RBL 36. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9.SDR AALA202506231489Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 949, RBL 50.0. REPLACED INTERCOSTAL PER SRM 51-10-02.SDR AALA202506192267Mount · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN RIGHT HAND AFT LAVATORY OUTBOARD MOUNT AT BS 947, RBL 48. REPAIRED PER SRM 51-10-02.SDR AALA202506189698Autothrottle Sys · faultedAIRCRAFT WAS NOT GROUNDED: AUTO BRAKE DISARM LIGHT STAYS ILLUMINATED. CHECKED FAULT HISTORY AND FOUND AACU PREVIOUSLY REPLACED. PERFORMED AACU BITE REF FIM 32-42-00-810-801 AND FOUND "PWR A/B" FAILURE. CONTINUED T/S REF. FIM 32-42-00-810-826 AND FOUND 26VDC ATSDR AALA202506189821Autothrottle Sys · faultyAIRCRAFT WAS NOT GROUNDED: AUTO BRAKE DISARM LIGHT STAYS ILLUMINATED. CHECKED FAULT HISTORY AND FOUND AACU PREVIOUSLY REPLACED. PERFORMED AACU BITE REF FIM 32-42-00-810-801 AND FOUND "PWR A/B" FAILURE. CONTINUED T/S REF. FIM 32-42-00-810-826 AND FOUND 26VDC ATSDR AALA202506170872Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: DOOR FOR LAVATORY-D IS DIFFICULT TO OPEN. LUBRICATED LAVATORY-D DOOR HINGES AND ADJUSTED DOOR HINGE, EDGE CLEARANCES WITHIN LIMITS. PER AARD 25-40-10-04.SDR AALA202506174821Tube · tornAIRCRAFT WAS NOT GROUNDED: FORWARD DOOR L1 RED TUBING AROUND GIRT BAR TORN. REINSTALLED RED TUBING AT FWD L1 DOOR GRIT BAR. PER AARD 25-66-00-4SDR AALA202506179821Autobrake Sys · faultedAIRCRAFT WAS NOT GROUNDED: AUTO BRAKE DISARM LIGHT STAYS ILLUMINATED. CHECKED FAULT HISTORY AND FOUND AACU PREVIOUSLY REPLACED. PERFORMED AACU BITE REF FIM 32-42-00-810-801 AND FOUND "PWR A/B" FAILURE. CONTINUED T/S REF. FIM 32-42-00-810-826 AND FOUND 26VDC ATSDR AALA202506171796Pressure Switch · failedAIRCRAFT WAS NOT GROUNDED: RIGHT WING AFT FUEL PUMP LOW PRESSURE LIGHT NOT ILLUMINATED WITH PUMP TURNED OFF. REMOVE AND REPLACED PRESSURE SWITCH S152. PER AMM 28-42-11. ALL OPERTIONAL TEST PASS.SDR AALA202506178071Autopilot Sys · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON CLIMB OUT PASSING 5000FT AND MAINTAINING 250KTS ENGAGED AUTOPILOT-B. A BUMP WAS FELT AND AIRCRAFT WAS THEN UNABLE TO MAINTAIN PITCH AND AIRSPEED. AUTOPILOT WAS DISCONNECTED AND AIRCRAFT WAS HAND FLOWNSDR AALA202506170685Sliding Window · out of adjustAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING THE TAKEOFF ROLL WE NOTICED AN ABNORMAL AND INCREDIBLY LOUD RUSHING AND WHOOSHING SOUND OF AIR SEEMINGLY FROM THE FIRST OFFICER WINDOW AND SIDE PANEL. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SSDR AALA202507116938Lug · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND HORIZONTAL STABILIZER REAR SPAR TERMINAL FITTING LOWER LUG. REPAIRED LUG PER SRM 55-10-10-1A.SDR AALA202507110976Filler · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER MATING SURFACE OF APU AIR INTAKE DUCT CUTOUT ON RIGHT SIDE OF STA 1088 BULKHEAD AT RBL 32. INSTALLED NEW FILLER PER AARD 51-00-05-1.SDR AALA202506270401Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON BULKHEAD FITTING ATTACH BRACKET AT BS 1088, RBL 14. REPLACED BRACKET PER AARD 51-00-05-1.SDR AALA202506275949Bushing · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STAB CONTROL TAB SPRING SUPPORT HAS RUSTED. REMOVED AND REPLACED AFT BUSHING ON LEFT-HAND ELEVATOR TAB MECHANISM. PER B737-NG-AMM27-31-34. PERFORMED SATISFACTORY ELEVATOR TAB CONTROL SYSTEM AND TRIM CONTROL OPSDR AALA202506271179Bushing · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STAB CONTROL TAB SPRING SUPPORT RUSTED. REMOVED AND REPLACED AFT BUSHING ON RIGHT HAND ELEVATOR TAB MECHANISM. PER B737-NG-AMM27--31-34. PERFORMED SATISFACTORY ELEVATOR TAB CONTROL SYSTEM AND TRIM SYSTEM OPERSDR AALA202506231262Threshold Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR CUTOUT THRESHOLD WEB FROM BS 795 TO BS 847, AT RL 28. REPLACED WEB PER AARD 51-00--05-1.SDR AALA202506178447Door · stuckAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR GETS STUCK AND IS DIFFICULT TO OPEN. ACCOMPLISHED PROPER ADJUSTMENTS TO FORWARD LAVATORY DOOR, OPERTIONAL CHECK GOOD. PER CMM 25-45-46.SDR AALA202506175757Slide · out of rigAIRCRAFT WAS NOT GROUNDED: FOUND THAT WHEN GIRT BAR IS STOWED AND DOOR IS CLOSING, THAT THE FORWARD EDGE OF GIRT IS HANGING LOW AND CATCHING ON THE LOWER L2 DOOR FLOOR SCUFF PLATE LIP AND PULLING AND FOLDING THE GIRT. GIRT IS ALSO IMPEDING DOOR OPERATION. REMO
Back to Boeing 737-823