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 AALA202312182997Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STR 23L BETWEEN STA 285.62 AND STA 344. REPAIRED STRINGER PER EA 349501 AND SRM 51-40-02-0G.SDR AALA202312155675Battery · no testAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDAB RIGHT HAND INBOARD FLASHLIGHT DID NOT PASS TEST. MAINTENANCE REPLACED THE FLASHLIGHT BATTERIES AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA202312143459Trim Panel · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT THAT THE LEFT AFT LAVATORY DOOR IS BROKE. MAINTENANCE FOUND THE LAVATORY DOOR CATCHING ON THE BOTTOM AND RE-ADJUSTED THE BOTTOM TRIM. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.SDR AALA202312145396Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT SERVICE DOOR HANDLE RAISES OUT OF THE STOWED POSITION AFTER TAKE OFF. HANDLE WILL NOT GO TO THE STOWED POSITION UNTIL DEPRESSURIZED AFTER LANDING. NO FLIGHT DECK INDICATIONS. MAINTENANCE ADJUSTED THE LEFT AFT SERVICE DOOR ASDR AALA202312141625Stop Fitting · out of adjustAIRCRAFT WAS GROUNDED: LEFT AFT ENTRY DOOR HANDLE KEEPS LIFTING AFTER BEING PUSHED DOWN. MAINTENANCE ADJUSTED THE LEFT AFT ENTRY DOOR STOP AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK WITH NO DEFECTS NOTED.SDR AALA202312148566Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN OR CLOSE. MAINTENANCE ADJUSTED LAVATORY DOOR LATCH AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA202312141233Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW DUE TO THE GEAR WOULD NOT RETRACT WHEN THE GEAR HANDLE IS PLACED IN THE UP POSITION. THE AIRCRAFT LANDED SAFELY WITHOUT FURTHER INCIDENT AND TAXIED TO THE GATE UNDER ITS OWN POWESDR AALA202312201563Oven · contaminatedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS THE NUMBER 2 OVEN IN FIRST CLASS GALLEY, HAS A VERY STRONG ODOR OF BURNING PLASTIC, WHEN TURNED ON.**SUPPLEMENTAL REPORT FOR AALA202312131563: REPLACED NUMBER 2 OVEN PER AMM 25-32-03.**(CLOSED)SDR AALA202312185891Frame · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER FORWARD SPAR SLIDING SEAL TRACK FRAME WORN, LOCATED AT BS 1090, LBL 48. REPLACE GUIDE RAIL FRAME PER AARD 51-00-05-01 AND DWG 181A8010.SDR AALA202312135663Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS REPORTED TO BE VERY DIFFICULT TO OPERATE. ADJUSTED AFT LEFT LAVATORY DOOR PER AMM 25-40-64.SDR AALA202312131727Door · out of adjustAIRCRAFT WAS NOT GROUNDED: CREW REPORTS LEFT HAND AFT LAVATORY DOOR STICKS AND IS DIFFICULT TO OPEN. ADJUSTED LAVATORY "D" DOOR PER CMM 25-40-64. OPERATIONAL CHECK GOOD.SDR AALA202312138774Cable · disconnectedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS AT SEATS ROW 9C TO 15C INOPERATIVE. FOUND SEAT-TO-SEAT CABLE ASSEMBLY (4NS047-2060 P1) DISCONNECTED. RECONNECTED CABLE AT SEAT 9ABC OF M2287. PERFORMED EMERGENCY LIGHT OPERATIONAL TEST PER AMM 33-51-00. OPERATIONAL CSDR AALA202312136610Tube · missingAIRCRAFT WAS NOT GROUNDED: RED TUBING ON FORWARD ENTRY GIRT BAR IS MISSING. INSTALLED RED HEAT SHRINK ON FORWARD ENTRY DOOR GIRT BAR.SDR AALA202312131563Unknown · unknownAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS THE NUMBER 2 OVEN IN FIRST CLASS GALLEY, HAS A VERY STRONG ODOR OF BURNING PLASTIC, WHEN TURNED ON.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202312206086Unknown · unknownAIRCRAFT WAS NOT GROUNDED: FOUND ALL FOUR OVER WING EMERGENCY EXIT ROW LIGHTS INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202312136086: PERFORMED SATISFACTORY OPERATIONAL TEST OF EMERGENCY LIGHTS PER AMM 33-51-00.**(CLOSED).SDR AALA202312206941Tube · missingAIRCRAFT WAS NOT GROUNDED: RED MARKING MISSING FROM R2 GIRT BAR.**SUPPLEMENTAL REPORT FOR AALA202312136941: INSTALLED HEAT SHRINK ON TO R2 GIRT BAR PER AARD 25-66-00-4.**(CLOSED).SDR AALA202312133209Handle · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY "A" DOOR HARD TO OPEN AND CLOSE. CLEANED AND LUBED FORWARD LAVATORY DOOR HANDLE ASSEMBLY PER AMM 12-25-41.SDR AALA202312131920Switch · damagedAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LATCH INOPERATIVE. REPLACED DAMAGED DOOR SWITCH PER AMM 33-26-03.SDR AALA202312133269Flashlight · missingAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDANT AISLE FLASHLIGHT MISSING. INSTALLED NEW FLASH LIGHT ON AFT LEFT HAND COMPARTMENT PER AMM 25-64-00.SDR AALA202312136941Unknown · unknownAIRCRAFT WAS NOT GROUNDED: RED MARKING MISSING FROM R2 GIRT BAR.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202312136086Unknown · unknownAIRCRAFT WAS NOT GROUNDED: FOUND ALL FOUR OVER WING EMERGENCY EXIT ROW LIGHTS INOPERATIVE.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202312123298Light · looseAIRCRAFT WAS GROUNDED: REF MIC 1034965 25D EXIT PATH LIGHTING WIRES BROKEN. FOUND LIGHT LOOSE RESECURED, PER AMM 33-20-00.SDR AALA202312202926Engine · vibrationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO HIGH ENGINE VIBRATION FELT ON RIGHT ENGINE 5.0 INDICATION. AIRCRAFT LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT FOR AALA202312112926: RIGHT ENGINE REPLACED PER JOB CARD 08L4007200SDR AALA202312133287Gusset · crackedAIRCRAFT IN BASE MAINTENANCE: 1 INCH CRACK IN GUSSET LOCATED AT BS 500I AND STR 19R. REMOVED AND REPLACED GUSSET PER AARD 51-00-05-1 BOEING DRAWING 143A7902.SDR AALA202312126894Transmitter · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAPS AND SLAT INDICATION ISSUES PREVENTED AIRCRAFT AUTOPILOT TO ENGAGE CORRECTLY. AIRCRAFT RETURN TO AND LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. REMOVED AND REPLACED RIGHT HAND FLAP TRANSMITTER. SDR AALA202312118617Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD ELECTRICAL / ELECTRONIC EQUIPMENT COMPARTMENT WEB FROM BS 330 TO BS 344 AT S23L. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202312116019Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD ELECTRICAL / ELECTRONIC EQUIPMENT COMPARTMENT FRAME ASSEMBLY AT BS 335, BETWEEN S21L AND S23L. REPLACED FRAME ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202312112926Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HIGH ENGINE VIBRATION FELT ON RIGHT ENGINE 5.0 INDICATION. AIRCRAFT LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202312112947Guide Arm · looseAIRCRAFT WAS GROUNDED: L1 DOOR WILL NOT OPEN. FOUND L1 DOOR GUIDE ARM RADIUS LINKS PIN SCREW LOOSE IN GUIDE ARM TRACK. REMOVE AND REPLACED GUIDE ARM RADIUS LINKS PIN, WASHERS, AND SCREW PER AMM 52-11-21. OPERATIONAL CHECK GOOD.SDR AALA202312114012Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312117249Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312117186Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00 REPAIR 1.SDR AALA202312113119Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312116802Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312117970Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312112594Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312116440Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312119362Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312114636Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312147132Connector · crossedAIRCRAFT WAS GROUNDED: #3 RIGHT MAIN TIRE WAS DISCOVERED BLOWN BY MAINTENANCE UPON BLOCK IN. GUSTY CONDITIONS ON APPROACH AND TOUCH TOWN, BUT NO HARD LANDING. DID NOT FEEL ABNORMAL OR PULL TO SIDE WHILE TAXIING TO GATE. MAINTENANCE ACCOMPLISHED A TIRE BURST ANSDR AALA202312126756Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663.5, RBL 2. REPAIRED ATTACH ANGLE PER SRM 57-10-10-2R-5.SDR AALA202312126219Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663.5, LBL 2. REPAIRED ATTACH ANGLE PER SRM 57-10-10-2R-5.SDR AALA202312119162Cartridge · looseAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY BIFOLD DOOR DIFFICULT TO OPEN AND CLOSE. FOUND DOOR TENSION A LITTLE LOOSE, ADJUSTED SPRING CARTRIDGE TO HIGH SETTING PER CMM 25-40-58.SDR AALA202312112257Roller · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR HARD TO OPEN. REMOVED AND REPLACED UPPER ROLLER (AALA202312112257) AND SPRING ASSEMBLY (AALA202312119040) PER CMM 25-40-58.SDR AALA202312119040Spring · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR HARD TO OPEN. REMOVED AND REPLACED UPPER ROLLER (AALA202312112257) AND SPRING ASSEMBLY (AALA202312119040) PER CMM 25-40-58.SDR AALA202312110983Screw · backed outAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY DOOR DOES NOT FULLY OPEN. FOUND ONE SCREW SLIGHTLY PROTRUDING INTO UPPER CHANNEL IMPEDING DOOR UPPER ROLLER. TIGHTENED SCREW. OPERATIONAL CHECK NORMAL.SDR AALA202312116892Faucet · detachedAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LAVATORY FAUCET CAME OFF, UNCONTROLLABLE WATER SPRAYING EVERYWHERE. AIRCRAFT DIVERTED AND LANDED SAFELY AT MEM WITHOUT FURTHER INCIDENT. INSTALLED NEW FAUCET IN LEFT AFT LAVATORY CHECK AND LEAK CHECKSDR AALA202401058332Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM UPPER CHORD (T-CAP) NEAR AFT LAVATORY MOUNT AT BS 947.5, LBL 24. REPLACED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202312137633Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: INTERCOSTAAL UNDER FLOODBOARD AT STA 285 AND BL 0 IS CRACKED. REMOVED AND REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202312136080Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FLOOR SUPPORT AT BS 349 BL 0 IS CRACKED NEAR FASTENER HOLE. REMOVED AND REPLACED INTERCOSTAAL PER AARD 51-00-05-1.
Back to Boeing 737-823