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 AALA202305162308Bracket · faultyAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT FLASHLIGHT INBOARD ON L1 FLIGHT ATTENDANT SEAT TEST RED LED. REMOVE AND REPLACED FLASHLIGHT BATTERY (AALA202305153225) AND BRACKET (AALA202305152308) ON FLIGHT ATTENDANT SEAT ON L1 DOOR INBOARD, OPERATION OK. ALL DONSDR AALA202305164656Drive Unit · failedAIRCRAFT WAS GROUNDED: INFLIGHT WHILE DEVIATING AROUND WEATHER LOUD NOISE FROM NOISE OF AIRCRAFT FOLLOWED BY WEATHER RADAR FAIL. EMERGENCY DECLARED, FLIGHT RETURNED TO MIA LANDING SAFELY. MAINTENANCE REPLACED WEATHER RADAR DRIVE UNIT AND ACCOMPLISHED SATISFACTSDR AALA202305195766Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL AROUND FASTENER HOLE LOCATED AT BS 500 + 10 INCHES AND S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1 AND DWG 143A8126.SDR AALA202305172358Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND BAFFLE LOCATED FROM BS 500A TO BS 500B, S25R, AND RBL 28. REPLACED BAFFLE PER AARD 53-00-01 AND SRM 51-40-02.SDR AALA202305150465Door · out of positionAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR IS ASKEW AND DOES NOT OPEN FULLY. ADJUSTED AFT LAVATORY D DOOR PER CMM 25-40-64.SDR AALA202305245368Fitting · wornAIRCRAFT IN BASE MAINTENANCE: WEAR ON ENTRY DOOR CUT OUT 834 FRAME- MOUNTED LATCH TRACK FITTING UPPER POSITION AT AFT GALLEY AREA. REMOVED AND REPLACED ENTRY DOOR CUT OUT 834 FRAME- MOUNTED LATCHTRACK FITTING UPPER POSITION AT AFT GALLEY AREA.SDR AALA202305190893Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED AT BS 727H TO BS 767 AT S25R. REPAIRED TRANSITION PANEL PER SRM 53 -00- 53 -2R-5.SDR AALA202305191963Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN SUB FLOOR WEB LOCATED FROM BS 987 TO BS 994 AT RBL 47. REPAIRED WEB PER EA 344799.SDR AALA202305156053Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION SHIELD LOCATED FROM BS 767 TO BS 793 AT S25R. REPLACED TRANSITION SHIELD PER SRM 51-10-02.SDR AALA202305155723Door · jammedAIRCRAFT WAS NOT GROUNDED: LAVATORY D AIRCRAFT LEFT DOOR TRACK JAMMED. REINSTALLED LAVATORY D DOOR.SDR AALA202305126453Door · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY D, AIRCRAFT AFT LEFT DOOR TRACK JAMMED. REINSTALLED DOOR.SDR AALA202305128182Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED OUTBOARD OF KEEL BEAM, LEFT HAND AIR CONDITIONING BAY, AT BS 663.5. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202305169980Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX LEFT HAND WHEEL WELL VAPOR BARRIER LOCATED AT BS 663, BETWEEN LBL 30 AND LBL 38. REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R-2 AND AARD 57-10-10-9.SDR AALA202305157170Screw · unsecureAIRCRAFT WAS NOT GROUNDED: LAVATORY D ENTRY DOOR DIFFICULT TO OPEN / CLOSE. FOUND SCREW ON BOTTOM OF DOOR STRIKING FLOOR FRAME. SECURED SCREW.SDR AALA202305127126Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR SILL CHORD LOCATED AT BS 315 AND LBL 64. REMOVED AND REPLACED CHORD PER SRM 51-40-02 AND SRM 51-40-05.SDR AALA202305126228Light · out of positionAIRCRAFT WAS NOT GROUNDED: EXIT ROW CEILING LIGHT FELL OFF. INSTALLED EXIT ROW CEILING LIGHT. OPERATION CHECKS OK.SDR AALA202305110168Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTS NOT ARMED. LIGHT HAS INOPERATIVE BULB. REPLAMPED IN ACCORDANCE WITH AMM 33-18-00. CHECKS NORMAL.SDR AALA202305118236Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB LOCATED AT STABILIZER STA 92.70. REPLACED RIB PER SRM 51-40-02-0G.SDR AALA202305172172Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN UPPER ANGLE LOCATED AFT OF LEFT HAND AIR CONDITIONING BAY AT BS 663.75 AND LBL 10. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202305121974Heat Exchanger · inoperativeAIRCRAFT WAS GROUNDED: LEFT WING-BODY OVERHEAT LIGHT ILLUMINATED AT CRUISE POWER. PERFORMED NON-NORMAL CHECKLIST IGHT WENT OUT. REPLACED L/H HEAT EXCHANGER.SDR AALA202305120711Regulator Valve · faultyAIRCRAFT WAS GROUNDED: ENGINE #2 ROLLED BACK TO APPROXIMATELY 50 % N1 FOR 3-5 SECONDS, THEN RETURNED TO NORMAL ON CLIMBOUT. EMERGENCY DECLARED; FLIGHT RETURNED TO PHX LANDING SAFELY. MAINTENANCE REPLACED ENGINE #2 PRESSURE REGULATING AND SHUTOFF VALVE (PRSOV) SDR AALA202305129630Sense Line · damagedAIRCRAFT WAS GROUNDED: ENGINE #2 ROLLED BACK TO APPROXIMATELY 50 % N1 FOR 3-5 SECONDS, THEN RETURNED TO NORMAL ON CLIMBOUT. EMERGENCY DECLARED; FLIGHT RETURNED TO PHX LANDING SAFELY. MAINTENANCE REPLACED ENGINE #2 PRESSURE REGULATING AND SHUTOFF VALVE (PRSOV) SDR AALA202305121845Fitting · faultyAIRCRAFT WAS GROUNDED: ENGINE #2 ROLLED BACK TO APPROXIMATELY 50 % N1 FOR 3-5 SECONDS, THEN RETURNED TO NORMAL ON CLIMBOUT. EMERGENCY DECLARED; FLIGHT RETURNED TO PHX LANDING SAFELY. MAINTENANCE REPLACED ENGINE #2 PRESSURE REGULATING AND SHUTOFF VALVE (PRSOV) SDR AALA202305122732Regulator Valve · faultyAIRCRAFT WAS GROUNDED: ENGINE #2 ROLLED BACK TO APPROXIMATELY 50 % N1 FOR 3-5 SECONDS, THEN RETURNED TO NORMAL ON CLIMBOUT. EMERGENCY DECLARED; FLIGHT RETURNED TO PHX LANDING SAFELY. MAINTENANCE REPLACED ENGINE #2 PRESSURE REGULATING AND SHUTOFF VALVE (PRSOV) SDR AALA202305120396Transmitter · stuckAIRCRAFT WAS GROUNDED: ON TAKEOFF #1 ENGINE OIL FILTER BYPASS LIGHT ILLUMINATED. ENGINE OIL PRESSURE CONSTANT 30 PSI. MAX OIL TEMP 105. NO VIBRATION. N1 & N2 NORMAL. EMERGENCY DECLARED, FLIGHT DIVERTED TO JFK, LANDING SAFELY. MAINTENANCE FOUND SCAVENGE OIL FILSDR AALA202305117502Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE LOCATED BELOW LEFT HAND TRANSITION PANEL FROM BS 500C TO BS 500D AT LBL 24. REPLACED BAFFLE AARD 50-00-05-1.SDR AALA202305109934Window · crazedAIRCRAFT WAS GROUNDED: AFT RIGHT DOOR EXIT WINDOW CRAZED. REMOVED AND REPLACED AFT RIGHT DOOR MOUNTED WINDOW IN ACCORDANCE WITH AMM 56-31-00. NO FURTHER DEFECT NOTED. OK FOR SERVICE.SDR AALA202305102237Door Latch · stuckAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DECOMPRESSION PANEL BOTTOM LATCH DOES NOT RELEASE DURING TEST. REMOVED AND REPLACED FLIGHT DECK DOOR PRESSURE RELEASE LATCH.SDR AALA202305127371Harness · faultyAIRCRAFT WAS GROUNDED: ENGINE OVERHEAT DETECTOR FAULT LIGHT INTERMITTENT AND ERRONEOUS IN POSITION A AND NORMAL IN POSITION B.**SUPPLEMENTAL REPORT FOR AALA202305097371: REPLACED LEFT ENGINE FIRE DETECTION HARNESSES MW0325 (AALA202305097371) AND MW0326 (AALA20SDR AALA202305120879Harness · faultyAIRCRAFT WAS GROUNDED: ENGINE OVERHEAT DETECTOR FAULT LIGHT INTERMITTENT AND ERRONEOUS IN POSITION A AND NORMAL IN POSITION B.**SUPPLEMENTAL REPORT FOR AALA202305097371: REPLACED LEFT ENGINE FIRE DETECTION HARNESSES MW0325 (AALA202305097371) AND MW0326 (AALA20SDR AALA202305119280Shade · stuckAIRCRAFT WAS NOT GROUNDED. FIRST OFFICER'S WINDOW SHADE ( R2 ) WLL NOT RETRACT ( ROLL UP). REMOVED AND REPLACED FIRST OFFICER'S R2 WINDOW SHADE.SDR AALA202305102856Fire Detector · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND FORWARD CARGO FIRE DETECTOR 2B INOPERATIVE. REMOVED AND INSTALLED FORWARD CARGO 2B FIRE DETECTORSDR AALA202305106844Light · burned outAIRCRAFT WAS NOT GROUNDED: AFT ENTRY DOORS L2 (AALA202305102069) AND R2 (AALA202305106844) UPPER EMERGENCY LIGHTS ARE PARTIALLY ILLUMINATED. INSTALLED AND PERFORMED SATISFACTORY AFT ENTRY DOORS L2 AND R2 UPPER EMERGENCY LIGHTS BULBS TEST.SDR AALA202305102069Light · burned outAIRCRAFT WAS NOT GROUNDED: AFT ENTRY DOORS L2 (AALA202305102069) AND R2 (AALA202305106844) UPPER EMERGENCY LIGHTS ARE PARTIALLY ILLUMINATED. INSTALLED AND PERFORMED SATISFACTORY AFT ENTRY DOORS L2 AND R2 UPPER EMERGENCY LIGHTS BULBS TEST.SDR AALA202305093433Light · intermittentAIRCRAFT WAS NOT GROUNDED: SEAT 16A EMERGENCY LIGHT FLICKERING. REMOVED AND REPLACED LAMP ASSEMBLY SEAT ROW 16A .SDR AALA202305090664Sliding Window · scratchedAIRCRAFT WAS NOT GROUNDED: L3 WINDOW IS SCRATCHED ON EXTERIOR. WINDOW IS DIFFICULT TO SEE OUT OF. REMOVED AND REPLACED L3 WINDOW.SDR AALA202305097371Unknown · unknownAIRCRAFT WAS GROUNDED: ENGINE OVERHEAT DETECTOR FAULT LIGHT INTERMITTENT AND ERRONEOUS IN POSITION A AND NORMAL, POSITION B..**SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202305123338Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND WHEEL WELL AFT BULKHEAD KEEL BEAM AREA WING TO BODY SUPPORT LOCATED AT BS 727 BETWEEN RBL 10 AND LBL10. REPLACED SUPPORT PER SRM 51-40-02-0G.SDR AALA202305119314Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN ANGLE AT FLOOR LINE LOCATED AT BS 298 AND S17R. REPLACED ANGLE PER AARD 51-00-05-1 AND DWG 141A8312.SDR AALA202305113103Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN GALLEY FLOOR SUPPORT LOCATED AT BS 290 AND RBL 43. REPLACED SUPPORT ANGLE PER SRM 51-40-02-0G.SDR AALA202305099623Slide · out of positionAIRCRAFT WAS NOT GROUNDED: EXIT SLIDE AT 1L PULLED OUT SLIGHTLY. REMOVED AND REPLACED L1 DOOR SLIDE. OPERATIONS CHECK NORMAL. OK FOR SERVICE.SDR AALA202305093810Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: 1L FLASHLIGHT INOPERABLE. REMOVED AND REPLACED 1L IB FLASHLIGHT BATTERY.SDR AALA202305093003Battery · no testAIRCRAFT WAS NOT GROUNDED: AFT RIGHT FLIGHT ATTENDANT LEFT FLASHLIGHT WILL NOT TEST. REMOVED AND REPLACED AFT RIGHT FLIGHT ATTENDANT LEFT FLASHLIGHT BATTERY.SDR AALA202305097269Flashlight · inoperativeAIRCRAFT NOT GROUNDED: AFT GALLEY JUMP SEAT FLASHLIGHT GREEN CHARGING LIGHT IS NOT FLASHING. REMOVED AND REPLACED FLASHLIGHT.SDR AALA202305088351Retainer · looseAIRCRAFT WAS NOT GROUNDED: L2 DOOR GIRT BARS IS LOOSE WHEN ARMED. ADJUSTED L2 DOOR GIRT BAR RETAINING CLIP.SDR AALA202305082986Retainer · looseAIRCRAFT WAS NOT GROUNDED: L1 DOOR GIRT BARS IS LOOSE WHEN ARMED. ADJUSTED L1 DOOR GIRT BAR RETAINING CLIP.SDR AALA202305089440Aoa · faultyAIRCRAFT WAS GROUNDED: SPEED LIMIT AMBER FAILURE FLAG ON CAPTAINS PFD AFTER TAKEOFF. INTERMITTENT STICK SHAKER ON FIRST OFFICERÏ¿½S SIDE, WITH ASCENDING RED/BLACK SPEED BAR ON CAPTAINS PFD. FLIGHT DIVERTED TO DFW. AUTO SLAT FAIL LIGHT ON RECALL DURING DESCENT.SDR AALA202305107293Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED AT BS 328 AND RBL 36. REPLACED INTERCOSTAL PER AARD 51-10-00-05-1.SDR AALA202305096239Regulator Valve · odorAIRCRAFT WAS GROUNDED: PACKS PRODUCED A VERY STRONG ODOR AFTER TAKEOFF. SMELLED LIKE A DIRTY WET DOG. ACCOMPLISHED JOB CARD 08L00021001 SMOKE ODOR FUMES INITIAL TROUBLESHOOTING FOUND TRIM AIR VALVE TO BE SOURCE OF ODOR. REMOVED AND REPLACED TRIM AIR PRESSURE RSDR AALA202305093894Bracket · out of adjustAIRCRAFT WAS NOT GROUNDED: GIRT BAR 1L LOOSE. ADJUSTED GIRT BAR BRACKET IN ACCORDANCE WITH AMM 25-61-00. OPERATION CHECKS OKAY.
Back to Boeing 737-823