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 AALA202507184661B-Nut · leakingAIRCRAFT WAS GROUNDED: STRONG SMELL AND LEAKAGE FROM FORWARD LAVATORY ON TAKEOFF AND LANDING AS REPORTED BY FLIGHT ATTENDANT. TROUBLESHOOT PER FIM 38-1000-810-807, UPON OPENING SINK CAB DOOR FOUND WATER DRIPPING FROM B-NUT ON WATER HEATER. TIGHTENED B-NUT, PERSDR AALA202509033988Flange · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO AFT CARGO COMPARTMENT CARGO TRACK UPPER FLANGE LOCATED AT BS 787 PLUS 5 INCHES, AT RBL 3. REPARED CARGO TRACK FLANGE PER SRM 53-00-53-2R-3.SDR AALA202508291975Skin · crackedAIRCRAFT IN BASE MAINTENANCE: FUSELAGE EXTERNAL POWER DOOR CUTOUT AFT EDGE HAS A SKIN CRACKED AROUND UPPER FASTENER SECURING AFT LATCH PAD. COMPLETED REPAIR. PER SRM 53-10-15-2R-4.SDR AALA202508289605Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR CHANNEL AT BS 787 PLUS 5 INCHES, AT LBL 3. REPAIRED FLOOR CHANNEL PER SRM 53-00-53-2R-2 ALTERNATIVE 3.SDR AALA202508280838Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED AT BS 767, RBL 22. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202508283815Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL ANGLE LOCATED FROM BS 767 TO BS 787 AT RBL 22. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202508206562Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO AFT CARGO COMPARTMENT CHANNEL FLOOR BEAM LOCATED AT BS 787 PLUS 5 INCHES, RBL 8. REPAIRED PER SRM 53-00-53-2R.SDR AAL202508180007Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO AFT CARGO COMPARTMENT CHANNEL FLOORBEAM LOCATED AT BS 787 PLUS 5 INCHES, RBL 8. REPAIRED PER SRM 53-00-53-2R.SDR AALA202508183386Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO AFT CARGO COMPARTMENT CHANNEL FLOORBEAM LOCATED AT BS 787 PLUS 5 INCHES, RBL 13.5. REPAIRED PER SRM 53-00-53-2R.SDR AALA202508181799Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO AFT CARGO COMPARTMENT CHANNEL FLOOR BEAM LOCATED AT BS 787 PLUS 5 INCHES, LBL 8. REPAIRED PER SRM 53-00-53-2R-2.SDR AALA202508126423Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR ENTRY WAY LOWER SILL INNER CHORD (CREASE ANGLE) FROM BS 320 TO BS 332 AT S17R, RBL 58. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202508064176Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 807 TO BS 827 AT S26L. BLENDED CORROSION PER SRM 53-00-53-1A-2.SDR AALA202508053631Spring · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HORIZONTAL STABILIZER ELEVATOR TAB CONTROL MECHANISM SPRINGS LOWER HARDWARE HAS EVIDENCE OF SURFACE RUST. REMOVED AND REPLACED LEFT HORIZONTAL STABILIZER ELEVATOR TAB CONTROL MECHANISM SPRINGS LOWER HARDWARE AND PERFORMED SATSDR AALA202507221082Fitting · missingAIRCRAFT IN BASE MAINTENANCE, L1 SLIDE GIRT BAR MISSING SPRING CLIP. REMOVED AND REPLACED L1 SLIDE GIRT BAR SPRING CLIP IAW AMM 25-66-01.SDR AALA202507229494Spring Assy · wornAIRCRAFT IN BASE MAINTENANCE: R1 GIRT BAR SPRING CLIP WORN. REMOVED AND REPLACED R1 GIRT BAR SPRING CLIP. PER AMM 25-66-01.SDR AALA202507180509Uplock Sensor · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER RAISING THE GEAR HANDLE, RIGHT MAIN GEAR LIGHT STAYED RED. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. PERFORMED TASK FOR RIGHT MAIN GEAR UPLOCK SENSOR FAULT, PER FIM 32-61-00. NO FSDR AALA202507177880Relay · inoperativeAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS THAT MULTIPLE CABIN AND EMERGENCY EXITLIGHTS ARE NOT WORKING. ACCOMPLISHED TROUBLESHOOTING, PER WDM 33-21-11. REMOVED AND REPLACED RELAY R120, PER AMM 20-10-07-201. ACCOMPLISHED OPERATIONAL TEST, PER AMM 33-21-00SDR AALA202507177323Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN, THE LAVATORY-D DOOR HINGE IS BINDING. LUBED DOOR HINGES, OPERATIONAL CHECK NORMAL. PER AMM 25-40-14.SDR AALA202507174387Slide · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENTS REPORT THAT R1 DOOR SLIDE IS SHOWING PART OF THE SLIDE OUT OF THE SLIDE COVER AROUND THE BOTTOM PART. SECURED R1 DOOR SLIDE. PER AMM 25-66-01.SDR AALA202507170353Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENTS ADVISED LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. READJUSTED AFT LAVATORY-D TOP DOOR RAIL SCREW IN POSITION. OPERATIONAL CHECKED GOOD. PER CMM 26-40-64.SDR AALA202507175806Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: R1 SERVICE DOOR GIRT BAR STOWED BRACKETS ARE REPORTED TO TIGHT TO DETACH GIRT BAR. LUBED GIRT BAR. PER AMM 25-66-01. OPERATIONAL CHECK GOOD.SDR AALA202507177332Sill Drain · odorAIRCRAFT WAS GROUNDED: AFTER LANDING FLIGHT ATTENDANTS IN THE AFT CABIN REPORTED A STINKY DIRTY DIAPER OR SULPHUR LIKE SMELL UPON LANDING AND SAID NOTICED IT SLIGHTLY DURING TAKEOFF AS WELL. SWITCHED AIRFLOW FROM ENGINE BLEEDS TO APU BLEED AND REMAINED UNTIL SDR AALA202507170509Warning Light · illuminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER RAISING THE GEAR HANDLE, RIGHT MAIN GEAR LIGHT STAYED RED. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. (OPEN).SDR AALA202512015435Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE SUPPORT ANGLE LOCATED AT BS 1006 PLUS 5 INCHES, LBL 32. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202510033570Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) LOCATED AT BS 986, LBL 3. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-4.SDR AALA202509165435Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE SUPPORT ANGLE LOCATED AT BS 1006 PLUS 5 INCHES, LBL 32. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202509098001Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT (Z ANGLE) LOCATED AT BS STA 986 PLUS 6 INCHES, FROM RBL 35 TO RBL 41. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202508296151Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO AFT PASSENGER CABIN FLOOR STRUCTURE DRAIN ANGLE SUPPORT INTERCOSTAL LOCATED FROM BS 945 TO 947 AT RBL 52. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202508257160Crease Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CREASE BEAM INNER CHORD LOCATED AT BS 638, LBL 64. REPAIRED CHORD PER SRM 53-40-13-2R-1SDR AALA202508256363Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR ENTRY WAY LOWER SILL INNER CHORD (CREASE ANGLE) LOCATED FROM BS 324 TO BS 330 AT RBL 60. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202508227569Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR ENTRY WAY LOWER SILL INNER CHORD (CREASE ANGLE) LOCATED FROM BS 947 TO BS 986 AT RBL 52. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202508202397Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FORWARD OF AFT LAVATORY INBOARD MOUNT AT BS 947, RBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05.SDR AALA202508186193Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER SILL INNER CHORD (CREASE ANGLE) LOCATED FROM BS 312 TO BS 344 AT LBL 59. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202508185132Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR SUPPORT LOCATED AT BS 986 PLUS 8 INCHES, FROM LBL 40 TO LBL 46. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202508183570Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) LOCATED AT BS 786, LBL 3. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-4.SDR AALA202508130349Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOORBEAM AT STA 950 FORM LBL 24 TO LBL 50. REPLACED FLOORBEAM PER AARD 51-00-05-01.SDR AALA202508115221Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L2 DOOR ENTRY WAY LOWER SILL INNER CHORD (CREASE ANGLE) FROM BS 950 TO BS 987 AT LBL 54. REPLACED CHORD PER SRM 53-70-51-1A-1.SDR AALA202508081788Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO L1 DOOR THRESHOLD SUPPORT ANGLE (TAB SUPPORT) AT BS 338, LBL 62. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202507296651Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947, FROM S17L TO S17R, FROM LBL 42 TO RBL 32. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202507171395Flap System · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CONFIGURATION FROM FLAPS 25 TO FLAPS 30, OBSERVED TRAILING RIDGE FLAP DISAGREE BY A NEEDLE WIDTH. RECEIVED THE AMBER LEADING EDGE FLAPS TRANSIT AND NO GREEN LEADING EDGE FLAPS LIGHT. EXECUTED A GOSDR AALA202507161602Sign · missingAIRCRAFT WAS NOT GROUNDED: OVERHEAD EXIT SIGN MISSING OVER AISLE NEAR ROW 16. REPLACED COVER ASSEMBLY. PER IPC 35-51-01.SDR AALA202507168062Locking Cam · lack of lubeAIRCRAFT WAS NOT GROUNDED: THE GIRT BAR BRACKETS ON THE FORWARD SERVICE DOOR ARE STICKING AND DIFFICULT TO ARM AND DISARM THE DOOR. LUBED R1 DOOR SLIDE BRACKETS AND OPERATIONAL CHECK. PER AMM 25-66-02.SDR AALA202507162155Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT BULB INOPERATIVE IN AISLE EXIT SIGN AT OVERWING EXIT. REPLACED BULB. PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA202507161395Flap System · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CONFIGURATION FROM FLAPS 25 TO FLAPS 30, OBSERVED TRAILING RIDGE FLAP DISAGREE BY A NEEDLE WIDTH. RECEIVED THE AMBER LEADING EDGE FLAPS TRANSIT AND NO GREEN LEADING EDGE FLAPS LIGHT. EXECUTED A GOSDR AALA202507176580Oil System · leakingAIRCRAFT WAS GROUNDED: STRONG SMELL ON TAKEOFF ROLL, SIMILAR TO DIRTY SOCKS. NOTICABLE AT 40% N1, BECAME WORSE AS WE INCREASED THRUST. EVIDENCE OF OIL WAS FOUND ON THE STAGE 3 BOOSTER BLADES AND EVIDENCE OF SIGNIFICANT COKING WAS PRESENT ON THE STAGE 4 GUIDE SDR AALA202507166580Unknown · odorAIRCRAFT WAS GROUNDED: STRONG SMELL ON TAKEOFF ROLL, SIMILAR TO DIRTY SOCKS. NOTICABLE AT 40% N1, BECAME WORSE AS WE INCREASED THRUST. (OPEN).SDR AALA202507162470Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LOCK VERY DIFFICULT TO LOCK AND UNLOCK. LUBRICATED LEFT HAND AFT LAVATORY DOOR. OPERATIONAL CHECK NORMAL.SDR AALA202507157128Adiru · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKE OFF APPROX 5000FT BOTH CAPTAIN AND FIRST OFFICER PFD GOT PITCH AMBER FLAG AND THEN ROLL FLAG, AND SCRATCH PAD MESSAGE THE IRS DISAGREE FOLLOWED BY LEFT IRS FAULT LIGHT. CAPTAINS PFD WAS UNRELISDR AALA202507146294Sensor · false indicationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WHILE CONFIGURING THE FLAPS ON FINAL APPROACH, THE AIRCREW NOTICED A SPLIT FLAP MALFUNCTION BETWEEN FLAPS 5 AND FLAPS 2. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT VPS. REMOVE AND REPLACE THE NUMBER 2 SKESDR AALA202508111663Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 16 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.
Back to Boeing 737-823