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 SWAA2014073030466Frame · crackedFRAME OTBD CHORD FWD FLANGE LOWER AFT FASTENER HOLE CRACKED AT BS 727 STRINGER 18A LT. REPAIRED CHORD IAW EA.SDR SWAA2014073030465Frame · crackedFRAME OTBD CHORD FWD FLANGE LOWER FWD FASTENER HOLE CRACKED AT BS 727 STRINGER 18A LT. REPAIRED CHORD IAW EA.SDR SWAA2014072830396Frame · crackedRIGHT FRAME OTBD CHORD CRACKED AT BS 727 STRINGER 18A. REPAIRED CHORD IAW EA.SDR SWAA2014072130178Frame · crackedFUSELAGE FRAME CHORD CRACKED AT BS 727 STRINGER 18A LT. REPAIRED CHORD IAW ER & EA.SDR SWAA2014072130177Frame · crackedFUSELAGE FRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A RT. REPAIRED CHORD IAW ER & EA.SDR SWAA2014071630030Skin · crackedEXTERNAL FUSELAGE SKIN CRACKED AT FWD LT CORNER OF AIR CONDITIONER DOOR CUT OUT. REPAIRED CUT OUT IAW SRM.SDR SWAA2014062329284Sensor · faultyAIR TURN BACK, NR 2 ENG FLUCTUATION APPROX 4 % N1 DURING TAKEOFF & CLIMB FOR APPROX 3 - 4 MINUTES. ONCE STABILIZED, N1 WAS APPROX 10% BELOW NR 1 ENG N1. R & R NR 2 ENG T2 SENSOR IAW MM.SDR SWAA2014072330248Stiffener · crackedSTIFFENER CRACKED AT BS 663.75 RBL 6.15. REPAIRED STIFFENER IAW EA.SDR SWAA2014072130140Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727 STRINGER 18A LT. REPAIRED CHORD IAW ER & EA.SDR SWAA2014070829751Frame · crackedFUSELAGE FRAME AUXILIARY CHORD CRACKED AT BS 727, BETWEEN STRINGER 20L TO 21L. REPAIRED CHORD IAW EA & DWG.SDR SWAA2014062329303Actuator · out of adjustLEFT WING NR 4 GND SPOILER OTBD ACTUATOR OUT OF ADJUSTMENT. R & R ACTUATOR IAW AMM.SDR SWAA2014062329302Actuator · brokenLEFT WING NR 4 GND SPOILER INBD ACTUATOR BROKEN. R & R SPOILER IAW AMM.SDR SWAA2014062329301Lug · brokenLEFT WING INBD GND SPOILER LUG BROKEN. R & R SPOILER IAW AMM.SDR SWAA2014062329329Angle · crackedLEFT WING TE ANGLE CRACKED AT WBL 533. R & R ANGLE IAW SRM & DWG.SDR SWAA2014071530006Skin · crackedAIR CONDITIONER DOOR FUSELAGE SKIN CUT OUT CRACKED AT LT CORNER. REPAIRED SKIN IAW SRM.SDR SWAA2014070929829Skin · crackedFORWARD RT CORNER OF AIR CONDITIONED DOOR SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2014062329293Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2014070829778Skin · crackedLT BS 500+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014070829777Skin · crackedLT BS 500C+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014070829776Skin · crackedLT BS 500B+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014070829775Skin · crackedLT BS 500A+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014070829774Skin · crackedLT BS 460+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN PER EA.SDR SWAA2014070829773Skin · crackedLT BS 420+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN PER EA.SDR SWAA2014070829772Skin · crackedLT BS 400+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN PER EA.SDR SWAA2014070829771Skin · crackedRT BS 520+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014070829770Skin · crackedRT BS 500C+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014070829769Skin · crackedRT BS 500B+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014070829768Skin · crackedRT BS 500A+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014070829767Skin · crackedRT BS 500+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014070829766Skin · crackedRT BS 480+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014070829765Skin · crackedRT BS 440+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014070829764Skin · crackedRT BS 400+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN PER EA.SDR SWAA2014070829763Skin · crackedRT BS 520+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN PER EA.SDR SWAA2014070829762Skin · crackedRT BS 500C+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN PER EA.SDR SWAA2014070829761Skin · crackedRT BS 500B+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014070829760Skin · crackedRT BS 500A+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014070829759Skin · crackedRT BS 480+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN PER SRM AND EA.SDR SWAA2014070829758Skin · crackedRT BS 440+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SRM AND EA.SDR SWAA2014070829757Skin · crackedRT BS 420+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN PER SRM AND EA.SDR SWAA2014070829756Skin · crackedRT BS 400+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN PER SRM AND EA.SDR SWAA2014071630051Skin · crackedLEFT BS 500C+10 LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014071630050Skin · crackedLEFT BS 360+10 LOWER AFT WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014071630049Skin · crackedLEFT BS 360+10 UPPER FWD WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014071530008Skin · crackedLEFT BS 887+0 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014071429960Skin · crackedLEFT BS 520+10 UPPER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW EA.SDR SWAA2014071429959Skin · crackedLEFT BS 500+10 UPPER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.SDR SWAA2014071429958Skin · crackedLEFT BS 480+10 UPPER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB & TASK CARD.SDR SWAA2014071429957Skin · crackedRIGHT BS 360+10 LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW EA.SDR SWAA2014071429956Skin · crackedRIGHT BS 500+10 UPPER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.SDR SWAA2014071429955Skin · crackedRIGHT BS 360+10 UPPER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW EA.
Back to Boeing 737-3H4