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 AALA2019082759031Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 747 AND BS 767 AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019082759030Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727G AND BS 727H AT S25L. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA2019082759029Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727J AND BS 747 AT S25L. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA2019082759028Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727I AND BS 727J AT S25L. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA2019082759027Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727H AND BS 727I AT S25L. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA2019082759026Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727F AND BS 727G AT S25L. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA2019082759025Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727C AND BS 727D AT S25L. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA2019082759024Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727E AND BS 727F AT S25L. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA2019082759023Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT BS 727A AND S25L. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA2019082629071Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR SUPPORT AT BS 537 AND RBL 12. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA2019082629070Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR SUPPORT AT BS 537 AND RBL 12. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA2019081209014Pump · overtempAIRCRAFT WAS GROUNDED: PILOT REPORTS ON PUSH BACK ELECTRIC 1 PUMP (B SYSTEM), OVERHEAT LIGHT ILLUMINATED. FAINT ODOR, POSSIBLE ELECTRIC DETECTED ODOR WENT AWAY WHEN PUMP WAS TURNED OFF, WHEN OVERHEAT LIGHT IS TESTED IT IS EQUAL BRIGHTNESS WITH THE ELECTRIC 2 LSDR AALA201908129025Module · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS ON PUSH BACK ELECTRIC 1 PUMP (B SYSTEM), OVERHEAT LIGHT ILLUMINATED. FAINT ODOR, POSSIBLE ELECTRIC DETECTED ODOR WENT AWAY WHEN PUMP WAS TURNED OFF, WHEN OVERHEAT LIGHT IS TESTED IT IS EQUAL BRIGHTNESS WITH THE ELECTRIC 2 LSDR AALA2019082979066Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND HORIZONTAL STABILIZER SECOND RIB VERTICAL STIFFENER AT STATION 92.70. REPAIRED RIB PER SRM 55-10-09-2R-4.SDR AALA2019082629069Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND OUT BOARD FLOOR SUPPORT AT BS 537. REPLACED FLOOR SUPPORT PER AARD 51-00-05.SDR AALA2019081299020Autothrottle Sys · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS AUTOTHROTTLE DISCONNECTED AFTER TAKEOFF POWER, ESTABLISHED ATEMPED RESET SEVERAL TIMES IN FLIGHT WITH NO SUCCESS. MAINTENANCE PERFORMED BITE CHECK OF THE AUTO THROTTLE SYSTEM IAW FIM 22-31-00-810-801. BITE CHECK SHOWS NO ASDR AALA2019081299002Slide · out of positionAIRCRAFT WAS NOT GROUNDED: DOOR 1L SLIDE PACK HAD PART OF THE SLIDE ASSEMBLY HANGING OUT OF THE COVER ON THE DOOR. MAINTENANCE RESTOWED Z FOLD PER AMM 25-66-01.SDR AALA2019081209901Light · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY PATH LIGHTING HAD INOPERABLE LIGHT OUT SEAT 20DEF REF SIC 2904. MAINTENANCE REPLACED LIGHT PER AMM 33-51-11.SDR AALA201908099021Warning Light · false activationAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS RT CTR FUEL PUMP LIGHT ILLUMINATED WITH CTR TANK SELET PUMP ILLUMINATED. MAINTENANCE INSPECTED R/H PUMP CANISTER & PICK UP LINE INSIDE TANK NO DEFECTS NOTED.SDR AALA201908099017Module · burned outAIRCRAFT WAS GROUNDED: PILOT REPORTS CLIMBING THROUGH 15000 FEET, ELEC 1 HYD PUMP OVERHEAT LIGHT ILLUMINATED WITH STRONG ELECTRICAL SMELL IN COCKPIT. HYD PRESSURE WAS 3080PSI, ON RIGHT, 3100 ON LEFT. MIANTENANCE ACCOMPLISHED SMOKE, ODOR, FUMES INITIAL TROUBLESSDR AALA201908099023Bulkhead Web · crackedAIRCRAFT WAS GROUNDED: INBOARD RIGHT MAIN LANDING GEAR WHEEL WELL FORWARD LOWER BULKHEAD OUTBOARD LOWER VAPOR BARRIER CRACKED. REPAIRED VAPOR BARRIER PER AARD 57-10-10.SDR AALA201908099022Bulkhead Web · crackedAIRCRAFT WAS GROUNDED: OUTBOARD RIGHT MAIN LANDING GEAR WHEEL WELL FORWARD LOWER BULKHEAD INBOARD LOWER VAPOR BARRIER CRACKED. REPAIRED VAPOR BARRIER PER AARD 57-10-10.SDR AALA2019082989039Seat Track · wornAIRCRAFT IN BASE MAINTENANCE: WORN SEAT TRACK BETWEEN BS 514 AND BS 518 AT RBL 45. REPLACED SEAT TRACK PER EA 297065 AND SRM 53-00-52-1A.SDR AALA2019082659076Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR BOARD SUPPORT AT FR 540, RBL -2. REPLACED FLOOR BOARD SUPPORT PER BOEING DRAWING 143A5240 AND AARD 51-00-05 AND SRM 51-40-02.SDR AALA2019082659075Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR BOARD SUPPORT AT FR 540, LBL 2. REPLACED FLOOR BOARD SUPPORT PER BOEING DRAWING 143A5240 AND AARD 51-00-05 AND SRM 51-40-02.SDR AALA2019082629064Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SHEAR TIE AT BS 847 BETWEEN S26L AND S27L. REPLACED SHEAR TIE PER 51-00-05-1.SDR AALA2019082629061Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER CLIP AT BS 887 AND S27L. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA201908089003Cover · damagedAIRCRAFT WAS NOT GROUNDED: AFT LEFT EXIT SIGN LIGHT COVER DAMAGED. MAINTENANCE REPLACED SIGN IDENTIFIER PER AMM 25-60-00.SDR AALA201908098001Sliding Window · bindingAIRCRAFT NOT GROUNDED: FO WINDOW JAMMED, WILL NOT OPEN FULLY. MAINTENANCE SECURED LOOSE HARDWARE, REINSTALLED F/O SLIDING WINDOW IN LOWER TRACK. OPS CKS NORMAL.SDR AALA2019082989041Seat Track · wornAIRCRAFT IN BASE MAINTENANCE: WORN SEAT TRACK BETWEEN BS 515 AND BS 516 AT LBL 45. REPLACED SEAT TRACK PER AARD 51-00-05-1.SDR AALA2019080879013Pressure Switch · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS LEFT FUEL FILTER BYPASS ILLUMINATED, NO ERRATIC SIGNS INDICATION. FIGHT CONTINUE PER QRH. MAINTENANCE REMOVED AND REPLACED FUEL FILTER DIFFERENTIAL PRESSURE SWITCH AND ENGINE FUEL FILTER IAW FIM 73-05-00-810-801.F00. LEAK CSDR AALA201908089018Filter · cloggedAIRCRAFT WAS GROUNDED: PILOT REPORTS LEFT FUEL FILTER BYPASS ILLUMINATED, NO ERRATIC SIGNS INDICATION. FIGHT CONTINUE PER QRH. MAINTENANCE REMOVED AND REPLACED FUEL FILTER DIFFERENTIAL PRESSURE SWITCH AND ENGINE FUEL FILTER IAW FIM 73-05-00-810-801.F00. LEAK CSDR AALA2019082759022Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL BETWEEN BS 312 AND BS 328 AT LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2019082759003Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL BETWEEN BS 328 AND BS 344 AT LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2019082759002Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL BETWEEN BS 344 AND BS 360 AT LBL 12. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2019082759001Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT BAFFLE BETWEEN BS 500C AND BS 500D AT S25R. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA2019082629067Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER CLIP AT BS 847 AND S26L. REPLACED STRINGER CLIP PER EA 296985.SDR AALA2019082629065Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER CLIP AT BS 867 AND S26L. REPLACED STRINGER CLIP PER EA 296985.SDR AALA2019082629062Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER CLIP AT BS 827 AND S27L. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA2019082629055Stringer Splice · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER SPLICE AT BS 887 AND S27L. REPLACED STRINGER SPLICE PER AARD 51-00-05-1.SDR AALA2019080869020Water Heater · odorAIRCRAFT WAS GROUNDED: PILOT REPORTS FORWARD LAV HAS AN ODOR OF RESIDUAL ELECTRIC SMOKE OR CHARING. NO EVIDENCE OF ANY ACTIVE ISSUE ON THIS FLIGHT. MAINTENANCE REMOVED AND REPLACED FWD LAV WATER HEATER IAW AMM 38-13-01. OPS CHECK GOOD.SDR AALA2019080869022Sensor · deterioratedAIRCRAFT WAS GROUNDED: PILOT REPORTS FLAPS WOULD NOT EXTEND ON DESCENT. EMERGENCY WAS DECLARED. MAINTENANCE FOUND #5 SKEW SENSOR AND CONNECTOR DETERIORATED BY SKYDROL. MAINTENANCE REMOVED AND REPLACED CANNON PLUG D11822P FOR SKEW SENSOR #5 IAW SWPM 20-61-11 ANSDR AALA2019080869026Windshield · arcedAIRCRAFT WAS GROUNDED: PILOT REPORTS L1 WINDSHIELD MAKES CRACKING SOUND IN CRUISE IN CLOUDS. MAINTENANCE REMOVED AND REPLACED L1 WINDSHIELD IAW JOB CARD 56-94-03.SDR AALA2019080769019Unknown · vaporAIRCRAFT WAS GROUNDED: PILOT REPORTS AFTER TAKE OFF FROM DFW, TRAILING FUEL VAPER NOTED OFF RIGHT WING TIP. MAINTENANCE FOUND NO EVIDENCE OF FUEL AT RIGHT WING TIP IAW AMM 28-11-00. OK FOR SERVICE.SDR AALA2019080769025Antenna · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS WHILE ON DOWNWIND, ORD, CLEAN CONFIG, SPEED 250, LEVEL 7000 MSL. THE MLG WARNING HORN CAME ON ALONG WITH 3 RED LIGHTS IN GEAR HANDLES WARNING WENT AWAY APPROX 30 SEC LATER. MAINTENANCE ACCOMPLISHED BITE OF DFGCS, SMYDS, ANDSDR AALA201908069013Sliding Window · inoperativeAIRCRAFT WAS GROUNDED: CAPTAIN'S L2 SLIDING WINDOW WOULD NOT OPEN OR CLOSE PROPERLY. MAINTENANCE ADJUSTED WINDOW PER AMM 56-12-11.SDR AALA201908069012Girt Bar · out of positionAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTED 1R SLIDE DIFFICULT TO ARM. MAINTENANCE REPOSITIONED GIRT BAR R1 DOOR SLIDE PER AMM 25-66-00.SDR AALA201908069011Lens · damagedAIRCRAFT WAS NOT GROUNDED: LENS COVER FOR EMERGENCY EXIT LIGHT IN FORWARD GALLEY DAMAGED. MAINTENANCE REPLACED LENS COVER PER STANDARD PRACTICES.SDR AALA201908069010Lens · unsecureAIRCRAFT WAS NOT GROUNDED: AFT GALLEY RIGHT SIDE EXIT COVER KEEPS FALLING OFF. MAINTENANCE REPLACED EXIT COVER PER MM 33-50-00.SDR AALA2019082989048Support Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SUPPORT FRAME AT BS 695 AND RBL 70. REPLACED SUPPORT FRAME PER AARD 51-00-01.
Back to Boeing 737-823