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 AALA2020020759004Sign · missingAIRCRAFT WAS NOT GROUNDED: OVERWING EXIT SIGN COVER MISSING AT 16A. MAINTENANCE REPLACED EXIT SIGN PER AMM 33-51-01.SDR AALA2020020759003Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT L1 INOPERABLE. MAINTENANCE REPLACED FLASHLIGHT PER AMM 25-64-00.SDR AALA202002069003Amplifier · failedAIRCRAFT WAS GROUNDED: CAPTAINS COMMUNICATION COMPLETELY INOPERATIVE USING ANY HEADSET. INTERCOM LOUD BUZZ. ATC-VHF LOUD BUZZ MISSED ATC CALLS INCOMING TWICE. HANDSET COMMUNICATION SEEMS TO WORK FINE. AFTER SWITCHING HEADSETS TO PERSONAL SINGLE PLUG HEADSET SDR AALA202002069006Slide · unknownAIRCRAFT NOT GROUNDED: R2 SLIDE REQUIRES REPLACEMENT. REMOVED AND INSTALLED NEW R2 SLIDE IAW AMM 25-66-01.SDR AALA202002059018Vane · faultyAIRCRAFT WAS GROUNDED: DIVERTED TO TUL ACCOUNT AIR SPEED LIMIT WARNING INDICATION. AN EMERGENCY WAS DECLARED. AFTER TAKEOFF SPD LIM AMBER MESSAGE DISPLAYED ON CAPT PFD FLASHED ON AND OFF DURING FLIGHT WITH BARBER POLE RISING UP CLOSE TO CURRENT AIRSPEED FO SSDR AALA202002059020Computer · faultyAIRCRAFT WAS GROUNDED: DIVERTED TO TUL ACCOUNT AIR SPEED LIMIT WARNING INDICATION. AN EMERGENCY WAS DECLARED. AFTER TAKEOFF SPD LIM AMBER MESSAGE DISPLAYED ON CAPT PFD FLASHED ON AND OFF DURING FLIGHT WITH BARBER POLE RISING UP CLOSE TO CURRENT AIRSPEED FO SSDR AALA202002059021Display · faultyAIRCRAFT WAS GROUNDED: DIVERTED TO TUL ACCOUNT AIR SPEED LIMIT WARNING INDICATION. AN EMERGENCY WAS DECLARED. AFTER TAKEOFF SPD LIM AMBER MESSAGE DISPLAYED ON CAPT PFD FLASHED ON AND OFF DURING FLIGHT WITH BARBER POLE RISING UP CLOSE TO CURRENT AIRSPEED FO SSDR AALA202002059022Battery Pack · inoperativeAIRCRAFT IN BASE SPECIAL VISIT: POSITION 1 FLASHLIGHT INOPERATIVE. REPLACED BATTERY PACK IAW AMM 25-64-00-900-806.SDR AALA202002059023Battery Pack · inoperativeAIRCRAFT IN BASE SPECIAL VISIT: POSITION 2 FLASHLIGHT INOPERATIVE. REPLACED BATTERY PACK IAW AMM 25-64-00-900-806.SDR AALA202002059024Battery Pack · inoperativeAIRCRAFT IN BASE SPECIAL VISIT: POSITION 3 FLASHLIGHT INOPERATIVE. REPLACED BATTERY PACK IAW AMM 25-64-00-900-806.SDR AALA202002059025Battery Pack · inoperativeAIRCRAFT IN BASE SPECIAL VISIT: POSITION 4 FLASHLIGHT INOPERATIVE. REPLACED BATTERY PACK IAW AMM 25-64-00-900-806.SDR AALA202002249041Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500 AND BS 500A AT RBL 24. REPLACED TRANSITION PANEL PER AARD 55-00-05 AND EA 302969.SDR AALA2020024219001Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500A AND BS 500B AT RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2020022049043Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500D AND BS 500E AT LBL 26. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5, AARD 51-00-05, SRM 51-40-02.SDR AALA2020022049042Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500C AND BS 500D AT LBL 26. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5, AARD 51-00-05, SRM 51-40-02.SDR AALA2020022049041Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500B AND BS 500C AT LBL 26. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5, AARD 51-00-05, SRM 51-40-02.SDR AALA2020022049040Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500 AND BS 500A AT LBL 26. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5, AARD 51-00-05, SRM 51-40-02.SDR AALA2020022049047Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500F AND BS 500G AT LBL 26. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5, AARD 51-00-05, SRM 51-40-02..SDR AALA2020022049045Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN STATION 500E AND 500F AT LBL 26. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5, AARD 51-00-05, SRM 51-40-02.SDR AALA2020021879018Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO DOOR CUT OUT LOWER SILL PLATE WEB BETWEEN BS 794 AND BS 827 AT S24R. REPLACED SILL PLATE WEB PER AARD 51-00-05.SDR AALA2020020549007Autobrake Sys · malfunctionedAIRCRAFT NOT GROUNDED: AUTOBRAKE SYSTEM DISARMED ON TOUCHDOWN WITH NO BRAKE OR INPUT.***SUPPLEMENTAL ACTION SECT 4: TROUBLESHOOT IAW FIM 32-42-00-810-828 NO FAULTS FOUND. PERFORMED AACU BITE CHECK IAW 32-42-00-810-801 BITE CHECK GOOD.***(CLOSED)SDR AALA2020021329022Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP ON THE FORWARD SIDE OF FRAME AT BS 500G AND S25R. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA202002109005Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND STABILIZER LOWER SURFACE SKIN AT STATION 175.5 AND 11 INCHES FORWARD OF THE AFT SPAR AT STABILIZER BL 130. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA2020030369008Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LOWER BULKHEAD ANGLE AT BS 500I BETWEEN LBL 24 AND RBL 24. REPLACED ANGLE PER SRM 51-40-02.SDR AALA2020024219003Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA FLOOR SHEAR WEB AT BS 987 ABD RBL 33. REPAIRED SHEAR WEB PER EA 303101SDR AALA2020022049039Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT / TRANSITION ANGLE AT BS 887 AND S24R. REPLACED FLOOR SUPPORT / TRANSITION ANGLE PER AARD 51-00-05-1 AND SRM 53-00-53-2R.SDR AALA2020022049038Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727 AND BS 767 AT RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA2020022049036Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM AT BS 986.5 AND RBL 42. REPAIRED FLOOR BEAM PER EA 303034 AND SRM 53-00-51-2R.SDR AALA2020022049033Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AFT CABIN WET AREA FLOOR SUPPORT ANGLE AT BS 993 AND LBL 42. REPLACED SUPPORT ANGLE PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA20200249032Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA FLOOR CREASE ANGLE BETWEEN BS 992 AND BS 995 AT LBL 45. REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA2020022049027Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500H AND BS 500I AT LBL 26. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5, AARD 51-00-05, SRM 51-40-02.SDR AALA2020022049051Attach Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD ATTACHMENT CLIP AT BS 767 AND S25R. REPLACED CLIP PER SRM 51-10-02 AND AARD 51-00-05-1.SDR AALA2020022049050Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD BETWEEN BS 767 AND BS 787 AT S25R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA2020022049048Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500G AND 500H AT LBL 26. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5, AARD 51-00-05, SRM 51-40-02.SDR AALA202002059001Autothrottle Sys · malfunctionedAIRCRAFT NOT GROUNDED: AFTER TOUCHDOWN WITH SPEEDBRAKES DEPLOYED, AUTO THROTTLE TRIED TO ADVANCE THROTTLES. PERFORMED AUTO THROTTLE BITE IAW AMM 22-11-00. FAULTS FOUND FOR R/A SYSTEM. PERFORMED R/A RESET AND OPS CHECK; ALL CHECKS FOUND GOOD.SDR AALA202002059005Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND EMERGENCY EXIT WING LOWER INOPERATIVE. MAINTENANCE REPLACED LAMP PER AMM 33-51-04.SDR AALA202002039021Slide · out of alignmentAIRCRAFT WAS GROUNDED: R1 DOOR SLIDE IS COMING OUT OF CASE. INSPECTED AND REMOVED AND REPLACED FWD GALLEY ESCAPE SLIDE IAW WORK CARD 08L2225001 25-94-11.SDR AALA2020020539029Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY SMOKE ALARM SOUNDED. NO ONE WAS IN LAVATORY AND ALARM STOPPED AFTER A FEW MINUTES. MAINTENANCE PERFORMED SATISFACTORY LAVATORY SMOKE DETECTION SYSTEM TEST IAW MM 26-14-00.SDR AALA2020020549062Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND MAIN LANDING GEAR WHEEL WELL VAPOR BARRIER BETWEEN RBL 34 AND RBL 36 AT THE 4TH BAY OUTBOARD OF THE KEEL BEAM. REPAIRED VAPOR BARRIER PER AARD 57-10-40-9 AND SRM 57-10-10-2R2.SDR AALA202002039007Control Unit · faultyAIRCRAFT WAS GROUNDED: L WING BODY OVERHEAT LIGHT CAME ON DURING CLIMBOUT. LIGHT WAS ON FOR APPROX 14 MINS. RETURNED TO SJO, EMERGENCY LANDING. DURING T/S, FOUND DISPLAY TEST BUTTON STUCK IN OPEN PISITION, REMOVED AND REPLACED COMPARTMENT OVERHEAT DETECTION COSDR AALA202002039030Accumulator · faultyAIRCRAFT WAS GROUNDED: NO BRAKE PRESS INDICATION. REMOVED AND REPLACED BRAKE ACCUMULATOR , LEAK CK SERVICED ACCOMLATER AND HYDRIC SYSTEMS. OP CK NORMAL IAW AMM 32-41-51.SDR AALA2020021329027Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500A AND BS 500I AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2020021329025Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727J AND BS 767 AT S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R PROCEDURE 5.SDR AALA2020021329023Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500B AND BS 500I AT S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202002079030Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED MID CABIN FLOOR SUPPORT AT BS 540 AND BL 0. REPLACED FLOOR SUPPORT PER SRM 51-10-02.SDR AALA202002079029Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA FLOOR INTERCOSTAL BETWEEN BS 947 AND BS 967 AT LBL 50. REPLACED INTERCOSTAL PER SRM 510-10-02 AND AARD 51-00-05-1.SDR AALA202002079020Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD SERVICE DOOR CUT OUT SCUFF PLATE SUPPORT ANGLE AT BS 309 AND RBL 56. REPLACED SUPPORT ANGLE PER AARD 51-00-05-1.SDR AALA202002039008Door · openAIRCRAFT WAS GROUNDED: ON T/O GEAR FAILED TO RETRACT. RAN QRH PROCEDURE. RETURN TO DEPARTURE AIRPORT. FOUND MANUAL EXTENSION DOOR OPEN. PREFORMED INSPECTION OF DOOR SWITCH IAW AMM 32-34-00-820-802. PREFORMED ALTERNATE LANDING GEAR TEST IAW AMM 32-31-51-400-801SDR AALA202001319022Door · openAIRCRAFT WAS GROUNDED, FLIGHT RETURNED TO DEPARTURE DUE TO THE GEAR UNABLE TO RETRACT. EMERGENCY DECLARED. LANDED WITHOUT INCIDENT. AIRCRAFT WAS REMOVED FROM SERVICE. FOUND MANUAL EXTENSION DOOR OPEN. PREFORMED INSPECTION OF DOOR SWITCH IAW AMM 32-34-00-SDR AALA202001309012Ballast · failedAIRCRAFT NOT GROUNDED: EMERG EXIT OVER 14F DOES NOT ILLUMINATE. MEL APPLIED.***SUPPLEMENTAL ACTION SECT 4 AND 5: REPLACED BALLAST ASSY AT 14F SIDEWALL LIGHT PER AMM 33-21-00.***(CLOSED)
Back to Boeing 737-823