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 AALA202601145321Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD CARGO COMPARTMENT CARGO MOUNT TIE DOWN TRACK AT BS 500I, RBL 14. REPAIRED TRACK FLANGE PER EA 369584.SDR AALA202601148116Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD CARGO BAY TRANSITION PANEL LOCATED FROM BS 500A TO 500I AND LBL 24. REPLACED TRANSITION PANEL IAW AARD 51-00-05-1.SDR AALA202601130172Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 400 TO BS 500A AT LBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202511031833Baffle · deformedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT BAFFLE BETWEEN STA 500C AND STA 500D AT LBL 24 UPPER ANGLE DEFORMED. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202510301841Flashlight Assy · brokenAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT JUMPSEAT 2L FLASHLIGHT HOLDER BROKEN. REMOVED AND REPLACED FLASHLIGHT HOLDER. ALL CHECKS NORMAL. PER AMM 25-64-00.SDR AALA202510293409Sign · dislodgedAIRCRAFT IN BASE MAINTENANCE: FORWARD GALLEY R1 DOOR EMERGENCY LIGHT "EXIT" LENS WIIL NOT STAY AT LIGHT ASSEMBLY. REMOVED AND REPLACED R1 DOOR EMERGENCY LIGHT"EXIT" ASSEMBLY. PER B737NG AMM 33-51-01. PERFORMED SATISFACTORY OPERATIONAL CHECK, PER B737NG AMM 33-SDR AALA202510284059Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE, LOCATED IN LEFT ECS BAY, AT STA 663, LBL 20. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202510241841Cradle · brokenAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT JUMPSEAT 2L FLASHLIGHT HOLDER BROKEN. (OPEN).SDR AALA202510247220Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT AT 16D DETACHED FROM CABIN WALL. RESECURED EXIT, LIGHT OPERATIONAL CHECKS GOOD.SDR AALA202510246084Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT HANGING AT ROW 17. RESECURED EMERGENCY LIGHT AT ROW 17. PER AMM 33-51-01. OPERATIONAL CHECK NORMAL.SDR AALA202510246104Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT UNDER SEAT 26C IS LOOSE AND DETACHED. RESECURED FLOOR EMERGENCY PROXIMITY LIGHT AT SEAT 26C. PER AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA202510247493Pin · dislodgedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT FOUND A LONG PIN WITH A LANYARD BELOW THE AFT LEFT ENTRY DOOR. REMOVED L2 DOOR SLIDE, SECURED PIN IN POCKET POUCH AND REINSTALLED. PER AMM 25-66-01.SDR AALA202510244630Light · no testAIRCRAFT IN BASE MAINTENANCE: CEILING MOUNTED EMERGENCY LIGHT AT 21ABC IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY AISLE LIGHT. PER AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA202510245407Sensor · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF AND RETRACTION OF LANDING GEAR, RECEIVED A TAKE OFF CONFIGURATION WARNING, ALSO RECEIVEDMASTER CAUTION FOR PSEU. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT TUL. PERFORMED BITE TESDR AALA202601152253Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD TEE FITTING AT BS 967, LBL 48. REPAIRED UPPER TEE FITTING PER EA 369387.SDR AALA202601159331Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 947, LBL 48. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202601153081Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SIDEWALL SUPPORT ANGLE AT BS 500D, LBL 25. REPLACED SUPPORT ANGLE PER AARD 51-00-05-1.SDR AALA202601140077Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SIDEWALL SUPPORT ANGLE AT BS 500D, RBL 25. REPLACED SUPPORT ANGLE PER 51-00-05-1.SDR AALA202601148200Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT BS 907 PLUS 5 INCHES, AT RBL 23. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA202601140239Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL FROM BS 967 TO BS 986 AT LBL 16. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202601143082Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL FROM BS 947 TO BS 967 AT LBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-1SDR AALA202601139319Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLE ON FRAME BRACKET AT BS 500D FROM S21R TO S22R. REPAIRED BRACKET PER EA 369468.SDR AALA202511074018Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: RIGHT AFT AUTOMATIC OVERWING EXIT DOOR AFT UPPER DOOR STOP PAD IS OUT OF POSITION. REMOVED AND REPLACED STOP PAD PLATE AT RIGHT AFT AUTOMATIC OVER-WING EXIT DOOR. PER B737NG AMM 52-01-000-801 AND AMM 52-22-01-400-801.SDR AALA202511079996Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: LEFT AFT AUTOMATIC OVERWING EXIT DOOR AFT UPPER DOOR STOP PAD IS OUT OF POSITION. REMOVED AND REPLACED STOP PAD PLATE AT LEFT AFT AUTOMATIC OVER-WING EXIT DOOR. PER B737NG AMM 52-01-000-801 AND AMM 52-22-01-400-801.SDR AALA202510242798Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER IN RIGHT HAND ECS BAY AT STA 663.75, RBL 45.64. REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R-2 AND AARD 57-10-10-9.SDR AALA202510242409Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER IN RIGHT HAND ECS BAY AT STA 663.75, RBL 31.83. REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R-2 AND AARD 57-10-10-9.SDR AALA202510238688Controller · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB OUT BETWEEN 9000 AND 10,000 FEET WE GOT CABIN ALTITUDE WARNING LIGHT, PRESSURE WAS SHOWING 1000 AND THEN SHOT UP TO 8500 WITH CABIN ALTITUDE CLIMB RATE OF 4000. AIRCRAFT AIR INTERRUPTED BACKSDR AALA202510237179Sign · unsecureAIRCRAFT WAS NOT GROUNDED: ROW 17 AFT FACING EMERGENCY EXIT SIGN FELL OFF. RESECURED EXIT SIGN. PER AMM 33-51-01.SDR AALA202510234729Door · stuckAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR IS LOCKED SHUT AND DOES NOT RESPOND TO INPUT CODE. MANUALLY OPENED FLIGHT DECK DOOR. PER MM 52-51-00. OPERATIONAL CHECKS NORMAL.SDR AALA202510238671Controller · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB OUT BETWEEN 9000 AND 10,000 FEET WE GOT CABIN ALTITUDE WARNING LIGHT, PRESSURE WAS SHOWING 1000 AND THEN SHOT UP TO 8500 WITH CABIN ALTITUDE CLIMB RATE OF 4000. AIRCRAFT AIR INTERRUPTED BACKSDR AALA202510230177Skin · wornAIRCRAFT IN BASE MAINTENANCE: WEAR TO UPPER FUSELAGE SKIN FROM BS 1134 TO BS 1156, BETWEEN S3R AND S5R. REPAIRED SKIN PER EA 368617.SDR AALA202601144395Structure · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO APU INLET LOWER CHORD LOCATED FROM BS 1148 TO BS 1156 AT LBL 25. REPAIRED CHORD PER EA 369247.SDR AALA202601144407Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO AFT CARGO COMPARTMENT DOOR OPENING WEB AT BS 830, RBL 24. REPLACED WEB PER AARD 51-00-05-01.SDR AALA202510319299Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT ZEE ASSEMBLY FROM STA 727G TO STA 767 AT S25R. REPLACED ZEE ASSEMBLY PER AARD 51-00-05-01.SDR AALA202510305674Compensator · faultedAIRCRAFT WAS NOT GROUNDED: LEFT MAIN FUEL TANK QUANTITY INDICATION ERRATIC. FUEL QUANTITY SHOWS INCREASING AND DECREASING CONSTANTLY WHEN CROSS-FEEDING AND LEFT MAIN TANK FUEL PUMPS TURNED OFF. CONFIRMED LEFT FLIGHT DECK FUEL TANK INDUCTION INOPERATIVE. REMOVSDR AALA202510304928Wire Harness · faultyAIRCRAFT WAS NOT GROUNDED: LEFT MAIN FUEL TANK QUANTITY INDICATION ERRATIC. FUEL QUANTITY SHOWS INCREASING AND DECREASING CONSTANTLY WHEN CROSS-FEEDING AND LEFT MAIN TANK FUEL PUMPS TURNED OFF. CONFIRMED LEFT FLIGHT DECK FUEL TANK INDUCTION INOPERATIVE. **SUPPSDR AALA202510222821Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AFT LEFT HAND AISLE JUMPSEAT EMERGENCY FLASHLIGHT IS FLASHING RED. REMOVED AND REPLACED AFT GALLEY INBOARD JUMPSEAT FLASHLIGHT (AALA202510224521) AND BATTERY (AALA202510222821). OPERATIONAL CHECK GOOD.SDR AALA202510224928Indication Sys · malfunctionedAIRCRAFT WAS NOT GROUNDED: LEFT MAIN FUEL TANK QUANTITY INDICATION ERRATIC. FUEL QUANTITY SHOWS INCREASING AND DECREASING CONSTANTLY WHEN CROSS-FEEDING AND LEFT MAIN TANK FUEL PUMPS TURNED OFF. CONFIRMED LEFT FLIGHT DECK FUEL TANK INDUCTION INOPERATIVE. (OPENSDR AALA202510223955Hook · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT ENTRY DOOR GIRT BAR DIFFICULT TO DISARM. LUBED AFT ENTRY DOOR GIRT BAR HOOK. PER AMM 25-66-00. OPERATIONAL CHECK GOOD AT THIS TIME.SDR AALA202510228853Girt Bar · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT THAT THE BRACKET FOR THE SLIDE GIRT BAR AT DOOR 1R IS TOO TIGHT; VERY DIFFICULT TO ARM THE SLIDE. REMOVED AND REPLACED R1 ESCAPE SLIDE COVER. PER AMM 25-66-01-400-803.SDR AALA202510224734Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FORWARD FLIGHT ATTENDANT STATION INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT ASSEMBLY UNDER FORWARD FLIGHT ATTENDANT SEAT PER STANDARD MAINT PRACTICES. OPERATIONAL CHECKS GOOD.SDR AALA202510224521Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AFT LEFT HAND AISLE JUMPSEAT EMERGENCY FLASHLIGHT IS FLASHING RED. REMOVED AND REPLACED AFT GALLEY INBOARD JUMPSEAT FLASHLIGHT (AALA202510224521) AND BATTERY (AALA202510222821). OPERATIONAL CHECK GOOD.SDR AALA202510224057Hook · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT SERVICE DOOR GIRT BAR DIFFICULT TO DISARM. LUBED AFT SERVICE DOOR GIRT BAR HOOK. PER AMM 25-66-00. OPERATIONAL CHECK GOOD AT THIS TIME.SDR AALA202601142899Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER TEE AT STA 328, RBL 46. REPAIRED UPPER TEE PER SRM 53-10-51-2R-8 ALTERNATVIE 3 AND EA 369583.SDR AALA202510318875Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 324, RBL 31. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202510302775Processor · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CRUISE, SUSPECTED FUEL LEAK ON ENGINE NUMBER 1. VERIFIED LEFT MAIN FUEL QUANTITY INOPERATIVE. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT ELP. REMOVE AND REPLACED FUEL QUANITY PROCESSOR, PER AMM 28SDR AALA202510232273Transmission · damagedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING APPROACH FLAP INDICATION WERE SPLIT CONDUCTED A GO AROUND. AIRCRAFT EMERGENCY LANDED SAFELY AT DFW. **SUPPLEMENTAL REPORT FOR (AALA202510210129): FOUND RIGHT WING OUTBOARD TORQUE TUBE SPRT INBOARDSDR AALA202510230129Torque Tube · damagedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING APPROACH FLAP INDICATION WERE SPLIT CONDUCTED A GO AROUND. AIRCRAFT EMERGENCY LANDED SAFELY AT DFW. **SUPPLEMENTAL REPORT FOR (AALA202510210129): FOUND RIGHT WING OUTBOARD TORQUE TUBE SPRT INBOARDSDR AALA202510230424Door · bindingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTS LAVATORY-D DOOR IS HARD TO OPEN. **SUPPLEMENTAL REPORT FOR (AALA202510210424): REMOVED AND REPLACED LAVATORY-D DOOR. PER CMM 25-40-64. OPERATIONAL CHECK GOOD**(CLOSED).SDR AALA202510212775Fuel Sys · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CRUISE, SUSPECTED FUEL LEAK ON ENGINE NUMBER 1. VERIFIED LEFT MAIN FUEL QUANTITY INOPERATIVE. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT ELP. (OPEN).
Back to Boeing 737-823