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 AALA2019082979063Support Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SUPPORT FRAME AT BS 695 AND RBL 70. REPLACED SUPPORT FRAME PER 51-00-05-1.SDR AALA2019080769006Transceiver · faultedAIRCRAFT WAS GROUNDED: PILOT REPORTS WITH #1 FLT DIRECTOR AS MASTER, AUTOTHROTTLES ADVANCED THRUST LEVERS DURING FLARE AFTER BEING RETARDED TO IDLE. MAINTENANCE REPLACED #1 LRRA XCVR DUE TO NUMEROUS 1,2 COMP FAULTS. OPS AND BITE CHECKS NORMAL IAW AMM 34-33-2SDR AALA201908059009Lens · detachedAIRCRAFT WAS NOT GROUNDED: CLEAR EMERGENCY EXIT LENS FELL OF DOOR 1R. MAINTENANCE REPLACED LENS PER AMM 33-51-01.SDR AALA201908059031Skin · delaminatedAIRCRAFT WAS GROUNDED: LEFT WING INBOARD AFT FLAP TRAILING EDGE DELAMINATED 29 INCHES OUT BOARD OF THE INBOARD END. REPAIRED FLAP PER EA 297024.SDR AALA201908069004Probe · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS WING FUEL QUANTITIES DECREASED WHILE FEEDING FROM CENTER. ALL PUMPS ON. CROSSFEED CLOSED. GROUND: LT 8.5 C 15.2 RT 8.5. TOP OF CLIMB: LT 8.39 C 9.95 RT 7.90. AT CENTER TANK EMPTY: LT 8.09 C 0.00 RT 7.75. MAINTENANCE CURRENSDR AALA201908279055Compensator · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS WING FUEL QUANTITIES DECREASED WHILE FEEDING FROM CENTER. ALL PUMPS ON. CROSSFEED CLOSED. GROUND: LT 8.5 C 15.2 RT 8.5. TOP OF CLIMB: LT 8.39 C 9.95 RT 7.90. AT CENTER TANK EMPTY: LT 8.09 C 0.00 RT 7.75. . MAINTENANCE REMOSDR AALA201908169054Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SUPPORT ANGLE AT BS 500I BETWEEN S25L AND S25R. REPLACED SUPPRT ANGLE PER SRM 51-40-02.SDR AALA201908059008Cover · missingAIRCRAFT WAS GROUNDED: AFT SERVICE, DOOR EMERGENCY EXIT LIGHT COVER MISSING. MAINTENANCE REPLACED LIGHT COVER PER AMM 33-51-01.SDR AALA201908059032Module · defectiveAIRCRAFT WAS GROUNDED: PRIOR TO PUSH BACK, PILOTS SLIDING WINDOW CRACKED, VERY HOT, BUBBLING. REPLACED WINDOW PER AMM 56-12-11 AND WINDOW HEAT CONTROL MODULE PER AMM 30-41-11.SDR AALA201908059010Sliding Window · crackedAIRCRAFT WAS GROUNDED: PRIOR TO PUSH BACK, PILOTS SLIDING WINDOW CRACKED, VERY HOT, BUBBLING. REPLACED WINDOW PER AMM 56-12-11 AND WINDOW HEAT CONTROL MODULE PER AMM 30-41-11. (PLEASE SEE AALA201908059032 FOR ADDITIONAL PART)SDR AALA2019082629056Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER CLIP AT BS 827 AND S26L. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA201908239002Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER CLIP AT BS 887 AND S26L. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA2019080539003Cover · brokenAIRCRAFT WAS NOT GROUNDED: LEFT AFT GALLEY EMERGENCY EXIT LIGHT COVER WAS BROKEN. REPLACED LENS COVER PER STANDARD PRACTICES.SDR AALA201908069002Control Unit · failedAIRCRAFT WAS GROUNDED: PILOT REPORTS BOTH HF #1 AND HF #2 RADIOS INOP. UNABLE TO TRANSMIT OR RECIEVE ON SEVERAL DIFFERENT FREQUENCIES. COULD NOT EVEN HEAR A TUNE SIGNAL WHEN INITAILLY KEYING MICROPHONE ON EACH FREQUENCY. MAINTENANCE REMOVED & REPLACED #1 & #2 SDR AALA201908069005Fmc · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS A MESSAGE AT CRUISE SAYING VNAV INVALID-PERF AIRCRAFT WENT TO ALITITUDE HOLD CHAGED THE COST INDEX SEVERAL TIMES AND FINALLY GOT VNAV PATH BUT IT WAS NOT ACCURATE. MAINTENANCE ACCOMPLISHED DFCS BITE IAW FIM 22-11-00, FOUND SDR AALA201908069003Computer · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS ON TAKE OFF #1 N1 COMMANDED THE EQUIVALENT OF A MAX POWER BLEED OFF POWER SETTING. WHEN THE BLEED WAS ON AND REDUCED POWER SELECTED. MAINTENANCE TROUBLESHOT SYSTEM, SWAPPED FLIGHT CONTROL COMPUTER WITH NEW SERVICEABLE FLIGHSDR AALA2019080649015Indicator · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS ON FINAL APPROACH, THE FLAPS TRAILING EDGE FAILED TO EXTEND WHEN INITIATING FLAPS 1. A SMALL SPLIT FLAP SITUATION OCCURRENCE WITH THE LEFT TRAILING EDGE FLAPS AT 1/2 OF 1 AND THE RIGHT TRAILING EDGE FLAPS INDICATING UP. WE SDR AALA2019080539010Water Heater · odorAIRCRAFT NOT GROUNDED: PILOT REPORTS COCKPIT SMOKE LIGHT CAME ON MOMENTARILY, F/A REPORTED THE AFT RIGHT LAV SMELLS LIKE BURNING RUBBER BUT COULD NOT CONFIRM ANYTHING REALLY. MAINTENANCE REMOVED AND REPLACED AFT RH LAV WATER HEATER IAW AMM 38-13-01. NO FURTHERSDR AALA201908039011Warning Horn · false activationAIRCRAFT WAS GROUNDED: PILOT REPORTS AT 13000 FEET GOT A PRESSURIZATION WARNING HORN FOR APPROX 7 SECONDS. CABIN ALT 2500, DIFF PRESS 4.2 INCHES 300 FPM DOWN CABIN RATE. NO WARNING LIGHTS NOTED. MAINTENANCE PERFORMED FIM PROCEDURE 31-51-00-810-803 FOR INTERMITSDR AALA2019080549003Lens · brokenAIRCRAFT WAS NOT GROUNDED: LENS ON ROW 9CBA BROKEN. MAINTENANCE REPLACED LENS PER AMM 33-51-03.SDR AALA2019080539001Screw · looseAIRCRAFT WAS NOT GROUNDED, AFT GALLEY EXIT SIGN CELLING PANEL HAD 2 SCREWS LOOSE. MAINTENANCE SECURED SIGN PER STANDARD PRACTICES.SDR AALA201908279009Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727C+16, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908299004Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BS 727J+15, RBL-20, S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908299003Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BS 727J+8, RBL-20, S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019082989049Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION SHIELD AT BS 782 AND RBL 21. REPLACED TRANSITION SHIELD PER AARD 51-00-05.SDR AALA201908289016Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 727I+16, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289015Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 765, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289014Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 759, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289013Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 727J+18, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD AARD 51-00-05-1.SDR AALA201908289012Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 767, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289011Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 763, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289010Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 755.5, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289009Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 748.5, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289008Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 727J+12, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289007Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 727J+2, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289006Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 727J+5, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289005Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 727I+8, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA201908289003Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 752, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289002Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION SHIELD, BS 775, RBL -20, AT S-25R. REPLACED TRANSITION SHIELD PER AARD 51-00-05-1.SDR AALA201908289001Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION SHIELD, BS 792, RBL -20, AT S-25R. REPLACED TRANSITION SHIELD PER AARD 51-00-05-1.SDR AALA2019082879038Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 787, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019082879036Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727+4, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019082879035Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 775, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019082879033Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727D+4, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279040Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 802, LBL 20, AT S26L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279032Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727J+11.5, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279030Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 778, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279029Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 783, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279028Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 770, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279027Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 780, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.
Back to Boeing 737-823