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 SWAA2015072442193Intercostal · crackedFUSELAGE INTERCOSTAL CRACKED AT STATION 277 TO 292, STRINGER 14R. REPAIRED INTERCOSTAL IAW SRM.SDR SWAA2015072042045Structure · crackedINNER CHORD CRACKED AT BS 348.2, STRINGER 17L. REPAIRED CHORD IAW EA.SDR SWAA2015071641969Fastener · damagedL1 DOOR EMER EVAC SLIDE FWD GIRT BAR CLIP ON SHROUD FASTENER DAMAGED. R & R FASTENER ASSEMBLY IAW SRM.SDR SWAA2015071041796Angle · crackedLEFT WING AFT TRACK FAIRING ANGLE CRACKED ON OTBD SIDE. R & R ANGLE IAW SRM & DWG.SDR SWAA2015071041714Slide · out of adjustL1 DOOR SLIDE SLIPPED OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW MT.SDR SWAA2015070941659Cover · looseRIGHT DOOR MID CABIN EMER EXIT LIGHT LENS COVER LOOSE. SECURED COVER IAW SIP.SDR SWAA2015081842927Doubler · crackedDOUBLER CRACKED AT BS 380, BETWEEN STRINGER 28R TO 28L. REPAIRED DOUBLER IAW ER & DWG.SDR SWAA2015081242774Skin · crackedSKIN CRACKED AT BS 380+1.5, STRINGER 28L. REPAIRED SKIN IAW ER & EA.SDR SWAA2015073042332Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 747 TO 767, STRINGER 25. R & R INTERCOSTAL IAW SRM.SDR SWAA2015071341845Skin · crackedRIGHT WING NR 5 SLAT, LE SLAT SKIN CRACKED AT 37" INBD SIDE. REPAIRED SKIN IAW SRM.SDR SWAA2015071341844Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360, STRINGER 16L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2015071341843Angle · crackedANGLE CRACKED BETWEEN BS 277 TO 291.5, BETWEEN STRINGER 13R TO 14R. REPLACED ANGLE IAW SRM & DWG.SDR SWAA2015071341842Angle · crackedANGLE CRACKED BETWEEN BS 277 TO 291.5, BETWEEN STRINGER 10R TO 11R. R & R ANGLE IAW SRM & DWG.SDR SWAA2015071041793Web · crackedWEB CRACKED BETWEEN BS 277 - 291.5, STRINGER 14R. R & R WEB IAW SRM & DWG.SDR SWAA2015070941595Lens · unsecureCOCKPIT DOOR EXIT SIGN LENS FELL OFF INFLIGHT. R & R LENS IAW SIP.SDR SWAA2015072242125Structure · corrodedLEFT HORIZONTAL STABILIZER CTR SECTION CHORD CORRODED ON FRONT SPAR UPPER AFT CLEVIS AFT FACE. REPAIRED CHORD IAW SRM & EA.SDR SWAA2015072042043Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STRINGER 20R TO 21R, AT 7 O CLOCK POSITION. REPAIRED FRAME IAW EA.SDR SWAA2015072042064Frame · crackedFRAME CRACKED AT BS 520 BETWEEN STRINGER 20R TO 21R, AT 5 O'CLOCK POSITION. REPAIRED FRAME IAW EA.SDR SWAA2015071641973Support Bracket · crackedRIGHT WING INBD TE PULLEY SUPPORT BRACKET CRACKED AT RSS 230. R & R BRACKET IAW SRM & DWG.SDR SWAA2015071441914Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STRINGER 4R. R & R SPLICE IAW SRM.SDR SWAA2015071341841Strap · crackedRIGHT WING NR 6 FIXED FLAP TRACK FAIRING STRAP CRACKED AT WBL 191.00. R & R STRAP IAW SRM & DWG.SDR SWAA2015071341868Angle · crackedRIGHT WING OTBD TE STRUCTURE ANGLE CRACKED, WBL 203. R & R ANGLE IAW SRM & DWG.SDR SWAA2015071341867Angle · crackedRIGHT WING INBD TE STRUCTURE ANGLE CRACKED AT WBL 71.24. R & R ANGLE IAW SRM & DWG.SDR SWAA2015070941667Angle · crackedRIGHT WING OTBD TE STRUCTURE ANGLE CRACKED AT WS 537.806. R & R ANGLE IAW SRM & DWG.SDR SWAA2015072042042Web · crackedRIGHT NLG WW WEB CRACKED AT BS 243.7+3.5, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2015071742015Skin · crackedR2 DOOR CUT OUT SKIN CRACKED AT FWD LOWER CORNER BETWEEN BS 947.5 TO 967+6.5, BETWEEN STRINGER 15R TO 19R. REPAIRED SKIN IAW SRM.SDR SWAA2015071041792Strap · crackedSTRAP CRACKED BETWEEN BS 312 - 344, RBL 31.6. R & R STRAP IAW SRM & DWG.SDR SWAA2015070841492Slat · delaminatedLEFT WING NR 1 SLAT DELAMINATED ON INBD TE. R & R NR 1 SLAT IAW MM.SDR SWAA2015070841491Slat · delaminatedRIGHT WING NR 5 LE SLAT DELAMINATED ON INBD TE CORNER. R & R NR 5 SLAT IAW MM.SDR SWAA2015080742618Stringer · corrodedSTRINGER CORRODED BETWEEN BS 360 - 380, STRINGER 28L. R & R STRINGER IAW SRM.SDR SWAA2015072742242Frame · corrodedFUSELAGE FRAME CORRODED AT BS 794.3, STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2015072242124Structure · corrodedLEFT HORIZONTAL STABILIZER CTR SECTION CHORD CORRODED ON FRONT TOP UPPER FWD CLEVIS FWD FACE. REPAIRED CHORD IAW SRM & EA.SDR SWAA2015071742014Skin · crackedRIGHT WING EXTERNAL SKIN OF INBD FIXED LE CRACKED AT STATION 208. REPAIRED SKIN IAW EA.SDR SWAA2015071441913Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STRINGER 20L TO 21L. REPAIRED FRAME IAW SRM.SDR SWAA2015071441912Angle · crackedMAIN WW ANGLE CRACKED AT BS 727, LBL 15.5. R & R ANGLE IAW SRM & DWG.SDR SWAA2015071441911Support · crackedLEFT MAIN WW FAIRING SUPPORT STRUCTURE CHORD CRACKED AT BS 680. R & R CHORD IAW SRM & DWG.SDR SWAA2015071041783Skin · crackedFUSELAGE SKIN CRACKED AT BS 356, STRINGER 24R. REPAIRED SKIN IAW EA.SDR SWAA2015070941666Skin · crackedLEFT WING INBD FIXED LE SKIN CRACKED AT BS 213. REPAIRED SKIN IAW EA.SDR SWAA2015070941665Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT OBS 670, LBL 24.5. REPAIRED CHORD IAW SRM & EA.SDR SWAA2015070841487Battery · inoperativeEMERGENCY BATTERY PACK HOUSING LOCKS INOPERATIVE AT LOCATION M1670. R & R BATTERY IAW AMM.SDR SWAA2015080542524Spar · crackedRIGHT WING REAR SPAR WEB CRACKED AT RSS 211 IN TOP FASTENER HOLE IN UPPER CHORD OF SPAR. REPAIRED WEB IAW SRM.SDR SWAA2015080542523Spar · crackedRIGHT WING REAR SPAR WEB CRACKED AT RSS 209 IN TOP FASTENER HOLE IN UPPER CHORD OF SPAR. REPAIRED WEB IAW SRM.SDR SWAA2015073042331Threshold · crackedAFT CARGO CENTER THRESHOLD CRACKED AT THE AFT END & A FASTENER HOLE CRACKED OUT IN UPPER INBOARD EDGE. REPAIRED THRESHOLD IAW EA.SDR SWAA2015072442189Skin · crackedFUSELAGE SKIN CRACKED AT STATION 513.3, STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2015070841514Slide · looseR1 DOOR SLIDE BUSTLE SLIDE LOOSE. SECURED BUSTLE IAW SOPM.SDR SWAA2015070841489Slide · out of positionR1 DOOR SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2015070841473Lens · looseLEFT OVERWING EXIT LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2015081242757Spar · crackedLEFT WING REAR SPAR UPPER CHORD CRACKED AT MLG AFT SUPPORT FITTING. REPAIRED CHORD IAW ER & EA.SDR SWAA2015081242756Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED AT MLG AFT SUPPORT FITTING. REPAIRED CHORD ER & EA.SDR SWAA2015081242754Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 385 TO 385.5, STRINGER 15R. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4