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 AALA202404260143Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON E AND E COMPARTMENT BRACKET AT BS 335, S23L. REPLACED BRACKET PER AARD 51-00-05-1.SDR AALA202404260865Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON E AND E COMPARTMENT WEB AT BS 319, S23L. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202404186575Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM UPPER CHORD AT BS 947, RBL 26. REPAIRED CHORD PER SRM 53-70-51-2R-5 ALTERNATIVE 2.SDR AALA202404099025Handle · unsecureAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-E DOOR STICKS. HARD TO OPEN AND CLOSE.**SUPPLEMENTAL REPORT FOR (AALA202404039025): RESECURED LAVATORY DOOR HANDLE TO DOOR**(CLOSED).SDR AALA202404092803Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING SECTION REAR SPAR VERTICAL STIFFENER AT BS 663, RBL 16. REPLACED STIFFENER PER AARD 51-00-05-1.SDR AALA202404036395Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: ROW 3AB EMERGENCY SEAT LIGHT INOPERATIVE. RECONNECTED EMERGENCY PATH LIGHT CONNECTOR. PER B737NG CMM 25-23-67.SDR AALA202404032454Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: EXIT EMERGENCY LIGHT (SLIDE LIGHT) LEFT HAND ADJACENT TO FORWARD ENTRY DOOR INOPERATIVE. REMOVED AND REPLACED LAMP ON EMERGENCY SLIDE LIGHT LEFT HAND ADJACENT TO FORWARD ENTRY DOOR. PER B737NG AMM 33-51-04-960-801. PERFORMED OPERTSDR AALA202404039025Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-E DOOR STICKS. HARD TO OPEN AND CLOSE. (OPEN).SDR AALA202404034284Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR WARPED AND HARD TO OPEN. ADJUSTED DOOR. OPERTIONAL CHECK GOOD. PRE AMM 25-40-00.SDR AALA202404038799Slide Raft · partial deployAIRCRAFT WAS NOT GROUNDED: PASSENGER PULLED ON RAFT HANDLE. OPENED PARTIALLY AND SEAL BROKEN. SECURED RAFT. PER AMM25-64-00SDR AALA202404260437Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT AFT BULKHEAD SUPPORT AT BS 500I, LBL 25. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202404157817Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT AFT BULKHEAD SUPPORT RAIL AT BS 500I, RBL 25. REPLACED SUPPORT RAIL PER AARD 51-00-05-1.SDR AALA202404121087Guide Arm · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY GUST LOCK DIFFICULT TO RELEASE, FORWARD PRESSURE ON DOOR REQUIRED TO RELEASE. CLEANED AND LUBRICATED GUIDE ARM AND ROLLER AS PER AMM 52-11-21, NO DEFECTS NOTED.**(CLOSED).SDR AALA202404084020Light · damagedAIRCRAFT IN BASE MAINTENANCE: FORWARD LEFT HAND OVERWING LOWER EXIT LIGHT DAMAGE. REMOVED AND REPLACED FORWARD LEFT HAND OVERWING LOWER EXIT LIGHT. PER B-737NG AMM 33-51-01 AND AMM 33-51-00.SDR AALA202404055197Connector · looseAIRCRAFT IN BASE MAINTENANCE: FIRST CLASS ROW 3AB EMERGENCY SEAT LIGHTS INOPERATIVE. FOUND EPL CONNECTORS LOOSE AND NOT PROPERLY CONNECTED TO SEAT. RECONNECTED, PER B737 NG CMM 25-23-67. PERFORMED SATISFACTORY EMERGENCY LIGHTS OPERATIONAL CHECK ON SEAT ROW 3ABSDR AALA202404034217Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT AT SEAT 31C BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY. OPERTIONAL CHECK GOOD. PER AMM 33-51-03.SDR AALA202404032300Lock · looseAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LOCK DOES NOT WORK. FOUND LOOSE HARDWARE, RESECURED HARDWARE AND OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202404029754Slide · unwanted deployAIRCRAFT WAS GROUNDED: PARTIAL DEPLOYMENT OF THE FORWARD (RIGHT) SERVICE DOOR SLIDE, DUE TO GIRT BAR STILL BEING ENGAGED DURING AIRCRAFT CATERING. REMOVED AND REPLACED R1 DOOR SLIDE PACK AND COVER. PER AMM 25-66-01SDR AALA202404020074Door Sill · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR VERY HARD TO OPEN AND CLOSE. SECURED LAVATORY DOOR SILL. PER CMM 25-47-63.SDR AALA202404022944Sign · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN FELL OFF IN CENTER AISLE AT ROW 16. REINSTALLED EXIT LIGHT LENS AT CENTER AISLE AT ROW 16. PER AMM 33-51-01.SDR AALA202404021049Trim Panel · bentAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR IS JAMMING. FOUND UPPER DOOR METAL EDGE TRIM BENT. REMOVED AND REPLACED EDGE TRIM FROM LAVATORY D DOOR ASSEMBLY. FUNCATIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202404022300Lock · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LOCK DOES NOT WORK.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404029940Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT BATTERY LOW AT RIGHT AFT FLIGHT ATTANDENT JUMPSEAT. REPLACED RIGHT HAND FLIGHT ATTANDENT JUMPSEAT FLASHLIGHT. FUNCTIONAL CHECK GOOD. PER AMM 25-60-00.SDR AALA202404028188Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT BATTERY DEAD LOCATED AT LEFT AFT FLIGHT ATTANDENT JUMP SEAT. REPLACED LEFT HAND AFT FLIGHT ATTANDENT JUMPSEAT FLASHLIGHT. FUNCATIONAL CHECK GOOD. PER 25-60-00.SDR AALA202404029281Slide · unsecureAIRCRAFT WAS NOT GROUNDED: 1L DOOR PART OF THE SLIDE APPEARS HANGING BELOW ENCLOSURE. SECURED 1L DOOR GIRT BAR. PER AMM 25-66-01.SDR AALA202404021087Gust Lock · bindingAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY GUST LOCK DIFFICULT TO RELEASE, FORWARD PRESSURE ON DOOR REQUIRED TO RELEASE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404029941Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB AT STABILIZER STA 111.10., REPLACED RIB PER SRM 51-40-02-0G.SDR AALA202404219340Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT BS 907, RBL 23. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202404164982Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT AT BS 887 FROM LBL 20 TO RBL 20. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA202404128121Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 947.5 TO BS 967, LBL 50. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202404121855Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 947.5 TO BS 967, LBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202404106272Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL AT BS 321, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202404100966Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL AT BS 335, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202404091699Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR THRESHOLD WEB FROM BS 807 TO BS 847, S25R. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202404095212Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON APU DOOR INSULATION ATTACH ANGLE AT RIB 3, BS 1110. REPLACED ANGLE PER SRM 51-10-02.SDR AALA202404098738Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON APU DOOR INSULATION ATTACH ANGLE AT RIB 4, BS 1110. REPLACED ANGLE PER SRM 51-10-02.SDR AALA202404038625Landing Gear · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: ISSUES WITH MAIN LANDING GEAR RETRACTION; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. PERFORMED OPERTIONAL CHECK OF LANDING GEAR RETRACTION AND EXTENSION. PER J/C 08L00007005, 08L000SDR AALA202404019613Slide · inoperativeAIRCRAFT WAS NOT GROUNDED: L2 DOOR MOUNTED SLIDE REQUIRES REPLACEMENT. REMOVED AND REPLACED L2 DOOR MOUNTED SLIDE. PER J/C 08L22125001.SDR AALA202404019141Battery · dischargedAIRCRAFT WAS NOT GROUNDED: 3 EA (AALA202404019141), (AALA202404016688), (AALA202404017656) FIGHT ATTENDANT FLASHLIGHTS LOW ON POWER. REMOVE AND REPLACED FLASHLIGHTS BATTERY AS REQUIRED, OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202404016688Battery · dischargedAIRCRAFT WAS NOT GROUNDED: 3 EA (AALA202404019141), (AALA202404016688), (AALA202404017656) FIGHT ATTENDANT FLASHLIGHTS LOW ON POWER. REMOVE AND REPLACED FLASHLIGHTS BATTERY AS REQUIRED, OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202404017656Battery · dischargedAIRCRAFT WAS NOT GROUNDED: 3 EA (AALA202404019141), (AALA202404016688), (AALA202404017656) FIGHT ATTENDANT FLASHLIGHTS LOW ON POWER. REMOVE AND REPLACED FLASHLIGHTS BATTERY AS REQUIRED, OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202404012256Battery · dischargedAIRCRAFT WAS NOT GROUNDED: AFT LEFT FLIGHT ATTENDENT SEAT FLASHLIGHT BATTERY RED (DEAD). REMOVED AND REPLACED AFT LEFT FLIGHT ATTENDENT SEAT FLASHLIGHT BATTERY. PER AMM 25-64-00.SDR AALA202404018810Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD RIGHT HAND OVERWING EMERGENCY DOOR LIGHT BULB INOPERATIVE. RELAMPED FORWARD RIGHT HAND OVERWING EMERGENCY DOOR LIGHT. OPERTIONAL CHECK GOOD. PER AMM 33-51-04.SDR AALA202404018625Landing Gear · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: ISSUES WITH MAIN LANDING GEAR RETRACTION; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404016007Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: R2 EXIT EMERGENCY LIGHT BULB INOPERATIVE. RELAMPED EXIT SIGN LENS AT R2 DOOR. OPERTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202405075990Access Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON NOSE WHEEL WELL FORWARD UPPER ACCESS PANEL 114AC AT STA 243.7, RBL 10. REPLACED PANEL PER AARD 51-00-05-1.SDR AALA202405073717Access Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON NOSE WHEEL WELL FORWARD ACCESS PANEL 114AW AT STA 277, LBL 14. REPLACED PANEL PER AARD 51-00-05-1.SDR AALA202405078331Access Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON NOSE WHEEL WELL FORWARD ACCESS PANEL 114BW AT STA 243.7, S23L. REPLACED PANEL PER AARD 51-00-05-1.SDR AALA202405070173Access Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON NOSE WHEEL WELL FORWARD ACCESS PANEL 113BW AT STA 277, S23R. REPLACED PANEL PER AARD 51-00-05-1.SDR AALA202405079684Access Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON NOSE WHEEL WELL FORWARD UPPER ACCESS PANEL 113AC AT STA 243.7, LBL 10. REPLACED PANEL PER AARD 51-00-05-1.
Back to Boeing 737-823