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 AALA202511211957Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: ELECTRICAL CONNECTORS FOR THE EMERGENCY LIGHTING ON SEATS 8ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202511216916Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: ELECTRICAL CONNECTORS FOR THE EMERGENCY LIGHTING ON SEATS 11ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202511210047Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: ELECTRICAL CONNECTORS FOR THE EMERGENCY LIGHTING ON SEATS 15ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202511217568Elec Connector · brokenAIRCRAFT WAS NOT GROUNDED: ELECTRICAL CONNECTOR FOR THE EMERGENCY LIGHTING ON SEATS 12ABC. REMOVED AND REPLACED EMERGENCY LIGHTING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202511214309Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: ELECTRICAL CONNECTORS FOR THE EMERGENCY LIGHTING ON SEATS 10ABC BROKEN. REMOVED AND REPALCED EMERGENCY LIGHTING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202511219798Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: ELECTRICAL CONNECTOR FOR THE EMERGENCY LIGHTING ON SEATS 2AB BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202511217555Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: BOTH EMERGENCY LIGHTING ELECTRICAL CONNECTORS UNDER SEATS 3AB BROKEN. REMOVED AND REPALCED EMERGENCY LIGHTING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202511216451Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING ELECTRICAL CONNECTOR UNDER SEAT 4AC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202511215701Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: ELECTRICAL CONNECTORS FOR THE EMERGENCY LIGHTING ON SEATS 9ABC. REMOVED AND REPLACED EMERGENCY LIGHTING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202511219110Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING CONNECTORS ON SEATS 31/32/33 ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING ELECTRICAL CONNECTOR ON SEAT 31 (AALA202511205865), 32 (AALA202511205646), 33 (AALA202511209110) ABC. PER SWPM 20-61-28.SDR AALA202511215646Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING CONNECTORS ON SEATS 31/32/33 ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING ELECTRICAL CONNECTOR ON SEAT 31 (AALA202511205865), 32 (AALA202511205646), 33 (AALA202511209110) ABC. PER SWPM 20-61-28.SDR AALA202511215865Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING CONNECTORS ON SEATS 31/32/33 ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING ELECTRICAL CONNECTOR ON SEAT 31 (AALA202511205865), 32 (AALA202511205646), 33 (AALA202511209110) ABC. PER SWPM 20-61-28.SDR AALA202511215901Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: ELECTRICAL CONNECTOR FOR THE EMERGENCY LIGHTING ON SEATS 17ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202511216835Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: ELECTRICAL CONNECTOR FOR THE EMERGENCY LIGHTING ON SEATS 18ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202511214116Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: BOTH EMERGENCY LIGHTING ELECTRICAL CONNECTORS UNDER SEATS 23ABC BROKEN. REMOVED AND REPALCED EMERGENCY LIGHTING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202511211370Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: BOTH EMERGENCY LIGHTING ELECTRICAL CONNECTORS UNDER SEATS 22ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202511212919Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: ELECTRICAL CONNECTOR FOR THE EMERGENCY LIGHTING ON SEATS 19ABC BROKEN. REMOVED AND REPALCED EMERGENCY LIGHTING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202511196146Fabric · wornAIRCRAFT IN BASE MAINTENANCE: L2 ESCAPE SLIDE LOWER SKIRT FABRIC WORN. REPAIRED GIRT FABRIC. PER AARD 25-66-00-2.SDR AALA202511191530Latch · missingAIRCRAFT IN BASE MAINTENANCE: L1 DOOR ESCAPE SLIDE GIRT BAR SPRING NYLON LATCH MISSING OUTER SLEEVE. INSTALLED SERVICEABLE LATCH. PER CARD 08C20025031 .SDR AALA202511197380Liner · wornAIRCRAFT IN BASE MAINTENANCE: R1 ESCAPE SLIDE LOWER SKIRT FABRIC WORN. REPAIRED GIRT FABRIC. PER AARD 25-66-00-2.SDR AALA202511195255Skin · delaminatedAIRCRAFT IN BASE MAINTENANCE: LEFT WING OUTBOARD AFT FLAP INBOARD END IS DELAMINATED UPPER EXTERNAL SURFACE. EVALUATED LEFT HAND OUTBOARD AFT FLAP INBOARD END UPPER AND LOWER SKIN AND FOUND DISBOND DAMAGE TO EXCEED SRM REPAIR LIMITS, PER B737-NG SRM 57-53-- 01SDR AALA202511181845Tab · corrodedAIRCRAFT WAS GROUNDED: WHILE PERFORMING J/C 08T33027001, DVI OF LEFT ELEVATOR TAB INSTALL, FOUND ELAVATOR TAB CONTROL ACTUATOR UNION CORRODED. REMOVED CORROSION FROM LEFT HAND TAB ACTUATOR FITTING. PER AMM 51-21-31 AND APPLIED CORROSION PROHIBITING LPS3 AS REQSDR AALA202511188320Tab · corrodedAIRCRAFT WAS GROUNDED: WHILE PERFORMING J/C 08T34027001, DVI OF RIGHT ELEVATOR TAB INSTALL, FOUND ELAVATOR TAB CONTROL ACTUATOR UNION CORRODED. REMOVED CORROSION FROM RIGHT HAND TAB ACTUATOR FITTING. PER AMM 51-21-31 (MECHANICAL METHOD) AND APPLIED CORROSION PSDR AALA202511179177Antenna · false indicationAIRCRAFT WAS NOT GROUNDED: AT 6000 FT WITH GEAR AND FLAPS UP GEAR WARNING HORN SOUNDED FOR APPROXIMATELY 2 SECONDS WITH THREE RED UNSAFE GEAR INDICATIONS. REPLACED ALL 4 RADIO ALTIMETERS ANTENNAS (AALA202511176584), (AALA202511170938), (AALA202511170218), (AALSDR AALA202511170218Antenna · false indicationAIRCRAFT WAS NOT GROUNDED: AT 6000 FT WITH GEAR AND FLAPS UP GEAR WARNING HORN SOUNDED FOR APPROXIMATELY 2 SECONDS WITH THREE RED UNSAFE GEAR INDICATIONS. REPLACED ALL 4 RADIO ALTIMETERS ANTENNAS (AALA202511176584), (AALA202511170938), (AALA202511170218), (AALSDR AALA202511170938Antenna · false indicationAIRCRAFT WAS NOT GROUNDED: AT 6000 FT WITH GEAR AND FLAPS UP GEAR WARNING HORN SOUNDED FOR APPROXIMATELY 2 SECONDS WITH THREE RED UNSAFE GEAR INDICATIONS. REPLACED ALL 4 RADIO ALTIMETERS ANTENNAS (AALA202511176584), (AALA202511170938), (AALA202511170218), (AALSDR AALA202511176584Antenna · false indicationAIRCRAFT WAS NOT GROUNDED: AT 6000 FT WITH GEAR AND FLAPS UP GEAR WARNING HORN SOUNDED FOR APPROXIMATELY 2 SECONDS WITH THREE RED UNSAFE GEAR INDICATIONS. REPLACED ALL 4 RADIO ALTIMETERS ANTENNAS (AALA202511176584), (AALA202511170938), (AALA202511170218), (AALSDR AALA202511171203Sign · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT DOOR EXIT LIGHT BY 16A IS MISSING. REMOVED AND REPLACED ROW 16 LEFT HAND LOWER EXIT LIGHT ASSEMBLY. PER AMM 33-51-01.SDR AALA202511176812Skin · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON FUSELAGE SKIN AROUND LAVATORY VENT LOCATED AT BS 917, FROM S21L TO S22L. REPAIRED SKIN PER SRM 53-70-01-2R-3.SDR AALA202511244438Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE, LOCATED IN LEFT HAND ECS BAY, AT STA 663 AT LBL 10. REPLACED ANGLE PER SRM 57-10-10-2R-5 AND EA 369792SDR AALA202511218562Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT, BS 344 TO 360, LBL 12. REPLACED FLOOR SUPPORT IAW AARD 51-00-05-1.SDR AALA202511172904Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS STICKING HARD TO OPEN. LUBRICATED LAVATORY-D DOOR. PER AMM 25-40-14. OPERATIONAL CHECK GOOD.SDR AALA202511175620Gust Lock · jammedAIRCRAFT WAS GROUNDED: L1 GUST LOCK JAMS WHEN DOOR FULLY OPEN. LUBED GUST LOCK. PER AMM 12-20-00. OPERATIONAL CHECK GOOD.SDR AALA202511214980Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOORBEAM BS 540, RBL 2. REPLACED THE FLOORBEAM IAW AARD 51-00-05-1.SDR AALA202511219112Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOORBEAM ASSEMBLY LOCATED AT BS 540, LBL 2. REPLACED THE FLOORBEAM IAW AARD 51-00-05-1.SDR AALA202511217807Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT LOCATED FROM BS 344 - 360, BL 0. REPLACED THE FLOOR SUPPORT IAW AARD 51-00-05-1.SDR AALA202511214931Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED PASSENGER CABIN FLOOR SUPPORT LOCATED BS 276 - 294.5, BL 0. REPLACED THE FLOOR SUPPORT IAW AARD 51-00-05-1.SDR AALA202511211529Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT BS 663.5, S22R. REPLACED ANGLE IAW AARD 51-00-05-1.SDR AALA202511158788Battery Pack · faultyAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS ROW 19ABC THROUGH 25ABC ARE DIM. REMOVE AND REPLACED M1670 (AALA202511153658) AND M1671 (AALA202511156906) EMERGENCY LIGHTS POWER SUPPLY AND BATTERIES (AALA202511151327), (AALA202511158788). PER AMM 33-51-06SDR AALA202511151327Battery Pack · faultyAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS ROW 19ABC THROUGH 25ABC ARE DIM. REMOVE AND REPLACED M1670 (AALA202511153658) AND M1671 (AALA202511156906) EMERGENCY LIGHTS POWER SUPPLY AND BATTERIES (AALA202511151327), (AALA202511158788). PER AMM 33-51-06SDR AALA202511156906Power Supply · faultyAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS ROW 19ABC THROUGH 25ABC ARE DIM. REMOVE AND REPLACED M1670 (AALA202511153658) AND M1671 (AALA202511156906) EMERGENCY LIGHTS POWER SUPPLY AND BATTERIES (AALA202511151327), (AALA202511158788). PER AMM 33-51-06SDR AALA202511156131Battery Pack · faultyAIRCRAFT WAS GROUNDED: EMERGENCY EXIT LIGHT AT ROW 16 WILL NOT TURN OFF. REPLACED M1670 (AALA202511155108) AND M1671 (AALA202511158299) EMERGENCY LIGHTS POWER SUPPLY AND BATTERIES (AALA202511154552), (AALA202511156131). PER AMM 33-51-06. OPERATIONAL CHECKS GOOSDR AALA202511154552Battery · faultyAIRCRAFT WAS GROUNDED: EMERGENCY EXIT LIGHT AT ROW 16 WILL NOT TURN OFF. REPLACED M1670 (AALA202511155108) AND M1671 (AALA202511158299) EMERGENCY LIGHTS POWER SUPPLY AND BATTERIES (AALA202511154552), (AALA202511156131). PER AMM 33-51-06. OPERATIONAL CHECKS GOOSDR AALA202511158299Power Supply · faultyAIRCRAFT WAS GROUNDED: EMERGENCY EXIT LIGHT AT ROW 16 WILL NOT TURN OFF. REPLACED M1670 (AALA202511155108) AND M1671 (AALA202511158299) EMERGENCY LIGHTS POWER SUPPLY AND BATTERIES (AALA202511154552), (AALA202511156131). PER AMM 33-51-06. OPERATIONAL CHECKS GOOSDR AALA202511153982Sign · brokenAIRCRAFT WAS NOT GROUNDED: EXIT SIGN COVER OVER DOOR L1 FELL OFF AND APPEARS BROKEN. INSTALLED EXIT SIGN COVER AT L1 DOOR. OPERATIONAL CHECK GOOD. PER AMM 25-00-00.SDR AALA202511156561Slide · faultyAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT DISCOVERED PLUG AND WIRE PROTRUDING FROM BOTTOM OF DOOR NEAR EMERGENCY EXIT SLIDE GIRT BAR. RMOVED AND REPLACED EMERGENCY ESCAPE SLIDE FROM L1 DOOR. PER WORK CARD #08L22125001.SDR AALA202511155108Power Supply · faultyAIRCRAFT WAS GROUNDED: EMERGENCY EXIT LIGHT AT ROW 16 WILL NOT TURN OFF. REPLACED M1670 (AALA202511155108) AND M1671 (AALA202511158299) EMERGENCY LIGHTS POWER SUPPLY AND BATTERIES (AALA202511154552), (AALA202511156131). PER AMM 33-51-06. OPERATIONAL CHECKS GOOSDR AALA202511153658Power Supply · faultyAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS ROW 19ABC THROUGH 25ABC ARE DIM. REMOVE AND REPLACED M1670 (AALA202511153658) AND M1671 (AALA202511156906) EMERGENCY LIGHTS POWER SUPPLY AND BATTERIES (AALA202511151327), (AALA202511158788). PER AMM 33-51-06SDR AALA202512096434Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER SECTION REAR SPAR RIGHT HAND VERTICAL STIFFENER AT BS 663. REPLACED STIFFENER IAW SRM 51-40-02.SDR AALA202512034946Wedge · delaminatedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND WING INBOARD FLAP OUTBOARD WEDGE ON MAIN FLAP DELAMINATED INSTALLED REPAIRED FLAP WEDGE. PER SRM 51-40-02.
Back to Boeing 737-823