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 AALA202304249592Unknown · unserviceableAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR IS HARD TO REMOVE FROM AFT RETAINER CLIP. **SUPPLEMENTAL REPORT FOR AALA202304199592: REMOVED AND REPLACED R1 DOOR AFT GIRT BAR RETAINER CLIP PER AMM 25-66-01-200-802 AND SRM 51-40-02..** (CLOSED)SDR AALA202304205100Skin · crackedAIRCRAFT IN BASE MAINTENANCE: 5 CRACKS IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED FROM STABILIZER STA 124 TO STA 128, FROM AFT SPAR TO 9 INCHES FROM FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202304199592Unknown · unknownAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR IS HARD TO REMOVE FROM AFT RETAINER CLIP. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202304182972Light · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND R1 DOOR ESCAPE SLIDE LIGHT OUT DURING EMERGENCY LIGHTS CHECK WORK CARD. RELAMPED R1 DOOR EXTERIOR EMERGENCY EXIT LIGHT.SDR AALA202304177893Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR IS DIFFICULT TO CLOSE. MUST SLAM HARD. ADJUSTED FLIGHT DECK LOCKING AND CLOSING LATCH MECHANISM. OPERATION CHECKS OK.SDR AALA202304175156Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND FORWARD FLIGHT ATTENDANT FLASHLIGHT BATTERY INOPERATIVE. REMOVED AND REPLACED FORWARD FLIGHT ATTENDANT EMERGENCY FLASHLIGHT BATTERY IN ACCORDANCE WITH AMM 25-64-00.SDR AALA202304171130Girt Bar · looseAIRCRAFT WAS NOT GROUND: L1 DOOR GIRT BAR LOOSE IN UNARMED POSITION. ADJUSTED GIRT BAR CLIPS L1 DOOR.SDR AALA202304174233Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY BAR RETAINING BAR CLIP, RIGHT SIDE IS VERY TIGHT AND MAKES BAR REMOVAL DIFFICULT. ADJUSTED GIRT BAR CLIP.SDR AALA202304175008Shield · corrodedAIRCRAFT WAS GROUNDED: CORROSION FOUND ON FORWARD SHIELD LOCATED BETWEEN STA 767 AND STA 793 AND STR 25R. REMOVED AND REPLACED RIGHT FORWARD SHIELD PER AARD.SDR AALA202305026485Wire Harness · faultyAIRCRAFT WAS NOT GROUNDED: AIR INTERRUPT BACK TO MIA ON ACCOUNT OF A NUMBER 2 THRUST REVERSER CAUTION LIGHT. EMERGENCY WAS NOT DECLARED. **SUPPLEMENTAL REPORT FOR AALA202304176485: MAINTENANCE REPLACED NUMBER 2 ENGINE RIGHT HAND THRUST REVERSER SLEEVE STOW PROSDR AALA202305028145Proximity Sensor · faultyAIRCRAFT WAS NOT GROUNDED: AIR INTERRUPT BACK TO MIA ON ACCOUNT OF A NUMBER 2 THRUST REVERSER CAUTION LIGHT. EMERGENCY WAS NOT DECLARED. **SUPPLEMENTAL REPORT FOR AALA202304176485: MAINTENANCE REPLACED NUMBER 2 ENGINE RIGHT HAND THRUST REVERSER SLEEVE STOW PROSDR AALA202305020231Actuator · faultyAIRCRAFT WAS NOT GROUNDED: AIR INTERRUPT BACK TO MIA ON ACCOUNT OF A NUMBER 2 THRUST REVERSER CAUTION LIGHT. EMERGENCY WAS NOT DECLARED. **SUPPLEMENTAL REPORT FOR AALA202304176485: MAINTENANCE REPLACED NUMBER 2 ENGINE RIGHT HAND THRUST REVERSER SLEEVE STOW PROSDR AALA202304263943Support Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND WING LEADING EDGE SLAT #7 OUTBOARD AUXILIARY TRACK SUPPORT BRACKET LOCATED AT OUTBOARD FRONT SPAR STATION (OFSS) 564.5. REPLACED SUPPORT BRACKET PER SRM 51-10-02-OG AND DWG 112A2003#DL.SDR AALA202304252564Intercostal · noneAIRCRAFT IN BASE MAINTENANCE: EXISTING REPAIR ON AFT PASSENGER CABIN FLOOR INTERCOSTAL LOCATED FROM BS 947 TO BS 967 AT LBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202304251147Intercostal · damagedAIRCRAFT IN BASE MAINTENANCE: UNSPECIFIED DAMAGE TO INTERCOSTAL LOCATED FROM BS 947 TO BS 967 AT LBL 50. INTERCOSTAL WAS DAMAGED DURING REMOVAL TO FACILITATE OTHER MAINTENANCE. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202304254298Intercostal · damagedAIRCRAFT IN BASE MAINTENANCE: UNSPECIFIED DAMAGE TO FLOOR INTERCOSTAL LOCATED FROM BS 947 TO BS 967 AT RBL 24. INTERCOSTAL WAS DAMAGED DURING REMOVAL TO FACILITATE OTHER MAINTENANCE. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202304176342Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO CLOSE. APPEARS LATCH NEEDS TO BE ADJUSTED. ADJUSTED FLIGHT DECK DOOR LATCH.SDR AALA202304176485Unknown · unknownAIRCRAFT WAS NOT GROUNDED: AIR INTERRUPT BACK TO MIA ON ACCOUNT OF A NUMBER 2 THRUST REVERSER CAUTION LIGHT. EMERGENCY WAS NOT DECLARED. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202304171653Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 157.10, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202304174215Circuit Breaker · trippedAIRCRAFT WAS NOT GROUNDED: AIRCRAFT PORT SIDE, SIDE LIGHTS AND EXIT LIGHTS ARE INOPERATIVE. RESET CIRCUIT BREAKER E-12 ON P-92 PANEL. CABIN INTERIOR LIGHTS OPERATIONAL CHECK GOOD PER AMM 33-21-02.SDR AALA202304132275Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: MEGAPHONE IN AFT CABIN INOPERATIVE. REMOVED AND REPLACED MEGAPHONE IN AFT CABIN IN ACCORDANCE WITH AMM 25-64-00.SDR AALA202304262771Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 175.50, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202304183037Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO COMPARTMENT, LEFT TRANSITION PANEL HAS CORROSION AROUND FASTENER HOLE AT STA 727C AND STR 25L. REMOVED FABRICATED AND INSTALLED TRANSITION PANEL.SDR AALA202304187274Window · crackedAIRCRAFT WAS GROUNDED: 1 RIGHT HAND FLIGHT DECK WINDOW CRACKED ON FINAL APPROACH. **SUPPLEMENTAL REPORT FOR AALA202304147274: REMOVED AND REPLACED RIGHT FRONT WINDOW** (CLOSED)SDR AALA202304174839Girt Bar · brokenAIRCRAFT WAS IN BASE MAINTENANCE: R-1 DOOR FWD GIRT BAR CLIP IS BROKEN/BENT. REMOVED AND REPLACED R-1 DOOR FORWARD GIRT BAR CLIP.SDR AALA202304171602Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR CUTOUT LOWER INNER CHORD LOCATED AT BS 328 AND LBL 60. REMOVED AND REPLACED INNER CHORD PER SRM 51-40-02-0G.SDR AALA202304141322Tat Probe · defectiveAIRCRAFT WAS NOT GROUNDED: AIRSPEED UNRELIABLE ON CLIMB OUT IN TURBULENCE, 33000 CLACKER WENT OFF AIRSPEED DIFFERENT BY 30 KNOTS RAN QUICK REFERENCE HANDBOOK. TOTAL AIR TEMPERATURE PROBE WAS REMOVED AND REPLACED IN ACCORDANCE WITH AMM 34-21-06, TOTAL AIR TEMPESDR AALA202304144688Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY DOOR GIRT BAR IS LOOSE. RESECURED R1 DOOR GIRT BAR.SDR AALA202304147274Unknown · unknownAIRCRAFT WAS GROUNDED: 1 RIGHT HAND FLIGHT DECK WINDOW CRACKED ON FINAL APPROACH. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202304136048Light · malfunctionedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS ON CAPTAIN SIDE EXIT WILL NOT TURN OFF. RESET AFT EMERGENCY OVERRIDE SWITCH.SDR AALA202304136836Motor · failedAIRCRAFT WAS GROUNDED: AFTER TAKEOFF THE STABILIZER TRIM TOTALLY FAILED WITH SPEED TRIM FAILED ANNUNCIATION. EMERGENCY DECLARED, FLIGHT RETURNED TO LGA LANDING SAFELY. MAINTENANCE REPLACED HORIZONTAL STABILIZER TRIM MOTOR PER AMM 27-41-71.SDR AALA202304138892Windshield · overheatedAIRCRAFT IN BASE MAINTENANCE: CAPTAIN'S L1 WINDSHIELD HAS EVIDENCE OF OVERHEATING ON UPPER BUS BAR. REMOVED AND REPLACED L1 WINDSHIELD PER AMM 56-11-11 AND JOB CARD 08L21056003.SDR AALA202304174953Life Raft · low pressureAIRCRAFT IN BASE MAINTENANCE: LIFE RAFT PRESSURE IS BELOW MINIMUM PER JOC CARD 8C20025047. REPLACED LIFE RAFT IN FORWARD PASSENGER CABIN PER AMM 25-64-00.SDR AALA202304144631Smoke Detector · faultyAIRCRAFT WAS NOT GROUNDED: SMOKE ALARM IN 2L WENT OFF NUMEROUS TIMES WHILE THE LAVATORY WAS UNOCCUPIED. REMOVED AND REPLACED LAVATORY D SMOKE DETECTOR IAW AMM 26-14-01.SDR AALA202304269753Retainer Cup · looseAIRCRAFT WAS NOT GROUNDED: 1L ENTRY DOOR GIRT BAR RETAINING CLIP IS LOOSE. **SUPPLEMENTAL REPORT FOR AALA202304119753: REPLACED SLIDE ASSEMBLY PER JOB CARD 08L22125001.** (CLOSED)SDR AALA202304110594Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: L1 FLIGHT ATTENDANT SEAT ONE FLASHLIGHT BLINKING RED. ONE L1 DOOR FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT INOPERATIVE. REMOVE AND REPLACE BATTERY IN FLIGHT ATTENDANT FLASHLIGHT IN ACCORDANCE WITH AMM 25-64-00. OPERATION CHECKS GOOD IN ASDR AALA202304110816Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY ENTRY DOOR VERY DIFFICULT TO OPEN/CLOSE. ADJUSTED THE LATCH ON FORWARD LAVATORY DOOR.SDR AALA202304113658Solenoid · fault messageAIRCRAFT WAS NOT GROUNDED: LEFT OVERWING DOOR LIGHT ILLUMINATED DURING TAKEOFF ROLL. REMOVED AND REPLACED LEFT HAND AFT OVERWING EXIT DOOR FLIGHT LOCK SOLENOID.SDR AALA202304119753Unknown · unknownAIRCRAFT WAS NOT GROUNDED: 1L ENTRY DOOR GIRT BAR RETAINING CLIP IS LOOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202305128264Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 400 TO BS 420 AT STR 26L. REPLACED INTERCOSTAL PER SRM 51-40-05. **SUPPLEMENTAL REPORT REQUIRED FOR AALA202305098264: SECTION 7 UPDATED TO REMOVE CORROSDR AALA202305098264Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 400 TO BS 420 AT STR 26L. REPLACED INTERCOSTAL PER SRM 51-40-05.SDR AALA202305033165Beam · corrodedAIRCRAFT WAS IN BASE MAINTENANCE: (CPCP)-53-380-00 CORROSION MAIN CABIN AFT WET AREA BEAM STA 986.5 LBL 45. REPAIRED MAIN CABIN AFT WET AREA BEAM STA 986.5 LBL 45 IAW B737-NG SRM 53-70-51-2R.SDR AALA202304120761Door · stickingAIRCRAFT WAS NOT GROUNDED: LAVATORY D PASSENGER STUCK IN LAVATORY HAD TO REMOVE DOOR FROM TRACK TO REMOVE PASSENGER. USED TOOLS FROM BLACK GEAR PIN BOX TO FREE PASSENGER. DOOR HAD DAMAGED UPPER TRIM CAUSING BINDING. REPLACED DOOR.SDR AALA202304102784Striker · wornAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR VERY DIFFICULT TO CLOSE, REQUIRES HARD SLAMMING. ALSO, CAN'T OPEN EASILY UNLESS YOU PULL HARD FIRST. CLEANED AND LUBED DOOR STRIKER AND MECHANISM. OPERATION CHECKS NORMAL.SDR AALA202304108589Pin · brokenAIRCRAFT WAS GROUNDED: L1 DOOR DIFFICULT TO DISENGAGE GUST LOCK. REPLACED L1 DOOR GUIDE ARM PIN AND GREASED DOOR LOCK PER AMM 52-11-21. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202304180576Door · stickingAIRCRAFT IN BASE MAINTENANCE: LAVATORY D AFT LEFT DOOR WAS FORCED INWARD. UNABLE TO OPEN OR CLOSE. **SUPPLEMENTAL REPORT FOR AALA202304120576: REMOVED AND REPLACED LAVATORY D DOOR ASSEMBLY** (CLOSED)SDR AALA202304120576Unknown · unknownAIRCRAFT IN BASE MAINTENANCE: LAVATORY D AFT LEFT DOOR WAS FORCED INWARD. UNABLE TO OPEN OR CLOSE. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202304115154Slide · damagedAIRCRAFT IN BASE MAINTENANCE: L2 SLIDE DAMAGED AT RUB STRIP. REMOVED AND REPLACED SLIDE.SDR AALA202304105945Smoke Detector · defectiveAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY SMOKE DETECTOR ACTIVATED IN FLIGHT. REPLACED FORWARD LAVATORY SMOKE DETECTOR IN ACCORDANCE WITH AMM 26-14-00. OPERATION CHECKED GOOD.SDR AALA202304106334Hinge · wornAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY DOOR IS HARD TO OPEN AND CLOSE. REMOVE AND REPLACE AFT RIGHT LAV DOOR HINGE ASSEMBLY IN ACCORDANCE WITH CMM 25-40-65. OPERATION CHECKED GOOD. NO FURTHER DEFECTS NOTED AT THIS TIME.
Back to Boeing 737-823