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 AALA202110048444Handle · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT 17F HANDLE REPORTED RATTLING CONSTANTLY. ACCOMPLISHED VISUAL INSPECTION OF RIGHT EMERGENCY EXIT 17F LATCH COMPONENTS FOUND LOOSE HARD WARE INSIDE DOOR HANDLE SECURED HANDLE PER AMM 52-22-00-210-801.SDR AALA202110048851Handle · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY INSIDE DOOR HANDLE BROKEN, OR LOOSE. TIGHTENED LAVATORY DOOR HANDLE SCREW AS REQUIRED.SDR AALA202110207659Plate · misalignedAIRCRAFT IN BASE MAINTENANCE: AFT UPPER STOP FITTING STRIKER PLATE IS MISALIGNED AT RH AFT EMERGENCY EXIT DOOR. ADJUSTED STRIKER PLATE IAW B737NG AMM 52-22-01-400-801, OPS CHECK GOOD.SDR AALA202110087588Rib · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER RIB CRACKED AT STA 155.00. REPAIRED PER SRM 55-10-09.SDR AALA202110080879Skin Panel · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STA 111.10. REPAIRED PER SRM 55-10-01.SDR AALA202110041277Pin · out of positionAIRCRAFT WAS NOT GROUNDED: CEILING EMERGENCY LIGHT BY ROW 32 DEF INOPERATIVE. FOUND CONNECTOR D11321 INCORRECTLY PINNED. REPINNED CONNECTOR D11321.SDR AALA202110045448Cover · detachedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT COVER AT SEAT 10C IS DETACHED. RESECURED SEAT 10C ESCAPE PATH LIGHT COVER PER AMM 20-00-00.SDR AALA202110045531Power Supply · failedAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING JOB CARD 08T21033001 FOUND EMERGENCY LIGHT BATTERY PACK M1673 FAILED TEST. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY PER AMM 33-51-06.SDR AALA202110044001Charger · intermittentAIRCRAFT WAS GROUNDED: FORWARD EXIT LIGHT FLICKERS INTERMITTENTLY ON AND OFF. REPLACED EMERGENCY EXIT LIGHTS BATTERY PACK (AALA202110041777) AND CHARGER M01675.SDR AALA202110041777Battery Pack · intermittentAIRCRAFT WAS GROUNDED: FORWARD EXIT LIGHT FLICKERS INTERMITTENTLY ON AND OFF. REPLACED EMERGENCY EXIT LIGHTS BATTERY PACK AND CHARGER (AALA202110044001) M01675.SDR AALA202110045111Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR EXT SLIDE LIGHT OFF LIGHT INOPERATIVE. REPLACED LAMP L730 PER AMM 33-51-04.SDR AALA202110205195Battery · depletedAIRCRAFT IN BASE MAINTENANCE: AFT RH FLASHLIGHT BATTERY DEPLETED. REPLACED BATTERY WITH NEW IAW AA B737-NG AMM 25-64-00-900-806, OPS CHECK GOOD.SDR AALA202110085582Rib · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND A CRACK ON THE RIB OF THE HORIZONTAL STABILIZER LOCATED AT STA 92.70. INSTALLED REPAIR ANGLES PER SRM 55-10-09.SDR AALA202110111818Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LOWER SKIN OF RH HORIZONTAL STABILIZER AT STA 101.9. ACCOMPLISHED REINFORCING REPAIR WITH REPETITIVE INSPECTIONS IAW SRM 55-10-01-2R-R11.SDR AALA202110118779Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LOWER SKIN OF LH HORIZONTAL STABILIZER AT STA 138.7. ACCOMPLISHED REINFORCING REPAIR WITH REPETITIVE INSPECTIONS IAW SRM 55-10-01-2R-R11.SDR AALA202110114864None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF TRANSITION PANEL NEAR FASTENER HOLES BETWEEN STA 500 AND STA 500A AT RBL 26, MEASURING L=1.0 IN, W=1.0 IN, D=0.031 IN. ACCOMPLISHED PERMANENT REINFORCING PLUG REPAIR IAW EA330774.SDR AALA202109293321Escape Rope · out of positionAIRCRAFT WAS NOT GROUNDED: RIGHT FORWARD OVERWING EXIT ESCAPE ROPE REQUIRES STOWING. STOWED ROPE PER AMM 52-22-51.SDR AALA202109297785Handle · out of positionAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY INSIDE HANDLE CAME OFF. REINSTALLED FORWARD LAVATORY DOOR HANDLE PER STANDARD MAINTENANCE PRACTICES.SDR AALA202109295460Cover · out of positionAIRCRAFT WAS NOT GROUNDED: SLIDE COVER AT CABIN DOOR 4L IS NOT FLUSH WITH DOOR. ADJUSTED SLIDE COVER AT DOOR 4L, OPERATIONS CHECK NORMAL PER AMM 25-66-00.SDR AALA202109295208Acm · damagedAIRCRAFT WAS GROUNDED: SULFUR SMELL ON TAKEOFF POWER AND DURING FINAL APPROACH. REPLACED AIR CYCLE MACHINE OF LH PACK IAW AMM 21-51-04, OPS CHECK GOOD.SDR AALA202109296277Indicator · faultedAIRCRAFT WAS GROUND. FLAPS INDICATOR SPLIT BETWEEN FLAPS 1 AND FLAPS 2 ON FINAL APPROACH. EMERGENCY DECLARED, GO AROUND EXECUTED. MAINTENANCE REPLACED FLAP POSITION INDICATOR PER AMM 27-58-02.SDR AALA202109296757None · looseAIRCRAFT WAS NOT GROUNDED: GIRT BAR, DOOR 1L, LOOSE. ADJUSTED 1L DOOR SLIDE GIRT BAR STOW CLIPS AS REQUIRED.SDR AALA202109294825Windshield · crackedAIRCRAFT WAS GROUNDED: L1 WINDSHIELD CRACKED IN FLIGHT OUTER PANE ONLY. REMOVED AND REPLACED L1 WINDSHIELD PER MCM 08L21056003.SDR AALA202109292620Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT LIGHT RIGHT WING OVERWING FORWARD IS INOPERATIVE. REMOVED AND REPLACED LAMP ON EMERGENCY EXIT LIGHT RIGHT OVERWING FORWARD PER AMM 33-51-04.SDR AALA202110085413Shade · damagedAIRCRAFT WAS NOT GROUNDED: WINDOW SHADE INOPERATIVE AT EXIT ROW 16. **SUPPLEMENTAL REPORT: REPLACED WINDOW SHADE ASSEMBLY WITH NEW IAW AMM 25-21-12, OPS CHECK GOOD.** (CLOSED)SDR AALA202109295953Shroud · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT PATH LIGHTING INDICATOR AT SEAT 9C HANGING BY WIRING. REPLACED EPL COVER WITH NEW IAW CMM 25-23-67, OPS CHECK GOOD.SDR AALA202109295413None · noneAIRCRAFT WAS NOT GROUNDED: WINDOW SHADE INOPERATIVE AT EXIT ROW 16. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202109281109Speed Brake · fault messageAIRCRAFT WAS NOT GROUNDED: WITH THE AUTO SPEED BRAKE INOPERATIVE ON TAKEOFF ROLL AT 60 KNOTS AND TAKE OFF GO AROUND, TO CONFIGURE WARNING SOUNDED. TO ABORTED. ACCOMPLISHED AURAL WARNING TEST PER AMM 31-51-00. ALL TESTS GOOD.SDR AALA202109281144Girt Bar · stickingAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR STUCK IN DISARMED POSITION. UNSTUCK GIRT BAR ON R1 DOOR AND SECURED IN SAFE POSITION.SDR AALA202109286174Buss · burnedAIRCRAFT WAS GROUNDED: ELECTRICAL ISSUE WITH TR2 FAIL, LEFT PUMP FAIL, PACK FAIL, AND BATTERY DISCHARGE LIGHT; FLIGHT DECLARED EMERGENCY AND LANDED WITHOUT FURTHER INCIDENT. REPLACED P92 RIGID BUS IAW B737NG AMM TASK 24-21-22-000/400-801, OPS CHECK GOOD.SDR AALA202109287550Lens · inoperativeAIRCRAFT WAS NOT GROUNDED: OVERWING EXIT EMERGENCY EXIT LIGHT IS MISSING ITS COVER. REPLACED LENS ROW 17A EMERGENCY EXIT SIGN PER AMM 33-51-01.SDR AALA202109280153None · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT FOR SEAT 15C LOOSE FROM SEAT MOUNT. INSTALLED MISSING HARDWARE ON 15C TRIM PER CMM 25-28-03.SDR AALA202109287804Controller · fault messageAIRCRAFT WAS GROUNDED: DURING TAKEOFF ROLL BOTH ELECTRONIC ENGINE CONTROL ALTERNATE LIGHTS ILLUMINATED AT 62KTS ABORTED TAKEOFF 150100 TAKE OFF WEIGHT. RAN NUMBER 1 AND NUMBER 2 ENGINE PER TASK 71-00-00-700-808 AT IDLE FOR 5 MIN. PERFORMED ENGINE SHUT DOWN, PESDR AALA202109280211Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR INTERCOSTAL SUPPORT AT FWD ENTRY NEAR FASTENER HOLE BETWEEN STA 344 AND STA 360 AT BL 0, MEASURING L=0.5 IN. REPLACED SUPPORT WITH MODIFIED PART IAW AARD 51-00-05-1 AND SRM 51-10-02-0G.SDR AALA202109241974Filter · dirtyAIRCRAFT WAS NOT GROUNDED: MUSTY SMELL DURING FINAL APPROACH. REPLACED LH AND RH (AALA202109249326) RECIRCULATION AIR FILTERS IAW AMM 21-25-01, OPS CHECK GOOD.SDR AALA202109249326Air Filter · dirtyAIRCRAFT WAS NOT GROUNDED: MUSTY SMELL DURING FINAL APPROACH. REPLACED LH (AALA202109241974) AND RH RECIRCULATION AIR FILTERS IAW AMM 21-25-01, OPS CHECK GOOD.SDR AALA202109240208Filter · cloggedAIRCRAFT WAS GROUNDED: ON TAKEOFF ROTATION FLIGHT CONTROL LIGHT AND LOW PRESSURE SYSTEM A ENGINE AND ELECTRIC LIGHT ILLUMINATED. HYDRAULIC QUANTITY A DROPPED TO 61% WITH ODOR IN COCKPIT. RETURNED TO JFK PRECAUTIONARY LANDING. EMERGENCY WAS DECLARED. AIRCRAFT WSDR AALA202109242854Filter · dirtyAIRCRAFT WAS GROUNDED: ON TAKEOFF ROTATION FLIGHT CONTROL LIGHT AND LOW PRESSURE SYSTEM A ENGINE AND ELECTRIC LIGHT ILLUMINATED. HYDRAULIC QUANTITY A DROPPED TO 61% WITH ODOR IN COCKPIT. RETURNED TO JFK PRECAUTIONARY LANDING. EMERGENCY WAS DECLARED. AIRCRAFT WSDR AALA202109240230Filter · cloggedAIRCRAFT WAS GROUNDED: ON TAKEOFF ROTATION FLIGHT CONTROL LIGHT AND LOW PRESSURE SYSTEM A ENGINE AND ELECTRIC LIGHT ILLUMINATED. HYDRAULIC QUANTITY A DROPPED TO 61% WITH ODOR IN COCKPIT. RETURNED TO JFK PRECAUTIONARY LANDING. EMERGENCY WAS DECLARED. AIRCRAFT WSDR AALA202109245460Filter · dirtyAIRCRAFT WAS GROUNDED: ON TAKEOFF ROTATION FLIGHT CONTROL LIGHT AND LOW PRESSURE SYSTEM A ENGINE AND ELECTRIC LIGHT ILLUMINATED. HYDRAULIC QUANTITY A DROPPED TO 61% WITH ODOR IN COCKPIT. RETURNED TO JFK PRECAUTIONARY LANDING. EMERGENCY WAS DECLARED. AIRCRAFT WSDR AALA202109240831Hose · leakingAIRCRAFT WAS GROUNDED: ON TAKEOFF ROTATION FLIGHT CONTROL LIGHT AND LOW PRESSURE SYSTEM A ENGINE AND ELECTRIC LIGHT ILLUMINATED. HYDRAULIC QUANTITY A DROPPED TO 61% WITH ODOR IN COCKPIT. RETURNED TO JFK PRECAUTIONARY LANDING. EMERGENCY WAS DECLARED. AIRCRAFT WSDR AALA202109281337Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR INTERCOSTAL SUPPORT AT FWD ENTRY NEAR FASTENER HOLE BETWEEN STA 312 AND STA 328 AT LBL 46, MEASURING L=0.5 IN. REPLACED INTERCOSTAL WITH NEW IAW AARD 51-10-02 AND DRAWING 141A5400.SDR AALA202109212517Light · out of positionAIRCRAFT WAS NOT GROUNDED: SEAT 25C EXIT LIGHT OUT OF SLOT. REATTACHED EXIT LIGHT AT SEAT 25C PER CMM 25-23-67.SDR AALA202109210193Screw · out of positionAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY INSIDE DOOR HANDLE FALLS OFF. NEEDS A SET SCREW. INSTALLED NEW SET SCREW ON FORWARD LAVATORY DOOR HANDLE OPERATIONS CHECKS GOOD AMM 25-40-11.SDR AALA202110080026Floor Panel · damagedAIRCRAFT WAS GROUNDED: FLOOR PANELS SOFT AND DEFLECTING AT ROWS 2-5. **SUPPLEMENTAL REPORT: REPLACED FLOOR PANELS 231AF, 231DF (AALA202110081458), AND 231GF (AALA202110081676) WITH NEW IAW AMM 53-21-00 AND AARD 53-00-50-01.** (CLOSED)SDR AALA202110081458Floor Panel · damagedAIRCRAFT WAS GROUNDED: FLOOR PANELS SOFT AND DEFLECTING AT ROWS 2-5. **SUPPLEMENTAL REPORT: REPLACED FLOOR PANELS 231AF, 231DF (AALA202110081458), AND 231GF (AALA202110081676) WITH NEW IAW AMM 53-21-00 AND AARD 53-00-50-01.** (CLOSED)SDR AALA202110081676Floor Panel · damagedAIRCRAFT WAS GROUNDED: FLOOR PANELS SOFT AND DEFLECTING AT ROWS 2-5. **SUPPLEMENTAL REPORT: REPLACED FLOOR PANELS 231AF (AALA202109230026), 231DF (AALA202110081458), AND 231GF WITH NEW IAW AMM 53-21-00 AND AARD 53-00-50-01.** (CLOSED)SDR AALA202109219508Sign · inoperativeAIRCRAFT WAS NOT GROUNDED: EXIT ROW SIGN FELL DOWN. RE SECURED EXIT ROW SIGN AS REQUIRED.SDR AALA202109216334Lens · inoperativeAIRCRAFT WAS NOT GROUNDED: DOOR EMERGENCY EXIT LIGHT AT SEAT 16F DAMAGED. INSTALLED NEW EMERGENCY LIGHT LENS AT DOOR SEAT 16F PER AMM 33-51-03.SDR AALA202109210363Girt Bar · damagedAIRCRAFT WAS NOT GROUNDED: L2 DOOR SLIDE GIRT BAR CLIP IS DAMAGED OR LOOSE. RESECURED CLIP ON L2 DOOR AS REQUIRED.
Back to Boeing 737-823