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 AALA20180413010Floor Support · corrodedAFT CARGO, BS 847 - 787 FLOOR SUPPORT CORRODED INBOARD OF WEB, RIGHT SIDE. REPLACED THE FLOOR SUPPORT IAW DRAWING 146A8128, 51-00-05, AND EA 279462, DRAFT 2.SDR AALA2018041700009Angle · corrodedAFT CARGO, RIGHT TRANSITION ANGLE HAS CORROSION AT BS 867. REPLACED THE ANGLE IAW SRM 53-00-53.SDR AALA201804179018Smoke Detector · false activationLAVATORY SMOKE LIGHT ILLUMINATED IN FLIGHT. FLIGHT ATTENDANTS REPORT NO SMOKE IN RIGHT AFT LAVATORY OR ANY INDICATION THAT A PAX HAD SMOKED. WATER HEATER WAS FAR HOTTER THEN THE LEFT AFT LAVATORY. FLIGHT ATTENDANTS TURNED OFF THE RIGHT AFT WATER HEATER. INSPECSDR AALA20180412003Floorbeam · corrodedCORRODED FLOORBEAM AT BS 986.5, LBL 4. REPAIRED THE FLOORBEAM IAW SRM 53-00-51.SDR AALA20180412002Angle · corrodedLEFT CREASE BEAM ANGLE CORRODED BETWEEN BS 948 TO 996 AT LBL 50. REPLACED THE CREASE BEAM ANGLE IAW 51-00-05.SDR AALA201804169014Light · damagedAIRCRAFT IN BASE MAINTENANCE. THE EMERGENCY LIGHT AND RED LENS MISSING FROM SEAT 14D. REPLACED THE LIGHT AND LENS.SDR AALA201804169009Lens · missingAIRCRAFT IN BASE MAINTENANCE. THE EMERGENCY LIGHT AND RED LENS MISSING FROM SEAT 14D. REPLACED THE LIGHT AND LENS.SDR AALA201804180008Doubler · wornOUTBOARD LATCH DOUBLER FOR PNEUMATIC DOOR, IN THE RIGHT AIRCRAFT BAY IS WORN. REPAIRED THE DOUBLER IAW SRM 57-10-13-2R, AND EA #278971.SDR AALA20180411006Mount · corrodedFORWARD ENTRY FORWARD GIRT BAR FITTING MOUNT CORRODED AT BS 312, LBL 54. REPLACED GIRT BAR MOUNT IAW SRM 51-40-02.SDR AALA20180411005Mount · corrodedFORWARD ENTRY AFT GIRT BAR FITTING MOUNT CORRODED AT BS 344 AND LBL 59. REPLACED THE GIRT BAR MOUNT IAW SRM 51-40-02.SDR AALA20180411004Crease Beam · corrodedRIGHT CREASE BEAM ANGLE CORRODED BETWEEN BS 308 AND 337. REPLACED CREASE BEAM ANGLE IAW DRAWING 141A8310, AND 51-00-05-1.SDR AALA201804159004Smoke Detector · false activationLEFT AFT LAVATORY SMOKE DETECTOR IS GOING OFF WITHOUT SMOKE. TESTED SMOKE DETECTOR IAW AMM 26-14-00.SDR AALA20180411003Intercostal · crackedINTERCOSTAL BETWEEN BS 277 TO 294.5, CRACKED AT FASTENER HOLE. INSTALLED A NEW INTERCOSTAL IAW SRM 51-40-02.SDR AALA201804139004Flashlight Assy · missingCABIN EMERGENCY FLASHLIGHT AND HOLDER MISSING. INSTALLED A NEW EMERGENCY FLASHLIGHT AT FORWARD FLIGHT ATTENDANT JUMPSEAT IAW AMM 25-64-00.SDR AALA20180410012Channel · corrodedCORROSION WAS FOUND ON THE FORWARD CARGO LEFT TRANSITION PANEL CHANNEL AROUND THE OUTBOARD FASTENER HOLES, BETWEEN BS 410 AND 500C. INSTALLED A NEW TRANSITION PANEL CHANNEL IAW SRM 53-00-53-2R-6.SDR AALA20180410013Transition Panel · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION ON FORWARD CARGO LEFT HAND TRANSITION PANEL AT STATIONS 500H AND 500I. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R5.SDR AALA20180410010Web · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. LEFT HAND MOON WEB CORRODED AT STATION 1010. REPLACED WEB PER 51-00-05 AND DRAWING 147A5712.SDR AALA20180410016Strap · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION FOUND ON THE LEFT HAND INSULATION RAIL IN THE APU COMPARTMENT. REMOVED CORROSION AND INSTALLED FABRICATED STRAPS PER EA 278854.SDR AALA20180410014Rib · crackedAIRCRAFT WAS GROUNDED. VERTICAL RIB CRACKED INSIDE RIGHT HAND HORIZONTAL STABILIZER 27 INCHES IN FROM INBOARD END OF 2ND RIB FROM FORWARD EDGE. INSTALLED DOUBLER REPAIR ON RIB PER SRM 55-10-09-2R.SDR AALA201804119021Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT 25D EMERGENCY LIGHT ABOVE OVERHEAD BIN HAS MISSING LENS. REPLACED MISSING LENS ON EMERGENCY LIGHT ABOVE 25D PER AMM 33-51-00.SDR AALA20180410007Frame · crackedFORWARD GALLEY DOOR STUB FRAME CRACKED WHERE IT MOUNTS TO CREASE ANGLE. INSTALLED DOUBLER AND SPACER AT FORWARD GALLEY STUB DOOR FRAME IAW SRM 51-70-11-2R.SDR AALA20180409008Doubler · crackedRIGHT ENVIRONMENTAL CONTROL SYSTEM BAY PACK EXHAUST DUCT DOUBLER CRACKED ON AFT INBOARD FLANGE. REPLACED DUCT DOUBLER IAW 51-00-05-1.SDR AALA201804129003Acm · odorDURING DESCENT FROM FL 180 TO APPROXIMATELY 16,000, THERE WAS A SLIGHT OIL ODOR. CABIN REPORTED A PLASTIC ODOR. ACCOMPLISHED MCM CARD 05-96-70. REPLACED THE LEFT AIR CYCLE MACHINE IAW AMM 21-51-04. NO ODOR NOTED.SDR AALA20180411009Floor Support · corrodedAFT CARGO BAY, CORROSION FOUND ON THE FLOOR SUPPORT, BS 767+3 BOTTOM SIDE. REPLACED THE FLOOR SUPPORT IAW SRM 51-10-02.SDR AALA201804119020Shade · damagedAIRCRAFT WAS NOT GROUNDED. SEAT 15A WINDOW SHADE TO EMERGENCY EXIT DAMAGED. REPLACED SEAT 15A WINDOW SHADE EMERGENCY EXIT PER AMM 25-21-12 AND 52-22-51.SDR AALA20180409001Angle · crackedFORWARD CARGO BAY BAFFLE ANGLE IS CRACKED BELOW THE LEFT TRANSITION PANEL ON THE FORWARD SDIE OF BS 510H. REPLACED THE ANGLE IAW SRM 51-40-02.SDR AALA20180409002Angle · crackedANGLE CRACKED BELOW THE LEFT TRANSITION PANEL ON AFT SIDE AT BS 500H. REPLACED THE ANGLE IAW SRM 51-40-02.SDR AALA20180408010Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR SUPPORT AT STATION 951, RBL 17 TO RBL 20. REPLACED FLOOR SUPPORT PER BOEING DRAWINGS #147A5760 AND #147A5650, AND AARD 51-00-05-1.SDR AALA20180408006Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR SUPPORT AT STATION 994 TO STATION 1015, RBL 31. REPLACED FLOOR SUPPORT PER AARD 51-00-05 AND BOEING DRAWING #147A5710.SDR AALA20180408002Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR SUPPORT FROM STATION 950 TO STATION 958, LBL 51 TO LBL 52. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1 AND BOEING DRAWING #147A5660.SDR AALA201804109023Lens · damagedAISLE EMERGENCY LIGHT LENS AT ROW 8 ABC IS DAMAGED. REPLACED THE LENS IAW AMM 33-21-03.SDR AALA20180408007Floorbeam · corrodedCABIN FLOORBEAM TEE AT BS 986 FROM LEFT HAND CREASE ANGLE TO RIGHT HAND CREASE ANGLE CORRODED OUT OF LIMITS IN SEVERAL AREAS. REPAIRED THE TEE IAW SRM 53-70-51-2R-4.SDR AALA20180408005Skin · crackedCRACK IN THE RIGHT HORIZONTAL STABILIZER LOWER SKIN AT HSS 129.5, APPROXIMATELY 18 INCHES AFT OF FRONT SPAR. REPAIRED THE HORIZONTAL STABILIZER LOWER SKIN IAW SRM 55-10-01-2R.SDR AALA20180408009Floor Support · damagedAIRCRAFT IN BASE MAINTENANCE. CABIN FLOOR SUPPORT HAS ELONGATED HOLE AT ATTACH HOLE AT STA 950 BETWEEN LBL 29 TO LBL 54. REPLACED FLOOR SUPPORT PER 51-00-05-1.SDR AALA20180408012Floor Support · crackedCABIN FLOOR SUPPORT CRACKED, BS 320, LBL 46. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA20180408004Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE. CABIN FLOORBEAM CORRODED AT BS 994, LBL 33 TO LBL 34. REPLACED THE FLOORBEAM IAW 51-00-05-1.SDR AALA2018042617008Stiffener · corrodedCORROSION ON TEE STIFFENER LOCATED IN THE APU COMPARTMENT ON THE OUTBOARD SIDE OF THE APU INLET DUCT RIGHT SIDE.SDR AALA201804109029Megaphone · inoperativeMEGAPHONE INOPERATIVE. REPLACED THE MEGAPHONE IAW MM 25-64-00.SDR AALA201804099026Shade · bindsTHE AIRCRAFT WAS NOT GROUNDED. SEAT 14 DEF EMERGENCY SHADE WILL NOT FULLY EXTEND. REMOVED AND REPLACED WINDOW SHADE AT SEAT 14 PER AMM 25-21-12. OPERATIONS CHECK GOOD.SDR AALA20180407009Floor Support · corrodedAFT CABIN FLOOR SUPPORT CORRODED BETWEEN BS 991 TO 1016, LBL 31. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201804109017Light · damagedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT LENS OFF IN FORWARD GALLEY. FOUND LENS AND LIGHT ASSEMBLY DAMAGED. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY. OPERATIONS CHECK GOOD PER MM 33-00-00.SDR AALA201804109018Cover · missingAIRCRAFT WAS NOT GROUNDED: EXIT SIGN COVER MISSING IN AISLE CLOSE TO GALLEY JUST ABOVE AISLE FLOOR. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-14 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180406007Panel · corrodedAFT CARGO, INNER SIDE OF THE AFT LAVATORY SERVICE PANEL IS CORRODED AT THE LOWER END. INSTALLED A NEW LAVATORY PANEL INNER ASSEMBLY IAW 51-00-05-1, DRAWING 146A7400, AND EA.278489.SDR AALA20180409005Transition Panel · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT CORROSION ON LEFT HAND TRANSITION PANEL AT STATIONS 727E-847. REPLACED LEFT HAND TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA20180409006Transition Panel · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT CORROSION ON RIGHT HAND TRANSITION PANEL AT STATIONS 727D-727E. REPLACED TRANSITION PANEL PER SRM 53-00-53-R1.SDR AALA20180406006Sensor · faultedAPU INOPERATIVE. EMERGENCY DECLARED LANDED WITHOUT FURTHER INCIDENT. THE AIRCRAFT WAS GROUNDED. RAN APU FOUND NO CURRENT FAULTS IN BITE HISTORY, FOUND FAULT 49-61259. FOLLOWED FIM 49-60-0-810-817. R & R THE SPEED SENSOR IAW AMM 49-61-21. OPS CHECKED GOSDR AALA20180405004Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFTHAND TRANSITION "Z" ANGLE FOR FLOORBOARD SUPPORT FROM STATION 500D TO AFT WALL OF FORWARD CARGO. REPLACED "Z" ANGLE PER 51-00-05-10 AND SRM 53-00-53-2R AND DRAWING 143A7501.SDR AALA20180405005Web · corrodedAIRCRAFT IN BASE MAINTENANCE. RIGHT HAND HALF MOON WEB CORRODED AT STA 1012. REPLACED WEB PER 51-00-05 AND DRAWING 147A5712.SDR AALA201805175003Floorbeam · corrodedFORWARD CARGO, NUMEROUS CORROSION AREAS ON FLOORBEAM AT THE AFT BULKHEAD, BS 500I. REPLACED FLOORBEAM IAW 51-00-05.SDR AALA201804069006Lens · missingEMERGENCY LIGHT LENS BY THE R4 DOOR IS MISSING. REPLACED EMERGENCY LIGHT IAW AMM 33-51-01-960-802. OPS TESTED GOOD, OK FOR SERVICE.
Back to Boeing 737-823