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 AALA202103039008Shroud · detachedAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT SHROUD DETACHED AT 20C. REMOVED AND REPLACED EMERGENCY LIGHT SHROUD AT SEAT 20C PER ESO 60882.SDR AALA202103039009Light · brokenAIRCRAFT WAS NOT GROUNDED: AISLE EMERGENCY LIGHTS HANGING OFF SEAT 23C. MEL AUTHORIZED. REMOVED AND REPLACED AISLE EMERGENCY LIGHT IAW AMM 33-51-01.SDR AALA202103059031Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: BAFFLE CLIP CRACKED AT STA 500H AND STR 25R. INSTALLED NEW BAFFLE CLIP PER AARD 51-00-05-1, BOEING DRAWING 143A7505, AND AA DRAWING CBF1699.SDR AALA202103059030Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORRODED TRANSITION PANEL AT 500A-5001 AND 25L. SPLICED IN NEW SECTION OF TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202103049015Fuse · blownAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT INOPERATIVE OUTSIDE RH BELLY AREA. REPLACED FUSE WITH NEW AT BATTERY PACK M1671 IAW AMM 33-51-06, OPS CHECK GOOD.SDR AALA202103049014Fuse · blownAIRCRAFT IN BASE MAINTENANCE: EMERGENCY ESCAPE PATH LIGHTS INOPERATIVE AT SEATS 1-4AB. REPLACED FUSE WITH NEW AT BATTERY PACK M2816 IAW AMM 33-51-06, OPS CHECK GOOD.SDR AALA202103049013Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: R1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED FUSE WITH NEW AT BATTERY PACK M2816 IAW AMM 33-51-06, OPS CHECK GOOD.SDR AALA202103029012Lanyard · disconnectedAIRCRAFT WAS NOT GROUNDED: WIRE STICKING OUT FROM R1 SLIDE COVER. RECONNECTED R1 SLIDE PACK COVER LANYARD IAW AMM 25-66-01.SDR AALA202103029011Bustle · obstructedAIRCRAFT WAS NOT GROUNDED: R1 DOOR SLIDE BUSTLE OBSTRUCTS VIEW OF THE GIRT BAR WHILE ARMING AND DISARMING DOOR. SECURED R1 SLIDE BUSTLE OUT OF THE WAY.SDR AALA202103199027Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND 0.5 INCH CRACK IN BREAK ASSEMBLY AT STA 540 AND LBL 0 TO LBL 20. REMOVED AND REPLACED BREAK ASSEMBLY IAW SRM 51-10-02.SDR AALA202103019008Bolt · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AFT ENTRY DOOR 2L HANDLE MOVES SLIGHTLY UPWARDS TOWARDS OPEN WHEN PRESSURIZED. SECURED AFT 2-L DOOR INBOARD HANDLE SUPPORT BOLT IAW AMM 53-13-31-400-802.SDR AALA202102259008Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: RH AFT FLIGHT ATTENDANT SEAT FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT WITH SERVICEABLE UNIT IAW AMM 25-64-00, OPS CHECK GOOD.SDR AALA202103119014Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: AT STA 540, EXPANSION JOINT FRAME FLOORBOARD SUPPORT AT LBL 2 CRACKED, MEASURING 2 INCHES LONG. REMOVED DAMAGED FLOORBOARD SUPPORT IAW SRM 51-40-02. INSTALLED NEW FLOORBOARD SUPPORT IAW AA IPC 53-42-11-66 AND BOEING INSTALLATION DSDR AALA202103059032Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: AT STA 540 EXPANSION JOINT FRAME AT RBL 2 CRACKED. REMOVED AND REPLACED RIGHT FLOORBOARD SUPPORT AT STA 540 PER IPC 53-42-11-66 AND SRM 51-40-01.SDR AALA202102269020Windshield · scratchedAIRCRAFT WAS GROUNDED: L1 WINDSHIELD SCRATCHED. REPLACED L1 WINDOW WITH SERVICEABLE UNIT IAW WORKCARD 56-94-03.SDR AALA202102269022Fuse · blownAIRCRAFT IN BASE MAINTENANCE: R2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED FUSE WITH NEW AT POWER SUPPLY M01672, OPS CHECK GOOD.
SDR AALA202102269021Fuse · blownAIRCRAFT IN BASE MAINTENANCE: EMERGENCY PATH LIGHTING INOPERATIVE AT SEATS 26-33ABC. REPLACED FUSE WITH NEW AT POWER SUPPLY M01672, OPS CHECK GOOD.SDR AALA202102259006Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: SERVICE DOOR R1 GIRT BAR RIGHT CLIP IS TOO TIGHT. ADJUSTED CLIP AT R1 DOOR GIRT BAR IAW AMM 25-66-02.SDR AALA202102259010Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: SECOND FLASHLIGHT AT 4L JUMP SEAT WILL NOT TEST. REPLACED BATTERIES PER AMM 25-64-00.SDR AALA202102259009Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT 4L JUMP SEAT WILL NOT TEST. REPLACED BATTERIES PER AMM 25-64-00.SDR AALA202102259007Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT 4R JUMP SEAT WILL NOT TEST. REPLACED BATTERIES PER AMM 25-64-00.SDR AALA202102269013Regulator · failedAIRCRAFT WAS GROUNDED: ON CLIMBOUT RIGHT DUCT PRESSURE FLUCTUATIONS FOLLOWED BY LEFT PACK ILLUMINATION. PACK LIGHT INITIALLY CLEARED WITH TRIP RESET BUT RETURNED WITHIN 1 MINUTE. **SUPPLEMENTAL INFORMATION: ACCOMPLISHED TSM IAW JOB CARD 36-95-01 AND LEFT ENGISDR AALA202102269019Window · crackedAIRCRAFT WAS GROUNDED: R1 WINDOW OUTER PANE CRACKED IN CRUISE AT FL250. REPLACED R1 WINDOW WITH SERVICEABLE UNIT IAW WORKCARD 08L21056004.SDR AALA202102239009Girt Bar · out of positionAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED FORWARD SERVICE DOOR UNABLE TO ENGAGE GIRT BAR. REPOSITIONED GIRT BAR AND ENGAGED. OPERATIONS CHECK OK.SDR AALA202102239010Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: 1L SLIDE PACK FALLING OUT. SECURED AND STOWED 1L SLIDE ASSEMBLY PART.SDR AALA202102239018Fmc · failedAIRCRAFT WAS GROUNDED: DUAL FLIGHT MANAGEMENT COMPUTER FAILURE, FLIGHT DIVERTED TO SJU AND LANDED WITHOUT INCIDENT. REPLACED RT FMC AND LT FMC (AALA202102239011) IAW AMM 34-61-02, OPS CHECK GOOD.SDR AALA202102239011Fmc · failedAIRCRAFT WAS GROUNDED: DUAL FLIGHT MANAGEMENT COMPUTER FAILURE, FLIGHT DIVERTED TO SJU AND LANDED WITHOUT INCIDENT. REPLACED LT FMC AND RT FMC (AALA202102239018) IAW AMM 34-61-02, OPS CHECK GOOD.SDR AALA202102229020Stop · missingAIRCRAFT WAS NOT GROUNDED: WHITE STOPPER ON THE LT AFT ENTRY DOOR GIRT BAR IS MISSING. INSTALLED STOPPER WITH NEW IAW AMM 25-66-01.SDR AALA202102229017Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LH FLIGHT ATTENDANT STATION FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT WITH SERVICEABLE UNIT IAW AMM 25-64-00-900-806, OPS CHECK GOOD.SDR AALA202102229010Sliding Window · out of positionAIRCRAFT WAS NOT GROUNDED: R2 SLIDING WINDOW CAME OUT OF TRACK. NO DEFECTS NOTED, RETURNED WINDOW TO PROPER POSITION IN TRACK IAW AMM 56-12-11-000-801, OPS CHECK GOOD.SDR AALA202102229009Window · delaminatedAIRCRAFT WAS NOT GROUNDED: PLEASE INSPECT FRONT WINDSHIELD AT UPPER LEFT CORNER FOR POSSIBLE DELAMINATION ON INSIDE PANE. **SUPPLEMENTAL REPORT: REMOVED AND REPLACED CAPTAINS WINDSHIELD PER WORK CARD NUMBER 08L21056003.SDR AALA202102239017Fuse · blownAIRCRAFT IN BASE MAINTENANCE: EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED FUSE WITH NEW AT BATTERY PACK M1671, OPS CHECK GOOD.SDR AALA202102229018Light · detachedAIRCRAFT IN BASE MAINTENANCE: FOUND OVERHEAD EMERGENCY EXIT LIGHT PANEL BETWEEN AFT LAVATORIES HANGING DOWN. RE-SECURED EMERGENCY EXIT LIGHT PANEL IAW AMM 33-51-00.SDR AALA202102199011Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: GIRT BAR ON FORWARD SERVICE DOOR IS DIFFICULT TO ARM AND DISARM ON THE RIGHT SIDE. LUBRICATED GIRT BAR BRACKET R1 DOOR WITH STANDARD MAINTENANCE PRACTICES.SDR AALA202102199012Handle · lack of lubeAIRCRAFT WAS NOT GROUNDED: L1 CABIN ENTRY DOOR HANDLE IS DIFFICULT TO OPERATE. LUBED L1 CABIN ENTRY DOOR HANDLE AS PER AMM 53-10-00.SDR AALA202102199017Fuse · blownAIRCRAFT IN BASE MAINTENANCE: INOPERATIVE EMERGENCY LIGHTS AT SEATS 1-4AB. REPLACED FUSE WITH NEW AT BATTERY CHARGER M2286 IAW AMM 33-51-06, OPS CHECK GOOD.SDR AALA202102199016Switch · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING CLIMB, RT PACK INOPERATIVE LIGHT ILLUMINATED; FLIGHT DIVERTED TO MIA AND LANDED WITHOUT INCIDENT. REPLACED COMPRESSOR DISCHARGE TEMPERATURE SWITCH IAW AMM 21-51-40, OPS CHECK GOOD.SDR AALA202102189016Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND LEFT MAIN LANDING GEAR WHEEL WELL BETWEEN LEFT BUTT LINE 31.83 AND 40.00 APPROXIMATELY .350 LONG. ACCOMPLISHED REPAIR OF PRESSURE DECK PER SRM 57-10-10-2R-4 PART 6.SDR AALA202102189023Fuse · blownAIRCRAFT IN BASE MAINTENANCE: R4 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED FUSE WITH NEW AT POWER SUPPLY M1671 IAW AMM 33-51-06, OPS CHECK GOOD.SDR AALA202102189022Fuse · blownAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTS INOPERATIVE AT SEATS 26-33ABC. REPLACED FUSE WITH NEW AT POWER SUPPLY M1672 IAW AMM 33-51-11, OPS CHECK GOOD.SDR AALA202102189021Fuse · blownAIRCRAFT IN BASE MAINTENANCE: BLOWN FUSE ON BATTERY PACK D12008 AT STA 585L. REPLACED FUSE WITH NEW, OPS CHECK GOOD.SDR AALA202102189020Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: L2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT BULB WITH NEW, OPS CHECK GOOD.SDR AALA202102189018Display · inoperativeAIRCRAFT WAS GROUNDED: STANDBY ATTITUDE INDICATOR FAILED, FLIGHT DIVERTED TO PHX AND LANDED WITHOUT INCIDENT. REPLACED INTEGRATED STANDBY FLIGHT DISPLAY WITH SERVICEABLE UNIT IAW AMM 34-24-02, OPS CHECK GOOD.SDR AALA202102179010Stop Fitting · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN. ADJUSTED DOOR STOP IAW 52-50-00, OPS CHECK GOOD.SDR AALA202102179011Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY D DOOR DIFFICULT TO OPEN. ADJUSTED LAVATORY D DOOR PER AMM 25-40-00.SDR AALA202102179009Shroud · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 28C EMERGENCY LIGHT SHROUD BROKEN. REPLACED SHROUD PER CMM 25-21-63.SDR AALA202102159026Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN ABOVE 2L DOOR FELL OFF. REPLACED LIGHT ASSEMBLY WITH NEW IAW AMM 33-51-01, OPS CHECK GOOD.SDR AALA202102159032Knob · looseAIRCRAFT WAS NOT GROUNDED: LAVATORY A FRONT DOOR DIFFICULT TO OPEN. TIGHTENED DOOR KNOB AT LAVATORY A IAW AMM 25-40-00, OPS CHECK GOOD.SDR AALA202102159029Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY D DOOR DIFFICULT TO OPEN. ADJUSTED LAVATORY D DOOR IAW AMM 25-40-00, OPS CK GOOD.SDR AALA202102159027Door · bindingAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR DIFFICULT TO OPEN FROM CABIN. REQUIRES FIRM PULL TO OPEN DOOR FROM PASSENGER SIDE AND OVERCOME SPRING TENSION OF ELECTRIC STRIKE. DOOR OPENS AS REQUIRED PER AMM 52-51-03. DOOR OPERATION NOT FAULTY.
Back to Boeing 737-823