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 AALA202504073887Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CAP) ANGLE AT STA 947, RBL 50. REPAIRED CHORD PER SRM 53-70-51-2R-5.SDR AALA202504077577Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 947, RBL 50. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202504071714Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM AT STA 987, LBL 43. REPAIRED PER SRM 53-70-51-2R-6.SDR AALA202504049776Support · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND WING AFT LOWER PANEL SUPPORT RAIL FROM FLAP TRACK 7 TO FLAPTRACK 8 HAS AREAS OF CORROSION. REMOVED CORROSION AT RIGHT HAND WING AFT LOWER PANEL SUPPORT RAIL FROM FLAP TRACK 7 TO FLAP TRACK 8. PER B737NG SRM 51-10-02-OG,SDR AALA202504020324Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500 TO BS 500I, S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202504027389Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500A TO BS 500I, S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202504020562Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727 TO BS 847, S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202504021818Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727 TO BS 787, S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202504015610Elec Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: OVERHEAD CEILING EMERGENGY AISLE LIGHT ABOVE ROW 19FED INOPERATIVE. REMOVE AND REPLACED OVERHEAD EMERGENCY LIGHT AT ROW 19FED, PER AMM 33-51-00. OPERTIONAL CHECK FAILED, REQUIRES FURTHER TROUBLESHOOTING. RESECURED 19DEF OVERHEAD ESDR AALA202504012799Starter · leakingAIRCRAFT WAS GROUNDED: ON TAKE OFF ROLL, A STRONG MUSTY SMELL NOTICED IN FLIGHT DECK ONLY. **SUPPLEMENTAL REPORT FOR (AALA202503242799): REMOVE AND REPLACED STARTER (AALA202503242799) AND DRIVE PAD SEAL (AALA202504018424), PER EA 363229. LEAK CHECKS GOOD**(CLOSDR AALA202504018424Seal · leakingAIRCRAFT WAS GROUNDED: ON TAKE OFF ROLL, A STRONG MUSTY SMELL NOTICED IN FLIGHT DECK ONLY. REMOVE AND REPLACED STARTER (AALA202503242799) AND DRIVE PAD SEAL (AALA202504018424), PER EA 363229. LEAK CHECKS GOOD.SDR AALA202503313010Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SHIELD FROM STA 490 TO STA 500A AT S25R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202503313532Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM BS 787 TO BS 807 AT S25R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202503256821Door Track · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY DOOR IS JAMMED SHUT AND CANNOT BE OPENED. APPLIED LUBRICANT WITHIN AFT LAVATORY DOOR TRACKS AS REQUIRED.SDR AALA202503252995Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY0-D DOOR JAMS WHEN TRYING TO OPEN AND CLOSE. ADJUSTED LATCH AND STRIKER ON LAVATORY-D DOOR. OPERTIONAL CHECK GOOD. PER AMM 25-40-00.SDR AALA202503255610Light · inoperativeAIRCRAFT WAS NOT GROUNDED: OVERHEAD CEILING EMERGENGY AISLE LIGHT ABOVE ROW 19FED INOPERATIVE. REMOVE AND REPLACED OVERHEAD EMERGENCY LIGHT AT ROW 19FED, PER AMM 33-51-00. OPERTIONAL CHECK FAILED, REQUIRES FURTHER TROUBLESHOOTING. **SUPPLEMENTAL REPORT WILL SDR AALA202503251917Flashlight · not seatedAIRCRAFT IN BASE MAINTENANCE: LEFT OUTBOARD EMERGENCY FLASHLIGHT DOES NOT TEST UNDER AFT LEFT FLIGHT ATTENDANT SEAT. PROPERLY RESEATED EMERGENCY FLASHLIGHT IN THE BRACKET ON THE LEFT OUTBOARD AFT FLIGHT ATTENDANT SEAT, OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202503240076Air Filter · odorAIRCRAFT WAS GROUNDED: CREW REPORTED DURING TAKEOFF FOR WE EXPERIENCED A DIRTY MUSTY SMELL FOR APPROXIMATELY 5 MINUTES. REMOVED AND REPLACED BOTH LEFT (AALA202503242397) AND RIGHT (AALA202503240076) RECIRCULATION FAN FILTERS. PER MM 21-25-01. NO DEFECTS NOTED SDR AALA202503242799Unknown · odorAIRCRAFT WAS GROUNDED: ON TAKE OFF ROLL, A STRONG MUSTY SMELL NOTICED IN FLIGHT DECK ONLY.SDR AALA202503242397Air Filter · odorAIRCRAFT WAS GROUNDED: CREW REPORTED DURING TAKEOFF FOR WE EXPERIENCED A DIRTY MUSTY SMELL FOR APPROXIMATELY 5 MINUTES. REMOVED AND REPLACED BOTH LEFT (AALA202503242397) AND RIGHT (AALA202503240076) RECIRCULATION FAN FILTERS. PER MM 21-25-01. NO DEFECTS NOTED SDR AALA202504210661Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 950.5, LBL 49. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202504113137Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM AT STA 947.5, RBL 48. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-1.SDR AALA202504119507Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 950.5, RBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202504110192Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE SHEAR WEB AT BS 988.5, RBL 33. REPAIRED PER EA 363372.SDR AALA202504072718Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 936, LBL 50. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202504071895Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD AT STA 947.5, RBL 51. REPAIRED CHORD PER SRM 53-70-51-2RSDR AALA202504010096Heater · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 1 ENGINE FAIL (COMPRESSOR STALL), ENGINE 1 SHUTDOWN BY CREW IN DESCENT; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MIA. REMOVED AND REPLACED HMU-HYDROMECHANICAL UNIT (AALA202503240627), PER JC 08SDR AALA202504011909Heater · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 1 ENGINE FAIL (COMPRESSOR STALL), ENGINE 1 SHUTDOWN BY CREW IN DESCENT; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MIA. **SUPPLEMENTAL REPORT FOR (AALA202503240627): REMOVED AND REPLACED HMU-HYDROMSDR AALA202504017775Pump · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 1 ENGINE FAIL (COMPRESSOR STALL), ENGINE 1 SHUTDOWN BY CREW IN DESCENT; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MIA. REMOVED AND REPLACED HMU-HYDROMECHANICAL UNIT (AALA202503240627), PER JC 08SDR AALA202504018371Switchpack · faultedAIRCRAFT WAS NOT GROUNDED: WHEN AUTO BRAKES ARE PUT IN RTO, THE AUTO BRAKES DISARM LIGHT COMES ON. TROUBLESHOT AND FOUND S2 SWITCH ON BOTH LEFT HAND AND RIGHT HAND (SWPK)-SWITCHPACK ASSEMBLY FAULTY. REMOVED AND REPLACED LEFT HAND (AALA202503211855) AND RIGHTSDR AALA202504010627Hmu · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 1 ENGINE FAIL (COMPRESSOR STALL), ENGINE 1 SHUTDOWN BY CREW IN DESCENT; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MIA. REMOVED AND REPLACED HMU-HYDROMECHANICAL UNIT (AALA202503240627), PER JC 08LSDR AALA202504011855Switchpack · faultedAIRCRAFT WAS NOT GROUNDED: WHEN AUTO BRAKES ARE PUT IN RTO, THE AUTO BRAKES DISARM LIGHT COMES ON. TROUBLESHOT AND FOUND S2 SWITCH ON BOTH LEFT HAND AND RIGHT HAND (SWPK)-SWITCHPACK ASSEMBLY FAULTY. REMOVED AND REPLACED LEFT HAND (AALA202503211855) AND RIGHT SDR AALA202504015498Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR KEEPS GETTING STUCK. DIFFICULT TO OPEN FROM THE INSIDE. ADJUSTED FORWARD LAVATORY-A DOOR. PER CMM 25-44-49.SDR AALA202503314881Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLANGE OF PASSENGER CABIN FLOORBEAM UPPER CHORD AT BS 947.5, RBL4. REPAIRED FLANGE PER SRM 53-00-51-2R-1.SDR AALA202503283425Girt Bar · wornAIRCRAFT IN BASE MAINTENANCE: L1 SLIDE LOWER GIRT BAR FLAP LOWER SURFACE IS WORN IN SEVERAL AREAS. REMOVE AND REPLACED SLIDE.SDR AALA202503258691Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND MIDDLE CABIN AISLE EMERGENCY LIGHT OUT. REMOVED AND REPLACED M1695 BATTERY (AALA202503258791) AND POWER SUPPLY (AALA2025032586910. OPERTIONAL CHECK GOOD. PER AMM 33-5 1-06.SDR AALA202503258791Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND MIDDLE CABIN AISLE EMERGENCY LIGHT OUT. REMOVED AND REPLACED M1695 BATTERY (AALA202503258791) AND POWER SUPPLY (AALA2025032586910. OPERTIONAL CHECK GOOD. PER AMM 33-5 1-06.SDR AALA202503256647Door · stickingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. APPEARS TO STICK AT THE BOTTOM OF DOOR. TIGHTENED FIRST CLASS LAVATORY DOOR THRESHOLD. PER MM 20-50-11.SDR AALA202503259797Pin · bindingAIRCRAFT WAS GROUNDED: FORWARD ENTRY L1 DOOR BINDS AND IS DIFFICULT TO OPEN. REPLACED PIN (AALA202503259797) AND SCREW (AALA202503255237) FOR FORWARD CABIN DOOR HINGE ASSEMBLY, OPERTIONAL CHECK GOOD. PER AMM 52-11-00 AND IPC 52-11-21-01.SDR AALA202503255237Screw · not reportedAIRCRAFT WAS GROUNDED: FORWARD ENTRY L1 DOOR BINDS AND IS DIFFICULT TO OPEN. REPLACED PIN (AALA202503259797) AND SCREW (AALA202503255237) FOR FORWARD CABIN DOOR HINGE ASSEMBLY, OPERTIONAL CHECK GOOD. PER AMM 52-11-00 AND IPC 52-11-21-01.SDR AALA202503255498Door · bindingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR KEEPS GETTING STUCK. DIFFICULT TO OPEN FROM THE INSIDE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202503259159Door · jammedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENTS REPORTS LAVATORY-D DOOR JAMMED DOOR FOUND "KICKED IN", DAMAGE TO TOP EDGE TRIM. UNJAMMED DOOR, DOOR OPERATES NORMALLY.SDR AALA202503258644Circuit Breaker · trippedAIRCRAFT WAS NOT GROUNDED: CABIN EMERGENCY LIGHTS CIRCUIT BREAKER FOUND POPPED DURING PREFLIGHT INSPECTION. CLOSED CIRCUIT BREAKER "CABIN EMERGENCY LIGHT" PERFORMED OPERTIONAL TEST. PER AMM 33-51-00-710-801.SDR AALA202503245084Computer · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: STAB OUT OF TRIM LIGHT UPON LEVEL OFF AT FL380; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT DFW. REMOVED AND REPLACE (FCC)-FLIGHT CONTROL COMPUTERS A (AALA202503248669) AND B (AALA202503245084). OPERTISDR AALA202503248669Computer · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: STAB OUT OF TRIM LIGHT UPON LEVEL OFF AT FL380; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT DFW. REMOVED AND REPLACE (FCC)-FLIGHT CONTROL COMPUTERS A (AALA202503248669) AND B (AALA202503245084). OPERTISDR AALA202503247684Overheat Loop · false activationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: RIGHT WING BODY OVERHEAT ILLUMINATED ENROUTE; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. REMOVED AND REPLACED OVERHEAT LOOP M356. ALL OPERTIONAL CHECK GOOD. PER AMM 26-28-02.SDR AALA202503247533Transmitter · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAP DISAGREE, FLAP INDICATOR STOPPED AT 2; AIRCRAFT LANDED SAFELY AT PHX. PERFORMED FIM 27-51-00, REMOVED AND REPLACED RIGHT HAND NUMBER 5 FLAP POSITION TRANSMITTER. OPERTIONAL CHECK GOOD. PER AMM 27-58SDR AALA202503240627Compressor · stalledAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 1 ENGINE FAIL (COMPRESSOR STALL), ENGINE 1 SHUTDOWN BY CREW IN DESCENT; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MIA. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202503211855Warning Light · illuminatedAIRCRAFT WAS NOT GROUNDED: WHEN AUTO BRAKES ARE PUT IN RTO, THE AUTO BRAKES DISARM LIGHT COMES ON. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202504042604Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: EXTERIOR FUSELAGE SKIN AND SEVERAL FASTENERS UNDER RIGHT AFT RAM AIR INLET MODULATION PANEL HAS CORROSION. REMOVED CORROSION AT EXTERIOR FUSELAGE SKIN BS 500I TO 520 RIGHT AFT RAM AIR INLET MODULATION. PER B737 NG SRM 51-10-02-0G.
Back to Boeing 737-823