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 AALA201709279019Shear Tie · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON SHEAR TIE UPPER SIDE OF LOWER FLANGE AT FUSELAGE STATION 967 BETWEEN STRINGERS 26L AND 27L. REMOVED AND REPLACED SHEAR TIE PER SRM 53-00-53-1A AND SRM 51-40-02.SDR AALA20170915001Skin · corrodedCORROSION ON THE LOWER SKIN FROM BS 888 TO 1016, STRINGER 23L TO 23R. REMOVED AND REPLACED THE SKIN IAW DWG 51-00-05-1.SDR AALA20170914004Skin · crackedCRACKS IN THE LEFT HORIZONTAL STABILIZER LOWER IN SPAR SKIN AT HSS 147.9 APPROXIMATELY 9 INCHES AFT OF LEADING EDGE, HSS 157.10 APPROXIMATELY 24 INCHES AFT OF LEADING EDGE, AND HSS 157.10 APPROXIMATELY 30 INCHES AFT OF LEADING EDGE. REPAIRED THE SKIN IAW SRM SDR AALA201709159001Slide · displacedL1 DOOR SLIDE IS DISPLACED FROM UNDER COVER. REMOVED AND REPLACED THE SLIDE IAW 25-94-10. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201709159002Light · brokenEMERGENCY EXIT LIGHT BY THE L2 DOOR IS BROKEN. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201709149017Lens · brokenEMERGENCY EXIT LIGHT BY THE R2 DOOR HAS A BROKEN LENS. REPLACED THE LENS IAW AMM 33-50-00. OPERATIONAL CHECKED GOOD.SDR AALA201709149016Lens · detachedEMERGENCY EXIT SIDEWALL LIGHT AT ROW 14DEF HAS A DETACHED LENS. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170913005Stringer · corrodedCORROSION FOUND INSIDE OF STRINGER 23L, AROUND FASTENER HOLE AT BS 920. REPAIRED THE STRINGER IAW SRM 53-00-03-2R-1, DRAWING 146A3230, AND D 51-00-05.SDR AALA201709139018Light · damagedAIRCRAFT WAS NOT GROUNDED. GALLEY-MOUNTED EMERGENCY ESCAPE PATH LIGHT TO THE RIGHT OF THE R2 DOOR IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201709139016Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS ON OVERHEAD BINS NEAR ROW 20ABC ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY (BATTERY PACK) PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201709149022Sensor · faultyEMERGENCY DECLARED. NO LEADING OR TRAILING FLAPS WHEN HANDLE SELECTED TO 1. RAN QRH. UNEVENTUL LANDING. REMOVED AND REPLACED THE NR 3 FLAP SKEW SENSOR IAW AMM 27-59-01. OPERATIONAL CHECK GOOD. AIRCRAFT WAS GROUNDED.SDR AALA20170912003Light · damagedEMERGENCY EXIT PROXIMITY LIGHT AT THE G2 GALLEY IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA201709139017Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT AISLE LIGHT AT STATION 727 HAS A MISSING LENS COVER. INSTALLED LENS COVER PER AMM 25-63-00. OPERATIONAL CHECK GOOD.SDR AALA201709129034Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT OVER THE R1 DOOR IS BROKEN. REPLACED EMERGENCY EXIT LIGHT LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA201709129033Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE R1 DOOR HAS A DETACHED LENS COVER. REPLACED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170911003Actuator · faultyAIRCRAFT WAS GROUNDED. EMERGENCY DECLARED. AUS-ORD FLIGHT DIVERTED TO DFW ACCOUNT STABILIZER TRIM INOPERATIVE. STABILIZER OUT OF TRIM AND SPEED TRIM FAIL LIGHTS ILLUMINATED. LANDING UNEVENTFUL. REMOVED AND REPLACED STABILIZER TRIM ACTUATOR (MOTOR) PER AMMSDR AALA20170911006Floor Support · crackedCRACKED CABIN FLOOR SUPPORT BETWEEN BS 312 AND 328, LBL 45. REMOVED AND REPLACED THE FLOOR SUPPORT IAW D 51-00-05-1 AND DRAWING 141A5400.SDR AALA20170911005Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 328 AND 344, LBL45. REMOVED AND REPLACED THE FLOOR SUPPORT IAW DWG 51-00-05-1 AND DRAWING 141A5400.SDR AALA20170911001Skin · crackedCRACKS IN THE RIGHT HORIZONTAL STABILIZER LOWER IN SPAR SKIN AT HSS 129.5, 18 INCHES FROM AFT SPAR. REPAIRED STABILIZER IAW SRM 55-10-01-2R-11.SDR AALA201709139021Flow Valve · faultyCABIN PRESSURIZATION COULD NOT BE MAINTAINED. ONE AIR-CONDITIONING PACK OPERATION AT FL240. CABIN ALTITUDE REACHED 10,000 AFTER 45 MINUTES IN CRUISE. DESCENDED TO 10,000 ALTITUDE WITH OUTFLOW VALVE INDICATING FULL CLOSE AND RIGHT PACK SHOWING 30 PSI. ZERO SDR AALA201709139022Acm · damagedAIRCRAFT WAS GROUNDED. CABIN PRESSURIZATION NOT MAINTAINED. ONE AIR-CONDITIONING PACK OPERATION AT FL240. CABIN ALTITUDE REACHED 10,000 AFTER 45 MINUTES IN CRUISE. DESCENDED TO 10,000 ALTITUDE WITH OUTFLOW VALVE INDICATING FULL CLOSE AND RIGHT PACK SHOWINGSDR AALA201709139020Isolation Valve · leakingAIRCRAFT WAS GROUNDED. CABIN PRESSURIZATION NOT MAINTAINED. ONE AIR-CONDITIONING PACK OPERATION AT FL240. CABIN ALTITUDE REACHED 10,000 AFTER 45 MINUTES IN CRUISE. DESCENDED TO 10,000 ALTITUDE WITH OUTFLOW VALVE INDICATING FULL CLOSE AND RIGHT PACK SHOWINGSDR AALA201709129009Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE L2 DOOR HAS A DETACHED LENS COVER. REPLACED LIGHT PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170909004Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CRACKED INTERCOSTAL BETWEEN FUSELAGE STATIONS 312 AND 328 AT LBL46. REMOVED AND REPLACED INTERCOSTAL PER AARD 51-00-05-1, DRAWINGS 141A5410 AND 141A5400.SDR AALA20170926004Transition Panel · corrodedCORROSION ON AFT CARGO RIGHT TRANSITION PANEL BETWEEN BS 847 AND 867, STRINGER 25R. INSTALLED A NEW TRANSITION PANEL IAW SRM 53-00-53.SDR AALA20170914002Angle · corrodedCORROSION ON THE L1 DOOR LOWER SILL CREASE ANGLE BETWEEN BS 300 AND 306. REMOVED AND REPLACED THE CREASE ANGLE IAW SRM 53-10-15, DWG 51-00-05-1, AND DRAWING 141A8110.SDR AALA201709119032Cover · crackedTHE AIRCRAFT WAS NOT GROUNDED. AFT GALLEY- WORK LIGHT HEAT DAMAGE WITH BURNING SMELL- RIGHT SIDE GALLEY. FOUND COVER CRACKED AND AGAINST LAMP. REMOVED AND REPLACED WORK LIGHT COVER. LIGHT CHECKS NORMAL REF AMM 33-26-02.SDR AALA201709089024Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE R1 DOOR HAS A DETACHED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201709089025Lens · brokenAIRCRAFT WAS NOT GROUNDED. RED LIGHT LENS COVER BROKEN OFF THE CEILING MOUNTED CALL LIGHT IN THE FLIGHT DECK ENTRY. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170907004Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT PROXIMITY LIGHT AT THE G2 GALLEY AISLE WALL IS DAMAGED. REMOVED AND REPLACED LIGHT PER AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA20170907003Channel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON FORWARD CARGO COMPARTMENT RIGHT TRANSITION ZEE CHANNEL SIDEPLATE BETWEEN FUSELAGE STATIONS 500D AND 500E. REPAIRED TRANSITION CHANNEL PER SRM 53-00-53-2R-5.SDR AALA20170907002Support · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CRACK IN THE CABIN FLOORBOARD RIGHT CENTER INBOARD OVERWING SUPPORT AT FUSELAGE STATION 540. REMOVED AND REPLACED PANEL BREAK ASSEMBLY (SUPPORT) PER AARD 51-00-05 AND SRM 51-40-02.SDR AALA20170906004Support Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON R1 DOOR LOWER SILL CREASE ANGLE ATTACH STIFFENER SUPPORT AT FUSELAGE STATION 325, RBL55. REMOVED AND REPLACED SUPPORT ANGLE PER AARD 51-00-05-1 AND DRAWING 141A0310.SDR AALA20170906003Light · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT FLOOR PROXIMITY LIGHT AT THE G2 GALLEY HAS A BROKEN FRAME. REMOVED AND REPLACED LIGHT PER AMM 33-51-14-960-801. OPERATIONAL CHECK GOOD.SDR AALA201709079016Power Supply · faultyAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS ON THE FOUR OVERWING EXITS FLICKERED ON AND OFF DURING CLIMB. REMOVED AND REPLACED TWO OVERWING POWER SUPPLIES (BATTERY PACKS) PER AMM 33-51-06. OPERATIONAL CHECK GOOD. SEE ALSO AALA201709079014SDR AALA201709079014Battery Pack · faultyAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS ON THE FOUR OVERWING EXITS FLICKERED ON AND OFF DURING CLIMB. REMOVED AND REPLACED TWO OVERWING POWER SUPPLIES (BATTERY PACKS) PER AMM 33-51-06. OPERATIONAL CHECK GOOD. SEE ALSO AALA201709079016SDR AALA20170906007Fmc · failedEMERGENCY DECLARED. RETURNED TO DEPARTURE DUE TO BOTH AUTO PILOTS AND NAVIGATIONAL AIDS FAILED. LANDING UNEVENTFUL. REMOVED AND REPLACED LEFT FLIGHT MANAGEMENT COMPUTER IAW AMM 34-61-02. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA20170905002Skin · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON SKIN IN 11 AREAS BETWEEN FUSELAGE STATIONS 727J AND 747, AND BETWEEN STRINGERS 27L AND 27R. REPAIRED PER SRM 51-10-02, SRM 53-00-01-1A-5, AND EA 272812.SDR AALA201709069039Cooling Fan · malfunctionedAIRCRAFT WAS NOT GROUNDED. EQUIPMENT COOLING SUPPLY FAN IN NORMAL MODE ILLUMINATED OFF IN DESCENT FOLLOWED BY GASEOUS ODOR OR FUMES. REMOVED AND REPLACED EQUIPMENT COOLING SUPPLY FAN PER AMM 21-27-02. OPERATIONAL CHECK GOOD.SDR AALA20170905005Intercostal · corrodedCORROSION ON AFT CARGO INTERCOSTAL BETWEEN BS 905 AND 927, BETWEEN STRINGERS 23L AND 24L. REMOVED AND REPLACED THE INTERCOSTAL IAW DWG 51-00-05-1, SRM 53-00-01-1A, AND DRAWING 147A7401.SDR AALA20170905004Stringer Splice · corrodedCORROSION ON THE AFT CARGO STRINGER SPLICE 27R, BS 887. REMOVED AND REPLACED THE STRINGER SPLICE IAW DWG 51-00-05-1, AND DRAWING 147A-0060.SDR AALA20170904005Light · no testEMERGENCY EXIT LIGHT L191 BY THE R2 DOOR FAILED. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR AALA201709069034Air Filter · odorAIRCRAFT WAS GROUNDED. DIRTY SOCK SMELL NOTICED ON TAXI OUT WITH APU NOT IN USE, DURING INITIAL CLIMB, AT CRUISE AFTER TURNING ON ANTI-ICE, AND AFTER START OF DESCENT. ACCOMPLISHED CABIN ODOR TROUBLESHOOTING PER MCM CARD 05-96-70, NO ODOR NOTED. REMOVED ANDSDR AALA20170903006Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 312 AND 328, RBL 31. REMOVED AND REPLACED THE FLOOR SUPPORT DWG 51-00-05-1 AND DRAWING 141A5400.SDR AALA20170903005Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 344 AND 360, LBL 11. REMOVED AND REPLACED THE FLOOR SUPPORT DWG 51-00-05-1 AND DRAWING 141A5400.SDR AALA20170903004Intercostal · crackedCRACKED INTERCOSTAL IN THE ELECTRICAL AND ELECTRONICS COMPARTMENT CEILING AT THE ANGLE NUT HOLE BETWEEN BS 312 AND 328, LBL 45. REMOVED AND REPLACED THE INTERCOSTAL IAW DWG 51-00-05-01 AND DRAWING 141A5400.SDR AALA201709069033Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED. SMOKE DETECTOR IN THE LEFT AFT LAVATORY SOUNDS WITH NO SMOKE PRESENT. ACCOMPLISHED SMOKE DETECTOR TEST PER FIM 26-14-00. OPERATIONAL CHECK GOOD.SDR AALA201709069002Light · brokenAIRCRAFT WAS NOT GROUNDED. G1 MOUNTED EMERGENCY ESCAPE PATH LIGHT HAS BROKEN RECEPTACLE CLIPS AND THE LENS COVER WILL NOT STAY ON. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170903009Warning System · false activationTHE AIRCRAFT WAS GROUNDED. AIRCRAFT RETURNED TO THE GATE ACCOUNT LEFT ENGINE OVER HEAT WITH BOTH FIRE BOTTLES USED. FIRE DEPARTMENT MET AIRCRAFT WITH NO EVIDENCE OF OVER HEAT. PERFORMED ENG. EXCEEDANCE CK PER AMM 71-00-00-740-801 NO EXCEEDANCES. PERF ACT TESSDR AALA20170904001Slide · detachedL1 DOOR EMERGENCY EVACUATION SLIDE FELL OFF HOUSING ON DOOR OPENING AT ARRIVAL. INSTALLED THE SLIDE IAW AMM 25-66-01. OPERATIONAL CHECKED GOOD.
Back to Boeing 737-823