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 AALA2020070879011Fuel Filter · cloggedAIRCRAFT GROUNDED - AFTER TAKEOFF, LEFT FILTER BYPASS LIGHT ILLUMINATED FOR 10 MINUTES WITH MASTER CAUTION. DID NOT REOCCUR AGAIN DURING FLIGHT, ENGINE INDICATIONS ALL NORMAL. REMOVED AND REPLACED #1 FUEL FILTER DIFFERENTIAL PRESSURE SWITCH (AALA202007079001) SDR AALA2020070879001Pressure Switch · defectiveAIRCRAFT GROUNDED - AFTER TAKEOFF, LEFT FILTER BYPASS LIGHT ILLUMINATED FOR 10 MINUTES WITH MASTER CAUTION. DID NOT REOCCUR AGAIN DURING FLIGHT, ENGINE INDICATIONS ALL NORMAL. REMOVED AND REPLACED #1 FUEL FILTER DIFFERENTIAL PRESSURE SWITCH (AALA202007079001) SDR AALA2020070549004Housing · detachedAIRCRAFT NOT GROUNDED - RED EXIT ROW SEAT LIGHT (16C) HOUSING DETACHED. REATTACHED AND SECURED EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-01, OPERATIONAL CHECK OKAY.SDR AALA2020070659001Battery Pack · dischargedAIRCRAFT NOT GROUNDED, LED FLASHES RED WHEN TESTED, RIGHT AFT FLIGHT ATTENDANT INBOARD SEAT, EMERGENCY FLASHLIGHT. REMOVED AND REPLACED BATTERY PACK PER AMM 25-64-00, OPERATIONAL CHECK GOOD.SDR AALA2020070439005Flashlight · dislodgedAIRCRAFT NOT GROUNDED - L4 EMERGENCY FLASHLIGHT, LED DOES NOT FLASH. RESEATED FLASHLIGHT AND INSTALLED NEW TAMPER SHIELD, PER AMM 25-64-00, OPERATIONAL CHECK NORMAL.SDR AALA2020070439004Flashlight · dislodgedAIRCRAFT NOT GROUNDED - L1 EMERGENCY FLASHLIGHT, LED DOES NOT FLASH. RESEATED FLASHLIGHT AND INSTALLED NEW TAMPER SHIELD, PER AMM 25-64-00, OPERATIONAL CHECK NORMAL.SDR AALA2020070629019Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND MAIN LANDING GEAR WHEEL WELL VAPOR BARRIER. REPAIRED VAPOR BARRIER PER 57-10-10-9 AND SRM 57-10-10-2R.SDR AALA2020070629018Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND MAIN LANDING GEAR WHEEL WELL VAPOR BARRIER. REPAIRED VAPOR BARRIER PER 57-10-10-9 AND SRM 57-10-10-2R.SDR AALA2020071099007Bearing · frozenAIRCRAFT GROUNDED: LEADING EDGE DISSAGREMENT LIGHT ILLUMINATED FROM FLAPS 5 TO 10. PEFORMED GO AROUND DECLARED EMERGENCY, QRH LANDING FLAPS 15. CONT LIGHT REMAINED ILLUMINATED THROUGHOUT LANDING. MINOR SPEED DEVIATIONS WOULD ILLUMINATE GREEN LIGHT THEN BACKSDR AALA2020071099006Bearing · frozenAIRCRAFT GROUNDED: LEADING EDGE DISSAGREMENT LIGHT ILLUMINATED FROM FLAPS 5 TO 10. PEFORMED GO AROUND DECLARED EMERGENCY, QRH LANDING FLAPS 15. CONT LIGHT REMAINED ILLUMINATED THROUGHOUT LANDING. MINOR SPEED DEVIATIONS WOULD ILLUMINATE GREEN LIGHT THEN BACKSDR AALA2020071099005Proximity Sensor · faultyAIRCRAFT GROUNDED: LEADING EDGE DISSAGREMENT LIGHT ILLUMINATED FROM FLAPS 5 TO 10. PEFORMED GO AROUND DECLARED EMERGENCY, QRH LANDING FLAPS 15. CONT LIGHT REMAINED ILLUMINATED THROUGHOUT LANDING. MINOR SPEED DEVIATIONS WOULD ILLUMINATE GREEN LIGHT THEN BACKSDR AALA202007029014Proximity Sensor · faultedAIRCRAFT GROUNDED: LEADING EDGE DISSAGREMENT LIGHT ILLUMINATED FROM FLAPS 5 TO 10. PEFORMED GO AROUND DECLARED EMERGENCY, QRH LANDING FLAPS 15. CONT LIGHT REMAINED ILLUMINATED THROUGHOUT LANDING. MINOR SPEED DEVIATIONS WOULD ILLUMINATE GREEN LIGHT THEN BACKSDR AALA202006309008Sign · unsecureAIRCRAFT WAS NOT GROUNDED: AIRCRAFT MID OVER WING EXIT SIGN IS HANGING BY ITS CORD OVER WALKWAY. SECURED OVERWING EXIT SIGN AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-01.SDR AALA202006309006Cover · abnormalAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT COVER AT ROW 16 LEFT SIDE, FELL OFF. REPLACED LIGHT BASE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA2020072219003Air Data Module · unserviceableAIRCRAFT GROUNDED: CLIMBING OUT OF FL300, FIRST OFFICERS AIRSPEED BECAME UNRELIABLE, EEC'S WENT TO ALT. BELOW FL200, INSTRUMENTS NORMALIZED. AIRCRAFT RETURNED TO MIA WHERE IT LANDED SAFELY WITHOUT FURTHER INCIDENT (NO EMERGENCY WAS DECLARED). ***SUPPLEMENTALSDR AALA2020072219002Probe · unserviceableAIRCRAFT GROUNDED: CLIMBING OUT OF FL300, FIRST OFFICERS AIRSPEED BECAME UNRELIABLE, EEC'S WENT TO ALT. BELOW FL200, INSTRUMENTS NORMALIZED. AIRCRAFT RETURNED TO MIA WHERE IT LANDED SAFELY WITHOUT FURTHER INCIDENT (NO EMERGENCY WAS DECLARED). REMOVED AND RESDR AALA2020072219001Sensor · malfunctionedAIRCRAFT GROUNDED: CLIMBING OUT OF FL300, FIRST OFFICERS AIRSPEED BECAME UNRELIABLE, EEC'S WENT TO ALT. BELOW FL200, INSTRUMENTS NORMALIZED. AIRCRAFT RETURNED TO MIA WHERE IT LANDED SAFELY WITHOUT FURTHER INCIDENT (NO EMERGENCY WAS DECLARED). REMOVED AND RESDR AALA202006309007Pin · shearedAIRCRAFT WAS GROUNDED: L1 ENTRY DOOR GUST LOCK GUIDE ARM HOLD OPEN DOWN TO RELEASE PIN SHEARED. REPLACED PIN AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-11-21.SDR AALA202006309005Air Data Module · malfunctionedGROUNDED, CLIMBING OUT OF FL300, F/O AIRSPEED UNRELIABLE. BELOW FL200, INSTRUEMENTS NORMAL. RTD & LANDED SAFELY, NO FURTHER INCIDENT. NO EMERGENCY DECLARED. R & R F/O STATIC ADM IAW AMM 34-21-04. R & R ANGLE OF ATTACK SENSOR IAW AMM 34-21-05. R & R PITOT PSDR AALA202007149015Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROISON ON AFT CARGO COMPARTMENT TRANSITION PANEL SHIELD BETWEEN BS 767 AND BS 787 AT S25R. REPLACED TRANSITION PANEL SHEILD PER 51-00-05-1.SDR AALA202006299004Flashlight · inoperativeAIRCRAFT NOT GROUNDED - L1 DOOR FLIGHT ATTENDANT SEAT FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-00-00.SDR AALA202006299003Battery Pack · missingAIRCRAFT WAS NOT GROUNDED BUT WAS IN SHORT TERM STORAGE: LEFT HAND AFT ENTRY DOOR EMERGENCY EXIT LIGHT BATTERY PACK MISSING. INSTALLED BATTERY PACK PER AMM 33-51-06.SDR AALA202006289006Battery Pack · missingAIRCRAFT WAS NOT GROUNDED BUT WAS IN SHORT TERM STORAGE: FOUND LEFT HAND EMERGENCY BATTERY UNDER AFT SIDE PANEL TO BE MISSING. INSTALLED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA202006289005Battery Pack · missingAIRCRAFT WAS NOT GROUNDED BUT WAS IN SHORT TERM STORAGE: FOUND LEFT HAND MAIN ENTRY EMERGENCY LIGHT BATTERY PACK MISSING. INSTALLED BATTERY PACK AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA202006289004Battery Pack · missingAIRCRAFT WAS NOT GROUNDED BUT WAS IN SHORT TERM STORAGE: FOUND EMERGENCY BATTERY PACK AT RIGHT HAND OVER WING EMERGENCY EXIT LIGHT MISSING. INSTALLED BATTERY PACK AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA202007099016Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL / BREAK ASSEMBLY PANEL AT BS 530 AND RBL 2. REPLACED INTERCOSTAL / BREAK ASSEMBLY PANEL PER SRM 51-40-02.SDR AALA2020071099015Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL / BREAK ASSEMBLY PANEL AT BS 530 AND LBL 2. REPLACED IINTERCOSTAL / BREAK ASSEMBLY PANEL PER SRM 51-40-02.SDR AALA2020070549007Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 344 AND BS 360 AT LBL 11. REPLACED INTERCOSTAL PER 51-00-05-1.SDR AALA202006289003Pin · brokenAIRCRAFT WAS GROUNDED: ON LANDING ROLLOUT CREW FELT A HEAVY SHIMMY WITH UNCONTROLLABLE STEERING WHICH RESULTED IN THE FAILURE OF THE NOSE LANDING GEAR STEERING SYSTEM. AN EMERGENCY WAS DECLARED. MAINTENANCE PERFORMED A PRELIMINARY EVALUATION OF THE NOSE GEARSDR AALA2020062879001Sign · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN DETACHED FROM CEILING. REATTECHED EMERGENCY EXIT SIGN PER AMM 33-51-01.SDR AALA202006269001Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE - EMERGENCY LIGHTS, ROW 21DEF, INOPERATIVE. REMOVED AND REPLACED EPSU (EMERGENCY POWER SUPPLY UNIT) PER AMM 33-51-06. ALLOWED BATTERY TO CHARGE FOR 90-MINUTES. ALL OPERATIONAL CHECKS GOOD.SDR AALA202007099009Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL AT BS 537 BETWEEN BL 0 AND LBL 22. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA2020062549041Battery Pack · missingAIRCRAFT WAS NOT GROUNDED BUT WAS IN SHORT TERM STORAGE: EMERGENCY EXIT LIGHTS AT L1 DOOR INTERIOR AND EXTERIOR INOPERATIVE. MAINTENANCE FOUND THAT THE EMERGENCY LIGHT M01675 POWER SUPPLY (AALA202006249001) AND BATTERY PACK (AALA202006249041) WERE NOT INSTALLSDR AALA2020062549001Power Supply · missingAIRCRAFT WAS NOT GROUNDED BUT WAS IN SHORT TERM STORAGE: EMERGENCY EXIT LIGHTS AT L1 DOOR INTERIOR AND EXTERIOR INOPERATIVE. MAINTENANCE FOUND THAT THE EMERGENCY LIGHT M01675 POWER SUPPLY (AALA202006249001) AND BATTERY PACK (AALA202006249041) WERE NOT INSTALLSDR AALA202006249019O-Ring · damagedAIRCRAFT WAS GROUNDED: AT CRUISE ALTTITUDE FL 360, HYDRAULIC SYSTEM B FAILED, HYDRAULIC QUANTITY AND PRESSURE INDICATED 0. AN EMEREGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO MIA WHERE IT LANDED SAFELY WITHOUT FURTHER INCIDENT. MAINTENANCE FOUND THE B SYSDR AALA202007069013Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 328 AND BS 344 AT LBL 45. REPLACED INTERCOSTAL PER 51-00-05-1.SDR AALA202007069012Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 344 AND BS 360 AT BL 0. REPLACED INTERCOSTAL PER 51-00-05-1.SDR AALA202006299002Eec · defectiveAIRCRAFT WAS GROUNDED: #1 ENGINE ACCELERATES SLOWER THAN #2. MOST NOTICABLE WHEN SETTING TAKEOFF POWER. REPLACED THE FOLLOWING COMPONENTS ON THE LEFT HAND ENGINE; HYDROMECHANICAL UNIT (HMU) PER TASK CARD 73-94-12 (AALA202006249002), ENGINE FUEL PUMP PER AMM 73SDR AALA202006299001Pump · defectiveAIRCRAFT WAS GROUNDED: #1 ENGINE ACCELERATES SLOWER THAN #2. MOST NOTICABLE WHEN SETTING TAKEOFF POWER. REPLACED THE FOLLOWING COMPONENTS ON THE LEFT HAND ENGINE; HYDROMECHANICAL UNIT (HMU) PER TASK CARD 73-94-12 (AALA202006249002), ENGINE FUEL PUMP PER AMM 73SDR AALA2020062549002Hmu · defectiveAIRCRAFT WAS GROUNDED: NR 1 ENGINE ACCELERATES SLOWER THAN NR 2. MOST NOTICABLE WHEN SETTING TAKEOFF POWER. REPLACED THE FOLLOWING COMPONENTS ON THE LEFT ENGINE HYDROMECHANICAL UNIT IAW CARD 73-94-12 (AALA202006249002), ENGINE FUEL PUMP PER AMM 73-11-01 (AASDR AALA2020062629026Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 312 AND BS 328 AT RBL 30 AND S17R. REPLACED INTERCOSTAL PER SRM 51-40-02 AND 51-00-05-1.SDR AALA2020062329025Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 312 AND BS 328 AT LBL 45 AND S17L. REPLACED INTERCOSTAL PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA2020062629031Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED ATTACH ANGLE ON THE CENTER WING REAR SPAR VERTICAL PRESSURE DECK AT BS 663 AND LBL 33. REPAIRED REAR SPAR VERTICAL PRESSURE DECK ATTACH ANGLE PER EA 306541.SDR AALA202006259001Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: LEFT EMERGENCY POWER SUPPLY BATTERY PACK AT BS 727 INOPERATIVE. REPLACED BATTERY PACK AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA2020062319001Windshield · wornAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK CAPTAINS SIDE L1 WINDSHIELD WORN. REPLACED WINDSHIELD PER TASK CARD 2711.SDR AALA202006229001Adiru · warning messageAIRCRAFT WAS GROUNDED: DURING CLIMB IAS DISAGREE MESSAGE. FIRST OFFICERS AIRSPEED INDICATED 130 KNOTS SLOW AT ALTITUDE. DURING DESCENT THROUGH 20,000 AIRSPEED RETURNED TO NORMAL THROUGH THE REST OF THE FLIGHT. MAINTENANCE FOUND FAULT MESSAGES ON AIR DATA INERSDR AALA2020071099018Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOORBEAM AT BS 986 AND LBL 40. REPAIRED FLOORBEAM PER EA 306838.SDR AALA2020071099017Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR Z ANGLE AT BS 990 BETWEEN RBL 34 AND RBL 47. REPLACED Z ANGLE PER SRM 51-10-02.SDR AALA2020071099014Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR K WEB AT BS 988 AND RBL 33. REPAIRED K WEB PER EA 306839.SDR AALA202007099013Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR HALF MOON WEB AT BS 1018 AND RBL 31. REPAIRED WEB PER SRM 57-70-51-1A.
Back to Boeing 737-823