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 AALA201806189027Connector · shortedEMERGENCY LIGHTS AT ROW 18 ABC AND 21 ABC WERE INOPERATIVE. REPLACED THE BATTERY PACK AT ROW 21 ABC IAW MM 33-51-06. FOUND PIN 16 OF M1670 CONNECTOR PLUG D10716 SHORTED TO GROUND. REPLACED LIGHT ASSEMBLY. SYSTEM CHECKED NORMAL IAW AMM 33-51-00, AND SSM 33SDR AALA201806185005Web · corrodedCORROSION FOUND ON THE WEB RUNNING ALONG STRINGER 23L, BETWEEN BS 299 TO 335. REPLACED THE WEB IAW EA 281320, DRAWING 141A8131, AND 51-00-05.SDR AALA201806185004Floorbeam · corrodedCORROSION FOUND ON THE FLOORBEAM, BS 986.5, RBL 43. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-4.SDR AALA201806185002Floorbeam · corrodedCORROSION FOUND ON THE FLOORBEAM, BS 947.5, LBL 24.75. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-5.SDR AALA201806159023Processor · faultyAIRCRAFT WAS NOT GROUNDED. PHX FLT 2626 EN-ROUTE SNA-DFW. WHEN A FUEL IMBALANCE BETWEEN THE MAIN TANKS WAS NOTICED DURING CRUISE. THE FLIGHT CREW SUSPECTED A FUEL LEAK. THE FLIGHT DIVERTED TO PHX WITHOUT FURTHER INCIDENT. MAINTENANCE PLACED THE FLIGHT DECSDR AALA201806199001Window · arcedTHE SOUND OF ARCING COMING FROM THE UPPER MIDDLE PART OF THE CAPTAINS L1 WINDOW DURING ICING CONDITIONS. THE AIRCRAFT WAS GROUNDED. REPLACED CAPTAINS WINDSHIELD IAW SIC 56-94-03. OK FOR SERVICE.SDR AALA2018061859024Warning Light · malfunctionedWHEN THE LANDING GEAR SELECTED TO THE DOWN POSITION AND FLAPS SELECTED 15, RECEIVED A WARNING HORN AND ALL THREE GREEN AND ALL THREE RED LIGHTS. CYCLING THE GEAR HANDLE AND ACHIEVED ALL THREE GREEN ONLY, LANDED. THE AIRCRAFT WAS GROUNDED. ACCOMPLISHED FIMSDR AALA201806159020Flashlight Assy · inoperativeL1 JUMPSEAT AISLE POSITION EMERGENCY FLASHLIGHT INOPERATIVE. REPLACED THE FLASHLIGHT AND HOLDER ASSEMBLY IAW MM 25-64-00. OPS CHECKED GOOD.SDR AALA201806159005Window Shade · brokenTHE AIRCRAFT WAS NOT GROUNDED. COACH SEAT WINDOW SHADE/HANDLE EXIT WINDOW SHADE AT 15A IS TORN/BROKEN. REPLACED SEAT 15A WINDOW SHADE ASSEMBLY PER AMM 25-21-12. OPERATIONS CHECK GOOD.SDR AALA201806189003Window · delaminatedAIRCRAFT IN BASE MAINTENANCE. R1 WINDOW FOUND DELAMINATION TO BE OUT OF LIMITS. REMOVED AND REPLACED THE R1 WINDOW PER MCM 56-94-04.SDR AALA201806159009Spring · looseAIRCRAFT WAS NOT GROUNDED. GUST LOCK SPRING ON L1 DOOR IS BROKEN. FOUND SPRING TO HAVE COME LOOSE FROM THE KEEPER. RE-SECURED SPRING PER AMM 52-11-21. OPERATIONS NORMAL.SDR AALA201806149008Window · delaminatedAIRCRAFT WAS NOT GROUNDED. COCKPIT R1 WINDOW HAS DELAMINATION IN THE UPPER LEFT CORNER. REPLACED R1 WINDOW AS PER MCM CARD 56-94-64.SDR AALA201806149018Window Shade · damagedAIRCRAFT WAS NOT GROUNDED. BOTH AFT EMERGENCY EXIT DOOR WINDOW SHADES DAMAGED. REPLACED BOTH AFT EMERGENCY EXIT DOOR WINDOW SHADES PER AMM 25-21-12.SDR AALA201806149017Unknown · odorAIRCRAFT WAS GROUNDED. AT IDLE POWER BELOW 10,000 FEET ACID OIL SMELL IN COCKPIT. ACCOMPLISHED SIC 05-96-70 NO FINDINGS. RAN BOTH ENGINES AT 80% N-1 IN MULTIPLE CONFIGURATIONS PACKS ON, OFF, BLEEDS ON. OFF, NO ODOR OBSERVED FROM ENGINES OR PACKS. ODOR WAS FOUNSDR AALA201806149019Fitting · brokenONE OF THE FITTINGS THAT HOLDS THE GIRT BAR AT THE AFT SERVICE DOOR WAS BROKEN. REPLACED THE GIRT BAR FITTING IAW AMM 25-66-00, AND SIP.SDR AALA201806132002Web · corrodedAFT CARGO DOOR SILL WEB CORRODED BETWEEN BS 793 TO 847. REPAIRED THE THRESHOLD WEB IAW SRM 51-20-01.SDR AALA201806132001Support · corrodedFORWARD CARGO, AFT BULKHEAD BS 500I, FLOOR SUPPORT ANGLE CORRODED FROM STRINGER 24L TO STRINGER 24R. REPLACED THE FLOORBEAM ANGLE IAW 51-00-05, AND SRM 51-10-02-0G.SDR AALA201806143001Power Supply · inoperativeEMERGENCY AISLE LIGHTS AT ROWS 18ABC AND 20ABC INOPERATIVE. REPLACED THE POWER SUPPLY M1670 IAW AMM 33-51-06.SDR AALA2018061439016Sliding Window · detachedFIRST OFFICERS SLIDING WINDOW FELL OFF THE TRACK, AFTER PULLING THE OPEN HANDLE. INSTALLED THE FIRST OFFICERS SLIDING WINDOW IAW AMM 56-12-11. OPS CHECKED GOOD.SDR AALA201806131002Transition Panel · corrodedFORWARD CARGO AREA, LEFT TRANSISTION PANEL HAD CORROSION AND DAMAGE, BS 500E TO 500H. REPAIRED THE TRANSITION PANEL IAW SRM 53-00-53-2R-5.SDR AALA201806131005Transition Panel · corrodedCORROSION FOUND ON THE FORWARD CARGO BAY, RT TRANSITION PANEL BETWEEN BS 500B +10, AND 500G -10. REPAIRED THE TRANSITION PANEL IAW SRM 53-00-53-2R 5.SDR AALA201806131004Transition Panel · corrodedCORROSION FOUND ON THE FORWARD CARGO BAY RT TRANSITION PANEL BETWEEN BS 500B +8 AND 500G -10. REPAIRED THE TRANSITION PANEL IAW SRM 53-00-53-2R 5.SDR AALA201806129027Slide · faultyTHE AIRCRAFT WAS GROUNDED. FORWARD SERVICE DOOR GIRT BAR DOES NOT STAY IN BRACKETS WHEN DOOR IS DISARMED. REMOVED AND REPLACED R1 DOOR ESCAPE SLIDE PER AMM 25-61-00.SDR AALA20180610008Baffle · crackedCRACKED BAFFLE BETWEEN BS 500G TO 500F, STRINGER 25L. REPLACED THE BAFFLE IAW DRAWING 143A7505.SDR AALA201806119034Window Shade · damagedTHE AIRCRAFT WAS NOT GROUNDED. LEFT FORWARD EMERGENCY DOOR WINDOW SHADE DAMAGED. REMOVED AND REPLACED EMERGENCY LIGHT FORWARD EXIT DOOR WINDOW SHADE PER AMM 25-21-12. OPERATIONS CHECK OK.SDR AALA201806120007Transition Panel · corrodedCORROSION ON THE LEFT TRANSITION PANEL BETWEEN BS 500E TO 500I, STRINGER 25L. REPAIRED THE TRANSITION PANEL IAW SRM 53-00-53-2R-6.SDR AALA2018061208008Cable · unsecureAFTER TAKEOFF GEAR HANDLE WOULD ONLY MOVE TO OFF BUT NOT UP. RAN QRH PROCEDURE AND RETURNED TO DEPARTURE. AIRCRAFT WAS GROUNDED. SECURED LOWER END OF GROUND SPOILER BRAKE VALVE TELEFLEX CABLE IAW AMM 27-62-51. ACCOMPLISHED FUNCTIONAL TEST OF GROUND SPOILER SDR AALA201806119038Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS IN OVERHEAD BINS AT 10DEF (SEE AALA20180608007) AND 14DEF INOPERABLE. MAINTENANCE REPLACED BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180608007Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS IN OVERHEAD BINS AT 10DEF AND 14DEF (SEE AALA201806119038) INOPERABLE. MAINTENANCE REPLACED BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201806119048Girt Bar · brokenAIRCRAFT WAS NOT GROUNDED. UPON ARRIVAL FLIGHT ATTENDANT DISARMED R1 DOOR AND PLASTIC PIECE FELL OF END OF GIRT BAR. FOUND R1 DOOR GIRT BAR DOOR STOP ASSEMBLY BROKEN. INSTALLED NEW STOP ASSEMBLY PER AMM 25-66-01.SDR AALA201808607003Floorbeam · crackedCRACKED FLOORBEAM AT BS 540, BL 0 TO RBL 20. REPLACED THE FLOORBEAM IAW SRM 51-10-02-0G, PARAGRAPH 9.SDR AALA201806087002Floorbeam · crackedCRACKED FLOORBEAM AT BS 540, BL 0 TO LBL 20. REPLACED THE FLOORBEAM ANGLE IAW SRM 51-10-02-0G, PARAGRAPH 9.SDR AALA201806079020Flashlight · no testEMERGENCY FLASHLIGHT AT THE L1 DOOR JUMPSEAT WOULD NOT TEST. REMOVED AND REPLACED THE FLASHLIGHT IAW AMM 25-64-00-200-802.SDR AALA201806076006Skin · corrodedCORROSION FOUND ON THE LEFT WING LOWER SKIN, LWS 540 DRAG LINK, THE CORROSION WAS BUSTING THROUGH THE SEALANT ABOUT 2-3 INCHES AFT OF FRONT SPAR. REPAIRED THE LEFT WING LOWER SKIN IAW EA 280942.SDR AALA201806079027O-Ring · leakingAIR CON SYSTEM HAD LOW AIR FLOW ON THE GROUND AND IN FLIGHT. DURING CRUISE, THERE WAS A STRONG MOLDY SOCK ODOR FOR THE DURATION OF THE FLIGHT. FOUND A LEAK ON THE OIL COOLER LINES. REPLACED OIL COOLER LINE O-RINGS IAW AMM 49-91-41.SDR AALA201806085012Window Frame · crackedLEFT COCKPIT WINDOW FRAME CRACKED. REPAIRED THE WINDOW FRAME.SDR AALA201806085011Window Frame · crackedR1 COCKPIT WINDOW FRAME CRACKED. REPAIRED THE WINDOW FRAME.SDR AALA201806074004Angle · corrodedRIGHT TRANSITION PANEL ANGLE CORRODED IN THE AFT CARGO BAY, BETWEEN BS 767 & 787. REPLACED THE TRANSITION PANEL ANGLE IAW 51-00-05-1 AND DRAWING 146A0081.SDR AALA201806064009Rib · crackedRIGHT HORIZONTAL STABILIZER INSPAR RIB AT HSS 92.70, HAD TWO STIFFENERS CRACKED FORWARD OF EXISTING STIFFENER REPAIR. REPAIRED THE RIB IAW 51-00-05-1.SDR AALA201806064008Floor Support · corrodedCORROSION ON THE FLOOR SUPPORT AT BS 947. REPLACED THE FLOOR SUPPORT IAW SRM 51-10-02.SDR AALA201806064007Transition Panel · corrodedCORROSION ON THE RIGHT TRANSITION PANEL BETWEEN BS 887 TO 947. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R, AND SRM 51-10-2, PARAGRAPH G.SDR AALA201806064006Strap · corrodedCORROSION FOUND ON THE STRAP INBOARD OF AFT CARGO THRESHOLD PAN WEB, BS 804 RIGHT. REPLACED THE STRAP IAW SRM 51-10-2, PARAGRAPH G, AND EA 281158, DRAFT 1.SDR AALA201806054005Floor Support · corrodedFLOOR SUPPORT HAS CORROSION AT BS 887 ON THE RIGHT SIDE. . REPLACED THE FLOOR SUPPORT IAW SRM 51-10-2, PARAGRAPH G.SDR AALA201806054002Floor Support · corrodedCORROSION FOUND ON FLOOR SUPPORT, BS 292, RBL 11. INSTALLED A REPAIR DOUBLER IAW EA 280897, DRAFT 1.SDR AALA2018060769003Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M1673 FAILED A FUNCTIONAL CHECK. REPLACED THE BATTERY PACK IAW 33-51-06. OPS CHECKED GOOD.SDR AALA2018060769002Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M1671 FAILED A FUNCTIONAL CHECK. REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201806069001Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M1695 FAILED A FUNCTIONAL CHECK. REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201806063002Angle · corrodedCORROSION FOUND ON THE LEFT CREASE ANGLE BETWEEN BS 992 TO 951, LBL 51. REPLACED THE CREASE ANGLE IAW 51-00-05.SDR AALA2018060549040Battery Pack · inoperativeMEGAPHONE INOPERATIVE. REPLACED THE MEGAPHONE BATTERIES IAW AMM 25-64-00.SDR AALA201806049004Spring · brokenAIRCRAFT WAS NOT GROUNDED. L1 DOOR GUST LOCK LEVER SPRING BROKE -YELLOW LEVER. REINSTALLED PROPERLY GUST LOCK LEVER SPRING PER AMM 52-11-00.
Back to Boeing 737-823