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 AALA201903069003Smoke Detector · false activationLEFT AFT LAVATORY SMOKE LIGHT ILLUMINATED DURING DESCENT, NO SMOKE FOUND. MAINTENANCE REPLACED SMOKE DETECTOR IAW AMM 26-14-01, AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 26-14-00-730-80.SDR AALA201903065004Floor Support · corrodedCORROSION FOUND ON THE AFT GALLEY FLOOR SUPPORT, BS 947 - 967, LBL 25. REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02.SDR AALA201903065003Floorbeam · corrodedCORROSION FOUND ON THE AFT GALLEY FLOORBEAM, BS 947, RBL 49-53. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-1A-1, AND EA 290691.SDR AALA201903059001Smoke Detector · false activationPILOT REPORTED THE LEFT AFT LAVATORY SMOKE DETECTOR WAS ACTIVATING. UNABLE TO SEE OR SMELL ANY SMOKE. REMOVED AND REPLACED THE SMOKE DETECTOR IAW AMM 26-14-01. OPS CHECKED NORMAL.SDR AALA201903064008Support Angle · corrodedCORROSION FOUND ON THE AFT GALLEY WALL SUPPORT ANGLE AT BS 992, LBL 32. REPLACED THE SUPPORT ANGLE IAW RD 51-00-05.SDR AALA201903064007Support Angle · corrodedCORROSION FOUND ON THE AFT GALLEY WALL SUPPORT ANGLE, BS 993, LBL 33 - LBL 42. REPLACED THE SUPPORT ANGLE IAW RD 51-00-05.SDR AALA201903064006Support Angle · corrodedCORROSION FOUND ON THE AFT GALLLEY WALL SUPPORT ANGLE. BS 993, RBL 33 - RBL 45. REPLACED THE SUPPORT ANGLE IAW RD 51-00-05.SDR AALA201903064005Web · corrodedCORROSION ON THE AFT GALLEY FLOOR WEB BETWEEN BS 986 AND 992, RBL 31 - RBL 45. REPLACED THE WEB IAW SRM 51-10-2.SDR AALA201903064004Support Angle · corrodedCORROSION FOUND ON THE AFT GALLEY WALL SUPPORT ANGLE AT BS 1014, RBL 32. REPLACED SUPPORT ANGLE IAW RD 51-00-05-1.SDR AALA201903064003Angle · corrodedCORROSION ON THE RIGHT AFT FLOOR CREASE ANGLE BETWEEN BS 947 AND 993, RBL 44, AND RBL 58. REPLACED THE CREASE ANGLE IAW RD 51-00-05-1.SDR AALA201903064002Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT GALLEY FLOOR WEB BETWEEN BS 986 AND BS 993, BETWEEN LBL 30 AND LBL 43. REPLACED WEB IAW SRM 51-10-2.SDR AALA201903064001Angle · corrodedCORROSION ON THE LEFT AFT ENTRY FLOOR CREASE ANGLE BETWEEN BS 941 AND 990, BETWEEN LBL 45 AND LBL 57. REPLACED CREASE ANGLE IAW RD 51-00-05-01.SDR AALA201903059003Quick Disconnect · leakingSMOKE REPORTED FROM THE LEFT MAIN GEAR. HYDRAULIC LEAK ONTO BRAKES. SUSPECT SYSTEM B QUANTITY 86. REPLACED THE NR 2 BRAKE QUICK DISCONNECT COUPLING, BLED BRAKES AND OPS CHECKED IAW AMM 32-41-00, NO LEAKS NOTED.SDR AALA20190302004Cylinder · dischargedAIRCRAFT IN BASE MAINTENANCE: WHEN REMOVING THE RH AFT SLIDE DUE TO TIME WHEN DUE, THE NEW SLIDE ARRIVED NEW FROM STOCK WITH 0 PSI IN THE INFLATION CYLINDER. OPDERED A NEW SLIDE.SDR AALA201903064010Pressure Deck · crackedLEFT WHEEL WELL PRESSURE DECK WEB CRACKED AT BS 663.75 BETWEEN LBL 40 - LBL 45. REPAIRED PRESSURE DECK IAW SRM 57-10-10-2R-3.SDR AALA2019030549023Latch · lack of lubeFLIGHT CREW REPORTED THE GARBAGE COMPARTMENT DOOR IN THE FWD GALLEY OPENS ON LANDING AND DISARMS THE GIRT BAR ON THE FWD RT DOOR. LUBRICATED THE LATCHES ON TRASH CAN DOOR. LATCHES CHECK OK.SDR AALA201903041005Floor Support · crackedFORWARD WET AREA FLOOR SUPPORT CRACKED BETWEEN BS 328 AND 344, LBL 45. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05-1.SDR AALA201903041004Floor Support · crackedFORWARD WET AREA FLOOR SUPPORT CRACKED, BS 312 - 328, LBL 45. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05-1.SDR AALA201903041003Floor Support · crackedCABIN FLOOR SUPPORT AT BS 540 AT LBL 2. REPLACED FLOOR SUPPRT IAW RD 51-00-05-1, AND SRM 51-40-02.SDR AALA201903049019Slide · no testL1 DOOR SLIDE FAILED LATCH RELEASE TEST IAW AMM 25-66-01. PROPERLY REINSTALLED THE L1 SLIDE IAW WC 25-94-10. OPS CHECKED GOOD.SDR AALA2019030419001Unknown · unknownCABIN PRESSURIZATION WAS FLUCTUATING, WENT TO ZERO ON FINAL UNDER 500 FT ALTITUDE. MAINTENANCE ACCOMPLISHED BITE CHECK OF DCPC NR 1 AND 2. NO FAULTS NOTED IAW FIM 21-31-00.SDR AALA201903018003Floorbeam · corrodedCORROSION FOUND ON THE AFT GALLEY FLOORBEAM, BS 986.5, RBL 21 - RBL 45. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-4.SDR AALA201903018002Floorbeam · corrodedCORROSION FOUND ON THE AFT GALLEY FLOORBEAM, BS 986.5, LBL 28 - LBL 43. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-4.SDR AALA201902289019Stop Fitting · brokenL1 DOOR, FOURTH FROM THE TOP PRESSURE STOP FITTING BROKEN. THE AIRCRAFT WAS GROUNDED. REPLACED PRESSURE STOP FITTING PER AMM 52-11-01-400.SDR AALA201903068005Transition Panel · corrodedCORROSION ON THE AFT CARGO LEFT TRANSITION PANEL BETWEEN BS 727 AND 847. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R, AND SRM 51-10-02.SDR AALA2019030489011Compensator · failedPILOT REPORTED FUEL CROSSFEED VALVE APPEARS TO BE LEAKING AFTER BEING CLOSED. AFTER CENTER TANK FUEL WAS USED, RE-BALANCED LT AND RT TANKS. THEN RIGHT TANK FUEL QUANTITY DROPPED COMPARED TO LEFT TANK QUANTITY. FUEL WAS GOING BACK INTO CENTER TANK. FUEL WAS BASDR AALA2019030489009Computer · malfunctionedPILOT REPORTED THE TAKEOFF CONFIGURATION WARNING HORN GOING OFF WHEN POWER ADVANCED, FLAPS SET, TRIM SET, SPEED BRAKES STOWED. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REMOVED AND REPLACED THE STALL MANAGEMENT, YAW DAMPENER COMPUTER NR 1 IAW AMM 27-32-42-4SDR AALA201903018007Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO, RIGHT TRANSITION PANEL, BS 727 - 787. REPLACED THE TRANSITION PANEL IAW RD 51-00-05, AND SRM 53-00-53-1A.SDR AALA201902287001A/C Pack · overheatedCABIN ODOR REPORTED IN COCKPIT BY FLIGHT CREW. EMERGENCY DECLARED AND RETURNED TO DEPARTURE, LANDED WITHOUT FURTHER INCIDENT. THE AIRCRAFT WAS GROUNDED. MAINTENANCE ACCOMPLISHED CABIN ODOR, SMOKE WORK CARD IAW MCM 05-96-70, AND FOUND THE RIGHT A/C PACK OVSDR AALA201903064011Floorbeam · corrodedCORROSION FOUND ON THE AFT GALLEY FLOORBEAM ANGLE AT BS 950 BETWEEN LBL 26 - LBL 49. REPLACED THE THE FLOORBEAM ANGLE IAW RD 51-00-05-1.SDR AALA201902289014Probe · unreliablePILOT REPORTED THAT THERE WAS AN UNWANTED FUEL TRANSFER FROM THE RIGHT WING TANK TO CENTER TANK. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REMOVED AND REPLACED THE NR 9 FUEL PROBE IAW AMM 28-41-21-401. ALL OPS CHECKED GOOD.SDR AALA2019030127007Battery Pack · no testEMERGENCY LIGHT BATTERY PACK AT SEAT 7 DEF WAS INOPERATIVE. REPLACED THE BATTERY PACK, AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW MCM 2311.SDR AALA2019030189001Oil System · leakingA VOMIT ODOR IN THE CABIN. PERFORMED MCM 05-96-70 AND ON INSPECTION OF APU FOUND OIL LEAKING FROM APU TURBINE SCAVENGE LINE. APU HAS BEEN REPLACED IAW MCM 49-94-11. OPERATIONAL AND LEAK CHECK GOOD.SDR AALA201902287006Sign · detachedAFT CEILING EXIT LIGHT WAS FALLING OFF. THE AIRCRAFT WAS GROUNDED. REPLACED THE SIGN ASSEMBLY AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-01.SDR AALA201902286004Floor Support · crackedCRACKED FORWARD CABIN FLOOR SUPPORT BETWEEN BS 312 AND 328, LBL 45.6. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05-01.SDR AALA201902286003Floor Support · crackedCRACKED FORWARD CABIN FLOOR SUPPORT BETWEEN BS 328 AND 344 AT LBL 45.60. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05-01.SDR AALA2019030189004Flashlight · not seatedTHE FIRST CLASS FLIGHT ATTENDANTS FLASHLIGHT INBOARD WONT TEST. RESEAT FLASHLIGHT AND REPLACED TAMPER SEAL IAW AMM 25-64-00. OPERATIONAL CHECKS NORMAL.SDR AALA2019030189003Flashlight · not seatedMAINTENANCE REPORTED THE RIGHT AFT FLIGHT ATTENDANTS FLASHLIGHT WOULD NOT TEST. RESEATED FLASHLIGHT AND REPLACED THE TAMPER SEAL IAW AMM 25-64-00. OPS CHECKED NORMAL.SDR AALA201902289005Cradle · damagedFIRST CLASS FLIGHT ATTENDANT'S FLASHLIGHT WOULD NOT TEST. MAINTENANCE REPLACED THE FLASHLIGHT BRACKET IAW AMM 25-64-00.SDR AALA2019030169006Fire Warning · illuminatedAFT CARGO FIRE INDICATION, AFT HALON DEPLOYED. REMOVED AND REPLACED CARGO FIRE EXTINGUISHER BOTTLE IAW AMM 26-23-01.SDR AALA2019022869001Smoke Detector · false activationFLIGHT CREW REPORTED THE LEFT AFT LAVATORY SMOKE DETECTOR WARNING ILLUMINATED IN THE COCKPIT WITH NO SMOKE OR FIRE INDICATION IN THE LAVATORY. THE WARNING EXTINGUISHED ON ITS OWN. ACCOMPLISHED A LEFT AFT LAVATORY SMOKE DETECTOR TESTED IAW AMM 26-14-00. TESTESDR AALA201902284006Seal · damagedPILOT REPORTS THAT THERE WAS A LOUD SQUEAL COMING FROM THE L1 DOOR ON CLIMB OUT. FOUND THE DOOR SEAL WAS DAMAGED. REPAIRED IAW RD 52-00-00-2, REPAIR 2. PRESSURIZED AIRCRAFT WITH NO LEAKS NOTED.SDR AALA201902284005Connector · corrodedFLIGHT CREW REPORTED THAT THE AFT CARGO FIRE WARNING INDICATION ILLUMINATED. THE AFT CARGO FIRE BOTTLES WERE DEPLOYED. THE AIRCRAFT DECLAIRED AN EMERGENCY AND LANDED WITHOUT INCIDENT. NO EVIDENCE OF A FIRE WAS FOUND. THE AIRCRAFT WAS GROUNDED. DURING TROUBLESDR AALA201902259020Window · crackedSMALL CRACK IN FIRST OFFICERS #1 WINDOW. THE AIRCRAFT WAS GROUNDED. REPLACED WINDOW PER TASK CARD 56-94-04.SDR AALA201902262003Web · damagedAFT GALLEY FLOOR WEB BULGED, WRINKLED AND MIS-SHAPENED, JUST FORWARD OF THE AFT PRESSURE BULKHEAD AT RBL 33. REPLACED WEB IAW RD 51-00-05-1.SDR AALA201902262002Web · damagedAFT GALLEY FLOOR WEB BULGED, WRINKLED AND MIS-SHAPENED, JUST FORWARD OF THE AFT PRESSURE BULKHEAD AT LBL 34. REPLACED THE WEB IAW RD 51-00-05-1.SDR AALA201903018006Floorbeam · corrodedCORROSION FOUND ON THE AFT GALLEY FLOORBEAM, BS 947, BL 0 - LBL 51. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-5, AND EA 290501.SDR AALA201902262005Floorbeam · corrodedCORROSION FOUND ON THE FORWARD CARGO FLOORBEAM, BS 500I, BETWEEN STRINGERS 25L AND 25R. REPLACED THE FLOORBEAM IAW SRM 51-10-2.SDR AALA201902259018Antenna · faultyDURING DESCENT WITH THRUST LEVERS AT IDLE, THREE RED GEAR WARNING INDICATORS WERE OBSERVED AND WARNING HORN WAS MOMENTARILY HEARD TWICE THEN WENT AWAY. THE GEAR LEVER WAS IN THE UP POSITION. THE AIRCRAFT WAS GROUNDED. DOWNLOADED THE FDR AND FOUND THAT BOTH RSDR AALA201902259017Antenna · faultyDURING DESCENT WITH THRUST LEVERS AT IDLE, THREE RED GEAR WARNING INDICATORS WERE OBSERVED AND WARNING HORN WAS MOMENTARILY HEARD TWICE THEN WENT AWAY. THE GEAR LEVER WAS IN THE UP POSITION. THE AIRCRAFT WAS GROUNDED. DOWNLOADED THE FDR AND FOUND THAT BOTH R
Back to Boeing 737-823