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 AALA202412053359Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT BATTERY PACK M1673 FAILED CAPACITY TEST. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK M1673. PER AMM 33-51-06. OPERTIONAL CHECK GOOD.SDR AALA202412053297Fuel Sys · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 1 ENGINE SUSPECTED FUEL LEAKING, CAUSED A FUEL IMBALANCE, HAD TO SHUTDOWN ENGINE PER ORH; AIRCRAFT AIR INTERRUPTED DIVERTED TO AND LANDED SAFELY AT DEN. VERIFIED FUEL QUANTITY LEFT HAND WING TANK SDR AALA202412054178Anti-Ice System · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENIGNE NUMBER 1 ANTI-ICE FAILED WHILE DESCENDING INTO ICING CONDITIONS, HAD TO SHUTDOWN NUMBER 1 ENGINE AS WELL; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT BWI. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OSDR AALA202412055761Skin · delaminatedAIRCRAFT WAS GROUNDED: FOUND DELAMINATION AND EXFOLIATION DUE TO CORROSION WITH THE FOLLOWING DIMENSIONS. 1 INCH WIDE FROM EDGE SKIN TO FORWARD, 5.250 INCHES LONG FROM INBOARD TO OUTBOARD, AND DEPTH 100 % (VERTICAL AXIS) EQUAL TO THE SKIN THICKNESS. 10 INCHES SDR AALA202412206970Light · crackedAIRCRAFT IN BASE MAINTENANCE: G7 CLOSET EMERGENCY LIGHTS ARE CRACKED. REPLACED CRACKED EMERGENCY EXIT LIGHT AT G7 CLOSET AND PERFORMED SATISFACTORY OPERATIONAL CHECK GOOD. PER B737-NG AMM 33-51-14-960-802.SDR AALA202412180220Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM STA 500D TO STA 500I, AT S28R. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202412163204Girt Bar · debondedAIRCRAFT IN BASE MAINTENANCE: RUBBER PROTECTIVE PAD ON GIRT FOR L1 DOOR SLIDE HAS A HOLE AND IS DISBONDING IN TWO LOCATIONS. GIRT HAS A SMALL TEAR. REMOVED AND INSTALLED LEFT HAND NUMBER 1 ESCAPE SLIDE PACK. PER B737NG AMM 25-66-01.SDR AALA202412044587Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ON SEAT 16C IS BROKEN AND JUST HANGING BY THE WIRES. RSECURED EMERGENCY LIGHT ON SEAT 16C AND PERFORMED OPERATIONAL CHECK GOOD. PER AMM 33-51-00.SDR AALA202412041928Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: REPEATED AFT LEFT LAVATORY BIFOLD DOOR CLOSES OVER CENTER RAILING AND STICKS CLOSED. HAD PAX STUCK FOR SEVERAL MINUTES. FLIGHT ATTANDENT HAD TO ASSIST FROM OUTSIDE TO OPEN DOOR. ADJUST TRACK ASSEMBLY AND LUBED UPPER LATCH ASSEMBLY.SDR AALA202412045834Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY BI-FOLD DOOR CLOSES OVER CENTER AND STICKS CLOSED. HAD PAX STUCK FOR SEVERAL MINUTES. CREW MEMBER WAS ABLE TO GET DOOR OPEN. INSPECTED LAVATORY-D BI-FOLDING DOOR FOR PROPERER DOOR OVER CENTER STOP INSTALLATI ON-FOUNSDR AALA202412030694Light · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT HANGING LOOSE FROM CEILING ABOVE SEAT 12D. SECURED WIRE ASSEMBLY. PER AMM 33-51-01.SDR AALA202412030291Slide · out of positionAIRCRAFT WAS NOT GROUNDED: AFT RIGHT EMERGENCY SLIDE CASING NOT FLUSH. REPLACED SLIDE ASSEMBLY. PER AMM 25-66.SDR AALA202412033115Light · burned outAIRCRAFT WAS GROUNDED: DURING CLIMB, SOF FAINT BURNING SMELL DETECTED NEAR ROW 11. ACCOMPLISHED MCM CARD 05-96-70, FOUND, OVERHEAD LED LIGHT ASSEMBLY BURNED OUT, REPLACED LIGHT ASSEMBLY. OPERTIONAL CHECK GOOD. PER AMM 33-22-00.SDR AALA202412032693Fan · failedAIRCRAFT WAS GROUNDED: COMPLY WITH TASK CARD 08L00021001 B737NG SMOKE ODOR FUMES INITIAL TROUBLESHOOTING BEFORE FURTHER FLIGHT. ACCOMPLISHED TASK CARF08L00021. FOUND LEFT HAND RECIRCULATION FAN FINS MOTOR WITH BURNING SMELL. REMOVED AND REPLACED LEFT-HAND RECISDR AALA202412033548Air Filter · odorAIRCRAFT WAS GROUNDED: COMPLY WITH TASK CARD 08L00021001 B737NG SMOKE ODOR FUMES INITIAL TROUBLESHOOTING BEFORE FURTHER FLIGHT. ACCOMPLISHED TASK CARF08L00021. FOUND LEFT HAND RECIRCULATION FAN FINS MOTOR WITH BURNING SMELL. REMOVED AND REPLACED LEFT-HAND RECISDR AALA202412039697Air Filter · odorAIRCRAFT WAS GROUNDED: COMPLY WITH TASK CARD 08L00021001 B737NG SMOKE ODOR FUMES INITIAL TROUBLESHOOTING BEFORE FURTHER FLIGHT. ACCOMPLISHED TASK CARF08L00021. FOUND LEFT HAND RECIRCULATION FAN FINS MOTOR WITH BURNING SMELL. REMOVED AND REPLACED LEFT-HAND RECISDR AALA202412101278Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD LOCATED FROM STA 767 TO STA 787, RBL 48. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202412049889Actuator · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 2 THRUST REVERSE INDICATION ILLUMINATED, HAD TO SHUT DOWN ENGINE NUMBER 2; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT CLT. **SUPPLEMENTAL REPORT FOR (AALA202412029889): REMOVED AND REPSDR AALA202412041566Actuator · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HYDRAULIC SYSTEM-A QUANTITY DECREASED FROM 93% TO 77% WITHIN 5 MINUTES AFTER TAKEOFF. CONTINUED LOSS AT 1% EVERY TEN MINUTES THERE AFTER; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. **SUPPSDR AALA202412022971Screw · looseAIRCRAFT WAS NOT GROUNDED: DOOR 1 L DOOR FRAME GUST LOCK DIFFICULT TO UNLOCK PRIOR TO CLOSING MAIN BOARD DOOR. UPON A CLOSER EXAMINATION FOUND FORWARD ENTRY DOOR GUIDE ARM SCREW LOOSE, RESECURED SCREW. PER AMM 52-11-21.SDR AALA202412028130Module · inoperativeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR WILL NOT UNLOCK WITH FLIGHT DECK DOOR CONTROL SWITCH ON CENTER CONSOLE. REMOVED AND REPLACED COCKPIT DOOR MODULE, OPERTIONAL CHECK GOOD. PER AMM 52-51-07.SDR AALA202412028224Screw · missingAIRCRAFT WAS GROUNDED: FORWARD MAIN ENTRY DOOR WOULD NOT FULLY OPEN UPON GATE ARRIVAL. SENSOR SHOWS OPEN BUT DOOR WILL NOT OPEN FULLY TO ALLOW DEPLANING. REPLACED MISSING SCREWS AND KEYWASHER. PER AMM 52-11-21.SDR AALA202412028214Pseu · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON TAKEOFF MASTER CAUTION ILLUMINATED FOR MULTIPLE DOOR LIGHTS AND CLIMB MASTER CAUTION AND WARNING ILLUMINATED FOR DOOR LIGHTS, TAKEOFF WARNING HORN, AND MULTIPLE AUTOPILOT/AUTO THROTTLE WARNING CAUTIONSDR AALA202412021566Hydraulic System · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HYDRAULIC SYSTEM-A QUANTITY DECREASED FROM 93% TO 77% WITHIN 5 MINUTES AFTER TAKEOFF. CONTINUED LOSS AT 1% EVERY TEN MINUTES THERE AFTER; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. **SUPPSDR AALA202412029889Thrust Reverser · warning messageAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 2 THRUST REVERSE INDICATION ILLUMINATED, HAD TO SHUT DOWN ENGINE NUMBER 2; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT CLT. (OPEN).SDR AALA202412064209Guide Arm · looseAIRCRAFT WAS GROUNDED: FWD ENTRY DOOR HINGE NEAR GUST LOCK. SCREW FELL OUT UPON ARRIVAL WHEN OPENING DOOR. MAINTENANCE INSTALLED SERVICEABLE REPLACEMENT GUIDE ARM IAW AMM 52-11-21. CHECKED ADJUSTMENT OF DOOR IAW AMM 52-11-00.SDR AALA202412060678Oil System · leakingAIRCRAFT WAS GROUNDED: AFTER ENGINE START, AFT GALLEY FLIGHT ATTANDENT REPORTED A SWEET AND BURNING SMELL THAT QUICKLY DISSIPATED. A FEW MINUTES LATER, A STRONG GAS SMELL EMANATED FROM THE AFT PART OF THE AIRCRAFT. APU WAS OFF. FLIGHT DECK TRIED TO ISOLATE BLESDR AALA202412020678Oil System · leakingAIRCRAFT WAS GROUNDED: AFTER ENGINE START, AFT GALLEY FLIGHT ATTANDENT REPORTED A SWEET AND BURNING SMELL THAT QUICKLY DISSIPATED. A FEW MINUTES LATER, A STRONG GAS SMELL EMANATED FROM THE AFT PART OF THE AIRCRAFT. APU WAS OFF. FLIGHT DECK TRIED TO ISOLATE BLESDR AALA202412025581Battery · dischargedAIRCRAFT WAS NOT GROUNDED: AFT F/A FLASHLIGHT DOESN'T TEST. MAINTENANCE REPLACED AFT F/A FLASHLIGHT BATTERY IAW AMM 25-64-00.SDR AALA202412023371Lock Pin · stickingAIRCRAFT WAS NOT GROUNDED: AFT LAV D DOOR IS INOP STICKING. MAINTENANCE ADJUSTED LOWER LOCKING PIN, DOOR OPS CHECK NORMAL IAW AMM 25-40-14.SDR AALA202412019698Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CAPTAIN'S NUMBER 1 WINDOW FRAME. REPAIRED WINDOW FRAME PER ECO J2009AB.SDR AALA202412017724Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FIRST OFFICER'S NUMBER 1 WINDOW FRAME. REPAIRED WINDOW FRAME PER ECO J2009AB.SDR AALA202412027370Sign · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN FOR DOOR 1L FELL OFF DURING TAKEOFF ROLL. INSTALLED DOOR 1L EXIT SIGN. PER AMM 33-51-01.SDR AALA202412028912Window · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: PRESSURE LEAK AT CAPTAINS SLIDING WINDOW; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. ACCOMPLISHED CABIN PRESSURISATION LEAK TEXT ON L2 WINDOW. PER 05-51-91. NO LEAKS NOTED, NO FAULT FSDR AALA202412029578Motor · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ELECTRIC STABILIZER TRIM FAIL ON DEPARTURE; AIRCRAFT DIVERTEDT TO AND LANDED SAFELY AT JFK. INSTALLED STAB TRIM MOTOR, PER AMM 27-41-71. OPERTIONAL CHECKED, PER AMM 27-41-71-700-801 AND AUTOPILOT TEST PESDR AALA202412022678Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: FWD MEGAPHONE WOULD NOT ADJUST PROPERLY TO CARRY SOUND TO THE BACK OF THE PLANE PLUS THERE'S A SHARP EDGE BY THE MOUTHPIECE AT AC RACK.MAINTENANCE REPLACED FWD MEGAPHONE PER MM 25-64-00.SDR AALA202412026388Lamp · burned outAIRCRAFT WAS NOT GROUNDED: LEFT HAND OVERWING AFT EMERGENCY LIGHT INOPERATIVE. FOUND BULB BLOWN, RELAMPED LEFT HAND AFT OVERWING EMERGENCY LIGHT. PER AMM 33-51-04-960-801.SDR AALA202411299253Extinguisher · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND FIRE EXTINGUISHER IN COCKPIT LEAKING. MAINTENANCE REPLACED FLIGHT DECK FIRE EXTINGUISHER IAW AMM 26-26-01.SDR AALA202411296799Stop Fitting · out of adjustAIRCRAFT WAS GROUNDED: L2 DOOR AFT ENTRY LIGHT CAME ON IN FLIGHT. DOOR HANDLE MOVEMENT WITH LIGHT INDICATION AND WOULD NOT REMAIN CLOSED. AIRCRAFT RETURNED TO CMH AND LANDED WITHOUT INCIDENT. MAINTENANCE PERFORMED L2 DOOR, DOOR STOP ADJUSTMENT IAW AMM 52-13-00SDR AALA202411290938Extinguisher · leakingAIRCRAFT WAS GROUNDED: HALON FIRE EXTINGUISHER IN AFT OVERHEAD BIN IS LEAKING HALON. MAINTENANCE REMOVED LEAKING FIRE EXTINGUISHER AND REPLACED WITH SERVICEABLE EXTINGUISHER FROM A/C 3LE IAW AMM 26-26-01.SDR AALA202411290987Proximity Sensor · out of adjustAIRCRAFT WAS GROUNDED: FWD ENTRY DOOR LIGHT ILLUMINATED IN FLIGHT, FA PUSHED HANDLE DOWN AND LIGHT EXTINGUISHED. ON LANDING FA SAW DOOR HANDLE START TOCOME UP SO HELD IT DOWN. GATE AGENT ALSO HAD TROUBLE OPENING DOOR UPON ARRIVAL AT GATE. MAINTENANCE ACCOMPLISDR AALA202412109922Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR LOWER SILL WEB LOCATED FROM STA 767 TO STA 787, AT S24R. REPLACED WEB AARD PER 51-00-05-1.SDR AALA202411295204Door · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY D LOCK IS JAMMED. MAINTENANCE REPLACED THE LAV "D" DOOR IAW CMM 25-40-64.SDR AALA202411298575Plate · looseAIRCRAFT WAS NOT GROUNDED: AFTER LAV LEFT DOOR DIFFICULT TO OPEN AND CLOSE. MAINTENANCE RESECURED LOWER SILL IAW CMM 25-40-64.SDR AALA202411291719Door · unsecureAIRCRAFT WAS NOT GROUNDED: LAV D DOOR IS VERY HARD TO OPEN. MAINTENANCE RE-SECURED LAV D DOOR IAW AMM 25-40-14.GOOD FOR SERVICE.SDR AALA202412186973Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED AT STA 317 AND LBL 11. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202411276616Baffle · damagedAIRCRAFT IN BASE MAINTENANCE: HOLE DAMAGE TO FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE LOCATED AT STA 501, LBL 23. REPLACED BAFFLE PER AARD 51-00-5-1.SDR AALA202411271535Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT STA 540, RBL 24.82, WL 208. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202412048936Elec Connector · not seatedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT ON CEILING AT ROW 12 INOPERATIVE DURING TEST. TROUBLESHOT EMERGENCY LIGHT SYSTEM BY RESEATING D11321 CONNECTOR ON CEILING EMERGENCY LIGHT ASSEMBLY AT ROW12. PER B737-NG WDM33-51-12 AND B737-NG SWPM 20-60-06. PERFORSDR AALA202411299583Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE BETWEEN STA 500C AND STA 500D, LBL 23. REPLACED BAFFLE PER AARD 53-00-01-6 AND SRM 53-30-53-2R-1.
Back to Boeing 737-823