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 AALA202002039037Bulkhead Web · crackedAIRCRAFT WAS GROUNDED: CRACK ON RIGHT HAND MAIN LANDING GEAR WHELL WELL VERTICAL PRESSURE WEB AT BS 663.75 BETWEEN RBL 35.00 AND RBL 43.80. REPAIRED PRESSURE WEB PER EA 277741, SRM 57-10-10-2R-3 AND EA 302587.SDR AALA2020013109017Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: FORWARD INBOARD CABIN EMERGENCY FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED FORWARD INBOARD EMERGENCY FLASHLIGHT BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 25-64-00.SDR AALA202001309013Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY BATTERY PACK FAILED LIGHT TEST AT ROW 23 RIGHT SIDE TO AFT GALLEY PER MCM CARD 2908. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-06.SDR AALA2020013029909Light · inoperativeAIRCRAFT WAS NOT GROUNDED: DOOR RIGHT OVER WING EXIT LIGHT BY SEAT 14F WAS INOPERATIVE. MAINTENANCE REPLACED LIGHT ASSEMBLY 14F PER MM 33-21-00.*** (CLOSED)SDR AALA202002109004Lug · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND HORIZONTAL STABILIZER AFT SIDE OF LOWER ATTACH LUG. REPAIRED LUG PER EA 302129.SDR AALA202002079012Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED MID CABIN FLOOR SUPPORT AT BS 538 BETWEEN BL 0 AND LBL 23. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1SDR AALA202001319006Snubber · brokenAIRCRAFT NOT GROUNDED, L1 DOOR SNUBBER WAS BROKEN AS DOOR WAS OPENED. REMOVED AND REPLACED THE L1 DOOR SNUBBER IAW AMM 52-11-51.SDR AALA202001299002Blade · damagedAIRCRAFT WAS GROUNDED: 360FL, .78 MACH, AC STARTED SHAKING NOTICEABLE, AT OFF, SPARKS FROM ENGINE NR 1. N1 45 PERCENT EGT SLIGHTLY HIGH. PAX SAW FLAMES FROM ENG. ENG SHUT DOWN WITHIN 2 MIN. SINGLE ENG RUN TIME 40 MIN. PERFORMED FIM 71-05-00-810-805-F00 AND SDR AALA202001289032Engine · power lossAIRCRAFT WAS GROUNDED: ABORTED TAKE OFF AT APPROX. 85 KNOTS NO.1 ENGINE N1 AT 91.5, NO.2 AT 96.5. TAKE OFF POWER THROTTLES WERE,ALIGNED. NO.1 ENGINE WOULD NOT REACH TAKE OFF POWER. ACCOMPLISHED SIC # 05-96-17, HIGH ENERGY RTO.SDR AALA202001309010Bulb · faultyAIRCRAFT WAS NOT GROUNDED: L2 EMERGENCY EXTERIOR LIGHT INOPERATIVE. MAINTENANCE REPLACED BULB IAW AMM 33-51-04.SDR AALA2020013029007Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED. FORWARD EMERGENCY FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT IAW AMM 25-64-00.SDR AALA202001299010Ballast · inoperativeAIRCRAFT WAS NOT GROUNDED: OVERWING LIGHT INOPERATIVE AT RIGHT HAND FORWARD POSITION. MAINTENANCE REPLACED OVERWING LIGHT BALLAST PER AMM 33-21-00-960-807.SDR AALA202001299005Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS AT SEAT ROW 14 DEF INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK AT SEAT ROW 14 DEF PER AMM 33-51-06.SDR AALA202001289004Handle · lack of lubeAIRCRAFT NOT GROUNDED: GATE AGENT HAD DIFFICULTY OPENING L1 DOOR. STATED HANDLE DID NOT EXTEND FULLY BEFORE SHE COULD TURN IT. PERFORMED TROUBLESHOOTING PER FIM 52-10-00-810. CLEANED AND LUBRICATED EXTERIOR HANDLE AND DOOR IAW AMM 12-25-11.SDR AALA202001279032Spring · brokenAIRCRAFT WAS GROUNDED: RIGHT ELEVATOR TAB CONTROL MECHANISM, AFT OUTBD SPRING IS BROKEN. REMOVED AND REPLACED RT ELEVATOR TAB CONTROL MECHANISM AFT OUTBD SPRING IAW AMM 27-31-34.SDR AALA202002109001Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARRGO COMPARTMENT TRANSITION PANEL AT BS 470 AND LBL 23. REPAIRED TRANSITION PANEL PER EA 302679.SDR AALA202002079019Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500B AND BS 500C AT S26R. REPLACED TRNASITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202002079018Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500C AND BS 500D AT S26R. REPLACED TRNASITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202002079017Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500D AND BS 500E AT S26R. REPLACED TRNASITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202002079016Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500E AND BS 500F AT S26R. REPLACED TRNASITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202002079015Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500F AND BS 500G AT S26R. REPLACED TRNASITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202002079014Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500G AND BS 500H AT S26R. REPLACED TRNASITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202002079013Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500H AND BS 500I AT S26R. REPLACED TRNASITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2020020549065Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED VERTICAL PRESSURE DECK WEB AT BS 639 BETWEEN RBL 31.83 AND RBL 40. REPAIRED VERTICAL PRESSURE DECK WEB PER SRM 57-10-10-2R.SDR AALA202002049015Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CABIN FLOOR INTERCOSTAL BETWEEN BS 312 AND BS 328 AT LBL 47. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202002049014Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CABIN FLOOR INTERCOSTAL BETWEEN BS 328 AND BS 344 AT LBL 47. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2020012879007Battery · no testAIRCRAFT WAS NOT GROUNDED, L1 OUTBOARD SEAT FLASHLIGHT BATTERY LOW. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER CMM 25-60-13.SDR AALA2020012879006Battery · no testAIRCRAFT WAS NOT GROUNDED: INBOARD FLASHLIGHT BELOW FORWARD FLIGHT ATTENDANT JUMPSEAT NOT TESTING CORRECTLY. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA202001279025Sensor · faultyAIRCRAFT WAS GROUNDED, LE FLAPS TRANSIT LIGHT AFTER TAKE OFF, DURING FLAP RETRACTION. EMERGENCY DECLARED. FOUND LE FLAP F2 SENSOR FAULT. REPLACED THE SENSOR IAW AMM 27-88-11. LE FLAP INDICATION OPS CHECKED NORMAL.SDR AALA202001279022Warning Message · false indicationAIRCRAFT WAS GROUNDED, DURING CLIMB THRU 10,000 FT, NOTICED 2000 LB FUEL IMBALANCE, LEFT MAIN LOW, ALL INDICATIONS NORMAL. REDUCED POWER AND RETURNED DEPARTURE, FUEL IMBALANCE REDUCED TO 1500 WITH LOWER POWER SETTINGS ON DESCENT, NO FUEL LEAKS NOTED FROSDR AALA2020012749006Coupler · faultedAIRCRAFT NOT GROUNDED: UNABLE TO TRANSMIT ON HF2 AND ATTEMPTING TO TRANSMIT ON HF1 AND ARINC HAD DIFFICULTY HEARING US. BOTH HF RADIOS NEED TO BE CHECKED.***SUPPLEMENTAL ACTION SECT. 4 AND 5: REMOVED AND REPLACED HF#1 AND HF#2 ANTENNA. COUPLERS IAW AMM 23-11-SDR AALA202002049001Coupler · faultyAIRCRAFT NOT GROUNDED: UNABLE TO TRANSMIT ON HF2 AND ATTEMPTING TO TRANSMIT ON HF1 AND ARINC HAD DIFFICULTY HEARING US. BOTH HF RADIOS NEED TO BE CHECKED.***SUPPLEMENTAL ACTION SECT. 4 AND 5: REMOVED AND REPLACED HF#1 AND HF#2 ANTENNA. COUPLERS IAW AMM 23-11-SDR AALA202001249010Slide · partial deployAIRCRAFT WAS GROUNDED: RIGHT FORWARD SERVICE DOOR EMERGENCY SLIDE PARTIALLY EXTENDED FROM HOLDER.INADVERTANT OPENING DURING PRE FLIGHT. SLIDE GIRT BAR HAD BEEN LEFT ARMED BY PREVIOUS CREW, ORANGE STRAP WAS OUT OF VIEW. REMOVED AND REPLACED R1 DOOR SLIDE IAW SISDR AALA2020012439012Flashlight · misinstalledAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT DOOR 1L NOT CHARGING, WOULD NOT FLASH. ***SUPPLEMENTAL TO UPDATE SECTION 4 AND SECTION 5. MAINTENANCE REINSTALLED FLASHLIGHT IN PROPER CRADLE AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER MM 25-64-00-200-802.*** (CLOSDR AALA2020020549064Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK FIRST OFFICERS #1 WINDOW POST UPPER OUTBOARD CORNER CRACKED AT BS 214 AND S10R. REPAIRED WINDOW POST PER EA 302085.SDR AALA2020020549063Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK CAPTAINS #1 WINDOW POST UPPER OUTBOARD CORNER CRACKED AT BS 214 AND S10L. REPAIRED WINDOW POST PER EA 302084.SDR AALA2020012969003Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER LOWER SURFACE SKIN CRACKED IN 4 LOCATIONS BETWEEN STABILIZER STATION 101.90 AND STABILIZER STATION 129.50. REPAIRED HORIZONTAL STABILIZER LOWER SURFACE SKIN PER SRM 55-10-01-2R-11 FIGURE 204 DETAILSDR AALA2020012439011Light · inoperativeAIRCRAFT WAS NOT GROUNDED: INTERIOR EMERGENCY EXIT LIGHT ABOVE FORWARD GALLEY AISLE INOPERATIVE. MAINTENANCE PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-01.SDR AALA202001239004Circuit Breaker · trippedAIRCRAFT NOT GROUNDED: DIVERTED TO MIA, WX FAIL ON BOTH ND WHEN WEATHER RADAR TURNED ON AT ALTITUTE. FOUND C/B (P6-1 D13 WEATHER RADAR OPEN) CLOSED C/B AND ACCOMPLISHED WEATHER RADAR TEST IAW AMM 34-43-00. OPS CHECK OK IAW AMM 34-43-00.SDR AALA202001239007Warning Horn · activatedAIRCRAFT NOT GROUNDED: AUTOMATIC AURAL ALERT FOR V1 CALL OCCURS 4 KNOTS PRIOR TO V1. ALL AIRSPEED INDICATORS CONCUR CA/FO/HUD. ACCOMP TAKE OFF WARNING BITE TEST REF FIM 31-51-00 AND ADIRS BITE IAW FIM 34-21-00 WITH NO FAULTS.SDR AALA202001239008Warning Light · illuminatedAUTO-THROTTLE RED LIGHT FLASHING, UNCOMANDED DISCONNECT. CHECKED AND IAW FIM TASK 22-32-00 T/S AND PERFORMED A/T GND TEST. RESET A/T SYS. PERFORMED GND TEST. A/T SYS TEST NORMAL .SDR AALA202001249020Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: CAPTAINS #3 WINDOW CUT OUT E-F WINDOW POST FORWARD EDGE #2 FASTENER HOLE CRACKED AT BS 240 AND S11L. REPAIRED WINDOW POST PER EA 302088.SDR AALA202001249019Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: FIRST OFFICERS #3 WINDOW CUT OUT E-F WINDOW POST FORWARD EDGE #2 FASTENER HOLE CRACKED AT BS 240 AND S11R. REPAIRED WINDOW POST PER EA 302089.SDR AALA202001219023Window · delaminatedAIRCRAFT IN BASE MAINTENANCE: LOWER OUTER CORNER OF THE R1 WINDSHIELD HAS MILKY DELAMINATION. **SUPPLEMENTAL REPORT: REPLACED WINDSHIELD PER TASK CARD 08L2156004 ** (CLOSED).SDR AALA202001239028Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND MAIN LANDING GEAR WHEEL WELL VERTICAL PRESSURE DECK CRACKED / DAMAGED AT BS 663 BETWEEN RBL 31.83 AND RBL 40. REPAIRED PRESSURE DECK PER SRM 57-10-10-2R-3 ALT2.SDR AALA2020012329003Battery · dischargedAIRCRAFT WAS NOT GROUNDED: JUMP SEAT 1 FLASHLIGHT LOW ON POWER MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA202001229015Light · unknownAIRCRAFT NOT GROUNDED: FA REPORTS EMERGENCY FLOOR PATH LIGHTING FLICKERS INTERMITTENTLY IN THE VICINITY OF ROW 16. ACCOMPLISHED EMERGENCY LIGHT OPS CK IAW AMM 33-51-00, NO FAULTS NOTED AT THIS TIME.SDR AALA2020012219017Starter · faultedAIRCRAFT WAS GROUNDED: DURING NR 2 ENGINE STARTER, NO ROTATION AND SPARKS REPORTED BY GROUND CREW FROM UNDER THE ENGINE. ENGINE STARTER ENGAGED FOR 10 SECONDS. MAINTENANCE REPLACED THE NR 2 ENGINE STARTER IAW AMM 80-11-01.SDR AALA2020012219018Coffeemaker · odorAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTED BURNING ELECTRICAL SMELL IN AFT GALLEY. AFTER TURNING OFF POWER, COFFEE MAKER SMELL BECAME LESS INTENSE. BOTH COFFEE MAKERS REMAINED OFF FOR DURATION OF FLIGHT AS A PRECAUTION. MAINTENANCE TROUBLESHOT AND RSDR AALA202001219001Fmc · faultedAIRCRAFT WAS GROUNDED: FMC FAIL INFLIGHT. 1ST L FAILED AND BOTH CDUS - NO FMC. PUT ON )'2 AUTO PILOT RESTORED L NAV/V NAV THEN B FAILED AND L CAME BACK WITH CDUS. RESTORED AP1 AND L NAV/VMAV AND AFTER A FEW MINUTES FMC 2 RESTORED. REMOVED AND REPLACED FMCS I
Back to Boeing 737-823