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 AALA202406263008Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT GALLEY FLOOR STRUCTURE SHEAR WEB AT STA 988, RBL 33. REPARED WEB PER EA 353994. **SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS LEVEL 1 NOT LEVEL 2. SECTION 7 CORROSION SDR AALA202405096102Floorbeam · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD AT STA 947, RBL 50. REPAIRED CHORD PER SRM 53-70-51-2R-5.SDR AALA202405083008Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT GALLEY FLOOR STRUCTURE SHEAR WEB AT STA 988, RBL 33. REPARED WEB PER EA 353994.SDR AALA202405083011Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR SUPPORT AT STA 992, RBL 37. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202404308467Door · unknownAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN AND CLOSE. OPENED AND CLOSED FLIGHT DECK DOOR A COUPLE OF TIMES AND THE DOOR OPERATED SMOOTHLY, NO FAULT FOUND.SDR AALA202404306693Landing Gear · out of rigAIRCRAFT WAS GROUNDED: WHEN GEAR LEVER WAS MOVED TO NEUTRAL OFF POSITION AFTER TAKEOFF. THE NOSEGEAR ONLY, EXTENDED. AIRSPEED WAS BELOW 230 FOR BOTH THE EXTENSION AND RETRACTION, LANDING GEAR HANDLE WAS NOT MOVED BEYOND OFF DURING THE ANOMALOUS EXTENSION. **SUSDR AALA202404308445Slide · out of positionAIRCRAFT WAS GROUNDED: AFTER GATE ARRIVAL UPON OPENING 1L PASSENGER DOOR, THE SLIDE FELL OUT OF THE BUSTLE AND ONTO THE RAMP. **SUPPLEMENTAL REPORT FOR (AALA202404268445): INSTALLED NEW SLIDE ASSEMBLY ON L1 DOOR. PER JOB CARD 08L22125001**(CLOSED).SDR AALA202404303142Control Rod · out of adjustAIRCRAFT WAS GROUNDED: 1L DOOR WAS VERY DIFFICULT FOR THE AGENT TO OPEN ON ARRIVAL.**SUPPLEMENTAL REPORT FOR (AALA202404263142): ADJUSTED HORIZONTAL CONTROL ROD, OPERTIONAL CHECK GOOD NO DEFECTS NOTED AT THIS TIME. PER AMM 52-11-00-820-801**(CLOSED).SDR AALA202404291912Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD OF FLOORBEAM AT STA 986, LBL 43. REPAIRED FLOORBEAM PER SRM 53-70-51-2R REPAIR 6 ALTERNATIVE 4 AND SRM 53-70-51-2R.SDR AALA202404263232Fuel Filter · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: FILTER BYPASS LIGHT NUMBER 2 ENGINE ILLUMINATED IN FLIGHT; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. REMOVED AND REPLACED NUMBER 2 ENGINE FUEL FILTER (AALA202404263232) AND FUEL FILTSDR AALA202404261990Pressure Switch · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: FILTER BYPASS LIGHT NUMBER 2 ENGINE ILLUMINATED IN FLIGHT; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. REMOVED AND REPLACED NUMBER 2 ENGINE FUEL FILTER (AALA202404263232) AND FUEL FILTSDR AALA202404268445Slide · dislodgedAIRCRAFT WAS GROUNDED: AFTER GATE ARRIVAL UPON OPENING 1L PASSENGER DOOR, THE SLIDE FELL OUT OF THE BUSTLE AND ONTO THE RAMP.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404268467Door · unknownAIRCRAFT WAS NOT GROUNDED: CHRONIC HISTORY (3/7) FLIGHT DECK DOOR DIFFICULT TO OPEN AND CLOSE. (OPEN).SDR AALA202404263916Tube · missingAIRCRAFT WAS NOT GROUNDED: RED SLEEVE MISSING FROM GIRT BAR ON ONE OF THE AFT CABIN DOORS. INSTALLED RED HEAT SHRINK AS REQUIREDSDR AALA202404264647Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR EXTREMELY DIFFICULT TO OPEN OR CLOSE. LUBRICATED FLIGHT DECK DOOR.SDR AALA202404263142Door · unknownAIRCRAFT WAS GROUNBDED: 1L DOOR WAS VERY DIFFICULT FOR THE AGENT TO OPEN ON ARRIVAL. (OPEN).SDR AALA202404266693Unknown · unknownAIRCRAFT WAS GROUNDED: WHEN GEAR LEVER WAS MOVED TO NEUTRAL OFF POSITION AFTER TAKEOFF. THE NOSEGEAR ONLY, EXTENDED. AIRSPEED WAS BELOW 230 FOR BOTH THE EXTENSION AND RETRACTION, LANDING GEAR HANDLE WAS NOT MOVED BEYOND OFF DURING THE ANOMALOUS EXTENSION. (OPSDR AALA202404259249Bear Strap · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN L1 DOOR SURROUND STRUCTURE BEAR STRAP AT BS 293, FROM S8R TO S9R. REPAIRED BEAR STRAP PER EA 352854 AND SRM 53-10-01-2R-6.SDR AALA202404306249Tube · missingAIRCRAFT WAS NOT GROUNDED: 2L GIRT BAR MISSING RED EDGE. **SUPPLEMENTAL REPORT FOR (AALA202404256249): REINSTALLED RED HEAT SHRINK TUBING ON 2L GIRT BAR. PER JOB CARD 2523J012-001. **(CLOSED).SDR AALA202404259178Latch · faultyAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR JAMS WHEN SHUT. SHORTENED LATCHING PINS ON LAVATORY DOOR AS REQUIRED. LAVATORY DOOR OPENS AND CLOSES NORMALLY.SDR AALA202404257536Tube · missingAIRCRAFT WAS NOT GROUNDED: RED HEAT SHRINK ON R2 DOOR NEEDS REPLACEMENT. REPLACED RED HEAT SHRINK ON R2 DOOR. PER AARD 25-66-00-4 STEP (6)(G).SDR AALA202404256249Girt Bar · abnormalAIRCRAFT WAS NOT GROUNDED: 2L GIRT BAR MISSING RED EDGE. OPENSDR AALA202405130531Lug · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND HORIZONTAL STABILIZER REAR SPAR LUG, LOWER AFT SIDE. REPAIRED LUG PER SB 737-55-1074, EA 354167, AND SRM 51-20-06.SDR AALA202404308353Latch · unknownAIRCRAFT WAS NOT GROUNDED: CHRONIC HISTORY AFT LEFT LAVATORY DOOR LATCH INOPERTIVE. PERFORMED FUNCATIONAL CHECK OF AFT LAVATORY DOOR, NO FAULT FOUND. PER CMM 25-40-64.SDR AALA202404254293Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WINGLET UPPER LEADING EDGE PANEL AT WS 750, WBL 680.40. REPLACED PANEL PER SRM 51-40-02-0G.SDR AALA202404253737Warning Message · false indicationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: POSSIBLE FUEL LEAK ON MAIN TANK 1, DURING TAKEOFF LOST 1800LBS IN LESS THAN 2 MINUTES, FUEL IMBAL INDICATION IN TANK 1 SHOWED UP. AIRCRAFT AIR INTERRUPTED TO AND LANDED SAFELY AT LAX. ACCOMPLISHED SDR AALA202404259531Oven · odorAIRCRAFT WAS GROUNDED: CABIN ODOR IN FORWARD PART OF AIRCRAFT. FOUND FORWARD GALLEY OVEN NUMBER 2 TO BE EMITING OZONE SMELL AFTER HEATING OVEN. **SUPPLEMENTAL REPORT FOR (AALA202404249531): REMOVE AND REPLACED OVEN. PER AMM 25-32-03**(CLOSED).SDR AALA202404240850Bumper · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR GIRT BAR PLASTIC BUMPER LOOSE. RE-SECURED GRIT BAR RELEASE STOP ASSEMBLY. PER AMM 25-66-01.SDR AALA202404241192Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: MAIN CABIN DOOR GUST LOCK WOULD NOT RELEASE. CLEANED AND LUBED GUST LOCK LINKAGE AND TRACK, OPERTIONAL CHECK NORMAL. PER AMM 52-11-00.SDR AALA202404241448Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO FULLY OPEN. LUBRICATED FLIGHT DECK DOOR. PER AMM 12-25-11.SDR AALA202404248353Latch · inoperativeAIRCRAFT WAS NOT GROUNDED: CHRONIC HISTORY AFT LEFT LAVATORY DOOR LATCH INOPERTIVE.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404246767Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR AND DOOR LOCK STICKING. LUBRICANTED AFT LEFT LAVATORY DOOR LOCK.SDR AALA202404241324Brake Assy · bindingAIRCRAFT WAS NOT GROUNDED: DURING PUSH BACK GROUND CREW OBSERVED VIBRATION ON THE LEFT MAINGEAR. FOUND NUMBER 1 BRAKE JAMMED. REPLACED NUMBER 1 BRAKE ASSEMBLY. PER AMM 32-41-11.SDR AALA202404249531Oven · odorAIRCRAFT WAS GROUNDED: CABIN ODOR IN FORWARD PART OF AIRCRAFT. FOUND FORWARD GALLEY OVEN NUMBER 2 TO BE EMITING OZONE SMELL AFTER HEATING OVEN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404243737Fuel Sys · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: POSSIBLE FUEL LEAK ON MAIN TANK 1, DURING TAKEOFF LOST 1800LBS IN LESS THAN 2 MINUTES, FUEL IMBAL INDICATION IN TANK 1 SHOWED UP. AIRCRAFT AIR INTERRUPTED TO AND LANDED SAFELY AT LAX. **SUPPLEMENTAL SDR AALA202404242946Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: L2 EMERGENCY LIGHT INOPERATIVE. REMOVE AND REPLACED BULB. PER B737NG AMM 33-51-04.SDR AALA202405018037Fuel Tank · fodAIRCRAFT WAS GROUNDED: DURING CLIMB OUT, FUEL IMBALANCE WITH LEFT MAIN TANK SHOWING 800POUNDS LOW, WHICH WORSENED TO GREATER THAN 1000 POUNDS AND CAUSED IMBALANCE INDICATION. FOUND FOD IN THE FUEL TANKS, REMOVED FOD AND CLEAN TANKS; CHECK CONDITION OF ALL COMSDR AALA202404305868Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATROY-D LATCH BENT. PASSENGERS ARE HAVING A DIFFICULT TIME GETTING OUT OF LAVATORY. **SUPPLEMENTAL REPORT FOR (AALA202404235868): ADJUSTED AND INSTALLED MISSING HARDWARE ON LAVATORY DOOR. PER CMM 25-48-48 OPS CHECK OK **(CLOSED).SDR AALA202404261223Oven · shortedAIRCRAFT WAS NOT GROUNDED: CIRCUIT BREAKER FOR THE OVEN NUMBER 2 IN THE FORWARD GALLEY POPPED AND FLIGHT ATTENDANTS REPORTED SMELLING FUMES. REMOVED AND REPLACED NUMBER 2 OVEN. PER AMM 25-32-03.SDR AALA202404245163Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: EXTERIOR OVERWING AFT RIGHT HAND LIGHT IS INOPERATIVE. REMOVED AND REPLACED EXTERIOR OVERWING AFT RIGHT HAND LIGHT LAMP. PER B737-NG AMM 33-51-01-960-801.SDR AALA202404235868Latch · bentAIRCRAFT WAS NOT GROUNDED: LAVATROY-D LATCH BENT. PASSENGERS ARE HAVING A DIFFICULT TIME GETTING OUT OF LAVATORY. (OPEN).SDR AALA202404235200Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKS CLOSED. ADJUSTED FORWARD LAVATORY DOOR LOCK PERFORMED. FUNCATIONAL CHECK GOOD. PER 25-40-01.SDR AALA202404238037Fuel Sys · unbalancedAIRCRAFT WAS GROUNDED: DURING CLIMB OUT, FUEL IMBALANCE WITH LEFT MAIN TANK SHOWING 800POUNDS LOW, WHICH WORSENED TO GREATER THAN 1000 POUNDS AND CAUSED IMBALANCE INDICATION. OPENSDR AALA202404231454Sign · dislodgedAIRCRAFT WAS GROUNDED: SEAT 17A EMERGENCY EXIT LIGHT HAS BEEN RIPPED OFF OF THE WALL. ACCOMPLISHED WIRE REPAIR (AALA202404230550), PER SWPM 20-30-12 AND WDM 33-51-21. REMOVED AND REPLACED EMERGENCY EXIT SIGN LIGHT ASSEMBLY (AALA202404231454), PER AMM 33-51-01.SDR AALA202404230550Wire · cutAIRCRAFT WAS GROUNDED: SEAT 17A EMERGENCY EXIT LIGHT HAS BEEN RIPPED OFF OF THE WALL. ACCOMPLISHED WIRE REPAIR (AALA202404230550), PER SWPM 20-30-12 AND WDM 33-51-21. REMOVED AND REPLACED EMERGENCY EXIT SIGN LIGHT ASSEMBLY (AALA202404231454), PER AMM 33-51-01.SDR AALA202404220832Door Latch · lack of lubeAIRCRAFT IN BASE MAINTENANCE: FORWARD LAVATORY LATCH IS DIFFICULT TO LOCK AND UNLOCK. CLEANED LATCH LOCKING BOLT AND APPLIED LUBRICANT. CYCLED LOCK WITH DOOR OPEN AND CLOSED AND CYCLED FROM EMERGENCY ACCESS COVER. OPERATION OF LOCK IS SMOOTH AND OPERATES EASILSDR AALA202404220367Door · out of adjustAIRCRAFT IN BASE MAINTENANCE: LAVATORY-D LOCK IS DIFFICULT TO LOCK AND UNLOCK. ADJUSTED DOOR, OPERTIONAL CHECKED GOOD. PER AMM 25-40-14.SDR AALA202404222291Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN HAS BEEN REMOVED FROM THE CEILING SIGN AROUND ROW 16. RE-ATTACHED FORWARD EMERGENCY CEILING LIGHT LENS AT ROW 16. PER AMM 33-51-01.SDR AALA202404228211Door Sill · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS STICKY AND HARD TO OPEN AND CLOSE. FOUND FORWARD LAVATROY DOOR LOWER DOOR SILL 2EA SCREWS STICKING UP AND LOOSE. SECURED SCREWS AS REQUIRED. OPERTIONAL CHECKED OKAY.SDR AALA202404225076Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540 FROM BL 0 TO LBL 24. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-40-02-0G.
Back to Boeing 737-823