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 SWAA2015052740070Bulkhead · crackedAFT PRESS BULKHEAD WEB CRACKED ON Y CHORD AFT FASTENER ROW BETWEEN THE 3 RIVETS BELOW STRINGER 6L. REPAIRED WEB IAW SRM & EA.SDR SWAA2015052640025Cover · looseL1 DOOR BULKHEAD EXIT SIGN COVER LOOSE. SECURED COVER IAW SIP.SDR SWAA2015052640024Cover · brokenL1 BULKHEAD EMER EXIT LIGHT COVER BROKEN. R & R COVER IAW MM.SDR SWAA2015052640023Glowstrip · looseFORWARD PHOTO LUMINESCENT STRIP LOOSE. R &R STRIP IAW SIP.SDR SWAA2015070141310Skin · crackedAFT GALLEY DOOR CUTOUT LOWER FORWARD CORNER CRACKED. REPAIRED IAW SRM.SDR SWAA2015061940932Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A RT. REPAIRED CHORD IAW EA.SDR SWAA2015061840906Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A, LT SIDE. REPAIRED CHORD IAW EA.SDR SWAA2015060940514Crease Beam · crackedRIGHT CREASE BEAM CRACKED AT STATION 460 - 480. REPAIRED BEAM IAW SRM.SDR SWAA2015060540410Slat · delaminatedLEFT WING NR 2 LE SLAT DELAMINATED AT OTBD EDGE. REPAIRED SLAT IAW SRM.SDR SWAA2015070641280Web · crackedNOSE LANDING GEAR WW LT PANEL WEB CRACKED AT BS 259.5. REPAIRED WEB IAW SRM.SDR SWAA2015062241021Lens · out of positionOVERHEAD CTR CABIN EMER EXIT LIGHT LENS OUT OF POSITION AT BS 907. REPOSITIONED LIGHT ASSEMBLY IAW AMM.SDR SWAA2015061540668Skin · delaminatedNUMBER 4 LE SLAT, INBD TE LOWER SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2015060340338Skin · crackedRIGHT WING UPPER SKIN CRACKED AT OTBD END OF AILERON. REPAIRED SKIN IAW SRM.SDR SWAA2015052039862Cover · looseFORWARD ENTRY DOOR EMER EXIT LIGHT COVER LOOSE. R & R LIGHT COVER IAW SIP.SDR SWAA2015052039858Light · looseMID CABIN FLOOR EGRESS ILLUMINATION STRIP LOOSE BETWEEN ROW 8 - 9. SECURED STRIP IAW SIP.SDR SWAA2015061840825Link · corrodedRIGHT MLG BEAM SUPPORT SWING LINK CORRODED. R & R LINK IAW AMM & SRM.SDR SWAA2015060340332Fitting · crackedRIGHT WING REAR SPAR FITTING CHORD CRACKED AT INBD END. REPAIRED CHORD IAW SI.SDR SWAA2015052640018Battery · dischargedL2 DOOR EMER EXIT SIGN LIGHT INOPERATIVE. R & R BATTERY IAW SRM.SDR SWAA2015052640014Battery · dischargedR2 DOOR EMER EXIT SIGN LIGHT INOPERATIVE. R & R BATTERY IAW SRM.SDR SWAA2015052039871Light · brokenFORWARD ENTRY DOOR LOWER EMER EXIT LIGHT BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015052940212Tab · delaminatedRIGHT ELEVATOR TAB DELAMINATED. REPAIRED TAB IAW SRM.SDR SWAA2015052640053Stiffener · crackedRIGHT NLG WW HORIZONTAL STIFFENER CRACKED AT BS 294.5, OTBD CORNER. R & R STIFFENER IAW ER & EA.SDR SWAA2015052640038Skin · delaminatedLEFT WING INBD FORE FLAP DELAMINATED ON UPPER SKIN SURFACE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015052640029Skin · crackedL2 DOOR CUT OUT FWD LOWER CORNER SKIN CRACKED BETWEEN BS 967 - 951, STRINGER 17L. REPAIRED SKIN IAW SRM & EA.SDR SWAA2015052239929Engine · failedINFLIGHT SHUTDOWN & DECLARED EMER. NR 1 ENG FAILED AT 3000 AGL. PROCEEDED BY COMPRESSOR STALL ROLLED BACK. AFTER SHUTDOWN RED LIGHT EGT 950 DEGREE, COOLED IMMEDIATELY. R & R NR 1 ENG IAW MT.SDR SWAA2015052039872Cover · brokenFORWARD ENTRY DOOR EXIT LIGHT COVER BROKEN. SECURED COVER IAW SIP.SDR SWAA2015051939828Light · inoperativeLEFT EMER LIGHT INOPERATIVE AT ROW 22. RELAMPED LIGHT IAW AMM.SDR SWAA2015051839815Vsi · inoperativeDIVERSION & DECLARED EMER. FIRST OFFICER'S VSI BLANK. R & R VERTICAL SPEED INDICATOR IAW AMM.SDR SWAA2015051839799Light · inoperativeAFT RT EMER EXIT BULLNOSE LIGHT INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2015052940214Flap · delaminatedLEFT WING INBD AFT TE FLAP DELAMINATED. R & R FLAP ASSEMBLY IAW MM.SDR SWAA2015051839759Light · inoperativeRIGHT LOWER OVERWING EMER EXIT LIGHT BULB INOPERATIVE. R & R BULB IAW AMM.SDR SWAA2015070941675Spar · crackedRIGHT WING AFT SPAR WEB CRACKED IN AFT SPAR WEB AT RSS 237.5. REPAIRED WEB IAW EA.SDR SWAA2015070641292Skin · crackedRIGHT WING AFT SPAR CRACKED IN UPPER SKIN FWD FASTENER ROW AT RSS 175. REPAIRED SKIN IAW EA.SDR SWAA2015070641283Spar · crackedRIGHT WING AFT SPAR CRACKED IN AFT SPAR WEB AT RSS 219. REPAIRED WEB IAW EA.SDR SWAA2015061740812Skin · delaminatedRIGHT WING OTBD AFT FLAP UPPER & LOWER SURFACE DELAMINATED. R & R AFT FLAP IAW SRM.SDR SWAA2015061640703Fitting · corrodedRIGHT WING REAR SPAR AT UPPER CHORD, WBL 71.2 AT RT WING TO CTR SECTION SPLICE, BATH TUB FITTING CORRODED. R & R FITTING IAW EA.SDR SWAA2015060840468Fitting · crackedRIGHT MLG REAR SPAR FITTING CRACKED. R & R FITTING IAW MM.SDR SWAA2015051839805Slide · out of positionL1 DOOR SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW AMM.SDR SWAA2015051839800Slide · looseL1 DOOR EMER EVAC SLIDE LOOSE. SECURED SLIDE IAW MM & MT.SDR SWAA2015051839793Slide · looseR2 DOOR EMER EVAC SLIDE LOOSE. SECURED SLIDE IAW AMM & MT.SDR SWAA2015051839762Flap · delaminatedRIGHT WING OTBD AFT FLAP DELAMINATED ON LOWER INBD SIDE. R & R AFT FLAP IAW MM.SDR SWAA2015051839761Cover · crackedFORWARD ENTRY AREA EMER EXIT LIGHT COVER CRACKED. REPLACED COVER IAW AMM.SDR SWAA2015051839760Stop Fitting · crackedL1 DOOR UPPER AFT STOP PIN FITTING CRACKED. R & R DOOR IAW AMM.SDR SWAA2015070641291Skin · crackedRIGHT WING AFT SPAR CRACKED IN UPPER SKIN AFT FASTENER ROW COMMON TO UPPER CHORD AT RSS 191. REPAIRED SKIN IAW EA.SDR SWAA2015070641290Skin · crackedRIGHT WING AFT SPAR CRACKED IN UPPER SKIN FWD FASTENER ROW AT RSS 226. REPAIRED SKIN IAW EA.SDR SWAA2015070641289Skin · crackedRIGHT WING AFT SPAR CRACKED IN UPPER SKIN AFT FASTENER ROW AT RSS 239. REPAIRED SKIN IAW EA.SDR SWAA2015070641288Skin · crackedRIGHT WING AFT SPAR CRACKED IN UPPER SKIN AFT FASTENER ROW AT RSS 255. REPAIRED SKIN IAW EA.SDR SWAA2015070641287Skin · crackedRIGHT WING AFT SPAR CRACKED IN UPPER SKIN AFT FASTENER ROW AT RSS 256. REPAIRED SKIN IAW EA.SDR SWAA2015070641286Skin · crackedRIGHT WING AFT SPAR CRACKED IN UPPER SKIN AFT FASTENER ROW AT RSS 257. REPAIRED SKIN IAW EA.SDR SWAA2015070641285Skin · crackedRIGHT WING AFT SPAR CRACKED IN UPPER SKIN AFT FASTENER ROW AT RSS 263. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4