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 AALA201910109013Bulkhead Web · crackedAIRCRAFT WAS NOT GROUNDED: RIGHT HAND WHEEL WELL CENTER WING BULKHEAD VAPOR BARRIER CRACKED IN 2 LOCATION, AT BS 663 AT RBL 47 AND RBL 50. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9 AND SRM 57-10-10-R-4.SDR AALA201910269011Intercostal · corrodedAIRCRAFT IN BASE VISIT: CORRSION FOUND ON INTERCOSTAL AT RBL 31 AT STA 986. INSTALLED NEW INTERCOSTAL IAW SRM 53-70-51-2R-4 AND SRM 51-40-02.SDR AALA201910109001Flashlight · inoperativeAIRCRAFT WAS NOT GROUDNED: L2 JUMP SEAT FLASHLIGHT WAS INOPERABLE. MAINTENANCE REPLACED FLASHLIGHT PER AMM 25-64-00.SDR AALA201910089006Unknown · fireAIRCRAFT WAS GROUNDED: AFTER A NORMAL ENGINE START AND WHILE SITTING AT IDLE RAMP PERSONNEL AND AIRCRAFT BEHIND US REPORTED MULTIPLE FLAMES SHOOTING OUT OF TAIL PIPE. NO UNUSUAL INDICATIONS IN COCKPIT. CHECKED NR 1 ENGINE IAW FIM 71-05-00-810-811-F00 AND AMM SDR AALA2019100989005Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: L2 JUMP SEAT FLASHLIGHT INOPERABLE. MAINTENANCE REPLACED FLASHLIGHT PER AMM 25-64-00.SDR AALA2019102219013Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727 AND BS 767 AT S26R. REPLACED TRANSITION PANEL SRM 53-00-53-2R.SDR AALA201910179012Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT ANGLE AT BS 807 AT S26R AND RBL 15. REPLACED FLOOR SUPPORT ANGLE PER 51-00-05-1.SDR AALA201910159060Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION SHIELD AT BS 774 AND S25R. REPLACED SHIELD PER 51-00-05-1.SDR AALA201910159058Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION SHIELD BETWEEN BS 847 AND BS 867 AT RBL 24. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA2019100979021Controller · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS ON TAKE OFF GOT MASTER CAUTION AIR CONDITIONING AND PACK LIGHT, REJECTED TAKE OFF AT 40 KNOTS DUE TO RIGHT PACK LIGHT. MAINTENANCE ACCOMPLISHED FIM 21-62-00-810-801 ON BOTH CONTROLLERS. REMOVED AND REPLACED R/H PACK CONTROLSDR AALA2019100979030Cabin Pressure · unknownAIRCRAFT WAS GROUNDED: FLIGHT AIR RETURNED TO IAH ON ACCOUNT OF PRESSURIZATION ISSUE. EMERGENCY WAS DECLARED. MAINTENANCE ACCOMPLISHED OPERATIONAL TEST AND LEAK TEST OF THE PRESSURIZATION SYSTEM IAW AMM 05-51-91, OPS AND LEAK TEST GOOD. ACCOMPLISHED OPS TEST OSDR AALA201910259023Web · corrodedAIRCRAFT IN BASE VISIT: K WEB HAS CORROSION AT FR989, LBL31-LBL34.SDR AALA201910259024Web · corrodedAIRCRAFT IN BASE VISIT: CORROSION ON K WEB AT FR986, RBL44. REMOVED AND REPLACED K WEB IAW SRM 51-40-05 AND EA299569.SDR AALA201910259027Angle · corrodedAIRCRAFT IN BASE VISIT: CORROSION ON LH AFT ENTRY CREASE ANGLE AT STA 970L, LBL64. REMOVED AND REPLACED LH AFT ENTRY CREASE ANGLE IAW SRM 51-40-02.SDR AALA2019102219032Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR INTERCOSTAL BETWEEN BS 947 AND BS 967 AT RBL 52. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2019100979020Sensor · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS FUEL IMBALANCE IN BOTH WING TANK INDICATIONS BEGAN DECREASING IMMEDIATELY AFTER T/O. LEFT WING REDUCED TO 8.59 RIGHT TO 8.12 FAIRLY RAPIDLY THEN AT A SLOWER RATE. FUEL LOG CONSISTENTLY AND INCREASINGLY BELOW PLAN. FUEL FLSDR AALA201910099019Compensator · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS FUEL IMBALANCE IN BOTH WING TANK INDICATIONS BEGAN DECREASING IMMEDIATELY AFTER T/O. LEFT WING REDUCED TO 8.59 RIGHT TO 8.12 FAIRLY RAPIDLY THEN AT A SLOWER RATE. FUEL LOG CONSISTENTLY AND INCREASINGLY BELOW PLAN. FUEL FLSDR AALA201910099020Sensor · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS FUEL IMBALANCE IN BOTH WING TANK INDICATIONS BEGAN DECREASING IMMEDIATELY AFTER T/O. LEFT WING REDUCED TO 8.59 RIGHT TO 8.12 FAIRLY RAPIDLY THEN AT A SLOWER RATE. FUEL LOG CONSISTENTLY AND INCREASINGLY BELOW PLAN. FUEL FLSDR AALA201910099021Compensator · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS FUEL IMBALANCE IN BOTH WING TANK INDICATIONS BEGAN DECREASING IMMEDIATELY AFTER T/O. LEFT WING REDUCED TO 8.59 RIGHT TO 8.12 FAIRLY RAPIDLY THEN AT A SLOWER RATE. FUEL LOG CONSISTENTLY AND INCREASINGLY BELOW PLAN. FUEL FLSDR AALA201910099018Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM UPPER FLANGE AT BS 947 AND LBL 4. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-5.SDR AALA201910099017Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM UPPER FLANGE AT BS 986 AND RBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-4.SDR AALA201910099016Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD WET AREA GIRT BAR TIE DOWN FITTING AT BS 312 AND LBL 54. REPLACED FITTING PER AARD 51-00-05-1.SDR AALA201910089017Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA "Z" ANGLE AT BS 1014 AND RBL 32. REPLACED ANGLE IAW SRM 51-10-02.SDR AALA201910089016Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA "Z" ANGLE AT BS 1014 AND LBL 32. REPLACED ANGLE PER SRM 51-10-02.SDR AALA2019102219016Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL SHIELD AT BS 500A AND S25R. REPLACED SHIELD PER SRM 51-10-02 AND EA 299522.SDR AALA2019102219015Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500A AND BS 500I AT RBL 25. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R AND 53-30-53-01-2.SDR AALA2019102219014Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 493 AND BS 500I AT S25L. REPLACED TRANSITION PANEL PER SRM 53-30-53-01-2 AND 53-00-53-2R.SDR AALA201910179013Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO DOOR CUT OUT THRESHOLD WEB BETWEEN BS 440 AND BS 492 AT S25R. REPLACED WEB PER SRM 51-40-02.SDR AALA201910159069Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 420 AND BS 440 AT S25R. REPLACED TRANSITION PANEL PER SRM 51-10-02.SDR AALA201910159068Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 420 AND S25L. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA2019100879032Warning Message · false activationAIRCRAFT WAS GROUNDED: FLIGHT RETURNED TO DFW ON ACCOUNT OF ENGINE OVERHEAT INDICATION. EMERGENCY WAS DECLARED. MAINTENANCE ACCOMPLISHED FIM 26-10-00-810-811. NO FAULTS FOUND. RAN ENGINE TO TAKE-OFF POWER. NO FAULTS. ACCOMPLISHED ENG/APU FIRE DETECTION CONTRSDR AALA2019100879029Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY SMOKE DETECTOR CAME ON, THEN WENT OUT. NO SMOKE OR PERSON IN LAVATORY. MAINTENANCE ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER MM 26-15-00. NO FAULTS FOUND.SDR AALA201910089025Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500 AND S25L. REPLACED CLIP PER SRM 53-00-01-6.SDR AALA201910089024Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500G AND S25R. REPLACED CLIP PER SRM 53-00-01-6.SDR AALA201910089023Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500G AND S25L. REPLACED CLIP PER SRM 53-00-01-6.SDR AALA201910089022Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 420 AND S25L. REPLACED CLIP PER SRM 53-00-01-6.SDR AALA201910079022Coupling · looseAIRCRAFT WAS GROUNDED: PILOT REPORTS SMOKE REPORTED FROM RIGHT TIRE AREA. HYD SYSTEM B FLUID INDICATION, SUSPECT HYDRAULIC LEAK. EMERGENCY WAS DECLARED. MAINTENANCE FOUND NR 4 BRAKE HYDRAULIC COUPLING / LINE LOOSE. REPLACED COUPLING IAW AMM 32-41-11. OPS CHECKSDR AALA201910049019Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE: BATTERY FAILED CAPACITY CHECK FOR LIGHTS ASSOCIATED WITH SEAT 13DEF. REPLACED BATTERY PACK AMM 33-51-06-960-806.SDR AALA2019100879049Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727 AND BS 767 AT RBL 24. REPLACED TRANSITIONN PANEL PER SRM 53-00-53-2R-5.SDR AALA201910049006Tcas System · malfunctionedAIRCRAFT WAS GROUNDED: PILOT REPORTS DURING CLIMB OUT TCAS FAIL ON ND. STARTED WORKING JUST PRIOR TO DESCENT. OPS NORMAL. MAINTENANCE TROUBLESHOT SYSTEM, PERFORMED TEST, COULDNT DUPLICATE DISCREPANCY. NO FAULTS NOTED AT THIS TIME IAW FIM 34-45-00. OK FOR SERVSDR AALA201910049009Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE: BATTERY PACK FAILED CAPACITY CHECK FOR EMERGENCY LIGHTS ASSOCIATED WITH UPPER RIGHT AFT CEILING PANEL. REPLACED BATTERY PACK AMM 33-51-06-960-806.SDR AALA201910049007Spoiler · out of adjustAIRCRAFT IN BASE VISIT: PILOT REPORTS AIRCRAFT ROLLS RIGHT WHEN DEPLOYING SPEEDBRAKE AT VMO - SPEEDBRAKES DEPLOYED TO FLIGHT DETENT - YOKE DISPLACED 1.0 UNITS LEFT WING DOWN. MAINTENANCE ADJUSTED FLIGHT SPOILERS #2 AND #3 AND SAFTIED IAW AMM 27-61-00-730-801.SDR AALA201910039011Connector · unsecureAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHT AT CEILING PANEL LT SEAT ROW 18 REQUIRES FURTHER TROUBLESHOOTING. FOUND CONNECTOR D14816 LOOSE IAW WDM 33-51-14 SECURED CONNECTOR. SYSTEM NORMAL IAW AMM 33-51-00.SDR AALA201910039010Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS LH CEILING PANEL EMERGENCY LIGHTS AT SEAT ROW 18, 19, 21 DO NOT ILLUMINATE. FOUND EMERGENCY POWER SUPPLY TO BE DEFECTIVE AT M1670, REMOVED AND REPLACED POWER SUPPLY. OPERATIONAL CHECK LT CEILING PANEL EMERGENCY LIGHTSSDR AALA2019100759029Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR "Z" ANGLE BETWEEN BS 992 AND BS 1006 AT RBL 32. REPLACED ANGLE PER SRM 51-40-02.SDR AALA2019100759025Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA PRESSURE DECK ANGLE AT BS 992 BETWEEN LBL 27 AND LBL 45. REPLACED ANGLE PER SRM 51-40-02.SDR AALA2019100329013Computer · inoperativeAIRCRAFT NOT GROUNDED: PILOT REPORTS ON TAKEOFF AFTER TOGA PUSHED, NO FLIGHT DIRECTOR DISPLAYED CAPTAIN OR FO. REAPPEARED AFTER HEADING AND VNAV SELECTED. MAINTENANCE REPLACED FCC B IAW AMM 22-11-33, ALL TESTS PASSED.SDR AALA201910029011Seal · deformedAIRCRAFT WAS GROUNDED: UPON BLOCKING IN GATE AGENT REPORTED THE ENTRY DOOR WAS MORE DIFFICULT TO OPEN, HAD MORE OF A VACUUM SEAL AS IF CABIN WAS NOT DEPRESSURIZED. COULD NOT DUPLICATE FAULT, HOWEVER, REPAIRED DOOR SEAL IAW AMM 52-09-10-350-801. ALL OPS CHECK,SDR AALA2019100759023Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500C AND LBL 24. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA2019100219021Light · burnedAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS BURNING SMELL AROUND LAST 2 ROWS OF COACH, LIKE RUBBER SMELL. MAINTENANCE ACCOMPLISHED CARD 05-96-70. FOUND LAV D SINK/COUNTER TOP LEDS BURNT, FULL OF SOAP. REPLACED HARNESS ASSY IAW ESO 60914. ALL CHECKS GOOD.
Back to Boeing 737-823