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 CALA2017051201365Pin · looseLEADING EDGE SLATS TRANSIT LIGHT STAYS ON 4. EMERGENCY DECLARED. FOUND CONNECTOR SECURE D40160P. DURING PERFORMING T/S FOUND INTERMITTENT FAULT SHOWING F4 PROX. EXTEND SENSOR SHOWING FAR WHEN SLATS EXTENDED, WHEN LOCATING WIRES 2152R-24/2152B-24 AT CONNECTOR DSDR CALA2017051201350Skin · crackedR/H HORIZ STAB LOWER INSPAR SKIN HAS A .500 CRACK AT STA 157.10 APPROX 8" FROM REAR SPAR REF EA 5510-01843 REV E VERIFIED CRACK WITH HFEC NDT PART 6 51-0100 PROCEDURE 23 R/H HORIZ STAB LOWER INSPAR SKIN AT STA 157.10 8" FROM REAR SPAR HAS BEEN REPAIRED IAW SRSDR CALA2017051201348Skin · crackedLEFT HORIZONTAL STAB LOWER IN SPAR SKIN HAS A .500 CRACK AT HSS 101.90, 11 INCHES FROM REAR SPAR. VERIFIED CRACK WITH HFEC NDT PART 6 51-0-00 PROCEDURE 23. THE SKIN WAS REPAIRED IAW SRM 55-10-01, REP 11.SDR CALA2017050801315Sign · missingAISLE EMERGENCY EXIT SIGN ABEAM OF ROW 25 MISSING. INSTALLED THE EXIT SIGN IAW AMM 33-51-01.SDR CALA2017050801314Lamp · inoperativeEMERGENCY EXIT LIGHT OVER SEAT 14D INOPERATIVE. REPLACED THE LAMP, CHECKED GOODSDR CALA2017050501284Slide · looseESCAPE SLIDE PACK BUSTLE LOOSE. REMOVED AND REPLACED R2 DOOR SLIDE IAW AMM 25-66-01 PAGEBLOCK 40 1 AND 25-66-01-400-801,ALL NORMAL.SDR CALA2017050501283Light · defectiveEMERGENCY EXIT SIGN DOES NOT TURN OFF 21A. REPLACED LAMP, OP CK OK.SDR CALA2017050101218Sign · missingMISSING EMERGENCY EXIT SIGN LOCATED NEXT TO AFT LEFT LAVATORY. REPLACED WITH A NEW LIGHT. FUNCTIONED NORMAL.SDR CALA2017050101217Light · inoperativeEMERGENCY LIGHT DOES NOT TURN ON 20C EXIT. ILLUMINATION LIGHT OFF NEXT TO SEAT 20C ROW 20C. ONE RED SEAT MOUNT RED EMERGENCY LIGHT INOPERATIVE. REPLACED THE RED EMERGENCY LIGHT ASSY AT ROW 20ABC. OPS CHECKED GOOD.SDR CALA2017050101203Unknown · odorMOMENTARY ODOR OF OVERHEATING ELECTRONICS SEAT 20C. LASTED 10 MINUTES, THEN DISSAPATED. PERFORMED AMM TASK 05-51-26-800-801C1 THRU STEP C(2)(F)(1). NO SMOKE ODOR IN FLIGHT DECK OR CABIN NOTICED AT THIS TIME. PERFORMED HIGH POWER ENGINE RUN WITH PACKS ON ENG BSDR CALA2017050101216Light · loose20C LOOSE WIRE RED REFLECTOR LIGHT REMOVED AND REPLACED EMERGENCY LIGHT ASSY AND LENS OPS CHECKS GO OD.SDR CALA2017050101215Lens · missingRIGHT AFT DOOR EMERGENCY EXIT LENS MISSING . SECURED THE LENS.SDR CALA2017050101214Battery · inoperativeEMERGENCY EXIT LIGHT AFT OF RIGHT AFT EMERGENCY EXIT DOOR INOPERATIVE. REMOVED AND INSTALLED SERVICEABLE EMERGENCY LIGHT POWER SUPPLY BATTERY ON POWER SUPPLY M1671 IAW AMM 33-51-06-960-805. OPERATIONAL CHECK GOOD.SDR CALA2017042901196Beam · crackedR1 DOOR BEAM CRACKED. THE DOOR FRAME WAS REPAIRED IAW EC/RA 5210-02823.SDR CALA2017042801182Battery · dischargedFWD DOOR 1L EMERGENCY FLASHLIGHT NOT WORKING AND INSTALLED UPSIDE DOWN, FOUND FLASHLIGHT MOUNT UPSIDE DOWN. REPOSITIONED AND REPLACED FLASHLIGHT BATTERY FOR NONFUNCTIONING BLINKING RED LIGHT.SDR CALA2017042801183Lens · brokenEMERGENCY LIGHT LENS BROKEN AT SEATS 20C AND 31C. REPLACED LENS.SDR CALA2017042801181Light · inoperativeLEFT FWD EMERGENCY OVERWING LIGHT INOP RELAMPED, OPS CKD NORMAL. OK TO CONTINUE.SDR CALA2017042801180Sign · unsecureEMER EXIT SIGN AT ROW 26 CAME OFF. REINSTALLED EMER EXIT SIGN ROW 26.SDR CALA2017042801179Lens · missing2R DOOR CAP ABOVE EXIT LIGHT IS MISSING. INSTALLED NEW EMERGENCY LIGHT LENS AT 2R.SDR CALA2017042801149Engine · flamed outENGINE FLAMEOUT, ENGINE RESTART NOT ATTEMPTED. RECORD ENGINE CONDITION. ENG1 FAILED DURING TAXI IN TO GATE IN MMUN DURING ENG2 SHUTDOWN. PERFORMED EEC 1 BITE TEST PER FIM 73-00-00-810-801-F00. SHOWING FAILURE MESSAGES 73-31441, 73-31351 & 74-30971. PERFORMED ASDR CALA2017042801144Skin · crackedLT HORIZ STAB LOWER SKIN CRACKED 2 PLACES STA 147.9 APPROX 16" AND 24.5" AFT OF FRONT SPAR. CATEGORY B REPAIR INSTALLED PER SRM 55-10-01, REPAIR 11.SDR CALA2017042801143Skin · crackedLT HORIZ STAB LOWER SKIN CRACKED AT STA 129.5 APPROX 9.5" AFT OF FRONT SPAR. CATEGORY B REPAIR INSTALLED PER SRM 55-10-01, REPAIR 11.SDR CALA2017042801142Strap · gougedINNER FAIL SAFE STRAP AT FRAME 794.37 HAS DEEP GOUGE ON UPPER SURFACE BETWEEN STR 25RT AND 26RT. REMOVED AND REPLACED FAIL SAFE STRAP AT FRAME 794.37 AFT CARGO BIN RT SIDE FWD OF CARGO DOOR REF SRM 51-40-02.SDR CALA2017042801137Fire Loop · faultyENG 1 OVERHEAT LIGHT IS ON LEFT ENGINE OVERHEAT REDUCED POWER PER QRH LIGHT EXTINGUISHED. EMERGENCY DECLARED. PERFORMED LEAK CHECK ON ENGINE 1 PNEUMATICS, NO LEAKS FOUND. FOILED BLEED DUCTS AND PERFORMED HIGH POWER RUN. NO FAULTS. REPLACE D 4 ENGINE FIRE LOOPSSDR CALA2017042301117Static Port · contaminatedSTANDBY ALTIMETER PROBLEM INDICATES 280 FEET LOW AT FL 370 SPEED .762/ IAS 247 AT FL350 280 FT LOW DRAINED WATER FROM ALTERNATE STATIC PORT. GROUND OPS CHECK GOOD PER MM 34-24-00-730-801. CDS/STANDBY WITHIN LIMITS AS PER EC3410 -01670.SDR CALA2017042101100Light · brokenAFT EMERGENCY EXIT SEAT LIGHT AT 15C BROKEN. REPLACED BOTH LIGHT BULBS AND LENS. EMERGENCY EXIT LIGHTS AT 15C OPS CHECK NORMAL.SDR CALA2017042101099Battery Pack · dischargedRIGHT SIDE AFT OF WING LOWER BODY EMERGENCY LIGHT OUT/INOP REPLACED FUSES AND BATTERY PACK M1670 PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR CALA2017042101101Lens · brokenEMERGENCY EXIT SEAT LIGHT AT 29C BROKEN. REPLACED SEAT EXIT LIGHT LENS, OPS NORMAL.SDR CALA2017042101102Lamp · inoperativeEXTERIOR EMERGENCY LIGHT AFT OF THE R2 DOOR FOUND INOPERATIVE. REPLACED THE LAMPS, OPS NORMAL.SDR CALA2017042101052Spring · bentAFT CARGO LIGHT ILLUMINATED AFTER TAKE OFF. EMERGENCY DECLARED. FOUND AFT CARGO DOOR HANDLE RETRACT SPRING BENT AND OUT OF PLACE. INSTALLED A NEW SPRING IAW CMM 52-36-12. AFT CARGO DOOR HANDLE OPS NORMAL IAW AMM 52-31-14-400-801SDR CALA2017042101051Transmitter · faultyFLAP POSITION INDICATOR HAS NEEDLES SPLIT. EMERGENCY DECLARED. REMOVED AND REPLACED LEFT FLAP POSITION TRANSMITTER IAW MM 27-58-01-000-801, OPS CHECKED GOOD.SDR CALA2017042101046Unknown · odorCABIN CREW REPORTED A FAINT SMOKE LIKE ODOR IN FWD GALLEY, THE ODOR DISSIPATED QUICKLY. NO OTHER ISSUES NOTED. OK TO CONTINUE.SDR CALA2017042101070Skin · crackedBS 540, RT SKIN HAD A CRACK INDICATION BETWEEN STRINGER 22 AND 23R. REPAIRED THE SKIN IAW EA 5310-05878, OPS 5, REV D.SDR CALA2017041701042Light · unsecureROW 34ABC SEAT EMERG LITE HANGING OUT. R&R EMERG LITE ASSY. OPS CHK OK ITEM CLRD.SDR CALA2017041701045Fuse · blownEMERGENCY EEL LITES INOP ROWS 15-21. ROW 20L AND 20R EMERGENCY EXIT SIGN LITES INOP. REPLACED BLOWN FUSES, CHECKS NORMAL.SDR CALA2017041701044Cover · looseEMERGENCY EXIT SIGN BROKEN OFF, MISSING A LATCHING MECHANISM. RE-INSTALLED OVERHEAD EMERGENCY EXIT SIGN COVER. OK TO CONTINUE.SDR CALA2017041701041Battery · discharged2 SEGMENTS OF EMERGENCY LIGHTS OUT. R&R BATTERY IN AFT GALLEY AND UNDER 8TH WINDOW FROM EMERGENCY EXIT. OP CHECK GOOD. REF AMM 33-51-06.SDR CALA2017041401012Battery · dischargedFLASHLIGHT LED DOES NOT TURN ON. REPLACED BATTERY-EMERGENCY FLASHLIGHT DOOR 1L.SDR CALA2017041401011Light · inoperativeEMERGENCY LIGHTS AT SEAT ROW 20ABC AND BETWEEN SEAT ROWS 28DEF AND 29DEF IN BULLNOSE INOP. RELAMPED EMERGENCY LIGHTS AT SEAT ROW 20ABC AND BETWEEN SEAT ROWS 28DEF REF 33-42-02-960-801. OPS CHECK NORMAL.SDR CALA2017041401010Battery · dischargedFLASHLIGHT BATTERY LOW FWD FA FLASHLIGHT LIGHT DOES NOT BLINK. REPLACED POWER UNIT, EMERGENCY FLASHLIGHT PER MM 25-64-00-900-806 OPS CHECK NORMAL AT THIS TIMESDR CALA2017041400967Skin · dented2 DENTS ON AFT CARGO DOOR SKIN 5" FROM LOWER EDGE AND 7" AND 10" FROM FWD EDGE. FIRST DENT IS OUT OF LIMITS PER SRM 52-30-01, PAGE 109, DETAIL "F" W=1.0", Y=.045" W/Y= 22 RATIO MUST & GT; 30. ACCOMPLISHED DOUBLER REPAIR REF SRM 52-00-01 REPAIR 3.SDR CALA2017041000961Battery Pack · dischargedAFT DOOR EMERGENCY LIGHTS AND VARIOUS EMER LIGHTS ON LEFT OF AIRCRAFT ARE INOP. REMOVED AND REPLACED AFT EMERGENCY BATTERY PACK PER AMM 33-51-06. OPS CHECK GOOD.SDR CALA2017041000960Flashlight · inoperativeL2 DOOR INBOARD EMERGENCY FLASHLIGHT INOP. REPLACED FLASHLIGHT PER AMM 25-64-00. OPS CHECK OK.SDR CALA2017041000959Cover · missingEMER EXIT SIGN IS MISSING AT DOOR 2L. REPLACED EMER EXIT COVER, OPS CHECK GOOD.SDR CALA2017040900929Unknown · odorAFTER TAKEOFF HAD ODOR IN AIRCRAFT OF DIRTY SOCK SMELL IN DUCTING IN ALL OF AIRCRAFT. EMERGENCY DECLARED. ACCOMPLISHED SMOKE ODOR PROCEDURE PER MM 05-51-26-800-801C1 NO ODOR AFTER EXTENSIVE ENGINE RUN.SDR CALA2017040700920Light · looseEMERGENCY FLOOR PROXIMITY LIGHT DOES NOT TURN ON. EMERG LIGHT AT 15C DAMAGED, SECURED EMERGENCY LIGHT AT 15C. PERFORMED OPS CHECK OF EMERGENCY LIGHTING IAW MM 33-51-00 WITH NO DEFECTS NOTED.SDR CALA2017040700878Skin · crackedHORIZONTAL STAB LOWER IN SPAR SKIN HSS 129.50, FOUND CRACKED ABOUT 18 INCHES FROM AFT SPAR. THE SKIN WAS REPAIRED IAW SRM 55-10-01, REP 11.SDR CALA2017040700876Stringer · dentedSTRINGER 2L DENTED AT BS 445. ACCOMPLISHED A REPAIR IAW EC/RA 5310-07109.SDR CALA2017040700862Skin · crackedHORIZONTAL STAB LOWER IN SPAR SKIN HSS 101.90 FOUND CRACKED 12 INCHES FROM A FT SPAR. REPAIRED THE SKIN IAW SRM 55-10-01, REPAIR 11.SDR CALA2017040700895Skin · dentedDENTED CROWN SKIN AT BS 445, STRINGER 2L. INSTALLED A SKIN REPAIR IAW SRM 53-00-01, REPAIR 35, AND EC/RA 5310- 07109.
Back to Boeing 737-824