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 AALA20170903008Switch · failedEMERGENCY DECLARED. FLIGHT RETURNED TO DEPARTURE DUE TO STABILIZER TRIM FAILED DURING CLIMB. LANDING UNEVENTFUL. REMOVED AND REPLACED CAPTAIN`S COLUMN LEFT STABILIZER TRIM CUTOUT SWITCH IAW AMM 27-41-51. OPERATIONAL CHECK PER AMM 27-41-00 GOOD. AIRCRAFT WSDR AALA201709069025Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT NEXT TO THE AFT RIGHT JUMPSEAT HAS A BROKEN LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201709069024Lens · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE L2 DOOR AFT POSITION HAS A DAMAGED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY (ILLUMINATOR) PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170902005Intercostal · crackedCRACKED INTERCOSTAL IN THE ELECTRICAL AND ELECTRONICS COMPARTMENT CEILING BETWEEN BS 328 AND 344, LBL 45. REMOVED AND REPLACED THE INTERCOSTAL IAW DWG 51-00-05-1 AND PRINT 141A5400.SDR AALA201709059037Quick Disconnect · failedTHE AIRCRAFT WAS GROUNDED. AFTER GEAR RETRACTION LEFT ENGINE HYDRAULIC LOW PRESSURE LIGHT ILLUMINATED. REMAINED ON.. FOLLOWED QRH PROCEDURES, DECLARED AN EMERGENCY, AND RETURNED TO DFW WITHOUT FURTHER INCIDENT. FOUND PYLON QUICK DISCONNECT FITTINGS FOR PRESSSDR AALA201709059034Cover · looseTHE AIRCRAFT WAS NOT GROUNDED. PLASTIC EXIT LIGHT CLEAR COVER NEAR AFT RIGHT EXIT DOOR COMES OFF EASILY. REPLACED RT AFT EXIT LIGHT ASSY IAW AMM 33-51-01. OPS OK.SDR AALA201709059033Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. OVERNIGHT A CHECK FOUND AFT R/H EMERGENCY LIGHT LENS MISSING, AFT OF RT DOOR. REMOVED AND REPLACED AFT RT EMERGENCY LIGHT ASSY. AFT OF RT DOOR IAW AMM 33-51-00 TESTED AND CHECKED GOOD.SDR AALA20170831011Sensor · faultyAIRCRAFT WAS GROUNDED. EMERGENCY DECLARED. ON APPROACH, THE CREW REPORTED UNABLE TO EXTEND FLAPS. LEADING EDGE DEVICES WERE EXTENDED WITH THE ALTERNATE FLAPS EXTENSION SWITCH. NO TRAILING EDGE OR LEADING EDGE DEVICES WOULD EXTEND BY FLAP LEVER POSITION ALOSDR AALA201709059032Light · damagedTHE AIRCRAFT WAS NOT GROUNDED. R-1 FWD GALLEY EMERGENCY LIGHT INOP, BASE IS BROKEN AND LENS IS MISSING. LENS WAS GLUED TO WALL. REPLACED R1 EMERGENCY LIGHT ASSY PER AMM 33-51-01 OPS CKS GOOD.SDR AALA201709059031Light · damagedTHE AIRCRAFT WAS NOT GROUNDED. R4 RIGHT AFT EMERGENCY LIGHT INOP, BASE IS BROKEN AND LANES IS MISSING. LENS WAS GLUED TO WALL. REPLACED R4 EMERGENCY LIGHT ASSY PER AMM 33-51-01, OPS CKS GOOD.SDR AALA201709019026Smoke Warning · false activationAIRCRAFT WAS NOT GROUNDED. LAVATORY SMOKE LIGHT ILLUMINATED DURING CRUISE WITH NO KNOWN ISSUES, FLIGHT ATTENDANTS FOUND NO SMOKE OR HEAT IN LAVATORIES. SELF TESTED LAVATORY SMOKE DETECTORS PER AMM 26-14-00. UNABLE TO DUPLICATE FAULT. OPERATIONAL CHECK GOODSDR AALA201709019025Smoke Detector · faultyAIRCRAFT WAS NOT GROUNDED. AFT LAVATORY D SMOKE DETECTOR AURAL WARNING WAS CONTINUOUSLY SOUNDING. WHEN ALERT STOPPED, THE GREEN LIGHT ON THE DETECTOR WAS NOT SHOWING. REMOVED AND REPLACED SMOKE DETECTOR PER AMM 26-14-01. OPERATIONAL CHECK GOOD.SDR AALA20170831012Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CRACK INDICATION ON CABIN FLOOR INTERCOSTAL BETWEEN FUSELAGE STATIONS 344 AND 360 AT LBL12. REMOVED AND REPLACED INTERCOSTAL PER AARD 51-00-05-01 AND DRAWING 141A5400.SDR AALA20170831010Floorbeam · corrodedCORROSION FOUND ON THE FORWARD CARGO AFT LOWER FLOORBEAM ANGLE AT AFT BULKHEAD BS 500I. REMOVED AND REPLACED THE FLOORBEAM ANGLE IAW SRM 51-10-02-0G.SDR AALA201709019021Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE LIGHT AT ROW 5E HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER PER AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA201709019020Battery · dischargedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT AT THE AFT RIGHT OUTBOARD JUMPSEAT IS INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA20170830006Floor Support · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CRACKED CABIN FLOOR SUPPORT BETWEEN BS 312 AND 328 AT LBL 46. REMOVED AND REPLACED THE FLOOR SUPPORT IAW 51-00-05-1 AND SRM 51-40-02.SDR AALA20170830004Actuator · failedAIRCRAFT WAS GROUNDED. EMERGENCY DECLARED ON APPROACH. LEADING EDGE SLATS WOULD NOT EXTEND WARNING INDICATION. NR 4 SLAT STUCK IN TRANSIT. LANDING UNEVENTFUL. REMOVED AND REPLACED NR 4 LEADING EDGE SLAT ACTUATOR PER AMM 27-81-41. LEAK AND OPERATIONAL CHESDR AALA201708319023Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE L2 DOOR HAS A DETACHED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201708309019Sign · unsecureAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN FALLING OFF NEAR 4R. REPLACED EMERGENCY LIGHT ASSEMBLY AFT OF 4R PER AMM 33-51-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708309016Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN OVER THE R2 DOOR HAS A MISSING LENS COVER. REPLACED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA201708309015Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT RIGHT AISLE NEAR FORWARD GALLEY HAS A BROKEN LENS COVER. REPLACED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201708309010Skin · corrodedAIRCRAFT WAS NOT GROUNDED. CORROSION AROUND FUSELAGE WATER DRAIN AT SECTION 43, STATION 500F, STRINGER 28L. REPAIRED PER SRM 51-10-02-0G AND SRM 53-00-01.SDR AALA201708309018Cover · missingAIRCRAFT WAS NOT GROUNDED. OVERWING EMERGENCY EXIT LIGHT LENS COVER BY FLOOR MISSING AT SEAT15A. INSTALLED NEW LENS COVER BY SEAT 15A PER AMM 33-51-01.SDR AALA201708299046Cover · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT COVER BROKEN IN FORWARD GALLEY, ACROSS FROM LAVATORY. REPLACED R1 DOOR EXIT SIGN LIGHT ASSEMBLY PER MM 33-51-01. CHECKS GOOD.SDR AALA20170828004Stringer · corrodedCORROSION FOUND ON THE AFT CARGO INSIDE STRINGER 24L BETWEEN BS 867 AND 869. A SPLICE REPAIR WAS INSTALLED IAW SRM 51-10-02, SRM 53-00-03-1A, DRAWING 147A0060, AND EA 262761.SDR AALA201708299045Light · inoperativeAIRCRAFT WAS NOT GROUNDED. OVERWING EXIT LIGHT 14ABC INOPERATIVE. REPLACED WINDOW OVERWING EXIT LIGHT AT 14ABC PER AMM 33-51-04.SDR AALA201708299044Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT ASSEMBLY AT FORWARD SERVICE DOOR DAMAGED. REPLACED LIGHT ASSEMBLY PER AMM 25-63-00, GOOD FOR SERVICE.SDR AALA20170826002Window · leakingEMERGENCY DECLARED. RETURNED TO DEPARTURE DUE TO AN EXTREMELY LOUD SQUEAL FROM THE FIRST OFFICERS R3 WINDOW. LANDING UNEVENTFUL. TORQUED AND SEALED THE WINDOW IAW AMM 56-11-21. LEAK AND OPERATIONAL CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201708289017Slide · deformedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT REPORTS L1 DOOR EMERGENCY EVACUATION SLIDE GIRT BAR IS DIFFICULT TO OPERATE AND EXCESS SLIDE IS SHOWING. REMOVED AND REPLACED SLIDE PACK AND COVER PER AMM 25-66-01. OPERATIONAL CHECK GOOD.SDR AALA20170826003Controller · faultedNO EMERGENCY DECLARED. FLIGHT RETURNED TO DEPARTURE DUE TO UNABLE TO PRESSURIZE THE CABIN. WHILE CLIMBING TO 10,000, CABIN ALTITUDE WARNING INDICATION AND LEAK SOUND FROM THE L1 AND L2 DOORS. LANDING UNEVENTFUL. PERFORMED A BITE CHECK OF BOTH PRESSURE COSDR AALA201708289067Sign · defectiveTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LENS LOWER BY DOOR 4R FELL OFF. REPLACED 4R DOOR EXIT SIGN ASSY PER AMM 33-51-01. OPS CK OK.SDR AALA20170825007Stringer · corrodedCORROSION ON STRINGER 26L BETWEEN BS 836.5 AND 887. A SPLICE REPAIR WAS INSTALLED IAW SRM 51-40-03, SRM 53-00-03-2R-1, EA 272761, AND DRAWING 147A0060.SDR AALA20170825006Stringer · corrodedCORROSION FOUND INSIDE STRINGER 22L, AROUND FASTENER HOLES AND BETWEEN BS 913 AND 920. REMOVED AND REPLACED THE STRINGER SECTION IAW DRAWING 147A0060 AND 51-00-05-1.SDR AALA20170825005Stringer · corrodedCORROSION ON AFT CARGO STRINGER 21L AT BS 888. SPLICE REPAIRED IAW DWG 51-00-05-1, EA 272743, AND DRAWING 147A0060.SDR AALA201708289013Retainer · out of adjustL1 DOOR EMERGENCY EVACUATION SLIDE IS DIFFICULT TO ARM. ADJUSTED GIRT BAR RETAINER IAW AMM 25-66-01. OPERATIONAL CHECKED GOOD.SDR AALA201708289011Light · damagedEMERGENCY EXIT LIGHT BY THE R1 DOOR FORWARD GALLEY COUNTER SIDE IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-14. OPERATIONAL CHECKED GOOD.SDR AALA201708289010Lens · brokenEMERGENCY EXIT LIGHT AT THE L2 DOOR HAS A BROKEN LENS COVER. REPLACED EXIT SIGN ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170824004Skin · crackedCRACK INDICATIONS ON THE LEFT HORIZONTAL STABILIZER LOWER IN SPAR SKIN AT HSS 175.50. REPAIRED IAW SRM 55-10-01-2R-11, AND EA 272673.SDR AALA201708289012Lens · missingEMERGENCY EXIT SIGN AT THE MIDDLE FUSELAGE HAS A MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 25-63-00. OPERATIONAL CHECKED GOOD.SDR AALA201708289009Bolt · looseL4 DOOR EMERGENCY EVACUATION SLIDE COVER HAS A LOOSE BOLT. SECURED THE SLIDE COVER BOLT IAW AMM 25-66-01. OPERATIONAL CHECKED GOOD.SDR AALA201708259010Probe · faultyFUEL IMBALANCE INDICATIONS. RAN FLIGHT WITH CROSSFEED OPEN AND LEFT PUMPS OFF. LEFT MAIN TANK QUANTITY INDICATOR SHOWS 600 LBS LESS THAN RIGHT MAIN TANK WHEN STICKS INDICATE BOTH EQUAL AND FULL. REMOVED AND REPLACED LEFT MAIN FUEL TANK UNIT PROBE F10 IAW ASDR AALA201708259002Slide · unsecureAIRCRAFT WAS NOT GROUNDED. L1 DOOR EMERGENCY EVACUATION SLIDE FELL DOWN FROM BUSTLE. REMOVED AND REPLACED SLIDE PACK PER AMM 25-66-01 AND CARD 25-94-10. OPERATIONAL CHECK GOOD.SDR AALA20170824014Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CRACKED INTERCOSTAL IN THE ELECTRONICS EQUIPMENT BAY BETWEEN FUSELAGE STATIONS 344 AND 360, LBL11. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-10-02, AARD 51-00-05-1, AND DRAWING 141A5400.SDR AALA20170824013Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CRACKED INTERCOSTAL IN THE ELECTRONICS EQUIPMENT BAY BETWEEN FUSELAGE STATIONS 312 AND 328, LBL42. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-00-05, AARD 51-00-05-1, AND DRAWING 141A5400.SDR AALA20170824012Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON FORWARD CARGO LEFT TRANSITION PANEL BETWEEN FUSELAGE STATIONS 460 AND 500I. REMOVED AND REPLACED TRANSITION PANEL PER SRM 53-00-53-2R AND AARD 53-00-53.SDR AALA201708259001Slide · looseAIRCRAFT WAS NOT GROUNDED. R4 DOOR EMERGENCY EVACUATION SLIDE PACK IS LOOSE. SECURED PACK. OPERATIONAL CHECK GOOD.SDR AALA201708249015Smoke Warning · false activationAIRCRAFT WAS NOT GROUNDED. LAVATORY SMOKE DETECTOR LIGHT AND WASTE COMPARTMENT FIRE EXTINGUISHER LIGHT ILLUMINATED. AFTER CREW DEBRIEF, FOUND NO FAULT ON SMOKE DETECTOR OR FIRE EXTINGUISHER. LIGHT IN TRASH AREA WAS HOT WATER HEATER. CREW SUSPECTS PASSENGERSDR AALA201708249014Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE LOWER R1 DOOR HAS A DETACHED LENS COVER. REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170823002Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS FROM SEAT ROW 22DEF TO RIGHT AFT LAVATORY AND RIGHT AFT SERVICE DOOR ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY (BATTERY PACK) M1672 PER AMM 33-51-06. OPERATIONAL CHECK GOOD.
Back to Boeing 737-823