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 AALA20180112006Floorbeam · corrodedCORROSION ON TOP OF CABIN FLOORBEAM AT BS 947, BEYOND MANUAL LIMITS. CUT OFF UPPER TEE, INSTALLED A NEW UPPER TEE IAW SRM 53-70-51-2R-5.SDR AALA20180112002Transition Panel · corrodedCORROSION ON RIGHT TRANSITION PANEL, BS 767+4. INSTALLED A NEW TRANSITION PANEL IAW AMM 51-00-05.SDR AALA201801199002Lens · brokenEMERGENCY LIGHT LENS BROKEN AT FORWARD SERVICE DOOR. REPLACED THE LENS IAW AMM 33-51-14.SDR AALA201801199001Lens · missingEXIT SIGN LENS AT FORWARD GALLEY AISLE IS MISSING. REPLACED THE LIGHT ASSEMBLY IN FORWARD AISLE IAW MM 33-51-01.SDR AALA20180112010Transition Panel · corrodedCORROSION FOUND ON THE RIGHT TRANSITION PANEL. INSTALLED A NEW SECTION OF THE TRANSITION PANEL IAW SRM 53-00-53-2R-5.SDR AALA20180114001Sign · brokenAIRCRAFT WAS NOT GROUNDED: FORWARD RIGHT DOOR, EXIT SIGN FELL OFF LOWER LIGHT SIGN. MAINTENANCE REPLACED EXIT SIGN LIGHT ASSEMBLY PER AMM 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180112013Angle · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON RIGHT TRANSITION PANEL ANGLE BETWEEN BS 727N PLUS 10 INCHES TO BS 767. REPLACED THETRANSITION PANEL ANGLE IAW 51-00-05-1A, SRM 53-00-53-2R-5, AND DRAWING 146A7502.SDR AALA20180112005Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF THE FLOORBEAM UPPER TEE AT BS 947, LBL 16. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-5, AND DRAWING CTY2588.SDR AALA20180112003Transition Panel · corrodedCORROSION ON THE RIGHT TRANSITION PANEL IN THE AFT CARGO BAY BETWEEN BS 727 TO 767. REPLACED THE TRANSITION PANEL IAW 51-00-05-1.SDR AALA20180112001Floor Support · corrodedCORROISION ON THE FLOOR SUPPORT BETWEEN BS 947 TO 967 AT LBL 24.75. INSTALLED A NEW FLOOR SUPPORT IAW 51-00-05-1, AND DRAWING 815A0010.SDR AALA20180112009Transition Panel · corrodedCORROSION ON LEFT TRANSITION PANEL. MAINTENANCE SPLICE REPAIRED THE TRANSITION PANEL IAW SRM 53-00-53-2R-5.SDR AALA20180112012Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. BATTERY PACK M1674 FAILED CAPACITANCE CHECK CARD 2908. REPLACED M1674 PER MM 33-51-06.SDR AALA20180112011Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. BATTERY PACK M1670 FAILS CAPACITANCE CHECK CARD 2908. REPLACED M1670 PER MM 33-51-06.SDR AALA201801189003Battery · dischargedL1 DOOR INBD JUMP SEAT EMERGENCY FLASHLIGHT LOW ON POWER. R & R THE BATTERY IAW AMM 25-64-00.SDR AALA201801189002Transmitter · odorPWS FAIL LIGHT ILLUMINATED AFTER TAKE OFF, FOLLOWED BY A BURNING CANDLEWICK ODOR DETECTED BY FA IN CABIN. WEATHER RADAR SWITCH ON CAPTAIN`S SIDE TURNED OFF. ON INSPECTION, FOUND THE WEATHER RADAR R/T CIRCUIT BREAKER TRIPPED. BURNING ODOR ALSO ABATED TROUGHOSDR AALA20180111010Floor Support · crackedA CRACK FOUND ON FORWARD ENTRY FLOOR SUPPORT BETWEEN BS 328 TO 340 PLUS 15 INCHES INBOARD OF L1 DOOR. REPLACED IAW 51-00-05-1 AND DRAWING 141A5400.SDR AALA20180111009Transition Panel · corrodedCORROSION ON THE RIGHT TRANSITION PANEL BETWEEN BS 500A TO 500I. INSTALLED A NEW TRANSITION PANEL IAW SRM 51-10-02, AND SRM 53-00-53.SDR AALA20180111008Transition Panel · corrodedCORROSION TO THE RIGHT TRANSITION PANEL BETWEEN BS 420 TO 440. INSTALLED A NEW TRANSITION PANEL IAW SRM 51-10-02.SDR AALA20180111007Intercostal · corrodedCORROSION ON FLOOR SUPPORT BETWEEN BS 947 TO 967 AT LBL 51. REPLACED THE FLOOR SUPPORT IAW 53-42-51-23, FIGURE 23, DETAIL H, 51-00-05-1 AND DRAWING 815A0010.SDR AALA20180111006Intercostal · corrodedCORROSION ON E&E BAY INTERCOSTAL WEB BETWEEN BS 312 TO 325 AT STRINGER 23L. REPLACED THE INTERCOSTAL IAW 51-00-05 AND 141A8131.SDR AALA20180111005Floor Support · corrodedCORROSION ON THE FLOOR SUPPORT BETWEEN BS 927 TO 947 AT LBL 51. REPLACED INTERCOSTAL PER DRAWING 147A5504 AND SRM 51-40-2.SDR AALA201801129042Sign · missingAIRCRAFT WAS NOT GROUNDED. FORWARD ENTRY EMERGENCY EXIT SIGN MISSING. REMOVED AND REPLACED FORWARD ENTRY LIGHT EXIT SIGN PER AMM 33-51-01-960-802.SDR AALA201801129043Shade · tornAIRCRAFT IN BASE MAINTENANCE. EXIT ROW 14F WINDOW SHADE TORN. REPLACED WINDOW SHADE AT SEAT 14F PER AMM 25-21-12.SDR AALA201801129041Sign · missingAIRCRAFT WAS NOT GROUNDED: CABIN ENTRY EMERGENCY CABIN ENTRY EMERGENCY EXIT SIGN AND LIGHT MISSING AT DOOR 4L. REINSTALLED CABIN ENTRY EMERGENCY EXIT SIGN AND LIGHT AT DOOR 4L PER 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201801129025Controller · malfunctionedAIRCRAFT WAS GROUNDED. L2 SLIDING WINDOW "OVERHEAT" LIGHT ILLUMINATED, FOLLOWED BY WINDOW CRACKING BEYOND LIMITS. REPLACED WINDOW HEAT CONT NR 3, PER 30-41-11, OPS CHECK NORMAL. (SEE ALSO SDR AALA201801129022)SDR AALA201801129022Window · crackedAIRCRAFT WAS GROUNDED. L2 SLIDING WINDOW "OVERHEAT" LIGHT ILLUMINATED, FOLLOWED BY WINDOW CRACKING BEYOND LIMITS. REPLACED L2 WINDOW OPS CHECK NORMAL PER MCM 56-94-01. (SEE ALSO SDR AALA201801129025)SDR AALA20180109002Floor Support · crackedCRACK FORWARD ENTRY AREA FLOOR SUPPORT BETWEEN BS 312 TO 328, LBL 47, 15 INCHES INBOARD OF DOOR ENTRY . REPLACED THE FLOOR SUPPORT IAW 51-00-05-1 AND DRAWING 141A5400.SDR AALA20180108005Floor Support · corrodedFLOOR SUPPORT CORRODED. MAINTENANCE REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201801109013Bracket · crackedRIGHT AFT SERVICE DOOR EXIT SIGN BRACKET IS CRACKED. SECURED SIGN LENS. REPLACED LIGHT ASSY IAW AMM 33-51-00.SDR AALA20180111012Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 312 TO 328 AT LBL 46. INSTALLED A NEW FLOOR SUPPORT IAW 51-00-05-01, AND DRAWING 141A5400.SDR AALA20180111011Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 328 TO 344, LBL 46. REPLACED THE FLOOR SUPPORT IAW 51-00-05 REPAIR 1, AND DRAWING 141A5400.SDR AALA20180108003Plate · corrodedCORROSION ON UPPER THE CAP PLATE AT THE CARGO DOOR CUT-OUT LOWER FRAME EXTENSION BETWEEN BS 847 TO 850 AT RBL 18. REPLACED THE CAP PLATE IAW 51-00-05-1 AND DRAWING 146A0081.SDR AALA20180108006Stiffener · corrodedCORROSION ON VERTICAL STIFFENER IN APU COMPARTMENT OF RIGHT SIDE AT BS 1125. INSTALLED VERTICAL STIFFENER IAW DRAWING148A8650 AND 51-00-05-R1.SDR AALA20180107006Floor Support · crackedMAINTENANCE FOUND A CRACKED FLOOR SUPPORT IN THE FORWARD WET AREA OF THE CABIN FLOOR. MAINTENANCE REPLACED THE FLOOR SUPPORT IAW 51-00-05-01.SDR AALA201801109018Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: INTERMITTENT LAVATORY SMOKE MASTER CAUTION ON SIX PACK OVERHEAD LIGHTS IN CRUISE FLIGHT. MAINTENANCE ACCOMPLISHED LAVATORY SMOKE DETECTOR SYSTEM TEST PER AMM 26-14-00 ON ALL LAVATORIES. NO FAULTS NOTED AND PERFORMED SATISFACTORY OPERSDR AALA201801109014Shroud · missingAIRCRAFT WAS NOT GROUNDED. SEAT 9D EMERGENCY LIGHT SHROUD IS MISSING. REPLACED SEAT 9D LIGHT SHROUD PER MM 33-51-11.SDR AALA201801109012Light · looseAIRCRAFT WAS NOT GROUNDED: AFT RIGHT GALLEY DOOR EXIT SIGN AT MID-DOOR HEIGHT CLOSEST TO GALLEY CABINETS, LOOSE FROM SIDEWALL. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201801109021Lens · missingMISSING EMERGENCY EXIT LIGHT LENS AT THE R1 DOOR. MAINTENANCE REPLACED THE LENS IAW 33-51-01 AND PERFORMED A SATISFACTORY OPS CHECK.SDR AALA20180108004Light · crackedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY PATH LIGHT ASSEMBLY CRACKED. REPLACED EPL LIGHT ASSEMBLY PER AMM 33-51-14. OPERATION CHECKED PER ECO/J1888AA_0001.SDR AALA20180107005Floor Support · crackedTHE AIRCRAFT IS IN BASE MAINTENANCE. MAINTENANCE FOUND CABIN FLOOR BOARD SUPPORT CRACKED AT STATION 540 LBL 2. REMOVED AND REPLACED CENTER FLOORBOARD SUPPORT PER AMM 53-21-00 AND SRM 51-40-02.SDR AALA20180107002Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. LOWER FORWARD ENTRY WAY WALL LIGHT MISSING COVER. REMOVED AND REPLACED EMERGENCY LIGHT R SIDE PER MM 33-51-00.SDR AALA20180107008Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. MAINTENANCE FOUND A INTERCOSTAL CRACKED IN THE FWD WET AREAS, STA 335.5. LBL 45. MAINTENANCE REMOVED AND REPLACED THE INTERCOSTAL WITH A NEW AT STA 335.5- LBL 45.SDR AALA20180107004Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. MAINTENANCE FOUND A CABIN FLOOR INTERCOSTAL CRACKED AT STA 344-360, LBL 12. MAINTENANCE REMOVED AND REPLACED THE INTERCOSTALS WITH NEW PER 51-00-05-1.SDR AALA201801099023Smoke Detector · false activationTHE AIRCRAFT WAS NOT GROUNDED. THE FORWARD LAVATORY SMOKE DETECTOR ACTIVATED SEVERAL TIMES IN A 3 MINUTE PERIOD. PASSENGER WAS USING LAVATORY AT THE TIME. THERE WAS NO SMOKE OR UNUSUAL ODORS PHYSICALLY DETECTED. REPLACED FORWARD LAVATORY SMOKE DETECTOR PER MMSDR AALA20180107007Floor Support · crackedMAINTENANCE FOUND A CRACKED FLOOR SUPPORT IN THE FORWARD WET AREA AT BS 321, LBL 45. REPLACED THE FLOOR SUPPORT IAW 51-00-05-01.SDR AALA201801099010Window Shade · damagedTHE AIRCRAFT WAS NOT GROUNDED. DAMAGED EMERGENCY EXIT WINDOW SHADE AT 15A POSITION. REMOVED AND REPLACED EMERGENCY EXIT WINDOW SHADE AT 15A POSITION AS PER AMM 25-21-12. OK FOR SERVICE.SDR AALA201801099009Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. LOWER FORWARD ENTRY WAY WALL (RIGHT SIDE) MISSING LENS COVER. REMOVED AND REPLACED EMERGENCY LIGHT R SIDE PER MM 33-51-00.SDR AALA20180108001Flap System · malfunctionedFLAPS WOULD NOT EXTEND ON COMMAND, AFTER GO AROUND FLAPS EXTENDED NORMALLY. AIRCRAFT WAS GROUNDED. PERFORMED INSPECTION OF FLAPS & SLAT SYSTEMS, NO DAMAGE. OPS AND INDICATIONS GOOD. FSEU BITE NO CURRENT FAULTS. PERFORMED FIM 27-88-00 & 27-51-00.SDR AALA201801099024Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN LENS COVER ON THE LOWER RIGHT SIDE AISLE, JUST AFT OF THE FORWARD GALLEY IS MISSING. REPLACED LIGHT ASSEMBLY INSTALLING NEW LENS PER AMM 33-51-01. OPERATIONS CHECK GOOD.SDR AALA20180107001Control Valve · failedBLEED TRIP OFF LIGHT ON CLIIMB OUT (RESET ) HAPPENED TWICE, CABIN ALTITUDE LIGHT AT 34,000 STAYED ON AFTER REDBOX DID EMERGENT DESCENT TO OK. AIRCRAFT WAS GROUNDED. TROUBLESHOOTING THE RIGHT BLEED AIR SYSTEM AND CABIN PRESSURE CONTROL SYSTEM. REPLACED PRECO
Back to Boeing 737-823