Boeing 737-824
Service difficulty reports · 9,839
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 = '737824' 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 = '737824' 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 CALA2017090103002Light · brokenON CONDUCTING EA3351-01098 REV B, FOUND FIRST CLASS EMERGENCY EXIT AISLE LIGHT ASSY. BROKEN. REMOVED AND REPLACED FIRST CLASS AISLE CEILING EXIT LIGHT ASSY. AND MODIFIED LENS PER EA3351-01098 REV B. OPERATIONALLY TESTED NORMAL IAW AMM 33-51-00.SDR CALA2017090103001Lamp · inoperativeACFT RIGHT FWD OVERWING EMERGENCY EXIT DOOR EXTERIOR LIGHT INOP. REPLACED THE LAMPS IAW AMM 33-51-04 . OPS CHECKED NORMAL.SDR CALA2017090103000Charger · faultyEMERGENCY LIGHTS IN CENTER ASILE FROM ROW 7ABC/DEF TO 12 ABC/DEF WILL NOT TURN ON. FOUND BATTERY AND CHARGER FAULTING REPLACED CHARGER D717-02-030 PER AMM 33-51-06 OPS CHECK CHARGERSDR CALA2017090102984Unknown · odorSMOKE OR FUMES IN CABIN, SOURCE UNKNOWN. SMELLED FUMES/ODOR DURING DESCENT BELOW 18000 THRUST LEVER IDLE CREW DEBRIEF REVEALS, ODOR MORE OILY AND SMOKEY. ONLY DURING INITIAL DECENT. PERFORMED SMOKE ODOR IN FLT DECK/CABIN CHECK PER AMM 05-51-26. NO DEFECTS.SDR CALA2017090102999Lens · detachedCABIN AISLE EMERGENCY EXIT SIGN COVER BY BULKHEAD FELL OFF. INSTALLED LENSSDR CALA2017090102972Attach Angle · crackedCRACK FROM INBD FASTNER HOLE OF ATTACH CLIP BETWEEN STR 8L AND 9L AT BS 480. INSTALLED REPAIR ANGLES.SDR CALA2017090102969Bulkhead Web · gougedAFT PRESSURE BULKHEAD WEB HAS A 3 INCH PENETRATING GOUGE IN WEB AT LBL 20 AT APPROX. WL 234. REMOVED DAMAGE AND INSTALLED REPAIR DOUBLER AS PER ECRA 5310-072 04. INPECTION REQUIREMENT ON OR BEFORE 40,000 TOTAL AIRFRAME FLIGHT CYCLES.SDR CALA2017090102967Engine · contaminatedSMOKE OR FUMES IN CABIN, SOURCE UNKNOWN. FUMES ODOR IN COCKPIT DURING DECENT POWER AT IDLE. ALSO AFTER TAKEOFF. CHECKED BOTH ENGS ON ARRIVAL. FOUND THE NR 1 ENGINE EXCESSIVE FAN BLADE LUBRICANT AND ENGINE OIL LEVEL IS HIGH. WIPED OFF EXCESSIVE LUBRICANT ONSDR CALA2017090102961Unknown · odorELECTRICAL ODOR AT ROW 28 HAPPENED WITH SIDEWALL LIGHTS, OPENED CEILING PANELS AND DROPPED PSU. INSPECTED WIRING AND ELECTRICAL COMPONENT IN THE VICINITY. NO DEFECTS.NOTED.SDR CALA2017090102955Lens · brokenEMERGENCY EXIT COVER 18F BROKEN. REMOVED & REPLACED LIGHT LENS IAW AMM 33-51-01.SDR CALA2017090102979Stringer · corrodedPULLED RIVET ON RIGHT SIDE OF AIRCRAFT 13 RIVETS AFT OF PRODUCTION JOINT - INGESTION WARNING DECAL- BELOW WATER LINE.WILL MARK WI TH TAPE AND MARKER. BULGING SKIN WITH RIVET POPPING IS LOCATED AT APPROX STA 373 ON STRINGER 25R. SECTION 43. HOLE EDGES CAUSING BSDR CALA2017082802936Lens · loosePLASTIC EMERGENCY EXIT SIGNS FELL DOWN. SECURED SIGN LENS.SDR CALA2017082802911Skin Panel · crackedCRACK INDICATION FOUND AT RT H STAB LOWER INSPAR SKIN PANEL AT APPROX STAB STA 147.90 APPROX 9.500IN FROM REAR SPAR REF W/C EA5510-01843 OP. INSTALLED REPAIR DOUBLER AND FILLER AT RT H STAB LOWER INSPAR SKIN PANEL AT APPROX STAB STA 147.90 APPROX 9.5IN FROM RESDR CALA2017082502891Battery Pack · faultyEMERGENCY LIGHTS AT THE L2 DOOR AND AFT ROWS OF SEATS NOT ILLUMINATING DURING TEST. REMOVED AND REPLACED THE M1673 BATTERY PACK. OPS CHECKED GOOD. ALL LIGHTS ILLUMINATED IAW AMM 33-51-06.SDR CALA2017082502890Cover · looseRIGHT BOTTOM OF EMERGENCY EXIT WINDOW HANDLE CAME OFF. SECURED EXIT WINDOW COVERSDR CALA2017082502887Lens · brokenEMERGENCY EXIT SEAT LIGHT AT 23C IS BROKEN. REPLACED EMERGENCY EXIT SEAT LIGHT LENS AT 23C. LIGHT OPS CHECKED NORMAL.SDR CALA2017082502886Lamp · inoperativeRIGHT FWD EMERGENCY LIGHT OVERWING ROW 20F INOPERATIVE. REPLACED THE LAMPS. OPS GOOD, OK TO CONTINUESDR CALA2017082502870Oven · smokeSMOKEY ODOR REPORTED NEAR THE AFT LAVATORY, NO SIGN OF SMOKE OR FIRE. REMOVED AND REPLACED THE OVEN. OPS CHECKED NORMAL IAW AMM 25-34-00.SDR CALA2017082502859Attach Angle · crackedCRACK FROM INBD FASTNER HOLE OF ATTACH ANGLE BETWEEN STRINGERS 8L AND 9L, BS 480. REPAIRED IAW ECRA 5310-07203.SDR CALA2017082502858Attach Angle · crackedCRACK FROM INBD RIVET HOLE FOR PSEU ATTACH ANGLE BETWEEN STR 8R AND 9R AT BS 727B. REPAIRED IAW ECRA 5310-07197.SDR CALA2017082502857Attach Angle · crackedCRACKED FROM INBD RIVET HOLE OF PSEU ANGLE BETWEEN STR 8R AND 9R AT BS 747. CUT OUT CRACK DAMAGE AT IB RIVET HOLE OF PSEU ANGLE INSTALLED REPAIR ANGLES, IAW ECRA 5310-07197.SDR CALA2017082502856Attach Angle · crackedCRACK FROM INBD RIVET HOLE OF PSEU ATTACH ANGLE BETWEEN STRINGERS 8 AND 9R, BS 727I. INSTALLED A NEW ATTACH ANGLE IAW ECRA 5310-07197.SDR CALA2017082102835Charger · malfunctionedFIRST CLASS EMERGENCY LIGHTS ILLUMINATED AFTER POWER TRANSFER AND REMAINED ON. RESETTED POWER TO FWD AND AFT L AFT R EMER CHARGERS, LIGHTS RESE TTED ALL NORMAL IN ARM POSITIONSDR CALA2017082102834Lens · missingEMERGENCY LIGHT LENS MISSING AT FWD CABIN NEAR CLOSET 712 REMOVED AND REPLACED MONUMENT LIGHT REF IPC 25-20-23 ITEM 165. CKS GOOD.SDR CALA2017082102832Light · brokenAFT RED EMERGENCY SEAT LIGHT INOPERATIVE AT 20C. REPLACED BROKEN RED EMERGENCY SEAT LIGHT ASSY. EMERGENCY EXIT SEAT LIGHTS OPS CHECK NORMAL.SDR CALA2017082102831Battery Pack · inoperativeLEFT CABIN BOTH FWD & AFT EMERGENCY EXIT DOOR UPPER LIGHTS INOPERATIVE AND BOTH FWD EMERGENCY EXIT DOOR LOWER LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK M1694. OPS CHECKED OK.SDR CALA2017082102804Failsafe · crackedAFT CARGO BAY FAILSAFE AT BS 847, STRINGER 20L CRACKED. REPAIRED IAW ECRA 5311-01874.SDR CALA2017082102803Structure · corrodedAFT CARGO BAY AT BS 847 BEETWEEN STRINGERS 27L AND 27R IS CORRODED ON THE FWD SIDE. REPAIRED IAW ECRA5311- 01872.SDR CALA2017082102798Frame · bentFWD CARGO FRAME IS BENT AT BS 500G BETWEEN STRINGERS 23 AND 24R. THE FRAME WAS REPAIRED IAW ECRA 5311-01871.SDR CALA2017081802785Lens · missingMID CABIN EMERGENCY EXIT LENS COVER MISSING. REPLACED LENS COVER.SDR CALA2017081802784Sign · looseONE HALF OF MID CABIN EMERG EXIT SIGN IS MISSING. RE-ATTACHED FWD HALF OF MID CABIN EMERG EXIT SIGN.SDR CALA2017081802783Power Supply · inoperativeEMERGENCY AISLE LIGHTS ROW 36,37,38 ABC INOP. REMOVED AND REPLACED ''M1672'' EMERGENCY POWER SUPPLY W/ BATTERY PACK PER WDM REF 33-51-12 AMM REF 33-51-06. OPERATIONALLY TEST NORMAL AT THIS TIME.SDR CALA2017081802781Battery Pack · dischargedM1694, M1695, M1676, M1671 EMERGENCY LIGHTS POWER SUPPLY BATTERIES FAIL CAPACITY CHECK PER W/C 29-3350-1-7100. REPLACED CHARGER ASSY M1671 IAW AMM 33-51-06. REPLACED BATTERY PACKS IN CHARGERS M1671, M1676, M1694, M1695 IAW AMM 33-51-06.SDR CALA2017081802782Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT IS INOP. REPLACED BULB OPS CHECK OK.SDR CALA2017081802742Light · inoperativeOVERHEAD INTERIOR EMERGENCY LIGHT INOPERATIVE, ROW 7 CBA. REPLACED LIGHT ASSY. OPS CHECKED NORMAL.SDR CALA2017081802731Skin · dentedL1 DOOR INTERNAL SKIN AND FRAME IS BENT AND HAS A GOUGE AT AFT NR 5 STOP FROM THE TOP. REPAIRED THE DOOR SKIN AND FRAME IAW ECRA 5210-02920.SDR CALA2017081802730Frame · dentedFWD CARGO BAY FRAME AT BS 500F IS DENTED BELOW STRINGER 23R. REPAIRED THE FRAME IAW ECRA 5310-07195.SDR CALA2017081802729Frame · dentedFWD CARGO BAY RT FRAME AT BS 500H IS DENTED BETWEEN STRINGERS 23R - 24R. REPAIRED IAW ECRA 5310-07193.SDR CALA2017081802727Floorbeam · corrodedCABIN BS 986.5, BETWEEN RBL 22 AND RBL 44, FLOORBEAM TEE HAS CORROSION AROUND FASTENER HOLES. INSTALLED A REPAIR IAW SRM 53-00-51, REPAIR 1, AND EC/RA 5321-0130, REV B.SDR CALA2017081802719Skin · crackedFOUND A CRACK AT THE RT HORIZONTAL STAB LOWER SKIN HSS 101.90 AND 11 INCHES FROM AFT SPAR. REPAIRED IAW SRM 55-10-01, REPAIR 11.SDR CALA2017081402700Charger · inoperativeOVERHEAD INTERIOR EMERGENCY LIGHTS INOPERATIVE, ROWS 12BCA AND 11FED. REPLACED EMERGENCY LIGHT CHARGER ASSEMBLY. OPS CHECKED GOOD IAW AMM 33-51-06-960-806.SDR CALA2017081402701Light · missingEMERGENCY EXIT LIGHT AT SEAT 10C MISSING.SDR CALA2017081402699Lens · missingSMALL EMERGENCY SIGN AT ROW 21A MISSING. INSTALLED A NEW LENS.SDR CALA2017081402683Motor · odorBURNING ODOR AT ROWS 23-25, TV ANTENNA MOTOR ABOVE ROWS 23-25 DEACTIVATED NO ODOR, COLLARED ANTENNA BREAKERSDR CALA2017081102622Charger · inoperativeMID EMERGENCY LIGHT INOPERATIVE. REMOVED & INSTALLED A SERVICEABLE EMERGENCY BATTERY CHARGER ASSY. OPS CHECKED GOOD, NO FAULTS NOTED.SDR CALA2017081102621Lens · detachedEMERGENCY EXIT SIGN LENS BY SEAT 25 FELL OFF. SECURED THE LENS.SDR CALA2017081102620Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE, RT SIDE AFT OF OVERWING EXITS. REPLACED THE BATTERY PACK AT POWER SUPPLY M1671. ALL EMERGENCY LIGHTS OPERATE NORMAL, INTERIOR AND EXTERIOR.SDR CALA2017081102619Battery · inoperativeEMERGENCY FLASHLIGHT BATTERY AT THE R2 DOOR INOPERATIVE. REPLACED THE BATTERY. CHECKED GOOD. OK FOR SERVICE.SDR CALA2017081102618Lens · detachedEMERGENCY LIGHT LENS AT EXIT ROW AISLE FELL OFF. REINSTALLED THE LIGHT LENS.SDR CALA2017081102601Coffeemaker · meltedCOFFEE MAKER DAMAGED, PLASTIC MELTED ON WARMER BURNER CAUSES ODOR. CLEANED. NO ODOR NOTED.
Back to Boeing 737-824