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 CALA2013012100044Lens · missingTHE EMERGENCY EXIT LIGHT COVER ADJACENT TO AFT GALLEY DOOR 2R IN MISSING. REPLACED/INSTALLED NOTED LENS (COVER) AT AFT GALLEY DOOR 2R EQUIPMENT L1190. TEST OK AMM 33-51-01-960-801.SDR CALA2013012100043Floor Support · crackedFLOOR SUPPORT CRACKED AT FASTENER HOLE STA 344 TO STA 360 BL0 CABIN. R & R NEW FLOOR SUPPORT AT STA 344 TO STA 360 LB0 IAW SRM 51-40-02.SDR CALA2013012100042Door · looseAFTER TAKEOFF, ACFT FAILED TO PRESSURIZE, F/A IN AFT CALLED AND SAID AFT DOOR R2 CLOSED, HANDLE SET CLOSED BUT HE COULD SEE A SPACE BETWEEN DOOR AND ACFT. RETURNED TO DEPARTURE. NO DOOR LIGHT ON OVERHEAD. FOUND FWD EDGE OF R2 DOOR NOT FAIRED. CLOSED DOOR SDR CALA2013010700014Indicator · inoperativeDURING TAKEOFF, CAPTAINS AIRSPEED INDICATOR FAILED TO INDICATE ANY SPEED. ABORTED AND REJECTED TAKEOFF AROUND 100 KNOTS. NO FLAG S NOTED ON A/S INDICATOR.SDR CALA2013010700013Bulkhead · crackedCRACK IN LEFT MAIN WHEEL WELL FWD BULKHEAD APPROX 42" FROM CENTERLINE, 6" FROM CEILING. REPAIRED IAW SRM 57-10-10, REPAIR 3, ALT 2 CATEGORY B.SDR CALA2012122600877Battery Pack · inoperativeROWS 32ABC THRU 37ABC EMERGENCY PATH LIGHTS INOPERATIVE. R & R BATTERY PACK M1672 REF AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2012122600874Lens · missingEXIT COVER FOR LIGHT AT DOOR 1R MISSING. INSTALLED LENS, TESTED OK, AMM 33-51-01-960-801/960-802,SDR CALA2012122000866Filter · odorAT ROWS 4 AND 20 AND 21, THERE WAS A BURNING ODOR OF ELECTRIC WIRE BUT NO SMOKE. PERFORMED TASK 05-51-26-800-801 C1 NO TROUBLE FOUND PERFORMED HIGH POWER RUN ON BOTH ENGINES NO PROBLEM FOUND OPERATION OF BOTH PACKS AT VARIOUS TEMPS CHECKS NORMAL. R & R BOTH SDR CALA2012122100872Power Supply · inoperativeL1 OVERHEAD EMERGENCY LIGHT INOPERATIVE. R & R POWER SUPPLY AND BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2012121000857Unknown · odorAPU 6 PACK LIGHT ON, SEEMS TO BE INDICATION PROBLEM. INSPECTED TAIL AREA OF A/C IN BALLPARK, DEPARTED MEL 49-01. AFTER T/O F/A REPORTED BURNING ODOR, DECLARED EMERGENCY, AIR RETURN TO DEPARTURE. ACCOMPLISHED CONDITIONAL INSPECTION IAW CARD 05-51-26-800-80SDR CALA2012120300828Power Supply · inoperativeEMERGENCY LIGHTS AT SEATS 8C THROUGH 12C INOPERATIVE. FOUND EMERGENCY LIGHT AT 8C SHORTED. DISCONNECTED LIGHT ASSY AND TAPED CONNECTOR . REPLACED BATTERY CHARGER IN SIDEWALL AT 8ABC. LIGHTS AT 9C THRU 12C, OPS NORMAL. IDT 172337 CR NO PARTS AVAILABLE MEL SDR CALA2012112800825Sensor · faultyLEFT BLEED TRIP FL 340 UNABLE TO RESET. PERFORMED ENG BLEED AIR SYS HEALTH CHECK, AMM 36-11-00-700-80 1. FOUND PRECOOLER CONTROL VALVE SENSOR; PRECOOLER CONTROL VALVE FAULTING. R & R PRECOOLER VALVE SENSOR AMM 36-12-03. PRECOOLER CONTROL VALVE AMM 36-12-0SDR CALA2012112600823Battery Pack · dischargedRIGHT EMERGENCY EXIT DOOR EMERGENCY LIGHT WILL NOT TEST. R & R 2 EA EMERGENCY LIGHT BATTERY PACKS. OPS CHECKED GOOD IAW AMM 33-51-06-960-805.SDR CALA2012112600821Frame · crackedFRAME BS 440 BETWEEN STRINGERS 8R AND 9R CRACKED AT AIR CONDITIONING OUTLET ATTACH BRACKET REF STEP 7 OF EA 5310-04716 REV D, FRAME 440 R HAS BEEN REPAIRED IAW ECRA 5310-05616.SDR CALA2012112600820Frame · crackedFRAME AT BS 400 BETWEEN STRINGERS 8R AND 9R CRACKED AT AIR CONDITIONING OUTLET BRACKET REF EA 5310 -04716 REV D STEP 7 FRAME 400 R HAS BEEN REPAIRED IAW ECRA 5310-05616.SDR CALA2012112600819Frame · crackedFRAME AT BS 480 BETWEEN STRINGERS 8R AND 9R CRACKED AT AIR CONDITIONING OUTLET ATTACH BRACKET REF STEP 7 OF EA 5310-04716 REV D OP 1 FRAME 480 R HAS BEEN REPAIRED IAW ECRA 5310-05616.SDR CALA2012112600818Frame · crackedFRAME AT STA 907 BETWEEN STR`S 8R AND 9R CRACKED AT AIR CONDTIONING OUTLET ATTACH BRACKET REF STEP 7 OF EA 5310-04716. REPAIR ACCOMPLISHED IAW ECRA 5310-05620.SDR CALA2012112600814Frame · crackedFRAME 440 CRACKED BETWEEN STR 8L AND 9L AT ATTACH BRACKET FRAME FASTENER HOLE. FRAME HAS BEEN REPAIRED IAW EA 5310-04716 OP 1 REV DSDR CALA2012112600817Floorbeam · corrodedFLOORBEAM AT BS 328 RBL 22 TO RBL 52 CORRODED. REPAIRED IAW EC/RA 5321-01822.SDR CALA2012111900811Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW AMM 33-51-06-960-805.SDR CALA2012111900810Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW AMM 33-51-06-960-805.SDR CALA2012111900809Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW AMM 33-51-06-960-805.SDR CALA2012111900808Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW AMM 33-51-06-960-805.SDR CALA2012111900807Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW AMM 33-51-06-960-805.SDR CALA2012111900806Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW AMM 33-51-06-960-805.SDR CALA2012111900805Angle · corrodedANGLE AT BS 270 BL 0 HAS CORROSION. INSTALLED REPAIR PARTS IAW EC/RA 5321-01566.SDR CALA2012111900802Seat · looseROW 37 ABC SEAT IS LOOSE FROM ATTATCHMENT INBD SIDE LOOSE, SECURED SEAT IN TRACK CHECKED BOTH SIDES-OK NOW, AMM 25-22-00-200-804, 25-22-00-400-902. OK.SDR CALA2012111900801Seal · leakingAT CRUISE, NR 1 ENGINE HYD PUMP "LIGHT" CAME ON, HYD QTY WAS AT 20 PERCENT AND DROPPING AT 0 PERCENT, HYD PUMP LIGHT CAME ON. RAN QRH FOR BOTH; MAIN GEAR DOWN. TROUBLE SHOT IAW FIM 29-10 TSK 812, FOUND RUPTURED SEAL AT HYD SYS "A" PRESS MODULE PLUG. R & R;SDR CALA2012111600799Structure · corrodedR1 DOOR HAS CORROSION AROUND SILL AREA. R & R STRUCTURE SRM 51-40-02.SDR CALA2012111300797Frame · crackedFRAME AT BS 500C BETWEEN STRINGERS 8 AND 9R, CRACKED AT AIR CONDITIONING OUTLET ATTACH BRACKET. REF STEP 7 OF EA 5310-04716 REV D, FRAME 500C R BETWEEN STRINGERS 8 AND 9 HAS BEEN REPAIRED IAW 5310-04716, REV D.SDR CALA2012111300795Frame · crackedFRAME AT BS 500A BETWEEN STRINGERS 8 AND 9R CRACKED AT AIR CONDITIONING OUTLET ATTACH BRACKET. REF STEP 7 OF EA 5310-04716 REV D. FRAME 500A R BETWEEN STRINGERS 8 AND 9 HAS BEEN REPAIRED IAW EA 5310-04716 REV D OP1.SDR CALA2012111300794Frame · crackedFRAME BS 727B CRACKED BETWEEN S8-9R AT ATTACH BRACKET. REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR CALA2012111300793Frame · crackedFRAME BS 867 CRACKED BETWEEN S8-9R AT ATTACH BRACKET. REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR CALA2012110900789Handle · dislodgedAFT CABIN ENTRY DOOR LIGHT ILLUMINATED ON TAKEOFF ROLL AT ABOUT 120 KTS. REJECTED, CHECKED BOTH AFT MAIN DOORS, OPS CHECKED OK, CLEANED TARGETS, ALL CHECKED NORMAL, IAW F/A ON T/O ROLL , LT AFT DOOR HANDLE POPPED UP CAUSING CAUTION LIGHT, INSPECTED IAW MM 05SDR CALA2012110900787Frame · crackedFRAME AT BS 867, CRACKED BETWEEN STR 8 AND 9L AT AIR CONDITIONING OUTLET ATTACH BRACKET. REPAIRED IAW EA 5310-04716, REV D, OP 2.SDR CALA2012110800784Angle · corrodedL1 DOOR ANGLE HAS CORROSION AROUND SILL AREA INSTALLED NEW ANGLE IAW SRM 51-40-02.SDR CALA2012110800781Frame · crackedFRAME BS 500A LT CRACKED BETWEEN STRINGERS 8 AND STR 9L, FRAME REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR CALA2012110800768Frame · crackedFRAME AT BS 400, CRACKED BETWEEN STR 8 AND 9L AT AIR CONDITIONING OUTLET ATTACH BRACKET. REF EA 5310-04716-REV D, STEP 6. REPAIRED IAW EA 5310-04716, REV D, OP 2.SDR CALA2012110800767Frame · crackedFRAME BS 380 CRACKED BETWEEN STR 8 AND 9R AT ATTACH BRACKET. FRAME REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR CALA2012110800765Frame · crackedFRAME AT BS 480, CRACKED BETWEEN STR 8 AND 9L AT AIR CONDITIONING OUTLET ATTACH BRACKET REF EA 5310-04716, REV D, STEP 6. REPAIRED FRAME AT IAW EA 5310-04716.SDR CALA2012110200742Skin · gougedDENT AND GOUGE AFT OF L2 DOOR AT BS 1039 S13L. REPAIRED IAW ECRA 5330-03436.SDR CALA2012110200741Frame · damagedAFT CARGO HAS DAMAGE TO TOP SIDE OF THE FRAME AT BS 947.5 AND RBL 20. FRAME REPAIRED IAW ECRA 5311-01568.SDR CALA2012110200740Skin · gougedUPPER CROWN SKIN GOUGED 2 INCHES AFT OF LTV PRESSURE FEED THRU DOUBLER AT BS 727E BETWEEN STR 1 AND 2L. REPAIRED SKIN IAW ECRA 5331-01653.SDR CALA2012110200739Skin · damagedLEFT SIDE FUSELAGE DENTED JUST ABOVE LAV SERVICE PANEL 1.8 WIDTH .060 DEPTH ACROSS 2 FRAMES AND A STRINGER REPAIRED IAW ECRA 5330-03460.SDR CALA2012110200731Skin · damagedON WALKAROUND FOUND HOLE AT STA 390, STR 16L SKIN . REPAIRED DAMAGE IAW SRM 53-00-01 REPAIR 19.SDR CALA2012110100719Skin · damagedSKIN DAMAGED. REPAIRED IAW ECRA 5330-03676, PART 1.SDR CALA2012110100714Charger · failedOVERHEAD EMERGENCY LIGHTS ON SEAT ROW 30C AND 32C WILL NOT COME ON. R & R BATTERY PACK POWER SUPPLY IAW AMM 33-51-06 AND BATTERY EMERGENCY POWER CHARGER IAW AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2009040600043Skin · damagedAFT FUSELAGE SKIN DAMAGE FOUND. FWD OF FUSELAGE BS 887 DAMAGE IS 14 INCHES LONG AND EXTENDS ACROSS S25L. CUTOUT DAMAGED AREA & REPAIRED IAW EC/RA 5361-01014.SDR CALA2012110600744Skin · dentedDENT ON AFT CARGO DOOR 14 INCHES FROM AFT EDGE OF DOOR AND 6 INCHES UP FROM BOTTOM OF DOOR. REPAIRED IAW ECRA 5230-01844, STEPS 1-21.SDR CALA2012110600755Bulkhead · canningAFT PRESSURE BULKHEAD HAS OIL CANNING AT WL 296.23 BETWEEN STR 2 & 3 RT 5.00 X 7.25 AND.200 DEEP REF WC 425, STEP 1 INSTALLED REPAIR IAW ECRA 5311-01468, REINSPECT BEFORE THE CORRECTION, SHOULD READ: INSTALLED REPAIR ACCUMULATION OF 46950 TOTAL FLT CYCLES AND
Back to Boeing 737-824