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 AALA202205064329Striker · stickingAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR HARD TO OPEN. COCKPIT DOOR STRIKER WAS ADJUSTED AND LUBRICATED PER AMM 52-51-03.SDR AALA202205065697Knob · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DIFFICULT TO CLOSE MUST SLAM. ADJUSTED AND LUBRICATED FLIGHT DECK DOOR KNOB ASSEMBLY PER AMM 52-50-00.SDR AALA202205066434Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO CLOSE. CLEANED AND LUBRICATED DOOR LATCH. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECKSDR AALA202205060908Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: R1 FWD SERVICE DOOR RIGHT SIDE GIRT BAR BOTH LOOSE AND DIFFICULT TO ENGAGE. CHECKED GIRT BAR STORAGE CLIPS. CHECKS NORMAL PER AMM 25-66-01.SDR AALA202205057111Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR DIFFICULT TO CLOSE. ADJUSTED COCKPIT DOOR LOCK PER AMM 52-51-02. OPERATIONAL CHECK GOOD.SDR AALA202205164353Brake Assy · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INBOARD END OF PASSENGER CABIN FLOORBOARD SUPPORT BRAKE ASSEMBLY, LOCATED AT BS 540, FROM LBL 2 TO LBL 23. REPLACED BRAKE ASSEMBLY PER AARD 51-00-05-1.SDR AALA202205160946Brake Assy · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INBOARD END OF PASSENGER CABIN FLOORBOARD SUPPORT BRAKE ASSEMBLY, LOCATED AT BS 540, FROM RBL 2 TO RBL 23. REPLACED BRAKE ASSEMBLY PER AARD 51-00-05-1.SDR AALA202205091370Rib · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT WING OUTBOARD FIX TRAILING EDGE RIB WORN ON LOWER SURFACE AT APPROXIMATELY STA 500 AND WATERLINE 419.75. REMOVED AND REPLACED RIB ASSEMBLY PER SRM 51-40-02.SDR AALA202205066203Windshield · crackedAIRCRAFT WAS NOT GROUNDED: FIRST OFFICER FORWARD WINDSHIELD (R1) HAS APPROXIMATELY 1 INCH DIAMETER AREAS (2) OF MULTIPLE SMALL CRACKS AND DISCOLORATION ALONG UPPER EDGE. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202205069802Tube · leakingAIRCRAFT WAS GROUNDED: ON CLIMB OUT ENGINE #1 OIL QUANTITY SHOWED ZERO OIL. OIL PRESSURE DECREASED. CREW SHUTDOWN ENGINE #1. EMERGENCY DECLARED, FLIGHT RETURNED TO JFK LANDING SAFELY. **SUPPLEMENTAL REPORT FOR AALA202205059802: REPLACED ENGINE #1 AFT SUMP OIL SDR AALA202205060969Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB ATTACH ANGLE LOCATED AT STABILIZER STATION 129.50 AT AFT SPAR. REPLACED ATTACH ANGLE PER AARD 51-00-05-1 AND SRM 55-10-09-2R-4.SDR AALA202205054363Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT FORWARD FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED LEFT FORWARD FLIGHT ATTENDANT FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA202205055109Door · out of adjustAIRCRAFT WAS GROUNDED: FLIGHT DECK DOOR DIFFICULT TO CLOSE IN FLIGHT AND ON THE GROUND. PERFORMED INSPECTION OF FLIGHT COMPARTMENT DOOR PUSH / PULL PER AMM 52-51-02-400-801, REF SUB TASK 710-002. OPERATIONAL CHECK GOOD.SDR AALA202205051094Girt Bar · out of positionAIRCRAFT WAS NOT GROUNDED: GIRT BAR STUCK IN CLIP ON FORWARD RIGHT SERVICE ENTRY DOOR. RE-POSITIONED GIRT BAR. NOW OPERATES CORRECTLY.SDR AALA202205059802Oil System · malfunctionedAIRCRAFT WAS GROUNDED: ON CLIMB OUT ENGINE #1 OIL QUANTITY SHOWED ZERO OIL. OIL PRESSURE DECREASED. EMERGENCY DECLARED, FLIGHT RETURNED TO JFK LANDING SAFELY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202205069231Window Shade · tornAIRCRAFT WAS NOT GROUNDED: OVER WING EXIT WINDOW SHADE TORN SEAT ROW 17DEF. NEED M&E 98-2525-3-0203. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202205062463Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STATION 138.70; 16 INCHES FROM AFT SPAR. REPAIRED CRACK PER SRM 55-10-01-2R-11.SDR AALA202205066540Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STATION 134, AT AFT SPAR. REPAIRED CRACK PER SRM 55-10-01-2R-11.SDR AALA202205059470Motor · failedAIRCRAFT WAS GROUNDED: MAIN ELECTRIC TRIM FLED ON CLIMB OUT AT ABOUT 8,000. LANDING WAS,MADE AT 127,000 LBS. FLAPS 15. AIRCRAFT WAS NOT OVERWEIGHT FOR LANDING. REMOVED AND REPLACED STAB TRIM MOTOR PER AMM 27-41-71.SDR AALA202205057888Strap · damagedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND OUTBOARD UPPER SEAT TRACK STRAP SPLICE LOCATED AT STA 887 AND RBL 45.50 HAS A DAMAGED HOLE. REPLACED SEAT TRACK STRAP SPLICE PER SRM 51-40-02 AND 51-40-05.SDR AALA202205187243Windshield · delaminatedAIRCRAFT WAS NOT GROUNDED: CAPTAIN'S L1 WINDSHIELD LOWER LEFT HAS SOME DELAMINATION. **SUPPLEMENTAL REPORT FOR AALA202205027243: REPLACED WINDSHIELD PER JOB CARD 08C21156001.** (CLOSED)SDR AALA202205168815Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 727A TO BS 767, STR 25R, RBL 23. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202204283354Door · stiffAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO CLOSE (SECURE). ACCOMPLISHED SATISFACTORY FUNCTIONAL CHECK OF THE FLIGHT DECK DOOR PER AMM 52-51-00. NO FAULTS NOTED.SDR AALA202205102437Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HORIZONTAL STABILIZER LOWER SKIN, VISUAL INDICATION OF A CRACK ALONG THE RIB AT STABILIZER STA 92.70 LOCATED 10 INCHES FROM AFT SPAR. INSTALLED DOUBLER REPAIR AND FILLER PER SRM 55-10-01-2R-11.SDR AALA202204280954Drain · crushedAIRCRAFT WAS GROUNDED: LOUD NOISE COMING FROM FIRST OFFICER'S SLIDING WINDOW. FLIGHT RETURNED TO JFK LANDING SAFELY. **SUPPLEMENTAL REPORT FOR AALA202204270954: REPAIRED SLIDING WINDOW DRAIN TUBE PER EA 335862A..** (CLOSED)SDR AALA202205104052Floorboard · crackedAIRCRAFT IN BASE MAINTENANCE: Z ANGLE FLOOR BOARD SUPPORT HAS DAMAGE AT UPPER FLANGE AT STA 990 RIGHT BUTT LINE 34-47. REPLACED Z ANGLE FLOORBOARD SUPPORT PER AARD 51-00-05-1.SDR AALA202205101277Intercostal · inoperativeAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR INTERCOSTAL CRACKED BETWEEN STA 380 AND 400, RIGHT BUTT LINE 12. REMOVED DAMAGED UPPER SECTION OF INTERCOSTAL AND INSTALLED NEW UPPER SECTION OF INTERCOSTAL PER EA 3357910 AND SRM 51-40-02.SDR AALA202205261585Door Frame · deformedAIRCRAFT IN BASE MAINTENANCE" QUADRUPLE DOUBLER REPAIR ACCOMPLISHED ON AFT CARGO DOOR FRAME FORWARD EDGE METAL DEFORMATION AT LAP SEAM AT TLE FOLLOW ON ACTIONS REQUIRED. **SUPPLEMENTAL REPORT FOR AALA202204271585: REPAIRED AND WILL BE INSPECTED PRIOR TO 50000 SDR AALA202205106586Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKS FOUND IN LOWER SKIN OF LEFT HORIZONTAL STABILIZER LOCATED AT STA 129.5 AND LEFT BUTT LINE 83.5-92.5. INSTALLED DOUBLER REPAIR PER SRM 55-10-01-2R-11.SDR AALA202204297338Shade · damagedAIRCRAFT WAS NOT GROUNDED: OVERWING EMERGENCY EXIT AT SEAT 17F WINDOW SHADE DAMAGED. **SUPPLEMENTAL REPORT FOR AALA202204217338: REPLACED WINDOW SHADE PER AMM 52-22-00.** (CLOSED)SDR AALA202205063062Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR INTERCOSTAL LOCATED BETWEEN STA 312 AND STA 328 AT LBL 46. REPLACED INTERCOSTAL PER SRM 51-40-02 AND AARD 51-00-05.SDR AALA202205058304Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION ON SHIELD TRANSITION PANEL LOCATED BETWEEN STA 767 AND STA 787, AND RIGHT BUTT LINE 25. INSTALLED NEW SHIELD PER AARD 51-00-05-1.SDR AALA202205056863Floorboard · crackedAIRCRAFT IN BASE MAINTENANCE: FLOORBOARD BREAK AT STA 540 BETWEEN LEFT BUTT LINE 1 AND LEFT BUTT LINE 24 IS BROKEN (CRACKED) ON THE INBOARD END. INSTALLED NEW FLOORBOARD BREAK AT STA 540.SDR AALA202205060918Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOORBEAM LOCATED AT STA 986 AND LBL 43. REPAIRED PER SRM 53-70-51-2R-6 AND EA 335688.SDR AALA202205069885Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM T CAP LOCATED AT STA 986 AND RBL 43. REPAIRED PER SRM 53-70-51-2R-6 AND EA 335687.SDR AALA202205057216Crease Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED CREASE ANGLE LOCATED BETWEEN STA 979 AND STA 984 AT RBL 46. REPLACED CREASE ANGLE PER SRM 51-40-02.SDR AALA202204138517Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM EXISTING "T" CAP REPAIR AT BS 947 BETWEEN LBL 24.75 AND RBL 24.75. REPLACED FLOOR BEAM "T" CAP PER SRM 53-70-51-2R-5.SDR AALA202204135148Door Latch · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR LATCH LOCK LOOSE.TIGHTENED LATCH. OPERATIONAL CHECK GOOD PER AMM 25-40-00.SDR AALA202204133619Handle · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT DOOR HANDLE AT SEAT 17A IS LOOSE. RE-SECURED EXIT DOOR HANDLE COVER PER IPC 52-00-00. OPERATIONAL CHECK NORMAL.SDR AALA202204127894Pin · brokenAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR- L1- GUST LOCK ARM PIN BROKEN. REPLACED LOWER RADIUS LINK PIN PER AMM 52-11-21 DOOR-L1.SDR AALA202204133803Window · delaminatedAIRCRAFT WAS GROUNDED: L1 WINDOW DELAMINATED. REPLACED L1 COCKPIT WINDOW PER JOB CARD 08C21156001.SDR AALA202204127764Door Latch · looseAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY DOOR HANDLE IS LOOSE. **SUPPLEMENTAL REPORT FOR AALA202204117764: REPLACED DOOR LATCH ASSEMBLY PER AMM 25-40-15. OPERATIONAL CHECK GOOD.** (CLOSED)SDR AALA202204126859Door Frame · out of positionAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR IS DAMAGED (DOOR IS STUCK). FOUND METAL TRIM HITTING DOOR FRAME. REWORKED METAL OPERATIONS CHECK GOOD OK FOR SERVICE.SDR AALA202204133781Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL IN E AND E COMPARTMENT CEILING BETWEEN BS 312 AND BS 328 AT LBL 42. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202204134676Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL IN E AND E COMPARTMENT CEILING BETWEEN BS 328 AND BS 344 AT LBL 42. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202204082199Control Valve · faultyAIRCRAFT WAS GROUNDED: DURING CLIMB CABIN TEMPERATURE UNCONTROLLABLE. SHORTLY AFTERWORD RECEIVED RIGHT WING BODY OVERHEAT. FLIGHT DIVERTED TO CLT LANDING SAFELY. REPLACED TRIM AIR PRESSURE REGULATING AND SHUT OFF VALVE PER AMM 21-62-01-000-801 AND 21-62-01-400SDR AALA202204079505Cover · looseAIRCRAFT WAS NOT GROUNDED: MULTIPLE SEAT EMERGENCY LIGHT COVERS LOOSE. TIGHTENED COVERS PER CMM 25-23-67.SDR AALA202204084283Charger · faultyAIRCRAFT WAS NOT GROUNDED: L1 DOOR AREA LIGHT WILL NOT EXTINGUISH. REPLACED FORWARD BATTERY CHARGER PER AMM 33-51-06.SDR AALA202204078182Servo · faultyAIRCRAFT WAS GROUNDED: ON TAKE OFF LEFT ENGINE NUMBER 1 WAS 5 TO 7 PERCENT LOWER AT TAKEOFF POWER .BELOW 80 PERCENT NUMBER 1 THROTTLES MATCHED. AT TAKEOFF POWER LEFT ENGINE WOULD NOT ACHIEVE TAKEOFF OR CLIMB NUMBER 1 POWER. AUTO THROTTLE ON, LEFT THE NUMBER 1SDR AALA202204078376Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: GUST LOCK DOOR L1 DIFFICULT TO RELEASE. LUBRICATED GUST LOCK ASSEMBLY PER AMM 52-11-00. OPERATES NORMAL.
Back to Boeing 737-823