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 CALA2009092500571Battery Pack · dischargedL1 AND L2 DOORS EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED FRONT LEFT AND AFT LEFT EMERGENCY LIGHT POWER SUPPLY BATTERY PACKS IAW AMM 33-51-06. OPS CHECKS GOOD.SDR CALA2009092500567Floorbeam · corrodedCABIN FLOORBEAM AT STA 986.5, LBL 4.0 HAS CORROSION. REPAIRED CABIN FLOORBEAM REF SRM 53-00-51.SDR CALA2009092500566Intercostal · crackedINTERCOSTAL CRACKED STA 312 TO 328, LBL 46. REMOVED AND REPLACED INTERCOSTAL REF SRM 51-40-02.SDR CALA2009092500565Intercostal · crackedINTERCOSTAL CRACKED STA 312 TO 328, RBL 31. REMOVED AND REPLACED INTERCOSTAL REF SRM 51-40-02.SDR CALA2009092500564Intercostal · crackedINTERCOSTAL CRACKED STA 328 TO 344, LBL 48. REMOVED AND REPLACED INTERCOSTAL REF SRM 51-40-02.SDR CALA2009092500563Intercostal · crackedINTERCOSTAL CRACKED STA 277 TO 294, BL 0. REMOVED AND REPLACED INTERCOSTAL IN REF TO SRM 51-40-02.SDR CALA2009091700556Skin · wornUPPER FUSELAGE HAS WEAR MARK AT STATION 860 WHERE FWD TIP OF DORSAL FIN HAS BEEN RUBBING. REPAIRED CROWN FUSELAGE SKIN UNDER DORSAL FIN REF PER EC/RA 5331-01464, AND INITIATED DIP 53-DIP CONTROL 00909.SDR CALA2009091700553Intercostal · crackedINTERCOSTAL BETWEEN STA 380-400 LBL 12 HAS CRACK AT FASTENER HOLE, FWD WET AREA. INSTALLED NEW ANGLE REF BAC DRAWING 143A5410 AND SRM 51-40-02.SDR CALA2009091700552Intercostal · crackedINTERCOSTAL BETWEEN STATION 380-400 AND BL 0 HAS CRACKS AT FASTENER HOLES, FWD WET AREA. REMOVED AND INSTALLED NEW ANGLE PER SRM 51-40-02 PARAGRAPH 7.SDR CALA2009091600551Battery Pack · dischargedEMERGENCY LIGHTS ARE INOPERATIVE AT SEATS 5ABC THROUGH SEATS 10ABC. REMOVED AND REPLACED EMERGENCY POWER BATTERY PACK RIGHT SIDEWALL BY FLOOR AT STATION 500 PER AMM 33-51-06 PAGE BLOCK 201. NO FAULTS NOTED. EMERGENCY LIGHTS AT SEATS 5ABC THROUGH SEATS 10ABCSDR CALA2009091500548Battery Pack · dischargedAFT CABIN CEILING EMERGENCY EXIT SIGN INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AND CHANGED FUSES ON LEFT BATTERY CHARGER. OPS CHECKS GOOD.SDR CALA2009091400546Intercostal · crackedINTERCOSTAL BETWEEN STATION 312 AND 328, LBL 45 HAS CRACKED AT FASTENER HOLE FWD WET AREA. REMOVED AND REPLACED INTERCOSTAL REF SRM 51-40-02.SDR CALA2009091400545Fitting · gougedLEFT HORIZONTAL STABILIZER FORWARD LOWER FITTING GOUGED AT AFT INBOARD SIDE. BLENDED OUT THE GOUGE ON LEFT HORIZONTAL STABILIZER CENTER SECTION FRONT SPAR CHORD COMPLIED WITH STEPS 1 THRU 6 REF ECRA 5510-02055.SDR CALA2009091400544Intercostal · crackedINTERCOSTAL BETWEEN STATION 312 AND 328, RBL 30 HAS CRACKS AT FASTENERS HOLES, FWD WET AREA. REMOVED AND REPLACED INTERCOSTAL REF SRM 51-40-02.SDR CALA2009091400547Intercostal · crackedCABIN FLOOR INTERCOSTAL CRACKED BETWEEN STA 344 TO STA 360 AT BL 0. DAMAGED INTERCOSTAL REMOVED, NEW INTERCOSTAL INSTALLED REF B737 SRM 51-10-02 AND 51-40-02.SDR CALA2009090100527Battery Pack · dischargedOVERHEAD EMERGENCY LIGHT IN AFT GALLEY NOT ILLUMINATING. REMOVED AND REPLACED BATTERY PACK OVER AFT GALLEY. OPERATIONAL CHECKS GOOD.SDR CALA2009090100526Battery Pack · dischargedAFT LEFT OVERHEAD EMERGENCY LIGHT NOT ILLUMINATING. REMOVED AND REPLACED BATTERY PACK AFT LEFT OVERHEAD. OPERATIONAL CHECKS GOOD.SDR CALA2009090100525Light · inoperativeBOTH EMERGENCY EXIT LIGHTS LOCATED AT AFT LEFT OVERWING EXIT INOPERATIVE. REPLACED BOTH LAMPS AT AFT LEFT OVERWING EMERGENCY EXIT LIGHT. OPERATIONAL CHECKS GOOD.SDR CALA2009090100521Intercostal · crackedFORWARD FUSELAGE FLOOR STRUCTURE INTERCOSTAL STA 312- 328 RBL 32 HAS CRACK AROUND FASTENER HOLE. REMOVED AND REPLACED INTERCOSTAL P/N 141A5410-16 AT STA 312-328 AND RBL 32 REF SRM 51-40-02.SDR CALA2009090100520Floor Support · crackedFORWARD FUSELAGE FLOOR STRUCTURE INTERCOSTAL STA 285-294 RBL 2 HAS CRACKS AROUND FASTENER HOLES. REMOVED AND REPLACED FWD FUSELAGE FLOOR STRUCTURE INTERCOSTAL STA 285 TO STA 294 RBL 2 IAW BOEING 737/800 SRM 51-40-02.SDR CALA2009090100519Floor Support · crackedFORWARD FUSELAGE, FLOOR SUPPORT STRUCTURE INTERCOSTAL STA 312-328 LBL 46 CRACKED AT FASTENER HOLE. REMOVED AND REPLACED FLOOR SUPPORT STRUCTURE AT STA 312 TO STA 328 LBL 46 REF SRM 51-40-02.SDR CALA2009082700517Shaft · lack of lubeON FINAL APPROACH CREW LOWERED GEAR AND HAD 3 GREEN OVERHEAD AND 3 GREEN AND 3 RED ON LANDING GEAR MAIN PANEL. AT 2000 FT GEAR TOO LOW WARNING, EXECUTED GO AROUND, 2ND APPROACH NORMAL. JACKED A/C PER AMM 07-11-01-580-815, PERFORMED FIM TASK 32-30-00-810-816,SDR CALA2009082700515Structure · corrodedLEFT WHEEL WELL UNDER PANEL 193CL HAS FRETTING CORROSION. REMOVED AND REPLACED CORRODED CHORD, REF SRM 51-40-02.SDR CALA2009082700516Angle · corrodedANGLE HAS FRETTING CORROSION, LOCATED APPROXIMATELY STATION 650 - 673, LBL 27 F/W OF WHEEL WELL. REMOVED AND REPLACED T-ANGLE REF SRM 51-40-02.SDR CALA2009082600513Light · inoperativeRIGHT SIDE FUSELAGE EMERGENCY EXIT SLIDE LIGHT IS INOPERATIVE. RE-LAMPED RIGHT SIDE FUSELAGE EMERGENCY EXIT SLIDE LIGHT IAW AMM 33-51-04. OPS CHECK GOOD.SDR CALA2009082600508Light · inoperativeEMERGENCY SLIDE / OVERWING LIGHT AT DOOR R2 INOPERATIVE. RELAMPED LIGHT IAW AMM 33-51-04. OPS CHECK GOOD.SDR CALA2009082600507Power Supply · dischargedEMERGENCY EXIT LIGHTS ON SEATS 25 - 29 AND R2 DOOR EXTERIOR LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M1672 REF AMM 33-51-06, OPS CHECK OK.SDR CALA2009082600506Battery Pack · dischargedOVERHEAD EMERGENCY LIGHT ON RIGHT SIDE BETWEEN ROWS 15DEF - 22DEF IS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IAW AMM 35-51-06, OPS CHECKS GOOD.SDR CALA2009082600497Floorbeam · corrodedCORROSION IN AFT WET AREA FLOOR STA 986.5 RBL 42. CUT OUT DAMAGED SECTION OF FLOORBEAM, FABBED REPAIR PIECES, TREATED, PRIMED AND INSTALLED IN REF TO ECRA 5321-01429 AND ECRA 5321-01684.SDR CALA2009082600496Angle · corrodedRIGHT WHEEL WELL UNDER PANEL 193CR HAS FRETTING CORRODED. REMOVED AND REPLACED ANGLE REF SRM 51-40-02.SDR CALA2009082600495Floor Support · gougedAFT BAGGAGE BIN FLOOR SUPPORT STA 727D+6, LBL 3 EDGE GOUGED. REPAIRED DAMAGE PER ECRA 5320-01960.SDR CALA2009082600494Floor Support · corrodedAFT BAGGAGE BIN FLOOR SUPPORT STA 727I , RBL 4 HAS CORROSION. FABRICATED AND INSTALLED SPLICED TRACK PER ECRA 5320-01961.SDR CALA2009082500492Floor Support · corrodedFRAME FLOOR SUPPORT CORRODED AROUND NUT PLATE HOLES AND BENT STA 500D STR 26LT TO 22LT. REMOVED DAMAGED CHANNEL; INSTALLED NEW CHANNEL REF B737 SRM 51-10-02 AND 51-40-02.SDR CALA2009082500491Trans Panel · corrodedRIGHT TRANSITION PANEL CORRODED STA 500G TO 500I. REMOVED AND REPLACED TRANSITION PANEL AS NEEDED SRM 51-40-02.SDR CALA2009082500490Trans Panel · corrodedRIGHT TRANSITION PANEL CORRODED STA 500A TO STA 500G. REMOVED AND REPLACED TRANSITION PANEL REF SRM 51-40-02.SDR CALA2009082500489Floorbeam · corrodedLATERAL INTERCOSTAL (FLOORBEAM) AT STATION 270 IS CORRODED AT BL-0. INSTALLED REPAIR PARTS PER ECRA 5321-01682.SDR CALA2009082400487Intercostal · corrodedCONTROL CABIN AFT CENTER FLOOR SUPPORT INTERCOSTAL CORRODED AT STA 270. REPLACED CENTER FLOOR SUPPORT PER ECRA 5321-01682.SDR CALA2009082400464Girt Bar · incorrectRIGHT AFT SERVICE DOOR HAS INCORRECT GIRT BAR ATTACHED TO THE SLIDE PACK. REMOVED AND REPLACED GIRT BAR AT DOOR 2R, FOUND TO BE IMPROPER LENGTH, INSPECTED IAW GMM 13-85-87 PG 20.SDR CALA2009082400486Intercostal · crackedINTERCOSTAL AT STATION 500F STR 26R CRACKED. REPLACED INTERCOSTAL REF SRM 53-30-53 AND SRM 51-40-02.SDR CALA2009082400485Intercostal · crackedINTERCOSTAL AT STATION 500, STR 26/R CRACKED. REPLACED INTERCOSTAL REF SRM 53-30-53 AND SRM 51-40-02.SDR CALA2009082400484Intercostal · bentINTERCOSTAL BETWEEN STATION 500E TO STA 500F STR 26 RIGHT BENT. REPLACED INTERCOSTAL REF SRM 53-30-53 AND SRM 51-40-02.SDR CALA2009082400483Skin · crackedRIGHT HORIZONTAL STABILIZER CRACK INDICATION AT STA 129.5 ACROSS FROM DRAIN HOLE. TRIMMED OUT DAMAGED AREA, PERFORMED NDT OF REPAIR AREA AND INSTALLED FILLER AND REPAIR DOUBLER PER ECRA 5510-02047.SDR CALA2009082400482Skin · crackedLT STABILIZER LOWER SKIN SHOWS CRACK AT STA 138.70 RUNNING FWD/AFT APPROX 1 INCH LT HORIZ STAB LOWER SKIN CRACK AT STA 138.70. REPAIRED PER ECRA 5510-02051, ACCOMP INITIAL INSP PRIOR TO 17,042 TOTAL FLT CYC`S AND REPEAT INSP`S AT INTERVALS NOT TO EXCEED 9000 SDR CALA2009082400481Skin · crackedLT STABILIZER LOWER SKIN SHOWS CRACK AT STA 129.50 APPROX .50 INCH WITH C SCAN LT STAB LOWER SKIN CRACK AT STA 129.50. REPAIRED PER ECRA 5510-02051, ACCOMP INITIAL INSP PRIOR TO 17,042 TOTAL FLT CYC`S AND THEN REPEAT INSP`S AT INTERVALS NOT TO EXCEED 9000 FLTSDR CALA2009082400480Skin · crackedRT STABILIZER LOWER SKIN SHOWS CRACK AT STA 129.50 RUNNING FWD AND AFT APPROX 1.25 INCH WITH C SCAN RT HORIZ STAB LOWER SKIN CRACK AT STA 129.50. REPAIRED PER ECRA 5510-02052 ACCOMP INITIAL INSP PRIOR TO 17,042 TOTAL FLT CYCLES AND THEN REPEAT INSP`S AT INTERSDR CALA2009082400479Skin · crackedRT HORIZONTAL STABILIZER LOWER SKIN SHOWS CRACK AT STA 138.70 APPROX .75 INCH WITH C SCAN RT STAB LOWER SKIN CRACK AT STA 138.70. REPAIRED PER ECRA 5510- 02052. ACCOMPLISH INITIAL INSP PRIOR TO 17,042 TOTAL FLT CYCLES AND THEN REPEAT INSP`S AT INTERVALS NOT SDR CALA2009082400478Floorbeam · corrodedCORROSION IN AFT WET AREA FLOOR AT STA 986.5 LBL 42. REPAIRED FLOORBEAM AT STA 986 LBL 42 REF ECRA 5321-01429 REPAIR A.SDR CALA2009082400477Rail · corrodedAFT BULKHEAD CENTER WALL SUPPORT CORRODED AT STATION 500I. INSTALLED NEW RAIL ASSEMBLY REF SRM 51-40-02.SDR CALA2009082400476Rail · corrodedAFT BULKHEAD LT WALL SUPPORT CORRODED AT STATION 500I. INSTALLED NEW RAIL ASSEMBLY REF SRM 51-40-02.SDR CALA2009082400475Intercostal · crackedINTERCOSTAL CRACKED AT STATION 500E TO 500F STR 26 LEFT. REMOVED INTERCOSTAL, FABRICATED NEW INTERCOSTAL AND INSTALLED REF SRM 51-40-02.
Back to Boeing 737-824