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 AALA201812059026Vapor Barrier · crackedAIRCRAFT WAS NOT GROUNDED: RIGHT HAND WHEEL WELL CENTER SECTION REAR SPAR VAPOR BARRIER CRACKED FORWARD OF HYDRAULIC HAND PUMP, BETWEEN RBL 45.64 RIB AND RBL 54.21 RIB. REPAIRED VAPOR BARRIER PER 57-10-10-9.SDR AALA201812059025Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT LEFT AFT FLIGHT ATTENDANT JUMPSEAT SHOWED LOSS OF CHARGE. MAINTENANCE REPLACED LEFTHAND AFT FLIGHT ATTENDANT EMERGENCY FLASHLIGHT BATTERY AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201812073003Seat Track · wornLEFT OTBD SEAT TRACK WAS DAMAGED, BS 515. REPAIRED THE SEAT TRACK IAW SRM 53-00-52, REPAIR 4.SDR AALA201812049003Smoke Detector · false activationLAVATORY SMOKE LIGHT ILLUMINATED IN FLIGHT FOR ABOUT ONE MINUTE. ALARM SOUNDED IN LAVATORY IN A NON- CONTINUOUS MANNER. NO SMOKE PRESENT DUIRNG INSPECTION. ACCOMPLISHED A SELF TEST OF THE AFT LEFT LAVATORY SMOKE DETECTOR IAW MM 26-14-00. CHECKED OK. ACFT OSDR AALA201812049006Smoke Detector · false activationFLT 1454 EN-ROUTE LAX - SFO. THE AIRCRAFT WAS NOT GROUNDED. INTERMITTENT LAV SMOKE OVERHEAD INDICATION. FLIGHT ATTENDANTS FOUND NO EVIDENCE OF SMOKE IN LAV. MAINTENANCE ACCOMPLISHED SMOKE DETECTOR TEST ON AFT RIGHT LAV PER AMM 26-14-00. TEST NORMAL.SDR AALA201812039003Electronic Unit · malfunctionedAT FL370, THE AFT CARGO FIRE LIGHT ILLUMINATED. DIVERTED, AN EMERGENCY WAS DECLARED, AND LANDED WITHOUT INCIDENT. CONFIRMED NO FIRE. THE AIRCRAFT WAS GROUNDED. TAXIED TO THE GATE AND DEPLANED NORMALLY. REPLACED AFT CARGO SMOKE ELECTRONIC UNIT IAW AMM 26-16-SDR AALA201812049005Spring · defectiveTHE AIRCRAFT WAS NOT GROUNDED. FLIGHT OFFICERS SLIDING WINDOW WHEN FULLY OPENED. THE HOLD-OPEN LATCH WILL NOT ENGAGE, WINDOW CAN BE SHUT CLOSED WITHOUT PULLING ON THE LATCH. REPLACED SPRING ON RIGHT HAND LATCH PER IPC 56-12-51 AND SRM 51-40-02.SDR AALA201812041004Fuse · blownEXTERIOR LOWER RIGHT EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REPLACED THE FUSE IN THE POWER SUPPLY M01671, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-06.SDR AALA2018120430010Fuse · blownTWO INTERIOR OVERWING EXIT EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE FOUND TWO BLOWN FUSES IN THE POWER SUPPLY M01695 AND ONE BLOWN FUSE IN POWER SUPPLY M01694. MAINTENANCE REPLACED THE FUSES AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA2018120430009Fuse · blownTWO INTERIOR OVERWING EXIT EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE FOUND TWO BLOWN FUSES IN THE POWER SUPPLY M01695 AND ONE BLOWN FUSE IN POWER SUPPLY M01694. MAINTENANCE REPLACED THE FUSES AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201812041002Light · crackedG4 GALLEY RIGHT EMERGENCY LIGHT ASSEMBLY WAS CRACKED. REPLACED THE RIGHT EMERGENCY LIGHT IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201812031001Light · inoperativeCEILING EMERGENCY LIGHT OVERWING EXITS FOUND INOPERATIVE DURING BASE MAINTENANCE TESTING. REPLACED THE LIGHT ASSEMBELY. CHECKED GOOD.SDR AALA2018120430003Strap · corrodedCORROSION WAS FOUND ON THE G4 GALLEY STRAP LOCATED AT BS 1006 - 1020, RBL 27. REPLACED THE STRAP IAW RD 51-00-05.SDR AALA201811309011Flashlight · missingCABIN FLASHLIGHT MISSING IN THE FIRST CLASS GALLEY JUMPSEAT. REPLACED THE FLASHLIGHT IAW MM 25-64-00.SDR AALA201812049041Battery · dischargedAIRCRAFT WAS IN BASE MAINTENANCE. AFT LAVATORY D FLIGHT ATTENDANT SEAT FLASHLIGHT INOPERATIVE. REPLACED AFT LAVATORY FLASHLIGHT BATTERY AND PERFORMED OPERATIONS CHECK. OPERATIONS CHECK GOOD.SDR AALA201811309008Flashlight · not seatedNR 1 JUMPSEAT FLASHLIGHT NOT CHARGING. SEATED THE FLASHLIGHT IAW GPM 25-64-00. OPS CHECKED OK.SDR AALA2018113028011Angle · corrodedCORROSION FOUND ON THE RIGHT TRANSITION PANEL ANGLE, BS 497 - 500A, IN THE FORWARD CARGO BILGE. REPLACED THE ANGLE IAW RD 51-00-05, AND DRAWING 143A8126, SHEET 19.SDR AALA2018113029009Angle · corrodedCORROSION AT SEVERAL PLACES ON AFT ENTRY FLOOR CREASE ANGLE BETWEEN BS 894 AND 1006, LBL 47 TO LBL 62. REPLACED THE ANGLE IAW RD 51-00-05.SDR AALA2018113029005Floorbeam · corrodedCORROSION AT SEVERAL PLACES ON THE FLOORBEAM UPPER CAP. STATION 986, LBL 52 TO RBL -52. REPAIRED THE FLOORBEAM UPPER TEE IAW SRM 53-70-51-2R-4.SDR AALA2018113029008Angle · corrodedCORROSION FOUND ON THE CREASE ANGLE AT BS 890 - 1006, LBL 60. REPLACED THE ANGLE IAW RD 51-00-05.SDR AALA2018113029007Web · corrodedCORROSION FOUND ON THE AFT HALF MOON WEB, BS 1016 - 1030, BL 0 - RBL 52. REPLACED THE WEB IAW RD 51-00-05.SDR AALA2018113029006Web · corrodedCORROSION FOUND ON THE AFT MOON WEB LOCATED AT BS 1016 - 1030, BL 0 - LBL-52. REPLACED THE WEB IAW RD 51-00-05.SDR AALA20181128008Support Angle · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION FOUND ON GALLEY WALL SUPPORT Z ANGLE AT STATION 992, RBL 33-43. REPLACED Z ANGLE WALL SUPPORT PER 51-00-05-1 AND DRAWINGS 147A5710 AND 14745700.SDR AALA20181128007Support Angle · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION WAS FOUND ON AFT GALLEY FLOOR Z ANGLE AT AFT END, STATION 1016 AND LBL 32. REPLACED Z ANGLE SUPPORT PER 51-00-05-1 AND DRAWINGS 147A5710 AND 147A5700.SDR AALA20181128006Support Angle · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. AFT ENTRY FLOOR SUPPORT Z ANGLE CORRODED IN TWO PLACES AT STATION 992, LBL 37-43. REPLACED Z ANGLE SUPPORT PER 51-00-05-1 AND DRAWINGS 147A5710 AND 147A5700.SDR AALA20181128005Support Angle · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION FOUND ON GALLEY WALL SUPPORT Z ANGLE AT STATIONS 991-1016, RBL 32. REPLACED WALL SUPPORT Z ANGLE PER 51-00-05-1 AND DRAWINGS 147A5710 AND 147A5700.SDR AALA201811298003Floor Support · crackedA CRACK WAS FOUND ON THE FLOOR SUPPORT AT LBL 45, BS 312 - 328. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05.SDR AALA201811298002Floor Support · crackedA CRACK WAS FOUND ON THE FLOOR SUPPORT AT LBL 45, BS 328 - 344. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05.SDR AALA201811298014Transition Panel · corrodedCORROSION FOUND ON FWD CARGO RIGHT TRANSITION PANEL, BS 420 - 440. REPLACED THE TRANSISTION PANEL IAW DRAWING 143A0080, 143A8126, SHEET 11, AND SRM 51-10-2, PARAGRAPH 8.SDR AALA201811298013Transition Panel · wornAFT CARGO, LEFT TRANSITION PANEL HAS AN ELONGATED HOLE AT BS 747+10. REPAIRED THE TRANSITION PANEL IAW RD 51-00-05-1, SRM 53-00-53-2R-5, AND DRAWING 146A7502.SDR AALA201811298010Web · corrodedCORROSION FOUND ON WEB AROUND GALLEY MOUNT AT BS 986 - 991, RBL 32. REPLACED THE WEB IAW RD 51-00-05-1, DRAWING 147A5712, AND 147A5700.SDR AALA201811298009Web · corrodedCORROSION FOUND ON THE FLOOR WEB AT BS 986, LBL 44. REPLACED THE WEB IAW RD 51-00-05-1, DRAWINGS 147A5712, AND 147A5700.SDR AALA201811289017Flashlight · faultyAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANTS FLASHLIGHT AT FORWARD JUMPSEAT IS ON AND NEEDS TO BE REPLACED. REPLACED FLASHLIGHT PER AMM 25-64-00.SDR AALA20181127005Intercostal · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION FOUND AT STA 947-967, LBL 51-52, OF THE CABIN LEFT HAND SUBFLOOR OUTBOARD INTERCOSTAL. REPLACED THE INTERCOSTAL PER 51-00-05-1 AND INSTALL PRINT 147A5650-55.SDR AALA20181127010Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOORBEAM AT BS 947.5 BETWEEN LBL 30 AND LBL 58. REPAIRED FLOORBEAM PER SRM 53-70-51-2R.SDR AALA201811299013Battery · no testTHE FLASHLIGHT AT THE FORWARD FLIGHT ATTENDANT STATION WOULD NOT TEST. REPLACED THE BATTERY PACK AND TAMPER SEAL IAW AMM 25-64-00. OPS CHECKED NORMAL.SDR AALA20181127001Battery Pack · no testFLASHLIGHT AT THE FORWARD FLIGHT ATTENDANT STATION WOULD NOT TEST. REPLACED THE BATTERY PACK AND TAMPER SEAL IAW AMM 25-64-00. OPS CHECKED NORMAL.SDR AALA2018113029011Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 277 AND 294, BL 0. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05 AND DWG 141A5400.SDR AALA201811299008Smoke Detector · false activationTHE AIRCRAFT WAS NOT GROUNDED. MOMENTARY FALSE AURAL AND VISUAL SMOKE WARNING IN FORWARD LAVATORY. NO EVIDENCE OF SMOKE OR SMOKE SOURCE DETECTED. ACCOMPLISHED FIRST CLASS LAVATORY SMOKE DETECTION SELF TEST-ALL TESTS PASS PER AMM 26-14-00.SDR AALA2018112969040Flap System · malfunctionedDURING APPROACH, DURING FLAP EXTENSION, FLAPS STOPPED AT ABOUT 13 DEG, USED ALTERNATE EXTENSION TO 15 DEG. DECLARED AN EMERGENCY AND LANDED UNEVENTFULLY. THE AIRCRAFT WAS GROUNDED. PERFORMED VISUAL INSPECTION OF FLAP SYSTEM IAW AMM 27-51-00-210-801. NO DEFECTSDR AALA201811289001Control Valve · leakingWHITE SMOKE REPORTED BY TOWER. ENGINE INDICATIONS NORMAL, EXCEPT NR 1 ENGINE FUEL FLOW A BIT HIGHER AND FUEL CONSUMPTION 50 LBS PER MINUTE HIGHER THAN LEFT. DIVERTED. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REMOVED AND REPLACED THE NR 1 ENG HPT ACC IAW AMM 7SDR AALA2018112769031Battery · inoperativeCABIN EMERGENCY FLASHLIGHT WAS INOPERATIVE. REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-00.SDR AALA201811263004Transition Panel · corrodedLEFT TRANSITION PANEL HAD CORROSION AT BS 500C+6 TO 500I, STRINGER 24L. ACCOMPLISHED A SPLICE REPAIR IAW SRM 53-00-53-2R-5.SDR AALA201811263003Transition Panel · corrodedCORROSION ON THE RIGHT TRANSITION PANEL IN THE FORWARD CARGO BAY, BS 500D+7 - 500I, STRINGER 24R. ACCOMPLISHED A SPLICE REPAIR IAW SRM 53-00-53-2R-5.SDR AALA201811239028Bulkhead Web · crackedRIGHT WHEEL WELL BULKHEAD WEB WAS CRACKED. REPAIRED THE BULKHEAD IAW RD 57-10-10-9.SDR AALA201811239024Flashlight · inoperativeEMERGENCY FLASHLIGHT BENEATH FORWARD FLIGHT ATTENDANT JUMPSEAT WAS INOPERATIVE. REPLACED THE FLASHLIGHT IAW MM 25-64-00.SDR AALA2018112329001Oil Cooler · faultyTHE AIRCRAFT WAS GROUNDED. DURING CRUISE, WITH THE #1 INTEGRATED DRIVE GENERATOR ON MEL DEFERRAL, APU WARNING OIL PRESSURE LIGHT ILLUMINATED FOLLOWED BY APU AUTO SHUT DOWN. CAPTAIN NOTIFIED DISPATCH THE APU GENERATOR HAD FAILED AND IT WAS DETEREMINED TO DIVERTSDR AALA20181121006Plate · corrodedCORROSION FOUND ON THE SIDE PLATE LOCATED AT BS 500G-500I. REPLACED SIDE PLATE.SDR AALA20181121005Plate · corrodedCORROSION FOUND ON SIDE PLATE LOCATED AT BS 500A-500I. REPLACED SIDE PLATE.SDR AALA20181121004Plate · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION FOUND ON SIDE PLATE LOCATED AT BS 500-500I. REPLACED SIDE PLATE.
Back to Boeing 737-823