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 SWAA2015080642560Fitting · crackedLEFT WING REAR SPAR RSS 222, UPPER FASTENER HOLE INBD SIDE OF FITTING CRACKED. R & R FITTING IAW DWG.SDR SWAA2015080542545Fitting · crackedRIGHT WING UPPER CHORD STATION RSS 220 UPPER FASTENER HOLE ON INBD SIDE OF AFT FITTING CRACKED. REPAIRED CHORD IAW EA.SDR SWAA2015080542522Fitting · crackedRIGHT WING STATION RSS 220 AFT FITTING, FASTENER HOLE UPPER INBD SIDE CRACKED. R & R FITTING IAW DWG & SRM.SDR SWAA2015080342419Web · crackedLEFT WING RSS 219 WEB CRACKED RACK INDICATION AT UPPER FASTENER HOLE AT AFT FITTING INBOARD SIDE. REPAIRED WEB IAW EA.SDR SWAA2015080342418Structure · crackedLEFT WING RSS 219, WING CHORD CRACKED AT THE FASTENER HOLE UPPER INBOARD SIDE OF AFT FITTING. REPAIRED CHORD IAW SRM & EA.SDR SWAA2015072242135Support Fitting · crackedRIGHT WING FWD SUPPORT FITTING FOR MLG BEAM CRACKED IN FASTENER HOLE COMMON TO UPPER REAR SPAR CHORD AT RSS 225. REPAIRED FITTING IAW SRM.SDR SWAA2015070841541Light · inoperativeRIGHT SIDEWALL LIGHT ON EMER EXIT BULB INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2015070841540Light · inoperativeRIGHT LOWER SIDEWALL EMER LIGHT, FWD OF EMER EXIT BULB INOPERATIVE. RELAMPED BULB IAW AMM.SDR SWAA2015070841488Cover · brokenFORWARD ENTRY LOWER EXIT SIGN COVER BROKEN. REPAIR COVER IAW EA.SDR SWAA2015070841484Slide · out of positionR2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2015070841474Slide · out of positionL2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2015070841472Light · faultyLOWER EMER EXIT LIGHTS FAULTY. R & R LIGHT IAW WDM.SDR SWAA2015070241278Coffeemaker · faultyDIVERSION & DECLARED EMER. FLIGHT ATTENDANTS REPORTED ELEC FUMES IN THE AFT GALLEY. R & R AFT COFFEE MAKER IAW MM.SDR SWAA2015070241277Coffeemaker · faultyDIVERSION & DECLARED EMER. FLIGHT ATTENDANTS REPORTED ELEC FUMES IN THE AFT GALLEY. R & R AFT COFFEE MAKER IAW MM.SDR SWAA2015073142391Stringer Splice · corrodedAFT CARGO COMPARTMENT STRINGER SPLICE CORRODED AT BS 907, STRINGER 20L. R & R SPLICE IAW DWG & SRM.SDR SWAA2015073042330Web · corrodedFLOOR WEB CORRODED BETWEEN BS 990 TO 1000, RBL 40. R & R WEB IAW SRM & DWG.SDR SWAA2015072942282Intercostal · crackedINTERCOSTAL WEB CRACKED AT BS 278, STRINGER 14R. R & R IAW SRM & EA.SDR SWAA2015072942281Stringer Splice · corrodedAFT CARGO COMPARTMENT STRINGER SPLICE CORRODED AT BS 907, STRINGER 19L. R & R THE STRINGER SPLICE IAW DWG & SRM.SDR SWAA2015072742241Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 787, STRINGER 26R. R & R THE STRINGER CLIP IAW SRM.SDR SWAA2015072242118Intercostal · corrodedINTERCOSTAL AT CREASE BEAM INNER CORD CORRODED AT BS 808 ABOVE DOOR CUT OUT. R & R FRAME IAW DWGS & SRM.SDR SWAA2015070241273Flashlight · inoperativeAFT CABIN FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW SIP.SDR SWAA2015063041221Lens · missingL1 DOOR EMER EXIT LIGHT LENS MISSING. REPLACED LENS IAW MM.SDR SWAA2015072342161Web · crackedAFT CARGO DOOR CUTOUT FWD FRAME CLOSE OUT WEB CRACKED. R & R WEB IAW SRM & DWG.SDR SWAA2015070641312Wire · brokenRIGHT OVERWING EMER EXIT LIGHT WIRE BROKEN. REPAIRED WIRE IAW AMM.SDR SWAA2015072342170Stiffener · crackedLEFT HORIZONTAL STABILIZER RIB STIFFENER CRACKED AT STAB STATION 92.7. R & R STIFFENER IAW SRM.SDR SWAA2015070941685Intercostal · crackedINTERCOSTAL CRACKED AT BS 277, STRINGER 14R. R & R INTERCOSTAL IAW & DWG.SDR SWAA2015080642565Bracket · crackedRIGHT WING NR 6 LE BRACKET CRACKED. REPAIRED BRACKET IAW DWG & SRM.SDR SWAA2015080542541Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 954 TO 967, RBL 54. R & R WEB IAW TC.SDR SWAA2015080542540Crease Beam · corrodedRIGHT CREASE BEAM INNER CHORD CORRODED BETWEEN BS 976.5 TO 986.5, RBL 46. R & R BEAM IAW SRM & DWG.SDR SWAA2015071541940Strap · frayedRIGHT EMER STRAP FRAYED. R & R STRAP IAW AMM.SDR SWAA2015070841508Skin · crackedSKIN CRACKED BETWEEN BS 375.75 - 376.50, STRINGER 8L. REPAIRED SKIN IAW EA.SDR SWAA2015070841477Skin · crackedSKIN CRACKED AT BS 362, STRINGER 1L. REPAIRED SKIN IAW SRM.SDR SWAA2015062941205Light · inoperativeEMERGENCY BULLNOSE LIGHT INOPERATIVE AT ROW 7 DEF. R & R LIGHT IAW MM.SDR SWAA2015080442504Door Frame · crackedR1 DOOR CUT OUT FORWARD LOWER CORNER STUB FRAME CRACKED AT BS 295, STRINGER 17R. REPAIRED FRAME IAW EA.SDR SWAA2015071541939Attach Fitting · crackedLONGITUDINAL FLOORBEAM STUB BEAM ATTACHMENT CLIP CRACKED AT BS 639, RBL 45.5. R & R CLIP IAW SRM & DWG.SDR SWAA2015071041795Frame · crackedLEFT WING AFT PYLON FRAME CRACKED AT BS 363.65. R & R FRAME IAW SRM & DWG.SDR SWAA2015071041734Support Fitting · crackedAFT CARGO COMPARTMENT AREA SUPPORT CLIP CRACKED AT BS 807, STRINGER 25R. R & R CLIP IAW SRM & DWG.SDR SWAA2015071041733Channel · crackedFORWARD CARGO COMPARTMENT SUPPORT CHANNEL CRACKED BETWEEN BS 420 - 440, STRINGER 26R. R & R CHANNEL IAW SRM & DWG.SDR SWAA2015071041716Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 277, STRINGER 15R. R & R CLIP IAW SRM.SDR SWAA2015062941206Spoiler · delaminatedRIGHT WING NR 7 SPOILER DELAMINATED. R & R SPOILER ASSEMBLY IAW MM.SDR SWAA2015062941204Lens · looseL1 DOOR EXIT LIGHT LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2015062941203Slat · delaminatedNUMBER 5 SLAT DELAMINATED. R & R SLAT ASSEMBLY IAW MM.SDR SWAA2015062641145Shaft · shearedDIVERSION NR 1 ENG WOULD NOT MAKE TAKEOFF POWER. R & R NR 1 ENG VBV MOTOR SHAFT ASSEMBLY IAW MM.SDR SWAA2015062641171Casting · crackedRIGHT INBD GND SPOILER CRACKED AT ACTUATOR CASTING. R & R CASTING IAW SRM.SDR SWAA2015080342415Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED AT FASTENER LOCATIONS AT RSS 222. REPAIRED CHORD IAW EA & ER.SDR SWAA2015080342414Spar · crackedLEFT WING REAR SPAR UPPER CHORD CRACKED AT RSS 222 FASTENER HOLE. REPAIRED CHORD IAW EA & ER.SDR SWAA2015080342454Crease Beam · crackedRIGHT CREASE BEAM WEB CRACKED BETWEEN BS 616 TO 639. R & R WEB IAW SRM & DWG.SDR SWAA2015072342169Bulkhead · crackedBULKHEAD VERTICAL BEAM WEB CRACKED AT BS 178, LBL 17. REPAIRED WEB IAW SRM.SDR SWAA2015062641167Tab · delaminatedLEFT ELEVATOR TAB DELAMINATED AT TE. R & R TAB IAW MM.SDR SWAA2015081142637Crease Beam · crackedLEFT CREASE BEAM WEB CRACKED BETWEEN BS 616 - 639. R & R WEB IAW SRM & DWG.
Back to Boeing 737-3H4