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 AALA202507117607Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328 AT LBL 20. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202507118432Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 328 TO BS 344 AT LBL 20. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202507117738Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL UPPER ANGLE FROM BS 380 TO BS 400 AT LBL 9. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202507095361Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HARD TO OPEN. ADJUSTED FORWARD LAVATORY DOOR, OPERATIONAL CHECK GOOD.SDR AALA202507094845Slide · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE PRESSURE OUTSIDE OF GREEN BAND. REMOVED AND REPLACED L1 DOOR SLIDE. PER J/C 08L22125001.SDR AALA202507090379Trim Panel · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR LEFT BOTTOM TRIM LOOSE. INTERFERES WITH DOOR OPENING AND CLOSING. SECURED TRIM IN PLACE, LAVATORY DOOR OPERATIONAL CHECK NORMAL. PER AMM 25-40-11.SDR AALA202507091583Flashlight · inoperativeAIRCRAFT WAS GROUNDED: FORWARD FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT INOPERATIVE. INSTALLED NEW BATTERY FLASHLIGHT. OPERATIONAL CHECKED NORMAL. PER AMM 25-00-00.SDR AALA202507148431Tube · missingAIRCRAFT WAS NOT GROUNDED: R2 DOOR ESCAPE SLIDE AFT END OF GIRT BAR MISSING RED HEAT SHRINK, PER J/C 08L22125001 AND AARD 25-66-00-4. **SUPPLEMENTAL REPORT FOR (AALA202507088431): INSTALLED R2 DOOR GIRT BAR RED HEAT SHRINK, PER AARD 25-66-00-4. NO FURTHER DEFESDR AALA202507147961Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663.5, LBL 8. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202507140181Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663.5, RBL 8. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202507141091Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 927 TO BS 947 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202507138414Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE: MULTIPLE EMERGENCY LIGHTS ARE OUT. SUSPECT BATTERY POWER SUPPLYTO BE BAD. REMOVED AND REPLACED 9RH BATTERY PACK. PER B737-NG-AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL TEST OF EMERGENCY LIGHTS, PER B737NG AMM 33-51-00.SDR AALA202507106493Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN AT AFT LAVATORY SERVICE PANEL BETWEEN BS 847 AND BS 867, BETWEEN S24L AND S25L. REPAIRED SKIN PER EA 365990.SDR AALA202507106231Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER 25L BETWEEN BS 845 AND BS 849. REPAIRED STRINGER PER SRM 53-00-03-2R-1.SDR AALA202507105876Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500H, RBL 24. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA202507089411Screw · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. BOTTOM OF DOOR IS JAMMING AGAINST THE FLOOR WHEN FULLY CLOSED. FOUND SCREW HEAD PROTRUDING UP ON THRESHOLD CAUSING DOOR TO CATCH ON SCREW. TIGHTENED SCREW. OPERATIONAL CHECK GOOD.SDR AALA202507088431Tube · missingAIRCRAFT WAS NOT GROUNDED: R2 DOOR ESCAPE SLIDE AFT END OF GIRT BAR MISSING RED HEAT SHRINK, PER J/C 08L22125001 AND AARD 25-66-00-4. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202507175676Pressure Switch · faultedAIRCRAFT WAS NOT GROUNDED: FILTER BYPASS LIGHT FOR FUEL ON ENGINE NUMBER 2 CAME ON FOR ACOUPLE MINUTES, THEN EXTINGUISHED WHEN CENTER PUMPS TURNED ON. CENTER PUMPS WERE OFF FOR TAKEOFF DUE TO LOW QUANTITY 1000 LBS. LIGHT REMAINED OFF AFTER CENTER PUMPS TURNED SDR AALA202507108624Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN AT AFT LAVATORY OVERBOARD VENT AT BS 907 BETWEEN S21L AND S22L. REPAIRED SKIN PER SRM 53-70-01-2R-3.SDR AALA202507081564Fire Bottle · no discrepancyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HAD FIRE INDICATIONS ON FORWARD CARGO COMPARMENT INFLIGHT, DISCHARGE BOTTLE, NO INDICATIONS OF ANY FIRE ONCE ON GROUND. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT JAX. REMOVED AND REPLACED FAULTY CARGO FISDR AALA202507085440Smoke Detector · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HAD FIRE INDICATIONS ON FORWARD CARGO COMPARMENT INFLIGHT, DISCHARGE BOTTLE, NO INDICATIONS OF ANY FIRE ONCE ON GROUND. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT JAX. REMOVED AND REPLACED FAULTY CARGO FISDR AALA202507085326Fire Detector · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HAD FIRE INDICATIONS ON FORWARD CARGO COMPARMENT INFLIGHT, DISCHARGE BOTTLE, NO INDICATIONS OF ANY FIRE ONCE ON GROUND. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT JAX. REMOVED AND REPLACED FAULTY CARGO FISDR AALA202507085676Warning Light · illuminatedAIRCRAFT WAS NOT GROUNDED: FILTER BYPASS LIGHT FOR FUEL ON ENGINE NUMBER 2 CAME ON FOR ACOUPLE MINUTES, THEN EXTINGUISHED WHEN CENTER PUMPS TURNED ON. CENTER PUMPS WERE OFF FOR TAKEOFF DUE TO LOW QUANTITY 1000 LBS. LIGHT REMAINED OFF AFTER CENTER PUMPS TURNED SDR AALA202507086448Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKS AND IS DIFFICULT TO OPEN. LUBED AND ADJUSTED DOOR FRAME BOTTOM PLATE. OPERATIONAL CHECK GOOD. PER AMM 25-40-00.SDR AALA202507085254Door · out of adjustAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS THAT THE FORWARD LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE. ADJUSTED VERTICAL SIDE TRIM ON FORWARD LAVATORY DOOR JAM. PER CMM 25 45-46.SDR AALA202507086910Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDANT EMERGENCY FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED AFT FLIGHT ATTENDANT FLASHLIGHT. PER AMM 25-64-00.SDR AALA202507089465Girt Bar · out of positionAIRCRAFT WAS NOT GROUNDED: GIRT BAR ON R1 DOOR SERVICE DOOR WAS HARD TO PUT ON POSITION AND REMOVE. REPOSITIONED GIRT BAR FOR DOOR 1R. PER AMM 25-66-01.SDR AALA202507085505Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT OVER WING EMERGENCY EXIT DOOR LIGHT AFT INOPERATIVE. RELAMP LEFT OVER WING EMERGENCY EXIT DOOR AFT LIGHT ASSEMBLY. PERFORMED OPERATIONAL CHECK GOOD. PER AMM 33-51-00.SDR AALA202507082320Handle · malfunctionedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EMERGENCY EXIT DOOR PULL HANDLE IS MALFUNCTIONING. REMOVED AND INSTALLED A SERVICABLE RIGHT HAND FORWARD OVERWING EMERGENCY EXIT DOOR PULL HANDLE. PER AMM 52-22-51. OPERATIONAL CHECK IS GOOD.SDR AALA202507230870Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500B TO BS 500C, AT S27L. REPLACED TRANSITION PANEL PER SRM 53-00-53.SDR AALA202507230701Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 495 PLUS 15 INCHES, AT S27L. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2.SDR AALA202507210254Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT DOOR OPENING THRESHOLD WEB FROM BS 440 TO BS 480 AT RBL 36. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202507167449Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500E TO BS 500F AT RBL 22. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5 AND AARD 51-00-05-1.SDR AALA202507140727Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500E, S24R, RBL 32. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202507086655Elec Connector · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB THE AIRCRAFT PITCHED UP AND DOWN WITH THE LEADING EDGE FLAPS TRANSIT LIGHT ILLUMINATED; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT PHL. FOUND PIN 34 OF CONNECTOR DM22 TO HAVE LOW SDR AALA202507086682Door · inoperativeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS STICKING. REMOVE AND REPLACED LAVATORY-D BI-FOLD DOOR ASSEMBLY. PER CMM 25-40-64. OPERATIONAL CHECK GOODSDR AALA202507238804Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500G TO BS 500H, AT S27L. REPLACED TRANSITION PANEL PER SRM 51-10-02.SDR AALA202507235371Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500F TO BS 500G, AT S27L. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2.SDR AALA202507220130Hanger Assy · brokenAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD PULL HANDLE ASSEMBLY IS BROKEN ON OVERWING EMERGENCY EXIT DOOR. REMOVED AND INSTALLED A SERVICABLE RIGHT HAND FORWARD PULL HANDLE ASSEMBLY. PER AMM 52-22-51. OPERATIONAL CHECK GOOD.SDR AALA202507148423Door · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENTS REPORTS FORWARD LAVATORY DOOR STICKS. FOUND HINGE ON FORWARD LAVATORY DOOR TO HAVE EXCESSIVE PLAY. **SUPPLEMENTAL REPORT FOR (AALA202507088423): FOUND THRESHOLD ON AFT END STICKING UP CAUSING DOOR TO BIND. REMOVED TSDR AALA202507143506Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT INTERCOSTAL AT BS 924, S27L, LBL 3. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202507114914Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM BS 767 TO BS 787, AT S25R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202507096600Shim · migratedAIRCRAFT IN BASE MAINTENANCE: VERTICAL STABILIZER RIGHT HAND REAR SPAR TERMINAL FITTING HAS SHIM WASHERS MIGRATING OUT FROM THE AFT SIDE OF THE OUTBOARD LUG. INSTALLED SHIMS AND ALL HARDWARE. PER AMM 53-30-00.SDR AALA202507081324Control Valve · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEFT PACK CAME ON DURING CRUISE AND LEPT FAILING. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. ACCOMPLISHED FIM TASK 21-62-00-810-830, REMOVED AND REPLACED LEFT TCV, PER AMM 21-51-10. OPERASDR AALA202507089195Window · crazedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD EMERGENCY EXIT WINDOW CRAZED. REMOVED AND REPLACED RIGHT HAND FORWARD EMERGENCY EXIT WINDOW. PER AMM 56-22-00.SDR AALA202507089745Window · crazedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT EMERGENCY EXIT WINDOW CRAZED. REPLACED RIGHT HAND AFT EMERGENCY EXIT WINDOW. PER AMM 56-22-00.SDR AALA202507085006Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: FRONT ENTRY DOOR WAS OPENED WITH JETBRIDGE ATTACHED WITHOUT BEING DISARMED. SLIDE DID NOT DEPLOY. REMOVED AND REPLACED L1 DOOR SLIDE. PER JOBCARD 08L22125001. OPERATIONAL CHECK GOOD.SDR AALA202507089693Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN. FOUND DOOR FRAME TRIM LOOSE (LATCH SIDE). SECURED AS REQUIRED, OPERATIONAL CHECK GOOD.SDR AALA202507088423Hinge · excess playAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENTS REPORTS FORWARD LAVATORY DOOR STICKS. FOUND HINGE ON FORWARD LAVATORY DOOR TO HAVE EXCESSIVE PLAY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202507083092Flashlight · no testAIRCRAFT WAS NOT GROUNDED: AFT GALLEY FLIGHT ATTENDANT EMERGENCY FLASHLIGHT NOT PROPERLY FUNCTIONING, DPES NOT STAY ON. REPLACED FLASHLIGHT. PER AMM 25-64-00.
Back to Boeing 737-823