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 AALA202304100283Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: 2 EXTERIOR EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M1671 IN ACCORDANCE WITH AMM 33-51-06. OPERATION CHECKS GOOD.SDR AALA202304178487Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD PASSENGER CABIN RIGHT HAND INNER CORD LOCATED FROM BS 312 TO BS 328 AT RBL 58. REMOVED AND REPLACED CHORD PER SRM 51-40-02-OGSDR AALA202304107049Hinge · wornAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN/CLOSE. LUBRICATED FORWARD LAVATORY DOOR. OPENED AND CLOSED SEVERAL TIMES. CHECKED OK. IN ACCORDANCE WITH AMM 25-00-02.SDR AALA202304103269Battery Pack · failedAIRCRAFT WAS NOT GROUNDED: EMERGENCY BATTERY PACK M1670 FAILED EMERGENCY LIGHT CAPACITY CHECK. REMOVED AND REPLACED BATTERY PACK AT M1670.SDR AALA202304108781Windshield · scratchedAIRCRAFT WAS GROUNDED: CAPTAIN WINDSHIELD INSIDE PANE HAS A DEEP SHAPE SCRATCH WHICH PARTIALLY IMPEDES VISION. REPLACED WINDSHIELD PER JOB CARD 08L21056003.SDR AALA202304180290Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: PASSENGER COMPARTMENT FLOOR SUPPORT CRACKED LOCATED AT STA 540 AND BUTT LINE 0. REMOVED AND REPLACED FLOOR SUPPORT.SDR AALA202304172919Seat Track · brokenAIRCRAFT IN BASE MAINTENANCE: SCALLOPED SECTION BROKEN OFF OF LEFT HAND SEAT TRACK LOCATED FROM BS 480 TO BS 500B + 10 INCHES AT LBL 45. REPLACED SEAT TRACK PER SRM 53-00-52-2R-4.SDR AALA202304145673Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT ELEVATOR LOWER SURFACE PANEL LANDING AFT HAS 30 FASTENER HOLES WITH SIGNS OF CORROSION. LOCATED LEFT ELEVATOR STA 121.59. REMOVED CORROSION AND INSTALLED FREEZE PLUGS AS REQUIRED.SDR AALA202304129869Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: CABIN ENTRY DOOR GIRT BAR CLIP LOOSE. **SUPPLEMENTAL REPORT FOR AALA202304109869: REPLACED GIRT BAR RETAINING CLIP PER AFMM 20-51-07. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK .** (CLOSED)SDR AALA202304100468Skin · damagedAIRCRAFT IN BASE MAINTENANCE: SMALL AREA OF DAMAGE ON UPPER SKIN AROUND THE HINGE CUT OUT. LOCATED AT LEFT ELEVATOR TAB AT ELEVATOR STA 24.9. INSTALLED BONDED REPAIR PER EA.SDR AALA202304109869Unknown · unknownAIRCRAFT WAS NOT GROUNDED: CABIN ENTRY DOOR GIRT BAR CLIP LOOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202304101722Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR EXTREMELY DIFFICULT TO CLOSE WHILE IN FLIGHT. LUBRICATED LOCK MECHANISM.SDR AALA202304255678Intercostal · out of toleranceAIRCRAFT IN BASE MAINTENANCE: ELONGATED FASTENER HOLE IN FORWARD PASSENGER CABIN INTERCOSTAL LOCATED AT BS 294 AND BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-01 AND DWG 141A5410.SDR AALA202304183482Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD WET AREA INTERCOSTAL CRACKED BETWEEN STA 278 TO STA 294 AND BUTT LINE 0. REMOVED AND REPLACED FORWARD WET AREA INTERCOSTAL.SDR AALA202304105207Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: GIRT BAR ON R1 SERVICE DOOR VERY LOOSE. ADJUSTED GIRT BAR AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202304068463Screw · missingAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR DIFFICULT TO OPERATE. REPLACED MISSING SCREWS IN TOP TRIM EDGE CAUSING BINDING IN ACCORDANCE WITH CMM 25-40-64.SDR AALA202304069699Bracket · looseAIRCRAFT WAS NOT GROUNDED: GIRT BAR AT DOOR 1L NEEDS ADJUSTING. BRACKET IS LOOSE. ADJUSTED GIRT BAR BRACKET.SDR AALA202304056640Fork · crackedAIRCRAFT WAS GROUNDED: 1 INCH CRACK FOUND ON LEFT MAIN LANDING GEAR PICKLE FORK FITTING. LOCATED AT STA 663 STR 18 AND WATERLINE 207. REMOVED AND REPLACED LEFT MAIN LANDING GEAR PICKLE FORK PER AARD.SDR AALA202304254812Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN, AROUND VACUUM WASTE VENT, LOCATED FROM BS 907 TO BS 927 AT LBL 22. REPAIRED SKIN PER SRM 53-70-01-2R-3.SDR AALA202304119560Door · out of positionAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT TO OPEN / CLOSE. **SUPPLEMENTAL REPORT FOR AALA202304059560: REPOSITIONED AND ADJUSTED AFT LAVATORY BI-FOLD DOOR PER CMM 25-42-51.** (CLOSED)SDR AALA202304053968Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500A + 10 INCHES TO BS 500G + 10 INCHES AT S26R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202304054645Unknown · damagedAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR HARD TO OPERATE. CANNOT GET IT TO FULLY LATCH WITHOUT EXCESSIVE FORCE. REPLACED RETAINING CLIP AND VERIFIED STOP ADJUSTMENT.SDR AALA202304056407Circuit Breaker · damagedAIRCRAFT WAS NOT GROUNDED: CABIN EMERGENCY LIGHTS CIRCUIT BREAKER ON PANEL P6-11 PANEL DAMAGED. REPLACED CABIN EMERGENCY LIGHTS CIRCUIT BREAKER C1949.SDR AALA202304059560Unknown · unknownAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT TO OPEN / CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202304135074Spring · looseAIRCRAFT WAS NOT GROUNDED: L1 DOOR GUST LOCK DOES NOT STAY IN PLACE WHEN PUSHED. **SUPPLEMENTAL REPORT FOR AALA202304055074: MAINTENANCE FOUND GUST LOCK SPRING LOOSE. SECURED SPRING PER AMM 52-11-21.** (CLOSED)SDR AALA202304052966Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES IN FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500E + 10 INCHES TO BS 500I AT LBL 21. REMOVED AND REPLACED TRANSITION PANEL PER 51-40-02-0GSDR AALA202304050078Door Latch · damagedAIRCRAFT WAS NOT GROUNDED: FLIGHT DOOR DIFFICULT TO CLOSE. REPLACED COCKPIT DOOR LATCH.SDR AALA202304057336Pump · inoperativeAIRCRAFT WAS GROUNDED: AMBER IMBALANCE AFTER TAKE OFF WITH CENTER TANK FUEL. AIRCRAFT AIR INTERRUPTED BACK TO MIA. EMERGENCY WAS DECLARED. REPLACED (LEFT) CENTER TANK FUEL PUMP.SDR AALA202304055074Unknown · unknownAIRCRAFT WAS NOT GROUNDED: L1 DOOR GUST LOCK DOES NOT STAY IN PLACE WHEN PUSHED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202304046057Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO LATCH SHUT. ADJUSTED DEADBOLT LATCH RECEPTACLE, OPERATION CHECKS NORMAL, OK FOR SERVICE, IN ACCORDANCE WITH AMM 52-51-04.SDR AALA202304042042Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT-HAND DOOR FLASHLIGHT AND CHARGER INOPERATIVE. REMOVE AND REPLACE BOTH EMERGENCY FLASHLIGHTS.SDR AALA202304041850Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD LEFT-HAND DOOR FLASHLIGHT AND CHARGER INOPERATIVE. REMOVE AND REPLACE BOTH EMERGENCY FLASHLIGHTS.SDR AALA202304044534Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES IN FORWARD CARGO COMPARTMENT LEFT HAND FLOOR STRUCTURE ZEE CHANNEL LOCATED BETWEEN BS 490 AND BS 500E+ 10 INCHES AT S26L. REMOVED AND INSTALLED ZEE CHANNEL PER SRM 51-40-02-0G.SDR AALA202304046273Relay · faultyAIRCRAFT WAS GROUNDED: SPEED LIMIT FLAG AFTER TAKEOFF. HIGH SPEED BARBER POLE WAS SHOWN AT ALL TIMES. FLIGHT DECLARED AN EMERGENCY AND DIVERTED TO IAD LANDING SAFELY. MAINTENANCE FOUND FLIGHT MANAGEMENT COMPUTER (FMC) INPUT FAULT. REPLACED FAULTY FMC TRANSFER SDR AALA202304049496Relay · faultyAIRCRAFT WAS GROUNDED: SPEED LIMIT FLAG AFTER TAKEOFF. HIGH SPEED BARBER POLE WAS SHOWN AT ALL TIMES. FLIGHT DECLARED AN EMERGENCY AND DIVERTED TO IAD LANDING SAFELY. MAINTENANCE FOUND FLIGHT MANAGEMENT COMPUTER (FMC) INPUT FAULT. REPLACED FAULTY FMC TRANSFER SDR AALA202304058272Skin · puncturedAIRCRAFT IN BASE MAINTENANCE: HAIL PUNCTURE IN LEFT HAND ELEVATOR UPPER SURFACE LOCATED AT ELEVATOR STA 76, 6.5 INCHES FROM TRAILING EDGE. REPAIRED SKIN PER SRM 51-70-04.SDR AALA202304051264Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL LOCATED FROM BS 951 TO BS 967 AT RBL 52. REPLACED INTERCOSTAL PER SRM 53-70-51-1A.SDR AALA202304055507Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM T CHORD LOCATED AT BS 986 AND FROM BL 0 TO RBL 50. REPLACED T CHORD PER DWG DBF-1555.SDR AALA202304040364Transmitter · faultyAIRCRAFT WAS GROUNDED: TRAILING EDGE FLAPS STUCK AT BETWEEN 5 INCHES AND 10 INCHES. EMERGENCY WAS DECLARED INTO MID. ACCOMPLISHED GENERAL VISUAL INSPECTION OF LEFT AND RIGHT WING FLAP DOWN BRIVE GEAR BOXES, TORQUE TUBES AND RELATED COMPONENTS, FOUND NO DISCREPSDR AALA202304034949Bracket · out of adjustAIRCRAFT WAS NOT GROUNDED: 1L DOOR SLIDE GIRT BAR BRACKET DOES NOT HOLD BAR. (STOW BAR). READJUSTED 1L DOOR SLIDE BRACKET.SDR AALA202304035812Hook · out of adjustAIRCRAFT WAS NOT GROUNDED: 1R DOOR GIRT BAR IS HARD TO STOW AND/OR RELEASE FROM STORAGE HOOKS. ADJUSTED STORAGE HOOKS FOR GIRT BAR ON 1R DOOR.SDR AALA202304037398Fitting · looseAIRCRAFT WAS NOT GROUNDED: 1L DOOR SLIDE GIRT BAR DOES NOT STAY IN UNARMED BRACKET. READJUSTED AND TIGHTENED GIRT BAR HOLDER BRACKET IN ACCORDANCE WITH AMM 25-66-01. CHECK OPERATES GOOD. OK FOR SERVICE.SDR AALA202304030568Handle · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HANDLE IS LOOSE AND DIFFICULT TO OPEN. TIGHTENED SCREW ON FORWARD LAVATORY HANDLE. OPERATES NORMAL.SDR AALA202304052688Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND Z CHANNEL LOCATED AT BS 982 AND LBL 40. REPLACED CHANNEL PER DWG 147A5700 REV AA.SDR AALA202304053298Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED FROM BS 328 TO BS 344 AT LBL 46. REPLACED INTERCOSTAL PER DWG 141A5400.SDR AALA202304030556Door · out of adjustAIRCRAFT WAS NOT GROUNDED: ENTRY DOOR DIFFICULT TO OPEN/CLOSE FORWARD LAVATORY. DOOR ADJUSTED AS REQUIRED. DOOR OPERATES NORMALLY.SDR AALA202304034530Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT SEAT HAS 1 FLASH LIGHT INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERYSDR AALA202304037727Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT AFT FLIGHT ATTENDANT SEAT HAS 1 FLASH LIGHT INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERYSDR AALA202304034410Girt Bar · looseAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT 1 REPORTED L1 DOOR SLIDE GIRT BAR LOOSE. ADJUSTED GIRT BAR BRACKETS AT L-1 DOOR SLIDE.SDR AALA202304038803Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX UPPER FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-10.
Back to Boeing 737-823