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 AALA201810296006Web · corrodedCORROSION FOUND ON THE RIGHT SUBFLOOR WEB JUST AFT OF FLOORBEAM BETWEEN BS 986 - 992.8, RBL 32-48. REPLACED THE WEB IAW 51-00-05.SDR AALA201810296005Support · corrodedCORROSION FOUND ON THE GALLEY SUPPORT BETWEEN BS 992.8 - 1006, RBL 35. REPLACED THE SUPPORT IAW 51-00-05.SDR AALA20181026004Floor Support · corrodedCORROSION ON THE TOP FACE OF THE FLOOR SUPPORT BETWEEN BS 986.5 TO 1006, RBL 30. REPLACED THE FLOOR SUPPORT IAW 51-00-0505-1, PRINT 147A5700, AND SRM 51-40-02.SDR AALA2018102690003Angle · corrodedCORROSION FOUND ON THE G4 ZEE ANGLE BETWEEN BS 986 TO 1016, LBL 35. REPLACED THE ANGLE IAW 51-00-05, AND PRINT 147A8501.SDR AALA20181026002Floor Support · corrodedCORROSION FOUND ON THE FLOOR SUPPORT BETWEEN BS 947 TO 967, RBL 25. REPLACED THE FLOOR SUPPORT IAW 51-40-02.SDR AALA201810309001Float Valve · cloggedSTRONG VOMIT ODOR NEAR THE L1 DOOR. NO VOMIT PRESENT. MAINTENANCE FOUND FWD SILL DRAIN FLOAT VALVE CLOGGED. REMOVED AND REPLACED IAW AMM 38-31-06. OPS CHECKED NORMAL.SDR AALA201810265003Angle · corrodedCORROSION WAS FOUND ON R1 DOOR CREASE ANGLE AT BS 312 - 328, RBL 51. REPLACED THE CREASE ANGLE IAW 51-00-05.SDR AALA201810265009Transition Panel · corrodedCORROSION ON THE LT TRANSITION PANEL BETWEEN BS 467 TO 500I. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R, AND SRM51-10-2, PARAGRAPH 9.SDR AALA201810265006Transition Panel · corrodedCORROSION TO FORWARD CARGO RIGHT TRANSITION PANEL BETWEEN BS 500A TO 500I. REPLACED FORWARD CARGO RIGHT TRANSITION PANEL IAW SRM 53-00-53-2R, AND SRM 51-10-2 PARAGRAPH 9.SDR AALA201810264008Connector · dirtyFLAPS WOULD NOT RETRACT. EMERGENCY WAS DECLARED AND FLIGHT WILL NOT LAND. FLAPS DID NOT EXTEND BEYOND 15 DEGREES AFTER BEING COMMANDED ON APPROACH. THE AIRCRAFT WAS GROUNDED. CLEANED THE T427 CONNECTOR. OPS CHECKED THE FLAPS IAW FIM 27-51-00-818-813. OPSSDR AALA201810254007Transition Panel · corrodedCORROSION ON AFT CARGO BAY RIGHT TRANSITION PANEL BETWEEN BS 847 AND 867. REPLACED THE TRANSITION PANEL IAW SRM 51-10-02 AND 51-00-05.SDR AALA201810254004Floorbeam · corrodedCORROSION ON THE CABIN FLOORBEAM AT BS 947.5 BETWEEN LBL 51 AND RBL 51. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-5.SDR AALA201810254003Angle · crackedA PREVIOUSLY REPAIRED ANGLE WAS FOUND TO BE CRACKED BETWEEN BS 291 AND 300 JUST FORWARD OF THE R1 DOOR, RBL 52. REPLACED THE ANGLE IAW 51-00-05 AND SRM 51-40-02.SDR AALA201810269007Pin · brokenAIRCRAFT WAS NOT GROUNDED. FORWARD ENTRY DOOR WILL NOT OPEN, IT UNLOCKS AND CRACKS ABOUT THREE INCHES THEN IS MECHANICALLY STUCK. REPLACED BROKEN PIN AND SAFETY SCREW AT L1 DOOR UPPER HINGE PER AMM 52-11-21.SDR AALA201810249008Fuse · failedRIGHT OVERWING AFT EXIT EMERGENCY LIGHT AT DOOR AND LOWER FUSELAGE WAS INOPERATIVE. REPLACED THE FUSES.SDR AALA201810243005Fuse · failedRIGHT OVERWING, AFT EXIT EMERGENCY LIGHT AT DOOR AND LOWER FUSELAGE WAS INOPERATIVE. REPLACED THE FUSES.SDR AALA201810243003Floorbeam · corrodedCORROSION ON THE AFT CABIN FLOORBEAM, BS 987 BETWEEN LBL 51 AND RBL 51. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-4.SDR AALA2018102659015Float Valve · cloggedDURING CRUISE FLIGHT, AT 2 HOURS AND 30 MIN, THE FLIGHT ATTENDANT REPORTED A ROTTEN ODOR COMING FROM THE VENTS IN THE FORWARD 1ST CLASS, NEAR LAVATORY. THE AIRCRAFT WAS GROUNDED. FOUND A CLOGGED DRAIN FLOAT VALVE. REPLACED THE FLOAT VALVE IAW AMM 38-31-06SDR AALA201810232003Angle · corrodedCORROSION ON THE L1 DOOR THRESHOLD CREASE ANGLE BETWEEN BS 313 AND 348, LBL 52. REPLACED CREASE ANGLE IAW 51-00-05.SDR AALA201810239021Engine · failedAIRCRAFT WAS GROUNDED. A/C DIVERTED TO CLE ACCOUNT OF NUMBER 1 ENGINE SHUT DOWN (FAILURE). OIL PRESSURE WAS 0 PSI OIL QTY WAS 17, WE HAD N-1 AND N-2 ROTATION PERFORMED EMERGENCY SHUT DOWN CHECK LIST. ACCOMPLISHED EEC NR 1 BITE FOUND SEVERAL FAULTS-INCLUDING FSDR AALA201810229051Sensor · defectiveAIRCRAFT WAS GROUNDED. PHX-MIA DECLARED EMERGENCY INBOUND MIA ACCOUNT FLAPS WOULD NOT EXTEND. FLIGHT LANDED WITHOUT INCIDENT. ON APPROACH AFTER SELECTING FLAPS TO 1, FLAP INDICATION WAS UP AND SPLIT. CREW DID FLAP ECS LANDING. REPLACED SENSOR NR 1 OUT B FLAP SSDR AALA201810229007Controller · failedAIRCRAFT RETURNED TO DEPARTURE, DUE TO THE CAPTAINS SIDE L1 WINDOW CRACKED. AN EMERGENCY WAS DECLARED AND LANDED WITHOUT INCIDENT. MAINTENANCE CONFIRMED THE WINDOW CRACKED DUE TO WINDOW HEAT SYSTEM FAILURE. REPLACED THE WINDOW IAW AMM 56-11-11, THE WINDOW SDR AALA201810240004Cable · contaminatedDURING CLIMB, LANDING GEAR HANDLE WOULD NOT RAISE AFTER TAKEOFF. QRH PROCEDURES FOLLOWED BUT THEY WOULD STILL NOT RAISE. EMERGENCY DECLARED AND FLIGHT LANDED WITHOUT FURTHER INCIDENT. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REMOVED FACEPLATE OF LANDING GEAR SDR AALA201810239001Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. AFT ESCAPE SLIDE LIGHT AT L2 DOOR IS INOPERATIVE ON TEST. REPLACED BATTERY PACK (M1673) PER MM 33-51-06 ON L2 DOOR ESCAPE SLIDE LIGHT. OPERATIONS CHECK NORMAL.SDR AALA201810229052Flap · stuckAIRCRAFT WAS GROUNDED. CLT-BOS DECLARED EMERGENCY INTO BOS ACCOUNT FLAP PROBLEM. FLAPS STUCK AT 2 WHICH CAUSED THEM TO USE ALTERNATIVE FLAPS 15 AT 4000 FEET. ARFF MET FLIGHT. FLIGHT LANDED WITHOUT INCIDENT. TRAILING EDGE FLAPS STOPPED AT 2 DEGREES USED ALTERNASDR AALA201810229049Doubler · crackedWHILE WORKING LOWER LATCH FOR EXTERNAL POWER ACCESS DOOR, FOUND THE LOWER DOOR CUTOUT DOUBLER FOR THE LATCH CRACKED IN TWO PLACES ON THE FUSELAGE. CRACKED AREA KEEPS DOOR FROM CLOSING COMPLETELY AND NOT LATCHING. REPAIRED THE DOUBLER IAW SRM 53-10-15-2R-4SDR AALA2018102200005Window · crackedAIRCRAFT RETURNED TO DEPARTURE DUE TO CAPTAINS SIDE L1 WINDOW CRACKED. AN EMERGENCY WAS DECLARED AND LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS GROUNDED. MAINTENANCE CONFIRMED THE WINDOW WAS CRACKED DUE TO WINDOW HEAT SYSTEM FAILURE. REPLACED THE WINDOW IAW SDR AALA201810239023Handle · out of adjustL4 DOOR OUT OF ADJUSTMENT DUE TO HANDLE CREEPING UP DURING FLIGHT. MAINTENANCE ADJUSTED THE DOOR IAW AMM 52-13-00 OK FOR SERVICE.SDR AALA2018102329044Starter · leakingLEFT OIL QUANTITY WENT TO ZERO ON DESCENT. EMERGENCY DECLARED AND FLIGHT LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE DETERMINED THAT THERE WAS NO DISCREPANCY IN OIL PRESSURE. ENGINE STARTER WAS FOUND TO BE THE SOURCE OF THE OIL LEAK. THE AIRCRAFT WAS GROUNDEDSDR AALA2018102329030Fseu · defectiveFLAP ASYMMETRY UPON EXTENSION LEFT NEEDLE AT "0", RIGHT NEEDLE APPROXIMATELY "0.1". LEADING EDGE DEVICE EXTENDED VIA ALTERNATE FLAP SWITCH, NO EXCESSIVE BRAKE USE REQUIRED FOR LANDING. THE AIRCRAFT WAS GROUNDED. ACCOMPLISHED VISUAL INSPECTION OF TRAILING EDGSDR AALA201810232004Web · corrodedCORROSION ON THE AFT CARGO DOOR CUTOUT THRESHOLD WEB BETWEEN BS 793 AND 847, RBL 20 TO RBL 28. REPLACED THE THRESHOLD WEB IAW 51-00-05 AND SRM 51-40-02.SDR AALA201810239004Battery · dischargedAIRCRAFT WAS NOT GROUNDED. LEFT AFT FLIGHT ATTENDANT FLASHLIGHT WON'T TEST. REPLACED BATTERY PER AMM 25-64-00. OPERATIONS CHECKS NORMAL.SDR AALA201810239003Battery · dischargedAIRCRAFT WAS NOT GROUNDED. RIGHT AFT FLIGHT ATTENDANT FLASHLIGHT WON'T TEST. REPLACED BATTERY PER AMM 2564-00. OPERATIONS CHECKS NORMAL.SDR AALA2018102299029Floor Panel · damagedMAIN CABIN FLOOR PANEL WAS SOFT BETWEEN SEATS 4AB - 4EF. REPLACED THE FLOOR PANEL IAW AMM 53-21-00.SDR AALA201810198002Floor Support · crackedCRACKED CABIN FLOOR FLOOR SUPPORT BETWEEN BS 328 AND 348, LBL 46. REPLACED THE FLOOR SUPPORT IAW 51-00-05.SDR AALA201810198001Floor Support · crackedCRACKED CABIN FLOOR SUPPORT BETWEEN BS 312 AND 328, LBL 46. REPLACED THE FLOOR SUPPORT IAW 51-00-05.SDR AALA2018101227010Outflow Valve · defectiveCRUISE ALTITUDE 37,000 FT, AUTO FAIL LIGHT CAME ON. WHILE RUNNING THE CHECKLIST FOR AUTO FAIL, CABIN PRESSURE WAS UNCONTROLLABLE. CABIN COULD NOT BE CONTROLLED, DIVERTED, CABIN OXYGEN MASKS WERE DEPLOYED, AN EMERGENCY WAS DECLARED AND LANDED WITHOUT INCIDENSDR AALA201810198003Battery Pack · inoperativeOVERWING EMERGENCY EXIT LIGHTS FORWARD RIGHT SIDE WERE INOPERATIVE. REPLACED THE BATTERY PACK M1695 IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201810199019Battery · dischargedAIRCRAFT WAS NOT GROUNDED. LEFT HAND AFT GALLEY FLIGHT ATTENDANT EMERGENCY FLASHLIGHT INOPERATIVE. INSTALLED NEW BATTERY TO LEFT HAND AFT GALLEY FLIGHT ATTENDANT FLASHLIGHT PER MM 25-6-00. OPERATIONS CHECK GOOD.SDR AALA201810189003Bulkhead Web · crackedRIGHT WHEEL WELL BULKHEAD WEB, AT BS 663 WAS CRACKED. REPAIRED THE BULKHEAD WEB IAW 57-10-10-9, AND SRM 57-10-10-2R2.SDR AALA201810187009Shear Web · corrodedCORROSION FOUND ON THE AFT GALLEY FLOOR SHEAR WEB BETWEEN BS 986 AND 988, RBL 40 AND RBL 42. REPAIRED THE SHEAR WEB IAW EA 285972.SDR AALA201810187006Transition Panel · corrodedCORROSION ON FORWARD CARGO BA7 LEFT TRANSITION PANEL BETWEEN BS 500B AND 500I. REPLACED THE TRANSITION PANEL IAW SRM 53-00-532-2R5.SDR AALA201810187005Transition Panel · corrodedCORROSION ON FORWARD CARGO COMPARTMENT RIGHT TRANSISTION PANEL, BETWEEN BS 500A AND 500I. REPLACED TRANSITION PANEL IAW SRM 53-00-53-2R5.SDR AALA201810176003Floor Support · crackedCRACKED CABIN FLOOR SUPPORT AT BS 540 AND LBL 2. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201810176002Floor Support · crackedCRACKED CABIN FLOOR SUPPORT AT BS 540 AND RBL 2. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201810179018Sliding Window · faultyAIRCRAFT WAS GROUNDED: CAPTAIN SLIDING WINDOW WAS VERY DIFFICULT TO OPEN AND CLOSE, NOT SLIDING FREELY IN TRACK AND GRINDING. MAINTENANCE REPLACED WINDOW PER AMM 56-12-11 AND MCM 56-94-01.SDR AALA201810179017Handle · looseAIRCRAFT WAS GROUNDED: FORWARD GALLEY, R2 DOOR HANDLE WAS VERY LOOSE. MAINTENANCE VERIFIED R2 DOOR CLOSED AND LATCHED AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201810179016Handle · looseAIRCRAFT WAS GROUNDED: FORWARD GALLEY, R1 DOOR HANDLE WAS VERY LOOSE. MAINTENANCE VERIFIED R1 DOOR CLOSED AND LATCHED AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201810165006Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO RIGHT TRANSITION PANEL BETWEEN BS 747 AND 767. REPLACED THE TRANSISTION PANEL IAW SRM 53-00-53-2R, AND 51-00-05-1.SDR AALA201810165005Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO, LEFT TRANSITION PANEL BETWEEN BS 727G AND 727H. REPLACED THE TRANSITION PANEL IAW 51-00-05-1, AND SRM 53-00-53-2R-5.
Back to Boeing 737-823