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 AALA202408159660Engine · vibrationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER TWO ENGINE RAPIDLY LOST ABOUT HALF ITS THRUST WITH NOTICEABLE VIBRATION, LANDED AIRCRAFT WITH IDLE THRUST THEN SHUTDOWN ENGINE AFTER LANDING; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT KIN.**SUPPLESDR AALA202408158663Probe · out of toleranceAIRCRAFT WAS GROUNDED: AFTER TAKEOFF AN 800 LB FUEL IMBALANCE DEVELOPED. CONFIRMED RIGHT MAIN TANK FUEL QUANTITY INOPERATIVE.**SUPPLEMENTAL REPORT FOR (AALA202408088663): NOTED RIGHT WING PROBE 10 OUT OF TOLERANCE, PER AA B737 AMM 28-41-21-710-801. REMOVED ANDSDR AALA202408087074Sign · unsecureAIRCRAFT WAS NOT GROUNDED: EXIT SIGN NEAR FORWARD SERVICE DOOR IS MISSING. RESECURED EXIT SIGN COVER NEAR FORWARD SERVICE DOOR. EXIT SIGN LIGHTS OPERTIONAL CHECK GOOD.SDR AALA202408089022Door Latch · lack of lubeAIRCRAFT WAS NOT GROUBNDED: FLIGHT DECK DOOR EXTREMELY DIFFICULT TO OPEN. ACCOMPLISHED DOOR LATCH LUBE. OPERTIONAL CHECK GOOD. PER AMM 52-51-00.SDR AALA202408083286Pressure Switch · faultyAIRCRAFT WAS GROUNDED: NUMBER 2 ENGINE FUEL FILTER BYPASS LIGHT ILLUMINATED IN FLIGHT STAYED ON UNTIL ENGINE SHUT DOWN. FOUND FUEL FILTER DIFFERENTIAL PRESSURE SWITCH TO BE CAUSING THE LIGHT TO TURN ON. REMOVED AND REPLACED FUEL FILTER DIFFERENTIAL PRESSURE SSDR AALA202408088277Fuel Filter · faultedAIRCRAFT WAS GROUNDED: NUMBER 2 ENGINE FUEL FILTER BYPASS LIGHT ILLUMINATED IN FLIGHT STAYED ON UNTIL ENGINE SHUT DOWN. FOUND FUEL FILTER DIFFERENTIAL PRESSURE SWITCH TO BE CAUSING THE LIGHT TO TURN ON. REMOVED AND REPLACED FUEL FILTER DIFFERENTIAL PRESSURE SSDR AALA202408083487Door · out of positionAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENT REPORTS LEFT LAVATORY DOOR IS JAMMED. FOUND LEFT AFT LAVATORY DOOR OUT OF TRACK AND JAMMED. REMOVED AND REINSTALLED LAVATORY DOOR IN POSITION AND OPERTIONAL CHECK GOOD. PER MM 52-50-00.SDR AALA202408088682Door · bindingAIRCRAFT WAS NOT GROUNDED: CHRONIC HISTORY OF LAVSTORY-D DOOR DIFFICULT TO OPERATE.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202408082598Sign · detachedAIRCRAFT WAS NOT GROUNDED: 24C EXIT SIGN LIGHT COVER DETACHED. REINSTALLED AND RESECURED EXIT SIGN COVER ASSEMBLY.SDR AALA202408088663Indicator · inoperativeAIRCRAFT WAS GROUNDED: AFTER TAKEOFF AN 800 LB FUEL IMBALANCE DEVELOPED. CONFIRMED RIGHT MAIN TANK FUEL QUANTITY INOPERATIVE.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202408089660Engine · power lossAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NR 2 ENGINE RAPIDLY LOST ABOUT HALF ITS THRUST WITH NOTICEABLE VIBRATION, LANDED AIRCRAFT WITH IDLE THRUST THEN SHUTDOWN ENGINE AFTER LANDING; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT KIN. OPENSDR AALA202408077061Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT AFT FLIGHT ATTANDENT SEAT EMERGENCY FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED LEFT AFT FLIGHT ATTANDENT SEAT EMERGENCY FLASHLIGHT BATTERY. OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202408121010Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 312 TO STA 328, LBL 44. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202408121805Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 344 TO STA 360, LBL 14. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202408087908Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 5OOC TO STA 500G, LBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202408086988Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOORBOARD INTERCOSTAL SUPPORT (CHORD) AT STA 390, LBL 11. REPLACED CHORD PER AAED 51-00-05-1.SDR AALA202408070371Lamp · no testAIRCRAFT IN BASE MAINTENANCE: LEFT FORWARD OVERWING EMERGENCY EXIT OUTSIDE LIGHT DID NOT ILLUMINATE DURING TEST. REMOVED AND REPLACED LAMP AT LEFT FORWARD OVERWING LIGHT, OPERTIONAL CHECK GOOD. PER AMM 33-51-04.SDR AALA202408073814Antenna · faultedAIRCRAFT WAS GROUNDED: ON DESCENT AT APPROXIMATELY 7000 FEET AND 210 KNOTS LANDING GEAR WARNING HORN AND GEAR LIGHTS CAME ON. REMOVE AND REPLACED ALL 4 RADIO ALTIMETER ANTENNAS (AALA202408073814), (AALA202408079265), (AALA202408070020), (AALA202408079690). ALLSDR AALA202408079690Antenna · faultedAIRCRAFT WAS GROUNDED: ON DESCENT AT APPROXIMATELY 7000 FEET AND 210 KNOTS LANDING GEAR WARNING HORN AND GEAR LIGHTS CAME ON. REMOVE AND REPLACED ALL 4 RADIO ALTIMETER ANTENNAS (AALA202408073814), (AALA202408079265), (AALA202408070020), (AALA202408079690). ALLSDR AALA202408070020Antenna · faultedAIRCRAFT WAS GROUNDED: ON DESCENT AT APPROXIMATELY 7000 FEET AND 210 KNOTS LANDING GEAR WARNING HORN AND GEAR LIGHTS CAME ON. REMOVE AND REPLACED ALL 4 RADIO ALTIMETER ANTENNAS (AALA202408073814), (AALA202408079265), (AALA202408070020), (AALA202408079690). ALLSDR AALA202408079265Antenna · faultedAIRCRAFT WAS GROUNDED: ON DESCENT AT APPROXIMATELY 7000 FEET AND 210 KNOTS LANDING GEAR WARNING HORN AND GEAR LIGHTS CAME ON. REMOVE AND REPLACED ALL 4 RADIO ALTIMETER ANTENNAS (AALA202408073814), (AALA202408079265), (AALA202408070020), (AALA202408079690). ALLSDR AALA202408078515Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR WILL NOT OPEN EITHER MANUALLY OR USING ACCESS CODE. LUBRICATED THE DOOR LATCHING, OPERTIONAL CHECK NORMAL. PER AMM 52-51-00.SDR AALA202408093298Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: UPON REMOVAL OF MAIN CABIN FLOOR PANEL, FOUND FLOOR BREAK LOCATED AT BS 540 AND LBL 0 TO LBL 24 CRACKED AT LBL 0 ATTACH POINT. REMOVED AND REPLACED BREAK ASSEMBLY AT MAIN CABIN FLOOR PANEL. PER B737-NG SRM 51-40-02.SDR AALA202408070258Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT STA 540, FROM BL 0 TO LBL 24. REPLACED BREAK ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202408060309Threshold · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS DIFFICULT TO OPEN. TIGHTENED SCREWS TO BOTTOM METAL THRESHOLD SLAB. DOOR NOW OPENS WITH LITTLE EFFORT. PER 25-46-96.SDR AALA202408130493Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT STA 540, FROM RBL 0 TO RBL 24. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-40-02-0G.SDR AALA202408069415Unknown · odorAIRCRAFT WAS GROUNDED: FUMES EVENT UPON TURNING ON APU BLEED AIR ON AFTER LANDING, FLIGHT ATTANDENT REPORTED STRONG ODOR IN THE BACK OF THE PLANE. ACCOMPLISHED WORK CARD 08L00021001, NO ODORS FOUNDED, NO FAULT FOUND.SDR AALA202408068709Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: FUME EVENT, FLIGHT ATTENDANTS REPORTED VERY STRONG WET SOCK AND CHEMICAL FUMES IN FORWARD CABIN, BEGAN ALL THE WAY IN AFT CABIN, THEN MOSTLY FORWARD OF ROW 12. FUME ELIMINATION CHECKLIST DID NOT IMPRSDR AALA202408059053Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL SUPPORT ANGLE AT STA 390, RBL 11. REPLACED SUPPORT ANGLE PER AARD 51-00-05-1.SDR AALA202408055705Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL UPPER ANGLE FROM STA 380 TO STA 400, LBL 13. REPLACED ANGLE PER AARD 51-00-5 AND SRM 51-40-2.SDR AALA202408055667Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL UPPER ANGLE FROM STA 380 TO STA 400, RBL 10. REPLACED ANGLE PER AARD 51-00-5 AND SRM 51-40-2.SDR AALA202408057617Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL UPPER ANGLE FROM STA 380 TO STA 400, LBL 0. REPLACED ANGLE PER AARD 51-00-5 AND SRM 51-40-2.SDR AALA202408058709Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: FUME EVENT, FLIGHT ATTENDANTS REPORTED VERY STRONG WET SOCK AND CHEMICAL FUMES IN FORWARD CABIN, BEGAN ALL THE WAY IN AFT CABIN, THEN MOSTLY FORWARD OF ROW 12. FUME ELIMINATION CHECKLIST DID NOT IMPRSDR AALA202408059415Bleed Air Sys · odorAIRCRAFT WAS GROUNDED: FUMES EVENT UPON TURNING ON APU BLEED AIR ON AFTER LANDING, FLIGHT ATTANDENT REPORTED STRONG ODOR IN THE BACK OF THE PLANE. OPENSDR AALA202408054353Door Frame · damagedAIRCRAFT WAS GROUNDED: RAMP REPORTS DAMAGE TO EXTERNAL POWER ACCESS DOOR FRAME. ACCOMPLISHED PERMANENT REPAIR. PER SRM 53-10-15-2R.SDR AALA202408058625Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: FOIRWARD MEGAPHONE FOUND INOPERATIVE. REMOVED AND REPLACED MEGAPHONE. PER AMM 25-64-00.SDR AALA202408056979Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: MOST FORWARD OUTBOARD EMERGENCY FLASHLIGHT BATTERY PACK INOPERATIVE. REMOVED AND REPLACED MOST OUTBAOARD EMERGENCY FLASHLIGHT BATTERY PACK. OPERTIONAL CHECK NORMAL. PER AMM-25-64-00-900-805.SDR AALA202408093583Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 344 TO STA 360, BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-R1.SDR AALA202408091280Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL FROM STA 344 TO STA 360, LBL 12. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202408058103Threshold · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. RESECURED AND ADUSTED THRESHOLD-SLAB. PER CMM 25-47-63.SDR AALA202409099364Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE SUPPORT LOCATED NEAR LEFT HAND FORWARD GALLEY MOUNT AT STA 990, LBL 31. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202408120882Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727 TO STA 767, S26L. REPLACED TRANSITION PANEL PER AARD 51-10-05.SDR AALA202408129716Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM STA 767 TO STA 787, S26R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202408097028Floorbeam · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT STA 540, LBL 6. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1SDR AALA202408093598Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT STA 540, RBL 6. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1SDR AALA202408056846Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN E AND E COMPARTMENT INTERCOSTAL FROM STA 344 TO STA 360, BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-R1.SDR AALA202408052047Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY-D DOOR HARD TO OPEN AND CLOSE. ADJUSTED LAVATORY-D DOOR. PER CMM 25-40-58.SDR AALA202408057025Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED FORWARD LAVATORY DOOR. PER AMM 25-40-11.SDR AALA202408124799Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727J TO STA 767, S26R. REPLACED TRANSITION PANEL PER AARD 51-10-05.SDR AALA202408054524Floorbeam · brokenAIRCRAFT IN BASE MAINTENANCE: PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT STA 538, LBL 1 BROKEN. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.
Back to Boeing 737-823