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 AALA202510075636Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 947.5 TO BS 967 AT RBL 50. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202510074634Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CAP) LOCATED AT BS 947.5, RBL 4. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202510075149Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CAP) LOCATED AT BS 947.5, LBL 12. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202510074654Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CAP) LOCATED AT BS 947.5, LBL 4. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202510079915Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CAP) LOCATED AT BS 947 BETWEEN S25L AND S25R. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202510073622Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CAP) LOCATED AT BS 947.5, RBL 25. REPAIRED UPPER CHORD PER SRM 53-70-51.SDR AALA202510077322Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CAP) LOCATED AT BS 947.5, RBL 53 . REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202509149783Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 947 TO BS 986.5 AT RBL 50. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202509091044Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 ENTRY LOWER SILL INNER CHORD (CREASE ANGLE) LOCATED AT BS 993, RBL 46. BLENDED CORROSION PER SRM 51-10-02.SDR AALA202509096373Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 ENTRY LOWER SILL INNER CHORD (CREASE ANGLE) LOCATED AT BS 328 PLUS 2.5 INCHES. BLENDED CORROSION PER SRM 51-10-02.SDR AALA202509087800Window · scratchedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FORWARD RIGHT HAND OVERWING EXIT WINDOW IS SCRATCHED. WINDOW REPLACED PER AMM 56-22-00.SDR AALA202509083976Window · scratchedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN AFT LEFT HAND OVERWING EXIT WINDOW IS SCRATCHED. WINDOW REPLACED PER AMM 56-22-00.SDR AALA202509082639Window · scratchedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FORWARD LEFT HAND OVERWING EXIT WINDOW IS SCRATCHED. WINDOW REPLACED PER AMM 56-22-00.SDR AALA202509088123Window · scratchedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN AFT RIGHT HAND OVERWING EXIT WINDOW IS SCRATCHED. WINDOW REPLACED PER AMM 56-22-00.SDR AALA202509058159Fseu · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WHILE CONFIGURING FLAPS DURING APPROACH FLAPS ASYMMETRY (SPLIT) OCCURRED. AIRCRAFT EMERGENCY LANDED SAFELY AT GUA. REMOVED AND REPLACED FLAP POSITION INDICATOR (AALA202509045316) AND FSEU (AALA20250905SDR AALA202509052245Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT AFT FLIGHT ATTENDANT JUMP SEAT IS INOPERABLE. INSPECTED AND CHECKED AFT FLIGHT ATTENDANT LEFT HAND JUMP SEAT, PER AMM 25-64-00. FOUND FLASHLIGHT OPERATIVE AND HOLDER GOOD. NO DEFECTS NOTED.SDR AALA202509055316Indicator · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WHILE CONFIGURING FLAPS DURING APPROACH FLAPS ASYMMETRY (SPLIT) OCCURRED. AIRCRAFT EMERGENCY LANDED SAFELY AT GUA. REMOVED AND REPLACED FLAP POSITION INDICATOR (AALA202509045316) AND FSEU (AALA202509058SDR AALA202509044354Sign · missingAIRCRAFT WAS NOT GROUNDED: FORWARD FACING EXIT SIGN ABOVE AISLE AND ADJACENT TO OVERWING EXITS IS MISSING. REINSTALLED EXIT SIGN COVER. PER 33-51-01.SDR AALA202509042245Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT AFT FLIGHT ATTENDANT JUMP SEAT IS INOPERABLE. (OPEN).SDR AALA202509043582Light · burned outAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT AFT OF RIGHT WING BURNED OUT. REPLACED LIGHT AND OPERATIONAL CHECK GOOD. PER AMM 33-35-00.SDR AALA202509045316Flap System · splitAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WHILE CONFIGURING FLAPS DURING APPROACH FLAPS ASYMMETRY (SPLIT) OCCURRED. AIRCRAFT EMERGENCY LANDED SAFELY AT GUA. (OPEN).SDR AALA202509173527Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: CABIN RIGHT HAND FORWARD EMERGENCY EXIT WHEN POSITIONED IN OPEN POSITION, AFT SIDE LOWER STOP PAD IS ASKEW. INSTALLED NEW STOP PAD ON RIGHT HAND FORWARD EMERGENCY EXIT DOOR. PER AMM 52-22-01.SDR AALA202509177394Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: CABIN LEFT HAND AFT EMERGENCY EXIT WHEN POSITIONED IN OPEN POSITION, AFT SIDE LOWER STOP PAD IS ASKEW. INSTALLED NEW STOP PAD ON LEFT HAND AFT EMERGENCY EXIT DOOR. PER AMM 52-22-01.SDR AALA202509171469Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: CABIN: RIGHT HAND AFT EMERGENCY EXIT WHEN POSITIONED IN THE OPEN POSITION, FORWARD SIDE LOWER STOP PAD IS ASKEW. INSTALLED NEW STOP PAD ON RIGHT HAND AFT EMERGENCY EXIT DOOR. PER AMM 52-22-01.SDR AALA202509176492Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: CABIN: LEFT HAND FORWARD EMERGENCY EXIT WHEN POSITIONED IN THE OPEN POSITION, AFT SIDE LOWER STOP PAD IS ASKEW. INSTALLED NEW STOP PAD ON LEFT HAND FORWARD EMERGENCY EXIT DOOR. PER AMM 52-22-01.SDR AALA202509178016Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: CABIN: RIGHT HAND AFT EMERGENCY EXIT WHEN POSITIONED IN THE OPEN POSITION, AFT SIDE, LOWER STOP PAD IS ASKEW. INSTALLED NEW STOP PAD ON RIGHT HAND AFT EMERGENCY EXIT DOOR. PER AMM 52-22-01.SDR AALA202509120574Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER COMPARTMENT BREAK ASSEMBLY PANEL LOCATED AT BS 538, RBL 10. REPLACED BRAKE ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202509120488Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER COMPARTMENT BREAK ASSEMBLY PANEL LOCATED AT BS 538, LBL 10. REPLACED BRAKE ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202509082547Window · scratchedAIRCRAFT IN BASE MAINTENANCE: LEFT EMERGENCY EXIT WINDOW L19 HAS MULTIPLE SCRATCHES ON EXTERIOR. REPLACED WINDOW PER AMM 56-22-00-400-801.SDR AALA202509041818Flap System · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAPS STUCK AT FLAPS 5; AIRCRAFT EMERGENCY LANDED SAFELY AT EWR. UPON ARRIVAL PERFORMED BITE TEST OF FLAP AND SLAT (FSEU), PER AMM 27-51-00-810-801. NO FAULTS RECORDED. PERFORMED FLAPS AND SLAT OPERATIONSDR AALA202509049158Tube · missingAIRCRAFT WAS NOT GROUNDED: AFT ENTRY DOOR GIRT BAR MISSING RED HEATSHRINK. INSTALLED HEAT SHRINK ON AFT LEFT DOOR GIRT BAR, PER AMM 25-66-00. OPERATIONAL CHECK GOOD.SDR AALA202509045297Connector · dirtyAIRCRAFT WAS NOT GROUNDED: RIGHT AFT FUEL PUMP LOW PRESSURE LIGHT NOT ILLUMINATING WITH PUMP TURNED OFF. FOUND TANK NUMBER 2 AFT FUEL PUMP LOW PRESSURE LIGHT INOPERATIVE. **SUPPLEMENTAL REPORT FOR (AALA202509035297): CLEANED CONNECTOR D872. PERFORMED AFT RIGHTSDR AALA202509034347Coupling · brokenAIRCRAFT WAS NOT GROUNDED: FOUL LAVATORY LIKE ODOR IN THE FLIGHT DECK. FOUND FORWARD TOILET VACUUM LINE COUPLING BROKEN AND SEEPING INTO FLIGHT DECK. REPLACED COUPLING, PER AMM 38-32-01. OPERATIONAL CHECK GOOD NO LEAKS NOTED. ACCOMPLISHED WORK CARD SMOKE ODOR SDR AALA202509034003Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LATCH HARD TO UNLOCK. SEVERAL PASSENGERS HAD TROUBLE GETTING OUT. ADJUSTED LAVATORY DOOR. PER AMM 25-40-00.SDR AALA202509039158Tube · missingAIRCRAFT WAS NOT GROUNDED: AFT ENTRY DOOR GIRT BAR MISSING RED HEATSHRINK. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202509034969Pin · out of adjustAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT AND AGENT REPORTED HAVING A DIFFICULT TIME OPENING THE L1 DOOR. FOUND STOP PINS REQUIRED ADJUSTMENT. ADJUSTED PINS, PER AMM 52-11-00.SDR AALA202509034395Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY DOOR HARD TO OPEN. LUBED AFT RIGHT LAVATORY DOOR STRIKER. OPERATIONAL CHECK GOOD.SDR AALA202509035539Bustle · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT FORWARD SERVICE SLIDE BUSSEL HAS 4 INCH GAP BETWEEN IT AND DOOR. FOUND R1 DOOR LOOSE SECURED R1 BUSSEL. PER AMM 25-66-01.SDR AALA202509032327Sign · missingAIRCRAFT WAS NOT GROUNDED: BACK SIDE OF EXIT SIGN ON CEILING ABOVE EXIT ROW 16 IS MISSING THE ARROWS POINTING TO OVER WING DOORS. REMOVED AND REPLACED EXIT SIGN. PER AMM 33-51-01.SDR AALA202509035297Pump · low pressureAIRCRAFT WAS NOT GROUNDED: RIGHT AFT FUEL PUMP LOW PRESSURE LIGHT NOT ILLUMINATING WITH PUMP TURNED OFF. FOUND TANK NUMBER 2 AFT FUEL PUMP LOW PRESSURE LIGHT INOPERATIVE. (OPEN).SDR AALA202509035848Girt Bar · dislodgedAIRCRAFT WAS NOT GROUNDED: R1 SERVICE DOOR SLIDE COMING OUT OF BUSSEL. RESECURED R1 DOOR SLIDE GIRT. PER AMM 25-66-01.SDR AALA202509031819Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EXTERIOR EMERGENCY LIGHT BY L2 DOOR IS INOPERATIVE. RELAMPED EXTERIOR EMERGENCY LIGHT BY L2 DOOR. PER AMM 33-51-04.SDR AALA202509146633Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BREAK ASSEMBLY PANEL LOCATED AT STA 538, LBL 10. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202509149227Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BREAK ASSEMBLY PANEL LOCATED AT STA 538, RBL R0. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202509128488Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D ENTRY DOOR DIFFICULT TO OPEN AND CLOSE. REMOVE AND REPLACED LAVATORY-D DOOR TRIM, PER CMM 25-40-64SDR AALA202509028488Door · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY-D ENTRY DOOR DIFFICULT TO OPEN AND CLOSE. (OPEN).SDR AALA202509026131Door · out of rigAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS THE MAIN CABIN DOOR WAS DIFFICULT FOR THE GATE AGENT TO OPEN. CONFIRMED CABIN MAIN DOOR WAS DIFFICULT TO OPEN. APPLIED CLAY TOALL DOOR STOPS, FOUND THE BOTTOM FORWARD AND AFT DOOR STOPS WERE NOT ADJUSTED CORRECTSDR AALA202509026462Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FRONT LAVATORY DOOR DIFFICULT TO OPEN. READJUSTED LAVATORY-A DOOR. PER CMM 25-40-61.SDR AALA202509023553Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT BATTERY INOPERATIVE. REMOVED AND REPLACED FORWARD FLIGHT ATTENDANT FLASHLIGHT BATTERY. PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA202509027493Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EXTERIOR EMERGENCY LIGHT LOCATED BEHIND THE RIGHT WING FLAP INOPERATIVE. RELAMPED EMERGENCY LIGHT BEHIND RIGHT HAND WING FLAP. PER AMM 33-51-04. OPERATIONAL CHECKS GOOD.
Back to Boeing 737-823