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 SWAA2015101244788Fitting · corrodedAFT CARGO COMPARTMENT, FRAME CLIP CORRODED AT BS 807, STRINGER 26R. R & R CLIP IAW SRM & DWG.SDR SWAA2015100944761Flap · delaminatedLEFT WING OTBD AFT FLAP DELAMINATED ON INBD LOWER SIDE. R & R AFT FLAP IAW AMM.SDR SWAA2016021649103Spar · crackedRIGHT WING REAR SPAR UPPER CHORD, AT MLG AFT SUPPORT FITTING UPPER ROW, 4TH FROM OTBD FASTENER HOLE H CRACKED. REPAIRED CHORD IAW EA.SDR SWAA2016020948800Spar · crackedLEFT WING REAR SPAR UPPER CHORD, UPPER ROW, 4TH FROM INBD, FASTENER HOLE CRACKED. REPAIRED CHORD IAW EA.SDR SWAA2016020348630Support Fitting · crackedRIGHT WING REAR SPAR WEB AT MLG, AFT SUPPORT FITTINGS UPPER ROW, 5TH FROM OTBD, FASTENER HOLE CRACKED. REPAIRED FITTING IAW EA.SDR SWAA2016011347969Spar · crackedRIGHT WING REAR SPAR, UPPER CHORD UPPER ROW, 4TH FROM INBD FASTENER HOLE CRACKED. R & R SPAR IAW EA.SDR SWAA2016011347968Spar · crackedLEFT WING REAR SPAR, UPPER CHORD AT MLG AFT SUPPORT FITTING, UPPER INBD FASTENER HOLE CRACKED. REPAIRED SPAR IAW EA.SDR SWAA2015112346328Stiffener · corrodedAFT PRESS BULKHEAD, CHANNEL STIFFENER CORRODED AT BS 1017, RBL 0. REPAIRED STIFFENER IAW ER & EA.SDR SWAA2015112346327Bulkhead · corrodedAFT PRESS BULKHEAD WEB CORRODED AT BS 1018, LBL 1. REPAIRED WEB IAW ER & EA.SDR SWAA2015110245596Skin · delaminatedLEFT WING UPPER SKIN INBD FORE FLAP DELAMINATED. R & R FORE FLAP IAW AMM.SDR SWAA2015102345283Slat · delaminatedRIGHT WING NR 5 SLAT DELAMINATED AT AFT EDGE OTBD END. REPAIRED NR 5 SLAT IAW AMM.SDR SWAA2015102145211Spar · crackedRIGHT WING REAR SPAR, UPPER CHORD AT MLG, AFT SUPPORT FITTING LOWER ROW 2ND FROM OTBD FASTENER HOLE CRACKED. REPAIRED SPLICE IAW EA.SDR SWAA2015102145210Spar · crackedRIGHT WING REAR SPAR, UPPER CHORD, LOWER ROW OTBD FASTENER HOLE SPLICE CRACKED. REPAIRED SPLICE IAW EA.SDR SWAA2015102145209Spar · crackedRIGHT WING REAR SPAR, UPPER CHORD, UPPER ROW 3RD FROM INBD FASTENER HOLE CRACKED. REPAIRED SPLICE IAW EA.SDR SWAA2015102045082Rib · crackedRIGHT HORIZONTAL STABILIZER LE PANEL 9250, CRACKED RIB, 3RD FROM INBD. REPAIRED CHORD IAW SRM & DWG.SDR SWAA2015101244834Fitting · crackedLEFT WING NR 4 GND SPOILER, OTBD ACTUATOR FITTING, LOWER PANEL SUPPORT ROD ATTACH LUG ON FITTING CRACKED. REPAIRED FITTING IAW EA.SDR SWAA2015100944730Skin · crackedSKIN CRACKED AT BS 747+2, STINGER 1L. REPAIRED SKIN IAW SRM.SDR SWAA2015100944747Light · inoperativeRIGHT OVERWING EMER HATCH LIGHT BULB INOPERATIVE. REPAIRED LIGHT IAW AMM.SDR SWAA2015100944746Light · inoperativeLEFT EMER AISLE LIGHTS INOPERATIVE BETWEEN ROW 2 - 6. REPAIRED LIGHT IAW AMM.SDR SWAA2015100944745Light · inoperativeRIGHT EMER AISLE LIGHT INOPERATIVE AT ROW 4. REPAIRED LIGHT IAW AMM.SDR SWAA2015100844722Slide · looseR2 DOOR EMER EVAC SLIDE LOOSE. SECURED SLIDE IAW AMM.SDR SWAA2015100844719Light · inoperativeFORWARD EMER EXIT SIGN BULB INOPERATIVE. RELAMPED SIGN IAW AMM.SDR SWAA2015100844706Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT AFT SPARE 36" FROM ACFT. REPAIRED SKIN IAW EA.SDR SWAA2015100844705Skin · crackedLEFT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT AFT SPAR 36" FROM ACFT FUSELAGE. REPAIRED SKIN IAW EA.SDR SWAA2015100844676Spring · brokenL2 DOOR AFT FLOOR EMER SLIDE GIRT BAR LOCK SPRING BROKEN. R & R GIRT BAR ASSEMBLY IAW MM.SDR SWAA2015100844684Spring · brokenR2 DOOR AFT FLOOR EMER SLIDE GIRT BAR LOCK, SPRING BROKEN. R & R GIRT BAR ASSEMBLY IAW MM.SDR SWAA2015100844683Light · inoperativeFOUND AFT EMER EXIT SIGN BULB INOPERATIVE. R & R BULB IAW AMM.SDR SWAA2015111846165Spar · crackedRIGHT WING REAR SPAR, UPPER CHORD, LOWER FASTENER HOLE, CRACKED NEAR RSS 220. REPAIRED CHORD IAW EA.SDR SWAA2015111846164Spar · crackedLEFT WING REAR SPAR, UPPER CHORD, UPPER FASTENER, HOLE CRACKED NEAR RSS 226. REPAIRED CHORD IAW EA.SDR SWAA2015111846163Spar · crackedLEFT WING REAR SPAR, UPPER CHORD, UPPER FASTENER HOLE, CRACKED NEAR RSS 225. REPAIRED CHORD IAW EA.SDR SWAA2015111846162Spar · crackedLEFT WING REAR SPAR, UPPER CHORD, UPPER FASTENER HOLE, CRACKED NEAR RSS 222. REPAIRED CHORD IAW EA.SDR SWAA2015111846161Spar · crackedLEFT WING REAR SPAR, UPPER CHORD, UPPER FASTENER HOLE, CRACKED NEAR RSS 221. REPAIRED CHORD IAW EA.SDR SWAA2015111646099Spar · crackedLEFT WING REAR SPAR WEB UPPER FASTENER HOLE COMMON TO UPPER SPAR CHORD, CRACKED NEAR RSS 225. REPAIRED WEB IAW EA.SDR SWAA2015111646098Spar · crackedLEFT WING REAR SPAR WEB UPPER FASTENER HOLE COMMON TO UPPER SPAR CHORD, CRACKED NEAR RSS 223. REPAIRED CHORD IAW EA.SDR SWAA2015111646097Spar · crackedLEFT WING REAR SPAR WEB UPPER FASTENER HOLE COMMON TO UPPER SPAR CHORD, CRACKED NEAR RSS 220. REPAIRED WEB IAW EA.SDR SWAA2015111646096Spar · crackedLEFT WING REAR SPAR WEB UPPER FASTENER HOLE COMMON TO UPPER SPAR CHORD, CRACKED NEAR RSS 223. REPAIRED WEB IAW EA.SDR SWAA2015111646095Spar · crackedLEFT WING REAR SPAR WEB UPPER FASTENER HOLE COMMON TO UPPER SPAR CHORD, CRACKED NEAR RSS 229. REPAIRED WEB IAW EA.SDR SWAA2015111646088Spar · crackedLEFT WING REAR SPAR WEB UPPER FASTENER HOLE COMMON TO UPPER SPAR CHORD CRACKED NEAR RSS 220. REPAIRED WEB IAW EA.SDR SWAA2015111346050Spar · crackedRIGHT WING REAR SPAR WEB LOWER FASTENER HOLE COMMON TO UPPER SPAR CHORD, CRACKED NEAR RSS 220. REPAIRED CHORD IAW SRM.SDR SWAA2015110245614Fitting · corrodedRIGHT WING AFT MLG, SUPPORT BEAM FITTING INBD UPPER HOLE CORRODED, AROUND UPPER PART OF HOLE. R & R FITTING IAW EA.SDR SWAA2015102845438Angle · crackedAFT CARGO COMPARTMENT ANGLE CRACKED AT BS 807, STRINGER 25R. R & R ANGLE IAW SRM & DWG.SDR SWAA2015102345280Crease Beam · corrodedCREASE BEAM CORRODED AT BS 824, RBL 70. REPAIRED CREASE BEAM IAW EA.SDR SWAA2015102245223Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 824, RBL 60. R & R WEB IAW DWG & SRM.SDR SWAA2015101645026Bulkhead · crackedAFT PRESS BULKHEAD WEB TO Y CHORD ATTACHMENT, CRACKED AT BS 1016, BETWEEN STRINGER 5L - 7L. REPAIRED WEB IAW EA.SDR SWAA2015100744671Light · looseMID CABIN OVERHEAD EMER EXIT LIGHT ASSEMBLY LOOSE. SECURED LIGHT ASSEMBLY IAW AMM.SDR SWAA2015100744641Light · brokenFORWARD ENTRY EMER LIGHT ASSEMBLY BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015111846160Skin · crackedLEFT WING UPPER SKIN, 3RD FROM AFT FASTENER ROW HOLE AT APPROX RSS 168 CRACKED. REPAIRED SKIN IAW SRM & EA.SDR SWAA2015111846159Skin · crackedLEFT WING UPPER SKIN, 3RD FROM AFT FASTENER ROW HOLE AT APPROX RSS 248 CRACKED. REPAIRED SKIN IAW SRM & EA.SDR SWAA2015111846158Skin · crackedLEFT WING UPPER SKIN, 2ND FROM AFT FASTENER ROW HOLE AT APPROX RSS 270 CRACKED. REPAIRED SKIN IAW SRM & EA.SDR SWAA2015111846157Skin · crackedLEFT WING UPPER SKIN, AFT MOST ROW, FASTENER HOLE AT APPROX RSS 238 CRACKED. REPAIRED SKIN IAW SRM & EA.
Back to Boeing 737-3H4