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 AALA201802199006Lens · missingEMERTENCY LIGHT LENS MISSING AT ROW 10DEF. INSTALLED THE LENS IAW AMM 33-51-03.SDR AALA201802199005Lens · missingSEAT 15D RED EMERGENCY LIGHT LENS MISSING. INSTALLED THE LENS IAW AMM 33-51-11. OK FOR SERVICE.SDR AALA20180303006Web · corrodedCORRODED WEB AT BS 984, RBL 33 TO RBL 41. REPLACED THE WEB IAW DRAWING 147A5700, AND 51-00-05-1.SDR AALA20180303004Floor Support · corrodedCORROSION ON THE NUT PLATE HOLE OF THE FLOOR SUPPORT IN FORWARD SERVICE WET AREA AT BS 325, RBL 11. REPLACED FLOOR SUPPORT IAW 51-00-05-1, AND DRAWING 141A5400.SDR AALA20180303003Angle · corrodedCORROSION FOUND ON THE AFT BULKHEAD TRANS ANGEL AT BS 500I. INSTALLED NEW TRANS ANGLE AND FASTENERS IAW 51-00-05-1, AND DWG:143A9485.SDR AALA201802199003Light · crackedEMERGENCY LIGHT AT THE R2 DOOR FOUND CRACKED. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-51-01.SDR AALA201802149018Lens · detachedEMERGENCY LIGHT LENS ON LOWER HALF OF FORWARD GALLEY WALL WON'T STAY ATTACHED. REPLACED THE LIGHT ASSEMBLY.SDR AALA201802149017Lens · missingEMERGENCY EXIT SIGN LENS IN THE AFT GALLEY FOUND MISSING. REPLACED SIGN IAW AMM 33-51-01.SDR AALA20180212007Skin · crackedINDICATIONS OF TWO CRACKS IN THE LOWER SKIN ON THE RIGHT HORIZONTAL STABILIZER HSS 101.90. REPAIRED THE HORIZONTAL STABILIZER SKIN IAW SRM 55-10-01-2R-11.SDR AALA20180212002Floor Panel · corrodedCORROSION FOUND ON THE RIGHT CARGO FLOOR PANEL. INSTALLED A REPAIR AND SPLICE PLATE IAW SRM 53-00-53-2R, PROCEDURE 5.SDR AALA20180212001Transition Panel · corrodedDEEP CORROSION FOUND ON THE LEFT TRANSITION PANEL IN THE FORWARD CARGO BAY, BS 500B + 10 - 500L. SPLICED IN A NEW SECTION OF TRANSITION PANEL IAW SRM 53-00-53-2R-5.SDR AALA201802149006Lens · brokenLENS BROKEN ON THE EXIT SIGN IN THE GALLEY. REPLACED THE LENS IAW AMM 33-51-01.SDR AALA20180211007Pitot Tube · defectiveLOSS OF CAPTAIN'S PITOT HEAT. EMERGENCY WAS DECLARED AND LANDED. THE AIRCRAFT WAS GROUNDED. REPLACED THE PITOT PROBE IAW AMM 34-11-01. TESTED NORMAL.SDR AALA201802159017Lens · missingL4 DOOR EMERGENCY EXIT LIGHT LENS IS MISSING. REPLACED THE LENS IAW AMM 33-50-00.SDR AALA201802149002Bladder · odorAIRCRAFT HAD VERY STRONG ACRID,OFFENSIVE ODOR COMING FROM FORWARD GALLEY AND FORWARD ENTRY AREA. ONE HOUR INTO FLIGHT THE THE WAS STILL PERVASIVE. THE AIRCRAFT WAS GROUNDED. ACCOMPLISHED SIC 05-96-70. FOUND FORWARD SILL DRAIN BLADDER THE CAUSE OF ODOR. RSDR AALA201802169001Lens · damagedEMERGENCY EXIT LIGHT LENS AT FWD ENTRY DOOR IS DAMAGED. REPLACED THE LENS.SDR AALA201802159012Lens · damagedEMERGENCY EXIT LIGHT COVER AT FORWARD ENTRY DOOR DAMAGED/DISLODGED. MAINTENANCE REPLACED EXIT LIGHT COVER AT FORWARD ENTRY DOOR AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802159011Lens · damagedEMERGENCY EXIT LIGHT COVER AT FORWARD ENTRY DOOR IS DAMAGED. REPLACED EXIT LIGHT COVER.SDR AALA201802149005Lens · brokenEMERGENCY EXIT LIGHT LENS ON THE RIGHT SIDE AT THE AFT GALLEY WAS FOUND BROKEN. REPLACED THE LENS IAW AMM 33-51-01, OPS CHECKED OK.SDR AALA201802209047Angle · corrodedR1 DOOR THRESHOLD ANGLE CORRODED. REPLACED THE ANGLE IAW SRM 51-40-02.SDR AALA201802149028Battery · dischargedFLASHLIGHT AT THE L1 DOOR, DISPLAYS A RED LED WHEN TESTED. REPLACED THE FLASHLIGHT BATTERY. OPS CHECK OK IAW MM 25-64-00.SDR AALA201802129002Smoke Warning · false activationAFT RIGHT LAVATORY SMOKE ALARM ACTIVATED DURING FLIGHT. FLIGHT ATTENDANTS INVESTIGATED AND FOUND NO SMOKE OR FIRE. RESET THE SMOKE ALARM AND SHUT OFF. MAINTENANCE PERFORMED A LAVATORY SMOKE DETECT TEST IAW MM 26-14-00, NO FAULTS NOTED.SDR AALA20180208007Web · corrodedCORROSION ON THE AFT CARGO DOOR THRESHOLD WEB, BETWEEN BS 793 AND 847. REPLACED THE WEB IAW SRM 53-60-15-1A.SDR AALA201802149001Battery · dischargedJUMPSEAT FLASHLIGHT LOW ON POWER. REMOVED AND REPLACED THE BATTERY. OPS CHECKED OK. OK FOR SERVICE IAW AMM 25-64-00.SDR AALA201802149004Battery · dischargedAFT FLIGHT ATTENDANT LEFT INBD SEAT FLASHLIGHT BATTERY LOW. REPLACED THE FLASHLIGHT IAW AMM 25-64-00-900-806.SDR AALA20180208008Angle · corrodedCORROSION FOUND ON THE RIGHT CREASE ANGLE RBL 50 BS 918-1006. REPLACED CREASE ANGLE IAW DRAWING 147A8540, 51-00-05, AND SRM 51-40-02.SDR AALA20180208004Web · corrodedCORROSION FOUND ON WEB AT BS 1016, RBL 33 TO 35. REPLACED THE WEB IAW DRAWING 147A5712-35, AND 51-00-05-1.SDR AALA201802149026Light · brokenEMERGENCY EXIT LIGHT BROKEN IN THE CABIN ACROSS FROM FRONT THE CLOSET AND RWD ENTRY AREA. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW WDM 33-51-12. OPS CHECKED GOOD.SDR AALA201802149025Lens · missingLENS MISSING FROM THE RIGHT AFT SERVICE DOOR EMERGENCY LIGHT. INSTALLED THE LENS IAW AMM 33-51-02, OPS CHECKED GOOD.SDR AALA20180207001Floorbeam · corrodedCORROSION WAS FOUND ON FLOORBEAM AT BS 993, RBL 33 - 46. INSTALLED A NEW FLOORBEAM IAW 51-00-05-1 AND DRAWING 147A5700.SDR AALA20180207002Floor Support · corrodedCORROSION ON THE FLOOR SUPPORT BETWEEN BS 990 AND 1016, RBL 33. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1 AND DRAWING 147A5700.SDR AALA201802099016Floor Support · crackedFLOOR SUPPORT CRACKED AT BS 312 - 328, LBL 45. INSTALLED A NEW FLOOR SUPPORT IAW DRAWING 141A5400, AND SRM 52-40-02.SDR AALA201802099015Floor Support · crackedFLOOR SUPPORT CRACKED AT BS 328 - 344, LBL 45. INSTALLED A NEW FLOOR SUPPORT IAW SRM 51-40-02.SDR AALA201802099014Floorbeam · crackedFLOORBEAM CRACKED AT BS 540, RBL 2. INSTALLED A FLOORBEAM IAW SRM 51-40-02.SDR AALA201802099002Floorbeam · crackedFLOORBEAM CRACKED AT BS 540, LBL 2. REPLACED THE FLOOR BEAM IAW ARM 51-40-02.SDR AALA201802089037Guide Arm · out of adjustL1 DOOR IS DIFFICULT TO CLOSE AND SEAL PROPERLY. ADJUSTED THE DOOR GUIDE ARM IAW AMM 52-11-00.SDR AALA201802089019Girt Bar · damagedTHE AIRCRAFT WAS NOT GROUNDED. GIRT BAR AT DOOR 1L HAS AFT PLASTIC CLIP BROKEN AND SOME SLIDE MATERIAL SHOWING. REMOVED AND REPLACED GIRT BAR RELEASE STOP ASSEMBLY AND REATTACHED GIRT VELCRO TO BACKING PAN ASSEMBLY PER AMM 25-66-01-000-804. OK FOR SERVICE.SDR AALA201802089017Light · detachedTHE AIRCRAFT WAS NOT GROUNDED. THE EXIT LIGHT FELL OFF THE 4L DOOR. REPLACED EMERGENCY LIGHT EXIT AT 4L DOOR PER AMM 33-53-01. OPERATIONS CHECK GOOD.SDR AALA20180206004Clamp · looseRECEIVED FUSION ALERT, RETURNED TO DEPARTURE. ADVISED THE AIRCRAFT HYDRAULIC SYSTEM A FAILED. AN EMERGENCY WAS DECLARED, AND LANDED WITHOUT INCIDENT. AIRCRAFT WAS GROUNDED. FOUND A CLAMP AT SYSTEM THE A RETURN FILTER MODULE ASSY LOOSE. INSPECTED THE FILSDR AALA201802089018Flashlight · not seatedCABIN FLASHLIGHT AND CRADLE, LEFT AFT CABIN JUMPSEAT. THE FLASHLIGHT DOES NOT FLASH WHEN TESTED. SEATED THE FLASHLIGHT. OPS CHECKED GOOD.SDR AALA201802089015Light · detachedEMERGENCY LIGHT AT SEAT 30D IS DANGLING AND PULLED OUT. PERFORMED AN OPS CHECK AND INSTALLED THE SEAT MOUNTED EMERGENCY LIGHT ASSEMBLY IAW MM 33-51-11. OK FOR FURTHER SERVICE.SDR AALA20180205001Floorbeam · corrodedCORROSION WAS FOUND ON BS 1016 FLOORBEAM, RBL 33 AND INBOARD OF G4 GALLEY MOUNT. REPAIRED THE FLOORBEAM TEE IAW EA 276639, AND SRM 53-70-51-2R-4.SDR AALA2018020879003Cover · crackedAIRCRAFT WAS NOT GROUNDED. RIGHT AFT DOOR VIEWING WINDOW HAS CRACK ON INNER PANE. REPLACED CRACKED DUST COVER ON RIGHT HAND SERVICE DOOR PER AMM 52-13-31.SDR AALA201802089004Smoke Detector · false activationFORWARD LAVATORY SMOKE DETECTOR ACTIVATED WITH NO SMOKE PRESENT. REPLACED THE FORWARD LAVATORY SMOKE DETECTOR IAW AMM 26-14-01.SDR AALA201802079007Lens · damagedEXIT SIGN LENS AT THE R2 DOOR WAS FOUND DAMAGED. REPLACED THE LENS IAW AMM 33-51-01.SDR AALA20180204010Seal · dislodgedDURING CLIMBOUT, FA STATED THE L1 DOOR WAS LEAKING. A LOUD AIR NOISE WAS COMING FROM L1 DOOR AREA, FORWARD CENTER HINGE SECTION. THE 1L DOOR SEAL WAS BLOWN. CONDITION CONFIRMED BY CAPTAIN. FOUND CENTER HINGE COVER DISLODGED, LIGHT SHOWING THROUGH THE OPENSDR AALA20180206003Light · inoperativeDURING AN OVER NIGHT INSPECTION, FOUND THE EMERGENCY LIGHT INOPERATIVE AT SEAT 30D. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-11. OPS CHECKED GOOD.SDR AALA201802079010Lens · missingEXIT SIGN LENS IS MISSING, AT THE LEFT AFT GALLEY DOOR. REPLACED THE EXIT SIGN LENS IAW 33-51-01.SDR AALA20180204007Skin · crackedCORRODED AND CRACKED RUDDER SKIN LOWER AFT CORNER. REPAIRED THE RUDDER SKIN IAW EA 276776, AND SRM 55-40-01.SDR AALA201802079009Lens · looseEXIT DOOR EMERGENCY LIGHT LENS IS LOOSE. REPLACED THE EXIT SIGN IAW 33-51-01.
Back to Boeing 737-823