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 AALA202210284472Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M2816 FAILS OPERATIONAL TEST. INOPERATIVE. REPLACED BATTERY PACK POWER SUPPLY PER AMM 33-51-06-960-806.SDR AALA202210286945Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1675 FAILS OPERATIONAL TEST. INOPERATIVE. REPLACED BATTERY PACK POWER SUPPLY PER AMM 33-51-06-960-806.SDR AALA202210282612Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1676 FAILS OPERATIONAL TEST. INOPERATIVE. REPLACED BATTERY PACK POWER SUPPLY PER AMM 33-51-06-960-806.SDR AALA202210288010Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1673 FAILS OPERATIONAL TEST. INOPERATIVE. REPLACED BATTERY PACK POWER SUPPLY PER AMM 33-51-06-960-806.SDR AALA202210285097Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1670 FAILS OPERATIONAL TEST. INOPERATIVE. REPLACED BATTERY PACK POWER SUPPLY PER AMM 33-51-06-960-806.SDR AALA202210285717Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1694 FAILS OPERATIONAL TEST. INOPERATIVE. REPLACED BATTERY PACK POWER SUPPLY PER AMM 33-51-06-960-806.SDR AALA202210282569Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1695 FAILS OPERATIONAL TEST. INOPERATIVE. REPLACED BATTERY PACK POWER SUPPLY PER AMM 33-51-06-960-806.SDR AALA202210284383Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1671 FAILS OPERATIONAL TEST. INOPERATIVE. REPLACED BATTERY PACK POWER SUPPLY PER AMM 33-51-06-960-806.SDR 2022F00426Light · burned outEMERGENCY EXIT LIGHT AT 19C FAILED TO ILLUMINATE.SDR AALA202211089320Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN INTERCOSTAL LOCATED AT BS 947.50 AND LBL 24.75. REPLACED INTERCOSTAL PER SRM 53-70-51-2R-5, AARD 51-00-05-1 AND DWG 147A5650.SDR AALA202211048681Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT FLOOR STRUCTURE MAIN FRAME FORWARD ATTACH ANGLE HAS CRACKS LOCATED AT STA 500G AND STR 26L. REMOVED AND REPLACED ATTACH ANGLE PER SRM 51-40-02-0G.SDR AALA202211046704Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN DECK AFT WET AREA BETWEEN STA 967 AND 986.5 AND LEFT BUTT LINE 17 APPROXIMATELY FLOOR SUPPORT UNDER SCREW HOLES CORRODED. REMOVED AND REPLACED FLOOR SUPPORT PER SRM 51-40-02-0G.SDR AALA202211040368Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO COMPARTMENT RIGHT FLOOR TRANSITION PANEL HAS AREAS OF CORROSION ON UPPER SURFACE BETWEEN STATION 727F AND STATION 787 AND LEFT BUTT LINE 25. REMOVED AND REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5SDR AALA202211040554Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND AFT FASTENER HOLE ON FLOOR BEAM AT STA 967 AND RIGHT BUT LINE 30. INSTALLED A SPLICE REPAIR PER SRM 53-00-51-2R-1.SDR AALA202211188641Web · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO DOOR LOWER SILL WEB CORRODED LOCATED BETWEEN STA 787 TO 847 AND STR 25R. REMOVED AND REPLACED INSTALLED SERVICEABLE AFT CARGO WEB SILL PER AARD 51-00-05-1.SDR AALA202211187344Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO AFT REMOVABLE BULKHEAD LOWER SUPPORT ANGLE HAS AREAS OF CORROSION LOCATED AT STA 500I AND BETWEEN RIGHT BUTT LINE 22 TO LEFT BUTT LINE 22. REMOVED AND REPLACED TRANSITION PANEL ASSEMBLY PER SRM 51-40-02.SDR AALA202211187120Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON SHIELD LOCATED BETWEEN 767 AND 787 AND STR 28R. REMOVED AND REPLACED SHIELD PER SRM 51-00-05-1.SDR AALA202211156830Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500C TO BS 500H AND LBL 25. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G. OPENSDR AALA202211088916Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM LOCATED AT BS 947 AND LBL 25. REPAIRED PER SRM 53-70-51-2R-5.SDR AALA202210310694Toilet · malfunctionedAIRCRAFT WAS GROUNDED: RIGHT AFT LAVATORY TOILET OVERFLOWING ABOVE 10000 FEET. FLIGHT DIVERTED TO DEN LANDING SAFELY. **SUPPLEMENTAL REPORT FOR AALA202210270694: REPLACED LAVATORY E VACUUM TOILET ASSEMBLY PER AMM 38-32-15.** (CLOSED)SDR AALA202303226837Engine · stalledAIRCRAFT WAS GROUNDED: RIGHT ENGINE COMPRESSOR STALLED AT FL-360 TWICE IN RAPID SUCCESSION. AUTO THROTTLES SPLIT AND RIGHT ENGINE WENT TO 40 PERCENT SMOOTH AIR. RAN CHECKLIST ITEMS AND ENGINE OPERATION WAS RESTORED. AIRCRAFT DIVERTED TO SLC AND DECLARED AN EMESDR AALA202211183752Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED TRANSITION PANEL LOCATED BETWEEN STA 500F AND 500I AND RIGHT BUTT LINE 22. REMOVED AND REPLACED TRANSITION PANEL PER AARD 51-00-05-1-R1.SDR AALA202211184410Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON TRANSITION PANEL LOCATED BETWEEN STA 500B AND 500F AND RIGHT BUTT LINE 22. REMOVED AND REPLACED TRANSITION PANEL PER AARD 51-00-05-1-R1.SDR AALA202211081523Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500B TO BS 500D, AT LBL 22. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-PROCEDURE 6 REPAIR 6.SDR AALA202211081681Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500D TO BS 500I, AT LBL 22. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-PROCEDURE 6 REPAIR 6.SDR AALA202210253385Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT INBOARD FLIGHT ATTENDANT FLASH LIGHT FAIL TEST. REMOVED AND REPLACED AFT LEFT INBOARD FLIGHT ATTENDANT FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA202210256304Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: LEFT FUSELAGE R1 DOOR EXTERIOR ENTER EXIT LIGHT DIM. REMOVED AND REPLACED LEFT FUSELAGE R1 DOOR EXTERIOR EMERGENCY EXIT LAMP PER AMM 33-51-04.SDR AALA202210257024Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: LEFT FUSELAGE FORWARD OVERWING ENTER EXIT LIGHT DIM. REMOVED AND REPLACED FORWARD OVERWING EMERGENCY EXIT LAMP PER AMM 33-51-04.SDR AALA202211042644Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: L1 DOOR LOWER SILL UPPER SURFACE CORRODED BETWEEN STA 320-345 AND LEFT BUTT LINE 60. REMOVED AND REPLACED L1 DOOR LOWER SILL PER SRM 51-40-02-0G.SDR AALA202211048774Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT FLOOR STRUCTURE STRINGER CLIP HAS CRACKS LOCATED AT STA 500I AND STR 26R. REMOVED AND REPLACED STRINGER CLIP PER SRM 51-40-02-0G.SDR AALA202210251535Retainer · out of adjustAIRCRAFT WAS NOT GROUNDED: GIRT BAR IS HARD TO ARM / DISARM. ADJUSTED BAR CLIP PER AMM 25-66-01.SDR AALA202210259653Gust Lock · bindingAIRCRAFT WAS NOT GROUNDED: GUST LOCK ON DOOR 1L IS DIFFICULT TO DISENGAGE. CLEANED AND LUBRICATED GUST LOCK AT DOOR 1L.SDR AALA202211147154Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER T CHORD LOCATED AT BS 947.5 FROM LBL 27 TO RBL 27. REPAIRED T CHORD PER SRM 53-70-51-2R-5 FIG 206 ALT R2.SDR AALA202211080145Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR AFT GIRT BAR FITTING LOCATED AT BS 344 AND LBL 58. REPLACED FITTING PER AARD 51-00-05.SDR AALA202211088968Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN INTERCOSTAL LOCATED FROM BS 947 TO BS 967, AT LBL 53. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND AIPC 53-42-51.SDR AALA202210242655Girt Bar · out of alignmentAIRCRAFT IN BASE MAINTENANCE: R1 SERVICE DOOR SLIDE MISALIGNED ON THE GIRT BAR. REPOSITIONED GIRT BAR ON R1 DOOR PER AMM 25-66-01.SDR AALA202210242574Retainer · looseAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR CLIP LOOSE. ADJUSTED R1 DOOR SLIDE GIRT BAR CLIP PER AMM 25-66-01.SDR AALA202210249081Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR STICKS HARD TO OPEN /CLOSE IN FLIGHT. RE-ADJUSTED LAVATORY D DOOR PER CMM 25-40-64.SDR AALA202210244903Computer · faultedAIRCRAFT WAS GROUNDED: ON TAKEOFF THROTTLES SPLIT AFTER TOGA WAS SELECTED. LEFT THROTTLE FROZE, RIGHT THROTTLE ADVANCED. AUTO THROTTLES KICKED OFF. REJECTED TAKEOFF AND RETURNED TO GATE. FOUND STALL MANAGEMENT YAW DAMPER (SYMD) FAULT. RESET AUTOMATIC FLIGHT CSDR AALA202210244049Lock · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR AND LOCK DIFFICULT TO OPEN / CLOSE. LUBRICATED AND ADJUSTED DOOR LOCK PER AMM 25-40-00.SDR AALA202210246386Fitting · looseAIRCRAFT WAS NOT GROUNDED: R1 DOOR EMERGENCY SLIDE GIRT BAR STOW CLIP LOOSE. RESECURED R1 DOOR EMERGENCY SLIDE GIRT BAR STOW CLIP.SDR AALA202211105066Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT TRANSITION PANEL, STA 727E - 727E + 8 AND RIGHT BUTT LINE 21. REMOVED AND REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA202211107571Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT TRANSITION PANEL, LOCATED BETWEEN STA 727 - 727D + 14 AND LEFT BUTT LINE 21. REMOVED AND REPLACED TRANSITION PANEL PER SRM 51-10-02.SDR AALA202211103797Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION RIGHT TRANSITION PANEL, LOCATED AT STA 727D + 8 AND RIGHT BUTT LINE 21. REMOVED AND REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA202211088045Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 727I TO BS 767, AT RBL 21. REPLACED TRANSITION PANEL PER SRM 51-40-02, SRM 51-20-01, AND AARD 51-00-05 REPAIR 1.SDR AALA202211044226Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION RIGHT TRANSITION PANEL LOCATED BETWEEN STA 767 AND 793 AND RIGHT BUTT LINE 21. REMOVED AND REPLACED AFT CARGO TRANSITION PANEL PER SRM 51-40-02.SDR AALA202210256016Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB STIFFENER LOCATED AT STABILIZER STA 129.5, SECOND VERTICAL STIFFENER FROM THE FORWARD SPAR. REPLACED RIB PER AARD 55-10-00-2 AND SRM 51-40-02.SDR AALA202210246224Retainer · looseAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR SLIDE GIRT IS LOOSE. ADJUSTED FORWARD ENTRY DOOR SLIDE GIRT BAR CLIP.SDR AALA202210247375Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT CABIN MEGAPHONE INOPERATIVE. REPLACED MEGAPHONE PER AMM 25-60-00.SDR AALA202210247493Bottle · low pressureAIRCRAFT WAS GROUNDED: R1 SLIDE BOTTLE PRESSURE LOW. REPLACED SLIDE PACK IAW AMM 25-66-01.
Back to Boeing 737-823