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 CALA2014040100416Bracket · out of positionBLEED DUCT BRACKET ON LT RAM AIR BAY WEB MISLOCATED. REPAIRED IAW ECRA 5710-02361 REV FOR EA 4700-01019 REV B STEP 41.SDR CALA2014040100408Frame · crackedMAIN CABIN FRAME AFT FACE AT BS 400 BETWEEN STRINGERS 8 & 9L IS CRACKED. REPAIRED IAW SR3-2703967022 & SRM53-00-07 REPAIR 1 FIG 201 & ECRA 5311-01675.SDR CALA2014040100409Battery Pack · dischargedLT & RT OVERWING EMERGENCY EXIT SIGNS & SEAT ROWS 20, 21 & 22 EMERGENCY EXIT LIGHTS INOPERATIVE. TROUBLESHOT AND FOUND EMERGENCY BATTERIES AT POWER SUPPLIES M1694 & M1695 DISCHARGED. R & R BATTERIES IAW AMM 33-51-06 & WDM 33-51-21, OPS CHECKED GOOD.SDR CALA2014040100407Frame · crackedCRACK FOUND ON FRAME DURING NDT HFEC INSPECTION AT BS 440 STRINGER 8 - 9R. REPAIRED FRAME IAW EA5310-04716 REV F FIG 3.SDR CALA2014040100406Lens · brokenL2 DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED LENS ASSEMBLY, ALL TEST PASSED AMM 33-51-00.SDR CALA2014032800405Frame · crackedCRACK AT FRAME STATION 400R BETWEEN STRINGER 8R & 9R. HFEC CONFIRMED FRAME 400R HAS BEEN REPAIRED IAW EA 5310-04716 REV G OP 1.SDR CALA2014032800404Frame · crackedCRACK AT FRAME STATION, 727B RT, STRINGER 8R & 9R, HFEC CONFIRMED. FRAME 727B HAS BEEN REPAIRED IAW EA 5310-04716 REV G OP 1.SDR CALA2014032800403Intercostal · crackedSPT PLENUM BAY BILDGEMAREA INTERCOSTAL CRACKED AT STATION 500I TO STATION 520 ABOVE STRINGER 27L. REMOVED DAMAGE FROM INTERCOSTAL AT BS 500I TO STATION 5205 TO STRINGER 27L. FABRICATED REPAIR DOUBLER, ALODINE & PRIMERED REPAIR PART & INSTALLED IAW SRM 51-70-SDR CALA2014032800400Frame · crackedCRACK AT FRAME STATION 867R BETWEEN STRINGER 8R & 9R. HFEC CONFIRMED REPAIRED FRAME BY INSTALLING REPAIR ANGLES IAW EA 5310-04716 REV G.SDR CALA2014032800398Frame · crackedCRACK AT FRAME STATION 727D RT, BETWEEN STRINGER 8R & 9R. HFEC CONFIRMED INSTALLED REPAIR ANGLES IAW EA 5310-04716 REV G.SDR CALA2014032600397Frame · crackedCRACK AT FRAME STATION 500A RT, BETWEEN STRINGER 8R & 9R. HFEC CONFIRMED PREVIOUSLY ENTERED INCORRECTLY UNDER LG PG 9633492 FRAME 500A RT HAS BEEN REPAIRED IAW EA 5310-04716 REV G OP 1.SDR CALA2014032600396Frame · crackedCRACK AT FRAME STATION 440L BETWEEN STRINGER 8L & 9L. MFEC & HFEC CONFIRMED FRAME 440L HAS BEEN REPAIRED IAW EA 5310-04716 REV G OP 1 FIG 3.SDR CALA2014032600393Frame · crackedCRACK AT FRAME STATION 480L BETWEEN STRINGER 8L & 9L. MFEC & HFEC CONFIRMED FRAME 480L HAS BEEN REPAIRED IAW EA 5310-04716 REV G OP 1.SDR CALA2014032600392Frame · crackedCRACK AT FRAME STATION 380R BETWEEN STRINGER 8R & 9R. HFEC CONFIRMED FRAME 380R HAS BEEN REPAIRED IAW EA 5310-04716 REV G OP 1 FIG 3.SDR CALA2014032400389Skin · damagedRT HORZ STAB RIB STATION 138.70 INBD OF DRAIN HOLE REPAIRED PER SRM 55-10-01, REPAIR 11.SDR CALA2014032400387Skin · crackedRIGHT LOWER HORIZONAL STAB SKIN IS CRACKED AT RIB 157.90 APPROXIMATELY 16 INCHES FROM REAR SPAR. INSTALLED REPAIR IAW SRM 55-10-01 REPAIR 11 FIG 204.SDR CALA2014032400388Skin · crackedRT LOWER STAB SKIN IS CRACKED AT RIB 92.70 APPROXIMATELY 12 INCHES FROM REAR SPAR. INSTALLED REPAIR AT CRACKED AREA RT LOWER STAB SKIN RIB 92.70 APPROXIMATELY 12 INCHES FROM REAR SPAR IAW SRM 55-10-01 REPAIR 11 FIG 204.SDR CALA2014032400383Angle · corrodedL2 DOOR HAS CORROSION ON L ANGLE SEEN THROUGH LOWER CTR HOLE JUST ABOVE GATE, ANGLE ATTACHES TO OUTER SKIN. INSTALLED L ANGLE IAW SRM 51-40-02.SDR CALA2014032400382Frame · crackedCABIN FRAME STATION 907 BETWEEN STRINGERS 8R - 9R HAS CRACK AT FASTENER HOLE. COMPLETED REPAIR ON CABIN FRAME AT STATION 907 STRINGER 8R - 9R IAW ECRA 5310-06017.SDR CALA2014032100380Frame · crackedFUSELAGE FRAME CRACKED AT LT STATION 400 JUST BELOW STRINGER 8L. REPAIRED FUSELAGE FRAME STATION 400 LT IAW EA 5310-04716 REV F & ECRA-5310-06012.SDR CALA2014032100379Web · corrodedNR 1 ENG PYLON AFT FAIRING, FWD WEB PN 313A2713-2 FOUND CORROSION. INSTALLED NEW FWD WEB ON NR 1 ENG PYLON AFT FAIRING IAW SRM 5 1-40-02 & DWG 313A2700.SDR CALA2014032100378Angle · corrodedNR 1 ENG PYLON AFT FAIRING OTBD FWD WEB ANGLE CORRODED. INSTALLED NEW OTBD FWD WEB ANGLE ON NR 1 ENG PYLON IAW SRM 51-40-02 & DWG 313A2700.SDR CALA2014032100377Angle · corrodedNR 1 ENG PYLON AFT FAIRING INBD FWD WEB ANGLE CORRODED. INSTALLED NEW INBD FWD WEB ANGLE ON NR 1 ENG PYLON IAW SRM 51-4 0-02 & DWG 313A2700.SDR CALA2014032100375Web · corrodedNR 2 ENG PYLON AFT FAIRING FWD WEB CORRODED. R & R NR 2 ENG PYLON AFT FAIRING FWD WEB IAW DWG 313A2700 & SRM 51-40-02.SDR CALA2014032100374Angle · corrodedNR 2 EMERGENCY PYLON AFT FAIRING OTBD WEB ANGLE CORRODED. R & R NR 2 ENG PYLON AFT FAIRING OTBD WEB ANGLE IAW DWG 313A2700 & SRM 51-40-02.SDR CALA2014032000373Rib · corrodedVERTICAL STABILIZER LE DORSAL FIN AREA, HEAVY FRETTING AROUND ENTIRE PERIPHERY FROM SEAL. R & R VERTICAL STAB LE DORSAL FIN RIB IAW SRM 51-40-02 & DWG 176A3001.SDR CALA2014032000372Stringer Clip · crackedSTRINGER CLIP IS CRACKED AT STATION 500I, STRINGER 26L. R & R STRINGER CLIP AT STATION 500I, STRINGER 26L IAW SRM 51-40-02.SDR CALA2014032000371Baffle · abnormalBAFFLE HAS CORROSION UNDER NUTPLATES AT BS 500H TO 500I STRINGERS 2 - 6R. R & R BAFFLE IAW DWG 143A7503-12 & SRM 51-40-02.SDR CALA2014032000368Vapor Barrier · crackedRT MLG VAPOR BARRIER APPEARS CRACKED, INBD OF RAM AIR EXHAUST DUCT. REPAIRED VAPOR BARRIER IAW SRM 57-10-10 REPAIR 2 FIG 204.SDR CALA2014032000367Vapor Barrier · crackedLT MLG WW, VAPOR BARRIER APPEARS CRACKED INBD OF RAM AIR EXHAUST DUCT. REPAIRED VAPOR BARRIER IAW SRM 57-10-10 REPAIR 2 FIG 204.SDR CALA2014031800355Unknown · malfunctionedDURING APPROACH FLAPS LOCKED OUT AT 25 & WOULD NOT EXTEND TO 30. ALL APPLICABLE CHECKLISTS COMPLETED, LANDING WITH INCIDENT IAW FIM TASK 27-51-00-810-801. PERFORMED FSEU BITE NO FAULTS OR PREVIOUS FAULTS LAST 28 LEGS. INSPECTED FLAPS & COMPLIED WITH FLAP LOSDR CALA2014032000360Fitting · corrodedNR 2 ENG PYLON AFT FAIRING AFT WEB CORRODED. R & R AFT WEB FITTING IAW SRM 51-40-02 & DWG 313A2700.SDR CALA2014031800353Floor Support · gougedMAIN CABIN FLOOR SUPPORT CORD AT RBL 51 & BETWEEN BS 957 & BS 980 HAS FOUR EACH DEEP GOUGES. MEASURED GOUGED AREAS & FOUND MAX MATERIAL LOSS .053 INCHES & TO CLOSE TO THE EXISTING FASTENERS HOLES. ORIGINAL MAT .080 INCHES, FOUND OUT OF LIMITS IAW SRM 53-70-5SDR CALA2014031800352Stringer · corrodedFWD CARGO COMPARTMENT STATION 500G, STRINGER 26 LT IS CORRODED ON DRAIN HOLE. STATION 500G, STRINGER 26 LT WAS REPAIRED IAW SRM 53-00-03 REPAIR 1.SDR CALA2014031800350Web · corrodedAFT CARGO STATION 847 TO 853, STRINGER 25 RT WEB HAS MILD CORROSION ON INBD SIDE. INSTALLED NEW WEB STATION 847 TO 853, STRINGER 25 RT IAW SRM 51-40-02.SDR CALA2014031800349Transition Panel · corrodedC2 COMPARTMENT CORROSION ON TRANSITION PANEL AT STATION 847 TO 867, RT SIDE. INSTALLED NEW TRANSITION PANEL AT STATION 847 TO 867, RT SIDE IAW SRM 51-40-02.SDR CALA2014031800348Frame · damagedFRAME SECTION AT STATION 986.5 PN 147A1086-55 HAS THREE EACH DAMAGED FASTENER HOLES AT SPLICE LOCATION. FRAME SECTION PN 147A1086-55 WAS REINSTALLED IAW SRM 51-40-02 & REPAIR COMPLIED WITH IAW STEPS 1 THRU 10 OF ECRA 5310-06011.SDR CALA2014031700338Battery Pack · dischargedSPT AFT RT EMERGENCY DOOR LT INOPERATIVE. R & R BATTERY PACK M1672. PERFORMED EMERGENCY LIGHTS OPERATIONAL CHECK FOR AFT RT DOOR ESCAPE SLIDE LIGHT GOOD IAW AMM 33-51-06.SDR CALA2014031700337Lens · wrong partAFT CABIN WINDOW EMERGENCY EXIT PLACARDS REPORT MARKED INCORRECTLY WITHOUT ARROWS. REPLACED LENS FOR LT & RT AFT CABIN WINDOW EMERGENCY EXIT SIGNS IAW IPC 33-51-01 FIG 16.SDR CALA2014031700330Battery Pack · dischargedSPT OVERWING EMERGENCY LIGHTS BOTH LT & RT SIDES INOPERATIVE. RECHARGED LT BATTERY PACK & REPLACED RT BATTERY PACK FOR OVERWING EMERGENCY LIGHTS. RT SIDE BATTERY PACK PN AD-D717-01-100, SN ON 146868, SN OFF 56250, IAW AMM 31-51-06-610-802 & AMM 33-51-06-960-SDR CALA2014031700326Frame · damagedCENTER FRAME AT STATION 986.5 FROM STRINGER 16 RT TO 16 LT HAS DAMAGE. CTR SECTION FRAME WAS REINSTALLED IAW SRM 51-40-02 & STEPS 1 THRU 10 OF ECRA 5310-06011.SDR CALA2014031700324Strip · corrodedFBB RT TRANSITION STRIP AFT OF CARGO DOOR, NEXT TO AFT BULKHEAD, HAS CORROSION ON SEVERAL SPOTS. FABRICATED NEW CAP STRIP IAW GMM 07-35-05. TREATED, PRIMED & PAINTED IAW SRM 51-20-01.SDR CALA2014031700323Transition Panel · corrodedAFT CARGO LT TRANSITION PANEL HAVE CORROSION STATION 727I - 847. REPAIRED LT TRANSITION PANEL STATION 727I - 847 IAW SRM 53-00-53 REPAIR 6.SDR CALA2014031700322Transition Panel · corrodedAFT CARGO LT TRANSITION PANEL HAVE CORROSION STATION 727G TO 727I. REPAIRED LT TRANSITION PANEL STATION 727G - 727I IAW SRM 53-00-53 REPAIR 6.SDR CALA2014031700321Transition Panel · corrodedFWD CARGO COMPARTMENT LT TRANSITIONAL PANEL HAS CORROSION BETWEEN STATION 500D & 500I. INSTALLED NEW FWD CARGO COMPARTMENT LT TRANSITIONAL PANEL BETWEEN STATION 500 TO 500I.SDR CALA2014031400320Transition Panel · corrodedFWD CARGO COMPARTMENT RT TRANSITIONAL PANEL HAS CORROSION FROM STATION 500A TO 500I. INSTALLED NEW FWD CARGO COMPARTMENT RT TRANSITIONAL PANEL & SPLICE BETWEEN STATION 500A TO 500I IAW SRM 53-00-53 REPAIR 5.SDR CALA2014031200317Frame · crackedFUSELAGE FRAME CRACKED AT LT STATION 440 JUST BELOW STRINGER 8L. REPAIRED FRAME IAW EA5310-04716 REV F FIG 3.SDR CALA2014031200314Angle · wornRIGHT SIDE CLOSURE ANGLE FOR VERTICAL STABILIZER PANEL IS WORN. R & R CLOSURE ANGLE IAW SRM 51-40-05 & 51-40- 02.SDR CALA2014031000311Frame · crackedCABIN FRAME AT STATION 440RT IS CRACKED AT SUPPORT FITTING BETWEEN STRINGER 8 & STRINGER 9RT IAW LOG PAGE 9603011. INSTALLED REPAIR ANGLES A & B AT STATION 440R IAW EA 5310-04716 REV E OP 2, IAW LP 9603011.SDR CALA2014031000309Angle · wornLT VERTICAL RT STAB CLOSURE ANGLE WORN STATION 1006 - 1016. R & R CLOSURE ANGLE IAW SRM 51-40-02.
Back to Boeing 737-824