Boeing 737-3H4
Service difficulty reports · 52,340
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 = '7373H4' 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 = '7373H4' 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 SWAA2016021148947Door Frame · crackedFORWARD CARGO DOOR FRAME, CRACKED FRAME AT THE EXTERNAL UPLOCK ASSEMBLY. R & R DOOR IAW AMM.SDR SWAA2016021148946Attach Bracket · crackedLEFT WING INBD GND SPOILER, INBD ACTUATOR CASTING ATTACH BRACKET CRACKED. REPAIRED BRACKET IAW DWG & SRM.SDR SWAA2016031449871Support Angle · crackedLEFT WING RSS 547 AILERON WIPER WEB SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2016031449870Support Angle · crackedRIGHT WING R22. 547 AILERON WIPER WEB SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2016030249568Plate · crackedLEFT EMER EXIT AFT UPPER, FWD UPPER & FWD LOWER DOOR STOP PIN PLATES CRACKED. R & R PLATES IAW DWG.SDR SWAA2016021949233Skin · corrodedRIGHT WING UPPER SKIN AT REAR SPAR AREA CORRODED, BETWEEN APPROX WBL 439 - 444. REPAIRED SKIN IAW EA.SDR SWAA2016021649121Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, BETWEEN STRINGER 28R - 28L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2016021249004Skin · crackedRIGHT WING UPPER SURFACE SKIN CRACKED AT APPROX WBL 174, AT REAR SPAR FASTENER HOLE. REPAIRED SKIN IAW SRM.SDR SWAA2016021148970Connector · missingFORWARD LAVATORY EXIT SIGN WIRE CONNECTOR MISSING. INSTALLED CONNECTOR IAW AMM.SDR SWAA2016021048880Battery Pack · dischargedEMERGENCY LIGHT POSITION M1135 INOPERATIVE AT ROW 5. R & R BATTERY POWER IAW MM.SDR SWAA2016021048877Battery Pack · dischargedR2 DOOR EMER LIGHT M1133 INOPERATIVE. R & R BATTERY POWER IAW MM.SDR SWAA2016030749697Skin · crackedFUSELAGE SKIN FWD OF CONDITIONED AIR DOOR CRACKED, BETWEEN BS 521.4 - 529.3. REPAIRED SKIN IAW SRM.SDR SWAA2016022949513Skin · crackedFUSELAGE SKIN CRACKED AT BS 360+4.5, STRINGER 1L. R & R SKIN IAW ER & EA.SDR SWAA2016020948808Battery Pack · dischargedAFT OTBD FLASHLIGHT INOPERATIVE. R & R BATTERY PACK IAW CMM.SDR SWAA2016020948807Skin · crackedSKIN CRACKED AT BS 727, BETWEEN STRINGER 18R - 19R. REPAIRED SKIN IAW EA.SDR SWAA2016020948766Fastener · looseR1 DOOR EMER ESCAPE SLIDE CONTAINER MOUNTING BRACKET LOOSE. SECURED FASTENER IAW AMM.SDR SWAA2016032850304Spar · crackedLEFT WING UPPER REAR SPAR CHORD CRACKED AT RSS 221. REPAIRED CHORD IAW EA.SDR SWAA2016032250117Spar · crackedRIGHT WING UPPER REAR SPAR CHORD CRACKED AT RSS 221. REPAIRED CHORD IAW EA.SDR SWAA2016031449865Skin · crackedFORWARD GALLEY DOOR CUT OUT LOWER AFT CORNER SKIN CRACKED AT BS. 328+4, STRINGER 17R. REPAIRED SKIN IAW SRM.SDR SWAA2016021649107Scuff Plate · crackedFORWARD CARGO AFT CORNER SCUFF PLATE CRACKED ON FWD & AFT. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2016021649106Scuff Plate · crackedAFT CARGO, AFT CORNER SCUFF PLATE, CRACKED AT AFT CORNER. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2016020948801Retaining Clip · brokenRIGHT OVERWING EMER EXIT SIGN LENS RETAINING CLIP BROKEN. R & R LENS ASSEMBLY IAW AMM.SDR SWAA2016021148977Flap Track · crackedLEFT WING NR 4 FLAP TRACK CRACKED. R & R NR 4 FLAP TRACK IAW AMM.SDR SWAA2016020548732Light · inoperativeFORWARD ENTRY DOOR AT FORWARD GALLEY LOWER EMERGENCY EXIT LIGHT BULB INOP. R&R BULB IAW AMM.SDR SWAA2016031049795Skin · crackedRIGHT WING UPPER SKIN CRACKED, AT FASTENER HOLE COMMON TO THE SKIN TE, AT RSS 253. REPAIRED SKIN IAW EA.SDR SWAA2016031049794Skin · crackedRIGHT WING REAR SPAR UPPER CHORD SKIN CRACKED, AT RSS 226.1. REPAIRED SKIN IAW ER & EA.SDR SWAA2016030349611Skin · crackedRIGHT WING UPPER SKIN, TE FASTENER HOLE COMMON TO THE REAR SPAR UPPER CHORD CRACKED AT RSS 205. REPAIRED SKIN IAW EA & ER.SDR SWAA2016021048905Hinge Bracket · crackedLEFT WING NR 4 GND SPOILER PANEL SUPPORT HINGE BRACKET, CRACKED ON UPPER OTBD FWD OTBD END. R & R BRACKET IAW SRM & DWG.SDR SWAA2016020948781Skin · crackedFUSELAGE SKIN CRACKED AT BS 807+3, STRINGER 8L. REPAIRED SKIN IAW EA.SDR SWAA2016020948780Skin · crackedFUSELAGE SKIN CRACKED AT BS 312-3, STRINGER 2L. REPAIRED SKIN IAW SRM.SDR SWAA2016020548739Strap · crackedRT OUTBOARD FLOORBEAM STRAP CRACKED BETWEEN BS 312 TO BS 328 INSIDE E/E ACCESS. REPAIRED STRAP PER SRM.SDR SWAA2016020448687Support Angle · crackedRT WING UPPER FIXED TRAILING EDGE PANEL SUPPORT ANGLE CRACKED, JUST INBOARD OF PYLON. R&R ANGLE IAW. SRM.SDR SWAA2016020448682Flap · delaminatedRT WING INBOARD AFT FLAP DELAMINATED. R&R AFT FLAP PER AMM.SDR SWAA2016020448681Cover · brokenRT EMERGENCY EXIT LIGHT COVER BROKEN. R&R COVER PER AMM.SDR SWAA2016021148978Support Angle · corrodedLEFT WING NR 4 STIFFENER REAR SPAR SUPPORT ANGLE, CORRODED AT APPROX RSS 185. REPAIRED ANGLE IAW SRM & DWG.SDR SWAA2016020348625Flap · damagedLEFT WING INBD FORE FLAP HAD FOD DAMAGE ON LOWER SID, AT 3RD HINGE ARM. R & R FORE FLAP IAW AMM.SDR SWAA2016020348624Flap · damagedLEFT WING OTBD FORE FLAP DAMAGED AT INBD END. R & R FORE FLAP IAW AMM.SDR SWAA2016020348623Lens · looseFORWARD UPPER CTR CABIN EMER LIGHT LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2016031449890Fitting · crackedLEFT MLG OTBD D FITTING CRACKED AT RSS 224.14, HOLE NR 5. REPAIRED FITTING IAW EA.SDR SWAA2016031449889Skin · crackedLEFT WING LOWER SURFACE OF WING UPPER SKIN CRACKED BETWEEN, RSS. 253 - 266. REPAIRED SKIN IAW EA.SDR SWAA2016031149820Skin · crackedLEFT WING, WING UPPER SKIN CRACKED IN THE HOLE LOCATED AT LT RSS 221. REPAIRED SKIN IAW EA.SDR SWAA2016020248592Lens · unsecureFORWARD ENTRY DOOR EXIT SIGN LENS COVER FELL OFF. REINSTALLED COVER IAW MM.SDR SWAA2016020148513Battery Pack · dischargedR2 DOOR EMER EXIT LIGHT AT FLOOR LEVEL INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2016020148512Battery Pack · dischargedL2 DOOR EMER EXIT LIGHT AT FLOOR LEVEL INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2016020148454Outflow Valve · faultyDIVERSION & DECLARED EMER AT FL360, CABIN POUNDS PER SQUARE INCH DIFFERENTIAL ROSE TO 8.0, CABIN ALTITUDE NEVER EXCEEDED 7,800 FEET. REMAINED IN AUTO, ALL OTHER INDICATIONS NORMAL. R & R OUTFLOW VLV IAW AMM.SDR SWAA2016022649477Skin · crackedRIGHT WING UPPER SKIN CRACKED AT AFT FASTENER HOLES APPROX BETWEEN RSS 239 - 255. REPAIRED SKIN IAW ER & EA.SDR SWAA2016020148549Strap · brokenFORWARD GALLEY FLASHLIGHT STRAP BROKEN. R & R STRAP IAW MM.SDR SWAA2016020148541Support · crackedAFT CARGO COMPARTMENT CHANNEL SUPPORT CRACKED, AT BS 727+3, RBL 3. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016031449888Support Fitting · crackedRIGHT WING AFT SUPPORT FITTING CRACKED AT NR 5 HOLE. REPAIRED FITTING IAW ER & EA.SDR SWAA2016030149559Skin · crackedLEFT WING UPPER SKIN CRACKED, BETWEEN RSS 239 - 288. REPAIRED SKIN IAW ER & EA.
Back to Boeing 737-3H4