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 AALA202507088422Acm · failedAIRCRAFT WAS GROUNDED: SMOKE AND FUME IN FLIGHT DECK REACHING 15,000FT IN CONJUNCTION WITH A LEFT PACK FAIL AFTER TAKEOFF. REMOVED AND REPLACED (ACM)-AIR CYCLE MACHINE. PER AMM 21-51-04. OPERATIONAL CHECKED GOOD.SDR AALA202507147481Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF AFT GALLEY SHEAR WEB AT BS 986, RBL 32. REPAIRED WEB PER EA 366091.SDR AALA202507119437Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663.5, RBL 2. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202507087397Elec Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY AISLE LIGHT AT SEAT 18ABC WILL NOT ILLUMINATE. FOUND CANNON PLUG DISCONNECTED, REONNECTED, PER SWPM 20-60-06. OPERATIONAL CHECK GOOD.SDR AALA202507086850Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFTER LAVATORY-D DIFFICULT TO OPEN AND CLOSE. ADJUSTED AFT LAVATORY-D LATCH. PER CMM 25-40-64. OPERATIONAL CHECK GOOD.SDR AALA202507084723Wire · disconnectedAIRCRAFT IN BASE MAINTENANCE: AFT LEFT HAND L2 DOOR EMERGENCY EXIT LIGHT NOT WORKING REMOVED LIGHT ASSEMBLY AND FOUND IT WAS DISCONNECTED. CONNECTED AND REINSTALLED LIGHT ASSEMBLY. PER AMM 33-51-01. PERFORMED OPERATIONAL CHECK AND IT WAS GOOD.SDR AALA202507085307Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: AIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER AT STA 663.75, LBL 30. ACCOMPLISHED REPAIR PER AARD 57-10-10-9.SDR AALA202507142738Bracket · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT VACUUM WASTE TANK ENCLOSURE SUPPORT BRACKET AT BS 867. REPLACED BRACKET PER AARD 51-00-05-1.SDR AALA202507083269Handle · bindingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS HANDLE OF THE DOOR ON AFT RIGHT LAVATORY-E IS DIFFICULT TO OPEN. CONFIRMED RIGHT AFT DOOR INTERMITTENT HARD TO OPEN, SEEMS HINGE MAY BE WORN. REMOVED AND REPLACED LAVATORY-E DOOR HANDLE. PER AARD 25-40-10. OSDR AALA202507085591Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, RBL 10. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202507083174Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, LBL 10. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202507028480Fitting · wornAIRCRAFT IN BASE MAINTENANCE: GIRT BAR APRON WORN ON R1 DOOR SLIDE. REPAIRED GIRT BAR APRON ON R1 DOOR SLIDE. PER AARD 25-66-00-2SDR AALA202507024304Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF, FLIGHT ATTENDANTS CALLED AND SAID THERE WAS A VERY STRONG SMELL IN THE CABIN. CONTINUED TO CLIMB AND LEVEL AT FL260, THE SMELL NEVER WENT AWAY. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SDR AALA202507023269Door · bindingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS HANDLE OF THE DOOR ON AFT RIGHT LAV IS DIFFICULT TO OPEN. CONFIRMED RIGHT AFT DOOR INTERMITTENT HARD TO OPEN, SEEMS HINGE MAY BE WORN. (OPEN).SDR AALA202507026786Light · detachedAIRCRAFT WAS NOT GROUNDED: THE EMERGENCY LIGHT UNDER SEAT 25C HAS FALLEN TO THE FLOOR. RESECURED EMERGENCY LIGHTS IN 25C. PER AMM 33-50-00.SDR AALA202507021406Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: L1 PASSENGER DOOR GERT BAR MOUNTS HARD TO RELEASE BAR. LUBED L1 DOOR SLIDE CLIPS AND FLOOR BRACKETS, OPERATIONAL CHECK GOOD. PER AMM 25-66-02.SDR AALA202507104447Girt Bar · frayedAIRCRAFT IN BASE MAINTENANCE: ESCAPE SLIDE PACK FOR R1 DOOR GIRT IS FRAYING AND WORN. REPLACED R1 SLIDE PACK WITH NEW 8130 SLIDE PACK. PER TASK CARD 08L22125001.SDR AALA202507017427Elec Connector · unsecureAIRCRAFT WAS NOT GROUNDED: SEAT 16F EXIT LIGHT FLICKERING. SECURED CONNECTION AT 16F SIDEWALL LIGHT AND OPERATIONAL CHECK IS GOOD. PER AMM 33-20-00.SDR AALA202507117393Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, LBL 7. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202507023349Memory Device · failedAIRCRAFT WAS NOT GROUNDED: SLIGHT BURNING SMELL AND SMALL WISP OF ELECTRICAL SMOKE FROM THE SPINNING NUMBERS ON THE CAPTAIN'S CONTROL COLUMN. LASTED ONLY 5 SECONDS THEN CEASED. REPLACED CAPTAIN'S CONTROL COLUMN MEMORY DEVICE. PER AMM 33-11-00. OPERATIONAL CHESDR AALA202506303349Unknown · odorAIRCRAFT WAS NOT GROUNDED: SLIGHT BURNING SMELL AND SMALL WISP OF ELECTRICAL SMOKE FROM THE SPINNING NUMBERS ON THE CAPTAIN'S CONTROL COLUMN. LASTED ONLY 5 SECONDS THEN CEASED. (OPEN).SDR AALA202506309225Fuse · inoperativeAIRCRAFT IN BASE MAINTENANCE: FORWARD LEFT HAND OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED FUSE IN POWER SUPPLY, OPERATIONAL CHECKED GOOD. PER AMM 33-51-06.SDR AALA202506308957Door · stuckAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR NEEDS ADJUSTMENT, HARD TO OPEN AND CLOSE. FOUND LOOSE SCREW ON DOOR BASEPLATE AND THRESHOLD, TIGHTENED SCREW. PER CMM 25-40-64. OPERATIONAL CHECK GOOD.SDR AALA202506303094Fitting · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT SAID THAT THE GIRT BAR ON THE LEFT AFT ENTRY DOOR IS VERY HARD TO REMOVE AND NEEDS ADJUSTMENT. ADJUSTED AFT LEFT ENTRY DOOR RETAINER CLIPS. PER FIM TASK 52-10-00 AND AMM 52-22-00. OPERATIONAL CHECK GOOD.SDR AALA202506305278Track · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE. LUBRICATED DOOR TRACK. PER CMM 25-40-64. OPERATIONAL CHECK GOOD.SDR AALA202507086224Engine · shutdownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: INFLIGHT ENGINE SHUTDOWN DUE TO LOW OIL PRESSURE ON NUMBER 1 ENGINE. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT CHA. ACCOMPLISHED ENGINE CHANGE.SDR AALA202507080347Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 277 TO BS 294, AR BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202506306224Oil System · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: INFLIGHT ENGINE SHUTDOWN DUE TO LOW OIL PRESSURE ON NUMBER 1 ENGINE. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT CHA. (OPEN).SDR AALA202506307149Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN ROW 15 FELL OFF WALL. RESECURED OVERWING EMERGENCY EXIT SIGN LENS, PER AMM 33-51-01.SDR AALA202506304191Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR STICKS AND IS HARD TO OPEN. INSPECTED AND READJUSTED LAVATORY-D DOOR. PER CMM 25-40-64. OPERATIONAL CHECK GOOD.SDR AALA202506307826Hinge · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR REPORTED HARD TO PULL OPEN OR CLOSED. SECURED LOOSE DOOR HINGE HARDWARE.SDR AALA202507144032Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.9, 17 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202507088645Relay · inoperativeAIRCRAFT WAS GROUNDED: LEFT MAIN AFT FUEL PUMP WILL NOT SHUT OFF. REMOVED AND REPALCED GFI RELAY R18. PER AMM 28-22-18. OPERATIONAL CHECK OF RELAY AND LOW PRESSURE SWITCH GOOD. PUMP WORKING PROPERLY. PER AMM 28-42-11.SDR AALA202506304348Processor · inaccurateAIRCRAFT WAS GROUNDED: ON TAKEOFF, WITH 2200LBS IN CENTER TANK, WE NOTICED THE CENTER FUEL QUANTITY RAPIDLY DECREASING AS WE PASSED BY 7,000FT, CENTER TANK RAPIDLY FELL TO 0.0 LBS INDICATED. WE RECEIVED A FMS MESSAGE 'VERIFY GROSS WEIGHT AND FUEL' - WITH NO WASDR AALA202506304331Float Switch · inaccurateAIRCRAFT WAS GROUNDED: ON TAKEOFF, WITH 2200LBS IN CENTER TANK, WE NOTICED THE CENTER FUEL QUANTITY RAPIDLY DECREASING AS WE PASSED BY 7,000FT, CENTER TANK RAPIDLY FELL TO 0.0 LBS INDICATED. WE RECEIVED A FMS MESSAGE 'VERIFY GROSS WEIGHT AND FUEL' - WITH NO WASDR AALA202506307238Compensator · fault messageAIRCRAFT WAS GROUNDED: ON TAKEOFF, WITH 2200LBS IN CENTER TANK, WE NOTICED THE CENTER FUEL QUANTITY RAPIDLY DECREASING AS WE PASSED BY 7,000FT, CENTER TANK RAPIDLY FELL TO 0.0 LBS INDICATED. WE RECEIVED A FMS MESSAGE 'VERIFY GROSS WEIGHT AND FUEL' - WITH NO WASDR AALA202506306150Probe · fault messageAIRCRAFT WAS GROUNDED: ON TAKEOFF, WITH 2200LBS IN CENTER TANK, WE NOTICED THE CENTER FUEL QUANTITY RAPIDLY DECREASING AS WE PASSED BY 7,000FT, CENTER TANK RAPIDLY FELL TO 0.0 LBS INDICATED. WE RECEIVED A FMS MESSAGE 'VERIFY GROSS WEIGHT AND FUEL' - WITH NO WASDR AALA202506302917Probe · fault messageAIRCRAFT WAS GROUNDED: ON TAKEOFF, WITH 2200LBS IN CENTER TANK, WE NOTICED THE CENTER FUEL QUANTITY RAPIDLY DECREASING AS WE PASSED BY 7,000FT, CENTER TANK RAPIDLY FELL TO 0.0 LBS INDICATED. WE RECEIVED A FMS MESSAGE 'VERIFY GROSS WEIGHT AND FUEL' - WITH NO WASDR AALA202506302410Engine · overtempAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: EGT OVER TEMP ON THE NUMBER 2 ENGINE. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT DFW. ACCOMPLISHED AMM 71-00-00-800-804-F00 AND CONTACTED ENGINE DESK FOUND NUMBER 2 ENGINE EXCEEDANCE IN AREA "B" NO EEC FASDR AALA202506308645Pump · malfunctionedAIRCRAFT WAS GROUNDED: LEFT MAIN AFT FUEL PUMP WILL NOT SHUT OFF. (OPEN).SDR AALA202506305216Handle · excess playAIRCRAFT WAS NOT GROUNDED: EXTERNAL EMERGENCY EXIT RELEASE HANDLE FOR NUMBER 2 COCKPIT WINDOW HAS EXCESSIVE PLAY AND DOES NOT SIT FLUSH TO FUSELAGE SKIN. REMOVE AND REPLACE EXTERNAL EMERGENCY EXIT RELEASE HANDLE FOR NUMBER 2 COCKPIT WINDOW, PER AMM 56-12-11.SDR AALA202506301950Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: SEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE FROM ROW 22ABC TO 25ABC. FOUND P1 CONNECTOR ON SEAT 22ABC DISCONNECTED. CONNECTED P1 CONNECTOR FOR FLOOR MOUNTED EMERGENCY LIGHTS. OPERATIONAL CHECKS ARE GOOD. PER WDM 33-51-22 AND AMM 33-SDR AALA202506303952Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. ADJUSTED LAVATORY-D DOOR. PER AMM 25-40-14. OPERATIONAL CHECK GOOD.SDR AALA202506301670Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR WAS DIFFICULT TO OPEN OR CLOSE. LUBRICATED FLIGHT DECK DOOR LATCH. PER AMM 52-51-02. OPERATIONAL TEST GOOD.SDR AALA202507223346Sleeve · missingAIRCRAFT IN BASE MAINTENANCE, R1 DOOR ESCAPE SLIDE GIRT BAR NYLON CLIP MISSING OUTER SLEEVE. REMOVED AND REPLACED GIRT BAR NYLON SLEEVE IAW AMM 25-66-01 SUB TASK 020-005.SDR AALA202507219324Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO SHEAR TIE (ANGLE) AT BS 312, S23L. REPLACED SHEAR TIE PER AARD 51-00-05-1 AND EA365984.SDR AALA202507085178Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727 TO BS 767 AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-51.SDR AALA202507085795Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 847 TO BS 867 AT RBL 35. REPLACED TRANSITION PANEL PER AARD 51-00-51.SDR AALA202507085774Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328, AT RBL 32.. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202507021874Tee Angle · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT ECS BAY "T" ANGLE CRACKED AT STA 650 AFT OUTBOARD CORNER OF ECS DOOR 192CL SURROUND STRUCTURE. REMOVED AND REPLACED "T" ANGLE. PER SRM 51-10-02, SRM 51-40-02, AND IPC53-42-00.
Back to Boeing 737-823