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 AALA202401311190Web · corrodedAIRCRAFT N BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE WEB, FROM BS 987 TO BS 992, FROM RBL 28 TO RBL 40. REPLACED WEB PER 51-40-02-0G.SDR AALA202401300633Holder · dislodgedAIRCRAFT WAS NOT GROUNDED: SEAT 15C SIDE EMERGENCY EXIT LIGHT HANGING OUT. RESECURRED SEAT 15C SIDE EMERGENCY EXIT LIGHT AS REQUIRED.SDR AALA202402284628Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON APU ENCLOSURE WEB AT STA 1121, LBL 18. INSTALLED DOUBLER REPAIR PER SRM 51-70-13.SDR AALA202402235887Door Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON APU ENCLOSURE, DOOR SURROUND STRUCTURE LOWER CHORD BETWEEN BS 1092 AND BS 1143, S23L. INSTALLED REPAIR STRAP PER 351640.SDR AALA202402122532Trim Panel · out of positionAIRCRAFT WAS NOT GROUNDED: REAR LEFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. REPLACED DOOR TRIM PER AMM 25-40-14 AND CMM 25-47-21**(CLOSED).SDR AALA202402095892Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL FROM BS 294.5 TO BS 312, LBL12. REPLACED INTERCOSTAL PER AARD 51-00-05-01 .SDR AALA202402080849Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 947.5 TO BS 967, LBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202402078659Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR ESCAPE SLIDE FLOOR MOUNTED GIRT BAR TIE DOWN AT BS 312, LBL 54. REPLACED TIE DOWN PER AARD 51-00-05-1.SDR AALA202402066764Torque Tube · chafedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: THE FLAPS INDICATED ASYMMETRICAL BETWEEN 0 AND 1, WITH BOTH OUT OF ZERO. AIRCRAFT RETURN TO AND LANDED SAFELY AT MSY WITHOUT FURTHER INCIDENT. REMOVED AND REPLACED RIGHT HAND FLAP TORQUE TUBE MPN 256A3SDR AALA202402069940Turnbuckle · damagedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: THE FLAPS INDICATED ASYMMETRICAL BETWEEN 0 AND 1, WITH BOTH OUT OF ZERO. AIRCRAFT RETURN TO AND LANDED SAFELY AT MSY WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT FOR (AALA202401304708): REMOVED AND RESDR AALA202402068587Torque Tube · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: THE FLAPS INDICATED ASYMMETRICAL BETWEEN 0 AND 1, WITH BOTH OUT OF ZERO. AIRCRAFT RETURN TO AND LANDED SAFELY AT MSY WITHOUT FURTHER INCIDENT. REMOVED AND REPLACED RIGHT HAND FLAP TORQUE TUBE MPN 256A37SDR AALA202402064708Indicator · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: THE FLAPS INDICATED ASYMMETRICAL BETWEEN 0 AND 1, WITH BOTH OUT OF ZERO. AIRCRAFT RETURN TO AND LANDED SAFELY AT MSY WITHOUT FURTHER INCIDENT. REMOVED AND REPLACED RIGHT HAND FLAP TORQUE TUBE MPN 256A37SDR AALA202402065372Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR ESCAPE SLIDE FLOOR MOUNTED TIE DOWN AT BS 344, LBL 58. REPLACED TIE DOWN PER AARD 51-00-05-1.SDR AALA202402063970Tube · missingAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR MISSING RED COVER ON ONE SIDE. INSTALLED SHRINK TUBING ON GIRT BAR. PER AARD 25-66-00.SDR AALA202402063907Probe · faultyAIRCRAFT WAS GROUNDED: CLIMBING THROUGH FLIGHT LEVEL 240 FUEL IMBALANCE ANNUNCIATION CAME ON. REMOVED, REPLACED, AND CAP CHECKED LEFT WING FUEL PROBE NUMBER 10. PER AA B737 AMM 28-41-21 AND CAP CHECKS GOOD OK FOR SERVICE.SDR AALA202401303907Annunciator · activatedAIRCRAFT WAS GROUNDED: CLIMBING THROUGH FLIGHT LEVEL 240 FUEL IMBALANCE ANNUNCIATION CAME ON. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202401300563Slide · dislodgedAIRCRAFT WA NOT GROUNDED: SLIDE ON FORWARD RIGHT DOOR APPEARS TO BE FALLING OUT. REMOVED AND REPLACED SLIDE ON FORWARD RIGHT DOOR. PER WORK CARD 08L22125001. NO OTHER DEFECTS NOTED.SDR AALA202401307158Pin · brokenAIRCRAFT WAS GROUNDED: MAIN CABIN DOOR DIFFICULT TO OPEN FULLY AND UNABLE TO LATCH GUST LOCK. REMOVED AND REPLACED BROKEN PIN ON FORWARD ENTRY DOOR GUILD ARM PER AMM 52-11-21. OPERATIONAL CHECK GOOD.SDR AALA202401304708Flap System · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: THE FLAPS INDICATED ASYMMETRICAL BETWEEN 0 AND 1, WITH BOTH OUT OF ZERO. AIRCRAFT RETURN TO AND LANDED SAFELY AT MSY WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202401302532Door · bindingAIRCRAFT WAS NOT GROUNDED: REAR LEFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202401303970Cover · missingAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR MISSING RED COVER ON ONE SIDE.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202401309460Slide · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORT LOOSE SCREWS ON EMERGENCY SLIDE COVER ON L2 DOOR. TIGHTEN LOOSE SCREWS ON L2 DOOR SLIDE. PER AMM 25-60-00.SDR AALA202401308852Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN DECK WEB FROM STA 420 TO STA 440, RBL 64. REMOVED, FABRICATED, AND INSTALLED CUSP WEB PER SRM 51-40-02-0G.SDR AALA202401305086Intercostal · out of toleranceAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL FROM BS 500H TO BS 500I, S26L.SDR AALA202401306909Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT INTERCOSTAL FROM STA 460 TO STA 480, LBL 26. REPLACED INTERCOSTAL PER SRM 53-00-01-6.SDR AALA202402127077Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT INTERCOSTAL AT BS 727 PLUS 12 INCHES, S25L. SPLICE REPAIRED INTERCOSTAL PER SRM 53-00-53-2R-5.SDR AALA202402084620Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 958, LBL 49.5. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202402085178Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L2 DOOR SILL STRUCTURE INNER CHORD AT BS 979, LBL 57. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202402078633Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR ESCAPE SLIDE FLOOR MOUNTED GIRT BAR TIE DOWN AT BS 344, LBL 59. REPLACED TIE DOWN PER AARD 51-00-05-1.SDR AALA202402075169Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR ESCAPE SLIDE FLOOR MOUNTED GIRT BAR TIE DOWN AT BS 312, LBL 54. REPLACED TIE DOWN PER AARD 51-00-05-1.SDR AALA202402060987Tube · incorrectAIRCRAFT WAS NOT GROUNDED: WHILE ACCOMPLISHING CARD 08C20025006 (DVI-EMERGENCY ESCAPE SLIDE AND PRESSURE BOTTLE) FOUND HEAT SHRINK TUBING ON R1 DOOR SLIDE IS NOT THE CORRECT LENGTH AND IS LOOSE, SLIDING ON GIRT BAR. REPLACED HEAT SHRINK TUBING ON GIRT BAR ON SDR AALA202402060764Tube · missingAIRCRAFT WAS NOT GROUNDED: WHILE ACCOMPLISHING CARD 08C20025006 (DVI-EMERGENCY ESCAPE SLIDE AND PRESSURE BOTTLE) FOUND HEAT SHRINK TUBING MISSING ON ONE END OF GIRT BAR FOR THE R2 SLIDE. REPLACED HEAT SHRINK TUBING ON GIRT BAR ON R2 SLIDE**(CLOSED).SDR AALA202402033744Pin · corrodedAIRCRAFT IN BASE MAINTENANCE: UPON OK TO INSTALL NEW FORWARD TRUNNION BEARING ASSEMBLY AT THE RIGHT WING FRONT SPAR FOUND FORWARD TRUNNION PIN CORRODED. REMOVED AND REPLACED RIGHT MAIN LANDING GEAR FORWARD TRUNNION PIN.SDR AALA202402013744Bearing · corrodedAIRCRAFT IN BASE MAINTENANCE: UPON OK TO INSTALL NEW FORWARD TRUNNION BEARING ASSEMBLY AT THE RIGHT WING FRONT SPAR FOUND FORWARD TRUNNION PIN CORRODED. REMOVED AND REPLACED RIGHT MAIN LANDING GEAR FORWARD TRUNNION PIN.SDR AALA202401307092Interrupter · faultyAIRCRAFT WAS GROUNDED: RIGHT CENTER FUEL PUMP LOW PRESSURE WILL NOT EXTINGUISH WITH SWITCH ON AND 14.0 FUEL IN CENTER TANK. REMOVED AND REPLACED R55 RELAY (AALA202401300308) PER SWPM 20-81-16 AND RIGHT HAND INTERRUPTER (AALA202401307092) PER AMM 28-22-99. OPERSDR AALA202401300308Relay · faultyAIRCRAFT WAS GROUNDED: RIGHT CENTER FUEL PUMP LOW PRESSURE WILL NOT EXTINGUISH WITH SWITCH ON AND 14.0 FUEL IN CENTER TANK. REMOVED AND REPLACED R55 RELAY (AALA202401300308) PER SWPM 20-81-16 AND RIGHT HAND INTERRUPTER (AALA202401307092) PER AMM 28-22-99. OPERSDR AALA202401301857Door · out of adjustAIRCRAFT WAS NOT GROUNDED: CHRONIC HISTORY LAVATORY D DOOR DIFFICULT TO OPEN AND CLOSE.**SUPPLEMENTAL REPORT FOR (AALA202401291857): ADJUST LAVATORY D BIFOLD DOOR CENTER HINGE PIN. PER CMM 25-47-21. OPERATIONAL CHECK GOOD. **(OPEN).SDR AALA202401291355Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY D LOCK DIFFICULT TO LOCK AND UNLOCK. LUBED LAV D DOOR LOCK.SDR AALA202401299615Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR HARD TO OPEN AND CLOSE. LUBED DOOR AT LAV D.SDR AALA202401293893Slide · dislodgedAIRCRAFT WAS GROUNDED: FOUND L1 DOOR SLIDE PARTIALLY OUT OF BUSTLE AND AFT END OF GIRT BAR WAS STILL CONNECTED TO FLOOR FITTING. REPLACED L1 DOOR ESCAPE SLIDE PER WORK CARD 08L22125001.SDR AALA202401291857Door · faultedAIRCRAFT WAS NOT GROUNDED: CHRONIC HISTORY LAVATORY D DOOR DIFFICULT TO OPEN AND CLOSE.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202401290756Transmitter · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: UNABLE TO RETRACT FLAPS FROM 1 TO UP. AIRCRAFT RETURN TO AND LANDED SAFELY AT DFW WITHOUT FURTHER INCIDENT. REMOVE AND REPLACE LEFT FLAP POSITION TRANSMITTER. ALL TEST PASSED. PER AMM 27-58-01.SDR AALA202401290885Coffeemaker · burnedAIRCRAFT WAS GROUNDED: SMELL DESCRIBED AS "BURNING PLASTIC" FROM NUMBER 4 COFFEE MAKER. REPLACED NUMBER 4 COFFEE MAKER. PER AMM 25-32-00. NO SMOKE ODOR DETECTED.SDR AALA202401291915Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR LOCKED AND WILL NOT OPEN WITH ENTRY CODE. LUBRICATED LATCH.SDR AALA202401299943Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: RIGHT FORWARD SERVICE DOOR GIRT BAR DIFFICULT TO PULL FROM UNARMED TO ARMED POSITION. ACCOMPLISHED LUBRICATION AND CLEANED GIRT BAR SLIDE FLOOR ARMING MECHANISM. PER AMM 25-66-01.SDR AALA202401290987Tube · incorrectAIRCRAFT WAS NOT GROUNDED: WHILE ACCOMPLISHING CARD 08C20025006 (DVI-EMERGENCY ESCAPE SLIDE AND PRESSURE BOTTLE) FOUND HEAT SHRINK TUBING ON R1 DOOR SLIDE IS NOT THE CORRECT LENGTH AND IS LOOSE, SLIDING ON GIRT BAR.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPESDR AALA202401290764Tube · missingAIRCRAFT WAS NOT GROUNDED: WHILE ACCOMPLISHING CARD 08C20025006 (DVI-EMERGENCY ESCAPE SLIDE AND PRESSURE BOTTLE) FOUND HEAT SHRINK TUBING MISSING ON ONE END OF GIRT BAR FOR THE R2 SLIDE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202401298910Light · missingAIRCRAFT WAS NOT GROUNDED: ROW 10 EMERGENCY EXIT LIGHT MISSING. REMOVED AND REPLACED EMERGENCY EXIT ROW SEAT LIGHT ROW 10.SDR AALA202401294745Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT TO OPEN. READJUSTED AFT LAVATORY DOOR.SDR AALA202401295474Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE CRACK IN FORWARD CARGO COMPARTMENT INTERCOSTAL ATTACH CLIP AT BS 500D, S26R. REPLACED INTERCOSTAL ATTACH CLIP PER SRM 51-40-02-0G.
Back to Boeing 737-823