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 SWAA2015080442503Attach Fitting · crackedFORWARD ENTRY DOOR SURROUND STRUCTURE ATTACH CLIP AFT OF FRAME, CRACKED AT BS 348.2, STRINGER 15L. R & R CLIP IAW SRM & DWG.SDR SWAA2015063041236Battery · dischargedEMERGENCY LIGHT BATTERY PACK M1674 INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2015062541128Light · inoperativeBULLNOSE EXIT LIGHT INOPERATIVE AT ROW 16 DEF. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015062541127Lens · looseLEFT OVERWING EXIT LIGHT LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2015080342413Bear Strap · crackedFORWARD CARGO BAY DOOR CUT OUT, BEAR STRAP INBOARD EDGE CRACKED AT LOWER FORWARD CORNER, 4" UP FROM LOWER DOOR CUT OUT EDGE. REPAIRED BEAR STRAP IAW ER & EA.SDR SWAA2015072442190Skin · crackedFUSELAGE SKIN CRACKED AT LT CORNER OF AIR CONDITIONING GND SERVICE DOOR CUT OUT. REPAIRED SKIN IAW SRM.SDR SWAA2015062341096Cover · brokenL1 DOOR EMER EXIT LIGHT COVER BROKEN. R & R COVER IAW MM.SDR SWAA2015081142636Splice · crackedLOWER BUTT JOINT SPLICE CRACKED AT BS 360, BETWEEN STRINGER 3R - 4R. R & R SPLICE IAW ER & EA.SDR SWAA2015071041715Skin · debondedRIGHT WING INBD FORE FLAP UPPER SURFACE DISBONDED 36" FROM OTBD END. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015062241010Skin · crackedLEFT WING UPPER SKIN CRACKED AFT OF REAR SPAR AT FASTENER HOLE NEAR RSS 237. REPAIRED SKIN IAW EA.SDR SWAA2015062240998Lug · brokenRIGHT WING NR 5 GND SPOILER OTBD LUG BROKEN. R & R SPOILER IAW AMM.SDR SWAA2015081242773Pressure Panel · corrodedPRESSURE WEB CORRODED AT BS 1016, BETWEEN LBL 1 TO LBL 2. REPAIRED WEB IAW EA.SDR SWAA2015081242782Stiffener · corrodedLEFT CHANNEL STIFFENER CORRODED AT BS 1016, BL 0. REPAIRED STIFFENER IAW EA.SDR SWAA2015080442494Crease Beam · crackedLEFT SIDE CREASE BEAM INNER CHORD CRACKED AT BS 616-1.50, WL 208. REPAIRED CHORD IAW EA.SDR SWAA2015071041720Skin · corrodedKEEL BEAM SKIN ASSEMBLY CORRODED BETWEEN BS 607 TO 630, BETWEEN LBL 6.30 - RBL 6.30. REPAIRED SKIN IAW EO & EA.SDR SWAA2015063041225Wedge · delaminatedLEFT WING NR 2 LE SLAT INBD WEDGE DELAMINATED. REPAIRED WEDGE IAW SRM.SDR SWAA2015063041224Skin · delaminatedRIGHT WING INBD FORE FLAP UPPER SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2015062241066Slat · crackedRIGHT WING NR 4 SLAT CRACKED ON BRACKET LOCATED ON SEAL DOOR ACTUATOR. REPLACED NR 4 SLAT IAW SRM & DWG.SDR SWAA2015062241056Light · inoperativeL2 DOOR EMER EXIT LIGHT AT COMMON TO AFT LAV FWD WALL BULB INOPERATIVE. R & R BULB IAW AMM.SDR SWAA2015062241026Slide · out of positionR2 DOOR EMER EVAC SLIDE ASSEMBLY OUT OF POSITION. REPOSITIONED SLIDE ASSEMBLY IAW MT.SDR SWAA2015062241020Light · out of adjustLEFT EMER EXIT OVERHEAD BIN BULLNOSE LIGHT OUT OF ADJUSTMENT AT ROW 22. ADJUSTED LIGHT IAW AMM.SDR SWAA2015080442502Crease Beam · crackedRIGHT CREASE BEAM INNER CHORD CRACKED AT BS 639, WL 208. REPAIRED CHORD IAW ER & EA.SDR SWAA2015071742010Strap · corrodedFORWARD CARGO DOOR SUB THRESHOLD WEB STRAP CORRODED BETWEEN BS 460 TO 487, RBL 22. R & R STRAP IAW SRM & DWG.SDR SWAA2015071041785Stringer Clip · corrodedSTRINGER TIE CLIP CORRODED AT BS 747, STRINGER 26L. R & R IAW SRM & DWG.SDR SWAA2015063041252Skin · corrodedCORROSION BULGE AT FUSELAGE SKIN STATION 787+5, STRINGER 26R. REPAIRED SKIN IAW EA.SDR SWAA2015062341101Channel · corrodedJOGGLE AREA OF CHANNEL CORRODED AT BS 767+5, LBL 8.10. REPAIRED JOGGLE IAW EA.SDR SWAA2015062341093Flap · delaminatedRIGHT WING INBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW EA.SDR SWAA2015062241008Skin · delaminatedRIGHT WING INBD FORE FLAP DELAMINATED ON UPPER SURFACE. REPAIR FORE FLAP IAW EA.SDR SWAA2015062241007Wedge · delaminatedLEFT WING NR 2 SLAT INBD WEDGE DELAMINATED ON UPPER & LOWER SURFACE. REPAIRED WEDGE IAW EA.SDR SWAA2015062240997Slide · looseL1 DOOR SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2015062240996Slide · looseR2 DOOR SLIDE LOOSE. SECURED SLIDE IAW MP.SDR SWAA2015062240992Compressor · stalledNUMBER 1 ENG INSTRUMENTS FLUCTUATE WITH COMPRESSOR STALL & VIBRATION AT IDLE ON DESCENT. R & R NR 1 ENG IAW MT.SDR SWAA2015070941680Skin · delaminatedLEFT WING NR 2 SLAT DELAMINATED ON OTBD LOWER SURFACE. REPAIRED NR 2 SLAT IAW SRM.SDR SWAA2015062341100Channel · corrodedJOGGLE AREA OF CHANNEL CORRODED AT BS 767+5, RBL 3. REPAIRED JOGGLE IAW EA.SDR SWAA2015061940969Angle · crackedRIGHT WING VERTICAL ANGLE CRACKED AT RSS 548 AILERON BALANCE BAY CORNER. R & R ANGLE IAW SRM.SDR SWAA2015061940922Fuse · faultyDIVERSION, WITH FLAPS EXTENDED AT 15, LE DEVICES DID NOT EXTEND AFTER TOUCHDOWN, LED EXTENDED & STAYED EXTENDED AFTER FLAPS RETRACTED. R & R B SYS LE EXTEND & RETRACT HYD FUSES IAW AMM.SDR SWAA2015061940921Switch · faultyDIVERSION, IN CLIMB WITH FLAPS UP NR 3 LT IN TRANSIT LIGHT ON OVERHEAD ANNUNCIATOR ON. R & R S172 NR 3 K FLAP UP SWITCH IAW AMM.SDR SWAA2015061840876Flap · delaminatedLEFT WING OTBD FLAP DELAMINATED. R & R AFT FLAP IAW AMM.SDR SWAA2015061840875Flap · damagedRIGHT WING INBD FORE FLAP DAMAGED ON INBD END. R & R FORE FLAP IAW AMM.SDR SWAA2015061840874Cover · crackedFORWARD GALLEY EMER EXIT LIGHT COVER CRACKED. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015070641342Skin · crackedSKIN CRACKED AT BS 528, STRINGER 28R. REPAIRED SKIN IAW SRM.SDR SWAA2015063041243Stringer · corrodedSTRINGER CORRODED AT STATION 1010, STRINGER 26R. REPAIRED STRINGER IAW SRM.SDR SWAA2015070641311Floor Support · crackedLONGITUDINAL FLOORBEAM CTR WING BOX UPPER CHORD CRACKED AT BS 727B, LBL 45.5. REPAIRED CHORD IAW EA.SDR SWAA2015063041237Light · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE AT ROW 12 DEF. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015062941197Light · inoperativeEXIT LIGHT INOPERATIVE AT ROW 14 ABC. RELAMPED LIGHT IAW MM.SDR SWAA2015062341095Lens · looseRIGHT LOWER OVERWING EXIT SIGN LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2015062341094Lens · looseRIGHT OVERWING EXIT LIGHT COVER LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2015061640702Lens · brokenL1 DOOR EMER EXIT LIGHT LENS COVER BROKEN. R & R LENS IAW MM.SDR SWAA2015061640693Slide · out of adjustR2 DOOR EMER EVAC SLIDE GIRT BAR OUT OF ADJUSTMENT. R & R SLIDE IAW MT.SDR SWAA2015061640747Lever · faultyAFTER GEAR EXTENSION ALL GREEN & ALL RED LIGHTS WERE ILLUMINATED. RETRACTED LG & EXTENDED GEAR A SECOND TIME. AFTER SECOND EXTENSION LIGHTS WERE NORMAL. R & R LG LEVER ASSEMBLY IAW MM.
Back to Boeing 737-3H4