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 AALA202403041029Sign · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT ROW SIGN ON CEILING MISSING BACKING ON BACK SIDE. INSTALLED EMERGENCY EXIT SIGN COVER IN PLACE. PER AMM 33-51-14.SDR AALA202403013796Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK FOUND AFT INBOARD FLASHLIGHT INOPERATIVE. REMOVE AND REPLACED AFT INBOARD FLASHLIGHT. PER AMM 25-64-00. FUNCATIONAL CHECK GOOD.SDR AALA202403054849Intercostal · crackedAIRCRAFT IN BASE MAINTENACE: CRACK IN PASSENGER CABIN FLOOR INTERCOSTAL FROM STA 312 TO STA 328, RBL 35. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202403048508Compensator · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENGINE 2 SUSPECTED FUEL LEAK, ENGINE SECURED IN FLIGHT; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ORD.**SUPPLEMENTAL REPORT FOR (AALA202403018508): REPLACED 1 MAIN FUEL QUANTITY COMPENSATOR FSDR AALA202403040313Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY ESCAPE SLIDE, AFT ENTRY AND GALLEY DOOR LIGHT ON LEFT SIDE INOPERATIVE. REMOVED AND REPLACED EMERGENCY ESCAPE SLIDE, AFT ENTRY (AALA202403040313) AND GALLEY DOOR (AALA202403047704) LIGHT BULB AND PERFORMED SATISFACTORY CSDR AALA202403047704Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY ESCAPE SLIDE, AFT ENTRY AND GALLEY DOOR LIGHT ON LEFT SIDE INOPERATIVE. REMOVED AND REPLACED EMERGENCY ESCAPE SLIDE, AFT ENTRY (AALA202403040313) AND GALLEY DOOR (AALA202403047704) LIGHT BULB AND PERFORMED SATISFACTORY CSDR AALA202403012111Tube · missingAIRCRAFT WAS GROUNDED: RED WARNING TRIM ON FORWARD SERVICE DOOR GIRT BAR IS MISSING. INSTALLED RED WARNING SHRINK TUBE ON FORWARD SERVICE DOOR GRIT BAR. PER AMM 25-66-00. OK FOR SERVICE.SDR AALA202403014211Battery · dischargedAIRCRAFT WAS GROUNDED: AFT RIGHT HAND SERVICE DOOR EMERGENCY PATH LIGHTS OUT. PERFORMED POWER SUPPLY BATTERY CHARGING. PER AMM 33-51-06. FOLLOWED FIM TASK 33-50-00-810-801, TEST OF EMERERGENCY LIGHTS GOOD NOW.SDR AALA202403010570Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT AT 1L INOPERATIVE. REMOVED AND REPLACED FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT AT 1L. PER AMM 25-64-00, FUNCATIONAL CHECK GOOD.SDR AALA202403018508Fuel Sys · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENGINE 2 SUSPECTED FUEL LEAK, ENGINE SECURED IN FLIGHT; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ORD. (OPEN).SDR AALA202403058515Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN INTERCOSTAL FROM STA 312 TO STA 328, LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202403044813Pump · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HYDRAULIC A SYSTEM "LOW PRESSURE" LIGHT FOR THE ENGINE PUMP ILLUMINATED DURING CLIMB AND LOST FLUID IN THE A HYDRAULIC SYSTEM; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT CLT. **SUPPLEMENTAL REPORT FOR (AASDR AALA202403014710Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: TOILET EXHAUST PORT SHOWING CORROSION. PERFORMED REPAIR AND REPAINTED TOILET EXHAUST PORT. PER AARD 53-70-00.SDR AALA202402299802Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: MAIN CABIN ENTRY DOOR GUST LOOK DIFFICULT TO RELEASE. CLEANED AND LUBED GUST LOCK.SDR AALA202402299128Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT 19C INOPERATIVE. REINSTALLED EMERGENCY LIGHT AT 19C. PER AMM 33-51-03. OPERTIONAL CHECK GOOD.SDR AALA202402299838Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: FIRST CLASS MEGAPHONE INOPERTIVE. REPLACED FIRST CLASS MEGAPHONE. PER AMM 25-64-00.SDR AALA202402291094Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR NOT SLIDING PROPERLY. ADJUSTED DOOR AT LOCATION AFT LEFT LAVATORY DOOR.SDR AALA202402291137Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND WING TO BODY ON RAM AIR INLET LOCATED AT BS 500I TO 520G, AND STR 22R TO 24R HAS CORROSION ON SKIN. REMOVED CORROSION ON SKIN AT RAM AIR INLET PERFORMED ALL WORK ON EA 350861.SDR AALA202402294813Pump · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HYDRAULIC A SYSTEM "LOW PRESSURE" LIGHT FOR THE ENGINE PUMP ILLUMINATED DURING CLIMB AND LOST FLUID IN THE A HYDRAULIC SYSTEM; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT CLT. **SUPPLEMENTAL REPORT WILL BESDR AALA202403042479Wire · shortedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF MULTIPLE SPARKS AND WHITE SMOKE WERE EMITTING FROM CAPTAIN'S SIDE OF GLARESHIELD PANEL; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT LIR.**SUPPLEMENTAL REPORT FOR (AALA202402282479SDR AALA202403044978Duct · looseAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEFT WING-BODY OVERHEAT LIGHT, MASTER CAUTION. UNABLE TO EXTINGUISH IN FLIGHT; AIRCRAFT AIR DIVERTED TO AND LANDED SAFELY AT IAH. PACK RAM AIR EXHAUST DUCT FOUND LOOSE IN LEFT AC PACK BAY. DUCT CLAMP RSDR AALA202402289540Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 328 TO BS 344, LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05.SDR AALA202402284990Channel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOORBOARD SUPPORT CHANNEL AFT SIDE OF BS 540, WL 208, RBL 2. REPLACED CHANNEL PER SRM 51-40-02.SDR AALA202402288697Channel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOORBOARD SUPPORT CHANNEL AFT SIDE OF BS 540, WL 208, RBL 22. REPLACED CHANNEL PER SRM 51-40-02.SDR AALA202402280321Channel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOORBOARD SUPPORT CHANNEL AFT SIDE OF BS 540, WL 208, LBL 22. REPLACED CHANNEL PER SRM 51-40-02.SDR AALA202402284978Warning Light · illuminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEFT WING-BODY OVERHEAT LIGHT, MASTER CAUTION. UNABLE TO EXTINGUISH IN FLIGHT; AIRCRAFT AIR DIVERTED TO AND LANDED SAFELY AT IAH. (OPEN).SDR AALA202402280232Door · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HANDLE LOOSE ON BOTH SIDES OF DOOR; HARD TO OPEN OR CLOSE. SECURED FORWARD LAVATORY DOOR HANDLES.SDR AALA202402289258Door · looseAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY DOOR JAM HARD TO OPERATE. TIGHTEN LOOSE HARDWARE AT TOP OF AFT LEFT LAVATORY DOOR.SDR AALA202402282479Glare Shield · sparksAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF MULTIPLE SPARKS AND WHITE SMOKE WERE EMITTING FROM CAPTAIN'S SIDE OF GLARESHIELD PANEL; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT LIR.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OSDR AALA202402287533Pump · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENGINE 1 HYDRAULIC PUMP FAILED INFLIGHT; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. REMOVED AND REPLACED NUMBER 1 ENGINE HYDRAULIC PUMP (AALA202402287533). REMOVED AND REPLACE CASE DRAIN SDR AALA202402282139Housing · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENGINE 1 HYDRAULIC PUMP FAILED INFLIGHT; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. REMOVED AND REPLACED NUMBER 1 ENGINE HYDRAULIC PUMP (AALA202402287533). REMOVED AND REPLACE CASE DRAIN SDR AALA202402282105Hose · damagedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENGINE 1 HYDRAULIC PUMP FAILED INFLIGHT; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. REMOVED AND REPLACED NUMBER 1 ENGINE HYDRAULIC PUMP (AALA202402287533). REMOVED AND REPLACE CASE DRAIN SDR AALA202402282603Fire Bottle · noneAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FIRE INDICATION ENROUTE IN AFT CARGO COMPARTMENT; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT TUL. REPLACED CARGO FIRE EXTINGUISHER BOTTLE (AALA202402282603), PER AMM 26-23-01 AND REPLACED AFT CARGO CEU PESDR AALA202402284604Smoke Detector · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FIRE INDICATION ENROUTE IN AFT CARGO COMPARTMENT; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT TUL. REPLACED CARGO FIRE EXTINGUISHER BOTTLE (AALA202402282603), PER AMM 26-23-01 AND REPLACED AFT CARGO CEU PESDR AALA202402286603Fire Detector · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FIRE INDICATION ENROUTE IN AFT CARGO COMPARTMENT; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT TUL. REPLACED CARGO FIRE EXTINGUISHER BOTTLE (AALA202402282603), PER AMM 26-23-01 AND REPLACED AFT CARGO CEU PESDR AALA202403132567Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727B TO STA 780, LBL 21. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202403137385Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR THRESHOLD WEB FROM BS 803 TO BS 821, RBL 25. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202403042860Roller · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY-D DOOR OFF TRACK AND DIFFICULT TO OPERATE. REMOVE AND REPLACED LAVATORY-D BIFOLD DOOR ROLLER. PER CMM 25-40-58.SDR AALA202403019021Tube · missingAIRCRAFT WAS NOT GROUNDED: FA REPORTS ALL GIRT BARS HAVE DARK OR BLACK TAPE AT ENDS WHERE THEY ARE SUPPOSED TO HAVE RED TAPE. INSTALLED RED HEAT SHRINK AT FORWARD AND AFT SERVICE DOORS GIRT BARS.SDR AALA202403017247Light · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT CABIN COVE BULLNOSE EMERGENCY LIGHT FOUND INOPERATIVE ON PS CHECK. REMOVED AND REPLACED AFT CABIN OVERHEAD EMERGENCY LIGHT ASSEMBLY. PERFORMED OPERATIONAL CHECK. PER AMM 33-51-03.SDR AALA202402278101Slide · low pressureAIRCRAFT WAS GROUNDED: FOUND AFT GALLEY SERVICE (2R) DOOR SLIDE BOTTLE PRESSURE LOW.**SUPPLEMENTAL REPORT FOR (AALA202402268101): REPLACED R-2 DOOR SLIDE PER JC 08L22125001**(CLOSED).SDR AALA202402271397Gust Lock · stuckAIRCRAFT WAS GROUNDED: FORWARD GALLEY SERVICE DOOR (R1) GUST LOCK RELEASE PIN STUCK AND WILL NOT ALLOW DOOR TO BE CLOSED. REMOVED AND REPLACED GUST LOCK RELEASE BUTTON ON R1 DOOR. PER AMM 52-41-21-000-801.SDR AALA2024022728601Door · off trackAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY (LAV D) DOOR OFF TRACK AND DIFFICULT TO OPERATE. (OPEN).SDR AALA202402275616Fmc · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER ROTATION BOTH PFDS LOST ALL VERTICAL AND LATERAL NAVIGATION; AIRCRAFT RETURN TO AND LANDED SAFELY AT DFW. REMOVED AND REPLACED LEFT (FMC) FLIGHT MANAGEMENT COMPUTER. PER AMM 34-61-02, OPERATIONAL SDR AALA202402272793Battery · dischargedAIRCRAFT WAS NOT GROUNDED: LEFT AFT EMERGENCY LIGHTS REMAIN ILLUMINATED WHEN ARMED. CHARGED EMERGENCY BATTERIES. PER AMM 33-51-06.SDR AALA202402279021Tape · wrong partAIRCRAFT WAS NOT GROUNDED: FA REPORTS ALL GIRT BARS HAVE DARK OR BLACK TAPE AT ENDS WHERE THEY ARE SUPPOSED TO HAVE RED TAPE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202402277247Light · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT CABIN COVE BULLNOSE EMERGENCY LIGHT FOUND INOPERATIVE ON PS CHECK. Ï¿½ **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202402268101Bottle · low pressureAIRCRAFT WAS GROUNDED: FOUND AFT GALLEY SERVICE (2R) DOOR SLIDE BOTTLE PRESSURE LOW.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202402269605Slide · low pressureAIRCRAFT WAS GROUNDED: FOUND FORWARD 1R GALLEY SERVICE DOOR SLIDE BOTTLE PRESSURE LOW. REMOVED AND REPLACED R-1 DOOR SLIDE. PER JOB CARD 08L22125001.SDR AALA202402299853Connector · crackedAIRCRAFT IN BASE MAINTENANCE: PANEL 192F FORWARD AT ANTENNA CONNECTOR HAS A CRACKED. APPLIED COMPOSITE AND ALUMINUM MESH PERMANENT REPAIR ON KEEL BEAM ACCESS PANEL 192F OUTER SKIN. PER B737-NG SRM 53-40-70-2R-1, PER B737-NG SRM 51-70-05-2R-1 AND PER B737-NG SR
Back to Boeing 737-823