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 AALA202404036326Flashlight · inoperativeAIRCRAFT IN BASE MAINTENANCE: FORWARD AFT HAND FLASHLIGHT NEEDS REPLACEMENT. REMOVED AND REPLACED FORWARD AFT HAND FLASHLIGHT. PER B737NG IPC 25-64-61 AND SRM 51-40-02.SDR AALA202404032215Flashlight · inoperativeAIRCRAFT IN BASE MAINTENANCE: AFT RIGHT HAND FLASHLIGHT REQUIRE REPLACMENT. REMOVED AND REPLACED AFT RIGHT HAND FLASHLIGHT. PER B737NG IPC 25-64-61 ASND SRM 51-40-02.SDR AALA202404014516Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR IS DIFFICULT TO OPEN AND CLOSE. REMOVED AND RE-ATTACHED LAV D DOOR FOR ALIGNMENT.SDR AALA202404017698Transmitter · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: DECREASING HYDRAULIC QUANTITY FLIGHT, ATTENDDANT REPORTED SEEING FLUID LEAKING; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MIA. REMOVED AND REPLACED SYSYTEM "A" HYDRAULIC FLUID QUANTITY TRANSMITTER. PSDR AALA202404012065Flashlight · faultyAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT FORWARD FLASHLIGHT WILL NOT TURN OFF. REMOVE AND REPLACE FLASHLIGHT. PER MM 25-64-00.SDR AALA202404018588Slide · unsecureAIRCRAFT WAS GROUNDED: AFT LEFT ENTRY DOOR SLIDE HANGS DOWN MORE THAN NORMAL WHEN ARMED.SDR AALA202404014652Pressure Switch · faultyAIRCRAFT WAS NOT GROUNDED: RIGHT CENTER BOOST PUMP LOW PRESSURE LIGHT STAYS ILLUMINATED WITH 0.3 INDICATED IN THE CENTER. REMOVED AND REPLACED LEFT CENTER FUEL BOOST PUMP PRESSURE SWITCH. LEAK CHECK AND OPERTIONAL CHECK GOOD. PER AMM 28-42-11.SDR AALA202404017281Sign · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN BY THE 2L JUMPSEAT FELL OFF. RESECURED EMERGENCY EXIT SIGN AT 2L JUMPSEAT, OPERTIONAL CHECK GOOD. PER AMM 33-51-00.SDR AALA202404013189Flashlight · dischargedAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY FLIGHT ATTANDENT INBOARD SEAT FLASHLIGHT BATTERY BAD. REMOVE AND REPLACED FLASHLIGHT BATTERY AT FORWARD GALLEY FLIGHT ATTANDENT INBOARD SEAT. OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202404016004None · noneAIRCRAFT IN BASE MAINTENANCE: EXISTING REPAIR TO AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 947 TO BS 967, RBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202404017371Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY (LAVATORY E), DOOR STICKING ON LOWER RIGHT SIDE. CLEANED AND LUBRICATED BOTTOM OF DOOR.SDR AALA202404055876Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT BS 540 FROM RBL 1 TO RBL 4. REPLACED BREAK ASSEMBLY PER AARD 51-00-05-1.SDR AALA202404022439Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT BS 540, FROM LBL 1 TO LBL 4. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202404019697Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY D (AIRCRAFT LEFT) DOOR DIFFICULT TO OPEN AND CLOSE. LUBED TRACK AND HINGES LAVATORY D DOOR PER CMM 25-40-58.SDR AALA202404014977Screw · looseAIRCRAFT WAS NOT GROUNDED: AFT LAV E ENTRY DOOR STUCK CLOSED DURING CRUISE FLIGHT FOUND LOOSE SCREW ON DOOR LATCH. SECURED SCREW AND OPS CHECK IAWCMM 25-40-59. OK FOR SERVICE.SDR AALA202404014281Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT ON AFT RIGHT HAND FLIGHT ATTANDENT SEAT IS INOPERATIVE. REMOVED AND REPLACED AFT RIGHT HAND FLIGHT ATTANDENT FLASHLIGHT. PER AMM 25-64-00.SDR AALA202404019090Slide · damagedAIRCRAFT IN BASE MAINTENANCE: AFT-2L PASSENGER DOOR ESCAPE SLIDE GIRT HAS A HOLE WORN THROUGHIT. INSTALLED SERVICEABLE L2 SLIDE. PER CARD 08L22125001.SDR AALA202404010300Megaphone · inoperativeAIRCRAFT WAS NOT GROUNBDED: MEGAPHONE IN THE FORWARD GALLEY HAS AN EXPIRATION LISTED PAST DUE. REMOVED AND REPLACED MEGAPHONE AT FORWARD GALLEY. OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202404015464Slide · detachedAIRCRAFT WAS NOT GROUNDED: MAINTENANCE FOUND L2 DOOR SLIDE HAS FALLING OUT OF BUSTLE AND IS LAYING ON AFT GALLEY FLOOR. SLIDE DID NOT DEPLOY. REINSTALLED L2 DOOR ESCAPE SLIDE. PER AMM 25-66-01-400-804.SDR AALA202404010840Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR WILL NOT OPEN. APPEARS SOMETHING BLOCKING DOOR FROM INSIDE. ADJUSTED AFT LAVATORY DOOR.SDR AALA202404220357Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL FROM BS 500D TO BS 500E, RBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202404228335Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500C TO BS 500D, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202404171370Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM UPPER CHORD AT BS 947.5, RBL 18. REPAIRED PER SRM 53-70-51-2R-8 ALTERNATIVE 2 AND EA 353161.SDR AALA202404048381Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT ECS BAY VERTICAL SUPPORT ANGLE AT BS 663.75, BL 0. REPLACED SUPPORT ANGLE PER EA 352898 & SRM 51-40-02.SDR AALA202404046191Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB THIRD STIFFENER FROM FRONT SPAR, LOCATED AT STABILIZER STA 111.10, REPAIRED RIB PER SRM 55-10-01-2R-4.SDR AALA202404031828Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT IN AISLE 21C FELL OFF. **SUPPLEMENTAL REPORT FOR (AALA202404011828): REMOVE AND REPLACED SEAT MOUNTED EMERGENCY LIGHT ASSYMBLY. FUNCATIONAL CHECK GOOD. PER AMM REF 33-51-11**(CLOSED).SDR AALA202404014203Light · unsecureAIRCRAFT WAS NOT GROUNDED: OVERHEAD EMERGENCY EXIT LIGHT OVER ROW 16 DEF HANGING DOWN. SECURED ROW 16DEF EMERGENCY AISLE LIGHT (EAL) ASSEMBLY. OPERTIONAL CHECK GOOD. PER AMM 33-51-03.SDR AALA202404013680Float Valve · crackedAIRCRAFT WAS GROUNDED: ON CLIMBING OUT GOT AN AMBER FUEL IMBALANCE. FOUND LEFT TANK VENT FLOAT VALVE CRACKED, REPLACED AS PER MM 28-13-11-400-801. NO LEAKS NOTED.SDR AALA202404011828Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT IN AISLE 21C FELL OFF. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404014084Tube · missingAIRCRAFT WAS NOT GROUNDED: L1 DOOR GIRT BAR MISSING RED PLASTIC COVERING ON OUTER EDGE. INSTALLED HEAT SHRINK MISSING AT NUMBER 1L DOOR. PER AMM 25-66-00.SDR AALA202404010159Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202404018021Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202404013957Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202404019043Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202404019511Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202404010236Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202404010532Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202404013307Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202404013179Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202404015814Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202403283306Door · bindingAIRCRAFT WAS NOIT GROUNDED: LEFT REAR LAVATORY DOOR STICKS THE DOOR STICKS ON THE BOTTOM ON THE LEFT SIDE. ADJUSTED AFT LEFT LAVATORY DOOR. PER CMM 25-40-64.SDR AALA202403288650Transceiver · failedAIRCRAFT WAS GROUNDED: INTERMITTENT ELECTRICAL SMELL IN FLIGHT DECK. REMOVED AND REPLACED WEATHER RADAR TRANSCEIVER. PER AMM 34-43-31. GROUND CHECKED OK.SDR AALA202403289033Transceiver · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WEATHER RADAR FAIL ON PILOT AND COPILOT SIDE; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. REMOVED AND REPLACED WEATHER RADAR TRANSCEIVER. GROUND CHECKED OK. PER AMM 34-43-31.SDR AALA202404034448Shroud · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLOOR LIGHT HOUSING AT SEAT 18C IS NOT ATTACHED TO THE SEAT. REMOVED AND REPLACED SHROUD ASSEMBLY AT SEAT 18C. PER CMM 25-23-67**(CLOSED).SDR AALA202403288387Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY BIN MOUNTED AISLE LIGHT BETWEEN ROWS 17 AND 18 ABC DOES NOT ILLUMINATE. FOUND CONNECTOR D12038 NOT CONNECTED PROPERLY, RECONNECTED CONNECTOR, FUNCATIONAL CHECK GOOD.SDR AALA202403283886Flashlight · missingAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT UNDER FORWARD FLIGHT ATTENDANT JUMP SEAT MISSING.**SUPPLEMENTAL REPORT FOR (AALA202403273886): REPLACED FLASHLIGHT AT FORWARD FLIGHT ATTENDENT SEAT AS REQUIRED. PER AMM 25-64-00**(CLOSED).SDR AALA202403282862Sign · brokenAIRCRAFT WAS NOT GROUNDED: AFT ENTRY EXIT SIGN BROKEN.**SUPPLEMENTAL REPORT FOR (AALA202403272862): REMOVED AND REPLACED AFT LEFT DOOR EMERGENCY LIGHT LENS COVER. PER AMM 33-51-01**(CLOSED).LENSDR AALA202403277354Slide · dislodgedAIRCRAFT WAS GROUNDED: GATE AGENT OPENED 1L DOOR WHILE STRAP AND SLIDE (GIRT BAR) WAS ARMED. SLIDE DROP FROM SLIDE CONTAINER. REMOVED AND REPLACED L1 DOOR SLIDE ASSEMBLY. PER WC# 08L22125001.SDR AALA202403271415Sign · missingAIRCRAFT WAS NOT GROUNDED: AFT SERVICE DOOR EXIT SIGN IS MISSING. INSTALLED MISSING AFT SVC DOOR EXIT SIGN LENS. PER AMM 33-51-01.SDR AALA202403274448Housing · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLOOR LIGHT HOUSING AT SEAT 18C IS NOT ATTACHED TO THE SEAT. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).
Back to Boeing 737-823