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 SWAA2014060228603Bulkhead · crackedAFT PRESS BULKHEAD WEB CRACKED AT BS 1016, STRINGER 15R. REPAIRED WEB IAW ER & EA.SDR SWAA2014053028538Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 986.5 TO BS 1006, STRINGER 21R. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2014053028496Shear Tie · corrodedSHEAR TIE CORRODED AT BS 1006, BETWEEN STRINGER 27L TO 27R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014052728360Fitting · crackedCLIP CRACKED AT BS 348.2, STRINGER 15L. R & R CLIP IAW SRM & DWG.SDR SWAA2014052728355Strap · crackedSTRAP CRACKED AT BS 348.2, STRINGER 16L. R & R STRAP IAW SRM & DWG.SDR SWAA2014052728354Web · crackedWEB CRACKED AT BS 348.2, STRINGER 16L. R & R WEB IAW SRM & DWG.SDR SWAA2014052728353Attach Fitting · crackedATTACHMENT CLIP CRACKED AT BS 348.2, STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2014052728352Attach Fitting · crackedATTACHMENT CLIP CRACKED AT BS 348.2, STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2014051327893Pressure Panel · crackedMLG WW PRESS DECK BEADED WEB CRACKED AT STATION 667, LBL 36. REPAIRED WEB IAW EA.SDR SWAA2014051227881Structure · crackedRIGHT WING INBD FIXED LE CRACKED AT STATION 125. REPAIRED LE IAW EA.SDR SWAA2014051227880Casting · crackedNUMBER 5 GND SPOILER CASTING BROKEN AT OTBD ACTUATOR MOUNT. R & R SPOILER ASSEMBLY IAW MM.SDR SWAA2014051227879Casting · crackedRIGHT INBD GND SPOILER ACTUATOR CASTING CRACKED. REPAIRED CASTING IAW SRM.SDR SWAA2014051227878Skin · delaminatedNUMBER 4 SLAT UPPER SKIN DELAMINATED. R & R SLAT ASSEMBLY IAW MM.SDR SWAA2014060428672Angle · damagedCENTER WING BOX LONGITUDINAL FLOORBEAM AT LOWER CHORD L ANGLE DAMAGED AT BS 663, RBL 24.8. REPAIRED L ANGLE IAW ER.SDR SWAA2014060428671Channel · damagedCENTER WING BOX LONGITUDINAL FLOORBEAM AT LOWER CHORD U CHANNEL DAMAGED AT BS 663, RBL 24.8. REPAIRED U CHANNEL IAW ER.SDR SWAA2014053028537Attach Fitting · crackedATTACH CLIP CRACKED AT BS 348.5, STRINGER 15L. R & R CLIP IAW SRM.SDR SWAA2014052928472Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500C, BETWEEN STRINGER 26L TO 27L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014052928453Attach Fitting · crackedATTACH CLIP CRACKED AT BS 348.2, STRINGER 15L. REPAIRED ATTACH CLIP IAW EA.SDR SWAA2014052228263Intercostal · crackedINTERCOSTAL CRACKED AT BS 348.5, STRINGER 16L. R & R INTERCOSTAL IAW SRM.SDR SWAA2014052128232Fitting · crackedSIDEWALL TO FLOORBEAM CLIP CRACKED AT BS 947, RBL 21. R & R CLIP IAW SRM.SDR SWAA2014052128231Fitting · crackedSIDEWALL TO FLOORBEAM CLIP CRACKED AT BS 947, LBL 21. R & R CLIP IAW SRM.SDR SWAA2014052128230Intercostal · corrodedINTERCOSTAL CORRODED AT BS 947, LBL 21. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2014052128229Floorbeam · crackedFLOORBEAM CORD CRACKED AT BS 827, RBL 17. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2014052128228Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, BETWEEN STRINGER 27 TO STRINGER 28L. REPAIRED SHEAR TIE IAW SRM & DWG.SDR SWAA2014052128227Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, BETWEEN STRINGER 27R TO STRINGER 28R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014051428010Attach Angle · crackedINTERCOSTAL INBD ATTACH ANGLE CRACKED BETWEEN BS 294.5 TO BS 303.9, STRINGER 16L. R & R ANGLE IAW DWG.SDR SWAA2014051428009Strap · crackedSTRAP CRACKED AT BS 312, RBL 50. R & R STRAP IAW SRM & DWG.SDR SWAA2014050827807Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.SDR SWAA2014050827803Angle · crackedRIGHT WING NR 6 FAIRING FLAP TRACK INBD SIDE UPPER AREA ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014050827802Angle · crackedRIGHT WING NR 6 FAIRING FLAP TRACK OTBD SIDE UPPER AREA ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014060428670Pressure Deck · crackedMAIN WW BEADED PRESS DECK CRACKED AT BS 664, LBL 37. REPAIRED DECK IAW ER & EA.SDR SWAA2014060228594Beam · crackedSTUB BEAM CRACKED AT BS 685, LBL 45.5. REPAIRED STUB BEAM IAW EA.SDR SWAA2014052928452Skin · crackedFUSELAGE SKIN CRACKED AT BS 520+2.5, STRINGER 8R. EXPIRED SKIN IAW EA.SDR SWAA2014052728359Buttstrap · crackedBUTT STRAP CRACKED AT BS 360+.5, STRINGER 14R. REPAIRED BUTT STRAP IAW EA.SDR SWAA2014052228262Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 664+9.5, LBL 30.5. REPAIRED DECK IAW SRM.SDR SWAA2014052228261Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 664+1.5, LBL 32. REPAIRED DECK IAW SRM.SDR SWAA2014052228260Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 664+1.5, LBL 30. REPAIRED DECK IAW SRM.SDR SWAA2014052128226Floorbeam · crackedFLOORBEAM CRACKED AT BS 328, LBL 28. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2014052128208Support Angle · crackedRIGHT WING ACCESS PANEL 6534 SUPPORT ANGLE CRACKED. R & R ANGLE IAW DWG & SRM.SDR SWAA2014052128194Skin · crackedSKIN CRACKED AT BS 380, STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014051928132Attach Angle · crackedRIGHT WING RSS 547, WIPER WEB ATTACH ANGLE CRACKED AT INBD CTR AILERON HINGE INBD ANGLE. R & R ANGLE IAW SRM.SDR SWAA2014051928131Support Angle · crackedRIGHT WING RSS 547 LOWER TE SUPPORT ANGLE CRACKED AT INBD CTR AILERON HINGE INBD ANGLE. R & R ANGLE IAW SRM.SDR SWAA2014051928120Support Angle · crackedRIGHT WING NR 2 PYLON OTBD UPPER TE SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2014051327892Slat · delaminatedLEFT WING NR 2 LE SLAT DELAMINATED. R & R LE SLAT IAW MM.SDR SWAA2014050727757Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW AMM.SDR SWAA2014050727756Lens · looseR2 DOOR EMER EVAC SLIDE COVER LENS LOOSE. SECURED LENS IAW AMM & MT.SDR SWAA2014060328644Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A RT AT FWD LOWER FASTENER HOLE AT 4 O'CLOCK DIRECTION. REPAIRED CHORD IAW EA.SDR SWAA2014060328643Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A LT AT FWD LOWER FASTENER HOLE AT 3 & 9 O'CLOCK. REPAIRED CHORD IAW EA.SDR SWAA2014060228602Slide · unserviceableR1 DOOR EMER EVAC SLIDE PROTECTIVE COVERING OVER PULL LANYARD MISSING. R & R SLIDE IAW MT.SDR SWAA2014060228601Skin · crackedEXTERNAL FUSELAGE SKIN CRACKED AT FWD LT CORNER OF CONDITIONED AIR DOOR CUT OUT. REPAIRED SKIN IAW SRM.
Back to Boeing 737-3H4