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 SWAA2016033150484Skin · crackedLEFT UPPER WING SKIN CRACKED TE AFT FASTENER HOLE AT RSS 284. REPAIRED SKIN IAW EA.SDR SWAA2016033150483Skin · crackedLEFT UPPER WING SKIN CRACKED TE AFT FASTENER HOLE AT RSS 267. REPAIRED SKIN IAW EA.SDR SWAA2016033150482Skin · crackedLEFT UPPER WING SKIN CRACKED TE AFT FASTENER HOLE AT RSS 254. REPAIRED SKIN IAW EA.SDR SWAA2016033150481Skin · crackedLEFT UPPER WING SKIN CRACKED TE AFT FASTENER HOLE AT RSS 253. REPAIRED SKIN IAW EA.SDR SWAA2016033150480Skin · crackedLEFT UPPER WING SKIN CRACKED TE AFT FASTENER HOLE AT RSS 249. REPAIRED SKIN IAW EA.SDR SWAA2016033150479Skin · crackedLEFT UPPER WING, SKIN CRACKED TE 2ND FROM AFT FASTENER HOLE, AT RSS 245. REPAIRED SKIN IAW EA.SDR SWAA2016033150478Skin · crackedLEFT UPPER WING SKIN CRACKED TE AFT FASTENER HOLE AT RSS 238. REPAIRED SKIN IAW EA.SDR SWAA2016033150477Skin · crackedLEFT UPPER WING SKIN CRACKED TE 3RD FROM AFT FASTENER HOLE AT RSS 164. REPAIRED SKIN IAW EA.SDR SWAA2016032250123Skin · crackedAFT GALLEY DOOR, SKIN CUT OUT CRACKED AT FWD LOWER CORNER. REPAIRED SKIN IAW SRM.SDR SWAA2016032150095Fitting · looseRIGHT WING OTBD AFT FLAP, OTBD ACTUATOR FITTING LOOSE. R & R FITTING IAW CMM.SDR SWAA2016031749977Strip · deterioratedLEFT CABIN EEPLS STRIP DETERIORATED. R & R STRIP IAW MM.SDR SWAA2016031649953Strip · deterioratedEEPLS STRIP DETERIORATED AT RT SIDE. R & R STRIP IAW MM.SDR SWAA2016022949512Pressure Deck · crackedMAIN WW PRESS DESK WEB CRACKED, AT BS 673.25, LBL 30.50. REPAIRED WEB IAW SRM.SDR SWAA2016022649451Attach Fitting · crackedFORWARD ENTRY SURROUND STRUCTURE ATTACHMENT CLIP CRACKED AT BS 360, STRINGER 8L. R & R CLIP IAW SRM & DWG.SDR SWAA2016021849183Wedge · delaminatedRIGHT WING NR 6 SLAT TE WEDGE DELAMINATED. R & R NR 6 SLAT IAW AMM.SDR SWAA2016021849171Bulkhead · crackedNOSE LANDING GEAR WW AFT BULKHEAD CRACKED AT RT LOWER CORNER. REPAIRED BULKHEAD IAW EA.SDR SWAA2016040450558Skin · crackedFUSELAGE SKIN CRACKED AT BS 332-3.5, STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2016033150485Spar · crackedRIGHT WING REAR SPAR GROUP OF 12 HOLES, HOLE 5 CRACKED, IN WEB AT 6 O'CLOCK POSITION. R & R WEB IAW EA.SDR SWAA2016032950380Support Fitting · crackedRIGHT WING REAR SPAR GROUP OF 12 HOLES, CRACKED IN AFT SUPPORT FITTING AT 6 O'CLOCK POSITION. R & R FITTING IAW EA.SDR SWAA2016032950379Support Fitting · crackedRIGHT WING REAR SPAR GROUP OF 12 HOLES, HOLE 3 CRACKED IN AFT SUPPORT FITTING AT 7 O’CLOCK POSITION. R & R FITTING IAW EA.SDR SWAA2016032850319Skin · crackedRIGHT WING, UPPER WING SKIN, TE EDGE AFT FASTENER HOLE AT RSS 269 CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2016032850318Skin · crackedRIGHT UPPER WING SKIN, E AFT FASTENER HOLE, AT RSS 266 CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2016032850317Skin · crackedRIGHT UPPER WING SKIN TE, AFT FASTENER HOLE, AT RSS 264 CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2016032850316Skin · crackedRIGHT UPPER WING SKIN TE AFT FASTENER HOLE CRACKED AT RSS 256. REPAIRED SKIN IAW EA.SDR SWAA2016032850315Skin · crackedRIGHT UPPER WING SKIN TE, AFT FASTENER HOLE, CRACKED AT RSS 254. REPAIRED SKIN IAW EA.SDR SWAA2016032850314Skin · crackedRIGHT UPPER WING SKIN TE, 2ND FROM AFT FASTENER HOLE, CRACKED AT RSS 213. REPAIRED SKIN IAW EA.SDR SWAA2016032850284Structure · crackedLEFT WING UPPER CHORD CRACKED AT RSS 221. REPAIRED CHORD IAW EA.SDR SWAA2016031649946Fitting · crackedRIGHT WING REAR SPAR FITTING CRACKED AT NR 2 HOLE. R & R FITTING IAW EA.SDR SWAA2016031649945Fitting · crackedRIGHT WING REAR SPAR FITTING CRACKED AT NR 1 HOLE. R & R FITTING IAW EA.SDR SWAA2016031549925Spar · crackedLEFT WING REAR SPAR WEB CRACKED. REPAIRED WEB IAW EA.SDR SWAA2016030749684Bulkhead · crackedBULKHEAD VERTICAL WEB CRACKED, AT BS 663, LBL 33. REPAIRED WEB IAW EA.SDR SWAA2016030449661Fitting · crackedLEFT WING REAR SPAR HOLE NR 7 CRACKED FWD SUPPORT FITTING AT 2 O CLOCK. R & R FITTING IAW SRM & EA.SDR SWAA2016030449660Fitting · crackedLEFT WING REAR SPAR HOLE NR 5 CRACKED AFT SUPPORT FITTING AT 7 O'CLOCK POSITION. R & R FITTING IAW SRM & EA.SDR SWAA2016030449659Spar · crackedLEFT WING REAR SPAR WEB CRACKED, BETWEEN RSS 211 - 238. R & R WEB IAW EA.SDR SWAA2016030449658Spar · crackedLEFT WING REAR SPAR HOLE NR 5 CRACKED UPPER CHORD AT 7 O'CLOCK POSITION. R & R CHORD IAW SRM & EA.SDR SWAA2016030449657Spar · crackedLEFT WING REAR SPAR HOLE NR 4 CRACKED UPPER CHORD AT 6 O'CLOCK POSITION. R & R CHORD IAW SRM & EA.SDR SWAA2016030449664Spar · crackedRIGHT WING REAR SPAR WEB CRACKED, BETWEEN RSS 211 - 235. R & R WEB IAW EA.SDR SWAA2016030449663Spar · crackedRIGHT WING REAR SPAR HOLE NR 8, CRACKED IN UPPER CHORD AT 12 O'CLOCK POSITION. R & R CHORD IAW EA.SDR SWAA2016030449662Spar · crackedRIGHT WING REAR SPAR HOLE NR 5 CRACKED IN UPPER CHORD, AT 6 O'CLOCK POSITION. R & R CHORD IAW EA.SDR SWAA2016030349620Attach Angle · crackedRIGHT HORIZONTAL STABILIZER ATTACH ANGLE CRACKED, FWD SIDE OF THE UPPER CHORD ON TAIL COMPARTMENT. R & R ANGLE IAW SRM & DWG.SDR SWAA2016030349619Attach Angle · crackedRIGHT HORIZONTAL STABILIZER ATTACH ANGLE CRACKED, AFT SIDE OF THE UPPER CHORD ON CTR SECTION IN TAIL COMPARTMENT. REPLACED ANGLE IAW SRM & DWG.SDR SWAA2016022649450Angle · corrodedZEE ANGLE CORRODED, BETWEEN BS 947.5 - 986, STRINGER 17R. R & R ZEE ANGLE IAW SRM & DWG.SDR SWAA2016022549408Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED, BETWEEN BS 727B - 727C, AT MIDDLE LIGHTNING HOLE AREA. R & R WEB IAW SRM & DWG.SDR SWAA2016021949231Strap · crackedELECTRONIC EQUIP COMPARTMENT STRAP CRACKED, BETWEEN BS 312 - 344, BL 0. R & R STRAP IAW SRM & DWG.SDR SWAA2016040150502Power Supply · inoperativeR2 DOOR EXTERNAL EMER LIGHT AFT OF DOOR INOPERATIVE. R & R POWER SUPPLY IAW AMM.SDR SWAA2016032150042Flap Track · crackedRIGHT WING NR 5 FLAP TRACK BEAM CRACKED. R & R NR 5 TRACK IAW AMM.SDR SWAA2016030249583Structure · corrodedFORWARD GALLEY DOOR INNER CHORD CORRODED, BETWEEN BS 312 - 360, STRINGER 17R. R & R CHORD IAW SRM & DWG.SDR SWAA2016030249582Structure · corrodedFORWARD ENTRY DOOR, INNER CHORD CORRODED, BETWEEN BS 312 - 344, STRINGER 17L. R & R CHORD IAW SRM & DWG.SDR SWAA2016030149550Tie Clip · crackedTIE CLIP CRACKED AT BS 277, STRINGER 10R. R & R CLIP IAW EA.SDR SWAA2016021949230Stiffener · crackedFLOOR STRUCTURE STIFFENER CRACKED AT BS 328, LBL 45.5. R & R STIFFENER IAW DWG & SRM.
Back to Boeing 737-3H4